Presentation Title: Go Deep Into PL/SQL With low Level Toolkit - DTrace Style
Speaker: Mr Kamil Stawiarski OakTable Member ACE
Company: ORA-600 | Database Whisperers
Co-presenter: 
Presentation abstract: Sometimes when I’m trying to learn something from the Oracle documentation I get the feeling that something is not exactly OK.

I don’t understand why PL/SQL packages are faster, based on this explanation: „Subsequent invocations of other subprograms in same the package require no disk I/O.”

„The UDF pragma tells the compiler that the PL/SQL unit is a user defined function that is used primarily in SQL statements, which might improve its performance.” - Yes, ok…. but why! When? How?

I've heard that cursor FOR loops are being optimized from 10g and converted to BULK COLLECTS… Is it true? Can see it somewhere?

What is the real meaning for cursor sharing and is it true that SQL statements executed from PL/SQL are parsed differently?

So many questions, so little beer… fortunately we have low level tools like DTrace!

Presentation begins: 03/12/2017 14:40
Presentation duration: 50
Presentation content level: 2 (1 = indepth, 5 = strategic overview)
Audience experience: All Experience Levels
Audience function: Oracle, Partner, Product Expert, Product User
Speaker biography: Oracle Database Whisperer, performance maker and story teller. At the moment probably one of the youngest Oracle ACEs and Oracle Certified Masters in the world. Owner of the ORA-600 company and blogger (blog.ora-600.pl). Trainer in Oracle Partner Academy and IT School. Personally a big fan of Terry Pratchett: "Wisdom comes from experience. Experience is often a result of lack of wisdom."
Related topics: Database: 12c Database, Database: Management & Administration, Database: Performance & Internals
Hall: Hall 7A

Top