Cargando…
Oracle database 12c release 2 performance tuning tips and techniques /
Proven Database Optimization Solutions--Fully Updated for Oracle Database 12c Release 2 Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 12c Release 2 Pe...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
New York :
McGraw-Hill Education,
[2017]
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | OR_ocn993673027 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr ||||||||||| | ||
| 008 | 170712s2017 nyu o 000 0 eng | ||
| 010 | |a 2017033333 | ||
| 040 | |a DLC |b eng |e rda |c DLC |d OCLCF |d UMI |d MLSOD |d TOH |d LVT |d ESU |d UKAHL |d C6I |d VT2 |d EBLCP |d YDX |d DLC |d OCLCO |d CZL |d OCLCO |d OCLCQ |d N$T |d OCLCO | ||
| 019 | |a 1000155596 |a 1060741667 |a 1076644201 |a 1152973216 |a 1165388433 |a 1192349517 |a 1240522401 |a 1381245838 | ||
| 020 | |a 9781259589690 |q (ebook) | ||
| 020 | |a 1259589692 |q (ebook) | ||
| 020 | |z 9781259589683 | ||
| 020 | |z 1259589684 | ||
| 029 | 1 | |a AU@ |b 000060485060 | |
| 029 | 1 | |a AU@ |b 000069024280 | |
| 035 | |a (OCoLC)993673027 |z (OCoLC)1000155596 |z (OCoLC)1060741667 |z (OCoLC)1076644201 |z (OCoLC)1152973216 |z (OCoLC)1165388433 |z (OCoLC)1192349517 |z (OCoLC)1240522401 |z (OCoLC)1381245838 | ||
| 037 | |a CL0500000882 |b Safari Books Online | ||
| 042 | |a pcc | ||
| 050 | 0 | 0 | |a QA76.9.D3 |
| 082 | 0 | 0 | |a 005.75/6 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Niemiec, Richard J., |e author. | |
| 245 | 1 | 0 | |a Oracle database 12c release 2 performance tuning tips and techniques / |c Richard J. Niemiec. |
| 264 | 1 | |a New York : |b McGraw-Hill Education, |c [2017] | |
| 300 | |a 1 online resource | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b n |2 rdamedia | ||
| 338 | |a online resource |b nc |2 rdacarrier | ||
| 588 | |a Description based on print version record and CIP data provided by publisher; resource not viewed. | ||
| 504 | |a Includes bibliographical references and index. | ||
| 505 | 0 | |a Cover -- Title Page -- Copyright Page -- About the Author -- Contents at a Glance -- Contents -- Acknowledgments -- Introduction -- 1 Introduction to Oracle Database 12c R1 & R2 New Features (DBA and Developer) -- Oracle Database 12cR1 (12.1.0.1) -- Increased Size Limit to 32K for VARCHAR2 and NVARCHAR2 -- Partial Indexes -- Invisible Columns -- Multiple Indexes on the Same Column List -- Fetch First x Rows -- Pluggable Databases (PDBs) -- Oracle Database Cloud Service (Database as a Service) -- PDB Level: MEMORY_LIMIT and MEMORY_MINIMUM (12cR2) -- Change Compression at Import Time | |
| 505 | 8 | |a Adaptive Query Optimization -- PGA_AGGREGATE_LIMIT -- Concurrent Execution for UNION/UNION ALL -- Invoker Rights Function Can Be Results Cached -- New DBMS_UTILITY. EXPAND_SQL_TEXT -- Default for Columns Based on Sequence -- Multiple SSD Devices for Smart Flash Cache -- Concurrent Cost-Based Optimizer Statistics Gathering -- Enhanced System Statistics -- Resource Manager for Runaway Queries -- Automatic Data Optimization (ADO) -- Global Index Maintenance: Drop and Truncate Partition Operations -- ASM Disk Scrubbing -- Online Capability Improvements -- Data Guard Improvements -- RMAN Improvements | |
| 505 | 8 | |a Oracle Database 12cR1 (12.1.0.2) -- In-Memory Database -- Advanced Index Compression -- Automatic Big Table Caching -- FDA Support for Container Databases -- Full Database Caching -- JSON Support -- FIPS 140 Parameter for Encryption -- PDB Subset Cloning -- Rapid Home Provisioning-Creating "Gold Images" -- Oracle Database 12cR2 (12.2) -- Application Development -- Enhanced Features to Reduce Costs and Issues for Migration to Oracle -- Availability -- Big Data -- Compression and Archiving -- Oracle RAC and Grid Infrastructure -- Security -- New Background Processes in 12c | |
| 505 | 8 | |a Exadata-New with Exadata X6! -- Version Comparison Chart -- New Features Review -- References -- 2 Basic Index Principles (Beginner Developer and Beginner DBA) -- Basic Index Concepts -- Invisible Indexes -- Multiple Types of Indexes on the Same Column(s) -- Concatenated Indexes -- Suppressing Indexes -- Using the NOT EQUAL Operators:,!= -- Using IS NULL or IS NOT NULL -- Using LIKE -- Using Functions -- Comparing Mismatched Data Types -- Selectivity -- The Clustering Factor -- The Binary Height -- Additional Details Concerning BLEVEL and Index Height -- Using Histograms -- Fast Full Scans | |
| 505 | 8 | |a Skip-Scans -- Types of Indexes -- B-Tree Indexes -- Bitmap Indexes -- Hash Indexes -- Index-Organized Tables -- Reverse Key Indexes -- Function-Based Indexes -- Partitioned Indexes -- New 12cR2 Features for Partitioned Indexes -- Bitmap Join Indexes -- Fast Index Rebuilding -- Rebuilding Indexes Online -- Tips Review -- References -- 3 Pluggable Databases, Disk Implementation Methodology, and ASM (DBA) -- Pluggable Databases (New in Oracle 12c) -- CDB or PDB Created Objects -- Creating a PDB: Many Ways to Do It -- Great Pluggable Database Commands | |
| 520 | |a Proven Database Optimization Solutions--Fully Updated for Oracle Database 12c Release 2 Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 12c Release 2 Performance Tuning Tips and Techniques details the latest monitoring, troubleshooting, and optimization methods. Find out how to identify and fix bottlenecks on premises and in the cloud, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide. • Properly index and partition Oracle Database 12c Release 2 • Work effectively with Oracle Cloud, Oracle Exadata, and Oracle Enterprise Manager • Efficiently manage disk drives, ASM, RAID arrays, and memory • Tune queries with Oracle SQL hints and the Trace utility • Troubleshoot databases using V$ views and X$ tables • Create your first cloud database service and prepare for hybrid cloud • Generate reports using Oracle's Statspack and Automatic Workload Repository tools • Use sar, vmstat, and iostat to monitor operating system statistics. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Oracle (Computer file) |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 fast |
| 650 | 0 | |a Relational databases. | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 7 | |a Relational databases |2 fast | |
| 776 | 0 | 8 | |i Print version: |a Niemiec, Richard J., author. |t Oracle database 12c release 2 performance tuning tips and techniques |d New York : McGraw-Hill Education, [2017] |z 9781259589683 |w (DLC) 2017004938 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781259589690/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a YBP Library Services |b YANK |n 16842217 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL6254474 | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH32568673 | ||
| 938 | |a EBSCOhost |b EBSC |n 2686682 | ||
| 994 | |a 92 |b IZTAP | ||