Oracle9i Performance Tuning Test

[alwendal]

Hi Tim,

I just took the Oracle9i Performance Tuning test and unforunately didn't pass. I've read the Oracle University Books, the Sybex book and the Oracle Certification Performance Tuning Study Guide Book. Plus, I used the Self Test Software to study. I had so many questions on the test which looked nothing like the Self Test software questions (they were much more difficult) and many of them were not in any of the books I studied. In the past three exams, I've never had this problem. One of the questions has been hauning me and it relates to the Large Pool in a database set up in Shared Server mode.

Specifically, the question asked if the Large Pool was running out of space, would users get an error (or something to that effect) or would Oracle go to the Shared Pool to borrow space. This is obviously not verbatem but hopefully you get the gist. Now, I've looked in my past Oracle University Books, like the Fundamentals II book and such but there is no exact mention of this situation. I've even checked the online Oracle documentation and found no mention of it. I am confused and very upset that questions such as these are on the exam. I thought I understood the concepts pretty well...alas I know not the answer to the situation I've described.

Any help you can provide would be most appreciated.

Best regards,
alwendal

[Tim...]

Hi.

The answer to this question is more by implication, than a specific sentence in the manuals. The large pool, if it is defined, can be thought of as a section of the shared pool. Since the large pool does not have a LRU list to age out blocks, once it's full it stays full. This alone should make you realize this situation doesn't result in a error. Since the large pool is like a section of the shared pool, it being full results in processes that would have used the large pool being forced to use the shared pool.

The exams often contain questions like this that force you to link sever pieces of distinct information together to form a logical conclusion. It's a true test of whether you understand the material or not.

Personally, I never waste time on practice tests. They are not a true reflection of the exams, so why bother. Spend your time learning the material.

Cheers and good luck next time.

Tim...

[alwendal]

Hi Tim,

Yes, I thought that was the case but I wasn't sure. So, just to make sure I understand things correctly, if the large pool runs out of room, then space is used from the associated shared pool. Also, users will not get errors because Oracle has another option -- going to the shared pool.

Thanks for all of your help,
alwendal

[Tim...]

Yes.

Cheers

Tim...

[alwendal]

Great! Thank you!

[Tim...]

[patrickwang72]

Hi alwendal,
I ever experiened what you ever had in oracle OCP exams. There is an sample questions package at

Link removed.

Please go to find it and take look at it. That's called TestKing, the closest exam practice test of Oracle OCP exams.

Enjoy,

Patrick

[Tim...]

Patrick, the link pointed to a forum which had uploaded versions of what I assume to be pirated software. I have therefore removed the link.

Please do not post links to illegal content.

Tim...

[sandeepkrs]

Hi,

I also have to give this last paper for OCP. Can you suggest me some usefull book for this beside Oracle University Books.

Can someone give me name of SYBAX book.

Thanks.

[Tim...]

Hi.

The Sybex book is here:

http://www.oracle-base.com/books/BookDe ... dy%20Guide

Cheers

Tim...