config.php

Love The Way You Lie 2023-10-18 21:07 20阅读 0赞

<?php  
$monitorsql=array(  
"product\_component\_version"=>"SELECT PRODUCT, VERSION FROM PRODUCT\_COMPONENT\_VERSION WHERE PRODUCT like '%Database%'",  
"tablespace"=>"select tablespace\_name,  
max\_gb,  
used\_gb,  
round(100 \* used\_gb / max\_gb) pct\_used,  
status,LOGGING,FORCE\_LOGGING,EXTENT\_MANAGEMENT,ALLOCATION\_TYPE  
from (  
select t.status status,t.LOGGING LOGGING,t.FORCE\_LOGGING FORCE\_LOGGING,t.EXTENT\_MANAGEMENT EXTENT\_MANAGEMENT,t.ALLOCATION\_TYPE ALLOCATION\_TYPE,a.tablespace\_name tablespace\_name,  
round((a.bytes\_alloc - nvl(b.bytes\_free, 0)) / power(2, 30),  
2) used\_gb,  
round(a.maxbytes / power(2, 30), 2) max\_gb  
from dba\_tablespaces t,(select f.tablespace\_name,  
sum(f.bytes) bytes\_alloc,  
sum(decode(f.autoextensible,  
'YES',  
f.maxbytes,  
'NO',  
f.bytes)) maxbytes  
from dba\_data\_files f  
group by tablespace\_name) a,  
(select f.tablespace\_name, sum(f.bytes) bytes\_free  
from dba\_free\_space f  
group by tablespace\_name) b  
where a.tablespace\_name = b.tablespace\_name(+) and a.tablespace\_name = t.tablespace\_name  
union all  
select t.status status,t.LOGGING LOGGING,t.FORCE\_LOGGING FORCE\_LOGGING,t.EXTENT\_MANAGEMENT EXTENT\_MANAGEMENT,t.ALLOCATION\_TYPE ALLOCATION\_TYPE,h.tablespace\_name tablespace\_name,  
round(sum(nvl(p.bytes\_used, 0)) / power(2, 30), 2) used\_gb,  
round(sum(decode(f.autoextensible,  
'YES',  
f.maxbytes,  
'NO',  
f.bytes)) / power(2, 30),  
2) max\_gb  
from dba\_tablespaces t,v\\$temp\_space\_header h, v\\$temp\_extent\_pool p, dba\_temp\_files f  
where p.file\_id(+) = h.file\_id  
and p.tablespace\_name(+) = h.tablespace\_name  
and f.file\_id = h.file\_id  
and f.tablespace\_name = h.tablespace\_name  
and t.tablespace\_name = h.tablespace\_name  
group by h.tablespace\_name,t.status,t.LOGGING,t.FORCE\_LOGGING,t.EXTENT\_MANAGEMENT,t.ALLOCATION\_TYPE  
)  
order by 4",  
"datafiles"=>"SELECT FILE\_NAME,FILE\_ID,TABLESPACE\_NAME,BYTES,STATUS,AUTOEXTENSIBLE,MAXBYTES,INCREMENT\_BY,ONLINE\_STATUS FROM dba\_data\_files");

//foreach($age as $x=>$x\_value)  
//\{  
//echo "Key=" . $x . ", Value=" . $x\_value;  
//echo "<br>";  
//\}  
?>

config.php

发表评论取消回复

还没有评论，来说两句吧...

相关阅读