我想查看某条语句是那个会话执行的一条sql语句:
select saddr,sid,user_NAME,ADDRESS,HASH_VALUE,SID,CURSOR_TYPE from V$OPEN_CURSOR where sql_id='dz7bbcwhuhhp7' order by 2;
SADDR
SID USER_NAME
ADDRESS
HASH_VALUESID CURSOR_TYPE
---------------- ---------- ------------------------------ ---------------- ---------- ---------- ----------------------------------------------------------------
000000134218C0A0437 XXXXXX_YYY
00000000A9EB38A8564675239437 OPEN
0000001342393560 1301 XXXXXX_YYY
00000000A9EB38A8564675239 1301 OPEN
00000012D2919428 4090 XXXXXX_YYY
00000000A9EB38A8564675239 4090 OPEN
00000012A2A2D088 4517 XXXXXX_YYY
00000000A9EB38A8564675239 4517 OPEN
00000012A2A2D088 4517 XXXXXX_YYY
00000000A9EB38A8564675239 4517 OPEN
00000012C2AF04B8 5121 XXXXXX_YYY
00000000A9EB38A8564675239 5121 OPEN
0000001342C526C0 5695 XXXXXX_YYY
00000000A9EB38A8564675239 5695 OPEN
00000012B2CE2030 5984 XXXXXX_YYY
00000000A9EB38A8564675239 5984 OPEN
0000001342ECABE0 6965 XXXXXX_YYY
00000000A9EB38A8564675239 6965 OPEN
0000001342ECABE0 6965 XXXXXX_YYY
00000000A9EB38A8564675239 6965 OPEN
0000001342ECABE0 6965 XXXXXX_YYY
00000000A9EB38A8564675239 6965 OPEN
00000012B2F60710 7242 XXXXXX_YYY
00000000A9EB38A8564675239 7242 OPEN
00000012B2F60710 7242 XXXXXX_YYY
00000000A9EB38A8564675239 7242 OPEN
00000012C2F42178 7345 XXXXXX_YYY
00000000A9EB38A8564675239 7345 OPEN
14 rows selected.
--很奇怪,cursor_type都是OPEN。并且sid出现重复的情况(6965,7242),难道程序不断的重新连接吗?
--这条语句是每个会话每隔30秒执行1次。到底采用什么连接方式。
那位知道为什么会出现这种情况。
版本 11.2.0.4 linux 64位版本。。。。。。
|