Presentation Title: All About Table Locks: DML, DDL, Foreign Key, Online Operations,...
Speaker: Mr Franck Pachot Oracle ACE OCM
Company: DBi Services
Presentation abstract: Oracle locking behavior is changing at each release. Do you know exactly what is locked when you do an online or offline DDL? Do you know when and why you need to index foreign keys? Do you know the meaning of the lock modes (RS,RX,S,SRX,X)? Do you think that 12c has new features about it? We will explain all that with demos.
Presentation begins: 07/12/2015 12:20
Presentation duration: 50
Presentation content level: 1 (1 = indepth, 5 = strategic overview)
Audience experience: Intermediate
Audience function: Product Expert, Product User
Speaker biography:  Franck Pachot is senior consultant at dbi services in Switzerland. He has 20 years of experience in Oracle databases, all areas from development, data modeling, performance, administration, and training. Oracle Certified Master and Oracle ACE, he tries to leverage knowledge sharing in forums, publications, presentations.
Related topics: Database: Performance & Internals, Database: SQL and PL/SQL
Hall: Hall 11A

P-ORA-20151002-001-OracleLocks.pdf714 KB03/11/2015 19:21:51