….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…
My notes about Oracle Database, APEX, OEM Cloud Control and Life (yes DBAs have life too :) )
DBA Blog Posts
Recently I was testing AWR Warehouse functionality at work and had to re-configure the AWR Repository database due to a firewall issue which caused me…
At work I came across a query that was using correlated sub select and I thought it is worth sharing. I have seen many queries…
Just wanted to write quick blog about an error we got on Standby Database and steps I performed to resolved it. Saved me from re-building…
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…
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…
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.…
I was asked if it was possible to generate all ddl since last restore point. I came up with following script. It might help others…
Recently at my work place for the first time, I planned and executed QA environment failover test to standby database and was asked how come…
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…