Sorry for not providing more details. * We have converted to in-row storage of CLOBs almost two years ago. This reduced our database disk space usage very significantly as well as we saw a small performance improvement. I will revisit this with the DBA team and ensure this has not changed.
* We have bumped the memory of the mid tier to the maximum possible (1.5 gb). However we are fronting the Apache Tomcat server with IIS. I currently have a small project effort to remove IIS services from the mid-tier hosts. Sean, I will provide this information to our DBA team to compare to our current settings, thank you! Matt, I will be checking these forms today, thank you for the pointers. Did you discover this through database tuning activities or just trial an error? I have spent some time with our DBA team on performing tuning activities, however many of the queries are ITSM defined so we have little ability to make significant changes. Danny, I will be sending you an email shortly, thank you for your assistance. ~Jim _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
