Home » RDBMS Server » Server Administration » writing by DBWn
writing by DBWn [message #189949] Mon, 28 August 2006 12:53 Go to next message
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 #190030 is a reply to message #189949] Tue, 29 August 2006 01:51 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

--> I wanted to know when the TIMEOUT would occur when a DBWn tries to write to the datafile and the error is thrown?

What kind of error are you expecting? It is an internal functioning of Oracle and it happens automatically.

http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10743/process.htm#i7259
Re: writing by DBWn [message #190050 is a reply to message #190030] Tue, 29 August 2006 02:32 Go to previous messageGo to next message
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
Hi,
Thanks for your reply. I am talking about the internal function of oracle only.

When would the time out occur?
Re: writing by DBWn [message #190067 is a reply to message #190050] Tue, 29 August 2006 03:39 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Check this out...
http://www.dbasupport.com/oracle/ora9i/ap_background_Processes_reader_followup.shtml
Re: writing by DBWn [message #190072 is a reply to message #190067] Tue, 29 August 2006 03:54 Go to previous message
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
Previous Topic: Alter table multiple
Next Topic: Access to another schema
Goto Forum:
  


Current Time: Tue Dec 06 14:04:12 CST 2016

Total time taken to generate the page: 0.31112 seconds