Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Expert Oracle Exadata / / by Martin Bach, Kristofferson Arao, Andy Colvin, Frits Hoogland, Kerry Osborne, Randy Johnson, Tanel Poder
| Expert Oracle Exadata / / by Martin Bach, Kristofferson Arao, Andy Colvin, Frits Hoogland, Kerry Osborne, Randy Johnson, Tanel Poder |
| Autore | Bach Martin |
| Edizione | [2nd ed. 2015.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 |
| Descrizione fisica | 1 online resource (661 p.) |
| Disciplina | 005.7565 |
| Collana | Expert's Voice in Oracle |
| Soggetto topico |
Database management
Data structures (Computer science) Database Management Data Storage Representation |
| ISBN | 1-4302-6242-7 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Contents at a Glance; Contents; About the Authors; Acknowledgments; Introduction; Chapter 1: What Is Exadata?; An Overview of Exadata; History of Exadata; Alternative Views of What Exadata Is; Data Warehouse Appliance; OLTP Machine; Consolidation Platform; Configuration Options; Exadata Database Machine X5-2 ; Exadata Database Machine X4-8 ; Exadata Storage Expansion Rack X5- 2 ; Upgrades; Hardware Components; Operating Systems; Database Servers; Storage Servers; InfiniBand; Flash Cache; Disks; Bits and Pieces; Software Components; Database Server Software
Storage Server Software Software Architecture; Summary; Chapter 2: Offloading / Smart Scan; Why Offloading Is Important; What Offloading Includes; Column Projection; Predicate Filtering; Storage Indexes and Zone Maps; Simple Joins (Bloom Filters); Function Offloading; Compression/Decompression; Encryption/Decryption; Virtual Columns; Support for LOB offloading; JSON Support and Offloading; Data Mining Model Scoring; Non-Smart Scan Offloading; Smart/Fast File Creation; RMAN Incremental Backups; RMAN Restores; Smart Scan Prerequisites; Full Scans; Direct Path Reads Exadata Storage Smart Scan Disablers; Simply Unavailable; Reverting to Block Shipping; Skipping Some Offloading; Skipping Offloading silently; How to Verify That Smart Scan Is Happening; 10046 Trace; Session Performance Statistics; Offload Eligible Bytes; SQL Monitoring; Parameters; Summary; Chapter 3: Hybrid Columnar Compression; Oracle Storage Review; Disassembling the Oracle Block; Compression Mechanics; BASIC Compression; OLTP Compression; Hybrid Columnar Compression; What Does the "Hybrid" in "Hybrid Columnar Compression" Mean?; Making Use of Hybrid Columnar Compression HCC Internals What Happens When You Create a HCC Compressed Table?; HCC Performance; Load Performance ; Query Performance ; DML Performance ; Expected Compression Ratios; Compression Advisor; Real-World Examples; Custom Application Data; Telecom Call Detail Data; Financial Data; Retail Sales Data; Summary of the Real-World Examples; Restrictions/Challenges; Moving Data to a Non-Exadata Platform; Disabling Serial Direct Path Reads; Locking Issues; Single Row Access; Common Usage Scenarios; Automatic Data Optimization; What Is Data Lifecycle Management?; Compression Automatic Data Optimization vs. Manual Lifecycle Management Example Use Cases for ADO; Enable ILM for Storage Tiering ; Enable ILM for Compression ; Summary; Chapter 4: Storage Indexes; Structure ; Monitoring Storage Indexes; Database Statistics; Tracing ; Monitoring Wrap-Up; Controlling Storage Indexes; _kcfis_storageidx_ disabled ; _kcfis_storageidx_diag_ mode ; _cell_storidx_ mode ; _cell_storidx_minmax_ enabled ; Storage Software Parameters ; Behavior; Performance; Special Optimization for Nulls; Physical Distribution of Values ; Potential Issues; Incorrect Results Moving Target |
| Record Nr. | UNINA-9910300645503321 |
Bach Martin
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Pro Oracle SQL / / Karen Morton [and four others]
| Pro Oracle SQL / / Karen Morton [and four others] |
| Autore | Morton Karen |
| Edizione | [2nd ed. 2013.] |
| Pubbl/distr/stampa | New York : , : Apress, , 2013 |
| Descrizione fisica | 1 online resource (xxi, 555 pages) : illustrations (some color) |
| Disciplina |
004
005.133 005.74 |
| Collana | The expert's voice in Oracle |
| Soggetto topico |
SQL (Computer program language)
Database management |
| ISBN | 1-4302-6221-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
""Contents at a Glance""; ""Contents""; ""About the Authors""; ""About the Technical Reviewer""; ""Acknowledgments""; ""Chapter 1: Core SQL""; ""The SQL Language""; ""Interfacing to the Database""; ""Review of SQL*Plus""; ""Connect to a Database""; ""Configuring the SQL*Plus Environment""; ""Executing Commands""; ""The Five Core SQL Statements""; ""The SELECT Statement""; ""The FROM Clause""; ""The WHERE Clause""; ""The GROUP BY Clause""; ""The HAVING Clause""; ""The SELECT List""; ""The ORDER BY Clause""; ""The INSERT Statement""; ""Single-Table Inserts""; ""Multitable Inserts""
""The UPDATE Statement""""The DELETE Statement""; ""The MERGE Statement""; ""Summary""; ""Chapter 2: SQL Execution""; ""Oracle Architecture Basics""; ""SGA: The Shared Pool""; ""The Library Cache""; ""Identical Statements""; ""SGA: The Buffer Cache""; ""Query Transformation""; ""Query Blocks""; ""View Merging""; ""Subquery Unnesting""; ""Join Elimination""; ""ORDER BY Elimination""; ""Predicate Pushing""; ""Query Rewrite with Materialized Views""; ""Determining the Execution Plan""; ""Executing the Plan and Fetching Rows""; ""SQL Execution: Putting It All Together""; ""Summary"" ""Chapter 3: Access and Join Methods""""Full Scan Access Methods""; ""How Full Scan Operations Are Chosen""; ""Full Scans and Throwaway""; ""Full Scans and Multiblock Reads""; ""Full Scans and the High-Water Mark""; ""Index Scan Access Methods""; ""Index Structure""; ""Index Scan Types""; ""Index Unique Scan""; ""Index Range Scan""; ""Index Full Scan""; ""Index Skip Scan""; ""Index Fast Full Scan""; ""Join Methods""; ""Nested Loops Joins""; ""Sort�Merge Joins""; ""Hash Joins""; ""Cartesian Joins""; ""Outer Joins""; ""Summary""; ""Chapter 4: SQL Is about Sets""; ""Thinking in Sets"" ""Moving from Procedural to Set-Based Thinking""""Procedural vs. Set-Based Thinking: An Example""; ""Set Operations""; ""UNION and UNION ALL""; ""MINUS""; ""INTERSECT""; ""Sets and Nulls""; ""NULL s and Unintuitive Results""; ""NULL Behavior in Set Operations""; ""NULL s and GROUP BY and ORDER BY""; ""NULL s and Aggregate Functions""; ""Summary""; ""Chapter 5: It�s about the Question""; ""Asking Good Questions""; ""The Purpose of Questions""; ""Categories of Questions""; ""Questions about the Question""; ""Questions about Data""; ""Building Logical Expressions""; ""Summary"" ""Chapter 6: SQL Execution Plans""""Explain Plan""; ""Using Explain Plan""; ""The Plan Table""; ""Breaking Down the Plan""; ""Understanding How EXPLAIN PLAN Can Miss the Mark""; ""Reading the Plan""; ""Access and Filter Predicates""; ""Reading the Plan as a Narrative""; ""Execution Plans""; ""Viewing Recently Generated SQL""; ""Viewing the Associated Execution Plan""; ""Collecting the Plan Statistics""; ""Identifying SQL Statements for Later Plan Retrieval""; ""Understanding DBMS_XPLAN in Detail""; ""Using SQL Monitor Reports""; ""Using Plan Information for Solving Problems"" ""Determining Index Deficiencies"" |
| Record Nr. | UNINA-9910437974503321 |
|
Morton Karen
|
||
| New York : , : Apress, , 2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||