DBA Catalog

When there is some simple query which is using just is null criteria on big table, oracle cost based optimizer making table access full, so ...

Sometimes there is situation when you need to modify default attributes for tables, tables partitions, index or index partitions in Oracle d...

Oracle Text index is a very powerful feature for searching user specified text in big text columns for example in clob type columns. As a Da...

Hello, If you have very busy database and you decide to run an online index rebuild, but unfortunately your session terminated abnormally o...

Hello, here I'll show you how to find and rebuild unusable indexes partition in oracle: SQL> select distinct status from dba_ind_pa...

While dropping a tablespace it fails with error ORA-29857 like below. SQL> drop tablespace example including contents and datafiles casc...