SDBT Blog

Home/Blog/
27 08, 2022

Temporary Tablespace, Archive log, Control file multiplexing method

By |2022-08-27T21:23:38+05:30August 27, 2022|Oracle Database|0 Comments

Control File Every oracle database has a control file.A control file is a small binary file that records the physical structure of the database .control file read only in mount stage. Min 1 or Max 8 control for single database.control file we use for recovery [...]

Read More
1 02, 2017

Oracle Database Monitoring scripts

By |2022-08-08T10:51:22+05:30February 1, 2017|Articles|Comments Off on Oracle Database Monitoring scripts

As an oracle dba, we need to automate things to make our life easy. So we need to monitor the below activities. 1. Alert log, place where database errors are logged. 2. File system, to check the threshold of the space where the datafiles/logfiles/control files/archive [...]

Read More
Go to Top