Understanding this command can help to kill shared server session,
e.g. alter system disconnect session ' 11, 14521' immediate;
However, this didn't seem to work in my production situation. The session was not gone until we stopped application end.
Any comments ?
Monday, July 14, 2014
Friday, July 11, 2014
ORA-01114
ORA-00603: ORACLE server session terminated by fatal error
ORA-24557: error 1114 encountered while handling error 1114; exiting server process
ORA-01114: IO error writing block to file 204 (block # 76928)
Please refer to my reply here
ORA-24557: error 1114 encountered while handling error 1114; exiting server process
ORA-01114: IO error writing block to file 204 (block # 76928)
ERROR at line
1:
ORA-12801: error signaled in
parallel query server P037
ORA-01114: IO error writing
block to file (block # )
ORA-01114: IO error writing
block to file 1527 (block # 3126400)
ORA-27072: File I/O error
Additional information: 4
Additional information: 3126400
Additional information: -1
Hit above error, even run a small query irregardless off 300GB TEMP space.
Subscribe to:
Posts (Atom)