-
编辑 删除
getconf in HP-UX
getconf usage in hp-ux, just a summary[@more@]getconf MACHINE_SERIAL获取主机设备序列号，这个序列号可用于HP的800报障。 getconf PAGE_SIZE每个内存页的大小。用kmeminfo或者ps -lfp 看内存显示的结果是多少个内存页，要乘以这个每个内存页的大小才得到每个进程的占用内存。 getconf KERNEL_BITS查看操作系统是32位还是64位，在安装oracle前必须弄清楚os版本，安装对应版本的oracle。 getconf MACHINE_MODEL查看主机的具体型号。如rp8440，N4000-55 getconf HW_CPU_SUPP_BITS硬件cpu支持多少位。如64位的cpu支持64位的os和32位的os。
-
编辑 删除
Linux Env Oracle auto start when OS start
When We configure an Oracle instance, how to start it automatically when the os restart(1)vi /etc/oratab orcl:/usr/local/oracle/product/9.2.0:Y(2)vi /home/oracle/.bash_profile ORACLE_SID=orcl ...
-
编辑 删除
sysadmin day
http://www.sysadminday.com/July 25th, 2008 (Last Friday Of July)9th AnnualSystem Administrator Appreciation DayIf you can read this, thank your sysadminA sysadmin unpacked the server for this websi...
-
编辑 删除
用trigger追查用户登陆错误信息
create or replace trigger log_errors AFTER SERVERERROR ON DATABASE BEGIN IF (IS_SERVERERROR (1017)) THEN insert into gdba_yanggua.logon_errors (Logon_Date_Time, Usr, OS_Usr, Machine, Process, Program,...
-
编辑 删除
install oracle with rsp file
respond file for install oracle automatically 通过Oracle通用安装工具（Oracle Universal Installer，以下简称为OUI）和安装应答文件（response file，以下简称为应答文件），可以完成非交互方式下的Oracle9i产品...
-
编辑 删除
Trigger 2-Before versus After
The insert of a single row has three stages. Figure 6-1 illustrates each stage. There are two stages in which you can inject your PL/SQL code. The middle stage is the Oracle constraint enforcement. Th...
-
编辑 删除
"latch free" Reference Note
This is a reference note for the wait event "latch free" which includes the following subsections: Brief definition Individual wait details (eg: For waits seen in <View:V$SESSION_WAIT>) Systemwide wai...
-
编辑 删除
How to find a user who is locking the rows
PURPOSE-------The following programs will attempt to pinpoint all the locked rows of a table and tell who has the lock on each of them. SCOPE & APPLICATION------------------- So far this is the only ...
-
编辑 删除
v$waitstat
CLASS COUNT TIMEdata block 3096911 122276sort block 0 0save undo block 0 0segment header 21 7save undo header 0 0free list 0 0extent map 0 0bitmap block 0 0bitmap index block 0 0unused 0 0system undo ...
-
编辑 删除
Oracle Wait Interface
From Www.oracle.comOracle Wait EventsDownload the sample code accompanying this article (Listings 1-10) The ability to analyze and correct Oracle Database physical read wait events is critical in any ...
-
编辑 删除
部署streams时的patch推荐列表
Recommended Patch for Streams Doc ID: Note:437838.1 PURPOSE-------Streams can be used for such diverse tasks as data replication,data warehousing, database migration between hardwa...
-
编辑 删除
Check Scope for Oracle dba when got an old db
When I got an new Oracle db, I will do following1. Operation System passwd, Administrator/root/oraclecat /etc/passwdCheck users in Winnt2.df -k3.echo $ORACLE_SID,$ORACLE_HOME,$ORACLE_BASEcat $ORACLE_H...
-
编辑 删除
COMPILATION OF PACKAGE IS HANGING ON LIBRARY CACHE LOCK AND LIBRARY CACHE
TIP: Click help for a detailed explanation of this page.BookmarkGo to End=========== Disclaimer: =========== This script is provided for educational purposes only. It is NOT supported by Oracle...
-
编辑 删除
From a msg
未曾清贫难成人，不经打击老天真。自古英雄出炼狱，从来富贵入凡尘。 醉生梦死谁成器，拓马长枪定乾坤。 挥军千里山河在，立名扬威传后人。
-
编辑 删除
TWO_TASK LOCAL ORACLE_SID用法
在UNIX下他们是有先后顺序的，1. TWO_TASK2. LOCAL3. ORACLE_SIDTWO_TASK 跟 LOCAL 都是 Oracle Net 的CONNECT STRING, 而ORACLE_SID是连接到本地数据库赪INDOWS 系统, 是沒有 TWO_TASK 的环境变量, 所以只有 2 和 3...
-
编辑 删除
三十五岁前成功法则
第一章:一个目标 一艘没有航行目标的船，任何方向的风都是逆风 1、你为什么是穷人，第一点就是你没有立下成为富人的目标 2、你的人生核心目标是什么？ 杰出人士与平庸之辈的根本差别并不是天赋、机遇，而在于有无目...
-
编辑 删除
"library cache pin" Reference Note
Oracle Library Cache Pin,Definition:Versions:7.0 - 9.2 Documentation:None Library cache pins are used to manage library cache concurrency. Pinning an object causes the heaps to be loaded into memory (...
