Oracle Exadata survival guide

Oracle Exadata Survival Guide is a hands-on guide for busy Oracle database administrators who are migrating their skill sets to Oracle's Exadata database appliance. The book covers the concepts behind Exadata, and the available configurations for features such as smart scans, storage indexes, S...

Full description

Main Author: Fitzjarrell, David,
Other Authors: Spence, Mary Mikell,, SpringerLink (Online Service)
Format: eBook
Language: English
Published: Berkeley, California : Apress, 2013.
Physical Description: 1 online resource (271 pages) : illustrations.
Series: Expert's voice in Oracle.
Subjects:
LEADER 08429cam a2200985Mi 4500
001 868922806
003 OCoLC
005 20240329122006.0
006 m o d
007 cr cn|||||||||
008 131128s2013 caua ob 001 0 eng d
010 |a 2017449356 
019 |a 857711964  |a 868040678  |a 870449742  |a 871223919  |a 880853069  |a 961504530  |a 966372782  |a 1066568445  |a 1086562579  |a 1110950949  |a 1112550435  |a 1203993095  |a 1300222269 
020 |a 9781430260110  |q (electronic bk.) 
020 |a 1430260114  |q (electronic bk.) 
020 |z 1430260106 
020 |z 9781430260103 
024 7 |a 10.1007/978-1-4302-6011-0  |2 doi 
035 |a (OCoLC)868922806  |z (OCoLC)857711964  |z (OCoLC)868040678  |z (OCoLC)870449742  |z (OCoLC)871223919  |z (OCoLC)880853069  |z (OCoLC)961504530  |z (OCoLC)966372782  |z (OCoLC)1066568445  |z (OCoLC)1086562579  |z (OCoLC)1110950949  |z (OCoLC)1112550435  |z (OCoLC)1203993095  |z (OCoLC)1300222269 
037 |a CL0500000371  |b Safari Books Online 
040 |a E7B  |b eng  |e rda  |e pn  |c E7B  |d OCLCO  |d GW5XE  |d UMI  |d OCLCQ  |d COO  |d DEBBG  |d DEBSZ  |d GGVRL  |d OCLCF  |d YDXCP  |d NUI  |d B24X7  |d IDEBK  |d EBLCP  |d OCLCQ  |d AZK  |d Z5A  |d LIV  |d MERUC  |d OCLCQ  |d ESU  |d VT2  |d IOG  |d N$T  |d REB  |d OCLCQ  |d CEF  |d INT  |d U3W  |d OCLCQ  |d WYU  |d TKN  |d OCLCQ  |d UAB  |d AU@  |d UKAHL  |d OCLCQ  |d DCT  |d ERF  |d OCLCQ  |d HAGCC  |d BTCTA  |d CDX  |d INO  |d DLC  |d OCLCO  |d OCL  |d OCLCQ  |d OCLCO  |d OCLCQ  |d OCLCL 
049 |a COM6 
050 4 |a QA76.9.D3  |b F58 2013eb 
072 7 |a COM  |x 021000  |2 bisacsh 
072 7 |a UN  |2 bicssc 
072 7 |a UMT  |2 bicssc 
082 0 4 |a 005.74  |2 23 
100 1 |a Fitzjarrell, David,  |e author. 
245 1 0 |a Oracle Exadata survival guide /  |c David Fitzjarrell and Mary Mikell Spence. 
264 1 |a Berkeley, California :  |b Apress,  |c 2013. 
300 |a 1 online resource (271 pages) :  |b illustrations. 
336 |a text  |b txt  |2 rdacontent. 
337 |a computer  |b c  |2 rdamedia. 
338 |a online resource  |b cr  |2 rdacarrier. 
347 |a text file  |b PDF  |2 rda. 
490 1 |a The expert's voice in Oracle. 
504 |a Includes bibliographical references and index. 
588 0 |a Online resource; title from PDF (ebrary, viewed January 6, 2014). 
520 |a Oracle Exadata Survival Guide is a hands-on guide for busy Oracle database administrators who are migrating their skill sets to Oracle's Exadata database appliance. The book covers the concepts behind Exadata, and the available configurations for features such as smart scans, storage indexes, Smart Flash Cache, hybrid columnar compression, and more. You'll learn about performance metrics and execution plans, and how to optimize SQL running in Oracle's powerful, new environment. The authors also cover migration from other servers. Oracle Exadata is fast becoming the standard for large installations such as those running data warehouse, business intelligence, and large-scale OLTP systems. Exadata is like no other platform, and is new ground even for experienced Oracle database administrators. The Oracle Exadata Survival Guide helps you navigate the ins and outs of this new platform, de-mystifying this amazing appliance and its exceptional performance. The book takes a highly practical approach, not diving too deeply into the details, but giving you just the right depth of information to quickly transfer your skills to Oracle's important new platform. Helps transfer your skills to the platform of the future Covers the important ground without going too deep Takes a practical and hands-on approach to everyday tasks. 
505 0 |a At a Glance; Chapter 1: Exadata Basics; What Is Exadata?; Available Configurations; Storage; Smart Flash Cache; Even More Storage; Things to Know; Chapter 2: Smart Scans and Offloading; Smart Scans; Plans and Metrics; Smart Scan Optimizations; Column Projection; Predicate Filtering; Basic Joins; Offloading Functions; Virtual Columns; Things to Know; Chapter 3: Storage Indexes; An Index That Isn't; Don't Look Here; I Used It; Or Maybe I Didn't; Execution Plan Doesn't Know; The More, the Merrier; NULLs; Needing to "Rebuild "; Things to Know; Chapter 4: Smart Flash Cache; Flash Me. 
505 8 |a How It WorksLogging We Will Go; It's a Disk; Monitoring; Storage Server Tools; Database Server Tools; What a Performer; Things to Know; Chapter 5: Parallel Query; Getting into the Queue; Old School; The New Method; Control Issues; Necessary Settings; My Friend Auto; Calibrate Me; Make It So; Do It in Memory; Things to Know; Chapter 6: Compression; How Can I Compress Thee; Basic; OLTP; Hybrid Columnar Compression (HCC); QUERY; ARCHIVE; The Nuts and Bolts of HCC; Performance; When You Load; When You Query; When You Update; Ratios-What to Expect; What Oracle Thinks; What You Get; Things to Know. 
505 8 |a Chapter 7: Exadata Cell Wait EventsAvailable Nowhere Else; Cell Events; Triggering Events; User I/O Events; Cell Smart Table Scan; Cell Smart Index Scan; Cell Single-Block Physical Read; Cell Multiblock Physical Read; Cell List of Blocks Physically Read; Cell Smart File Creation; Cell Statistics Gather; System I/O Events; Cell Smart Incremental Backup; Cell Smart Restore from Backup; Idle Class/Other Class; Cell Smart Flash Unkeep; Things to Know; Chapter 8: Measuring Performance; Measure Twice, Cut Once; Smart Scans, Again; Performance Counters and Metrics; Dynamic Counters. 
505 8 |a When to Use Them, and HowLet Me Explain; Performance Counter Reference; cell blocks helped by commit cache; cell blocks helped by minscn optimization; cell commit cache queries; cell blocks processed by cache layer; cell blocks processed by data layer; cell blocks processed by index layer; cell blocks processed by txn layer; cell flash cache read hits; cell index scans; cell IO uncompressed bytes; cell num fast response sessions; cell num fast response sessions continuing to smart scan; cell num smart IO sessions using passthru mode due to _______ 
505 8 |a Cell physical IO bytes sent directly to DB node to balance CPU usagechained rows process ed by cell; chained rows rejected by cell; chained rows skipped by cell; SQL Statement Performance; Things to Know; Chapter 9: Storage Cell Monitoring; Talking to the Storage Cells; Where Shall I Go?; What Shall I Do?; What's in a Name?; Monitoring Basics; As cellmonitor; As celladmin; Things to Know; Chapter 10: Monitoring Exadata; The Database Layer; Are We There Yet?; Real-Time SQL Monitoring Reports; Using GVSQL and GVSQLSTATS (But That's Not All); The Storage Cells; The Command Line; OEM. 
630 0 7 |a Oracle (Computer file)  |2 blmlsh. 
650 0 |a Computer science. 
650 0 |a Database management. 
650 0 |a Data structures (Computer science) 
650 2 |a Electronic Data Processing. 
650 6 |a Informatique. 
650 6 |a Structures de données (Informatique) 
650 6 |a Bases de données  |x Gestion. 
650 7 |a COMPUTERS  |x Databases  |x General.  |2 bisacsh. 
650 7 |a Data structures (Computer science)  |2 fast. 
650 7 |a Computer science  |2 fast. 
650 7 |a Database management  |2 fast. 
700 1 |a Spence, Mary Mikell,  |e author. 
710 2 |a SpringerLink (Online Service) 
773 0 |t Springer eBooks. 
776 0 8 |i Print version:  |z 9781430260103. 
830 0 |a Expert's voice in Oracle. 
907 |a .b41783232  |b multi  |c -  |d 140304  |e 240501 
998 |a (3)cue  |a cu  |b 240404  |c m  |d z   |e -  |f eng  |g cau  |h 0  |i 2 
948 |a MARCIVE Comp, in 2022.12 
948 |a MARCIVE Over, 07/2021 
948 |a MARCIVE Comp, 2019.12 
948 |a MARCIVE Comp, 2018.05 
948 |a MARCIVE August, 2017 
948 |a MARCIVE extract Aug 5, 2017 
994 |a 92  |b COM 
995 |a Loaded with m2btab.elec in 2024.04 
995 |a Loaded with m2btab.ltiac in 2022.12 
995 |a Loaded with m2btab.ltiac in 2021.07 
995 |a Loaded with m2btab.elec in 2021.06 
995 |a Loaded with m2btab.ltiac in 2019.12 
995 |a Loaded with m2btab.ltiac in 2018.06 
995 |a Loaded with m2btab.ltiac in 2017.08 
995 |a Loaded with m2btab.elec in 2016 
995 |a Loaded with m2btab.elec in 2016 
995 |a OCLC offline update by CMU 
995 |a Loaded with m2btab.auth in 2021.07 
995 |a Loaded with m2btab.auth in 2021.07 
999 |e z 
999 |a cue 
989 |d cueme  |e  - -   |f  - -   |g -   |h 0  |i 0  |j 200  |k 240404  |l $0.00  |m    |n  - -   |o -  |p 0  |q 0  |t 0  |x 0  |w SpringerLink  |1 .i151401676  |u http://ezproxy.coloradomesa.edu/login?url=https://link.springer.com/10.1007/978-1-4302-6011-0  |3 SpringerLink  |z Click here for access