Having created user HOWARD, do you connect as
howard, or were you still connected as SYS. Autotrace
acquires its statistics from a second session on the same
connection, and uses the AUDSID to identify the first
session. Funny things happen for SYS, though, as any
session on the SYS account runs with AUDSID = 0.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
April 2004 Iceland http://www.index.is/oracleday.php
June 2004 UK - Optimising Oracle Seminar
"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.
>
Received on Wed Mar 31 2004 - 02:00:13 CST
