OBIEE 11.1.1 - Advanced Usage of nqcmd command

Following are the useful nqcmd command lines arguments:

a. In your environment set the "export SA_NQCMD_ADVANCED=yes"

b. Following is the description of the nqcmd command line arguments for BIServer (nqsserver) testing:

-d = Datasource.
-u = username.
-p = password.
-s = inputsqlsfile.
-o = outputfile. counters will be in outputfile_Counters.txt.
-td <secs> = timeduration in secs. nqcmd will run until <secs> elapses.
-qsel r = select queries random manner from inputsqlsfile.
-ds <secs> = dump statistics to outputfile_Counters.txt every <secs>.
-T = Timer is on. Otherwise you won’t get correct statistics.
-t <number> = generate users . if you give -t 50, 50 users will be there.
-q = turn off row output - mandatory flag for load testing.
-n <number> = used for login test run for <number> iterations.
-w = thinktime (in seconds).

For example: The following command runs 50 users and runs for 200secs , this will use logical.sql as input file and fire queries randomly as we select -qsel r. it dumps statistics to stats_sessions_Counters.txt for every 20 secs. the nqcmd for load testing will append _Counters.txt to filename given by -o option:
./nqcmd -d AnalyticsWeb -u weblogic -p welcome1 -s logical.sql -o stats_sessions -td 200 -qsel r -ds 20 -q -T -t 50 -utf16

Sample output of nqcmd and interpretation

TotalSqls/TimeinSecs gives sqls/sec .
CumulativeRT/TotalSqls gives Avg RT

For example:
nQcmd Testing
TimeStamp   TotalSqls   CumulativeRT            CumulativePrepareTime   CumulativeExecuteTime    CumulativeFetchTime
00:00:20    62          84.88       19.40       17.55       47.93
00:00:40    124         181.07      44.17       38.66       98.24

Comments:

Hi Mate,

I was looking for this information

Regards
Kashif M
http://mkashu.blogspot.com

Posted by kashif on March 02, 2014 at 05:45 PM SGT #

I just stumbled across this site and wanted to thank you folks for doing this. I just used the BICheckPart1 script to validate my security setup. Excellent work.

Please keep up the great work - more wlst scripts please.

THANKS!

R. Brooks

Posted by R Brooks on March 18, 2014 at 04:58 AM SGT #

Great job folks. Really appreciate you sharing this fine work.

Thanks!

Posted by rjb4standards on March 18, 2014 at 05:05 AM SGT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today