Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> replication error GET_FINAL_LOB big TEMP
After 1 month when replication work fine now I can't establish it because
TEMP enlarge extreemly in two minuts to 5 GB and so on...
SELECT * FROM DEFERRCOUNT; >> no rows
SELECT * FROM DEFERROR; >> no rows
select SESSION_ADDR, SESSION_NUM, sum(EXTENTS) from v$sort_usage
group by SESSION_ADDR, SESSION_NUM
order by 3 desc; >> no rows
extent_used=0 block_used=0
I think problem is in table with CLOB datat type. repadmin session create in TEMP sorts about 5000 extents (one extent 10 MB ) but after few second deasapear, but Oracle doesn't release free space.
SESSION_ SESSION_NUM SUM(EXTENTS)
-------- ----------- ------------
A3D3F074 12778 4719
That session is INACIVE with PL/SQL error 6553 incorrect count arguments in
function GET_FINAL_LOB.
What is wrong?
thanks,
Arek
Received on Mon Oct 07 2002 - 08:03:19 CDT