數(shù)據(jù)庫中NESTED_TABLE_SET_REFS hint有什么用

這篇文章將為大家詳細(xì)講解有關(guān)數(shù)據(jù)庫中NESTED_TABLE_SET_REFS hint有什么用，小編覺得挺實(shí)用的，因此分享給大家做個參考，希望大家閱讀完這篇文章后可以有所收獲。

NESTED_TABLE_SET_REFS hint 是 相當(dāng)于數(shù)據(jù)泵的操作 expdp 、impdp的操作
INSERT /*+NESTED_TABLE_SET_REFS+*/ 

一個Oracle未公開的hint提示出現(xiàn)了我的面前，再看這個session對應(yīng)的后臺應(yīng)用，原來是一個export操作,以前還真沒注意過，到metalink上查到了如下的解釋：

This hint specifies that nested tables should be retrieved as refs.It is used for exporting, importing and loading. It should never be issued by 
user queries, and in fact is unlikely to make a difference if tried.

This is also consistent with seeing large amounts of queries with this hint, and that those queries are not reused. If this is a problem for you, try to export at another time of day. If the exports are really long-running or the system load is constant, try to find out what you are using exports for and suggest alternatives (eg. backup and recovery purposes, etc). If this is a DSS system, you probably have a smaller shared pool and use import/export heavily. If so, it might be a good idea to use a bigger shared pool when doing this activity.

關(guān)于“數(shù)據(jù)庫中NESTED_TABLE_SET_REFS hint有什么用”這篇文章就分享到這里了，希望以上內(nèi)容可以對大家有一定的幫助，使各位可以學(xué)到更多知識，如果覺得文章不錯，請把它分享出去讓更多的人看到。