RMAN catalogRMAN catalog
1.catalog和nocatalog nocatalog就是用controlfile作为catalog，RM […]
分类： Oracle
分享Oracle数据库相关教程，文章，知识以及技巧
How to identify STALE Statistics on a table?How to identify STALE Statistics on a table?
Check dba_tables last analyzed column. select owner,tab […]
Oracle Dataguard setup for CDBsOracle Dataguard setup for CDBs
primary=cdb141 standby=cdb481 1. DB Arcive-Log Mode Ver […]
常见命令常见命令
1.manual man ls 查看ls的用法 2.help ls --help help cd 查看ls的用 […]
Useful Study LinkUseful Study Link
06/29/2021: ZFS explain https://www.modb.pro/db/17376 S […]
Backup data from one database to anotherBackup data from one database to another
Target： Backup data from table ‘soa.soa_archive&# […]
Create Role and grant to userCreate Role and grant to user
Traget: grant user abc with read only access to all the […]
Merge Into和Update效率比较Merge Into和Update效率比较
from: https://www.cnblogs.com/eastsea/p/4519759.html 以前 […]
PL/SQL中三种游标循环效率对比PL/SQL中三种游标循环效率对比
from: https://blog.csdn.net/WuLex/article/details/81743 […]
PL/SQL的分析函数PL/SQL的分析函数
Analytic-Function ORACLE提供了以下分析函数： 1 统计函数（MAX MIN AVG S […]