Oracle Database Administration

SELECT      index_name,     table_name,     leaf_blocks,     empty_blocks,     num_rows,     DISTINCT_KEYS,     (leaf_blocks - empty_blocks)...

Hello World

Exam AZ-303: Microsoft Azure Architect Technologies -  https://docs.microsoft.com/en-us/learn/certifications/exams/az-303   Practice Test...

https://query.prod.cms.rt.microsoft.com/cms/api/am/binary/RE4Hxv D  Find IP Address subnets Range https://www.ultratools.com/tools/net...

https://ravikirans.com/az-104-azure-exam-study-guide/

How to Analyze the Performance History of a SQL Statement as Recorded in AWR Using Simple SQL (Doc ID 1580764.1) http://www.nocoug.org/d...

https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/ggsci_commands.htm#GWURF895

set lines 1000 col STARTUP_TIME for a25 col platform for a40 select DBID, INSTANCE_NUMBER INST_NU,STARTUP_TIME,PARALLEL RAC, VERSION,...

http://sridharramireddy.blogspot.com/2014/09/script-to-monitor-goldengate-monitoring.html

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

SET LINESIZE 120 SET PAGESIZE 1000 col snap_begin format a35 COL executions FOR 999,999,999 COL elapsed_time FOR 999,999,999,999 COL avg...

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

Oracle GoldenGate supports two types of capture: Classic Capture Integrated Capture Classic Capture Oracle GoldenGate contin...

col PATH form a25 col GB_read for 99999 col GB_written for 9999 select a.PATH, a.mount_status, a.state, a.TOTAL_MB, a.FREE_MB, a.mount_...