参考:http://topic.csdn.net/t/20050203/13/3773134.html
conn @32 as sysdba;
column file_name2010 new_value fname2010
select 'D:\archivecheck\db_check_' || to_char(sysdate,'yyyy-mm-dd_hh24-mi-ss') || '_log.txt'
file_name2010 from dual;
spool &fname2010
select to_char(sysdate,'yyyy-mm-dd_hh24-mi-ss') time from dual;
select count(*) session_num from v$session;
select count(*) process_num from v$process;
spool off
exit
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7633405/viewspace-625996/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7633405/viewspace-625996/