Mohammad Jeffry wrote:

> Thanks for the input. I'll suggest this to my developer. I would imagine
> checking the "unclose" db connection in the source code gonna take some time
> because this is a very huge application. While waiting for the dev team to
> finish on that, the production system need to go on. The only temporary
> measue is to do a backup restore to improve the db performance...
>

No need to backup and restore. Just shutdown the database (or server)
and restart it. That will kill all open transactions.


Regards


Ann