Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance difference issue between two users of the same database

Re: Performance difference issue between two users of the same database

From: Bjarke Wedemeijer <bjarke_at_wedemeijer.dk>
Date: 25 May 2005 20:35:40 -0700
Message-ID: <6ac2a573.0505251935.1929cea7@posting.google.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US