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 (AT) yahoo (DOT) com wrote:

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:
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:

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



--
http://mgogala.byethost5.com

Mladen Gogala schreef:
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:

Take off every zig for great justice



--
http://mgogala.byethost5.com

On Sep 17, 2:32*pm, "if_inves... (AT) yahoo (DOT) com"
<basis_consult... (AT) hotmail (DOT) com> wrote:
Google tom kyte show_space for a procedure that nicely formats the
output of the dbms_space packaged procedures.