| Temp TS [message #181849] |
Tue, 11 July 2006 22:48  |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
Some questions about TEMP Tablespace.
Will used space in temp: tablespace be freedup after sometime?
If yes,what decides when it is freedup?
Can we truncate or Shrink temp tablesapce ?if yes, difference ?
If temporary tablespace is full,and there is no space on disk.is there any way to freeup sapce from temp: tablesapce ?
Can some one give some DBA script that can be used with temprary tablesapce?
|
|
|
|
| Re: Temp TS [message #181859 is a reply to message #181849] |
Tue, 11 July 2006 23:49  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Temp TS will free up upon shutdown.
The only way I know to shrink it is to provide another TEMP tablespace and switch at startup. Make sure you get a clean shutdown first.
I will try out a few scripts and reply.
Neil.
|
|
|
|
| Re: Temp TS [message #181864 is a reply to message #181849] |
Wed, 12 July 2006 00:18 |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
select sum( u.blocks * blk.block_size)/1024/1024 "Mb. in sort segments"
, (hwm.max * blk.block_size)/1024/1024 "Mb. High Water Mark"
from v$sort_usage u, (select block_size
from dba_tablespaces
where contents = 'TEMPORARY') blk
, (select segblk#+blocks max
from v$sort_usage
where segblk# = (select max(segblk#) from v$sort_usage) ) hwm
group by hwm.max * blk.block_size/1024/1024;
|
|
|
|
|
|
|
|
| Re: Temp TS [message #182074 is a reply to message #181961] |
Wed, 12 July 2006 20:00 |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
When it is freedup ?
Also, any one got any DBA scripts ,thati can use for temp tablespace related issues
|
|
|
|
|
|
| Re: Temp TS [message #182079 is a reply to message #182078] |
Wed, 12 July 2006 22:14 |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
|
Who all are using temporary tablespace,what transaction ,how much used,how much free etc... DBA scripts
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
