Get a Solid Foundation in Oracle Database Technology Master Oracle Database 11g fundamentals quickly and easily. Using self-paced tutorials, this book covers core database essentials, the role of the administrator, high availability, and large database features. Oracle Database 11g: A Beginner's Guide walks you, step by step, through database setup, administration, programming, backup, and recovery. In-depth introductions to SQL and PL/SQL are included. Designed for easy learning, this exclusive Oracle Press guide offers: Core Concepts--Oracle Database 11g topics presented in logically organized chapters Critical Skills--Lists of specific skills covered in each chapter Projects--Practical exercises that show how to apply the critical skills learned in each chapter Progress Checks--Quick self-assessment sections to check your progress Notes--Extra information related to the topic being covered Mastery Checks--Chapter-ending quizzes to test your knowledge

Oracle is an enormous system, with myriad technologies, options, and releases. Most users--even experienced developers and database administrators--find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g. This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains chapters on: Oracle products, options, data structures, and overall architecture for Oracle Database 11g, as well as earlier releases (Oracle Database 10g, Oracle9i, and Oracle8i) Installing, running, managing, monitoring, networking, and tuning Oracle, including Enterprise Manager (EM) and Oracle's self-tuning and management capabilities; and using Oracle security, auditing, and compliance (a new chapter in this edition) Multiuser concurrency, data warehouses, distributed databases, online transaction processing (OLTP), high availability, and hardware architectures (e.g., SMP, clusters, NUMA, and grid computing) Features beyond the Oracle database: Oracle Application Express, Fusion Middleware (including Oracle Application Server), and database SOA support as a Web services provider The latest Oracle Database 11g features: query result set caching, Automatic Memory Management, the Real Application Testing, Advanced Compression, Total Recall, and Active Data Guard Option Options, changes to the OLAP Option (transparently accessed and managed as materialized views), the Flashback transaction command, transparent data encryption, the Support Workbench (and diagnosability infrastructure), and partitioning enhancements (including interval and new composite types) For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle Database 11g features. But even if you already have a library full of Oracle documentation, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference. "Oracle Essentials gives a clear explanation of the key database concepts and architecture underlying the Oracle database. It's a great reference for anyone doing development or management of Oracle databases." --Andrew Mendelsohn, Senior Vice President, Database Server Technologies, Oracle Corporation

A major prerequisite for the usage and deployment of Oracle database technology is a successful installation. The purpose of this Oracle 11g training course module is to offer a step-by-step guide for the configuration of a Linux or Microsoft Windows server to host an Oracle database Enterprise Edition installation. Especially in a Linux environment installation of the database requires careful preparation, configuration and sometimes troubleshooting in order to succeed. This course includes practical tips learned from many real-world installations which can assist you to achieve a successful installation in your environment. We will explore both a standalone database installation and also a grid infrastructure installation. Major objectives covered within this guide book include: - Configuration of the Linux and Microsoft Windows operating systems in anticipation of a database installation; Performing a Desktop Class installation of the Oracle 11g R2 Enterprise Edition database; - Performing a Server Class installation of the Oracle 11g R2 Enterprise Edition database; - Addressing configuration and setup issues using the FixUp utility;- Verification of a valid database installation; Database administrator and technical support interface options, including the use of Enterprise Manager, command-line SQL*Plus, and terminal console SSH;- Preparing a host system for the Grid Infrastructure and Oracle RDBMS installations and performing those installations;- Preparing a host system for ASM storage management; - Partitioning and configuration of storage devices for ASM storage on both Linux and MS Windows servers; While this course module applies specifically to the installation of the Enterprise Edition of the Oracle database, it covers basic topics which apply to any Oracle software installation. Therefore, this material is also useful for the installation of other Oracle products such as the Oracle Database Client, specialized options for a database server installation, and so on.

A real-world DBA survival guide for Oracle 11g database implementations with this book and eBook.

Sam Alapati's Expert Oracle Database 11g Administration is a comprehensive handbook for Oracle database administrators (DBAs) using the 11g release of the Oracle Database. All key aspects of database administration are covered, including backup and recovery, day–to–day administration and monitoring, performance tuning, and more. This is the one book to have on your desk as a continual reference. Refer to it frequently. It'll help you get the job done. Comprehensive handbook for Oracle Database administrators. Covers all major aspects of database administration. Tests and explains in detail key DBA commands. Offers primers on Linux/Unix, data modeling, SQL, and PL/SQL.

This brilliant new book gives readers the lowdown on the most important new features in the latest release of Oracle's flagship database product. Authors Sam Alapati and Charles Kim are experienced database administrators who go beyond regurgitating Oracle's new feature documentation to report on "what's new that really matters." Readers whose careers are bound up in Oracle's database system need to know what's new. Sam and Charles deliver with a rigor and candor that will help readers choose the best of the new features to apply in their own environments.

Implement Proven Database Optimization Solutions Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 11g Release 2 Performance Tuning Tips & Techniques details the latest monitoring, troubleshooting, and optimization methods. Find out how to find and fix bottlenecks, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide. Properly index and partition Oracle Database 11g Release 2 Work with Oracle Exadata and Oracle Exalogic Elastic Cloud Efficiently manage disk drives, RAID arrays, and memory Tune queries with Oracle SQL hints and the TRACE utility Troubleshoot databases using V$ views and X$ tables Distribute workload using Oracle Real Application Testing Generate reports using Oracle's Statspack and Automatic Workload Repository tools Use sar, vmstat, and iostat to monitor system statistics “This is a timely update of Rich’s classic book on Oracle Database performance tuning to cover hot new topics like Oracle Database 11g Release 2 and Oracle Exadata. This is a must-have for DBAs moving to these new products.” --Andrew Mendelsohn, Senior Vice President, Oracle Database Server Technologies

Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? If database administration with Oracle is part of your job, you’ll be glad to have Oracle 11g For Dummies in your cubicle. This nuts-and-bolts guide walks you through the mysteries of Oracle and database administration. You’ll learn how to understand Oracle database architecture, set up and manage an Oracle database, and keep it running in tiptop form. Oracle 11g For Dummies covers: The building blocks behind the database engine as well as Oracle’s physical and logical structures Hardware, software, system, and storage requirements for implementation How to recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX Daily and intermittent tasks necessary to keep your database running properly How to assess potential threats to your database, configure Oracle Recovery Manager, and set up backup and recovery procedures When to use online, offline, controlfile, and archivelog backups Troubleshooting methodology and how to use Oracle database logs and other diagnostic utilities Different ways to manage your database How to automate jobs with the Oracle Scheduler Using SQL in Oracle, and a great deal more Completely up to date for the newest release of Oracle, Oracle 11g For Dummies will give you both the information and the confidence to set up and maintain an Oracle database for your organization.

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