Oracle Database Probe

Sessions;
Session_Active/Session_Used <= .1

Process;
Block_Mods_Sec > .25*Block_Gets_Sec

PGA_Allocated / SGA_Size >=.2
PGA_Used / PGA_Max <=.6

SGA;
-db buffer cache
DB_Buffer_Cache_Default_Hit < 85
DB_Buffer_Cache_Recycle_Hit < 85
DB_Buffer_Cache_Recycle_Used / DB_Buffer_Cache_Recycle_Max <=.6
DB_Buffer_Cache_Keep_Hit < 85
DB_Buffer_Cache_Keep_Used / DB_Buffer_Cache_Keep_Max <=.6
-Shared Pool
Shared_Pool_Dict_cache_Hit < 85
Shared_Pool_Dict_Cache_Tool < 2 M
Shared_Pool_Misc_Total / Shared_Pool_Overall_Total >=.4
-large pool
Large_Pool_Cur_Used / Large_Pool_Megs >=.8
Large_Pool_Max_Used / Large_Pool_Megs >=.8
-redo log buffer
Redo_Log_Buffer_Megs > 1 M
-lock sga
SGA_Lock=0
-pre page sga
Prepage=0
-cursor space for time
Cursor_space_for_time=0

File;
-data files
Data_Files_Datafiles >= Data_File_Tablespaces*2
Data_Files_Percent_Used >=80

OverHead;
Time_Stats_DB_InitORA > 0
Trace_Enabled_Oracle_InitORA > 0