查询Oracle资源使用情况

约定不等于承诺〃 2022-07-12 09:00 157阅读 0赞

SELECT trim(NAME) ||'            '|| VALUE FROM v$parameter  
WHERE NAME IN ('sga\_max\_size','db\_cache\_size','shared\_pool\_size',  
'shared\_pool\_reserved\_size','large\_pool\_size','java\_pool\_size',  
'db\_block\_size','db\_block\_buffers','log\_buffer','sort\_area\_size',  
'sort\_area\_retained\_size','hash\_area\_size','sessions','open\_cursors')  
ORDER BY NAME;  
  
  
  
TRIM(NAME)||''||VALUE  
\--------------------------------------------------------------------------------  
db\_block\_buffers                        0                        0            
db\_block\_size                               8192                           8192         
db\_cache\_size                                   2,281,701,376                 8,589,934,592   
hash\_area\_size                                4194304                       131072       
java\_pool\_size                                  33,554,432                   50,331,648     
large\_pool\_size                         0                                   0            
log\_buffer                                      14,302,208                   14,469,120     
open\_cursors                              800                               800          
sessions                                  96                               400          
sga\_max\_size                                    4,613,734,400                 13,304,332,288  
shared\_pool\_reserved\_size               227,143,581                232,364,441    
shared\_pool\_size                        2,281,701,376               4,647,288,832             
sort\_area\_retained\_size                 0                        0            
sort\_area\_size                                  2,097,152                  65,536        
                                                                    
![0_1273627069ccaV.gif][]

[0_1273627069ccaV.gif]: /images/20220710/e5842697745349f98b6115e50837bb56.png