SQL Tuning Tools   «Prev 

Identifying Roles of DBA in SQL tuning

Internal Stored Procedures

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

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

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

4) SQL can come from Visual Basic application on a PC

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