Re: Interview question

Van Messner wrote:
>
> OK That's what I thought. Prevention is all you can do. But the
> interviewer indicated another DBA had told him what could be done and seemed
> surprised I didn't know all about it. Just wanted to make sure.
>
> Thanks,
>
> Van
>
> "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3AE131C4.E203CADA_at_exesolutions.com...
> > Doesn't sound like a serious question to me. Sounds like the person
 interviewing
> > you had it happen minutes before and was hoping you would bail him out.
> >
> > How to prevent it when you rerun is the only relevant issue.
> >
> > Daniel A. Morgan
> >
> >
> > Van Messner wrote:
> >
> > > A question came up in an interview recently. You're running a very
 long
> > > query and get a snapshot too old error. What's the best thing to do at
 that
> > > time? The interviewer didn't want to know how to prevent this problem
 but
> > > what to do about it when you were right in the middle of it. What's the
> > > best answer?
> > >
> > > Van
> >

You could always say "We wait for 9i and see if the claimed resume query after error stuff works..." :-)

Cheers
Connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"