Tony Jambu is an Oracle professional with over 28 years Oracle experience specializing in database development and performance tuning. He regularly presents papers at Oracle conferences in Asia-Pacific, Europe and the Americas. Tony was awarded the "Oracle Consultant of the Year by Oracle Magazine for his knowledge and experience in Oracle technology. In addition, he was also awarded the title Oracle ACE by Oracle Corp for his technical contribution to the Oracle community. Tony was awarded the Oracle Consultant of the Year by Oracle Magazine for his knowledge and experience in Oracle technology. In addition he was also awarded the title Oracle ACE by Oracle Corp for his technical contribution to the Oracle community. Tony currently works for the National Australia Bank as a Data Analytics Manager.
Deep Dive Into Index Monitoring And Identifying Missing Indexes.
Having numerous indexes on a table can improve access performance but expansive to maintain and can be detrimental to DMLs against the table. As a developer or DBA, knowing which indexes are helpful and which are superfluous and can be ‘removed’, will not only improve performance but save space
Attendees will learn
• The difference between the ‘old’ Index Monitoring and Oracle 12c’s new Index Usage Tracking
• New features in Index Usage Tracking
• Identify unused or seldom used indexes
• More importantly, identifying with high certainty, missing performance indexes , Gotchas
Compression: Are There Performance Gains To Be Had?
Oracle RDBMS has various compression options, Basic, Advanced and HCC. But do you know if there are any performance gains to be had? Or are there any performance degradation?
In this presentation, we shall investigate the performance impact on
• Consistent gets
• CPU utilised
• Elapsed time
• Execution Plan
With turning on some of the above compression options on the following types of operations.
Consider the performance of
• OLTP inserts
• Batch/DW (Direct-Path) inserts
The performance figures are from a real world data base.