Publisher: Apress. See details. See all 3 brand new listings. Buy It Now. Add to cart. About this product Product Information Oracle Database 11g : New Features for DBAs and Developers is a comprehensive, example-laden review of the most significant new features and improvements offered by the latest release of Oracle Corporation's flagship database product. Learn what's new in Oracle that really counts See actual examples and test run output Make sound decisions on new feature adoption Sift the gold from the silt and discover which new features of the latest release of Oracle's flagship database product are really worth adopting.
Years of database administration experience from authors Sam Alapati and Charles Kim are combined with sound, step-by-step testing and a heart-felt emphasis on what matters in the real-world to help you get the most out of Oracle Database 11g.
Oracle Database 11g: New Features for DBAs and Developers - Sam Alapati, Charles Kim - Google книги
What you'll learn Which new features really can make your day-to-day work easier How to automate more of your database administration work than ever before Who this book is for Oracle Database 11g: New Features for DBAs and Developers is for developers, database administrators, project managers, consultants, and other technically minded users of the Oracle database. The book will be of use to any professional in the field who wants to quickly review the features offered by the Oracle Database 11g release.
Additional Product Features Number of Volumes. Show More Show Less. Add to Cart. For now, avoid forcing the issue with mere "lists" of works possessing an arbitrary shared characteristic, such as relating to a particular place. Avoid series that cross authors, unless the authors were or became aware of the series identification eg. Also avoid publisher series, unless the publisher has a true monopoly over the "works" in question.
Oracle Database 11g: New Features for DBAs and Developers (Expert's Voice in Oracle)
Series description. Related series The Expert's Voice in. The Expert's Voice in Open Source. The Expert's Voice in Web Development. The Expert's Voice in Java. Books for Professionals by Professionals. The Expert's Voice in Oracle. The Expert's Voice in Java Technology.
The Expert's Voice in Sharepoint. The Expert's Voice in Linux. The Expert's Voice in Silverlight. Apress The Expert's Voice in Linux. Novice to Professional.
go to link The Expert's Voice in Security. The Expert's Voice in Game Programming. How do series work? Helpers AnnaClaire , davidgn 3. Series: The Expert's Voice Series by cover 1—7 of next show all. Accelerated C by Trey Nash. NET by Ellen Hatton. Beginning Android by Mark Murphy. Beginning ASP. NET 2. NET 3. Beginning Drupal 7 by Todd Tomlinson. Beginning Hibernate by Jeff Linwood. Beginning Joomla! Jason Gilmore. Beginning Scala by David Pollak. Beginning WordPress 3 by Stephanie Leary.
Beginning XNA 2. Beginning XNA 3. Beginning Zend Framework by Armando Padilla. New Analytic Functions — Below new Analytic functions were introduced. Default Value in Table ALTER command — In the Oracle version earlier than 11g, if a table has to be altered to add a column, the very next step was to update the existent rows to some default value.
- Pile Design for Structural and Geotechnical Engineers.
- Flirt (Anita Blake, Vampire Hunter).
- Daddy Love;
- How to Teach Religion!
- Human Ecology: Fragments of Anti-Fragmentary Views of the World.
This has resolved the overhead of updating column with default value. For example,. Note that it uses Mixed notation of parameter passing in the Function call. Refer the code snippet in Example code 14a. Oracle 11g identified it as bad code practice to assign NULL operation to the compiler.
Refer the Example code 14b. In oracle 11g, such code would raise a warning PLW Program continues the execution but traces the coding standard failure. They are compatible with the native compilation feature of Oracle 11g, which makes supports their faster implementation. Similarly, the other two data types avoid NULL check and data overflow checks, thereby enhancing performance to a notable extent. Few of them are listed below. This looks quite similar to exclusive mode of locking.
It ignores the unique key violation during insertion. Recursive common table expressions — In Oracle 11g, recursive common table expression CTE algorithm can be used for multiple utilities on hierarchical data. It can be used as number generator, data of bills of material, chasing many to many relationship data and interestingly Sudoku puzzle. Encrypted Tablespace — Encryption of Tablespace was introduced with Oracle 10g version but was deprecated due to multiple existing issues. Tablespace encryption in Oracle 11g extends the concept of Transparent Data Encryption and resolves the limitations of range scan and primary key issues.
A new tablespace can be created in Encrypted form, with all of its tables and indexes in Encrypted form.
Available Encryption algorithms are:. Fine Grained Dependency Tracking — Starting from Oracle 11g Release 1, concept of dependency is enhanced to a much granular level by magnifying logical dimension of the referenced object. If the changes to the referenced object make no consequence on the dependent object, the status of dependent object would remain VALID. In 11g, this feature is majorly implemented for Views and Triggers. Having first introduced in Oracle 9i, data compression feature shows major impact on costs, storage system, and memory usage.
Oracle 11g takes ahead this feature by aiming to reduce the space occupied by data for OLTP as well as warehouse databases. The graph in Fig 2 demonstrates the differences between Oracle 10g and Oracle 11g on Advanced Compression. We shall discuss above features in detail in my upcoming articles on Oracle 11g, with more code snippets, help texts and descriptions. Eye on Databases. Sign in.