v$sort_usage视图在10gr2官方文档中找不到?

显示全部楼层 · 2010-10-8 09:28:51

如题 v$sort_usage这个视图我居然在 10gR2 的官方文档 Reference 里面没有找到这是为何?
用desc v$sort_usage 却能显示出来，你们能在Reference中找到吗？

千问 · 2010-10-8 09:28:51

nnd ，居然改名了改成V$TEMPSEG_USAGETnnd.

千问 · 2010-10-8 09:28:51

More about this view is at
http://yong321.freeshell.org/oranotes/v$sort_usage.txt
Yong Huang

千问 · 2010-10-8 09:28:51

拜读了Yong的文章。官方文档未见。
V$SORT_USAGE和V$TEMPSEG_USAGE同源。

再引一篇供参考：http://dbsnake.com/2009/08/sort-tempseg-usage.html

千问 · 2010-10-8 09:28:51

原帖由 secooler 于 2009-11-19 20:31 发表
再引一篇供参考：http://dbsnake.com/2009/08/sort-tempseg-usage.html
Thanks. That article is correct about v$tempseg_usage not showing all temporary segments, for example the ones in CTAS. I corrected my wording in my note accordingly.
V$tempseg_usage is simply a synonym for v_$sort_usage. So there's really not much on their "difference" to talk about.
Yong Huang

千问 · 2010-10-8 09:28:51

thanks .