investigatingtheeffectsofliteralsqlonoracleperformance-itideas.docVIP

Piranhas in the Pool,SQL Performance Killers Investigating the effects of literal SQL on Oracle performance John BeresniewiczPrecise Software Solutions Contents Summary 2 Introduction 2 The Problem: Non-sharable SQL 2 Initialization Parameters 6 Testing the Performance of High-Volume Literal SQL 8 Oracle 8.1.5 Tests 12 Oracle 8.1.6 Tests 15 Analysis of 8.1.6 Results 17 Conclusion 18 Acknowledgements 19 Appendix 20 Summary This paper investigates the effects of non-sharable SQL on Oracle performance and presents quantitative results of controlled testing of the issue. Oracle shared pool and