Page 1 of 1

Invalid SID

Posted: Sun 01 Feb 2009 19:37
by csadler
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.

Posted: Mon 02 Feb 2009 11:12
by Shalex
We don't know the reason of such behaviour. Refer to the Oracle documentation or send me (alexsh*devart*com) a small test project that reproduces the problem. Please include definitions of database objects and avoid using third-party components.