| 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
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
![]() |
![]() |