I am testing a product against an Oracle database for failure scenarios. The product talks to Oracle through a session and maintains a few tables. I want to make sure that whenever Oracle recovers from whatever errors it can recover, the product can recover too.
For this, I will be manually simulating failures and checking what happens. What are all the failure scenarios I should try?