Monday, July 14, 2014

alter system disconnect session for shared server session

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 ?

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)


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.

Please refer to my reply here