No one here is too worried about gaps in the sequence numbers, just as long
as they are unique. Thanks for the info! Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Monday, June 17, 2002 4:46 PM
> certainly the active ones -- one way to determine which ones is to monitor
> changes to the LAST_NUMBER column over time to determine which ones are
> busiest...
>
> the sequence cache in the SGA is managed via an LRU algorithm, so only the
> sequences that get used will take up space. the parameters
> SEQUENCE_CACHE_ENTRIES and SEQUENCE_CACHE_HASH_BUCKETS had been used to
size
> the cache in the SGA, but as of 8.1.x they are obsolete and ignored as the
> job of sizing is now automated...
>
> ...by the way, getting aged out of the sequence cache is another scenario
> for "losing numbers", just FYI...
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Monday, June 17, 2002 1:54 PM
>
>
> > Do you have a recommendation on the number of sequences to cache or is
> that
> > up to the application,etc?
> >
> > Thanks in advance,
> > Ruth
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Monday, June 17, 2002 2:58 PM
> >
> >
> > > uncached sequences are another frequent cause. lots of people think
> that
> > > using sequences without caching will prevent "number loss", which is
> > untrue.
> > > it only reduces the number of scenarios under which blocks of numbers
> can
> > be
> > > "lost". transaction rollbacks and application logic are a much more
> > > frequent cause...
> > >
> > > ...gotta wonder why people would worry about "number loss" or "gaps in
> the
> > > number sequence". this concern should only be a consideration instead
> of
> > a
> > > knee-jerk negative reaction. i keep flashing back to that George
Carlin
> > > routine on the discovery of a "new number" named "bleen", which
resides
> > > between 6 and 7...
> > >
> > > ----- Original Message -----
> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > Sent: Monday, June 17, 2002 11:48 AM
> > >
> > >
> > > > Seema,
> > > > Check for users with temporary or default tablespace set to system.
> > > > Another area to look at is the level of activity in the data
> dictionary
> > > > (such as space management). I have found condition 1 to be rather
> common
> > > > (unfortunately).
> > > >
> > > > Daniel W. Fink
> > > > Sr. Oracle DBA
> > > > MICROMEDEX
> > > > 303.486.6456
> > > >
> > > >
> > > > -----Original Message-----
> > > > Sent: Monday, June 17, 2002 10:38 AM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > > Hi
> > > > I am wondering in one of database teh IO rate is high on system data
> > > > files.Let me know what could be reason and how to reduce it.
> > > > Thx
> > > > -Seema
> > > >
> > > >
> > > > _________________________________________________________________
> > > > Join the world's largest e-mail service with MSN Hotmail.
> > > > http://www.hotmail.com
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Seema Singh
> > > > INET: oracledbam_at_hotmail.com
> > > >
> > > > 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: 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: Fink, Dan
> > > > INET: Dan.Fink_at_mdx.com
> > > >
> > > > 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: 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: Tim Gorman
> > > INET: Tim_at_SageLogix.com
> > >
> > > 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: 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: Ruth Gramolini
> > INET: rgramolini_at_tax.state.vt.us
> >
> > 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: 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: Tim Gorman
> INET: Tim_at_SageLogix.com
>
> 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: 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: Ruth Gramolini
INET: rgramolini_at_tax.state.vt.us
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: 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).
Received on Mon Jun 17 2002 - 16:04:53 CDT
