I'm on RSU 501. How did you get an SGA of 225 MB on a 400 MB guest?
Is the SGA dynamic? What is your PGA size? Are you using OEM? Do you start DBCONSOLE or just use the agent to an OEM somewhere else? Thanks Tom Duerbusch THD Consulting >>> [EMAIL PROTECTED] 12/16/2005 7:52 AM >>> Tom, What RSU is your system at? Our VM 5.1 paging rates dropped by 2 orders of magnitude when I moved from service level 401 to 502. Regarding Oracle, 9i is running at 350M. We have 10g in test, running at 400M. SGA size is ~225M, but depends a lot on application tuning. Ray Mrohs Energy Information Administration U.S. Department of Energy -----Original Message----- From: Tom Duerbusch [mailto:[EMAIL PROTECTED] Sent: Thursday, December 15, 2005 9:03 PM To: [email protected] Subject: Slim and trim Oracle? Next topic. I need to run many, many copies of Oracle 10g under SLES9 under z/VM 5.1. But I need a small memory footprint. Now Oracle suggests a 1 GB memory and 1-2 GB for swap (vdisk in my case). I've been able to install with 512 MB and 1 GB vdisk. But that still ends up taking the 512 MBs, all the time. Even idling and I drive up paging to 2,000 per second, it gets trimmed by less than 5%. I can run SLES9 in 64 MB, without any swapping. ORACLE's OEM, seem to take about 50 MB, just to startup. Then the Oracle database takes the rest of the virtual storage. I've been able to get the Oracle SGA down to 76 MBs which gets my virtual size of Linux down to 320 MBs. Any smaller SGA, seems have Oracle failing just after startup. I don't mind using, perhaps abusing vdisk. I would rather have most of the entire machine paged out when it isn't in use. I might end up having the machines automatically brought down after an hour of unuse, but I would rather not have to write something myself. Of course production machines will be sized for production workloads. What I need is a bunch of departmental development/testing machines, most of them will not be used on any particular day. So, who has the smallest Oracle memory footprint for a full blown Oracle database and how did you get it? Thanks Tom Duerbusch THD Consulting ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
