-
Recent Posts
Recent Comments
- yangtingkun on 非空字段空值对查询的影响
- Eric Zong on 非空字段空值对查询的影响
- Kamus on Oracle Ace Director
- 设置全局死锁优先级 | yangtingkun on RAC全局死锁检测时间
- ORA-600(krbounotread_noctx)错误 | yangtingkun on ORA-600(krboReadBitmap_badbitmap)错误
Archives
- December 2020
- February 2019
- December 2018
- November 2018
- October 2018
- July 2018
- June 2018
- May 2018
- July 2016
- July 2013
- June 2013
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
Categories
Meta
Tag Archives: 10.2
10g中DBA_TAB_STATISTICS的STATTYPE_LOCKED列对分区锁定显示为空的解决
Oracle10g的DBA_TAB_STATISTICS视图的STATTYPE_LOCKED列没有正确的显示结果。 10g中DBA_TAB_STATISTICS的STATTYPE_LOCKED列对分区锁定显示为空：https://yangtingkun.net/?p=1023 上文提到了DBA_TAB_STATISTICS中的STATTYPE_LOCKED列在10g中对于分区锁定统计信息显示为空，那么在10g中有没有办法获取到正确的结果呢： SQL> SELECT TABLE_NAME, partition_name, last_analyzed, stattype_locked 2 FROM dba_tab_statistics 3 WHERE owner = USER 4 AND TABLE_NAME = ‘T_PART’; TABLE_NAME PARTITION_NAME LAST_ANAL STATT —————————— —————————— ——— —– T_PART 16-JUL-12 T_PART P1 T_PART P2 16-JUL-12 T_PART PMAX 16-JUL-12 … Continue reading
Posted in ORACLE
Tagged 10.2, dba_tab_statistics, DBMS_STATS, lock_partition_stats, partition, stattype_locked
Leave a comment
10g中DBA_TAB_STATISTICS的STATTYPE_LOCKED列对分区锁定显示为空
Oracle10g的DBA_TAB_STATISTICS视图的STATTYPE_LOCKED列没有正确的显示结果。 看一个简单的例子： SQL> SELECT * FROM v$version; BANNER —————————————————————- Oracle DATABASE 10g Enterprise Edition Release 10.2.0.5.0 – 64bi PL/SQL Release 10.2.0.5.0 – Production CORE 10.2.0.5.0 Production TNS FOR Linux: Version 10.2.0.5.0 – Production NLSRTL Version 10.2.0.5.0 – Production SQL> CREATE … Continue reading
Posted in ORACLE
Tagged 10.2, dba_tab_statistics, DBMS_STATS, lock_partition_stats, stattype_locked
Leave a comment
删除归档出现ORA-15028错误
在10.2.0.4 RAC环境中使用RMAN删除归档报错ORA-15028。 错误信息如下： RMAN> DELETE archivelog ALL completed BEFORE ‘sysdate-3’; Do you really want TO DELETE the above objects (enter YES OR NO)? YES RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure OF DELETE command … Continue reading
进程日志中出现out of OS kernel IO resources
在检查一个进程的日志时，意外发现这个问题。 错误信息如下： /ora10g/app/admin/dbname/bdump/dbname1_j001_8567.trc Oracle DATABASE 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production WITH the Partitioning, REAL Application Clusters, OLAP AND DATA Mining options ORACLE_HOME = /ora10g/app/product/10.2.0/dbname System name: HP-UX Node name: dbname1 Release: B.11.23 Version: U Machine: ia64 Instance … Continue reading
11.2通过数据库链调用10.2过程报错
测试中无意发现了这个bug，在11.2数据库通过数据库链，执行10.2.0.1上的过程，结果出现ORA-06553: PLS-801: internal error [55916]的错误。 错误可以通过下面的例子重现： -bash-3.2$ sqlplus / AS sysdba SQL*Plus: Release 10.2.0.1.0 – Production ON Mon Sep 12 23:12:47 2011 Copyright (c) 1982, 2005, Oracle. ALL rights reserved. Connected TO: Oracle DATABASE 10g Express Edition Release 10.2.0.1.0 – … Continue reading