Re: HIGH IO ON SYSTEM DATA FILES

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).