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.
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-lReceived on Wed Jun 20 2012 - 13:43:12 CDT