|
-
Originally posted by jmodic
Where did you hear that????? Server proces *can never* write to the database file. Never! It can only read from database file. It would be a shocking news to me if you could prove me wrong on that.
Why would be any different with ALTER TABLESPACE COALESCE command? How does it differ with any other CREATE, ALTER, etc commands? No matter what command is executed, server process can only *read* from datafiles. All modifications that must be performed by server processare are executed in the buffer cache, and it is DBWR that performs any datafile writes associated with that.
Realy, can you provide any explanation/URL regarding what is so special about ALTER TABLESPACE COALESCE in this context?
I may be wrong. But, coelescing is done by a server process when we use this "alter tablespace ...." command.
Last edited by nagarjuna; 10-25-2002 at 06:26 AM.
-nagarjuna
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote