asrblogger, Author at ASRblogger

Changing Protection Mode in Data Guard !!

In Oracle Data Guard, changing the protection mode involves adjusting the configuration to one of the three protection modes: Maximum Protection, Maximum Availability, or Maximum Performance. The steps to change…

asrblogger April 3, 2024No Comments

Splunk

Basic Search: SPLUNK

Meta-Data:The Meta-data is generally the first command of the search. As a best practice, we should include 4 fields always in the first line of the query. This is not…

asrblogger March 26, 2024No Comments

Oracle

Hash partitioning in Oracle !!

Hash partitioning is a database partitioning technique used in Oracle databases to distribute data evenly across multiple partitions. This method is particularly useful for ensuring a balanced distribution of data…

asrblogger March 24, 2024No Comments

Oracle

Memory Tuning in Oracle Database

What is Memory Tuning? Memory tuning involves redistributing or reallocating free memory to Oracle memory components, primarily aimed at optimizing the performance of Oracle queries. As database performance continues to…

asrblogger March 4, 2024No Comments

Oracle

How to Kill Session in Oracle 19c

As an Oracle DBA, there may be times when you need to terminate a session. For example, an application developer might accidentally run a resource-intensive query multiple times or face…

asrblogger February 24, 2024No Comments

DataGuard Oracle

ORA-16855: Transport Lag Has Exceeded Specified Threshold in Data Guard !!

The ORA-16855 error indicates that the transport lag (the delay in sending redo data from the primary to the standby database) has exceeded the specified threshold. Cause: The current apply…

asrblogger February 23, 2024No Comments

Oracle

Basic Administration 12c/19c – Imp!!

Basic-Administration-1Download Hope it worked !! :)

asrblogger December 30, 2023No Comments

DataGuard Oracle

Dataguard Configuration with DG Broker using Active Duplicate in Oracle !!

Dataguard-Configuration-using-active-duplicate-1Download Hope it helped !! :)

asrblogger December 30, 2023No Comments

Splunk

Exposure to commands in Splunk – Part I

Stats: The stats command is used to calculate summary statistics on the results of a search or the events retrieved from an index. count It gives you the count of events…

asrblogger December 27, 2023No Comments

Oracle

How To Purge The UNIFIED AUDIT TRAIL ?

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later The unified audit trail can be purged using the DBMS_AUDIT_MGMT package: sqlplus / as sysdba SQL> select count(*) from unified_audit_trail;…