Oracle Single Client Access Name (SCAN)
Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments…
Read moreAugust 2023
What 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 more