Flylib.com
SUSE LINUX Enterprise Server 9 Administrators Handbook
SUSE LINUX Enterprise Server 9 Administrators Handbook
ISBN: 672327910
EAN: 2147483647
Year: 2006
Pages: 214
Authors:
Peter Kuo
,
Jacques Beland
BUY ON AMAZON
Oracle Database 10g INSIDER SOLUTIONS
Table of Contents
Copyright
Preface
About the Authors
Acknowledgments
We Want to Hear from You
Introduction
Who Should Read This Book
What You Need to Use This Book
How This Book Is Organized
About the Book s Sample Code
Conventions Used in This Book
PartI.Getting Started with Oracle Database 10g
Chapter 1. Exploring Oracle Database 10g Architecture
Overview of New Features
Processes Beneath the Hood
Memory Architecture
Automatic Undo Management
SQL Advisors
Oracle s Suite of Other Advisors
Flash Recovery Area
Flashback Operations
Improved Oracle Enterprise Manager
Grid Technology Unveiled
Summary
Chapter 2. Installing Oracle Database 10g
Installation Decisions
Prerequisites
Installing 10g on UNIXLinux
Oracle Database 10g DBCA Overview
Installing 10g on Windows
Companion CD Installation and Patches (All Platforms)
Installation Checklists
Database and Binary Cloning
Using Enterprise Manager for Cloning
Migrating a Database from 8i or 9i
Overview of Database Upgrade Assistant
Applying Patches to Database Installations
Uninstalling from a Failed Install
Summary
Chapter 3. Customizing Installation Options
OEM and Automatic Alerts
XML DB for XML Data Processing
ConText and Other Options
Setting Up RAC
Managing Backups with RMAN
Summary
Chapter 4. Setting Up Automatic Storage Management
Automatic Storage Management (ASM)
Prerequisites for Using ASM
Configuration Options
Performing ASM Operations
Avoiding ASM Pitfalls
When and Where to Use ASM
Summary
PartII.Quick Wins Using Oracle Database 10g
Chapter 5. Using Automatic Memory Management
Introduction to Quick Wins
What Is Automatic Shared Memory Management?
Understanding Memory Advisor
Automated Maintenance Tasks
Memory Management Tips
Scaling for Database Expansion
ASMM Improvements in 10g Release 2
Summary
Chapter 6. Monitoring with Automatic Statistics Collection
Automatic Statistics Collection Fundamentals
Collecting and Analyzing Statistics
Metrics Monitoring and Customization
Using Database Alerts with Metrics
Making the Most of Metrics and Statistics Collection
New Features in Oracle Database 10g Release 2
Summary
Chapter 7. Managing Automatic Undo
Using Automatic Undo Management
Redo Log File Sizings
Using Undo Advisor
Guaranteeing Undo Availability
Undo Tips from the Trenches
Automatic Undo Management Improvements in Release 2
Summary
Chapter 8. Leveraging Automatic Segment Management
Segment Management in Oracle Database 10g
Making Segment Management Work for You
Using Segment Advisor
Intelligent Segment Resource Estimation
Space-Management Tips and Tricks
ASSM Improvements in Release 2
Summary
Chapter 9. Implementing Recovery Manager
RMAN Basics
New Features of RMAN
Recovery Without Hurdles
New Features in Oracle Database 10g Release 2
Summary
PartIII.Tuning Oracle Database 10g
Chapter 10. Adopting a New Approach to Tuning
A New Performance Philosophy
New and Improved Views
Time and Wait Model
OEM and Tuning
New Features in Oracle Database 10g Release 2
Summary
Chapter 11. Effectively Using the Automatic Workload Repository
Introducing the AWR
Customizing the AWR
Performing Baselining
Active Session History
New Features in Oracle Database 10g Release 2
Summary
Chapter 12. Effectively Using the Automatic Database Diagnostic Monitor
Introduction to ADDM
Interfacing to ADDM
Making Sense of ADDM Data
New Features in Oracle Database 10g Release 2
Summary
Chapter 13. Effectively Using the SQL Advisors
Automating the SQL Advisors
Using the Advisors for Tuning
Avoiding Advisor Pitfalls
New Features in Oracle Database 10g Release 2
Summary
Chapter 14. Influencing the Cost Based Optimizer
New Optimizer Improvements
SQL Profiles
Effective Use of Histograms
New Features in Oracle Database 10g Release 2
Summary
PartIV.Scaling and Availability with Oracle Database 10g
Chapter 15. Utilizing Oracle Database 10g Real Applications Clusters
Oracle 10g RAC Overview
Cluster Ready Services
Service Workload Management
10g RAC Installation and Migration Enhancements
10g RAC Manageability Enhancements
Automatic Storage Management for Cluster Management
Third-Party Cluster Management Support
Limited Rolling Upgrade with OPATCH
10g RAC Tips for Better Use
Advanced RAC Features in Oracle Database 10g Release 2
Summary
Chapter 16. Utilizing 10g Physical and Logical Standby with Data Guard
Oracle 10g Data Guard Overview
General Improvements with Oracle 10g Data Guard
Logical Standby Improvements
Data Guard Broker Improvements
Applying Patch Sets with Data Guard in Place
New Features in Oracle Database 10g Release 2
Summary
Chapter 17. Effectively Using Flashback Technologies
Brief Overview of Flashback Technology
Flashback Database
Flashback Table
Flashback Drop with Recycle Bin
Flashback Versions Query
Flashback Transaction Query
Advanced Flashback Features in Oracle Database 10g Release 2
Summary
Chapter 18. Leveraging Grid Technology Features
What Exactly Is the Grid?
Oracle s Version of the Grid
Managing the Grid
Summary
PartV.Using Oracle Database 10g Utilities and Other Advanced Features
Chapter 19. Maximizing Data Movement with Oracle Data Pump
Oracle 10g Data Pump Enhancements
External Table Enhancements
Advanced Data Pump Features in Oracle Database 10g Release 2
Summary
Chapter 20. Using 10g SQLPlus and iSQLPlus
10g SQLPlus Enhancements
10g iSQLPlus Enhancements
Advanced iSQLPlus and SQLPlus Features in Oracle Database 10g Release 2
Summary
Chapter 21. Making the Most of Oracle Database 10g
A Collection of Useful Features
DMLDDL Features
Network Features
Security Features
Resource Manager and Scheduler
New Database Initialization Parameters
Oracle Streams Enhancements
MetaLink Integration with Oracle Database 10g
Oracle Database 10g EM Patch Cache
Oracle Applications 11i with Oracle Database 10g
Summary
Index
SYMBOL
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
X
Z
SUSE LINUX Enterprise Server 9 Administrators Handbook
ISBN: 672327910
EAN: 2147483647
Year: 2006
Pages: 214
Authors:
Peter Kuo
,
Jacques Beland
BUY ON AMAZON
Beginners Guide to DarkBASIC Game Programming (Premier Press Game Development)
Basic Commands, Variables, and Data Types
Making Programs Think Branching Statements and Subroutines
More Power to the Numbers Data Sequences and Arrays
Programming the Keyboard, Mouse, and Joystick
Multiplayer Programming The Crazy Carnage Game
Managing Enterprise Systems with the Windows Script Host
Introduction
Registry Operations
Application Automation
Internet Information Server
Exchange Server
The Complete Cisco VPN Configuration Guide
VPN Definition
When to Use SSL VPNs
Router Deployment Scenarios
Router Site-to-Site Connections
Fragmentation Problems
Data Structures and Algorithms in Java
The List Interface
Summary
Vocabulary
Projects
B.2. Instance Diagrams
Twisted Network Programming Essentials
Accepting Connections from Clients
Checking Whether a Page Has Changed
Monitoring Download Progress
Parsing HTTP Requests
Using Public Keys for Authentication
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hack 45. Forward Ports over SSH
Hack 46. Proxy Web Traffic over SSH
Hack 54. Boot from a Compact Flash Hard Drive
Hack 83. Make a Deep Dish Cylindrical Parabolic Reflector
Section A.10. 802.1x: Port Security for Network Communications
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies