Re: How to calculate size of table including size of its indexes too.

From: Jared Still <>
Date: Tue, 29 Jan 2008 11:41:24 -0800
Message-ID: <>

On Jan 22, 2008 9:31 AM, hansraj sao <> wrote:

> yeah, but this that case i will only get size of particular index.
> I wanted know if there is any way be get table size+ its indexez size in
> on scripts.
> its seems i need to write small procedure..

Writing a procedure is a last resort.
Doing this in SQL not too difficult to do, and Dan Fink has already posted a solution.

Even when difficult, SQL is a a better solution if possible.

Please see if you are not convinced of
the need to avoid unnecessary procedures.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Tue Jan 29 2008 - 13:41:24 CST

Original text of this message