Gruñidos sobre …

9 enero 2014

GV$ Function

Filed under: Oracle — fidelinho @ 10:45 am

Estaba intentando usar V$DIAG_ALERT_EXT en un sistema RAC, pero sólo contiene información sobre la instancia actual y no existe una vista global. Esta función resuelve el problema 🙂


I really thought I’d blogged about this before, but it appears not!

First of all, this isn’t something I’ve worked out, I’m just recycling something that John Beresniewicz (who seems to be better known as JB) shared during one of his presentations at the UKOUG Conference 2011. This wasn’t a big part of the presentation, but it jumped out at me as a gem of knowledge that I was unlikely to get from anywhere else. In fact, as I recall, John described how he only became aware of the functionality as a result of discussing what he was working on, and the problem he had, to a member of the database server development team at Oracle.

That nicely brings me to the usual, and very important, point about Oracle functionality that isn’t documented: It is not supported (unless someone from Oracle tells you otherwise).

So, did you know that as…

Ver la entrada original 378 palabras más


Blog de

A %d blogueros les gusta esto: