Skip to main content

Güven’s Blog, Web, Software, Database and About Life …

  • CONTACT
  • ABOUT ME

Tag: concurrent manager

HOW TO FIND SESSION ID OF A CONCURRENT REQUEST

26 June 201509 January 2018 Guven Leave a comment

You can use the following query to find Session Id of a Concurrent Request:

View Code
1
2
3
4
5
 SELECT ses.sid AS session_id, ses.serial#, fcr.request_id
  FROM v$session ses, v$process pro, fnd_concurrent_requests fcr
 WHERE     ses.paddr = pro.addr
       AND pro.spid = fcr.oracle_process_id
       AND fcr.request_id = :concurrentRequestId;

:concurrentRequestId is painted red area in the image below.

concurrent_manager

Aliexpress TR

Categories

  • Blogger (1)
  • Database (19)
  • General (3)
  • Internet (5)
  • Java (1)
  • Oracle Application Framework (OAF) (3)
  • Oracle ERP (11)
  • Oracle Forms (5)
  • Oracle Workflow (2)
  • PL-SQL (12)
  • Programing (24)
  • Software (7)
  • Technology (1)
  • Training (20)
    • Advanced SQL Training (5)
    • SQL Training (11)
  • Windows (5)
  • Wordpress (3)
Aliexpress INT
Flag Counter

Recent Comments

  • berkant on [Çözüm] VMWare Virtual Machine “Failed to Lock the File” Error
  • Mümin Köykıran on [Çözüm] VMWare Virtual Machine “Failed to Lock the File” Error
  • Alper on [Çözüm] VMWare Virtual Machine “Failed to Lock the File” Error
  • ArmgnCn on [Çözüm] VMWare Virtual Machine “Failed to Lock the File” Error
  • Ferhat on Wampserver Çalışmıyor? Çözümü (Yardım)

Recent Posts

  • [Solved] VMWare Virtual Machine “Failed to Lock the File” Error
  • How To Retry or Skip Workflow Oracle E-Business Suite?
  • Oracle 12c VARCHAR2 32K Extended Limit – Arttırılmış Boyut
  • Microsoft Visio Alternatifi Ücretsiz Uygulamalar
  • Oracle 12c Invisible Column – Gizli Kolon

Tags

12c acces advanced bilim ilaç database ddl ders dml donanım e-business suite ebs Error eğitim form builder Global Management Challenge gmc google koşul like microsoft mssql mysql oracle plsql problem program script select server seçme sorgu sql syntax söz dizimi tablo training veritabanı version voltran where Windows Wordpress yarışma Yazılım yıldız
sparkling Theme by Colorlib Powered by WordPress