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

Latest DML time on a table

In this post we will see how to find the latest DML time performed on the table. For this we are going to use ORA_ROWSCN Pseudocolumn. ORA_ROWSCN returns the conservative upper bound system change number (SCN) of the most recent change to

Difference between count(*) and count(1) – Part 3

In the last two post we have seen the two scenarios to check the difference between count(*) and count(1) executions. Execution plans and statistics from both the scenarios confirmed that there is no any difference difference between the executions of these

Difference between count(*) and count(1) – Part 2

In the last post I have demonstrate the scenario for employee table without any index to differentiate the executions of count() and count(1). That demonstration proved that there is no any difference between count() and count(1) executions. If you have

Difference between count(*) and count(1) – Part 1

Almost everyone have used both the functions count() and count(1). I heard different views about the difference between count() and count(1) functions. Some people says that count(1) only counts the number of rows of tables first column whereas count(*) counts

ORA-14758: Last partition in the range section cannot be dropped

An error “ORA-14758: Last partition in the range section cannot be dropped” is expected behavior while dropping the last partition in the range section. The high value of the last partition in the range section has an important role in the

Oracle Query Tuning – Example 3

In this query tuning example we will see how to index table columns null value to improve the performance of query. Many developers writes queries which has filter condition as NULL i.e. they are quering the tables with something IS

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

Page 1 of 512345