This content has been marked as final. Show 13 replies
Mohit Ag wrote:DML generates REDO records
When we start the Oracle Apps Concurrent manager then there are few sessions and queries that are taking huge space and because of that archive directory gets full so fast that we are unable to control it..
Below is the query:
Following is the sql used by the sessions:
23:58:42 sys@ITGPRD> @hash
Enter value for hash: 3687172293
old 1: select sql_text from v$sqltext where hash_value=&hash order by piece
new 1: select sql_text from v$sqltext where hash_value=3687172293 order by piece
begin fndcp_tmsrv.read_R_pipe(:ec, :to, :typ, :enddt, :rid, :C_p
ipe, :nl, :nc, :dl, :secgrp, :usr, :rspap, :rsp, :log, :app, :pr
g, :argc, :a1, :a2, :a3, :a4, :a5, :a6, :a7, :a8, :a9,
:a10, :a11, :a12, :a13, :a14, :a15, :a16, :a17, :a18, :a19, :a20
5 rows selected.
Please help on this , what needs to be done to resolve this thing.
when we stop the Conc Manager then archival stops and no archive files are generated. the moment we start it, the archive dir gets full..
How to find the concurrent ID which is resposible for generating the huge archive logs....
--What this below query does? And how do we find the SQL TEXT for a SID....
select v$session.sid, username, value/1024/1024 redo_size_MB
from v$sesstat, v$statname, v$session
where v$sesstat.STATISTIC# = v$statname.STATISTIC#
and v$session.sid = v$sesstat.sid
and name = 'redo size'
and value > 0
and username is not null
order by value;
---What the below query does
select s.sid, s.value from v$sesstat s, v$statname n where s.statistic#=n.statistic# and n.name = 'redo size' order by 2
-- what this query does
where status_code in ('Q','I')
and requested_start_date > SYSDATE
and hold_flag = 'N';
Can anybody help me on this . it would be really helpful...
We just shut down the Concurrent Manager. Then I just logged on to Oralce EBS with SYSADMIN and went to Request -> View...
There is one request as shown below....
Name: Migrate Concurrent Programs
Status: On Hold
Run the Job: As Soon As Possible
I have no idea about Oracle Apps. So Can I cancel this request? May be this is creating the problem...would there be any impact of cancelling this?
Mohit Ag wrote:you can cancel request using GUi by press Cancel button or using sql plus
Can anyone help me on this?
notice if you don't have any experience in oracle apps it's prefer to let DBA Apps do that._
Update fnd_concurrent_requests SET PHASE_CODE=’C’ ,STATUS_CODE=’E’ WHERE request_id=’<request-id>′;
Arunan.KL wrote:Actually the archival is so fast that it fills up before being deleted by script as we only have 5 GB in the arvhival mount.
ofcourse it affects the functionality. if you stop the process.
As of now.. try to schedule a script to move the archive logs to different mount point or schedule a RMAN backup for the archivelogs, with delete input clause.
so you have the backup safe.
further you can analyse the issue.
So we have stopped CM as of now...as soon as we start the CM, the application goes down...plz suggest any thing that we can do..