My Oracle Support Banner

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 later
Information 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


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