I passed 1z0-033
Oracle9i Performance Tuning
My score is 52/65.
Required is 46/65.
I meet total 70 questions(65 scored + 5 unscored) within 90 minutes,
I finished all the 70 questions just in time.
9i new feature I met:
STATSPACK(two items),Dynamic SGA,buffer cache advisory,
JAVA_MAX_SESSIONSPACE_SIZE,auto UNOD management,
Share row exclusive's 9i implementation,
Half of items are simply, like get info from V$xxx and usage of package.
Half of items are difficult, like what statments are
true on some issues(select2/3 from 4/5 items)
The Student Guide(SG) D33513 is quite good for preparing the exam, read it carefully.
(I lost one item on Tuning phases, one on tuning goals,these items just come from the SG.)
I used
oracle 8i STS 001,023,025 026,024 to prepare my 9i OCP,
if you can find STS 007,031-033, I think it will be better.
The good news to use 8i STS is it can be easy found and good enough to pass 9i exam.
The bad news to use 8i STS is that you can't find the same questions on your 9i exam.
I(8 hours work a day as engineer) prepare every exam for about 4 weeks,
3 weeks read book, do examples and pratics mentioned in SG,
do 8i STS, 1 week to read SG once more and take exam.
if you have more time to prepare on daytime, maybe 1-2 weeks is enough(without braindump).