Library Hours
Monday to Friday: 9 a.m. to 9 p.m.
Saturday: 9 a.m. to 5 p.m.
Sunday: 1 p.m. to 9 p.m.
Naper Blvd. 1 p.m. to 5 p.m.
LEADER 00000cam a2200877 a 4500
001 775468104
003 OCoLC
005 20240129213017.0
006 m o d
007 cr cnu---unuuu
008 120207s2011 cauac o 001 0 eng d
010 2012493861
019 779411136|a779881841|a785779307|a792930262|a803439914
|a1005819828|a1064052863|a1066478277|a1086512778
|a1086876525|a1110822511|a1112562553|a1129351636
|a1153040411|a1162628363|a1192334879|a1204010262
|a1240517144|a1296607673
020 9781430239550|q(electronic bk.)
020 1430239557|q(electronic bk.)
024 7 10.1007/978-1-4302-3955-0|2doi
029 1 AU@|b000048698976
029 1 AU@|b000053278321
029 1 AU@|b000060583617
029 1 DEBBG|bBV040901523
029 1 DEBSZ|b378288296
029 1 DEBSZ|b381375633
029 1 DEBSZ|b397270879
029 1 GBVCP|b722019998
029 1 NZ1|b14230882
029 1 NZ1|b14685851
029 1 AU@|b000067098980
035 (OCoLC)775468104|z(OCoLC)779411136|z(OCoLC)779881841
|z(OCoLC)785779307|z(OCoLC)792930262|z(OCoLC)803439914
|z(OCoLC)1005819828|z(OCoLC)1064052863|z(OCoLC)1066478277
|z(OCoLC)1086512778|z(OCoLC)1086876525|z(OCoLC)1110822511
|z(OCoLC)1112562553|z(OCoLC)1129351636|z(OCoLC)1153040411
|z(OCoLC)1162628363|z(OCoLC)1192334879|z(OCoLC)1204010262
|z(OCoLC)1240517144|z(OCoLC)1296607673
037 CL0500000135|bSafari Books Online
040 GW5XE|beng|epn|cGW5XE|dCOO|dB24X7|dEBLCP|dE7B|dUMI|dOCLCQ
|dDEBSZ|dOCLCQ|dBEDGE|dOCLCQ|dUUO|dYDXCP|dOCLCF|dVT2
|dMEAUC|dGBVCP|dOCLCQ|dTXI|dOCLCQ|dCAUOI|dZ5A|dLIV|dMERUC
|dESU|dIOG|dN$T|dCEF|dINT|dU3W|dAU@|dOCLCQ|dOCLCO|dWYU
|dDEHBZ|dYOU|dOCLCQ|dUAB|dUKAHL|dOL$|dOCLCQ|dOCLCO|dDCT
|dERF|dOCLCQ|dBRF|dOCLCO|dOCLCQ|dOCLCO|dOCLCQ|dOCLCL
049 INap
082 04 005.74
082 04 005.74|223
099 eBook O’Reilly for Public Libraries
100 1 Lewis, Jonathan,|d1957-
245 10 Oracle Core :|bessential internals for DBAs and Developers
/|cJonathan Lewis.|h[O'Reilly electronic resource]
260 [Berkeley, CA] :|bApress ;|aNew York :|bDistributed to the
Book trade by Springer,|c©2011.
300 1 online resource (xiv, 266 pages) :|billustrations, color
portraits
336 text|btxt|2rdacontent
337 computer|bc|2rdamedia
338 online resource|bcr|2rdacarrier
347 text file|bPDF|2rda
490 1 The expert's voice in databases
505 0 Machine generated contents note: ch. 1 Getting Started --
Oracle in Processes -- Oracle in Actio -- Summary -- ch. 2
Redo and Undo -- Basic Data Change -- The Approach -- An
Example -- Debriefing -- Summary of Observations -- ACID -
- Redo Simplicity -- Undo Complexity -- Read Consistency -
- Rollback -- Summary -- ch. 3 Transactions and
Consistency -- Conflict Resolution -- Transactions and
Undo -- Start and End of Transaction -- The Transaction
Table -- Reviewing the Undo Block -- Data Block Visits and
Undo -- Setting the Scene -- The Interested Transaction
List -- Concurrent Action -- Commit SCN -- Commit Cleanout
-- Delayed Block Cleanout -- Transaction Table Rollback --
LOBs -- Summary -- ch. 4 Locks and Latches -- First Things,
First -- Arrays -- Pointers -- Linked Lists -- Hash Tables
-- Latches -- Logic Behind Latches -- Latch Activity
Statistics -- Latch Scalability -- Locks -- Infrastructure
-- A Graphic Image of v$lock -- Deadlock -- Lock Modes --
Latches for Locks.
505 0 Note continued: KGL Locks (and Pins) -- Locks and Pins --
Summary -- ch. 5 Caches and Copies -- Memory Management --
Granules -- Granules and Buffers -- Multiple Data Caches -
- Granules and Buffer Pools -- Buffer Pools -- Working
Data Sets -- The LRU/TCH Algorithm -- LRU/TCH in action --
Relinking a Buffer -- REPL_AUX -- Finding Data -- Pinning
Buffers -- Logical I/O -- Updates -- Loading a Hash Chain
-- Read-Consistent Copies -- Physical I/O -- Tablescans --
Summary -- ch. 6 Writing and Recovery -- Targets -- Log
Writer -- Log Writer Writes -- PL/SQL Optimization -- ACID
Anomaly -- Commit Enhancements -- Mechanics -- Redo
Wastage -- Private Redo -- Database Writer -- Buffer
Headers -- Checkpoint Queues -- Incremental Checkpointing
-- Database Writer Interactions -- Database Writer Meets
Log Writer -- Database Writer and LRU -- Checkpoints and
Queues -- Buffer Header Queues -- Checkpoints and Log
Files -- Recovery -- Media Recovery -- Standby Databases.
505 0 Note continued: Flashback Database -- Side Effects --
Summary -- ch. 7 Parsing and Optimizing -- Understanding
SQL -- Parsing -- Optimizing -- Interpreting the tkprof
Summaries -- The Dictionary Cache -- The Structure --
Dictionary Cache Activity -- What Is a Parse Call? --
Cursor Caching -- Holding Cursors -- The Library Cache --
Shared Pool Structures -- The Fine Structure of the Shared
Pool -- ... and Action! -- Parsing and Optimizing --
Executing, Locking, and Pinning -- Mutexes -- Summary --
ch. 8 RAC and Ruin -- The Big Picture -- Staying Alive --
What's the Point? -- High Availability -- Scalability --
The Grid -- How Can It Work? -- The GRD -- Masters and
Shadows -- GCS and GES -- Cache Fusion -- Consequences --
Recovery -- Sequences -- Caching Sequences -- Sequence
Internals -- Ordered Sequences -- Sequences and Indexes --
Summary -- Appendix: Dumping and Debugging -- Oradebug --
Suspending Processes -- Dumps -- Peeking at Memory --
Dumps from SQL.
505 0 Note continued: Oradebug Alternatives -- Data File Blocks
-- Log Files -- Guesswork.
520 Oracle Core: Essential Internals for DBAs and Developers
by Jonathan Lewis¡provides just the essential information
about Oracle Database internals that every¡database
administrator¡needs for troubleshooting--no more, ¡no
less. Oracle Database seems complex on the surface.
However, its extensive feature set is really built upon
upon a core infrastructure resulting from sound
architectural decisions made very early on¡that have stood
the test of time. This core infrastructure manages
transactions and the ability to commit and roll back
changes, protects the integrity of the database, enables
backup and recovery, and allows for scalability to
thousands of users all accessing the same data. Most
performance, backup, and recovery problems that database
administrators face on a daily basis can easily be
identified through understanding the essential core of
Oracle Database architecture that Lewis describes in this
book. Provides proven content from a world-renowned
performance and troubleshooting expert Emphasizes the
significance of internals knowledge to rapid
identification of database performance problems Covers the
core essentials and¡does not waste your time with
esoterica.
588 0 Online resource; title from PDF title page (EBSCO, viewed
November 29, 2017).
590 O'Reilly|bO'Reilly Online Learning: Academic/Public
Library Edition
630 00 Oracle (Computer file)
630 07 Oracle (Computer file)|2blmlsh
630 07 Oracle (Computer file)|2fast
650 0 Database management.
650 6 Bases de données|xGestion.
650 7 Informatique.|2eclas
650 7 Database management|2fast
650 7 ORACLE.|2gnd
653 4 Computer science.
653 4 Database management.
773 0 |tSpringer eBooks
776 08 |iPrint version:|aLewis, Jonathan, 1957-|tOracle Core.
|d[Berkeley, CA] : Apress ; New York : Distributed to the
Book trade by Springer, ©2011|w(DLC) 2012493861
830 0 Expert's voice in databases.
856 40 |uhttps://ezproxy.naperville-lib.org/login?url=https://
learning.oreilly.com/library/view/~/9781430239543/?ar
|zAvailable on O'Reilly for Public Libraries
938 Askews and Holts Library Services|bASKH|nAH29391000
938 Books 24x7|bB247|nbks00044638
938 EBL - Ebook Library|bEBLB|nEBL883814
938 ebrary|bEBRY|nebr10530914
938 EBSCOhost|bEBSC|n1173505
938 YBP Library Services|bYANK|n7425235
938 YBP Library Services|bYANK|n6939827
994 92|bJFN