How to run SQL tuning advisor manually in Oracle Database
Step 1: Get the hash value of the SQL using the SQL ID. Enter the SQL ID select a.plan_hash_value from v$sql a where sql_id=’&a’; Step 2: Create a tuning…
Read MoreMICROSOFT SQL DATABASE CREATION
STEPS TO CREATE THE MS-SQL DATABASE STEP 1: Download the .NET Framework version 3.5 and above, if not installed already. STEP 2: Download the SQL server –…
Read MoreBackup and Restore Boot Volume in OCI
BACKUP AND RESTORE BOOT VOLUME IN OCI Introduction In Oracle Cloud Infrastructure (OCI), it’s crucial to have a backup of the boot volume of your instances to ensure data and…
Read MoreAdding and Grouping Server in Logic Monitor
ADDING & GROUPING SERVER IN LOGIC MONITOR INTRODUCTION: Logic Monitor is a cloud-based infrastructure monitoring solution designed to help organizations monitor the health and performance of their IT systems. It…
Read MoreOEM Upgrade from 13.4 to 13.5
OEM UPGRADE FROM 13.4 TO 13.5 PRE-REQUISITE: First, we need to take a backup of the Middleware Home, the Management Repository, Central inventory, Software library, Management Agent. The minimum…
Read MoreNFS Server & Client Installation on Linux Environment
What is Network File System (NFS) Network File System (NFS) is a distributed file system that allows various users to access and share files over a network. It is commonly…
Read MoreAutomate All IT Operations in Linux using OLAM 2.0
Automate All IT Operations in Linux using OLAM 2.0 Introduction of OLAM 2.0(Oracle Linux Automation Manager/Engine) In today’s fast-paced business environment, companies are under pressure to deliver their IT services…
Read MoreOEM 13.4 Step by Step Installation
OEM 13.4 INSTALLATION AND CONFIGURATION OEM OVERVIEW: Oracle Enterprise Manager is management tool, which is used to integrated solution for managing your heterogeneous environment. It Includes, Graphical console, Agents,…
Read MoreReduce cloud efforts upto 30% in OCI
The rapid growth of cloud technologies is accelerating the expansion of cloud applications and driving demand for higher levels of application performance and availability. Business environments are more dynamic than…
Read MoreTo Fix SQL Server Always on Availability Group Database in Secondary Replica is Not Synchronized with Primary Replica.
SQL Server Issue and Solution Error Summary: To Fix SQL Server Always on Availability Group Database in Secondary Replica is Not Synchronized with Primary Replica. REASON: If there is…
Read More