Originally posted by Rohit
I am sorry I did not furnish enough details about our environment..

We are on OLTP database with oracle 8.1.7 on Sun Solaris 5.8 on a Sun Sparc With 4 processors and 2 GB RAM.

I was just wondering if the parameters were set appropriately or can they be changed cos the max_UTILIZATION show a lesser numer for eg the processes or the sessions.

Pls do advice
It depends.. depends on query response time. how users feelings.. if users are happy, dont touch the system..