V_$DIAG views pointing to a different ADR_HOME
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Wed, 29 May 2013 09:37:43 -0500 (CDT)
Message-ID: <0747d362fe9c4c7956d31058ba322305.squirrel_at_society.servebeer.com>
Hey all,
Date: Wed, 29 May 2013 09:37:43 -0500 (CDT)
Message-ID: <0747d362fe9c4c7956d31058ba322305.squirrel_at_society.servebeer.com>
Hey all,
As I'm waiting for a table move to finish, I thought I'd snoop around the V$ views in 11.2.0.3 on AIX. When I came across the V$DIAG views, I quickly spun through their data via Toad's schema browser to see what fun info might be lurking, until I came to V_$DIAG_V_ACTINC.
That view, along with at least V_$DIAG_V_ACTPROB and V_$DIAG_V_NFCINC, appear to show information for a different ADR_HOME. In this case, it was an ADR_HOME that I had not cleaned up after dropping a DB I no longer needed.
I can't seem to find any information on these views in the docs (http://docs.oracle.com/cd/E11882_01/server.112/e25513/dynviews_part.htm), MOS, google, duckduckgo or anywhere.
Thoughts?
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 29 2013 - 16:37:43 CEST