Tag 11gR2

ASH Script for Finding out Top Wait Events in Oracle

prompt ************************************ prompt **** ASH OVERALL WAIT PROFILE prompt ************************************ set lines 999 SELECT MIN(sample_time) min_ash_available,sysdate-MIN(sample_time) available duration FROM v$active_session_history;…

CREATE TABLE REPLICATION USING MATERIALIZED VIEWS ORACLE

CREATE TABLE REPLICATION USING MATERIALIZED VIEWS ————————————————- SOURCE TABLE : LOG_RECORD TARGET TABLE : LOG_RECORD_UPD We have a large table…