RE: Oracle urban legends and myths needed

From: Barbara Baker <barbarabbaker_at_yahoo.com>
Date: Tue, 01 Apr 2003 13:33:54 -0800
Message-ID: <F001.005777E3.20030401133354@fatcity.com>

   ORA-01555, 00000, "snapshot too old: rollback segment number %s with name \"%s\" too small"

indicates that the DBA should immediately create a hugh rollback segment

> > -----Original Message-----
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]
> On Behalf Of
> > Stephane Paquette
> > Sent: 01 April 2003 15:54
> > To: Multiple recipients of list ORACLE-L
> > Subject: Oracle urban legends and myths needed
> >
> >
> > Hi all,
> >
> > I'm currently writing an Oracle user guide for our
>
> > developpers about how Oracle is implemented, SQL
> and PL/SQL
> > good practices, tuning, rule base vs cost base (90
> on 120
> > databases are still rule base) ...
> >
> >
> > I want to add an Oracle urban legends and myths
> section
> > focussed on development. I'm missing inspiration
> as I only
> > have the "use an index it'll go faster" one.
> >
> > I'm sure you have lots of them.
> >
> >
> > TIA
> >
> > Stephane Paquette
> > Administrateur de bases de donnees
> > Database Administrator
> > Standard Life
> > www.standardlife.ca
> > Tel. (514) 925-7187
> > stephane.paquette_at_standardlife.ca
> > <mailto:stephane.paquette_at_standardlife.ca>
> >
> >
> > --
> > Please see
> > the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Stephane Paquette
> > INET: stephane.paquette_at_standardlife.ca
> >
> > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > San Diego, California -- Mailing list and
> web hosting services
> >
>

---

> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru')
> > and in the message BODY, include a line
> containing: UNSUB
> > ORACLE-L (or the name of mailing list you want to
> be removed
> > from). You may also send the HELP command for
> other
> > information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Niall Litchfield
> INET: niall.litchfield_at_dial.pipex.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>

---

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>

---

Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barbara Baker
  INET: barbarabbaker_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Apr 01 2003 - 15:33:54 CST