reg : oracle sessions greater than a certain limit

[Former Member]

Hi ,

We have a ixos system running on oracle 8 i .We are getting alert as : Current Sessions are equal to or greater than 85 % of maximum. what does that alert correspond to and how do we resolve it .

[Former Member · Accepted solution]

This is probably about the init.ora parameter sessions. You can check it with sqlplus:

SQL> show parameter sessions

To see the number of actual sessions:

SQL> select count(*) from v$session;

The solution is most probably to increase the session parameter.

Regards, Michael

[Former Member · Accepted solution]

Thanks for the instant reply.

need to know about this thing resource limits for application profile .How do we get to know thisthing .Thanks in advance .

[Former Member · Accepted solution]

Well, i cannot help you there, because we don't use profiles for the SAP systems. But did you look at the [official oracle documentation|http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/users.htm]?

Careful this is 9i, as 8i is not supported anymore.

Cheers Michael

[Former Member]

Same question as your post ??

See my answer there.