Thanks I agree that DBCONSOLE take a fair share of memory. It seems to take 50 MB real to startup. But then it seems to also be a webserver amoung other things.
I don't want to afford DBCONSOLE eveywhere, just the agent. Perhaps have one Oracle machine with DBCONSOLE collecting all the data from all the other agents. I don't know exactly how that is done, but the doucmentation seems to imply that it can be. Tom Duerbusch THD Consulting >>> [EMAIL PROTECTED] 12/16/2005 1:47 PM >>> PGA target is 24M. I'm not sure how much the SGA size changes. Here is a sample TOP display: CPU states: 42.2% user, 13.8% system, 0.0% nice, 43.8% idle Mem: 346744K av, 338088K used, 8656K free, 0K shrd, 2816K buff Swap: 399424K av, 202192K used, 197232K free 246640K cached DBCONSOLE is a hog on our z800 box. Theres no way we can activate that on all our Oracle servers. We plan on using a separate grid server for that function, since the OEM agent is fairly small. Ray Mrohs Energy Information Administration U.S. Department of Energy -----Original Message----- From: Tom Duerbusch [mailto:[EMAIL PROTECTED] Sent: Friday, December 16, 2005 11:43 AM To: [email protected] Subject: Re: Slim and trim Oracle? 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 ---------------------------------------------------------------------- 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
