SQL> desc dba_users 名前 NULL? 型 ------------------------------------------------------------------------------- USERNAME NOT NULL VARCHAR2(30) USER_ID NOT NULL NUMBER PASSWORD VARCHAR2(30) ACCOUNT_STATUS NOT NULL VARCHAR2(32) LOCK_DATE D…

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 …