We are entering a new era in database with the introduction of the first ever Autonomous Database Cloud. Oracle Database is also switching to a new annual release model to support this new era, with Oracle Database 18c being the first release in this new model. But what does this mean to you and how will it change how you interact with the Oracle Database? This session provides a clear understanding of how our unique Autonomous Database Cloud works and illustrates how it will impact both DBAs and developers. It also provides a unique opportunity to get ahead of the curve and learn what’s new in Oracle Database 18c directly from the Oracle Database development team.
As enterprises look to public cloud to move their on-prem VMware apps, ease of move and performance is top of mind. Join us to learn how Oracle Cloud Infrastructures blazing fast bare-metal servers coupled with hardware assisted nested virtualization can run your VMware application faster on public cloud than you do on-prem, and help you scale your application horizontally or vertically. And yes, with Oracle Cloud Infrastructure Ravello Service you can move the application to cloud in less than a day.
How does the Oracle RDBMS actually work? Despite the complexity and capability of the database, there are just a few things you need to know to understand most of it. In this session I’ll explain them, covering the core structures and activities that drive the RDBMS. Whilst this is an overview presentation it is still technical. The session will help you better understand SQL and database performance, how data moves between disk, memory & your queries, how Oracle ensures you see a consistent set of data and, most importantly, what a “”Consistent Get”” actually is. And why the Datafiles are less important then Redo. If you can write a select statement you can understand everything in this talk – and... Read More
When we create our programs, just getting it to compile is not enough. We want to test if our code does what it is supposed to do. But testing over and over again is time consuming and mostly boring process. You don’t want to run the same tests over and over again. It worked before, so it will work now, or won’t it? This should be an automated process which you can start whenever you want, even when you’re not present. There are multiple unit testing frameworks and tools available to do this job for you. This session will show a couple of them and will show an in depth analysis of utPLSQL and SQL Developer. Although very different in... Read More
Are you using Histograms? Yes, of course you are – even if you didn’t know it. Did you want to use them? Are they helping you get to the optimal optimization plan, or making life harder for the optimizer? I will explain the benefits and threats associated with histograms, how the new 12.2 histogram types make them more acceptable, where they are still a threat and how I usually handle them for greatest benefit in large systems.
Over the years, a lot of new features have been introduced in the Oracle Database to save developers time and to spare them from having to reinvent the wheel. Many of these features are actively highlighted via conference sessions or blogs when a new release is launched but over time are forgotten before they can be put to good use. In this session, we will discuss the critical features that already existing in the Oracle Database, which every developer should not only know about but also utilize. Using easy-to-follow examples, we will demonstrate when and where you should take advantage of these features to make your life easier and help you getting the best out of your Oracle Database, regardless of whether you are a DBA or a developer.
Gartner showing in their report, Top 10 Strategic Technology Trends for 2017, interesting things like Artificial Intelligence and Advanced Machine Learning, Intelligent Apps, Intelligent Things and Conversational Systems. All this added to the buzz on Big Data, the business people realize that data, in all forms and sizes, is critical for making the best possible decisions to win the competition over customers. According to Gartner (Magic Quadrant for Data Warehouse and Data Management Solutions for Analytics 2016), “Organizations now require data management solutions for analytics that are capable of managing and processing internal and external data of diverse types in diverse formats, in combination with data from traditional internal sources. Data may even include interaction and observational data — from... Read More
For metadata fans like me a dream has come true with 12R2: PL/Scope can not only analyse identifiers within PL/SQL but also SQL statements inside your code, i.e. Tables, Views and their columns! It is extremely easy to use, but what can developers actually do with this wealth of information it generates? PL/Scope can support code analysis, checking/enforcing of coding guidelines, refactoring and optimising. I will show – how to query the metadata and how to combine it with other information from the data dictionary. – how the PL/Scope information is already used within SQL Developer – how we can also build our own reports with it – how to use PL/Scope information inside an APEX application Many demos and... Read More
Almost all of the organizations today are moving to consume cloud services in a different configuration – public, private or hybrid. In the lecture, I will cover AWS RDS for Oracle from different angles. We’ll discuss the “DEVOPS” role and the best practices to deploy and RDS service. We’ll discuss talk about the ROLE and the responsibilities of a DBA and the interactions with DEVELOPERS, OPS and DATA scientist. In the end, I’ll present a quick and simple way to deploy Oracle RDS setup using “terraform” script.
Creating beautiful applications with APEX is easy, especially after the introduction of Universal Theme. It is easy to follow the wizards and drop SQL and PL/SQL all over the place in your application thereby creating a maintenance nightmare. When a table is changed, which pages are affected? How can you easily find out? Getting the structure of your application right requires a method to follow. In this session I will share my thoughts on structuring your APEX application. This session will focus on just that: build robust applications; leverage views, packages, instrumentation, etc.
What is Machine Learning and why should I care? In this session we will talk about the basic concepts of Machine Learning: Features, Instances, Binary classification, Scoring and Ranking, and beyond. There are different models used in Machine Learning: logical, geometrical, grouping, probabilistic models, and model ensembles. We will talk about those models and learn a little bit more about Concept learning, Tree models, Rule models, Linear models, Distance-based models, and probabilistic models. After we have learn the basics of the models used in Machine Learning we will talk about Experiments in Machine Learning: what to measure, how to measure, and how to interpret the results. And in the end of the session we will take a look to the... Read More
While the cloud is gaining more and more interest, virtualization has become a common thing. As a result of that, more and more of our customers ask to implement of Oracle VM on Exadata. This session will discuss the project implementation, issue encountered. It will answer following following questions : What it is and what it is not? When could you use it? How does it work? How to install? How to patch? Which pitfalls and problems were encountered and how to solve them? How does it compare to other Engineered systems such as for example the Super Cluster? “
It regularly happens to me that for testing purposes I have to generate load on an Oracle Database. The three most common situations leading to such a task are when I need to: assess the performance of a new platform or disk I/O subsystem; verify whether a set of SQL statements executed on a specific environment and/or configuration fulfills the expected performance requirements; perform usability and functionality checks of tools or utilities that require a non-trivial load to be carried out. The aim of this presentation is to introduce the freely available tools that I use, to explain how I use them, and to present real-world use cases of their utilization.
The headline features of 12.2 are Sharding, Multitenant and Application Containers. But it’s the small changes to SQL that make a real difference in your day-to-day life work with Oracle Database. In this session Chris gives you an overview of the changes to SQL and PL/SQL that will help you build faster, more robust database applications. If you’re a developer or DBA who regularly writes SQL or PL/SQL and wants to keep up to date this session is for you!
You might (or might not) have heard of Docker. But you have no idea what it is and why you should care. But if you are a database or APEX developer and still work with Virtual Machines, it is about time to broaden your horizon. In this session you’ll learn what Docker is and how you can benefit from it in your daily work.
For some reports the fastest way to get them done is to use an index to go straight to the rows of interest, but sometimes the only way that makes sense is to scan the entire table. I’m the Oracle Architect for Smart Scan and the engineer in Oracle co-responsible for the table scan driver and this talk will show what happens under the covers in simple easy to understand steps. We will look at (1) what is a granule in PQ (2) how exactly does the system decided whether to use buffer cache to direct read, (3) how is physical I/O done including Multi-Block reads and Async-I/O (4) what wait events and stats to look at (5) what tuning... Read More
Apache Kafka is a massively scalable message queue that is being used at more and more places connecting more and more data sources. This presentation will introduce Kafka from the perspective of a mere mortal Oracle DBA and share the experience of (and challenges with) getting events from the database to Kafka and possibly even backusing different solutions and connectors including poor-man’s CDC using flashback query and replication tools like Dbvisit and Oracle Golden Gate.
This lecture will focus on providing important guidelines, recommendations and best practices for writing efficient and optimized SQL statements while ensuring high level of performance and response time. We will explore how to write well-tuned SQL statements and see some different ways in which the Oracle optimizer can access data in tables and indexes, rewriting complex sub-queries, using the WITH clause and scalar sub-queries, using EXISTS, using new caching features, implementing new optimizer statistics features, interpreting execution plans, taking advantage of bind variables, using hints.
In this presentation we will introduced Ansible and explore how it can be used to automate Oracle activities enabling DBA’s and DevOps teams to be more agile. The presentation will build upon examples shared ending with a demo of cloning an Oracle database using an Ansible playbook.
Learn about Oracle’s community recognition programs, the Oracle ACE and Developer Champion programs. How can you get involved and what are the benefits for you professionally and personally. For women, why it is important to be recognized for your contributions and how you can find a mentor.
The model clause is a very powerful addition to the sql language in Oracle. But just like stepping up to a real-life model, taking the first steps with the model clause can be a bit scary because it’s not quite like what your used to. Because of this a lot of people looked at it once and plan to look at it again some day. That’s a shame because there’s a lot the model clause can do for you once you get past those first steps. This presentation will help you get passed that scary first contact. It will explain the general syntax and how it works, and will show some real-life problems that can be solved with it. After... Read More
In recent years there has been a rapid surge in the adoption of smart devices. Everything from phones and tablets, to smart meters and fitness devices, connect to the Internet and share data. With all of these smart devices comes a huge increase in the frequency and volume of data being ingested into and processed by databases. But what most folks forget is, industries like telecoms and manufacturing have been dealing with these challenges for years with the help of the Oracle Database. This session provides step-by-step instructions on deploy a high-ingest, mission critical IoT workload with the Oracle Database.
By taking full advantage of the new Row Pattern Matching functionality in Oracle Database 12c, you can quickly solve new problems – and old problems in much more efficient and scalable ways. This session will present general-purpose techniques for bin fitting problems, hierarchical summaries, temporal validity queries and joining or summarizing data by ranges. By decreasing CPU use, these techniques run 50 to 300 times faster than existing solutions, with or without Exadata or the In-Memory option. The pattern matching features of the most recent version will be presented. This session is geared primarily to SQL practitioners who are willing to unleash the full power of SQL in the Oracle database. They will learn how to apply row pattern matching... Read More
PL/SQL and SQL naturally work well together. We can use PL/SQL to extend SQL in any way we want. A PL/SQL function is treated by SQL as though it is part of the language and gives us great flexibility to improve and simplify our code. However, there are performance considerations with calling PL/SQL from SQL. In this presentation I cover those concerns and also enhancements in Oracle 12c & 11g that improve performance. There are also dangers with calling PL/SQL functions from SQL which can give unexpected (and sometimes wrong) results – which are often overlooked. I explain those issues and how you can avoid them.
The time-based analysis of SQL performance issues is teached and lived actively throughout the database world. It proved its value many times, and is often a good way to solve problems. But with only little or no knowledge of the application behind, performance analysts have difficulties to monitor the timing behavior of software components in a reliable way. Especially within an Oracle execution plan, the measured execution times depend on too many factors and variables. Buffer Gets instead, are easy to count and a good “”Unit Of Work”” to hunt for. The aim of this lecture is to show, how to analyze execution plans with very small knowledge about the application, and with on-board utilities of the Oracle Database. My... Read More
Oracle 12c Multitenant is a great option for implementing Database Consolidation which can definitely makes the Oracle DBAs life much easier from an administration standpoint. Having said that, it is critical to make sure you understand how to effectively monitor and diagnose performance issues in Oracle Multitenant environments and if needed implement resource management plans to ensure high QoS (Quality of Service) for the pluggable databases.
Do you want to get up to speed with the most current release of the Oracle database? Then this session is for you. You will learn the most exciting and most useful new features from the Oracle Database 12c which can make your work as database developer a lot easier. There is more to the Oracle database 12c than just pluggable databases.
For decades developers and DBAs have battled over who controls the world. With each new development paradigm the battle flares again as developers push DBAs to adopt and support new data structures (JSON), new APIs (REST services), new technologies (In-Memory) and new platforms (Cloud). In this session, Gerald takes on the role of lead developer on a project to deploy a RESTful web-based application, while Maria takes on the role of the DBA. Through the use of live demos, they learn to work together to find a solution that will allow them to embrace a more agile development approach, as well as the latest technology trend without exposing the business to painful availability or security vulnerabilities. Can developers and DBAs peacefully coexist? Join us in this session and find out!
Instance and SQL tuning with EM12c Cloud Control is so easy, it is not even much fun anymore. Also, not every customer may have the appropriate license or database edition, or all you have available remotely is a command-line login to a database. This presentation showcases a few open-source database tuning tools such as Snapper and ASH replacements that DBAs can use to gather and review metrics and wait events from the command line and even in standard edition. This is done by dissecting the familiar performance pages in EM12c, explaining the underlying statistics and showing how similar observations can be made in other tools.
Diagnostic Pack, which is an option available for the Enterprise Edition of Oracle Database only, gives access to a number of dynamic performance views and to the Automatic Workload Repository (AWR). Both are very useful for the identification of performance problems. On the one hand, dynamic performance views are mainly used for the analysis of performance problems while they are occurring. On the other hand, AWR is aimed at the analysis of performance problems that occurred in the past. The aim of this presentation is to describe how to perform analyses similar to those that can be carried out with the tools provided by the Diagnostic Pack even if you don’t have it.
In this fun session you’ll see SQL used in new and exciting ways. Chris will perform SQL “magic tricks” including: Cups & Balls: in SQL version of the classic “cups and balls” trick, watch as rows magically jump from one table to another Find the Card: Chris will attempt to find a “card” (row) chosen by an audience member from a “deck” (table) The Magically Changing Data Type: watch as a number changes to a date and back again! But unlike real magicians, he’ll show you how the tricks work. This will enable you to perform your own “SQL magic” and build better Oracle Database applications. This session is for developers looking to expand their SQL skills and see what... Read More