This session offers you the fastest way to master all of the advanced Site Studio tools with minimum fuss. Dont hate yourself for missing out... unless you've just completed a 3 day instructor-led Advanced Site Studio 11g class - course with flying colors.

All DBAs know a thing or two about partitions. We know the various types of partitions, when we think we should use partitions, etc. However, most DBAs don't know the events that occur in the background when the various types of partitions are used. How do indexes behave when partitions are introduced? This session takes…

All DBAs know a thing or two about partitions. We know the various types of partitions, when we think we should use partitions, etc. However, most DBAs don't know the events that occur in the background when the various types of partitions are used. How do indexes behave when partitions are introduced? This session takes…

This is a two-part session that will take place on Monday and Tuesday. Oracle 11g databases can scale to handle tremendous volumes of data, but some effort is involved to avoid the dastardly villians that would sabotage your success. This presentation will help DBAs avoid the villainous techniques and pitfalls in code and schema designs,…

There are several vendors that can provide clustering capabilities for databases. The beauty of using Oracle's RAC One-Node is that it is integrated with the Oracle stack and can help to reduce overall software costs. This gives you one vendor that can handle both the clustering software and the database. Additionally, you gain the ability…

In an 11g RAC environment, establishing a Data Guard configuration using Data Guard Broker can be a bit tricky and frustrating. This session will provide all of the information you need to successfully create the standby database, create services, configure the broker, perform switchovers, and verify that CRS is aware of the database's correct state.

In an 11g RAC environment, establishing a Data Guard configuration using Data Guard Broker can be a bit tricky and frustrating. This session will provide all of the information you need to successfully create the standby database, create services, configure the broker, perform switchovers, and verify that CRS is aware of the database's correct state.

We are alarmed by a recent trend back to the philosophy of closed, proprietary servers that was popular in the 1960s and all but dead by the mid-80s. The idea of open systems as an alternative to the proprietary mainframe was championed by Oracle, HP, DEC, and others in the 1980s, and the arguments in…

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…

Learn how to build multilingual applications with Oracle Application Express