Monday, September 13, 2010

How to find highwater mark of sessions? OR How to resolve ORA-12537: TNS:connection closed ?

select sessions_highwater from v$license;

select * from v$resource_limit;

Check if VALUE_LIMIT = MAX_UTILIZATION your database is exhausted for that parameter.

No comments:

Post a Comment