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.

Is Oracle’s Exadata database machine as good as the marketing brochure says it is? Does a Proof of Concept reflect the real world or is it all smoke and mirrors? This presentation is based on one of the 1st Exadata PoC in Australia which was benchmarked against a 26 TB data warehouse currently running on…

Migrating from non-Oracle databases to Oracle can always be a challenge. Heterogenous systems will have stored code that requires translation or rewrite, large amount of data needs to be migrated in a short timeframe, downtime/uptime requirements during the migration can be tricky. This session will discuss the different approaches, techniques and tools available for moving…

Migrating from non-Oracle databases to Oracle can always be a challenge. Heterogenous systems will have stored code that requires translation or rewrite, large amount of data needs to be migrated in a short timeframe, downtime/uptime requirements during the migration can be tricky. This session will discuss the different approaches, techniques and tools available for moving…

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

Many database management tasks become more difficult as you move from hundreds of millions of rows and hundreds of gigabytes to data to billions of rows and terabytes of data. Such tasks include ingesting data quickly while maintaining indexes, changing schemas without downtime, supporting many connections, replication, and backup. For some scaling problems (connections, and…

A humorous but serious look at Oracle's DATE, TIMESTAMP and INTERVAL types. In particular, focusing on the common misuse, alternate best practices and techniques for generating date ranges, filling in missing dates within existing data, manipulating timezones and Daylight Saving Time and exposing some quirks of manipulating the data types including illegal-yet-valid dates and indexing.

Attending this session will provide you with the knowledge you need in order to improve quality of service, reduce IT operational cost, and enable real-time insight into business performance for both small- and large-scale Oracle WebLogic Server environments.