queary taking time [message #476416] |
Thu, 23 September 2010 03:36 |
goracle9
Messages: 136 Registered: December 2006
|
Senior Member |
|
|
Dear all,
when my developer when ever execute the queary getting late pls advice.
select * from sal_inv_fa_test where c_type='AC10CRL4D1'
Statistics is as below
General
Module SQL*Plus
Action
Parsing Schema SALADMIN
PL/SQL Source (Line Number) Not Applicable
Activity By Waits
User I/O Waits(90%)
CPU(10%)
Activity By Time
Elapsed Time (sec) 33.41
CPU Time (sec) 3.55
Wait Time (sec) 29.86
Elapsed Time Breakdown
SQL Time (sec) 33.41
PL/SQL Time (sec) 0.00
Java Time (sec) 0.00
Shared Cursors Statistics
Total Parses 1
Loads 1
Child Cursors 1
Child Cursors With Loaded Plans 1
Invalidations 0
Largest Cursor Size (KB) 28.47
All Cursor Size (KB) 28.47
First Load Time Sep 23, 2010 11:23:11 AM
Last Load Time Sep 23, 2010 11:23:11 AM
Execution Statistics
Total Per Execution Per Row
Executions 1 1 0.33
CPU Time (sec) 3.55 3.55 1.18
Buffer Gets 109167 109167.00 36389.00
Disk Reads 108448 108448.00 36149.33
Direct Writes 0 0.00 0.00
Rows 3 3.00 1
Fetches 2 2.00 0.67
Other Statistics
Executions that Fetched all Rows (%) 100.00
Average Persistent Mem (KB) 9.75
Average Runtime Mem (KB) 5.65
Serializable Aborts 0
Remote No
Obsolete No
Child Latch Number 5
|
|
|
|
|