Loading…
View analytic
Saturday, November 12 • 5:50pm - 6:40pm
Errorstack and short_stack - Tool for advance Troubleshooting FULL

Log in to save this to your schedule and see who's attending!

Limited Capacity full
Adding this to your schedule will put you on the waitlist.

 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 . 

Speakers
avatar for Rishi Raj Srivastava

Rishi Raj Srivastava

Oracle Database SME, HPE
Rishi has 11 years of experience as a DBA , he holds the many Oracle Certifications including Oracle Certified Master (OCM). Rishi has worked for companies like Accenture, Oracle, IBM. | His experience includes working as country SME (India SME) for IBM and currently he is working... Read More →


Saturday November 12, 2016 5:50pm - 6:40pm
Room - 5 First Floor