Sangam16 - Largest Independent Oracle Users Group Conference in India

 Errorstack and short_stack- Tool for advance Troubleshooting:-These are very useful and powerful tool when requirement is to know more about Oracle error , Even Oracle Support team uses these to solve many Oracle related error .Cases where we can use Oracle errorstack are as below..

- To find out the SQL statement which has caused the error
- To get Oracle Function call for interpreting cause for the error (e.g ORA 4030, ORA- 4031). 
- It is also used in case of database hang scenarios. 
- It also used in cases where Oracle process is taking 100% CPU.
- It can also be used to findout the reason for stuck sessions.
- It also contains execution plan in some cases which can be used to diagnose ORA - 1652 errors (Excessive temp usage)

short_stack:
- This is quick way to find if session is moving or has stuck .