>ASKMACLEAN_

> 文章列表 / Page 326

2009-06-12

Script:收集数据库安全风险评估信息

以下脚本可以用于收集数据库安全风险评估信息: REM list database vulnerability assessment info set escape on; set linesize 140 ; spool db_vulnerability_assessment.log Select role from dba_roles…
#POST 6 MIN READ
2009-06-03

PMON: TERMINATING INSTANCE DUE TO ERROR 600 on 8i

Alert logfile reported as below: ********************* Wed May 27 13:11:47 2009 Errors in file /u01/app/oracle/admin/proa021/udump/proa021_ora_9533.trc: ORA-07445: exception encountered: core dump…
#POST 1 MIN READ
2009-06-01

ORA-00600 [kddummy_blkchk]错误一例

一套HP-UX Itanium平台上的10.2.0.2，实例意外终止，维护人员尝试重启实例，在数据库打开后数秒，smon后台进程报ORA-00600: internal error code, arguments: [kddummy_blkchk], [120], [856039], [6110]错误，实例再次意外终止。 部分告警日志如下: Corrupt Block Found TSN = 50, TSNAME = TS_DNI_AAL_12…
#POST 4 MIN READ
2009-06-01

Oracle内部错误:ORA-00600[25012]一例

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队 服务热线 ： 13764045638   QQ号:47079569    邮箱：[email protected]     SQL> select count(*) from WWork; COUNT(*) ---------- 116114 select count(*)…
#POST 7 MIN READ
2009-05-20

Most of library cache latches have gone in 11g

10g SELECT t1.ksllasnam "parent_name", t2.ksllwnam "location" FROM x$ksllw t2, x$kslwsc t1 WHERE t2.indx = t1.indx AND ksllasnam like '%library cache%'…
#POST 5 MIN READ
2009-05-16

[Repost]List of X$ Tables

This is a summary list of X$ Table Definitions - Last revision was 7.3.2 The main purpose of this note…
#POST 9 MIN READ
2009-05-09

Script:Translate RDBA relative data block address

Script:Translate RDBA relative data block address   -- scripts/admin/rdba/rdba_to_file_block.sql select trunc( to_number('&rdba','XXXXXXXX')             / power(2,22) ) as rfile#      ,…
#POST 1 MIN READ
2009-05-07

Trace obtained enqueue information by set event 10704

Oracle事件10704可以帮助我们了解队列Enqueue的使用情况，使用方法如下: [oracle@rh2 bdump]$ oerr ora 10704 10704, 00000, "Print out information about what enqueues are being obtained" // *Cause: When…
#POST 2 MIN READ
2009-04-13

脚本:格式化的V$SQL_SHARED_CURSOR报告

The function generates a summary report of the v$sql_shared_cursor view and additional diagnostic information depending on the reason code. Counts…
#POST 1 MIN READ