asrblogger, Author at ASRblogger

Redolog Buffer Cache : SGA Component of Oracle

The redo log buffer is a circular buffer in the SGA that stores redo entries describing changes made to the database.A redo record is a data structure that contains the information necessary to reconstruct,…

asrblogger March 31, 2023No Comments

Interview Questions Oracle

Shared /Large/Java/Result Pool: SGA Component of Oracle

The shared pool caches various types of program data.For example, the shared pool stores parsed SQL, PL/SQL code, system parameters, and data dictionary information. The shared pool is involved in almost every operation that…

asrblogger March 29, 2023No Comments

Splunk

SPLUNK’s Advance Topic

Macros Search macros are reusable chunks of Search Processing Language (SPL) that you can insert into other searches. Search macros can be any part of a search, such as an eval…

asrblogger March 26, 2023No Comments

Linux Oracle Scripts

Crontab : RMAN Backup

Automate RMAN Backup using Shell Script In a real environment, you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. Create…

asrblogger March 26, 2023No Comments

Splunk

Roles and Licensing in Splunk

Roles: There are basically three different types of Roles in Splunk:User: This is the basic role in Splunk which provides access to all shared data sets to be read, viewed…

asrblogger March 25, 2023No Comments

DataGuard Oracle

Recovery Point Objective(RPO) and Recovery Time Objective (RTO)

A) Recovery Point Objective(RPO) A recovery point objective (RPO) is the maximum length of time permitted that data can be restored from, which may or may not mean data loss.…

asrblogger March 21, 2023No Comments

Oracle

How to Change SQL*Plus Prompt to Reflect Username & Instance Name ??

1. Verify that client networking connections are functional. Clients must be able to login to sql*plus with username/password/host string (where host string is the alias created for the specific sid).…

asrblogger March 14, 2023No Comments

ASM Oracle

Background Processes in Oracle ASM

Once the ASM instance is started, all the basic background processes, as well as some that are specific to the operation of ASM, are started. On Linux, the ASM processes…

asrblogger March 13, 2023No Comments

Oracle

Row Chaining and Row Migration

Row Chaining Occurs when the row is too large to fit into one data block when it is first inserted. In this case, Oracle stores the data for the row…

asrblogger March 12, 2023No Comments

Interview Questions Oracle

Overview of the Program Global Area (PGA)

The PGA is memory specific to an operating process or thread that is not shared by other processes or threads on the system. Because the PGA is process-specific, it is…