A single general-purpose empty database takes gigabytes?
I have a 80-gigbyte harddisk and 512 mb memory in HP Pavilion 762n running Windows XP Pro. There is 55 gigbyte available for Oracle 92010NT for Windows XP. So I installed a downloaded 9i Personal Edition on my stand-alone PC last week. It took about 3 gigbytes for the uninitialized SW package. From the Installer 2.2, my installation and setup profile include the following:
1. Select Personal Edition.
2. Tried two different installations with either 'Preconfigured environment' or 'software only' (that requires creating database manually in the post setup step).
3. Created a single empty database for general purpose.
The behavior I noticed so far is: After creating such database the 9i software takes as much disk space as 50 gigbytes and continues to do so. For how much more? I don't know because eventually my hard disk runs out of space. But it happened even before I connected to the database I created.
Three more comments:
1. I was able to login as scott/tiger in Sql*Plus and connected to the database.
2. I was able to use the database with ODBC supported simple application (of course that was before my hard disk ran out of space).
3. I noticed that the entire system response so, so, so slowly. I thought that was caused by the continuous action of the database management process running in background. That's because I periodically monitor the decreasing hard disk space about every 15 seconds.
I don't mind to see my database engine/client environment takes less than 100 gigbytes hard disk space as long as it is predictable. In fact my purpose of using the Oracle 9i is as very simple as to practice ODBC/JDBC programming and gain experience of using SQL statement.
I don't need to do any administration, migration, and other server side stuff yet. I more likely have just simple and short database to start with.
I tried to get enough information from the book "Oracle 9i for Windows (XP) Handbook" published by Oracle Press, 2002. But to no avail. Any one has any idea what's going on?
Tom +
t2513earth@earthlink.net