Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Calculate the BIGGEST table(in space) in one tablespace efficiently?

Re: Calculate the BIGGEST table(in space) in one tablespace efficiently?

From: <fitzjarrell_at_cox.net>
Date: 27 Jan 2006 12:57:47 -0800
Message-ID: <1138395467.384472.61090@g47g2000cwa.googlegroups.com>

dominica_at_gmail.com wrote:
> Hi David,
>
> Thank you very much for helping me.
> Yes, I compute statistics (except for a few tables, long story in my
> work).
>
> I never know how to use that OCCUPIED_BLOCKS.
> Everyday, I learn something new, which is very cool.
>
> Yeah, I am still in oracle 8.1.7.4 32 bits on solaris,
> hope to migration to 10g this april,2006.
>
> I am the one who will be upgrading it..
>
>
> Thank you,
>
>
> Dominica

You're welcome.

David Fitzjarrell Received on Fri Jan 27 2006 - 14:57:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US