Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Is STANDARD_HASH or DBMS_CRYPTO disabled for Always Free Autonomous Oracle Cloud

    With Always Free, there is no support. How do I get DBMS_CRYPTO grant? I tried using STANDARD_HASH, but it says STANDARD_HASH must be declared. So is there a way to get this access preferably to DBMS_CRYPTO? If not is there an alternative?
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Column Object Storage in Relational Tables

    Refer to object-relational-developers-guide / Column Object Storage in Relational Tables If “The null indicators for an object and its embedded object attributes occupy one bit each. Thus, an object with n embedded object attributes (including objects at all levels of nesting) ha...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    IN Vs NOT IN filters

    Hi Team, From performance perspective, which is a better filter IN or NOT IN?
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Why is the cwallet.sso that is installed by osbws_install.jar, prompting for password?

    I've installed Oracle Secure Backup using osbws_install.jar on a couple of hosts and it works fine on all of them (i.e. I can list, add and delete credentials in the wallet without being prompted for password). But on one particular host, after installing, when I try to list the ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Data Base Size

    I need to report the database sizing to our management. Following are the questions: 1) Total space allocated and used for each Database instance (We have 14 each for 3 applications) 2) How is the growth pattern over the last few years. Year to Year change. My answer is 1) Run th...
    #MISC#
    #ACTIONS#

Upcoming Live Sessions

Upcoming Ask TOM Live report