Tuesday 25 October 2011

What is suspending a database

Suspending a database halts all input and output (I/O) operations to datafiles and control files. You can use ALTER SYSTEM SUSPEND/ALTER SYSTEM RESUME statement to suspend the database. All ongoing I/O operations are allowed to complete and all new incoming db accesses are placed in a queued state.

No comments:

Post a Comment