Re: AQ streams expected performance in 10gr2

What are the waits showing?

Try cutting your sga down to 1.2, perhaps you are spending too much time checkpointing. Alert log show anything? Hot blocks in those dequeue tables? Maybe you can split them into alternate buffer pools
(the idea being that the cpu usage comes from oracle continuously
shuffling things about in the default pool, so it has to burn cpu to calculate that and wait while that happens, so moving them lets the other tables things go on). What does top say those cpu's are doing?

(The Tuning Oracle at the Block Level download at tusc.com might help
you see where I'm coming from on this.)

jg

--
@home.com is bogus.
The Tony Soprano vision of networking:
http://www.slate.com/id/2140850/fr/rss/