Re: Advanced queueing CPU consumption

From: joel garry <joel-garry_at_home.com>
Date: 30 May 2007 14:56:59 -0700
Message-ID: <1180562219.000984.311960@i13g2000prf.googlegroups.com>

On May 30, 1:10 pm, Mladen Gogala <mgogala.SPAM..._at_not-at-verizon.net> wrote:
> This is 10.2.0.3 database on Linux. My application developers have
> installed an application that utilizes advanced queueing and the CPU
> consumption skyrocketed. The 3 SQL statements consuming most CPU are all
> related to AQ. The "Streams AQ: waiting for messages in the queue" event
> surpasses even "SQL*Net mssage from client" and the database is spinning
> like crazy. Is anybody here aware of anything I can do to alleviate the
> burden to the CPU resources?
> --http://www.mladen-gogala.com

Upgrade to 11.
Ask support about it, I'm fairly certain it is an unpublished bug. Root around in the bug db, you'll probably see what I mean. Some of the variants have workarounds.

--
@home.com is bogus.
$4K doesn't buy a lot of fertilizer these days:
http://www.signonsandiego.com/uniontrib/20070530/news_1b30journal.html

Received on Wed May 30 2007 - 16:56:59 CDT