Skip to Main Content

Ask The Oracle Masters

Recently Answered

Recently Answered Report

Connor McDonaldORA-06512 - PL/SQL: numeric or value error%s
Apologies... this is related to a previous question answered earlier today, but I did not know how to ask a 'follow up' question...I've written the code below to generate an email report on users in an instance which have not been logged into in the last 15 da...
Connor McDonaldCreate MVW takes 15 mins. Refresh of same MVW takes 12 hours (or mostly failes)
We have a materialized view, which has undergone some tuning. When creating the new MVW, it took 15 mins.The MVW is then refreshed using a shell in which many MVWs are refreshed in order. As part of the refresh, to make it faster, the indexes on the MVW are dr...
Connor McDonaldDifference Between IMPDP Method
Hello Teama while ago, I had a problem with a DB import. I managed to get it, but there's a question still remain in my head1. what is the difference between<code>expdp system/system schemas=ieulive directory=dir1 dumpfile=dump1.dmp logfile=exp.logimpdp system...
Connor McDonaldDBMS_JOB.SUBMIT doesn't do anything in Oracle 12c (12.2.0.1.0)
Hi guys,I have a problem when I try to start a stored procedure with DBMS_JOB.SUBMIT.I have the package "dafneMultithread":<code>CREATE OR REPLACE PACKAGE DAFNE.dafneMultithread AS PROCEDURE start_job(p_procedure_name IN VARCHAR2);END dafneMultithread;/</co...
Connor McDonaldBidn variable peeking doesn't work?
Hi Tom, I have a below case in which bind variable peeking seems to not work well.1. I have a table RETRO where is around 1,5 millions records 2. This table has a three below indexes:- IK_RETRO_02 ON RETRO(PAR_ID, RETRO_PAYMENT_DATE) - IK_RETRO_05 ON RETRO(N...

Resources