Tag: Database & Technology

Presented at INSYNC 21

Session ID: 100870

In the brave new digitally-driven world, IT organizations can no longer focus on internal-only RDBMS databases as the central pillar of their infrastructure; data must be accessed externally as well, regardless of format or location, with utmost security. Fortunately, Oracle’s Converged Database strategy makes it simple to satisfy these demands. Join ACE Directors Nitin Vengurlekar, Rich Niemiec, and Jim Czuprynski as they explore the facets of Converged Database from the perspectives of CEO, CIO, and DBA, and what it means for your career’s future path.

Presented at INSYNC 21

Session ID: 101640

For IT management, one of the most valuable changes in the transition from reactive to proactive and ultimately to predictive intervention – fix the faults before they occur – or at least before anyone knows. The simple truth is that IT monitoring will increasingly become a critical element in an organization's overall digital business service delivery strategy. Attend this session if you want to not only survive but to thrive with the rapid pace of change occurring on the path toward an increasingly digital future. The presentation will cover Oracle Cloud's new Observability & Management Platform. The Oracle Observability & Management provides comprehensive visibility and actionable insights across all stack layers, deployed on any technology, anywhere.

Presented at INSYNC 21

Session ID: 101400

This session focuses on how Oracle is applying Machine Learning technologies in Oracle to prevent performance issues and maintain availability. Autonomous Health architectures and algorithms are covered for both Autonomous Database and on-premise deployments. Deep dive use cases detail their use to proactively detect performance degradation through the phases of detection, root-cause analysis and targeted corrective actions. Actual use cases protecting session, database instances, nodes and storage are presented. Next, diagnostic use cases for rapid recovery monitoring configurations, log and trace files where analysis is based upon anomalous events and record signatures. The final section will cover integration into DevOps processes.

Presented at INSYNC 21

Session ID: 100050

The latest release of the world's most popular database, Oracle Database 21c, was recently released on Oracle Cloud Infrastructure (including Autonomous Database Free-Tier Service). In this session, we'll take a look at some of the new features and enhancements that further enable Oracle's converged capabilities for data-driven applications.

Presented at INSYNC 21

Session ID: 100790

Just the word NETWORKING leaves a bad taste in the mouth of many technical people.  At least when you are not talking about TCP/IP, fiber or CAT6.  After all, one thing that attracted many of us to the IT world was not needing to deal with people. 

This session will help erase that bad taste by showing you how networking can help your career in more ways than you expect.  It can also be pretty easy to do if you do just a little planning.

Employees with better networking skills are beneficial to employers as your network is a resource that you can use to be a more effective problem solver.

Presented at INSYNC 21

Session ID: 100730

Efficient applications require the best performance from all components used to implement the application. If you are using cloud services, tuning of some components is out of your control, but regardless of your use of cloud, your job as an application developer is to ensure that your database code runs as efficiently as possible. It is so much easier to create highly-performant code in the first place than it is to have to fix the code later when you find that it is not performing well.

At this session, you will hear an introduction to (or a review of) a set of PL/SQL coding techniques that help performance. Although these techniques have been known for years, if you are relatively new to the language you may not have been exposed to them. Examples of these techniques include: caching local variables, iteration handling, reducing context switching, datatype selection, and various methods for handling data manipulation. Sample code will illustrate the principles.

Presented at INSYNC 21

Session ID: 101500

Have you ever found yourself staring at a list of patches and wondering what to do? What patch should I install? What are the risks? Is there anything I should do after the patch? This becomes even more stressful in a complex environment: How to install patches on RAC? What about standby databases?

This session will try to put things in order and help create a roadmap for patching databases. We will discuss the different types of patches (RU, RUR, DBBP, PSU, OJVM, One-off), installation types (RAC rolling patches, standby first patches), known issues and where to find them, and how to plan the patch installation in order to have as few surprises as possible.

Presented at INSYNC 21

Session ID: 100160

Have you had that one SQL statement that you just couldn’t figure out what the Oracle optimizer was thinking?  In this session, we will take a deep dive into doing a trace and talk about some of the sledgehammer methods to influence the optimizer.  You may not find the solution to that one nagging SQL but we will cover how the optimizer frustrated you so.  Using these tools along with Oracle’s SQL Plan Management or Profiles you may be able to achieve your goals.

Many developers do not understand how to dig into SQL beyond the basic explain plan. Here we will cover the somewhat gory details of going deep inside how the optimizer is making decisions.

Presented at INSYNC 21

Session ID: 100360

MySQL is the largest open-source database in the world. It's a product that resides under the wings of Oracle Corporation and still it survives with it's big brother Oracle Database as the flagship product in Oracle Corp. This is an open-source product which means that, as opposed to Oracle Database, you can get it for free. We'll discuss features and we'll go into some details what we experience as the strong points and what are the weaknesses. I will guide you through the basic installation of the most recent release MySQL 8.0, we'll go through the basic concepts of the database and we will set up a replica.

Presented at INSYNC 21

Session ID: 101090

Security breaches are becoming more and more common. From both external and internal threats/bad actors. And while organizations spend considerable effort on perimeter security, the database is often overlooked or considered too fragile to touch.

But more effort needs to be directed towards Oracle database security. Both inside the database and out (i.e. operational practices). And regardless of whether on-premises or in the cloud.

This presentation covers common weaknesses and vulnerable areas of the Oracle database due to configuration and management issues that are easy to correct or remediate right away. Going well beyond the obvious like password rotations and having security policies.