"Other" wait class related events in Elapsed time
Hello All,
v$sql and dba_hist_sqlstat have below columns to understand distribution of Elapsed time of sqls:
CPU Time
Application Wait Time
Concurrency Wait Time
Cluster Wait Time
User IO Wait Time
PLSQL Execution Time
Java Execution Time
I was checking an ADDM report today and found below:
SQL statement with SQL_ID 7jy3hgyz87kcu:
INSERT INTO DBO.PERSON (PERSON_ID, SSN, FIRST_NAME,
LAST_NAME,MIDDLE_NAME, SEX, BIRTH_DATE , SUFFIX, PREFIX) VALUES
(DBO.S_PERSON_PK.NEXTVAL, :B8 , :B7 , :B6 , :B5 , UPPER(:B4 ), :B3 ,
:B2 , :B1 ) RETURNING PERSON_ID INTO :O0;
SQL statement with SQL_ID "7jy3hgyz87kcu" was executed 54847 times and