hi all oracle guru's,
iam a chicken in this database field and i was wondering if anyone of you could help me. I have a front end application for which i dont have the source code and i want to see how a certain form (the query) is getting executed (the explain plan). can anyone tell me how can i see what tables it is accesing and what indexes are being used?????
any help would be gr8 full.
use the v$session to find the sid
use the following query to find the sql query
the session is running
select sid, sql_text, piece from v$sqltext t,
v$session s where s.sql_address = address and
sql_hash_value = hash_value and sid = &sid;
use explain plan for optimising.
thanx heaps mr. giri
it just worked fine and i'm really impressed by the fast response in this site.
See my response to this thread to see how to capture *all* the SQL that a session is submitting:
I built an integrated set of GUI tools to manage, monitor and tune the Oracle database. One of the many monitoring functions allows you to list all the active sessions, you can then click on any session, to view the SQL statement being executed, and with another click you can analyze that statement. It is particulary usefull when you donít have the source code. The link is http://www.barsoft.net and it is free.
Click Here to Expand Forum to Full Width