Tag: Database Performance Tuning

Quest Forum Digital Event 2020

Learn how Advanced Machine Learning techniques can be leveraged to Manage and Monitor you E-Business Suite applications deployed on-premises or in a cloud environment. The monitoring solution built in conjunction with E-Business Suite Application Development and Support team gives you visibility into the key components line Concurrent Manager and Workflow to allow quick diagnosis of issues.

Access all 11 Quest Experience Week PeopleSoft session recordings. Purchase now.

Webinar: Finding and Fixing Performance Problems in a Complex Application & Database System

Be a hero with your DBA! Learn how to identify database key performance indicators, classify relevant workloads, and analyze AWR/STATSPACK reports to make meaningful recommendations for what is needed in your database system infrastructure to meet your performance service-level objectives. The methods discussed will apply equally to on-premises and cloud based infrastructure. This technical session…

Costs Increasing numbers of users, devices, and applications require real time concurrent access to ever larger amounts of enterprise data. To keep pace with these rapidly changing business needs, IT infrastructure has transformed to leverage faster networks, multi-core CPUs, and server virtualization technologies to scale operations. But storage hasn’t kept pace with these new requirements.…

Have you ever been overwhelmed looking at an AWR report and not sure where to start?  I will show you the different types of AWR reports,  information that is contained within each section and how you can use it to tune and troubleshoot your database.  I will provide examples of how I've used the reports…

Learn how to use simple algorithm analysis for Oracle performance tuning.  Finding the mathematical functions that describe the computational complexity of different operations can help us understand and predict performance.  This presentation will discuss common functions such as 1/N, LOG(N), N, N*LOG(N), N^2, and N!, and how they can help us understand operations such as…

Historical trends of the last decade lead to a paradox: In search of optimization, our solutions represent a group of independent modules communicating via various APIs (up to an extreme point of micro-services!) The overall number of performance problems increased significantly (comparing to the past, i.e. monolithic implementations). In addition, time to solve any performance…

The methods used to track performance issues in SQL and PL/SQL vary based on the level of access within a system.  A developer in cooperation with a DBA, or already granted DBA privileges can has a wide variety of tools and deep visibility.  However, a user with nothing more than CREATE SESSION and SELECT privileges…