Hi there,
sorry to dig out this old thread...
Our setup:
DB: Oracle 10G 10.2.0.2.0
Webserver: Solaris Coolstack
Moodle 1.9.2+: 14000+users - 400+courses
Last week, our setup hung at ~60 concurrent users/min.
We now changed the config-table-clob to varchar...and so far it looks ok...
Why isn't this important information in the oracle moodle-docs (
http://docs.moodle.org/en/Installing_Oracle_for_PHP)?!Do we have to change it back to clob, when we update to the next moodle-version?
Should we also change the cache_text-clob to varchar...? (Or other clobs in tables?)
Why does Moodle use clobs and not varchar2(4000) fields at all?
Are there any other patches or informations from you core-moodle-developers we could use for our setup before moodle 2.0 is released...?!
Maybe other
blog-articles, docs, forum posts, etc. about moodle-oracle-performance we here don't know about...?!
Thanks for your help!