v$option - installed but ever used?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: v$option - installed but ever used?

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    v$option - installed but ever used?

    I can see from v$option what options are installed (This is 10.2.0.4) but is there any way to see if the particular installed option is being used? (ie) Trying to see if I can uninstall an option without upsetting the database.

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Not sure if it make sense... try from dba_registry (modified column).

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    nope

  4. #4
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    I kinda thought not. Thanks Dave.

    And Vijay - Yes, I'd looked at dba_registry. Thanks.

  5. #5
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    JMac -

    Did you get any solution?

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    Quote Originally Posted by vnktummala View Post
    JMac -

    Did you get any solution?

    Thanks,
    dba_registry is not a solution

  7. #7
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    I agree Dave.

    I am curious to see if the poster is find any thing else so I just sent a follow-up to him.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  8. #8
    Join Date
    Apr 2006
    Posts
    377
    Check LAST_USAGE_DATE in DBA_FEATURE_USAGE_STATISTICS.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width