With the increased adoption of the Cloud, security professionals often face the challenge where they have to apply security controls efficiently for databases both on-premise and in the Cloud. This session will address the challenges related to managing audit data collection and encryption keys in hybrid scenarios, by maintaining the audit data and encryption keys…

At this session you will be able to understand the structure, concept the how they match with Internals, once you understand the structures you will be able to decide when, where and how to create indexes in order to improve your queries. Here you will know miths, tricks and best practices, recommendation based on the experience.

At this session you will be able to understand the structure, concept the how they match with Internals, once you understand the structures you will be able to decide when, where and how to create indexes in order to improve your queries. Here you will know miths, tricks and best practices, recommendation based on the experience.

At this session you will be able to understand the structure, concept the how they match with Internals, once you understand the structures you will be able to decide when, where and how to create indexes in order to improve your queries. Here you will know miths, tricks and best practices, recommendation based on the experience.

An introduction to key skills a database developer should have in his/her toolbelt. Including sql and pl/sql syntax as well as monitoring and debugging tools such as explain plan, tracing and profiling. Differences in db versions will be noted as each feature is discussed. In addition to (often overlooked) fundamentals, the presentation will discuss approaches…

An introduction to key skills a database developer should have in his/her toolbelt. Including sql and pl/sql syntax as well as monitoring and debugging tools such as explain plan, tracing and profiling. Differences in db versions will be noted as each feature is discussed. In addition to (often overlooked) fundamentals, the presentation will discuss approaches…

An introduction to key skills a database developer should have in his/her toolbelt. Including sql and pl/sql syntax as well as monitoring and debugging tools such as explain plan, tracing and profiling. Differences in db versions will be noted as each feature is discussed. In addition to (often overlooked) fundamentals, the presentation will discuss approaches…

An introduction to key skills a database developer should have in his/her toolbelt. Including sql and pl/sql syntax as well as monitoring and debugging tools such as explain plan, tracing and profiling. Differences in db versions will be noted as each feature is discussed. In addition to (often overlooked) fundamentals, the presentation will discuss approaches…

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.

This is a continuation of “Oracle11.1 to 11.2 – In giant steps” session. The previous session talked about what you need to think about before starting the migration. This session continues the process to discuss the specific steps needed to upgrade from Oracle11.1 to Oracle11gR2.