Oracle 临时表空间问题小结
- WBOYOriginal
- 2016-06-07 16:58:22927browse
1gt;用户临时缺省表空间的切换--查询用户缺省临时表空间SQLgt; select username,temporary_tablespace from dba_users;USERNAM
select * from (select sess.username,sess.SID,sess.serial#,segtype,blocks*8/1024 "MB",sql_text from v$sort_usage sort, v$session sess ,v$sql sql where sort.SESSION_ADDR = sess.SADDR and sql.ADDRESS = sort.SQLADDR (+) order by blocks desc ) a where rownum
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：关于Linux下MySQL修改root密码时遇到的问题Next article：Linux下安装完Oracle后的一些操作及技巧