This forum is currently locked. You can't register or post questions at this time. (read more)

Oracle9i Performance Tuning Test

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

Moderator: Tim...

alwendal
Member
Posts: 19
Joined: Wed Jun 15, 2005 1:40 am

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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

alwendal
Member
Posts: 19
Joined: Wed Jun 15, 2005 1:40 am

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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

alwendal
Member
Posts: 19
Joined: Wed Jun 15, 2005 1:40 am

Thanks!

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

Great! Thank you! :D

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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

patrickwang72
Member
Posts: 2
Joined: Mon Apr 16, 2007 7:31 pm

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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

sandeepkrs
Member
Posts: 2
Joined: Tue May 08, 2007 7:21 pm

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.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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


Return to “Oracle Certification”

Who is online

Users browsing this forum: No registered users and 3 guests