"Especially noteworthy, because it uses file system files (not raw partitions), and the "caching" is outside, it relies heavily on (and is very sensitive to) the file system cache that you have set up." This guy seems to have never heard about the buffer cache, directIO and ASM (and long before ASM, people where running oracle databases on raw devices). "Oracle does not have a true server architecture (others have it). Rather than performing classic server tasks, such as multi-threading, caching of data pages, parallel processing (split a query across many devices) etc. within itself, it uses the o/s to do all that. That means for each user process (PL/SQL connection) there is one unix process; 1000 users means 1000 unix processes, all competing for the same resources." No idea what his problem with this is. To me, process handling is something that is the responsibility of the OS. And which is something that differs from platform to platform. To my knowledge the other RDBMS systems work on the same way (don't know if there any niche products which are doing this). In short, this guy is full of ... Regards, Freek D'Hooge Uptime Oracle Database Administrator email: freek.dhooge@xxxxxxxxx tel +32(0)3 451 23 82 http://www.uptime.be disclaimer: www.uptime.be/disclaimer ________________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Brady, Mark Sent: dinsdag 15 maart 2011 15:09 Cc: oracle-l@xxxxxxxxxxxxx Subject: Oracle internal flaws? I saw this answer today on StackOverflow. http://stackoverflow.com/questions/5307590/cpu-usage-of-oracle-installed-database-machine Quote from PerformanceDBA, a notable Oracle basher. "Oracle does not have a true server architecture (others have it). Rather than performing classic server tasks, such as multi-threading, caching of data pages, parallel processing (split a query across many devices) etc. within itself, it uses the o/s to do all that. That means for each user process (PL/SQL connection) there is one unix process; 1000 users means 1000 unix processes, all competing for the same resources. Especially noteworthy, because it uses file system files (not raw partitions), and the "caching" is outside, it relies heavily on (and is very sensitive to) the file system cache that you have set up. likewise, Oracle needs a massive amount of memory for these processes." I'm not enough of an internals guy to accurately refute these declarations. Can anyone help me understand which of these statements are true and whether or not they are deficiencies? >>> This e-mail and any attachments are confidential, may contain legal, >>> professional or other privileged information, and are intended solely for >>> the addressee. If you are not the intended recipient, do not use the >>> information in this e-mail in any way, delete this e-mail and notify the >>> sender. CEG-IP1 -- //www.freelists.org/webpage/oracle-l