Re: Interview question

From: Van Messner <vmessner_at_bestweb.net>
Date: Mon, 23 Apr 2001 22:28:32 GMT
Message-ID: <k02F6.4716$Uu6.429269@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 - 17:28:32 CDT