Re: Retrieve size of db objects
- From: "Mark C. Stock" <mcstockX@Xenquery .com>
- Date: Thu, 1 Jun 2006 11:57:09 -0400
"Tony" <acangiano@xxxxxxxxx> wrote in message
news:1149176796.535120.238780@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
: 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
.
- Follow-Ups:
- Re: Retrieve size of db objects
- From: Tony
- Re: Retrieve size of db objects
- References:
- Retrieve size of db objects
- From: Tony
- Retrieve size of db objects
- Prev by Date: Retrieve size of db objects
- Next by Date: Can someone post the utlsampl.sql script?
- Previous by thread: Retrieve size of db objects
- Next by thread: Re: Retrieve size of db objects
- Index(es):
Relevant Pages
|
