Difference between a hot backup and a cold backup
|
Explain the difference between a hot backup and a cold backup.A cold backup is done when there is no user activity going on with the system. Also called as offline backup, is taken when the database is not running and no users are logged in. all files of the database are copied and no changes during the copy are made.
A hot backup is taken when the database needs to run all the time. It is an online backup. All files of the database are copied and there may be changes to the database during the copy.
|
What is the cache hit ratio?Cache hit ratio - When the cache client like a CPU, web browser etc finds a successful entry in the cache memory, it is called as a cache hit...
Concept of the DUAL tableDUAL table - On installing Oracle database, DUAL table Is present by default. It is a special table with just one row.....
