Too many datafiles?

[MCubitt]

Again, the Toad application reports "The database may have too many data files. A typical Oracle database should have just a few data files per tablespace. When a tablespace has lots of data files, it's often the case that the data file is being used as a generic container for too many unrelated objects."

I have 13 tablespaces, 34 datafiles. 31Gb.

With a UNIX platform and the 2Gb filesize limit, is Toad being unfair? Would the solution be to create further tablespaces? I am not even sure if this is reasonable with our ERP.





Applications Support
UK

 

[SantaMufasa]

Martin,

I believe Toad is making you feel uncomfortable about unimportant minutia. I have no problem (or worry) with one of my systems in San Francisco that has 26 tablespaces, 121 datafiles, 65GB. Each of my datafiles has a 2GB size limit.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[MCubitt]

Dave,

I suspected this was the case and will remove that particular alert.

thanks again!


Applications Support
UK