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

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

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

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

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