Re: High Resource consuming SQL in Statspack ?

Vivek,

What time period is the snapshot for?

I've seen application running on application servers that make this call
frequently.

Each execution is only about 5 milliseconds but there are over 13,000
executions. It the snapshot time period is something like 2 hours then I would
conclude that the % of total is high because not much else is happening and
it's nothing to worry about.

Keith



> P.S. Bad SQL:-
>
> SQL ordered by CPU  DB/Inst: LOSDB/LOSDB  Snaps: 552-554
> -> Resources reported for PL/SQL code includes the resources used by all SQL
>    statements called by the code.
> -> Total DB CPU (s):             121
> -> Captured SQL accounts for   78.9% of Total DB CPU
> -> SQL reported below exceeded  1.0% of Total DB CPU
>
>     CPU                  CPU per             Elapsd                     Old
>   Time (s)   Executions  Exec (s)  %Total   Time (s)    Buffer Gets  Hash
> Value
> ---------- ------------ ---------- ------ ---------- ---------------
> ----------
>      60.09       13,016       0.00   49.7      60.10               0
> 1702556642
> Module: JDBC Thin Client
> SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'


--
http://www.freelists.org/webpage/oracle-l

Other related posts: