The Resource Database performance tuning and optimization : using Oracle, Sitansu S. Mittra, (ebook)

Database performance tuning and optimization : using Oracle, Sitansu S. Mittra, (ebook)

Label
Database performance tuning and optimization : using Oracle
Title
Database performance tuning and optimization
Title remainder
using Oracle
Statement of responsibility
Sitansu S. Mittra
Creator
Contributor
Subject
Genre
Language
eng
Member of
Cataloging source
N$T
http://library.link/vocab/creatorName
Mittra, Sitansu S
Dewey number
005.75/85
Illustrations
illustrations
Index
index present
LC call number
QA76.9.D3
LC item number
M579 2002eb
Literary form
non fiction
Nature of contents
  • dictionaries
  • bibliography
http://library.link/vocab/relatedWorkOrContributorName
EBSCO Publishing (Firm)
Series statement
Springer professional computing
http://library.link/vocab/subjectName
Database management
Label
Database performance tuning and optimization : using Oracle, Sitansu S. Mittra, (ebook)
Link
http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=108041
Instantiates
Publication
Antecedent source
unknown
Bibliography note
Includes bibliographical references and index
Color
multicolored
Contents
Cover -- Table of Contents -- Preface -- Part 1 Methodology -- 1 Database Application Development -- Outline -- Overview of the Chapter -- 1.1 1970s Software Technology Era -- 1.2 Role of the Database in SDLC and SMLC -- 1.3 Enterprise Modeling -- 1.4 Logical Database Design -- 1.5. Physical Database Design -- 1.6 Database Implementation -- 1.7 Database Maintenance -- 1.8 Naming Guidelines for Database Objects -- Key Words -- References and Further Reading -- Exercises -- 2 Performance Tuning Methodology -- Outline -- Overview of the Chapter -- 2.1 Three Levels of a Database -- 2.2 Optimization at Each Level -- 2.3 Process and Metric for Performance Tuning -- Key Words -- References and Further Reading -- Exercises -- 3 Tuning the Conceptual Level of a Database -- Outline -- Overview of the Chapter -- 3.1 Three Versions of the Conceptual Level -- 3.2 Performance Issues at the Conceptual Level -- 3.3 Denormalization of the Conceptual Level -- 3.4 Optimal Indexing of Tables -- 3.5 Integration of Views into Queries -- 3.6 Partitioning of Tables and Indices -- 3.7 Data Replication -- Key Words -- References and Further Reading -- Exercises -- Part 2 Oracle Tools for Tuning and Optimization -- 4 Internal Level of an Oracle Database -- Outline -- Overview of the Chapter -- 4.1 Components of the Internal Level -- 4.2 Oracle Instance -- 4.3 Oracle Database -- 4.4 Internal Level Tuning Methodology -- 4.5 Oracle Data Dictionary -- 4.6 V$ Views and X$ Tables -- 4.7 Initialization Parameters for an Oracle Database -- Key Words -- References and Further Reading -- Exercises -- 5 Tuning of Disk Resident Data Structures -- Outline -- Overview of the Chapter -- 5.1 Disk-Resident Data Structures -- 5.2 Performance Tuning of Disk-Resident Data Structures -- 5.3 Baseline of Disk-Resident Data Structures -- 5.4 Changes to Database Schema -- 5.5 Data Block Structure -- 5.6 Used Space Fragmentation at the Segment Level -- 5.7 Severity of Free Space Shortage -- 5.8 Free Space Fragmentation at Tablespace Level -- 5.9 Row Chaining and Row Migration in Tables -- 5.10 Performance Tuning of Rollback Segments -- Key Words -- References and Further Reading -- Exercises -- 6 Tuning of Memory-Resident Data Structures -- Outline -- Overview of the Chapter -- 6.1 Memory Resident Data Structures -- 6.2 Performance Tuning -- 6.3 Data Block Buffers -- 6.4 Redo Log Buffer -- 6.5 Shared SQL Pool -- 6.6 Background Processes -- 6.7 Tuning the Memory -- 6.8 Tuning the CPU -- 6.9 Pinning Packages in Memory -- 6.10 Latching Mechanism for Access Control -- Key Words -- References and Further Reading -- Exercises -- 7 Oracle Utility for Tuning and Optimization -- Outline -- Overview of the Chapter -- 7.1 Scope of Oracle Utilities -- 7.2 UTLBSTAT and UTLESTAT Utilities -- 7.3 Location and Function of the Utility Scripts -- 7.4 Procedure for Running the Utilities -- 7.5 UTLBSTAT/ESTAT Performance Report Analysis -- 7.6 Comprehensive Tuning Plan
Dimensions
unknown
Extent
1 online resource (xxi, 489 p.)
File format
unknown
Form of item
online
Isbn
9786610188505
Isbn Type
(electronic bk.)
Level of compression
unknown
Other physical details
ill.
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
  • ocm56104220
  • (OCoLC)56104220
Label
Database performance tuning and optimization : using Oracle, Sitansu S. Mittra, (ebook)
Link
http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=108041
Publication
Antecedent source
unknown
Bibliography note
Includes bibliographical references and index
Color
multicolored
Contents
Cover -- Table of Contents -- Preface -- Part 1 Methodology -- 1 Database Application Development -- Outline -- Overview of the Chapter -- 1.1 1970s Software Technology Era -- 1.2 Role of the Database in SDLC and SMLC -- 1.3 Enterprise Modeling -- 1.4 Logical Database Design -- 1.5. Physical Database Design -- 1.6 Database Implementation -- 1.7 Database Maintenance -- 1.8 Naming Guidelines for Database Objects -- Key Words -- References and Further Reading -- Exercises -- 2 Performance Tuning Methodology -- Outline -- Overview of the Chapter -- 2.1 Three Levels of a Database -- 2.2 Optimization at Each Level -- 2.3 Process and Metric for Performance Tuning -- Key Words -- References and Further Reading -- Exercises -- 3 Tuning the Conceptual Level of a Database -- Outline -- Overview of the Chapter -- 3.1 Three Versions of the Conceptual Level -- 3.2 Performance Issues at the Conceptual Level -- 3.3 Denormalization of the Conceptual Level -- 3.4 Optimal Indexing of Tables -- 3.5 Integration of Views into Queries -- 3.6 Partitioning of Tables and Indices -- 3.7 Data Replication -- Key Words -- References and Further Reading -- Exercises -- Part 2 Oracle Tools for Tuning and Optimization -- 4 Internal Level of an Oracle Database -- Outline -- Overview of the Chapter -- 4.1 Components of the Internal Level -- 4.2 Oracle Instance -- 4.3 Oracle Database -- 4.4 Internal Level Tuning Methodology -- 4.5 Oracle Data Dictionary -- 4.6 V$ Views and X$ Tables -- 4.7 Initialization Parameters for an Oracle Database -- Key Words -- References and Further Reading -- Exercises -- 5 Tuning of Disk Resident Data Structures -- Outline -- Overview of the Chapter -- 5.1 Disk-Resident Data Structures -- 5.2 Performance Tuning of Disk-Resident Data Structures -- 5.3 Baseline of Disk-Resident Data Structures -- 5.4 Changes to Database Schema -- 5.5 Data Block Structure -- 5.6 Used Space Fragmentation at the Segment Level -- 5.7 Severity of Free Space Shortage -- 5.8 Free Space Fragmentation at Tablespace Level -- 5.9 Row Chaining and Row Migration in Tables -- 5.10 Performance Tuning of Rollback Segments -- Key Words -- References and Further Reading -- Exercises -- 6 Tuning of Memory-Resident Data Structures -- Outline -- Overview of the Chapter -- 6.1 Memory Resident Data Structures -- 6.2 Performance Tuning -- 6.3 Data Block Buffers -- 6.4 Redo Log Buffer -- 6.5 Shared SQL Pool -- 6.6 Background Processes -- 6.7 Tuning the Memory -- 6.8 Tuning the CPU -- 6.9 Pinning Packages in Memory -- 6.10 Latching Mechanism for Access Control -- Key Words -- References and Further Reading -- Exercises -- 7 Oracle Utility for Tuning and Optimization -- Outline -- Overview of the Chapter -- 7.1 Scope of Oracle Utilities -- 7.2 UTLBSTAT and UTLESTAT Utilities -- 7.3 Location and Function of the Utility Scripts -- 7.4 Procedure for Running the Utilities -- 7.5 UTLBSTAT/ESTAT Performance Report Analysis -- 7.6 Comprehensive Tuning Plan
Dimensions
unknown
Extent
1 online resource (xxi, 489 p.)
File format
unknown
Form of item
online
Isbn
9786610188505
Isbn Type
(electronic bk.)
Level of compression
unknown
Other physical details
ill.
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
  • ocm56104220
  • (OCoLC)56104220

Library Locations

  • Beatties Ford Road RegionalBorrow it
    2412 Beatties Ford Road, Charlotte, NC, 28216, US
    35.2676379 -80.8555409
  • Charlotte Mecklenburg LibraryBorrow it
    310 N Tryon St., Charlotte, NC, 28202, US
    35.2285169 -80.839928
  • CorneliusBorrow it
    21105 Catawba Avenue, Cornelius, NC, 28031, US
    35.4833296 -80.8663023
  • DavidsonBorrow it
    119 South Main Street, Davidson, NC, 28036, US
    35.498441 -80.8505028
  • Hickory GroveBorrow it
    5935 Hickory Grove Road, Charolette, NC, 28215, US
    35.2229798 -80.730329
  • ImaginOnBorrow it
    300 East Seventh Street, Charlotte, NC, 28202, US
    35.2269427 -80.8398527
  • Independence RegionalBorrow it
    6000 Conference Drive, Charlotte, NC, 28212, US
    35.1764837 -80.757611
  • Main LibraryBorrow it
    310 North Tryon Street, Charlotte, NC, 28202, US
    35.2285213 -80.8421167
  • MatthewsBorrow it
    230 Matthews Station St., Matthews, NC, 28105, US
    35.1160092 -80.720516
  • Mint HillBorrow it
    6840 Matthews - Mint Hill Road, Mint Hill, NC, 28227, US
    35.1717049 -80.6610649
  • Morrison RegionalBorrow it
    7015 Morrison Boulevard, Charlotte, NC, 28211, US
    35.1517093 -80.8250892
  • Mountain IslandBorrow it
    4420 Hoyt Galvin Way, Charlotte, NC, 28214, US
    35.3350873 -80.9625991
  • Myers ParkBorrow it
    1361 Queens Road, Charlotte, NC, 28207, US
    35.1964537 -80.8295867
  • North County RegionalBorrow it
    16500 Holly Crest Lane, Huntersville, NC, 28078, US
    35.4406879 -80.8661493
  • Plaza MidwoodBorrow it
    1623 Central Avenue, Charlotte, NC, 28205, US
    35.2206234 -80.8132445
  • ScaleybarkBorrow it
    101 Scaleybark Road, Charlotte, NC, 28209, US
    35.1890888 -80.8773791
  • South County RegionalBorrow it
    5801 Rea Road, Charlotte, NC, 28277, US
    35.086541 -80.8137402
  • Steele CreekBorrow it
    13620 Steele Creek Road, Charlotte, NC, 28273, US
    35.1067994 -80.9910789
  • Sugar CreekBorrow it
    NC, US
  • University City RegionalBorrow it
    4045 North Tryon Street, Suite A, Charlotte, NC, 28206, US
    35.2575219 -80.7997242
  • West BoulevardBorrow it
    2157 West Boulevard, Charlotte, NC, 28208, US
    35.2111493 -80.8983269
Processing Feedback ...