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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Execution time doubled ???

Re: Execution time doubled ???

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sun, 18 Mar 2001 14:56:31 -0800
Message-ID: <3AB53D1F.4D9FF5E6@exesolutions.com> 






> The execution time for a selection query is 2 mins.

>

> If I execution two same query concurrently using the same sqlplus account,

> the execution time is doubled.

>

> Is this normal ?




Possibly. Though my suspicion is that your schema could use some indexes and
some better written SQL.



Daniel A. Morgan
Received on Sun Mar 18 2001 - 16:56:31 CST












Original text of this message













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