Oracle ASMM (Automatic Shared Memory Management)Oracle ASMM (Automatic Shared Memory Management)
1.ASMM简介 ASMM是Oracle 10g提供内存管理方式。使用ASMM，不再需要手工设置shared […]
年度归档： 2021 年
How to Delete GRIDHow to Delete GRID
Method 1: export GRID_HOME=/oracle/app/oracle/product/1 […]
十大SQL问题十大SQL问题
转：Enmotech 2020-04-25 07:47:23 你不可不知的十大SQL问题（上） 众所周知，自 […]
Oracle 数据库分布式事务Oracle 数据库分布式事务
转载：小猪跑得快-Fly 链接 1.什么是分布式事务 分布式事务就是指事务的参与者、支持事务的服务器、资源服务 […]
Oracle home preferred locations for 19cOracle home preferred locations for 19c
I have used for GRID_HOME and DB_HOME the following loc […]
Oracle Grid Infrastructure Patch Set Update(GI PSU)Oracle Grid Infrastructure Patch Set Update(GI PSU)
Grid Infrastructure Patch Set Update GI PSU 中包含了Databas […]
Oracle Compile Invalid objectsOracle Compile Invalid objects
1) find invalid objects select owner,object_name,object […]
V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 2471245.1)V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 2471245.1)
Purpose Scope Details NOTE: Before proceeding w […]
find orphaned ASM filesfind orphaned ASM files
SET VERIFY OFF SET LINESIZE 200 SET SERVEROUTPUT ON SET […]