-
performance tuning
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.
rajorcl
-
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.
Regards
giri
-
thanx heaps mr. giri
it just worked fine and i'm really impressed by the fast response in this site.
rajorcl
-
See my response to this thread to see how to capture *all* the SQL that a session is submitting:
http://www.dbasupport.com/forums/sho...threadid=37833
Tom Best
-
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.
Michel Bartov
http://www.barsoft.net/
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|