Performance & Tunings

[shravansam]

Hai Friends,

I am planning to write Performance & Tuning by next weekend. Can anybody send me some questions which was asked in OCP, and the questions which is in your memory.
Please send me to shravansam@rediffmail.com
or shravansam@hotmail.com

Thanks in advance.

Regards,

saravanan.

[padmam]

Hi, 15th July 2001 15:49 hrs chennai

Wll wish you all th ebest for the exams.

Since this is not the forum Reg Certifications i am moving this to Certifications forums.

By this time you would have recived my bunch of Q&A.

My Best Advice would be to Put your Practical work on Oracle Expert and SQL statement Tuning which is very crucial where many blink at Exam centre.

Cheers

Padmam

[mayank69]

Could you also send me any questions you may have for Oracle8 to Oracle8i Upgrade exam.

My address is mayank69@yahoo.com

Thanks very much.

[ngwh]

i juz passed my OCP oracle8i on perf&tuning..i remember qns asked were:
1)oracle stripe consideration depends on db_block_size and db_file_multi_read_count
2)what is the first thg for creating new resource that u'll do using resource_manager DBMS

that's all..
gd luck!!

[shravansam]

Thanks a lot padmam & ngwh

regards

saravanan.

[oracbase]

Hi, for this exam I recall there is only 1 question on Oracle Expert...so don't put too much effort on this.

Don't confuse between the different views for the different types of tuning. This is where the answers for the question gets you... with very similar view names.

Good Luck!

[kmadhu]

Hi
I have written the exam on lost saturday and passed 55 out of 57.

Don't put too much effort on Oracle expert.There was only one question.

Concentrate on Buffer cache,Library cache,dictionary cache,Redo log buffer tuning. Because these topics cover almost 40% of the exam.

Questions I remeber

1. Which one specify the daily usage of database to Oracle Expert
Ans : Workload class

2. Which parameters determine the no of shared server process in MTS ??

ans . PROCESSS
MTS_MAX_SERVERS
3.V$ROWCAHE is used for _____ ?
Tuning Data Dictionary

GOOD LUCK !

-Madhu

[dbatobe]

Hi kmadhu,

Could you pls tell the breakup of this test you took. is this for ocp 8i? how many question per chapters in real ocp?

my email is radar78@hotmail.com


thanks,
dbatobe

[kmadhu]

Hi Dbatobe,
Following is the breakup of Performance & Tuning.

Performance Tuning No.of questions(57)
--------------------------------------------------
No. of Questions to be Correct to Pass : 38
1 . Course Introduction (0)
2 . Tuning Overview (1)
3 . Oracle Alert and trace files (2)
4 . Utilities & Dynamic erformance Views (3)
5 . Tuning the Shared Pool (7)
6 . Tuning the Buffer Cache (7)
7 . Tuning the Redo Log Buffer (3)
8 . Database Configuratin and I/O issues (7)
9 . Using Oracle Block Efficiency (4)
10. Optimizing Sort Operations (4)
11. Tuning Rollback segments (4)
12. Monitoring and Detecting Lock Contention (5)
13. SQL Issues and Tuning Considerations for (5)
Different applications
14. Managing a Mixed Workload (2)
15. Tuning with Oracle Expert (1)
16. Multithreaded server Tuining Issues (2)

GOOD LUCK! for the exam.

-Madhu

[kmadhu]

Hi
Sorry, I forgot to mention.The above breakup is for Oracle 8i

-Madhu