RE: Performance analysis (enqueue and buffer busy waits)

From: Post, Ethan <epost_at_kcc.com>
Date: Mon, 20 Aug 2001 10:08:11 -0700
Message-ID: <F001.003712EB.20010820101240@fatcity.com>

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:jonathan_at_jlcomp.demon.co.uk]
>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.
>
>
>
>
>-----Original Message-----
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 20 August 2001 14:03
>
>
>|I am curious.
>|What are you trying to accomplish by
>|decreasing rollback segment size??
>|
>|- Babette
>|
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jonathan Lewis
> INET: jonathan_at_jlcomp.demon.co.uk
>
>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).
>

---

This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.

---

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  INET: epost_at_kcc.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).

Received on Mon Aug 20 2001 - 12:08:11 CDT