Oracle Press
13 total works
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
OCP Oracle Database 12c Advanced Administration Exam Guide (Exam 1Z0-063)
by Bob Bryla
A Complete Study System for OCP Exam 1Z0-063
Prepare for the Oracle Certified Professional Oracle Database 12c Advanced Administration exam with this exclusive Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-063, including:
- Configuring and managing Oracle Recovery Manager (RMAN) settings
- Using the Oracle RMAN recovery catalog
- Performing backup and recovery
- Diagnosing database failures and using the automatic diagnostic repository
- Encrypting, securing, monitoring, and tuning Oracle RMAN backups
- Configuring and using flashback features
- Transporting and copying tablespaces and databases
- Creating and managing multitenant container databases and pluggable databases
- Using the Oracle Data Pump, SQL*Loader, and auditing features
Electronic content includes:
- 150+ practice exam questions
- Test engine that provides practice exams or quizzes that can be customized by chapter or exam objective
- PDF copy of the book
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
The ultimate guide for every Oracle DBA! Guru author, Kevin Loney gives readers complete coverage of all the new and existing features – everything a DBA needs to know in one volume.
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.
This authorized guide from Oracle Press explains how implement all the new features of Oracle9i and manage a robust, high-performance Oracle database. You'll get new and revised material on installation, database creation, using STATSPACK, Recovery Manager, Oracle9i Application Server, external tables, flashback queries, and much more.
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
A Fully Integrated Study System for OCP Exam 1Z0-053
Prepare for the Oracle Certified Professional Oracle Database 11g: Administration II 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 OCP objectives for exam 1Z0-053, including:
Database structure and Oracle Automatic Storage ManagementConfiguring database recoverability Oracle Recovery Manager (RMAN)Oracle Flashback Memory management techniques Database tuning advisors Disk space and resource management Configuring database diagnostics Administering the Oracle Scheduler Database globalization
On the CD-ROM:
One full practice exam that simulates the actual OCP examDetailed answers and explanations
Score report performance assessment tool
Complete electronic book
Bonus exam available free with online registration
The Definitive Guide to Oracle Database 11g
Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included.
Install Oracle Database 11g or upgrade from an earlier versionCreate database tables, sequences, indexes, views, and user accountsConstruct SQL statements, procedures, queries, and subqueries Optimize security using virtual private databases and transparent data encryptionImport and export data using SQL*Loader and Oracle Data Pump Use SQL replay, change management, and result cachingAvoid human errors using flashback and automatic undo managementBuild and tune PL/SQL triggers, functions, and packagesDevelop database applications using Java, JDBC, and XMLOptimize availability and scalability with Oracle Real Application Clusters
Advanced Oracle Tuning and Administration
by Eyal Aronoff, Kevin Loney, and Noorali Sonawalla
Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.
