> -----Original Message----- > From: Linux on 390 Port [mailto:LINUX-390@VM.MARIST.EDU] On Behalf Of > Damian Gallagher
> I have worked on numerous migration projects, where we have taken the > Win/*nix system with hundreds of GB of SGA, and run it on Linux on IBM > zSeries with much less memory - my usual recommendation is to reduce by > 90% to start with, and we generally get there or better - in common with > this thread it takes a while to convince the DBAs :-). I have the numbers, > AWR, throughput etc from a specific project in front of me, so this is no idle > statement. Add hugepages to the mix, and it just gets better. > The question would also be how to convince them if even Oracle itself provides questionable or just wrong recommendations. The Installation script demands 4G memory, while it can be installed within 1.2G. It demands 1G+ /tmp space, eventhough it only uses 120M. The machine needs at least 1G per database, preferably more, according to the recommendations. We have proven this to be wrong in a system with 2 databases within 1G. And it still performs very well. One of our production databases had a 'bad' performance and the Oracle tools recommend sizing the SGA to 10G (instead of 3.5G). And time and time again we prove the problem to be a bad userprogram or bad data. Even redbooks do not do better in this respect, for any product for that matter. They tend to present a "this is how we did it" instead of these are the requirements. Often they disregard other requirements such as multiple customer networks, security rules, virtual systems running multiple customers and different workloads. Unfortunately the books are quickly considered to be the required (or even only) way to do it. Regards, Berry. Dit bericht is vertrouwelijk en kan geheime informatie bevatten enkel bestemd voor de geadresseerde. Indien dit bericht niet voor u is bestemd, verzoeken wij u dit onmiddellijk aan ons te melden en het bericht te vernietigen. Aangezien de integriteit van het bericht niet veilig gesteld is middels verzending via internet, kan Atos Nederland B.V. niet aansprakelijk worden gehouden voor de inhoud daarvan. Hoewel wij ons inspannen een virusvrij netwerk te hanteren, geven wij geen enkele garantie dat dit bericht virusvrij is, noch aanvaarden wij enige aansprakelijkheid voor de mogelijke aanwezigheid van een virus in dit bericht. Op al onze rechtsverhoudingen, aanbiedingen en overeenkomsten waaronder Atos Nederland B.V. goederen en/of diensten levert zijn met uitsluiting van alle andere voorwaarden de Leveringsvoorwaarden van Atos Nederland B.V. van toepassing. Deze worden u op aanvraag direct kosteloos toegezonden. This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Nederland B.V. group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. On all offers and agreements under which Atos Nederland B.V. supplies goods and/or services of whatever nature, the Terms of Delivery from Atos Nederland B.V. exclusively apply. The Terms of Delivery shall be promptly submitted to you on your request. Atos Nederland B.V. / Utrecht KvK Utrecht 30132762 ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- For more information on Linux on System z, visit http://wiki.linuxvm.org/
