RE: Using x$ tables in production

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

--
http://www.freelists.org/webpage/oracle-l