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 version
Create database tables, sequences, indexes, views, and user accounts
Construct SQL statements, procedures, queries, and subqueries
Optimize security using virtual private databases and transparent data encryption
Import and export data using SQL*Loader and Oracle Data Pump
Use SQL replay, change management, and result caching
Avoid human errors using flashback and automatic undo management
Build and tune PL/SQL triggers, functions, and packages
Develop database applications using Java, JDBC, and XML
Optimize availability and scalability with Oracle Real Application Clusters
A century ago, outsiders saw China as a place where nothing ever changes. Today the country has become one of the most dynamic regions on earth. In Oracle Bones, Peter Hessler explores the human side of China's transformation, viewing modern-day China and its growing links to the Western world through the lives of a handful of ordinary people. In a narrative that gracefully moves between the ancient and the present, the East and the West, Hessler captures the soul of a country that is undergoing a momentous change before our eyes.
This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity.
The chapters of this book are logically organized into four parts that closely track the way your database administration career will naturally evolve. Part 1 gives you necessary background in relational database theory and Oracle Database concepts, Part 2 teaches you how to implement an Oracle database correctly, Part 3 exposes you to the daily routine of a database administrator, and Part 4 introduces you to the fine art of performance tuning. Each chapter has exercises designed to help you apply the lessons of the chapter. Each chapter also includes a list of reference works that contain more information on the topic of the chapter.
In this book, you'll find information that you won't find in other books on Oracle Database. Here you'll discover not only technical information, but also guidance on work practices that are as vital to your success as technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible.
What you’ll learn
Theory of relational database management systems
Oracle Database internals
Licensing, architecture, and sizing
Software installation and database creation
Using indexes to improve performance
User management and data loading
How to monitor all aspects of your database
How to solve and fix problems
Database backups and database recovery
Database maintenance
Database tuning
SQL tuning
Who is this book for?
If you are an IT professional who has been thrust into an Oracle database administration role without the benefit of formal training, or you just want to understand how Oracle Database works, this book is for you. It's the book the author wishes he'd had when he first started using Oracle Database many years ago. It's the book that he would have liked to have given to the many IT colleagues and friends who, over the years, have asked him to teach them the basics of Oracle Database.
About the Apress Beginning Series
The Beginning series from Apress is the right choice to get the information you need to land that crucial entry–level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from “novice to professional.” You’ll start your journey by seeing what you need to know—but without needless theory and filler. You’ll build your skill set by learning how to put together real–world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there—it is your trusted guide through unfamiliar territory!
About this product: Design Feature-Rich PL/SQL Applications
Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance.
Create, debug, and manage Oracle-driven PL/SQL programs
Use PL/SQL structures, delimiters, operators, variables, and statements
Identify and eliminate errors using PLSQL_WARNINGS and exception handlers
Work with functions, procedures, packages, collections, and triggers
Define and deploy varray, nested table, and associative array data types
Handle external routines, object types, large objects, and secure files
Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE
Call external procedures through Oracle Net Services and PL/SQL wrappers
Integrate internal and server-side Java class libraries using Oracle JVM
Develop robust Web applications using PL/SQL Gateway and Web Toolkit
About this product: 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
In Washington, D.C., a homeless man takes an assassin's bullet and dies in Commander Gray Pierce's arms. A bloody coin clutched in the dead man's hand—an ancient relic that can be traced back to the Greek Oracle of Delphi—is the key to a conspiracy that dates back to the Cold War and threatens the very foundation of humanity. For what if it were possible to bioengineer the next great prophet—a new Buddha, Muhammad, or even Jesus? Would this Second Coming be a boon . . . or would it initiate a chain reaction that would result in the extinction of humankind?
Vital seconds are ticking rapidly away as Pierce races across the globe in search of answers, one step ahead of ruthless killers determined to reclaim the priceless artifact. Suddenly the future of all things is balanced on the brink between heaven and hell—and salvation or destruction rests in the hands of remarkable children.
From the acclaimed author of River Town comes a rare portrait, both intimate and epic, of twenty-first-century China as it opens its doors to the outside world.
A century ago, outsiders saw Chinaas a place where nothing ever changes. Today the coun-try has become one of the most dynamic regions on earth. That sense of time—the contrast between past and present, and the rhythms that emerge in a vast, ever-evolving country—is brilliantly illuminated by Peter Hessler in Oracle Bones, a book that explores the human side of China's transformation.
Hessler tells the story of modern-day China and its growing links to the Western world as seen through the lives of a handful of ordinary people. In addition to the author, an American writer living in Beijing, the narrative follows Polat, a member of a forgotten ethnic minority, who moves to the United States in searchof freedom; William Jefferson Foster, who grew up in an illiterate family and becomes a teacher; Emily,a migrant factory worker in a city without a past; and Chen Mengjia, a scholar of oracle-bone inscriptions, the earliest known writing in East Asia, and a man whosetragic story has been lost since the Cultural Revolution. All are migrants, emigrants, or wanderers who find themselves far from home, their lives dramatically changed by historical forces they are struggling to understand.
Peter Hessler excavates the past and puts a remarkable human face on the history he uncovers. In a narrative that gracefully moves between the ancient and the present, the East and the West, Hessler captures the soul of a country that is undergoing a momentous change before our eyes.
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
About this product: If you're doing database application development in the Oracle environment, you're going to have to know PL/SQL, the company's extended query and update language. If you want your programs to exploit the special capabilities of Oracle software, you'll need to know the language well. That's where the third edition of Oracle PL/SQL Programming comes into play. It's an absolutely comprehensive reference (as well as a rather extensive tutorial) on PL/SQL, ideally suited to answering your questions about how to perform some programming tasks and reminding you of the characteristics of functions, triggers, and other elements of the database programmer's toolkit. The new edition covers calls to Java methods from within PL/SQL programs, autonomous transactions, object type inheritance, and the new Timestamp and XMLType data types. There's also more information about server internals--the way PL/SQL programs are run--than before, better enabling readers to optimize their code for fast and safe execution.
Steven Feuerstein takes care to explain, with prose and example code, the characteristics of PL/SQL elements. In explaining number conversions, for example, he explores Oracle's different ways of formatting numbers, then details the behavior of the to_number function under different conditions (with and without a specified format model, and with National Language Support information attached). It's a helpful approach that will have readers using the index to locate places in which Feuerstein mentions language elements of interest. --David Wall
Topics covered: How to use Oracle PL/SQL in all its manifestations through Oracle9i. Fundamentals of program structure (loops, cases, exceptions, etc.) and execution get attention, as do data types, transaction management, triggers, and the object-oriented aspects of the language. There's also coverage of calls to external Java and C programs.
A Fully Integrated Study System for OCA Exam 1Z0-051
Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals 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-051, including:
SQL SELECT statements
Restricting and sorting data
Single-row functions
Conversion functions and conditional expressions
Group functions
Displaying data from multiple tables
Subqueries
Set operators
DML and DDL statements
Schema objects
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