Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UNDO Tablespace Full

Re: UNDO Tablespace Full

From: joel garry <joel-garry_at_home.com>
Date: 21 Jun 2006 15:25:12 -0700
Message-ID: <1150928711.976543.109970@c74g2000cwc.googlegroups.com>

ADRoman wrote:

>
> My undo_retention is 3 hours.
>
> but, sometimes I obtain errors 1555.
> I am reading about error 1555

You should search asktom.oracle.com for ORA-1555, developers sometimes write foot-shooting code ("fetch across commits") that increases the likelihood of getting this error. Don't miss the delayed block cleanout issue, too.

My undo_retention is 10 hours, and I inevitably get ORA-1555 when I turn off the process that runs in the middle of the night and hunts down and kills processes where people forgot to log off (a third-party 3-tier). The thing about ORA-1555 is, its root cause is often due to other processes than the one that gets the error. Simply futzing with undo_retention may not solve the problem, you need to understand the read-consistency of your system.

jg

--
@home.com is bogus.  "Widescreen TVs are designed primarily for viewing
widescreen images. The majority of images displayed on them should be
widescreen-shaped or expanded to fill the screen, and constantly
moving. Displaying stationary images, such as side bars shown on
non-expanded standard shaped TV pictures, should be limited to 15
percent of total viewing per week. Viewing other stationary images such
as stock market reports, video game patterns, station logos, web sites,
or computer-style patterns should be similarly limited. These types of
stationary images displayed on any projection tube system can cause
uneven aging of the tubes and leave a subtle but permanent ghost image
in the picture. To avoid this, mix the types of pictures you watch,
with the majority filling the screen with moving images, not stationary
patterns or black bars. Use the zoom or expand features (on models that
offer them) whenever necessary to fill the screen. Be careful in your
selection of TV format, as the uneven aging resulting from excessive
viewing in the wrong format is not covered under your warranty. "

In other words, most of your television viewing must be in a distorted
format, otherwise you burn your TV tubes in a way disclaimed by the
warranty.  Oughta be a law against that...
Received on Wed Jun 21 2006 - 17:25:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US