3.9 Ensure 'SESSIONS_PER_USER' Is Less than or Equal to '10'

Information

As limiting the number of the SESSIONS_PER_USER can help prevent memory resource exhaustion by poorly formed requests or intentional Denial-of-Service attacks, this value should be set according to the needs of the organization.To enable this setting it is necessary to enable the RESOURCE_LIMIT ( ALTER SYSTEM SET RESOURCE_LIMIT = TRUE; ).

Solution

To remediate this setting execute the following SQL statement. ALTER PROFILE DEFAULT LIMIT SESSIONS_PER_USER 10;

See Also

https://workbench.cisecurity.org/files/601