Oracle High Performance Tuning for 9i and 10g - Image 1

£48.99

Digital Press Oracle High Performance Tuning for 9i and 10g

Name: Oracle High Performance Tuning for 9i and 10g
Brand: Digital Press
Price: 48.99 GBP
Availability: InStock

Applications

Price History & Forecast

Last 84 days • 84 data points (No recent data available)

Historical

Generating forecast...

Price Distribution

Price distribution over 84 days • 1 price levels

Days at Price

Price Analysis

Most common price: £49 (84 days, 100.0%)

Price range: £49 - £49

Price levels: 1 different prices over 84 days

Description

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. Physical database tuning involves hardware resource usage, networking and various other Oracle things such as configuration and file distribution. Physical configuration is often a culprit of poor performance where Oracle is installed with defaults, and never altered by an expert. *Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning *Contains experienced guidance and real-world examples using large datasets *Emphasizes development as opposed to operating system perspective

Product Specifications

Brand: Digital Press
Format: paperback
ASIN: 1555583059
Category: Books > Subjects > Computing & Internet > Databases > Applications
Domain: Amazon UK
Release Date: 02 January 2004
Listed Since: 22 January 2007

Barcode

No barcode data available

Digital Press Oracle High Performance Tuning for 9i and 10g

Price History & Forecast

Price Distribution

Price Analysis

Description

Product Specifications

Barcode

Similar Products You Might Like

Oracle Tuning: The Definitive Reference

Oracle DBA Reference Library

Practical Oracle SQL: Mastering the Full Power of Oracle Database

Oracle® 11g: PL/SQL Programming, International Edition (with CD-ROM)

Oracle SQL and PL/SQL: (3rd Edition)

SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance

Databases and Transaction Processing:An Application-Oriented Approach with Learning SQL:A Step-By-Step Guide Using Oracle

The SQL Server 7.0 Handbook: A Guide to Microsoft Database Computing

SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights

DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide

Machine Learning with Spark - Second Edition: Develop intelligent, distributed machine learning systems

Oracle Database 12c Release 2 In-Memory: Tips and Techniques for Maximum Performance (DATABASE & ERP - OMG)

SQL & NoSQL Databases: Models, Languages, Consistency Options and Architectures for Big Data Management

The SQL Guide to Pervasive PSQL

Learning SQL, 3e: Generate, Manipulate, and Retrieve Data

Murach's SQL Server 2019 for Developers

Fundamentals of Database Systems, with E-book: United States Edition

Database Systems: A Pragmatic Approach, 3rd edition

Die Konfigurierung modular aufgebauter Datenbanksysteme: 137 (Informatik-Fachberichte, 137)

MCSA Guide to Microsoft SQL Server 2012 (Exam 70-462) (Networking (Course Technology)): (Exam 70-462)

Database Technology: Nulls Considered Harmful

Advanced Transact-SQL for SQL Server 2000

Expert Consolidation in Oracle Database 12c

Expert Oracle Exadata (Expert's Voice in Oracle)