Oracle9i for Windows(R) 2000 Tips & Techniques [Paperback]

Scott Jesse (Conductor)

Book Description

Series: Oracle Books | Publication Date: December 7, 2001

Windows as a platform for databases continues to grow and Oracle on Windows continues to become more important. Written by the team at Oracle, this book provides undocumented tips and techniques and covers issues central to database administration, features of 9i and highlights issues specific to Windows 2000. The core of the book is aimed at providing undocumented tips and techniques for maximizing the utility of the RDBMS. Coverage in this book includes: tuning, and backup and recovery; clustering and standby databases focusing on high availability; features in 9i-highlighting differences between 9i and 8i; centralizing and simplifying database administration using Enterprise Manager; and developing an upgrade and migration strategy.

Editorial Reviews

From the Back Cover

Best Practices from Oracle Experts

Find Undocumented, Expert Advice Inside

Take full advantage of the strength and reliability of Oracle9i and the management features of Windows 2000. Written by the experts and authorized by Oracle Corporation, Oracle9i for Windows 2000 Tips & Techniques presents insider best practices for installation, upgrades, migration, tuning, backup and recovery, clustering, and high availability. You'll also get in-depth details on the new features of Oracle9i.

• Configure Oracle9i on Windows 2000 as a management platform, database client, and database server
• Ease administrative tasks with database templates and Oracle Managed Files
• Monitor and manage Oracle to maximize available memory, CPU, and I/O
• Use Oracle9i Recovery Manager for backup, restore, and recovery
• Implement Standby Databases for greater availability
• Use Oracle9i Oracle Enterprise Manager for enterprisewide database administration
• Execute clustering and high availability solutions, using Microsoft Cluster Server, Oracle Failsafe, and Real Application Clusters
• Implement Advanced Replication to provide database load balancing, disaster recovery, and offline distributed transaction processing

Covers Oracle Database Releases 7.x, 8i, and 9i

About the Author

Scott Jesse (Colorado Springs, CO) is an Oracle Certified Professional who has worked extensively with the Windows NT Operating System for more than 7 years. Scott began by deploying Windows NT on a corporate-wide rollout for more than 3000 users while working for MCI Worldcom. For the past 5 years, Scott has worked in the Oracle support organisation, primarily assisting Oracle customers in implementing the Oracle RDBMS on Window NT. For the last 3 years, Scott has specialised in clustering and high availability technologies on the Windows NT platform, including Oracle Failsafe and Oracle Parallel Server. Matthew Hart (Colorado Springs, CO) has worked exclusively with the Windows Operating System for more than 5 years, the last 3 of which have been with Oracle Corporation, assisting Oracle customer implement the RDBMS on Windows NT and 2000. From 1999 onward, his role has increasingly become focused on Oracle's high availability solutions, specifically Oracle Recovery Manager and Oracle Advanced Replication. For the past 6 months he has been involved in the beta testing of Oracle9i, and he currently supports beta customers who are rolling out 9i into the enterprise. Matthew became an Oracle Certified Professional in May 1999. Mike Sale (Colorado Springs, CO) is a Consulting Technical Specialist and Team Lead with Oracle's NT Bug Diagnosis and Escalation Team and an Oracle 7,8 and 8i Oracle Certified DBA. Mike has worked on and off site with top Oracle customers to assist them with integrating Oracle on NT. He is also a member of the Analyst Requirements Committee for Oracle's Test & Diagnostics labs and teaches Oracle University Database Internals classes. Prior to his tenure at Oracle, he worked in a number of positions as a developer, IT manager, and consultant.

Product Details

• Paperback: 612 pages
• Publisher: McGraw-Hill Companies; 1st edition (December 7, 2001)
• Language: English
• ISBN-10: 0072194626
• ISBN-13: 978-0072194623
• Product Dimensions: 9.3 x 7.4 x 1.4 inches
• Shipping Weight: 2.6 pounds
• Average Customer Review: 4.3 out of 5 stars  See all reviews (7 customer reviews)
• Amazon Best Sellers Rank: #2,590,990 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

3 of 3 people found the following review helpful:

5.0 out of 5 stars Best Book for Windows 2000 and Oracle 9i, December 10, 2002

By 

Susan Wagner (Colorado Springs, CO United States) - See all my reviews

This review is from: Oracle9i for Windows(R) 2000 Tips & Techniques (Paperback)

I found it very helpful that this book also references 8.1.7 as well as 9i. The index, found in the back of the book, has several references to the SPFILE. It also has a detailed section on memory usage. Not only does this book give a summary of
Oracle Memory usage on Windows 2000, but goes into detail on how
to set up the boot.ini file when using 8i. Therefore, the reader
knows what 9i can do, and what it can't. This is very helpful
when tuning your database and deciding what version to upgrade to. It is obvious that the authors put a lot of research into this book.

2 of 2 people found the following review helpful:

5.0 out of 5 stars Excellent book, March 22, 2002

By 

"lucac" (Parma, Italy) - See all my reviews

This review is from: Oracle9i for Windows(R) 2000 Tips & Techniques (Paperback)

I've found this book literally packed with useful information that I could hardly find anywhere else (apart from oracle's support web site, of course). The authors have taken the unusual route of choosing Windows as their reference platform. Not only they have succeeded with their endeavor, but they filled the book with tips & techniques that are really valuable in the Unix environment too.

3 of 4 people found the following review helpful:

5.0 out of 5 stars Very useful information, March 25, 2002

By 

Adrian Matala - See all my reviews

This review is from: Oracle9i for Windows(R) 2000 Tips & Techniques (Paperback)

This is a very good book, covering many Oracle features. You can find more info on setting up Advanced Replication, FailSafe, Standby Databases, Real Application Clusters than you can find in most of the other Oracle books on the market.
The book is dedicated to Windows platforms, but lot of the information is also applicable to other platforms. Definetly a 5-stars work for me.