After Oracle installation you need to configure listener.ora and tnsnames.ora network files. In Oracle three most important network files are…
Below are the list of packages you must install before Oracle 12c installation on RHEL/Linux. yum install binutils -y yum…
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.…
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…
The default DBA role is automatically created during Oracle Database installation. This role contains most database system privileges. Therefore, the…