My Oracle Support Banner

Statspack Module Showing Incorrect Information Application Module (Doc ID 2534216.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Oracle Database - Standard Edition - Version and later
Information in this document applies to any platform.




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 .....



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.