Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance difference issue between two users of the same database
"Billy" <vslabs_at_onwe.co.za> wrote in message news:<1116999853.585303.108350_at_o13g2000cwo.googlegroups.com>...
> Bjarke Wedemeijer wrote:
>
> > If the cause is different access paths, I afterwards run a 10053 in
> > the same way. 10046 let you know, without guessing what is going on.
>
> Good.. but that course is only taught after Basic Troubleshooting 101
> and requires DBA access or public trace files ;-)
Hi Billy
for 10053 interpretation look at
http://www.centrexcc.com/SQL%20Tuning%20with%20Statistics.pdf
Its breitlings paper.
I understand your security issue wrt. DBA access and public trace files, therefore I said that you might reproduce the problem on a test system with these rights. Received on Wed May 25 2005 - 22:35:40 CDT