Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: V$ tables
"Hemant K Chitale" <hkchital_nospam_at_singnet_nospam.com.sg> wrote in message news:<aegvid$6e3$1_at_coco.singnet.com.sg>...
> I agree with both Daniel and Sybrand.
>
> Allow developers to access v$ and dictionary views. Let
> them learn about how to trace sessions, identify locks,
> identify bad SQL etc. They'd be grateful.
> However, enforce a rule about not using v$ views in
> application code.
>
Hmmmm ...
I would say that there are exceptions. Sometimes there may be a need to access V$SESSION, say.
See
http://groups.google.com/groups?hl=en&lr=&safe=off&selm=9iv536025ol%40drn.newsguy.com
CE Received on Mon Jun 17 2002 - 05:46:21 CDT