Oracle 21c 专题索引

本页汇总 Oracle 21c DBA 常用知识与操作的专题入口，推荐阅读顺序与快速链接，便于培训、排障与变更执行。

快速链接

提示：本站前端按“文件名”排序，索引页已通过“000-”前缀置顶至 DBA 分类首位。

当前容器与 PDB 状态 sql SHOW con_name; SELECT con_id, name, open_mode FROM v$containers ORDER BY con_id;
空间与数据文件 sql SELECT tablespace_name, ROUND(SUM(bytes)/1024/1024) total_mb FROM dba_data_files GROUP BY tablespace_name; SELECT file_id, file_name, bytes/1024/1024 mb FROM dba_data_files ORDER BY file_id;
等待与会话热点 sql SELECT wait_class, event, COUNT(*) samples FROM v$active_session_history WHERE sample_time > SYSTIMESTAMP - INTERVAL '10' MINUTE GROUP BY wait_class, event ORDER BY samples DESC FETCH FIRST 10 ROWS ONLY;