Oracle - Web Diagnostics graphs provide you with performance information for SQLs generated by transactions on the Oracle NCA system. You can view the SQLs for each transaction, identify the problematic SQL queries of each script, and identify at what point problems occurred.
To analyze where problems are occurring, you correlate the data in the Oracle - Web Diagnostics graphs with data in the Transaction Response Time graphs.
You begin analyzing these graphs with the transaction graphs that display the average transaction response time during each second of the load test scenario run. For example, the following Average Transaction Response Time graph demonstrates that the average transaction response time for the enter transaction was high.
Using the Oracle - Web Diagnostics graphs, you can pinpoint the cause of the delay in response time for this transaction.
A measurement that is broken down in the Average Transaction Response Time graph will be different from the same measurement broken down in the Oracle - Web(DB) Side Transactions graph. This is because the Average Transaction Response Time graph displays the average transaction time, whereas the Oracle - WebDB Side Transactions graph displays the average time per transaction event (sum of SQL component response times).
vuser_init and vuser_end actions in Oracle cannot be broken down.