1

Topic: db file async I/O submit? there?

Absolutely simple : "db file async I/O submit" in the histogram in 2 % about 1 second.
It generally  for the period of transaction?  with what it generally eat? The server behaves well,
But some  speak that it is a problem. Whether so it or is simple  want?

% of Total Waits
Event Waits 64ms to 2s <32ms <64ms <1/8s <1/4s <1/2s <1s <2s> =2s
SQL*Net more data from client 5 100.0.0.0.0
buffer busy waits 3 100.0.0.0
control file parallel write 3 99.9.1.0
control file sequential read 2 100.0.0.0
cursor: pin S 1 98.1 1.9
cursor: pin S wait on X 15 99.5.4.0.1
db file async I/O submit 23.9K 28.9 26.6 25.5 11.4 5.3 1.3.6.4

2

Re: db file async I/O submit? there?

0;
Thanks.

3

Re: db file async I/O submit? there?

wrote:

It is strange wait event, for example, at

On a metalink it is written  this such.
It is necessary to expose filesystemio_options in as it is necessary (setall) and it disappears.

4

Re: db file async I/O submit? there?

0 wrote:

also be engaged in waitings buffer busy waits

Yes, all three
Generally the strange ratio - almost 24  waitings on Asinc I/O and at the same time 3 waitings of record in a control file

5

Re: db file async I/O submit? there?

in this business wrote:

it is passed...
On a metalink it is written  this such.
It is necessary to expose filesystemio_options in as it is necessary (setall) and it disappears.

Tady DISK_ASYNCH_IO (1274737.1)