This is the total list of titles and abstracts for the entire event. Each country will select the most relevant presentations for their members, so you’ll have to check your local event page to see which specific presentations you can look forward to.
Oracle Active Data Guard and Global Data Services in action!
Oracle Global Data Services (GDS) is a new 12c feature that facilitates enormously database services relocations across distributed environments. How does it work? How can we install it and configure it? Join this session to learn the answers. Live demos will complete the learning experience.
Adaptive Features or: How I Learned to Stop Worrying and Troubleshoot the Bomb.
Adaptive Dynamic Sampling, Adaptive Execution Plans, SQL Plan Directives: these new features are the new performance troublemakers when migrating databases from 11g to 12c. The optimizer uses them to seek for the perfect execution plan, but does it always succeed? This session will focus on the first steps required to quickly troubleshoot performance issues due to the adaptive features.
Oracle Database and Oracle ACFS: a lovely couple!
Oracle ACFS 12c supports Oracle Database files. Which new opportunities come out from this combination? What are the possible use cases? What about the performance? Join this session and learn more about this solution through graphs, examples and live demos.
Oracle Clusterware and Rapid Home Provisioning
Rapid Home Provisioning is a Clusterware feature introduced in 18.104.22.168 that simplifies the management and deployment of Oracle homes in a clustered environment. In this session you will discover the basics of this technology. Examples and live demos will complete the learning experience.
Migrating to 12c: 300 DBs in 300 days. What we learned.
For a customer in Switzerland, we are in process of migrating 400 databases to 12c. We have migrated 300 so far, and we have had good and bad surprises. This session will show a few scenarios that we faced during the upgrade project.
Self-Service Database Operations made easy with APEX
APEX can dramatically increase productivity through development of web applications. Even less skilled developers and DBAs can quickly develop solutions which facilitate everyday life. Join this session and learn how a big customer in Switzerland developed a Self-Service Database Operations Portal that reduced the routine tasks of the DBA Team by almost 100%.
Database Migration Assistant for Unicode (DMU): a Real Customer Case
DMU is the new tool introduced by Oracle for database conversion to the Unicode character set. Beside introducing briefly the tool, this session will focus on a real database conversion scenario faced by a customer, the problems encountered and the solutions.
Mastering the APEX Universal Theme
But how do you make changes to comply to your company branding in such a way you don’t break anything else? And how do you add new templates and template options?
In this session you will learn how the Universal Theme works, what the components are and what you should and shouldn’t do when you make your changes.
But there are way more and some of them are extremely useful. But first you have to be aware they exists. And secondly you have to know how to use the properly.
Make your APEX Applications fly using JET components
The quest for the little gems in APEX 5.1
You have probably already heard about the stunning big new features of APEX 5.1, like Editable Grid, JET Charts and Live Template Options. But did you know that the APEX Development Team added a lot more gems in their product? Smaller gems, but definitely worth examining in some more detail.
In this session we will cover ten of those little gems that will make your upgrade to APEX 5.1 even more worthwhile!
Oracle Database 12c New Features for Developers and DBAs
Attendees are introduced to new and improved features of Oracle 12c directly impacting application development. Special emphasis is given to features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: IDENTITY columns, improved SEQUENCEs, INVISIBLE columns, improved defaults, JSON enablement, APPROX_COUNT_DISTINCT function, security enhancements, PL/SQL interoperability improvements, outer-join improvements, other SQL improvements, and Edition Based Redefinition (EBR) improvements. An overview of Oracle 12c Multitenant Features (“Pluggable” databases; CDB &PDB) and In-memory Database are included too.
Using JSON in Oracle 12c
Oracle 12c added formal support for JSON data with the 22.214.171.124 update in July 2014. Oracle 12c stores JSON using standard Oracle character data types VARCHAR2, CLOB, and BLOB. A JSON-specific “IS JSON” test may be applied in CHECK constraints and WHERE clauses as can two other JSON-specific conditionals: JSON_EXISTS and JSON_TEXTCONTAINS. Three JSON-specific functions are also provided: JSON_VALUE, JSON_QUERY, and JSON_TABLE. Attendees will learn how to create tables using JSON columns, how to INSERT data into JSON columns, how to query JSON data, and how to use JSON_TABLE to represent JSON data as “normal” relational data.
To Cache or not to Cache; and How?
Recent advances in Oracle’s database have provided different statement caching
Options. SQL and PL/SQL performance may be improved by using caching features properly. This session will explore various statement caching features of SQL and
PL/SQL including SQL Statement Result Cache, PL/SQL Function Result Cache,
SQL WITH clause Function (12c), and PL/SQL PRAGMA UDF (12c). In this session, we will examine the performance benefits (and potential issues) of each method via live demonstration using Oracle SQL Developer and SQL*Plus. This session will also discuss the issues involved in using PL/SQL from SQL statements, and using SQL from PL/SQL.
DBaaS: Taking Advantage of Oracle Cloud Database
Oracle has been the database leader for decades. Oracle extends that leadership to an industry-leading Database as a Service (DBaaS) Cloud Service. With Oracle’s DBaaS organizations can eliminate the need to identify, purchase, and provision new systems to accommodate changing and expanding database needs. Instead, we simply provision a database in the cloud, choosing from among many options to install a database instance of the size and type required in minutes (rather than weeks). Whether creating a production instance or building a test database the Oracle DBaaS makes things easy. In this session you’ll learn the capabilities of Oracle DBaaS, see a live demonstrations of the ease of deploying and using a new service.
Accessing Your Database in the Cloud; Oracle REST Data Services (ORDS) in Action
Many organizations store the “crown jewels” in their Oracle databases and need to make that data available easily to mobile and cloud-based applications. The modern world of services and microservices is increasingly reliant upon HTTP-style or REST-style APIs. Oracle’s REST Data Services (ORDS) make getting data from Oracle Database, Oracle Database JSON document store, and Oracle NoSQL data sources easy. In this session attendees will learn how to use ORDS to make data available using industry-standard API calls.
12c WITH or Without? Getting the Most Out of PL/SQL
Oracle 12c PL/SQL provides several performance-enhancing features including the ability to use WITH to define PL/SQL as part of SQL or PRAGMA UDF to anticipate processing. In addition, Oracle 11gR2 gave us the PL/SQL Result Cache and 12c adds INVOKER RIGHTS caching. This session will discuss how the different features work, what their strengths and costs are, and how to maximize performance by choosing features carefully.
UX is not UI
With the explosion of mobile apps; UX (User Experience) garners more attention with each passing day. Sadly, applications often focus on the User Interface (UI) rather on solving the problems faced by the application user. UX is the formulation of a strategy to provide a solution; UI is simply a small (but important part) of the overall solution. UX design focuses on a strategy to help the user accomplish a task directly and simply. This session will highlight the important facets of UX design and help attendees create more-useful applications.
Cloud: So Much More Than The Same-Old-Thing!
Cloud-this; Cloud-that; Cloud blah blah blah. Are you one of those who think “this is the same old stuff we’ve been doing for years with a new name”? Well, you’re a little-bit right, but mostly you’re wrong! In this session you will learn that the cloud is in fact a combination of features enabling your organization to maximize its IT resource while getting out of the data center business. Cloud provides a combination of on-demand self-service, broad network access, resource pooling, rapid elasticity, and measured service. Organizations use cloud Infrastructure as a Service (Iaas), Platform as a Service (PaaS), and Software as a Service (Saas) depending upon their need and their desire to manage the environment. Finally, choices must be made to use Public Cloud, Private Cloud, or a Hybrid Cloud. Attendees will understand the specifics of cloud architecture and how their organizations can leverage cloud to best advantage.
The Heart of Oracle – How the core RDBMS works
How does the Oracle RDBMS actually work? In this session I’ll tell you how, 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 data files are less important then Redo.
If you can write a select statement you can understand everything in this talk – and might end up knowing some things most oracle professionals don’t know.
Understanding how the database works really helps you to use it more efficiently.
Tips on Bulk Data Processing with SQL and PL/SQL
How do you process a million records into your database a day? Or bulk load several Terabytes of historic data? SQL is “the fastest” but PL/SQL gives you far more control. Which is best? That depends on what your overall process is and how often you are running it.
I’ve been designing and working with VLDBS for twenty years and I’ve made enough mistakes to learn a few things. In this presentation I will show, with examples from real projects, ways of using SQL and PL/SQL to bulk process data, critical considerations and real-world lessons on how to manage the loading of data.
The Forgotten Performance Tuning Trick – Clustering your Data
As data volumes continue to increase, SQL performance and tuning remain as critical as ever. But it is not all about Explain Plans, using hints and adding indexes.
How you structure your data and how you cluster your information together is vital to getting the best performance from your database – and it is often overlooked. It is an urban myth that you no longer need to consider where your data actually is, if you care about performance that is.
By using Index Organised Tables, Cluster, Partitioning, normal indexes and other tricks, you can not only access your data quicker, you can greatly increase the use of your database’s memory.
Calling PL/SQL from SQL – Performance, Practicality and Point-in-Time view
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 function from SQL which are often overlooked. I explain those issues and how you can avoid them.