Wednesday, July 8, 2015

Find Query Versions


SQL to find Query Versions based on a particular SQL_ID
=> you can remove the columns selected based upon your need.

Select inst_id, sql_id,address, hash_value, sql_text, version_count,loaded_versions,
executions,loads,invalidations
from gv$sqlarea
where version_count >= 1
and sql_id ='&Input_SQL_ID'
order by inst_id,version_count
/

Find historical data using SQL_ID




SAMPLE OUTPUT

Enter value for 1: 6ajkhumm78nrp





Friday, February 13, 2015

Troubleshooting 'log file sync'


Very Good Document on "log file sync" on My Oracle Support Site.
Troubleshooting: 'Log file sync' Waits (Doc ID 1376916.1)

http://www.pythian.com/blog/adaptive-log-file-sync-oracle-please-dont-do-that-again/

Tuesday, January 27, 2015

Oracle GoldenGate Limitations and Restrictions


Oracle GoldenGate supports two types of capture:

Classic Capture
Integrated Capture

Classic Capture
Oracle GoldenGate continues to support the existing Capture module, now referred to as Classic
Capture, which directly accesses the database redo logs looking for DML changes to capture for
distribution.
It is possible to capture from redo logs stored inside of ASM. Adjusting the read
size can improve Extract performance. In this mode, Extract can be integrated
with Oracle RMAN to manage log retention.


Excellent Post by another DBA - Credit goes to him.
http://sandeepnandhadba.blogspot.com/2014/12/oracle-golden-gate-12-bidirectional.html