Lock Activity - What is Diana Version Enqueue

[Horace]

Hi,

Monitoring our 817 database on Win2K using Quest's Spotlight tool.

In the Lock Activity tab - it lists 'Diana Version Enqueue'

Tried Metalink, but no joy..........

Anyone know what this is all about ??

[jmodic]

From PL/SQL User's Guide and Reference manual (http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/e_lims.htm):

PL/SQL is based on the programming language Ada. As a result, PL/SQL uses a variant of Descriptive Intermediate Attributed Notation for Ada (DIANA), which is a tree-structured intermediate language. It is defined using a meta-notation called Interface Definition Language (IDL). DIANA provides for communication internal to compilers and other tools.

At compile time, PL/SQL source code is translated into machine-readable m-code. Both the DIANA and m-code for a procedure or package are stored in the database. At run time, they are loaded into the shared (memory) pool. The DIANA is used to compile dependent procedures; the m-code is simply executed.

So whenever a PL/SQL object is loaded into shared pool, the proces must obtain an enqueue lock on the object's DIANA tree-structure to get it.

[Horace]

Oh yeah, I knew that !!!!!! Just forgot it for a moment...........

Seriously though, thanks for that great piece of info.