Re: Conceivably a daft question...

No. I've gotten results back with 100 million record tables without a problem.

try granting yourself the plustrace role(yes I know its supposed to be included in DBA).

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<406a7601$0$20085$afc38c87_at_news.optusnet.com.au>...
> I'm having trouble with something as simple as SQL*Plus autotrace.
>
> If I create user howard, then grant dba to howard, then create the plan
> table for howard, then set autotrace trace stat, then select from a small
> table (scott's EMP, for example), I get the expected report back about
> number of physical reads, consistent gets and so on.
>
> If I then immediately do a select from an extremely large table (well, 6
> million rows anyway), then I get the autotrace report back but with all the
> numbers set to zero, apart from the last one where it correctly reports the
> number of rows processed.
>
> I was just wondering if there is a size limitation on autotrace or not, and
> if so what it might be. Or what else I'm missing (it has been a long day).
>
> It's not a major drama in the sense that I can always trace the session, but
> it would be nice to know I'm not completely barking mad.
>
> Oh... 9iR2 on both Windows and Linux (RHAS3).
>
> Regards
> HJR
Received on Wed Mar 31 2004 - 08:43:25 CST