Home / Oracle DBA / Temporary Tablespaces

Temporary Tablespaces

Temporary Table spaces

A temporary table space contains transient data that persists only for the duration of a session. No permanent schema objects can reside in a temporary table space. The database stores temporary table space data in temp files. Temporary table spaces can improve the concurrency of multiple sort operations that do not fit in memory. These table spaces also improve the efficiency of space management operations during sorts.
When the SYSTEM table space is locally managed, a default temporary table space is included in the database by default during database creation. A locally managed SYSTEM table space cannot serve as default temporary storage. You can specify a user-named default temporary table space when you create a database by using the DEFAULT TEMPORARY TABLE SPACE extension to the CREATE DATABASE statement. If SYSTEM is dictionary managed, and if a default temporary table space is not defined at database creation, then SYSTEM is the default temporary storage. However, the database writes a warning in the alert log saying that a default temporary table space is recommended.
Duration of an Instance
An instance begins when it is created with the STARTUP command and ends when it is terminated. During this period, an instance can associate itself with one and only one database. Furthermore, the instance can mount a database only once, close it only once, and open it only once. After a database has been closed or shut down, you must start a different instance to mount and open this database.
View More:
Overview of Segments
Overview of Data Blocks
Introduction to Logical Storage Structures
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

Your email address will not be published. Required fields are marked *

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe