formatting for Oracle

[nontrad]

I'm a "newbie" and I don't do hardware stuff at all.

We are getting a new Sun server. One is going to be devoted to Oracle as the new Web server. There will be two databases, at least, on the server but they are either in development or will be imported from somewhere elase and the exact size/accesses, etc is not known at this time.

I have been tasked with suggesting how to partition the space. I have absolutly NO idea what should be required, etc.

Any suggestions???

 

[MikeLacey]

That's a *very* wide question nontrad. See if you can get some more details on:

How large the databases will be.

How many.

What disks you will have available on the new server. Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.

 

[THoey]

Mike, a concern I had when I read this post yesterday is that (s)he says (s)he is getting one server, going to put multiple databases on it and use it as a web server. I don't have enough experience to make an official answer, but I think (s)he is looking at overloading the server.

Based on that, other considerations should be:

How many hits do you plan on having on this web server?
Based on hits, how many tables will be accessed?
etc...

Like I said, not enough experience to really help, but maybe I will bring up something that will make someone else think... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[DBAwhosaysNIE]

depends on the hardware.

I wouldn't try it on a U2 but we have a 450 for development which runs 8.1.6, Apache & WebSphere together just fine. as with any unix box you'd want to monitor CPU utilization (particularly user to kernel ratio), I/O wait, etc. but as long as those numbers stay reasonable I don't see any inherent problem with this. back in my Oracle Applications (yuck! pa-toohey! days this was a common practice with 11.0.3 (db, http & even forms/report servers on same box).

 

[nontrad]

This is actually going to be the second server devoted to Oracle (8.1.7 btw).

The one we have right now it has 3 Dbs - one which is ADORA purely a test Db for trying out stuff that comes w/ Oracle - not big, one which is in development now and just starting to be loaded with data and will be accessed via web, and one with the "skeleton " set up but tables/data to be imported later this summer. There is also one more Db coming w`that will also be accessed via web. The only thing I know is that is will be a survey that MANY people will be filling out - I guesstimate lots of initial hits and then sporatic.

Their plan is to add the 2nd server and then use replication between the two.

Yes, I think trouble is just around the corner. The people here seem to be treating this as if it is as complicated as MS Excel. My boss actually is a self-taught hardware geek and there are big gaps in his comprehension of software. There is no Oracle experienced person here - just a few people trying to teach themselves (YIKES!).

Here are the questions that I have fired back to my boss.

****************
In order to know how to partition the server, I need to have the following info:

1) Size of the HD

2) Size of each database when operational
This would include the zzz Db when loaded, the expected size of all the databases (charity, etc) from the XXX department, any space
needed for the YYY Dept. Db that we just won the contract for.

3) What is the min, max and average # of hits expected on each Db and the number of tables that will be accessed on each hit. Not the max number
per day but the max at any one time that the system should be able to handle.

4) How many log/archive files do you want to maintain to be able to recover the database plus how many database saves do you want on the HD?
NOTE: The more active the database plus possibilities for recovery due to viruses, etc, the more space you would need to reserve for this.



**************
Can you think of anything else and where could I go to get the formulas, etc that I would need to determine the partition size when I get the answers? BTW, this will have a Unix or Redhat Linux OS.