This morning I have
experienced a couple of strange lockups of our database. The symptoms were
the database was nonresponsive to any activity, freeze on login to sqlplus,
active sessions freeze as soon as they interact with the db. There is
no alert log activity. The systems cpu usage soars to 100%, and an oracle
process, once a shared server and once a dedicated server, is dominating the
usage(info gathered from top).
The first time I
killed the shared server process, and the database picked up and operated
normally. Then a half hour later the dedicated connection popped up.
The dedicated connection was owned by one of our oltp processes that pretty well
runs without issue 24/7, so I decided to bounce the db to hopefully clear up the
issue.
Our system is Oracle
8.1.7 on Solaris 8. In short, I am hoping to get some ideas in
tracking down what happened. I have some sql scripts that I have used to
identify problem sessions/sql in the past. They focus on v$session,
v$sess_io, and v$sqltext. Unfortunately, these did me little good because
while the trouble was occurring I couldn't interact with the database while the
sessions were active.
I am soliciting
actively for any Hints, Tips, or Ideas you may have,
Thanks,
Steve
McClure
