I/O performance problem
From: Giuseppe De Donno <dedonno_at_ariadne.it>
Date: Thu, 16 Apr 1998 12:38:15 +0200
Message-ID: <3535DF97.DA633922_at_ariadne.it>
I think to have a degrade of performance in I/O system. By SQL TRACE I have the follow report:
------- ------ -------- ---------- ---------- ---------- ----------
------- ------ -------- ---------- ---------- ---------- ----------
Date: Thu, 16 Apr 1998 12:38:15 +0200
Message-ID: <3535DF97.DA633922_at_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 - 12:38:15 CEST