Re: Oracle Profile Question

amerar_at_iwc.net wrote:
> Obviously you fail to understand the application that I've tried
> explaining. The remote system TAKES DOWN their database during their
> randon batch cycles. So, if one of our clients is in the middle of a
> query, or our batch cycle is running and their database GOES DOWN, we
> hang.....
>
> What is so hard to understand about that? There must be a way to
> detect that, in batch mode, and deal with it, without having everything
> hang or abort.......

You're serious? Someone is actually stopping an Oracle database and random unpredictable times for random and unpredictable amounts of time?

Reality check: There is not reason I can posit for doing that and most certainly not just because someone is doing any batch processing. If they are doing this they need some help: Where's that lead pipe?

If the problem isn't on your side it is on theirs and either way you have two choices ... (1) hang or (2) fix the problem.

There is a nasty workaround you could do using jobs and killing sessions but it is preposterous that this would be a business solution. I still see what you are doing as resisting doing the diagnostics. But assuming all of what you've written is correct who is managing this remote system? Do you have an SLA with them? If not why not? If so surely they are violating it. This is not a technology problem this is a business problem and should be kicked upstairs for IT management to negotiate out a solution.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)