How, Why and When to use Oracle SQL Trace

Attend this free training session and learn:

• How to enable SQL Trace, both at the command line and with a logon trigger
• How to trace by client identifier and service name
• The benefits of "extended" SQL Trace
• How to use the tkprof utility to format a raw trace file
• Why the raw trace can be useful
• How to read and interpret the tkprof report
• What to watch out for in the tkprof report, including the trigger trap
• SQL trace analysis tips, including an introduction into the Oracle wait events externalized in the SQL extended trace output

Your Instructor: Dave Anderson has more than 27 years of hands-on experience in the I.T. industry. His last 12 years have been spent working with Oracle - as a developer and administrator. Dave is also a frequent presenter at Oracle User Groups around the country.

Language: English

Recorded Sept. 10

On Demand!

View portions
of this recorded training in streaming Flash video

(Free Registration Required)

Effective Use of Oracle SQL Trace

Extended SQL Trace is one of the most effective diagnostic tools for Oracle. When done properly, tracing reveals exactly what calls a user session is making and eliminates guess work when addressing performance issues. This presentation focuses on real life experience with lightly documented issues and covers how to properly trace a user session, wait events, trace file architecture and how to read it, and summarizing session activity using profiling tools. We finish with several test cases demonstrating the usefulness of sql trace to diagnose session, sql, system and architecture issues.

Presenter: Daniel Fink specializes in Oracle performance diagnosis and optimization, monitoring and data recovery. He has been in IT for over 17 years, first as a Cobol programmer on the Vax VMS platform. In 1995, he transitioned to Oracle, first as a developer, then DBA...on DEC Alpha OpenVMS and Oracle Parallel Server 7.0.13. He has been both a development and production DBA (often at the same time). For the past 5 years, Daniel has focused on Oracle performance diagnosis and optimization. He has been a member of the Oak Table Network (www.oaktable.net) since 2004. Daniel has presented at conferences and user group meetings across the United States and Europe, including RMOUG Training Days, The Hotsos Symposium, IOUG-A Live!, UKOUG, Miracle dbForums in Denmark and Scotland.

Language: English

Recorded
June 27

On Demand!

View recorded training in streaming Flash video

(Free Registration Required)

SQL Injection: From the Basics to Botnet-Based Attack Automation

SQL Injection is an enormous emerging data security threat, used to commit wide-scale fraud, steal from bank accounts, capture credit card numbers, distribute malware, and construct botnets. Neil Daswani reviews how SQL Injection works, provides examples of advanced and automated SQL injection attacks, outlines how to properly defend against attacks, and discusses why you must defend against them — even if you don't store "sensitive" information in your databases.

Presenter: Neil Daswani has held R&D, teaching and managerial roles at Google, Stanford University, DoCoMo USA Labs, Yodlee, and Bellcore (now Telcordia). He is an expert in data security, and the lead author of "Foundations of Security: What Every Programmer Needs to Know."

Language: English

Presented June 19

n/a

Get Presentation
 
(Free Registration Required)

Oracle Database 11g Real Application Testing: SQL Performance Analyzer

This webinar focuses on Oracle Database 11g Real Application Testing's SQL Performance Analyzer component. Real Application Testing combines a workload capture & replay feature with an SQL performance analyzer to help you test changes against real-life workloads, then helps you fine-tune them before putting them into production.

Language: English

Recorded
May 22

On Demand!

View recorded training in streaming Flash video

(Free Registration Required)

This webinar focuses on the capabilities of Oracle Database 11g Real Application Testing's Database Replay component. Real Application Testing combines a workload capture & replay feature with an SQL performance analyzer to help you test changes against real-life workloads, then helps you fine-tune them before putting them into production.

Language: English

Presented April 11

n/a

Get Presentation
 
(Free Registration Required)

Find out how – beginning with Oracle 10g and growing more powerful in Oracle 11 – the new features of ASH (Active Session History) and AAS (Average Active Sessions) are more versitile and powerful than statspack. Learn more about ASH, a new paradigm in performance data, and AAS, the ultimate summary of ASH data. Kyle will also present examples of problem detection, analysis and resolution, as well as scripts to get the most out of ASH with the least amount of effort.

Language: English

Presenter: Kyle Hailey, ASH Master! Kyle recently helped Oracle redesign OEM to be wait-event centric and was the Technical Editor of the 5-Star Oracle Wait Event Tuning book by Richmond Shee.

Attend an online class with Kyle

June 4 (India Only)

June 5 (US and UK Only)

9AM (GMT+5.30)

4 PM BST, 11 AM EDT, 8 AM PDT

Register (India Only)

Register (US and UK Only)

This one hour presentation will provide the attendee with a basic understanding of the general Service Oriented Architecture (SOA) and its more specific manifestation as Web Services. Topics that Kevin will discuss include the SOA service provider/consumer model, the Web Service XML technology stack (WSDL, SOAP, and UDDI), coarse grained vs. fine grained transactions, web latency, and asynchronous transmissions.

Language: English

May 1
Thursday

1:00pm - 2:00pm EDT

Get Presentation

Free Registration Required

XML in Oracle

This 90-minute XML in Oracle presentation describes the primary features of Oracle10g Release 2 XML DB. XML DB is an Oracle product that provides high performance XML storage and retrieval capabilities. Data can be stored in XML tables, in columns of standard Oracle tables, in Oracle's XML Repository, or in XML documents stored external to the Oracle database. With XML DB, Oracle now combines the capabilities and advantages of Oracle relational databases with the capabilities and advantages of XML. Features such as the XMLType datatype, structured versus unstructured XML storage, schema registration, XQuery, and the XML Repository are described. Many code examples are shown to demonstrate these features.

Language: English

Recorded
May 28

On Demand!

View recorded training in streaming Flash video

(Free Registration Required)

An Introduction to Oracle Warehouse Builder

This presentation will provide a basic understanding of Oracle Warehouse Builder. The presentation will define the Extract, Transform, and Load process and specifically discuss Oracle Warehouse Builder. The presentation will provide an overview of the tool and how projects are created, how to import tables, what a mapping looks like and some basic transformations. Lastly, this presentation will discuss the advantages of Oracle Warehouse Builder over standard PL/SQL and its return on investment.

Language: English

Presented May 15

n/a

Get Presentation

Free Registration Required