Aiti Tribe Stories (13): Playing to one's strengths and avoiding one's weaknesses to enter the Oracle development industry

[51CTO.com original article] "Others laugh at me for being too crazy, but I laugh at how others can tell that?" The motto of a joke teller who was delayed by databases is surprisingly humorous. Before introducing Fatty's profession, let's first get to know him. You may not believe that Fatty is a programmer, and a calm and composed database engineer. Fatty's hobbies are fiercely competitive blue football, hiking, talk shows, and writing videos. Such an extrovert has almost nothing to do with the label of a programmer.

[[186571]]

Fatty·Oracle Database Development

Taking Advantage of Strengths and Avoiding Weaknesses, and Becoming Connected with Oracle Development

If he had not chosen software engineering as his major in college (a major that Fatty knew nothing about before college), perhaps he would now be working in the talk show industry like Chi Zi and Li Dan, or performing in various venues like Xiao Shenyang and Song Xiaobao.

In the first year of college, Fatty didn't learn anything, resulting in him failing 4 subjects at the end of the semester, including a professional course. At that time, he had reached a low point in his studies and once doubted his original choice. He wanted to change his major, but when he thought about changing his major, he would have to start from scratch. He had studied this industry for at least a year, so why start from scratch again? In fact, everyone wants to succeed, so why not push yourself once? From then on, he reviewed and previewed every day, and asked his classmates, and finally got a little bit of a foothold. In particular, he discovered the database course. When everyone was not interested or felt it was difficult, he found that he actually fell in love with it, and it felt very simple. Junior year was when the major began to be determined. Fatty was still a novice in programming (still didn't understand the three major frameworks of Java), and the head teacher who taught database specifically suggested that he learn Oracle database. Because databases don't use Java codes, and avoid Java, C++, and other patterns. To give full play to his professional strengths, Fatty followed the teacher's advice and signed up for an Oracle training class. In this way, he studied Oracle very easily and happily for 4 months and obtained the OCP certificate. Although he is still a novice in programming, he is an intermediate in database, especially Oracle database. At least he will have a meal after graduation and will not have to rely on his parents.

Oracle's bumpy development road

Fatty searched for social recruitment for more than a month and finally found a good job in the first semester of his senior year. But soon after he joined the company, he suffered a setback. The first time he went on a business trip with his team leader to the client site, he found that he knew nothing and the knowledge he learned in college and training institutions was of no use at all. He could only stand behind the team leader every day and watch the team leader develop. In two days, he felt like two years had passed. After the business trip, he returned to the company. In order not to repeat the same situation again, Fatty used his off-get off work time to study every day and slept only 5 hours a day. He left messages on various technology-related forums and websites such as ITPUB and 51CTO to learn. His skills in Linux shell script writing, Java development, and Oracle management and operation have improved a lot. Finally, he had the opportunity to go on a business trip for the second time. Fatty went to the client site alone to solve the problem of slow database data upload. Although he passed the test in the company, there were still many emergencies at the client site.

The problem that Fatty remembers most is that he changed the Oracle database memory parameter to 80% of the machine system (the machine memory is 16G, and he originally planned to change it to 12G). As a result, the database could not be started after the modification. After checking, he found that the Oracle memory parameter of the 32-bit operating system cannot exceed 1.7G. He used 64-bit system before and did not pay attention to this problem at all. In addition, his technology was not proficient, so he could only ask for help from his former teacher. Fatty used the database parameter file to change the Oracle memory to 1.7G, but the problem of slow data transmission was still not solved. He started to optimize from the SQL statements used in the software code (80% of the slow database problems are caused by SQL). Using the AWR report to find the top 5 SQL statements, we found that there was delete from table1; and changed it to TRUNCATE TABLE table1; (both delete statements are DML statements, and the operation will be placed in the rollback segment, but TRUNCATE will not. Too many delete statements will generate a lot of fragments, and the high watermark will remain in its original position. TRUNCATE will reset the high watermark (back to the beginning), which is the essential difference between it and delete.) The speed is a little faster than before, but it has not yet achieved the expected effect. The database environment was installed by a Java programmer, so Fatty decided to start with the Oracle database. First, he turned off the archive log switch, then modified the online log file size, and finally modified the temporary table space size. After several modifications, the speed finally met the customer's requirements.

Because the database optimization was done on the weekend, there was time to solve any problems, and there were many database experts helping him, so the database slowness problem was solved. Although Fatty had tested it many times in the company, it was still not as good as real-life operation on site. In such a high-pressure environment, people's stress resistance and ability will be brought into play, at least Fatty did.

Oracle's choice and influence on newcomers

If a person wants to succeed, he must use his strengths to work and avoid his weaknesses.

Oracle database has a market share of more than 60%, and the system is mature. There are many places to find various learning materials and problem answers. The most important thing is that the treatment and respect of the database industry are the best in the industry. As the leading software vendor in the market, Fatty has also been captured by it.

Databases are divided into development, management, and operation and maintenance. For a rookie like Fatty, development is the easiest to get started with and the fastest growing. Although the salary is still relatively low, the work content and intensity will be much easier than other programmers (Java engineers, test engineers), but the salary is the same as theirs (why is it so annoying?). When he first came into contact with Oracle, he found that Oracle was very simple (compared to Java, C++ and other programming). After really getting into it, he found that it was very large. Only by constantly learning the core of the database can you truly master it and not be abandoned by this industry. And after you really learn it, there will be many directions to choose from, no longer limited to Oracle development, operation and maintenance, and management. You can choose the currently popular big data, cloud computing, etc., and you will have more advantages than other positions (C++\Android\ios engineers, etc.).

At present, most of the databases used by domestic enterprises and institutions are Oracle 10g and 11g databases. This is another challenging opportunity for Oracle practitioners. In this era of big data, enterprises are faced with the bottleneck of Oracle database upgrade or migration, and most enterprises do not have a full-time DBA team or position. For you who are confused in the workplace, it will be another opportunity.

If you are also willing to share your story, please join the 51CTO developer QQ exchange group 312724475 and contact the group owner. We look forward to your wonderful story!

[51CTO original article, please indicate the original author and source as 51CTO.com when reprinting on partner sites]