Tag: Database

Presented at INSYNC 21

Session ID: 101040

Oracle Enterprise Manager (OEM) brings your Oracle deployments together in a single management, monitoring, and automation dashboard. Oracle developed this solution, so it offers deep integration with many of its technologies. The ease of integration, coupled with the support of both on-premise and cloud-based Oracle databases, allows it to fit into many enterprise infrastructures. Oracle Enterprise Manager can also monitor and manage non-Oracle databases, making it a cost effective and central tool to manage IT environments with a mix of database platforms. This presentation takes on a brief history of OEM and then does a deep dive into seven robust features organizations should consider implementing.

Presented at INSYNC 21

Session ID: 101200

Oracle Enterprise Manager is the management tool of choice for monitoring mission-critical infrastructure, databases, application servers and applications.   Built on a scalable and highly available framework, Enterprise Manager offers a rich set of capabilities to meet the enterprise monitoring demands of today's dynamic datacenters and support and automate many of its operational processes.

Join this session to learn our best practices for monitoring using Enterprise Manager -- from basic monitoring to quickly set up monitoring with a few steps,  to enterprise-level monitoring that enables you to implement your company's monitoring requirements in an effective and scalable way.

Presented at INSYNC 21

Session ID: 100090

Oracle Machine Learning is now a free feature in Oracle Databases (on-premises, Cloud and Autonomous). As part of Oracle’s Converged Database strategy, OML “moves the algorithms; not data” processing data where it resides. Oracle Machine Learning extends Oracle Database(s) delivering 30+ ML algorithms and AutoML functionality via SQL (OML4SQL) and integration with open source languages: Python, OML4Py and R, OML4R.  This OML presentation and demonstration(s) highlights existing and new OML features: AutoML, AutoML UI, new algorithms in 21c, OML4Py and OML Services.  Now Oracle DBAs, users and application developers can leverage OML's ML algorithms to discover new insights, make predictions and deploy ML models enterprise-wide via APEX, Oracle Analytics Cloud and embedded in Applications. Come learn how to get started taking immediate advantage of these free and powerful in-database ML capabilities.

Presented at INSYNC 21

Session ID: 100540

Oracle Database 18c introduces Polymorphic Table Functions. This session will tell you about Polymorphism. How can you apply this in pre-18c databases? I will show you what problem and the solution when your data or structure changes. I will also show you an example of a Polymorphic Table Function and how this can help protect you from changing table structures and how you can apply the same code to different table structures without changing or even recompiling the code. After this session you will understand when to use which technique.

Presented at INSYNC 21

Session ID: 100490

Over the years, we have been following certain Oracle Database best practices which helped us to utilize database resources efficiently and run things smoothly minimizing unexpected downtimes. It is also important to use correct tools and techniques to quickly analyze and address any performance problems in the database. In this session, I'll talk about different database performance best practices we follow for SaaS application databases as far as development and DBA teams are concerned. Along with that, would like to share Oracle Database tuning tools and techniques we found most effective to resolve database performance problems as situation demands.

Presented at INSYNC 21

Session ID: 100810

This presentation will focus on preparing for the Oracle 21c database and new features such as AutoML, In-Memory Advancements, Data Guard standby DML, Result Cache on the Standby, Big Data SQL, and other features.  This presentation will also look at a few 19c/18c new features that should be in use now before you get to 20c.  We'll look at how Machine Learning and Autonomous Database will change the role of the future DBA. Emerging information technology trends for the cloud have the power to transform organizations. In the data management and analytics space, a key cloud service offering has arrived. Oracle Autonomous Data Warehouse (ADW) Cloud & Oracle Autonomous Transaction Processing (ATP) simplifies the provisioning, maintenance, and optimization for data warehouse workloads in the cloud, and promotes low touch for database administrators and load and pull approaches to data analytics.

Presented at INSYNC 21

Session ID: 100450

When using Oracle you will find more than enough solutions for High Availability and Data Security. If you have never been confronted with this topic before, you might ask yourself what solutions are there anyway and which one is right for my problem. Without delving too deeply into technical details such as setup and operation, a few of the most common solutions

(Standby Database with Standard Edition via Scripting, Dbvisit, Refreshable PDB, Oracle Data Guard, Oracle Failover Cluster, Oracle RAC One Node and Oracle RAC) will be touched upon briefly and compared with each other. The comparison of the different solutions provides a decision-making for your environment.

Presented at INSYNC 21

Session ID: 101510

In Oracle Database 19c, Oracle Database Standard Edition no longer supports Real Application Clusters (RAC). However, Oracle introduced a new feature: SEHA (Standard Edition High Availability). This is not RAC by any means, but it provides a high availability solution that is easy to implement and manage.. This session will explain what SEHA is, the differences between RAC and SEHA, and will dive into how SEHA behaves in different scenarios.

Presented at INSYNC 21

Session ID: 100270

In 2020 An internal Oracle team along with several value-add Partners, assembled to develop a Patient Screening, Scheduling, and Testing System.  This system was built in rapid development mode to deal with the much needed Covid19 testing.  The Coalition executed Mockups, POCs, and deployment at unprecedented speed, and due to the short time frame and urgent need, critical decisions on platform stack components, data governance, and long term supportability were quickly made. This session will review how the Coalition addressed the design, governance, and security requirements necessary to implement this system. As part of this discussion, we describe the thought process for final stack design, how the CDC Covid19 guidelines impacted our solution, explain the overall configuration, cost savings and outline the deployment experience.  Key areas of discussion will include Autonomous Database features, Data Catalog, Data Safe, and other Oracle Cloud Infrastructure Services.

Presented at INSYNC 21

Session ID: 100120

Oracle database upgrades can seem like a daunting task if you are like most DBAs who only upgrade every few years. What if you have a stand-alone (non-Oracle RAC) database and want to switch from a non-container database to a container/pluggable configuration? I know this sounds like a lot more work, adding to an already stressful situation. However, please know it only requires a few extra steps and results in greatly improved resource utilization. This presentation provides step-by-step instructions for upgrading from Oracle 12.2 to 19c and converting from a non-container to a container/pluggable configuration. I’ll even throw in the steps for upgrading an OEM repository to this configuration at no extra charge.