The presentation is about performance testing results Accenture have made for OCI-C, OCI and latest OADW against leading cloud provider. We also compared how much would cost to run similar amount of transactions in competitors cloud. Results are stunning!! The presentation include also live demo on Oracle Autonomous Database.
Everybody knows how important testing is, but hardly any developer writes repeatable tests. This session will show you how Unit Testing can help your developers getting more productive and more confident about their results. 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... Read More
This talk will look at how Oracle Table Scans work (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 (4) what wait events and stats to look at and how to trace what is happening. 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... Read More
The *Data Visualization Desktop* is an amazingly powerful tool for understanding and visualizing your data – all sorts of data – in many different ways. DVD lets you explore your data sets, apply various interactive visualizations, and finally create powerful narratives to present your findings. One little known possibility is to use *maps* as a visualization, next to pie charts and histograms. This session will explain how you can use this capability. You will learn how to use the predefined maps included with DVD to view your sales figures, your dropped calls, your employment statistics. You will also learn how to use your own maps for that: your own sales territories, school districts, store locations. Even product placement inside your... Read More
Patching and the vulnerability space is a very hot topic at the moment. Given all the news coverage to hacking incidents the CEO’s are now starting to take an interest. This is a high level talk on how to implement an automated patching solution and the issues/concerns associated with this. This talk is about how to implement an automated patching solution across a varied Oracle estate. It covers the tools that were considered and how we made our final decision based upon what was technically possible and what was available to us. We also cover the pitfalls of implementing our solution. This talk includes a basic overview of the patching model and the path we chose (PSU/CPU/RU/RUR/BP). The solution we... Read More
Machine Learning is used everywhere. In this presentation we will see some examples of machine learning used in real life. For example how does Facebook use ML, what business areas could take advantage of chatbots and how can Oracle SQL Developer be used to find the potential customers.
A new clause – MATCH_RECOGNIZE – was added to the SELECT statement in Oracle 12c, to allow recognizing patterns in sequences of rows. This new capability is very powerful, and introduces a completely new (yet somewhat intimidating) syntax. It allows solving a variety of problems in a simpler way than before, and with better performance. In this session we’ll focus on this new feature, understand its syntax (and see that it’s not as difficult as it seems), learn how to use it and see many useful examples.
Oracle Database 18c. It marks the start of a new yearly release schedule and version numbering system. As always, there are lots of cool new features to help developers build better applications using Oracle Database. This session covers the key new SQL & PL/SQL features of 18c. These will make it easier for you to write faster, more robust, secure applications using Oracle Database. 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!
In this presentation Ron will discuss *DevOps* and the explore why automation is key to developer agility. Ron will show how automation can accelerate development and improve quality by ensuring consistent platform configurations and by delivering the right data to the right people, fast! Ron will share **Ansible** code and demos and provide delegates enough knowledge to start creating their own Ansible playbooks.
Since not all companies can move their data to cloud , especially the financial sector , Oracle can bring the “cloud” on premises thus having all the cloud features within a companies LAN and network. In this session we shall explore the implementation of Oracle Exadata Cloud at Customer (EXACC) which is based on an Exadata system configuration that contains a predefined number of compute nodes (database servers) and a predefined number of Exadata Storage Servers, all tied together by a high-speed, low-latency InfiniBand network and intelligent Exadata software. The session is based on a true implementation done at a financial customer
Introduced in Oracle 18c, the Autonomous Data Warehouse (ADW) provides a tightly-controlled environment for application workloads focused on analytic reporting and data warehousing. Find out the details of how to take advantage of ADW features and understand what ADW means for Oracle DBAs.
Every time I present about machine learning at least one attendee asks me what language is the best for machine learning. That is a question I can only reply: it depends. In this presentation I will demonstrate three languages: R, Python and SQL. Hopefully after seeing this demo you will have a better understanding which of these three would suite you the best.
Have you learned the syntax of analytic functions? Seen many presenters demonstrate with nice short examples how smart analytic functions are? And then went home and thought: “”Well, they may be smart, but how can I use them in my real work?”” I’ve used analytic functions in thousands of SQL statements in more than 15 years developing our application. I can’t imagine coding SQL without analytic functions, as they allow me to put much functionality in SQL that otherwise might have needed procedural looping. Boss is happy as well, as the application perform much faster. In this session I’ll showcase several of the real life use cases of analytic functions I’ve made over the years, hopefully serving as inspiration to... Read More
While the adoption of agile methodology and DevOps automation are a common place among “”regular”” development teams, adopting those in the world of the database has some unique challenges. In this demo driven session we’ll show you how to: Manage database modifications scripts Automate rolling database structure changes across instances Leverage test driven development with the Oracle DB Manage and track an agile development process for your team Leverage Free and Open source tools and utilities such as FlywayDB, Liquibase, UT/PLSQL, Git, SQLDeveloper and more Leverage Oracle’s cloud platform to achieve this easily In this demo driven session we’ll teach you how to: Manage database modifications scripts Automate rolling database structure changes across instances Leverage test driven development with the... Read More
We should be careful with mixing SQL and PL/SQL. The context switches between both engines can quickly kill performance. For quite a long time now Oracle supports bulk operations in PL/SQL, minimizing these context switches when executing SQL from PL/SQL. Version 12c of the database finally brought us similar enhancements for the other way around: the use of PL/SQL (function calls) from within a SQL statement. Starting with that edition subquery factoring (the with clause) can also include definitions of PL/SQL-functions and (yes, even) -procedures for use inside your query. And then there is the option to compile functions and procedures in the database/packages for use by the SQL engine, using the udf pragma. This presentation will show both features... Read More
Both graph analysis and machine learning can be used very effectively to detect patterns, similarities and anomalies in datasets. The former is particularly useful when data can be represented as a network in which the connectedness of data, ie. the explicit relationships between entities, play a role. Social network analysis is one obvious example, but the approach is applicable to a wide range of use cases in e-commerce, fraud detection, cyber security, and so on. In this session, we will show that graph analysis and machine learning are complementary techniques. We will describe how to create, manage and analyze graph data with Oracle technologies and how to visualize results of graph processing. For the integration of machine learning, we will... Read More
Oracle External Tables have become richer in the last 5 years with the addition of the ORACLE_HIVE and ORACLE_BIGDATA, Big Data SQL and Partitioned External Tables. We’ll discuss: the different driver types, security, datatypes , I18N, and PQ, and for the DBA: dictionary, tracing, and wait events. It has long puzzled me that I’ve never seen Oracle External Tables as a talk at any OUG but they are an essential part of any DBA’s arsenal. Oracle External Tables have become much richer and more complex in the last five years with the addition of – ORACLE_HIVE and ORACLE_BIGDATA drivers, and Big Data SQL – Partitioned and hybrid external tables – In -Memory External Tables This talk aims to review the... Read More
Moving your data center to cloud is done in phases, some of the enterprise would like to partially move to the cloud. This session will describe ways to use hybrid Data Guard connecting your on-premise database to a standby in Oracle Cloud Gen 2. Come see Data Guard and Far Sync best practices in action. The session concentrates on: Setup the network (site to site) between our data center to the cloud Building the Physical Standby Building the Far Sync Configuring Data Guard Broker Setting RMAN Archive Retention
Sick and tired of writing thousands of lines of middle-tier code and still having performance problems? Let’s get developers to become fans once again of the database, by showing them just how powerful the SQL language really is! Coding is great fun, but we do it to explore complex algorithms, build beautiful applications, and deliver fantastic solutions for our customers, not just to do boring data processing. By expanding our knowledge of SQL facilities, we can let all the boring work be handled via SQL rather than a lot of middle-tier code, and get performance benefits as an added bonus. This session highlights some SQL techniques to solve problems that would otherwise require a lot of complex coding, freeing up... Read More
Oracle Database with Sharding is a globally distributed multi-model (relational & document) cloud-native (and on-premises) DBMS. It is built on shared-nothing architecture where data is horizontally partitioned across databases that share no hardware or software. It provides linear scalability, fault isolation and geographic data distribution for shard-amenable applications. Sharding does all this while rendering strong consistency, full power of SQL, and the Oracle Database ecosystem. Attend this session to learn how you can deploy a sharded DB and elastically scale your transactions, database capacity and concurrent users. The session covers Oracle Sharding 18c features such as user-defined sharding, RAC sharding, Multitenant support etc.
Data Vault is a great methodology for a datawarehouse. In this presentation we will see how a Data Vault DW can be designed using Oracle SQL Developer Data Modeler and many of its amazing features, including DDL Transformations and Table DDL Transformations amoung others.
You will hear about the newest kid on the block Oracle’s Digital Assistant Service and how it can help transform your app from another icon cluttering your phone to a transformative part of your business. These digital agents will be able to support not only today’s business needs but what’s coming next to server mobile strategies into the future. We will also show a live demo and customer case study.
The Oracle database includes tons of features for developers, and because of that we sometimes miss some of them – good and useful features that many developers either don’t know about them or assume they are not supported in their licensed edition or options. This session focuses on such features – by introducing them, exploring them, showing when they are useful and how to use them.
We will discuss several techniques to improve Dw running on Oracle 12c: MVs, including query rewrite Partitions IMDB Parallel queries We will see the pro and cons of each option,what gains are possible,how to use them,how to avoid pitfalls, possible use cases,etc
Learn the docker abilities. Which docker features are worth a closer look at? In what context do the new features and option do make sense? How can a Lab environment can be improved in general with Oracle database 18c? Where does it make sense to invest in dockerizing Oracle Databases? Objectives 1. Understand Docker capabilities 2. Install Docker 3. Create your own Docker images 4. Connect Database within a Docker
What does Autonomous mean to your organization and and its goals? Perhaps more importantly, what does an Autonomous future mean for DBAs. This session will walk through the Autonomous database offering, and how to configure it for use within your organization. We’ll also talk about the features and restrictions that are imposed, and most importantly – does it mean all DBA’s are out of a job?
Oracle database 18c introduces Polymorphic Table Functions. This session will tell you about Polymorphism and how you could apply this in pre-18c databases. After this session you will understand when to use which technique. Oracle database 18c introduces Polymorphic Table Functions. This session will tell you about Polymorphism. How can you apply this in pre-18c databases? I will show you what problem and the solution when your data or structure changes. I will also show you an example of a Polymorphic Table Function and how this can help protect you from changing table structures and how you can apply the same code to different table structures without changing or even recompiling the code. After this session you will understand when... Read More
Oracle keep saying default setup of their database works well most of the time. But some of those defaults lead to different issues often enough to question why it is done this way. This talk will be about such defaults.
Autonomous Transaction Processing (ATP) – the 2nd in the family of Oracle’s Autonomous Databases offers DBAs a force multiplier for their OLTP database application workloads. Take a deep dive into how best to take advantage of ATP. (Hint: Think automatic transmission instead of stick-shift.)
In this session we’ll explore Spring.cloud.function and learn the principals of coding Serverless applications. We’ll discuss Serverless in general and understand the motivation for it. The seminar will end up with a demo on a public cloud (e.g AWS LAMBDA)
SQL is a powerful language for accessing data. Using analytic functions, you can gain lots of insights from your data. But there are many problems which are hard or outright impossible to solve using these. Introduced in 12c, the row pattern matching clause, match_recognize, fills this gap. With this it’s easy to write efficient SQL to answer many previously tricky questions. This session introduces the match_recognize clause. It will use worked examples to show how it works and show how it’s easier to write and understand than traditional SQL solutions. This is useful for developers and data analysts that need to search for patterns in their data.
Very often our application suffers from bad SQL performance caused by inefficient data access. However, is’s possible to automatically identify such cases and to correct it either by defining more efficient indexes or rewriting SQL statement itself. During the session we are going to look for a number of possible causes of bad performing SQL statements, discuss the methods for automatic identification of these causes and possible solutions, based on existing Oracle dynamic performance views.
In this session we’ll explore Spring.cloud.function and learn the principals of coding Serverless applications. We’ll discuss Serverless in general and understand the motivation for it. The seminar will end up with a demo on a public cloud (e.g AWS LAMBDA) Topics – Introduction to Serverless – Conventions – Spring.cloud.function – Default routing – Testing – Demo
In this session we will introduce the managed MySQL analytics service which will be available shortly. This new in-memory analytic engine has been developed in Oracle Labs from the ground up designed for massive scalability and optimized for Oracle Cloud Infrastructure. We will present the architecture of how this engine is integrated seemlessly with MySQL and provides support for near real-time analytics. With the introduction of this capability, customers can now use MySQL for both their transaction processing and analytics needs.
This session shows how easy it is to instrument your code using the Open Source Logger Framework, so you can trace the steps in production without having to install a new piece of code. When we create our programs, we usually don’t anticipate anything will go wrong. And it won’t, during development and testing. But in production there is always someone who does something unexpected and your code fails. When running in dev you can easily step through your code and see what happens, but in production you are not allowed to do this. How great would it be that you could see what was happening in the production environment? But logging every step takes up a lot of the... Read More
Reactive Programming is a popular way of coding based on functional, streams & concurrent framework. In this seminar we’ll explore the reactive evolution and take the journey from function to reactive for traditional OOP programmers Topics: – Introduction & understanding the need – exploring Java 8 functional programming – exploring streams and lazy pipeline executions – understanding Fork-Join – reactive Streams – Java 9 Flow API Spring 5 – reactive with Flux & Mono
This session will explore best practices for using the SQL* family of tools which includes 3 main utilities: The SQL*Plus command-line interface, the SQL Developer GUI IDE and the latest Oracle’s SQLcl Java-based command line interface. Participants will gain significant knowledge regarding how they can use those three tools in order to both administer and develop either cloud or on-premise databases. This session will also include real life examples and live demonstrations on using some very handy commands and features for all three tools while leveraging and enriching your day-to-day productivity and accomplishing your database development and administration tasks much easier and faster.
In this talk I’ll present a shift from Virtualized application architecture in a startup I own (called fitness360now) to containerized architecture environment. I’ll emphasize on the ability to shift from single tier architecture to a multi-tier architecture (Web-App-DB tiers) while not having virtualization overhead/penalty. I’ll speak about how to replicate between several MySQL in containerized environment, I’ll present a better way to establish a delayed replication where replication is at least 6 hours behind the origin – in order to avoid Human errors. And I’ll present a sophisticated approach to performing backup in a containerized environment.
Using bulk operations to do dml from plsql is a lot faster than processing row by row. However, during bulk dml some or all records may not be successfully created, modified or deleted. This presentation will be about some of the pitfalls in handling these errors using “save exception” and its alternative “log errors”. Why is error_index a misleading name for that column in sql%bulk_exceptions? And how do you overcome the implications? What if a record fails halfway through multiple consecutive bulk operations on relationally dependent tables? Can log_errors be used as an alternative to using “save exceptions”? You will be given the answers to these and more questions and gain a better understanding of how to deal with errors... Read More
Oracle has tightly integrated DB In-Memory and Exadata NVMe Flash to offer seamless high performance columnar scans of data from the hottest data in RAM to the coolest on Flash. The buffer cache has also been extended via DMA to tier out to storage memory greatly increasing OLTP and index access
Tucked away in Enterprise Edition are 6 independent and powerful technologies that all fall under the umbrella of “Flashback”. The term often gets lobbed into the bucket of “Only useful in case of emergency”. But there are a LOT more use cases out there for Flashback technology.
Ever feel the world of mobile/cloud is beyond your reach, in this session we will review the many four (and more) letter words to help you navigate the world of emerging technology so you won’t feel so left out of the conversations at the water cooler. We hope after the session you will even be able to incorporate these buzzwords into the future vision for your enterprise applications. This session will help developers understand the world of emerging technology buzzwords, learn an overview of the next generation technologies and how they can bring value to their businesses and it will provide a general sense of the current development landscape – development trends and help them devise next generation mobile /... Read More
In this session we present some of the advanced development work we are doing for automating various aspects of MySQL service and MySQL analytics service. The infrastructure which is being developed for providing this automation is based on machine learning. We expect this to significantly improve the efficiency of our service as well as provide ease of use for customers using the MySQL and the MySQL Analytics service.
Traditionally, relational databases such as MySQL have usually required a schema to be defined before documents can, but new type of data requires a new type of schema-less structure. In This session, I will show how to use MySQL as Document Store like MongoDB and couchbase.
Quite often you have data in rows and need them in columns, or vice versa. You can also often have delimited data in strings and need them separated out, or conversely aggregate rows of data into delimited strings. You can do the Data Twist in SQL, pivoting, unpivoting, splitting and aggregating.
Looks DO matter, and today’s users are fed up with look and feel of their Oracle Forms/EBS Systems. We know your Forms are highly functional and getting the job done, however, they are in desperate need of a makeover.
All of us would like to be ‘lazy’ DBAs and developers, that accomplish our tasks with as little effort as possible. This session will cover the architecture on current database base applications and how oracle features evolved to help us work less and some more …
We have user groups, forums, and meetups…and yet often we’re critical of people who don’t build and learn everything from scratch. We accuse them of using the knowledge of others. But they SHOULD be doing this – we SHOULD be sharing our knowledge and experience! This session is all about sharing! The skill set of a database practitioner is much more than what is read in the documentation, on blogs, or on StackOverflow. It is the knowledge from years of trial and error, experimentation, and sometimes painful failures. The problem is it takes time , a long time to build that experience. This session aims to fast-track that path. Get a collection of hints, tips, features, and techniques picked up... Read More
Oracle Text is included with every edition of the Oracle database – even the free Express Edition (XE). Many APEX applications can benefit from adding its powerful search capabilities. This presentation will explain how to quickly add powerful text searching capabilities to your APEX application. We’ll look at: Strategies for gathering and indexing textual data to be searched — Indexing of BLOBs containing PDFs or Word documents — Indexing of structured documents such as XML or JSON — Searching your data using the Oracle Text syntax — Different search types such as word , phrase, stem, etc. — Searching within tags — Google-like highlighting of snippets in search results.
Through presentations and online demonstrations, this session illustrates how to: – Flesh out an application for canvassing 180,000 potential voters using Oracle APEX in less than 48 hours – Build and deploy the data model for the application in minutes with SQL Developer Data Modeler – Leverage Oracle Public Cloud (OPC) to host an Oracle 18c database for the underlying application data Agenda: 1. Vote Early, Vote Often: Finding the Grain Among the Chaff 2. Napkin, Meet APEX: Fleshing Out the Initial Application Interface 3. Building the Data Model In Minutes Instead of Hours 4. Leveraging Oracle Database 18c for Security, Scalability, and Flexibility 5. Deploying the Production Application: Wait, Can We Do This Instead? 6. Conclusions
A task can be done in a very short way and in a very long way. Which one will you choose? Knowledge is Power! This session gives lots of interesting knowledge about an allegedly boring topic – Constraints. And this *knowledge* will give you the *power* to optimize and make better decisions. The behavior of adding columns and constraints to big tables in Oracle may vary significantly, in two aspects – duration and availability – based on the way we perform these operations. In addition, different constraints may have different impact, based on their syntax, types, states, locking, etc. Attend this session to understand what happens exactly under the hood when we issue a simple ALTER TABLE statement, and how... Read More
Looking for a simple and efficient way to optimize your large estate management? Do you want to streamline your upgrade, patching, and provisioning efforts? Focusing on Fleet Patching & Provisioning (formerly known as RHP), this session explores how to enhance software maintenance, deployment, patching, and upgrade operations. Learn how Fleet Patching & Provisioning takes advantage of and maintains software gold images, a small set of approved software homes that contain the patches and configurations that you need. See how you can create gold images based on existing deployments and which services you can use to obtain a preconfigured image tailored to your on-premises & cloud environments.