Temporary tablespaces often referred as Temp tablespace in Oracle are used for sorting operations and can grow huge in size.…
In this article you will learn how to set, change , recover and reset forgotten MySQL root passwords. Many times…
In order to drill down database performance issue like top memory, I/O and CPU consumers, you need to check SID…
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…