RE: 9.2 V$ views
- From: Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Jul 2004 17:18:31 -0500
Tanel,
(like even analyzing DD in 9.2, etc.)
Can't that lead us to other problems?
Larry
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Tanel P=F5der
Sent: Monday, July 26, 2004 5:10 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: 9.2 V$ views
<snip>
> from
> v$_lock l
> ,x$ksuse s
> ,x$ksqrs r
> where l.saddr=3Ds.addr
> and l.raddr=3Dr.addr
> ;
And when you go RAC, your queries from v$lock will start returning extra
rows for each instance, because there is no inst_id restriction in the view.
Generally I'd advise against changing any of v$ views or public synonyms on
them, instead I'd try to find another solution first (like even analyzing DD
in 9.2, etc.).
One solution to get your own custom v$ views is to make a v$lock view or
synonym to your own schema. Local schema objects take preference over public
synonyms when referenced in SQL, that way you don't change any of the SYS
objects, which is mostly unsupported anyway.
Tanel.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,=20
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
