pizi110的专栏

SELECT ROWNUM top, t.* FROM (SELECT x.CPU_TIME/x.executions per_cpu, x.hash_value, x.sql_text FROM v$sqlarea x WHERE x.executions>0 AND x.parsing_user_id <>0 ORDER BY x.CPU_TIME/x.ex...

可用户11.2.0.4静默安装1：配置响应文件响应文件模板/software/database/response/db_install.rspvi /software/database/response/install.rsporacle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_sc...

#!/bin/shsource /home/oracle/.bash_profilerman target sys/oracle msglog='/tmp/full.log' append <<EOFrun {allocate channel ch1 device type disk;allocate channel ch2 device type disk;allocat...

#!/bin/bash# tablespace usagep checksource ~/.bash_profilefunction check {sqlplus -S "/ as sysdba" << EOFset linesize 200set pagesize 200spool /tmp/ora_tablespace.txtselect a.tablespace...

#!/bin/bashsource /home/oracle/.bash_profilerman target / msglog=/data/delete_arch.log append << EOFrun { delete noprompt archivelog until time 'sysdate-7';}exit;EOF

在RMAN备份的时候都要先切换归档3次才能够将redo log里面的内容备份出来，在做expdp之前也需要做切换归档的操作么，如果不做归档切换，能直接备份出在redolog中的内容吗，谢谢！...