Amazon RDS for Oracle で起動しているプロセスは V$PROCESS で確認できる。*1
$ export _JAVA_OPTIONS="-Duser.language=en -Duser.country=US" $ sql awsuser@orcl.******.ap-northeast-1.rds.amazonaws.com:1521/orcl Picked up _JAVA_OPTIONS: -Duser.language=en -Duser.country=US SQLcl: Release 4.2.0 Production on Sun Sep 10 12:27:40 2017 Copyright (c) 1982, 2017, Oracle. All rights reserved. New version: 4.1.0 available to download Password? (**********?) ************* Last Successful login time: Sun Sep 10 2017 12:27:49 +09:00 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> set sqlformat ansiconsole SQL> select * from v$process; ADDR PID SOSID SPID STID EXECUTION_TYPE PNAME USERNAME SERIAL# TERMINAL PROGRAM TRACEID TRACEFILE BACKGROUND LATCHWAIT LATCHSPIN PGA_USED_MEM PGA_ALLOC_MEM PGA_FREEABLE_MEM PGA_MAX_MEM CON_ID 0000000344B0E280 1 NONE 0 PSEUDO /rdsdbdata/log/diag/rdbms/orcl_a/ORCL/trace/ORCL_ora_0.trc 0 0 0 0 0 0000000344B0F028 2 12011 12011 12011 PROCESS PMON rdsdb 1 UNKNOWN oracle@ip-10-7-2-38 (PMON) /rdsdbdata/log/diag/rdbms/orcl_a/ORCL/trace/ORCL_pmon_12011.trc 1 797036 974508 0 974508 0 0000000344B0FDD0 3 12013 12013 12013 PROCESS PSP0 rdsdb 1 UNKNOWN oracle@ip-10-7-2-38 (PSP0) /rdsdbdata/log/diag/rdbms/orcl_a/ORCL/trace/ORCL_psp0_12013.trc 1 772748 949716 0 949716 0 0000000344B10B78 4 12015 12015 12015 PROCESS VKTM rdsdb 1 UNKNOWN oracle@ip-10-7-2-38 (VKTM) /rdsdbdata/log/diag/rdbms/orcl_a/ORCL/trace/ORCL_vktm_12015.trc 1 769508 949716 0 949716 0 0000000344B11920 5 12019 12019 12019 PROCESS GEN0 rdsdb 1 UNKNOWN oracle@ip-10-7-2-38 (GEN0) /rdsdbdata/log/diag/rdbms/orcl_a/ORCL/trace/ORCL_gen0_12019.trc 1 778644 958084 0 958084 0 （以下略）
参考
*1:クライアントはSQLclを使用
