> 文章列表 / Page 324

该脚本用以汇总表空间使用情况报告: 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...

以下脚本可以用于收集数据库安全风险评估信息: 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'...

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...

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...

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

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队 服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com SQL> select count(*) from WWork; COUNT(*) ---------- 116114 select coun...

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 ---------------------------...

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...

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('&...

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...