Oracle Database 12c is designed for the cloud. With its unique Multitenant architecture you can reduce both capital and operating expenses and increase agility, and it’s easy to adopt and use. Attend this hands-on lab to experience the exciting capabilities of Oracle Multitenant for yourself.

Missed Oracle OpenWorld? then this a catch-up session for DBAs and Oracle Technologists on what are Oracle's Infrastructure as a Service offerings and how they are applicable to your job role, someone on your team,or within your company.

Do you want to migrate big database to the cloud or to a different data center with minimum downtime? That is your answer, use 12c database RMAN new features. Different OS platform? Want a version upgrade at the same time, - no problem.  Minimize downtime applying incremental backups. Use compressed backup sets or  storage split…

Success of an application depends on its performance and its cost of maintenance. Interestingly both of these factors are largely influenced by the simplicity of the algorithm and it is also important to choose the right application layer for executing this algorithm. Often accessing and processing “data” plays the pivotal role in an application’s performance.  So we can say that writing simpler data access and process algorithm we can make an application faster and scalable. Needless to say that the application should also be free from contention and locks at runtime.

Here is an architecture to apply these principals in a traditional system built with Oracle and Java.

Lets talk about accessing data – Oracle provides one of the fastest way to access data. So as a principle we will always depend on Oracle technology for accessing data. We will use simple SQL, well-designed table, pinpointed index and partition to access this data in a very fast manner.  We will not write complicated SQL which may give inefficient and complex plan which will always be slower. We will segregate data from processing so that complexity of processing doesn’t make data access complex. A complex data access is a very slow process.

Lets talk about processing data – Java (or a comparative Language) is a very fast processing engine because they entirely work in memory. It can be multi-threaded to use all cores of the server. It provides functional and object oriented paradigm to write complicated algorithm in a simple way. In-memory (soft) data structures can be built to suit the exact need of your algorithm so that finding data will be fast. This will be harder to achieve in a hard data structure like database index. So as a principle we will push execution of algorithm into Java.

Lets talk about contention and locks – Adopt immutability to protect the application from locks. Find a natural boundary/partition of data, which can be processed independently from each other. The more granular this partition is the faster your application will be. With immutable code, an in-memory process can be largely free from any contentions and locks. Whereas data access can not be as contention free because logically granular data may be sharing the same disk location and hence bottlenecked due to things like hot blocks, segment contention etc. So to build a contention free application we will prefer Java (or a comparative language) over a complicated SQL.

A real life application built on these principles yielded 10 times better performance as compared to a system built using complicated SQL.

From driving in traffic to being served at a restaurant, every person feels the impact of queuing theory. Queuing theory beautifully relates time and work into terms we can feel, like utilization, workload intensity, response time, elapsed time and systems architecture design. With only the basics we can use queuing theory to derive targeted performance…

Managing/deploying code changes is an essential task in all software development projects.  It’s a problem that’s largely solved for application code, however, it’s still a challenge in many projects to manage database schema changes.

With the release of 12c, Oracle introduced a licensed option, the Database Lifecycle Management Pack to address this issue.  I’ll be discussing an open source alternative called “Liquibase”. I’ll describe how to support multiple developers working on several branches and how to manage thousands of schemas deployed in heterogeneous database environments.

I’ll show you how to migrate existing database schema code, create a strategy to minimize upgrade time and how to extend the framework to enhance its capabilities.

Big data is one of the biggest buzzword in today's market. Terms like Hadoop, HDFS, YARN, Sqoop, and non-structured data has been scaring DBA's since 2010 - but where does the DBA team really fit in? In this session, we will discuss everything database administrators and database developers needs to know about big data. We…

This hands-on-lab will help you to understand the concept of data virtualization and how it is used to provision virtual databases and applications. You'll learn how to create, refresh and rewind virutal databases.

The session will Introduce key new features that will be available with "Oracle Real Application Clusters 12c Release 2" Introduce best practices for deployment, Management, Availability and Performance tuning Cover internals of the key features so DBA's can understand how the feature will help with their day-to-day activities