FAQ
What is an ideal datafile size for a large database 10G or greater

Oracle 8.1.6

We have been using slightly under 2G and looking for an ideal size and
possible reasons to use such a size

Thanks
bob

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Metelsky
INET: bmetelsky_at_cps92.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

  • Tony Johnson at Sep 5, 2002 at 11:10 pm
    There used to be a bug that caused problems with files on NT 4g or more in size.
    I've standardsized on 3999 meg as a result of this.

    Tony Johnson Email : tony_johnson_at_trimble.com
    Manager Database Administration Voice : ( 480 ) 682 - 0849
    Trimble Navigation Cell : ( 602 ) 363 - 7328
    7408 W. Detroit Street #100 Fax : ( 480 ) 961 - 8801

    Chandler, AZ 85226

    Murphy's Data Constant:Data will be damaged in direct proportion to its value

    -----Original Message-----
    Sent: Thursday, September 05, 2002 2:29 PM
    To: Multiple recipients of list ORACLE-L

    What is an ideal datafile size for a large database 10G or greater

    Oracle 8.1.6

    We have been using slightly under 2G and looking for an ideal size and
    possible reasons to use such a size

    Thanks
    bob

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Bob Metelsky
    INET: bmetelsky_at_cps92.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Tony Johnson
    INET: Tony_Johnson_at_Trimble.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Bishop Lewis at Sep 6, 2002 at 9:38 am
    The 4GB problem on NT was ONLY where it would autoextend over a 4gb boundary
    (eg 4,8,12,16...). You can manually size the datafile whatever size you wish
    - ie you can cross the boundary manually.

    However, one place I recently contracted at were determined to cold backup
    their 120GB data warehouse system and it was decided to zip the datafiles as
    part of the backup process. Zip only handles files up to 4GB in size so they
    standardised on 4000MB datafiles (zipped down they reduced to 80mb - yep
    huge allocation, little data - it takes all sorts!) - guess who had to
    rebuild the data warehouse to these specs!;-(

    So, on deciding your datafile size, be aware of various issues - mostly
    regarding the management of these files. I would agree with my previous
    client that 4gb (or near) is probably the biggest I'd go on windows systems
    unless there's a *specific* and good reason to go higher.

    Lewis Bishop

    ---
    Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
    Phone - 020 8298 3418
    Mobile - 07950 380857
    Email - lewis.bishop_at_woolwich.co.uk

    -----Original Message-----
    Sent: 06 September 2002 00:10
    To: Multiple recipients of list ORACLE-L

    This header confirms that this email message has been swept for the
    presence of computer viruses.

    Corporate IT
    THE WOOLWICH
    ----------------------------------------------------------------------

    There used to be a bug that caused problems with files on NT 4g or more in
    size.
    I've standardsized on 3999 meg as a result of this.

    ----------------------------------------------------------------------------
    ------
    Tony Johnson Email :
    tony_johnson_at_trimble.com
    Manager Database Administration Voice : ( 480 ) 682 - 0849
    Trimble Navigation Cell : ( 602 ) 363 -
    7328
    7408 W. Detroit Street #100 Fax : ( 480 ) 961 - 8801
    Chandler, AZ 85226
    ----------------------------------------------------------------------------
    ------
    Murphy's Data Constant:Data will be damaged in direct proportion to its
    value

    -----Original Message-----
    Sent: Thursday, September 05, 2002 2:29 PM
    To: Multiple recipients of list ORACLE-L

    What is an ideal datafile size for a large database 10G or greater

    Oracle 8.1.6

    We have been using slightly under 2G and looking for an ideal size and
    possible reasons to use such a size

    Thanks
    bob

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Bob Metelsky
    INET: bmetelsky_at_cps92.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Tony Johnson
    INET: Tony_Johnson_at_Trimble.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

    The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice.

    The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at ADMINISTRATOR_at_WOOLWICH.CO.UK

    Replies to this email may be monitored for operational or business reasons.

    Woolwich plc. Registered in England Number : 3295699.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Bishop Lewis
    INET: Lewis.Bishop_at_woolwich.co.uk

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 5, '02 at 9:28p
activeSep 6, '02 at 9:38a
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase