The SQL SELECT statement is used to fetch data from a database. How SELECT command in Oracle works or executes…
When you run the database in NOARCHIVELOG mode, you disable the archiving of the redo log. If you want to…
In this post, we will discuss about the wait event “Streams AQ: enqueue blocked on low memory” which was captured…
It is not easy task to manually deal with too many jobs. So to overcome with this scenario oracle database…
There are a number of cases were you want to lock table statistics and schema statistics for example, if you…
From Oracle 10gR2 onward RAC clusterware automatically start and stop the ASM and Oracle database instances and listeners, so the…
It is difficult to gather stats on large partition tables which is huge in size, specially in core domain like…
Q1. How to export only ddl/metadata of a table?Ans: you can use CONTENT=METADATA_ONLY parameter during export. Q2: Which memory area…
Introduction In this article I will discuss about table fragmentation, which cause slowness and a wastage of space. Fragmentation is…
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],[210], [39496], [39684], [], [], [], [], [], [], [] error in oracle? You…