dbakevin.blogspot.com
Kevin's Blog: ARCHIVE
http://dbakevin.blogspot.com/p/archive.html
Years 7*24 support of multiple data centers, thousands instances. Experience in solving real world complicated oracle problems, many of which did not have available workaround previously. This blog is created to record these issues. View my complete profile. ORA-27303: additional information: startup egid = 1757 (oinstall), current egid = 104 (dba). Real meaning and Simulate "ORA-01152: file was not restored from a sufficiently old backup". Deinstall oracle 11g on linux.
dbakevin.blogspot.com
Kevin's Blog: buffer busy waits, resmgr:cpu quantum, and Suspending MMON action ..
http://dbakevin.blogspot.com/2012/04/test.html
Years 7*24 support of multiple data centers, thousands instances. Experience in solving real world complicated oracle problems, many of which did not have available workaround previously. This blog is created to record these issues. April 6, 2012. Buffer busy waits, resmgr:cpu quantum, and Suspending MMON action . When checking on one DB, below queries hang:. Bdr1 SELECT INST ID,DECODE(request,0,'Holder: ','Waiter: ') sid sess, id1, id2, lmode, request, type,ctime. ORDER BY id1, request;. Index state cfl...
jydba.net
2015 二月 | Java & Oracle
http://www.jydba.net/2015/02
系统架构,性能优化,打杂,放牛. Archive for 二月, 2015. Scn to timestamp ORA-00904. Laquo; Older Entries. Dbms outln.create outline在10.2.0.5中创建outline所包含的执行计划并不正确. Query Using Bind Variables Suddenly Starts to Perform Slowly. 发表在 Oracle 11R2 Grid Infrastructure执行root.sh脚本rootcrs.pl execution failed的处理. 发表在 oracle 10g 物理备库转换逻辑备库ORA-19953故障解决方法. 发表在 oracle 10g 物理备库转换逻辑备库ORA-19953故障解决方法.
acoug.org
ACOUG会员项目(ACOUG MEMBERSHIP PROGRAM)-中国 Oracle 用户组
http://www.acoug.org/acoug-membership-program
ACOUG Senior Member(ASM) 资深会员. 会员 是该项目的入门级,是那些在ACOUG社区中刚刚开始活动但是渴望在更高的层次做出贡献的人士 ASM 则是那些已经在社区中做出卓越贡献的人士。 成为 ACOUG Member(AM) 会员 有哪些好处. 在ACOUG网站中被标志和推荐为 ACOUG Member 会员. ACOUG Member(AM) 会员 的义务. 成为 ACOUG Senior Member(ASM) 资深会员 有哪些好处. 在ACOUG网站中被标志和推荐为 ACOUG Senior Member 专家. 可使用ACOUG Senior Member(ASM) logo. 有机会参加每年的ACOUG Borad Member(ABM) 董事成员候选人评选,进入ACOUG董事会. ACOUG Senior Member(ASM) 资深会员 的义务. 对于当年没有任何文章、活动贡献的会员,将保留把该会员的ACOUG Member状态修改为 ACOUG Alumnus(ACOUG校友(前会员) 的权力,直至下一次申请通过。 Eygle – 盖国强. 老熊 – 熊军.
dbakevin.blogspot.com
Kevin's Blog: simulate one ORA-01161, solving for ORA-01161 and ORA-01189
http://dbakevin.blogspot.com/2011/02/simulate-one-ora-01161-solving-for-ora.html
Years 7*24 support of multiple data centers, thousands instances. Experience in solving real world complicated oracle problems, many of which did not have available workaround previously. This blog is created to record these issues. February 12, 2011. Simulate one ORA-01161, solving for ORA-01161 and ORA-01189. ORA-01161:database name . in file header does not match given name of . Recreate controlfile with command. I simulate it here again. Its db name is NIGHT. SQL select name,open mode from v$database;.
jydba.net
_awr_sql_child_limit是否能控制awr记录sql执行次数的问题 | Java & Oracle
http://www.jydba.net/_awr_sql_child_limit控制是否记录sql执行次数的疑问
系统架构,性能优化,打杂,放牛. Awr sql child limit是否能控制awr记录sql执行次数的问题. 在ACOUG中国行长沙站的活动上分亨了一个关于high version count的主题,在活动中老盖提到在AWR报告的SQL ordered by Version Count部分,当SQL的version count大于等于200时就不会记录SQL的Executions,但是今天在优化SQL时仔细观察了一下情况并不是这样。 以下是102.0.4的一个AWR报告的SQL ordered by Version Count. 下面是112.0.1.0的一个AWR报告的SQL ordered by Version Count. 如上图所展现的一样,在oracle 10g,11g中,虽然 awr sql child limit参数设置200,但还是记录了version count大于200的SQL语句的执行次数。 From → oracle. You can use basic XHTML in your comments. Your email address will never.
jydba.net
备份与恢复 | Java & Oracle
http://www.jydba.net/category/uncategorized/备份与恢复
系统架构,性能优化,打杂,放牛. Posts from the ‘备份与恢复’ Category. Oracle 11g duplicate database基于备份复制数据库(六). Oracle 11g duplicate database基于备份复制数据库(五). Oracle 11g duplicate database基于备份复制数据库(四). Oracle 11g duplicate database基于备份复制数据库(三). Laquo; Older Entries. Dbms outln.create outline在10.2.0.5中创建outline所包含的执行计划并不正确. Query Using Bind Variables Suddenly Starts to Perform Slowly. 发表在 Oracle 11R2 Grid Infrastructure执行root.sh脚本rootcrs.pl execution failed的处理. 发表在 oracle 10g 物理备库转换逻辑备库ORA-19953故障解决方法.
jydba.net
2015 五月 | Java & Oracle
http://www.jydba.net/2015/05
系统架构,性能优化,打杂,放牛. Archive for 五月, 2015. Db file async I/O submit等待事件的故障诊断. Dbms outln.create outline在10.2.0.5中创建outline所包含的执行计划并不正确. Query Using Bind Variables Suddenly Starts to Perform Slowly. 发表在 Oracle 11R2 Grid Infrastructure执行root.sh脚本rootcrs.pl execution failed的处理. 发表在 oracle 10g 物理备库转换逻辑备库ORA-19953故障解决方法. 发表在 oracle 10g 物理备库转换逻辑备库ORA-19953故障解决方法.
jydba.net
Java & Oracle
http://www.jydba.net/page/2
系统架构,性能优化,打杂,放牛. Oracle Column Group Statistics. 例如:select ename from emp where sal = 25000 and job = ‘PRESIDENT’. SQL create table t1(t name varchar2(20) not null,t country varchar2(20) not null,t town varchar2(20) not null); Table created. SQL desc t1 Name Null? SQL exec dbms stats.gather table stats(ownname= 'JY',tabname= 'T1',estimate percent= 100,method opt= 'for all columns sizeauto',cascade= true); PL/SQL procedure successfully completed. From → 性能优化. Automatic SQL Tuning and SQL Profiles. DECLARE...