Oracle Database 12cR1 – The Database Handyman

Unified Auditing

November 4, 2020November 4, 2020 Aamir

In this blog post I am sharing my notes about Unified Auditing. It shows how to enable and purge Unified Audit data. From Oracle Documents:

….yes, that is correct. You can apply an execution plan even if it has been aged out from your local Automatic Workload Repository (AWR). But

September 20, 2016 Aamir

I attended a session in Oracle Open World 2016 given by Kyle Hailey. In his presentation Kyle talked about how to measure database performance and

March 16, 2016March 15, 2016 Aamir

This is the second part of my blog about Shell scripting with focus on Oracle database. Here is an example of how you can use

March 11, 2016March 15, 2016 Aamir

I am going to start blogging about shell scripting tips and technique focusing on database and how they can be used to make DBA life easier.

December 5, 2015 Aamir

All most all of Oracle DBAs are familiar with command to flush shared pool: alter system flush shared_pool; This command clears all data from shared