ITPub博客

rem 查看cpu wmic cpu list briefrem 查看物理内存wmic memphysical list briefrem 查看逻辑内存wmic memlogical list briefrem 查看缓存内存wmic memcache list briefrem 查看虚拟内存wmic pagefile list briefrem ...

最近在监控服务器上新安装了一个oracle 10.2.0.4,被安全科扫描出漏洞,详细信息如下:--------------------------------------10.0.3.23 漏洞编号： 3661 CVE号： CVE-2009-0688 CVE-2009-2404 CVE-2010-0086 CVE-201...

简单总结如下:1) 启动到mount2) 执行Alter database backup controlfile to trace;3) 找到第2步生成的trace文件,并作相应修改. 只保留创建语句4) shutdown并启动到nomount, 执行创建语句5) 启动到mount6) 执行下面脚...

近期几次停一个库迁文件时, 发现srvctl stop instance xxx 停库后, 迁完文件在open时报SQL> alter database open;alter database open*ERROR at line 1:ORA-01122: database file 113 failed verification checkORA-...

Oracle在北京,西安,深圳三地组织'Oracle 数据中心优化高峰会', 跟预料中一样, 主要还是推它的exadata, 宣讲理念,Oracle的优势,发展趋势,并对这两个东西是什么,及如何整合起来作了介绍, 并有数据服务商的真实案例讲解...

此为学习笔记, 目前正在做一个数据仓库的数据迁移工作, 从一个'故障'dg(normal redundancy中其中一个failgroup中的所有disk都offline, 由于asm的bug 无法解决)迁到另一个没问题的dg上, 每个文件都有128GB (db_block_...

#查看对像创建语句 (适合于 'VIEW','CLUSTER','INDEX')set long 1000000;select dbms_metadata.get_ddl('TABLE','T_SM_COMMU_COMMU_USER','WSD') from dual;#获得动态视图的定义 select view_definition from ...

加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

Parallel Execution Wait Events list

怎样得到格式较好的执行计划.

http://news.cnet.com/2100-1001_3-235999.html原来extradata以前的名字叫'生铁', 早于1998年, Oracle就公共宣布要研发一体机了, 主要思想是将软硬件一起打包,屏蔽掉普通用户对存储,服务器,操作系统,Oracle软件的认...

原文 http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:79311076314021, 在文中,TOM详细解释了 filesystem与raw device的区别及我们常用的四个存储方式的区别:1)  Cooked" operating syst...

http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2109833600346625821如果对filesystem与ASM的区别不太明白，这个贴子值得反复看，老汤简要总结到下面这个贴子由一个用户的两个问题引出:(1), ...

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

发现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

@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

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

注意,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

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=137482.1PURPOSE This document explains the usage of Oracle Managed Files (OMF files) under different configurations. SCOPE & APPLICATION Users of Oracle Managed Files.OMF (Oracle Managed Files) Usage for Datafiles:===============================================You decide to manage your datafiles with OMF.*** **************************************************** Homogeneous Test : tablespace with OMF files only *** **