Re: Conceivably a daft question...

"Holger Baer" <holger.baer_at_science-computing.de> wrote in message news:c4e4lc$463$1_at_news.BelWue.DE...
> Howard J. Rogers wrote:
> > "Holger Baer" <holger.baer_at_science-computing.de> wrote in message
> > news:c4e3a1$2tu$1_at_news.BelWue.DE...
> >
> >>Howard J. Rogers wrote:
> >>
> >>>Any clues to the (probably) blindingly obvious that I've missed?
> >>>
> >>>Cheers,
> >>>HJR
> >>>
> >>
> >>Ever heard of the PLUSTRACE role? ;-)
> >>
> >>Cheers,
> >>Holger
> >
> >
> >
> > Of course. But that's not the issue (I have the dba role, which is what
> > you're probably getting at, I guess).
> >
> > Regards
> > HJR
> >
> >
>
> No, what I was getting at is the fact that even with dba, you don't seem
> to have all necessary privileges. I followed you test with a vanilla
> 9.2.0.5 installation with the same results. After creating the plustrace
> role (which btw. is explicitly granted to dba by running
@?\sqlplus\admin\plustrce)
> I got the expected trace data.
>
> Cheers,
>
> Holger

That can't be it, because:

C:\Documents and Settings\Howard>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Mar 31 20:28:50 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

SQL> connect howard/rogers
Connected.
SQL> set autotrace trace stat
SQL> select * from blah;

999 rows selected.

Statistics

          0  recursive calls
          0  db block gets
         97  consistent gets
          0  physical reads
          0  redo size
      84390  bytes sent via SQL*Net to client
       1225  bytes received via SQL*Net from client
         68  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
        999  rows processed

See? Now it works. It's when it's run in a script that it doesn't.

So it can't be a permissions issue.

Regards
HJR Received on Wed Mar 31 2004 - 04:30:21 CST