Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Understanding nqcmd command

Received Response
2
Views
1
Comments
Nivedita Venkateswaran-Oracle
Nivedita Venkateswaran-Oracle Rank 1 - Community Starter
edited Aug 13, 2024 6:07PM in Oracle Analytics Cloud and Server

Hi,

When nqcmd command is run to check the performance of OBIEE,  an output file is generated giving the following details,
1. TimeStamp
2. Sqls/Sec
3. Avg RT
4. CumulativePrepareTime
5. CumulativeExecuteTime
6. CumulativeFetchTime
7. TotalFailedQueries

How are CumulativePrepareTime, CumulativeExecuteTime and CumulativeFetchTime calculated?  Or what is the exact description of these field?

Regards,

Nivedita

Answers