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: 28 May 2005 23:25:30 -0700
Message-ID: <6ac2a573.0505282225.15e26807@posting.google.com>


suck, suck, suck,

please read what Sybrand wrote, please read my respons on thread nr 5. I wrote:

if 2 users fire the same SQL against the same database, and 1 user is 10 times slower than the other one, I would always test this scenario on a test
machine, make a logon trigger on both users, and incorporate a 10046 trace within the logon trigger. 10046 will tell you right away what your
problem is. 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

Please provide this usergroup with these 2 trace files and we will definitly find out what is going on. As Mogens always says "gæt og grimasser" what means
in danish that you are guessing all the time. Received on Sun May 29 2005 - 01:25:30 CDT

Original text of this message

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