25、请选择两项。A) SELECT INTERVAL '1' DAY + INTERVAL '1' MONTH FROM DUAL; .C) SELECT INTERVAL '1' DAY - INTERVAL '1' MINUTE FROM DUAL;E) SELECT INTERVAL '1' DAY - SYSDATE FROM DUAL;【阅读全文】
select * from v$log; select * from v$logfile; alter system switch logfile; select * from v$log_history; select dbid,name,created,log_mode from v$database; select recid,stamp,thread#,sequence#,name from v$archived_log; alter database add logfile group 1...【阅读全文】
把语句提取后,加入些提示,让解析器重新执行SELECT /*+ gather_plan_statistics test111 */ ...执行2分钟后 Ctrl +C 中断 ##获取SQL_IDset linesize 200 pagesize 100select sql_id,sql_text from v$sqlarea where sql_text like '%test111%' and sql_text not like '%sqlarea%'; ##打印执...【阅读全文】