Hi David,
If it's yes what needs to be done in order to stabilize this issue??
Thanks in advance.
Regards,
Pavan
On Jan 23, 2018 8:15 PM, "David G. Johnston" <david.g.johnston@xxxxxxxxx> wrote:
" checkpoints are frequently occurring (1second apart). Consider increasing checkpoint_segements parameter".The custom on these lists is to bottom or inline post.This tends to appear when someone decide to write a load script of the form:INSERT INTO tbl (cols) VALUES (...);INSERT INTO tbl (cols) VALUES (...);[repeat many, many, times](note the lack of BEGIN/END, single transaction help mitigate it somewhat)David J.