limiting the number of sessions per user

[former_member207834]

Hi,

We want to limit  the number of sessions per user to 10 by setting parameter SESSIONS_PER_USER.

As we know , there is a dedicated shadow process in oracle for each SAP work process. Is it feasible to set SESSIONS_PER_USER=10 in oracle for SAP system?

Best Regards.

Tushar

[former_member206552]

Hi Tushar,

If i understand you correctly, You cannot manage SAP users at oracle level, you will need to limit the users from within SAP

this is an overview from SAP

http://help.sap.com/saphelp_nwpi711/helpdata/en/47/c32b96f41f2974e10000000a42189b/content.htm

http://wiki.scn.sap.com/wiki/display/EP/Limiting+Number+of+Users+Logged+On

Just to add, number of sessions per user be limited

12466 - Logon restrictions in R/3

If you set parameters at DB level you limit the whole SAP system and not just users.

Best Regards

Marius

[ACE-SAP]

Hi

You cannot use this parameter, as SAP system connects onto the DB using only the SAPSR3 account.

SAP users are not defined at Oracle level.

The only option option for restricting resource usage is to use Oracle Ressource Mger

1589924 - SAP Workload Management via Oracle Resource Manager

Regards