摘要：
PG EXPLAIN (query planner) Synopsis EXPLAIN [ ANALYZE ] [ VERBOSE ] statement where option can be one of: ANALYZE [ boolean ] VERBOSE [ boolean ] COST 阅读全文
摘要：
``` https://github.com/carlos-sierra/cscripts CS Scripts Inventory by Type (2023-07-29) Latency Load SQL Performance SPBL - SQL Plan Baselines SPRF - 阅读全文
摘要：
### ``` 原文-https://github.com/aws-samples/automate-table-partitioning-in-oracle-standard-edition/tree/main/partitions/scripts 需要调整的地方有： 1. drop table 阅读全文
摘要：
``` #!/bin/bash PDB=ORCLPDB2 export ORACLE_PDB_SID=ORCLPDB2 for x in {1..3} do sqlplus -S '/ as sysdba' <<EOF alter session set container=$ORCLPDB1 dr 阅读全文
摘要：
Oracle partition 功能发展历程  > 细节参考:https://www.oracle.com/doc 阅读全文
摘要：
### 基础理论 ``` Oracle数据库逻辑存储结构 Oracle Database allocates logical space for all data in the database. Oracle数据库逻辑存储单元有 data blocks, extents, segments, an 阅读全文
摘要：
答案是：对于Oracle数据库的CBO（Cost-Based Optimizer），统计信息的基础是来自DBA_TAB_STATISTICS视图，而不是DBA_SEGMENTS视图。DBA_TAB_STATISTICS视图提供了表级别的统计信息，这些信息用于CBO生成查询执行计划和优化查询。在CBO 阅读全文
摘要：
1. 网卡配置 默认使用dhcp config.vm.network :public_network 或者使用指定IP config.vm.network :public_network, ip: "192.168.56.102", virtualbox__hostonly: "vboxnet0" 阅读全文
摘要：
``` PURPOSE In Oracle10g and onwards, we have the option to shrink a segment, which will help DBAs to manage the space in better way. This feature als 阅读全文
摘要：
https://blog.iarsov.com/oracle/partial-restore-and-recovery/ 阅读全文