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
Organizations are struggling to manage and standardize an ever increasing number of database deployments. This presentation shows how scripting and automation tools can be used to provision databases and to manage resources like users, tablespaces, instance parameters and settings in general. With this setup one can manage a large range of systems from a very small set of descriptive text based configuration files. Moreso, these configs are easily managed in a revision control system like git enabling agile workflows for database change management.
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
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 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.
This session will be split into two. The first part will be quick overview of the most exciting new features in MySQL version 8, the upcoming new version. The second part will be a live demo of InnoDB Cluster, MySQL newest fully-Sync HA solution, in action.
Companies increasingly need BOTH Corporate data in Oracle and Big Data on HDFS and then find they need to integrate the two into common reports. This talk presents an overview of how Big Data SQL enables you to run Oracle queries seamlessly across both sets of data and use Oracle analytics against data on HDFS. The talk will take a look at how Oracle offloads queries to Smart Scan on HDFS and how to use Oracle security features such as redaction on HDFS data.
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
Starting from common problems facing SQL developers, this session will show how the MATCH_RECOGNIZE clause provides more straightforward and efficient solutions than pre-12c methods such as analytics or the MODEL clause. Some of the problem areas covered are: grouping sequences; grouping based on intervals or running totals; and bin fitting problems. These real-life examples will illustrate both basic and advanced syntax, with a focus on regular expressions. Attendees will learn how to think of common problems in terms of pattern matching; how to discern problem types that the MATCH_RECOGNIZE clause can help solve; and how to work around some limitations, including the major pitfall of regular expressions: catastrophic backtracking.
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!
Next Insurance was founded in the beginning of 2016 and first lines of our production code started accumulating in May 2016. As the first backend developer I have started writing in Java and out of curiosity was experimenting with Kotlin. Kotlin just saw its 1.0 release two months earlier. A year later our entire backend development team is writing all of the code in Kotlin. We have 6 microservices and several AWS lambda functions all written in Kotlin. Migration from 1.0.x to Kotlin 1.1 was smooth and our developers are happy. In this talk I will cover the language features and why I think it is awesome and how it fits perfectly to our architecture.
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.
Garbage collection is the most famous (infamous) JVM mechanism and it dates back to Java 1.0. Every Java developer knows about its existence yet most of the time we wish we can ignore its behaviour and assume it works perfectly. Unfortunately this is not the case and if you are ignoring it, GC may hit you really hard…. in production. Furthermore the information that you may find on the web can be a lot of times misleading. In this talk I will try to demystify some of the misconceptions around GC by understanding how different GC mechanisms work and how to make the right decisions in order to make them work for you.
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.
Virtualization as a backbone technology – an all-time-high topic, and much older than the current buzzword wit the capital C. Not uncomplicated regarding licensing and handling, such a hypervisor hides a bunch of nasty surprises for the unprepared. The talk will have a focus on OLTP and shows, how to optimize VMware for good, stable and predictable performance of an Oracle Database. But before we can do that, we need to know analysis with limited capabilities: I’ll show the “locked-in DBA” how to find out about available resources, if he is deprived of them and how and when they are missing. The Oracle database is a powerful, beautiful and joyful utility to achieve that. And yes, it can cause tears... Read More
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. Learn more about Oracle’s Startup program, recently launched in Israel, and see how Oracle works with startups and entrepreneurs to give them access to unique knowledge and expertise, cutting edge technology and a huge customer base to accelerate their growth in the enterprise space.
Get to know the latest Java release and the goods it brings: turn your apps into modules and generate standalone images, enhance your streaming capabilities, walk through stack trace like never before, enjoy shell scripting with pure Java and many more!
It’s the small things that make your life beautiful, and it’s the same with SQL Developer. The best things are often just a mouse click or a keyboard shortcut away but you don’t see them because you weren’t looking for them. During daily business one tends to forget to “sharpen the saw”. This condensed session is the opportunity to make up for it and find out how to be more efficient with SQL Developer. Being someone who hates repetitive tasks I put quite a bit of effort into finding many of the “hidden” little helpers and I would love to share them to make everyone a happier SQL Developer user. I will cover different aspects like customising your workspace, the... Read More
For more than 25 years, MySQL has been a de-facto infrastructure piece for web applications. MySQL provides a solid relational database that enables companies to build systems that perform well in many use cases. In this talk, I will bring an intro to MySQL and a new revolutionary Feature in MySQL InnoDB Cluster a complete high availability solution for MySQL. a quick introduction to MySQL InnoDB Cluster Demo
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
In this session, we will review 2 case studies of organizations that have recently made the move from clipboard and paper / back office systems to tablet based mobile inspections. Learn best practices and strategies how to modernize your back office apps including considerations such as Security, device management and how to choose your tools and platforms. Includes live demos of Israeli customers who have gone digital.
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
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 will demystify the Hadoop ecosystem and explore the different components. We will learn how HDFS and MapReduce are changing the data world, and where traditional databases fits into the grand scheme of things. We will also talk about why DBAs are the perfect candidates to transition into Big Data and Hadoop professionals and experts.
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.
Reveal the power of dynamic invocation on parallel streams with Java functional programming. Learn how to use LAMBDA expressions and method references and create your own for implementing functional programming. Discover how to create your own functional interfaces and use it correctly on server-side developments.
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!
We at Oracle Data Cloud are building an identity graph that connects all the fragmented presence of a person, both online and on the real world, into a single concise view. This allows us to better model a person behavior, target her, and measure the effect of a campaign on her actions. To build this graph, we apply a tiered model that can handle the very large scale of the graph (composed of billions of points) and be able to utilize the different signals we collect for a person presence. This model uses a collection of Machine Learning and Graph Algorithms that enable us to solve for identity while controlling the scale and the accuracy of the results. In this... Read More
Bi is can be a complex matter in big organisations. This presentation will tell the story about a strategic business decision to move the on premise BI stack to the Microsoft Azure cloud. The main focus is on how the Oracle Database is moved as the application servers were moved using a lift and ship mechanism. This presentation will cover – how we managed to move +300TB divided over several multi Tb databases to the cloud – which services were chosen to run the database servers and why – how performance testing and sizing has been done – how automatic provisioning has been done for providing developers what they need in agreed SLA’s. – how we dealed with the short... Read More
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.
AI – the newest buzzword, or a viable way to bring your business into the next generation? In this session, learn what all the hype is about and how you can leverage the newest trend to help your customers, and employees get the most out of your Applications. What is the anatomy of a chatbot? What products, languages do I need to have in my toolbox? What do I need to know to get started? help me build my first BOT and where do I turn to learn more ? Are all questions we will answer in the session. We will also show demos of ChatBots and how one comes to life!
RAC is regarded as a commodity, but so many organizations implement it incorrectly. This talk goes trough the basics of what you need to know about RAC on Oracle (12c): – What is RAC for, exactly? – Understanding the archtecture – ASM basics – Understanding services and GDS – How the Scan listener works – Fast Connect Failover – Memory – What apps do wrong – What happens when a node crashes – Troubleshooting and more.
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