首页 / ORACLE / Oracle12.1.0.2新特性ApproximateCountDistinct

Oracle12.1.0.2新特性ApproximateCountDistinct

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了Oracle12.1.0.2新特性ApproximateCountDistinct，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3349字，纯文字阅读大概需要5分钟。

内容图文

[oracle@PD009 ~]$ grep -i approx_count oracle.strsettings for approx_count_distinct optimizationsqkaGBPushdown: estimated memory without GPD = groupSize (%.2f) * aclsum (%u) = %.2f; estimated memory with GPD = optHllEntry (%u) * # of appro

[oracle@PD009 ~]$ grep -i approx_count oracle.str
settings for approx_count_distinct optimizations
qkaGBPushdown:  estimated memory without GPD = groupSize (%.2f) * aclsum (%u) = %.2f; estimated memory with GPD = optHllEntry (%u) * # of approx_count_distinct (%d) * parallelDegree (%.0f) = %.2f
APPROX_COUNT_DISTINCT
APPROX_COUNT_DISTINCT
APPROX_COUNT_DISTINCT
_approx_cnt_distinct_gby_pushdown = choose
_approx_cnt_distinct_optimization = 0
 alter system flush shared_pool;
  alter session set events '10053 trace name context forever ,level 1';
 select count( distinct prod_id) from sales_history where  amount_sold>1;
 select approx_count_distinct(prod_id) from sales_history where  amount_sold>1;
  oradebug setmypid;
  oradebug tracefile_name;
  /s01/diag/rdbms/pdprod/PDPROD/trace/PDPROD_ora_4086.trc
  sql= select count( distinct prod_id) from sales_history where  amount_sold>1
----- Explain Plan Dump -----
----- Plan Table -----
============
Plan Table
============
---------------------------------------------+-----------------------------------+
| Id  | Operation             | Name         | Rows  | Bytes | Cost  | Time      |
---------------------------------------------+-----------------------------------+
| 0   | SELECT STATEMENT      |              |       |       |  4912 |           |
| 1   |  SORT AGGREGATE       |              |     1 |    13 |       |           |
| 2   |   VIEW                | VW_DAG_0     |    72 |   936 |  4912 |  00:00:59 |
| 3   |    HASH GROUP BY      |              |    72 |   648 |  4912 |  00:00:59 |
| 4   |     TABLE ACCESS FULL | SALES_HISTORY| 3589K |   32M |  4820 |  00:00:58 |
---------------------------------------------+-----------------------------------+
sql= select approx_count_distinct(prod_id) from sales_history where  amount_sold>1
----- Explain Plan Dump -----
----- Plan Table -----
============
Plan Table
============
----------------------------------------------+-----------------------------------+
| Id  | Operation              | Name         | Rows  | Bytes | Cost  | Time      |
----------------------------------------------+-----------------------------------+
| 0   | SELECT STATEMENT       |              |       |       |  4820 |           |
| 1   |  SORT AGGREGATE APPROX |              |     1 |     9 |       |           |
| 2   |   TABLE ACCESS FULL    | SALES_HISTORY| 3589K |   32M |  4820 |  00:00:58 |
----------------------------------------------+-----------------------------------+
Predicate Information:

Related posts:

  1. Extract SQL Plan from AWR
  2. 部分行索引使用介绍
  3. Script:诊断解析等待和高version count
  4. 【11g新特性】SPM SQL PLAN MANAGEMENT执行计划管理流程图
  5. Number of distinct values (NDV) & synopsis & Histogram gather speed
  6. SQL调优:带函数的谓词导致CBO Cardinality计算误差
  7. 【11g新特性】Cardinality Feedback基数反馈
  8. 【Oracle CBO优化器】视图合并View Merging技术 _complex_view_merging & _simple_view_merging
  9. 海量数据插入性能测试
  10. 查询v$lock缓慢和direct path write temp等待

原文地址：Oracle 12.1.0.2新特性 Approximate Count Distinct, 感谢原作者分享。

内容总结

以上是互联网集市为您收集整理的Oracle12.1.0.2新特性ApproximateCountDistinct全部内容，希望文章能够帮你解决Oracle12.1.0.2新特性ApproximateCountDistinct所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/555446.html

来源：【匿名】