-
编辑 删除
俗人谈酒
喝酒主要是助兴，有酒就有气氛，无酒不成宴，家事、国事、天下事，往往需要酒来提提兴致。 国人和外国人喝酒不一样。无论是威士忌、白兰地，酒精含量大约都在三、四十度，而国人一般认为四十度以下的白酒是...
-
编辑 删除
Oracle Enqueue Name list(9.2.0.6)
ALL Oracle Enqueue ListEnqueue TypeNotesBL Buffer Cache Management CF Controlfile Transaction CI Cross-instance Call Invocation CU Bind Enqueue DF Datafile DL Direct Loader Index Creation DM Database ...
-
编辑 删除
Install Oracle In Linux 9.0
configure and Install Oracle in Linux?软件环境：RedHat9.0,内核2.4.20?????Oracle:? oracle9i,光盘：?????ship_9204_linux_disk1.cpio.gz，?????ship_9204_linux_disk2.cpio.gz，?????ship_9204_linux_disk3.cpio...
-
编辑 删除
使用ORACLE诊断事件:打开事件跟踪的方法
Oracle为RDBMS提供了多种的诊断工具，诊断事件(Event)是其中一种常用、好用的方法，它使DBA可以方便的转储数据库各种结构及跟踪特定事件的发生。使用这些事件也不是件很高深的学问，举例来说10046这个Event你也一定...
-
编辑 删除
Standby DB 增加数据文件
1.22 Standby DB关闭，1.23给PRIMARY DB增加了一个数据文件，结果在standby DB中发现错误。alter database register physical logfile 'D:FTPlogARC01493_001.Arc'There are 1 logfiles specified.ALTER DATABASE RE...
-
编辑 删除
Veritas Backup Script of Shell for RMAN
veritas Backup Script modify#bcpyrght#***************************************************************************#* $VRTScprght: Copyright 1993 - 2002 VERITAS Software Corporation, All Rights Reserved...
-
编辑 删除
How To Reduce the DB File Sequential Read Wait Event
How to reduce the DB File Sequential Read :)stripe the data across multiple disks?db file sequential read is due to INDEXED reads by the way -- it is single block IO, it is not the result of a full sc...
-
编辑 删除
exp big file over os
mknod exp_pipe pdd if=/u05/dbbackup/exp_pipe of=tvsn.dmp & exp oscar/dba@tns owner=tvsn file=/u05/dbbackup/exp_pipe direct=y
-
编辑 删除
转贴
from other site理财的路是一步一步的，给自己设定好目标，然后一步一步的往前走，达到了每个小的目标奖励自己奖励家人，理财其实就是做人，发现最优秀的自己，拥有最真心的朋友，背靠着最和谐的家庭，你就是世界上...
-
编辑 删除
Finding the source of enqueue waits
From OTNSystem wide, event based tuning using statspack or utlbstat/estat reports can give a useful overview of any potential bottlenecks in the database. The wait events are good place to start looki...
-
编辑 删除
配置ntp服务器
配置ntp服务器Introduction The Network Time Protocol (NTP) is a protocol used to help synchronize your Linux system's clock with an accurate time source. There are that allow the genera...
-
编辑 删除
如何知道HP-UX是32位还是64位
getconf KERNEL_BITS i.e.>getconf KERNEL_BITS 64
-
编辑 删除
如何指定Oracle instance在多instance db 环境
<htx678:9.2.0:rephd:/home/oracle>cat jumpto#! /bin/ksh#typeset -u x=$1## Edit SID list using /etc/oratab file entries#passedit=N#lowerx=`echo $x | tr '[A-Z]' '[a-z]'`sidlist=`grep -v '#' /etc/or...
-
编辑 删除
Managing Contention for Oracle Latches
From metalinkInternally, Oracle uses various types of structures, the access of which is controlled using a variety of mechanisms, including latches. In this article, Oracle expert Megh Thakkar discus...
-
编辑 删除
compress sh
COMPRE="/u03/dbbackup/PROD/export"; export COMPREif [ -f $COMPRE/* ]; then echo " " echo "${JOBNAME_SHORT}: Compressing export logs..." for FILE in $COMPRE/* do ls -l $FILE ARCNAME=`b...
-
编辑 删除
ORA-00600: [KGHSSKINS1]
HP-UX Itanium 10.2.0.2 & 10.2.0.3 Oracle DatabaseORA-00600: internal error code, arguments: [kghsskins1], [], [], [], [], [], [], []ISSUE CLARIFICATION====================ORA-00600 [kghsskins1] repo...
-
编辑 删除
Oracle 9i Materialized view
高机复制就是物化视图： 物化视图是包括一个查询结果的数据库对像，它是远程数据的的本地副本，或者用来生成基于数据表求和的汇总表。物化视图存储基于远程表的数据，也可以称为快照。 物化视图可以查询...
-
编辑 删除
DBA Checklist
For Oracle DBA Daily/Weekly/Monthly ChecklistA. Verify all instances are upMake sure the database is available. Log into each instance and run daily reports or test scripts. Some sites may wish t...
-
编辑 删除
Kill Session Not Release Locks
Alter system kill session ........Problem Description------------------- You have killed a session at the os level. Now, the session is showing "killed" in v$session but v$access is showing objects lo...
-
编辑 删除
global cache cr request
global cache cr request当一个进程访问需要一个或者多个块时，它会首先检查自己的CACHE是否存在该块，如果发现没有，就会先通过global cache赋予这些块共享访问的权限，然后再访问。假如，通过global cache 发现这...
