Session Abstract: This presentation emphasizes on the role of DBA's in effectively analyzing Application load test. Database load testing and analysis not only helps DBA's in reducing production outage but can also detect performance degradation. This also helps in identifying existing bottlenecks which can result in further tuning of database to make it scalable .The…

Migration can be done in many ways, you can have offline migration, online migrations and a combination of both. This session will deal with migration and upgrade and the success we had in getting a system up with minimal downtime using Dataguard to migrate between system from single Instance to RAC and also to upgrade…

For over 10 years, since its introduction in Oracle8, partitioning has been a very powerful tool for management and performance of Oracle databases. Each major release since that time has added additional capabilities and Oracle Database 11g is no exception. Several powerful options are now available which allow for almost unlimited flexibility in building and…

This is a continuation of “Oracle11.1 to 11.2 – In giant steps” session. The previous session talked about what you need to think about before starting the migration. This session continues the process to discuss the specific steps needed to upgrade from Oracle11.1 to Oracle11gR2.

This is a continuation of “Oracle11.1 to 11.2 – In giant steps” session. The previous session talked about what you need to think about before starting the migration. This session continues the process to discuss the specific steps needed to upgrade from Oracle11.1 to Oracle11gR2.

Discuss best practices and challenges involved in implementing Universal Records Management at Oracle. Discuss what it took to translate a 1200 page retention schedule and translate that to a file plan which could be leveraged by 100K different employees at Oracle to manage the life cycle of their content. Discuss how federated adapters of URM…

It seems that LDAP is cropping up as a data source more and more and DBAs and traditional RDBMS developers are asked to use it. This presentation provides an introduction to LDAP, describes the differences between this hierarchical database and RDBMS, and demonstrates the PL/SQL interfaces provided by Oracle to access and manipulate LDAP data.

Managing complex Oracle database environments often presents many challenges to the database administrators in the area of database performance, backup and recovery, disaster recovery, data growth, and development and testing. This session introduces common technologies offered by many disk storage subsystems. It examines how DBAs can combine Oracle features such as Automatic Storage Management and…

How do you design an OLTP system that handles terrabytes of data and needs to scale 200% per year ? Or 200% per month ? By the way, all queries still need to respond in subseconds. And no, your budget is not unlimited. Enter Database sharding - the art of splitting data into manageable chunks,…

How do you design an OLTP system that handles terrabytes of data and needs to scale 200% per year ? Or 200% per month ? By the way, all queries still need to respond in subseconds. And no, your budget is not unlimited. Enter Database sharding - the art of splitting data into manageable chunks,…