Cloud Architecture. Open-Source Databases. Data-Driven Solutions.
Cloud Architecture. Open-Source Databases. Data-Driven Solutions.
Stuff about Oracle Database 11gR2
….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 first you’ll need a graveyard 🙂 , in other words AWR Warehouse Repository. AWR…
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.…
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…
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…
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…
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…
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…
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…
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…
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 for solution. During a Disaster Recovery exercise, my task was to drop already existing database…