今天在查数据的时候报错 ORA-01652:无法通过16(在表空间temp1中)扩展 temp 字段
查看表空间使用明细
SELECT
b.tablespace,
b.segfile#,
b.segblk#,
b.blocks,
b.blocks *
32
/
1024
/
1024
,
a.sid,
a.serial#,
a.username,
a.osuser,
a.status,
c.sql_text,
b.contents
FROM
v$session a, v$sort_usage b, v$sql c
WHERE
a.saddr = b.session_addr
AND
a.sql_address = c.address(+)
ORDER
BY
b.blocks
DESC
;
查看临时表空间情况
SELECT
D.TABLESPACE_NAME,
SPACE
"SUM_SPACE(M)",
BLOCKS SUM_BLOCKS,
USED_SPACE "USED_SPACE(M)",
ROUND
(
NVL
(USED_SPACE,
0
) /
SPACE
*
100
,
2
) "USED_RATE(%)",
NVL
(FREE_SPACE,
0
) "FREE_SPACE(M)"
FROM
(
SELECT
TABLESPACE_NAME,
ROUND
(