SQL> select sid,type,status_code,status from v$logstdby_process;
SID TYPE STATUS_CODE STATUS
---------- ---------------------------------------------------------------------------------------------------------------------------------------
1074 COORDINATOR 16116 ORA-16116: no work available
1050 READER 16116 ORA-16116: no work available
1071 BUILDER 16116 ORA-16116: no work available
1072 PREPARER 16116 ORA-16116: no work available
1069 ANALYZER 16116 ORA-16116: no work available
1061 APPLIER 16116 ORA-16116: no work available
1064 APPLIER 16116 ORA-16116: no work available
1060 APPLIER 16116 ORA-16116: no work available
1070 APPLIER 16116 ORA-16116: no work available
1058 APPLIER 16116 ORA-16116: no work available
10 rows selected.
