On 12c, Oracle XML DB is now a mandatory component of Oracle Database. You cannot uninstall it, and if Oracle...
Month: September 2023
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:...
SAR is used to collect, report or save system activity. SAR stands for System Activity Report. SAR is used to...
The top utility is a commonly used tool for displaying system-performance information. It dynamically shows administrators which processes are consuming processor and...
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...
Overview Benefits What can be done Different Instances Users (Interview Question) User Power User Admin Mode (Interview Question) Fast Smart...