Performance issues

Performance issues

 

  

Hi All,

My Oracle 9i Database seems to hang up sometimes if one of the users goes in for heavy processing. What are the tuning parameters i should look into ??

Sometimes it doesnt give new logins too. How do i know what is the limit on the number of users who can connect ??

I have Oracle9i/RHAS2.1.

TIA.

--Shib

Oracle LazyDBA home page