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的用 […]
Oracle GG SetupOracle GG Setup
1. Source: host 1 CBD: cdb141 PDB: MCRMB Target: host 2 […]
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 […]
How To Create a Snowflake Role HierarchyHow To Create a Snowflake Role Hierarchy
The Snowflake Data Cloud provides a powerful hierarchic […]
A standard model for Snowflake roles and privilegesA standard model for Snowflake roles and privileges
by trevorscode | posted in: Snowflake from: https://tre […]
A Comprehensive Tutorial of Snowflake Privileges and Access ControlA Comprehensive Tutorial of Snowflake Privileges and Access Control
by trevorscode | posted in: Snowflake from: https://tre […]