Oracle Customer Engineering & Advocacy Lab (CEAL) Blog covers Oracle Analytics Cloud, Oracle Analytics Server and...

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

Join the discussion

Comments ( 3 )
  • kashif Sunday, March 2, 2014

    Hi Mate,

    I was looking for this information


    Kashif M


  • R Brooks Monday, March 17, 2014

    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.


    R. Brooks

  • rjb4standards Monday, March 17, 2014

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


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.