Find Archive Log Gaps On Standby Database ??

Archivelog gap set pagesize 320 set linesize 200 set wrap off select thread#, sequence#, applied,to_char(first_time,’mm/dd/yy hh24:mi:ss’) first,to_char(next_time, ‘mm/dd/yy hh24:mi:ss’) next,to_char(completion_time, ‘mm/dd/yy hh24:mi:ss’) completion from v$archived_log where thread# = 1 order…

What is a Materialized View?

Materialized views are query results that have been stored or "materialized" in advance as schema objects. The FROM clause of the query can name tables, views, and materialized views. Collectively…