Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Credits
About the Author
About the Reviewer
Preface

Services


Services are the single most important tool available to perform instance consolidation. In this context, a service refers to the name by which a client can connect to the instance, this is configured by the SERVICE_NAMES instance parameter, and it defaults to DB_UNIQUE_NAME.DB_DOMAIN if defined.

Connecting through services in an RAC environment is useful to have shifted the service across instances depending on availability and scalability. Using services in a single instance is not frequently seen. Most DBA's configure the default service and even more, there are DBA's who simply ignore this parameter and configure connections to the database by means of TNS entries compatible with Oracle 8.0 using the Oracle SID instead of the Oracle Service.

In single instance environments sessions can be tuned by services. There are other session management tools like Resource Manager, which can provide different resource allocation emphasis based on the service the user defines to connect to...