Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Error using DBMS_MVIEW.EXPLAIN_REWRITE

    Hello All,The problem I raised uses a scenario from one of the quizzes played recently on Devgym.I try to use DBMS_MVIEW.EXPLAIN_REWRITE for a materialized view in LiveSQLand for some reason, I encounter an error for both the table and the array version.- For
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Performance issues in production

    Hi Tom,We are supporting a Siebel application having Oracle 11g as backed. Last month we upgraded database to 19C and after that we are facing performance issues on daily basis. When we checked DB reports like AWR and ASH, I have below observations:a) In AWR r
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Job Scheduling

    Hi Tom,can u tell me that how can i scheduled my procedures execution. for example there is a procedure namely 'abc' i want to execute it at 4'o clock every day. it would by highly appreciated if u provide my any code, or reffer documents etc. in this regard.p
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    How to properly assign ENABLE_PARALLEL_DML to a profile?

    Hi, In a 19.0, I've found a daily update that lasts for more than 30 mins in a 3rd party software.I would like to execute it in parallel.PDML is disabled, and when I try to create a profile for that update, I cannot get the desired plan.I made a small case to
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    19c Oracle Text Index(CTXSYS.CONTEXT ) - String search anomaly

    We have a table with a blob column that stores the blob of various files like PDF, TIF, WORD, etc and the blob field has Oracle text index INDEXTYPE IS CTXSYS.CONTEXT for us to be able to search for text within the blob’s. We are seeing that the search query u
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

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