Home » SQL & PL/SQL » SQL & PL/SQL » Temporary Tabelspace Issue (merged)
Temporary Tabelspace Issue (merged) [message #234900] Thu, 03 May 2007 07:31 Go to next message
sivaprasad.nandi
Messages: 3
Registered: May 2007
Junior Member
Hi.
Recently i Have faced a situation stating that TEMP tablespace is 100% full.I ran some scripts basesd on v$sort_usage,v$session,v$process and identified some of the sessions which are consuming more TEMP space and i killed the same.Now i cheked using v$temp_space_header to know the free space.All the times,its showing 100%.After this i checked in TOAD.In TOAD it showing only 50% usage.I would like to know what is the view to know the correct usage of Temporary tablespace.
Temporary Tablespace Issue [message #234901 is a reply to message #234900] Thu, 03 May 2007 07:32 Go to previous messageGo to next message
sivaprasad.nandi
Messages: 3
Registered: May 2007
Junior Member
Hi.
Recently i Have faced a situation stating that TEMP tablespace is 100% full.I ran some scripts basesd on v$sort_usage,v$session,v$process and identified some of the sessions which are consuming more TEMP space and i killed the same.Now i cheked using v$temp_space_header to know the free space.All the times,its showing 100%.After this i checked in TOAD.In TOAD it showing only 50% usage.I would like to know what is the view to know the correct usage of Temporary tablespace.
Re: Temporary Tablespace Issue [message #234971 is a reply to message #234901] Thu, 03 May 2007 10:34 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
1.Are you sure you see TEMP TABLESPACE in TOAD

you should check through OEM

2.DON'T WORRY about TEMP TABLESPACE 100% FULL it will maintain by oracle itself.

regards
Taj
Re: Temporary Tablespace Issue [message #235132 is a reply to message #234971] Fri, 04 May 2007 02:47 Go to previous messageGo to next message
sivaprasad.nandi
Messages: 3
Registered: May 2007
Junior Member
I am very much sure.I found the Temp tablespace in TOAD.I think i can't neglect this temp space issues.Becauise so many jobs are failing due to this.Please let me know which view is useful for me to check the corect usage of temp space.
Re: Temporary Tablespace Issue [message #235242 is a reply to message #235132] Fri, 04 May 2007 08:15 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
What errors are these jobs failing with?
Previous Topic: How To optimize this complex Query
Next Topic: how do i sum columns
Goto Forum:
  


Current Time: Wed Dec 07 10:25:55 CST 2016

Total time taken to generate the page: 0.05621 seconds