** The Engineered Systems track at COLLABORATE 14 is sponsored by Enkitec. **
Thriving and Surviving Through the Big Data Revolution
Guy Harrison, Dell Software
Big Data offers many opportunities for large enterprises to improve competitiveness and to create new, data-driven products. And it offers significant opportunities for IT professional career growth. But these opportunities to not come without risks for the individual and organization. Big data is potentially transformative for some industries and those that cannot or will not adapt may face extinction. Furthermore, big data projects are inherently ground breaking and while many will prevail and lead to fame and glory for the big data pioneer, others will suffer ignominious defeat.
In this presentation we'll look at the market forces driving big data, drill into the key technologies available to power a big data project and outline the attribute that allow big data projects to succeed. \
After assessing the business imperatives that are driving big data projects we will survey the big data technology landscape which includes technologies such as the Hadoop ecosystem, Exadata, Machine Learning, collective intelligence and predictive analytics. We'll conclude with recommendations on how to optimize your big data project, career and architectures.
12c Multi-Tenancy and Exadata IORM: An Ideal Cloud Based Resource Management
Fahd Chughtai, Pythian
Cloud database enables administrators to scale up and down the resource usage according to the business requirements. Oracle 12c renders multi-tenancy to manage multiple pluggable databases within a multi-tenant container database. In an Exadata, at the compute nodes, the resource manager controls the resources among pluggable databases, and all this resource management is trickled down to the storage servers, where IORM controls the resources. This presentation lucidly explains as how a business can leverage the benefits of 12c multi-tenancy, DBRM, and IORM in an Exadata realm to have an ideal cloud based resource management.
Using Flash SSD to Optmize Oracle Database Performance
Guy Harrison, Dell Software
While SSD may be too expensive to replace your entire database disk, judicial use of SSD in combination with magnetic disk can be a very cost effective way of accelerating Oracle database performance.
This presentation will consider how best to use SSD in an Oracle database to get the most bang for your SSD buck. You'll see examples of configuring SSD:
As part of the database flash cache
To improve IO for selected tables or partitions
As part of a temporary tablespace to improve disk sort performance
To accelerate redo log IO
In Exadata smart flash cache and Exadata smart flash logging
Finally, we'll review technological advances in SSD and server including transparent device caching and SSD caching in storage appliances
Accelerate Enterprise Database as a Service (DBaaS) with Oracle Exadata
Tim Moone, Oracle
Learn how Oracle Exadata in conjunction with Oracle Database 12c and Oracle Enterprise Manager 12c can help accelerate your move to a new model of database administration - enterprise Database as a Service. Hear how Oracle's approach to Enterprise Database-as-a-Service allows you to consolidates and virtualizes hardware and software to dramatically reduce management and costs, increases simplicity, standardization, and agility to databases in the enterprise, and improves performance, availability and security while ensuring QoS for mixed workloads.
Accelerate Your Exadata Deployment with the Skills You Already Have
Marc Fielding, Pythian
Exadata presents a new set of concepts---InfiniBand, storage servers, CellCLI, bundle patches, and others---that can be overwhelming for Oracle DBAs, yet Oracle Exadata still runs Oracle Database software and makes heavy use of well-known Oracle Real Application Clusters (Oracle RAC) technology and Oracle Database's Oracle Automatic Storage Management feature. Beginning with Oracle Exadata's architecture, this presentation shows where traditional database, storage, network, and operating concepts are in use. It moves on to discuss Exadata's secret sauce and the skills DBAs need in order to make the best use of it.
Certifying Application Performance on Exadata - A Real-World Case Study
Gaja Vaidyanatha, Dbperfman LLC
Seems like yesterday, but Oracle Exadata is almost 4 years old. In its time, it has evolved as the preferred and quintessential database solution for large mission-critical Oracle systems and database consolidation efforts. This 2-hour talk shares all relevant technical information pertaining to an application performance certification effort, performed for an ERP application suite on an Exadata X2 system. The presentation will delve deep into the details of the setup and configuration of the Exadata system, including but not limited to Oracle initialization parameters, storage layout, partitioning, parallelism, low-level application traces, relevant WebLogic configuration details and Oracle*Net optimizations. Bottom line -- All technical decisions need to driven by mathematical data not expert opinions.
Exadata & Exalytics Integration for Fast Analytics and Optimized Data Warehouse
Satyendra Pasalapudi, Apps Associates
Learn how customers can leverage the software and hardware features of Engineered Systems(Exadata & Exalytics) to achieve performance gains by applying these to their existing data warehouse and business intelligence environment. The presentation will detail the below points on how Oracle's offerings complement each other and provide real-world lessons learned when implementing these engineered systems together. *High-Speed InfiniBand *Oracle Exalytics for Analyzing vast datasets held in relational and OLAP databases through in-memory aggregates and InfiniBand connection to Exadata. *Using DBFS in the Exadata Storage Servers for ETL *EHCC & In-Memory Columnar Compression *Parallel Essbase, Parallel TimesTen Database, In Memory Analytical Functions. Run through some workloads running on Exalytics Box
Exadata 101 -- What You Need to Know
Rich Niemiec, ROLTA
This presentation will teach you the basics of Exadata & other Engineered Systems from a beginner's perspective, with experiences and examples that are intermediate level. It will go over the advantages of using this hardware and how the hardware components provide the speed that you'll realize implementing it.
We will cover the following topics:
Terminology & the Basics about Exadata (X2-2 & X2-8 & X3)
Hybrid Columnar Compression (HCC)
Enterprise Manager & Grid Control
Enterprise Manager Exadata Simulation
I/O Resource Manager (IORM)
Exalogic, ODA, Exalytics, SuperCluster, & other Hardware
Exadata Deep Dive
Mahesh Subramaniam, Oracle
Take a plunge into the technical details of Oracle Exadata. After this session, you will understand what has been done to enhance and extend the Oracle Exadata system, database architecture, and functionality and how to take maximum advantage of these new capabilities. The presentation examines in detail the Oracle Exadata hardware and software architecture, Oracle Database extensions for Oracle Exadata, I/O resource management, and the Exadata Smart Scan and Exadata Smart Flash Cache features of Oracle Exadata.
My First 100 Days With an Exadata
Gustavo Antunez, The Pythian Group
The biggest headine at the 2009 Oracle OpenWorld was when Larry Ellison announced that Oracle was entering the hardware business with a pre-built database machine, engineered by Oracle. Since then businesses around the world have started to use these engineered systems. This beginner/intermediate-level session will take you through my first 100 days of starting to administer an Exadata machine and all the roadblocks and all the success I had along this new path.
Oracle Engineered Systems for Databases: How to Choose the Right One for Your Database
Kirby McCord, U.S. Cellular
When Exadata was originally released, that was the only option for dba's to run databases on. Now, the dba has many engineered solutions (Exadata, Sparc SuperCluster, ODA, OVCA) to run on with different options for backups (Exadata Storage Expansion, ZFS, Backup Appliance). This presentation will talk about the options available and provide information on how to decide which option is best.
RAC to Exadata: Migration Approaches, List of Don'ts, Pre/Post Validations and Tips
The session starts with the pre requisites and scope. It brings awareness to the common practices from pre to post migration. Pre migration highlights on employing exadata configuration automation, and ensuring s/w compatibility among different components. Migration focuses on optimal ASM configurations, and choosing the right strategy with either logical or physical. Post migration enables the dba to evaluate the index and rebalancing requirements. It reports the list of Don'ts and validation scripts to avoid migration failures and performance issues with a production implementation at Verizon wireless from 4 nodes RAC to Full Exadata. It also provides few tips on preparing the RAC setup to be ready for a successful migration.
Should You Drop Indexes on Exadata?
Arup Nanda, Starwood Hotels & Resorts
This is an interesting conundrum -- does the presence of storage indexes make traditional indexes unnecessary in Exadata? Not at all. 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. All concepts will be presented with examples and case studies.
Tricks to Migrate 10TB Data to Exadata X3
Amin Adatia, KnowTech Solutions Inc
Tips and Tricks for migrating 10TB data from AIX (2 Nodes and v10.2.0.4)to Exadata X3 (8 Nodes and v18.104.22.168) with only 6 hours of downtime. Database included Oracle Label Security, 40 Partitioned Tables, 4 Tables with Oracle Text Indexes, LOB Columns for 5 Tables and for one table a CLOB column had not to be removed during migration. On the Target Exadata, the indexes had to be in place because there was data loading being done just prior to the migration and immediately afterwards.
Ultimate Exadata IO monitoring with OEM12c Metric Extensions and BI Publisher integration
Karl Arao, Enkitec
his session will show you how you can utilize the OEM12c Metric Extensions and BI Publisher integration to boost the IO capacity monitoring of a large scale Exadata environment. The session will start with a use case highlighting an issue on a very write intensive OLTP Exadata environment and will discuss the different ways to monitor IO capacity from the database and storage cell layer perspective. Then move on to the details of creating and deploying metric extensions and consuming the metrics data for reporting and visualization using BI Publisher integration and ultimately scaling it to a bunch of Exadata environments.
Oracle Exadata Management Deep Dive with Oracle Enterprise Manager 12c
Ashish Agrawal & Joe Diemer, Oracle
Oracle Enterprise Manager 12c enables complete management of Oracle Exadata, including management of the storage servers, the InfiniBand fabric, and Oracle Database and its Oracle Grid Infrastructure feature. This session presents an overview of how you can utilize Oracle Enterprise Manager Cloud Control to effectively monitor and manage Oracle Exadata, followed by a deep dive into performance management techniques using instrumentation from Oracle Exadata storage servers, Oracle Enterprise Manager 12c's Automatic Workload Respository and Active Session History features, and SQL monitoring.
High Performance Security and Virtualization for Oracle Database and Cloud-Enabled Applications
Ramesh Nagappan & Glenn Brunette, Oracle
This session presents the high performance security and secure consolidation strategies for business-critical, multi-tier/multi-tenant cloud applications and databases on Oracle SuperCluster and Exadata Systems.
** The Engineered Systems track at COLLABORATE 14 is sponsored by Enkitec. **