Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> replication error GET_FINAL_LOB big TEMP

replication error GET_FINAL_LOB big TEMP

From: Arkadiusz Malinowski <am_sik_at_poczta.onet.pl>
Date: Mon, 7 Oct 2002 15:03:19 +0200
Message-ID: <ans0lf$q75$1@news.onet.pl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US