Forum OpenACS Q&A: Re: ACS3/Oracle DATA Model Question

8: Re: ACS3/Oracle DATA Model Question (response to 1)

Posted by Don Baccus on 06/17/04 01:03 AM

Once upon a time data was never deleted from that table ... that's probably the problem.

Miguel, I suggest you empty 99.9% of that table as Dirk suggested, and check your tcl library to see if there's any proc being scheduled to empty it periodically, and the security code tcl library file to see if it attempts to delete rows from that table when doing session management.

I think we fixed this in our latest OpenACS 3.x versions (as opposed to not fixing until we took over ACS 4.x) so you might be able to use our sources as a resource, even though they're PostgreSQL only.

9: Re: ACS3/Oracle DATA Model Question (response to 8)

Posted by Miguel Albuquerque on 06/17/04 04:25 PM

Thanks Don, you are right, there is no schedule proc for that table...

So are you suggesting to use the code from an early ACS 4.x version in order to port it to Oracle, or can I still find the latest OACS3.x code from CVS or other ?

Anyway thank you all. Just one more question : how do i check the version of the Oracle driver?

This is all i could find about it:

[17/Jun/2004:11:19:01][23909.16384][-main-] Notice: modload: loading '/opt/aolserver/bin/ora8.so'
[17/Jun/2004:11:19:01][23909.16384][-main-] Notice: ora8 driver LobBufferSize = 16384
[17/Jun/2004:11:19:01][23909.16384][-main-] Notice: ora8 driver PrefetchRows = 0
[17/Jun/2004:11:19:01][23909.16384][-main-] Notice: ora8 driver PrefetchMemory = 0
[17/Jun/2004:11:19:02][23909.16384][-main-] Notice: dbdrv: opening database 'ora8:'

Cheers

10: Re: ACS3/Oracle DATA Model Question (response to 9)

Posted by Miguel Albuquerque on 06/17/04 04:31 PM

And by the way, i've deleted 99% of the table and damn what a difference! 😉

Thnx !