Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

v$tempseg_usage.segtype explanation

TimWong765Mar 10 2010 — edited Mar 10 2010

The Oracle documentation has the following explanation for v$tempseg_usage.segtype

Type of sort segment:
    *      SORT
    *      HASH
    *      DATA
    *      INDEX
    *      LOB_DATA
    *      LOB_INDEX

What does data mean? Or is there a better explanation in a book / magazine (compared to the Oracle reference entry http://download-uk.oracle.com/docs/cd/B28359_01/server.111/b28320/dynviews_3100.htm )?

Edited by: TimWong765 on Mar 10, 2010 4:13 AM

This post has been answered by Anurag Tibrewal on Mar 10 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 7 2010

Added on Mar 10 2010

#general-database-discussions

1 comment

1,269 views