oracle ebs 根据请求id找到对应trace 文件

SELECT ‘Request id: ‘||request_id ,

‘Trace id: ‘||oracle_Process_id,

‘Trace Flag: ‘||req.enable_trace,

‘Trace Name:

‘||dest.value||’/’||lower(dbnm.value)||’_ora_’||oracle_process_id||’.trc’,

‘Prog. Name: ‘||prog.user_concurrent_program_name,

‘File Name: ‘||execname.e免费云主机域名xecution_file_name|| execname.subroutine_name ,

‘Status : ‘||decode(phase_code,’R’,’Running’)

||’-‘||decode(status_code,’R’,’Normal’),

‘SID Serial: ‘||ses.sid||’,’|| ses.serial#,

‘Module : ‘||ses.module

from fnd_concurrent_requests req, v$session ses, v$process proc,

v$parameter dest, v$parameter dbnm, fnd_concurrent_programs_vl prog,

fnd_executables execname

where req.request_id = &request

and req.oracle_process_id=proc.spid(+)

and proc.addr = ses.paddr(+)

and dest.name=’user_dump_dest’

and dbnm.name=’db_name’

and req.concurrent_program_id = prog.concurrent_program_id

and req.program_application_id = prog.application_id

and prog.application_id = execname.application_id

and prog.executable_id=execname.executable_id

生产环境有定时运行请求“Purge Obsolete Workflow Runtime Data”，而且仅保留3天的历史记录

Purge Concurrent Request and/or Manager Data

相关推荐: PostgreSQL 源码解读（211）- 后台进程#10（checkpointer-BufferSync）

本节介绍了checkpoint中用于刷盘的函数:BufferSync,该函数Write out all dirty buffers in the pool免费云主机域名(把缓冲池中所有脏页持久化到物理存储中). 值得一提的是:checkpoint只会处理在ch…