Statspack Module Showing Incorrect Information Application Module
(Doc ID 2534216.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Standard Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Goal
Statspack report showing wrong Module: SQL Developer, while observed SQL is actually running from JDBC Thin Client:
DB: TEST Instance: TEST Snaps: 485 -486
-> Total DB Time (s): 10,801
-> Captured SQL accounts for 28.5% of Total DB Time
-> SQL reported below exceeded 1.0% of Total DB Time
Elapsed Elap per CPU Old
Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
1392.79 32,666 0.04 12.9 1391.31 3,794 2802158869
Module: SQL Developer <==Actual module is JDBC Thin Client
SELECT .....
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |