SQL Tuning Tools   «Prev 

Identifying the roles of the DBA in SQL tuning

Internal Stored Procedures

SQL may come from internal stored procedures inside the Oracle data dictionary

SQL can come from procedural programs with embedded SQL, such as Pro*C or Pro*Cobol

SQL may come from Microsoft ODBC connections on a personal computer.

SQL can come from Visual Basic application on a PC

SQL can come from Oracle SQL*Plus sessions on a Oracle Net client PC.