Testing Profiles(sessions_per_user)

Before testing user sessions, we need to set resource_limit parameter.

SQL> show parameter resource_limit

                By default is it "false"

                We need to set  this value as "true"

SQL> alter system set resource_limit=true;

SQL> show parameter resource_limit

                Now we need to test user sessions in 3 different terminals.

SQL> conn venu/venu

SQL> conn venu/venu

SQL> conn venu/venu

                ORA-02391 : exceeded simultanious SESSIONS_PER_USER limit.

SQL> alter user venu profile default;

SQl> select username,profile from dba_users where username='VENU';