Re: Conceivably a daft question...

"Holger Baer" <holger.baer_at_science-computing.de> wrote in message news:c4gjrp$mek$1_at_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 we think that's a bug, do we? It certainly behaves as one!

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

Testing, testing, testing... I need a level playing field, which means setting certain parameters such as log_buffer, to name but one. And that's not a dynamic parameter unfortunately.

It's frustrating not knowing *why* it's happening, but merely being able to predict when it will happen! But it's no great drama I guess.

Thanks for your help, Holger, anyway.
Regards
HJR

-- 
-------------------------------------------
Dizwell Informatics: http://www.dizwell.com
  -A mine of useful Oracle information-
===========================================