-
编辑 删除
linux_db_script.txt
DT2PRDB<umlaut*/home/oracle/dba/run>$cat shutdown_db.sh #!/bin/bash#shutdown_db.shORACLE_HOME=/u01/product/oracle;export ORACLE_HOMEORACLE_SID=umlaut; export ORACLE_SID/u01/product/oracle/bin/sqlp...
-
编辑 删除
windows_db_script
primary db:autocheck.batset ORACLE_SID=dt2esdsqlplus "sys/'sys' as sysdba" @d:\auto\tbs.sqlexittbs.sqlset linesize 131col object format a40col type format a10col tsname format a10select a.owner|...
-
编辑 删除
查找耗費資源的SQL
SELECT ADDRESS, substr(SQL_TEXT,1,20) Text, buffer_gets, executions, buffer_gets/executions AVG FROM v$sqlarea WHERE executions>0 AND buffer_gets > 100000 ORDER BY 5;...
-
编辑 删除
IO_TUNNING
1. 求數據文件的I/O分布 SELECT df.name, phyrds, phywrts, ...
-
编辑 删除
SGA_TUNNING
1. 監控SGA的命中率 (data buffer)SELECT a.VALUE + b.VALUE "logical_reads", c.VALUE "phys_reads", &n...
-
编辑 删除
SGA_TUNNING
1. 監控SGA的命中率 (data buffer)SELECT a.VALUE + b.VALUE "logical_reads", c.VALUE "phys_reads", &n...
-
编辑 删除
PGA_TUNNING
1. 查看PGA的使用情況 SELECT a.name, SUM (b.VALUE) FROM v$statname a, v$sesstat b WHERE a.statistic# = b.statistic# AND a.name LI...
-
编辑 删除
PGA_TUNNING
1. 查看PGA的使用情況 SELECT a.name, SUM (b.VALUE) FROM v$statname a, v$sesstat b WHERE a.statistic# = b.statistic# AND a.name LI...
-
编辑 删除
SQL_TUNNING
1. 查找I/O,SWAP 嚴重時候的SQL語句 SELECT address, hash_value, ...
-
编辑 删除
fetch comment lob
如何查詢數據字符集.txtselect * From v$nls_parameters;批量獲取表的DDL語句腳本.txtset feedback offset pagesize 0set heading offset verify offset linesize 200set serveroutput on size 1000000set trimsp...
-
编辑 删除
oracle8i&9i standby 文件同步命令
oracle8i&9i standby 文件同步命令.txtalter database create datafile '/data/umlaut/log_data42.dbf' as '/data/umlaut/log_data42.dbf' size 2000m;alter database create datafile '/data/umlaut/temp04.dbf' ...
-
编辑 删除
flashback
alter table xxx enable row movement;flashback table xxx to timestamp to_timestamp('2010-07-07 11:40:00','YYYY-MM-DD HH24:MI:SS');FLASHBACK TABLE EMP TO SCN 101942356712: SELECT * FROM tableName AS ...
-
编辑 删除
exp&expdb example
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8export NLS_LANG=AMERICAN_AMERICA.AL32UTF8expdp system/'system' directory=EXPDP_DUMP_DIR dumpfile=dfms20110225.dmp schemas=dfms logfile=dfms20110225.logimpdp s...
-
编辑 删除
logical_standby_managed
1)DML SQL> alter database stop logical standby apply;Database altered.SQL> exec dbms_logstdby.skip('DML','DFMS','WIP_D_SHIP_BIN_DETAIL');PL/SQL procedure successfully completed.SQL> alter database s...
-
编辑 删除
dbms_stats_all
#!/bin/bashexport ORACLE_SID=umlautexport ORACLE_HOME=/u01/product/oracleexport PATH=$ORACLE_HOME/bin:$PATH$ORACLE_HOME/bin/sqlplus ' / as sysdba'<<!set serveroutput on;set time on;spool /data/temp/g...
-
编辑 删除
表與表空間建置規則
大型資料庫BASE_DATA ( < 5 萬 或 < 500 筆/月 或 < 5000 筆/年) LOG_DATA ( < 500 萬 或 < 2000 筆/天 或 < 50000&nb...
-
编辑 删除
awr script
cat /data/run/autoawr#!/bin/shcd /data/logbakrm *.htmlORACLE_HOME=/u01/product/oracle;export ORACLE_HOMEORACLE_SID=wmb2bprd2;export ORACLE_SID$ORACLE_HOME/bin/sqlplus /nolog<<!connect / as sysdba;...
-
编辑 删除
startup_shutdown.sh
#!/bin/sh#startup_db.shORACLE_HOME=/u01/product/oracle;export ORACLE_HOMEORACLE_SID=SID; export ORACLE_SIDsu oracle -c "/u01/product/oracle/bin/sqlplus /nolog <<EOFconnect / as sysdbastartupexitEOF"...
