(Presented at Oracle Open World 11) "Throw more hardware at the project to keep up the speed" is a phrase heard all too often among IT professionals. Sometimes, additional hardware doesn't solve performance problems. When dealing with computer systems, XML documents are an effective method to communicate real time information between two or more computers.…

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.

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.

This talk will provide tips for using SQL against an Oracle Database. It will discuss how to exploit a selection of lesser known features and also how to avoid traps and pitfalls. Examples of redundant and undocumented functions, such as OVERLAPS, REVERSE and the range of SYS_OP functions will be covered and some of the…

This paper re-introduces Perl as a language of choice for many solutions for DBA's and developers. Discover what makes Perl so successful and why it is so versatile. Perl can automate all those manual daily tasks and is truly platform independent so that your scripts can now run on Linux, Unix and Windows. Perl may…

This is a two-part session that will take place on Tuesday and Wednesday. “I never had the need for Analytic Functions”, is one of the phrases that is heard quite often. Maybe that’s true, maybe it isn’t. Recognizing the need for a particular feature can only occur when you have enough exposure to the feature.…

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…

Set is a card game which is fun to play while exercising your mind. In this session you will learn about the SET game, as well as how you can leverage SQL to solve it really quickly. Learn advanced features of SQL, such as Subquery Factoring and ANSI join syntax while we're cheating in the…

This is a two-part session that will take place on Tuesday and Wednesday. “I never had the need for Analytic Functions”, is one of the phrases that is heard quite often. Maybe that’s true, maybe it isn’t. Recognizing the need for a particular feature can only occur when you have enough exposure to the feature.…

This is a two-part session that will take place on Tuesday and Wednesday. “I never had the need for Analytic Functions”, is one of the phrases that is heard quite often. Maybe that’s true, maybe it isn’t. Recognizing the need for a particular feature can only occur when you have enough exposure to the feature.…