Oracle Data Dictionary Pocket Reference gives DBAs and developers at any level quick and easy access to the data dictionary in Oracle's latest database, Oracle9i. This pocket-sized book provides a complete list of the most commonly used tables and views in the Oracle9i data dictionary, intelligently arranged for quick reference. It also includes column names and descriptions for each of the tables and views, as well as helpful tips, warnings, and usage examples. When you've reached a sticking point in your work and want to check your facts quickly, the Oracle Data Dictionary Pocket Reference is the book to have close by. (Midwest).
This quick reference covers database releases Oracle8i, Oracle 9i, and Oracle Database 10g. For each initialization parameter, the book includes a description, valid values, default, and whether it can be changed dynamically. It also describes the initialization file and server parameter file and provides hints for best performance. In addition to listing all parameters alphabetically, the book indicates the categories of parameters often set as a group to control different aspects of the database.
SQL (Structured Query Language), the heart of a relational database management system, is the language used to query the database, to create new tables in the database, to update and delete fields, and to set access privileges. Aimed at everyone who needs to access an Oracle database using SQL, including developers, DBAs, designers, and managers, this book delivers all the information they need to know about standard SQL, and Oracle's extensions to it.
Oracle database administration demands extensive knowledge and the ability to execute numerous tasks, including installation, tuning, and troubleshooting. While Oracle offers various tools to assist, understanding which tool to use, the necessary commands, and the required parameters and privileges is crucial. DBAs often work under pressure, facing multiple crises. This book serves as a concise reference for the vast information needed daily by Oracle DBAs, featuring quick-reference tables, task lists, and summary materials beneficial for both novice and expert users. It addresses commands and operations introduced in Oracle8, while also including information relevant to Oracle7 for those using earlier versions.
The content is divided into two main sections: DBA tasks, which summarize critical functions such as installation, performance tuning, data loss prevention, networking, security, auditing, query optimization, and the use of Oracle tools; and DBA reference, which offers quick access to information about the Oracle instance, initialization parameters, common SQL statements, data dictionary tables, system privileges, and SQL*Plus syntax. Additionally, the book provides a resource summary with references to further readings and online resources valuable to Oracle DBAs. This essential reference is one you'll consistently rely on, whether at the office, home, or on-site troubleshooting.
