Tag: Database

Presented at INSYNC 21

Session ID: 101850

Oracle Data Safe is an exciting new service offering security capabilities for identifying and reducing risk in Oracle Databases. First introduced at Oracle Open World San Francisco in 2019, Data Safe has been continuously enhanced and is now available for all Oracle Databases, on-premises and in the cloud. Join us to learn how you can simplify managing the security of your databases. We will go through a real life use case to assess configuration risks, evaluate database users, manage audit settings, report on database activity, discover sensitive data, and remove sensitive data from non-production copies of the database. And the best part – no special expertise is needed to leverage the capabilities of Data Safe.

Presented at INSYNC 21

Session ID: 101820

In this interactive session see why Azure is a great cloud to run Oracle Databases and applications. You can confidently use Oracle Database supported by Oracle and certified by Oracle to run on Azure. Rely on field-tested reference architectures that can accelerate your deployment times while reducing risks. Build and deploy cloud native enterprise-class Java applications on Oracle WebLogic Server in Azure and on Oracle Linux. The session also explores in detail some of the lessons learned regarding Microsoft Azure and Oracle’s cloud interoperability based on early customer deployments and use cases.

Presented at INSYNC 21

Session ID: 101800

Database Security is one of the most important topics nowadays as data breaches are on the rise, in this presentation I will discuss best strategies to audit your Oracle database systems. Moreover, Auditing will cover three layers: database layer, OS layer, and configuration layer.

Presented at INSYNC 21

Session ID: 100980

The Latest Persistent Memory such as Intel Optane Persistent Memory (PMEM) combines near-DRAM performance with the data persistence of storage. It can be configured in memory mode or application direct mode.  When the memory mode is used, PMEMs can be considered as volatile and can be used as main memory and DRAM is treated as a write-back cache. PMEMs can also be configured in application direct mode to store database files and redo logs. This presentation will discuss the use cases of PMEM:1)  In memory mode use PMEMs for Oracle In Memory store ;2) in Application direct  mode to store the database files, namely persistent Memory Database in  Oracle 21c. We will discuss the significant performance benefits that can be achieved from either of these two modes. We will discuss the Persistent Memory Database feature that includes directly mapped buffer cache and Persistent Memory Filestore (PMEM Filestore) in Oracle 21c. We will also discuss how PMEMs are used in Oracle Exadata X8M.

Presented at INSYNC 21

Session ID: 101670

JSON data is becoming increasingly prevalent in many enterprises today. As a result the world of data management now includes the need for storing JSON documents in a fast, reliable and secure way. What better place to store and manage this data then in the Oracle Database? ...and best of all it's totally free!

This session covers the different approaches to loading, storing, retrieving and managing JSON in the Oracle Database including the new native JSON datatype introduced in Database 21c.

The session will include live demonstrations.

Presented at INSYNC 21

Session ID: 101690

Learn about what's new in Oracle Database 21c for Database development.  Oracle Database 21c is packed with innovative new features from Blockchain Tables and Native JSON support, but have you heard about any of  the SQL and PLSQL innovations?   Attend this session to learn more about what your missing.

Presented at INSYNC 21

Session ID: 101700

Learn how Intel Optane Persistent Memory works with Oracle Database 21c.  See how to configure your Oracle database for faster writes with a PMem filestore.

Understand the difference between PMem App Direct Mode and Memory Mode.  Compare Oracle 21c with DRAM + SSD vs PMem vs TimesTen Cache for OCI and JDBC workloads.

Presented at INSYNC 21

Session ID: 101010

Infrastructure as code is the process of managing and provisioning computer data centers through machine-readable definition files, rather than physical hardware configuration or interactive configuration tools (by Wikipedia). On this vibrant session you would learn the differences between “configuration orchestration” and “configuration management” tools, and how emergent technologies such as Vagrant, Terraform, and Ansible fit and can be used to define, manage and provision a datacentre infrastructure or even build and maintain portable virtual environments.

The future is here, let's take advantage of it today!

Presented at INSYNC 21

Session ID: 100970

Many Machine Learning tasks need to access a lot of data set, which in many cases are stored in a database such as Oracle Database.  It makes a more scalable solution to do the machine learning task in the database, which is called in-database machine learning.  Oracle Autonomous Data Warehouse (ADW)  comes a library of Oracle machine learning algorithms and a set of building tools such as SQL notebooks  for machine learning.  This allows Data scientists to run Machine Learning projects in Oracle Database without moving data. This session will examine Oracle Machine Learning as part of Oracle database  as well as ADW . We will discuss process of machine learning:  analyze and prepare data set;  build and evaluate and apply machine learning model. We also will discuss the  Oracle machine learning features in Oracle 21c such as  AutoML for In-Database Machine Learning and newly added in-database machine learning algorithms for anomaly detection, regression, and deep learning analysis.

Presented at INSYNC 21

Session ID: 100930

This presentation aims to help you use the Active Session History (ASH) repository to investigate performance problems.  Oracle have produced many presentations that explain how ASH works, so this presentation provides only a very brief overview of how ASH works.