January 2023 - ASRblogger

Killing Hung RMAN Session in Oracle

Sometimes you may need to kill the RMAN session which is hanging and does not respond. There are several ways to terminate an RMAN command in the middle of execution:…

asrblogger January 29, 2023No Comments

Oracle

Enable/Disable Archive Log Mode In Oracle Database?

ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that have occurred in the database so that you can recover…

asrblogger January 23, 2023No Comments

Splunk

SPLUNK Commands

Commands: In Splunk, to write a query we need to learn the various commands it offers. Each command comes with a special use case and can be used for its…

asrblogger January 20, 2023No Comments

Oracle RAC

Server Parameter File in RAC

During the Creation of database via DBCA , SPFILE is created in the file location that we specify. This location can be an ASM disk group, cluster file system file,…

asrblogger January 17, 2023No Comments

Core DBA Interview Questions Oracle

Read-only user Creation.

Sometimes the DBA requires to create the read-only user for a particular schemas.While creating the user,one should always keep in mind that the user should have minimum privileges. There is…

asrblogger January 15, 2023No Comments

GoldenGate Oracle

Before we start tuning GoldenGate…

Large objects (LOBs) LOBs can be a problem in data replication by virtue of their size and the ability to extract, transmit, and deliver the data from source to target.…

asrblogger January 12, 2023No Comments

Oracle

System Locks Oracle Database uses various types of system locks to protect internal database and memory structures. These mechanisms are inaccessible to users because users have no control over their…

asrblogger January 7, 2023No Comments

GoldenGate Oracle

Adding Replicats with @RANGE function in GG

Hey Folks, We have recently faced issue with huge lag due to bulk transaction(Insert Operation). To resolve the gap quickly, we opted in creating Range Replicat. The RANGE function The…