Hi I found this one rather more informative. So, just wanted to share with u.

select
a.sql_fulltext, a.last_load_time,c.name, c.value_string
from
v$sql a, v$sql_bind_capture c
where
a.sql_id = c.sql_id and
a.child_address=c.child_address and
sql_text like
'select P.partyname,P.partycode,Q.QUOTATIONCODE,Q.QUOT_NO,P.TOLERANCE from partymst P, QUOTATION Q %'