direct writes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

john.enevoldson@pulsen.se - 18 May 2006 07:29 GMT

Hi,
When running a job that inserts data into a particular table we are
seeing a significant number of direct writes against the tablespace
containing the table. This is the only
table in the tablespace and there are no other jobs running against the
table at the same time. The table contains no lobs or long varchar
columns so we cannot understand what is causing the direct writes.
Anyone any ideas ?
Regards,
John.

Reply to this Message

Pierre Saint-Jacques - 18 May 2006 18:37 GMT

Just off the top of my head, aren't log writes counted as direct writes.
Direct writes, AFAIR are all writes that are non buffered, meaning thru the
buffer pools.
Inserts would have to be logged an cause log writes. If the logbufsz is
small, you could cause a lot of direct writes.
HTH, Pierre.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

> Hi,
> When running a job that inserts data into a particular table we are
[quoted text clipped - 6 lines]
> Regards,
> John.

Reply to this Message

rAinDeEr - 22 May 2006 13:53 GMT

Hi John,

How can we find the writes while inserting Data in a table ?

Regards
RaInDeeR

Reply to this Message

UDBDBA - 22 May 2006 18:17 GMT

What kind of job are you running that does inserts? can you please
provide details?
Vijay

Reply to this Message