Oracle Datafile Size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle Datafile Size

  1. #1
    Join Date
    Nov 2000
    Posts
    34

    Arrow

    Hi Friends,

    Software :

    Oracle8i release 2(8.1.6)
    Sun Solaries 2.8

    I am designing a huge databse.

    The database size will grow upto be 4 terabytes,
    we r having EMC disk storage and sun E6500 machine.

    So what is recommended oracle datafile size for such a
    huge database for better performance ?

    Thanks

    Jayesh

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I don't know about limitations on the latest version of Solaris thast 2.8, but 2GB is limit on Solaris 2.6. You might need to check with vendor or server administator.

  3. #3
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Solaris 8 has a 64 bit API which allows large file sizes. Set the large file option on the OS. You will now able able to have files of upto 1 Terabyte. Refer to note #62409.1 on Metalink for details.

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I found this document on Metalink which gives enough information that you need. If OS supports thats not enough and You have other limitations to consider from Oracle and backups perspective. Here you go:

    [url]http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=62427.1[/url][/url]



    [Edited by sreddy on 12-21-2000 at 05:50 PM]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width