Using x$ tables in production

From: McPeak, Matt <vxsmimmcp_at_subaru.com>
Date: Tue, 25 Aug 2015 17:03:35 +0000
Message-ID: <AFDDB440FA283042BCC0AB8E5C2EDF637D1808_at_S7041VA006.soa.soaad.com>

So, as a DBA and/or experienced developer of production-quality systems, would you ever:

• Make a view on (or otherwise expose select access to) an SYS.X$* table to a non SYS user?
• Use that view (or direct access) in an production system to drive a process.

My question is about using X$ tables in general. Are they OK to use (I know they can change from release to release), or is using one like logging on as SYS (i.e., just don't do it)?

Thoughts (with supporting evidence, if possible)?

Thanks!
Matt

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

Received on Tue Aug 25 2015 - 19:03:35 CEST