Autonomicity in Oracle Database Management System

Human world is becoming more and more dependent on computers and information technology (IT). The autonomic capabilities in computers and IT have become the need of the day. These capabilities in software and systems increase performance, accuracy, availability and reliability with less or no human intervention (HI). Database has become the integral part of information system in most of the organizations. Databases are growing w.r.t size, functionality, heterogeneity and due to this their manageability needs more attention. Autonomic capabilities in Database Management Systems (DBMSs) are also essential for ease of management, cost of maintenance and hide the low level complexities from end users. With autonomic capabilities administrators can perform higher-level tasks. The DBMS that has the ability to manage itself according to the environment and resources without any human intervention is known as Autonomic DBMS (ADBMS). The paper explores and analyzes the autonomic components of Oracle by considering autonomic characteristics. This analysis illustrates how different components of Oracle manage itself autonomically. The research is focused to find and earmark those areas in Oracle where the human intervention is required. We have performed the same type of research over Microsoft SQL Server and DB2 [1, 2]. A comparison of autonomic components of Oracle with SQL Server is provided to show their autonomic status.

[1]  Gail E. Kaiser,et al.  Self-managing systems: a control theory foundation , 2005, 12th IEEE International Conference and Workshops on the Engineering of Computer-Based Systems (ECBS'05).

[2]  David L. Cohn,et al.  Autonomic Computing , 2003, ISADS.

[3]  Jeffrey O. Kephart,et al.  An architectural approach to autonomic computing , 2004 .

[4]  Mian M. Awais,et al.  Autonomic Computing in SQL Server , 2008, Seventh IEEE/ACIS International Conference on Computer and Information Science (icis 2008).

[5]  Richard Murch,et al.  Autonomic Computing , 2004 .

[6]  Jeffrey O. Kephart,et al.  An architectural approach to autonomic computing , 2004, International Conference on Autonomic Computing, 2004. Proceedings..

[7]  Benoît Dageville,et al.  Automatic SQL Tuning in Oracle 10g , 2004, VLDB.

[8]  Sam Lightstone,et al.  Toward autonomic computing with DB2 universal database , 2002, SGMD.

[9]  Salim Hariri,et al.  Autonomic Computing: An Overview , 2004, UPP.

[10]  Mian M. Awais,et al.  Autonomic Success in Database Management Systems , 2009, 2009 Eighth IEEE/ACIS International Conference on Computer and Information Science.

[11]  Said Elnaffar,et al.  Today's DBMSs: how autonomic are they , 2003, 14th International Workshop on Database and Expert Systems Applications, 2003. Proceedings..

[12]  Rrio Op-amps.  FEATURES , 2008 .

[13]  Graham Wood,et al.  Automatic Performance Diagnosis and Tuning in Oracle , 2005, CIDR.

[14]  Basit Raza,et al.  Autonomicity in Universal Database DB2 , 2009, 2009 Eighth IEEE/ACIS International Conference on Computer and Information Science.