** CPU impact of I/O change

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Mon, 14 Apr 2008 09:50:45 -0700 (PDT)
Message-ID: <369294.45225.qm@web58014.mail.re3.yahoo.com>


Hi,

     I plan to make changes to database like increase SGA, save rows of some tables : then do truncate of table and insert the rows back or move table to reduce HWM and to take care of chained rows. All this will help reduce the I/O done. There are some full table scans and some index accesses. My question is : What impact will this change in I/O have on CPU usage. Improvement, no impact or adverse? Anything else to look at or watch out for? Thanks                  

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 14 2008 - 11:50:45 CDT

Original text of this message