Hi Guys,
In case of oracle virtual memory servers 100% cpu is normal and i dont know why most people are scared by this
Understand what is virutal memory
http://searchstorage.techtarget.com/definition/virtual-memory
http://www.dba-oracle.com/t_high_cpu.htm
Myth 2 --- I have heard from my friends in office that if you have a system with millions of records in oracle a OLTP system that is continuously accessed by users and you fire a query without a date range it will cause the system to crash due to overload as there is not enought CPU resource...Lets investigate this what is actually happening
Oracle db crash can occur through CPU starvation . its also called resource starvation suppose there is stats utility running for long time now this has high priority and there are also other sql request whch are not able to get cpu then the server can crash
consider sql which is running for hours. the important thing here is not cpu utilization but at 100% are there any processes in que whaiting to get cpu time. ??
In case of oracle virtual memory servers 100% cpu is normal and i dont know why most people are scared by this
Understand what is virutal memory
http://searchstorage.techtarget.com/definition/virtual-memory
http://www.dba-oracle.com/t_high_cpu.htm
Myth 2 --- I have heard from my friends in office that if you have a system with millions of records in oracle a OLTP system that is continuously accessed by users and you fire a query without a date range it will cause the system to crash due to overload as there is not enought CPU resource...Lets investigate this what is actually happening
Oracle db crash can occur through CPU starvation . its also called resource starvation suppose there is stats utility running for long time now this has high priority and there are also other sql request whch are not able to get cpu then the server can crash
consider sql which is running for hours. the important thing here is not cpu utilization but at 100% are there any processes in que whaiting to get cpu time. ??
No comments:
Post a Comment