Oracle database transactions and locking revealed: building high performance through concurrency
Access much-needed information for building scalable, high-concurrency applications and deploying them against the Oracle Database. This new edition is updated to be current with Oracle Database 19. It includes a new chapter with troubleshooting recipes to help you quickly diagnose and resolve locki...
Gespeichert in:
| Beteiligte Personen: | , |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | Englisch |
| Veröffentlicht: |
Berkeley, CA
Apress
[2021]
|
| Ausgabe: | Second edition |
| Schlagwörter: | |
| Links: | https://doi.org/10.1007/978-1-4842-6425-6 https://doi.org/10.1007/978-1-4842-6425-6 https://doi.org/10.1007/978-1-4842-6425-6 https://doi.org/10.1007/978-1-4842-6425-6 https://doi.org/10.1007/978-1-4842-6425-6 https://doi.org/10.1007/978-1-4842-6425-6 https://doi.org/10.1007/978-1-4842-6425-6 https://doi.org/10.1007/978-1-4842-6425-6 https://doi.org/10.1007/978-1-4842-6425-6 https://doi.org/10.1007/978-1-4842-6425-6 https://doi.org/10.1007/978-1-4842-6425-6 https://doi.org/10.1007/978-1-4842-6425-6 https://doi.org/10.1007/978-1-4842-6425-6 https://doi.org/10.1007/978-1-4842-6425-6 https://doi.org/10.1007/978-1-4842-6425-6 https://doi.org/10.1007/978-1-4842-6425-6 |
| Zusammenfassung: | Access much-needed information for building scalable, high-concurrency applications and deploying them against the Oracle Database. This new edition is updated to be current with Oracle Database 19. It includes a new chapter with troubleshooting recipes to help you quickly diagnose and resolve locking problems that are urgent and block production. Good transaction design is an important facet of highly-concurrent applications that are run by hundreds, even thousands, of users who are executing transactions at the same time. Transaction design, in turn, relies on a good understanding of how the database engine manages the locking of resources to prevent access conflicts and data loss that might otherwise result from concurrent access to data in the database. This book provides a solid and accurate explanation of how locking and concurrency are dealt with by Oracle Database. You will learn how the Oracle Database architecture accommodates user transactions, and how you can write code to mesh with the way in which Oracle Database is designed to operate. Oracle Database Transactions and Locking Revealed covers in detail the various lock types, and also different locking schemes such as pessimistic and optimistic locking. Then you will learn about transaction isolation and multi-version concurrency, and how the various lock types support Oracle Database's transactional features. You will learn tips for transaction design, as well as some bad practices and habits to avoid. Coverage is also given to redo and undo, and their role in concurrency. The book is loaded with insightful code examples that drive home each concept. This is an important book that anyone developing highly-concurrent applications will want to have handy on their shelf. You will: Avoid application lockups due to conflicts over accessing the same resource Understand how Oracle prevents one application from overwriting another's modifications Create transaction designs that mesh with how Oracle Database is designed Build high-throughput applications supporting thousands of concurrent users Design applications to take full advantage of Oracle's powerful database engine Gain a fundamental knowledge of Oracle's transaction and locking architecture Develop techniques to quickly diagnose and resolve common locking issues |
| Beschreibung: | 1. Getting Started -- 2. Locking and Blocking -- 3. Locks, Latches, and Mutexes -- 4. Concurrency and Multiversioning -- 5. Transactions -- 6. Redo and Undo -- 7. Investigating Redo -- 8. Investigating Undo -- 9. Troubleshooting |
| Umfang: | 1 Online-Ressource (xxviii, 265 Seiten) Illustrationen |
| ISBN: | 9781484264256 |
| DOI: | 10.1007/978-1-4842-6425-6 |
Internformat
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV046957552 | ||
| 003 | DE-604 | ||
| 005 | 20221011 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 201023s2021 xx a||| o|||| 00||| eng d | ||
| 020 | |a 9781484264256 |9 978-1-4842-6425-6 | ||
| 024 | 7 | |a 10.1007/978-1-4842-6425-6 |2 doi | |
| 035 | |a (ZDB-2-CWD)978-1-4842-6425-6 | ||
| 035 | |a (OCoLC)1220905582 | ||
| 035 | |a (DE-599)BVBBV046957552 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-863 |a DE-862 |a DE-573 |a DE-M347 |a DE-1043 |a DE-1050 |a DE-1046 |a DE-1047 |a DE-188 |a DE-898 |a DE-859 |a DE-523 |a DE-92 |a DE-20 |a DE-Aug4 |a DE-1051 |a DE-860 | ||
| 082 | 0 | |a 005.74 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Kuhn, Darl |e Verfasser |0 (DE-588)1098317459 |4 aut | |
| 245 | 1 | 0 | |a Oracle database transactions and locking revealed |b building high performance through concurrency |c Darl Kuhn, Thomas Kyte |
| 250 | |a Second edition | ||
| 264 | 1 | |a Berkeley, CA |b Apress |c [2021] | |
| 300 | |a 1 Online-Ressource (xxviii, 265 Seiten) |b Illustrationen | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 500 | |a 1. Getting Started -- 2. Locking and Blocking -- 3. Locks, Latches, and Mutexes -- 4. Concurrency and Multiversioning -- 5. Transactions -- 6. Redo and Undo -- 7. Investigating Redo -- 8. Investigating Undo -- 9. Troubleshooting | ||
| 520 | |a Access much-needed information for building scalable, high-concurrency applications and deploying them against the Oracle Database. This new edition is updated to be current with Oracle Database 19. It includes a new chapter with troubleshooting recipes to help you quickly diagnose and resolve locking problems that are urgent and block production. Good transaction design is an important facet of highly-concurrent applications that are run by hundreds, even thousands, of users who are executing transactions at the same time. Transaction design, in turn, relies on a good understanding of how the database engine manages the locking of resources to prevent access conflicts and data loss that might otherwise result from concurrent access to data in the database. This book provides a solid and accurate explanation of how locking and concurrency are dealt with by Oracle Database. | ||
| 520 | |a You will learn how the Oracle Database architecture accommodates user transactions, and how you can write code to mesh with the way in which Oracle Database is designed to operate. Oracle Database Transactions and Locking Revealed covers in detail the various lock types, and also different locking schemes such as pessimistic and optimistic locking. Then you will learn about transaction isolation and multi-version concurrency, and how the various lock types support Oracle Database's transactional features. You will learn tips for transaction design, as well as some bad practices and habits to avoid. Coverage is also given to redo and undo, and their role in concurrency. The book is loaded with insightful code examples that drive home each concept. This is an important book that anyone developing highly-concurrent applications will want to have handy on their shelf. | ||
| 520 | |a You will: Avoid application lockups due to conflicts over accessing the same resource Understand how Oracle prevents one application from overwriting another's modifications Create transaction designs that mesh with how Oracle Database is designed Build high-throughput applications supporting thousands of concurrent users Design applications to take full advantage of Oracle's powerful database engine Gain a fundamental knowledge of Oracle's transaction and locking architecture Develop techniques to quickly diagnose and resolve common locking issues | ||
| 650 | 4 | |a Database management | |
| 650 | 0 | 7 | |a ORACLE |g Datenbanksystem |0 (DE-588)4206222-6 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |D s |
| 689 | 0 | 1 | |a ORACLE |g Datenbanksystem |0 (DE-588)4206222-6 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Kyte, Thomas |d 1965- |e Verfasser |0 (DE-588)1231739282 |4 aut | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 978-1-4842-6424-9 |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 978-1-4842-6426-3 |
| 856 | 4 | 0 | |u https://doi.org/10.1007/978-1-4842-6425-6 |x Verlag |z URL des Erstveröffentlichers |3 Volltext |
| 912 | |a ZDB-2-CWD | ||
| 912 | |a ZDB-2-SXPC | ||
| 940 | 1 | |q ZDB-2-CWD_2021 | |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-032365957 | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-6425-6 |l DE-1043 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-6425-6 |l DE-1046 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-6425-6 |l DE-Aug4 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-6425-6 |l DE-1050 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-6425-6 |l DE-573 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-6425-6 |l DE-M347 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-6425-6 |l DE-92 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-6425-6 |l DE-1051 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-6425-6 |l DE-898 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-6425-6 |l DE-859 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-6425-6 |l DE-860 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-6425-6 |l DE-863 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-6425-6 |l DE-862 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-6425-6 |l DE-523 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-6425-6 |l DE-20 |p ZDB-2-CWD |x Verlag |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1818987377767481344 |
|---|---|
| any_adam_object | |
| author | Kuhn, Darl Kyte, Thomas 1965- |
| author_GND | (DE-588)1098317459 (DE-588)1231739282 |
| author_facet | Kuhn, Darl Kyte, Thomas 1965- |
| author_role | aut aut |
| author_sort | Kuhn, Darl |
| author_variant | d k dk t k tk |
| building | Verbundindex |
| bvnumber | BV046957552 |
| classification_rvk | ST 271 |
| collection | ZDB-2-CWD ZDB-2-SXPC |
| ctrlnum | (ZDB-2-CWD)978-1-4842-6425-6 (OCoLC)1220905582 (DE-599)BVBBV046957552 |
| dewey-full | 005.74 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.74 |
| dewey-search | 005.74 |
| dewey-sort | 15.74 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| doi_str_mv | 10.1007/978-1-4842-6425-6 |
| edition | Second edition |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>05927nam a2200697zc 4500</leader><controlfield tag="001">BV046957552</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20221011 </controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">201023s2021 xx a||| o|||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781484264256</subfield><subfield code="9">978-1-4842-6425-6</subfield></datafield><datafield tag="024" ind1="7" ind2=" "><subfield code="a">10.1007/978-1-4842-6425-6</subfield><subfield code="2">doi</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-2-CWD)978-1-4842-6425-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1220905582</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV046957552</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield><subfield code="a">DE-862</subfield><subfield code="a">DE-573</subfield><subfield code="a">DE-M347</subfield><subfield code="a">DE-1043</subfield><subfield code="a">DE-1050</subfield><subfield code="a">DE-1046</subfield><subfield code="a">DE-1047</subfield><subfield code="a">DE-188</subfield><subfield code="a">DE-898</subfield><subfield code="a">DE-859</subfield><subfield code="a">DE-523</subfield><subfield code="a">DE-92</subfield><subfield code="a">DE-20</subfield><subfield code="a">DE-Aug4</subfield><subfield code="a">DE-1051</subfield><subfield code="a">DE-860</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Kuhn, Darl</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1098317459</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Oracle database transactions and locking revealed</subfield><subfield code="b">building high performance through concurrency</subfield><subfield code="c">Darl Kuhn, Thomas Kyte</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Second edition</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Berkeley, CA</subfield><subfield code="b">Apress</subfield><subfield code="c">[2021]</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xxviii, 265 Seiten)</subfield><subfield code="b">Illustrationen</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">1. Getting Started -- 2. Locking and Blocking -- 3. Locks, Latches, and Mutexes -- 4. Concurrency and Multiversioning -- 5. Transactions -- 6. Redo and Undo -- 7. Investigating Redo -- 8. Investigating Undo -- 9. Troubleshooting</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Access much-needed information for building scalable, high-concurrency applications and deploying them against the Oracle Database. This new edition is updated to be current with Oracle Database 19. It includes a new chapter with troubleshooting recipes to help you quickly diagnose and resolve locking problems that are urgent and block production. Good transaction design is an important facet of highly-concurrent applications that are run by hundreds, even thousands, of users who are executing transactions at the same time. Transaction design, in turn, relies on a good understanding of how the database engine manages the locking of resources to prevent access conflicts and data loss that might otherwise result from concurrent access to data in the database. This book provides a solid and accurate explanation of how locking and concurrency are dealt with by Oracle Database. </subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">You will learn how the Oracle Database architecture accommodates user transactions, and how you can write code to mesh with the way in which Oracle Database is designed to operate. Oracle Database Transactions and Locking Revealed covers in detail the various lock types, and also different locking schemes such as pessimistic and optimistic locking. Then you will learn about transaction isolation and multi-version concurrency, and how the various lock types support Oracle Database's transactional features. You will learn tips for transaction design, as well as some bad practices and habits to avoid. Coverage is also given to redo and undo, and their role in concurrency. The book is loaded with insightful code examples that drive home each concept. This is an important book that anyone developing highly-concurrent applications will want to have handy on their shelf. </subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">You will: Avoid application lockups due to conflicts over accessing the same resource Understand how Oracle prevents one application from overwriting another's modifications Create transaction designs that mesh with how Oracle Database is designed Build high-throughput applications supporting thousands of concurrent users Design applications to take full advantage of Oracle's powerful database engine Gain a fundamental knowledge of Oracle's transaction and locking architecture Develop techniques to quickly diagnose and resolve common locking issues</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">ORACLE</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Kyte, Thomas</subfield><subfield code="d">1965-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1231739282</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">978-1-4842-6424-9</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">978-1-4842-6426-3</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="x">Verlag</subfield><subfield code="z">URL des Erstveröffentlichers</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-2-CWD</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-2-SXPC</subfield></datafield><datafield tag="940" ind1="1" ind2=" "><subfield code="q">ZDB-2-CWD_2021</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-032365957</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="l">DE-1043</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="l">DE-1046</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="l">DE-Aug4</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="l">DE-1050</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="l">DE-573</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="l">DE-M347</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="l">DE-92</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="l">DE-1051</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="l">DE-898</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="l">DE-859</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="l">DE-860</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="l">DE-863</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="l">DE-862</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="l">DE-523</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-6425-6</subfield><subfield code="l">DE-20</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV046957552 |
| illustrated | Illustrated |
| indexdate | 2024-12-20T19:05:44Z |
| institution | BVB |
| isbn | 9781484264256 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-032365957 |
| oclc_num | 1220905582 |
| open_access_boolean | |
| owner | DE-863 DE-BY-FWS DE-862 DE-BY-FWS DE-573 DE-M347 DE-1043 DE-1050 DE-1046 DE-1047 DE-188 DE-898 DE-BY-UBR DE-859 DE-523 DE-92 DE-20 DE-Aug4 DE-1051 DE-860 |
| owner_facet | DE-863 DE-BY-FWS DE-862 DE-BY-FWS DE-573 DE-M347 DE-1043 DE-1050 DE-1046 DE-1047 DE-188 DE-898 DE-BY-UBR DE-859 DE-523 DE-92 DE-20 DE-Aug4 DE-1051 DE-860 |
| physical | 1 Online-Ressource (xxviii, 265 Seiten) Illustrationen |
| psigel | ZDB-2-CWD ZDB-2-SXPC ZDB-2-CWD_2021 |
| publishDate | 2021 |
| publishDateSearch | 2021 |
| publishDateSort | 2021 |
| publisher | Apress |
| record_format | marc |
| spelling | Kuhn, Darl Verfasser (DE-588)1098317459 aut Oracle database transactions and locking revealed building high performance through concurrency Darl Kuhn, Thomas Kyte Second edition Berkeley, CA Apress [2021] 1 Online-Ressource (xxviii, 265 Seiten) Illustrationen txt rdacontent c rdamedia cr rdacarrier 1. Getting Started -- 2. Locking and Blocking -- 3. Locks, Latches, and Mutexes -- 4. Concurrency and Multiversioning -- 5. Transactions -- 6. Redo and Undo -- 7. Investigating Redo -- 8. Investigating Undo -- 9. Troubleshooting Access much-needed information for building scalable, high-concurrency applications and deploying them against the Oracle Database. This new edition is updated to be current with Oracle Database 19. It includes a new chapter with troubleshooting recipes to help you quickly diagnose and resolve locking problems that are urgent and block production. Good transaction design is an important facet of highly-concurrent applications that are run by hundreds, even thousands, of users who are executing transactions at the same time. Transaction design, in turn, relies on a good understanding of how the database engine manages the locking of resources to prevent access conflicts and data loss that might otherwise result from concurrent access to data in the database. This book provides a solid and accurate explanation of how locking and concurrency are dealt with by Oracle Database. You will learn how the Oracle Database architecture accommodates user transactions, and how you can write code to mesh with the way in which Oracle Database is designed to operate. Oracle Database Transactions and Locking Revealed covers in detail the various lock types, and also different locking schemes such as pessimistic and optimistic locking. Then you will learn about transaction isolation and multi-version concurrency, and how the various lock types support Oracle Database's transactional features. You will learn tips for transaction design, as well as some bad practices and habits to avoid. Coverage is also given to redo and undo, and their role in concurrency. The book is loaded with insightful code examples that drive home each concept. This is an important book that anyone developing highly-concurrent applications will want to have handy on their shelf. You will: Avoid application lockups due to conflicts over accessing the same resource Understand how Oracle prevents one application from overwriting another's modifications Create transaction designs that mesh with how Oracle Database is designed Build high-throughput applications supporting thousands of concurrent users Design applications to take full advantage of Oracle's powerful database engine Gain a fundamental knowledge of Oracle's transaction and locking architecture Develop techniques to quickly diagnose and resolve common locking issues Database management ORACLE Datenbanksystem (DE-588)4206222-6 gnd rswk-swf Datenbankverwaltung (DE-588)4389357-0 gnd rswk-swf Datenbankverwaltung (DE-588)4389357-0 s ORACLE Datenbanksystem (DE-588)4206222-6 s DE-604 Kyte, Thomas 1965- Verfasser (DE-588)1231739282 aut Erscheint auch als Druck-Ausgabe 978-1-4842-6424-9 Erscheint auch als Druck-Ausgabe 978-1-4842-6426-3 https://doi.org/10.1007/978-1-4842-6425-6 Verlag URL des Erstveröffentlichers Volltext |
| spellingShingle | Kuhn, Darl Kyte, Thomas 1965- Oracle database transactions and locking revealed building high performance through concurrency Database management ORACLE Datenbanksystem (DE-588)4206222-6 gnd Datenbankverwaltung (DE-588)4389357-0 gnd |
| subject_GND | (DE-588)4206222-6 (DE-588)4389357-0 |
| title | Oracle database transactions and locking revealed building high performance through concurrency |
| title_auth | Oracle database transactions and locking revealed building high performance through concurrency |
| title_exact_search | Oracle database transactions and locking revealed building high performance through concurrency |
| title_full | Oracle database transactions and locking revealed building high performance through concurrency Darl Kuhn, Thomas Kyte |
| title_fullStr | Oracle database transactions and locking revealed building high performance through concurrency Darl Kuhn, Thomas Kyte |
| title_full_unstemmed | Oracle database transactions and locking revealed building high performance through concurrency Darl Kuhn, Thomas Kyte |
| title_short | Oracle database transactions and locking revealed |
| title_sort | oracle database transactions and locking revealed building high performance through concurrency |
| title_sub | building high performance through concurrency |
| topic | Database management ORACLE Datenbanksystem (DE-588)4206222-6 gnd Datenbankverwaltung (DE-588)4389357-0 gnd |
| topic_facet | Database management ORACLE Datenbanksystem Datenbankverwaltung |
| url | https://doi.org/10.1007/978-1-4842-6425-6 |
| work_keys_str_mv | AT kuhndarl oracledatabasetransactionsandlockingrevealedbuildinghighperformancethroughconcurrency AT kytethomas oracledatabasetransactionsandlockingrevealedbuildinghighperformancethroughconcurrency |