In RAC environments, GES process structures are used to record details about local and remote processes with an interest in global locks.
There must be one GES process for each process in each instance in the cluster. Therefore there will be more GES process structures in each instance than KSUPR (process) structures.
I think that the abbreviation for GES processes is kjpIn the SGA there are two main GES process structures:
In Oracle 10.2.0.1 (32-bit Linux) the ges process array occupies 256000 bytes
In Oracle 10.2.01 (32-bit Linux) the ges process hash table occupies 8640 bytes
GES process structures are covered by three latches:
Latch Name | Variable Name |
ges process parent latch | kjptfl_ |
ges process hash list | kjplat_ |
ges process table freelist | kjphsh_ |
In Oracle 10.2.0.1 (32-bit Linux) :
Static kjp structures are also allocated for
A list of addresses of kjp structures can be obtained using
SQL> ORADEBUG LKDEBUG -a proc
For example
nproc = 30 etc... |
You can dump detailed information for each GES process using
SQL> ORADEBUG LKDEBUG -A proc
This command produces output in the following format for each GES process.
--------procp 0x2f43a730----------------- |
Possible values for the process state are probably KJP_NORMAL, KJP_FREEZE and KJP_UNFREEZE
The GES process structures also appear in the SYSTEMSTATE (level 10) dump:
SQL> ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME SYSTEMSTATE LEVEL 10';
SO: 0x2f43a730, type: 19, owner: 0x30222a18, flag: INIT/-/-/0x00 |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-84419/,如需转载,请注明出处,否则将追究法律责任。