Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #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#
  • #SELECTION#
    Connor McDonald

    How to do update (replace values) in a table contains 50+ million records?

    Hi, I have a table contains 50+ million records, and I am writing a procedure to replace the bad data to the correct values(about 1500 records). K_V is the array of bad data and target correct value,like K_V('bad data1') := 'correct value1' when I loop the K
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    ORA-12569: TNS:Packet Checksum Failure - How is this error even possible?

    Hello masters. Here I am again with another mystery from our favorite DBMS (no, that was not sarcasm, I do love Oracle in fact). So, in my company we are facing the referred error, ORA-12569: TNS:Packet Checksum Failure While Trying To Connect Through Client. The message itself i...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    XLIFF export timeout (Apex)

    Hi! I have a problem with downloading XLIFF file for whole application (Shared Components\Translate\XLIFF Export). It looks the request timeouts after 5 minutes ("Failed to load resource: the server responded with a status of 500 (Internal Server Error)"). The application is quit...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    what is lobsegment,lobindex

    I query table 'user_segments' sql>select segment_name, segment_type, tablespace_name, bytes, max_extents from user_segments where segment_type like 'LOB%' result is SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME SYS_IL0000012099C00002$$ LOBINDEX CPOCKET_DATA SYS_LOB
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report