`
qingyujingyu427
  • 浏览: 26911 次
社区版块
存档分类
最新评论

oracle text performance

阅读更多

oracle text的索引跟其它的基本索引不同,当执行dml操作时,数据库不会自动维护这些索引(不过会将这些dml操作记录在表CTX_USER_PENDING里),需要调用存储过程ctx_dll.sync_index来维护索引。

当执行ctx_dll.sync_index时,会先去CTX_USER_PENDING表里查看未索引的行,然后将其索引。ctx_dll.sync_index能够利用多cpu的优势,并行执行。

Index Fragmentation

The CONTEXT index is an inverted index where each word contains the list of documents that contain that word. For example, after a single initial indexing operation, the word DOG might have an entry as follows:

   DOG DOC1 DOC3 DOC5

When new documents are added to the base table, the index is synchronized by adding new rows. Thus if you add a new document (DOC 7) with the word dog to the base table and synchronize the index, you now have:

DOG DOC1 DOC3 DOC5
DOG DOC7

Subsequent DML will also create new rows:

DOG DOC1 DOC3 DOC5
DOG DOC7
DOG DOC9
DOG DOC11


我们可以用ctx_dll.optimize_index来优化索引,去除索引碎片。

You optimize your index after you synchronize it. Optimizing an index removes old data and minimizes index fragmentation,

which can improve query response time. Querying and DML may proceed while optimization takes place.

Some users choose to perform frequent time-limited full optimizations along with occasional rebuild optimizations.

 

下面是一些限制,关于并行执行的

You can run CTX_DDL.SYNC and CTX_DDL.OPTIMIZE at the same time.

You can also run CTX_DDL.SYNC and CTX_DDL.OPTIMIZE with parallelism at the same time.

However, you should not run CTX_DDL.SYNC with parallelism at the same time as CTX_DDL.OPTIMIZE,

nor CTX_DDL.SYNC with parallelism at the same time as CTX_DDL.OPTIMIZE with parallelism.

If you should run one of these combinations, no error is generated;

however, one operation will wait until the other is done.

 

看起来,如果数据库服务器的cpu数量如果足够的话,估计性能应该还是不错的。可以每隔几分钟就执行一次

sync_index, optimize_index(full 模式)。晚上执行一次optimize_index(rebuild 模式)。

不太清楚多cpu的工作方式,也不太清楚oracle是怎样利用多cpu的,不知道它在并行执行sync_index时,

会不会用到主cpu?如果不用的话,应该是比较完美吧?

分享到:
评论
1 楼 fishoflove 2009-10-09  
怎么让索引自动同步?因为需要,但我对ORACLE TEXT 又不熟悉,找到的方法不管用

相关推荐

    Digital Press - Oracle High Performance Tuning for 9i and 10g.part2.rar

    This text covers the three parts of tuning an Oracle database: data modeling, SQL code tuning, and physical database configuration, and explains both problem detection and resolution

    Digital Press - Oracle High Performance Tuning for 9i and 10g.part1.rar

    This text covers the three parts of tuning an Oracle database: data modeling, SQL code tuning, and physical database configuration, and explains both problem detection and resolution.

    Oracle PL/SQL programming(5th Edition)

    Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, ...

    Oracle Essbase 11 Development Cookbook

    Modifying Essbase settings to improve calculation performance Using MDX to calculate Aggregate Storage database Up Chapter 7: Using MaxL to Automate Process Introduction Setting up folder structure ...

    Sqlhelper源码包

    sqlhelper是一个完全开源的源码组件,使用sqlhelper可以方便操作sqlserver、oracle、access等数据库。语法简单,提高性能。 SqlHelper 的两种写法: SqlHelper make in Visual studio 2010.support sqlserver,...

    plsqldev12.0.3.1821x64主程序+ v12中文包+keygen

    64位版本的 PLSQL 正式版,只能运行在64位系统中,需要你安装 64 位的 Oracle11g 或 Oracle12c 客户端。 安装中文包时请注意安装路径是否为PLSQL程序的路径。 备注:新版本Ribbon启用了 Ribbon 界面,改动较大,不...

    Tuning IBM AIX 5L for an Oracle Database.pdf

    Example configuration for using large pages for .text and .data...................................................11 Tools to monitor memory usage.........................................................

    plsqldev13.0.0.1882x32主程序+ v12中文包+keygen

    The performance results can be viewed in real-time as text, bar chart, or line chart: Editor Enhancements After making a column selection with Alt-select, you can now type new text for the column. ...

    plsqldev13.0.6.1911x64主程序+ v12中文包+keygen.rar

    Excel export functions now pass dates before Jan 1, 1900 as text to prevent conversion errors When copying and pasting a row in a SQL Window result set, line breaks would disappear View Error Stack ...

    PLSQL.Developer(X64) v11.0.5.1790 主程序+ v11中文包+keygen - 副本

    64位版本的 PLSQL 正式版,只能运行在64位系统中,需要你安装 64 位的 Oracle11g 或 Oracle12c 客户端。 安装中文包时请注意安装路径是否为PLSQL程序的路径。 Enhancements Performance and stability improvements...

    plsqldev13.0.6.1911x32主程序+ v12中文包+keygen.rar

    Excel export functions now pass dates before Jan 1, 1900 as text to prevent conversion errors When copying and pasting a row in a SQL Window result set, line breaks would disappear View Error Stack ...

    sql表关系.txt

    oracle 创建用户: CREATE USER 用户名 IDENTIFIED BY 密码; grant resource ,connect to 用户名; mysql数据库分为两类: 系统数据库: information_schema:存储数据库对象信息(例如:用户表信息,列信息等...

    PLSQL.Developer v11.0.4.1774 主程序+ v11中文包+keygen

    Performance and stability improvements Export to XLSX did remove leading and trailing spaces from data Find and Replace would keep incrementing number on status line when nothing was replaced When ...

    Beginning.R.An.Introduction.to.Statistical.Programming.2nd.Edition.148420

    R has also become popular in commercial use at companies such as Microsoft, Google, and Oracle. Your investment in learning R is sure to pay off in the long term as R continues to grow into the go to...

    java7帮助文档

    The TextLayout class supports Tibetan script. libfontconfig, a font configuration API, is used to select fonts to use for the logical fonts for some implementations of Linux; see Fontconfig. Java ...

    nginx+tomcat高可用、高性能jsp集群

    #INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/local/jdk1.6.0_25/jre/lib/i386/client:/usr/...

    plsqldev14.0.0.1961x32多语言版+sn.rar

    32位版本的 PLSQL 正式版。 安装请查看说明。 APRIL 17, 2020 - VERSION 14.0 RELEASED Built-in Version Control support for Git and ...DBMS_Jobs could not be edited on Oracle19 (‘xxxx’ is not a valid

    plsqldev14.0.0.1961x64多语言版+sn.rar

    64位版本的 PLSQL 正式版,只能运行在64位系统中,需要你安装 64 位的 Oracle 客户端。 安装请查看说明。 APRIL 17, 2020 - VERSION 14.0 RELEASED Built-in Version Control support for Git and Subversion ...

    Geoserver Beginner`s Guide

    Chapter 8: Performance and Caching 205 Exploring GeoWebCache 206 Time for action – configuring GeoWebCache storage 206 Time for action – configuring Disk Quota 209 Setting caching defaults 212 ...

    Citrix_XenApp5

    • good in the sense that users can enable a setting such as Local Text Echo for just their client if they are a fast typist and the latency of the session cannot keep up; and bad when a user can ...

Global site tag (gtag.js) - Google Analytics