Deep Dive sessions from Oracle Guru "Arup" on DB Security , Indexes and Buffer cache in Cloud
#sangam18 #aioug #oracle
Sangam18 At A Glance
Sangam, the largest independent Oracle user’s group conference will feature over 150+ in-depth technical sessions presented by expert speakers from inside and outside of Oracle. Over 1000+ database administrators, developers and architects professionals are expected at the conference from December 7th-8th 2018 at The Oterra, Bengaluru. This is our moment of glory and time for you to join us !
Arup Nanda has been an Oracle DBA for over 20 years with experience spanning all aspects from Modeling to performance tuning and Exadata. He speaks frequently, has authored about 300 articles, co-authored 5 books, blogs at arup.blogspot.com and mentors new and seasoned DBAs.
Sessions
Database Security in a Single Day in the Cloud
This session attendees will learn some simple but highly effective steps they can implement in just one day that will eliminate a lot of vulnerability and make the database secure against
90% of the common attacks.
Should I Drop Indexes in Exadata Cloud
In this session you will learn what storage indexes are in Exadata, how they work (and don’t), how they work along with traditional indexes, how to gradually evaluate the effect of indexes instead of a sudden change, how to compensate for lack of indexes and read execution plans.
In this session you will learn how the blocks get into the buffer cache, what buffer cache chains are, how they are managed, how cache buffer chain latches are used and when they cause significant performance issue, how DBWR and
checkpoint processes work, what causes the buffers to be written back to the disk, the role of commits and rollbacks in buffer movement between buffer cache and disks and much more.