Re: Conceivably a daft question...

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<c4dtqd$ok7$1_at_hercules.btinternet.com>...
> 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.
> >

I think autotrace bugs are a red herring. I've noticed differences in the way things work in scripts through many versions. I always just assumed they came from some general strangeness in the way O handles file handles in unix, not ever having thought about it in Windows.

The example that comes immediately to mind is 8i recover managed standby database; which seems to detach properly when run in a backgrounded unix shell script, but might give problems if run in an X-Window that goes awry, but seems to not quite understand if it is there if things don't go awry.

jg

--
@home.com is bogus.
http://www.heathenworld.com/bandname/index.html