Deep Dive – Data Dictionary Views
Introduction:- The current topic should be very familiar to the freshers and DBA’S as we know earlier. In general, The data dictionary is structured in tables and views, just like…
Read MoreRole of Global Names in Database Links
ROLE OF GLOBAL NAMES IN DATABASE LINKS Introduction:- This is mainly for Oracle DBA’S who are widely seen about Database links in their organizations, Let us understand closely about the…
Read MoreTABLE RECOVERY USING RMAN BACKUP
Objective is to recover a table using the database and archive log backup with the help of timestamp and backup destination. Here, As an example we have an database user…
Read MoreIn order to up multiple Apex application in a single instance.
The objective of this blog is to start multiple apex application in a single instance. While doing so, we get an issue in apex applications. Issue: We have about…
Read MoreWHAT IS THE DIFFERENCE BETWEEN SRVCTL AND CRSCTL?
SERVER CONTROL UTILITY (SRVCTL) Server Control Utility (SRVCTL): It is used to administer Oracle Real Application Clusters (Oracle RAC) databases and instances. Use SRVCTL to manage Oracle supplied resources such as:…
Read MoreHow 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 MoreAutomatic Indexing (DBMS_AUTO_INDEX) in Oracle Database 19c
Automatic Indexing (DBMS_AUTO_INDEX) in Oracle Database 19c The automatic indexing feature automates the index management tasks in an Oracle database. Automatic indexing automatically creates, rebuilds, and drops indexes in a…
Read More