XREF isn't going to tell you anything for dataserver tables. Oracle decides how to execute the query at execution time and not compile time.
There are tools to show how queries are being executed on the Oracle side of the fence. You will have to use one of those to debug how well the code is performing.
Also reading up on the Oracle CBO (Cost Based Optimizer) would be a good idea.