Wednesday, October 28, 2020
dbametrix
More
    Home Oracle DBA Tips How to install-uninstall CTXSYS schema in Oracle 8i,Oracle 9i and Oracle 10g

    How to install-uninstall CTXSYS schema in Oracle 8i,Oracle 9i and Oracle 10g

    How to resolve a full table scan with “like” operator in where condition using Oracle ConText index:

    Hi friends,

    - Advertisement -
    dbametrix

    The article explains how to tune a full table scan while using like operator in where clause using Oracle ConText (interMEDIA) , CTXSYS schema install, and uninstall on Oracle 8i, Oracle 9i, Oracle 10g.

    Oracle Text can perform linguistic analysis on documents as well as search text using various search patterns like keyword searching, Boolean searching, matching pattern searching, HTML, and XML searching. It supports CHAR, VARCHAR, VARCHAR2, LONG, LONG RAW, BLOB, CLOB, BFILE, Date, number datatype columns.

    Please read and download the article of CTXSYS called “how to tune full table scan while using like operator” from the following link.
    http://www.dbametrix.com/oracle-dba-tips.html

    All the best,
    Thanks and regards,
    Leena Upadhyay.

    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    Five Reasons Why Database Outsourcing

    The blog post explains why database outsourcing and remote dba support becomes most popular during present time of Covid-19 Pandemic.

    Hardware of Database Server

    The blog post explains how to choose best hardware of your database server for getting high performance and security.

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Differences Raw Device, ASM Device and CFS

    The article explains basic differences of ASM device, raw device and Oracle cluster file system cfs with fundamentals

    Recent Comments