Oracle_Session_Max_status_SID

[Former Member]

Hi,

I am receiving below error alert for Solution Manager 7.1 Production.

Oracle_Session_Max_status_SID

Select limit_value current_utilization from v$resource_limit where resource name='sessions':92

Kindly advise

Thanks & Regards

Rao

[Former Member]

Hi Rao,

The alert is triggered due to the no. of Process and session hit max in your Database.

You can check the current values as below:-

sqlplus "/as sysdba"

show parameter sessions

Try to check the existing values and tune them according to below OSS notes:-

830576 - Parameter recommendations for Oracle 10g

1171650 - Automated Oracle DB parameter check

1431798 - Oracle 11.2.0: Database Parameter Settings

Do let us know if you need further help on this.

Regards,

Ram