Shulou(Shulou.com)06/01 Report--

I took the 11G OCM exam in late December 2017 and received an email from ORACLE to pass the exam in mid-January 2018.

Thank my family for their support and dedication.

Thanks to Mr. Zhao, Mr. Han, Mr. Huang from the School of continuing Education of Shanghai Jiaotong University, and all the partners who prepared for the exam together, because of their efforts, mutual encouragement and mutual support.

Enrichment, tiredness, calmness, apprehension and emptiness are the five stages of the OCM examination, namely, the enrichment of what you have learned during the training, the tiredness of practice before the exam, the calmness of the examination, the apprehension of looking forward to the results after the examination, and the emptiness after the results come out.

Does not mean that other OCMER also think so, I am a relatively stupid person's personal perception: the OCM exam is the physical strength, willpower, generally speaking, the examination is not difficult, mainly because there are many questions and short time, we must do more experiments to make perfect. The calmness in the examination room comes from the great effort of physical strength before the exam. at the beginning, the individual also did the experiment according to the simulated questions step by step, brushing the questions over and over again, until he was able to finish the test 10-40 minutes ahead of time. From preparing for the exam to the end of the exam, it took 3 months, with an average of at least 4 hours a day doing experiments, and the previously obscure abdominal muscles were transformed into clear six-piece specifications. I remember brushing to the sixth time, there was a time when I wanted to throw up when I saw the topic, and I completely lost interest in ORACLE, especially one day on a weekend from 8am to 11:00 in the evening, after I finished 9 simulation questions, I felt that I was seriously overstretched and I couldn't hold on to 20 push-ups. Fortunately, there was a group of friends who prepared for the exam together, and we encouraged and supported each other, all of which slowly persisted. In the process of looking forward to the exam results, although I feel that I don't have a big problem, I still have inexplicable fear occasionally. If I don't pass, do I still have enough strength for the next exam? When the mobile phone prompt tone jumped out, after seeing the results, there was not too much excitement, silently closed the email, picked up the bowl and continued to eat, sat for a while after eating, felt deeply empty, and suddenly did not know where the next goal was. Passing the OCM exam is not an achievement, but a note of so many years of DBA career. I have to go back to pick up my interest in ORACLE and find those lost branches.

Tell me briefly about the details from the training to the end of the exam.

The choice of training institutions

When I chose the OCM examination and training institution, I not only valued the passing rate, but also looked at the level of the teachers. The purpose of participating in the training was to really learn something.

I chose Shanghai Jiaotong University entirely because I knew that the teacher was Mr. Han. I personally thought that there was no one of the lowest-key gods in the domestic ORACLE industry. Author of "selected cases of Oracle Database Technical Service" and "practical explanation of ORACLE Database Technology: teaching you how to be 10g OCP". During the training course, which began in June 2017 and ended in September 2017, individuals gained a lot, especially in terms of optimization. Many previously unclear areas were suddenly enlightened after being explained by teachers and combined with official documents.

The practice process of simulated questions before the examination

Of course, even if a real master goes to take the OCM exam without any preparation, the probability of passing the exam is still very low, and preparing for the test questions is a necessary link. OCM test simulation questions can refer to the website of a Spanish master, http://www.dbajunior.com/ocm/, which covers 85% of the content of the exam, and 60% of the questions are familiar with those of the personal experience exam.

After the end of the National Day in October 2017, individuals began to brush simulation questions. Because they were busy at work during the day, they practiced from 7 o'clock to 11:00 every night on weekdays, and practiced all day on weekends. Nine courses practiced, the first time took a month, the second time took half a month, the third time took a week, the fourth time began to practice with reference to the time specified in the exam, and it was December by the eighth time. Almost every question can be completed 20 minutes ahead of schedule at a specified time. When the real exam is approaching, you will know the answer when you see the question. When your brain is still thinking about how to write this command, your hand has been habitually tapped on the keyboard. Of course, this process is painful, just as I realized, it is difficult to achieve this state without sufficient physical strength and firm willpower.

The process of entering the examination room calmly

The day before the exam, I wanted to relax but couldn't put it down at all. I went to the examination room early to check the environment. The test was at the Shanghai ORACLE Center on the 12th floor of Henderson Celebrity Commercial Building at exit 5 of Nanjing East Road Metro Station. After returning home, I took a hot bath in the bathroom for a whole hour.

The exam began at 9:00 in the morning. Basically, everyone arrived at the examination room 15 minutes in advance. After the invigilator explained the test instructions, and after everyone finished checking the mouse and keyboard, the invigilator began to do exercises. The formal exam began at about 9:15. I was nervous at first, but when I opened the web page and finished the first question with reference to the questions on the web page, I was not nervous at all. For the six people in the examination room, the only thing I could hear during the whole examination was the crackling sound of tapping on the keyboard. I felt that everyone was sure. After all, I was not sure and dared to enter the examination room. I didn't hear who didn't finish the questions in the nine exams. Someone finished the data management of the third exam 40 minutes ahead of schedule, and after talking to the monitoring teacher, I ran out to have a rest. The process of 9 examinations was very smooth. Of course, individuals also encountered some problems during the examination, and encountered several unsuccessful situations. For example, in the fifth performance optimization, there was a question about result_cache. At that time, three methods were used: alter table result_cache (mode force), alter session set result_cache_mode=auto, prompt / * + result_cache * / and then execute the SQL statement. There is still no record in the v$result_cache_objects view. It took about 10 minutes, and then I gave up and went on to do the following questions. After 9 exams, I felt that 80% of the correct rate was still there. Generally speaking, there are no particularly difficult questions in the exam, and 60% of the questions will be encountered in the work scene. Basically, such as DATAGUARD has been used very skillfully. The main difficulties are the large amount of questions for the fourth session _ data warehouse and the fifth session _ performance optimization for a long time, high proficiency requirements, and fast typing speed, otherwise the questions may not be finished.

Introduction of examination sequence and time

The first morning

130 minutes of database management

The first afternoon

Backup recovery for 40 minutes

85 minutes of data management

Data warehouse 110 minutes

The next morning

Performance optimization for 90 minutes

Grid control 50 minutes

The next afternoon

Data guard 60 minutes

GI 60 minutes

RAC 50 minutes

Exam environment and situational introduction

1, six seats are divided into two rows, each seat is about 1 meter apart, others can not touch your power cord, the power cord has also been fixed by the fixed board, unless pulled out by force, ordinary touch does not have any impact, see the forum before someone experienced the power cord was encountered what the situation, we did not see this exam, ORACLE may also be improving to reduce the impact of these off-site factors on the exam.

2. At that time, there were six people in the examination room. After everyone came in, we sat casually. The last one who came in took the last remaining seat. After sitting, we could not change seats until the end of the exam. If you want to take a seat of your choice, you'd better be the first to wait at the door before the first exam. Of course, I also heard that sometimes the invigilator will specify everyone's seat.

3. The examination machine is two physical machines, both are linux operating system, and the boot is the desktop environment of linux. The machines are all new machines with good performance. In terms of memory, the personal DATABASE SERVER machine is 3G database MANAGEMENT SERVER machine is 2G, the mouse and keyboard are also new, and the machine is a small chassis that is standing and fixed on both sides of the table. It is very hard to touch, so you don't have to worry about your legs touching it. Before I saw the forum, someone said that the machine memory was 32 gigabytes, which was incredible, because the OS of the exam environment was 32 bits, and more than 4 gigabytes of memory was wasted.

4. 15% of the disk space required on the DATABASE SERVER is far from needed, so feel free to use it.

5. GI and RAC exams, which provide virtual machines that can be connected through VNC on DATABASE SERVER machines. This set of virtual machines provides root users

6. The official document of DB is on the DATABASE SERVER machine, and the official document of GI is on the DATABASE MANAGEMENT SERVER machine, which can be opened through firefox.

7. after explaining to the teacher during the exam, you can go out to drink water and go to the toilet. The bag can be brought into the examination room, but the mobile phone can not be taken out.

8. There is only one monitoring teacher in the whole examination environment, and there is no legendary camera.

9. There is no legendary milk tea, coffee, bread and fruit in the examination room, nor does it serve lunch. They all go out at noon to solve the problem.

The examination time starts at 9:00 in the morning and 13:00 in the afternoon

Life is going through exams one by one! Let you wake up in the exam and grow up in the exam!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.