Thanks,
I've found some on asktom also.
Stephane
-Original Message-
Litchfield
Sent: Tuesday, April 01, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
I seem to be missing some of the replies etc to this so apologies for
repeating anything anyone else has said.
1. A BCHR of x
ORA-01555, 0, "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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> On Behalf Of
> > Stephane Paquette
I seem to be missing some of the replies etc to this so apologies for
repeating anything anyone else has said.
1. A BCHR of x% means that you have a well tuned system (where x is
usually > 95)
2. Minimise the number of extents for each object
3. Set PCTIncrease to a small value (typically 1%) to
Title: Re: Oracle urban legends and myths needed
Do a search for "myth" on asktom.oracle.com:
e,g.:
Whenever possible, issue frequent COMMIT statements in all your programs.
By issuing frequent COMMIT statements, the performance of the program is
enhanced and its resource requir
