Re: perplexing performance on AIX

From: Daniel Fink <>
Date: Tue, 06 May 2008 15:33:52 -0600
Message-ID: <>

Why do you want to use parallelism? If it is for performance reasons, you need to prove that parallelism would help not hurt. Doug Burns has done extensive research into parallelism ( and I strongly recommend reading it.

In terms of the actual wait events, you will need to trace the parallel slave sessions and use trcsess to combine the trace files so you can profile them.

Daniel Fink

Daniel Fink

Oracle Performance, Diagnosis, Data Recovery and Training

Oracle Blog

Lost Data?

Received on Tue May 06 2008 - 16:33:52 CDT

Original text of this message