Re: Retrieve size of db objects

On 1 Jun 2006 08:46:36 -0700, "Tony" <acangiano@xxxxxxxxx> 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
.

Relevant Pages

  • Re: MAX NUMBER
    ... Reiro wrote: ... i am entering dat in an access front end connect to an oracle database. ... how do retrieve the maximum value that is in the table. ...
    (comp.databases.oracle.misc)
  • Capturing returned ODBC error message using form_Error
    ... I have written an application with an Access front end to an Oracle Database. ... user-defined error messages. ... Is there any way I can retrieve this message during ...
    (microsoft.public.access.externaldata)
  • Retrieve size of db objects
    ... given a certain Oracle database, I need to execute queries/commands in ... order to retrieve the following information: ... I'd appreciate any advice or pointer. ...
    (comp.databases.oracle.server)
  • Re: SGA limit on Solaris x86
    ... oracle database ... Please note if you specify sga_target you will get a shared memory ... Sybrand Bakker ... Senior Oracle DBA ...
    (comp.databases.oracle.server)
  • Re: Oracle database 11g
    ... I want to write oracle database 11g advanced pl/sql certification ... Can anybody please tell me where will I get the materials? ... Senior Oracle DBA ...
    (comp.databases.oracle.server)