Bookshelf Home | Contents | Index | Search | PDF |
Siebel Tools Reference > Performance Improvement > Performance Troubleshooting Using Spooled SQL >
Followup Analysis
If you identify a problematic query in the trace file, you can obtain more information about it using the database query tool provided with the RDBMS (such as SQL*Plus in Oracle). Copy and paste the SQL statement from the trace file into the database query tool, and then execute the query against the database. This will provide the following additional information:
- The use of indexes
- The use of temporary tables
- Table scans
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Tools Reference, Version 7.5, Rev. A Published: 18 April 2003 |