-
编辑 删除
用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产品...
-
编辑 删除
"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...
-
编辑 删除
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...
-
编辑 删除
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...
-
编辑 删除
"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 (...
