SQL Performance (MOSC)

MOSC Banner

"Other" wait class related events in Elapsed time

edited Nov 25, 2019 1:35PM in SQL Performance (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center