Home » RDBMS Server » Server Administration » System Tablespace usage (Oracle 10.2.0.4,Linux)
System Tablespace usage [message #481942] Mon, 08 November 2010 09:03 Go to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
The status of our System Tablespace is
Datafile : system.dbf
Size : 550MB
Used : 545MB

The tablespace status shows
Used : 99.8%
Extent Management : Local
Segment Space Management :Manual
Storage Allocation Type :Automatic

Should i add another datafile or does it does it extend to Maxsize 32GB ?

Report message to a moderator

Re: System Tablespace usage [message #481945 is a reply to message #481942] Mon, 08 November 2010 09:14 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Should i add another datafile or does it does it extend to Maxsize 32GB ?
yes

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Previous Topic: Oracle Database Best Practices
Next Topic: upgrade oracle db from 11.1.0.6 to 11.2.0.1
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 15:27:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.