Team,
let us consider our normal scott schema for this concern.
Let us consider emp table.
REM INSERTING into EXPORT_TABLE
SET DEFINE OFF;
Insert into emp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7369,'SMITH','CLERK',7902,to_date('17-12-80 00:00:00','DD-MM-RR HH24:MI:SS'),800,null,20);
We have two concerns here.
Concern 1;
In few scenarios ,Insert is taking too long in our prod DB . The insert statement in our Prod is different than the one provided above, though the syntax of insert stmt is same.(I meant to say that it's a single record insert stmt.)
We would like to know what could be the possible reasons for the insert to take too long time.
Concern 2;
In few scenarios, the SQL commit is taking lot of time.
We would like to know what could be the possible reasons for the commit to take too long time.
Any of your suggestions are most welcome !!
Thanks & Regards,