HUGE PAGES CONCEPTS
HUGE PAGES What are Huge Pages? Linux Manages memory in pages while loading data from disk to memory or writing back to disk from memory. Huge pages is a…
Read MoreOracle Blob and Clob Datatypes
CLOB and BLOB are two types of data types used in databases to store large amounts of data. BLOB: BLOB, or Binary Large Object, is used to store binary data such as images, audio, video, and other multimedia objects. It is an extension of the VARBINARY data type and can store up to 2GB of data.Using CLOB and BLOB data types can be beneficial in many situations. CLOB:CLOB, or Character Large Object, is used to store textual data and is used for large strings of text. It is an extension of the VARCHAR data type and can store up to 4GB of data if you have a large document or image you need to store, you can use a CLOB or BLOB data type to store it.storage space is occupied more in the database, so you should be careful about when and how you use them. To query for CLOB or BLOB datatypes,…
Read Morewhat 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 MoreSteps 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 MoreSQL 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 MoreDifferent 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 MoreDeep 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 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 More