Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Easy way to get size of an index?

Easy way to get size of an index?

From: Kevin O'Gorman <kevin_at_trixie.kosman.via.ayuda.com>
Date: Sun, 24 Oct 1999 15:04:40 -0700
Message-ID: <38138278.12856FFA@trixie.kosman.via.ayuda.com>


I have to confess I'm a total newbie as a DBA: just learning from the docs.

I want to know how big individual indexes are (they're all sharing a tablespace at the moment), so that I can do some planning about where they really should be stored.

I have the user_indexes view, but it doesn't seem to tell me what I need to know.

Is there another view I should use?

--
Kevin O'Gorman (805) 650-6274 kogorman_at_pacbell.net At school: kogorman_at_cs.ucsb.edu
Permanent e-mail forwarder: Kevin.O'Gorman.64_at_Alum.Dartmouth.org Received on Sun Oct 24 1999 - 17:04:40 CDT

Original text of this message

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