Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Local context VS global context

    Hi Tom, Please clarify the following points: 1.what is the difference between local context and global context? 2.For a session, can both exists and if yes, what differentiates them? 3.I have heard that this concept is basically used for web based application because of the conce...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Perf : Insert into Select Vs For All

    I need to perform db operations where I need to inserts .5 million reocrds from another complex query involving joins,exists etc: As of now I am using INSERT INTO SELECT inside a pl/sq package. but some time I am observing for same data set this queries takes more time  Will For ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Options for Change Data Capture

    Chris & Connor, We are working on a new project and were wondering as to what options are currently available / provided by Oracle for Change Data Capture, besides the DIY MViews ( MVIEW logs mostly ), triggers etc, does Oracle 11.2.0.4 and above provide an out of the box solutio...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Data Guard physical standby database redo apply lag time about one month

    SYS@standby28> select database_role,open_mode from v$database; DATABASE_ROLE OPEN_MODE -------------------------------- ---------------------------------------- PHYSICAL STANDBY READ ONLY WITH APPLY SYS@standby28> desc v$dataguard_sta
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    UNDO RETENTION in Standby

    Hi all We offload reading/long queries to physical dataguard standby We also know that a fact that the physical standby is applying redo stream generated from primary It also does seems that - uncommitted undo generated from primary DMLs is not required in the standby - unexpired...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

Free training, how-tos and Q&A with Oracle experts, every month! Learn more