« Yahoo! Maps API in VB.Net | Home | Apache rewrite rules for hosting multiple domains »
Usage of the temp tablespace in Oracle
First find the block size:
select value "BLOCK_SIZE" from v$parameter where name='db_block_size' ;
Now check the usage of the tablespace:
select s.username "USER",s.sid,s.osuser,
u.tablespace "TS" ,
sum(u.blocks) * &BLOCK_SIZE./1024/1024 MB,
x.sql_text
from v$session s,v$sort_usage u,v$sqltext x
where s.saddr=u.session_addr and s.sql_address=x.address
group by s.sid, s.username, osuser, tablespace, sql_text, address, piece
order by sid, piece asc;
u.tablespace "TS" ,
sum(u.blocks) * &BLOCK_SIZE./1024/1024 MB,
x.sql_text
from v$session s,v$sort_usage u,v$sqltext x
where s.saddr=u.session_addr and s.sql_address=x.address
group by s.sid, s.username, osuser, tablespace, sql_text, address, piece
order by sid, piece asc;
Topics: Oracle, tablespace, temp | Submitter: checkthis
One Response to “Usage of the temp tablespace in Oracle”
Comments
You must be logged in to post a comment.
July 11th, 2008 at 3:01 am
"How much more MB/GB needed to be added to bring down the TS usage down to 80%".