121 Hits in 3.7 sec

Automatic SQL Tuning in Oracle 10g [chapter]

Benoit Dageville, Dinesh Das, Karl Dias, Khaled Yagoub, Mohamed Zait, Mohamed Ziauddin
2004 Proceedings 2004 VLDB Conference  
doi:10.1016/b978-012088469-8.50096-6 dblp:conf/vldb/DagevilleDDYZZ04 fatcat:z5gh4dwhpjhtbgjrpskylzn6aq

Basic Concepts [chapter]

2011 Oracle Database Performance and Scalability  
Each title brings the principles and theory of programming in-the-large and industrial strength software into focus.  ...  Oracle 10g introduced new features in this area to facilitate SQL tuning. This feature set is summarized as follows: . Transportable SQL Tuning Sets.  ...  Oracle 10g enables SQL Tuning Sets to be exported from one system and imported into another system.  ... 
doi:10.1002/9781118135532.ch1 fatcat:itsggugltfdqvis5qndwmthbku

Database Performance Sensitivity for Malicious Transactions Detection Mechanisms

W. Shalish, A. Ghalwash, H. El-Deeb, G. Salama, H. Mohamed, K. Badran
2011 International Conference on Aerospace Sciences and Aviation Technology  
This paper presents implementation of three mechanisms for detection of malicious transactions in the Oracle 10g DBMS, and investigates the performance of the three mechanisms using a telephone database  ...  Most of an organization's sensitive and proprietary data resides in a Database Management System (DBMS).  ...  Three configurations have been considered in the evaluation of the impact on the database performance: First, Baseline (Oracle 10g fully tuned for performance and without using the audit mechanism); Second  ... 
doi:10.21608/asat.2011.23379 fatcat:5po7stebp5cnpjr4k33nffjv4u

Enhancing ETL Performance with Warehouse Builder

2013 Database Systems Journal  
: data warehouses (using Oracle Warehouse Builder).  ...  We live in a dynamic world, in a permanent move, were performance of information systems continually increases.  ...  Using transportable modules, you can copy large volumes of data and metadata, from an Oracle 9i database to another Oracle 9i database, and from an Oracle 10g database to another Oracle 10g database or  ... 
doaj:9a040547f3b74cb9be62064542c2cd1e fatcat:joigkcrkh5apzlarxpme4hsxkq

SGA Dynamic Parameters: The Core Components of Automated Database Tuning

2014 Database Systems Journal  
So the memory management for the DBMS's components stored in the main memory of the server is the critical task for a DBA.  ...  The management of the various components stored in the main memory is the key challenge to get the desired throughput from an application running on the server.  ...  Conclusion In this paper we have explained the memory architecture of one of the leading DBMS (i.e. Oracle 10g). It describes the instance configuration of oracle database server.  ... 
doaj:f56a1706b9a242cd97831711b610dd09 fatcat:cw6f3vrtofd3petwelwkywcnsu

Architecture, Design, Development, and Usage of ODBDetective 1.0

Christian Mancas Alina Iuliana Dicu
2013 Journal of Information Technology & Software Engineering  
Moreover, even this first ODBDetective version also allows for storing semantic decision data on desired db scheme improvements, which will prove very useful to automatic improvement code generation in  ...  ODBDetective is an Oracle database (Oracle) metadata mining tool for detecting violations of some crucial database (db) design, implementation, usage, and optimization best practice rules (bpr).  ...  For example, Oracle provides Automatic Workload Repositories (AWR) views [1] , Automatic SQL Tuning [2] , SQL Access Advisor (including Partition Advisor), Real-time SQL Monitoring (the latter three  ... 
doi:10.4172/2165-7866.1000119 fatcat:f4g3ouohvvgbbc5vti2kke264a

Database query optimization

М.В. Нестеров, Д.Е. Бакитько, A.O. Михайлова
[15] For Oracle, automatic database gathering of all optimizer statistics recommended. Since the release of Oracle Database 10g, a statistics collection tool has been introduced.  ...  plan expressions by headers. 5) DISPLAY_SQLSET -output execution plan, which stored in the SQL Tuning set.  ... 
doi:10.33216/1998-7927-2019-253-5-78-83 fatcat:4u6p35hctvc6dadappaddpswrm

The ubiquitous DBMS

Kyu-Young Whang, Il-Yeol Song, Taek-Yoon Kim, Ki-Hoon Lee
2010 SIGMOD record  
In this paper, we first review the requirements of the UDBMS.  ...  Advancement in mobile computing technologies has prompted strong needs for database systems that can be used in small devices such as sensors, cellular phones, PDAs, car navigators, and Ultra Mobile PCs  ...  Commercial products include IBM DB2 Everyplace, Oracle 10g Lite, Oracle Berkeley DB, and Microsoft SQL Server CE.  ... 
doi:10.1145/1815948.1815952 fatcat:wmqq3kfpmrbv3bfimq2yy43bfm

The Ubiquitous DBMS [chapter]

Kyu-Young Whang
2010 Lecture Notes in Computer Science  
In this paper, we first review the requirements of the UDBMS.  ...  Advancement in mobile computing technologies has prompted strong needs for database systems that can be used in small devices such as sensors, cellular phones, PDAs, car navigators, and Ultra Mobile PCs  ...  Commercial products include IBM DB2 Everyplace, Oracle 10g Lite, Oracle Berkeley DB, and Microsoft SQL Server CE.  ... 
doi:10.1007/978-3-642-17616-6_4 fatcat:yruivqrxpvbjtnwj4jcxb63aeu

Solutions for improving data extraction from virtual data warehouses

Adela BARA
2010 Database Systems Journal  
Some of the techniques that can be applied to reduce the cost of execution for improving query performance in BI systems will be presented in this paper.  ...  The data warehousing project's team is always confronted with low performance in data extraction.  ...  The database management system (DBMS) is Oracle Database 10g Release 2 and the reports were developed in Oracle Business Intelligence Suite (OBI).  ... 
doaj:e4e7ed6d2ce14ab581d09b063857b804 fatcat:yuqk3rja7fgmrcn4ldch2pjacq

A Knowledge Representation and Data Provenance Model to Self-Tuning Database Systems

Ana Carolina Almeida, Sergio Lifschitz, Karin Breitman
2009 2009 33rd Annual IEEE Software Engineering Workshop  
Most autonomic database systems do not explicit their decision rationale behind tuning activities. Consequently, users may not trust some of the automatic tuning decisions.  ...  The proposed approach consists in transforming log results into a userfriendly knowledge representation, based on the graphical representation for OWL.  ...  For example, Oracle Database 10g has a self-tuning component called the SQL Tuning Advisor [18] .  ... 
doi:10.1109/sew.2009.25 dblp:conf/sew/AlmeidaLB09 fatcat:oqvmli5sibckxejmmitliahhkm

XML-Enabled Relational Database for XML Document Update

E. Pardede, J.W. Rahayu, D. Taniar
2006 20th International Conference on Advanced Information Networking and Applications - Volume 1 (AINA'06)  
Regarding this matter, our paper search for deciding whether an XML-enabled relational database, as a relatively mature technology, or native XML database is suitable for storing XML data in a way that  ...  databases and their products to store XML Oracle 10g Release 1: Oracle 10g was chosen because provides several advantages even in this type XML will Oracle claims it was one of the first, if not the first  ...  To run the XMark queries Fig. 1 : The Proposed Experiments Architecture in Oracle, SQL queries was used in SQL-Plus environment The XMark queries were rewrote and converted from using a select clause  ... 
doi:10.1109/aina.2006.354 dblp:conf/aina/PardedeRT06 fatcat:httkpgaikjehrcrdp2w25ownlu

SQL Memory Management in Oracle9i [chapter]

Benoît Dageville, Mohamed Zait
2002 VLDB '02: Proceedings of the 28th International Conference on Very Large Databases  
This paper presents a new model used in Oracle9i to manage memory for database operators. This approach is automatic, adaptive and robust.  ...  Several research projects addressed this problem in the past, but very few commercial systems proposed a comprehensive solution to managing memory used by SQL operators in a database application with a  ...  PGA Advice Statistics Oracle9i has many manageability features to assist the DBA in tuning the performance of an Oracle instance.  ... 
doi:10.1016/b978-155860869-6/50095-0 dblp:conf/vldb/DagevilleZ02 fatcat:n2ihlcyktja3pehcp5zfje2ujm

Outer-Tuning: an Ontology-based Extensible Framework for Supporting Database Automatic Tuning

Raphael Marins, Rafael Pereira de Oliveira, Edward Hermann Haeusler, Sérgio Lifschitz, Daniel Schwabe, Ana Carolina Almeida
2021 Journal of Information and Data Management  
This paper presents the Outer-Tuning framework, which aims to support the (semi) automatic tuning of relational database systems through a domain-specific ontology.  ...  In this paper we focus on the main aspects of the Outer-Tuning component-based architecture. We also give an overview of our tool in practice.  ...  semi-automatic Knobs No Oracle Yes No [Dias et al. 2005] Indexes [Alhadi and Ahmad 2012] Outer-Tuning automatic semi-automatic Indexes MVs Yes PostgreSQL Oracle, MySQL Yes Yes  ... 
doi:10.5753/jidm.2021.1984 fatcat:3ywj47hgtnhitkz2sdp3jhtyle

Towards Timely ACID Transactions in DBMS

Marco Vieira, Antonio Costa, Henrique Madeira
2006 2006 12th Pacific Rim International Symposium on Dependable Computing (PRDC'06)  
The paper illustrates the proposed programming model with a practical example using the Oracle 10g DBMS running a performance benchmark for real-time database applications.  ...  In spite of the importance of timeliness requirements in database applications, typical commercial DBMS do not assure any temporal properties, not even the detection of the cases when the transaction takes  ...  For that reason we have chosen Oracle 10g [11] , which has been tuned based on the results from a previous work on the evaluation of the Oracle performance and recoverability [12] .  ... 
doi:10.1109/prdc.2006.63 dblp:conf/prdc/VieiraCM06 fatcat:kfnyqoyzizb5zjdiwiwo3nlroi
« Previous Showing results 1 — 15 out of 121 results