今天下午收到客户的邮件，说有一个job在运行的时候报错了，希望我们能帮忙看看是什么原因。ERROR: Caught en exception: ORA-12801: error signaled in parallel query server P130 ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Additional information: 128 Additional information: 1 ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Additional information: 128 Additional information: 1 ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Additional information: 128 Additional information: 1 ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O Additional information: 3 Additional information: 128 Additional information: 2113522240 ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O Additional information: 3 Additional information: 128 Additional information: 2113522240 100449113 INACTIVE

Session_count osuser hash_value sql_id

1 truwl71 1443142349 bhm5y9tb096qd

4844 pcmwrk01 3361273624 5vxmncv45jxss

42 truwl15 941869720 f6hcnghw27kns

4 pcowrk01 3359590350 fa311gg43yjyf

15 pcmwrk01 2311663385 27uaksf4wkbst

65 parwrk01 1950821498 459f3z9u4fb3u

2 truwl74 1443142349 bhm5y9tb096qd

15 truwl35 941869720 f6hcnghw27kns

1 truwl35 3428812084 bwjxuug65z19n

30 truwl22 941869720 f6hcnghw27kns

1 truwl41 4042609743 bg0xgs3sgap2g

9 pcmwrk01 1204453754 frvwp893wp0bu

2 truwl74 4042609743 bg0xgs3sgap2g

1 truwl71 1488663547 b26tu71cbqczv

192 pcmwrk01 20635029 byd95500mprcp

1 truwl71 2397213050 26b628u7f54bu

64 pcmwrk01 2555678015 6vf0fzkc5939z

425 pcmwrk01 1950821498 459f3z9u4fb3u

36 truwl32 941869720 f6hcnghw27kns

5 parwrk01 1209197086 07h65fd415shy

1 truwl25 1605399126 g1p5bjdgv0wkq

32 truwl71 941869720 f6hcnghw27kns

32 truwl14 941869720 f6hcnghw27kns

449 pcmwrk01 3203606695 dm03006zg6a57

40 truwl65 941869720 f6hcnghw27kns

33 truwl43 941869720 f6hcnghw27kns

2 truwl53 647050378 f9mmq7sm92d4a5vxmncv45jxss)占用了相当多的session，可以断定这些session都是inactive的。这个可以通过如下的信息来验证。INACTIVE 9879