Oracle和MySQL - 博客园

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 阅读(345) 评论(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 阅读(267) 评论(0) 推荐(0)

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 阅读(126) 评论(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 阅读(181) 评论(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 阅读(110) 评论(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 阅读(144) 评论(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 阅读(417) 评论(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 阅读(1972) 评论(0) 推荐(0)

DBMS_REPAIR example

摘要： PURPOSE This document provides an example of DBMS_REPAIR as introduced in Oracle 8i. Oracle provides different methods for detecting and correcting data block corruption - DBMS_REPAIR is one option. W... 阅读全文

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

Materialized Views and Dimensions

摘要： Materialized Views and Refresh TypesThis practice will familiarize you with the various features and privileges to ensure successful creation of a materialized view from a base table.1) Grant the nece... 阅读全文

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

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