HugePages in Linux
Computer memory is managed in blocks of storage known as pages, which have a predetermined…
Read moreasrblogger
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 moreComponent 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 moreOracle Single Client Access Name (SCAN)
Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments…
Read moreWhat is a Materialized View?
Materialized views are query results that have been stored or "materialized" in advance as schema…
Read moreComponents and Buckets in SPLUNK
Components: The primary components in the Splunk architecture are Forwarders, the Indexers and the Search…
Read moreORA-04031: unable to allocate bytes of shared memory
What is the shared pool ? Oracle keeps SQL statements, packages, object information and many…
Read moreRMAN Retention Policy Based On Redundancy Policy
When you are taking backups regularly to a specified disk then after some period of…
Read morePrerequisite check “CheckActiveFilesAndExecutables” failed.
While trying to rollback the conflicting patch 18893947 applying patch 21967332 Following executables are active…
Read moreUndo retention time with autoextend on and autoextend off in Oracle
The undo tablespace can have many datafiles, but if it has at least 1 datafile…
Read moreHow to Monitor the Progress of a Materialized View Refresh ??
Determine if a Specific MVIEW is Being Refreshed: Determine if a Refresh Group is Being…
Read moreData Guard Protection Mode.
Maximum Protection Mode 1. No data loss 2. Redo has to be written to both…
Read moreORA-16401, ORA-16055 : How to Drop and recreate SRL From Standby Database??
It has been seen in cases where ORA-16401 and ORA-16055 reported in primary alert log…
Read moreHow To Automatic Kill Inactive Sessions using Resource Manager
Database server crashed after memory on server used by inactive sessions The Following Example used…
Read moreMonthly Growth of the Database
We may need to find the database growth for different periods in the past. This…
Read moreDifference Between exp/imp vs Datapump (expdp/impdp)
Below Are the differences b/w exp/imp vs Datapump 1. Datapump operates on a group of…
Read more