Re: drop user hangs

Joel Garry wrote:

> Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3F4BF4E7.456C1CD3_at_exxesolutions.com>...
> > Joel Garry wrote:
> > > Well, ORA-155x is supposed to be long-gone with undo, but I'm
> > > wondering if something is so messed up it hangs and can't tell you
> > > about it. That could be an error that is supposed to come back to
> > > you, rather than the alert log.
> > >
> > > Are you sure you aren't running into a maxsize parameter on your
> > > autoextend ts? I would be worried about a 98% filled system ts just
> > > on general principle, but then again I'm old-fashioned.
> > >
> > > jg
> > > --
> > > @home.com is bogus.
> > > http://www.zone-h.org/en/news/read/id=3287/
> >
> > UNDO decreases the incidence of ORA-01555 but does not eliminate it. And most certainly can not solve the problem
> > of badly written code such as incremental commits inside a loop.
>
> I knew that, I just can't resist obscure digs at Oracle marketroids
> who claimed "no more ora-1555" in so many words when 9 came out. Or
> was it 9iR2? :-O
>
> jg
> --
> @home.com is bogus.
> http://philip.greenspun.com/wtr/dead-trees/53013.htm

Digs? Why? What possible purpose is served. Anyone with an IQ above room temperature knows that marketing claims are hyperbole and that stupid people can make anything not work such as my example with incremental commits.

Undo has gone a huge way toward elminating ORA-01555 and credit should be given to Oracle's development team for a job well done. If you want to hold out for Oracle (or anyone else) fixing things so that no one, no matter how moronic, can't break them you are in need of counselling.

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