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…
MYSQL database is used by many applications and in most of the cases users struggle to get the list of…
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],[210], [39496], [39684], [], [], [], [], [], [], [] error in oracle? You…
You see ORA-04030 errors being reported in the alert log: ORA-04030: out of process memory when trying to allocate 16328…
I was facing below error while starting oracle database and because of that database was unable to start. SQL> startupORA-04031:…