500 M for batch transactions? -- Chris J. Guidry P.Eng. EE ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED]
> -----Original Message----- > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > Sent: Monday, March 04, 2002 07:28 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: # of datafiles per tablespace > > no reason. I can see creating multiple files under those conditions > only because you want to keep files to a specific size. > > Now, I did once find that the rollback datafiles were a bottleneck on a > system I had. So we built TWO rollback tablespaces, with datafiles on > different mount points etc and the rollback segments divided between > the two tablespaces. > > cleared up that bottleneck like a dream > > > other than that though.. why? > > > --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > > OK, I know we had the debate already but lets have another go at it. > > > > Say you got a tablespace, lets call it RBS and its for rollbacks. > > Now, for what reason would you create a 500M file and 4 50M files > > for this puppy as opposed to just one file. I just cannot see the > > reasoning > > for this at all. None. Natta. Zilch. > > > > So educate me please if someone out there knows a legit reason they > > would do this. > > > > Lets assume for the sake of argument that disk size and mount point > > size is not a limitation. Space available to me on any one mount > > point > > is unlimited. > > > > ___________________________ > > Kimberly Smith > > Portland, OR > > [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Kimberly Smith > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing > > Lists > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (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! Sports - sign up for Fantasy Baseball > http://sports.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com -- Author: Guidry, Chris INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
