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