No. CPU utilitization averages 40-60% across 4 CPUs. --- Mohammed Shakir <[EMAIL PROTECTED]> wrote: > No enough inserts to bog down the CPUs? > > --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > > Thanks, Mohammed and Anjo, for your replies. > > > > Now my question is this: given that the table structures > (freelists, > > etc.) are identical on the two machines, the init.ora parameters > are > > identical for the two instances, and the machines themselves are > > nearly > > identical (one has 6 CPUs, one 4, but in neither case are the CPUs > > anywhere near maxed out), what could be causing the discrepancy? > > > > PB > > > > --- Mohammed Shakir <[EMAIL PROTECTED]> wrote: > > > data block waits is the indicator of freelists contention. I have > > > never > > > seen a freelists contention, even though I have been running 11 > > > processing doing inserts using 11 CPUs. I have seen library > cache, > > > Shared pool and cache buffer chains waits. I took care of buffer > > busy > > > waits and db file sequential reads by increasing freelists, > > initrans > > > to > > > 11 and by partitioning the disks. In my case most of the data was > > > writting to the same block by as many as 9 processes. I am > working > > on > > > a > > > > > > Sparc 4500 Solaris 2.1.6 with Oracle 8.1.6.0 and 8.1.7.2 > > > > > > Library Shared Pool latch contention was found due to Literal or > > > non-shared SQL. Check SQL_text in SQLarea to find literal SQL. > > Shared > > > Pool contention seems to be due to a very large Shared pool. I > > found > > > a > > > bug report that indicates that cache buffer chain problem was > fixed > > > in > > > 8.1.3.4 and 9.0.1.3 > > > > > > Cache buffer chain is also an indicator of high physical and > > logical > > > I/O. You can check on that as well. > > > > > > Hope this helps. > > > > > > Shakir > > > > > > --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > > > > Greetings! > > > > > > > > I am trying to diagnose a performance difference between two > > > > databases > > > > running the same test. They are similarly configured (same SGA > > > size, > > > > etc.), and the servers are identical except for the number of > > CPUs > > > > (server A has 4, server B has 6). > > > > > > > > On database A, INSERT performance is about 190 rows/second. > > > > > > > > On database B, INSERT performance is over 500 rows/second. > > > > > > > > I saw some cache buffers chains, buffer busy, and library cache > > > latch > > > > waits on database A while the test was running, as well as redo > > log > > > > sync waits. The waits didn't seem excessive, though. I > checked > > > for > > > > "checkpoint not complete" redo allocation messages in database > > A's > > > > alert log and found none. The db_block_lru_latches parameter > is > > > set > > > > to > > > > one-half the number of CPUs in both machines. > > > > > > > > I'd much appreciate any suggestions as to what else to check. > I > > > know > > > > that freelists can be an issue (there are multiple sessions > > > > performing > > > > inserts); how can I check to see if there's freelist > contention? > > > > Anything else I should investigate? > > > > > > > > Many TIA, > > > > > > > > > > > > > > > > > > > > > > > > ===== > > > > Paul Baumgartel, Adept Computer Associates, Inc. > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > __________________________________________________ > > > > Do You Yahoo!? > > > > Yahoo! Tax Center - online filing with TurboTax > > > > http://taxes.yahoo.com/ > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > -- > > > > Author: Paul Baumgartel > > > > 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). > > > > > > > > > ===== > > > Mohammed Shakir > > > CompuSoft, Inc. > > > 11 Heather Way > > > East Brunswick, NJ 08816-2825 > > > (732) 672-0464 (Cell) > > > (732) 257-6001 (Home) > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Yahoo! Tax Center - online filing with TurboTax > > > http://taxes.yahoo.com/ > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Mohammed Shakir > > > 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). > > > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Tax Center - online filing with TurboTax > > http://taxes.yahoo.com/ > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Paul Baumgartel > > 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). > > > ===== > Mohammed Shakir > CompuSoft, Inc. > 11 Heather Way > East Brunswick, NJ 08816-2825 > === message truncated ===
__________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel 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).
