-
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: DROP TABLE
DML_LOCKS设置为0导致SHUTDOWN IMMEDIATE失败
DML_LOCKS参数设置系统中允许DML锁的数量，如果将这个参数设置为0，会禁止ENQUEUE的产生，有可能轻微的提升系统的性能。 不过如果将这个参数设置为0，带来的后果会严重很多： SQL> SHOW parameter dml_locks NAME TYPE VALUE ———————————— ———– —————————— dml_locks INTEGER 264 SQL> ALTER system SET dml_locks = 0 scope = spfile; System altered. SQL> shutdown immediate DATABASE closed. DATABASE dismounted. ORACLE instance shut down. SQL> startup … Continue reading
Posted in ORACLE
Tagged create index, dml_locks, DROP TABLE, enqueue, ora-62, shutdown abort, shutdown immediate, truncate table
Leave a comment
分区表相关视图没有过滤删除表
一直认为，表被删除后，普通的视图中是查询不到表信息的，只有从RECYCLBIN相关视图才能看到被删除的表，没想到最近发现分区表的相关视图中仍然保留被删除表的信息。 看一个简单的例子： SQL> CREATE TABLE T_PART (ID NUMBER, NAME VARCHAR2(30)) 2 PARTITION BY HASH (ID) 3 PARTITIONS 4; 表已创建。 SQL> SELECT TABLE_NAME, PARTITIONING_TYPE, PARTITION_COUNT, STATUS 2 FROM USER_PART_TABLES; TABLE_NAME PARTITION PARTITION_COUNT STATUS —————————— ——— ————— ——– T_PART HASH 4 VALID … Continue reading
Posted in ORACLE
Tagged DROP TABLE, DROPPED, USER_PART_TABLES, USER_TABLES, USER_TAB_PARTITIONS
Leave a comment