Home > Computing and Information Technology > Computer hardware > Maintenance and repairs > Oracle and UNIX Performance Tuning: Maximizing Client/Server Performance (Bk/CD-ROM)
Oracle and UNIX Performance Tuning: Maximizing Client/Server Performance (Bk/CD-ROM)

Oracle and UNIX Performance Tuning: Maximizing Client/Server Performance (Bk/CD-ROM)

          
5
4
3
2
1

Available


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Quantity:
Add to Wishlist

About the Book

84916-6 The only way to truly optimize your database: Tune the Oracle DBMS and the UNIX kernel together. If you're running an Oracle production database system on a UNIX platform, there's only one way to truly maximize your performance: tune both Oracle and UNIX-and understand how the two interrelate. Oracle and UNIX Performance Tuning is the first book to address tuning of both current Oracle releases and the underlying Solaris, HP-UX, or Sequent Dynix systems they're running on. It's also the first Oracle database tuning book with detailed, specific coverage of optimizing both OLTP and decision support systems. Oracle Senior Engineer Ahmed Alomari begins by presenting a systematic approach to tuning Oracle databases based on UNIX, and showing how benchmarking and optimization fit into the development lifecycle. Next, he reviews important UNIX kernel-related issues that impact performance, and introduces effective techniques for tuning memory, processors, and I/O. The book also contains detailed coverage of optimizing SQL code-a factor often neglected in database tuning books, but which can powerfully impact database performance.Alomari makes in-depth recommendations for tuning both decision support and transaction applications - each of which impact the Oracle kernel in significantly different ways. No other tuning book covers specific DSS and OLTP issues in comparable detail. Oracle and UNIX Performance Tuning includes a CD-ROM with shell scripts for Solaris, HP-UX, and Sequent platforms, a performance monitor, Oracle scripts, a parameter reference, and extensive Oracle white papers on tuning and performance issues. Tuning Oracle without tuning UNIX is like tuning half the cylinders on your car. If you want all the performance you're paying for, you need to do both-and Ahmed Alomari's Oracle and UNIX Performance Tuning will show you how.

Table of Contents:
Introduction. Tuning and Science. Tuning by Iteration. Tuning by Understanding. Tuning and Training. Getting the Most of Your Environment. Tuning on the Project. The Team. Resources. Version Control. The Repository. Staying Current. 1. Inside the UNIX Kernel. UNIX Internals. UNIX Architecture. Kernel Layer. File Systems. Virtual Memory. Shared Memory. Process Model. The Job Scheduler. Threads Model. Signals and Interrupts. Network Services and Communication. I/O Services. Synchronization. System Daemon Layer. Shell Layer. Application Layer. 2. Memory and Processor Tuning. UNIX Memory Model. Paging. Swapping. Process Memory Model. Monitoring Paging and Swapping. Tuning Paging. Physmem. Lotsfree. Desfree. Minfree. Maxpgio. Swapping. Configuring Swap. Memory Shortages. Memory Surplus. Kernel Memory Allocator. Shared Memory Parameters. Semaphore Parameters. Processor Architecture. Cache Concepts. Cache Coherency. Central Bus. Threads Model. Threads Safety. Threads Programming. Process Tuning. Processor Related Kernel Parameters. Think Parallel. Right-Sizing the Number of Processors. Affinity Binding on Multi-Processor Systems. Benchmarking Processors. 3. Configuring and Tuning. UNIX I/O Model. Logical Volume Manager. Striping. Striping on Sequent. Striping on Sun. Striping on HP. Maximizing the Performance of the Strip. Partitioning the Disks. Setting the Stripe Width. Mirroring. RAID-5. Asynchronous I/O. Asynchronous I/O in Solaris. Asynchronous I/O in HP-UX. Asynchronous on Sequent. Asynchronous I/O in Oracle. Direct I/O (DIO). Kernelized Asynchronous I/O (KAIO). List I/O (LIO). Read(). Db_file_multiblock_read_count. File Systems Versus Raw Devices. UNIX File Systems. Raw Devices. Separate Sequential and Random I/O. Tablespace Optimization. Setting the Database Block Size. Monitoring I/O Activity. Tuning NFS. NFS and Database. Using the Automounter. Configuring and Sizing the Disk I/O Subsystems. 4. Application Tuning: Eliminating the SQL Bottleneck. Application Architecture. Development Environment. Tuning Pro*C Applications. Using Arrays in Pro*C. Linking with the Shared Library. Pro*C Compile Options. Parallel Processing Using Pro*C. The Make File. Tuning SQL. Rule-Based Optimizer. Coat-Based Optimizer. Using Hints. The Explain Plan. The Hints. Tuning by Selectivity. Using Parallel Query. Using PL/SQL. PL/SQL Tables. Locking Contention. Using the System Packages. Profiling and Optimization. 5. Tuning an OLTP System. Performance Monitoring. Tuning I/O. Local Volume Manager (LVM). Raw Devices. Asynchronous I/O. Oracle Writes. Veritas File System Mount Options. Veritas Database Edition for Oracle. Number of Data Files. Checkpoints. Disk Cache. Monitoring File I/O. Latches and Locks. LRU Latches. Tuning Redo. Configuring the Redo Log Files. Operating System Mirroring Versus Oracle Mirroring. Using PrestoServe for the Redo Log Files. Monitoring the Redo Buffer. Tuning Redo Log Buffer Latches. Tuning Spin_Count. Tuning Rollback Segments. Sizing Rollback Segments. Large Transactions. The Shared Pool. Library Cache. Data Dictionary Cache. Maximizing the Shared Pool Utilization. Fragmentation in the Shared Pool. Sizing the SGA. Tuning Shared Memory. Sizing the Buffer Cache. Tuning Archiving. The Post-Wait Driver. Tuning TCP/IP. Tuning SQL*Net V2. Recursive SQL and tkprof. Tuning Storage Clauses. The Free List. Monitoring Locking. Referential Integrity. Discrete Transactions. Hash Cluster. Database Design. 6.Tuning a Decision Support System (DSS). The Data Warehouse. Requirements for a Data Warehouse. DSS Database Design. Tuning I/O. Sorting. Direct Write Sorts. The Temporary Tablespace. Temporary Tablespaces in Oracle 7.3. Bitmap Indexes. Tuning Queries. The Star Hint. Anti-Join. Histograms. Merge Joins. Hash Joins. Partitioned Views. Loading Data. Direct Path Loads. Conventional Path Loads. Fixed Field Loads. Loading Through NFS. Building Indexes. Building Tables. Parallel Storage. Degree of Parallelism. Parallel Query and the 9/13 Rule. Maximizing Parallel Query Performance. Configuring the Number of Parallel Query Slaves. Reducing Locks. Inter-Node Parallel Query. Single-Task Processes. 7. Media Recovery. The System is Down. System Architecture. Hardware Requirements. Selecting the Backup and Recovery Tools. Configuring and Sizing the Media Devices. Export and the Buffer Option. The Direct Export Option. Import and the Buffer Option. Export, Import, and the 2 G File Limit. Enterprise Backup Utility (EBU). EBU and Hot Backups. Disk and Tape I/O Sizes. Tuning EBU Parameters. Parallel Recovery. Standby Database. 8. Conclusion. Chapter Summaries. Chapter 1 "Inside the UNIX Kernel." Chapter 2 "Memory and Processor Tuning." Chapter 3 "Configuring and Tuning I/O." Chapter 4 "Application Tuning: Eliminating the SQL Bottleneck." Chapter 5 "Tuning an OLTP System." Chapter 6 "Tuning a Decision Support System (DSS)." Chapter 7 "Media Recovery." Oracle8. The Network Computing Architecture. Appendix A: Installing and Configuring UNIX for Optimal Performance. A Corporate Architecture. Determining the Type of System. Sizing the File Systems. Mirroring the Operating System. Installing the UNIX Operating System. Naming Service. Post-Installation Procedures. Appendix B: Installing Oracle for Optimal Performance. A Corporate Architecture. Determining the Type of System. Sizing the File Systems. Directories and File Locations. Installing the Oracle DBMS. Configuring SQL*Net. Post-Installation Procedures. References.


Best Sellers


Product Details
  • ISBN-13: 9780138491673
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Prentice Hall
  • Height: 234 mm
  • No of Pages: 288
  • Sub Title: Maximizing Client/Server Performance (Bk/CD-ROM)
  • Width: 234 mm
  • ISBN-10: 0138491674
  • Publisher Date: 16 Jun 1997
  • Binding: SA
  • Language: English
  • Spine Width: 20 mm
  • Weight: 581 gr


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
Oracle and UNIX Performance Tuning: Maximizing Client/Server Performance (Bk/CD-ROM)
Pearson Education (US) -
Oracle and UNIX Performance Tuning: Maximizing Client/Server Performance (Bk/CD-ROM)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Oracle and UNIX Performance Tuning: Maximizing Client/Server Performance (Bk/CD-ROM)

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book
    Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!
    ASK VIDYA