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!

new temp tablespace usage

2670775Dec 21 2015 — edited Dec 23 2015

hi all

I have create a new temp tablespace temp02, and

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP02;

but I found many inactive session still using old temp tablespace, but they are inactive

SELECT b.tablespace,b.segfile#,b.segblk#,b.blocks,a.sid,a.serial#,a.username,a.osuser, a.status,a.logon_time FROM v$session a,v$sort_usage b where a.saddr = b.session_addr

can I drop the old tablespace without killing those inactive session ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 20 2016

Added on Dec 21 2015

#general-database-discussions

6 comments

1,480 views