查看数据仓库的awr报告发现以下问题 顺便总结一下之前碰到的一类问题
CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
13,664.[……]
11g DEFAULT_MAINTENANCE_PLAN 总结
June 18, 2012 11g, oracle No comments 11g
Scripts: check user all granted privileges
June 14, 2012 maintain, oracle No comments scripts
this scripts is used to check user all privileges
set serveroutput on;
DECLARE
v_user VARCHAR2(30) := ‘XXX’;
v_ddl[……]
Why ASM?
June 13, 2012 oracle, RAC No comments asm
Why ASM?
. ASM is an Oracle provided Database/Cluster filesystem and Storage Volume manager, optimized for Oracle for any kind of workload (b[……]
Bitmap index tips
June 7, 2012 Internals, oracle No comments structure
对于BITMAP index的使用 一直存在一些争议 我们来看看下面几个观点：
1. Low cardinality – Some dabase vendor, like Oracle, provides very practical suggestion
If the num[……]
some change in cache buffer handle
June 7, 2012 Internals, oracle No comments internal
今天开发因为连接数不够 强烈要求加大processes值,突然想到了processes对_cursor_db_buffers_pinned的影响,,小记之:
当会话需要pin住buffer header时它首先要获去buffer handle,实例所存在的buffer handle总数由(ea[……]
Oracle latch internals
June 6, 2012 Internals, oracle 4 comments internal
Oracle latch internals
Server latch implementation called KSL, e.g. every table with name starting with x$ksl… is latch
related and every[……]
坏块处理一例 (1)
May 31, 2012 maintain, oracle 2 comments
测试AIX从linux导入数据时 Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS阶段停留了很久：
ORA-39082: Object type ALTER_PROCEDURE:”USER_DA[……]
新到两台x2-2
May 29, 2012 Exadata, oracle 3 comments Exadata
Linux mysql 优化
May 28, 2012 MYSQL, performance No comments
linux mysql
一、修改内核参数
1.1、编辑/etc/sysctl.conf
vi /etc/sysctl.conf
net.ipv4.tcp_max_syn_backlog = 65536
net.core.netdev_max_backlog = 65536
ne[……]
11g 密码延迟登陆导致 library cache lock
May 24, 2012 11g, oracle No comments