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
Here are some important steps that needs to be done before you upgrade Oracle Managed Repository (OMR) database to 12c PDB. First you have to
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