RE: two instance -- one database
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: Mark.Brady@xxxxxxxxxxxxxxxxx, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Sep 2008 11:32:28 -0400
It frankly sounds pretty silly to me. Your friend can set up resource
profiles on Database A to limit resource consumption by "bad
queries"...or the developers could be taught how to write efficient SQL!
Also, "bad queries" can be written against views as well, and placing
the views on another database does nothing to make them less bad. Using
db links complicates administration, availability, and performance
optimization.
Tom Kyte (asktom.oracle.com) would have a field day with this one.
Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
==============================================================================
Other related posts:
