Query to see OS process id given to Concurrent Manager Fndlibr

Query to see OS process id given to Concurrent Manager (Fndlibr)

SELECT a.concurrent_queue_name, SUBSTR(b.os_process_id,0,10) "OS Proc", b.oracle_process_id "Oracle ID", b.process_status_code

FROM fnd_concurrent_queues a

,fnd_concurrent_processes b

WHERE a.concurrent_queue_id=b.concurrent_queue_id

AND b.process_status_code='A'

ORDER BY b.process_status_code;

Upgrade 12.1.1 to 12.1.3

Document ID : 1066312.1


https://supporthtml.oracle.com/ep/faces/secure/km/DocumentDisplay.jspx?id=1066312.1

Temp File add

SQL> select name,bytes/1024/1024 from v$tempfile;

NAME                                                                               BYTES/1024/1024
---------------------------------------------------------------------------------------------------
/oracle1/VIS1211/db/apps_st/data/temp1_01.dbf              16000
/oracle1/VIS1211/db/apps_st/data/temp2_01.dbf                  0

SQL> desc dba_tablespace_groups;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 GROUP_NAME                                NOT NULL VARCHAR2(30)
 TABLESPACE_NAME                           NOT NULL VARCHAR2(30)

SQL> select *from dba_tablespace_groups;

GROUP_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
TEMP                           TEMP2
TEMP                           TEMP1

sql> select a.name , b.name from V$tablespace a, V$tempfile b where a.TS#=b.TS#;

SQL> alter tablespace TEMP2 add tempfile '/oracle1/VIS1211/db/apps_st/data/temp3_01.dbf' size 100m;

Tablespace altered.

SQL>