********************************************************************
*** BEQ-LOCAL                             07/09/2011 6:31:50 PM  ***
********************************************************************
 
~Time to Connect             : 0 seconds.
 
~Database Version            : Oracle9i Enterprise Edition Release 9.0.1.1.1 
~Database Up Since           : 01:01:09 PM, September 7 2011
!Buffer Cache Hit Ratio      : 77.8311   <------- (in red colour)
~Library Cache Miss Ratio    : 0.2612
~Dictionary Cache Miss Ratio : 2.7429
 
[Shared Pool Usage] Exec Time 0 seconds
~ Total Mb Unused : 23.97
~ Total Mb Used   : 24.03
~ Total Mb        : 48
~ Shared Pool Percent Used : 50.06
 
[Archive Log Mode Info] Exec Time 0 seconds
! Archiver : STOPPED   <------- (in red colour)
! Log Mode : NOARCHIVELOG <------- (in red colour)
! log_archive_start (init.ora param) = FALSE <------- (in red colour)
 
[Archive Log Info] Exec Time 0 seconds
~ Average Log Switches Per Day                          : 12.58
~ Hard Drive Storage (in Mb) for this many archive logs : 1257.92
 
!  Error using UTL_FILE to examine alert log! <------- (in red colour)
!  Error using UTL_FILE  <------- (in red colour)
!  Possible causes:  <------- (in red colour)
!  1)  You don't have privileges to execute the UTL_FILE package.  <------- (in red colour)
!  2)  UTL_FILE_DIR initialization parameter does not include one of these lines:   <------- (in red colour)
!      utl_file_dir=D:\oracle\admin\orcl90\bdump   <------- (in red colour)
!      utl_file_dir=*    <------- (in red colour)
!  3)  alert.log file name is not among the following:    <------- (in red colour)
!      (if this is the case please inform Quest support)   <------- (in red colour)
!      alert_orcl90.log  <------- (in red colour)
!      orcl90alrt.log   <------- (in red colour)
!  4)  No directory has been created for D:\oracle\admin\orcl90\bdump,   <------- (in red colour)
!      or directory exists but privileges have not been granted for it.    <------- (in red colour)
 
[Redo Log Group Sizes and Quantities] Exec Time 0 seconds
~ Number of Log Groups : 3
! Number of Members per Log Group: 1    <------- (in red colour)
~ All redo log members are 100M in size. 
 
[Rollback Segments with wait ratios > 1 %] Exec Time 1 seconds
~ None
 
[Objects with Mixed-Case Names] Exec Time 1 seconds
! Synonym            PUBLIC.NameFromLastDDL   <------- (in red colour)
 
[Tables with > 5 % chained rows and > 500 total rows] Exec Time 0 seconds
~ None
 
[Table Partitions with > 5 % chained rows and > 500 total rows] Exec Time 0 seconds
~ None
 
[Segments with < 10% of extents remaining and (maxextents > 1)] Exec Time 11 seconds
~ None
 
[Segments with > 100 extents] Exec Time 4 seconds
~ None
 
[Objects which can't extend because there is not
enough room in the tablespace] Exec Time 3 seconds
~ None
 
[Jobs] Exec Time 0 seconds
~ None
 
[redundant object privs with conflicting grant option] Exec Time 2 seconds
~ None
 
[Profiles that are not granted to any user] Exec Time 0 seconds
~ None
 
[Tablespace Fragmentation] Exec Time 0 seconds
~ None
 
[Tablespaces with less than 10% free space] Exec Time 1 seconds
! EXAMPLE                   : 0.1% Free Space,  MB Free / Total : 0 / 153    <------- (in red colour)