oracle导出时能否停止,Oracle exp导出停止不前

最新推荐文章于 2024-03-07 18:34:43 发布

魔王别嚣张

最新推荐文章于 2024-03-07 18:34:43 发布

阅读量274

点赞数

文章标签： oracle导出时能否停止

v$session_wait内容：

1 1016 26 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 2723168908 6 Idle -1 0 WAITED SHORT TIME

2 1017 2 Streams AQ: qmn slave idle wait 0 00 0 00 0 00 2723168908 6 Idle 0 324 WAITING

3 1018 239 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 5557 WAITING

4 1019 126 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 0 WAITING

5 1020 773 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 2173 WAITING

6 1021 64 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 5467 WAITING

7 1022 13119 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236524 00000005CA70F3AC 3875070507 4 Concurrency 0 0 WAITING

8 1023 33791 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236525 00000005CA70F3AD 3875070507 4 Concurrency 0 0 WAITING

9 1025 22174 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236513 00000005CA70F3A1 3875070507 4 Concurrency 0 0 WAITING

10 1027 10894 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236522 00000005CA70F3AA 3875070507 4 Concurrency 0 0 WAITING

11 1028 33420 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236527 00000005CA70F3AF 3875070507 4 Concurrency 0 0 WAITING

12 1029 13011 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236528 00000005CA70F3B0 3875070507 4 Concurrency 0 0 WAITING

13 1030 38169 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236512 00000005CA70F3A0 3875070507 4 Concurrency 0 0 WAITING

14 1031 21307 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236515 00000005CA70F3A3 3875070507 4 Concurrency 0 0 WAITING

15 1032 43973 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236509 00000005CA70F39D 3875070507 4 Concurrency 0 0 WAITING

16 1033 47408 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236501 00000005CA70F395 3875070507 4 Concurrency 0 0 WAITING

17 1034 225 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 2182 WAITING

18 1035 2 enq: FU - contention name|mode 1179975686 0000000046550006 0 0 00 0 0 00 1893977003 0 Other 0 153 WAITING

19 1036 60904 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236512 00000005CA70F3A0 3875070507 4 Concurrency 0 0 WAITING

20 1037 9568 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236529 00000005CA70F3B1 3875070507 4 Concurrency 0 0 WAITING

21 1039 19090 SQL*Net message from client driver id 1952673792 0000000074637000 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 72 WAITING

22 1040 19090 SQL*Net message from client driver id 1952673792 0000000074637000 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 72 WAITING

23 1041 56813 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236516 00000005CA70F3A4 3875070507 4 Concurrency 0 0 WAITING

24 1043 40599 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236501 00000005CA70F395 3875070507 4 Concurrency 0 0 WAITING

25 1044 25750 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236515 00000005CA70F3A3 3875070507 4 Concurrency 0 0 WAITING

26 1045 40650 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236519 00000005CA70F3A7 3875070507 4 Concurrency 0 0 WAITING

27 1046 19499 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236507 00000005CA70F39B 3875070507 4 Concurrency 0 0 WAITING

28 1047 24554 SQL*Net message from client driver id 1952673792 0000000074637000 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 102 WAITING

29 1048 40869 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236523 00000005CA70F3AB 3875070507 4 Concurrency 0 0 WAITING

30 1049 3323 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236508 00000005CA70F39C 3875070507 4 Concurrency 0 0 WAITING

31 1050 51039 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236504 00000005CA70F398 3875070507 4 Concurrency 0 0 WAITING

32 1051 59612 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236502 00000005CA70F396 3875070507 4 Concurrency 0 0 WAITING

33 1052 974 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236514 00000005CA70F3A2 3875070507 4 Concurrency 0 0 WAITING

34 1053 26239 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236505 00000005CA70F399 3875070507 4 Concurrency 0 0 WAITING

35 1054 38909 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236510 00000005CA70F39E 3875070507 4 Concurrency 0 0 WAITING

36 1055 25128 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236519 00000005CA70F3A7 3875070507 4 Concurrency 0 0 WAITING

37 1057 15545 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236506 00000005CA70F39A 3875070507 4 Concurrency 0 0 WAITING

38 1058 20937 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236517 00000005CA70F3A5 3875070507 4 Concurrency 0 0 WAITING

39 1059 520 library cache lock handle address 5.04403165826987E17 07000001C2B332E8 lock address 5.04403165389813E17 07000001A8A473B0 100*mode+namespace 501 00000000000001F5 3875070507 4 Concurrency 0 2998399 WAITING

40 1060 65457 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236527 00000005CA70F3AF 3875070507 4 Concurrency 0 0 WAITING

41 1061 22347 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236532 00000005CA70F3B4 3875070507 4 Concurrency 0 0 WAITING

42 1062 24554 SQL*Net message from client driver id 1952673792 0000000074637000 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 102 WAITING

43 1063 34361 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236504 00000005CA70F398 3875070507 4 Concurrency 0 0 WAITING

44 1064 42502 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236531 00000005CA70F3B3 3875070507 4 Concurrency 0 0 WAITING

45 1065 54170 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236521 00000005CA70F3A9 3875070507 4 Concurrency 0 0 WAITING

46 1067 17580 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236520 00000005CA70F3A8 3875070507 4 Concurrency 0 0 WAITING

47 1069 14791 SQL*Net message from client driver id 1650815232 0000000062657100 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 54 WAITING

48 1070 11118 SQL*Net message from client driver id 1650815232 0000000062657100 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 0 WAITING

49 1071 21984 cursor: pin S wait on X idn 1241645471 000000004A02019F value 4642859646976 0000043900000000 where|sleeps 24871236530 00000005CA70F3B2 3875070507 4 Concurrency 0 0 WAITING

50 1072 50449 Streams AQ: waiting for messages in the queue queue id 32516 0000000000007F04 process# 5.04403165869119E17 07000001C53617D0 wait time 10 000000000000000A 2723168908 6 Idle 0 3 WAITING

51 1074 28797 Streams AQ: waiting for time management or cleanup tasks 0 00 0 00 0 00 2723168908 6 Idle 0 286 WAITING

52 1078 58398 Streams AQ: qmn coordinator idle wait 0 00 0 00 0 00 2723168908 6 Idle 0 9 WAITING

53 1080 51516 SQL*Net message from client driver id 1650815232 0000000062657100 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 390 WAITING

54 1081 37683 gc cr request file# 1 0000000000000001 block# 28300 0000000000006E8C class# 1 0000000000000001 3871361733 11 Cluster 0 6 WAITING

55 1082 61737 rdbms ipc message timeout 300 000000000000012C 0 00 0 00 2723168908 6 Idle 0 3 WAITING

56 1087 20369 rdbms ipc message timeout 100 0000000000000064 0 00 0 00 2723168908 6 Idle 0 219 WAITING

57 1088 55398 rdbms ipc message timeout 300 000000000000012C 0 00 0 00 2723168908 6 Idle 0 3 WAITING

58 1089 18536 rdbms ipc message timeout 500 00000000000001F4 0 00 0 00 2723168908 6 Idle 0 69 WAITING

59 1090 13745 rdbms ipc message timeout 60055 000000000000EA97 0 00 0 00 2723168908 6 Idle 0 219 WAITING

60 1091 59588 smon timer sleep time 300 000000000000012C failed 0 00 0 00 2723168908 6 Idle 0 74 WAITING

61 1092 58171 rdbms ipc message timeout 300 000000000000012C 0 00 0 00 2723168908 6 Idle 0 0 WAITING

62 1093 37070 rdbms ipc message timeout 300 000000000000012C 0 00 0 00 2723168908 6 Idle 0 0 WAITING

63 1094 15090 rdbms ipc message timeout 300 000000000000012C 0 00 0 00 2723168908 6 Idle 0 93 WAITING

64 1095 40903 rdbms ipc message timeout 300 000000000000012C 0 00 0 00 2723168908 6 Idle 0 30 WAITING

65 1096 8 rdbms ipc message timeout 300 000000000000012C 0 00 0 00 2723168908 6 Idle 0 3093874 WAITING

66 1097 436 gcs remote message waittime 24 0000000000000018 poll 0 00 event 0 00 2723168908 6 Idle 0 874 WAITING

67 1098 856 gcs remote message waittime 24 0000000000000018 poll 0 00 event 0 00 2723168908 6 Idle 0 54369 WAITING

68 1099 3944 gcs remote message waittime 24 0000000000000018 poll 0 00 event 0 00 2723168908 6 Idle 0 12654 WAITING

69 1100 802 gcs remote message waittime 24 0000000000000018 poll 0 00 event 0 00 2723168908 6 Idle 0 40996 WAITING

70 1101 542 ges remote message waittime 64 0000000000000040 loop 0 00 p3 0 00 2723168908 6 Idle 0 1954 WAITING

71 1102 2017 rdbms ipc message timeout 10 000000000000000A 0 00 0 00 2723168908 6 Idle 0 0 WAITING

72 1103 56466 rdbms ipc message timeout 300 000000000000012C 0 00 0 00 2723168908 6 Idle 0 33 WAITING

73 1104 13 DIAG idle wait component 1 0000000000000001 where 1 0000000000000001 wait time(millisec) 200 00000000000000C8 2723168908 6 Idle 0 5263 WAITING

74 1105 5 pmon timer duration 300 000000000000012C 0 00 0 00 2723168908 6 Idle 0 3093876 WAITING

魔王别嚣张

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
oracle导出时能否停止,Oracle exp导出停止不前

v$session_wait内容：1 1016 26 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 ...
复制链接

扫一扫