Oracle数据库:
获取版本信息:
SELECT BANNER FROM V$VERSION WHERE BANNER LIKE '%Oracle%'
获取主机名,实例名,实例启动时长:
SELECT host_name, instance_name,startup_time,logins,archiver, log_switch_wait from v$instance
获取表空间
SELECT d.status "Status", d.tablespace_name "Name", d.contents "Type", d.extent_management "Extent Management",
TO_CHAR(NVL(a.bytes / 1024 / 1024, 0),'99,999,990.900') "Size (M)",
TO_CHAR(NVL(a.bytes - NVL(f.bytes, 0), 0)/1024/1024,'99999999.999') ||'/'||TO_CHAR(NVL(a.bytes/1024/1024, 0), '99999999.999') "Used (M)",
TO_CHAR(NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes * 100, 0), '990.00') "Used %"
FROM sys.dba_tablespaces d, (select tablespace_name, sum(bytes) bytes from dba_data_files group by tablespace_name) a,
(select tablespace_name, sum(bytes) bytes from dba_free_space group by tablespace_name) f
WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = f.tablespace_name(+)
AND d.tablespace_name like '表空间名字'
列出表空间文件
SELECT d.file_name, v.status FROM sys.dba_data_files d, sys.v_$datafile v WHERE d.tablespace_name = '表空间名字' AND d.file_name = v.name ORDER BY 1
××××××××××××××××××××××××××××××××××××××××××××××××××××××××××
MySQL数据库:
获取版本:
select @@version_comment,@@version from dual
select concat(@@version_comment , ' ' , @@version) from dual
获取启动时长:
show status like 'Uptime'
获取主机名,数据文件路径,Innodb数据文件名,Innodb默认目录:
select @@hostname,@@datadir,@@innodb_data_file_path,@@innodb_data_home_dir,@@innodb_log_file_size/1024/1024 from dual
如何远程获取MySQL相关数据文件,日志文件的大小等信息,我还没有找到方法,有达人知道的话,请不吝赐教。