Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Maintaining one big datafile(1TB)

user1093072Apr 9 2013 — edited Apr 13 2013

Hi All,

My production database have one 1152GB data file and it’s auto extending by 1 MB. As per my understanding we need to maintaining small data files(such as 32 GB ). Therefor please tell me the best way to maintain this (stop this point and create separate datafiles or just using one file) also what kind of benefits we can get segregating to different datafiles.

FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUTOEXTENSIBLE MAXBYTES MAXBLOCKS INCREMENT_BY ONLINE_STATUS
/PROD_DATA_02.dbf 7 PROD_DATA 1,237,701,623,808 151086624 AVAILABLE 1024 YES 35184372064256 4294967293 1 ONLINE

Thanks,
krish

This post has been answered by Dave Rabone on Apr 9 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 11 2013

Added on Apr 9 2013

#general-database-discussions

5 comments

758 views