SQL Performance (MOSC)

MOSC Banner

Improve my query or my database ( Statistics )

edited May 23, 2013 4:57AM in SQL Performance (MOSC) 20 commentsAnswered
hello,
     I see a query in my statspack report because this query do plenty of access disk : 2,771,398
and for it i would retrieve my full query by the old_hash_value.
and when I execute  next query the query do not find a result no rows.
how can i do to retrieve this query full for execute an explain after and maybe improve my query or my database tunning ?

best regards
JP
 
select sql_text from v$sqltext where hash_value = '&hash_value_of_sql'
order by piece;

no rows


                                                                                   CPU      Elapsd   Old
  Buffer Gets    Executions  Gets per Exec  %Total Time (s)  Time (s) Hash Value

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