Oracle9i Performance Tuning Test

All posts relating to Oracle certification (OCA, OCP, OCM).

Moderator: Tim...

Oracle9i Performance Tuning Test

Postby alwendal » Tue Apr 03, 2007 1:33 am

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
alwendal
Member
 
Posts: 19
Joined: Wed Jun 15, 2005 1:40 am

Postby Tim... » Tue Apr 03, 2007 10:12 am

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Thanks

Postby alwendal » Wed Apr 04, 2007 7:20 pm

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
alwendal
Member
 
Posts: 19
Joined: Wed Jun 15, 2005 1:40 am

Postby Tim... » Thu Apr 05, 2007 7:07 am

Yes.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Thanks!

Postby alwendal » Thu Apr 05, 2007 7:26 pm

Great! Thank you! :D
alwendal
Member
 
Posts: 19
Joined: Wed Jun 15, 2005 1:40 am

Postby Tim... » Fri Apr 06, 2007 6:15 am

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

sample of Oracle 9i Exam questions

Postby patrickwang72 » Tue Apr 17, 2007 6:48 pm

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
patrickwang72
Member
 
Posts: 2
Joined: Mon Apr 16, 2007 7:31 pm

Postby Tim... » Wed Apr 18, 2007 6:55 am

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

OCP - Performance And Tuning Exam

Postby sandeepkrs » Tue May 08, 2007 7:30 pm

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.
sandeepkrs
Member
 
Posts: 2
Joined: Tue May 08, 2007 7:21 pm

Postby Tim... » Wed May 09, 2007 7:38 am

Hi.

The Sybex book is here:

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

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Certification

Who is online

Users browsing this forum: No registered users and 2 guests

cron