oracle concurrent program session and sql
SELECT req.request_id,
req.logfile_node_name node,
req.oracle_process_id,
req.enable_trace,
dest.VALUE || '/' || lower(dbnm.VALUE) || '_ora_' ||
oracle_process_id || '.trc' trace_filename,
prog.user_concurrent_program_name,
execname.execution_file_name,
execname.subroutine_name,
phase_code,
status_code,
ses.sid,
ses.serial#,
ses.module,
ses.machine
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 1 = 1
AND req.request_id = 21442588
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;
SELECT osuser,
username,
sql_text
FROM v$session a,
v$sqltext b
WHERE a.sql_address = b.address
AND a.sid=3112
ORDER BY address,
piece;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/59792/viewspace-1051021/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle EBS Submit Concurrent Program from Self-Service Application: FNDCPSRSSSWAOracleMITAPP
- FNDCPSRSSSWA:Oracle EBS Submit Concurrent Program from Self-Service ApplicationOracleMITAPP
- 提交一個併發請求(Concurrent Program)
- How To Export a Concurrent Program and Executable Using Fndload ?Export
- 透過CPU記憶體佔用情況,找出Oracle的session對應的program記憶體OracleSession
- Oracle SQL 跟蹤 --- dbms_system.set_sql_trace_in_sessionOracleSQLSession
- Oracle Scheduler(5)job呼叫programOracle
- Compilation of Views and PL/SQL Program Units (242)ViewSQL
- PL/SQL Program Units and the Shared Pool (89)SQL
- oracle實用sql(5)--session相關資訊OracleSQLSession
- the program list about oracle database in SAP systemOracleDatabase
- 查詢oracle比較慢的session和sqlOracleSessionSQL
- Oracle Scheduler(4)job呼叫program和scheduleOracle
- 查詢oracle比較慢的session和SQL[轉]OracleSessionSQL
- trace top sql sessionSQLSession
- Oracle session traceOracleSession
- Oracle kill sessionOracleSession
- Oracle 查詢某個session正在執行的sql語句OracleSessionSQL
- EBS R12的Concurrent Request ID和資料庫Session ID的關聯資料庫Session
- Oracle OCP 1Z0-053 (Schedule&Program&Job)Oracle
- 【ABAP】FTP ProgramFTP
- Oracle 會話(Session)Oracle會話Session
- Oracle kill session scriptOracleSession
- ORACLE SESSION 和 PROCESSOracleSession
- oracle_kill_sessionOracleSession
- Oracle session總結OracleSession
- Oracle中Kill sessionOracleSession
- Oracle批量kill sessionOracleSession
- 【kill session】Oracle 徹底 kill session(轉載)SessionOracle
- 【Oracle】-【v$session】v$session的SNIPED狀態OracleSession
- [Oracle Script] check active sessionOracleSession
- Oracle 徹底 kill sessionOracleSession
- oracle session阻塞查詢OracleSession
- ORACLE中的KILLED SESSIONOracleSession
- Oracle wait interface -- sessionOracleAISession
- Oracle中Kill session [轉]OracleSession
- Spark Driver Program剖析Spark
- Registering a program on the GatewayGateway