Day-29 : Miscellaneous

How would you determine the time zone under which a database was operating?
select DBTIMEZONE from dual;

You have been asked to write the requeriments for an automatic “health check” system for a database. What things would you include?
Tablespace size used/free/total and filesystem usage, swap/CPU/IO/Memory usage

A database is not shutting down 15 minutes after the shutdown immediate command was issued. What would you do?
shut abort

No comments:

ORA-600 [kwqitnmphe:ltbagi], [1], [0] reported in the alert log file.

ORA-00600 [kwqitnmphe:ltbagi] Cause: This issue arises in 12.1.0.2. The error occurs because there are still Historical Messages without...