Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Fetch and pga

    I run in sqlplus a query with huge result set. It has to return million records Set arraysize to 5000 Monitoring v$session, v$process, v$sqlstats while query is running I can see after some minutes executions changes from 0 to 1. Then fetch count begin to be incremented at each s...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    I want to compate Table A with Table B store difference in C and update A To B

    I need to compare 2 table A and B I want to store the difference in C and after I want to update B to A. The B table could be updated every second so , I wondering what is the right approach to ensure when I update B to A I m using same value as when I compare B and A Hope this i...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Optimal ways to Capture Data Changes in Oracle 19c

    Hi Tom, Greetings, we have a requirement to capture data changes for multiple tables and push to Kafka topic in the following format similar to GoldenGate provides. "op_type":"Insert or Update","op_ts": "timestamp","current_ts": "timestamp", "before" :"Row Data before change", "a...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    ADD_MONTHS Function returning last day of the month

    The question I have is regarding the ADD_MONTHS function. The live sql link for the test case is as below:- https://livesql.oracle.com/apex/livesql/s/JT1FDGOHXMRWN3LG94GEYLMPJ If we have a look at this link it has 3 components:- 1. A function that takes an old date and adds a mon...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    "alter session sync with primary" with Maximum Performance Protection Mode

    "alter session sync with primary" raises ORA-03173 for us. SQL> select database_role, open_mode, db_unique_name from v$database; DATABASE_ROLE OPEN_MODE DB_UNIQUE_NAME ---------------- -------------------- ------------------------------ PHYSICAL STANDBY READ ONLY WITH AP
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report