In this video presented by Karen Morton, you’ll learn how to utilize data to understand the work your SQL is doing and the resources it consumes; identity
currently evident performance issues as well as areas that could be problematic in the future; and modify your SQL to use fewer resources more efficiently while still
returning the desired results.
SQL is utilized to return data via our applications to service user requests. Whether it's a single customer lookup or a huge month-end summary report,
the SQL we write must gather the correct data and return it to the user.
Ensuring that the SQL you write can do this in a timely and efficient manner, both now and in the future, requires that you measure and evaluate what resources your query must use.
In this webinar, we'll cover several methods for how to collect data that show you precisely how your SQL consumes resources:
Using AUTOTRACE
Using DBMS_XPLAN.DISPLAY_CURSOR
Using Report SQL Monitor
Using ASH (Active Session History) and AWR (Automatic Workload Repository) data
For our complete archive, and to sign up for upcoming webinars, visit our website - www.red-gate.com/hub/events/.
#Oracle #Redgate #SQL
Негізгі бет Ғылым және технология How to Gather SQL Resource Consumption Metrics in Oracle | Redgate
Пікірлер: 1