#dba users

Managed User account in Oracle

Managed User account in Oracle

Check User table Quota SELECT * FROM DBA_TS_QUOTAS

Check the USER present in Oracle database SELECT USERNAME FROM DBA_USERS;

Check session info of connection SELECT * FROM V$SESSION_CONNECT_INFO;

SELECT * FROM V$SESSION;

Check the resource limit SELECT * FROM USER_PASSWORD_LIMITS;

RESOURCE_NAME LIMIT -------------------------------- ------------ F…