RE: Reducing the number of databases

[Guang Mei]

Title: Message

Thanks for the suggestions. I already have planned to move all our instances to one server and move all schemas (in all instances) to sys schema. This way I can have better use of system tablespace and drop all other tablespaces. Also I will put in a cron job to "rm" all database files every morning to save some disk spaces.   Guang -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Mladen Gogala Sent: Friday, September 19, 2003 2:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Reducing the number of databases Additional money might be saved by having only one database which would assume the role of QA, development and production. That would mean that developers test in production and their own QA. You can save a bundle on oracle licenses that way. In addition to that, if you switch to noarchivelog mode, you can save a small fortune on the backup tapes. Smart thing to do in that situation would be to put your resume online before stuff hits the fan.     -- Mladen Gogala Oracle DBA -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Guang Mei Sent: Friday, September 19, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: Reducing the number of databases Here we have 3 environments for most applications (dev, QA and prod) and all Oracle version are the same (8173 now). It works fine. And to save Oracle license costs, we also consolidated some db servers by putting multiple instances on one server machine. No problem so far.   Guang -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of AK Sent: Friday, September 19, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Subject: Re: Reducing the number of databases I have seen more requirement for individual development databases ( where ind schema is not possible ) due to complexity of application . Developers step on each other if they work of same database . A pl/sql developer is invalidating procedure while a java developer is trying to make his program work.   -ak     ----- Original Message ----- From: Stephane Paquette To: Multiple recipients of list ORACLE-L Sent: Friday, September 19, 2003 8:59 AM Subject: Reducing the number of databases Hi,   We have around 120 databases. Most applications have 5 environments (dev, test, integrated test, acceptance, prod) some applications have more. The applications are a mix of home developped and bought application (peoplesoft, harvest, compass,...) New applications are coming in. New databases will appear soon with DB2UDB.   All servers are unix/aix, there are 15 production server and around 10 servers for the dev, test, integrated test and  acceptance databases. All databases are at 8172 except 6-7 databases and planning to go to 9i in 2004. Off course we see the migration like a pain.   We want to reduce the number of databases and instances. To obtain a significative gain I think we must reduced to around 60 databases.   Anybody has done the task to consolidate on less servers and les databases ?   One way to do it would be to go with     2 instances of dev     2 instances of test     2 instances of integrated test     2 instances of acceptance     all prod instances are standalone.   Food for thought     backup     Oracle version     availability     naming convention of objects     security     ...   All feedback is welcome.   Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 et (514) 925-7187 [EMAIL PROTECTED]     Note: This message is for the named person's use only.  It may contain confidential, proprietary or legally privileged information.  No confidentiality or privilege is waived or lost by any mistransmission.  If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender.  You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.  Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.