Big Data is growing exponentially, requiring massive-scale infrastructure however, business analytics has shifted from reactive to proactive analysis; this is the era of streaming data (a.k.a. Fast Data). Apache Hadoop is very good for analyzing data at rest but cannot handle streaming data. Big Data analytics needs new Big data frameworks. Apache Spark brings in-memory processing and…

There are a lot of considerations on how to move Oracle from on premise to AWS. Should we spin up an EC2 instance and install run and Oracle database there?  Should we use Amazon's Relational Database Service?  What do we still do in AWS RDS?  Should we convert from Oracle to MySQL, PostgreSQL or Aurora?  How…

Modern IT trends pose new challenges in database management. Databases exist on-premises and in the cloud, and these databases should support DevOps and business agility with the same management tools. Oracle Management Cloud introduces new and exciting capabilities to tackle database management challenges with modern IT. Oracle Management Cloud’s database management service provides a rich…

This talk covers a real-world solution, that recreates database links using ORDS, REST and JSON. It breaks the limits of database links by loosely coupling two databases. The complexity is completely hidden from users and developers. Modern technologies such as REST and JSON offer elegant ways to couple databases without fixed dependencies. The protocol http(s)…

Many DBAs are faced with the task of migrating and updating older Oracle databases to newer platforms and to Oracle12c, sometimes on-premises and sometimes to the cloud.  Frequently an endian change adds additional complexity.  Outage time constraints add to the challenge. While Data Pump may seem like an obvious choice, it does introduce many issues…

One of most commonly used architectures for in a database as a service (DBaaS)  cloud is virtualizing database. In this architecture, all the Oracle databases are running on virtual machines. To provide a database service, virtual machines with database preconfigured are dynamically provisioned. This session will discuss the two most commonly used virtualization methods: Oracle VM and VMware.

This session provides 360–degree insight into Exadata performance. Learn how to identify and remediate common performance problems across your entire Exadata system, correlate Exadata-specific metrics in a single pane of glass, rapidly troubleshoot problems using Exadata logs, and analyze resource usage in order to gain insight into consumption patterns and utilization. Purpose-built machine learning provides…

Security acts always against performance. On many occasions the necessity to limit access to data is paramount regardless of the cost. One of the methods to enforce data confidentiality it is to encrypt data - either by application means or by using Oracle Advanced Security Option. In this presentation I would like to shed some…

The only group of Oracle specialists that continues to stay outside of the cloud hype are server-side developers. Everybody else (from CFOs to DBAs) are frantically trying to figure out what is happening and how to survive in the rapidly changing environment. Nevertheless, developers still hope that either their DBAs are good enough or their CFOs are charitable enough to make the system work. They are wrong – both in the technical and in the political/corporate sense!

Politically, developers are missing tectonic shifts: (1) hardware resources are no longer static and (2) expense model is “pay-per-use”. Previously, as long as your current servers were surviving the workload, no one cared whether they were 50% or 70% utilized. Now, this difference can be immediately converted to real money because the resource elasticity means that you can give it back. As a result, the total quality of the code base (+performance tuning efforts) has a direct impact on cost. This presentation will share some of the corresponding best practices:

Code instrumentation – to solve any performance problem you first need to detect it! You can place markers yourself or by using DBMS_APPLICATION_INFO, but this task must be done.
Profiling – even if you can detect a performance problem, you need to find its exact location.  The Hierarchical Profiler is your best friend in that search.
Code management – proper versioning helps to ensure that new fixes don’t introduce new problems. Edition-based redefinition (EBR) could streamline such efforts. 

Technically, the shift is a bit more subtle. For years, the whole industry “knew” that for any large system the most limited resource was I/O bandwidth. In reality, that was mostly due to the fact that CPU resources were over-allocated (Black Friday!). In the cloud, you cannot afford such over-allocation all the time. Don't forget that the introduction of solid-state drives decreased storage latency. Together, these two factors caused cloud-based systems to suddenly become CPU-bound! Fortunately, you can do a lot with your code to make it less expensive:

Avoid context switches between SQL and PL/SQL - using PRAGMA UDF or WITH-clause can help a lot. 
Don’t reinvent the wheel – There are some very powerful SQL features (for example: analytical functions, PIVOT/UNPIVOT) that are often ignored by the majority of developers.
Don’t do things multiple times - various caching techniques can help reuse what’s already known.
Collections in-memory processing are still the fastest way of calculating anything. Wide usage of SET operations decreases the number of context switches as well.

Overall, it is possible to make your system cloud-friendly, but doing so takes explicit efforts and serious thinking. This presentation will help you by utilizing real-world examples based on years of experience.

This talk is all about how an Oracle DBA has been using the Python programming language in his work and why Python might be a good language for other DBAs to use. There are hundreds of programming and scripting languages. Why Python? Also, database administrators are not full time programmers. Should they learn a programming…