A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2015; you can also visit the original URL.
The file type is application/pdf.
Filters
Automatic SQL Tuning in Oracle 10g
[chapter]
2004
Proceedings 2004 VLDB Conference
Preserved Fulltext
Basic Concepts
[chapter]
2011
Oracle Database Performance and Scalability
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2011
International Conference on Aerospace Sciences and Aviation Technology
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2019; you can also visit the original URL.
The file type is application/pdf.
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
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
: 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
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2013
Journal of Information Technology & Software Engineering
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
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
2019
ВІСНИК СХІДНОУКРАЇНСЬКОГО НАЦІОНАЛЬНОГО УНІВЕРСИТЕТУ імені Володимира Даля
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
[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
2010
SIGMOD record
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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]
2010
Lecture Notes in Computer Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2010
Database Systems Journal
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2009
2009 33rd Annual IEEE Software Engineering Workshop
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2006
20th International Conference on Advanced Information Networking and Applications - Volume 1 (AINA'06)
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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]
2002
VLDB '02: Proceedings of the 28th International Conference on Very Large Databases
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2004; you can also visit the original URL.
The file type is application/pdf.
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
2021
Journal of Information and Data Management
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2021; you can also visit the original URL.
The file type is application/pdf.
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
2006
2006 12th Pacific Rim International Symposium on Dependable Computing (PRDC'06)
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2008; you can also visit the original URL.
The file type is application/pdf.
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