Introduction: Sessions which are running longer in oracle database can be viewed from v$session_longops view provided...
How to find long running sessions in Oracle database
read more
Oracle
How to purge audit trail records from audit table sys.aud$ in Oracle database 12c?
Introduction: If you are observing fast growth in SYSAUX tablespace and your database version is 12c, then you need to...
How to change AWR snapshot interval in Oracle database
Introduction: Performance statistics for the database are obtained, analysed and managed by the Automated Workload...
Datapatch in 12c Oracle database
Introduction: Prior to 12c, the post patch steps as part of CPU/PSU/Bug fixes are required to run manually on the...