way to make sql statement stay on cache (SGA) logner?
From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Sun, 31 Jan 2010 15:17:03 -0800 (PST)
Message-ID: <687721.84523.qm_at_web65703.mail.ac4.yahoo.com>
We have ORACLE 10GR2 on UNIX server and some of SQL statements run much longer on first after that it only run few seconds. I know the reason first time SQL statements run need parse and other things, after that SQL statement on cache (SGA) and it will run shorter. But eventually SQL statement still will be age out from SGA.
Date: Sun, 31 Jan 2010 15:17:03 -0800 (PST)
Message-ID: <687721.84523.qm_at_web65703.mail.ac4.yahoo.com>
We have ORACLE 10GR2 on UNIX server and some of SQL statements run much longer on first after that it only run few seconds. I know the reason first time SQL statements run need parse and other things, after that SQL statement on cache (SGA) and it will run shorter. But eventually SQL statement still will be age out from SGA.
Does there has way to make SQL statement stay longer on cache (SGA)?
Thanks.
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Jan 31 2010 - 17:17:03 CST