Abstract
The magnitude of data in the concurrent databases is exponentially escalating with respect to time. This advent conveys a challenge to the database administrators and SQL developers in the arena of performance, due to incessant data accumulation and manipulation. As such, this paper proposes an approach to overcome these befalling sundry wait events in the internal database engine through Query and PL/SQL rewrite methodologies, and additional overhauling approaches to increase the data hit ratio. Our experimental progression and approaches evinced that CPU impact, wait events and other performance bottlenecks are minimized. This paper could serve as tuning tool to boost query as well as database performance by wait event tuning and can also oblige as a utility for database administrators, SQL programmers, database managers and database operators.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Myalapalli VK, Savarapu PR (2014) High performance SQL. In: 11th IEEE international conference on emerging trends in innovation and technology, Pune, India, Dec 2014
Myalapalli VK, Shiva MB (2015) An appraisal to optimize SQL queries. In: IEEE international conference on pervasive computing, Pune, India, Jan 2015
Myalapalli VK, Totakura TP, Geloth S (2015) Augmenting database performance via SQL tuning. In: IEEE international conference on energy systems and application, Pune, India, Oct 2015
Myalapalli VK, Teja BLR (2015) High performance PL/SQL programming. In: IEEE International conference on pervasive computing, Pune, India, Jan 2015
Myalapalli VK, Chakravarthy ASN, Reddy KP (2015) Accelerating SQL queries by unravelling performance bottlenecks in DBMS Engine. In: IEEE international conference on energy systems and application, Pune, India, Oct 2015
Myalapalli VK, Chakravarthy ASN (2014) A unified model for cherishing privacy in database system. In: IEEE international conference on networks and soft computing, Andhra Pradesh, India
Burleson DK, Celko J, Cook JP, Gulutzan P (2003) Advanced SQL database programmer handbook, August 20031st edn. Rampant Tech press
Mishra S, Beaulieu A (2002) Mastering oracle SQL April 2002 1st edn. O’Reilly Publishing
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2016 Springer Science+Business Media Singapore
About this chapter
Cite this chapter
Myalapalli, V.K. (2016). Wait Event Tuning in Database Engine. In: Chakrabarti, A., Sharma, N., Balas, V. (eds) Advances in Computing Applications. Springer, Singapore. https://doi.org/10.1007/978-981-10-2630-0_1
Download citation
DOI: https://doi.org/10.1007/978-981-10-2630-0_1
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-10-2629-4
Online ISBN: 978-981-10-2630-0
eBook Packages: Computer ScienceComputer Science (R0)