I/O performance problem

From: Giuseppe De Donno <dedonno_at_ariadne.it>
Date: Thu, 16 Apr 1998 11:01:25 +0200
Message-ID: <3535C8E5.9DF127D8@ariadne.it>

I think to have a degrade of performance in I/O system. By SQL TRACE I have the follow report:

call     count       cpu    elapsed       disk      query
current        rows

------- ------ -------- ---------- ---------- ---------- ----------

Parse        1      0.01       0.00          0          0
0           0
Execute      1      0.02       0.00          0          0
0           0
Fetch        1     23.74      42.61      24348      43285
6           6

------- ------ -------- ---------- ---------- ---------- ----------

total        3     23.77      42.61      24348      43285
6           6

Misses in library cache during parse: 0 Optimizer goal: CHOOSE

The fetch is of ~24 seconds!!!
Is it a problem of I/O system?

How do i do?

Thank
Giuseppe Received on Thu Apr 16 1998 - 04:01:25 CDT