RE: two instance -- one database
Date: Wed, 24 Sep 2008 11:05:22 -0500
Message-ID: <D8B6ACB8EA9BBE4AB9A7EFBEA6986D6204E7820A@mlxdpm1w3.we.dirsrv.com>
The only "advantage" that I see is that you'll have syntactically
correct SQL being executed.
It would probably be slower.
IMO, Pretty stupid way to go about running the environment.
Steve... ( a duh-veloper )
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Brady, Mark
Sent: Wednesday, September 24, 2008 11:07 AM
To: oracle-l
Subject: two instance -- one database
I have a friend (no really, this isn't some lame way of telling you about me but trying to hide that by ... )
I have a friend, and at his company they have an Oracle database with tables and data. We'll call it Database A and they have another Database B that has views across dblinks to each of the tables in Database A. The data team says that this protects Database A from bad queries.
So can anyone think of any possible benefit from this arrangement? Will administration be easier, queries faster, performance more predictable? Anything?
>>> This e-mail and any attachments are confidential, may contain legal,
professional or other privileged information, and are intended solely
for the addressee. If you are not the intended recipient, do not use
the information in this e-mail in any way, delete this e-mail and notify
the sender. CEG-IP1
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 24 2008 - 11:05:22 CDT