Re: oracle in solaris consume lot of memory

Hi Ana ,

thanks for your help , can you pls guide me how can i check my Page scan rate without orcallator ? because orca itself make take lot of cpu resource from server , is ther any command for that ?

thanks

Amitabh Talukdar

Chennai, India

This will ALWAYS be the case when Oracle runs on Solaris after a short

period of time after a reboot & users are using the DB. It does NOT

matter how much RAM you put in the system or how small you make the

SGA. Simply put "free memory" is a useless indicator of anything.

A better metric is the Page Scan rate;

where 0 is GREAT

  and < 10 is perfectly acceptable

  and < 100 should be of no concern

  and > 1000 users will like experience slow response time.   

--
Posted via http://dbforums.com