increase SGA size and performance

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Wed, 20 Jun 2012 11:43:12 -0700 (PDT)
Message-ID: <1340217792.18001.YahooMailNeo_at_web120505.mail.ne1.yahoo.com>



We have ORACLE 10GR2 database on LINUX server.  One of SQL statement I ran on database with sga_target P0M.  It ran more than two hours still not finish.  When I increase SGA_TARGET = 1500M, it finish in 5 minutes. I know increase SGA_TARGET size sometime will increase access rate, but should NOT that much difference. 

Anyone have ideal?

Thanks.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 20 2012 - 13:43:12 CDT

Original text of this message