|Publisher : by Robert G. Freeman|
|Your Must-Have Guide to Everything New in Oracle Database 11g
Realize the full potential of Oracle Database 11g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved
capabilities of Oracle Database 11g, including:
*New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components
*Improved Automated Memory Management capabilities
*New database design features, such as virtual columns, tablespace encryption, and true table-level data compression
*New Database Advisors for data recovery and repair, partitioning, and streams performance
*New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer
*Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization
*Improved auditing and security capabilities
*Advanced BI, data warehousing, and partitioning features
*New SQL and PL/SQL enhancements
|Publisher : Gavin Powell, Microsoft and Database consultant; Author of seven database books.|
Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune.
Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model.
SQL code tends to be contained inside independent blocks within applications or stored procedures. Physical database tuning involves hardware resource usage, networking and various other Oracle things such as configuration and file distribution. Physical configuration is often a culprit of poor performance where Oracle is installed with defaults, and never altered by an expert.
*Includes all three aspects of Oracle database tuning: data model tuning,
SQL & PL/SQL code tuning, physical plus configuration tuning
ContentData Model Tuning: emphasis on both relational and object model tuning for Java and other object designed Internet OLTP applications. SQL Code Tuning: tune SQL statements both with and without using Optimizer query plans. Physical and Configuration Tuning: creating a well-balanced physical and configuration architecture at initial Oracle installation; bottleneck tuning.
|Publisher : by Ian Abramson, Michael Abbey, and Michael Corey|
Learn the fundamental concepts of Oracle Database 10g administration and programming from this step-by-step beginner’s guide. Through self-paced tutorials, learn about database essentials, the role of the administrator, and large database features. You’ll also get an in-depth introduction to SQL, PL/SQL, Java, and XML programming. Get on your way to becoming an expert Oracle DBA, developer, or user by following the proven learning method of this Oracle Press guide:
Table of Content
|Publisher : -|
|Maximize the Capabilities of Oracle Collaboration Suite
Facilitate enterprisewide communication, data sharing, and team work using Oracle Collaboration Suite 10g and the in-depth information contained in this Oracle Press guide. Oracle Collaboration Suite Handbook explains how to install, implement, manage, and optimize the suite in an enterprise environment. You'll discover how you can use this powerful tool to securely, reliably, and cost-effectively enable real-time collaboration, streamline business processes, simplify data distribution, and consolidate corporate information.
*Tailor a system-specific Oracle Collaboration Suite environment
*Install the Infrastructure Tier, Datastore Tier, and Applications Tier
*Perform successful migrations to Oracle Collaboration Suite 10g
*Create, manage, monitor, and delete user accounts with provisioning
*Control processes, components, and subcomponents from the command line and the Enterprise Manager Browser interface
*Perform reliable full and partial database backups and restores
*Monitor, analyze, and act on system log files
*Administer applications, application components, and program functionality
*Manipulate unstructured data using intelligent containers and Oracle Content Services
|Publisher : by Ian Abramson, Michael Abbey, and Michael Corey|
|The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL,
and perhaps include a few simple examples.
It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs.
But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment.
You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language.
Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory.
Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle's implementation of SQL than any other book on the market.
It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType.
Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL.
For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.
|Publisher : O'Rially|
|One of the most important challenges faced by Oracle database administrators and Oracle developers is the
need to tune SQL statements so that they execute efficiently.
Poorly tuned SQL statements are one of the leading causes of substandard database performance and poor response time.
SQL statements that perform poorly result in frustration for users, and can even prevent a company from serving its customers in a timely manner.
In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients.
Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. Mark also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers.
In addition to the specific problem/solution scenarios for the optimizers, Mark provides a number of handy SQL tuning tips.
He discusses the various optimizer hints, telling you when they can be used to good effect.
Finally, Mark discusses the use of the DBMS_STATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify.
|McGraw Hill , Oracle Database 10g New Features||Download Here..|
|O'Reilly , Oracle - Advanced Programming With Packages||Download Here..|
|O'Reilly , Oracle - Oracle Built In Packages||Download Here..|
|O'Reilly , Oracle Language Pocket Reference||Download Here..|
|O'Reilly , Oracle PL-SQL Built-ins Pocket Reference||Download Here..|
|O'Reilly , Oracle PL SQL Programming||Download Here..|
|Oracle Database 10g - DBA||Download Here..|
|Special Edition Using Oracle 11i||Download Here..|