Oracle和MySQL - 博客园

EVENT:10228 trace application of redo by kcocbk

摘要： Error: ORA 10228Text: trace application of redo by kcocbk-------------------------------------------------------------------------------Explanation: This is NOT an error but is a special EVE... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(140) 评论(0) 推荐(0)

EVENT:10212 check cluster integrity

摘要： Error: ORA 10212Text: check cluster integrity-------------------------------------------------------------------------------Explanation: This is NOT an error but is a special EVENT code. ... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(196) 评论(0) 推荐(0)

Know Oracle Date And Time Function

摘要： Oracle9i provides extended date and time support across different time zones with the help of new datetime data types and functions. To understand the working of these data types and functions, it is ... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(364) 评论(0) 推荐(0)

利用dbms_system包加速imp导入数据时的索引建立

摘要： imp数据导入时往往大多数的时间都消耗在了索引建立上，我们可以通过为导入会话设置一系列session级别的参数来加速索引的建立:begin dbms_system.set_int_param_in_session(&sid, &serial, '... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(187) 评论(0) 推荐(0)

Learning 11g New Background Processes

摘要： New Background Processes In 11g* ACMS (atomic controlfile to memory service) per-instance process is an agent that contributes to ensuring a distributed SGA memory update is either globally committed... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(367) 评论(0) 推荐(0)

Script to Collect Data Guard Diagnostic Information

摘要： Overview--------This script is intended to provide an easy method to provide informationnecessary to troubleshoot Data Guard issues.Script Notes-------------This script is intended to be run via sqlpl... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(290) 评论(0) 推荐(0)

EVENT: 10500 "turn on traces for SMON"

摘要： Error: ORA 10500Text: turn on traces for SMON-------------------------------------------------------------------------------Cause:Action: Level: 5 trace posting of SMONTo set event 10500:... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(167) 评论(0) 推荐(0)

VIEW: X$KTUXE - Transaction Entry (table)

摘要： View: X$KTUXE [K]ernel [T]ransaction [U]ndo Transa[x]tion [E]ntry (table) This view is very useful as it gives an indication of the state of the transaction tables in the rollbac... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(474) 评论(0) 推荐(0)

Know more about Oracle Latches

摘要： Two purposes of latches were:Serialize Execution,Serialize AccessMatch the characteristics with latches and enqueues.Several modes of access EnqueueFIFO queue acquisition... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(439) 评论(0) 推荐(0)

EVENT:10061 disable SMON from cleaning temp segment

摘要： Error: ORA 10061Text: disable SMON from cleaning temp segment-------------------------------------------------------------------------------Explanation: This is NOT an error but is a special... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(239) 评论(0) 推荐(0)