2 Day DBA covers general database administration tasks and concepts. Each 2 Day + book covers more specialized tasks and concepts for specific advanced topics. All tasks are presented in the Enterprise Manager GUI. Supporting documentation describes command line-based methods.
Provides a single source reference for administering Oracle Database in a small to midsize environment. If you are familiar with computers, but unfamiliar with administering Oracle Database, and your computer has four CPUs or fewer, and you do not expect to support more than 500 users, this book is appropriate for you.
A quick start guide that teaches you how to perform day-to-day database performance tuning tasks using features provided by the Oracle Diagnostics Pack, Oracle Tuning Pack, and Oracle Enterprise Manager.
A database administration quick start guide that teaches you how to perform day-to-day database security tasks. The goal of this book is to help you understand the concepts behind Oracle database security. This book teaches you how to perform all common security tasks needed to secure your database. The knowledge you gain from completing the tasks in Oracle Database 2 Day + Security Guide helps you not only to better secure your data, but to meet common regulatory compliance requirements, such as the Sarbanes-Oxley Act.
Describes detailed ways to enhance Oracle performance by writing and tuning SQL properly, using performance tools, and optimizing instance performance. It also explains how to create an initial database for good performance and includes performance-related reference information. This book could be useful for database administrators, application designers, and programmers.
SQL*Plus is a command-line client used for running SQL statements and compiling PL/SQL code. SQL Developer provides all the same capabilities as SQL*Plus, as well as an easy-to-use, powerful drag-and-drop GUI for managing database objects and creating and viewing reports.
Describes conceptual and usage information about Oracle SQL Developer, a graphical tool that enables you to browse, create, edit, and delete (drop) database objects; run SQL statements and scripts; edit and debug PL/SQL code; manipulate and export data; and view and create reports.
Provides a comprehensive overview of security for this database release, featuring security as a necessary, primary focus for Oracle installations. It provides the conceptual framework for understanding security requirements and threats as well as introducing the features, techniques, and policies for meeting those needs with Oracle products. The audience for this book includes system managers as well as users, database administrators, and application developers. This version addresses bug 7579601 and additional fixes throughout. It also includes additional material and tutorials for Chapter 9, "Verifying Security Access with Auditing."
Provides an overview and detailed configuration information about database advanced security features. These features include network encryption, strong authentication (RADIUS, Kerberos, and SSL), and centralized user management that uses the Oracle Identity Management infrastructure (Enterprise User Security). The audience for this guide includes network security and enterprise user security administrators.
Provides in-depth information on the mechanics of backup and recovery, and a guide to performing complex and less frequently performed backup and recovery tasks, including user-managed backup and recovery and performance tuning of backup and recovery.