If you have worked on oracle, then you must of aware of AWR report, which is used to generate workload performance report of the database for a specific duration. But in postgres there is no inbuilt f...
profile
ORA-02394: exceeded session limit on IO usage
PROBLEM: Sql query failed with ORA-02394: exceeded session limit on IO usage error. SQL> select count(*) from dba_objects; select count(*) from dba_objects * ERROR at line 1: ORA-02394: exceeded...
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
PROBLEM: While connecting to the database, getting error: SQL> connect test9/test9 ERROR: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit SOLUTION: 1. Check how many sessions were already ...
Lock account automatically with INACTIVE_ACCOUNT_TIME
In Oracle 12.2 Release We can use the INACTIVE_ACCOUNT_TIME resource parameter in profile to automatically lock the account of a database user who has not logged in to the database instance in a speci...