possibly the world's most unfortunate name for an application? I see it posted alot. seriously, I think it's a web server or a name for an application....? -----Original Message----- Sent: Wednesday, August 22, 2001 1:06 AM To: Multiple recipients of list ORACLE-L What is "unil-bialism" ?? ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, August 20, 2001 2:12 PM > FYI, in a previous message I detailed some of the tuning efforts we have > been working on in regards to getting a EDI sales order processing job to > process 150,000 lines per hour. Well the major point of contention was > freelists. We went from 250 lines per minute to over 1500 lines per minute > simply by increasing freelists on some tables and indexes. We saw an > unbelievable 20,000 commits per minute on a 12 CPU AIX box. Looked like we > could actually achieve the client's goal until we turned on advanced > pricing. It added 60% more overhead and increased user calls 3 fold which > pegged all 12 CPU's at 100%. I have a detail trace file event 10046 level 8 > to look at and see if I can improve any. Think I will give unil-bialism a > try. > > Thanks, > Ethan > http://www.geocities.com/epost1 > > > >-----Original Message----- > >From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] > >Sent: Monday, August 20, 2001 7:56 AM > >To: Multiple recipients of list ORACLE-L > >Subject: Re: Performance analysis (enqueue and buffer busy waits) > > > > > > > >Small rollback segments can be recycled > >without being written to disc. This can > >reduce the total write-load on the system > >and enhance your general use of the > >db_block_buffer. > > > > > >Jonathan Lewis > > > >Host to The Co-Operative Oracle Users' FAQ > >http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > >Author of: > >Practical Oracle 8i: Building Efficient Databases > >See http://www.jlcomp.demon.co.uk/book_rev.html > > > >For latest news of public appearances > >See http://www.jlcomp.demon.co.uk > > > >Screen saver or Life saver: http://www.ud.com > >Use spare CPU to assist in cancer research. > > [snipped] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Mohan, Ross INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
