Breaking News: Grepper is joining You.com. Read the official announcement!

ora-02391

VasteMonde answered on May 4, 2022 Popularity 7/10 Helpfulness 6/10

answer ora-02391

ora-02391

Comment

-- Current sessions:
SELECT USERNAME, count(*) as connections FROM v$session GROUP BY USERNAME;
-- Limitations:
SELECT a.USERNAME, b.PROFILE, b.RESOURCE_NAME, b.LIMIT
FROM DBA_USERS a, DBA_PROFILEs b
WHERE a.PROFILE = b.PROFILE AND b.RESOURCE_NAME = 'SESSIONS_PER_USER';
-- Change limitation:
ALTER PROFILE my_profile LIMIT SESSIONS_PER_USER 10;

Popularity 7/10 Helpfulness 6/10 Language sql

Source: dbaclass.com

Tags: limit oracle simultaneous sql

Link to this answer
Share Copy Link

Contributed on May 04 2022

VasteMonde

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

ora-02391

Contents

More Related Answers

ora-02391

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.