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.

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.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<john.enevoldson (AT) pulsen (DOT) se> a écrit dans le message de news:
1147933758.213791.61480 (AT) y43g200...oglegroups.com...

Hi John,

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

Regards
RaInDeeR

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