| SYSTEM tablespace [message #172755] |
Wed, 17 May 2006 21:18  |
kasakarito
Messages: 2
Registered: May 2006
Location: Malaysia
|
Junior Member |
|
|
Hi, i'm not an Oracle expert but my application is running on Oracle 9i.
Can anyone tell me what is SYSTEM tablespace and is this will cause my application slow if this tablespace almost full?
Thanks
|
|
|
|
| Re: SYSTEM tablespace [message #172778 is a reply to message #172755] |
Thu, 18 May 2006 01:19  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
The SYSTEM tablespace is intended for the data dictionary - not for users to put their stuff in.
If SYSTEM gets fragmented, the entire database will be slow. In such cases you need to recreate the entire database as you cannot reorg SYSTEM.
Even worst, if Oracle tries to write to the dictionary and SYSTEM is full, you can expect to see some ORA-600 errors and maybe even database crashes.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
