Oracle 性能优化工具(AWR/ASH/ADDM)详情
Oracle 性能优化工具(AWR/ASH/ADDM)详情
Oracle 表结构顺序不一致 隐藏的2个问题...
Oracle 表结构顺序不一致 隐藏的2个问题...
Oracle 是分区表,但条件不带分区条件的SQL
Oracle 是分区表,但条件不带分区条件的SQL
如何在系统上查看当天Oracle log切换频率
如何在Linux 系统上查看当天Oracle log切换频率
Oracle imp/impdp报ORA-04031:streams pool,..fixed allocation callback解决/分析
ORAOOracle imp/impdp导入报错-04031: ("streams pool","unknown object","streams pool","fixed allocation callback")解决分析
Oracle -- 深入体会PLAN_TABLE、PLAN_TABLE$
Oracle -- 深入体会PLAN_TABLE、PLAN_TABLE$ PLAN_TABLE is the default table for results of the EXPLAIN PLAN statement. It is created by utlxplan.sql, and it contains one row for each step in the execution plan. ---> session1:commit,session2:可查看数据PLAN_TABLE$ is a global temporary table accessible from any schema .It is created by catplan.sql ,It also creates the plan_id sequence number. ---> 临时表 session1:commit,session2:不可查看数据