Personal Information
Organization / Workplace
Campinas Area, Brazil, Sao Paulo Brazil
Occupation
Oracle 10g/11g SQL Tuning - PostGraduate Teacher
Industry
Technology / Software / Internet
About
Present the best practices, tips and concepts to optimize(tune) the SQLs applications performance using Oracle Database 10G and 11G ;
Present the best practices in data modeling and database's project that can influence the performance of data access in OLTP and OLAP environments;
Present how to Identify and fix bad performing of SQL;
Presente how to trace an application problems through its different levels of the application architecture, using Sql Trace, Tkprof and Trcsess;
Present how the Query Optimizer makes Decisions about how to access data;
Define how optimizer statistics Affect the performance of SQL;
Present the possible access data methods, including different join method...
Contact Details
Users following Marcos Santos