随笔分类 -  Oracle

Partition Fast Split 不起作用时应检查的内容 (Doc ID 378138.1)
摘要：What to Check When Partition Fast Split does Not Appear Working (Doc ID 378138.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.7 a 阅读全文
posted @ 2019-12-31 10:36 ZYLONG-SYS 阅读(165) 评论(0) 推荐(0) 编辑
How to Perform a FAST SPLIT PARTITION Using ALTER TABLE? (Doc ID 1268714.1)
摘要：APPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and laterOracle Databa 阅读全文
posted @ 2019-12-30 17:06 ZYLONG-SYS 阅读(373) 评论(0) 推荐(0) 编辑
盘点 Oracle 11g 中新特性带来的10大性能影响
摘要：转自 https://mp.weixin.qq.com/s?__biz=MjM5MDAxOTk2MQ==&mid=2650275500&idx=1&sn=84bc12fea2b88a92162117ab95a52954&chksm=be4866ba893fefac19fd7abb984057be31 阅读全文
posted @ 2019-12-20 17:03 ZYLONG-SYS 阅读(876) 评论(0) 推荐(0) 编辑
Oracle查看 open_cursors 和 session_cached_cursors
摘要：本文转自 http://blog.itpub.net/25583515/viewspace-2152997/ 查看当前session已使用的最大open cursor数 和cached cursor数： SELECT 'session_cached_cursors' PARAMETER, LPAD 阅读全文
posted @ 2019-12-18 14:14 ZYLONG-SYS 阅读(1383) 评论(0) 推荐(0) 编辑
如何在Oracle 12C中Drop/Truncate多个分区 (Doc ID 1482264.1)
摘要：How to Drop/Truncate Multiple Partitions in Oracle 12C (Doc ID 1482264.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and late 阅读全文
posted @ 2019-12-15 14:07 ZYLONG-SYS 阅读(2617) 评论(0) 推荐(0) 编辑
如何在Oracle 12C中添加多个分区 (Doc ID 1482456.1)
摘要：How to Add Multiple Partitions in Oracle 12C (Doc ID 1482456.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Da 阅读全文
posted @ 2019-12-15 13:52 ZYLONG-SYS 阅读(961) 评论(0) 推荐(0) 编辑
12c分区增强功能，新功能（文档ID 1568010.1）
摘要：12c Partitioning Enhancements, New Features (Doc ID 1568010.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Dat 阅读全文
posted @ 2019-12-15 13:41 ZYLONG-SYS 阅读(489) 评论(0) 推荐(0) 编辑
12C新功能：在线移动分区 (Doc ID 1584032.1)
摘要：12C New Feature: Online Move Partition (Doc ID 1584032.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Database 阅读全文
posted @ 2019-12-15 12:53 ZYLONG-SYS 阅读(256) 评论(0) 推荐(0) 编辑
12C新功能：在线移动数据文件 (Doc ID 1566797.1)
摘要：12C New Feature : Move a Datafile Online (Doc ID 1566797.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Databa 阅读全文
posted @ 2019-12-15 12:31 ZYLONG-SYS 阅读(507) 评论(0) 推荐(0) 编辑
How To Convert A Partitioned Table To A Non-Partitioned Table Using DataPump In 11g (Doc ID 1276049.1)
摘要：How To Convert A Partitioned Table To A Non-Partitioned Table Using DataPump In 11g (Doc ID 1276049.1) APPLIES TO: Oracle Database Exadata Cloud Machi 阅读全文
posted @ 2019-12-15 11:38 ZYLONG-SYS 阅读(1049) 评论(0) 推荐(0) 编辑
如何在asm上定位数据块
摘要：转自 https://blogs.oracle.com/database4cn/%e5%a6%82%e4%bd%95%e5%9c%a8asm%e4%b8%8a%e5%ae%9a%e4%bd%8d%e6%95%b0%e6%8d%ae%e5%9d%97 我们都知道当db使用传统的文件系统时，定位bloc 阅读全文
posted @ 2019-12-10 13:25 ZYLONG-SYS 阅读(478) 评论(0) 推荐(0) 编辑
12c新特性 在线操作数据文件
摘要：我们都知道，oracle pre-12c之前，若是想要把一个数据文件改名或者迁移， 必须在归档模式下先把这个数据文件offline之后， 然后进行OS上的copy或者rename 操作， 最后在sqlplus里面进行alter database rename file x to Y; 如果不是arc 阅读全文
posted @ 2019-12-10 12:35 ZYLONG-SYS 阅读(372) 评论(0) 推荐(0) 编辑
LogMiner Utility Release 8i - 11g (Doc ID 291686.1)
摘要：LogMiner Utility Release 8i - 11g (Doc ID 291686.1) APPLIES TO: Oracle Database Exadata Cloud Machine - Version N/A and laterOracle Cloud Infrastructu 阅读全文
posted @ 2019-12-09 15:50 ZYLONG-SYS 阅读(524) 评论(0) 推荐(0) 编辑
ODA: After Apply ODA 12.2.1.2.0 Patch, Unable to Create TableSpace Due to [ORA-15001: diskgroup "DATA" does not exist or is not mounted | ORA-15040: diskgroup is incomplete] (Doc ID 2375553.1)
摘要：ODA: After Apply ODA 12.2.1.2.0 Patch, Unable to Create TableSpace Due to [ORA-15001: diskgroup "DATA" does not exist or is not mounted | ORA-15040: d 阅读全文
posted @ 2019-12-05 22:42 ZYLONG-SYS 阅读(1161) 评论(0) 推荐(0) 编辑
Oracle 统计表空间和对象历史增长量
摘要：最近7天内 每天(某个)表空间的增长量 col TS_NAME for a15 SELECT a.snap_id, a.rtime, c.tablespace_name ts_name, round(a.tablespace_size * c.block_size / 1024 / 1024 / 1 阅读全文
posted @ 2019-12-04 17:36 ZYLONG-SYS 阅读(3326) 评论(0) 推荐(1) 编辑
示例：Oracle表锁、行锁模拟和处理
摘要：for update模拟锁表 --session 1 SQL> select * from tt for update; --session 2 SQL> update tt set id=1 where id=2; 按用户查询锁的情况 set line 300 col OBJECT_NAME fo 阅读全文
posted @ 2019-12-04 10:14 ZYLONG-SYS 阅读(2699) 评论(1) 推荐(0) 编辑