Home > General > Easy Oracle Jumpstart Oracle Database Management Concepts & Administration
11%
Easy Oracle Jumpstart Oracle Database Management Concepts & Administration

Easy Oracle Jumpstart Oracle Database Management Concepts & Administration

          
5
4
3
2
1

Out of Stock


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.
Notify me when this book is in stock
Add to Wishlist

About the Book

This book introduces you to the Oracle Database in plain English with a focus on providing you with an in-depth knowledge of Oracle’s basic features and management techniques. By explaining how Oracle works, this book will provide you with the information and tools you need to manage and administer an Oracle database. Included are important Oracle tasks such as database creation, startup, shutdown and management. This book also covers Oracle’s capability to protect the data stored in the database, as well as critical daily maintenance scripts. Although focused on Oracle 10g, Easy Oracle Jumpstart includes managing Oracle 9i and 8i. This book is a valuable resource for both the new DBA and a manager wanting to understand the management and operation of an Oracle Database. Key Features Get detailed information on the inner-workings of the Oracle Database and how to effectively use Oracle’s caches Learn how Oracle provides consistent views and transactional control using UNDO and REDO logs See how Oracle protects your data with Archive Logs Protect your data with Archive Logs Learn to manage Users and database security Gain knowledge of Oracle’s Storage Structures including Locally Managed Tablespaces and ASSM Become skilled at Database Monitoring and Performance Tuning. About the Author Robert G. Freeman is a Senior Oracle Consultant with Burleson Consulting. Freeman one of the most famous Oracle experts and author of eight popular Oracle books, including Oracle9i RMAN Backup & Recovery and the bestselling Oracle9i and Oracle 10g New Features books. A respected Oracle expert and author, Robert serves as a writer for DBAZine and SELECT Magazine. Steve Karam is one of less than 20 DBA's worldwide to achieve the coveted Oracle 10g Certified Master status. A former senior instructor for Oracle University, Steve has a proven track record in performance and troubleshooting on dozens of high profile Oracle systems, and complex Oracle 10g RAC environments. Table of Contents CHAPTER 1 – Inside the Oracle Architecture This section describes the Oracle architecture in plain English and shows you how to 1-1: Instance Architecture Creating the OFA file structure ($DBA, bdump, udump, pfile) 1-2: SGA Architecture 1-3: Background processes 1-4: Control file management Explaining the use of control files Listing the Contents of the control File File locations for control Files Obtaining Control File Information Listing control file contents 1-5: UNDO and REDO logs Displaying and Creating Rollback Segments Altering Rollback Segments Determining the Number and Size of Rollback Segments Obtaining Rollback Segment Information from v$rollstat and dba_rollback_segs Troubleshooting Rollback Segment Problems – snapshot too old Redo log concepts for recovery Online redo log (log_buffer) online redo logs and archived redo logs Oracle ARCH and LGWR background processes Redo log dictionary queries Redo log switch frequency and performance Multiplexing the Online Redo Log Files Archiving the Oracle Redo Logs Recovery using the redo log files 1-6: Users and privileges Creating New Database Users User default tablespaces and TEMP Password aging Altering and Dropping Existing Database Users Monitoring Information bbout Existing Users Identifying System and Object Privileges Granting and Revoking Privileges Creating and Modifying Roles Controlling Availability of Roles Removing Roles Using Predefined Roles Displaying Role Information from the Data Dictionary CHAPTER 2 – Managing an Oracle Instance This section 2-1: Initialization file management Creating the init.ora file Displaying init.ora values with v$parameter 2-2: Listener configuration Creating the listener.ora file 2-3: TNS names configuration Creating the tnsnames.ora file 2-4: Data buffer configuration & sizing 2-5: Shared pool configuration & Sizing 2-6: Starting and stopping Oracle Shutdown and Startup an Instance Mounting and opening an instance Chapter 3 – Oracle DBA tools This is an introduction to Oracle administration tools and techniques. 3-1: Enterprise Manager (OEM) 3-2: Schema, File & tablespace management Describing the relationship between data files, tablespaces and table Understanding Oracle segments Creating Tablespaces – using the autoextend option Changing the Size of Tablespaces – alter database datafile command Defining a TEMP tablespace Changing the default storage Settings for a tablespace 3-3: Database Maintenance Reason for reorgs – chained rows, imbalanced freelists Reorganizing Tables using Export and Import Using CTAS to reorganize data Index rebuilding 3-4: Monitoring Oracle Enterprise manager performance pack Displaying and managing Oracle sessions with v$session Monitoring the log and searching for Oracle trace files 3-5: Utilities Imp and exp utilities SQL Loader 3-6: Dictionary and v$ views The dba_, all_ and user_ structures Querying the tables, indexes, and segments views Getting view names from dict view CHAPTER 4 – Managing Oracle objects This section explores the methods used for managing all active components of the Oracle database including 4-1: File and tablespace structures Review of the storage parameters pctfree, pctused and freelists. Chained rows and pctfree Insert performance and pctused values Using the APPEND option with inserts 4-2: Table structures Creating Tables Using Appropriate Storage Settings Controlling table extents and fragmentation Analyzing Tables for CBO statistics Using the dba_tables and dba_segments views Converting Between Different Formats of ROWID 4-3: Index structures Listing the Different Types of Indexes and Their Uses Creating B-Tree, bitmap and function-based Indexes Reorganizing Indexes with alter index rebuild Dropping Indexes Getting Index Information from the Data Dictionary 4-4: Object-oriented Oracle Identification of objects - real-world modeling Object representation Data storage for composite objects Differences between existing data storage methods Benefits of object-oriented systems Comparisons of methodologies Retrofitting existing systems into object technology Improving on traditional systems design methods Internalizing object technology concepts 4-5: Oracle Object Structures Object-oriented Oracle SQL Nested Tables VARRAYS within tables Using object ID’s Using abstract data types 4-6: STATSPACK performance management Installing STATSPACK Running STATSPACK reports Interpreting a STATSPACK report Getting time series reports with STATSPACK Finding performance signatures with STATSPACK CHAPTER 5 – Performance Management This section explores the methods used for performance management in Oracle and shows tips and scripts for monitoring all components of any Oracle database. You will also learn the proper action to take when any area of Oracle becomes a bottleneck. 5-1: Bottleneck performance analysis Top-5 timed events External Server Bottlenecks (Network, I/O, RAM, CPU) 5-2: Tuning at the Instance Level Changing init.ora parameters (index_optimizer_cost_adj, optimizer_mode) Buffer busy waits Object parameters (PCTFREE, PCTUSED, INITTRANS, FREELISTS) 5-4: CBO behavior Introduction to rule-based optimization Introduction to cost-based optimization Changing the default optimizer modes Collecting table and index statistics (dbms_stats) Using column histograms Skewonly 5-5: SQL Tuning Review of Basic joining methods Merge join Hash Join Nested Loop join Advanced SQL operators Between operator Using hints to improve SQL performance Using parallel query to improve performance SQL reusability within the library cache Table high-water mark Table striping and table partitions Using indexes to improve performance Identifying full-table scans Re-writing SQL queries Tuning sub-queries 5-6: Explain plan Using EXPLAIN PLAN Interpreting EXPLAIN PLAN Output Using TKPROF Using SQL*Trace


Best Sellers



Product Details
  • ISBN-13: 9788184043280
  • Publisher: Shroff - Rampant
  • Publisher Imprint: Shroff - Rampant
  • Language: English
  • ISBN-10: 8184043287
  • Publisher Date: 2008
  • Binding: Paperback
  • No of Pages: 230

Related Categories

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
Easy Oracle Jumpstart Oracle Database Management Concepts & Administration
Shroff - Rampant -
Easy Oracle Jumpstart Oracle Database Management Concepts & Administration
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.

Easy Oracle Jumpstart Oracle Database Management Concepts & Administration

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!