Temporary tablespace script

From: Uma Sankara_Sivadanam <UmaSankara_Sivadanam_at_satyam.com>
Date: Mon, 13 Nov 2000 19:37:12 +0530
Message-Id: <10679.121874@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Temporary tablespace script</TITLE>
</HEAD>
<BODY>

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

 

</BODY>
Received on Mon Nov 13 2000 - 08:07:12 CST