American DBA Online Technical Seminar

Date & Time:  Saturday, May 15, 2010,  2:00pm C 5:30pm

Location:   Crowne Plaza Hotel (Formerly Clarion Hotel)
                        2055 Lincoln Highway, Edison, NJ 08817

Seminar Program (Subject to change)

2:00pm to 2:15pm



2:15pm to 3:00pm

Database Storage Optimization with 11g New Features



Enterprise database is growing rapidly as more and more data are stored and processed. Database storage has become huge part of IT infrastructure spending. It is common nowadays that database storage is over allocated or database objects are fragmented in database environment. Optimizing database storage has been a major initiative in many organizations to reduce storage cost. This presentation will cover how to identify storage saving opportunity, e.g., identify fragmentations of tables, indexes and tablespaces, and provide guidelines to optimize storage with re-organizing, compressing, moving and shrinking, and so on. 11g new features on storage management such as advanced compressing  will also be discussed.

John Zhong, Senior Database Architect

3:15pm to 4:00pm

PeopleSoft EPM Warehouse Tuning Case Study: SQL Tuning And Performance Tuning of Batch Jobs.



The case studies focus on SQL (rewrite), fundamental, and partitions. It talks about composite indexes (unique), basic indexes(bitmap and functional), partition indexes (global and local). It also shows how to read the new "explain plan" using utlxplp.sql to identify performance issue, and find out root cause. The case study will let you rethink about physical i/o and logical i/o, and why logical i/o is what we should pay more attention to and what contributes to big LIO. The finding may surprise most people.

Stan Ma, Senior Oracle DBA

4:15pm to 5:00pm

Panel Discussion and Sharing on DBA Real-word Tips

Panelist: Qi Wang, Jeff Zheng, Stan Ma, John Zhong, David Wang.

5:00pm to 5:30pm

Network and Social