Oracle11g New Features
关注
分享
扫一扫
czmmiao
这个作者很懒，什么都没留下…
展开
-
SQL Access Advisor的使用
环境:OS:Red Hat Linux As 5DB:10.2.0.4SQL Access Advisor是伴随着10G出现的一个优化工具,提供对表分区,物化视图,索引,物化视图日志优化建议.下边通过对单个SQL的执行,查看Oracle给出的建议.1.建表并生成测试数据SQL> connect scott/scottConnected.SQL> drop tabl...原创 2014-11-03 00:43:56 · 158 阅读 · 0 评论 -
Oracle 11g Securefile(原创)
Overview Oracle SecureFilesContemporary organizations deal with data that includes traditional data stored in relational tables, semi-structured data such as XML and word processing documents, and u...2013-10-27 11:19:23 · 316 阅读 · 0 评论 -
Oracle 11g PL/SQL Function Result Cache(原创)
The PL/SQL Function Result CacheThe PL/SQL function result cache uses the same infrastructure as the SQL query result cache, and caches the results of the PL/SQL functions in the result cache compon...2013-10-26 16:10:02 · 253 阅读 · 0 评论 -
Oracle 11g Result Cache(原创)
Result CacheThe shared pool component of the SGA, as you are aware, stores the parsed and compiled versions of SQL queries, which lets the database quickly execute frequently run SQL statements and ...2013-10-26 09:36:05 · 277 阅读 · 0 评论 -
Oracle 11g Extension Statistics and Expression Statistics(原创)
Overview Extended StatisticsIn this release, Oracle has introduced major new capabilities in statistics gathering, which are referred to as extended statistics, to make the optimizer statistics refl...2013-10-24 17:45:41 · 146 阅读 · 0 评论 -
Oracle 11g Optimizer Statistics Enhancement(原创)
OverviewThere are two major innovations in optimizer statistic collection in the Oracle Database 11g release: pending statistics and extended statistics. In addition, the Statistics Preferences fe...2013-10-24 17:13:01 · 305 阅读 · 0 评论 -
ORACLE 11g 自动内存管理(原创)
Overview在oracle 11g中，使用一个参数memory_target就能够实现SGA和PGA组件依据工作负荷进行自动内存分配。oracle推荐使用自动内存管理简化内存分配。oracle 11g依然支持手工内存分配：1：oracle 11g使用memory_target来支持内存自动分配。2：使用sga_target和pga_target参数来设置SGA和PGA，数据库会在这两个...2013-10-23 08:13:58 · 590 阅读 · 0 评论 -
Oracle 11g ADDM Enhancements(原创)
Overview ADDM Enhancements The Automatic Database Diagnostic Monitor, which Oracle introduced in Oracle Database 10g, analyzes the AWR data, diagnoses the root causes for performance problems, and...2013-10-21 13:24:23 · 191 阅读 · 0 评论 -
Oracle 11g SQL Access Advisor Enhancements(原创)
Overview SQL Access AdvisorOracle introduced the SQL Access Advisor in the Oracle database 10g Release to help you create efficient access structures to optimize SQL queries. The advisor accepted ei...2013-10-15 15:19:08 · 172 阅读 · 0 评论 -
Oracle 11g SQL Plan Management(原创)
SQL Plan ManagementOnce the cost optimizer provides an efficient execution plan for a SQL statement, you can’t assume that the optimizer will always use that execution plan. There may be any numbe...2013-10-13 22:59:49 · 253 阅读 · 0 评论 -
Oracle 11g R2令人赞赏的五大新特性
2009年9月Oracle公司发布了期待已久的Oracle 11g R2，本系列文章将给读者一一揭开新版本中的新特性，并会介绍企业如何利用这些新特性将现有的Oracle 9i，10g，11g R1升级到Oracle 11g R2.经历了难以忍受的长时间等待，Oracle公司突然在9月1发布了Oracle 11g R2，我不得不承认Oracle的保密工作做得多么好，我相信Oracle公司选择...原创 2014-03-25 21:07:11 · 168 阅读 · 0 评论 -
Oracle 11g Fine-grained Dependency Management(原创)
Minimal Invalidation of Dependent ObjectsIn the previous release, Oracle automatically invalidated all dependent views and PL/SQL packages during an online redefinition, even if those objects weren’t...2013-10-27 14:25:42 · 134 阅读 · 0 评论 -
Oracle 11g Direct NFS(原创)
Direct NFS ClientNAS storage devices use the Network File System (NFS) to access data. In Oracle Database 10g, NAS devices were accessed using operating system–specific kernel NFS drivers. This requ...2013-10-28 22:10:44 · 377 阅读 · 0 评论 -
Oracle 11g ASM Command Enhancement(原创)
Changes in the check CommandThe check command lets you verify if the ASM disk group metadata is consistent. If there are any inconsistencies, the command shows you a summary of the errors and record...2013-11-02 16:25:31 · 166 阅读 · 0 评论 -
Oracle 11g ASM Enhancement(原创)
ASM CompatibilityASM in Oracle Database 11g can support databases from both the 11g release as well as the 10g release. The ASM version must be the higher version or at least the same as the RDBMS v...2013-11-02 14:43:55 · 124 阅读 · 0 评论 -
Oracle 11g Locking Enhancement(原创)
Locking EnhancementsOracle Database 11g provides more efficient capabilities relating to the implementation of object locking. These new capabilities include allowing a DDL lock to wait for a DML lo...2013-10-31 20:41:36 · 147 阅读 · 0 评论 -
Oracle 11g Create Parameter file from memory and Hot Patch(原创)
Creating a Parameter File from MemoryYou can now create a text initialization parameter file (PFILE) or a server parameter file (SPFILE) from the system-wide parameters currently in use by the insta...2013-10-31 20:40:19 · 143 阅读 · 0 评论 -
Oracle 11g Invisible Index(原创)
Invisible IndexesIn Oracle Database 11g, you can create invisible indexes. An invisible index is similar to regular indexes in most respects. However, you can hide the index from the optimizer, thus ...2013-10-30 20:44:56 · 183 阅读 · 0 评论 -
Oracle 11g Shrink Temporary Tablespace and Temporary Table Enhancement(原创)
Shrinking Temporary TablespacesWhen a large job that uses a temporary tablespace finishes executing, the database doesn’t immediately release the space used by the job in the temporary tablespace, e...2013-10-29 13:22:09 · 166 阅读 · 0 评论 -
Oracle 11g PL/SQL and Java Automatic Native Compilation(原创)
PL/SQL and Java Automatic Native CompilationUp until the Oracle Database 11g release, the database always transformed PL/SQL code to C code first before executing it. This meant you needed a third-p...2013-10-29 13:21:04 · 166 阅读 · 0 评论 -
oracle XML的使用
XML DB简介Oracle XML DB 是一组专门为 XML 开发的内置高性能存储和检索技术，首次随 Oracle9i 数据库第 2 版推出。OracleXML DB 将 World Wide Web Consortium (W3C) XML 数据模型完全吸收到 Oracle9i 数据库中，并为导航和查询 XML 提供了新的标准访问方法。可以同时获得关系数据库技术和 XML 技术的所有优势...原创 2013-10-29 13:20:30 · 288 阅读 · 0 评论 -
Binary XML Data Storage in 11g
Oracle 11g New Features TipsIn previous versions of Oracle, two Extensible Markup Language (XML) storage options were available: unstructured, or CLOB, and storage and structured, or schema-based. ...原创 2013-10-29 13:06:38 · 211 阅读 · 0 评论 -
Oracle 11g Compress Enhancement(原创)
OLTP Table CompressionIn earlier releases, you could compress data only during bulk load operations such as during a direct load or a create table as select operation. You couldn’t, however, compres...2013-10-28 22:12:49 · 226 阅读 · 0 评论 -
Oracle 11g Automatic SQL Tuning Advisor(原创)
Introduce of SQL Tuning AdvisorIn Oracle Database 10g, Oracle introduced the Automatic Tuning Optimizer, which is the name given to the optimizer when it is running in the tuning mode instead of i...2013-10-12 13:30:40 · 443 阅读 · 0 评论 -
Tablespace Encryption in Oracle 11g R1(原创)
OverviewIn Oracle Database 10g, Oracle introduced the new Transparent Data Encryption (TDE) feature, which let you easily encrypt a column’s data in a table. The encryption is called transparent b...2013-10-10 09:46:29 · 331 阅读 · 0 评论 -
Oracle 11g SQL Performance Analyzer(原创)
Overview The SQL Performance AnalyzerThe SQL Performance Analyzer focuses on comparing the performance of a specific SQL workload before and after a major system change. The analyzer does this by bu...2013-07-28 16:34:46 · 321 阅读 · 0 评论 -
Database Replay in Oracle Database 11g(原创)
OverviewThe Database Replay functionality of Oracle 11g allows you to capture workloads on a production system and replay them exactly as they happened on a test system. This provides an accurate ...2013-07-28 10:40:22 · 214 阅读 · 0 评论 -
Adaptive Cursor Sharing in Oracle Database 11g(原创)
DBAs are always encouraging developers to use bind variables, but when bind variables are used against columns containing skewed data they sometimes lead to less than optimum execution plans. This i...2013-07-14 19:07:57 · 104 阅读 · 0 评论 -
ORA-904 "MAXSIZE" When Exporting From 10g Database Using 11g Export Client.
ORA-904 "MAXSIZE" When Exporting From 10g Database Using 11g Export Client.(exp) (Doc ID 957380.1) APPLIES TO:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.5 [Release 10.1 to 10....原创 2013-12-01 10:33:48 · 171 阅读 · 0 评论 -
Oracle 11g Concurrent Statistics Gathering
Concurrent Statistics GatheringGathering optimizer statistics is one of life's necessary evils even if it can take an extremely long time to complete. In this blog post, we discuss one remedy to i...原创 2013-12-01 10:19:08 · 277 阅读 · 0 评论 -
Oracle 11g Flashback Database feature(原创)
Flashback Data ArchiveWhile you can rely on the undo data in the undo tablespace to query older versions of a row or even perform a logical recovery, there’s a limit on how far back you can go. Beca...2013-11-17 16:38:31 · 227 阅读 · 0 评论 -
Oracle 11g Reference Partitioning(原创)
Reference PartitioningReference partitioning is a new partitioning scheme in Oracle Database 11g that lets you partition a table on the basis of the partitioning scheme of the table that its referen...2013-11-17 12:51:32 · 208 阅读 · 0 评论 -
Oracle 11g Virtual Column(原创)
Virtual ColumnOracle Database 11g lets you include a virtual column in a table. Unlike normal columns, a virtual column’s values aren’t inserted directly into a table. The virtual column you speci...2013-11-16 20:54:25 · 221 阅读 · 0 评论 -
Oracle 11g System Partition(原创)
System PartitioningSystem partitioning is quite different from all other types of data partitioning. System partitioning is meant to enable application controlled table partitioning. Just for starte...2013-11-15 15:48:44 · 276 阅读 · 0 评论 -
Oracle 11g Interval Partition(原创)
Interval PartitioningInterval partitioning is an extension of the familiar range partitioning scheme. Range partitioning is ideal for partitioning historical data. You use range partitioning to orga...2013-11-15 15:05:52 · 324 阅读 · 0 评论 -
Oracle 11g Flashback Transaction Backout(原创)
Flashback Transaction BackoutOracle Database 11g introduces the flashback transaction backout feature, which lets you perform logical recovery by undoing changes made by a transaction as well as its...2014-07-01 09:59:31 · 488 阅读 · 0 评论 -
Oracle 11g Automatic Diagnostic Repository(原创)
Automatic Diagnostic RepositoryThe automatic diagnostic repository tracks all problems and incidents that occur in the database. The ADR is a file-based repository that you create for storing tradit...2013-09-08 19:35:46 · 222 阅读 · 0 评论 -
Oracle 11g Security Enhancement(原创)
Secure Password SupportOracle Database 11g provides several new ways to make database passwords more secure. Among these are the following new password-related features:Case-sensitive passwords ...2013-10-09 17:42:31 · 164 阅读 · 0 评论 -
Fine-Grained Access to Network Services in Oracle Database 11g R1(原创)
OverviewOracle allows access to external network services using several PL/SQL APIs (UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP and UTL_INADDR), all of which are implemented using the TCP protocol. In pr...2013-10-09 16:27:11 · 133 阅读 · 0 评论 -
Oracle 11g Lightweight Jobs(原创)
Overview Lightweight JobIn Oracle Database 10g, there was only a single type of Scheduler job. In Oracle Database 11g, you can also create what’s called a lightweight job (also referred to as a pe...2013-10-08 21:17:54 · 499 阅读 · 0 评论