Tag: Database & Technology

Presented at INSYNC 21

Session ID: 100690

Experience an innovative approach which relies on big data and advanced analytical techniques to detect anomalies in performance metrics in order to improve Oracle DB performance. The approach represents a step-change paradigm shift away from traditional methods which tend to rely on a few hand-picked/favorite metrics or wading through a voluminous AWR report. With this innovative process, you can draw on all available performance data to help you draw impactful, focused performance improvement conclusions.

The process targets the most relevant metrics for the problem interval which results in event focused and actionable intelligence on the performance issue, and insight into possible solutions. This method improves on the typical/traditional approaches which monitor a standard set of hard coded metrics; which may cause you to miss important system behavior or configuration that is relevant to the root cause of the performance problem. The speaker will share his process and code.

Presented at INSYNC 21

Session ID: 100770

Not that long ago it was so simple: if you were a developer who wanted to work with an Oracle development tool, you used Oracle Forms. Period. End of story.

Now the number of Oracle development tools has grown to the point where it is natural to wonder which one to use. Each of Oracle's offerings is a solid choice so the only real answer to the question of "which one is best?" is a not so helpful, "It depends."

This session provides some guidelines for determining which Oracle development tool is best for your situation among the large crowd of: Application Development Framework  (ADF), ADF Essentials, Application Express (APEX), Mobile Application Framework (MAF), PL/SQL Web Toolkit, Visual Builder Studio (VBS), Mobile Application Accelerator (MAX), JavaScript Extension Toolkit (JET), and, of course, Oracle Forms. In addition, the session will explain the role played by Alta UI, Oracle UX, and Redwood in developing modern user interface applications with any tool.

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.