Understanding the Oracle Server
Home > Computing and Information Technology > Databases > Database software > Understanding the Oracle Server
Understanding the Oracle Server

Understanding the Oracle Server

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

For administrators, programmers, MIS management, students, and anyone involved with Oracle Server. In this book an Oracle Corporation expert walks the reader through Oracle Server architecture, explains how it handles data concurrency, data integrity and other information management issues, and shows how a database administrator can use it to maximum advantage.

Table of Contents:
PART I. INTRODUCTION AND ARCHITECTURE. 1. The Big Picture. Chapter Overview. Oracle7 and Client/Server. Front Ends and Back Ends. The Multiple Servers of Oracle. Applications. Ease of Use. Reduction of Redundancy. Reinforcement of Business Rules. Custom Applications. Application-Development Tools and Related Products. Letting the Tool Handle the Mechanics. Helping Out with Creative Work. The 2000 Series. Networking Products. Preview of Concepts to Come. 2. Structured Query Language. Chapter Overview. The Relational Model: Columns, Rows, and Tables. What Is a Database? Device Independence. Data Definition and Data Manipulation. Common Commands. SELECT. INSERT. UPDATE. DELETE. COMMIT. ROLLBACK. From SQL to PL/SQL. 3. Logical Structures. Chapter Overview. Schemas and Schema Objects. Views. Sequences. Indexes. Clusters. Database Links. Synonyms. Procedures. Packages. Tablespaces. Segments. Data Segments. Rollback Segments. Index Segments. Temporary Segments. Extents. Data Blocks. Data Dictionary and Its Views. Instances. 4. Physical, Memory, and Process Structures. Chapter Overview. Architecture Summary. System Global Area (SGA). Purpose of the SGA. Database Buffer Cache. Redo Log Buffer. Shared Pool. Cursors. Processes. User Processes. Server Processes. Background Processes. Storing Information for a Process. Files. Data Files. Redo Log Files. Control Files. How the Server Uses the Database Buffer Cache. Types of Buffers. The Dirty List. The LRU List. PART II. ADMINISTRATION. 5. Data Integrity. Chapter Overview. Domain Integrity and Datatypes. What Is Domain Integrity? Why Domain Integrity? The Datatypes. Entity Integrity and the Primary Key. Referential Integrity and the Foreign Key. Referencing Versus Referenced Tables. The Foreign Key. Self-Referential Integrity. Enforcing Referential Integrity. Using Declarative Integrity Constraints. NOT NULL. UNIQUE. PRIMARY KEY. FOREIGN KEY. CHECK. Enforcing Custom Data Integrity Rules. Using Procedural Means. Stored Procedures, Functions, and Packages. Database Triggers. 6. Data Consistency and Concurrency. Chapter Overview. Statements and Transactions. Ensuring Accurate Writes. The Lost-Update Problem. How Locks Prevent Destructive Interference. Lock Restrictiveness. Lock Granularity. How the Server Handles Locks. Ensuring Accurate Reads. Consistent Reads. The Multi-version Consistency Model. Transaction-Level Read Consistency. Putting It All Together. 7. Starting and Stopping an Instance. Chapter Overview. Starting an Instance. SQL*DBA: Line Mode Versus Screen Mode. Instance Startup Options. How Do You Start an Instance? What Happens During Instance Startup? Setting Initialization Parameters. Stopping an Instance. When Do You Need to Stop an Instance? How Do You Stop an Instance? What Happens During Shutdown? 8. Managing Space Usage. Chapter Overview. Planning Initial Space Usage. Planning for Fault Tolerance. Setting Up Tablespaces. Setting the Size of Data Files. Setting the Size of Database Blocks. Altering Space Usage. Adding Tablespaces. Adding Data Files. Removing Tablespaces. Deleting Data Files. Further Controlling Space Usage. Controlling Block Usage. Controlling Extent Allocation. Setting Tablespace Quotas. 9. Optimizing Performance. Chapter Overview. Optimizing the Use of Memory. Total Memory. SGA Allocation. Optimizing the Use of Disk Resources. Reducing Contention. Reducing Fragmentation. Using the Multi-threaded Server. Optimizing Queries. Rule-Based Method. Cost-Based Method. Choosing a Method. Using Indexes and Hash Clusters. Indexes. Hash Clusters. 10. Security. Chapter Overview. Identification and Authentication. Creating Users. Choosing an Authentication Method. Setting Resource Limits Through Profiles. Dropping Users. Getting Information About Users. Privileges. Types of Privileges. Granting Privileges. Revoking Privileges. Granting Privileges on Program Units. Getting Information About Privileges. Roles. How Do Roles Work? Why Use Roles When You Can Use Privileges? Predefined Roles. Getting Information About Roles. File Permissions. Auditing Database Activity. 11. Backup, Failure, and Recovery. Chapter Overview. Types of Failure. User Process Failure. Instance Failure. Media Failure. Backup. How Backup Makes Full Recovery Possible. Types of Backup. Performing Offline Backups. Performing Online Backups. Frequency of Backups. Another Reason to Create a Backup. Recovery. Redo Log Buffers and Redo Log Files. How Multiple Log Files Work Together. How the Server Performs Recovery. Checkpoints. Additional Structures for Full Recovery from Media Failure. Mirrored Redo Log Files. Mirrored Control File. Archived Redo Log Files. Read-Only Tablespaces. Advantage of Read- Only Tablespaces. Candidates for Read-Only Tablespaces. Making a Tablespace Read-Only. 12. Distributed Processing. Chapter Overview. Why Use Distributed Databases? SQL*Net. Global Names, Database Links, and Synonyms. Global Names. Database Links. Synonyms. Two-phase Commit: Data Consistency in a Distributed Database. Some Definitions. Potential Problems. How a Two-phase Commit Works. Replication. Read-Only Snapshots. Updatable Snapshots. 13. Parallel Processing. Chapter Overview. Parallel Server. What Is the Parallel Server? Advantages of the Parallel Server. How the Parallel Server Works. Parallel Queries. Uses. How Parallel Querying Works. Hardware and Disk Requirements. Specifying How Many Processors to Use. Index.


Best Sellers


Product Details
  • ISBN-13: 9780131902657
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Prentice Hall
  • Language: English
  • Spine Width: 15 mm
  • Width: 234 mm
  • ISBN-10: 0131902652
  • Publisher Date: 16 Dec 1995
  • Binding: Paperback
  • No of Pages: 208
  • Weight: 408 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Understanding the Oracle Server
Pearson Education (US) -
Understanding the Oracle Server
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.

Understanding the Oracle Server

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!