Database Auto extend question

This is an Interview Question By BMC Software.. " while installing the Oracle 9i ( 9.2) version, automatically system takes the space of approximately 4 GB.. thats fine.... Now, if my database is growing up and it is reaching the 4GB of my database space...Now, i would like to extend my Database space to 20 GB or 25 GB... what are the things i have to do " Pls give me the accurate Solutions or alternates for this Query....? Thanks in Advance

Interview Candidate
Sep 9th, 2007
3
3243

Database Administration

Answer

Showing Answers 1 - 3 of 3 Answers

Kinjal

Sep 24th, 2007

Following steps can be performed.

1. First check for available space on the server
2. you can increase the size of the datafiles if you have space available on the server and also you can make auto extend on. So that in future you don't need to manually increase the size.

Kinjal

alex.v
Profile Answers by alex.v Questions by alex.v

Jul 11th, 2008

better make the autoextend off and add more datafiles to the tablespace. Making a single datafile to a bigger size is risky...

By making autoextend off you can monitor the growth of the tablespace....schedule a growth monitoring script with a threshhold of 85 % full