Oracle High Performance Tuning for 9i and 10g

Oracle High Performance Tuning for 9i and 10g
Publisher: Digital Press | ISBN: 1555583059 | edition 2004 | File type: CHM | 738 pages | 10,4 mb

There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration.
A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.
Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside independent blocks within applications or stored procedures.


[Fast Download] Oracle High Performance Tuning for 9i and 10g

Related eBooks:
Reinforcement Learning: An Introduction, 2 edition
Enhancing Competitive Advantage With Dynamic Management and Engineering
Natural Computing for Unsupervised Learning
Internet of Things for Smart Cities: Technologies, Big Data and Security
Information Science and Applications 2018: ICISA 2018
The Complete Android Manual
Learning Concurrent Programming in Scala
Building Android Apps with HTML, CSS, and JavaScript
Microsoft Office Project Server 2003 Unleashed
E-mail and Behavioral Changes: Uses and Misuses of Electronic Communications
Teach Yourself Visual Basic .NET in 21 Days
Proceedings of the International Conference on Advanced Intelligent Systems and Informatics 2016
Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.