Targeted toward experienced Oracle professionals who need to perform powerful system-wide operating system on their Oracle databases, this definitive guide includes details on all of the Oracle utilities, including an experts-only section on undocumented utilities, plus the Linux/UNIX utilities, Oracle command-line utilities, and the all-important DBA package utilities. Approaching Oracle Utilities from a functional perspective, this guide adds value by explaining the "why" and "how" for the use of all Oracle Utilities. Additionally, the book also covers Oracle tuning utilities and all areas of Oracle database administration, including ADDM and the SQL tuning advisors and the traditional command-line tuning utilities, as well as secrets for database migration, and detailed tips for using Oracle OS utilities.

With the expert techniques discussed in this book, Oracle database administrators can automate routine tasks to save time and money and better monitor the flow of work. Using shell scripts-an indispensable tool on UIX and Linux-any number of commands can be combined and executed either simultaneously or sequentially. More than 50 working shell scripts for both beginners and experts give Oracle professionals a fantastic head-start on automating their administration duties and are easily modifiabl e for any environment. Topics include the history of shells and shell scripting, detailed step-by-step instructions on building shell scripts, how to tell when things are working right, and how to effectively monitor the system for failures.

Covering all aspects of Oracle disk I/O tuning, this book explores disk performance, RAID management, Oracle data file performance, and Oracle data segment internals. Also explored is physical disk I/O, which includes disk device internals, detecting disk bottlenecks, disk organization techniques, and disk striping and disk load balancing. Highlighted are RAID and Oracle performance as well as techniques for effective use of RAID with Oracle. Additionally, Oracle data file internals are consider ed and how to use multiple data block sizes to detect and repair Oracle data segment bottlenecks and segment waits is described. Oracle segment management is illustrated, and the effective use of Oracle segment partitioning, segment slot internals, and monitoring segment I/O is explained.

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 bring order to the chaos of Oracle informatio n -- 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 admini strators need as they manage Oracle databases and write code for these databases.

This book is designed to be the "one-stop shop" for security engineers who want all their information in one place. Content includes the newest vulnerabilities and exploits, assessment methodologies, host review guides, secure baselines, and case studies to bring it all together. Several security experts offer guidance on both technical and strategic subjects.

From the exclusive publishers of Oracle Press Books, here is the only book available offering complete coverage of RMAN (Recovery Manager), Oracle's free backup and recovery technology. An indispensable resource for new Oracle users, database administrators, and system administrators.

Step-by-step configuration guide for Tru64 UNIX 5.1 TruCluster and Oracle9i RAC. Oracle9i RAC installation and configuration tips. Command summary included in each chapter. This quick reference provides step-by-step instructions on setting up Oracle9i RAC to run on a Tru64 UNIX cluster. Configuration information is included from start to finish. Command summary guides are built into each chapter for quick information retrieval. Examples and step-by-step instructions assist in the complete inst allation of a Tru64 UNIX 5.1A and Oracle9i. Designed as an introduction to Tru64 UNIX and Oracle9i RAC, Tru64 UNIX-Oracle9i Cluster Quick Reference will give intermediate and advanced administrators an invaluable resource for quickly locating vital information.

This is a very interesting read for any Unix DBA, full of comprehensive explanations and diagrams on the way in which Oracle interacts with the Unix server. There are many detailed Unix Scripts to help you monitor your instances, which can be run via Statspack (dbms_job) and/or via the Unix cron. There is additional information on some more complicated UNIX commands, and copious small tips and tricks that will help in everyday Database Administration tasks. The book also covers commands for all different Unix environments Solaris, HP-UX, Tru64, AIX etc and help you interpret results from vmstat, sar and other Unix admin utilities.

Oracle DBA on Unix and Linux provides all the information needed to install, support, tune, and upgrade Oracle databases on the UNIX and Linux platforms. Maintain a robust, mission-critical Oracle8i database. This book provides administrative solutions for the day-to-day DBA. You'll learn how to install the database for maximum efficiency, upgrades, patches, migrations, tune, and maintain its security. The book also explains in detail how to build and support a fully functioning Oracle database. This authoritative text contains up-to-date information available on Oracle's latest release and shows you how to: configure database architecture; install and set up with UNIX requirements; create the actual database with scripts; GUI management products; use Backup and Recovery; tune, monitor, and troubleshoot servers; Web DB and the Oracle Portal, 8i, iFS, Java, and 9i coverage; and iAS - Internet Application Server.

The Unix for Oracle DBAs Pocket Reference has a remarkably tight focus. It's about making Oracle database management systems run optimally under various Unix operating systems, including HP-UX, Sun Solaris, and IBM AIX (there's also some specialized coverage of IRIX and DEC Unix). Author Donald Burleson assumes readers know how to get around the Unix command shell, and that they're quite familiar with Oracle database administration. To put it simply, to get the most out of this book, you should already know what you want to do, and need only to be told concisely how to do it. This book is ideal for people moving from Oracle administration under Windows to the same job under Unix.

Oracle & Open Source is the first book to tie together the commercial world of Oracle and the free-wheeling world of open source software. As this book reveals, these two worlds are not as far apart as they may seem. Today, there are many excellent and freely available software tools that Oracle developers and database administrators can use, at no cost, to improve their own coding productivity and their system's performance. Moreover, many of the finest Oracle developers are now making thei r source code freely available so their peers can build upon this code base. Oracle Corporation is even porting its RDBMS to Linux and starting to incorporate a growing number of open source tools in the company's own software. Oracle & Open Source describes close to 100 open source tools you can use for Oracle development and database administration, from large and widely known open source systems (like Linux, Perl, Apache, TCL/Tk and Python) to more Oracle-specific tools (like Orasoft, Ora c, OracleTool, and OraSnap). You'll learn how to obtain the software and how to adapt it to best advantage. The book abounds with code examples, download and installation instructions, and helpful usage hints. Not only does it tell you how to find and use existing open source code; Oracle & Open Source gives you the details and the motivation to build your own open source contributions and release them to the Oracle community. You'll lear n all about tools like the Oracle Call Interface (OCI) and Perl-DBI (Database Interface), which provide the glue allowing new open source tools to link into commercial Oracle software. With Oracle & Open Source as a guide, you'll discover an enormous number of highly effective open source tools, while getting involved with the thriving community of open source development.

The purpose of this book is to share my experiences in the areas of UNIX and Oracle performance and tuning. The chapters of this book provide a tremendous level of detail on the internal workings of the Oracle and UNIX kernels. The purpose of including so much detail is to give the reader a complete understanding of Oracle and UNIX. It is this understanding that will enable the reader to apply these concepts to specific applications and/or user environments, thus enabling the reader to maximize the performance of his or her environment. It is a key characteristic of this book that only the latest versions of Oracle and UNIX are discussed, such as Oracle8i and Solaris 8. This will enable the reader to focus on the functionality and enhancements of the new versions, avoiding discussion of old releases. Another characteristic of this book is that I have organized it into two major areas: data warehousing and Online Transaction Processing (OLTP). This edition of the book places more of an emphasis on application tuning since the application has the most control over the overall performance and scalability. It is important that the application be well designed and highly optimized. Recommended prerequisites for this book are a basic understanding of SQL, UNIX shell language, and experience with UNIX system and Oracle database administration.

Computer professionals increasingly rely on the Web, online help, and other online information sources to solve information pain. Now the second edition of O'Reilly's Unix CD Bookshelf gives you convenient online access to updates of your favorite books on your CD-ROM drive. The UNIX CD Bookshelf contains a powerhouse of UNIX Animal books from O'Reilly plus the complete text and software from UNIX Power Tools -- all readable with your Web browser on a convenient CD-ROM. A bonus hard-copy book, U NIX in a Nutshell, 3rd Edition, is also included. In addition to UNIX Power Tools, you'll find the complete text of the following books: Learning the UNIX Operating System, 4th Edition; Learning the vi Editor, 6th Edition (also new); sed & awk, 2nd Edition; Learning the Korn Shell; and UNIX in a Nutshell, System V Edition. Never has it been easier to learn, or look up, what you need to know online. Formatted in HTML, The UNIX CD Bookshelf can be read by any Web browser. The books are fully s earchable and cross-referenced. In addition to individual indexes for each book, a master index for the entire library is provided.

This kit includes three books: Oracle SQL highperformance tuning, Oracle database administration on UNIX systems, and Oracle and UNIX performance tuning. Three CD ROMs included. The complete professional's resource for building, managing, and optimizing Oracle databases! Oracle DBA Reference Library is an unparalleled practical resource for DBAs, database programmers, IT managers, and anyone who needs to make the most of Oracle database technology. It's three comprehensive, up-to-date books by w orld-class Oracle professionals, plus three CD-ROMs packed with tools and information, all for one great price!

A book/CD-ROM for new and experienced database administrators and managers, reviewing Oracle database architecture and offering step-by- step instructions for planning, sizing, and installing Oracle systems, focusing UNIX-specific configuration and tuning issues. Other topics include security, backup and recovery, and application development. The accompanying CD-ROM contains a multimedia installation and configuration tutorial, readable with any Web browser. Oracle is the leading enterprise data base management system, and more Oracle databases are deployed on UNIX systems than any other platform. There is no introduction to database administration that focuses exclusively on the UNIX platform--this book fills that critical void. The CD-ROM includes a multimedia tutorial on installing and configuring the Oracle server.

A book/CD-ROM package on tuning both current Oracle releases and the underlying Solaris, HP-UX, or Sequent Dynix systems they run on, and on optimizing both OLTP and OLAP decision support systems. Presents a systematic approach to tuning Oracle databases based on UNIX, reviews UNIX kernal-related issues, and introduces techniques for tuning memory, processors, and I/O. Also covers optimizing SQL code. The companion CD-ROM contains tuning tools. Assumes basic understanding of SQL, UNIX shell lang uage, and database administration.

2001-2011 Oracle-Books.com