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 -> query execution time falls when connected with SYSTEM!!

query execution time falls when connected with SYSTEM!!

From: Tuning <c_armanet_at_hotmail.com>
Date: Fri, 30 Aug 2002 11:31:28 +0200
Message-ID: <akndvd$9qp$1@wanadoo.fr> 





Hello,



Oracle Enterprise Edition 8.1.7, HP-UX Server
optimizer_mode = choose



I've 2 tables: T1 and T2, owned by a user A...
And a query on these tables which takes about 2 hours to execute
connected with a user B...


Then, when connected with SYSTEM, this time falls to 7 seconds!!!



Any idea?



Thanks.



Regards,



C.A.
Received on Fri Aug 30 2002 - 04:31:28 CDT












Original text of this message













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