Author: Kevin Loney
Publisher: McGraw Hill Professional
ISBN: 0071770437
Category : Computers
Languages : en
Pages : 737
Book Description
Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it’s been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author.
Oracle Database 11g DBA Handbook
Author: Bob Bryla
Publisher: McGraw Hill Professional
ISBN: 0071595791
Category : Computers
Languages : en
Pages : 698
Book Description
The Essential Resource for Oracle DBAs--Fully Updated and Expanded Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces Optimize disk allocation, CPU usage, I/O throughput, and SQL queries Develop powerful database management applications Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management Diagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning Sets Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import Work with networked databases, data warehouses, and VLDBs Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more
Publisher: McGraw Hill Professional
ISBN: 0071595791
Category : Computers
Languages : en
Pages : 698
Book Description
The Essential Resource for Oracle DBAs--Fully Updated and Expanded Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces Optimize disk allocation, CPU usage, I/O throughput, and SQL queries Develop powerful database management applications Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management Diagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning Sets Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import Work with networked databases, data warehouses, and VLDBs Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more
Oracle Database 12c DBA Handbook
Author: Bob Bryla
Publisher: McGraw Hill Professional
ISBN: 007179879X
Category : Computers
Languages : en
Pages : 745
Book Description
The definitive reference for every Oracle DBA—completely updated for Oracle Database 12c Oracle Database 12c DBA Handbook is the quintessential tool for the DBA with an emphasis on the big picture—enabling administrators to achieve effective and efficient database management. Fully revised to cover every new feature and utility, this Oracle Press guide shows how to harness cloud capability, perform a new installation, upgrade from previous versions, configure hardware and software, handle backup and recovery, and provide failover capability. The newly revised material features high-level and practical content on cloud integration, storage management, performance tuning, information management, and the latest on a completely revised security program. Shows how to administer a scalable, flexible Oracle enterprise database Includes new chapters on cloud integration, new security capabilities, and other cutting-edge features All code and examples available online
Publisher: McGraw Hill Professional
ISBN: 007179879X
Category : Computers
Languages : en
Pages : 745
Book Description
The definitive reference for every Oracle DBA—completely updated for Oracle Database 12c Oracle Database 12c DBA Handbook is the quintessential tool for the DBA with an emphasis on the big picture—enabling administrators to achieve effective and efficient database management. Fully revised to cover every new feature and utility, this Oracle Press guide shows how to harness cloud capability, perform a new installation, upgrade from previous versions, configure hardware and software, handle backup and recovery, and provide failover capability. The newly revised material features high-level and practical content on cloud integration, storage management, performance tuning, information management, and the latest on a completely revised security program. Shows how to administer a scalable, flexible Oracle enterprise database Includes new chapters on cloud integration, new security capabilities, and other cutting-edge features All code and examples available online
Oracle Data Guard 11g Handbook
Author: Larry Carpenter
Publisher: McGraw Hill Professional
ISBN: 0071621482
Category : Computers
Languages : en
Pages : 545
Book Description
Master Oracle Data Guard 11g Provide superior data protection, availability, and disaster recovery using the tested techniques in this Oracle Press guide. Cowritten by a team of Oracle experts, Oracle Data Guard 11g Handbook provides a sound architectural foundation along with best practices for configuration, monitoring, maintenance, and troubleshooting. You will get full details on implementing deployment architectures to address requirements that extend beyond disaster recovery. This invaluable resource also includes a complete set of monitoring scripts available for download. Develop a disaster recovery plan for your Oracle database to meet your organization's requirements Configure and deploy Oracle Data Guard for your environment Tune and troubleshoot your physical and logical standby databases Implement the Oracle Data Guard Broker management framework Integrate with Oracle Grid Control Monitor your Oracle Data Guard environment Enable read-only services and disaster recovery with Oracle Active Data Guard Configure seamless database and application failover Minimize planned downtime using Oracle Data Guard switchover Handle backup and recovery with Oracle Recovery Manager
Publisher: McGraw Hill Professional
ISBN: 0071621482
Category : Computers
Languages : en
Pages : 545
Book Description
Master Oracle Data Guard 11g Provide superior data protection, availability, and disaster recovery using the tested techniques in this Oracle Press guide. Cowritten by a team of Oracle experts, Oracle Data Guard 11g Handbook provides a sound architectural foundation along with best practices for configuration, monitoring, maintenance, and troubleshooting. You will get full details on implementing deployment architectures to address requirements that extend beyond disaster recovery. This invaluable resource also includes a complete set of monitoring scripts available for download. Develop a disaster recovery plan for your Oracle database to meet your organization's requirements Configure and deploy Oracle Data Guard for your environment Tune and troubleshoot your physical and logical standby databases Implement the Oracle Data Guard Broker management framework Integrate with Oracle Grid Control Monitor your Oracle Data Guard environment Enable read-only services and disaster recovery with Oracle Active Data Guard Configure seamless database and application failover Minimize planned downtime using Oracle Data Guard switchover Handle backup and recovery with Oracle Recovery Manager
Oracle Database 10g: A Beginner's Guide
Author: Ian Abramson
Publisher: McGraw-Hill Companies
ISBN:
Category : Computers
Languages : en
Pages : 430
Book Description
Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you’ll get the fundamentals applicable to all Oracle database releases.
Publisher: McGraw-Hill Companies
ISBN:
Category : Computers
Languages : en
Pages : 430
Book Description
Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you’ll get the fundamentals applicable to all Oracle database releases.
OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)
Author: John Watson
Publisher: McGraw Hill Professional
ISBN: 0071591036
Category : Computers
Languages : en
Pages : 770
Book Description
A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11g Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including: Database architecture Creating an Oracle Database Managing the Oracle instance Configuring and managing the Oracle network Managing database storage structures Administering user security Managing schema objects, data and concurrency, and undo data Implementing Oracle Database security Database maintenance and performance management Backup and recovery Moving data Intelligent infrastructure enhancements On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration
Publisher: McGraw Hill Professional
ISBN: 0071591036
Category : Computers
Languages : en
Pages : 770
Book Description
A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11g Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including: Database architecture Creating an Oracle Database Managing the Oracle instance Configuring and managing the Oracle network Managing database storage structures Administering user security Managing schema objects, data and concurrency, and undo data Implementing Oracle Database security Database maintenance and performance management Backup and recovery Moving data Intelligent infrastructure enhancements On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration
Beginning Oracle Database 11G Administration:From Novice To Professional
Author: Iggy Fernandez
Publisher: Dreamtech Press
ISBN: 9788184892161
Category :
Languages : en
Pages : 466
Book Description
Open the door to a career as an Oracle database administrator as you learn to plan for and install the Oracle Database software. Then learn the rudiments of database administration from longtime Oracle expert Iggy Fernandez. Take advantage of the high demand for Oracle expertise and use Beginning Oracle Database 11g Administration to launch you on the right track to Oracle DBA career success.Part 1: Database ConceptsChapter 1: Relational Database Management SystemsChapter 2: SQL and PL/SQLChapter 3: Oracle ArchitecturePart II: Database ImplementationChapter 4: PlanningChapter 5: Software InstallationChapter 6: Database CreationChapter 7: Physical Database DesignChapter 8: User Management and Data LoadingPart III: Database SupportChapter 9: Taking ControlChapter 10: MonitoringChapter 11: Fixing ProblemsChapter 12: BackUpsChapter 13: RecoveryChapter 14: Database MaintenanceChapter 15: The Big Picture and the Ten DeliverablesPart IV: Database TuningChapter 16: Instance TuningChapter 17: SQL Tuning
Publisher: Dreamtech Press
ISBN: 9788184892161
Category :
Languages : en
Pages : 466
Book Description
Open the door to a career as an Oracle database administrator as you learn to plan for and install the Oracle Database software. Then learn the rudiments of database administration from longtime Oracle expert Iggy Fernandez. Take advantage of the high demand for Oracle expertise and use Beginning Oracle Database 11g Administration to launch you on the right track to Oracle DBA career success.Part 1: Database ConceptsChapter 1: Relational Database Management SystemsChapter 2: SQL and PL/SQLChapter 3: Oracle ArchitecturePart II: Database ImplementationChapter 4: PlanningChapter 5: Software InstallationChapter 6: Database CreationChapter 7: Physical Database DesignChapter 8: User Management and Data LoadingPart III: Database SupportChapter 9: Taking ControlChapter 10: MonitoringChapter 11: Fixing ProblemsChapter 12: BackUpsChapter 13: RecoveryChapter 14: Database MaintenanceChapter 15: The Big Picture and the Ten DeliverablesPart IV: Database TuningChapter 16: Instance TuningChapter 17: SQL Tuning
Oracle GoldenGate 11g Handbook
Author: Robert G. Freeman
Publisher: McGraw Hill Professional
ISBN: 0071790896
Category : Computers
Languages : en
Pages : 449
Book Description
Master Oracle GoldenGate 11g Enable highly available, real-time access to enterprise data in heterogeneous environments. Featuring hands-on workshops, Oracle GoldenGate 11g Handbook shows you how to install, configure, and implement this high-performance application. You’ll learn how to replicate data across Oracle databases and other platforms, including MySQL and Microsoft SQL Server, and perform near-zero-downtime migrations and upgrades. Monitoring, performance tuning, and troubleshooting are also discussed in this Oracle Press guide. Install and configure Oracle GoldenGate Implement Oracle GoldenGate one-way replication Configure multitarget and cascading replication Use bidirectional replication to build a heterogeneous database infrastructure Secure your environment, control and manipulate data, and prevent errors Configure Oracle GoldenGate for Oracle Clusterware and Oracle Real Application Clusters Use Oracle GoldenGate with MySQL and Microsoft SQL Server Perform near-zero-downtime upgrades and migrations Use Oracle GoldenGate Monitor and Oracle GoldenGate Director Ensure data quality with Oracle GoldenGate Veridata Implement nondatabase integration options
Publisher: McGraw Hill Professional
ISBN: 0071790896
Category : Computers
Languages : en
Pages : 449
Book Description
Master Oracle GoldenGate 11g Enable highly available, real-time access to enterprise data in heterogeneous environments. Featuring hands-on workshops, Oracle GoldenGate 11g Handbook shows you how to install, configure, and implement this high-performance application. You’ll learn how to replicate data across Oracle databases and other platforms, including MySQL and Microsoft SQL Server, and perform near-zero-downtime migrations and upgrades. Monitoring, performance tuning, and troubleshooting are also discussed in this Oracle Press guide. Install and configure Oracle GoldenGate Implement Oracle GoldenGate one-way replication Configure multitarget and cascading replication Use bidirectional replication to build a heterogeneous database infrastructure Secure your environment, control and manipulate data, and prevent errors Configure Oracle GoldenGate for Oracle Clusterware and Oracle Real Application Clusters Use Oracle GoldenGate with MySQL and Microsoft SQL Server Perform near-zero-downtime upgrades and migrations Use Oracle GoldenGate Monitor and Oracle GoldenGate Director Ensure data quality with Oracle GoldenGate Veridata Implement nondatabase integration options
Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition
Author: K Gopalakrishnan
Publisher: McGraw Hill Professional
ISBN: 0071752625
Category : Computers
Languages : en
Pages : 546
Book Description
Master Oracle Real Application Clusters Maintain a dynamic enterprise computing infrastructure with expert instruction from an Oracle ACE. Oracle Database 11g Oracle Real Application Clusters Handbook, Second Edition has been fully revised and updated to cover the latest tools and features. Find out how to prepare your hardware, deploy Oracle Real Application Clusters, optimize data integrity, and integrate seamless failover protection. Troubleshooting, performance tuning, and application development are also discussed in this comprehensive Oracle Press guide. Install and configure Oracle Real Application Clusters Configure and manage diskgroups using Oracle Automatic Storage Management Work with services, voting disks, and Oracle Clusterware Repository Look under the hood of the Cache Fusion and Global Resource Directory operations in Oracle Real Applications Clusters Explore the internal workings of backup and recovery in Oracle Real Application Clusters Employ workload balancing and the Transparent Application Failover feature of an Oracle database Get complete coverage of Stretch Clusters, also known as Metro Clusters Troubleshoot Oracle Clusterware using the most advanced diagnostics available Develop custom Oracle Real Application Clusters applications
Publisher: McGraw Hill Professional
ISBN: 0071752625
Category : Computers
Languages : en
Pages : 546
Book Description
Master Oracle Real Application Clusters Maintain a dynamic enterprise computing infrastructure with expert instruction from an Oracle ACE. Oracle Database 11g Oracle Real Application Clusters Handbook, Second Edition has been fully revised and updated to cover the latest tools and features. Find out how to prepare your hardware, deploy Oracle Real Application Clusters, optimize data integrity, and integrate seamless failover protection. Troubleshooting, performance tuning, and application development are also discussed in this comprehensive Oracle Press guide. Install and configure Oracle Real Application Clusters Configure and manage diskgroups using Oracle Automatic Storage Management Work with services, voting disks, and Oracle Clusterware Repository Look under the hood of the Cache Fusion and Global Resource Directory operations in Oracle Real Applications Clusters Explore the internal workings of backup and recovery in Oracle Real Application Clusters Employ workload balancing and the Transparent Application Failover feature of an Oracle database Get complete coverage of Stretch Clusters, also known as Metro Clusters Troubleshoot Oracle Clusterware using the most advanced diagnostics available Develop custom Oracle Real Application Clusters applications