Oracle Troubleshooting

CRS-4124: Oracle High Availability Services startup failed

CRS-4124: Oracle High Availability Services startup failed I was installing the Oracle Grid Infrastructure on Red Hat Enterprise 6.5 on 64 bit platform. While execute the root.sh I got CRS-4124 : Oracle High Availability Services startup failed error. This information

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

Calculating Execution Time of Query in Oracle

In this post I am going to show how to calculate execution time of Query in Oracle Database. When user submits the query oracle parses the query and compute Hash Value for the statement. In V$SQL view we are having

Interpreting Oracle Execution Plan

I have found a very nice oracle white paper of interpretation of Oracle Execution Plan. This white paper covers the below topics. Displaying Execution Plan What is Cost Understanding Execution Plan(Cardinality,Access Paths, Join Method, Join Order,Partitioning, Parallel Execution Etc.) Download

Oracle database slow after schema import

Oracle database slow after schema IMPORT. Some days ago I got called from one of my client regarding the slowness of one of the data synchronization process after performing IMPORT operation of the schema. I called the onsite DBA to