book

Oracle Database 11g New Features

by Robert Freeman

November 2007

Intermediate to advanced

362 pages

9h 13m

English

McGraw Hill Computing

Read now

Unlock full access

Installing Oracle Database 11gThe Database Configuration AssistantUpgrading to Oracle Database 11gSaving Time When UpgradingSupported Upgrade PathsSupported Upgrade MethodsUpgrade with DBUAManual UpgradesUsing Export/Import for Upgrades and RollbackUpgrade Using Data CopyingOracle Parameter ChangesNew ParametersDeprecated ParametersObsolete ParametersUndo_Management Parameter MadnessOracle Dictionary View ChangesEnd of Line

ASM-Related Changes and New FeaturesNew ASM-Related DocumentationASM Disk Group AttributesASM Fast Disk ResyncASM Compatibility SettingsASM Preferred Mirror ReadASM Rolling UpgradesASM Support for Variable Allocation Unit SizesNew SYSASM RoleNew asmcmd CommandsAutomatic Memory ManagementOverview of Automatic Memory ManagementNew Memory Advisor Functionality and ViewsHow Is Oracle Managing My Memory?Automatic Memory Management and OEMConverting to Automatic Memory ManagementADDM New FeaturesADDM New ViewsADDM Now RAC-AwareManaging ADDM Through DBMS_ADDMFinding ClassificationsDirectivesAWR New FeaturesDefault Retention of AWR Snapshots ChangedAWR Baseline New FeaturesAdaptive Metric ThresholdsScheduler AutoTask Automated Maintenance TasksAutoTask ArchitectureAutoTask Dictionary ViewsManaging AutoTask Tasks via OEMManaging AutoTask Tasks ManuallyAutoTask Maintenance WindowsParameter File Management Changes and New FeaturesRead/Write Error Handling of SPFILESEasier Conversion to the Use of SPFILESUsers Are Prevented from Setting Invalid Values in SPFILESResource Manager Changes and New FeaturesIO CalibrationDefault Maintenance PlanBuilt-In Resource PlansResource Manager Statistics in AWRResource Manager Plan Directive New FeaturesFiner-Grained DependenciesDDL WAIT Option Now DefaultNew Add Column FunctionalityEnd of Line
Fault Diagnosability InfrastructureThe Automatic Diagnostic Repository (ADR)The Alert LogTrace, Dump, and Core FilesThe Support WorkbenchRMAN New FeaturesInterfile Backup ParallelismFaster Backup CompressionActive Database DuplicationImproved Handling of Long-Term BackupsBackup Failover for Archived Redo LogsArchived Redo Log Deletion Policy EnhancementsRecovery Catalog EnhancementsUndo Backup OptimizationBlock Media Recovery Performance ImprovedOther RMAN New FeaturesOracle Flashback-Related New FeaturesOracle Flashback Transaction BackoutOracle Flashback Data ArchivesOracle Standby Database New FeaturesLost-Write DetectionCompression of Archived Redo LogsReal-Time Query Capabilities from a Physical Standby DatabaseSnapshot DatabasesOracle Data Pump New FeaturesExp Utility DeprecatedCompression of Dump File SetsData Pump Encryption EnhancementsData Pump Data Remapping (Obfuscation)Data Pump Rename TableData Pump and Partitioned TablesOverwrite Dump FilesData Pump Data_Options ParameterThe Transportable ParameterEnd of Line
The Data Recovery AdvisorThe SQL Repair AdvisorThe SQL Access AdvisorThe Streams Performance AdvisorOracle Database 10g Database Advisor ViewsEnd of Line
Database ReplayUsing Oracle Database ReplayDatabase Replay—OverviewDatabase Replay Workload Support and LimitationsDatabase Replay—Capture WorkloadDatabase Replay—PreProcess the Captured WorkloadDatabase Replay—Replay WorkloadThe SQL Performance AnalyzerOverview of SQL Performance AnalyzerSQL Performance Analyzer via OEMSQL Performance Analyzer via PL/SQLEnd of Line
AuditingPassword-Related FeaturesPassword Settings and the Default ProfilePassword ComplexityPassword Case SensitivityHacking Prevention with Failed Logon DelaysPassword Hashing ChangesDefault Password UseFine-Grained Access Control on Network ServicesCreate the ACL and Define the Associated PrivilegesAssign the ACL to Network HostsACL-Related Data Dictionary ViewsTablespace EncryptionOverview of Oracle Tablespace EncryptionPreparing the Database for Tablespace EncryptionCreating Encrypted TablespacesEncryption and Database PerformanceTDE and Log Miner, Logical Standby, and StreamsOracle SECUREFILE LOBSEnd of Line
PartitioningInterval PartitioningExtended Composite PartitioningReference PartitioningSystem PartitioningSystem-Managed Domain IndexesVirtual ColumnsAbout Virtual ColumnsCreating Tables with Virtual ColumnsPartitioning Tables with Virtual ColumnsData Pump Single-Partition ImportsMaterialized Views and Query RewriteOnline Redefinition for Tables with Materialized View LogsQuery Rewrite During RefreshPartition Change Tracking Refresh for Union All MviewsNew and Enhanced Materialized View Catalog ViewsQuery Rewrite EnhancementsThe Pivot and Unpivot ClausesThe Pivot ClauseThe Unpivot ClauseTable CompressionEnd of Line
SQL*PlusNew set CommandsFast Application Notification Events in an RAC DatabaseOnline Application Maintenance and UpgradeNew lock table ParameterFewer Exclusive Locks Taken During Online OperationsInvisible IndexesSQLRead-Only TablesSQL Query Result CacheClient Side Result CacheRegular Expression EnhancementsNamed and Mixed Notation from SQLPL/SQLCreate Triggers as Enabled or DisabledCreate Trigger Follows ClauseCompound TriggersInliningSIMPLE_INTEGER DatatypePL/SQL Function Result CacheDynamic SQLDynamic SQL and REF CursorsPLW 06009 WarningPL/SQL Sequence EnhancementPL/SQL Continue StatementEnd of Line
Enhanced Oracle Process MonitoringStatisticsPending and Published StatisticsRecovering Previous StatisticsExtended StatisticsPL/SQL Native CompilationSQL Plan ManagementSQL Plan Management OverviewPlan CaptureUse of SQL Plan BaselinesQuerying SQL Plan BaselinesEvolving SQL Plan BaselinesManaging SQL Plan BaselinesAutomatic SQL TuningOverview of Automatic SQL TuningAutomatic SQL Tuning with OEMManage Automatic SQL Tuning ManuallyManual Creation and Use of SQL Tuning SetsCreate the TaskCreate the SQL Tuning SetLoad the SQL Tuning SetLink the SQL Tuning Set and the TaskSet Any Task ParametersExecute the TaskReview the ResultsIntelligent Cursor Sharing (Bind-Aware Peeking)About Bind-Aware PeekingBind-Aware Peeking ViewsStarting a System with Bind-Aware PeekingTemporary Tablespace FeaturesTemporary Tablespace ShrinkThe DBA_TEMP_FREE_SPACE ViewReal-Time SQL MonitoringReal-Time SQL Monitoring OverviewReal-Time SQL Monitoring ViewsReal-Time SQL Monitoring ReportControl Real-Time SQL MonitoringControl the Use of OEM Management PacksEnd of Line
Real Application ClustersOCI Runtime Connection Load BalancingUsing XA Transactions with RACRAC Configuration AssistantsNetwork Configuration Assistant (NetCA)Database Rolling UpgradeParallel Execution Honors Service PlacementDirect NFSXMLDB New FeaturesBinary XML StoragePartitioning Support for XMPXQuery EnhancementsDatabase Native Web ServicesXML DB Repository EnhancementsXML Developers KitJavaOracle JVM-Related FeaturesEnhancements to Existing UtilitiesThe ojvmtc UtilityJDBC 4.0 SupportJDK Support in Oracle Database 11gNew Oracle Supplied Packages and Procedures
Arup's Top Feature #1: Database ReplayArup's Top Feature #2: SQL Performance AnalyzerArup's Top Feature #3: PartitioningArup's Top Feature #4: Transparent Tablespace EncryptionArup's Top Feature #5: Flashback Data ArchiveArup's Top Feature #6: SQL Plan ManagementArup's Top Feature #7: Private StatisticsArup's Top Feature #8: More ConcurrencyArup's Top Feature #9: Result CacheArup's Top Feature #10: Better-Quality PL/SQL Code

Content preview from Oracle Database 11g New Features

This book is dedicated to my wife and companion Lisa, who is always there for me, patient with me, and loves me in spite of my many faults. This book is dedicated to my kids, Felicia, Sarah, Jacob, Jared, and Elizabeth, who are the light of my life even if they don't know this all the time.