Message-Id: <10679.121874@fatcity.com> From: Uma Sankara_Sivadanam Date: Mon, 13 Nov 2000 19:37:12 +0530 Subject: Temporary tablespace script This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C04D7B.045FA860 Content-Type: text/plain 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 ------_=_NextPart_001_01C04D7B.045FA860 Content-Type: text/html Content-Transfer-Encoding: quoted-printable Temporary tablespace script

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