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
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 requirements
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
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
Sent: 01
