Home -> Usenet -> comp.databases.oracle -> Unexplainable disk activity after simple select statement

Unexplainable disk activity after simple select statement

From: Matthew Heiman <boo_at_deltanet.com>
Date: 1998/02/15
Message-ID: <34e6ce73.20588885_at_news2.deltanet.com>#1/1 







I am trying to export database tables to ascii files for archiving.  I
basically write straight sql code that will spool the output of a
select * from table statement.  For each entry, I have to do this
62 times.  That is, I have to open, write the output of the select
statement, and close the file 62 times for each entry that I process.



The strange thing, the select statement seems to work fairly quickly
but then afterwards I have a lot of unexplainable disk activity that
is slowing my outputs to a crawl.  The larger the output that is
generated from the select statement, the longer the stall seems to be.



Any ide what is going on?



Any help would be greatly appreciated.



Matt Heiman


boo_at_deltanet.com
Received on Sun Feb 15 1998 - 00:00:00 CET












Original text of this message