Re: Interview question

i am glad you approve.

"Van Messner" <vmessner_at_bestweb.net> wrote in message news:k02F6.4716$Uu6.429269_at_monger.newsread.com...
> That's a MUCH better answer than the guy who said "ask your DBA"
>
> Van
>
>
> "Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
> news:3AE4459F.1A12_at_yahoo.com...
> > 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"
>
>
Received on Mon Apr 23 2001 - 19:29:25 CDT