asrblogger, Author at ASRblogger

Database Buffer Cache : SGA Component of Oracle

The database buffer cache, also called the buffer cache, is the memory area that stores copies of data blocks read from data files. A buffer is a main memory address in which the buffer…

asrblogger November 25, 2021No Comments

Oracle

Contents in Flash Recovery Area(FRA)?

Oracle can store different kind of files under FRA: – backupset: for RMAN regular backups. – datafile: for RMAN image copies. – autobackup: for control file autobackups. – flashback: If…

asrblogger November 11, 2021No Comments

SQL

LIKE Operator : Pattern-matching Conditions

The pattern-matching conditions compare character data. LIKE Condition * The LIKE conditions specify a test involving pattern matching. Whereas the equality operator (=) exactly matches one character value to another.…

asrblogger October 24, 2021No Comments

Oracle

Control files in Oracle (Physical Storage)

The database control file is a small binary file associated with only one database. Each database has one unique control file, although multiple identical copies are permitted. Use of Control…

asrblogger October 21, 2021No Comments

Cloud

Protected: Workshop: Generative AI Resources

This content is password protected. To view it please go to the post page and enter the password.

asrblogger October 15, 2021

Oracle RAC

Flush SQL Statement from Shared Pool

If you flush the shared pool, all the statements in cursor will be flushed. Sometimes it is required to flush the bad SQL_PLAN from shared_pool so that new (or old)…

asrblogger October 10, 2021No Comments

Oracle

Overview of Checkpoints !!

A checkpoint is a crucial mechanism in consistent database shutdowns, instance recovery, and Oracle Database operation generally. The term has the following related meanings: • A data structure that indicates…

asrblogger October 8, 2021No Comments

Oracle SQL

Dynamic Performance Views in Oracle

The dynamic performance views are special views that are continuously updated while a database is open and in use. Throughout its operation, Oracle Database maintains a set of virtual tables…

asrblogger September 15, 2021No Comments

Oracle

Oracle Database Locking Mechanism – 1

A lock is a mechanism that prevents destructive interactions. Interactions are destructive when they incorrectly update data or incorrectly alter underlying data structures, between transactions accessing shared data. Locks play…

asrblogger August 19, 2021No Comments

Oracle

OPATCHAUTO-72083: Performing bootstrap operations failed OPATCHAUTO-72146: Failed to load patch !!

Problem:While patching 19.3 GRID_HOME with July2019 RU patch 19.4 I got this error: [root@localhost bin]# export PATCH_LOCATION=/u01/oracle/RU_PATCHES/29708769 [root@localhost bin]# $GRID_HOME/OPatch/opatchauto apply $PATCH_LOCATION -oh $GRID_HOME OPatchauto session is initiated at Mon…