Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

ISBN
978-0-9797951-0-7

0-9797951-0-9

Library of Congress Number:
2008936207
480pages
Perfect Bind 9x7
PD 908
Shelving: Databases/Oracle Oracle In-Focus Series # 30
  Oracle 11g New Features
Get started fast with Oracle11g enhancements
 

John Garmany, Steve Karam, Lutz Hartmann, V. J. Jain, Brian Carr

Retail Price $39.95 /  £34.95 

       
Key Features   About the Authors Table of Contents
Index   Reader Comments Errata
       

- Order now and get 30% off the retail price!

Only $28.95

 


Oracle 11g grid database is the next incarnation of Oracle's flagship database management system, noted as the world's most flexible and robust data storage platform.

Many of the Oracle11g new features are intended to automate the inherent complexity of the Oracle engine, and this book on Oracle 11g new features explores all of the new features from the perspective of a working Oracle professional.

Unlike other 11g new features book that list all new features regardless of value, this Oracle 11g new features book shows only the important Oracle 11g enhancements and includes expert discussion about each new feature, why the new feature is important, and how to use the new 11g functionality.

Oracle 11g has over 500 new features and this comprehensive Oracle11g new features book explores those enhancements most useful to Oracle users:

  • 11g SQL new features

  • 11g language & PL/SQL new features

  • 11g DBA features

  • 11g RAC new features & enhancements

  • 11g performance features

  • 11g security new features

  • 11g Enterprise Manager (OEM) new features

This is the flagship book on Oracle11g new features written by working Oracle experts with many years of real-world experience.  This book is the indispensable reference for Oracle 11g new features for both DBA's and Oracle developers and programmers.

 
 

 
The Premier
Book of Oracle 11g

New Features

Key Features

* See Oracle11g SQL new features

* Understand Oracle 11g language & PL/SQL new features

* Learn the Oracle 11g DBA new features

* See the Oracle 11g RAC new features & enhancements

* Examine 11g new high-performance features

* Learn 11g security new features

* Use 11g OEM new features
 

About the Authors:


Lutz Hartmann

Lutz Hartmann is a senior instructor specializing in Oracle trainings for DBAs and developers. Lutz has been an Oracle employee for more than 6 years.

After leaving Oracle Corporation Lutz has raised his own company sysdba database consulting GmbH in Switzerland which provides advanced Oracle consulting and support services as well as custom courses for DBAs and developers.

 Lutz was one of the first trainers worldwide to deliver 11g New Features courses for Oracle University and Oracle Support Services.  He has delivered Oracle trainings in more than 10 countries and three continents.

Lutz has published a great number of articles on Oracle new features in American, Swiss and German tech magazines and speaks at Oracle User Group meetings from time to time. His blog http://sysdba.wordpress.com is well recognized in the Oracle community and registers more than 100,000 hits per year.

For his outstanding contributions to the oracle communities he was awarded ORACLE ACE in 2006.

   

V.J. Jain

V.J. Jain is an Oracle Database and Applications consultant with over 12 years of experience in database and ERP systems. He specializes in database performance, development, interfaces and high-performance solutions. V.J. actively evaluates Oracle's newest technologies and is a member of the Oracle Partner Network and Beta program. He has published articles on SearchOracle, OraFaq, OTN and is the owner of www.oracle-developer.com.

V.J. received his B.S. in Information and Computer Science from the University of California Irvine and is a veteran of the U.S. Army National Guard who was in military intelligence and held a TS/SCI security clearance. V.J. is the owner of Varun Jain, Inc., a Southern California based consulting firm.

   

Brian Carr

Brian Carr works as a Senior Oracle DBA and is an Oracle Certified Professional and Oracle ACE. His articles have appeared in SELECT Journal, OTN, Database Trends and Applications, JavaWorld, and DevX. He co-wrote a multithreaded Web crawler and search engine in Perl, as well as an anonymous web browsing service in C#. Brian also wrote a server monitoring solution that has been commercially released.  Brian has a Master of Business Administration degree.

   

John Garmany

 

John Garmany has been working as an Oracle DBA since 2002.

Steve Karam

                   

Steve Karam is one of the few DBAs worldwide to achieve both the Oracle 10g Certified Master certification and the Oracle ACE designation, both of which he received before the age of 26.  As both a production DBA and an instructor, he has a proven track record in performance and troubleshooting on dozens of high profile Oracle systems including complex RAC environments. 

Additionally, Steve has been developing against Oracle databases for over twelve years on a variety of platforms including C, C++, Java, PHP, and Application Express.
Steve is also involved heavily in the Oracle community as the President of the Hampton Roads Oracle Users Group, Web Chair for the IOUG RAC SIG, and judge for the yearly Oracle Academy educational competition.
 

Table of Contents:
 


Using the Online Code Depot
Conventions Used in this Book   
Acknowledgements
Credits

Chapter 1: Introduction to 11g New Features
Inside 11g New Features  
Oracle 11g DBA New Features
Oracle 11g High Availability & RAC new features
OEM - Enterprise Manager Oracle 11g new features
Oracle 11g New Features Programming Language Support 
Oracle 11g PL/SQL New Features          
Oracle SQL optimizer (CBO) Improvements       
Oracle 11g SQL New Features    
11g Performance Tuning Optimization New Features
Oracle 11g Security & Auditing New Features  
Oracle 11g New RMAN Features
HTML-DB 11g Enhancements     
Oracle 11g Business Intelligence & OLAP        
Oracle 11g data mining     
Conclusion  

Chapter 2: 11g New DBA Features
11g for the DBA      
Partitioning Enhancements          
Interval Partitioning
System Partitioning
Reference Partitioning      
Virtual Column-Based Partitioning         
Composite Partitioning Enhancements 
Enhanced Partition Pruning Capabilities          
Enhanced Information Lifecycle Management 
The Oracle 11g ILM Assistant       
New Index Features           
Invisible indexes     
Improved table compression         
Improved NFS Performance/Management        
Database Resident Connection Pooling           
Oracle Call Interface (OCI) Consistent Client Cache   
Virtual columns       
Oracle 11g Binary XML data storage       
Incident Packaging Service          
Enhanced Read-only tables         
Faster DML triggers
Conclusion  

Chapter 3: High Availability and RAC New Features
Background of Oracle RAC          
Scalability     
Automatic Workload Repository   
Services        
Putting Load Balancing into Action        
Cloning a Cluster to another Cluster      
Scalability Conclusion       
Cluster Performance          
ADDM for RAC        
High Availability      
Clusterware Rolling Upgrades     
ASM Rolling Upgrades      
Conclusion  

Chapter 4: OEM Oracle 11g new features
Introduction to OEM           
Improved Database Home Page and Performance changes  Integrated Interface for LogMiner 
Advanced Replication Interface   
Wait Activity Detail Enhancement           
Easy Oracle Text Management    
Better OEM Grid Tools       
Clone Database Enhancements 
Migrate Database (and more!) to ASM    
Workspace Manager          
Find Referential Integrity Constraints     
Compress a Workspace     
Manage System Parameters         
Privilege Management       
Conclusion  

Chapter 5: Oracle 11g PL/SQL New Features
11g PL/SQL New Features           
PL/SQL Sequence Access           
SIMPLE Number Types     
The CONTINUE Statement           
PL/SQL Subprogram Inlining       
PL/SQL Compound Triggers        
PL/SQL Trigger Enhancements   
Cross-Session PL/SQL Function Result Cache           
Conclusion  

Chapter 6: Oracle 11g SQL New Features
11g SQL       
SQL PIVOT and UNPIVOT Operators     
Regular Expressions Enhancements     
regexp_instr 
regexp_substr          
regexp_count          
Result Cache Hint  
HASH OUTER JOINS        
Conclusion  

Chapter 7: 11g Performance Tuning Features
New Performance Tuning Features        
A trip to the SPA – Inside the 11g SQL Performance Analyzer          
Decision Support and Expert Systems Technology     
Inside the Oracle 11g SQL Performance Analyzer       
A trip to the SPA      
Comparing the SPA Results        
Extended Optimizer Statistics       
Inside Extended Optimizer Statistics       
Automatic Diagnostic Repository 
Conclusion  

 


Chapter 8: Oracle 11g Security Enhancements
        
New Password Security Features           
Enhances hashing algorithm       
Passwords with symbols in 11g   
Case sensitive passwords
Case sensitive passwords and database upgrade to 11g       
How to enable the Oracle 11g EXCLUSIVE MODE     
Enforcing complex passwords     
How to find accounts with default passwords in 11g   
Other Hacking Prevention Features       
Auditing by DEFAULT in 11g       
Strong Authentication for SYSDBA and SYSOPER in 11g   
Limiting Access to External Networking Services         
How to create and manage ACLs with PL/SQL
How to create and manage ACLs with OEM     
Other network security features   
Transparent Data Encryption Features in 11g  
External Master Key Storage using Hardware Security Module        
TDE with Logminer and Logical Standby Database    
TDE with Export Data Pump         
Transparent Tablespace Encryption       
TDE with Enterprise Manager      
Intelligent LOB Encryption with Secure File LOBs       
Securefile Lobs at work     
Securefile Lobs at work with OEM           
Virtual Private Catalogues for RMAN     
Other security aspects about backup in 11g      
Conclusion 

Chapter 9: 11g New Features Streams and Data Guard
Data Guard  
Physical Standby + Real-Time Query     
Snapshot Standby  
Creation of Standby Database     
Dynamic Setting of Oracle Data Guard SQL Apply Parameters         
Streams        
Streams Performance        
Streams Topology   
Materialized Views 
Conclusion  

Chapter 10: Oracle 11g Change Management
RAT - Real Application Testing    
Testing with a snapshot standby database        
SQL Performance Analyzer (SPA)          
SQL Performance Analyzer using PL/SQL        
SQL Performance Analyzer using OEM 
Database Replay    
Database replay using the command line         
Preparing the system for capture 
Capturing the workload     
How to capture a workload in a 10g database for replay in an 11g database (patchset 10.2.0.4)           
Preparing the testing system for workload replay         
Workload replay and analysis on the testing system   
Database replay in the GUI           
Conclusion  

Chapter 11: SQL Management
SQL Plan Management with SQL Plan Baselines       
How Automatic SQL Plan Management works 
Use cases for Automatic SQL Plan Management        
SQL Plan Management in OEM  
How Manual SQL Plan Loading works  
Integration of SQL Plan Management with Automatic SQL Tuning  
Conclusion  

Chapter 12: Oracle 11g Flashback
A brief history of FLASHBACK functionalities  
TRANSACTION BACKOUT in Oracle 11g         
Transaction backout without OEM using PL/SQL        
Transaction backout with OEM    
Oracle Total Recall 
The Technology Behind It 
Enabling Flashback Data Archive           
What is in the Flashback Data Archive?
DDL limitations for Flashback Data Archive      
What’s new about UNDO and transactions in 11g?    
Optimized UNDO BACKUP with RMAN 
Conclusion  

Chapter 13: Oracle 11g ASM Enhancements
ASM Security Enhancements       |
SYSASM role in 11g          
UPGRADING ASM to 11g 
ASM disk group attributes 
Resetting the CSSd           
ASM Rolling Upgrade        
ASM Fast Mirror Resync    
ASM Performance Enhancements         
Variable size of Allocation Units  
ASM Fast Rebalance         
Stretched ASM cluster configuration with ASM Preferred Mirror Read in 11g        
ASMCMD new features     
Automatic and manual ASM disk repair in 11g 
ASM Disk Group Checks Enhanced      
ASM metadata         
Conclusion  
Index 

About the Authors  
John Garmany        
Steve Karam
Lutz Hartmann        
V.J. Jain        
Brian Carr     

Index Topics:

_
_asm_ausize   
_asm_stripesize          
_newsort_enabled      
_recyclebin     

A
accept_sql_profiles    
Access Advisor          
Access Control Lists  
add_filter       
Advanced Replication
Advanced Security Network Encryption Option      
Advanced Security Option    
alert.logs         
allowed_logon_versions        
alter_param    
alter_sql_plan_baseline          
ambr_backup_intermediate_file        
analyze_current_performance
apply_captured_compilenv    
apply_set        
apply_unset    
ARCH transport        
asm_preferred_read_failure_groups  
asmcmd          
au_size           
aud$   
Audit Vault    
audit_trail       
Automatic Segment Space Management       
Automatic Shared Memory Management      
Automatic Storage Management    
   

B
background_dump_dest
basic_filter
Benchmark Factory
Binary XML
BINARY_DOUBLE
BINARY_FLOAT
bloom filtering
buffer_gets     

C
cancel_analysis_task
chained blocks
Class of Secure Transports
client_result_cache_lag
client_result_cache_size
client_result_cache_stats$
Clone Database
clone.pl
cloning
cluster interconnect
Cluster Synchronization Service daemon
cluster_database
clustered tables
comparison_metric
compatible
compensating transaction
composite partitioning
compound trigger
configure_pool
connect_time_scale
connection broker
Connection Load Balancing
connection pooling
Content Repository API
core_dump_dest
cost-based optimizer           
cp
cpu_count
cpu_time
create_analysis_task
create_job
create_sqlset
create_virtual_catalog
ctx_user_index_errors
Cube Organized Materialized Views   
CURRVAL

D
Dark Fiber
data pump
Database Configuration Assistant
Database Control
Database Resident Connection Pooling
days_to_expire
db_block_size
db_cache_size
db_file_multiblock_read_count
db_recovery_file_dest
db_recovery_file_dest_size
db_securefile
dba_advisor
dba_advisor_executions
dba_blockers
dba_cpool_info
dba_free_space
dba_hist_sql_plan
dba_hist_sqlstat
dba_indexes
dba_network_acls
dba_part_tables
dba_segments
dba_sql_plan_baselines
dba_streams_tp_component
dba_streams_tp_component_link
dba_streams_tp_component_stat
dba_streams_tp_database
dba_streams_tp_path_bottleneck
dba_streams_tp_path_stat
dba_tab_partitions
dba_tables
dba_user_network_acl_privileges
dba_users
dba_users_with_defpwd
dba_waiters
dba_workload_captures
dba_workload_filters
dba{user}_advisor_executions           
dba{user}_advisor_findings
dba{user}_advisor_sqlplans
dba{user}_advisor_sqlstats
dba{user}_advisor_tasks
DBCA
DBConsole
dbms_addm.analyze_partial
dbms_addm.get_report
dbms_auto_task_admin
dbms_connection_pool
dbms_file_transfer
dbms_flashback   
dbms_logstdby     
dbms_network_acl_admin
dbms_network_acl_utility    
dbms_rcvcat         
dbms_repair          
dbms_result_cache              
dbms_scheduler   
dbms_space         
dbms_spm            
dbms_sqlpa          
dbms_sqltune       
dbms_stats            
dbms_streams_tablespace_adm
dbms_workload_capture     
dbms_workload_replay       
dbms_workload_repository
dbms_xplan          
deadly embrace    
default_action       
default_execution_type        
delete_filter           
denial of service attacks
diagnostic_dest   
Direct NFS Client  
direct_writes         
disaster recovery
disk_reads            
disk_repair_time   
display_sql_plan_baseline 
drop_analysis_task             

 

 

E
elapsed_time
enable_at_time
encryption
encryption_algorithm
encryption_mode
encryption_password
encryption_wallen_location
evolve_sql_plan_baseline
excution_type       
execute_analysis_task
execution plan      
execution_days_to_expire
execution_name1 
execution_name2
expdp    
explain_plan         

F
fal_client
fal_server              
Fast Connection Failover
Fined Grained Auditing
flashback data archiver       
flashback query    
flashback transaction          
flashback transaction query
flashback versions query    
flashback_retention_target  
flashback_transaction_query              
flush       

G
gather_workload_stats
global cache hot blocks
Grid Control         
gv$asm_disk        

H
Hangman Utility    
Hardware Security Module
hash_area_size
Health Monitor      
hosts     

I
identification key logging
ignorecase            
ILM Assistant        
impdp    
inactivity_timeout 
Incident Package Service    
Incident Packaging System
incremental           
incrsize  
Index Organized Tables      
Information Lifecycle Management    
inlining  
interrupt_analysis_task       
interrupt_anaylsis_task       
Interval Partitioning             
invalidate              
invalidate_object  
invisible indexes  
Invisible indexes

L
ldap_directory_access
ldap_directory_sysauth       
list-hash
list-list    
list-range               
local_time_limit     
Log Writer             
log_archive_dest_1             
log_archive_dest_10           
log_archive_dest_n
 Logical Standby Database  
Logminer               
LogMiner               
lost writes              
lsdsk      

M
max_lifetime_session          
max_think_time    
max_use_session
maxconn_cbrok   
Maximum Availability Architecture      
maxsize 
md_backup           
md_restore            
memory_max_target             
memory_report     
memory_target      
minsize  

N
NetCA    
NEXTVAL               
no_restart_mode  
num_cbrok            
numtxns

O
oci_result_cache_max_rset_rows      
oci_result_cache_max_rset_size        
oci_result_cache_max_size
OEM Text Manager              
ONLINE REDEFINITION      
optimizer_capture_sql_plan_baselines             
optimizer_cost      
optimizer_features_enable   
optimizer_index_caching    
optimizer_index_cost_adj   
optimizer_mode    
optimizer_use_sql_plan_baselines    
options  
ORA-24247            
ORA-28334            
Oracle Call Interface            
Oracle Cluster Registry       
Oracle Enterprise Manager Database Control  
Oracle Notification Service 
Oracle Secure Backup         
Oracle Text           
Oracle Universal Installer    
oranfstab               

P
parallel_automatic_tuning   
partition key          
partition pruning  
partitioning key    
password_versions             
pga_aggregate_target         
plan_filter              
planning downtime              
PLS_INTEGER      
plsql_optimizer_level           
PRAGMA INLINE   
pre_11g_enable_capture     
preupdate.sh        
primary connection nodes 
principal
privilege
publish  

R
range partitioning
range-hash           
range-list               
range-range          
rank_measure1     
rank_measure2     
rank_measure3     
recovery_catalog_owner     
recyclebin             
reference partitioning          
Reference partitioning         
referential constraint            
regexp_count       
regexp_instr         
regexp_like           
regexp_replace    
regexp_substr       
remap    
report_analysis_task           
reset_analysis_task             
result_cache         
result_cache_max_result
result_cache_max_size        
result_cache_mode
result_cache_remote_expiration
resume_analysis_task         
resume_filter         
Row Level Security               
rvwr        

S
sec_case_sensitive_login   
sec_max_failed_login_attempts
sec_protocol_error_further_action
sec_protocol_error_trace_action       
sec_return_server_release_banner    
SecureFiles           
session_cached_cursors    
set_analysis_default_parameter
set_analysis_task_parameter              
set_table_prefs     
sga_max_size       
sga_target             
shared_pool_size
SIMPLE_DOUBLE 
SIMPLE_FLOAT    
SIMPLE_INTEGER
sort_area_size      
spfile      
SQL Performance Analyzer 
SQL Plan History
SQL Tuning Set    
sql_impact_threshold
sql_limit 
sql_percentage    
sqlnet    
srvctl      
stale_percent        
status     
Stored Outlines    
subexpression parameter    
subquery pruning 
supertypes            
supplemental logging         
Swingbench          
synchronization   
sys.user$               
sys.xid_array        
sys_auto_sql_tuning_task  
System Parameters               
System partitioning              
System Partitioning

T
Tablespace Migration Wizard
test_execute          
think_time_auto_correct      
time_limit               
Transaction Backout            
transaction_backout            
transcation_backout            
transition point     
Transparent Data Encryption             

U
undo_retention     
undo_sql               
use_db_recovery_file_dest 
user_dump_dest   
user_flashback_txn_state    
user_tab_col_statistics
utlpwdmg.sql

V
v$asm_attribute     
v$asm_client         
v$asm_disk           
v$asm_disk_iostat               
v$asm_file             
v$cpool_cc_stats 
v$cpool_stats       
v$database            
v$dnfs_channels 
v$dnfs_files          
v$dnfs_servers     
v$dnfs_stats         
v$encrypted_tablespaces   
v$encryption_wallet             
v$flashback_txn_graph       
v$flashback_txn_mods        
v$logmnr_contents              
v$pwfile_users      
v$result_cache_objects       
v$session             
verify_function      
verify_function_11g             
virtual column       
Virtual Column-Based Partitioning     
virtual columns     
Virtual Private Database       
Voting Disk           
vpc_databases     

W
Wait Activity          
Wait Class             
wallet     
wallet_location     
workload_impact_threshold               
Workspace Manager           

X
x$kfdat   
x$kfdpartner         
x$kffxpi  
XQuery  

Reviews:

Errata:

Reader Comments:

I have since learned that unfortunately in Oracle11g (so far, at least) OEM Grid Control is quite different from OEM Database Control.  For some reason, in Grid Control, OEM is still at version 10.2.x.x.x, so it does not include the new OEM 11g features.  In Database Control (only) OEM is available in version 11, and includes the new features.  I understand that Oracle is working on getting OEM Grid Control in sync with what Database Control offers, but they aren’t there yet.  I can’t get dbconsole (for the Database Control) version of OEM to work on our new 11G servers, but I have a Service Request open with Oracle to address that.

Mark Geerlings

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks