Cargando…
Oracle Core : essential internals for DBAs and Developers /
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 feat...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[Berkeley, CA] : New York :
Apress ; Distributed to the Book trade by Springer,
©2011.
|
| Colección: | Expert's voice in databases.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000Ia 4500 | ||
|---|---|---|---|
| 001 | OR_ocn775468104 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 120207s2011 cauac o 001 0 eng d | ||
| 010 | |a 2012493861 | ||
| 040 | |a GW5XE |b eng |e pn |c GW5XE |d COO |d B24X7 |d EBLCP |d E7B |d UMI |d OCLCQ |d DEBSZ |d OCLCQ |d BEDGE |d OCLCQ |d UUO |d YDXCP |d OCLCF |d VT2 |d MEAUC |d GBVCP |d OCLCQ |d TXI |d OCLCQ |d CAUOI |d Z5A |d LIV |d MERUC |d ESU |d IOG |d N$T |d CEF |d INT |d U3W |d AU@ |d OCLCQ |d OCLCO |d WYU |d DEHBZ |d YOU |d OCLCQ |d UAB |d UKAHL |d OL$ |d OCLCQ |d OCLCO |d DCT |d ERF |d OCLCQ |d BRF |d OCLCO |d OCLCQ | ||
| 019 | |a 779411136 |a 779881841 |a 785779307 |a 792930262 |a 803439914 |a 1005819828 |a 1064052863 |a 1066478277 |a 1086512778 |a 1086876525 |a 1110822511 |a 1112562553 |a 1129351636 |a 1153040411 |a 1162628363 |a 1192334879 |a 1204010262 |a 1240517144 |a 1296607673 | ||
| 020 | |a 9781430239550 |q (electronic bk.) | ||
| 020 | |a 1430239557 |q (electronic bk.) | ||
| 020 | |z 9781430239543 | ||
| 020 | |z 1430239549 | ||
| 024 | 7 | |a 10.1007/978-1-4302-3955-0 |2 doi | |
| 029 | 1 | |a AU@ |b 000048698976 | |
| 029 | 1 | |a AU@ |b 000053278321 | |
| 029 | 1 | |a AU@ |b 000060583617 | |
| 029 | 1 | |a DEBBG |b BV040901523 | |
| 029 | 1 | |a DEBSZ |b 378288296 | |
| 029 | 1 | |a DEBSZ |b 381375633 | |
| 029 | 1 | |a DEBSZ |b 397270879 | |
| 029 | 1 | |a GBVCP |b 722019998 | |
| 029 | 1 | |a NZ1 |b 14230882 | |
| 029 | 1 | |a NZ1 |b 14685851 | |
| 029 | 1 | |a AU@ |b 000067098980 | |
| 035 | |a (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 | |a CL0500000135 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.D3 |b L49 2011 | |
| 072 | 7 | |a COM |x 021040 |2 bisacsh | |
| 072 | 7 | |a UN |2 bicssc | |
| 072 | 7 | |a UMT |2 bicssc | |
| 082 | 0 | 4 | |a 005.74 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Lewis, Jonathan, |d 1957- | |
| 245 | 1 | 0 | |a Oracle Core : |b essential internals for DBAs and Developers / |c Jonathan Lewis. |
| 260 | |a [Berkeley, CA] : |b Apress ; |a New York : |b Distributed to the Book trade by Springer, |c ©2011. | ||
| 300 | |a 1 online resource (xiv, 266 pages) : |b illustrations, color portraits | ||
| 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 databases | |
| 588 | 0 | |a Online resource; title from PDF title page (EBSCO, viewed November 29, 2017). | |
| 520 | |a 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. | ||
| 505 | 0 | |a 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 | |a 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 | |a 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 | |a Note continued: Oradebug Alternatives -- Data File Blocks -- Log Files -- Guesswork. | |
| 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 blmlsh |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 fast |0 (OCoLC)fst01363816 |
| 650 | 0 | |a Database management. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a COMPUTERS |x Databases |x Data Warehousing. |2 bisacsh | |
| 650 | 7 | |a Informatique. |2 eclas | |
| 650 | 7 | |a Database management. |2 fast |0 (OCoLC)fst00888037 | |
| 650 | 7 | |a ORACLE. |2 gnd | |
| 653 | 4 | |a Computer science. | |
| 653 | 4 | |a Database management. | |
| 773 | 0 | |t Springer eBooks | |
| 776 | 0 | 8 | |i Print version: |a Lewis, Jonathan, 1957- |t Oracle Core. |d [Berkeley, CA] : Apress ; New York : Distributed to the Book trade by Springer, ©2011 |w (DLC) 2012493861 |
| 830 | 0 | |a Expert's voice in databases. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781430239543/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH29391000 | ||
| 938 | |a Books 24x7 |b B247 |n bks00044638 | ||
| 938 | |a EBL - Ebook Library |b EBLB |n EBL883814 | ||
| 938 | |a ebrary |b EBRY |n ebr10530914 | ||
| 938 | |a EBSCOhost |b EBSC |n 1173505 | ||
| 938 | |a YBP Library Services |b YANK |n 7425235 | ||
| 938 | |a YBP Library Services |b YANK |n 6939827 | ||
| 994 | |a 92 |b IZTAP | ||