今日学Oracle心得

Monitor the redo log file configuration with

V$logfile

V$log

V$log_history

ALTER SYSTEM ARCHIVE LOG ALL TO <log_archive_dest> //归档设置

V$archive_dest

V$archived_log

v$archive_processes

show paramete share

select *from v$sgastat;

 cursor_sharing

v$sysstat

select * from v$sgsstat where name like '%parse count%';