Database Tuning (MOSC)

MOSC Banner

SQL*Net message from client

edited Apr 8, 2011 3:12AM in Database Tuning (MOSC) 5 commentsAnswered
Hi everyone,

My platform:
Oracle9i Release 9.2.0.1.0 -- windows 2003 R2 SP2 standard edition

We are working with a third party application and a process is taking us a long time.
We have made a track with sqltrace and this is the result:


OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse     6212      2.17       1.91          0          0          0           0
Execute 1548579     33.82      32.52         15       6203      24541        3298
Fetch   3089298     35.78      34.92          0      42979          8     3377968
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total   4644089     71.78      69.36         15      49182      24549     3381266

Misses in library cache during parse: 1372

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------

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