Passed Performance tuning

[tycho]

Hello all,

I passed Oracle 8 performance tuning today (56/61). Was the easiest exam sofar.

Still have to do one (Networking).

Like all other exams this exam had some wiered questions.

The STS was of little help.

tycho

[Zbigi]

Could you share me with STS Orcale8 : preformance tuning
I am going to take this exam soon and I'm looking for self test sofware
Zbigi
Please contact me on
Zbigi@zeto.com.pl

[pal77]

Tycho,

Could you pls give me some insight into this Performance and Tuning exam. I have seen postings in a couple of forums and they seem to say that this particular exam is hard.

Planning to take the exam next week. I would highly appreciate if you could let me know as soon as possible. Thanks in advance.

[vimalp]

Congratulations Tycho!

Good Luck for Net Admin :)

[tycho]

Hi pal77,

What you need to understand for this exam is the way things work together in Oracle.

Understand the order for tuning: DAMICO (design,application,etc)

Tuning SQL.
What is in the shared pool, the buffer cache, the log buffer and how do you tune these structures.
Tuning I/O.
Tuning Contention


There are also 'practical' questions presenting some sort of problem for which you have to find the correct answer.

And also there are the well known questions which after reading five times I still not understand or the right answer is missing (imho).
If you know your stuff it's not a hard exam

Good luck next week


tycho

Thanx vimalp

[pal77]

Thanks tycho.