Stduying on Oracle select * from v$sgainfo; desc v$sgainfo; select name, bytes/1024/1024 as Mbyte from v$sgainfo; show parameter sga_target; show parameter log_buffer; desc x$ksmfsv col ksmfsnam for a20 col ksmfstyp for a20 select ksmfsnam, ksmfstyp, ksmfssiz, ksmfsadr from x$ksmfsv where ksmfsnam LIKE 'kcrf%'; select * from hr.employees; col sql for a60 SELECT SUBSTR(sql_text, 1, 60) sql, count(*) copies FROM v$s.. 더보기 이전 1 ··· 416 417 418 419 420 421 422 ··· 595 다음