You develop new skills when you're down --Raghava KK

Raghava KK - Five Lives of an Artist:

Just watched this and yes I would recommend to watch this. Its worth watching such a creative and honest person speak.

http://www.ted.com/talks/raghava_kk_five_lives_of_an_artist.html

Wait Events - single-task message along with cursor: Pin S wait on X

Some thing or other to learn everyday...

Just got a call from one of our team stating that the application doesn't make connection to the database anymore!!!.

It just hangs.

Checked in the Database and don't see anything going on. Why is it hanging?

It was fine till yesterday... (as usual of-course. Everything starts fresh on first thing in the morning).

So, trying to figure out whats going on and looked into the sessions and found a new wait event(s)

"single-task message" on one session and "cursor: Pin S wait on X" on another session.

Good notes on resolving "cursor: Pin S wait on X" wait event was found in metalink with note id: 786507.1.

But that's not the issue that we facing...

Finally figured out that one of the DB-Link(s) that are used by Application are not valid anymore and thus the session is hanging (well "waiting").

Correct the DB-Link and all are happy... No more wait events...