Database Blog

what are the oracle index status

Oracle index is a database object that is used to improve the performance of certain queries by providing direct access to the data in a table.  Indexes are created on columns and contain entries that point to the data in the table.  An index can be unique or non–unique and can be created on one or more columns. some of status are below. 1.Unusable 2.N/A 3.Valid 4.Invalid 1.UNUSABLEAn Oracle index can become unusable if the underlying table has been modified or dropped, or if the index has been corrupted. To fix this, you need to re–create the index.The data is not in the order specified by the  SORTED INDEXES clause ALTER INDEX [schema.]indexname REBUILD ONLINE;…

Read More

Steps for modifying the scan name configuration in oracle RAC.

INTRODUCTION What is scan name for Oracle database? Single Client Access Name (SCAN) is a feature used in Oracle Real Application Clusters environments that provides a single name for clients to…

Read More

SQL Server installation Slipstream

                        Slipstream in SQL Server What is the slipstream how to use slipstream to install SQL server? Slipstream is a technique used by System Admins to easily update the setup packages…

Read More

Different ways to get the Explain Plan for a SQL ID 

1.To Display the execution plan of the last SQL statement executed by the current session  SET LINESIZE 150  SET PAGESIZE 2000  SELECT * FROM table (DBMS_XPLAN.DISPLAY_CURSOR);  2.To display the execution…

Read More

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 More

Role 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 More

In 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 More

WHAT 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 More

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 More

MICROSOFT 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 More