A Framework for Automated Database TuningUsing Dynamic SGA Parameters and Basic Operating System Utilities

Hitesh KUMAR Sharma (), Aditya Shastri () and Ranjit Biswas ()
Additional contact information
Hitesh KUMAR Sharma: University of Petroleum & Energy Studies
Aditya Shastri: Banasthali University, Rajasthan,India
Ranjit Biswas: CSE Dept, Jamia Hamdard (Hamdard University)

Database Systems Journal, 2012, vol. 3, issue 4, 25-32

Abstract: In present scenario the manual work (Done by Human) cost more to an organization than the automatic work ( Done by Machine)and the ratio is increasing day by day as per the tremendous increment in Machine (Hardware + Software) Intelligence. We are moving towards the world where the Machines will be able to perform better than today by their own intelligence. They will adjust themselves as per the customer’s performance need. But to make this dream true, lots of human efforts (Theoretical and Practical) are needed to increase the capability of Machines to take their own decision and make the future free from manual work and reduce the working cost. Our life is covered with the different types of systems working around. The information system is one of them. All businesses are having the base by this system. So there is the most preference job of the IT researcher to make the Information system self-Manageable. The Development of well-established frameworks are needed to made them Auto-tuned is the basic need of the current business.The DBMS vendors are also providing the Auto-Tune packages with their DBMS Application. But they charge for these Auto-Tune packages. This extra cost of packages can be eliminated by using some basic Operating system utilities (e.g. VB Script, Task Scheduler, Batch Files, and Graphical Utility etc.). We have designed a working framework for Automatic Tuning of DBMS by using the Basic Utilities of Operating System (e.g. Windows) .These utilities will collect the statistics of SGA dynamic Parameters. The Framework will automatically analyze these SGA Parameter statistics and give suggestions fordiagnose the problem. In this paper we have presented that framework with practical Implementation.

Keywords: SGA; SGA Dynamic Parameters; Database Tuning; DBA; Automated Tuning; TOC (search for similar items in EconPapers)
Date: 2012
References: Add references at CitEc
Citations:

Downloads: (external link)
http://dbjournal.ro/archive/10/10_3.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:aes:dbjour:v:3:y:2012:i:4:p:25-32

Access Statistics for this article

Database Systems Journal is currently edited by Ion Lungu

More articles in Database Systems Journal from Academy of Economic Studies - Bucharest, Romania Contact information at EDIRC.
Bibliographic data for series maintained by Adela Bara ().