ITPub博客

真實環境下的archivelog delete腳本：PrimaryDB:crontab -l00 12 * * * sh /data1/fullbackup/rman_del/rman_del.sh          ------------------此時DB負載相對較...

How to Configure the DNS Server for SCAN VIP on Linux for 11gR2 GI installation [ID 1107295.1] ---------------------------------------------------------------------------------------------------------...

默认情况下，SQL Server 保存 7 个 ErrorLog 文件，名为：  http://www.cnblogs.com/blosaa/archive/2011/10/11/2206904.htmlErrorLog ErrorLog.1 ErrorLog.2 ErrorLog.3 ErrorLog.4 ErrorLog.5 E...

How to Disable Automatic Statistics Collection in 11g [ID 1056968.1] Modified 31-MAR-2011     Type HOWTO     Status PUBLISHED A...

The OSDBA group (typically, dba)You must create this group the first time you install Oracle Database software on the system. This group identifies operating system user accounts that have database a...

Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid Infrastructure [ID 1096952.1] Modified 27-OCT-2011     Type ANNOUNCEMENT&nbsp...

Applies to:Oracle Net Services - Version: 8.1.7.4.0 to 11.1.0.6.0 - Release: 8.1.7 to 11.1Information in this document applies to any platform.Checked for relevance on 12-DEC-2007PurposeThe purpose o...

Enhanced Tablespace Point-In-Time Recovery (TSPITR) Tablespace point-in-time recovery (TSPITR) is enhanced as follows:You now have the ability to recover a dropped tablespace.TSPITR can be repea...

今天接到客戶需求，要將當前的WebServer遷移到虛擬機中、配合遷移DB,第一次面對MYSQL還是有點。。。(沒有使用mysqldump、直接copy ...\data目錄)環境：WIN2003+MYSQL4.0.18簡述DB遷移流程：1、DBA首要任務當然是b...

1 啟用 teamcat <<EOF>>/etc/modprobe.confalias bond0 bondingEOF2 設置 網卡eth0為team模式cat <<EOF>/etc/sysconfig/network-scripts/ifcfg-eth0BOOTPROTO=noneDEVICE=eth0ONBOOT=yesTYPE=EthernetMASTER=bond0S...

TOP 子句TOP 子句用于规定要返回的记录的数目。对于拥有数千条记录的大型表来说，TOP 子句是非常有用的。注释：并非所有的数据库系统都支持 TOP 子句。SQL Server 的语法：SELECT TOP number|percent column_na...

             介紹一個小工具：psftp.exe http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

SQL>ANALYZE TABLE TODAY.YGZHOU COMPUTE STATISTICS;ORA-38029:object statistics are locked要运行一个dbms包才能解开SQL>begin           2  dbms_sta...

      折騰了兩天的三節點RAC更換網卡，終于OK了！實驗環境及過程：1、模擬節點RAC02網卡eth0(PBULIC VIP)壞掉。2、添加網卡、重新配置vip；（注：所有的IP+GATEWAY均無變化）3、異常...

http://space.itpub.net/trackback.php?code=N1mL0gUog0K4xHWUm7dUhjgOJ8A%2BUFQJ8EMKlWY

ORA-00845: MEMORY_TARGET not supported on this systemWARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm file system to be mounted for at least 314572800 byte...

1、Testing a system change on a production system will impact the system's throughput because SQL Performance Analyzer must execute the SQL statements that you are testing. 2、

1、Oracle ASM is Oracle's recommended storage management solution that provides an alternative to conventional volume managers, file systems, and raw devices.2、You can add or remove disks f...

http://blog.csdn.net/tianlesoftware/article/details/6728885一. 概述在之前的文章：       RAC 的一些概念性和原理性的知识       http://blo...

 已經建立的index 是否有效的工作，取決于在執行SQL語句的過程，由ORACLE自己選擇是否使用index，這不由用戶決定（非強制）、但是這又是DBA想了解的。         V$OBJ...