+1 401 783 6172 (International callers)
gary@skillbuilders.com
Request Info
Register Login

Login/Register to Access all of Skillbuilders' Content

Connect with:

Login with Facebook Login with Google Login with LinkedIn

Login with your site account

Connect with:

Login with Facebook Login with Google Login with LinkedIn


Lost your password?

Not a member yet? Register now

SkillBuildersSkillBuilders
  • Services
    • Oracle APEX Hosting on AWS
    • Oracle Database Admin/Remote DBA
    • Oracle APEX App Development
    • APEX Administration
  • Products
    • Oracle Database Manager (free)
    • Deprecated APEX Plugins
  • Training
    • Course Calendar
    • Oracle DBA
    • Oracle Developer
    • Oracle APEX
    • Web Development
    • Free Webinars
    • Mentoring
    • Free Oracle Database Tutorials
      • Free Oracle Database Administration Tutorials
      • Free Oracle Developer Tutorials
      • Free Oracle APEX Tutorials
      • Free Solaris 11, Oracle VM and ZFS Tutorials
      • Free Oracle Database Retired Tutorials
      • Free Groovy and Grails Tutorials
  • Blog
  • About
    • About Us
    • Our Team
    • Events
    • Case Studies
      • Oracle Database Administration
      • Oracle APEX Development
      • Oracle APEX Administration
      • Oracle and AWS Cloud
    • Client Testimonials
    • Contact
    • Services
      • Oracle APEX Hosting on AWS
      • Oracle Database Admin/Remote DBA
      • Oracle APEX App Development
      • APEX Administration
    • Products
      • Oracle Database Manager (free)
      • Deprecated APEX Plugins
    • Training
      • Course Calendar
      • Oracle DBA
      • Oracle Developer
      • Oracle APEX
      • Web Development
      • Free Webinars
      • Mentoring
      • Free Oracle Database Tutorials
        • Free Oracle Database Administration Tutorials
        • Free Oracle Developer Tutorials
        • Free Oracle APEX Tutorials
        • Free Solaris 11, Oracle VM and ZFS Tutorials
        • Free Oracle Database Retired Tutorials
        • Free Groovy and Grails Tutorials
    • Blog
    • About
      • About Us
      • Our Team
      • Events
      • Case Studies
        • Oracle Database Administration
        • Oracle APEX Development
        • Oracle APEX Administration
        • Oracle and AWS Cloud
      • Client Testimonials
      • Contact

    Oracle Database 10g New Features by Example

    • Home
    • Oracle Database 10g New Features by Example

    Oracle Database 10g New Features by Example

    By Dave Anderson
    A Practical and Hands-On Introduction to Oracle Database 10g New Features



    Spiral Bound 446 pages, Price $60.00(US)

    Book Description

    The essential step-by-step Oracle 10g new features course book for experienced Oracle9i Developers and Database Administrators.

    This course book presents – in a succinct and practical fashion – an introduction to more than 120 new features introduced with Oracle Database 10g. Release 1 and Release 2 features are covered. If you are an experienced Oracle9i DBA or Developer, you will learn the concepts of a feature and receive – via more than 180 working examples – an introduction to the implementation and use of the feature. This book is an invaluable resource for those migrating to Oracle 10g. Scripts are available free .

    The book’s design lends itself to classroom use or self-study. Most pages contain a “slide” at the top of the page that contains a working example or critical points about a feature. Below each slide are descriptive notes that expand on the points or provide insight into the example. (Look inside this book)

    The book is spiral bound and will lay down flat making it easy to use when working at your computer.

    Topics include:

    • Flashback Enhancements – Flashback Version Query, Flashback Transaction Query, LOB Handling with Flashback, Setting up for Flashback, Flashback Table, Flashback Drop Table and Recycle Bin management.
    • Backup and Recovery Enhancements – Flash Recovery Area, Flashback Database (setup, flashback logs and use), Restore Points, Simplified Recovery through RESETLOGS, Compressed Backups, Change Tracking, Incrementally Updated Image Copies, SWITCH DATABASE, New V$ Views, Encrypted Backups, DROP DATABASE, CATALOG, Oracle Secure Backup and more.
    • Automatic Storage Management – An introduction to Oracle’s new integrated file system and volume manager. Examples illustrate the basic use of ASM, including creating disk groups, fail groups, and using ASMCMD.
    • Job Scheduler – Use the new DBMS_SCHEDULER package to schedule jobs, including OS scripts. Examples illustrate creating and scheduling jobs in both a Linux and a Windows environment.
    • SQL Enhancements – Regular expressions, DML error logging, case-insensitive sort and search, MERGE enhancements, MODEL queries, XQUERY and much more.
    • PL/SQL Enhancements – The new optimizing compiler, compiler warning messages, debugging improvements, native compilation enhancements, UTL_MAIL and more.
    • Performance and Tuning Features – Automatic SGA Management, Automatic Workload Repository (AWR), Advisors (ADDM, SQL Tuning Advisor, etc), Active Session History data, new performance statistics (e.g. metrics and database time), Thresholds and Server-Generated Alerts, CBO Enhancements and much more.
    • Security and Auditing Enhancements – Changes to the CONNECT Role, FGAC Review, FGAC / VPD Enhancements, FGA Review, Fine Grained Auditing Enhancements, Encryption Enhancements, DBMS_CRYPTO Package (R1) and Transparent Data Encryption (R2).
    • Tablespace, Table and Segment Management – SYSAUX tablespace, BIGFILE and SMALLFILE tablespaces, database-level default tablespace, database-level default temp tablespace, temp tablespace groups, multi-platform transportable tablespace, renaming tablespaces, predicting object growth, online table redefinition enhancements and online segment shrink.
    • Utilities (Data Pump) – An example-based introduction to Data Pump, the next generation export / import utility. Also covered: External Table and Logminer enhancements.
    • SQL*Plus Enhancements – New predefined variables, SPOOL command enhancements, AUTOTRACE enhancements and more.
    • Miscellaneous Enhancements – Guaranteed UNDO retention, ROLLBACK monitoring, Easy Connect (EZCONNECT) connections, database high watermark recording, database feature usage tracking and new and deprecated initialization parameters.

    What this course book is not :

    • This book is not an exhaustive treatment of each and every feature in Oracle 10g. Readers should expect to come away with a solid understanding of the features covered and their purpose. The material will provide, in most cases, the knowledge required to get started with use of or implementation of the feature or enhancement.
    • This book is not a rehashing of Oracle documentation or Oracle command syntax.
      Oracle Instructors Take Note: Instructor kits are available for purchase from the publisher’s web site.

    About the Author
    Dave Anderson has been working in the Information Technology industry as a developer, database administrator, author and teacher since 1980. He has developed and managed applications and databases for banks, retailers, a defense contractor and an oil company, to name a few. He is a frequent and highly rated speaker at Oracle industry events. Dave founded and is still employed by SkillBuilders, an IT training and consulting firm, located in Rhode Island , USA !

    Product Details
    Spiral Bound Paperback: 446 pages

    Publisher: SkillBuilders, Inc. 2nd Edition July 2006

    Language: English

    Shipping Weight: 4 pounds

    Copyright © Skillbuilders.com

    Interested in joining our team?

    View details
    Managed APEX Hosting on AWS

    Sorry. This form is no longer accepting new submissions.