ver 4.75.42.0
direct mode
I have a background thread doing database updates while a foreground thread updates the screen (counts) also selecting from the database.
It there is a lot of records and I push it hard I get an exception from the CoreLab of "Invalid SID"
I'm connecting to oracle 10G XE version. I bumped the sessions up to 250 and process to 200 and this seemed to help.
Is this a resource issue in oracle?
Thanks very much in advance for any pointers.