Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered Report

Connor McDonaldPerformance Issue : Oracle Dot Net Array Binding
Hi Tom / Team,I am connecting to the oracle server through dot net Oracle Data Provider dll Oracle.DataAccess(V 4.112.3.0) where I make a stored procedure call which essentially makes a database insert to a table and returns the id of newly created record usin...
Connor McDonaldtkprof sort option to find most expensive query
Hi, I saw various sort options in tkprof.sort=(prsela,exeela,fchela)sort=PRSDSK, EXEDSK, FCHDSKsort=EXECPU,FCHCPUsort=(exeela,fchela)I really want to get poorly performing queries on the top. and then i want to print 10 top most poorly written queries from t...
Connor McDonaldDBMS_SCHEDULER execute bat file
HI,I created a bat file to run sqlldr to load the data from a csv file into Oracle,and I want to execute it automatically ,so I tried it by DBMS_SCHEDULERexec DBMS_SCHEDULER.run_job('DAILY_LOAD');Rapport d'erreur -ORA-27369: ├ęchec du travail de type EXECUTABLE...
Connor McDonaldUnable to install 18c Expression Edition
We are unable to install 18c Expression Edition in Windows 10 it is extracting and in middle, it is start rollback. Finally below the below message. Below is the message.The wizard was interrupted before Oracle Database 18c Express Edition could be completely...
Chris SaxonHow to exclude rows from outer join calculation but still include them in results
Hello Chris, Hello Connor.I have a view with a schedule of some kind of launches:<code>create or replace view v_schedule as select trunc(sysdate) + interval'1'minute * level as plan_date from dual connect by level <= 100000</code>And a log of actual launch dat...