| New instance or new user ... [message #119133] |
Tue, 10 May 2005 14:53  |
BenL2
Messages: 3
Registered: May 2005
|
Junior Member |
|
|
I have to install two environments on a linux server and I need two oracle user (name : user1 and user2).
Those 2 users have nothing in share, all object, tables from user1 belong to user1 and to nobody else. Idem for user2.
My question is :
In a normal way, it would be better to create two oracle instance but in case of performance, isn't it better to create a new user ? I suppose that creating a new user in the same scheme will be better but how can I appreciate this difference ?
Thanks
|
|
|
|
|
|
| Re: New instance or new user ... [message #119178 is a reply to message #119141] |
Wed, 11 May 2005 01:01  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI
Also, u can allocate separate tablespaces for both these users. If possible do place the datafiles for these respective users on separate disks in order to minimize disk I/O contention for these users.
Regds
Girish
|
|
|
|
| Re: New instance or new user ... [message #119258 is a reply to message #119133] |
Wed, 11 May 2005 08:53 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
I agree that in a general since you should create two users in one database.
But, can you elaborate more on why you were thinking two databases to begin with? You must have had some thought/reason particular to your situation?
And what do you mean by "create a new user in the same scheme"? Are the tables etc going to be identical for each? If so, you may well want only one "owner user" and then have various "end users".
|
|
|
|
| Re: New instance or new user ... [message #119262 is a reply to message #119178] |
Wed, 11 May 2005 09:00 |
BenL2
Messages: 3
Registered: May 2005
|
Junior Member |
|
|
I have difficulties to appreciate the difference between those different way of working. I suppose that installing two instance will necessitate more storage on the system (catalogue, ...) but in a way of execution speed, I have difficulties to understand ... Will we see differences using those different possibilities ?
Thanks a lot.
|
|
|
|
| Re: New instance or new user ... [message #119266 is a reply to message #119133] |
Wed, 11 May 2005 09:14 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
And I'm assuming by instance you really mean database.
But I think you need to read more in the oracle concepts guide and provide some more detailed information about your situation and more specific questions about it for us to be able to provide much further help.
The other responders pretty much said it, how would having two databases, and all of the overhead and management that they entail, be better than one database? What is your concern with that approach?
|
|
|
|
|
|
| Re: New instance or new user ... [message #119279 is a reply to message #119266] |
Wed, 11 May 2005 10:26 |
BenL2
Messages: 3
Registered: May 2005
|
Junior Member |
|
|
By instance I want to say database.
The situation is the one :
We have an environment of delivery (original software) and an environment of programming (adaptation of the software for a specific project).
We usually create a database for delivery and one for programming. This database can be dismount easily without perturbing the programming database (same for the backup procedure). It's possible that those two environment are situated in different server ... so it's better and cleaner to separate everything. But for a specific project, we have to install those two environments on the same server (that's a constraints). This one isn't so powerful and so we can't waste performances ...
Thanks for your answer.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
