Where to get plantable information about runtime queries!?!

From: John Vernes <vernes.j_at_consunet.nl>
Date: Mon, 23 Aug 1999 18:46:14 +0200
Message-ID: <7prtp3$3tv$1@news.worldonline.nl>

Hello,

we have a lot of programs working with pl/sql. In some programs we would like to save the query, together with the way the query accesses it's data. So we want to store the plan table for the query.

I know, we can run the query and store the information in the plan_table using same stategy as @utlxplan.sql But we don't want to do that. Oracle stores the plan table somewhere in it's data dictionary.

Is there anyone who knows where I can find this information??? It would be very usefull to me.

Thanx in advance.

-John Received on Mon Aug 23 1999 - 11:46:14 CDT