Introduced a quarter-century ago, the Oracle database remains the leading enterprise relational database management system (RDBMS) in the world. Oracle is a complex system, offering a myriad of products, languages, and tools. Frequent updates, releases, and editions complicate the ability of Oracle users to keep up with the huge amounts of frequently changing information about the database and its capabilities.The goal of Oracle in a Nutshell is to pull together the most essential information on Oracle architecture, syntax, and user interfaces. The content and format of this book, an admirable addition to O'Reilly's respected In-a-Nutshell line, combine to boil down vital Oracle commands, language constructs, parameters, and file formats in a succinct and highly accessible desktop reference.Oracle in a Nutshell covers the information that database administrators PL/SQL and Java developers, and system, network, and security administrators need as they manage Oracle databases and write code for these databases. It includes:
<ul>
<li>Oracle Foundations--Overview of the Oracle architecture (memory structures and fundamental concepts), Oracle's various editions and packaging options, summary of the initialization file parameters and data dictionary views, and fundamentals of Oracle's concurrency scheme, security mechanisms (privileges, profiles, roles), and networking files (TNSNAMES.ORA, SQLNET.ORA, LISTENER.ORA, DAP.ORA, NAMES.ORA, CMAN.ORA) and options.</li>
<li>Oracle Languages--Syntax summary for SQL language statements, SQL function calls PL/SQL language statements and characteristics, PL/SQL built-in package headers, and Java (JDBC and SQLJ) interfaces to the Oracle database.</li>
<li>Oracle Tools--Commands provided with SQLPlus, SQLLoader, Import and Export, Oracle Recovery Manager (RMAN) and other backup/recovery methods, Oracle Enterprise Manager, and various performance tuning tools (Explain Plan, TKPROF, AUTOTRACE, UTLBSTAT, UTLESTAT, Statspack).</li>
<li>Appendixes--Summary of Oracle datatypes, operators, expressions, conditions, numeric and date formats, and resources for additional reading.</li>
</ul>

Oracle in a Nutshell: A Desktop Quick Reference

Computers & Technology

Kreines, David C.

Greenwald, Rick

Software

O'Reilly Media

If you work with Oracle, then you don't need to be told that the data dictionary is large and complex, and grows larger with each new Oracle release. It's one of the basic elements of the Oracle database you interact with regularly, but the sheer number of tables and views makes it difficult to remember which view you need, much less the name of the specific column. Want to make it simpler? The Oracle Data Dictionary Pocket Reference puts all the information you need right at your fingertips. Its handy and compact format lets you locate the table and view you need effortlessly without stopping to interrupt your workOracle 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. O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. 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.

Oracle Data Dictionary Pocket Reference: Views, Columns & Tips

Oracle designed its database products to be flexible and configurable so they would operate on a variety of hardware platforms, and they succeeded--Oracle software runs on more than seventy computer platforms, from mainframes to PC networks to handheld PDAs. The secret to this flexibility lies in the software's initialization parameters, whose numerous settings can be configured for top performance in countless environments. On the downside, however, improper settings can slow a system down; even grind it to a halt. And with so many parameters--which change from version to version of Oracle software--it's challenging for Oracle administrators to keep in mind the characteristics and optimal settings for each parameter.The Oracle Initialization Parameters Pocket Reference provides the crucial information you need to make key adjustments to your Oracle database. This concise guide is a mix of invaluable performance tips and a quick reference to Oracle's initialization parameters. The book describes each initialization parameter, indicates what category it's in--from auditing to multi-threaded server MTS--and whether it can be modified dynamically via the ALTER SESSION or ALTER SYSTEM command.In addition to the details about parameter characteristics and settings, you'll find performance tips, such as how the various parameters interact, and what the most advantageous settings are for different configurations. No other reference focuses exclusively on these initialization parameters--an absolute must for anyone working with an Oracle database.Presented in a handy, easy-to-use format, the Oracle Initialization Parameters Pocket Reference is a welcome alternative for anyone who's struggled to memorize the best configuration settings or gone back and forth to online resources, trying to figure out what works. O'Reilly's Pocket References put the information you need close at hand where you need it most. This guide will keep your Oracle databases operating at peak performance.

Oracle Initialization Parameters Pocket Reference: Oracle Configuration Quick Reference

Computer Science

The Oracle database is one of the most popular in the world, and for good reason. It's compatible, scalable, portable, and capable of performing incredibly fast. The advantages Oracle holds over its competition come with a price, however-it's a highly complex database that's becoming more complex with every release. And this level of detail, of course, can begin to weigh on database administrators (Dbas). Fortunately, the Oracle Dba Pocket Guide from O'Reilly is on the case. This handy reference is designed to help administrators make more effective use of their time by presenting a compact summary of Dba tasks in an easy-to-use form. With this book by your side, you'll have instant access to the most important concepts, best practices, tips, and checklists. Key topics include architecture, installation, configuration, tuning, and backup/recovery. Everything that you absolutely must know to do your job well is right there at your fingertips. Moreover, the Oracle Dba Pocket Guide covers Oracle Database 9i, as well as its latest release, Oracle Database 10g. The first database designed for enterprising grid computing, Oracle Database 10g significantly reduces the cost of managing the It environment with a simplified install, reduced configuration and management requirements, and automatic performance diagnosis and Sql tuning. The latest in O'Reilly's line of bestselling Oracle titles, this book is an invaluable companion for any database administrator-new or experienced-interested in reviewing core Oracle concepts at a glance.

Oracle DBA Pocket Guide: Quick Reference for Database Administration

This book provides a powerful set of tools for Oracle database administrators and developers. During their many years of administering, tuning, and troubleshooting Oracle databases, the authors have developed hundreds of useful scripts. Now you can instantly take advantage of their experience by putting these scripts to work at your own site. DBAs and developers are constantly reinventing the wheel. Most Oracle sites have similar requirements, problems, and crises, and at most of these sites DBAs and developers find themselves reinventing the wheel by writing the same kinds of scripts -- and too often they're writing them under pressure, in hit-or-miss and error-prone fashion.The scripts in this book are tried-and-true. They've been thoroughly tested in many different environments. You can use them right now to simplify the tasks you perform each day -- monitoring databases for reliability, protecting your database against data loss, improving performance, increasing security, and building reports that provide insight into the inner workings of Oracle databases. You can also turn to these scripts in emergencies to diagnose system problems and repair databases when the pressure is on.The book includes:
<ul>
<li>Scripts for DBAs -- The ways that DBAs structure files, allocate disk space, tune systems, and enforce security have an enormous impact on how efficiently and effectively systems will operate. The scripts in this category analyze performance, check database reliability, produce security and auditing reports, perform backups and restores, and work with the Oracle Applications. </li>
<li>Scripts for developers and designers -- These scripts help to create, analyze, report, and reverse-engineer the objects in the database. They also allow developers to easily create EXPLAIN PLAN reports on SQL statements, and they provide a front end to RCS (the Revision Control System).</li>
<li>Utility scripts -- These scripts perform a variety of operating system, file, directory, and memory operations (aimed particularly at UNIX sites). You can customize these scripts for your own operating system. The accompanying CD-ROM provides a comprehensive resource for DBAs and developers. It contains complete source code for all of the scripts described in this book, as well as additional software that you will find helpful in monitoring and improving the performance of your databases.</li>
</ul>A brief table of contents follows:Part I: Overview<ul><li>Introduction</li></ul>Part II: Scripts for DBAs<ul>
<li>Database Control Utilities </li>
<li>Database Performance and Trend Analysis Utilities </li>
<li>Database Reliability Monitoring Utilities </li>
<li>Database Security Reports and Utilities</li>
<li>Database Backup Utilities </li>
<li>Oracle Applications Utilities </li>
</ul>Part III. Scripts for Developers and Designers<ul>
<li>Database-Design/DDL Utilities </li>
<li>Database Developer Utilities </li>
</ul>IV: UNIX Utility Scripts<ul>
<li>General System Utilities </li>
<li>Directory and File Management Utilities </li>
<li>Memory Usage Reports </li>
</ul>Part V. Appendixes<ul>
<li>A. SQL Scripts That Create Oracle Tables </li>
<li>B. Tables Created by SQL Scripts </li> <li>C. SQL Scripts That Create Output Files </li>
<li>D. Output Files Created by SQL Scripts</li>
</ul>

Oracle Scripts: Powerful Tools for DBAs and Developers

Lomasky, Brian

Databases & Big Data

Oracle database administration requires a vast amount of information and an ability to perform a myriad of tasks-from installation to tuning to network troubleshooting to overall daily administration. Oracle provides many tools for performing these tasks; the trick is knowing what tool is right for the job, what commands you need to issue (and when), and what parameters and privileges you need to set. And, as every Dba knows, you need to know how do all this under pressure, while you face crisis after crisis. This book provides a concise reference to the enormous store of information an Oracle Dba needs every day (as well as what's needed only when disaster strikes). It's crammed full of quick-reference tables, task lists, and other summary material that both novice and expert Dbas will use time and time again. It covers the commands and operations new to Oracle8, but also provides Oracle7 information for sites still running earlier versions. Oracle Database Administration provides two types of material: Dba tasks-chapters summarizing how to perform critical Dba functions: installation, performance tuning, preventing data loss, networking, security and monitoring, auditing, query optimization, and the use of various Oracle tools and utilities Dba reference-chapters providing a quick reference to the Oracle instance and database, the initialization (Init.Ora) parameters, the Sql statements commonly used by Dbas, the data dictionary tables, the system privileges and roles, and the Sql*Plus, Export, Import, and Sql*Loader syntax The book also includes a resource summary with references to additional books, Web sites, and other online and offline resources of special use to Oracle Dbas. Oracle Database Administration is the single essential reference you'll turn to again and again. If you must choose only one book to use at the office, keep at home, or carry to a site you're troubleshooting, this will be that book.

Oracle Database Administration: The Essential Refe: A Quick Reference for the Oracle DBA

Science & Math

Laskey, Brian

Mathematics

SQL (Structured Query Language) is the heart of a relational database management system. It's the language used to query the database, to create new tables in the database, to update and delete database fields, and to set privileges in the database. Oracle SQL: The Essential Reference is for everyone who needs to access an Oracle database using SQL--developers, DBAs, designers, and managers.SQL is based on research dating back to the late 1960s, but its first commercial release was in the RDBMS announced by the fledgling Oracle Corporation in 1979. Since that time, every other database vendor has adopted SQL, and ANSI and the ISO have made it a standard. Although vendors diverge in their extensions to SQL, the core language is standard across vendor boundaries.Despite SQL's long history and relative simplicity, few developers and database administrators are truly masters of SQL. The constant stream of vendor enhancements, the hard-won experience in tuning SQL for best performance, and the requirements of particular operational environments mean that there is always more to learn about SQL.Oracle SQL: The Essential Reference delivers all the information needed to keep ahead of the learning curve on standard SQL and Oracle's extensions to it. This single, concise reference volume will hold its own against a stack of Oracle manuals and even yield insights and examples not available in those manuals.There are chapters on basic SQL elements (naming requirements, column types, pseudo-types, data conversion rules, operators); Data Definition Language (DDL) and Data Manipulation Language (DML); common language elements (constraints, storage clause, predicates); SQL functions; PL/SQL (including procedures, functions, and packages); SQL*Plus, and Oracle SQL optimization and tuning. The book covers Oracle 8i, release 8.1.6.

Oracle SQL: the Essential Reference

Programming Languages

The Oracle database is one of the most popular in the world, and for good reason. It's compatible, scalable, portable, and capable of performing incredibly fast. The advantages Oracle holds over its competition come with a price, however--it's a highly complex database that's becoming more complex with every release. And this level of detail, of course, can begin to weigh on database administrators (DBAs).Fortunately, the Oracle DBA Pocket Guide from O'Reilly is on the case. This handy reference is designed to help administrators make more effective use of their time by presenting a compact summary of DBA tasks in an easy-to-use form.  With this book by your side, you'll have instant access to the most important concepts, best practices, tips, and checklists.  Key topics include architecture, installation, configuration, tuning, and backup/recovery.  Everything that you absolutely must know to do your job well is right there at your fingertips.Moreover, the Oracle DBA Pocket Guide covers Oracle Database 9i, as well as its latest release, Oracle Database 10g.  The first database designed for enterprising grid computing, Oracle Database 10g significantly reduces the cost of managing the IT environment with a simplified install, reduced configuration and management requirements, and automatic performance diagnosis and SQL tuning.The latest in O'Reilly's line of bestselling Oracle titles, this book is an invaluable companion for any database administrator--new or experienced--interested in reviewing core Oracle concepts at a glance.

Oracle DBA Pocket Guide

Shroff Publishers & Distributors Pvt Ltd

See the best price to sell, buy, or rent books by Kreines, David C.. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Kreines, David C.