Tag: IOUG

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.

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…