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!

Temporary tablespace query - v$sort_usage and sql_id

1049507Nov 6 2014 — edited Nov 7 2014

DB Version: Oracle 11.2

Please see the attachment.

Why do I have multiple rows for same SQL_ID and SQL_HASH in v$sort_usage ?

Ideally, when oracle creates a sort segment for a SQL_ID, the same sort segment can be used by all current sessions. Am I missing something ? Can someone please help.

Also, what would be the result of not using 'REUSE' in the below statement?

alter tablespace temp add tempfile '+data' size 10G;

One last thing: If 'Segment Space management' is set to MANUAL for the default TEMP tablespace, does this have any effect when compared to setting the same parameter to 'AUTO'

I tried to google this.. but no luch.

Thanks in advance for your time

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2014

Added on Nov 6 2014

#general-database-discussions

5 comments

3,694 views