Managing Tablespace in Multi-Tenant Environment Part – II

In the previous article, we have seen System tablespace and Users tablespace.

In this article we will see Temporary tablespace and Undo tablespace :

Temporary Tablespace :

Every CDB$ROOT can have one default temporary tablespace or tablespace group. Pluggable databases must have their own temporary tablespace to use for local users.

SQL> select con_id,name from v$tablespace where name like '%TEMP%';

    CON_ID NAME
---------- ----------------------------------------------------------------------------------------------------
	 1 TEMP
	 2 TEMP
	 3 TEMP
	 4 TEMP
	 5 TEMP
	 7 TEMP
	 8 TEMP

7 rows selected.

We can see in the above output every container database have its own temporary tablespace.

When the pluggable database is unplugged temporary tablespace is transported with PDB.

We can change default temporary tablespace by connecting to pluggable or root database and then applying to alter database default temporary tablespace.

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT

SQL> alter database default temporary tablespace temp1;

Database altered.

We can set a shared temp size for particular pdb using the following statement.

ALTER PLUGGABLE DATABASE STORAGE (MAX_SHARED_TEMP_SIZE 300M);

Undo Tablespace : 

We can set Undo modes two way :

1.Shared Undo tablespace

2. Local undo tablespace

To know more about undo tablespace :

Configure and use the local UNDO mode

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us an Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp