篇幅有限呀,汗- -

其实知道算法的话可以写出甚至比awr,statspack更细致优秀的报表,如果可以的话可以将grid的细粒度报表也可以实现,这样对DBA的工作更灵活了....

................

.'********THISISBUFFERCACHEHIT,SUGGESTION>90%********'                                                                                                                                                  
-------------------------------------------------------                                                                                                                                                
********This is Buffer Cache Hit,Suggestion>90%********                                                                                                                                                


Buffer cache Hit(%)                                                                                                                                                                                    
-------------------                                                                                                                                                                                    
         .998760486                                                                                                                                                                                    


'********THISISMEMORY/TOTALHIT,SUGGESTION>90%********'                                                                                                                                                 
-------------------------------------------------------                                                                                                                                                
********This is Memory/Total Hit,Suggestion>90%********                                                                                                                                                


Sort memory  Sort disk Sort mem_hit(%)                                                                                                                                                                 
----------- ---------- ---------------                                                                                                                                                                 
     599192          0             100                                                                                                                                                                 


'********LOGBUFFERHIT,SUGGESTION>90%********'                                                                                                                                                          
---------------------------------------------                                                                                                                                                          
********Log Buffer Hit,Suggestion>90%********                                                                                                                                                          


NAME                       GETS     MISSES IMMEDIATE_GETS IMMEDIATE_MISSES    Hit1(%)    Hit2(%)                                                                                                       
-------------------- ---------- ---------- -------------- ---------------- ---------- ----------                                                                                                       
redo copy                   128          0        5549463             2500          1 .954970881                                                                                                       
redo allocation          746646        189        5549188              687 .974686799 .987621343                                                                                                       


'********THISSORFTPARSE,SUGGESTION>90%********'                                                                                                                                                        
-----------------------------------------------                                                                                                                                                        
********This Sorft Parse,Suggestion>90%********                                                                                                                                                        


Parse Hard Parse Fail Parse Total Soft Parse Hit(%)                                                                                                                                                    
---------- ---------- ----------- -----------------                                                                                                                                                    
     13489        459      698023         .98001785                                                                                                                                                    


'********THISISENDOFCHECK********'                                                                                                                                                                     
-------------------------------------                                                                                                                                                                  
********This is End of Check ********