Hello, It's "Unal Bilisim". Ethan mentioned about itrprof SQL Analyzer, which is superior to tkprof. web: http://www.unal-bilisim.com/products/itrprof/itrprof.html Thank Ethan. regards... Babette Turner-Underwood wrote: > 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: Danisment Gazi Unal (Unal Bilisim) 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).
Re: Performance analysis (enqueue and buffer busy waits)
Danisment Gazi Unal (Unal Bilisim) Wed, 22 Aug 2001 01:11:53 -0700
- RE: Performance analysis (enqueue and b... Post, Ethan
- Re: Performance analysis (enqueue and b... Jonathan Lewis
- RE: Performance analysis (enqueue and b... Post, Ethan
- RE: Performance analysis (enqueue and b... Babette Turner-Underwood
- Re: Performance analysis (enqueue and b... Jonathan Lewis
- RE: Performance analysis (enqueue and b... Post, Ethan
- RE: Performance analysis (enqueue and b... Post, Ethan
- RE: Performance analysis (enqueue and b... Gogala, Mladen
- Re: Performance analysis (enqueue and b... Jonathan Lewis
- Re: Performance analysis (enqueue and b... Babette Turner-Underwood
- RE: Performance analysis (enqueue and b... Danisment Gazi Unal (Unal Bilisim)
- RE: Performance analysis (enqueue and b... Christopher Spence