| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Temporary tablespace script
Uma
You may use following script to check usage of temp tablespace:
select
substr(owner,1,4),substr(segment_name,1,30)SEGMENT_NAME,substr(segment_type,1,10)SEG_TYPE,
substr(tablespace_name,1,10)TBS_NAME,round(bytes/(1024*1024),2)MB,
extents EXTENTS
from dba_segments
where segment_TYPe = 'TEMPORARY'
/
Regards
Rafiq
From: Uma Sankara_Sivadanam <UmaSankara_Sivadanam_at_satyam.com>
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Subject: Temporary tablespace script
Date: Mon, 13 Nov 2000 06:16:16 -0800
Hi All,
I feel i need to reduce the SORT AREA SIZE as i feel it is too big and
eating away the memory(it is a 40 GB database having 4MB Sort area).I planed
to reduce it and i know it will lead to excessive temp segments
genaration.So i need to keep an eye before i go for reducing the SORT AREA
SIZE.
Can anybody help me by sending a script for monitoring the activity of my
temporary rable space?
cheers,
/uma
Share information about yourself, create your own public profile at Received on Thu Nov 16 2000 - 13:58:46 CST
 |
 |