Ingeniera De Sistemas

Spine: .816

Database Management/General

Grow wise about Oracle
and get going with the
leading database software!

™

Open the book and find:
• Two ways to manage your
database
• What tablespaces are and how to
use them
• How to automate jobs with the
Oracle Scheduler
• Ten common installation tips
• How to use SQL in Oracle

• Prepare for takeoff — review the hardware,software, system,
and storage requirements for implementation

• When to use online, offline, control
file, and archive log backups

• Know your environment — recognize and accommodate the
differences between Oracle installations on Windows and on
Linux/UNIX

• Database encryption options
• Advantages of the Flashback
database

le 11g
Orac
®

®

• Build it — learn the buildingblocks behind the database engine
and understand Oracle’s physical and logical structures

Oracle 11g

Are you a seasoned system administrator charged with
setting up an Oracle database? Or did you suddenly
become a DBA by default? Either way, this book will
guide you through the mysteries of Oracle and database
administration. Here are the nuts and bolts of creating an
Oracle database,implementing it, and keeping it running in
tiptop form.

g Easier!
Making Everythin

• Defend it — assess potential threats to your database, configure
Oracle Recovery Manager, and create backup and recovery
procedures
• Maintain it — know the daily and intermittent tasks necessary to
keep your database running properly
• Head off trouble — implement the system troubleshooting
methodology,use Oracle database logs, and explore other
diagnostic utilities

Learn to:
Go to dummies.com®
for more!

• Set up and manage an Oracle database
• Maintain and protect your data

• Manage it — monitor with Oracle Enterprise Manager

• Understand Oracle database
architecture
• Troubleshoot your database and keep
it running smoothly
$29.99 US / $32.99 CN / £19.99 UK

Chris Zeis isChief Technology Officer and partner at Perpetual
Technologies, Inc., an Oracle partner. Chris Ruel is an Oracle database
administrator and consultant. Michael Wessler manages multiple Web
applications for the Department of Defense and consults at various
government and private agencies.

ISBN 978-0-470-27765-2

Zeis
Ruel
Wessler

Chris Zeis
Chris Ruel
Michael Wessler

Oracle 11g®

FOR

DUMmIES

‰

Oracle 11g
®

FOR

DUMmIES

‰

by Chris Zeis, Chris Ruel,
and Michael Wessler

Oracle® 11g For Dummies®
Published by
Wiley Publishing, Inc.
111 River Street
Hoboken, NJ 07030-5774
www.wiley.com
Copyright © 2009 by Wiley Publishing, Inc., Indianapolis, Indiana
Published by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously inCanada
No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or
by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written
permission of the Publisher, or authorization through payment of theappropriate per-copy fee to the
Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600.
Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley
& Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://
www.wiley.com/go/permissions.
Trademarks: Wiley, the WileyPublishing logo, For Dummies, the Dummies Man logo, A Reference for the
Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything
Easier, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/
or its affiliates in the United States and other countries, and may not be used without written permission.
Oracle is a...