Tham khảo tài liệu 'dba_fundamentals1', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả

This book covers everything you need to know to pass the OCP: Oracle8i Performance and Tuning and OCP: Oracle8i Network Administration exams. The first part of the book covers the most critical areas of database performance tuning and how to follow and implement Oracle’s recommended tuning methodology. The second part covers the topics of network administration including configuring the necessary client and server components of an Oracle network and helps you develop an understanding of the Oracle 8i Net8 architecture....

The role of Database Administrator (DBA) has become a key to success in today’s highly complex database systems. The best DBAs work behind the scenes, but are in the spotlight when critical issues arise. They plan, create, and maintain databases to ensure that the databases meet the data manage- ment needs of the business. DBAs also monitor the databases for perfor- mance issues and work to prevent unscheduled downtime. Being an effective DBA requires a broad understanding of the architecture of Oracle databases and expertise in solving system-related problems. The Oracle8i certified administrator track consists of the following five tests:...

The Oracle Net8 Administrator’s Guide contains information that describes the features and functionality of the Oracle8 and the Oracle8 Enterprise Edition products. Oracle8 and the Oracle8 Enterprise Edition have the same basic features. However, several advanced features are available only with the Enterprise Edition, and some of these are optional. For example, to use Oracle Connection Manager, you must have the Enterprise Edition. For information about the differences between Oracle8 and the Oracle8 Enterprise Edition, and the features and options that are available to you, please refer to Getting to Know Oracle8 and the Oracle8 Enterprise Edition....

You can enhance Oracle performance by adjusting database applications, the database itself, and the operating system. Making such adjustments is known as tuning. Proper tuning of Oracle provides the best possible database performance for your specific application and hardware configuration. Note: Oracle8 Tuning contains information that describes the features and functionality of the Oracle8 and the Oracle8 Enterprise Edition products. Oracle8 and Oracle8 Enterprise Edition have the same basic features. However, several advanced features are available only with the Enterprise Edition, and some of these are optional. For example, to use application failover, you must have the Enterprise Edition and the Parallel Server Option....

Oracle8 Replication contains information relating to both Oracle8 and the Oracle8 Enterprise Edition. Some features documented in this manual are available only with the Oracle8 Enterprise Edition. Furthermore, some of these features are only available if you have purchased a particular option, such as the Objects Option. For information about the differences between Oracle8 and the Oracle8 Enterprise Edition, please refer to Getting to Know Oracle8 and the Oracle8 Enterprise Edition. This text describes features common to both products, and features that are only available with the Oracle8 Enterprise Edition or a particular option....

Oracle8i Parallel Server Concepts and Administration contains information that describes the features and functionality of the Oracle8i and the Oracle8i Enterprise Edition products. Oracle8i and the Oracle8i Enterprise Edition have the same basic features. However, several advanced features are available only with the Oracle8i Enterprise Edition, and some of these are optional. For example, to use client application failover, you must have the Enterprise Edition and the Parallel Server Option....

Welcome to Release 6.0 of the Oracle Reports Reference. This reference guide includes information to help you effectively work with Oracle Developer Report Builder and contains detailed information about the following: · Built ins · Triggers · Properties · Executables This preface explains how this reference is organized and introduces other sources of information that can help you use Oracle Reports.

This book is intended for anyone who uses Oracle Reports to build reports. The needs of both novice and advanced users are addressed. Each chapter contains stepby- step instructions to build a report from start to finish. Each report that you build will demonstrate how to use many of the powerful features in Report Builder. Some of the tasks in this manual tell you how to access online help for additional information. If you see a table like the one that follows, use the steps to get more information about the task you are performing:...

This chapter introduces parallel processing and parallel database technologies, which offer great advantages for online transaction processing and decision sup- port applications. The administrator’s challenge is to selectively deploy this tech- nology to fully use its multiprocessing power.

Welcome to Release 6.0 of the Oracle Developer Report Builder Reference. This reference guide includes information to help you effectively work with Oracle Developer Report Builder and contains detailed information about the following: · Built ins · Triggers · Properties · Executables This preface explains how this reference is organized and introduces other sources of information that can help you use Oracle Developer Report Builder.

This manual describes all features of the Oracle server, an object-relational database management system. It describes how the Oracle server functions and lays a conceptual foundation for much of the practical information contained in other Oracle server manuals. Information in this manual applies to the Oracle server running on all operating systems. Oracle8i and Oracle8i Enterprise Edition Oracle8i Concepts contains information that describes the features and functionality of the Oracle8i and the Oracle8i Enterprise Edition products. Oracle8i and Oracle8i Enterprise Edition have the same basic features. However, several advanced features are available only with the Enterprise Edition, and some of these are optional. For example, to partition tables, you must...

Oracle8 Migration contains information that describes the features and functionality of the Oracle8 and the Oracle8 Enterprise Edition products. Oracle8 and Oracle8 Enterprise Edition have the same basic features. However, several advanced features are available only with the Enterprise Edition, and some of these are optional. For example, to use Objects, you must have the Enterprise Edition and the Objects Option.

Welcome to Release 6.0 of the Oracle Developer Procedure Builder Reference. This reference guide includes information to help you effectively work with Oracle Developer Procedure Builder and contains detailed information about its commands This preface explains how this user’s guide is organized and introduces other sources of information that can help you use Oracle Developer Procedure Builder.

The guidelines in this book are intended to help you fully exploit some of Oracle Developer’s most powerful features. Whether you’ve been using Oracle Developer for years or are brand new to the product, the concepts and suggestions provided in this book should make it easier for you to complete such tasks as deploying an existing Oracle Developer application on the Web, designing an effective graphical user interface, or tracking and managing the disparate modules that make up a single application....

Oracle8 Concepts contains information that describes the features and functionality of the Oracle8 and the Oracle8 Enterprise Edition products. Oracle8 and Oracle8 Enterprise Edition have the same basic features. However, several advanced features are available only with the Enterprise Edition, and some of these are optional. For example, to use object functionality, you must have the Enterprise Edition and the Objects Option. For information about the differences between Oracle8 and the Oracle8 Enterprise Edition and the features and options that are available to you, see Getting to Know Oracle8 and the Oracle8 Enterprise Edition....

This book is intended to introduce Oracle8i, and to present the new functionality that it brings. It provides descriptions of new features, options, and enhancements; and includes feature and option factoring matrixes to identify those features and options that are available with each specific product configuration (Oracle8i, Oracle8i Enterprise Edition, or Oracle8iWorkstation). It references the documentation that is available for Oracle8i and identifies deprecated or desupported features....

Welcome to Release 6.0 of the Oracle Developer Graphics Builder Reference. This reference guide includes information to help you effectively work with Oracle Developer Graphics Builder and contains detailed information about the following: · Built ins · Properties · Attributes · Global variables This preface explains how this user’s guide is organized and introduces other sources of information that can help you use Oracle Developer Graphics Builder.

You should be familiar with your computer and its operating system. For example, you should know the commands for deleting and copying files and understand the concepts of search paths, subdirectories, and path names. Refer to your Microsoft Windows 95 or NT and DOS product documentation for more information. You should also understand the fundamentals of Microsoft Windows, such as the elements of an application window. You should also be familiar with such programs as the Explorer, Taskbar or Task Manager, and Registry....

The Oracle8 Backup and Recovery Guide contains information that describes the features and functionality of the Oracle8 and the Oracle8 Enterprise Edition products. Oracle8 and Oracle8 Enterprise Edition have the same basic features. However, several advanced features are available only with the Enterprise Edition, and some of these are optional. For example, to perform automated tablespace point-in-time recovery (using Recovery Manager), you must have the Enterprise Edition.