Re: Max Extents Script

From: david_g <david_l_gouldNOdaSPAM_at_yahoo.com.invalid>
Date: Tue, 25 Jan 2000 07:06:12 -0800
Message-ID: <254d6108.29a35727@usw-ex0106-048.remarq.com>

COLUMN "Segment Name" FORMAT A30
COLUMN "Ext"          FORMAT 999
COLUMN "Max Ext"      FORMAT 999
COLUMN "% Inc"        FORMAT 999
COLUMN "Owner"        FORMAT A6
COLUMN "Type"         FORMAT A6

SELECT  segment_type "Type",
        segment_name "Segment Name",
        extents "Ext",
        max_extents "Max Ext",
        next_extent "Next Ext",
        pct_increase "% Inc",
        owner "Owner"

FROM dba_segments
WHERE extents >= (max_extents*.9)
AND segment_type <> 'CACHE'
/

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Received on Tue Jan 25 2000 - 09:06:12 CST