Online Tutorials & Training Materials | STechies.com
Register Login

How to Find a SQL_ID and Top SQL query Using Temp Tablespace Which Causing Temp Tablespace to be Full?

|| || 1

How to Find a SQL_ID and Top SQL query Using Temp Tablespace Which Causing Temp Tablespace to be Full?
Stechies

Hi everyone,
Need quick answer for this please help me.
My question is that how to find a SQL_ID and top SQL query using temp tablespace which causing temp tablespace to be full?
I need query for this but don't post the size of temp tablespace please.
send query as soon as possible.
Thanks in advance.


Comments

  • 29 Oct 2015 6:43 pm

    select distinct user_id,sql_id,TEMP_SPACE_ALLOCATED,to_char(SQL_EXEC_START,'DD-MON-YYYY HH24:MI:SS') from dba_hist_active_sess_history where to_char(SQL_EXEC_START,'DD-MON-YYYY HH24:MI') between '19-OCT-2015 19:00' and '19-OCT-2015 19:30' and user_id=143 and TEMP_SPACE_ALLOCATED is not null order by 4;
    You can also mention time in above query.

Related Articles