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: Query Performance

Re: Query Performance

From: Kiran Samvedi <kiran1_at_starhub.net.sg>
Date: 2000/06/02
Message-ID: <39377bd8.0@news.cyberway.com.sg>#1/1

Hi,
Try Increasing the shared_pool_size.
..Kiran

"Deborah Carter" <dcarter_at_cnfei.com> wrote in message news:j4xZ4.753$RT3.1291009_at_firenze.visi.net...
> I am working on this project writing a procedure to select information out
> of some rather large tables and insert them into another table. The
> procedure runs for about 6-8 minutes. How can I improve this performance?
> I believe my select statements are optimized. I just don't know what else
> to check or do to speed up the performance. The query takes so long. I
 was
> thinking about reorganizing the largest tables as index-organized tables.
> How will this effect performance? What are the drawbacks to
 index-organized
> tables? Any suggestions are appreciated.
>
> Deborah Carter
>
>
Received on Fri Jun 02 2000 - 00:00:00 CDT

Original text of this message

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