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: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 28 May 2005 07:47:05 -0700
Message-ID: <1117291362.328194@yasure> 





Talk2Vineet_at_gmail.com wrote:


 > My concern is not why the execution plan is


> different for the same query, but the response time that has a diffence

> almost 3 times between the two users.




They are not two indepenent unrelated things.



Run a StatsPack on each.


Run a trace on each.



No other help is possible without that information.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)


Received on Sat May 28 2005 - 09:47:05 CDT












Original text of this message













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