Re: Retrieve size of db objects

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 1 Jun 2006 11:57:09 -0400
Message-ID: <jY2dncxEEZTIk-LZnZ2dnUVZ_tSdnZ2d@comcast.com>

"Tony" <acangiano_at_gmail.com> wrote in message news:1149176796.535120.238780_at_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
:

The Oracle Reference manual lists all the data dictionary views, where such information can be found

Also, the online view DICTIONARY provides a listing of data dictionary views

How familiar are you with Oracle architecture? You many need to peruse the Concepts manual before being able to answer these questions.

++ mcs Received on Thu Jun 01 2006 - 10:57:09 CDT