Path: utzoo!attcan!uunet!world!decwrl!shelby!rutgers!gatech!prism!arabian.gatech.edu!martin
From: martin@arabian.gatech.edu (Martin Robert Frank)
Newsgroups: comp.databases
Subject: The EXPLAIN statement in ORACLE
Message-ID: <15970@hydra.gatech.EDU>
Date: 28 Oct 90 18:39:43 GMT
Sender: news@prism.gatech.EDU
Reply-To: martin@arabian.gatech.edu (Martin Robert Frank)
Organization: Georgia Institute of Technology
Lines: 17



Hi,
I am doing some work on constructing a tool to monitor and evaluate the
usage pattern in a relational DBMS.
I would like to use ORACLE V6 for a test implementation of this tool,
however I run into trouble finding out about internal data at query
evaluation time, e.g. the number of page accesses for a query. 
This is bacause ORACLE implements only a restricted version of the EXPLAIN
statement (only EXPLAIN PLAN).

Has somebody found out a workaround to get this data? Does ORACLE plan to
provide the full functionality of the EXPLAIN statement in the future.

Please email, I will summarize, thanks.
--
Martin R. Frank    martin@cc.gatech.edu   College of Computing, Georgia Tech