Hi all,
I have problem to set up a persistent oracle connection in child thread.
We have a massive batch process dealing with large data. Application was written and impossible to be rewritten. I am trying to extract the most time consuming data fetching and put it into a dedicated child thread.
So main thread will only process(including quick fetch from DB) and child can constantly fetch. Data will be flushed from child to main by global variables.
However I can't see any way to obtain a dedicated DB connection in pthread child.
I got core when main and child both try to access DB.
I tried using context, allocate different context to main and child, but not working, still same core.
If I stop main accessing DB, then child is fetching continuously.
Can some one help me out or give some code I can refer to?
Thanks in advance!