Re: Newbie question: how can I find out the number of extents used by a table

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 7 Dec 1999 19:51:05 +0100
Message-ID: <944592708.16363.0.pluto.d4ee154e@news.demon.nl>

select segment_name, extents, bytes/1024 k from user_segments
where segment_name = '<your table'>

Hth,

--
Sybrand Bakker, Oracle DBA
hellen davis <hellen101_at_hotmail.com> wrote in message news:384C9E2A.DEA09D0D_at_hotmail.com...
>
>
Received on Tue Dec 07 1999 - 12:51:05 CST

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: C Access Oracle"
Previous message: Sybrand Bakker: "Re: Trace file name camouflages!"
In reply to: hellen davis: "Newbie question: how can I find out the number of extents used by a table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US