Month: September 2023

On 12c, Oracle XML DB is now a mandatory component of Oracle Database. You cannot uninstall it, and if Oracle...

On : 19.18.0.0.0 version, Patching After applying a RU Patch , CATALOG / CATPROC Component goes Invalid with lot of...

SELECT to_char(begin_interval_time,’YY-MM-DD HH24′) snap_time, dhso.object_name, sum(db_block_changes_delta) BLOCK_CHANGED FROM dba_hist_seg_stat dhss, dba_hist_seg_stat_obj dhso, dba_hist_snapshot dhs WHERE dhs.snap_id = dhss.snap_id AND dhs.instance_number...

ORACLE_HOME disk (filesystem) became full and caused an ASM error... Got the following errors in the alert log file: ORA-01148:...

Traditional startup/shutdown command prior to 12c. Shutdown Command SHUTDOWN NORMAL SHUTDOWN IMMEDIATE SHUTDOWN ABORT Startup Command STARTUP STARTUP NOMOUNT STARTUP...

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...

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,...

Private SQL area holds information about a parsed SQL statement and other session specific information for processing. When a server...