The “show analyze detail” results in “No process found for analyze service” and “Or invalid data source”
The command will only show the actions of the Capture process when the analyze is running. This is to monitor the analyze process. Here is a sample output:
sp_ctrl (alvsupu15:5438)> show analyze detail
Host: alvsupu15
Operations
Source Status Processed Since Total Backlog
---------- --------------- ---------- ------------------ ---------- ----------
o.ORA11GR2 Running 9 06-Dec-16 16:40:54 10 0
Last operation processed:
Redo log: 13490 Log offset: 1156624
INSERT in "SHA86"."TABLE1" at 12/06/16 16:41:28
Activation id : 30
Operations processed : 9
Transactions processed : 1
Analysis complete : 06-Dec-16 16:43:54
Once it terminates after the designated time duration of analyze, if the command is re-issued, it will return the messages:
No process found for analyze service.
Or invalid data source
The results of analyze can still be viewed by querying the file o.SID-analysis.actid located in log sub-directory under the variable directory where SID refers to the SID of the source database and the actid refers to the SharePlex activation ID.
