SURESHKUMAR.NET FORUMS - View Single Post - What is the functionality of SYSTEM table space

sriodba · 09-02-08, 03:08 AM

hi system tablespace is where all the data dictionary tables, views reside and system tablespace cannot be taken offline and if any user is not assigned any default tablespace then the default location to store data is system tablespace as the system tablespace keeps growing the performance of the DB degrads. so no users are assigned system tablespace.

09-02-08, 03:08 AM	#3 (permalink)
sriodba Junior Member Join Date: Feb 2008 Age: 29 Posts: 8 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: What is the functionality of SYSTEM table space hi system tablespace is where all the data dictionary tables, views reside and system tablespace cannot be taken offline and if any user is not assigned any default tablespace then the default location to store data is system tablespace as the system tablespace keeps growing the performance of the DB degrads. so no users are assigned system tablespace.