We sometimes need to shutdown our oracle database but when we execute shutdown immediate it takes up to 2 hours. I dont want to execute shutdown abort. I have even made sure all connections to the database are gone.



We are using 8.1.7 oracle