SQL Performance (MOSC)

MOSC Banner

What is this in my statspack report appears DBMS_SCHEDULER on TOP SQL's ordered by cpu

we have Performanceproblems and in my Statspack report i can see on Top


   CPU                 CPU per            Elapsd                    Old

 Time (s)  Executions Exec (s) %Total  Time (s)   Buffer Gets Hash Value

---------- ------------ ---------- ------ ---------- --------------- ----------

  1912.16      75,116      0.03 427.6   1925.54  1,153,709,418 3815900929

Module: DBMS_SCHEDULER

SELECT TABLESPACE_ID, HEADER_FILE, HEADER_BLOCK, SEGMENT_OBJD FR

OM SYS_DBA_SEGS, DBA_LOBS WHERE DBA_LOBS.OWNER = :B3 AND DBA_LOB

S.TABLE_NAME = :B2 AND DBA_LOBS.SEGMENT_NAME = SYS_DBA_SEGS.SEGM

ENT_NAME AND DBA_LOBS.OWNER = SYS_DBA_SEGS.OWNER AND SYS_DBA_SEG


how can i find out which scheduled Job oder session is responsible for this?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center