Brian,
When I said "For, 200 to 300....." I mentioned about the limitation of
resources also in the context...
Now, please explain why it is "Simply not true"...?
Thanks & Regards,
Manash Partim Baruah
Collaboration Platform LCS-E-commerce| DBA Team| Tech Mahindra Ltd.|
Sharda Center, 6th Floor Annex Building, Pune-4, India
www.techmahindra.com
-----Original Message-----
From: Brian Winter
[mailto:oracledba-ezmlmshield-x35395478.[Email address protected]
Sent: Friday, December 28, 2007 4:58 AM
To: LazyDBA Discussion
Subject: RE: More than one database in oracle ??
>>For, 200 to 300 users, you must use Shared Server architecture.
This is just simply not true.
>>Creating a separate database for each user is definately not an
efficient solution.
Aside from managing them as you have suggested, imagine the horrors of
database upgrades, backups, defining separate sga/pga memory
allocations, cpu overheads for multiple (ie several hundred) databases
on the same server. Non-starter.
-----Original Message-----
From: Manash Baruah
[mailto:oracledba-ezmlmshield-x24281156.[Email address protected]
Sent: 27 December 2007 11:48
To: LazyDBA Discussion
Subject: RE: More than one database in oracle ??
Rajesh,
If you are not running out of resources (memory/cpu) then upto 25/30
users, you can opt for a Dedicated Server architecture. For, 200 to 300
users, you must use Shared Server architecture.
Creating a separate database for each user is definately not an
efficient solution. How come you will be able to keep them in sync, if
the developers are working on the same project? It's possible but there
will be overheads.
Thanks & Regards,
Manash Partim Baruah
Collaboration Platform LCS-E-commerce| DBA Team| Tech Mahindra Ltd.|
Sharda Center, 6th Floor Annex Building, Pune-4, India
www.techmahindra.com
-----Original Message-----
From: Rajesh kalaria [mailto:rajesh.[Email address protected]
Sent: Thursday, December 27, 2007 4:27 PM
To: Manash Baruah
Subject: Re: More than one database in oracle ??
Manash,
Thanks for the quick reply. Solution#1 is not applicable because
if we will be using only one database with multiple schemas, and if
there will be any issue at the database level, then all the developers
will suffer and could not continue the development work until the issue
is fixed.
So solution#2 is acceptable. But in that case, my concern was
that, if in future no. of developers increased say 200 to 300, then
creating a separate database for each developer will be an efficient
solution or not.
Regards,
Rajesh
Manash Baruah wrote:
> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email, **and removed
> any attachments, and kept your email address secret **from this
> person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address
> as normal **Anything below this line is the original email text
>
>
>
> Hi,
>
> There are multiple solutions:
>
> 1. You can create different schemas within the same database.
> Developers will connect to the same database and work with the schema
> of their interest.
>
> 2. If solution-1 is not applicable then you can create multiple
> databases in the same server. All of them will have their own instance
> and the developers may connect to the required instance.
>
> I did not understand your point of concerning about the huge increase
> of number of developers in the future, unless you are going to create
> new databases for the new users. Is this really a requirement like
that??
>
>
> Thanks & Regards,
>
> Manash Partim Baruah
>
> Collaboration Platform LCS-E-commerce| DBA Team| Tech Mahindra Ltd.|
> Sharda Center, 6th Floor Annex Building, Pune-4, India
> www.techmahindra.com
>
>
> -----Original Message-----
> From: Rajesh kalaria
> [Email address protected]
> Sent: Thursday, December 27, 2007 3:32 PM
> To: LazyDBA Discussion
> Subject: More than one database in oracle ??
>
> All,
>
> We want to use oracle as back end for development
environment.
>
> We want a centralized location, where all the developers can have
> their respective database. Now the problem is one oracle instance can
> connect with only one database. We wants instances should be
> automatically start when a developer wants to connect with one
database. In future the no.
> of developers could be increased by a huge no. also. So how and which
> type of configuration will be suitable for this types of requirements.
>
> Regards,
> Rajesh
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
> a dba job: http://jobs.lazydba.com To Subscribe :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
>
>
> ======================================================================
> ======================================================
>
>
> Disclaimer:
>
> This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review the policy at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.com/Disclaimer.html</a> internally within Tech Mahindra.
>
> ======================================================================
> ======================================================
>
>
>
========================================================================
====
================================================
Disclaimer:
This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review the policy at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
ra.c
om/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.c
om/Disclaimer.html</a> internally within Tech Mahindra.
========================================================================
====
================================================
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
============================================================================================================================
Disclaimer:
This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.
============================================================================================================================
Oracle LazyDBA home page