Abnormal Form

Ever since I inherited the Grid Control project at my current company, I've despaired of ever finding a way to monitor the multiple databases in our Cold Failover Cluster (CFC) environments. You see, as of version 10.2.0.3, the recommended method for monitoring databases in a CFC setup was to install one agent per node, and one ...

I've been enjoying the clean and organized look of Subquery Factoring for awhile now, despite some of the current limitations of the feature. But I've recently run into what appears to be very strange behavior when using a global view (gv$...) in a subquery. Upon reflection, this limitation is understandable, given the nature of global instance ...