| writing by DBWn [message #189949] |
Mon, 28 August 2006 12:53  |
Anand Ramaswamy
Messages: 111
Registered: January 2005
|
Senior Member |
|
|
Hi All,
I learnt that DBWn writes when few events occur including a TIMEOUT.
I just wanted to test the timeout option, for which I did the following.
SQL> create tablespace t1 datafile '/erp/oracle/test/t1.dbf' reuse;
Tablespace created.
SQL> CREATE TABLE T1(v number)tablespace t1;
Table created.
SQL> INSERT INTO T1 VALUES(1);
1 row created.
SQL> INSERT INTO T1 VALUES(3);
1 row created.
SQL> host
$ cd /erp/oracle/test
$ mv t1.dbf t2.dbf
$ exit
SQL>commit;
commit complete
I wanted to know when the TIMEOUT would occur when a DBWn tries to write to the datafile and the error is thrown?
Regards,
Anand
|
|
|
|
|
|
|
|
|
|
| Re: writing by DBWn [message #190072 is a reply to message #190067] |
Tue, 29 August 2006 03:54  |
Anand Ramaswamy
Messages: 111
Registered: January 2005
|
Senior Member |
|
|
Hi,
Thanks for providing that hyperlink. That was really useful.
So with the situation given in my post, if I have no transactions thereby reducing the scope of a log switch, when do you think DBWn would attempt to write the dirty buffer to the datafiles.
Regards,
Anand
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
