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 -> Oracle instructor said...

Oracle instructor said...

From: Bob Yeh <Bob_Yeh_at_vaffx2_at_cscuuxch.dayton.csc.com>
Date: 1997/02/17
Message-ID: <3308B39E.4CAF@cscuuxch.dayton.csc.com>#1/1

Hi,

I attended an Oracle training last week. The instructor told us to set the initial extent and next extent for rollback segs 10% larger than the largest table in the database. Also set the min/max extents to 2 ONLY. This way no expanding/shrinking will take place.

Is this a good practice? How come no other tuning book recommend this way.

Thanks.
Bob Received on Mon Feb 17 1997 - 00:00:00 CST

Original text of this message

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