Re: DATABASE LINKS

Van Messner wrote:

>I'd just make the link and try the queries to see how slow they are and if
>they have any effect on production apps. (It sounds like you don't have a
>test or development environment to try this in.). If the queries are slow
>or impact production apps, you could suggest an alternative - perhaps
>materialized views.
>
>
>"Rose" <rosebernardo_at_yahoo.com> wrote in message
>news:d200c71d.0311081723.4a3acd71_at_posting.google.com...
>
>
>>I am working for the Business Investigation Department. They requested
>>a database link to production so they can perform their research to
>>the production environment through this database link.
>>Their investigation consists of procedures that read files of any
>>number between 50,000 to 1,000,000 records and perform queries against
>>the production database - one by one. Since their customers make about
>>twenty to thirty different requests every day, they don't have time to
>>make up test data. Therefore they also wish to test their procedure
>>with production data using this same databalink link.
>>
>>I believe this whole thing to be crazy. Can someone give me some very
>>good technical explanation and/or point me to somewhere I can get a
>>technical paper of something I can give to my boss to stop my boss?
>>
>>

The issue has nothing to do with speed. There might be zero impact on speed. The issue is
entirely encapsulated in the phrase "they also wish to test their procedure with production data using
this same databalink link."

In other words, at any moment, they reserve the right to throw in a Cartesian join and bring the
entire production database to its knees.

Another possible solution Van. Look at giving them a profile that tightly restricts their use of resources. Also look at the DBMS_RESOURCE_MANAGER built-in package.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)