Originally posted by Dilippatel
Vipassana, the v$object_usage is included in the 9i, so we may have to rely on the Explain plan.

You can search the queries for the related table from v$sql and then check the queries for the explain plan.
oh ur r right sir. i missed to observe he works on 8i.