| Soumya |
Posted: Jul 09, 2007 03:22:55 AM |
Total Post: 56
Joined: Mar, 2006
|
Hi,
I need to know Temp tablespace usage :
How much temp TS is used at a particular time ?
How is the sizing of Temp TS should be done ?
I have a the Temp TS as 8 GB still getting error ORA-1652:.
Is there any docs for this .....
Plz let me know.
Thanx |
|
|
 KS |
| Posted: Jul 09, 2007 06:26:55 AM |  |
|
Total Post: 60
Joined: Nov, 2006
|
Hi Sowmya,
The following query will return you the amount of Temp space used at that instant,
select tablespace_name,sum(bytes_used)/1024/1024, sum(bytes_free/1024/1024) from v$temp_space_header group by tablespace_name;
--Sri
|
|
|
|
|
| Soumya |
| Posted: Jul 09, 2007 06:32:08 AM | |
|
Total Post: 56
Joined: Mar, 2006
|
Hi,
This qry returns the physical size of the TEMP TS.
Not the being used .
|
|
|
|
|
| KS |
| Posted: Jul 09, 2007 06:49:41 AM | |
|
Total Post: 60
Joined: Nov, 2006
|
Sowmya,
select tablespace_name,
sum(bytes_used)/1024/1024, --- This gives used Space
sum(bytes_free/1024/1024) --- This gives Free Space
from v$temp_space_header group by tablespace_name;
The sizing of the temp TB depens on the Sorting operations that happen in your DB.
|
|
|
|
|
| Soumya |
| Posted: Jul 09, 2007 06:51:28 AM | |
|
Total Post: 56
Joined: Mar, 2006
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 08:53:32 PM | |
|
Total Post: 361
Joined: Jun, 2008
|
For more details visit:
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
