Maclean’s Oracle Database Tech Blog Archives

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 [memset()+116] [SIGSEGV] [Address not mapped to object] [0] [] [] From Trace file ******************** Dump file /u01/app/oracle/admin/proa021/udump/proa021_ora_9533.trc Oracle8i Enterprise Edition Release 8.1.7.4.0 – Production With the Partitioning option JServer Release 8.1.7.4.0 – Production ORACLE_HOME =…

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$version; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bi PL/SQL Release 10.2.0.4.0 – Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 -…

一套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 RFN = 120, BLK = 849708, RDBA = 504166188 OBJN = 701796, OBJD = 701796, OBJECT = MAP_WOL_SILJUK, SUBOBJECT = SEGMENT OWNER = DBOWN, SEGMENT TYPE = Table Segment Corrupt Block Found TSN = 50,…

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复! 诗檀软件专业数据库修复团队 服务热线 ： 13764045638   QQ号:47079569    邮箱：[email protected]     SQL> select count(*) from WWork; COUNT(*) ———- 116114 select count(*) from WWork where Work_WorkID = 100; select count(*) from WWork where Work_WorkID = 100 * ERROR at line 1: ORA-00600: internal error code, arguments: [25012], [15], [8], [], [], [], [], [] Tablespace id 15…

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 ————————————————– —————————————————————- library cache kqlftc library cache kqlmbfre: parent library cache kqlmbpil: parent library cache kqlmbinv: parent library cache kqlmbfre: child: in loop library cache kqlmbfre: child: no obj to free library cache…

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 X$K2GTE  – Current 2PC tx X$K2GTE2 – Current 2PC tx [C]ache Layer [B]uffer Management Buffer [H]ash X$BH – Hash Table Buffer LRU…

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(‘&rdba’,’XXXXXXXX’)-           trunc( to_number(‘&rdba’,’XXXXXXXX’)                / power(2,22))*power(2,22) ) as block#   from dual / CREATE OR REPLACE FUNCTION getbfno (p_dba IN VARCHAR2)    RETURN VARCHAR2 IS    l_str   VARCHAR2 (255) DEFAULT NULL;    l_fno   VARCHAR2…

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 arguments to calls to ksqcmi and // ksqlrl and the return values. // *Action: Level indicates details: // Level: 1-4: print out basic info for ksqlrl, ksqcmi // 5-9: also print out…

The function generates a summary report of the v$sql_shared_cursor view and additional diagnostic information depending on the reason code. Counts all the versions that have ‘Y’ in any of the columns and if any have all ‘N’ too. This script may be useful to diagnose ORA-600 [17059] errors Running the Script — Generate reports for…

脚本正文: col username for a12 col “QC SID” for A6 col “SID” for A6 col “QC/Slave” for A8 col “Req. DOP” for 9999 col “Actual DOP” for 9999 col “Slaveset” for A8 col “Slave INST” for A9 col “QC INST” for A6 set pages 300 lines 300 col wait_event format a30 select decode(px.qcinst_id,NULL,username, ‘ -…