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…