August 2023 - ASRblogger

Oracle Single Client Access Name (SCAN)

Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments that provides a single name for clients to access any Oracle Database running in a…

asrblogger August 29, 2023No Comments

Oracle

What is a Materialized View?

Materialized views are query results that have been stored or "materialized" in advance as schema objects. The FROM clause of the query can name tables, views, and materialized views. Collectively…

asrblogger August 27, 2023No Comments

Splunk

Components and Buckets in SPLUNK

Components: The primary components in the Splunk architecture are Forwarders, the Indexers and the Search Head. Forwarders:The forwarder is an agent you deploy on IT systems, which collects logs and…

asrblogger August 25, 2023No Comments

Oracle

ORA-04031: unable to allocate bytes of shared memory

What is the shared pool ? Oracle keeps SQL statements, packages, object information and many other items in an area in the SGA known as the shared pool. This sharable…

asrblogger August 23, 2023No Comments

Core DBA Interview Questions Oracle

RMAN Retention Policy Based On Redundancy Policy

When you are taking backups regularly to a specified disk then after some period of time the backup disk will get full and you will need to delete old backups…

asrblogger August 15, 2023No Comments

Oracle RAC

Prerequisite check “CheckActiveFilesAndExecutables” failed.

While trying to rollback the conflicting patch 18893947 applying patch 21967332 $ opatch rollback -id 18893947 Oracle Interim Patch Installer version 12.2.0.1.11 Copyright (c) 2018, Oracle Corporation. All rights reserved.…

asrblogger August 12, 2023No Comments

Oracle

Undo 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 with autoextend=on then the tablespace will use the first approach, it will set the undo…

asrblogger August 10, 2023No Comments

Oracle

How to Monitor the Progress of a Materialized View Refresh ??

Determine if a Specific MVIEW is Being Refreshed: column owner format a15 column username format a15 column mview format a15 select o.owner, o.object_name mview, username, s.sid from v$lock l, dba_objects…

asrblogger August 7, 2023No Comments

DataGuard Oracle

Data Guard Protection Mode.

Maximum Protection Mode 1. No data loss 2. Redo has to be written to both Primary redo logs and standby redo logs (of atleast one standby database) before transaction commits…