Oracle和MySQL - 博客园

EVENT 10051:"trace OPI calls"

摘要： Error: ORA 10051Text: trace OPI calls-------------------------------------------------------------------------------Explanation:This is NOT an error but is a special EVENT code.It should *NOT* be u... 阅读全文

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

VIEW:X$KCCRS-Controlfile Record Section directory (8.0 - 8.1)

摘要： View: X$KCCRS [K]ernel [C]ache [C]ontrolfile management controlfile [R]ecord [S]ection directory Column Type Description -------- ---- ----------- ... 阅读全文

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

Fixed X$ Tables in ASM

摘要： From Vinod Haval's These Views helps in understanding the following metrics Physical Mapping Provides Undocumented Information 18 X$ Tables (May be more) TABLE NAMEDESCRIPTIONX$KFALSThis table gi... 阅读全文

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

Script:To Report Information on Indexes

摘要： Reports index fragmentation statistics:==========Script #1:==========SET ECHO offREM NAME: TFSIFRAG.SQLREM USAGE:"@path/tfsifrag schema_name index_name"REM ------------------------------------------... 阅读全文

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

Script to Detect Tablespace Fragmentation

摘要： create table SPACE_TEMP ( TABLESPACE_NAME CHAR(30), CONTIGUOUS_BYTES NUMBER)/declare cursor query is select * from dba_free_space order by tablespace_name, bloc... 阅读全文

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

Network Interface No Longer Operational?

摘要： Solaris平台上的Oracle数据库，Alert日志偶尔会出现"Network Interface No Longer Operational"的相关记录：ospid 11223: network interface with IP address 192.4.1.22 no longer operationalrequested interface 192.4.1.22 ioctl get ... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(99) 评论(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 阅读(1824) 评论(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 阅读(104) 评论(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 阅读(134) 评论(0) 推荐(0) 编辑

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