Oracle XML Database (XDB) Installation on 12c – XDB invalid status
On 12c, Oracle XML DB is now a mandatory component of Oracle Database. You cannot…
Read moreSeptember 2023
Component goes Invalid after applying a RU Patch , CATALOG / CATPROC
On : 19.18.0.0.0 version, Patching After applying a RU Patch , CATALOG / CATPROC Component…
Read moreScript to check Segments Generating Redo logs?
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…
Read moreORA-09817: Write To Audit File Failed
ORACLE_HOME disk (filesystem) became full and caused an ASM error... Got the following errors in…
Read moreMonitoring System Performance Using SAR
SAR is used to collect, report or save system activity. SAR stands for System Activity…
Read moreHow to Use the top Command in Linux ??
The top utility is a commonly used tool for displaying system-performance information. It dynamically shows…
Read moreHow to Startup/Shutdown PDB’s ??
Traditional startup/shutdown command prior to 12c. Shutdown Command SHUTDOWN NORMAL SHUTDOWN IMMEDIATE SHUTDOWN ABORT Startup…
Read moreDB Opened In Restricted Mode Due To PDB Plug-in Violations Related To Datapatch
After performing database upgrade from 12.1.0.2.171017 to 12.2.0.1.171017, PDB is shown in RESTRICTED mode. PDB_PLUG_IN_VIOLATIONS…
Read moreFind Archive Log Gaps On Standby Database ??
Archivelog gap Log Gap Check Restore Archivelog from Backup Stop and Start MRP Services
Read moreCursor Sharing in Oracle
Private SQL area holds information about a parsed SQL statement and other session specific information…
Read moreSplunk Contents ….In Progress on below topics !!
Overview Benefits What can be done Different Instances Users (Interview Question) User Power User Admin…
Read more