We have a requirement where we have to support more than 100 jdbc sessions inserting nearly 1000 rows per second.
Can you please help em with best pracitces for implementing something like this.
1: Would a PPI based on source key help (My guess is no ,Since it would only be useful while retreival )
2: Is it neccessarry to change jdbc and use TPT or Tpump instead.
3: Would making tables as NoPi help avoiding contention/deadlock ?.