V$ACCESS Question

From: Daniel Looby ider <iasysdl_at_prism.gatech.edu>
Date: 14 Dec 1999 10:29:04 GMT
Message-ID: <83565g$gtd@catapult.gatech.edu>

A Pro*C process is doing a SELECT from a view as in:

  SELECT column3
    FROM view1
   WHERE column1 = :id1
     AND column2 = :id2

The view is comprised of data from five tables. While this is running a check is made of V$ACCESS by the sid.

The query returns values in the TYPE column such as: SYNONYM, PACKAGE, CURSOR, and more. The one I don't understand is NON-EXISTENT. What's that?

Thanks for any help in advance.

Dan
--
Daniel Looby ider
Georgia Institute of Technology, Atlanta Georgia, 30332 Email: iasysdl_at_prism.gatech.edu Received on Tue Dec 14 1999 - 04:29:04 CST