![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
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 · 138 阅读 · 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 · 276 阅读 · 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 · 210 阅读 · 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 · 246 阅读 · 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 · 114 阅读 · 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 · 259 阅读 · 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 · 550 阅读 · 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 · 169 阅读 · 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 · 147 阅读 · 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 · 220 阅读 · 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 · 147 阅读 · 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 · 104 阅读 · 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 · 347 阅读 · 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 · 148 阅读 · 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 · 104 阅读 · 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 · 117 阅读 · 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 · 119 阅读 · 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 · 151 阅读 · 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 · 132 阅读 · 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 · 139 阅读 · 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 · 237 阅读 · 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 · 192 阅读 · 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 · 202 阅读 · 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 · 397 阅读 · 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 · 296 阅读 · 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 · 279 阅读 · 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 · 181 阅读 · 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 · 78 阅读 · 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 · 146 阅读 · 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 · 249 阅读 · 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 · 197 阅读 · 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 · 178 阅读 · 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 · 187 阅读 · 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 · 239 阅读 · 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 · 282 阅读 · 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 · 454 阅读 · 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 · 185 阅读 · 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 · 117 阅读 · 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 · 109 阅读 · 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 · 473 阅读 · 0 评论