RE: _spin_count Revealed
EXCELLENT site! Makes me feel right at home :). Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Next event: Miracle Database Forum, Sep 20-22 Middelfart Denmark -Original Message- Rich Sent: Wednesday, September 18, 2002 10:18 AM To: Multiple recipients of list ORACLE-L I doubt the _counter_corriolis_effect parameter would do much: http://www.ems.psu.edu/~fraser/Bad/BadCoriolis.html :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Grant Allen [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 7:18 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: _spin_count Revealed > > > You're forgetting about the _counter_corriolis_effect > parameter, introduced > in 9i. If you set this to true, then you need to flip you're > setting for > _spin_count. I've also found it useful to buy hard drives > with synchromesh > to make gear changes smoother :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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: Cary Millsap INET: [EMAIL PROTECTED] 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: [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).
RE: _spin_count Revealed
Well ... although you are correct, you forgot to mention that there is a hidden table sys. fence$, leftover from the archaic time, which (table, not time) has a column drift# (Boolean) and one row. Default value is FALSE and unless changed manually to TRUE, the_centripedal_acceleration parameter works only up to 1K spin. In addition one has to alter session set nls_territory= western before updating fence$. inka -Original Message- Sent: Wednesday, September 18, 2002 2:19 PM To: Multiple recipients of list ORACLE-L All I'm saying is that the parameter wouldn't have nearly as much effect as the _centripedal_acceleration parameter, which as we all know keeps the bits from flying off of HDs, especially the 15K spin. I believe it's undocumented now, since setting it to "false" caused corruption from bit loss. (how's that?) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Tim Gorman [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 18, 2002 12:38 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: _spin_count Revealed > > > Such a drag to detract from a good story using facts... > > ...which is how the whole discussion got started... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, September 18, 2002 9:18 AM > > > > I doubt the _counter_corriolis_effect parameter would do much: > > > > http://www.ems.psu.edu/~fraser/Bad/BadCoriolis.html > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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: Inka Bezdziecka INET: [EMAIL PROTECTED] 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: [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).
RE: _spin_count Revealed
All I'm saying is that the parameter wouldn't have nearly as much effect as the _centripedal_acceleration parameter, which as we all know keeps the bits from flying off of HDs, especially the 15K spin. I believe it's undocumented now, since setting it to "false" caused corruption from bit loss. (how's that?) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Tim Gorman [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 18, 2002 12:38 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: _spin_count Revealed > > > Such a drag to detract from a good story using facts... > > ...which is how the whole discussion got started... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, September 18, 2002 9:18 AM > > > > I doubt the _counter_corriolis_effect parameter would do much: > > > > http://www.ems.psu.edu/~fraser/Bad/BadCoriolis.html > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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).
Re: _spin_count Revealed
Such a drag to detract from a good story using facts... ...which is how the whole discussion got started... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, September 18, 2002 9:18 AM > I doubt the _counter_corriolis_effect parameter would do much: > > http://www.ems.psu.edu/~fraser/Bad/BadCoriolis.html > > :) > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > > > -Original Message- > > From: Grant Allen [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, September 17, 2002 7:18 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: _spin_count Revealed > > > > > > You're forgetting about the _counter_corriolis_effect > > parameter, introduced > > in 9i. If you set this to true, then you need to flip you're > > setting for > > _spin_count. I've also found it useful to buy hard drives > > with synchromesh > > to make gear changes smoother :-) > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > 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: [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: Tim Gorman INET: [EMAIL PROTECTED] 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: [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).
RE: _spin_count Revealed
I doubt the _counter_corriolis_effect parameter would do much: http://www.ems.psu.edu/~fraser/Bad/BadCoriolis.html :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Grant Allen [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 7:18 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: _spin_count Revealed > > > You're forgetting about the _counter_corriolis_effect > parameter, introduced > in 9i. If you set this to true, then you need to flip you're > setting for > _spin_count. I've also found it useful to buy hard drives > with synchromesh > to make gear changes smoother :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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).
RE: _spin_count Revealed
Fink, Dan[SMTP:[EMAIL PROTECTED]] wrote: > >I have learned that my information was incorrect. A negative value for > spin count is not to be used for reversing transactions. It is to be used > for those systems in the southern hemisphere to insure that the disks spin > counter-clockwise. > > > >I sincerely apologize for this mistake and hope the list will forgive me. > > > >Dan > Dan, You're forgetting about the _counter_corriolis_effect parameter, introduced in 9i. If you set this to true, then you need to flip you're setting for _spin_count. I've also found it useful to buy hard drives with synchromesh to make gear changes smoother :-) Ciao Fuzzy :-) -- "Woo Hoo!" - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] 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: [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).