Tag: Database & Technology

For readers who are familiar with the Asterix and Obelix series, the magic potion refers to the potion brewed by Getafix, that gives the Gaulish warriors superhuman strength.

One of VMware’s magic potions for Oracle workloads is the ‘Paravirtualized SCSI Controllers a.k.a PVSCSI Controllers’ which is accelerated workloads performance on a VMware vSphere Platform.

This blog is meant to raise awareness of the importance of using PVSCSI adapters with adequate Queue Depth settings for an Oracle workload.

Written by Sridhar Avantsa, Rolta AdvizeX

Oracle introduced the feature of database sharding in 12.2 and has since been refining it. The purpose of this article is for the reader to understanding database sharding. This includes general concepts of sharding as well as the concepts, architecture, and how to use Oracle Sharding.

It is paramount to protect and secure your companies most valuable asset: your Oracle databases! Oracle Database Administrators often spend most of their time and resources dealing with multiple products, features—not to mention—complexity. Explore how you can simplify, and cost-effectively automate, data protection. Learn how to create frequent backups, and test failover and failback of critical databases and applications to or from DR site (in cloud or on-premises). See how to meet RPO and RTO=0 objectives and burst to cloud for test and development. ​

Presented by Ebin Kadavy, NetApp

Apr 21 @  11:00am

It is paramount to protect and secure your companies most valuable asset: your Oracle databases! Oracle Database Administrators often spend most of their time and resources dealing with multiple products, features—not to mention—complexity. Explore how you can simplify, and cost effectively automate, data protection. Learn how to create frequent backups, and test failover and failback…

Presented at INSYNC 21

Session ID: 101030

Taking your customer's experience to the next level is a gargantuan task! Ensuring that your infrastructure and apps are healthy and performant, today, is a minimum requirement but the real insights are derived by deeper analysis of the usage patterns available in logs, among other sources, to inform business decisions which are measurable. Logs come in different variety and could be from few Gigabytes to Terabytes making it difficult for everyone to visualize and analyze. Enter OCI Logging Analytics.

In this workshop, we'll take you through the end-to-end Log Analytics value chain to show how you can use OCI Logging Analytics to do advance analytics and ML on log data.

Come to this session if you are a DBA, IT Analyst, IT Admin, DevOps or LoB Manager to learn how to quickly gain deeper insights from your log data quickly.  You'll learn how to use Logging Analytics' in-built ML features and integration with Data Science for custom ML models. No prior training is required.

Presented at INSYNC 21

Session ID: 101330

During a large in-house cloud project with a large amount of developers and teams, Oracle was chosen to be one of the main data backends. This led to a huge demand of databases and schemata and thus resulting in lot of work for us as the DBA-Team.

Our "classical" approach to handle these requirements didn't work in this case efficiently enough. Therefore we needed an optimised solution to handle all these in shorter time and with less effort. We had chosen Ansible, RAC and the Oracle Multitenant Option to be the components to solve this.

This Talk highlights the challenges, as well as the solution we had implemented. It will be shown what the current status quo of the implementation is and if the improvements could be reached.

Presented at INSYNC 21

Session ID: 100670

Running out of support, security concerns, new features, coming operating system or hardware changes.... there is a long and versatile list of potential reasons for our customers, to change the version of their running Oracle Databases. The "choice" of situations, challenges and options for changing the version, is at least as long and as versatile as the reasons are.

Oracle ACE Director Martin Klier will deliver an unveiled overview about his adventures with logical dependencies, human sensitivities, technical skulduggeries and license traps. All this happens, when one or multiple databases are to be migrated or upgraded to a new version in a controlled fashion. For A as in AIX, L like Linux, S like Solaris, V like Virtualization, W twice in Windows ... there was trouble, there was a solution, and there was a new experience!

Presented at INSYNC 21

Session ID: 100140 

Oracle SQL Plan Management (SPM) is often overlooked and underused. This feature started in version 11.1 and has been enhanced with each new release. As of 19c, this should be your go-to method to help maintain well-performing SQL statements. In this session, we will cover what SPM is, how to use SPM from end to end, and how to monitor it. Once you start using SPM Baselines you will find them to an invaluable tool in your continuous goal to maintain database performance. 

Presented at INSYNC 21

Session ID: 100550

Oracle Database provides us with collections since a long as I can remember (Oracle 7.3.6.4). First as PL/SQL Tables in PL/SQL only. They have been been renamed (Index-by Tables, Associative arrays) and new implementations have been added since (Varrays, Nested Tables [SQL and PL/SQL]). Also the original Asscociative arrays have been updated, making them available in SQL as well. They play a key role in many of the newer Oracle features like BULK Processing (BULK COLLECT and FORALL) and Table functions. Using the bulk processing capabilities of your Oracle Database they can speed up your processing by an order of magnitude.

This session will show a little bit of history, how to use the collections, how to make collections available in SQL so they can be processed in other languages. How things can be done in what version and how things become easier with the newer versions of the database.

Presented at INSYNC 21

Session ID: 101920

Most modern computer applications include an “advanced search” screen that allows users to enter multiple criteria and parameters. Unfortunately, behind the scenes, this functionality can cause major headaches for implementing the back end, because the resulting queries may reference an unknown number of tables and/or columns and may return unknown numbers of rows. In addition, the results may mutate depending upon the parameters. There are multiple ways of solving this problem with various levels of efficiency. This presentation will demonstrate how to handle generic search functionality within an Oracle database by utilizing Dynamic SQL, object collections, and a bit of a creativity.