DBTIMEZONE There're 2 ways to check the time zone of a database. Database Property Since DBTIMEZONE is actually a property of database, we may query… Read More »How to Check Database Time Zone
DATABASE_PROPERTIES DATABASE_PROPERTIES is a data dictionary view which is able to describe the nature of a database by collecting its permanent properties Let's see standard… Read More »DATABASE_PROPERTIES, How and Why
We take the following steps to drop a tablespace. Make Sure Tablespace is Non-Default Take Tablespace Offline Make Sure Tablespace is Empty Drop a Tablespace… Read More »Drop Tablespace Examples
To globally change the default permanent tablespace of a database, we take the following steps: Check Current Default Permanent Tablespace Make Sure the Target Tablespace… Read More »Alter Database Default Tablespace Examples
There're 2 cases that makes problems about local UNDO tablespace in a RAC database. Newly Created PDB Open Activated PDB Newly Created PDB Usually, we… Read More »PDB Local Undo for Each RAC Instance
DataFile MaxSize According to Oracle Database Physical Database Limits, we can have approximate 222 database blocks for a data file in a smallfile tablespace (default)… Read More »How Max a Data File Can Be