With large multi-terabyte databases it can be difficult to quickly back out a large amount of database changes. One way to back out changes and have your production database up and available for use is to use Flashback Database. And you can back out the changes from your large standby database by using Snapshot Standby.…

Partitioning and compression are technologies that have been in the Oracle database for a long time. The EXCHANGE PARTITION command is the key to large-scale and scalable data loading in a data warehouse, and a key prerequisite for the effective use of compression. But now there are many different types of compression available in Oracle…

Partitioning and compression are technologies that have been in the Oracle database for a long time. The EXCHANGE PARTITION command is the key to large-scale and scalable data loading in a data warehouse, and a key prerequisite for the effective use of compression. But now there are many different types of compression available in Oracle…

This presentation will discuss the latest Oracle database features certified and supported by SAP applications. This presentation is targeted for Oracle DBAs and SAP basis administrators responsible for managing an Oracle database running under SAP applications.

Databases keep getting bigger and bigger. Business applications that utilize ever-growing databases are expanding at an alarming rate. To stay competitive, businesses require additional functionality, and the technology needed to make that functionality possible keeps getting more complex. To make matters worse, the DBAs needed to keep it all running are hard to find and…

The world has gone mobile so why haven’t your enterprise applications caught up? As more than 85 percent of today’s population owns at least one mobile device, it’s no wonder system users expect to access their applications from their mobile. Stop daydreaming about running your systems on mobile devices and start developing! This session will…

The world has gone mobile so why haven’t your enterprise applications caught up? As more than 85 percent of today’s population owns at least one mobile device, it’s no wonder system users expect to access their applications from their mobile. Stop daydreaming about running your systems on mobile devices and start developing! This session will…

The world has gone mobile so why haven’t your enterprise applications caught up? As more than 85 percent of today’s population owns at least one mobile device, it’s no wonder system users expect to access their applications from their mobile. Stop daydreaming about running your systems on mobile devices and start developing! This session will…

Oracle 11g has been in production since July 2007 but to-date, its statistics gathering procedure DBMS_STATS, is not well understood nor has it gained the confidence of users to accept its default parameters. This paper will demonstrate with examples and demos how the DBMS_STATS statistics gathering has improved significantly and is gathering more accurate information…

Oracle 11g has been in production since July 2007 but to-date, its statistics gathering procedure DBMS_STATS, is not well understood nor has it gained the confidence of users to accept its default parameters. This paper will demonstrate with examples and demos how the DBMS_STATS statistics gathering has improved significantly and is gathering more accurate information…