ORACLE SQL
文章平均质量分 62
xiadingling
天道酬勤
展开
-
How to use V$SQL_MONITOR
1. add hint to monitor a particular SQLeg. select/*+ monitor */ emp_name from emp;2. to get sid for the sqlselect SQL_ID,sum(buffer_gets) buffer_gets,sum(disk_reads)disk_reads,round(sum(cpu_time/100...原创 2018-04-19 11:39:12 · 353 阅读 · 0 评论 -
Oracle SQL tuning - Tips for writing more efficient SQL
1.Rewrite complex subqueries with temporary tables - Oracle created the global temporary table (GTT) and the SQL WITH operator to help divide-and-conquer complex SQL sub-queries (especially those with...转载 2018-04-19 12:54:16 · 173 阅读 · 0 评论 -
STATISTICS_LEVEL A-ROWS
STATISTICS_LEVEL specifies the level of collection for database and operating system statistics. The Oracle Database collects these statistics for a variety of purposes, including making self-manageme...原创 2018-04-20 14:33:37 · 610 阅读 · 0 评论 -
Table Access by Rowid 有时候会花费很长时间
通过ROWID访问表的时候, 通常是先根据索引找到某个范围的ROWID,然后再根据ROWID反查表去获得满足其他条件的数据。 通常反查的物理读会比较多。 如果这个反查的物理读特别大并且没有其他更有效的方式过滤返回结果的时候,应该考虑检查使用的索引是否不合适官方解释如下:8.2.3.2 How Table Access by Rowid WorksTo access a table by rowid...原创 2018-04-20 15:48:18 · 3041 阅读 · 0 评论