前言:
如今同学们对“oraclehint驱动表”大概比较重视,看官们都想要剖析一些“oraclehint驱动表”的相关文章。那么小编也在网上汇集了一些关于“oraclehint驱动表””的相关内容,希望朋友们能喜欢,咱们一起来了解一下吧!概述
在AWR报告中经常看到一个hint /*+ OPAQUE_TRANSFORM */,感到莫名其妙。这个是什么引起的呢?
相关sql
SELECT /*+ OPAQUE_TRANSFORM */ "TAG_1", "LPN", "ORDERNUMBER", "SKU_ID", "PQUANTITY", "TAG2", "LOCATION_NAME", "SOURCE_LOCATION_XID", "DEST_LOCATION_XID", "UNLOAD_POINT", "EARLY_PICKUP_DATE", "LATE_PICKUP_DATE", "PU_XID", "TU_XID", "SNP" FROM "RF_SHIPUNIT_SCANNING"官网介绍
What is OPAQUE_TRANSFORM usage :
The OPAQUE_TRANSFORM hint is to help with the transformation of datatype when certain type of operations are done within the database. For example object types .
It is also used for a insert-as-remote-select operation on a remote database.
OPAQUE_TRANSFORM的用法:
OPAQUE_TRANSFORM hint 是帮助数据库中某种操作下的数据转换。例如对象类型。它也用于远程数据库上的插入。
如果在数据库B的AWR中看到这种hint,原因是其他数据库通过DB link访问数据库B,且用的是insert into table_name select * from table_name@dblink_name的方式访问。
觉得有用的朋友多帮忙转发哦!后面会分享更多devops和DBA方面的内容,感兴趣的朋友可以关注下~
标签: #oraclehint驱动表