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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Analyze a table results in huge num_rows count

Re: Analyze a table results in huge num_rows count

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 5 Oct 2005 10:11:18 -0700
Message-ID: <bf46380510051011r1c794bb5o1953ecd7e561fd0f@mail.gmail.com>


On 9/30/05, Arnon, Yuval <Yuval.Arnon_at_webloyalty.com> wrote:
>
> For those who like to check if this is a problem in their environments
> you can use this simple example
>
> SQL> drop table test;
>
> Table dropped.
>
>

...

NUM_ROWS
> ----------
> 658340

I get indentical results on 9.2.0.6 <http://9.2.0.6> on Linux.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 05 2005 - 12:14:13 CDT

Original text of this message

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