For Oracle 8 and above, the new dictionary view "V$SORT_USAGE" shows
currently active sorts for the instance. Joining "V$SORT_USAGE" to
"V$SESSION" will provide the user who is performing a sort within the
sort segment. The CONTENTS column shows whether the segment is
created in a temporary or permanent tablespace.
阅读全文>
发表于 @ 2004年11月18日 18:43:00|评论(loading...)|举报|收藏