5 min read
Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments that provides a single name...
Month: August 2023
5 min read
3 min read
Materialized views are query results that have been stored or "materialized" in advance as schema objects. The FROM clause of...
2 min read
Components: The primary components in the Splunk architecture are Forwarders, the Indexers and the Search Head. Forwarders:The forwarder is an...
2 min read
What is the shared pool ? Oracle keeps SQL statements, packages, object information and many other items in an area...
3 min read
When you are taking backups regularly to a specified disk then after some period of time the backup disk will...
1 min read
While trying to rollback the conflicting patch 18893947 applying patch 21967332 $ opatch rollback -id 18893947 Oracle Interim Patch Installer...
2 min read
The undo tablespace can have many datafiles, but if it has at least 1 datafile with autoextend=on then the tablespace...
2 min read
Determine if a Specific MVIEW is Being Refreshed: column owner format a15 column username format a15 column mview format a15...
2 min read
Maximum Protection Mode 1. No data loss 2. Redo has to be written to both Primary redo logs and standby...
