need an example script for testing oracle database using loadrunner

[sandeep chandra]

Hi All,
I am curently learning loadrunner. Can someone send me an
example script to load test Oracle 9i Database
and can you give me an example test case too..Any info will be really
helpful.

Thanks,
Sandeep

[James Pulley]

F1
Table of contents
ORACLE
example

Thanks,
Sandeep

--
You received this message because you are subscribed to the Google
"LoadRunner" group.
To post to this group, send email to LR-Loa...@googlegroups.com
To unsubscribe from this group, send email to
LR-LoadRunne...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/LR-LoadRunner?hl=en

[sandeep chandra]

Hi James,
I have already done that..But I need more sample scripts to understand
the concept.
Can anyone help me with that. In real time, What kind of metrics do
you monitor during the database test.

Thanks,
Sandeep

On Feb 20, 8:33 am, "James Pulley" <loadrunner-li...@jamespulley.com>
wrote:

[James Pulley]

Use the database virtual users to exercise the ODBC version of the sample
flights application.

[sandeep chandra]

Hi all,

In real time, What kind of metrics do you monitor

while testing a database like Oracle.

[chaitanya bhatt]

Your question would have been more appropriate in Oracle google groups. However, since you have already posted a quire;

 

Most important oracle counters are:

-latch and lock waits: These waits result from serialized access latches.

-control file waits: Oracle touches the control file very frequently.

-buffer busy waits: Segment header contention with the data buffers can cause bottlenecks.

-en queue waits: This can indicate internal latch and lock contention.

-log buffer waits: Events such as redo log space requests can cripple Oracle performance.

-undo segment waits: Undo segments can cause serialization waits.

-buffer deadlocks:  Internal locking and latching can cause contention.

 

And never forget to keep an eye on your SGA and PGA memory.

 

Chaitanya Bhatt

http://www.performancecompetence.com
 

[James Pulley]

Please go pull the book from your Database class in college. Concepts
associated with a properly performing database server should have been
covered in that class. If not, please pay a visit to your local bookstore
and pick up books on the relational database model by Mssrs. Codd and Date.

[Vamsi]

Hi Sandeep,

Thsi is Vamis Working for Syntel as Project lead . I have assigned a
new project which is related to DB Performance testing .
Did you got the solution for this question if so can you please mail
to below mail address

VamsiKalya...@Syntelinc.com

Thanks,
Vamsi Kalyan

On Feb 19, 5:17 am, sandeep chandra <u.sunde...@gmail.com> wrote:
> Hi All,
>         I am curently learning loadrunner. Can someone send me an

> example script to load testOracle9i Database

[utkarsh sinha]

hi vamsi,
            You can test oracle 9i using 2 diffrent approches.

Approach 1
-----------------
Step 1) Install a orcale client on your machine(Preferably TOAD)
Step 2)Use oracle 2 tier protocol for recording the actions using TOAD.
           Recprding select (Win32.exe) and mention your toad exe path aswell.Record all the activities that you do on your database
Step3)Replay the recorded script and verify if the actions happen in the database.

Approach 2
-----------------
In this method we use JDBC to establish connection with your oracle 9 i database

Here we use JAva Protocol.All LR script has to manuaaly coded.
You write a small piece of java program to establish connection using JDBC
Once u establish the connection use the connection object to execute whatever query or stored Procedure that u want to execute.

Cheers,
Utkarsh Sinha

--
You received this message because you are subscribed to the Google "LoadRunner" group.
To post to this group, send email to LR-Loa...@googlegroups.com
To unsubscribe from this group, send email to
LR-LoadRunne...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/LR-LoadRunner?hl=en

To unsubscribe from this group, send email to LR-LoadRunner+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.

[chaitanya bhatt]

If you don't have TOAD installed then the good old SQL Plus command line interface(popularly known as character mode SQL plus) is good enough for recording queries.

@Shlomi Nissim,

Knowing that you are one of the functional architects of LoadRunner, I would like bring a pressing defect to your notice.
And I would greatly appreciate if you can find a fix for the same in future version of LoadRunner,.:

LR version: 9.52

Defect Summary: LoadRunner crashes while generating a script recorded through Oracle 2 Tier protocol:

Targeted Win32 application: cmd.exe

Functional Requirement: Test engineer intends to record  ORA calls between character mode sql client (executed via windows command prompt) and the oracle server via Oracle 2 tier procol of loadrunner. The engineer uses sqlplus.exe launched through cmd(command prompt) and prefers it over sqlplusw.exe because the latter consumes more memory than the former(there is a significant difference )

Steps to reproduce the defect:
1.Launch Vugen.
2. Select Oracle 2 Tier protocol.
3. Press the START recording button.
4. Fill in the path of CMD.EXE
5. Hit OK to start.
6. Navigate to the path where sqlplus.exe is stored in the command prompt.
7. Type sqlplus.exe once in the directory.
8. Enter the database connection string with username and password.
9. On return of cursor (i.e SQL>_) -- enter a random sql query.
10. Type disconnect and quit the session.
11. Stop recording.

Result: Though events were observed while recording, after stopping the recording process the Vugen gets stuck for a long period (approx 5 minutes) and later crashes while generating the script!

Expected Result: You know it  :P

Chaitanya M Bhatt
http://www.performancecompetence.com

Hardware specs: 2.8 Gz dual core system with 4 Gb of physical memory.

Additional notes: I have tried these steps in multiple

Steps involved i

[James Pulley]

Have you considered the ODBC version of the flight application which ships with every copy of LoadRunner?  The flights app, after all, is what is used for training and education of this type.

 

From: lr-loa...@googlegroups.com [mailto:lr-loa...@googlegroups.com] On Behalf Of chaitanya bhatt
Sent: Monday, March 29, 2010 1:52 PM
To: lr-loa...@googlegroups.com
Subject: Re: need an example script for testing oracle database using loadrunner

 

If you don't have TOAD installed then the good old SQL Plus command line interface(popularly known as character mode SQL plus) is good enough for recording queries.

[Shlomi Nissim]

Chaitanya,

 

Thanks a lot for the detailed description. I'll pass the information to our R&D team and make sure it get's proper attention. I can't commit for fix though.

 

Thanks,

Shlomi

Shlomi Nissim
Functional Architect
HP LoadRunner and Performance Center

[chaitanya bhatt]

@Shlomi Nissim,

 

Thank you very much! :)

 

@James Pully,

 

The limitation of ODBC is: it fails to capture Oracle OCI API calls, where as, Oracle 2 tier protocol succeeds at capturing it.

 

Plus, even if ODBC assumingly had the capabilities of capturing oracle OCI API calls, when ODBC is coupled with Web Http/HTML in multi-protocol mode of recording, there is no option to record a Win32 application in LoadRunner. Which I think is a major drawback.

On the contrary Oracle 2 Tier and Web Http/Html, together,  works brilliantly on both Win32 and Internet applications.

[James Pulley]

The script development models for ODBC and Oracle OCI are fundamentally identical in the areas of

·         Recording

·         Parameterization

·         Correlation models

·         Timing Record Management

 

If someone is looking at becoming familiar with database virtual users then the skills developed with ODBC virtual users can be directly applied to

·         Other ODBC Applications

·         DB2 Applications

·         INGRES Applications

·         ORACLE Applications

·         SYBASE SQL Server users

·         Microsoft SQL Server users

 

Back during the era when Mercury delivered training on database virtual users the ODBC version of the flights application was the training app.   It should also be noted that flights applications variants exists of

·         WEB

·         ODBC

·         DCOM

·         WINSOCK

·         CORBA

These are controlled applications specifically designed for the purposes of highlighting the capabilities of the tool in a very narrow scope, allowing you to understand the concepts and tool mechanics as applied to a particular interface before moving onto a “real app”

[Nishu BG]

Hi Chaithanya,

 

Even i am facing the same issue while recording using Web(HTTP/HTML)
protocol.

 

Once i hit "Stop" after recording the VuGen crashes.

 

Any idea on this.

 

I have sent a seperate email on the same to out LR-Group. Hope u have received it, if not please let me know i ll forward the same.

 

Best Regards,

Nishu BG.

[James Pulley]

“Functional Requirement: Test engineer intends to record  ORA calls between character mode sql client (executed via windows command prompt) and the oracle server via Oracle 2 tier procol of loadrunner. The engineer uses sqlplus.exe launched through cmd(command prompt) and prefers it over sqlplusw.exe because the latter consumes more memory than the former(there is a significant difference )”

 

Your significant difference will only occur when you are recording your script.   When you go to replay (assuming the queries are the same), the memory footprint of the virtual user will be the same whether recorded in command line mode or though the rich SQLPLUSW client.

 

Try SQLPlus for Windows for recording.

 

From: lr-loa...@googlegroups.com [mailto:lr-loa...@googlegroups.com] On Behalf Of Nishu BG
Sent: Tuesday, March 30, 2010 5:40 AM
To: lr-loa...@googlegroups.com
Subject: Re: need an example script for testing oracle database using loadrunner

 

Hi Chaithanya,