Database Tuning (MOSC)

MOSC Banner

I would like understand the time waits of my query

edited May 17, 2011 4:50AM in Database Tuning (MOSC) 10 commentsAnswered
 hello,     When I analyze a query on an update, I have the next result :
I do not understand who are waiting who ?
For my opinion i think it's Oracle which wait the application, and Oracle answer quickly the cpu time is 0.01 Sec

but "Elapsed Time (sec) 398.60"

I do not understand where I can win this Wait Time.

Regards

JP  

Execution Statistics


TotalPer ExecutionPer Row
Executions110.03
Elapsed Time (sec)398.60398.6010.49
CPU Time (sec)0.010.01<0.01
Buffer Gets281281.007.39
Disk Reads77.000.18
Direct Writes00.000.00
Rows3838.001
Fetches00.000.00

Shared Cursors Statistics

Total Parses 2
Hard Parses 0
Child Cursors 2
Loaded Plans 1
Invalidations 0
Largest Cursor Size (KB) 122.86
All Cursor Size (KB)

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