Posted by Mir Sayeed Hassan on 12th February 2018
Managing Multiplexing of Control Files in Oracle database 11gR2 As per the Oracle DB, every db has its own controlfile; the control file is a binary file that records the physical structure of the db The control file contains: The database name Name & location of datafiles… Read more..
Posted in DBA Administration | Comments Off on Managing Multiplexing of Control Files in Oracle database 11gR2
Posted by Mir Sayeed Hassan on 10th February 2018
Managing Temporary Tablespaces in Oracle database 11gR2 The temporary tablespace is basically used for sorting the large tables in database & database should contain 1 temp tbs in it, this temp tbs are created while creation of the database itself, Therefore if it requires you can create multiple temp tbs in the database. sys@TESTDB>… Read Read More
Posted in DBA Administration | Comments Off on Managing Temporary Tablespaces in Oracle database 11gR2
Posted by Mir Sayeed Hassan on 10th February 2018
Increase or decrease the size of Tablespace and Datafiles in Oracle database 11gR2 To Increase/extend the Size of a tablespace Method 1 – Increase/Extend the size of the tbs using the resize keyword as shown below: sys@TESTDB> select INSTANCE_NAME, VERSION from v$instance; INSTANCE_NAME … Read more..
Posted in DBA Administration | Comments Off on Increase or decrease the size of Tablespace and Datafiles in Oracle database 11gR2
Posted by Mir Sayeed Hassan on 7th February 2018
Managing Redo Logfiles in Oracle database 11gR2 Brief about the Redo logfiles in an Oracle databases it should contain atleast 2 redo logfile group as mandatory & Oracle writes every statement expect the select statement, Example – update etc, The Oracle writes to the datafile in case if there is power failure or any system Read More
Posted in DBA Administration | Comments Off on Managing Redo Logfiles in Oracle database 11gR2
