關於OGG stats 命令的解釋,oggstats命令解釋
GGSCI (gg321) 19> stats extqdSending STATS request to EXTRACT EXTQD ...Start of Statistics at 2015-04-18 17:53:06.Output to /u02/ggs/dirdat/qd:Extracting from usera.taba to usea.taba:*** Total statistics since 2015-04-18 17:38:42 *** Total inserts 0.00 Total updates 2.00 Total befores 1.00 Total deletes 5.00---->此處的5表示:5條受到delete影響的記錄 或者說被delete 掉的5條記錄。而被delete 掉的這5條記錄,可以是由一個delete語句造成的。 Total discards 0.00 Total operations 8.00*** Daily statistics since 2015-04-18 17:38:42 *** Total inserts 0.00 Total updates 2.00 Total befores 1.00 Total deletes 5.00 Total discards 0.00 Total operations 8.00*** Hourly statistics since 2015-04-18 17:38:42 *** Total inserts 0.00 Total updates 2.00 Total befores 1.00 Total deletes 5.00 Total discards 0.00 Total operations 8.00*** Latest statistics since 2015-04-18 17:38:42 *** Total inserts 0.00 Total updates 2.00 Total befores 1.00 Total deletes 5.00 Total discards 0.00 Total operations 8.00End of Statistics.