Re: temp file useage on 10.2..0.4 enterprise database / windows 2003
From: ddf <oratune_at_msn.com>
Date: Tue, 14 Sep 2010 09:04:06 -0700 (PDT)
Message-ID: <de64cab4-0a59-4cd0-89af-639f6b96b070_at_y12g2000prb.googlegroups.com>
On Sep 14, 6:13 am, dba cjb <chris.br..._at_providentinsurance.co.uk> wrote:
> We have a database using temp space with approx 3 * 60 gig files
> / I woud like to drop a temp file but am not sure on getting
> max_used_blocks from v$sort_segment out of AWR
>
> ie what's the max space used in temp from awr history rather than when
> instance was bounced
>
> regards
> Chris B
Date: Tue, 14 Sep 2010 09:04:06 -0700 (PDT)
Message-ID: <de64cab4-0a59-4cd0-89af-639f6b96b070_at_y12g2000prb.googlegroups.com>
On Sep 14, 6:13 am, dba cjb <chris.br..._at_providentinsurance.co.uk> wrote:
> We have a database using temp space with approx 3 * 60 gig files
> / I woud like to drop a temp file but am not sure on getting
> max_used_blocks from v$sort_segment out of AWR
>
> ie what's the max space used in temp from awr history rather than when
> instance was bounced
>
> regards
> Chris B
AFAIK that metric is not recorded in the AWR repository; it's reported from the v$tempseg_usage view.
David Fitzjarrell Received on Tue Sep 14 2010 - 11:04:06 CDT