Tag: Database

Presented at INSYNC 21

Session ID: 101180

Docker is widely embraced in the developer community but less well known or understood in the database world. Database administrators and developers are beginning to realize how powerful containers are and the speed, flexibility, and portability advantages they offer over virtual guests.

This session is a practical course for those curious about or just starting out with Oracle on Docker. Attendees will learn terminology and understand how containers differ from virtual machines, followed by demonstrations of Docker’s speed and versatility. Explore basic commands and examples for building Oracle on Docker and making container databases visible on a network. Discover how to separate and preserve data, share and distribute database images and data, then how to create new databases in seconds (not an exaggeration). The session closes with advice on customizing container environments and a peek into orchestrated builds for multi-database needs posed by Data Guard and Sharding.

Presented at INSYNC 21

Session ID: 101630

Hear lessons learned on an APEX gal’s voyage to Visual Builder Studio, Oracle’s updated cloud-based visual application development environment, the new path to using Visual Builder.   VB Studio allows one to build web and mobile applications, extend Oracle cloud applications, and manage the full development life cycle in an integrated, collaborative environment.  Sounds great – but how does it really work? 

What is the difference between VB Studio and VB?  When do I use one vs. the other?  How hard is it to get started?  How hard is it build a real production application?  How hard is it to extend my cloud applications?  Do I have to be a JavaScript expert? What investment – time, money, learning - is required to be productive? Was this voyage worth the effort?  Can VB Studio make a difference for one's Oracle cloud investment?  Attend and learn about a long-time Oracle APEX developer’s continued adventure into VB and VB Studio.

Presented at INSYNC 21

Session ID: 100720

Business rules define the requirements of the organization such as what constitutes valid data. A PL/SQL Table API provides a centralized location for the code you write to represent those business rules. This technique has many benefits including better performance, reduced cloud database costs, simplification of user interface code, and more secure applications, and it can be used for any development environment: APEX, ADF, MAF, JET, MAX, VB Studio, Java, JavaScript, or any other framework.

Attend this session to hear about the benefits of this kind of centralized code in more detail as well as some advice about how to incorporate it into your development practices. The presentation focuses on the code components and strategies relevant to using a PL/SQL Table API and the methods used to call it. It also describes and demonstrates methods for automatically generating a large part of the code and shows examples of generated code as well as code that calls the Table API.

Presented at INSYNC 21

Session ID: 100570

As business applications grow rapidly, scale-out should be easy and contains few steps to implement.

In MySQL8 Source-Target setup, adding a 3rd or 4th ..nth server as part of replication is simple and easy. We will discuss the steps/option available to scale out with no downtime to the primary/source server.

Presented at INSYNC 21

Session ID: 100510

Learn how to set up and configure and utilize the Oracle Database Security Assessment Tool.  The tool can help with data and database security best practices and options.  The tool can also help you uncover the sensitivity in your databases so that you and implement ways to better protect your data.

Presented at INSYNC 21

Session ID: 100260

Panel session with:

Charles Kim, Sean Scott, Gary Gordhamer

Oracle Database 19c is the current long-term supported release.  If you have not upgraded to 19c yet, it’s time to get to work.  This panel of three Oracle ACE’s will answer questions and provide knowledge based on their real-world experiences of upgrading customers to 19c over the past two years.  Bring your questions about the upgrade process, technical upgrade steps, and performance changes or challenges.

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.