After performing database upgrade from 12.1.0.2.171017 to 12.2.0.1.171017, PDB is shown in RESTRICTED mode. SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY…

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…

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…

What is the shared pool ? Oracle keeps SQL statements, packages, object information and many other items in an area in the SGA known as the shared pool. This sharable…

The undo tablespace can have many datafiles, but if it has at least 1 datafile with autoextend=on then the tablespace will use the first approach, it will set the undo…

Determine if a Specific MVIEW is Being Refreshed: column owner format a15 column username format a15 column mview format a15 select o.owner, o.object_name mview, username, s.sid from v$lock l, dba_objects…