Database Tuning (MOSC)

MOSC Banner

I analyse my database and I see process not statspack not correct

edited Dec 2, 2011 12:23AM in Database Tuning (MOSC) 12 comments

Hello,

     I analyze my database by  a query to retrieve the Worst Total SQL by CPU Time and I see 2 query system  are bad.

 The cpu time are very high 948 for the query 84828483

and 325 for the query 3471794499

What do you think about it ?

and What can I do ?

regards

JP

   

HASH_VALUE USERNAME CPU_TIME_SECS ELAPSED_TIME_SECS ELAP_PER_EXEC EXECUTIONS ROWS_PROCESSED LINE# SQL_TEXT

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

3471794499 SYS 4 325 2 157 1,476 0 insert into wri$_adv_objspace_trend_data select timepoint, spac3471794499 SYS 4 325 2 157 1,476 1 e_usage, space_alloc, quality from table(dbms_space.object_grow3471794499 SYS 4 325 2 157 1,476 2 th_trend(:1, :2,

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