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 -> Retrieve size of db objects

Retrieve size of db objects

From: Tony <acangiano_at_gmail.com>
Date: 1 Jun 2006 08:46:36 -0700
Message-ID: <1149176796.535120.238780@y43g2000cwc.googlegroups.com>


Hi all,

given a certain Oracle database, I need to execute queries/commands in order to retrieve the following information:

  1. Database size
  2. List of tables
  3. Each table size
  4. List of indexes
  5. Each index size

I'd appreciate any advice or pointer.

Many thanks in advance,
Tony Received on Thu Jun 01 2006 - 10:46:36 CDT

Original text of this message

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