Tuesday, August 11, 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

    0
    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    ASM Disk creation issue

    The article explains how to troubleshoot Oracle ASM disk creation. Solution of Oracle ASM disk creation with ASMLIB

    Oracle Tuning Basics Part-2

    This is the 2nd part of Oracle database tuning basics including depth of every aspects.

    Oracle Tuning Basics Part-1

    The article explains Oracle database performance tuning basics details.

    When you finding new job

    The article guides you 10 things to remember when you are searching a new job to improve yourself including skills and better growth for every DBA.

    Recent Comments