Tag: Database Performance Tuning

Quest Forum Digital Event 2020

Learn how POWER9 with the Oracle 19c DB In Memory features can help you accelerates performance and reduce CPU use when performing simple and complex analytics queries. After an overview of the newest capabilities of Oracle Database In-Memory feature, we'll share our experiences testing DBIM with simple and complex queries on POWER9. We will share the speed ups achieved for a set of reporting queries run In-Memory compared to disk row format, as well as hints and tips for getting the best results with In-Memory.

Quest Forum Digital Event 2020

Anyone who’s familiar with tuning SQL knows that you need to get the execution plan for a query.  But once you’ve got an execution plan, what do you do with it?  Everyone understands that an execution plan is important for diagnosing, but almost no one knows how to answer questions like “which step in the execution plan is taking the longest?” “Which hardware component (CPU, Memory, Disk) is causing my query’s bottleneck?” “Is my parallel query making good use of its resources, or are they being wasted?”  If you have the Oracle Tuning and Diagnostic Pack license for your database and 30 seconds, you can find the answer to these questions--and more!

Quest Forum Digital Event 2020

This presentation explains the various data movement techniques of the Multitenant (MT) option to the Oracle Database.  The techniques discussed cover unplugging and plugging, cloning, CDB Fleet, Snapshot Carousel, CDB/PDB upgrades, and PDB refresh.  Related administrative topics such as charactersets, proxy PDBs, backup and recovery, Data Pump, RAC, and Data Guard topics are discussed.

Quest Forum Digital Event 2020

Oracle Sharding is a technology for managing multiple, geographically dispersed databases in a shared-nothing architecture. Sharding is often associated with large, complex databases but that need not be the case. Based on Oracle Partitioning technology, sharding is a component of Oracle's Maximum Availability Architecture and boasts a rapidly growing user base. Its adoption is a result of the many database challenges it solves, including extreme availability, fault isolation, data tenancy, application response and latency, hybrid cloud deployment, migration, and data sovereignty. In this presentation, learn how Oracle's sharding technology works, its limits, implementation planning, use cases, and features and enhancements planned in Oracle 20c.

Quest Forum Digital Event 2020

Epsilon deploys real-time marketing solution for many customers, Application Uptime and Performance SLAs are key business measures. Using Oracle MAA technologies, RAC, Data Guard, GoldenGate, and Application Continuity, Epsilon is able to provide customers a platform where planned maintenance operations are completely hidden from application end users. This allows us to be fully compliant.  In fact, by using the Oracle high availability solution, Application Continuity, we even hide unplanned outages from end users.

Quest Forum Digital Event 2020

Oracle provides a number of "vanilla" recipes in the Docker repository but these don't cover the needs of modern enterprises. This presentation discusses methods for creating images to support Data Guard, OEM, APEX, Sharding, rapid container deployments, Gold images, and transportable datasets. Participants will learn how to develop and customize Dockerfiles and orchestrations and apply them to their needs.

Quest Forum Digital Event 2020

Oracle Enterprise Manager provides a comprehensive monitoring solution for your on-premise, hybrid, and cloud estate through a single pane of glass. Through its holistic approach, Oracle Enterprise Manager offers rich features as a foundation for monitoring all components of your IT infrastructure. This session gives valuable insight into monitoring best practices with Oracle Enterprise Manager 13c. Learn practical tips and strategies with common use cases to simplify and streamline monitoring of your IT ecosystem. Drill-down topics covered include best practices, common challenges, and new features in monitoring including Intelligent Incident Compression, Always-On Monitoring, login page customization, consolidating alerts, and more.

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.

Quest Forum Digital Event 2020

This presentation will look at which 19c new features that should be investigated for use.  This presentation will also have a few 20c new features such as AutoML.  This presentation will also look at which 18c new features that should be in use (such as Snapshot Carousel, PDB Switchover, In-Memory External Tables, Merge Partition Online, Advances in the Approximate Query, Polymorphic Tables, Standby Nologging, and Password-less Schema Creation - & others).  Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer.  There will be simple examples, where possible, to show the basic functionality of the new features.  Some features are too new to show example, but only explain.  We will also look at the autonomous database and Oracle's focus on the future of security.

Quest Forum Digital Event 2020

Competitive businesses rely on database as a service (DBaaS) to provide the agility needed to meet quickly changing market requirements and respond to demands for additional services. In this session learn how customers create and implement a DBaaS platform on top of Exadata, which provides rapid provisioning of databases from a service catalog, as well as integrated Oracle Recovery Manager backup and automated security compliance checks. In addition, learn how to use Oracle Enterprise Manager 13c to deliver powerful DBaaS capabilities for consolidation.