How To Trace SGA Using Toad For Oracle?

How To Trace SGA Using Toad For Oracle?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • Toad
  • 2 mins read

Tracing SGA is useful especially when you don't know that which DML statement is affecting a particular table and by which application process. To find out this kind of issues, you need to check Oracle SGA. In this tutorial, you will learn how to trace SGA using Toad for Oracle.

Suppose you have an Oracle Forms application and a Python application which are using the same schema and both the apps have the module to update EMPLOYEES table. Now you exactly want to know, that by which application the table is getting updated. Below is the example to trace the SGA to view which statement is updating the table EMPLOYEES.

Steps To Trace SGA Using Toad For Oracle

  1. In Toad, click on the menu Database > Monitor > SGA Trace/Optimization option.
  2. Then in SGA Trace window, select the type of statement from the first drop-down, for example, UPDATE Statements as shown in below image.
  3. Select the Schema from the second drop-down.
  4. Then click on the Refresh button right side of the Schema drop-down, to display the data below.
  5. After that, you can select the row below to view full statement below that grid and also you can check the module information like it is an Oracle form, Toad or Python application.

Trace SGA Using Toad For Oracle Example

You can also enter any field name or table name in SQL Search Text column to filter out the result.

See also: