Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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/Received on Wed May 03 2006 - 16:53:32 CDT