Handling application performance degradation – especially when an RDBMS as complex as Oracle Database 12cR2 underlies the application – can be a complex, time-consuming, frustrating task. Via actual use cases, stories of painful discoveries, and of course some hard-core metrics, this session will take a look at some of the simplest mistakes even an Oracle DBA can make when probing application performance issues and how to overcome one’s own blind spots when searching for the true root causes of that degradation.
You’re an Oracle DBA whose CIO has at last agreed to embrace the Oracle Public Cloud (OPC) and now you’re ready to begin your journey. But now you face another difficult task: choosing from an almost dizzying array of options as you start your trek to building your first 12cR2 database in the OPC.
This session will give you some much-needed practical advice using an actual example of implementing an application performance evaluation environment using Swingbench’s TPCDS model to compare the original Oracle Database as a Service (DBAAS) – aka the Database Schema Service – versus its latest and greatest incarnation, Exadata Express and even the newest “bare metal” OPC options so that you can choose wisely, begin your OPC trek, and never regret your decision.
Oracle Database 126.96.36.199 (12cR2) significantly improves the performance of Database In-Memory (DBIM) features, offering potentially massive improvements in real-time analytic processing and queries This session takes a deeper look at what the Oracle 12cR2 optimizer is actually doing “under the covers” when it makes its decisions to process a query against IMCS-resident and non-resident tables, including improved In-Memory Joins, leveraging Join Groups, taking advantage of In-Memory Expressions, and utilizing In-Memory Filtering effectively. We’ll look at some real-world performance improvement metrics obtained against an Exadata Express OPC environment that shows how best to tackle using these newest DBIM features.
Oracle Database 12c is the first release to offer the capability to access a file in HDFS or HIVE format as an EXTERNAL table. Through live and recorded demonstrations, this session will explain how an Oracle DBA can leverage these new features to gather data in tabular format from these file formats while leveraging the best tool ever designed to filter, sort, aggregate, and report information: Structured Query Language.
Almost every modern IT organization has struggled with the best place to locate crucial application code bases -inside the application server layer, or inside the database itself? The good news is that Oracle Database 12c has helped push the argument towards locating the majority of application code within the database through several key feature sets, including Edition-Based Redefinition (EBR) and PL/SQL enhancements like [add]. This session will offer several practical examples of how any Oracle DBA can build a case for and then implement the best practices of the ThickDB paradigm within their organization while making their application developer colleagues happier than ever.