Retrieve size of db objects
This is a discussion on Retrieve size of db objects within the Oracle Database forums, part of the Database Server Software category; --> Hi all, given a certain Oracle database, I need to execute queries/commands in order to retrieve the following information: ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-25-2008, 04:45 AM
| ||||
| ||||
 Retrieve size of db objects 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      |
|
02-25-2008, 04:45 AM
| |||
| |||
| Re: Retrieve size of db objects "Tony" <acangiano@gmail.com> wrote in message news:1149176796.535120.238780@y43g2000cwc.googlegr oups.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 |
|
02-25-2008, 04:45 AM
| |||
| |||
| Re: Retrieve size of db objects On 1 Jun 2006 08:46:36 -0700, "Tony" <acangiano@gmail.com> wrote: >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 To do other's homework my hourly rate is €200 -- Sybrand Bakker, Senior Oracle DBA |
|
02-25-2008, 04:45 AM
| ||||
| ||||
| Re: Retrieve size of db objects Tony wrote: > Mark C. Stock wrote: > > The Oracle Reference manual lists all the data dictionary views, where such > > information can be found > > Thanks Mark. That answers my question. > > Tony You might also google about for scripts that already do it. If you have metalink access, see https://metalink.oracle.com/metalink...,1,1,helvetica jg -- @home.com is bogus. "My pants are off and the Lesbians are waiting!" - Kathy Griffin |
Linear Mode
