HOW TO ACCESS ORATOP UTILITY
Description : Oratop is an interface that takes data from top and oracle databases on a host. The utility combines the data to OS data and session data. It allows…
Read MoreSecurity Care in AWS RDS
Running Oracle Database on Amazon Web Services (AWS) Relational Database Service (RDS) provides a variety of advantages, including scalability, flexibility, and managed services. However, in order to secure your sensitive…
Read MoreNew Features of Oracle Database 23c
Oracle Database 23c, Oracle Corporation’s most recent release, includes a slew of new features and changes designed to provide organizations with expanded capabilities and improved performance. Overview: Enhanced machine learning…
Read MoreCreate a login using SSMS for SQL Server
To use SQL Server, you need a login. You can log in using a regular Windows account or a special SQL Server account. SQL Server Supports two Authentication Modes:…
Read MoreDemystifying Load Balancer Setup in Oracle Cloud Infrastructure (OCI)
Demystifying Load Balancer Setup in Oracle Cloud Infrastructure (OCI) Introduction Load Balancing allows customers to distribute web requests among a group…
Read MoreComprehensive Guide: Removing and Adding RAC Nodes in Oracle Clusterware
Overview Diving into the intricacies of Oracle Clusterware management, this comprehensive guide elucidates the meticulous steps involved in the process of deleting and adding RAC nodes within the Oracle environment. …
Read MoreTroubleshooting and Resolving ‘CheckApplicable’ Prerequisite Error When Applying Oracle GI RU July-2023 Patch
Overview of blog In this blog post, we will explore a comprehensive solution to resolve the issue of ‘oracle.rdbms.deconfig, 19.0.0.0.0’: Cannot delete file ‘/usr/local/oracle/19.3.0.0/suptools/tfa’ and the subsequent ‘CheckApplicable’ prerequisite failure.…
Read MoreManual Failover of Oracle Data Guard
A failover is performed only when the primary database becomes unavailable, and there is no possibility of recovering the primary database. Steps involve in failover Connect to Physical Standby…
Read MoreFortifying Oracle Identity Cloud Service with Multifactor Authentication (MFA)
Fortifying Oracle Identity Cloud Service with Multifactor Authentication (MFA) Introduction Oracle Identity Cloud Service employs MFA, where users utilize two-factor verification, incorporating extra information or a second device during logins…
Read MoreHARNESSING BLOCK CHANGE TRACKING FOR ENHANCED PERFORMANCE
Block changing tracking improves the performance of incremental backups by recording changed blocks in the block change tracking file. During an incremental backup, instead of scanning all data blocks to identify which blocks have changed, RMAN uses this file to identify the changed blocks that need to be backed up. TO ENSURE THE CURRENT PERFORMANCE OF INCREMENTAL BACKUPS: SQL> select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,’mm/dd/yy hh24:mi’) start_time, to_char(END_TIME,’mm/dd/yy hh24:mi’) end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; The above command will show the performance of daily incremental backups. i.e., How many hours the database backup is running before enabling the block change tracking. TO ENSURE THE BLOCK CHANGE TRACKING IS ENABLED IN THE DATABASE: SQL> select status, filename from v$block_change_tracking; It will show the block change tracking is enabled in our database or not. If it shows disabled, we want to enable the parameter by issue the below command. SQL> alter database enable block change tracking; NOTE:- After enables the BLOCK_CHANGE_TRACKING, wait for a day to complete the database backup. Then issue the above command to ensure the incremental backup performance. It will show you the positive differences compares to the earliest performance.
Read More