Expert Oracle database architecture : techniques and solutions for high performance and productivity / / Darl Kuhn, Thomas Kyte |
Autore | Kuhn Darl |
Edizione | [Fourth edition.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress, , [2022] |
Descrizione fisica | 1 online resource (lvi, 1123 pages) |
Disciplina | 005.7585 |
Soggetto topico | Relational databases |
ISBN | 1-4842-7499-7 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | 1. Developing Successful Oracle Applications -- 2. Architecture Overview -- 3. Files -- 4. Memory Structures -- 5. Oracle Processes -- 6. Locking and Latching -- 7. Concurrency and Multi-versioning -- 8. Transactions -- 9. Redo and Undo -- 10. Database Tables -- 11. Indexes -- 12. Datatypes -- 13. Partitioning -- 14. Parallel Execution -- 15. Data Loading and Unloading. |
Record Nr. | UNINA-9910522949003321 |
Kuhn Darl | ||
Berkeley, CA : , : Apress, , [2022] | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Expert Oracle Database Architecture : Techniques and Solutions for High Performance and Productivity |
Autore | Kuhn Darl |
Edizione | [4th ed.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress L. P., , 2021 |
Descrizione fisica | 1 online resource (1169 pages) |
Altri autori (Persone) | KyteThomas |
Soggetto genere / forma | Electronic books. |
ISBN |
9781484274996
9781484274989 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910508457303321 |
Kuhn Darl | ||
Berkeley, CA : , : Apress L. P., , 2021 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Expert Oracle Indexing and Access Paths : Maximum Performance for Your Database / / by Darl Kuhn, Sam R Alapati, Bill Padfield |
Autore | Kuhn Darl |
Edizione | [2nd ed. 2016.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2016 |
Descrizione fisica | 1 online resource (XIX, 257 p. 20 illus., 8 illus. in color.) |
Disciplina | 005.74 |
Collana | Expert's Voice in Oracle |
Soggetto topico |
Database management
Database Management |
ISBN |
9781484219843
1484219848 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | 1. Introduction to Oracle Indexes -- 2. B-Tree Indexes -- 3. Bitmap Indexes -- 4. Index-organized Tables -- 5. Specialized Indexes -- 6. Partitioned Indexes -- 7. Tuning Index Usage -- 8. Maintaining Indexes -- 9. SQL Tuning Advisor -- 10. In Memory Column Store. |
Record Nr. | UNINA-9910254753903321 |
Kuhn Darl | ||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2016 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Linux and Solaris Recipes for Oracle DBAs / / by Darl Kuhn, Bernard Lopuz, Charles Kim |
Autore | Kuhn Darl |
Edizione | [2nd ed. 2015.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 |
Descrizione fisica | 1 online resource (485 p.) |
Disciplina | 004 |
Collana | The expert's voice in Oracle |
Soggetto topico |
Database management
Database Management |
ISBN |
9781484212547
1484212541 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Chapter 1: Getting Started -- Chapter 2: Chapter 2: Working in the Shell -- Chapter 3: Managing Processes and Users -- Chapter 4: Creating and Editing Files -- Chapter 5: Managing Files and Directories -- Chapter 6: Archiving and Compressing Files -- Chapter 7: Shell Scripting -- Chapter 8: Analyzing Server Performance -- Chapter 9: Viewing and Configuring System Resources -- Chapter 10: Automating Jobs with cron -- Chapter 11: Managing Server Software -- Chapter 12: VirtualBox for Oracle -- Chapter 13: Optimizing Linux for Oracle Databases -- Chapter 14: Working Securely Across a Network -- Chapter 15: Managing X Window -- Chapter 16: Managing Remote Servers with VNC -- Chapter 17: RAID Concepts -- Chapter 18: Server Log Files. -- Index. |
Record Nr. | UNINA-9910300639203321 |
Kuhn Darl | ||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle Database transactions and locking revealed : building high performance through concurrency / / Darl Kuhn, Thomas Kyte |
Autore | Kuhn Darl |
Edizione | [Second edition.] |
Pubbl/distr/stampa | [Place of publication not identified] : , : Apress, , [2021] |
Descrizione fisica | 1 online resource (XXVIII, 265 p. 12 illus.) |
Disciplina | 005.7585 |
ISBN | 1-4842-6425-8 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | 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. |
Record Nr. | UNINA-9910483256203321 |
Kuhn Darl | ||
[Place of publication not identified] : , : Apress, , [2021] | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle RMAN Database Duplication / / by Darl Kuhn |
Autore | Kuhn Darl |
Edizione | [1st ed. 2015.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 |
Descrizione fisica | 1 online resource (183 p.) |
Disciplina | 005.74 |
Collana | The expert's voice in Oracle |
Soggetto topico |
Database management
Database Management |
ISBN |
9781484211120
148421112X |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Contents at a Glance; Introduction; Chapter 1: Introduction; Use Cases for Duplicating; Methods for Replicating; RMAN Duplicate Advantages; Ease of Use; Performance and Security; Flexible Replication; RMAN Duplication Overview; Definition of Terms; RMAN Duplication Process; Example Setup Environment; Summary; Chapter 2: Manual Duplication Techniques; Cloning from Cold Backup; Copying from an RMAN Backup; Renaming a Database; Manual; NID; Replicating with Data Pump Across a Network Link; Replicating with Data Pump Transportable Tablespaces; RMAN Replication Using Transportable Tablespaces
Same Operating SystemCross-Platform Replication; Different Operating System (Convert Tablespace); Different Operating System (Convert DataFile); Moving Data with External Tables; Enabling Parallelism; Enabling Compression; Summary; Chapter 3: Backup-Based Duplication; Basic Troubleshooting; Checking Syntax; From the Command Line; From a Script; Monitoring Progress; Operating System Approach; SQL Approach; Capturing RMAN Output; RMAN Logging; Script Command; Tee Command; RMAN Command Output View; Targetless Duplication; Directory Structure and Database Name Remain Identical Directory Structure Identical and Database Name DifferentDirectory Structures and Database Names Different, Using SPFILE Clause; Directory Structures and Database Names Different, Not Using SPFILE; Transforming Directory Names via Initialization File; Transforming Directory Names using SET NEWNAME; Shell Scripting the Duplication Process; Duplicating and Stopping Recovery at a Specific Time; Restarting Duplication; Restricting Access after Duplication; Scenarios Requiring Connections to Target; UNTIL Sequence; UNTIL Restore Point; Summary; Chapter 4: Active Duplication Oracle Net ConfigurationSetting Up the Listener; Setting Up the Password File; Same Directory Structure and Database Name; Different Directory Structure and Database Name Using SPFILE Clause; Replicating from a Noarchivelog Mode Target; Same-Host Replication; Image Copies; Compression; Encryption; Summary; Chapter 5: Advanced Topics; Partial Database Duplication; Excluding Tablespaces; Including Tablespaces; Parallelism; Configuring Parallelism; Using SECTION SIZE; Creating Standby Databases; Creating Standby from Active Target; Creating Standby from RMAN Backup Container and Pluggable DatabasesDuplicating a Container Database; Duplicating Pluggable Databases; Including Pluggable Databases; Excluding Pluggable Databases; RAC Databases; Non-RAC/Non-ASM to RAC/ASM; RAC/ASM to Non-RAC/Non-ASM; Summary; Chapter 6: Oracle Net Primer; Oracle Net; Services Default Behavior; Creating and Registering Services with the Listener; Setting SERVICE_NAMES; Setting the LOCAL_LISTENER to contain host and port information; Setting LOCAL_LISTENER to point to an entry in tnsnames.ora; Statically Registering Services; Dynamic Registration versus Static Registration Why Use Multiple Services? |
Altri titoli varianti | Oracle recovery manager database duplication |
Record Nr. | UNINA-9910300642403321 |
Kuhn Darl | ||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle RMAN for Absolute Beginners / / by Darl Kuhn |
Autore | Kuhn Darl |
Edizione | [1st ed. 2014.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 |
Descrizione fisica | 1 online resource (272 p.) |
Disciplina |
004
005.74 |
Collana | The expert's voice in Oracle |
Soggetto topico |
Database management
Database Management |
ISBN |
9781484207635
1484207637 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Contents at a Glance; Introduction; Chapter 1: Getting Started; Connecting to Your Database; Establishing OS Variables; Manually Setting Variables; Using Oracle's Script; Understanding oratab; Using oraenv; Using OS Authentication; Using a Password File; Starting the Database; Stopping the Database; Summary; Chapter 2: Files in Support of Backup and Recovery Operations; Managing Control Files; Viewing Control File Names and Locations; Adding a Control File; Spfile Scenario; Init.ora Scenario; Moving a Control File; Removing a Control File; Managing Online Redo Logs
Displaying Online Redo Log InformationDetermining the Optimal Size of Online Redo Log Groups; Determining the Optimal Number of Redo Log Groups; Adding Online Redo Log Groups; Resizing and Dropping Online Redo Log Groups; Adding Online Redo Log Files to a Group; Removing Online Redo Log Files from a Group; Moving or Renaming Redo Log Files; Implementing Archivelog Mode; Making Architectural Decisions; Setting the Archive Redo File Location; Setting the Archive Location to a User-Defined Disk Location (non-FRA); Using the FRA for Archive Log Files; Enabling Archivelog Mode Disabling Archivelog ModeReacting to a Lack of Disk Space in Your Archive Log Destination; Backing Up Archive Redo Log Files; Managing Tablespaces and Data files; Understanding the First Five; Understanding the Need for More; Creating Tablespaces; Renaming a Tablespace; Controlling the Generation of Redo; Changing a Tablespace's Write Mode; Dropping a Tablespace; Using Oracle Managed Files; Creating a Bigfile Tablespace; Enabling Default Table Compression within a Tablespace; Displaying Tablespace Size; Altering Tablespace Size; Toggling Data Files Offline and Online Renaming or Relocating a Data FilePerforming Online Data File Operations; Performing Offline Data File Operations; Using SQL and OS Commands; Re-Creating the Control File and OS Commands; Summary; Chapter 3: User-Managed Backup and Recovery; Implementing a Cold-Backup Strategy for a Noarchivelog Mode Database; Making a Cold Backup of a Noarchivelog Mode Database; Step 1. Determine Where to Copy the Backup Files and How Much Space Is Required; Step 2. Identify the Locations and Names of the Database Files to Copy; Step 3. Shut Down the Database; Step 4. Create Backup Copies of the Files Step 5. Restart Your DatabaseRestoring a Cold Backup in Noarchivelog Mode with Online Redo Logs; Step 1. Shut Down the Instance; Step 2. Copy the Files Back from the Backup; Step 3. Start Up the Database; Restoring a Cold Backup in Noarchivelog Mode Without Online Redo Logs; Step 1. Shut Down the Instance; Step 2. Copy the Files Back from the Backup; Step 3. Start Up the Database in Mount Mode; Step 4. Open the Database with the OPEN RESETLOGS Clause; Scripting a Cold Backup and Restore; Making a Cold Backup of an Archivelog Mode Database; Implementing a Hot Backup Strategy Making a Hot Backup |
Record Nr. | UNINA-9910300466203321 |
Kuhn Darl | ||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Pro Oracle Database 12c administration / / Darl Kuhn |
Autore | Kuhn Darl |
Edizione | [2nd ed.] |
Pubbl/distr/stampa | Berkeley, CA, : Apress, 2013 |
Descrizione fisica | 1 online resource (xl, 714 pages) : illustrations (some color) |
Disciplina |
004
005.74 005.7565 |
Collana | The Expert's voice in Oracle Pro Oracle database 12c administration |
Soggetto topico | Database management |
ISBN |
9781430257295
1430257296 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
""Contents at a Glance""; ""Contents""; ""About the Author""; ""About the Technical Reviewers""; ""Acknowledgments""; ""Introduction""; ""Chapter 1: Installing the Oracle Binaries""; ""Understanding the OFA""; ""Oracle Inventory Directory""; ""Oracle Base Directory""; ""Oracle Home Directory""; ""Oracle Network Files Directory""; ""Automatic Diagnostic Repository""; ""Installing Oracle""; ""Step 1. Create the OS Groups and User""; ""Step 2. Ensure That the OS Is Adequately Configured""; ""Step 3. Obtain the Oracle Installation Software""; ""Step 4. Unzip the Files""
""Step 5: Creating oraInst.loc File""""Step 6. Configure the Response File, and Run the Installer""; ""Oracle Database 11g Release 2 Scenario""; ""Oracle Database 12c Release 1 Scenario""; ""Step 7. Troubleshoot Any Issues""; ""Installing with a Copy of an Existing Installation""; ""Step 1. Copy the Binaries, Using an OS Utility""; ""Step 2. Attach the Oracle Home""; ""Upgrading Oracle Software""; ""Reinstalling After Failed Installation""; ""Applying Interim Patches""; ""Installing Remotely with the Graphical Installer"" ""Step 1. Install X Software and Networking Utilities on the Local PC""""Step 2. Start an X Session on the Local Computer""; ""Step 3. Copy the Oracle Installation Media to the Remote Server""; ""Step 4. Run the xhost Command""; ""Step 5. Log In to the Remote Computer from X""; ""Step 6. Ensure that the DISPLAY Variable Is Set Correctly on the Remote Computer""; ""Step 7. Execute the runInstaller Utility""; ""Step 8. Troubleshoot""; ""Summary""; ""Chapter 2: Implementing a Database""; ""Setting OS Variables""; ""A Manually Intensive Approach""; ""Oracle�s Approach to Setting OS Variables"" ""Understanding oratab""""Using oraenv""; ""My Approach to Setting OS Variables""; ""Creating a Database""; ""Step 1. Set the OS Variables""; ""Step 2: Configure the Initialization File""; ""Step 3: Create the Required Directories""; ""Step 4: Create the Database""; ""Step 5. Create a Data Dictionary""; ""Configuring and Implementing the Listener""; ""Manually Configuring a Listener""; ""Implementing a Listener with the Net Configuration Assistant""; ""Connecting to a Database through the Network""; ""Creating a Password File""; ""Starting and Stopping the Database"" ""Understanding OS Authentication""""Starting the Database""; ""Stopping the Database""; ""Using the dbca to Create a Database""; ""Dropping a Database""; ""How Many Databases on One Server?""; ""Understanding Oracle Architecture""; ""Summary""; ""Chapter 3: Configuring an Efficient Environment""; ""Customizing Your OS Command Prompt""; ""Customizing Your SQL Prompt""; ""Creating Shortcuts for Frequently Used Commands""; ""Using Aliases""; ""Using a Function""; ""Rerunning Commands Quickly""; ""Scrolling with the Up and Down Arrow Keys""; ""Using Ctrl+P and Ctrl+N"" ""Listing the Command History"" |
Record Nr. | UNINA-9910438099503321 |
Kuhn Darl | ||
Berkeley, CA, : Apress, 2013 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
RMAN recipes for Oracle Database 12c : a problem-solution approach / / Darl Kuhn, Sam Alapati, Arup Nanda |
Autore | Kuhn Darl |
Edizione | [2nd ed.] |
Pubbl/distr/stampa | [Berkeley, Calif.], : Apress, c2013 |
Descrizione fisica | 1 online resource (lxvi, 730 pages) : illustrations (some color) |
Disciplina |
004
005.74 005.86 |
Altri autori (Persone) |
AlapatiSam
NandaArup |
Collana | The expert's voice in Oracle |
Soggetto topico |
Electronic data processing - Backup processing alternatives
Data recovery (Computer science) Relational databases |
ISBN |
9781430248378
1430248378 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
""Contents at a Glance""; ""Contents""; ""Foreword""; ""About the Authors""; ""About the Technical Reviewers""; ""Acknowledgments""; ""Introduction""; ""Chapter 1: Backup and Recovery 101""; ""Types of Database Failures""; ""Statement Failure""; ""User Process Failure""; ""Network Failure""; ""Instance Failure""; ""User Error""; ""Media Failure""; ""Oracle Backup and Recovery Concepts""; ""Backup and Recovery Instance Architecture""; ""The Checkpoint Process""; ""The Log Writer Process""; ""The Archiver Process""; ""Physical Database Structures Used in Recovering Data""
""Archivelog and Noarchivelog Mode of Operation""""Flashback Technology""; ""Backup Types""; ""Physical and Logical Backups""; ""Whole and Partial Backups""; ""Online and Offline Backups""; ""Full and Incremental Backups""; ""Consistent and Inconsistent Backups""; ""Recovery Types""; ""Database Recovery and Consistent vs. Inconsistent Backups""; ""Crash Recovery and Media Recovery""; ""Crash Recovery""; ""Media Recovery""; ""Complete and Point-in-Time Recovery""; ""Deciding on the Appropriate Recovery Technique""; ""RMAN Architecture""; ""Benefits of Using RMAN"" ""Backup and Recovery Best Practices""""Configure a Fast Recovery Area""; ""Make and Protect a Database Redundancy Set""; ""Create Powerful Backup Strategies""; ""Schedule Regular Backups""; ""Create Regular Backups of the Control File""; ""Run the Database in Archivelog Mode""; ""Multiplex the Control File""; ""Multiplex the Redo Log Groups""; ""Adopt the Right Backup Storage Strategy""; ""Plan Your Backup-Retention Duration""; ""Plan Your Backup Schedules""; ""Validate Your Recovery Strategy""; ""Conduct Regular Trial Recoveries""; ""Record Accurate Software and Hardware Configuration"" ""Chapter 2: Jump-Starting RMAN""""2-1. Connecting to Your Database""; ""Problem""; ""Solution""; ""Establishing OS Variables""; ""Using OS Authentication""; ""Using a Password File""; ""How It Works""; ""Explaining OS Authentication""; ""Explaining Password File Authentication""; ""2-2. Starting and Stopping Your Database""; ""Problem""; ""Solution""; ""How It Works""; ""2-3. Toggling Archivelog Mode""; ""Problem""; ""Solution""; ""Enabling Archivelog Mode""; ""Disabling Archivelog Mode""; ""How It Works""; ""2-4. Connecting to RMAN""; ""Problem""; ""Solution""; ""How It Works"" ""2-5. Backing Up Your Database""""Problem""; ""Solution""; ""How It Works""; ""2-6. Simulating a Failure""; ""Problem""; ""Solution""; ""How It Works""; ""2-7. Restoring and Recovering Your Database""; ""Problem""; ""Solution""; ""How It Works""; ""Chapter 3: Using the Fast Recovery Area""; ""3-1. Creating the Fast Recovery Area""; ""Problem""; ""Solution""; ""How It Works""; ""3-2. Writing Regular RMAN Backups to the FRA""; ""Problem""; ""Solution""; ""How It Works""; ""3-3. Freeing FRA Space in an Emergency""; ""Problem""; ""Solution 1: Delete Unneeded Files"" ""Solution 2: Increase Space"" |
Altri titoli varianti | Recovery Manager recipes for Oracle Database twelve c |
Record Nr. | UNINA-9910438097603321 |
Kuhn Darl | ||
[Berkeley, Calif.], : Apress, c2013 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|