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...

sonaligujral1

 Profile Answers by sonaligujral1 Questions by sonaligujral1

• Aug 9th, 2010

Here comes the concept of database capacity planning

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

Answer Question  Select Best Answer

srinivasanram2004

 Profile Answers by srinivasanram2004 Questions by srinivasanram2004

• Jul 29th, 2008

Characteristics of a Data File : - A Data file can be associated with only one tablespace. - Once created, a datafile can be increased or decreased in size with RESIZE command. Example: ALTER da...

alex.v

 Profile Answers by alex.v Questions by alex.v

• Jul 11th, 2008

datafiles can be resized to a lower size also, but till the used space....

Answer Question  Select Best Answer