Re: How to calculate size of table including size of its indexes too.
Date: Tue, 29 Jan 2008 11:41:24 -0800
On Jan 22, 2008 9:31 AM, hansraj sao <hansrajsao_at_gmail.com> 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 http://www.youtube.com/watch?v=40Lnoyv-sXg if you are not
the need to avoid unnecessary procedures.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 29 2008 - 13:41:24 CST