table 7: ptime test.sh
8. caveat
the preceding code is not multithreaded. for oracle clients that are multithreaded, the write access to the cache variables needs to be mutex protected or synchronized.
9. conclusion
caching the file oraus.msb in memory improves the performance of oracle clients. even though the performance gain observed in the test program is about 1000 percent, the gain when running a really big oracle client application might not be more than 2 to 15 percent, due to other i/o contentions. this gain can be achieved without any code changes to the client application.
10. acknowledgments
i would like to thank teresa riege (sun) and thomas yen (kenan/bp billing platform, csg systems) for their contributions and help in testing this utility during the 2002 kenan/bp study (see related article listed in references). i would also like to thank my colleagues at mde (ipe) for supporting me during this project.
i would like also to thank ben humphreys, technical support specialist, sun, who made the 64-bit modifications to the code.
11. references
- nagendra nagarajayya, s.r. venkatramanan, "fast sockets, an interprocess communication library to boost application performance"
- sun product documentation site
- oracle metalink (for news, problems, and bugs)
- csg kenan/bp exceeds billing needs of largest telecom service providers in scalability test
appendix: test programs and wrappers
the sample code is being made available by sun merely as a convenience to you. the sample code below is provided "as is." sun makes no warranties of any kind whatsoever with respect to the sample code.
all express or implied conditions, representations and warranties, including any warranty of non-infringement or implied warranty of merchantability or fitness for a particular purpose, are hereby disclaimed and excluded to the extent allowed by applicable law. in no event will sun be liable for any lost revenue, profit or data, or for direct, special, indirect, consequential, incidental, or punitive damages however caused and regardless of the theory of liability arising out of the use of or inability to use the sample code, even if sun has been advised of the possibility of such damages.
