INSTANCE-WORKINGSLOW

NODE_NAME       SUPPORT_DB   SUPPORT_CP   SUPPORT_ADMIN   SUPPORT_WEB  SUPPORT_FORMS   STATUS     HOST            DOMAIN

--------------- ------------ ------------ --------------- ------------ --------------- ---------- --------------- --------------------

AUTHENTICATION  N            N            N               N            N

LUPIN-PROD  N            Y            Y               Y            Y               Y          LUPIN-PROD  lupin.com

LUPIN-PROD-server2  N            Y            Y               Y            Y               Y          LUPIN-PROD-server2  lupin.com

LUPIN-PROD-dbserver  Y            N            N               N            N               Y          LUPIN-PROD-dbserver  lupin.com

NO LOCKS

=========

SQL> select name from v$database;

NAME

---------

DEV1EBS

SQL> set pages 300 lines 300

SELECT inst_id, DECODE(request,0,'Holder: ','Waiter: ')|| sid sess, id1, id2, lmode,request, type

FROM GV$LOCK WHERE (id1, id2, type) IN (SELECT id1, id2, type FROM GV$LOCK WHERE request>0)

ORDER BY id1, request;SQL>   2    3

no rows selected

NO CPU PERFORMANCE EFFECTED ON DB AND CM NODE AS WELL

================================================

[appldev1@LUPIN-PROD-server2 ~]$ CONCSUB apps/apps_dev1 SYSADMIN 'System Administrator' SYSADMIN WAIT=N CONCURRENT FND FNDSCURS > rleq.txt

[appldev1@LUPIN-PROD-server2 ~]$ cat rleq.txt

Submitted request 16270034 for CONCURRENT FND FNDSCURS

CONCURENT_REQUEST STATUS CHECKING

=================================

 col USER_CONCURRENT_PROGRAM_NAME for a20

 col CONCURRENT_PROGRAM_ID for a20

col REQUEST_ID for a20

 col ACTUAL_START_DATE for a10

 col REQUEST_ID for a40

spool healthcheck.txt

set lines 300

select a.user_concurrent_program_name,a.CONCURRENT_PROGRAM_ID ,REQUEST_ID,REQUEST_TYPE,PHASE_CODE,STATUS_CODE,ACTUAL_START_DATE,COMPLETION_TEXT from fnd_concurrent_programs_tl a, fnd_concurrent_requests b

where a.concurrent_program_id=b.concurrent_program_id and program_application_id=0 and REQUEST_ID=&ID;

spool off;

exit;

1656591

USER_CONCURRENT_PROG CONCURRENT_PROGRAM_ID REQUEST_ID R P S ACTUAL_STA COMPLETION_TEXT

-------------------- --------------------- ---------- - - - ---------- --------------------

Активные пользовател            ########## ##########   C C 02-JUN-20  Normal completion

и

Usuarios Activos                ########## ##########   C C 02-JUN-20  Normal completion

Aktivni korisnik                ########## ##########   C C 02-JUN-20  Normal completion

Active Users                    ########## ##########   C C 02-JUN-20  Normal completion

Aktywni użytkownicy             ########## ##########   C C 02-JUN-20  Normal completion

Aktívni používatelia            ########## ##########   C C 02-JUN-20  Normal completion

6 rows selected.

  col OWNER for a10

  col DIRECTORY_NAME for a30

  col DIRECTORY_PATH for a30

  col ORIGIN_CON_ID for a10

  select * from dba_directories where DIRECTORY_NAME like '%&DIRNME%';

Enter value for dirnme: XXGLO_PA_DRAFT_INV_DIR