Re: Easy way to get size of an index?

Hy Kevin,

there is an handy PL/SQL package to get those information:

$ORACLE_HOME/rdbms/admin/dbmsutil.sql

After running this, you can use (in SQL*Plus)   execute dbms_space.unused_space ... (look at proc to get all parameters)
  print total_blocks;
  print unused_blocks;

The difference of those figures is the space used by your object.

HTH
  Joerg

Kevin O'Gorman schrieb:

> 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 Mon Oct 25 1999 - 07:32:04 CDT