| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Instance
Think of Object Oriented, then 1 db can be an Object, better security, easy to upgrade or downgrade, easy to change any setting as you like.
Think of memory, overhead, administration, 1 instance will be better (I think, specially backup and recovery)
Think of performance, you can tune each db individually and contention will quite easy to maintain.
Think of risk and potential application bug, why your management want to overhaul the system?
About the schema that transparent or invisible, you can search Oracle Doc (SQL Plus) with key word "GRANT" or "REVOKE" (If you decide to merge your databases)
Merry X'mas
Sinardy
-----Original Message-----
Sent: 24 December 2003 09:49
To: Multiple recipients of list ORACLE-L
Dear : All
First and foremost , if i ask stupid question pls forgive me coz i new to oralce. I have a question here.
I have a server, and this server contains 5 oracle database. Each database contains 5 web application that are running on live ( production server ). As i understand abt oracle , every database that i created will have 1 instance. So since this server hold 5 database then i will have 5 instances running.
Lately, my manager want me to remove all the databases and remain a single instance. I was wondering if i move everything into single database then if one of the application fail due to oracle error , then all other four application will fail also rite ?
Each of our web application needs to have 2 schema and both schema have to be transparent to each other. While other application schema will be invisible to each other. Since i have 5 web app then i will need 10 schema.One major problem is all the 10 schema will contain same table name. It will be a mess putting so much app in a single db .
Pls correct me if i am wrong and do let me know what are the pro and cons or maybe you can educate me with some of the best practice to setup a proper production server environment.
Thank You
Regards,
Jkean
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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.net
--
Author: Sinardy Xing
INET: SinardyXing_at_bkgcomsvc.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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). Received on Tue Dec 23 2003 - 23:04:24 CST
 |
 |