Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    how does SKIPEMPTYTRANS work?

    I am wondering how does SKIPEMPTYTRANS work? when does ogg judge a transaction empty or not? if it does the judgement in the middle transction? how does ogg know it's a empty transaction? provided that it did not update mapped tables before the judgement, but it may update the ma...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Factors Affecting Rollback Speed

    Hey Tom, 1. I would like to know the factors influencing the rollback speed of a transaction. And why does it generally take more than the time it took for the actual transaction. Could you show some light on this? 2. I read one of your answers where you have said "A rollback is ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Plan problem using composite domain index on CLOB and XMLTYPE

    HI, I need to perform fulltext searches in an xmltype XML field. The table in which this field is located has other fields that can be used to narrow the search in the fulltext index (for example, a date field). However, I noticed that by creating a composite domain index on the ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Loading External Data, Flat file, into an Oracle Table.

    Hi Tom, I need to come up with an automated method to insert data (xml_type) from an external flat file into to a table in Oracle Database using SQL Developer. Read some articles which shows how to load the files by using a control file, but I couldn't find any article about how ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    shared_pool_size and the streams_pool_size parameters

    Can the shared_pool_size and the streams_pool_size parameters be set to the same value? Both parameters are currently set to zero. I would like to set them both to 2g. I will need to use about 1.5g of the streams_pool memory for Golden Gate. Will this work? Thanks much for your h...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report