Re: temp space useage on Oracle 10.2.0.4 enterprise / windows 2003
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Thu, 26 Aug 2010 06:20:33 -0700 (PDT)
Message-ID: <6c7c0800-ae34-42b3-85c3-28eaeb72c77c_at_q22g2000yqm.googlegroups.com>
On Aug 26, 6:26 am, dba cjb <chris.br..._at_providentinsurance.co.uk> wrote:
> Is there a way of working out the maximum out of temp capacity used
> since a database was started.
>
> I currently have a temp space of 3 60g temp files & would like to
> remove one if possible
>
> regards
> Chris B
Date: Thu, 26 Aug 2010 06:20:33 -0700 (PDT)
Message-ID: <6c7c0800-ae34-42b3-85c3-28eaeb72c77c_at_q22g2000yqm.googlegroups.com>
On Aug 26, 6:26 am, dba cjb <chris.br..._at_providentinsurance.co.uk> wrote:
> Is there a way of working out the maximum out of temp capacity used
> since a database was started.
>
> I currently have a temp space of 3 60g temp files & would like to
> remove one if possible
>
> regards
> Chris B
Look at v$sort_segment and v$tempfile. If your database is using a true temporary tablespace then it has only one sort segment per instance and v$sort_segment will tell you the largest amount of temp you have used since startup.
HTH -- Mark D Powell -- Received on Thu Aug 26 2010 - 08:20:33 CDT