profile

Generate performance report in postgres using pg_profile

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...

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...