Home > database >  Consult everybody, how oracle tracking application execution of SQL
Consult everybody, how oracle tracking application execution of SQL

Time:11-10

Good god:
Younger brother unit to switch to the oracle database, recently has been used before used, now meet a problem, problem description is as follows:
If I wrote a login procedure (C/S architecture), wrote in a "select * from t_user where user_id=" 123 "; ", the program at the time of running, will submit this statement to oracle, the question now is, through what way should I go to track this statement?
Before, by the way, is essentially a tool, called SQL Server Profiler, can I open this function, then click login button on the local, and then shut down this function, and then search in this period of time to submit to the sqlsever statements, you can find the SQL, oracle whether also has the function, please? If there is how to operate? Or is there a similar tracking tool?
Now, I have a database of administrative authority, but the program was written by someone else, want to see him every step in to check what data, specifically what is logical,
Thank you for your attention!
  • Related