2009-06-21から1日間の記事一覧
select name,value from v$system_parameter where name like 'spfile'
select * from nls_session_parameters;
SQL> select * from v$sgainfo;NAME BYTES RES - Fixed SGA Size 1332892 No Redo Buffers 6340608 No Buffer Cache Size 41943040 Yes Shared Pool Size 146800640 Yes Large Pool Size 25165824 Yes Java Pool Size 12582912 Yes Streams Pool Size 0 Yes …