#DateForumTypeThreadPost
925 Sep 2009 @ 02:58 PDTDatabaseReplyInvalid session mode for procedure executionThanks Dieter.
824 Sep 2009 @ 08:26 PDTDatabaseTopicInvalid session mode for procedure executionAm facing this error- 'Invalid session mode for procedure execution' while calling a proc through Java/JDBC. I am guessing that this error has something to do with the db layer. Solution/Fix?
704 Sep 2009 @ 07:45 PDTDatabaseReplyMacros vs Stored ProceduresThanks.
604 Sep 2009 @ 07:44 PDTDatabaseReplyStats collection frequencyThanks.
503 Sep 2009 @ 09:28 PDTDatabaseTopicStats collection frequencyIs there an ideal frequency at which stats should be collected? Or is it on a case by case basis where in if needed, daily stats collection should also be done? Inputs appreciated. Thanks, ...
427 Aug 2009 @ 01:59 PDTDatabaseTopicMacros vs Stored ProceduresWe currently have multiple macros being used via one transaction call that potentially makes it dead lock prone. Would it be better to convert those macros into 1 SP? On these lines, any advant...
312 Aug 2009 @ 01:52 PDTDatabaseReplyDeadlocks on Join Indexes- How/What/Why?And Dieter, to add to my above post, what kind of additional info would one need to address this clearly? Thanks, ShyGuy
212 Aug 2009 @ 01:39 PDTDatabaseReplyDeadlocks on Join Indexes- How/What/Why?Thanks Dieter for shedding some light on this. So you mean to say that at the time of insert, somehow there are potential duplicate row-hash values across users and that leads to row-hash lock...
110 Aug 2009 @ 02:16 PDTDatabaseTopicDeadlocks on Join Indexes- How/What/Why?All, I have a table, CUSTOMER and 3 Join Indexes- CUST_JI1, CUST_JI2, CUST_JI3 defined on the same, say for columns- cust_address, cust_phone, cust_email. During peak hours, users insert data i...