Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Conceivably a daft question...
So, if I read your script correctly, the only thing you do differently is to
create the plustrace role before granting me the dba role, yes?
I've just tested it, and sure enough.... I'm still not getting any statistics reported! (Not surprising, really, because as I posted to Holger the statistics report just fine when I do the tests one at a time, by hand. Only when the tests are included in a script do I get problems. But the fact they appear at all means my user account's privileges aren't the issue).
Just for the hell of it, I granted myself the plustrace role directly.
And STILL no statistics.
And as I mentioned before, it's not a Windows thing, because this is happening as I type on my RHAS3 box (Oracle 9.2.0.4).
It's really most curious.
Regards
HJR
-- ------------------------------------------- Dizwell Informatics: http://www.dizwell.com -A mine of useful Oracle information- ===========================================Received on Wed Mar 31 2004 - 15:34:15 CST