OCP Oracle Database 11g: New Features for Administrators by Sam Alapati

By Sam Alapati

Книга OCP Oracle Database 11g: New gains for directors examination advisor OCP Oracle Database 11g: New beneficial properties for directors examination consultant Книги Oracle Автор: Sam Alapati Год издания: 2008 Формат: pdf Издат.:The McGraw-Hill businesses, Inc. Страниц: 554 Размер: three ISBN: 0-07-164372-9 Язык: Русский0 (голосов: zero) Оценка:-

Show description

Read or Download OCP Oracle Database 11g: New Features for Administrators Exam Guide PDF

Best oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication allow real-time info entry and information sharing throughout your allotted framework utilizing the specialist details during this Oracle Press advisor. Oracle Streams 11g info Replication explains find out how to manage and administer a unified company facts sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle program exhibit four Recipes offers an example-based method of studying software exhibit - the ground-breaking, quick software improvement platform incorporated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply desires a great instance or to kick begin their pondering and get pointed within the correct path.

Additional info for OCP Oracle Database 11g: New Features for Administrators Exam Guide

Sample text

Downgrading a Database You can easily downgrade a database back to the release from which you upgraded it to the Oracle Database 11g release. Here are the steps: 1. Shut down the database and start it up in the downgrade mode. SQL> startup downgrade 2. Spool the results of the downgrade script. log 3. sql. sql 4. sql script finished executing, shut down the database cleanly. SQL> shutdown immediate Upgrading to Oracle Database 11g 31 5. Start up the database in the upgrade mode, from the pre-upgrade ORACLE_ HOME environment.

Chapter 2 shows how the Configuration Manager can facilitate the transmission of configuration information to Oracle Support. 02 New Features in Database Creation There are some key changes in creating an Oracle database when you use the DBCA to create the database. Whether you create a database with the DBCA or manually by using the create database SQL statement, you must be aware of the important new initialization parameters in Oracle Database 11g. I thus summarize the key new initialization parameters before moving on to the new features in database creation.

Chapter 3 explains how to use the sec_max_failed_login_ attempts parameter. ■ The parameters optimizer_capture_sql_plan_baselines and optimizer_use_sql_baselines support the SQL Plan Management feature, which replaces the stored outlines feature. The parameter optimizer_use_private_statistics enables you to create private optimizer statistics. Another optimizer-related new initialization parameter, optimizer_use_invisible_indexes, enables you to manage invisible indexes, as discussed in Chapter 8.

Download PDF sample

Rated 4.05 of 5 – based on 36 votes