Long session related to PZ98
HI Everybody,
We are using RAC running 10gR2 based on four nodes. On one of the nodes, we have a session started more than 22 days ago and still in active status.
Tha session is related to process PZ98. Then it's a parellel session started by aother node.
Below, is the output of the query : select * from gv$sssion where sid=457 and inst_id=4.
4,00000001668F5530,457,600,4294967295,00000001665FE810,0,SYS,3,131455,,,ACTIVE,DEDICATED,0,SYS,oracle,8800,rachmaninoff02.register.it,,oracle@rachmaninoff04.register.it (PZ98),USER,00,0,,0,00,0,,0,,,,,racgimon@rachmaninoff02.register.it (TNS V1-V3),305308502,,0,,26297003,-1,0,0,0,06-APR-14,1934186,NO,NONE,NONE,NO,,DISABLED,ENABLED,ENABLED,0,,UNKNOWN,,,17,329,IPC send completion sync,send count,1,0000000000000001,,0,00,,0,00,1893977003,0,Other,0,1934156,WAITING,SYS$USERS,DISABLED,FALSE,FALSE