- About the Author
- About the Technical Editor
- Acknowledgments
- Adding Fault Tolerance
- Additional Considerations
- Alertlog
- Always Have a Few Hacker Friends
- Application and Database Considerations
- Application DBA
- Application Development
- Application Testing
- Applying a Patch to Your System
- Architecture
- Archiver Process ARCn
- Archiving Business Data
- Availability
- B - 2
- Gro
- Ylb
- Background Processes
- Backing Up Entire Schemas
- Backing Up Individual Tables
- Backup of Software and Parameter Files
- Backup Types
- Benefits of Certification
- Building Schemas
- Capacity Planning Sizing
- Changing the Passwords
- Checkpoint Process CKPT
- Clean Up a Failed Database
- Client - 2 3
- Clusters
- Cold Backups and Noarchivelog Mode
- Cold Backups and Recoveries
- Common Mistakes
- Comprehensive Sample Schemas
- Conclusion
- Configora
- Configuration File Location and Apache Control
- Configuring MTS and IIOP for Java
- Configuring Net8 for the New Database
- Configuring the System
- Consulting Contracting versus Salaried Employee
- Contents at a Glance
- Continuing Your Education
- Control Files
- Conventional Path Loading
- Corruption Checks
- Cpu
- Create a Soft Link for initora
- Creating Users
- Customizing Your profile File
- Data
- Data Availability
- Data Dictionary Cache
- Data Files
- Data Files and Other OFA Conventions
- Data Protection
- Database
- Database Administration
- Database Administration Principles
- Database Buffer Cache
- Database Shutdown
- Database Stages
- Database Testing
- Database Tuning Approach
- Database Versus Instance
- DDL Locking
- Decision Support Systems DSS
- Dedicated Server
- Depends on the Shop
- Developer Programmer
- Diagnostics Pack
- Direct Path Loading
- Disks - 2
- Dont Forget to Set Your Display
- E
- Rt
- Eh
- Electronic Monitoring and Notification
- Essentials - 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
- Example Patch
- Example Upgrade
- Export and Import
- Export Using Parameter Files
- Export Import
- F
- File and Space Management
- Files
- Full Database Export
- G - 2
- Gather Statistics
- Generating Creation Scripts
- Groups
- H
- Identifying Technical Problems
- Impact on the Database
- Imperative Concepts
- Importance of Backups
- Incurring Damage on the Database
- Index
- Index Organized Tables IOTs
- Indexes
- Info - 2 3 4 5 6 7 8 9 10 11 12 13 14
- Information Gathering
- Initora
- Installation - 2
- Installation Process 3
- Installing Java16
- Installing the 9i Server
- Interactive Export
- Interactive Import
- Intimate Shared Memory
- Introduction
- IO Subsystem
- Java Configuration Parameters
- Java Inside the Database
- Java Overview
- Jk
- Keep Your Talented People or the System Will Suffer
- Key Differences between Oracle Portal and WebDB
- Learning Java
- Learning on Your
- Library Cache
- Listener
- Listenerora
- Loading EJBs and Corba Servers
- Log into the Site
- Logical Backups
- M I
- Maintenance DBA
- Management
- Memory
- Memory Structures
- Middle Tier
- Mig
- Migration Testing
- Miscellaneous Commands
- Modifying oratab File
- Modules
- Monitoring
- Monitoring Backups
- Monitoring Disk IO
- Monitoring Exports
- Monitoring the Network
- Motivation
- Moving and Renaming Data Files
- MPPs and NUMAs
- Multi Threaded Server MTS
- Multiple Non Contiguous Segments
- N
- Need for Monitoring the Server
- Net8
- Network Information
- Non Technical Sizing Issues
- Odma
- Online Redo Logs
- Online Transaction Processing OLTP
- Optimal Flexible Architecture
- Oracle File Types
- Oracle Forms Reports and Discover
- Oracle Products Relating to Database Servers
- Oracle Software Installation Files
- Oracle Startup Shutdown
- Oracle University Classes
- Oratab
- Outside Organizations
- Overview - 2
- Overview of Export and Import
- Overview of Monitoring the Server 3
- Parfile Imports
- Partitioned Tables
- Paths to Becoming a DBA System Administrator SA
- Performing an Upgrade
- Persistence Is Good Up to a Point
- Physical Backups
- Plan and Establish Paging Policies Reasonably
- Planning - 2
- Pre Installation Setup
- Preparation
- Privileges
- Problem Identification at the System Level
- Problems Are Often Tuning Opportunities
- Professional Benefits
- Programmers Developers
- PSPs and JSPs
- Purpose
- Putting Databases in Hot Backup Mode
- Query Based Exports
- Quotas
- Ratios
- Reasons to Migrate Your Database
- Recovering from a Crash During Hot Backups
- Recovering from a Lost Data File
- Recovering from a Lost Temporary or Index Tablespace
- Recovering from Lost Control Files
- Review the Create Logs
- Roles
- Roles Within the IT Organization
- Rollback
- Rollback Segments for Batch Jobs
- Rollback Segments for OLTP
- Row Counts
- Row Migration and Chaining
- Running the Scripts
- S E
- SAms
- Scalability
- Semaphores
- Server - 2
- Server Manager
- Server Processes
- Server Related Checks
- Setting Up Security and Logging In
- SGA Allocation
- Shared Global Area SGA
- Shared Memory
- Shared Memory Parameters Dont Cause Swapping
- Showredologssql
- Sizing Data Files
- Skill of the DBA
- Skills Needed
- Snapshot Too Old Rollback Errors
- SQLPlus
- Standalone
- Starting and Stopping the Listener
- Startup Shutdown Processes in Unix
- Statspack
- Summary - 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
- Symbols
- Symmetrical Multiprocessor Machines
- System
- System Administrators
- System Architecture
- Systems DBA
- Systems Designer Data Modeler
- T - 2
- Table Index Sequence Creation and Maintenance
- Table Level Export
- Table Rebuilds
- Tablespace Management
- Taking the Test
- Te mp
- Technical Benefits
- Technical Sizing Issues
- Technological Design18
- Tell Us What You Think
- Test Your Exports and Imports
- Testing
- The Database Crashed
- Third Party Oracle Classes
- Three Tier Client Server Architecture
- Time Available to Perform the Migration
- Tnsnamesora - 2
- Toad
- Traditional Education
- Transaction Control
- Tuning Parameters
- Tuning Tables
- Types of DBAs
- U
- Understanding the Hardware Architecture
- Understanding the Kernel
- Uninstalling Java
- Uniprocessor Machines
- Use of Scripts
- User Level Export
- User Management
- Users
- Using Import
- Utlbstatutlestat
- V
- Verification of a Good Install
- Verify Database and Connectivity
- Vsessionevent
- Vsessionwait
- Vsystemevent
- Wait Events
- Web Environment
- WebDBOracle Portal Architecture
- What Are Patches and Upgrades
- What Is a Migration
- What Makes This Book Different
- Who Should Read This Book