Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Oracle SQl Commit taking too long

    <b></b>Team,let us consider our normal scott schema for this concern.Let us consider emp table.REM INSERTING into empSET DEFINE OFF;Insert into emp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7369,'SMITH','CLERK',7902,to_date('17-12-80 00:00:00','DD-
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Installation Error 18c XE

    I tried to install Oracle XE 18c,but it keeps rolling back. On trace log, it said no valid ip address return for the host. I'm using windows 10 pro. What should i do to fix this problem?
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Unified Audit Log Change Tablespace Location

    Hi Tom,Is that we can changed the unified audit log tablespace from SYSAUX to standalone tablespace(example: TBS_AUDIT) online without restart the database? If yes, is that will be any impact by doing so?
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    How to move the Jobs from one User to another User Present in the Different DB server

    Team,This is is continuation with the below link :https://asktom.oracle.com/pls/apex/f?p=100:12::::RP:P12_QUESTION_ID,P12_PREV_PAGE:9543884800346428497,11I could not continue on that link , so sorry to raise a new request.The solution provided there works wel
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Cancelling long running queries

    Dear Tom,I'm wondering about how a 'cancel' in Oracle works.For example, I have a long running query and I define a timeout on application level.Once the timeout is reached, the application sends a 'cancel'.What i observed is, that the cancel does not seem to
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

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