Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Expert Oracle Database Architecture / / by Thomas Kyte, Darl Kuhn
| Expert Oracle Database Architecture / / by Thomas Kyte, Darl Kuhn |
| Autore | Kyte Thomas |
| Edizione | [3rd ed. 2014.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 |
| Descrizione fisica | 1 online resource (823 p.) |
| Disciplina | 005.7585 |
| Collana | Expert's Voice in Oracle |
| Soggetto topico |
Database management
Software engineering Database Management Software Engineering/Programming and Operating Systems |
| ISBN |
9781430262992
1430262990 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910300475103321 |
Kyte Thomas
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle Database 12c Performance Tuning Recipes : A Problem-Solution Approach / / by Sam Alapati, Darl Kuhn, Bill Padfield
| Oracle Database 12c Performance Tuning Recipes : A Problem-Solution Approach / / by Sam Alapati, Darl Kuhn, Bill Padfield |
| Autore | Alapati Sam |
| Edizione | [1st ed. 2013.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2013 |
| Descrizione fisica | 1 online resource (621 p.) |
| Disciplina | 005.7565 |
| Collana | Expert's Voice in Oracle |
| Soggetto topico |
Database management
Database Management |
| ISBN |
9781430261889
1430261889 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Optimizing table performance -- Choosing and optimizing indexes -- Optimizing instance memory -- Monitoring system performance -- Minimizing system contention -- Analyzing operating system performance -- Troubleshooting the database -- Creating efficient SQL -- Manually tuning SQL -- Tracing SQL execution -- Automated SQL tuning -- Execution plan optimization and consistency -- Configuring the optimizer -- Implementing query hints -- Executing SQL in parallel. |
| Record Nr. | UNINA-9910437971203321 |
|
Alapati Sam
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle Database Transactions and Locking Revealed / / by Thomas Kyte, Darl Kuhn
| Oracle Database Transactions and Locking Revealed / / by Thomas Kyte, Darl Kuhn |
| Autore | Kyte Thomas |
| Edizione | [1st ed. 2014.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 |
| Descrizione fisica | 1 online resource (179 p.) |
| Disciplina |
004
005.11 005.74 |
| Collana | Expert's Voice in Oracle |
| Soggetto topico |
Database management
Computer programming Database Management Programming Techniques |
| ISBN |
9781484207604
1484207602 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Contents at a Glance; Introduction; Chapter 1: Getting Started; Background; Locking; Concurrency Control; Multiversioning; Transactions; Redo and Undo; Summary; Chapter 2: Locking and Issues; What Are Locks?; Lost Updates; Pessimistic Locking; Optimistic Locking; Optimistic Locking Using a Version Column; Optimistic Locking Using a Checksum; Optimistic or Pessimistic Locking?; Blocking; Blocked Inserts; Blocked Merges, Updates, and Deletes; Deadlocks; Lock Escalation; Summary; Chapter 3: Lock Types; DML Locks; TX (Transaction) Locks; TM (DML Enqueue) Locks; DDL Locks; Latches
Latch " Spinning "Measuring the Cost of Latching a Shared Resource; Setting Up for the Test; Without Bind Variables; With Bind Variables; Performance/Scalability Comparison; Mutexes; Manual Locking and User-Defined Locks; Manual Locking; Creating Your Own Locks; Summary; Chapter 4: Concurrency and Multiversioning; What Are Concurrency Controls?; Transaction Isolation Levels; READ UNCOMMITTED; READ COMMITTED; REPEATABLE READ; Getting a Consistent Answer; Lost Updates: Another Portability Issue; SERIALIZABLE; READ ONLY; Implications of Multiversion Read Consistency A Common Data Warehousing Technique That FailsAn Explanation for Higher Than Expected I/O on Hot Tables; Write Consistency; Consistent Reads and Current Reads; Seeing a Restart; Why Is a Restart Important to Us?; Summary; Chapter 5: Transactions; Transaction Control Statements; Atomicity; Statement-Level Atomicity; Procedure-Level Atomicity; Transaction-Level Atomicity; DDL and Atomicity; Durability; WRITE Extensions to COMMIT; COMMITS in a Nondistributed PL/SQL Block; Integrity Constraints and Transactions; IMMEDIATE Constraints; DEFERRABLE Constraints and Cascading Updates Bad Transaction HabitsCommitting in a Loop; Performance Implications; Snapshot Too Old Error; Restartable Processes Require Complex Logic; Using Autocommit; Distributed Transactions; Autonomous Transactions; How Autonomous Transactions Work; When to Use Autonomous Transactions; Summary; Chapter 6: Redo and Undo; What Is Redo?; What Is Undo?; How Redo and Undo Work Together; Example INSERT-UPDATE-DELETE-COMMIT Scenario; The INSERT; Hypothetical Scenario: The System Crashes Right Now; Hypothetical Scenario: The Buffer Cache Fills Up Right Now; The UPDATE Hypothetical Scenario: The System Crashes Right NowHypothetical Scenario: The Application Rolls Back the Transaction; The DELETE; The COMMIT; Commit and Rollback Processing; What Does a COMMIT Do?; What Does a ROLLBACK Do?; Summary; Chapter 7: Investigating Redo; Measuring Redo; Can I Turn Off Redo Log Generation?; Setting NOLOGGING in SQL; Setting NOLOGGING on an Index; NOLOGGING Wrap-up; Why Can't I Allocate a New Log ?; Block Cleanout; Log Contention; Temporary Tables and Redo/Undo; Prior to 12c; Starting with 12c; Summary; Chapter 8: Investigating Undo What Generates the Most and Least Undo? |
| Record Nr. | UNINA-9910300467003321 |
|
Kyte Thomas
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Pro Oracle Database 18c Administration : Manage and Safeguard Your Organization’s Data / / by Michelle Malcher, Darl Kuhn
| Pro Oracle Database 18c Administration : Manage and Safeguard Your Organization’s Data / / by Michelle Malcher, Darl Kuhn |
| Autore | Malcher Michelle |
| Edizione | [3rd ed. 2019.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2019 |
| Descrizione fisica | 1 online resource (1,009 pages) |
| Disciplina | 005.7585 |
| Collana | Expert's Voice in Oracle |
| Soggetto topico |
Database management
Database Management |
| ISBN |
9781484244241
1484244249 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | 1. Installing the Oracle Binaries -- 2. Creating a Database -- 3. Configuring an Efficient Environment -- 4. Tablespaces and Data Files -- 5. Managing Control Files, Online Redo Logs, and Archivelogs -- 6. Users and Basic Security -- 7. Tables and Constraints -- 8. Indexes -- 9. Views, Synonyms, and Sequences -- 10. Data Dictionary Fundamentals -- 11. Large Objects -- 12. Partitioning: Divide and Conquer -- 13. Data Pump -- 14. External Tables -- 15. Materialized Views -- 16. User-Managed Backup and Recovery -- 17. Configuring RMAN -- 18. RMAN Backups and Reporting -- 19. RMAN Restore and Recovery -- 20. Automating Jobs -- 21. Database Troubleshooting -- 22. Pluggable Databases. |
| Record Nr. | UNINA-9910338004403321 |
|
Malcher Michelle
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2019 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Pro Oracle Database 23ai Administration : Manage and Safeguard Your Organization’s Data / / by Michelle Malcher, Darl Kuhn
| Pro Oracle Database 23ai Administration : Manage and Safeguard Your Organization’s Data / / by Michelle Malcher, Darl Kuhn |
| Autore | Malcher Michelle |
| Edizione | [5th ed. 2024.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2024 |
| Descrizione fisica | 1 online resource (612 pages) |
| Disciplina | 005.74 |
| Altri autori (Persone) | KuhnDarl |
| Soggetto topico |
Database management
Database Management |
| ISBN | 9798868810381 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | 1. Installing the Oracle Binaries -- 2. Creating a Database -- 3. Configuring an Efficient Environment -- 4. Tablespaces and Data Files -- 5. Managing Control Files, Online Redo Logs and Archivelogs -- 6. Users and Basic Security -- 7. Tables and Constraints -- 8. Indexes -- 9. Views, Duality Views and Materialized Views -- 10. Data Dictionary Fundamentals -- 11. Large Objects -- 12. Containers and Pluggables -- 13. RMAN Backups and Reporting -- 14. RMAN Restore and Recovery -- 15. External Tables -- 16. Automation and Troubleshooting -- 17. Migration to Multitenant and Fleet Management -- 18. Data Management. |
| Record Nr. | UNINA-9910919810503321 |
|
Malcher Michelle
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2024 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Pro Oracle Database 23c Administration : Manage and Safeguard Your Organization’s Data / / by Michelle Malcher, Darl Kuhn
| Pro Oracle Database 23c Administration : Manage and Safeguard Your Organization’s Data / / by Michelle Malcher, Darl Kuhn |
| Autore | Malcher Michelle |
| Edizione | [4th ed. 2024.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2024 |
| Descrizione fisica | 1 online resource (600 pages) |
| Disciplina | 005.7585 |
| Soggetto topico |
Database management
Relational databases |
| ISBN |
9781484298992
1484298993 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | 1. Installing the Oracle Binaries -- 2. Creating a Database -- 3. Configuring an Efficient Environment -- 4. Tablespaces and Data Files -- 5. Managing Control Files, Online Redo Logs and Archivelogs -- 6. Users and Basic Security -- 7. Tables and Constraints -- 8. Indexes -- 9. Views, Duality Views and Materialized Views -- 10. Data Dictionary Fundamentals -- 11. Large Objects -- 12. Containers and Pluggables -- 13. RMAN Backups and Reporting -- 14. RMAN Restore and Recovery -- 15. External Tables -- 16. Automation and Troubleshooting -- 17. Migration to Multitenant and Fleet Management -- 18. Data Management. . |
| Record Nr. | UNINA-9910799494803321 |
|
Malcher Michelle
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2024 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||