What is a quick way to find out what's wrong with an oracle database

Submitted by barnettech on Wed, 09/09/2009 - 16:17

If you run this query, you'll get back info on any serious problems, also check the alert.log file. The alert log is located in $ORACLE_HOME/admin/$ORACLE_SID/bdump