Skip to Main Content
Ask The Oracle Mentors
Ask a Question
Recently Answered Report
Performance 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 126.96.36.199) 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...
tkprof 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...
DBMS_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...
Unable 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...
How 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...
Upcoming Office Hours
All Office Hours
Free training, how-tos and Q&A with Oracle experts, every month!
OML usage highlight: Oracle...
Next: April 27 15:00 UTC
Exploring Automatic In-Memory
Next: April 28 17:00 UTC
REST API Deep Dive
Next: May 4 16:00 UTC
Cloud Coaching Office Hours...
Next: May 10 17:00 UTC