Configuring and Tuning Databases on the Solaris Platform

Placing Orders
Barnes&Noble · Amazon

Preface

Table of Contents

Errata/Clarifications

Sample Chapters

Utilities

Ordering the Book

Blog

Check out my blog over at blogs.sun.com. Any news about a Second Edition of the book will be posted there.




Click on the front or back cover to see a larger image


Preface

    To get some background on the book, its layout and its intended audience, refer to the Preface.



Table of Contents

    You can view the Table of Contents by clicking here.



Errata

    You can find a list of corrections for errors and typos here. Clarifications are also listed in the same location.



Sample Chapters

  • Chapter 21, Drill-Down Monitoring of Database Servers, has been published in pdf format as a Sun BluePrints Online article (June 2002 edition).
  • Chapter 22, Monitoring and Tuning Oracle, appears in two parts in the July and August 2002 editions.



Utilities

    Here are some of the utilities referred to in the book. By downloading any of these utilities, you are acknowledging that you will receive no support of any kind. By downloading you are also acknowledging that neither Allan Packer nor Sun Microsystems accept any liability whatsoever for the use of these utilities.
    • The statit utility (referred to on pages 278 and 289) provides a broad range of system information, including disk and network statistics. While I'm trying to locate a current manpage, here is an old one.
    • The procmem utility (referred to on pages 280 and 285) helps identify where your memory is being used. It shows all memory used by processes, but doesn't show memory currently used by the UNIX file system page cache. Run "procmem -h" to get detailed usage information. Procmem expects that you have installed Richard McDougall's memtool package (referred to on pages 280, 284, and 285).
    • Srmtool (tarfile, 75 Kbytes) is an unsupported GUI frontend for Solaris Resource Manager (SRM) 1.x. This tool is also available on http://www.sun.com/bigadmin. The tarfile includes a README file with installation instructions. Refer to page 215 for more information.

      Srmtool is written in Java and supports SRM 1.0 (Solaris 2.6), SRM 1.1 (Solaris 7) and SRM 1.2 (Solaris 8). It is easy to use and includes extensive context-sensitive help.

      You might also want to check out the Implementation Guide: Consolidating Oracle RDBMS Instances Using Solaris Resource Manager Software on Sun's Solaris Resource Manager page. This whitepaper also includes a couple of srmtool screenshots.

    • The Starfire Timeshare Dispatch Table is suitable for use on all Sun Enterprise E3x00-E6x00 servers and on Sun Fire x800 servers. Refer to page 221 for more details of its purpose and use.
    • The Timeshare Scheduling Class Dispatch Modifications script referred to on page 221 is available both for Enterprise Ex500 platforms and Sun Fire x800 platforms (tarfile, 27 Kbytes), and for the Enterprise 10000 (Starfire) platform (tarfile, 30 Kbytes). Each tarfile includes modified dispatch tables as well as a script to modify nominated processes to take advantage of them. The onus is on you to modify the search strings for your environment. IMPORTANT - please note the caveats on page 222. If you decide to use these scripts you're on your own! That means you won't ask me (or Sun) for support, and won't complain if your production system hangs as a result of using them!
    • The DB2 for Solaris db2mon monitoring script, referred to on pages 402 and 407.
    • The Oracle _params script to display hidden parameters, referred to on page 312.
    • The top utility, referred to on page 278. For top versions for Solaris 2.5.1 to Solaris 9, untar the top tarball into a bin directory that's in your path (e.g. /usr/local/bin). For example, if the top tarball has been downloaded into /tmp, and the target directory is /usr/local/bin, run the following commands:

      cd /usr/local/bin; tar xvf /tmp/top.tar

    Still to Come
    • HandsOff Remote Terminal Emulator. Referred to on pages 186, 275, and 464.
    • Virtual Adrian, referred to on page 277. The SE toolkit, referred to on page 293.
    • The sample RCM script referred to on page 345.



Ordering the Book

    The book is in stock on the web at Barnes&Noble and Amazon. Borders bookstores and other major technical bookstores also have it in stock. You can place online orders at this Barnes&Noble page and this Amazon page.




This page maintained by Allan.Packer@Sun.COM