TEMP

How to Resolve ORA-25153: Temporary Tablespace is Empty

Posted on
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 to use space in a temporary tablespace with no files. Action Add files to the tablespace using ADD TEMPFILE command. This is because the temporary tablespaces contain no any temp […]
UNDO

How to Check UNDO Tablespace Usage

Posted on
The first purpose of using UNDO is for storing all uncommitted data in case we need to undo uncommitted data in rollback or after system failures. As you know, UNDO could be growing very fast during system busy hours. If you ignore undo tablespace usage, some transactions may fail. In this post, we will discuss […]
Space

What is Difference Between PCT_FREE and PCT_USED

Posted on
For manual segment space management (MSSM), we have to define the two parameters in a table in order to meet our target space plan. Let see their definitions by Oracle:PCTFREE specifies the percentage of space to be reserved in a block for future updates.PCTUSED sets the percentage of free space that must exist in a […]
Space

How to Check Database Overall Space Usage

Posted on
Do you know how large is your database? And how much space has been used? Here is an example to check it out.column “DB Name” format a8;column “DB Space GB” format 999.99;column “DB Free GB” format 999.99;column “DB Used GB” format 999.99;column “DB Used %” format 99.99;SELECT c.NAME “DB Name”,  a.totalspace “DB Space GB”,  b.totalfree […]
Tablespace

How to Check Oracle Tablespace Usage

Posted on
After having the whole picture about the size of the database, we can further check Oracle tablespace usage solely by SQL. Oracle Tablespace Usage Of course, you can use GUI tools to check the space usage of tablespace in Oracle, but if someday, the only tool you got is sqlplus, a text-based tool, everything must […]