Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g5I3mTE04044 for ; Mon, 17 Jun 2002 23:48:39 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id MAA63322; Mon, 17 Jun 2002 12:48:10 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 0047F9C2; Mon, 17 Jun 2002 12:46:13 -0800 Message-ID: Date: Mon, 17 Jun 2002 12:46:13 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Tim Gorman" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Tim Gorman" Subject: Re: HIGH IO ON SYSTEM DATA FILES Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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" 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" > 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" > > 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@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@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@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@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@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@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@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@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@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@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).