There are some Data Pump Parameters that Significantly affect the export and import Performance. To make expdp and impdp backup…
Depending on the requirement, you must set the Linux kernel parameters before Oracle database installation. Configuring Linux Kernel Parameters for…
SYS.AUD$ table which is also referred as audit trial is a table inside the sys schema which is used to…
You must select proper Oracle Database Characterset while installing the database because it is very difficult to modify after installation.…
As a DBA, you must schedule the crontab script to take the backup of MySQL databases. It is important to…
The tar is most common compression format used in GNU/Linux to extract and create compressed archive files and that can…
This is the common error in DB2 and it occurs when a database doesn’t able to find the system temporary…
dba_segments is used to get schema size in Oracle. Schema is simply a user inside the database. To find growth…
ORA-1652: unable to extend temp segment by %s in tablespace TEMP This error occur when user running the queries doesn’t…
This post is all about monitoring Data Pump jobs, checking expdp or impdp status, to kill running jobs, troubleshoot hung…