Sangam 11-India Oracle User Groups Annual Conference

Sangam 11-India Oracle User Groups Annual Conference

 

  • AIOUG Members
    (Database and Technology Tracks-AIOUG)

    Sale Date Ended

    INR 3500
    Sold Out
  • Non AIOUG Members
    (Database and Technology Tracks-AIOUG)

    Sale Date Ended

    INR 4000
    Sold Out
  • Student Registration
    (Database and Technology Tracks-AIOUG)

    Sale Date Ended

    INR 3000
    Sold Out
  • Student Registration
    (Application Tracks-India OAUG)

    Sale Date Ended

    INR 3000
    Sold Out
  • Regular Registration
    (Application Tracks-India OAUG)

    Sale Date Ended

    INR 4000
    Sold Out
  • Regular Registration
    Java Tracks-JUG\'s (9th Dec 2011)

    Sale Date Ended

    INR 1500
    Sold Out
  • Student Registration
    Java Tracks-JUG\'s (9th Dec 2011)

    Sale Date Ended

    INR 1000
    Sold Out

Invite friends

Contact Us

 

For Enquiries

a href"mailto:sangam11@aioug.org"sangam11@aioug.org/a

Page Views : 4717

About The Event

SANGAM is the largest Annual Oracle user’s conference of AIOUG and has been a forum to get the key technologists from around the world to share their expertise while encouraging users in India to learn and share to enlarge the Oracle user base in India. Sangam has primarily focused on the Oracle technology in 2009 and 2010 with a minor focus on Oracle applications. This year Sangam 11 is a co-hosted event with India OAUG and JUG's and will feature applications as a separate track along with Java, Oracle database, middleware and other development tools.                  

AIOUG (All India Oracle Users Group) is conducting this event in main cities in India every year. This year AIOUG is conducting Sangam11 in Bangalore with Oracle/Apps and Java as key topics.

Who should attend?
  • Oracle Technology and Application Professionals. 
  • DBAs  Developers 
  • Application Developers 
  • Application DBA's
  • DB Architects 
  • Java Architects 
  • Java Developers 
  • DBA Managers.

Expand Your Horizon by ARUP Nanda.

 Arup Nanda, the Lead DBA at Starwood Hotels has been an Oracle DBA for 14 years, spanning all aspects of the DBA tasks from modeling to performance tuning to backup/recovery, disaster recovery and security. He frequently presents at Oracle related conferences, writes regularly for publications like OTN and has co-authored four books on Oracle. He was the recipient of the coveted "DBA of the Year" award from Oracle in 2003. He has provided training sessions under Oracle University's Celebrity Seminar series in 13 countries.       

Agenda: http://www.aioug.org/sangam11/Sangam11Agenda.htm

Friday, 9th December 2011 9:30 AM to 12:30 PM

Session 1

PL/SQL Profiling for Performance:
How do you tune a PL/SQL application? By attacking the segment that takes the most time. In this session you will learn the profling techniques in PL/SQL, how to use the PL/SQL profiler to identify the elapsed time in each call, or sub-call. Both the traditional and hierarchical profilers will be explained. All the tips and techniques will be shown with live examples.

Session 2

Stats with Confidence and Intelligence:

This is a two part session. In the first part you will learn how to add intelligence to the Optimizer. For instance, no one born in June will have a zodiac sign of Capricorn - a fact we all know; but not the optimizer. How will you let the optimizer know about the correlation? Oracle 11g's Extended Statistics allows you to do exactly that and much more - to provide intelligence about data distribution after applying a function to a column value. In this session you will learn how they work and how to effectively use them in real life to solve everyday performance problems.

In the second part, you will learn how to perform stats collection effectively. Collecting new optimizer stats is a double-edged sword: it might improve performance but, equally likely, break it. In this session, you will learn how to:1. Confirm that the stats will produce accurate plans *before* the optimizer sees them. Publish the stats after this check to prevent unnecessary risk.2. Use SQL plan management (SPM) to create multiple baselines and choose the best plan among them--especially useful with canned applications.3. Use pending stats with the SQL performance analyzer to see the impact of the new stats on the entire application, not just a few queries.4. Roll back stats to a previous set, and export the pending stats to another database for testing.

Saturday, 10th December 2011 8:30 AM to 12:30 PM

Session 3

Real World Best Practices for the DBA:
Learn some of the tips and techniques of successfully managing a database infrastructure from someone who has been a DBA for 14 years and counting. Each recommendation is explained with justification and how it works. Some examples – install patches in a different Oracle Home, enable simple auditing, RMAN validate and restore preview, prefer pfile over spfile and many others. This presentation was delivered in Collab ’09 to a packed room.

Session 4

Understanding Cache Fusion:
Cache Fusion the fundamental to performance in RAC by reducing the need to go to disk for the data and getting it from the memory of another instance directly. But it is also a source of a lot of mystery, myths and misconceptions. This session will explain in clear terms what cache fusion can or can’t do by traversing the course of a buffer from the disk to the instance and then to the others. Also covered will be the different states of the buffer, the global locking mechanism, the need for a CPU and I/O as opposed to a super-fast interconnect, the cause of the different global cache related wait events and how they can be resolved. All will be shown with live demos.

Session 5

Exadata Demystified:

Exadata is fast, superfast - that is not a secret anymore. But what really makes it fast? In this session we will explore the various building blocks of Exadata - Storage Indexes, Cell Offloading, Smart Scan, smart Flash and more - all the components that make the database machine faster. You will learn what these concepts are and how they are used, with live examples. 

About AIOUG:

AIOUG (All India Oracle Users Group)http://bit.ly/ogBViy is a non-profit organization started in the year 2007 by like-minded users who think such a community is required in India where the amount of Oracle user base is humongous. The idea of this group is to share what the Oracle users have learned from using Oracle technology over the years with fellow users who have similar interest.

With Participation:

 

For Any Group Registrations. Please contact:

Mobile# 91-09880223160

Email : sangam11@aioug.org

Venue Map