Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Redo log threads in Real Application Clusters

    Tom, I have been trying to understand the concept of redo log threads in a RAC environment. I understand how the redo logs work in a single instance database. But I cannot find proper documentation anywhere that clearly explains what a redo log thread is and how the whole thing w...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    cycle detected in recursive query where it seems to be no cycle

    I have recursive query on Oracle 11g table with undirected graph data. Each row represents one edge. The recursive query traverses all edges starting from given input edge. The idea of query is: - input edge is at the 0th level - for n>0, edge is on n-th level if it incides with ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    How to move a table in oracle database 19c excluding Lob column

    We start getting alerts about a tablespace users that it was getting full, tablespace users contains 3 datafiles of 32GB each, but we found out that in one of the tables in tablespace users it has a Lob(67 GB), so we decided to moved that Lob to have it owns tablespace. Now we wa...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    VMWARE

    I have a problem in defining shared folders in VMVirtualBox. As there ist no category for that it seams that this is the wrong place. So where can i send the problem that seems to be a bug?
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Using enum domains in PL/SQL

    hi folks, I am very happy about the new enum domains in PL/SQL. They are very useful and can make the code much more maintainable. But I struggled over a problem. When I create an enum domain like create domain MY_TEST_ENUM as enum ( text1 = 'text1', text2 = 'text2', text3 = 'te
    #MISC#
    #ACTIONS#

Upcoming Live Sessions

Upcoming Ask TOM Live report