You can use the ALTER SESSION statement to display the physical contents of the control file; for example, The prior line of code displays the following name of the trace file: The trace file is written to the $ADR_HOME/trace directory. You can also view the trace directory name via this query: The command works in […]
A control file is a small binary file that stores the following types of information: • Database name • Names and locations of data files • Names and locations of online redo log files • Current online redo log sequence number • Checkpoint information • Names and locations of RMAN backup files You can query […]
DBAs often use monitoring scripts to alert them when they need to increase the space allocated to a tablespace. Remember you have to check tablespace in both the CDB and all of the PDBs, keeping in mind that the PDBs each need to be monitored as they will be more dynamic and growing. The following […]
In environments such as data warehouses, you may need to load data into tables and then never modify the data again. To enforce that no objects in a tablespace can be modified, you can alter the tablespace to be read-only. To do this, use the ALTER TABLESPACE statement: One advantage of a read-only tablespace is […]
The bigfile feature allows you to create a tablespace with a very large data file assigned to it. The advantage of using the bigfile feature is this potential to create very large files. With an 8KB block size, you can create a data file as large as 32TB. With a 32KB block size, you can […]
You use the CREATE TABLESPACE statement to create tablespaces. In most scenarios you need to use only a few of the features available, namely, locally managed extent allocation and automatic segment space management. The following code snippet demonstrates how to create a tablespace that employs the most common features: You need to modify this script […]
Although you could put every database user’s data in the USERS tablespace, for logical separation, backup and recovery additional tablespaces should be created for the applications and ad hoc users or developers. DBAs used to separate table and index data for performance reasons and management of the data files. The thinking was that separating table […]