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 阅读(112) 评论(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 阅读(168) 评论(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 阅读(312) 评论(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 阅读(165) 评论(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 阅读(327) 评论(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 阅读(253) 评论(0) 推荐(0) 编辑

Gather DBMS_STATS Default parameter

摘要： What are the default parameter values ? select dbms_stats.get_param('cascade') from dual; select dbms_stats.get_param('degree') from dual; select dbms_stats.get_param('estimate_percent') from du... 阅读全文

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

PGA Usage Larger than PGA_AGGREGATE_TARGET setting?

摘要： pga_aggregate_target is a target, as opposed to a hard limit – so it isn’t unusual to go above that.13G above that, now that’s unusual though! There IS an enhancement request in,to make a hard-limit s... 阅读全文

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

Know about Oracle High Water Mark

摘要： there's no HWM for datafiles, it's just a virtual term to describe the last block containing data in the data file, which is the minimum size allowed for sizing down the data file.This article intends... 阅读全文

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

Oracle内部错误ORA-07445: [ACCESS_VIOLATION] [unable_to_trans_pc][UNABLE_TO_READ]

摘要： ORA-07445: [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x5A1113A] [ADDR:0xFFFFFFFFFFFFFFFF] [UNABLE_TO_READ]一般是Windows平台上常见的内存不足问题引起，在64 bit 或 32bit 平台均可能发生，一般建议通过增加SGA_MAX_SIZE和SGA_TARGET(ASMM)来解决该问... 阅读全文

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

ORACLE数据库服务热线：13764045638 诗檀软件