Tag: Database & Technology

Presented at INSYNC 21

Session ID: 101100

Multi-factor authentication (MFA) or 2-factor authentication (2FA) for database connections is frequently inquired about, but rarely implemented.  Yet is surprisingly easy to implement in the Oracle Database.

This session covers how to implement MFA/2FA for your Oracle Databases via common MFA platforms including Cisco Duo.  Including specifics of how to get started and test in your own DBA lab environment.

Presented at INSYNC 21

Session ID: 101550

Cloud Computing already dominates the IT landscape. As Oracle Cloud adoption grows exponentially, a skills gap is also on the rise. Join Oracle ACE Director, Basheer Khan, as he introduces you the Oracle Cloud landscape, identifies skills that are in demand and provides a roadmap to bridge your skills gap. Whether you are an Oracle developer, database administrator, functional expert or manager: attend this presentation to understand how you can upgrade your existing skills to stay relevant in the Oracle Cloud Computing world.

Presented at INSYNC 21

Session ID: 100840

This presentation will focus on what specific Algorithms that are inside Oracle can be applied to Business Problems. Robots may be the first to truly learn Machine Learning (ML) and expand into Artificial Intelligence (AI). Python is one of the keys to Machine Learning as we program the invention of Man's Mind to further replace man's most basic tasks. This session will focus on ML 101 and building the future ahead. Some business issues are seasonal, some relate to customers with certain attributes, some relate to customers we don't know exist, but all can be solved by using the correct algorithm to quickly prescribe a better corporate future.

Presented at INSYNC 21

Session ID: 101020

Oracle Sharding was further improved for linear scalability and complete fault isolation of OLTP workloads. With Oracle, sharding Data are partitioned horizontally partitioned across discrete  Oracle Databases (shards) in shared-nothing architecture that collectively forms a single logical database. Come to this session to learn its latest improvements and leveraging sharding for your business. We will share the experience and tips of configuring sharded database architecture with HA  replication for massive scalability and complete fault isolation. We will also discuss some of the considerations of choosing a sharding method in a global geographic distribution application and the experience of using Sharing Advisor.  We will also discuss some new sharding features that are in Oracle  20c/21c such as Federated Sharding and sharding with database in Persistent memory and Sharding Automation tool.

Presented at INSYNC 21

Session ID: 101600

Unified Auditing was introduced with the release of Oracle 12c and changes how Oracle database logging and auditing is accomplished.  In previous releases of Oracle, there were separate audit trails for each individual component.  Unified Auditing now consolidates all auditing into a single view.  For DBAs, IT Security, and auditors, Unified Auditing presents significant new opportunities for Oracle database activity monitoring and security.  This session will dive into Unified Auditing to highlight how it enhances database auditing and how to take full advantage of it to improve the security, compliance, and visibility into your database. Unified Auditing configuration, maintenance, performance, reporting, alerting, and archiving will be reviewed to provide a full understanding of its capabilities.

Presented at INSYNC 21

Session ID: 100290

The latest version of Oracle RAC includes features that enable better scalability and provide higher availability. In this session, we will cover the internals of new features and changes that DBA's need to make in their Pluggable Database deployment to benefit from the integration of PDBs with Oracle RAC.

Presented at INSYNC 21

Session ID: 100210

The database administration role as we knew it is dead.  DBAs who have been around for decades have become irrelevant in this data-driven economy.  Developers want autonomous management and executive leaders want to cut costs any way they can.  Join Oracle community experts as we discuss the next evolutionary role of the database administration role and what we must do to adapt and survive in this ever-changing dynamic technology-driven world.  Learn what future skills you need to possess and how you can stay on top of the demand.

Discussions will include how technical enhancements to autonomous databases, cloud innovations, and what you must learn to survive, how AI and machine learning can impact the database scene, and understanding which technologies you need to learn to adapt.

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.