Hi,

I checked google, but did not find much on identifying tables
in 10g that can benefit (In terms of space reduction)
from reorganization, or from compression. (I realize that
there are many considerations for reorg and compression,
but I am looking for a starting point).

Any ideas would be appreciated.

Thanks,
QZ

On Fri, 17 Sep 2010 11:32:00 -0700, if_investor@yahoo.com wrote:

> Hi,
> 
> I checked google, but did not find much on identifying tables in 10g
> that can benefit (In terms of space reduction) from reorganization, or
> from compression. (I realize that there are many considerations for
> reorg and compression, but I am looking for a starting point).
> 
> Any ideas would be appreciated.
> 
> Thanks,
> QZ

What would you like to reorganize and compress? Compressing OLTP tables 
in Oracle 10g is not a good idea, you should upgrade to 11g and purchase 
the advanced compression option. As for the reorg, you should probably 
forget all about that. Reorg is done on a business request, as a part of 
the application restructuring. There is one reorg you can do to speed 
things up, it's truncating large table. If you have large tables, several 
gigabytes or more in size, truncating them will do wonders for your 
queries, they will simply fly.



-- 
http://mgogala.byethost5.com

Mladen Gogala schreef:
>
> What would you like to reorganize and compress? Compressing OLTP tables
> in Oracle 10g is not a good idea, you should upgrade to 11g and purchase
> the advanced compression option. As for the reorg, you should probably
> forget all about that. Reorg is done on a business request, as a part of
> the application restructuring. There is one reorg you can do to speed
> things up, it's truncating large table. If you have large tables, several
> gigabytes or more in size, truncating them will do wonders for your
> queries, they will simply fly.
>
>
>

Thank you for your advice, mr. Gogala.  We've truncated all large tables 
and the results are astounding, the queries are fast as lightning.  But 
we seem to have another problem now, in that they are not returning any 
rows, not even for a simple "select * from ...".  After the truncate, is 
there something we have to do to enable selects again?

Thank you,

GHP

On Sat, 18 Sep 2010 12:10:50 +0200, Gerard H. Pille wrote:

> Thank you for your advice, mr. Gogala.  We've truncated all large tables
> and the results are astounding, the queries are fast as lightning.  But
> we seem to have another problem now, in that they are not returning any
> rows, not even for a simple "select * from ...".  After the truncate, is
> there something we have to do to enable selects again?

You should seek the mighty Oz and ask him for a brain.



-- 
http://mgogala.byethost5.com

Mladen Gogala schreef:
> On Sat, 18 Sep 2010 12:10:50 +0200, Gerard H. Pille wrote:
>
>> Thank you for your advice, mr. Gogala.  We've truncated all large tables
>> and the results are astounding, the queries are fast as lightning.  But
>> we seem to have another problem now, in that they are not returning any
>> rows, not even for a simple "select * from ...".  After the truncate, is
>> there something we have to do to enable selects again?
>
> You should seek the mighty Oz and ask him for a brain.
>
>
>
I'd be the last to complain
About what I've got for a brain,
But I could do with a heart,
and some courage for a start.

On Sat, 18 Sep 2010 21:56:51 +0200, Gerard H. Pille wrote:

> I'd be the last to complain
> About what I've got for a brain,
> But I could do with a heart,
> and some courage for a start.

Take off every zig for great justice



-- 
http://mgogala.byethost5.com

On Sep 17, 2:32=A0pm, "if_inves...@yahoo.com"
<basis_consult...@hotmail.com> wrote:
> Hi,
>
> I checked google, but did not find much on identifying tables
> in 10g that can benefit (In terms of space reduction)
> from reorganization, or from compression. (I realize that
> there are many considerations for reorg and compression,
> but I am looking for a starting point).
>
> Any ideas would be appreciated.
>
> Thanks,
> QZ

Google tom kyte show_space for a procedure that nicely formats the
output of the dbms_space packaged procedures.