Anuroop Challa

 View running queries in postgreSQL： SELECT * FROM pg_stat_activity;

 Golden gate commands for ggsci: $ ./ggsci GGSCI> info all - Displays status of all Extract, Replicat, and Manager processes.  Start / Stop Processes • start extract <extract_name>   --- Start Extract process • stop extract <extract_name>   --- Stop Extract process • start replicat <replicat_name>  --- Start Replicat process • stop replicat <replicat_name>  --- Stop Replicat process check info about individual. • info extract <extract_name>, detail   -- Detailed info about Extract • info replicat <replicat_name>, detail   -- Detailed info about Replicat • info mgr - Displays Manager process status Check Lag • lag extract <extract_name>   -- Shows Extract lag • lag replicat <replicat_name>   -- Shows Replicat lag View Statistics • stats extract <extract_name>   -- Displays Extract statistics • stats replicat <replicat_...