Use $dbh->do("explain plan ... $sql") and query the plan table for the objects. Or if the code has already executed you should be able to find the data in v$sql_plan