Over a period of time temporary tablespace grow in size and we must resize tempfile to overcome space issue. In…
In this article we will discuss about shrinking datafiles to reclaim unused space in an Oracle database. Below are the…
As an application user you might have been asked to write a cleanup script to delete old data from a…
If your AUD$ table is in SYSTEM tablespace, then it is advised to move the AUD$ table to a dedicated…
Datafiles can be located on ASM or file system on disk. So either you can add datafile in ASM or…
Oracle MMON background process collect the AWR statistics and generate the snapshot based on retention which violates the threshold metric.…
If you want to perform hot backup then your database must be in archivelog mode. Using below shell script you…
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…
Below are the list of Solaris kernel parameters which you must set before oracle installation on Solaris. In the previous…