Getting Creative with SQL Profiles and SPM

DBAs want control over SQL execution plans both proactively and reactively. In other words, DBAs want to be able to fix plans from the outset, repair a regression quickly or use a mixture of the two approaches. Tough-to-deliver service level requirements for critical systems can necessitate a strategic approach to constrain all execution plans, but often a more targeted and tactical technique is appropriate. The Oracle Database has a number of features to control and constrain SQL execution plans, but how are they used and what are the differences between them? What is the best choice for a given requirement? This session answers these questions and presents some creative ways in which to use the features at your disposal in the Oracle Database. The session covers Oracle Database 11g and on to Oracle Database Cloud Services (Oracle Database 12c Release 2).

Mittwoch, 31.05.2017
12:15 - 13:00
Düsseldorf 2+3
Datenbank Betrieb

Nigel Bayliss

Oracle Corporation UK

Weitere Vorträge, die Sie interessieren könnten

Root-Cause-Analyse nach "unable to extent temp segment"
Amsterdam 2
14:15 - 15:00
Peter Ramm
Oracle Infrastruktur up and runing mit Vagrant und Ansible
Düsseldorf 1
15:15 - 16:00
Natascha Karfich
Future of DB Management in the Era of Cloud and Big Data
Amsterdam 3
15:15 - 16:00
Mughees Minhas
Introduction to solving SQL problems with MATCH_RECOGNIZE
Amsterdam 3
16:15 - 17:00
Keith Laker
Erfahrungen mit Actifio Copy Data für HA, DR und DevOps
Düsseldorf 1
13:15 - 14:00
Marcel Pils