I personally use bigfiles in ASM. I dont even consider the time to restore a hugefile, because I do not forsee the need to restore only a chunk of a tablespace. If I am restoring the entire tablespace, it doesn't matter how many files I have. If I have corrupted blocks, I would use RMAN's blockrecover command. -- Christo Kutrovsky Senior Database/System Administrator The Pythian Group - www.pythian.com I blog at http://www.pythian.com/blogs/ On 5/2/07, Robert Freeman <robertgfreeman@xxxxxxxxx> wrote:
Wow... that makes for a long dba_data_files query!! My personal thought on this is for BIG databases, I like to time how long it takes to restore a given datafile size. If I need to recover a given datafile, how long do I want that to take? My general rule is no more than 10-15 minutes (depending on any SLA's of course!). So if it takes 15 minutes to restore 20GB, that would be my datafile size (assuming the OS can handle a datafile of that size and so on). I much prefer fewer, larger datafiles to more, smaller ones. Much easier to manage among other things. RF Robert G. Freeman Oracle Consultant/DBA/Author Principle Engineer/Team Manager The Church of Jesus Christ of Latter-Day Saints Father of Five, Husband of One, Author of various geeky computer titles from Osborne/McGraw Hill (Oracle Press) -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of daniel.hubler@xxxxxxxxxx Sent: Wednesday, May 02, 2007 9:50 AM To: oracle-l@xxxxxxxxxxxxx Subject: Datafile sizes Looking for comments & experiences regarding sizes of datafiles. We have a large (6+ TB) OLTP database, which currently has 2300+ datafiles. A while ago, we stopped adding datafiles and were exclusively extending them. But we are wondering how far we can/should go, with the size of individual data files. Currently about 30% of the datafiles are at 8 gig. BTW - this particular application resides on VMS. Any ideas/thoughts/comments would be appreciated. Thanks. Dan Hubler Database Administrator Aurora Healthcare daniel.hubler@xxxxxxxxxx
-- Christo Kutrovsky Senior Database/System Administrator The Pythian Group - www.pythian.com I blog at http://www.pythian.com/blogs/ -- //www.freelists.org/webpage/oracle-l