Home » RDBMS Server » Server Administration » what should be the smallest possible size of the 9i database
what should be the smallest possible size of the 9i database [message #62078] Wed, 23 June 2004 20:49 Go to next message
anurag vidyarthi
Messages: 4
Registered: April 2004
Junior Member
OS Platform :solaris 8
DB version 9i 9.0.2

Hi,

Can anybody has the idea about the smallest possible size of a 9i database(that one can specify at the creation od database).

I know that that this is difficult question to answer, but can anybody suggest something on basis of experience.

MY Objective:
I am creating a unicode al32utf8 database for just to start of the testing of global language support in oracle 9i.

with reagrds
anurag

can also mail me : anurag.vidyarthi@conax.com

Report message to a moderator

Re: what should be the smallest possible size of the 9i database [message #62084 is a reply to message #62078] Thu, 24 June 2004 03:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
around 200 Megs for system tablespace (if you are not installing OTHER options withing the database like XMLDB,JAVA support , datamining or sample schemas).
rest tablespace sizes are upto u.
ORL size , undosegment size upto u.

Report message to a moderator

Re: what should be the smallest possible size of the 9i database [message #62300 is a reply to message #62078] Tue, 13 July 2004 09:03 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
My (smallest) SYSTEM tablesapce is 119 MB out of 150 MB and TOOLS is 27 MB out of 50 MB. So a total of 119 + 27 = 146 MB.

Rest of tablespace depends on what you want as Mahesh pointed out.
--
Sanjay

Report message to a moderator

Previous Topic: How to question.
Next Topic: partitioning a big table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 01:54:19 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.