Home » RDBMS Server » Performance Tuning » queary taking time (Oracle10.2.0.1/linux)
queary taking time [message #476416] Thu, 23 September 2010 03:36 Go to next message
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 
 
 
 
Re: queary taking time [message #476420 is a reply to message #476416] Thu, 23 September 2010 03:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Add an index on c_type.

Regards
Michel
Re: queary taking time [message #476430 is a reply to message #476420] Thu, 23 September 2010 04:54 Go to previous message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Thanks Michel
Previous Topic: Performance over a DB link!!
Next Topic: will effect the performace of DML on Fast refresh of Materialized view
Goto Forum:
  


Current Time: Fri Nov 22 07:09:56 CST 2024