Oracle和MySQL - 博客园

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

Know More About Libarary Cache and Latches

摘要： Stored objects And Transient objects are stored in the library cache, neither Temporary objects nor Permanent objects.The library cache is structured as a Hash table .But Library cache objects are c... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(162) 评论(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 阅读(344) 评论(0) 推荐(0)

ORA-4031 Common Analysis/Diagnostic Scripts

摘要： 4031_diag_script.zip1. SGA中的内存池包含不同大小的内存块。当数据库启动时，就有一个大的内存块分配并被hush buckets 里的空闲列表追踪。随着时间推移，随着内存的分配和释放，内存块被按照大小在不同的hush buckets间移动。当SGA里任何一个内存池里出现不能满足内部分配请求的情况时，ORA-04031就出现了。shared pool共享池的管理方式不同于其它的... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(257) 评论(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 阅读(220) 评论(0) 推荐(0)

EVENT:10226 trace CR applications of undo for data

摘要： Error: ORA 10226Text: trace CR applications of undo for data operations-------------------------------------------------------------------------------Explanation: This is NOT an error but is... 阅读全文

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

EVENT:10218 dump uba of applied undo

摘要： @23-JAN-01, rpowell.uk, Distribution justification: "Should not be used by@ customers unless told to by support so making noncustomer-viewable." - dbither.usEvent: 10218Text: dump uba of applied undo... 阅读全文

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

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