temp file useage on 10.2..0.4 enterprise database / windows 2003
From: dba cjb <chris.brown_at_providentinsurance.co.uk>
Date: Tue, 14 Sep 2010 03:13:23 -0700 (PDT)
Message-ID: <75b526b0-fa98-4e0f-a387-ef3f1eef7b84_at_k13g2000vbq.googlegroups.com>
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
Date: Tue, 14 Sep 2010 03:13:23 -0700 (PDT)
Message-ID: <75b526b0-fa98-4e0f-a387-ef3f1eef7b84_at_k13g2000vbq.googlegroups.com>
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
Received on Tue Sep 14 2010 - 05:13:23 CDT