Correlated Subquery to Analytics
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 where correlated sub select is used which can easily be written using analytics. In this…
The Database Handyman
Cloud Architecture. Open-Source Databases. Data-Driven Solutions.
The Database Handyman
Cloud Architecture. Open-Source Databases. Data-Driven Solutions.
Oracle 11gr2 Dataguard – Resolving ORA 19909
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 the dataguard database. Configuration: All databases were on 11gR2 (11.2.0.4) single node using Oracle Restart.…
Advance Active Session History
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 what to look for when application is running slow. I am sharing few notes from…
Variables: Shell Variables in SQL*PLUS
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 shell variables in sqlplus to create dynamic sql. Shell to SQLPLUS Here I am using…
Variables: Shell, SQL*PLUS and PL/SQL
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. Here is an example of how to save result from SQL query into Shell variable. Commands…
Generate Meta Data Since Last Restore Point
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 looking to do something similar set pages 0 long 200000 feedback off lines 2000 trims…
Oracle Database Service
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 Transparent Network Substrate (TNS) entry didn’t need to be update for failover test? Some background…
How to Flush SQL Cursor Cache from Oracle Library Cache
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 pool in system global area (SGA). The shared pool stores cached data dictionary information and…
Important Steps Before Upgrading OMR database to 12c PDB
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 change connect descriptor for Oracle Managed Service (OMS) to SERVICE_NAME instead of SID. Run the…
How to Clone Oracle Grid Infrastructure / Restart and database Home
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 a lot of time in installing the GI Software, oracle database software and then applying…