Correction. Not every row - just once at the end of retrieving
all the rows. Still - how can I avoid it?
-Paul
> -----Original Message-----
> From: Paul G. Weiss
> Sent: Wednesday, October 24, 2001 2:30 PM
> To: '[EMAIL PROTECTED]'
> Subject: File read for every record retrieved
>
> I'm using DBD::Oracle to read records from an Oracle database.
> It's Oracle 8.1.6.2, DBI version 1.15, DBD::Oracle version 1.07.
> The platform is Solaris 2.7.
>
> When trussing my Perl process, I've noticed the following lines
> between every record retrieved:
>
> open("/usr/oracle/product/8.1.6/rdbms/mesg/oraus.msb", O_RDONLY) = 9
> fcntl(9, F_SETFD, 0x00000001) = 0
> lseek(9, 0, SEEK_SET) = 0
> read(9, "1513 "011303\t\t\0\0\0\0".., 256) = 256
> lseek(9, 512, SEEK_SET) = 512
> read(9, "1C88 YBB xCE\0\0\0\0\0\0".., 512) = 512
> lseek(9, 1024, SEEK_SET) = 1024
> read(9, "\018\0 $\0 7\0 @\0 J\0 V".., 512) = 512
> lseek(9, 39936, SEEK_SET) = 39936
> read(9, "\0\t0519\0\0\0 >051A\0\0".., 512) = 512
> close(9) = 0
>
> Can anyone explain what is going on here? This file hasn't changed
> since July. Why is it being read for every record?
>
> -Paul Weiss
>
