When a PROMON -F session is disconnected the database sometimes becomes connectionless and won't shutdown
Intermittent connection-less database that fails to shutdown after a PROMON -F session logs out
Any new connection hangs including a new
promon -F and utilities (proutil, dbtool), then subsequently does not shut down
At this time, the database is currently running without error and data is being read and written to the database
Even though new users cannot connect the database it is still processing transactions
To recover, all processes have to be killed off and eventually the database broker itself.
promon option latch counts shows the latch owner, if a user is holding a usr latch.
promon dbname -NL -F
R&D > debghb > 11. Latch counts