>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

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s