Re: HIGH IO ON SYSTEM DATA FILES

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