If you're running Oracle8 on Windows NT Server, all the hard-to-find DBA information you need is right here, in Oracle8 Database Administration on Windows NT. Expert Oracle DBA Lynwood Brown covers architecture, installation, tuning, security, networking, even the basics of application development with PL/SQL. Learn to use Oracle 8's GUI-based Data Manager, master the art of gathering and interpreting performance data, and much more. Soup-to-nuts coverage includes using SQL*NET and SQL*NET 2 in networked client/server environments; Oracle auditing and data integrity features; managing user accounts, backup, and recovery. The book is replete with real-world examples developed through Lynnwood Brown's years of teaching Oracle to working DBAs. The CD-ROM contains MenloSoftware's flexible, easy-to-use DBAWare 2.0 database performance analysis tool, which allows you to monitor, track and tune Oracle databases from any MS-Windows client, using provided SQL statements and stored procedures -- or your own. Plus CBT Systems Oracle8 Training Module. Don't throw away the manuals -- but this is the book you'll use every day!
Book Description
Editorial Reviews
From the Inside Flap
Preface This book is intended for people who have a basic understanding of computers and programming. The reader should be familiar with Windows NT, but does not have to be an expert. There are several appendices with helpful tips on the various utilities that are used to install, manage and tune the Oracle relational database management system. The Windows NT operating system will be covered at a level intended to show the integration of Windows NT and Oracle8. The book is written for those people that may have experience with mainframe, UNIX or Windows/DOS computing and need to understand how Oracle's RDBMS functions on the Windows NT platform. The audience that this book is intended for includes: Working professionals who need to understand Oracle8 on the Windows NT platform and are not enrolled in a college or extension course. These are people that work for companies that are considering or have decided to invest in Oracle as a solution to their data processing needs. Working professionals that are taking a course in computer systems through a college or a computer training school. College students taking a course in computer science or information systems. The book is compiled from my experience teaching Oracle database administration at the University of California at Berkeley Extension and teaching and consulting and at various corporations including DHL, MCI, Wells Fargo Bank, GTE, InfoWorld and Clarify Inc. I have also drawn on my experience working for the Oracle Corporation in the worldwide technical support group. Many of my students are working professionals who have many years of experience using various other RDBMS products and need to learn Oracle to advance their careers. One of my goals in writing this book is to consolidate relevant information on Oracle database administration into one easy to understand book and use this information in training other database administrators. I can be contacted at ldbrown if additional or specific training or consulting is required. The intent of the book is not to teach database design or be a guide to SQL programming. The focus of the book is to show a person who has some basic programming skills what is Oracle8 and how can they use it. At various parts in the book the reader will be pointed to reference material that comes from Oracle. Therefore the reader will be able to gain an understanding of Oracle and how to use the system. Should they require further information into the theory behind how Oracle operates they will be pointed to the various Oracle reference manuals. It is my feeling that the Oracle manuals are the best place to get detailed information on Oracle. The problem is that the manuals are usually written for someone that already understands the product and the information is spread out among many manuals. Some of the material for the book came from my first book on Oracle database administration on the UNIX operating system. This book is an expansion of the first book in that it describes the activities that a DBA performs while administering an Oracle8 database on the Windows NT operating system platform. The job of the database administrator (DBA) can be divided into the various tasks that the DBA may be required to perform during a normal day. These task include: Database installation and customization Database performance monitoring/analysis Database backup and recovery Database tuning Application tuning End user creation and management Client server application implementation Database capacity planning Implementing database security Database auditing This book will demystify Oracle database administration by using real world examples of the various tasks that a DBA will be required to perform on a daily basis. The problem with a lot of the documentation that comes from Oracle concerning it's RDBMS and tools are that it is spread out among too many books. This book seeks to consolidate this information into one text. The book focuses on the following database administration topics: Introduction to the Oracle relational database management system and the various products that are offered by the Oracle Corporation. The reader will be introduced to the reasons why the Oracle relational database management system running on the Windows NT platform has become a very popular environment for client server computing. The Oracle8 RDBMS architecture. The architectural discussion provides the foundation that will be required in the latter sections on installation considerations and performance and tuning for the Windows NT operating system. Installation and configuration of the Oracle relational database management system software. Various tips will be given to help demystify the installation of Oracle on the Windows NT platform. The chapter will show the tight integration between Oracle8 and the Windows NT operating system. Client server implementation using Oracle's SQL*NET. The topics include SQL*NET's integration with the Window NT's networking strategy. In addition to defining what is a protocol and what are some of the more popular communications techniques/protocols (SPX/IPX, SNA, TCP/IP etc. ...) the configuration and debug of SQL*NET is covered. End user management and system security. The reader is introduced to the various SQL commands that must be used to accomplish basic DBA task. The purpose of the book is not to teach SQL but an appendix on SQL programming is included. The language reference also includes examples of Oracle's procedural language PL/SQL. The reader is introduced to the SQL commands that are required for the DBA to manage the database. The reader will be introduced to the various graphical user interface (GUI) tools that are part of Oracle8 offering. The relationship between the various GUI tools and the SQL commands that they generate will be covered in detail. Easy to understand performance guidelines will be covered. The reader is stepped through what system information should be collected from the Windows NT operating system as well as the Oracle kernel. The reader will be guided through how to tune the system based on the performance data. The book includes sections covering application development and the management of very large databases. The reader will be introduced to table partitioning and how it is used to manage large tables. The reader is also introduced to entity relationship modeling and its role in application development. The goal is to introduce the reader to data modeling as it relates to the DBA. The book is organized into the following chapters: Chapter 1 - Introduction Introduce the reader to RDBMS from a historical perspective. Introduce the Oracle RDBMS and the various tools that make up the Oracle offering. A brief explanation will be given for the various Oracle tools and applications. Chapter 2 - The Oracle8 RDBMS Architecture Introduce the reader to the Oracle RDBMS architecture. The various Oracle services and data structures will be described. The relationship between the data structures and the various Windows NT services will be described both pictorially and in writing. Introduce various commands and terminology that will be used in the latter sections of the book. Chapter 3 - System Installation Explain the installation process is integrated with the Windows NT registry. Explain the various Windows NT system administration tasks that need to be performed to set up the correct environment for the installation and give examples on how to perform them. Chapter 4 - Client/Server Implementation Introduce the reader to data communications. Various types of data communications architectures will be briefly covered. The OSI model will be described and related to the implementation of client server systems using Oracle's SQL*NET. Cover various installation and debug issues using SQL*NET v2. Cover the use of SQL*NET in implementing client server and distributed database environments. Chapter 5 - Database Access and Security Introduce the reader to the basic DBA task. The topics will include how to add users, controlling access (security), starting and stopping the database. Various examples will be given. The examples will show how the operations are performed using one of the new GUI tools (such as Data Manager) and it's command line equivalent. Sow the relationship between performing the various end user management tasks using the new Oracle GUI's (User Manager, Data Manager etc.) and using the command line utility Server Manager. Chapter 6 - Database Backup/Recovery Backup and recovery techniques will be covered through various examples. The reader will be advised as to how to determine the best backup strategy for their environment. Database backup and recovery using the Oracle Backup and Recovery utility and using the command line utility Server Manager. Chapter 7 - Database Performance and Tuning Show the reader how collect and interpret the database performance statistics. Show the reader how to tune the system (this includes the RDBMS and how it relates to the Windows NT operating system). Show the reader how use the utilities database analysis product DBAware. Chapter 8 - Database Capacity Planning Estimating disk storage requirements. Estimating table, index and rollback segment requirements. Monitoring disk storage utilization. Chapter 9 - Application Development Entity Relationship modeling and its relationship to application development Defining database constraints related to the ER model. Chapter 10 - VLDB Managing large tables using table stripping Managing large tables using table partitioning SQL is introduced as the programming language that is used to access the Oracle relational database system. The language reference that is provided contains various examples that the readers can use to familiarize themselves with the SQL language. The SQL language reference has also been expanded to include object oriented SQL and PL/SQL examples. A project of this size cannot be accomplished without the help of other people. I want to thank my former students Sujata Raju for her assistance in writing the Oracle product summary and Robert Briley (now with Oracle Worldwide Technical Support) for his review and comments. I want to thank Fif W. Agenhu of the University of California at Berkeley Extension's Computer and Information Systems department for her comments on Windows NT system administration. Thank you Paul Osborn of MenloSoftware for providing the database analysis tool DBAware and the section on using DBAware for Oracle database analysis and tuning. I also want to thank Paul for being a good friend who kept me laughing as we discussed topics related and unrelated to database administration. I want to thank the publishing staff of Prentice Hall especially Mark Taub for believing in me and Joanne Anzalone for not giving up on me. I want to thank Barbara Brown for being my mom. As always I want to thank my sister Stephanie Brown for indexing the manuscript, tolerating all of my last minute changes and being my best friend.
From the Back Cover
Specific day-to-day information and great tips for running Oracle on NT!
If you're running Oracle8 or Oracle7 on Windows NT Server, all the hard-to-find DBA information you need is right here, in Oracle Database Administration on Windows NT. Expert Oracle DBA Lynwood Brown covers architecture, installation, tuning, security, networking, and even the basics of application development with PL/SQL. Whether you're an experienced DBA or a novice, you'll find invaluable guidance for:
- Planning and sizing NT-based Oracle systems
- Installing Oracle8 on NT Server and leveraging the tight integration between them
- Tuning Oracle8 on NT: memory and CPU management, disk I/O, and other key variables
- Using SQL*NET and SQL*NET 2 in networked client/server environments
- Oracle auditing and data integrity features
- Managing user accounts, backup, and recovery
You'll learn to use Oracle 8's GUI-based Data Manager, master the art of gathering and interpreting performance data, and much more. From "soup to nuts," Oracle Database Administration on Windows NT is replete with real-world examples developed through years of teaching Oracle to working DBAs. Don't throw away the manuals but this is the book you'll use every day!
CD-ROM INCLUDED
Includes MenloSoftware's flexible, easy-to-use DBAWare 2.0 database performance analysis tool, which allows you to monitor, track and tune Oracle databases from any MS-Windows client, using provided SQL statements and stored procedures or your own.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
2 of 2 people found the following review helpful:
2.0 out of 5 stars
I preferred the Oracle 8 Black Book for Windows NT,
By A Customer
This review is from: Oracle8 Database Administration on Windows NT with CDROM (Paperback)
I found this book too lightweight on conveying real hands-on skills for using Oracle 8 for Windows NT. The focus seems more on a combination of theory and hands-on, achieving neither. Since I am using the OEM for most DB admin the combination of command line and GUI contributed to the confusion.
0 of 1 people found the following review helpful:
4.0 out of 5 stars
This book is very productive,
By A Customer
This review is from: Oracle8 Database Administration on Windows NT with CDROM (Paperback)
I guess the author is a populor teacher in his class. This book has covered most of the requireed knowledge for an Oracle DBA. It contains many figures which will save readers a lot of time in understanding and exercising. The text is simple but to the point. The attached CDROM is not of much interest to me.
0 of 1 people found the following review helpful:
4.0 out of 5 stars
Good for installation, Backup & recovery, and basic tuning,
By A Customer
This review is from: Oracle8 Database Administration on Windows NT with CDROM (Paperback)
This book gives you a good explanation of how Oracle is implemented on Windows NT. It does a good job covering installation, backup and recovery, and basic tuning. However, I purchased this book specifically for more information on Job Scheduling through Oracle Enterprise Manager. This topic is not covered in this book.
Share your thoughts with other customers: Create your own review
|
|
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
