ORA-28604 table too fragmented to build bitmap index

One of my data loading got delayed by 4 hours in data warehouse. Application team reported they have found some errors in their log. When i checked the application log I found that 6-7 bitmap index creation was failed due

APPROX_COUNT_DISTINCT Function – Oracle 12c

The need to count distinct values of column is common operation in data analysis. It helps to decide whether an index will be useful or not. Prior to 12c database, we need to execute a query on the table to

Maximum Size of VARCHAR2, NVARCHAR2, and RAW Columns in 12C Database

Maximum Size of VARCHAR2, NVARCHAR2, and RAW Columns in 12C Database

In Oracle Database 12c, VARCHAR2 and NVARCHAR2 data types supports size up to 32767 bytes. This article explains how to increase maximum size of VARCHAR2, NVARCHAR2 and RAW columns in oracle 12c database using MAX_STRING_SIZE parameter. Prior to 12c version,

Return dataset from function using pipelined table function

In this post I am going to demonstrate how to return dataset from function in PL/SQL using pipelined table function. For this we need to perform below steps. Create TYPE object as OBJECT of the structure of required output format Create

Oracle Query Tuning – Example 2

Day by day technology is upgrading and every organization tries to make easy way of communication for their customers. In our day-today life when we make any payment, Recharge Mobiles etc, we get notification on mobile phone via SMS. These

OPT_PARAM Hint in oracle

The OPT_PARAM hint in oracle lets you set an initialization parameter for the duration of the current query only. As per oracle documentation following parameters supports with OPT_PARAM hint. OPTIMIZER_DYNAMIC_SAMPLING OPTIMIZER_INDEX_CACHING OPTIMIZER_INDEX_COST_ADJ OPTIMIZER_SECURE_VIEW_MERGING STAR_TRANSFORMATION_ENABLED

How to Convert rows into columns using SQL in Oracle

What comes in mind if we think about transposition like row-to-column or column-to-row. Answer is very simple, It’s ‘Pivot’ when there is row-to-column transposition and it’s ‘Unpivot’ when there is column-to-row transposition. As post title shows this article is about

Virtual Index in Oracle Database

Virtual index is definition of index which is physically not created that is segment is not created for such index. The main purpose of virtual index is to determine whether the created index would be useful or not for the

Page 2 of 512345