System Data File
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: System Data File

Hybrid View

  1. 02-05-2002, 06:00 PM #1
    safkhan
    safkhan is offline Junior Member
    Join Date
    Nov 2001
    Location
    India
    Posts
    11

    Arrow

    How can I estmate the size of the system datafile? Help will be appreciated
    Reply With Quote Reply With Quote Share on Google+
  2. 02-05-2002, 06:05 PM #2
    jlakhani's Avatar
    jlakhani
    jlakhani is offline Learn by breaking rdbms
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Are you creating a new database? I just make it 200Megs. It depends on exactly you are trying to achieve.
    "High Salaries = Happiness = Project Success."
    Reply With Quote Reply With Quote Share on Google+
  3. 02-05-2002, 06:52 PM #3
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    It depends on the number of "things" (objects, segments, extents, tablespaces, etc.) Oracle has to keep track of. Start off at 256M and set autoextend on.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Reply With Quote Reply With Quote Share on Google+
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width