Re: return all base objects referenced by a cursor?
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 31 Oct 2008 17:39:51 +0100
Message-ID: <490b34d6$0$19713$426a74cc@news.free.fr>
Date: Fri, 31 Oct 2008 17:39:51 +0100
Message-ID: <490b34d6$0$19713$426a74cc@news.free.fr>
<wodenic_at_googlemail.com> a écrit dans le message de news: 01d9da60-580a-4499-a0a7-1a39593ba4bc_at_k36g2000pri.googlegroups.com...
| Hi,
|
| Its been a slow day at work, and I had a thought to write a bit of sql
| to return the list of indexes, last time analyzed, and num_rows for a
| given cursor.
|
| I initially thought about using the join and split pl/sql functions
| available on the web to take sql_text and parse it to return the top
| level of objects referenced 1 per row, but i am now curious if there
| is a better view to obtain all the base objects referenced by a
| cursor. Any ideas?
|
| thanks
| Craig Simpson
V$OBJECT_DEPENDENCY
Regards
Michel
Received on Fri Oct 31 2008 - 11:39:51 CDT