sss.sh@cosol.jp

1.2014-10-30 09:56:17.152,testcase/tc_enq_tx_l11204.trc
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
proc/sess state summary
~~~~~~~~~~~~~~~~~~~~~~~

proc state						sess state
pid	addr	user	term	ospid	image	saddr	sid	ser	service	username	process	term	cli_info	module	action	machine	osuser	program	command	sql_addr	block_sess	wait_time	seq	event
1	32bf578c			(DEAD)
2	32bf62b8	oracle	UNKNOWN	6405	PMON	322abac4	125	1	SYS$BACKGROUND	SYS												0.604719_sec	35	pmon_timer
3	32bf6de4	oracle	UNKNOWN	6407	PSP0	32358e5c	187	1	SYS$BACKGROUND	SYS												0.000167_sec	131	rdbms_ipc_message
4	32bf7910	oracle	UNKNOWN	6409	VKTM	32151394	1	1	SYS$BACKGROUND	SYS												1_min_28_sec	1	VKTM_Logical_Idle_Wait
5	32bf843c	oracle	UNKNOWN	6413	GEN0	321fba78	64	1	SYS$BACKGROUND	SYS												0.001637_sec	34	rdbms_ipc_message
6	32bf8f68	oracle	UNKNOWN	6415	DIAG	322a8e10	126	1	SYS$BACKGROUND	SYS												0.000211_sec	90	DIAG_idle_wait
7	32bf9a94	oracle	UNKNOWN	6417	DBRM	323561a8	188	1	SYS$BACKGROUND	SYS												0.001848_sec	44	rdbms_ipc_message
8	32bfa5c0	oracle	UNKNOWN	6419	DIA0	3214e6e0	2	1	SYS$BACKGROUND	SYS												0.000251_sec	90	DIAG_idle_wait
9	32bfb0ec	oracle	UNKNOWN	6421	MMAN	321f8dc4	65	1	SYS$BACKGROUND	SYS												0.001144_sec	38	rdbms_ipc_message
10	32bfbc18	oracle	UNKNOWN	6423	DBW0	322a615c	127	1	SYS$BACKGROUND	SYS												0.000584_sec	70	rdbms_ipc_message
11	32bfc744	oracle	UNKNOWN	6425	LGWR	323534f4	189	1	SYS$BACKGROUND	SYS												0.001551_sec	299	rdbms_ipc_message
12	32bfd270	oracle	UNKNOWN	6427	CKPT	3214ba2c	3	1	SYS$BACKGROUND	SYS												0.000746_sec	120	rdbms_ipc_message
13	32bfdd9c	oracle	UNKNOWN	6429	SMON	321f6110	66	1	SYS$BACKGROUND	SYS									SELECT	3254b14c
14	32bfe8c8	oracle	UNKNOWN	6431	RECO	322a34a8	128	1	SYS$BACKGROUND	SYS												0.000194_sec	8	rdbms_ipc_message
15	32bff3f4	oracle	UNKNOWN	6433	MMON	32350840	190	1	SYS$BACKGROUND	SYS												0.002836_sec	581	rdbms_ipc_message
16	32034010	oracle	UNKNOWN	6435	MMNL	32148d78	4	1	SYS$BACKGROUND	SYS												0.000323_sec	91	rdbms_ipc_message
17	32034b3c	oracle	UNKNOWN	6437	D000
18	32035668	oracle	UNKNOWN	6439	S000
19	32036194	oracle	UNKNOWN	6482		3234db8c	191	3	SYS$USERS	SYS	6401	pts⁄1		sqlplus@ol48x86s_(TNS_V1-V3)		ol48x86s	oracle	sqlplus@ol48x86s				39.306014_sec	1241	SQL*Net_message_from_client
20	32036cc0	oracle	UNKNOWN	6481		321460c4	5	3	SYS$USERS	SYS	6480	pts⁄2		sqlplus@ol48x86s_(TNS_V1-V3)		ol48x86s	oracle	sqlplus@ol48x86s	SELECT	325bdec4	sid:191⁄ser:3@inst:1	14.854838_sec	20	enq:_TX_-_row_lock_contention
21	320377ec	oracle	UNKNOWN	6484	QMNC	321fe72c	63	13	SYS$BACKGROUND	SYS												0.002185_sec	13	Streams_AQ:_qmn_coordinator_idle_wait
22	32038318	oracle	UNKNOWN	6603		3228fbbc	135	9	SYS$USERS	SYS	6602	pts⁄4		sqlplus@ol48x86s_(TNS_V1-V3)		ol48x86s	oracle	sqlplus@ol48x86s
23	32038e44	oracle	UNKNOWN	6531		32348224	193	11	SYS$USERS	SYS	6530	pts⁄3		sqlplus@ol48x86s_(TNS_V1-V3)		ol48x86s	oracle	sqlplus@ol48x86s				1_min_23_sec	17	SQL*Net_message_from_client
26	3203afc8	oracle	UNKNOWN	6535	CJQ0	3229ae8c	131	3	SYS$BACKGROUND	SYS												0.001206_sec	150	rdbms_ipc_message
37	32042aac	oracle	UNKNOWN	6598	Q000	321eae40	70	3	SYS$BACKGROUND	SYS												0.001712_sec	24	Streams_AQ:_qmn_slave_idle_wait
38	320435d8	oracle	UNKNOWN	6600	Q001	3228cf08	136	51	SYS$BACKGROUND	SYS												0.000156_sec	4	Streams_AQ:_waiting_for_time_management_or_cleanup_tasks

waiter/holder summary
~~~~~~~~~~~~~~~~~~~~~

waiter					holder
type	id	pid	mode	event	pid	mode	event
enqueue	TX-00030011-000002AB	20	X	enq:_TX_-_row_lock_contention	19	X	SQL*Net_message_from_client