2.8.3.4 Configure ER Schema Profile

This section describes how to configure the ER schema profile.

Set the SESSIONS_PER_USER limit to UNLIMITED for ER Schema:

1. Get the ER schema profile using the below query.

   select profile from dba_users where username ='<ER SCHEMA USERNAME>’;

2. Change the profile which is obtained from the step 1 using the below query.

   ALTER PROFILE <profile> LIMIT SESSIONS_PER_USER UNLIMITED;