suggestions from tkprof output
Hi All,
can you please provide inputs to tune the following sql from the tkprof output of the query.
TKPROF: Release 11.2.0.1.0 - Development on Wed Mar 23 13:52:30 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Trace file: hsctst09_ora_1671386_10046.trc
Sort options: prsela fchela exeela
********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
can you please provide inputs to tune the following sql from the tkprof output of the query.
TKPROF: Release 11.2.0.1.0 - Development on Wed Mar 23 13:52:30 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Trace file: hsctst09_ora_1671386_10046.trc
Sort options: prsela fchela exeela
********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
0