- An oracle on Oracle, Byron Pearce takes the complexity out of the Oracle 11g database and helps readers work effectively in the Oracle 11g environment
- Begins with a friendly introduction to the basics of the Oracle database and then progresses to implementing Oracle in real-world situations, creating and protecting an Oracle database, and troubleshooting
- Covers the new features of Oracle 11g, including automatic memory tuning, fully automatic SQL tuning, automatic storage load balancing, and automatic diagnostic repository
- Devotes entire chapters to the oft-forgotten but critical topic of common mistakes that occur when installing Oracle, designing a database, and writing SQL code
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.
* Build it - learn the building blocks behind the database engine and understand Oracle''s physical and logical structures
* Prepare for takeoff - review the hardware, software, system, and storage requirements for implementation
* Know your environment - recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX
* 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
* Manage it - monitor with Oracle Enterprise Manager
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
* When to use online, offline, control file, and archive log backups
* Database encryption options
* Advantages of the Flashback database
- Begins with a friendly introduction to the basics of the Oracle database and then progresses to implementing Oracle in real-world situations, creating and protecting an Oracle database, and troubleshooting
- Covers the new features of Oracle 11g, including automatic memory tuning, fully automatic SQL tuning, automatic storage load balancing, and automatic diagnostic repository
- Devotes entire chapters to the oft-forgotten but critical topic of common mistakes that occur when installing Oracle, designing a database, and writing SQL code
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.
* Build it - learn the building blocks behind the database engine and understand Oracle''s physical and logical structures
* Prepare for takeoff - review the hardware, software, system, and storage requirements for implementation
* Know your environment - recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX
* 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
* Manage it - monitor with Oracle Enterprise Manager
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
* When to use online, offline, control file, and archive log backups
* Database encryption options
* Advantages of the Flashback database