Re: Performance analysis (enqueue and buffer busy waits)

What is "unil-bialism" ??

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> 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: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.
> >

[snipped]
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Babette Turner-Underwood
  INET: babattt_at_home.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).