11G ODI Temp usage


OBIA 11g ODI Temporary Table Consume Large Tablespace, How To Purge These Tables ? (Doc ID 1572972.1) To BottomTo Bottom

APPLIES TO:

Business Intelligence Applications Consumer - Version 11.1.1.7.0 and later

Information in this document applies to any platform.

GOAL

There are some temporary tables consuming huge amounts of space in the DW_DATA tablespace.

The table's name listed as below:

C$_<Session ID number>.1GB

How can we purge these data? and when to purge these data ?

SOLUTION

These tables are automatically purged once the interface is run successfully.

If there are failed sessions, then this table is not dropped immediately. This helps in debugging the failed sessions.


At the end of the load plan which  is generated using Load Plan Generator (LPG), we have a step called Finalize Batch Load , under which there is a step called Clean Work and Flow Tables. This automatically drops any such stale tables that are older than 30 days. You can reduce this default of 30 days by changing the value that is passed to that scenario step, if you so desire. But with this setup, you normally do not have to worry about dropping such tables.


The temporary table is named after the session that is using it. So C$_2082500_2_0 corresponds to the session with id 2082500.


Comments

Post a Comment

Popular posts from this blog

12c: emctl start agent Fails or Hangs or Timeout or Connection Refused

EM 12c: emctl start agent Fails or Hangs or Timeout or Connection Refused Due to PKCS11 'security.pkcs11.P11SecureRandom.implNextBytes' Reported in Thread Dump 'Hang detected' (Doc ID 1427773.1) APPLIES TO: Enterprise Manager Base Platform - Version 12.1.0.1.0 to 12.1.0.2.0 [Release 12.1] Oracle Solaris on SPARC (64-bit) SYMPTOMS $AGENT_INST/bin/emctl start agent fails to start or gets hung Oracle Enterprise Manager Cloud Control 12c Release 2 Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved. Starting agent ........................................................................................... OR $AGENT_INST/bin/emctl start agent fails with following error Oracle Enterprise Manager 12c Cloud Control 12.1.0.1.0 Copyright (c) 1996, 2012 Oracle Corporation. All rights reserved. Agent status could not be determined. Check the agent process Consult the log files in: /oracle/product/Agent_home/agent_inst/sysman/log $AGENT_INST/bin/emctl
Read more
Image
12.2 Creating New WLS Domain Fails On Adcfgclone.pl With "oracle.as.t2p.exceptions.FMWT2PPasteConfigException: PasteConfig failed. Make sure that the move plan and the values specified in moveplan are correct." (Doc ID 2215729.1) To Bottom In this Document Symptoms Cause Solution References APPLIES TO: Oracle Applications Manager - Version 12.2 and later Information in this document applies to any platform. SYMPTOMS E-Business Suite 12.2 Applications Manager, Rapidclone Related issues When creating to clone E-Business Suite adcfgclone.pl fails with the following error: WARNING : Nov 20, 2016 01:00:05 - WARNING - CLONE-20454 Execution of wlst script is not successful. WARNING : Nov 20, 2016 01:00:05 - CAUSE - CLONE-20454 An internal operation failed while executing /fs1/inst/apps/<CONTEXT_Name>/logs/appl/rgf/TXK/CLONINGCLIENT573700/tmp14795960.py wlst script. WARNING : Nov 20, 2016 01:00:05 - ACTION - CLONE-20454 Check clone log a
Read more