In this article we will discuss about avoiding index maintenance and insert data faster into the table. Index maintenance is…
SQL*Loader-700: Out of memory while performing essential allocations [7] and unable To Load Using Direct Sqlldr Path Option SQL*Loader-700 are…
Temporary tablespaces often referred as Temp tablespace in Oracle are used for sorting operations and can grow huge in size.…
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…
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…