⌘KCtrl+K 快速搜索

> 文章列表 / Page 324

2009-06-14

Script:Tablespace Report

该脚本用以汇总表空间使用情况报告: REM tablespace report set linesize 200 select a.tablespace_name, round(a.bytes_alloc / 1024 / 1024) megs_alloc, round(nvl(b.bytes_free, 0) / 1024 / 1024) megs_free, round((a.bytes_al...
#POST 13 MIN READ
2009-06-11

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

以下脚本可以用于收集数据库安全风险评估信息: REM list database vulnerability assessment info set escape on; set linesize 140 ; spool db_vulnerability_assessment.log Select role from dba_roles r where role not in ('CONNECT'...
#POST 21 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 [me...
#POST 6 MIN READ
2009-06-01

How does cpu_count parameter affect instance?

Parameter cpu_count is determined by Oracle Software when instance started, But we can set it manually. This parameter can affect lots of hidden initialization parameters,see: SQL> select * from v$ver...
#POST 11 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...
#POST 12 MIN READ
2009-05-31

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

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队 服务热线 : 13764045638 QQ号:47079569 邮箱:service@parnassusdata.com SQL> select count(*) from WWork; COUNT(*) ---------- 116114 select coun...
#POST 24 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%' parent_name location ---------------------------...
#POST 23 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 is to show the naming conventions. [K]ernel Layer [2]-Phase Commit [G]lobal [T]ransaction [E]ntry...
#POST 19 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# , trunc(to_number('&...
#POST 3 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 enabled, prints out argument...
#POST 5 MIN READ