Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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