Who is currently running what SQL
- This script will show you the user's OS name, Username in the database and the SQL Text they are running
pop
(Added: 20-Aug-1999 Hits: 15368 Rating: 4.24 Votes: 20) Rate It
Capture application's sql in N tier evironment
- In N tier structure it is really hard to track user session specially in a web enviroment, All users connect to database using the same application , so all requests are going to database on behalf of one oracle user. then how can you track actions of one ENDUSER (application user).
(Added: 29-Jan-2003 Hits: 5010 Rating: 0 Votes: 0) Rate It
SQL trace and TKPROF in SQLPLUS
- Purpose: To read raw session trace file with option to format trace file with TKPROF and read it in SQLPLUS Session
(Added: 26-Sep-2004 Hits: 4596 Rating: 0 Votes: 0) Rate It
