How to Check Database Time Zone
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, How and Why
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
Drop Tablespace Examples
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
Alter Database Default Temporary Tablespace Examples
To globally change the default temporary tablespace of a database, we take the following steps: Check Current Default Temporary Tablespace Make Sure the Target Tablespace… Read More »Alter Database Default Temporary Tablespace Examples
Alter Database Default 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
PDB Local Undo for Each RAC Instance
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
How Max a Data File Can Be
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
How to Resolve ORA-25153: Temporary Tablespace is Empty
ORA-25153 After activating a physical standby database, I found some SQL statements returned ORA-25153: Description ORA-25153: Temporary Tablespace is Empty Cause An attempt was made… Read More »How to Resolve ORA-25153: Temporary Tablespace is Empty