Oracle Archives - Page 15 of 30

Common Roles Vs Local Roles

Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants 2) Roles Roles: Collection of privileges called role. In 12c we have 2 different types…

asrblogger April 3, 2023No Comments

Oracle

Common Grant Vs Local Grant

Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants 2) Roles Grants: oracle12c have two variant of grants. They are: 1) Common grants 2)…

asrblogger April 3, 2023No Comments

Interview Questions Oracle

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

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

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…