Oracle11g introduced very important new features that all together guarantee execution plan stability. In this session we will discuss SQL Plan Management, extended statistics and new bind-aware cursor matching which resolve majority of the problems with execution plan instability.

Detalji o predavanju

Vrsta: Predavanje / Lecture

Razina težine: Srednje detaljno / Detailed

Poželjno iskustvo slušatelja: Iskusni (2-3 g.) / Experianced

Poželjna funkcija slušatelja:
DBA
Developer
Menadžer - operativni / Manager - Operational

Predviđeno vrijeme trajanja rada - aktivnosti: 60 min

401_Senegacnik.pdf 330,80 kB

O predavaču

Execution Plan Stability in Oracle11g

Jože Senegačnik

Senegačnik Jože - Raziskovanje v naravoslovju

Jože Senegačnik has 20+ years experience in working with Oracle products. He started in 1988 to work with Oracle version 4. He is an international speaker, DBA and performance tuning specialist. For many years he is a member of the Slovenian Oracle Users Group (SIOUG) board. He is a regular speaker in all importrant Oracle Users Group events worldwide and also on Hotsos Symposium. He is also a member of highly respected OakTable Network.