Interested to Buy Any Domain ? << Click Here >> for more details...
What is a system tablespace and why do we need it?
- 1 Answers
- 8 Views
- I also Faced
- E-Mail Answers
Answer / Ramesh Babu
A System Tablespace is an Oracle Database container that stores system catalogs, rollback segments, and temporary segments. It's essential because the system catalog contains all the metadata about the database objects like tables, indexes, views, etc. Rollback segments are used for undo data, and temporary segments hold sort areas and work tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between restoring a database and recovering a database?
What are the different types of backups that are available in oracle?
Mention what are the key characteristics of rac or why to use rac?
What are the file systems and volume management techniques used in oracle rac?
What are the key components of oracle’s maximum availability architecture?
What is an explain plan and how does it help in optimizing the sql query?
What is a recovery catalog?
What are the benefits of oracle rac?
What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?
What are the various benefits of using rac architecture?
What is the load balancing advisory?
What is the difference between instance recovery and crash recovery?
Oracle General 
