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

Optimizing SQL is a laborious technical task, constantly analyzing execution plans, adding hint, indexing, analyzing statistics, and so on. Don't worry, you're not fighting alone. Starting with 10g, Oracle launched its own SQL optimization aid: the SQL optimizer (SQL Tuning Advisor: STA)-- the DBMS_SQLTUNE package. SQLTXPLAIN (SQLT) is a SQL performance diagnosis and tuning tool provided by Oracle Server Technologies Center of Expertise-ST CoE. These artifacts are worth having.

This online open course is lectured by Hu Yi, a gold medal OCM lecturer at CUUG. Mr. Hu is proficient in using various management and configuration tools from Oracle9i-Oracle11g, has rich experience in database engineering projects, has been responsible for Oracle database maintenance in a financial IT service company, and has experience in database deployment and implementation of large-scale projects.

The content of every online course in CUUG comes from the careful preparation and arrangement of the teacher, and the topic is unique each time, which provides a great help for everyone to learn Oracle knowledge deeply. Students who listen to the course online can not only ask questions and interact with each other, but also have immediate access to the learning documents and PPT of this course. Free on-site participation, after-class video will be paid to watch, please cherish only one free opportunity to sign up. Friends who are interested in Oracle and want to experience CUUG distance courses are welcome to sign up.

Can't you get into the online open course? Click the novice guide illustration → http://www.51CTO to remind you, do not spam ads! / jishushalong/gongkaike/201204/zhinan-1218.html

Course content:

1. Using SQL Tuning Advisor: STA to diagnose and optimize problem SQL.

2. Using SQLT to diagnose and optimize the problem SQL

See group sharing for courseware download: 273684597

Speaker: Mr. Hu Yi, lecturer of CUUG oracle

Speaker qualification: Oracle 10g OCP, OCM

Course time: 20:00 on Friday, June 6, deadline for registration: 18:00 on June 6

Course website and password: please sign up for free and attend for free

Venue: Cisco online meeting system is used to teach online. If you have a network, you can listen to the class.

Registration method: send your name and phone number to signup@51CTO to remind you, do not spam ads! Can

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.