Descriptions of Common Wait Event Parameters
来源:互联网 发布:unity3d 导入fbx 编辑:程序博客网 时间:2024/06/07 07:20
Descriptions of Common Wait Event Parameters
This section provides descriptions of some of the more common wait event parameters.
block#
This is the block number of the block for which Oracle needs to wait. The block number is relative to the start of the file. To find the object to which this block belongs, issue the following SQL statement:
select segment_name, segment_type, owner, tablespace_namefrom dba_extentswhere file_id = file# and block# between block_id and block_id + blocks - 1;
blocks
The number of blocks that is being either read from or written to the file. The block size is dependent on the file type:
Database files have a block size of
DB_BLOCK_SIZE
Logfiles and control files have a block size that is equivalent to the physical block size of the platform
break?
If the value for this parameter equals 0, a reset was sent to the client. A nonzero value indicates that a break was sent to the client.
class
The class of the block describes how the contents of the block are used. For example, class 1 represents data block, and class 4 represents segment header.
dba
The initials "dba" represents the data block address, which consists of a file number and a block number.
driver id
The address of the disconnect function of the driver that is currently being used.
file#
The following query returns the name of the database file:
select *from v$datafilewhere file# = file#;
id1
The first identifier (id1) of the enqueue or global lock takes its value from P2 or P2RAW. The meaning of the identifier depends on the name (P1).
id2
The second identifier (id2) of the enqueue or global lock takes its value from P3 or P3RAW. The meaning of the identifier depends on the name (P1).
le
The relative index number into V$GC_ELEMENT
.
mode
The mode is usually stored in the low order bytes of P1 or P1RAW and indicates the mode of the enqueue or global lock request. This parameter has one of the following values:
Table C-1 Lock Mode Values
1
Null mode
2
Sub-Share
3
Sub-Exclusive
4
Share
5
Share/Sub-Exclusive
6
Exclusive
Use the following SQL statement to retrieve the name of the lock and the mode of the lock request:
select chr(bitand(p1,-16777216)/16777215)|| chr(bitand(p1, 16711680)/65535) "Lock", bitand(p1, 65535) "Mode"from v$session_waitwhere event = 'DFS enqueue lock acquisition';
name and type
The name or "type" of the enqueue or global lock can be determined by looking at the two high order bytes of P1 or P1RAW. The name is always two characters. Use the following SQL statement to retrieve the lock name.
select chr(bitand(p1,-16777216)/16777215)|| chr(bitand(p1,16711680)/65535) "Lock"from v$session_waitwhere event = 'DFS enqueue lock acquisition';
namespace
The name of the object namespace as it is displayed in V$DB_OBJECT_CACHE
view.
requests
The number of I/Os that are "requested." This differs from the number of blocks in that one request could potentially contain multiple blocks.
session#
The number of the inactive session. Use the following SQL statement to find more information about the session:
select *from v$sessionwhere sid = session#;
waited
This is the total amount of time the session has waited for this session to terminate.
- Descriptions of Common Wait Event Parameters
- Descriptions of Wait Events
- Simple explanation of Wait Event “cursor: pin s”
- 公共参数(Common Parameters)
- Generation and Comprehension of Unambiguous Object Descriptions
- 【wait event】--CPU Time
- 等待事件 wait event
- lk中的event wait
- ORACLE wait event
- Oracle Common wait events
- How to get the field descriptions of a table?
- How to get the field descriptions of a table
- [tfs] Using rich HTML descriptions instead of plain text
- Learning Deep Representations of Fine-Grained Visual Descriptions
- library cache lock wait event
- oracle wait event:reliable message
- oracle wait event:reliable message
- oracle wait event 等待事件
- Linux常用命令全集(连接)
- 触发器
- C#图像细化:Hilditch细化算法
- Tutorial: Debugging the U-Boot Universal Boot Loader (最全的uboot调试方法,找了好久)
- 为嵌入式操作系统linux(二)
- Descriptions of Common Wait Event Parameters
- modprobe
- Classes of Wait Events
- Android待机的suspend_sys_sync_queue分析
- oracle创建索引 .
- socket python
- Mybatis学习总结
- UILocalNotification 实现 本地 提醒
- LLDB和GDB比较