| temp space error ORA-1652 [message #546094] |
Mon, 05 March 2012 05:37  |
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
|
Senior Member |
|
|
Hello Expert,
We have enough space in the temp tablespace.
SQL> /
TABLESPACE_NAME EXTENT_SIZE TOTAL_EXTENTS USED_EXTENTS FREE_EXTENTS MAX_USED_SIZE
------------------------------- ----------- ------------- ------------ ------------ -------------
TEMP 128 58363 4574 53789 58363
SQL> select TABLESPACE_NAME,TOTAL_BLOCKS,USED_BLOCKS,FREE_BLOCKS from v$sort_segment;
TABLESPACE_NAME TOTAL_BLOCKS USED_BLOCKS FREE_BLOCKS
------------------------------- ------------ ----------- -----------
TEMP 7470464 585472 6884992
But still we are getting error
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
Also when looking into V$TEMP_SPACE_HEADER we have below finding.
SQL> select TABLESPACE_NAME,sum(BYTES_USED/1024/1024),sum(BYTES_FREE/1024/1024)
from V$TEMP_SPACE_HEADER group by TABLESPACE_NAME;
TABLESPACE_NAME SUM(BYTES_USED/1024/1024) SUM(BYTES_FREE/1024/1024)
------------------------------ ------------------------- -------------------------
TEMP 58367 0
Please suggest, why we have alert.
[Updated on: Mon, 05 March 2012 06:40] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
