Get kicked tribal Story (13): Develop your weaknesses in Oracle

"Others laugh at me too crazy, I laugh at how others see it?" The motto of a jiangzi that was delayed by the database was a humorous one. Before introducing the fat job, you know who he is, and you may not believe that Fat Man is a program ape, and a cool-headed, mind-cold database engineer. Fat peacetime hobby is the fierce confrontation of the blue football, like hiking, like talk show to talk about jokes, like the writers video. There is little connection between the outgoing person and the program's tag for the ape Siege Lion.

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/8F/25/wKioL1jU3w3isipAAABbEA-I4iY700.jpg-wh_651x-s_ 4044338935.jpg "border=" 0 "alt=" Fat Oracle Database Development "title=" Fat Oracle Database Development "style=" border:none; "/>

Fat Oracle Database Development

Develop your strengths with Oracle

If it wasn't for the university to choose a software engineering major (the one that didn't know anything before Fat University), perhaps he would now be in the talk show industry like a pond Li, or run a variety of fields like little Shenyang Song.

In the first year of college, Fat didn't learn anything, leading to 4 subjects, including a specialized course. At that time, he had gone to the academic trough, once doubted the original choice. He had wanted to change majors, but the thought of changing majors is also from the beginning to learn, the industry at least a year, why do you start from the beginning? In fact, anyone wants to succeed, why not force themselves once? From then on, he will review every day, preview, pull the classmate asked, finally calculate a bit of introduction. In particular, he found the database of the course, when everyone is not interested or feel difficult, he found that he fell in love with it, and feel very simple. Junior is a professional beginning to set the direction of the time, for programming, FAT or rookie (until now still do not understand the three main framework of Java), the teaching database of the class teacher specifically proposed him to learn Oracle database. Because the database does not use Java code, avoid Java, C + + those patterns and other things. Play professional director, Fat followed the teacher's advice, enroll in Oracle training course. So he was very relaxed and happy. He studied Oracle for 4 months and obtained the OCP certificate. Although it is a novice in programming, but in the database, especially Oracle database, he is intermediate. At least the graduation has the mouth to eat, does not have to chew the old clan.

Oracle Bumpy Development Road

Fat ran a one-month social recruitment, finally in the senior year to find a good job. But soon after he got into the job, he went through a blow. The first and the team leader on a business trip to the customer site, the result he found nothing, in the university and training institutions to learn the knowledge at all. Can only stand on the back of the team leader every day, looking at the team leader development. Two days, he felt for two years. The end of the business trip back to the company, in order to no longer appear the first scene, Fat daily use off-hours study, almost every day sleep only 5 hours. Itpub, 51CTO and other technology-related forum websites have message learning, the writing of Linux shell scripts, Java Development, Oracle Management operations have improved a lot. Finally ushered in the second opportunity to travel, fat alone came to the customer site to solve the problem of slow database data upload. Although he was tested in the company, there are many unexpected situations on the customer site.

The most impressive problem for fat man is that he modified the Oracle database memory parameter to 80% of the machine system (machine memory is 16G, this is intended to be modified to 12G), and the result is that the database cannot be started. After checking, he found that 32bit of operating system Oracle memory parameters cannot exceed 1.7G. And he used to be 64bit system, did not pay attention to this problem. In addition to his skill is not skilled, can only turn to the former teacher, the last Fat man use the database parameter file to modify Oracle memory to 1.7G, but the problem of slow data transmission is still unresolved. He begins by using the SQL statement from the software code to start the optimization (database slowness problem 80% is SQL-induced). Using the AWR report to find the top 5 SQL statement, found that there is a delete from table1, modify it to truncate TABLE table1, (also delete the table, delete belongs to the DML statement, the operation will be placed in the rollback segment, TRUNCATE will not , the delete will produce a lot of fragments as long as the high waterline (higher Watermark) remains in its original position, truncate will reset the high watermark (back to the beginning), which is the essential difference from the delete, which is a little faster than before, but it has not yet achieved the desired effect. The database environment is installed by the Java programmer, so fat decided to start from the Oracle database, first stop the archive log switch, and then modify the online log file size, and finally modified the size of the temporary table space, after several modifications, finally speed reached the customer's requirements.

Because tuning the database is over the weekend, there are problems that can be resolved over time, and there are a lot of databases where the great God is helping him, and the database slowness problem is solved. Although fat has been tested many times in the company, it is not as good as the actual operation at the scene. In such a stressful environment, people's stress resistance and ability will play out, at least the fat is the case.

Oracle's Choice and impact on first-entry professionals

If a person wants to succeed, must be to play their own merits to work, to avoid their shortcomings.

Oracle database market share has reached more than 60%, the system is also mature, a variety of learning materials, problem solving are many places to find. The most important thing is that the database industry has the highest level of treatment and respect in the industry as a whole. As the market's leading software provider, Fat was also captured by it.

Database is divided into development, management, operation and maintenance. For fat people who have just started, the development is the easiest to get started, but also the fastest growing. Although the salary is relatively small, but the content and intensity of work than other programmers (Java Engineers, test engineers) a lot easier, and wages are the same (why so irritating). When he first approached Oracle, he found that Oracle was very simple (as opposed to programming in Java, C + +, etc.), and then discovered that it was huge when it actually entered. Only constantly to learn the core of the database, to truly harness it, will not be abandoned by this industry. And after really learning, there will be many directions to choose, no longer limited to Oracle development, operations, management of these. You can choose to get to the current big data, cloud computing and so on, you will be more than other positions (c++\ Android \ios and other engineers) more advantages.

Most of the current domestic enterprise business database is Oracle 10g and 11g database. This is also an opportunity for Oracle practitioners to challenge. In this era of big data, companies are facing bottlenecks in Oracle database upgrades or migrations, and most businesses don't have dedicated DBA teams or posts. For the workplace confused you, will be another opportunity.

If you are willing to share your story, please add 51CTO Developer QQ Exchange Group 312724475 Contact Group master Xiao Guan, look forward to your wonderful story!

Get kicked tribal Story (13): Develop your weaknesses in Oracle