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.