oracle杀死session影响,为何oracle session杀了又冒出来

10205单实例

客户的某些开发库经常需要从生产库refresh，最常用的做法是数据泵；

删除开发库的用户时因有session连接报错，需先将其kill

SQL> select 'alter system kill session '''||sid||','||serial#||''';' from v$session where username in ('GP','ECMF');

'ALTERSYSTEMKILLSESSION'''||SID||','||SERIAL#||''';'

--------------------------------------------------------------------------------

alter system kill session '628,30999';alter system kill session '699,442';

alter system kill session '631,20832';

alter system kill session '634,46544';

alter system kill session '637,59836';

alter system kill session '640,42040';

alter system kill session '644,15680';

alter system kill session '652,54203';

alter system kill session '653,49518';

alter system kill session '656,46428';

alter system kill session '672,44523';

alter system kill session '677,9077';

alter system kill session '680,50794';

alter system kill session '686,13863';

alter system kill session '692,61546';

alter system kill session '629,2272';

--执行完kill查看

SQL> select 'alter system kill session '''||sid||','||serial#||''';' from v$session where username in ('GP','ECMF');

'ALTERSYSTEMKILLSESSION'''||SID||','||SERIAL#||''';'

--------------------------------------------------------------------------------

alter system kill session '628,31001';

alter system kill session '694,35119';

alter system kill session '637,59836';

--执行完kill再次查看

SQL> select 'alter system kill session '''||sid||','||serial#||''' immediate;' from v$session where username in ('GP','ECMF');

'ALTERSYSTEMKILLSESSION'''||SID||','||SERIAL#||'''IMMEDIATE;'

--------------------------------------------------------------------------------

alter system kill session '629,2275' immediate;alter system kill session '694,35123' immediate;

alter system kill session '634,46547' immediate;

alter system kill session '637,59836' immediate;

alter system kill session '640,42043' immediate;

alter system kill session '644,15683' immediate;

alter system kill session '652,54206' immediate;

alter system kill session '653,49521' immediate;

alter system kill session '656,46431' immediate;

alter system kill session '672,44526' immediate;

alter system kill session '674,9149' immediate;

alter system kill session '677,9080' immediate;

alter system kill session '680,50797' immediate;

alter system kill session '686,13866' immediate;

alter system kill session '692,61549' immediate;

alter system kill session '631,20836' immediate;

--执行后查看

SQL> select 'alter system kill session '''||sid||','||serial#||''' immediate;' from v$session where username in ('GP','ECMF');

'ALTERSYSTEMKILLSESSION'''||SID||','||SERIAL#||'''IMMEDIATE;'

--------------------------------------------------------------------------------

alter system kill session '674,9151' immediate;

alter system kill session '637,59836' immediate;

--

咋跟韭菜似的 割不干净阿？

上述红色标注的session，要么每次kill后serial#自动增加借尸还魂(sid=629/628)，要么无法Kill(sid=637)；

请问此种现象该如何解释，莫非客户端有自动重连机制？那sid=637生命力为何如此顽强？

注：最后调用kill -9且修改了用户密码才解决