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.

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.

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.

Database as a service (DaaS) is becoming a reality. More and more datacenters are moving to a self-service model in which users can request a database and get it in minutes. In this session, learn how Oracle Enterprise Manager enables such agile database-on-demand environments, supplemented with metering and chargeback.

This hands-on lab will walk participants through how they can extend Oracle Social Network into their existing business applications including Portals and other web applications.  Participants will learn how to use the embedded UI components including iFrames and ADF taskflows provided by Oracle Social Network into a variety of environments.  Some knowledge of web based…

Hierarchical structures are a fundamental part of any contemporary IT system consisting of organizational chains, responsibility trees, etc. But in the database world, still there is no clear consensus about the best way of working with these designs. For years, database professionals became accustomed to CONNECT-BY clauses (with all of their additional functionality), which are…

This is a two-part session that will take place on Tuesday and Wednesday. One of the most critical aspects of building effective systems is the successful management of unstructured information. The database is no longer only a place to store dollars and cents for accounting purposes. Documents, images, videos, podcasts, etc. must be sorted out…

A database cloud is a model for enabling convenient, on-demand access to a shared pool of configurable computing resources. These resources can include servers, storage, applications, and services, which can be rapidly provisioned and released with minimal management effort. Oracle Real Application Clusters (RAC) provides the required functionality to enable such a database cloud. You…