Oracle Automatic Workload Repository (AWR) was introduced with Oracle 10g and is a powerful way to analyze and compare database performance. The AWR data is collected by the Oracle database and recorded for a defined period of time. AWR is the came to be evolving from UTLBSTAT/UTLESTAT to statspack, to AWR. Do you want to…

Amazon being a global company and the largest online retailer on the internet has business units across the globe. The challenge was to consolidate the hundreds of different financial reports being generated everyday across the globe from different transactional systems and data marts. This led to inaccurate reporting of financial numbers and also delays for…

Exadata is an engineered system that has a variety of expansion options. Learn about the methodology that was used to determine the expansion approach and the lessons learned with expantion of an Exadata system with the Exadata Storage Expansion.

This presentation is based on real world example of a complex migration and consolidation. 21 databases, 15 tb in size, with 200,000 objects were merged into one database. Consolidation of multiple databases into a single database has several unique advantages including but not limited to … improved operations and management, simplified backup and recovery, easy…

Top Exadata features you need to know. Detailed slides will have those features explained with appropriate examples. 1. What is Exadata? 2. Instance caging 3. EHCC 4. Storage indexes 5. DBRM 6. IORM 7. DBFS 8. Flash Cache

Attend this session to get the inside track on how Oracle Exadata is monitored and managed using Oracle Enterprise Manager. Learn from a real-world implementation on how to effectively instrument and monitor your engineered systems.

This session will give a brief overview of implementations that we've done with Exadata. It will include panel members that have worked with Exadata. It will also have a Q&A Session

SQL Plan Management (SPM) has been well publicized as one of the major benefits of moving to Oracle 11gR1 and 11gR2. This session will present this technology as it was really used to test a database upgrade and move it into production. We will discuss steps that were performed and cover what worked well as…

This presentation will teach you the basics of Exadata 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. Consolidation is the number 1 way that companies are saving money…

In Agile project management methodologies, user stories describe desired content and functionality delivered and verified in a short amount of time. But traditional data warehouse projects struggle to deliver completed user stories due to the complexity of the intermingled moving parts: data modeling, ETL, front-end development, and a QA process that needs to validate the…