Dayton Oracle Users Group (DAY-O) Meeting: Thursday, April 25, 2013 Sponsors : Oracle Corporation Booz Allen Hamilton Transcender AGENDA 08:00 AM – 08:30 AM Meeting Registration / Raffle Registration / Coffee, Refreshments08:30 AM – 09:30 AM Executing Explain Plans and Explaining Execution Plans - Craig Martin09:30 AM – 09:45 AM Break09:45 AM – 10:45 AM SQL Tuning – A look behind the curtain - Craig Martin10:45 AM – 11:00 AM Break11:00 AM – 11:30 AM Oracle Regular Expression Function, Oracle Analytic function - Shruti Shaw11:30 AM – 11:40 AM Announcements / Members (mention sponsors)11:40 AM – 12:45 PM Buffet Lunch12:45 PM – 02:15 PM Database as a Service (DBaaS) - Greg Walters (Oracle Corp)02:15 PM – 02:30 PM Break02:30 PM – 03:15 PM Data Protection Solutions for Oracle Database - Tony Ossege (Oracle Corp)03:15 PM – 03:45 PM Announcements / Raffles03:45 PM – 03:55 PM Break03:55 PM – 04:30 PM DAY-O Business Presentation Abstracts : Executing Explain Plans and Explaining Execution Plans: Craig MartinAn overview of DBMS_XPLAN.DISPLAY_CURSOR and a detailed walk through of the output it produces. This presentation will focus mainly on the execution plan section of the output and reveal how to properly make sense of it, a topic that even the Oracle documentation doesn't always get right. SQL Tuning – A look behind the curtain: Craig MartinStrip away all of the magic and mystery of SQL tuning and learn a method that can be used to easily find a performant execution plan for any query, no matter how complex. I will show you how to turn your queries into diagrams that will lead you directly to either an execution plan that will perform well or will show you where the most effective place for an index would be. Oracle Regular Expression Function:Shruti ShawRegular Expression function enables users to search for patterns in string by using standardized syntax conversation. Regular Expressions are a powerful text processing component for other languages such as Perl and Java. Upon introduction of the Regular Expression function in Oracle 10g, developers are now able to implement complex match logic in the database. In Oracle there are 4 types of Regular Expression functions which are REGEXP_LIKE , REGEXP_REPLACE, REGEXP_INSTR, and REGEXP_SUBSTR. During this session I will review these 4 types of Regular Expression function and demonstrate how they can be used in complex match logic. Oracle Analytic function:Shruti ShawOracle Analytic function is a powerful addition to Oracle database which enables developers to compute and aggregate values based on a group of rows. This analytic function differs from aggregate functions in that it returns multiple rows for each group. The group of rows is called windows and is defined by the analytic clause. The window determines the range of rows used to perform the calculation for the current rows. During this session I will present how this function can be used to select single row of data over various single, duplicate or multiple combinations of data rows. This is very useful for any data consolidation, data migration and data integration project where multiple copies of same data come from different sources and we want only a single copy of the data. Oracle Enterprise Manager 12c Database as a Service (DBaaS): Greg WaltersOracle Enterprise Manager 12c is Oracle’s premiere cloud management solution. It is the industry’s first complete solution including self-service provisioning balanced against centralized, policy-based resource management, integrated chargeback and capacity planning and complete visibility of the physical and virtual environment from applications to disk.Oracle Cloud Management Pack for Oracle Database provides the foundation for Database as a Service (DBaaS), delivering capabilities spanning the entire Database cloud lifecycle. It allows Cloud administrators to identify pooled resources, configure role-based access, define the service catalog, and the related chargeback plans. It allows Cloud users to request database services and consume them on-demand. It also allows users to scale-up and down their platforms to adapt to changes in workload. Finally, it allows both parties to understand the costs of the service delivered, and establish accountability for consumption of resources. The key benefit of a database cloud is to enable faster deployment of typical platforms by moving from admin driven to end user driven provisioning. Data Protection Solutions for Oracle Database: Tony OssegeOracle Databases manage vast volumes of business critical data, data that enterprises literally cannot live without. Protecting your Oracle Databases from multiple types of data loss is a key component of an optimized data center that can be easily overlooked or over-specified, resulting in either an elevated risk of data loss or inflated costs. Come and learn about the data protection challenges in today's optimized data centers and understand how Oracle's storage solutions work together with the rest of the Oracle stack to provide the ultimate, integrated data protection solution for Oracle Databases. Speaker Biographies Craig Martin is currently an Applications DBA at Nationwide in Columbus, OH. He specializes in Oracle SQL and PL/SQL with a focus on performance improvement. He has been working with SQL and PL/SQL in Oracle since 2002. Craig has presented for the Oracle Users Groups in Cleveland and Columbus, and at the annual conference for NEOOUG. Shruti Shaw is a consultant employed by Booz Allen Hamilton in Dayton, Ohio. She is working with various aspects of Oracle technologies for the last 16 years including database administration, database development, database modeling, data integration, ERP implementation, Data Warehouse and Business Intelligence application implementation for both commercial and defense industry. Greg Walters is a Sr. Sales Consultant and Database Specialist at Oracle Corporation and has over 17 years of experience with Oracle Database Technologies. Greg works closely with Oracle customers to optimize their enterprise architecture, meet their business requirements and achieve their business goals. Greg's background includes 14 years of Oracle Database Administration with a focus on Oracle's Maximum Availability Architecture (MAA) - Oracle's best practices blueprint for achieving optimal uptime and availability at the lowest possible cost and complexity to the customer. Tony Ossege is a Storage Architect with the Oracle North America Hardware Team based out of Houston, TX. He has been in the Storage Industry for over 20 years with a focus on Disaster Recovery and Business Continuance. He has been at Oracle since the acquisition of Sun Microsystems in 2010 and was with StorageTek when Sun acquired them in 2005. Prior to that he was a Systems Administrator in the Air Force stationed in the United Kingdom. He is a proud Buckeye and was born in Kettering, Ohio and lived in Huber Heights until the early 80’s. Meeting Attendees :Register by Apr 23 to allow planning for luncheonFee of $10, registration required :Coffee, refreshments, Buffet LunchEligibility for raffleWalk-ins welcome, register at the doorHow to Register and Pay :Press REGISTER button above on this site. Fee payment does not process on this site.Payment information will be sent to your email address provided during registration.Fees are waived for students, sponsors and unemployed individuals.Find this and other events on DAY-O website http://dayton.oracle.ioug.org Directions to Booz Allen Hamilton’s Dayton location : 1900 Founders Drive, Dayton OH 45420-4011 The Learning Center Miami Valley Research Park sign is at entrance of parking lot. There is a building entrance to the lower floor where 5 flags are flying; Find the Theatre Room reception desk just inside entrance. From Dayton International Airport:1. Take I-70E to I-675 South (Exit 44).2. Take I-675 S to Route 35E toward Xenia (Exit 13)3. Approximately 2 miles, exit at Route 835W - - Research Blvd (Road will curve to the right).4. Continue on Research Blvd for approximately 2 miles to Spaulding (The second stop light).5. Turn right on Spaulding.6. The first road on the left is College Drive – Turn Left. At the dead end – left is Founders Drive.7. Turn in at the first parking entrance on the left (north side). Sinclair Learning Center sign is by the entrance.8. Turn in at the first parking entrance on the left. Turn left into parking lot on the North side. 9. Enter lowest level of the building on the north side.From Columbus International Airport:1. Get on I-70W toward Dayton to I-675S (Exit 44).2. Continue with above directions from Dayton International Airport starting with Step 2.From Cincinnati International Airport:1. Take I-275 to I-71/75N towards Cincinnati.2. Take I-75N towards Dayton to I-675N (toward Columbus).3. Continue I-675N to 35E toward Xenia (Exit 13).4. Continue with above directions from Dayton International Airport starting with Step 3.
Register Now, $10 Payment Request is sent later 0.00