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: How do you find the table with a big highwater mark yet very few rows?

Re: How do you find the table with a big highwater mark yet very few rows?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 15 Jun 2003 16:47:54 +0200
Message-ID: <vep2amm36ja183@corp.supernews.com>

"joe bayer" <joebayerii(no-spam)@hotmail.com> wrote in message news:u6%Ga.22196$Bw2.15376_at_nwrddc03.gnilink.net...
> Thanks for your help.
>
>

analyze the table, and run the dbms_space package on it.

See Tom Kyte's book for working examples.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Sun Jun 15 2003 - 09:47:54 CDT

Original text of this message

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