select 'V$PARAMETRER' "View name",name,
to_number(value,'9999999') "Value"
from v$parameter
where name='log_buffer'
UNION
select 'V$SGASTAT' "View name", name,bytes
from v$sgastat
where name='log_buffer';
to_number(value,'9999999') "Value"
from v$parameter
where name='log_buffer'
UNION
select 'V$SGASTAT' "View name", name,bytes
from v$sgastat
where name='log_buffer';
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7232789/viewspace-231076/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7232789/viewspace-231076/