Skip navigation

OTNYathra 2016 - Bangalore

Event has ended

Loading...

Description

TimingsRoom 1Room 2Room 3
9:00 to 9:30Registrations
9:30 to 10:00Oracle ACE Program Overview - Sai Janakiram
10:00 to 10:50 RAC Cache Fusion Internals - Riyaj Shamsudeen Supercharge your SQL skillset -  Connor McdonaldOracle Database 12c: Rest of the New Features for 11gR2 DBA -
Biju Thomas
10:50 to 11:10 Tea/Coffee/Networking Break
11:10 to 12:00 RAC performance tuning -
Riyaj Shamsudeen
Oracle Application Express 5.1  New Features - Chaitanya Koratamaddi Database Caching -
Suvendu Patra
12:00 to 13:00 Networking Lunch
13:00 to 13:50 Database Performance Management Best Practices -  Prabhaker Gongloor12c features for Developers-
Connor Mcdonald
Use Oracle Big Data SQL to query for All Your Data -
Saurabh Gupta
13:50 to 14:40 Data Pump: Tips, Techniques and Tricks -
Biju Thomas
Understanding 12c Adaptive Query Optimization -
Aman Sharma
Oracle Data Security-
Chetan Vithlani
14:40 to 15:00Tea/Coffee/Networking Break
15:00 to 15:50 In-memory internals -
Riyaj Shamsudeen
Learn the capabilities of GDS -
Nassyam Basha
Troubleshooting Oracle GoldenGate -
Hariharaputhran Vaithinathan / Veeratteshwaran Sridhar
15:50 to 16:40Oracle RAC Node Eviction: What, Why, How -
Aman Sharma
Oracle DevOps for Dummies -
Sai Janakiram
Online Patching & Edition Based Redefinition -
Pravin Takpire
16:40 to 17:10Expert Panel
17:10 to 17:30Closing

NOTE: Agenda and speakers subject to change without notice.

Please take note of the appropriate venue /date of the event. The registration for the event is free, however there will be a non-refundable fee of Rs 500.00 ( to cover lunch and incidental expenses ) to be paid at the time of registration.

Click here to register!

 

 

Connor McDonald

 

Session Title:
Supercharge your SQL skillset


Session Abstract:

Cloud and virtualization services now take care of many of the day to day concerns for organizations - keeping infrastructure up to date, ensuring the integrity of backup/recovery, resource capacity and high availability. Finally IT professionals can focus on the true art of software development - writing quality SQL to provide data to upstream services. This session covers some of the SQL techniques available in the Oracle database, to allow developers to supercharge their SQL skillset.


Session Title:

12c features for Developers


Session Abstract:

With the banner headline multitenancy features in Oracle Database 12c, lost in the mix has been the incredible list of new features for developers. Hundreds of improvements and new facilities have arrived in Oracle Database 12c. This session redresses the balance and excites developers with all the new Oracle Database 12c goodies.


Speaker Bio:

Connor McDonald is a former Oracle Ace Director who has joined the Oracle Developer Advocates team. Over the past 18 years, he has worked with systems in Australia, the UK, Southeast Asia, Western Europe, and the United States. He has co-authored three books, and has been a popular speaker at Oracle conferences around the world, specializing in topics regarding the database engine and PL/SQL. He has twice won the Inspirational Speaker award by the UK Oracle User Group in 2009 and 2011.

Riyaj Shamsudeen

Session Title:

RAC Cache Fusion Internals


Session Abstract:

A demo of internal working of RAC and cache fusion. Audience will understand the core concepts behind RAC internals. Conceptual understanding will lead to better performance tuning and debugging RAC related issues. I use wireshark, output from internal structures to explain these concepts.


Session Title:

RAC performance tuning


Session Abstract:

Part 1. This presentation is a logical extension to RAC Cache Fusion Internals session. Audience will be able to understand the RAC wait events and performance statistics better.


Session Title:

In-memory internals


Session Abstract:

In this presentation, I will discuss the inner working of in-memory column store. Conceptual understanding of internals will help the customers to use the product better.


Speaker Bio:

Riyaj Shamsudeen is considered industry recognized RAC Expert, Performance Tuning Specialist with 20+ years of Experience in implementing, using, and tuning RAC and Oracle products. He is an Oracle ACE Director and proud member of OakTable member. He has co-authored many books about Oracle and Performance. He is an active blogger at http://orainternals.wordpress.com and frequent international speaker in major conferences such as UKOUG, HOTSOS, Open World, RMOUG, etc.

Biju Thomas

 

Session Title:

Oracle Database 12c: Rest of the New Features for 11gR2 DBA (1 Hour)


Session Abstract:

Oracle Database 12c comes with large number of features - from as small as a default value of parameter to core database architecture with Multitenant. This session will show the 11g DBAs and Developers how they can quickly start using few of the 12c features and understand some behavior changes. Session will also cover the features introduced in 12.1.0.2. Session will focus on the changes and features you can expect when you upgrade your 11g database to 12c.  This paper discusses the features those may not be on the top list, but are helpful in everyday database administration and management. Discuss the behavior and setup changes compared to Oracle11g.


Outline:

The session will focus on the changes in 12c database compared to 11g database, and introducing new 12c features that come with an upgrade. We will cover features like (not limited to)

-        Upgrade runs in parallel (using catctl.pl instead of catupgrd.sql)

-        TRUNCATE has a new CASCADE option

-        How many DB Writer processes allowed

-        What is COMMON_USER_PREFIX parameter for

-        Why READ privilege when we have SELECT privilege

-        Row limiting

-        Faster approximate count

-        What is FORCE FULL DATABASE CACHING

-        How to use UNIFIED_AUDIT_TRAIL

-        Rename a disk within an ASM diskgroup

-        Datapump Import without generating archivelogs

-        What is SPARE6 column in SYS.USER$ for

-        And many more (over 30 features and tips)


Session Title:

Data Pump: Tips, Techniques and Tricks (1 Hour)


Session Abstract:

Data pump was introduced in Oracle Database 10g, and has evolved over the versions with various features and performance improvements to migrate data and objects. The legacy export (exp) / import (imp) utility is still maintained in all versions of database including 12c for backward compatibility, and to migrate legacy data to newer versions of database. In this session the speaker shows you how to extend data pump for your various data and object migration needs outside of copying a table or schema. You will learn to export public and private database link and synonyms, various object filtering and row filtering techniques, improving performance of data pump operations, migrate data without using any space for dump file, changing storage properties during export and import, and methods to verify the contents of export dump file.

Outline:

In addition to the content mentioned in the abstract, the session will go in to details with example to show how to export and import with various INCLUDE and EXCLUDE options. Will also cover the improvements like NOLOGGING import and export views as tables introduced in 12c. The topics include:

-        Major difference between legacy export and data pump tools

-        Estimating dump file space requirement

-        Finding valid EXCLUDE and INCLUDE values

-        Saving and restoring database links during a clone

-        Copying public objects from one database to another

-        Excluding large tables during a nightly backup

-        Using subqueries in EXCLUDE and INCLUDE filter conditions

-        Export subset of data

-        Data Masking using data pump

-        Changing storage properties during import

-        Merging partitions during import as well as splitting partitioned table into multiple tables

-        Consolidating tables and indexes on tablespaces reducing the number of tablespaces to manage

-        Using PL/SQL code for data pump operations

-        Performance improvement considerations

-        Upgrading database using data pump


Speaker Bio:

Biju Thomas is Oracle ACE Director, Oracle Certified Professional and Certified Oracle Database SQL Expert. Biju Thomas is a senior solutions architect with more than 20 years of Oracle DBA experience. He is the author of Oracle12c OCA, Oracle11g OCA, co-author of Oracle10g, 9i, 8i OCP certification guides published by Sybex/Wiley. He is a frequent presenter at Oracle conferences and publishes articles for Oracle technical journals. Twitter @biju_thomas

Prabhaker Gongloor

 

Session Title:

Tips and Techniques for Maximizing Database Performance: Theory and Practice


Session Abstract:

Oracle Database and Oracle Enterprise Manager introduce new, exciting capabilities that help improve DBA productivity and maximize performance while reducing management costs. This session covers the theory behind performance diagnosis and tuning and the new and upcoming capabilities in Oracle Database and Oracle Enterprise Manager, such as Hybrid Cloud Management, Automatic Workload Repository multitenant enhancements, Automatic Workload Repository and SQL Tuning Advisor support for Oracle Active Data Guard, Performance Hub Reports, Database Operations Monitoring, and more. This session provides tips on when and how to best use the above mentioned features that will help DBAs with day-to-day tasks.


Speaker Bio:

Prabhaker Gongloor (GP) works as Product Management Senior Director in the Database and EM development organization at Oracle Corporation covering the areas of Oracle Database Diagnostics and Tuning Packs, Real Application Testing, Application Replay, and Diagnosability. He also covers all aspects of Engineered Systems and In-memory Database manageability. GP has over 23 years industry experience spanning many roles - Developer, Consulting Technical Advisor (Centers of Expertise), and Consulting Product Manager. He holds Bachelor's and Master's degrees in Computer Science and Engineering. GP has contributed significantly towards building Oracle’s Database Manageability solutions and is well respected in the Oracle community. He has presented numerous sessions at OOW and user conferences and some of his sessions have been rated the best in their category.

Chaitanya Koratamaddi

 

Session Title:

Oracle Application Express 5.1 New Features


Session Abstract:

Released in April 2015, Oracle Application Express (APEX) 5.0 represented the greatest advancement of APEX in its 10 year history, enabling customers to develop, design and deploy beautiful, responsive, database-driven desktop and mobile applications using only a browser. APEX 5.1 will build on the success of 5.0, introducing a small number of new features, and enhancements to existing functionality, and is currently planned to incorporate a new multi-row edit region, master / detail / detail wizard built pages, and improved packaged applications. This session covers an overview of APEX 5.0 and you will also see demonstrations of the important new features of APEX 5.1.


Speaker Bio:

Chaitanya is a Principal Product Manager for Oracle Application Express. He joined Oracle in 2005. Chaitanya has extensive knowledge and experience on various Oracle technologies such as Oracle Application Express, Oracle SQL Developer, SQL Developer Data Modeler, Oracle Database, Oracle XML DB, Oracle Database XE, Oracle Database Vault, and Oracle Fusion Middleware. Chaitanya is a seasoned technology professional with 13 + years of experience in IT in various roles.

Chaitanya is a regular speaker at various conferences like Oracle Develop, Oracle Cloud World, OOW, OTN Developer Days, ODTUG, JavaOne, AIOUG Tech Days, and Sangam, and user groups. Chaitanya spends his free time gardening, volunteering, learning music, and enjoys traveling. Chaitanya writes his technical blog @http://chaitanyain.blogspot.com/

https://twitter.com/chaitanya_in

Aman Sharma

 

Session Title:

Oracle RAC Node Eviction: What, Why, How


Session Abstract:

In Oracle Real Application Cluster environments, there is a common issue of Node and Instance evictions. This presentation would reflect the reasons behind these node and instance evictions and as a DBA, troubleshoot the reasoning why did they occur?


Speaker Bio:

Aman Sharma is an Oracle Database consultant and instructor. He holds a Master's degree in Computer Applications and has been working with Oracle Database for over a decade. His main focus is to understand how Oracle Database works internally. Besides the core database, he has a very strong knowledge of Linux, Solaris, Oracle RAC, Data Guard, RMAN, Oracle Exadata and Oracle Enterprise Manager. He is an Oracle Certified Professional and also an Oracle Certified Expert in Oracle RAC, SQL and Linux. He is also an Oracle Certified Implementation Specialist and a certified Solaris System Administrator. In 2010, he was awarded the prestigious Oracle ACE award from Oracle Corporation. He loves to share his learning with the Oracle community, so when he is not delivering an Oracle related session, he spends a lot of his time participating in OTN (Oracle Technology Network) discussion community spaces. He also shares his research and findings over his Oracle blog (http://blog.aristadba.com). He has co-authored two books-Oracle Backup and Recovery: Expert secrets for using RMAN and Data Pump-Rampant TechPress (USA) and Oracle Database 12c Backup and Recovery Survival Guide-Packt Publishing (UK). He is an avid supporter of Oracle user groups and is a member of All India Oracle Users Group (http://www.aioug.org). He also manages the AIOUG's North India Chapter. He has presented at various Oracle conferences organized by AIOUG i.e. Sangam, OTNYathra and Tech Days. He is also an associate member of IOUG (http://www.ioug.org).

Sai Janakiram

 

Session Title:

Oracle DevOps for Dummies


Session Abstract:

Application development and IT operations teams travel different roads with different points of view. These separate roads slow the delivery of new apps and features to customers. Relations between Development and Operations are generally viewed as poor, with some even characterized as toxic.

Ready to begin your journey to DevOps? The journey to continuous everything. DevOps brings together your development and IT operations professionals early in the application process, enabling them to collaborate closely and function as an integrated team. Along the way, DevOps automates many processes so one organization isn’t left waiting on the other. Integration, automation, and collaboration are keys to DevOps success. This session is going to help Oracle Customers to understand how DevOps can benefit their business.


Speaker Bio:

Sai is an Oracle ACE Director and Oracle Certified Professional. He is having more than fourteen years of experience in Oracle & Cloud technologies. Currently working with Hewlett Packard Enterprise (HPE) as Lead Cloud Architect. He is one of the founding member of All India Oracle Users Group (www.aioug.org – a non-profit organization) and currently serving as Vice-President & Director of Finance. He is frequent speaker in Users Group conferences inside and outside of Oracle including Oracle Open World, UKOUG, OTNYathra (India OTN Tour) and AIOUG Sangam Conferences & Java One. He was part Oracle Database 12c Beta testing. His Oracle Application DBA blog - www.oadba.com. Oracle 12c blog www.oracle12c.info. He is also leading Oracle VM Special Interest Group (SIG) www.oraclevmsig.org. Presented more than 35 conferences, major conference including Oracle Open World (2015,2014,2013), UKOUG (Tech14), Java One India (2013), Sangam (AIOUG Annual Conference 2014,2013, 2012, 2011, 2010, 2009), OTNYathra (India OTN Tour 2014,2013, 2012)

Nassyam Basha

 

Session Title:

Learn the capabilities of GDS


Session Abstract:

This session gives an idea to understand what Global data services of ADG 12c is.

Before implement you need lot of idea how GDS works and how to manage in complex environments, you can learn from this session ABC's of Global data services and various components involved in GDS like GSM, Load balancing, pools, and failover so on. After the detailed introduction users can learn how to implement/configure the GDS with simple steps and what software/tools required to create and manage global data services. Finally we will see how to administer the Global data services and few troubleshooting tips."


Speaker Bio:

Nassyam Basha Oracle DBA, OCM 11g, Oracle ACE Director, Author of Data Guard 11gR2 Book, Blogger, OTN Moderator and Super Hero, MOSC Guru,  Writer with OTN, DELL and  having around 9 years of hands on experience in High Availability technologies Like Oracle RAC, Data Guard, Exadata and much more. Currently working with The Pythian Group, In the past i have worked for AT&T(Bell Labs), dbaDirect, SLK software services.

Saurabh K. Gupta

 

Session Title:

Backup your databases to the cloud using Oracle Database Backup Service


Session Abstract:

Oracle Database Backup Service is a secure, scalable, reliable, and on-demand Oracle public cloud storage solution for storing Oracle Database backups. Businesses can access additional storage capacity in minutes with zero hardware investment. The Oracle Database Backup Service can be accessed from anywhere, at any time, and from any Oracle database server connected to the Internet.

This session will touch upon several aspects of backup cloud service like subscription process, scalability, access, and security. The attendees will learn about the new backup-as-a-service offering that enables customers to store their backups securely in the Oracle cloud via a downloadable backup module that transparently handles the backup and restore operations.


Speaker Bio:

Saurabh K. Gupta works as a Principal Technologist with the Database Product Management group at Oracle India Private Limited. He is a seasoned professional with wide experience in Oracle Database design, development, and administration. He is responsible for driving technology adoption of the Oracle Database product with Oracle partners. His areas of expertise are PL/SQL development, database administration, high availability, and Exadata engineered systems. He is the author of Packt's "Oracle Advanced PL/SQL Developer Professional Guide". He is an active speaker at technical conferences and Oracle user groups.

Suvendu Patra

 

Session Title:

Database Caching


Session Abstract:

Oracle has introduced a new feature called full database caching (Different from In-memory option), this can be used to cache the entire database in memory.

Caching the entire database provides significant performance benefits, especially for workloads that were previously limited by I/O throughput or response time. This improves the performance of full table scans by forcing all tables to be cached.


Speaker Bio:
  Suvendu Patra

I have over 12 years of experience in IT Industry. I am an Oracle Certified Master (OCM) and RAC Certified Expert. I have spent 4.5 years with Oracle metalink support. Currently I am working as a Lead Database administrator with Fiberlink

(An IBM labs company).Fiberlink a market leader in mobile device management (MDM) over cloud (SaaS model).At Fiberlink, I am responsible for delivery of multiple projects, introducing new technologies to solve complex issues. My main focus areas are production support of the Cloud Maas360 applications, databases, and code review and infrastructure management. I have presented 'Fastest Db refresh' @ AIOUG .I share my work experience regularly at http://www.dbagalaxy.com/

Chetan Vithlani

Session Title:

Oracle Data Security Introduction


Session Abstract:

Databases make very attractive targets as they have all the data neatly arranged in columns and rows, properly structured and linked with relevant information.

Hackers may try to enter from network, operating system, storage, databases, applications, storage, backups, etc. if you can sniff the wire, copy the database files from the operating system, exploit someone already in the database, or the application, you can get away with all the data. Passwords can now be obtained by the hackers as well, and you have to make sure that those privileges are not getting abused. The scope of the problem is thus slightly larger than typically what can be addressed by just encryption.


Speaker Bio:
  Chetan Vithlani

Enterprise Security Solutions Architect with two decades of Information Technology experience. Currently work as Principal Security Technology Consultant with Oracle focusing on Enterprise Security.

Chetan worked in BFSI, Tele Communications, Web Hosting and many other domains. Extensive experience as Production and development Database Administrator, Architect, Data Migration & ERP.

AIOUG Bangalore chapter Core Team member.

Specialist:

  1. Data Security: on premise as well as cloud
  2. Big Data (HDFS, NoSQL & RDBMS) Security
  3. Presales

Certifications:

2014: Oracle Database RAC 12c certified implementation specialist (OCE)

2014: Oracle Database 12c certified implementation specialist (OCS)

Hariharaputhran Vaithinathan / Veeratteshwaran Sridhar

 

Session Title:

Troubleshooting Oracle GoldenGate


Session Abstract:

Process Abended - oh!!! Not Again. My processes are up and running, but my data is not getting replicated. If you are looking for troubleshooting Oracle GoldenGate, then this is the session for you. Prevention is always better than cure, on following this quote, the session not just troubleshooting but also explains the key areas which has to be considered so as to prevent or avoid the errors and problems which occur frequently in your Oracle GoldenGate environment. A step by step methodology on how to troubleshoot Oracle GoldenGate problems will be showcased based on real time scenarios.


Speaker Bio:

Hariharaputhran: Technology and Business Professional with 12 yrs experience in data architecture, data integration business intelligence, Professional Services Delivery. Recognized as a strategic thought-leader with a consistent track record of client-focused innovation and execution. Extensive global experience in Finance, Banking and Telecom projects. He has extensive experience in design, development, support and management of large scale data systems and deploying enterprise level global solutions.  His area of interest includes Data Modelling, Replication, SQL Tuning and Big Data. He is currently heading the AIOUG Chennai Chapter. Hari is a speaker at User Group Conferences including India OTN Tour, AIOUG Sangam Conferences, and Oracle Open World 15. He was the recipient of the award from Cognizant Technologies Ltd- Chennai Top Trainer for Q1-2013. He shares his experience in his blog www.puthranv.com

Veeratteshwaran Sridhar is an Oracle Database Administrator with 8 Years of Experience working as Senior Software Engineer, Oracle GoldenGate Global Customer Support in Oracle India Pvt Ltd. He is an Oracle 11g Certified Professional and Oracle GodlenGate 11g Certified Implementation Specialist. He is also having good knowledge in Oracle Technologies such as GoldenGate, Data Guard, RAC and RMAN. He is also a speaker in AIOUG Chennai Chapter, Sangam, Oracle Technology Network and He actively participates in Oracle related forums such as OTN (ID - ORASCN). He constantly publishes articles on his blog www.oracle-scn.com and he is reachable atveeratteshwaran.sridhar@oracle.com / veeratteshwaran.s@gmail.com

Pravin Takpire

 

Session Title:

Online Patching & Edition Based Redefinition


Session Abstract:

Patching in Oracle Application previous versions like 11i and R12.1.x

Downtime effect in earlier versions

2 File Systems in R12.2.x

What is Edition Based Redefinition

How downtime can be reduced/minimized in R12.2.x

ADOP Patching Life Cycle

Various Parameter of ADOP and their usage

Advantages of ADOP

Edition Based Redefinition -- a closer look


Speaker Bio:

Pravin have 16 years of experience as Oracle Applications DBA and Core DBA. He has worked on 10.7/11.0.3/11i/12.1.x and 12.2.x and Oracle Database from version 8 to 12C. He has extensive experience in Upgrading Oracle Applications and managing mission critical Oracle Application Instances for large number of clients. He is Oracle Certified Professional and Oracle Certified RAC expert.

When and Where

  • Start Time:

    Apr 24, 2016 9:00 AM UTC (UTC)
  • End Time:

    Apr 24, 2016 6:00 PM UTC (UTC)
  • Location:

    Symbiosis Institute of Business Management Bengaluru #95/1, 95/2, Electronic City Phase 1, Hosur Road, Bengaluru - 560100

Event Info

  • Event Type:

    Conference
  • Event Visibility & Attendance Policy:

    Open

Contact Info

Comments

More Like This