-
编辑 删除
常用sql
#查看对像创建语句 (适合于 'VIEW','CLUSTER','INDEX')set long 1000000;select dbms_metadata.get_ddl('TABLE','T_SM_COMMU_COMMU_USER','WSD') from dual;#获得动态视图的定义 select view_definition from ...
-
编辑 删除
分区操作常用sql
加list分区alter table wsd.T_SM_COMMU_COMMU_USER add partition P_201011 values(201011) tablespace WSDH03M201011;
-
编辑 删除
How to Get a 10046 trace for a Parallel Query [ID 1102801.1]
How to Get a 10046 trace for a Parallel Query
-
编辑 删除
Master Note Parallel Execution Wait Events [ID 1097154.1]
Parallel Execution Wait Events list
-
编辑 删除
* Recommended Method for Obtaining a Formatted Explain Plan [ID 235530.1]
怎样得到格式较好的执行计划.
-
编辑 删除
Lack of interest sinking Oracle's Raw Iron?
http://news.cnet.com/2100-1001_3-235999.html原来extradata以前的名字叫'生铁', 早于1998年, Oracle就公共宣布要研发一体机了, 主要思想是将软硬件一起打包,屏蔽掉普通用户对存储,服务器,操作系统,Oracle软件的认...
-
编辑 删除
Raw Device vs File System
原文 http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:79311076314021, 在文中,TOM详细解释了 filesystem与raw device的区别及我们常用的四个存储方式的区别:1) Cooked" operating syst...
-
编辑 删除
关于filesystem与ASM的性能对比
http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2109833600346625821如果对filesystem与ASM的区别不太明白，这个贴子值得反复看，老汤简要总结到下面这个贴子由一个用户的两个问题引出:(1), ...
-
编辑 删除
kudzu命令查看及设置网卡等硬件信息
http://it.kswchina.com/Linux/zh/608103.htmlkudzu 是Linux下检测硬件变化的命令，这个命令可以用于检查系统中网卡的型号等信息： kudzu(1) NAME kudzu - detects and configures new and/or changed hardware on a system SYNOPSIS kudzu DESCRIPTION kudzu detects and configures new and/or changed hardware on a system. When started, kudzu detects the current hardware, and checks it against a database stored in /etc/sysconfig/hwconf, if one exists. It then determines if any h
-
编辑 删除
[2010.1.29]exp,imp引发的create tablespace问题
发现alert log中有创建tablespace的语句,把db中所有表空间都重建一次,当然,由于db中已经存在同名表空间,语句都出错了, 显然不是执行自定义脚本形成的语句Fri Jan 29 18:41:28 2010CREATE TABLESPACE "SYSAUX" BLOCKSIZE 32768 DATAFILE '+DATA1/isddw/datafile/sysaux.1757.705671987' SIZE 5294M AUTOEXTEND ON NEXT 10485760 MAXSIZE 131071M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTOORA-1543 signalled during: CREATE TABLESPACE "SYSAUX" BLOCKSIZE 32768 DATAFIL
-
编辑 删除
snapshot 测试
@A机create table test1 as select OBJECT_NAME,OBJECT_ID,OBJECT_TYPE,status,CREATED from user_objects;delete from test1 where object_id is null;commit;alter table test1 add constraint pk_OBJECT_ID primary key (OBJECT_ID) using index;Create snapshot log on test1;@B机create database link lnk_dwisd connect to etl identified by Loadlif5 using 'isddw';Create snapshot sn_test1 as Select * From test1@lnk_dwisd;Alter snapshot sn_test1 refresh fast Start with sysdate+1/1440 next sysdate+1/144;SQL> set s
-
编辑 删除
ora-15064会不会跟没有安装asmlib有关?
SQL> ALTER DISKGROUP ALL MOUNTNOTE: cache registered group DATA number=1 incarn=0x41fce947NOTE: cache began mount (not first) of group DATA number=1 incarn=0x41fce947NOTE: cache registered group HIST number=2 incarn=0x41fce948NOTE: cache began mount (not first) of group HIST number=2 incarn=0x41fce948NOTE: cache registered group NL02 number=3 incarn=0x41fce949NOTE: cache began mount (not first) of group NL02 number=3 incarn=0x41fce949NOTE: cache registered group SYSD number=4 incarn=0x41fce94
-
编辑 删除
批量检查主机是否可达的ping脚本.
注意,dwpri/dwstb/dwisd/dwied/bmdmk/dwbi/bistb对应的ip要放到hosts中脚本发两个包去探测，基本上可以准确知道机器是否可达.#more ping.sh#!/bin/shcase "$1" indwpri|dwstb|dwisd|dwied|bmdmk|dwbi|bistb)#send 2 packets to pingif [ $1 = "dwpri" -o $1 = "dwstb" ];then nodeNUM=24elif [ $1 = "dwisd" -o $1 = "dwied" -o $1 = "bmdmk" ];then nodeNUM=8elif [ $1 = "dwbi" -o $1 = "bistb" ];then nodeNUM=4fipkgCNT=2while [ $nodeNUM
