2012 年 5月 10 日随笔档案 - weaver_chen

2012年5月10日

摘要： ORA-00604: 递归 SQL 层 1 出现错误ORA-14450: 试图访问已经在使用的事务处理临时表首先要查一下错误信息, 可以从手册中查:Cause: An attempt was made to access a transactional temporary table that has been already populated by a concurrent transaction of the same session.Action: Do not attempt to access the temporary table until the concurrent tra 阅读全文

posted @ 2012-05-10 11:30 weaver_chen 阅读(1995) 评论(0) 推荐(0)

hp-unix 11G出现的BUG

摘要：在ALERT的日志中出现如下报错：Errors in file /home/oracle/db/diag/rdbms/qdsj/qdsj1/trace/qdsj1_m000_18573.trc:ORA-04035: unable to allocate 4096 bytes of shared memory in shared object cache "JOXSHM" of size "134217728"Tue Jul 07 05:00:33 2009Thread 1 advanced to log sequence 79Current log# 5 阅读全文

posted @ 2012-05-10 10:08 weaver_chen 阅读(327) 评论(0) 推荐(0)

v$sql,v$sqlarea,v$sqltext有什么区别？

摘要： 1、查一下这些视图的定义你就能理解，它们的源都是一个。SELECT view_definition FROM v$fixed_view_definition WHERE view_name='GV$SQL';SELECT view_definition FROM v$fixed_view_definition WHERE view_name='GV$SQL_AREA';2、实际上最模糊的是v$sql与v$sqlarea,区别与联系除biti说的还有：a、v$sql_area相当于是按INST_ID, KGLNAOBJ, KGLHDPAR, KGLNAHSH, K 阅读全文

posted @ 2012-05-10 09:54 weaver_chen 阅读(320) 评论(0) 推荐(0)

SQL Server Code Review Checklist

摘要： Problem In a recent tip, you outlined steps for code deployment (Code Deployment Best Practices). That is a good first step to get a process in place to work with the team and set expectations. As a DBA, I need to find out the technical steps I should take when reviewing T-SQL code. Can you provide 阅读全文

posted @ 2012-05-10 01:10 weaver_chen 阅读(324) 评论(0) 推荐(0)