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
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Tim Gorman [mailto:Tim_at_SageLogix.com]
> 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" <ORACLE-L_at_fatcity.com>
> 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: Rich.Jesse_at_qtiworld.com

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: ListGuru_at_fatcity.com (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: IBezdziecka_at_cupe.ca

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: ListGuru_at_fatcity.com (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).