國立虎尾科技大學 |

Oracle Database Transactions and Locking Revealed = Building High Performance Through Concurrency /

Record Type:	Language materials, printed : Monograph/item
Title/Author:	Oracle Database Transactions and Locking Revealed/ by Darl Kuhn, Thomas Kyte.
Reminder of title:	Building High Performance Through Concurrency /
Author:	Kuhn, Darl.
other author:	Kyte, Thomas.
Description:	XXVIII, 265 p. 12 illus.online resource. :
Contained By:	Springer Nature eBook
Subject:	Database management. -
Online resource:	https://doi.org/10.1007/978-1-4842-6425-6
ISBN:	9781484264256

Oracle Database Transactions and Locking Revealed = Building High Performance Through Concurrency /
Kuhn, Darl.

Oracle Database Transactions and Locking RevealedBuilding High Performance Through Concurrency /[electronic resource] :by Darl Kuhn, Thomas Kyte. - 2nd ed. 2021. - XXVIII, 265 p. 12 illus.online resource.

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.

ISBN: 9781484264256

Standard No.: 10.1007/978-1-4842-6425-6doiSubjects--Topical Terms:

557799
Database management.

LC Class. No.: QA76.9.D3

Dewey Class. No.: 005.74

Oracle Database Transactions and Locking Revealed = Building High Performance Through Concurrency /
LDR:03924nam a22003975i 4500 001 1050188
003 DE-He213
005 20210622111948.0
007 cr nn 008mamaa
008 220103s2021 xxu| s |||| 0|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 978-1-4842-6425-6
050 4 $a QA76.9.D3
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
072 7 $a UMT $2 thema
082 0 4 $a 005.74 $2 23
100 1 $a Kuhn, Darl. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 792342
245 1 0 $a Oracle Database Transactions and Locking Revealed $h [electronic resource] : $b Building High Performance Through Concurrency / $c by Darl Kuhn, Thomas Kyte.
250 $a 2nd ed. 2021.
264 1 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2021.
300 $a XXVIII, 265 p. 12 illus. $b online resource.
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
505 0 $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. 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.
650 0 $a Database management. $3 557799
650 1 4 $a Database Management. $3 669820
700 1 $a Kyte, Thomas. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 673358
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9781484264249
776 0 8 $i Printed edition: $z 9781484264263
856 4 0 $u https://doi.org/10.1007/978-1-4842-6425-6
912 $a ZDB-2-CWD
912 $a ZDB-2-SXPC
950 $a Professional and Applied Computing (SpringerNature-12059)
950 $a Professional and Applied Computing (R0) (SpringerNature-43716)