Oracle 视图 V$SQL_SHARED_MEMORY 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图 V$SQL_SHARED_MEMORY 查看共享池中已经缓存的SQL语句。
它有几列：
HASH_VALUE：用于查找缓存的SQL语句的一个哈希值；
ADDRESS：共享内存中缓存SQL语句的地址；
KGLHDADR：SQL语句的内存结构的地址；
KGLHDSIZ：执行SQL语句时分配的内存的大小；
KGLHDNAM：缓存的SQL语句的标识符，例如它的HASH值；
KGLNAOBJ：引用缓存的SQL语句的对象的计数；
KGLNEXTS：缓存中SQL语句的下一个指针；
KGLNEXTB：缓存中SQL语句的上一个指针。
使用V$SQL_SHARED_MEMORY视图，可以查看数据库保存在共享池中的SQL语句，以及相关参数，如地址，大小等。此外，它还能用来查看数据库中缓存的SQL语句的个数、每个SQL语句中对象的数量以及它们在内存空间中的情况。
官方英文解释
V$SQL_SHARED_MEMORY displays information about the cursor shared memory snapshot. Each SQL statement stored in the shared pool has one or more child objects associated with it. Each child object has several parts, one of which is the context heap, which holds, among other things, the query plan.
| Column | Datatype | Description |
|---|---|---|
|
|
|
SQL text of the shared cursor child object for which this row is displaying information |
|
|
|
Full text for the SQL statement exposed as a |
|
|
|
Hash value of the above SQL text in the shared pool |
|
|
|
SQL identifier of the above SQL text in the shared pool |
|
|
|
Address of the descriptor for the context heap of the child cursor described in this row |
|
|
|
If the memory chunk described in this row was allocated using a comment of the form “X : Y”, then this is the “X” part of the comment |
|
|
|
Similar to the |
|
|
|
Whole comment field that was supplied when this memory chunk was allocated |
|
|
|
Starting address of the allocated memory chunk |
|
|
|
Amount of memory allocated for this chunk |
|
|
|
Class of memory that this chunk of memory belongs to. It will usually be either |
|
|
|
An index into a table of callback functions that tell the server how to re-create this chunk of memory should it need to be removed from the shared pool based on an LRU algorithm |
|
|
|
If the parent heap of this context heap is itself a subheap, then this is the address of the descriptor of the parent heap |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
