….yes, that is correct. 🙂 You can apply an execution plan even if it has been aged out from your local Automatic Workload Repository (AWR).
Category: Oracle Database 11gR2
Stuff about Oracle Database 11gR2
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
Following instructions can be used to clone Oracle Grid Infrastructure Restart from already working Oracle Linux Server to another new server. This method can save
I came across this error at work and thought it was worth blogging. Maybe someone else can benefit from it and not spend hours looking