Tuesday, October 20, 2020
dbametrix
More
    Home Oracle Internals Oracle 9i hidden feature

    Oracle 9i hidden feature

    Hi,

    Oracle 9i hidden feature: Virtual Index.

    - Advertisement -
    dbametrix

    Q) What is virtual index:

    a) It is hidden index because not showing up or display in data dictionary views.

    Q) Does it occupy space from disk?

    a) No it not occupy disk space.

    - Advertisement -
    dbametrix

    Q) What is usage of virtual index?

    a) For checking up to tune sql in explain plan.

    Q) Why it is hidden?

    a) Because it is deployment feature of OEM not from SQL*Plus

    For more detail kindly check following link:

    http://dbametrix.com/download_info.php

    Thanks and regards,
    Gitesh Trivedi
    http://www.dbametrix.com

    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    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

    What is a Database Administrator?

    The blog post explains what is the work of database administrator called DBA in database domain and what is the importance.

    Top Reasons to Implement Remote Database Monitoring

    The blog post explains top three reasons and ideas to get remote monitoring services from outer support company.

    Recent Comments