Re: Conceivably a daft question...

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Thu, 01 Apr 2004 10:28:41 +0200
Message-ID: <c4gjrp$mek$1@news.BelWue.DE>

Howard J. Rogers wrote:
> 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
See my other reply a little bit up in the thread, it seems that the shutdown/startup sequence is doing this to you.

And here I'm getting curious: why did you restart your instance?

Regards,
Holger Received on Thu Apr 01 2004 - 02:28:41 CST