Oracle Initialization Parameters Pocket Reference

Oracle Initialization Parameters Pocket Reference PDF Author: David C. Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 0596007701
Category : Computers
Languages : en
Pages : 119

Get Book

Book Description
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.

Oracle Initialization Parameters Pocket Reference

Oracle Initialization Parameters Pocket Reference PDF Author: David C. Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 0596007701
Category : Computers
Languages : en
Pages : 119

Get Book

Book Description
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.

Oracle DBA Pocket Guide

Oracle DBA Pocket Guide PDF Author: David Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 0596100493
Category : Computers
Languages : en
Pages : 153

Get Book

Book Description
A pocket guide that provides useful information about Oracle database administration including software options, installation and initialization, key concepts, and commands.

TOAD Pocket Reference for Oracle

TOAD Pocket Reference for Oracle PDF Author: Jim McDaniel
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596003371
Category : Computers
Languages : en
Pages : 130

Get Book

Book Description
TOAD -- the Tool for Oracle Application Developers -- is an enormously popular interactive environment for Oracle development and administration. It allows developers to build, test, debug, and format their code via an easy-to-use graphical user interface, available in both freeware and commercial versions. TOAD makes developers far more productive; using TOAD, you'll find that program changes that once took hours can now be completed in minutes. In addition to its development features, TOAD also provides extensive facilities for Oracle database administration. Coauthored by the TOADman and TOAD team, and Patrick McGrath of Quest Software, Inc., this pocket reference is a helpful companion for Oracle developers and DBAs. It's packed with quick-reference material: TOAD feature and menu summaries, shortcut keys, suggested changes to TOAD defaults, productivity tips and tricks, and more. The book includes concise discussions of all the basic TOAD components: the SQL Editor, Procedure Editor, Text Editor, SQL Modeler, Schema Browser, and Debugger. It also provides helpful hints on using TOAD to perform database administration and SQL tuning. Whether you're a new or experienced TOAD user, you'll find this quick reference an indispensable companion to the product and its online help files. Book jacket.

Oracle DBA Checklists Pocket Reference

Oracle DBA Checklists Pocket Reference PDF Author: Quest Software
Publisher: "O'Reilly Media, Inc."
ISBN: 0596001223
Category : Computers
Languages : en
Pages : 83

Get Book

Book Description
Oracle database administration is a complex and stressful job. In a series of easy-to-use checklists, this concise pocket reference summarizes the enormous number of tasks you must perform as an Oracle DBA. Each section takes a step-by-step "cookbook" approach to presenting DBA quick-reference material. The Oracle DBA Checklists Pocket Reference is divided into three major sections covering the main areas of an Oracle DBA's responsibilities: Database management. Describes how to maintain existing databases (with a checklist of daily, weekly, and monthly activities), prepare new databases for production, and back up and recover databases (with checklists for how to recover tables, data files, index files, control files, rollback segments, and active and inactive redo logs). Installation and configuration. Contains a summary of key procedures for installation on Unix, Windows NT, and VMS platforms. Also includes special steps for configuring a parallel database. Network management. Helps with installing, configuring, and testing Net8 software on server and client machines. Tasks include confirming network availability and Net8 connectivity, verifying Net8 name resolution, configuring Net8 clients (with LDAP or Oracle Names), configuring Net8 on the server, configuring the Multi-Threaded Server (MTS), tracing client connections, and tracing the Net8 listener. This book's quick-reference, step-by-step approach takes the stress out of DBA problem solving by making it easy to find the information you need--and find it fast.

Oracle Data Dictionary Pocket Reference

Oracle Data Dictionary Pocket Reference PDF Author: David C. Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 0596005172
Category : Computers
Languages : en
Pages : 147

Get Book

Book Description
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).

Oracle DBA Automation Quick Reference

Oracle DBA Automation Quick Reference PDF Author: Charlie Russel
Publisher: Prentice Hall Professional
ISBN: 9780131403017
Category : Database management
Languages : en
Pages : 296

Get Book

Book Description
With concise coverage of both Oracle 9i and Oracle 10g, this is the ideal reference for the professional DBA on how to use Perl to automate database tasks. The book covers language selection and concepts, including basic scripting concepts.

Oracle PL/SQL Language Pocket Reference

Oracle PL/SQL Language Pocket Reference PDF Author: Steven Feuerstein
Publisher: "O'Reilly Media, Inc."
ISBN: 0596006802
Category : Computers
Languages : en
Pages : 157

Get Book

Book Description
Provides quick-reference information that will help you use Oracle's PL/SQL languange, including the newest Oracle Database 10g features. This is a companion to Steven Feuerstein and Bill Pribyl's Oracle PL/SQL Programming.

Oracle PL/SQL Language

Oracle PL/SQL Language PDF Author: Steven Feuerstein
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596004729
Category : Computers
Languages : en
Pages : 132

Get Book

Book Description
This updated edition describes features available in Oracle9i, and provides a quick reference that summarizes PL/SQL syntax for every developer who uses PL/SQL for database programming.

Oracle PL/SQL Language Pocket Reference

Oracle PL/SQL Language Pocket Reference PDF Author: Steven Feuerstein
Publisher: "O'Reilly Media, Inc."
ISBN: 0596551614
Category : Computers
Languages : en
Pages : 181

Get Book

Book Description
The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. This concise guide boils down the most vital PL/SQL information into an accessible summary of: Fundamental language elements (e.g., block structure, datatypes, declarations) Statements for program control, cursor management, and exception handling Records, procedures, functions, triggers, and packages Calling PL/SQL functions in SQL Compilation options, object-oriented features, collections, and Java integration The new edition describes such Oracle Database 11g elements as PL/SQL's function result cache, compound triggers, the CONTINUE statement, the SIMPLE_INTEGER datatype, and improvements to native compilation, regular expressions, and compiler optimization (including intra-unit inlining). In addition, this book now includes substantial new sections on Oracle's built-in functions and packages. When you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration.

Oracle Utilities Pocket Reference

Oracle Utilities Pocket Reference PDF Author: Sanjay Mishra
Publisher: "O'Reilly Media, Inc."
ISBN: 0596553056
Category : Computers
Languages : en
Pages : 125

Get Book

Book Description
The Oracle Utilities Pocket Reference is a handy, quick-reference guide to the multitude of Oracle utilities that database administrators (DBAs) use every hour of every day.As the undisputed leader among database products, Oracle is grasped conceptually by most DBAs. However, they understandably may not recall the specific utility to use for a given task, and, more commonly, won't in many cases remember the syntax to use. And that's exactly what the Oracle Utilities Pocket Reference supplies--the syntax and options for whatever utility a DBA needs to perform a given task.Some of the utilities documented in this guide include: SQL*Loader, for loading data expdp and exp for exporting data to another database oradebug for use in troubleshooting loadjava and dropjava for loading and unloading Java programs Packed with information in an easy-to-read format, this valuable resource is ideal for any experienced DBA. Even database programmers who deal with Oracle will truly appreciate having the Oracle Utilities Pocket Reference close at hand.Authored by Sanjay Mishra, a foremost authority on Oracle systems, this convenient and compact guide is focused and to-the-point, eliminating any potential guesswork or difficult memorization. The Oracle Utilities Pocket Reference is part of the strong-selling collection of O'Reilly "pocket reference" books.