Tag: Database

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. 

Presented at INSYNC 21

Session ID: 100910

This talk is for database and information security professionals.

The database holds the crown jewels of the organization; however, the infosec security teams have little understanding of working of the database and database developers, designers, and DBAs have little understanding of security concepts. I get it, we get pressure from the top and the users to deliver a system with little time or budget to apply to database security. In this talk, we are going to take the 10,000 meter view of the database and look at the attack surface, attack vectors, and how to mitigate those attacks. At the end of the presentation, developers, designers, and DBAs will have action items they can take back to their shop and start improving security.

Presented at INSYNC 21

Session ID: 100890

Understanding how Oracle Database data and index compression works, what has changed in the latest versions and discussing compression best practices can help you in getting the best results with Oracle Compression. Join Oracle Product Management to gain insights on compression topics that include: when compression occurs during bulk loads and DML inserts/updates, when to use Index Key (prefix) Compression versus Advanced Index Compression, how to track compression using AWR’s as well as recent Advanced Row Compression and Hybrid Columnar Compression enhancements with Oracle Database. This session is the perfect opportunity to get all your compression questions answered by Product Management.

Presented at INSYNC 21

Session ID: 100030

Learn the how and why of running Oracle on Windows, and some tricks to help you along the way.  This session will benefit the Beginner to Mid-Level Oracle DBA faced with running Oracle on a Windows Server, and may also teach some old hands a trick or two.  Instead of delving into topics that would be for Server Administrators, this talk will deal with issues directly related to DBAs running Oracle on a Windows Server.  Find out how to leverage many of the features that Windows has to help you as a DBA, including taking advantage of some of the command line and scripting options available.

  • Quest Customer Learning Team
  • Recordings & Presentations
  • 4/01/21
Sep 11

Oracle Database 19c SIG Meeting

SIG Meetings & Calls

Quest Forum Digital Event 2020

It is true. You can laugh your way to understanding queuing theory, performance analysis and why systems behave the way they do.

From driving in traffic to being served at a restaurant, every person feels the impact of queuing theory. Queuing theory beautifully relates time and work into terms we can feel, like utilization, workload intensity, response time, elapsed time and systems architecture design.

With only the basics we can use foundational queuing theory to derive targeted performance solutions and goals, filter and evaluate any performance solution thrown at us and help non-technical people understand why our solutions make perfect sense.

Join us for a shockingly practical and fun session that will impact your Oracle career and beyond.