RE: Using x$ tables in production
- From: Rich J <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 25 Aug 2015 13:25:43 -0500
On 2015/08/25 12:32, Mark W. Farnham wrote:
So, my advice is avoid this unless you need to for a reason, and my evidence
that it does not necessarily cause harm per se is that x$ tables are
referenced and exposed via some v$ views already.
Viewing V$ views is unlikely to cause the symptoms of an instance hang.
X$ views are a different beast. Some, like X$KSMSP, have the ability to
cause severe issues (info courtesy of Tanel's blog).
Tread very carefully.
Rich
Other related posts: