Invalid SID

Invalid SID

Postby csadler » Sun 01 Feb 2009 19:37


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.
Posts: 2
Joined: Fri 12 Sep 2008 14:18

Postby Shalex » Mon 02 Feb 2009 11:12

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.
Devart Team
Posts: 7888
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for Oracle