I guess it has to do with the fact that Oracle on Windows is a single process multithreads. So any opened file in the main thread will be accessible and opened for the spawned threads (correct me if I'm wrong).
So concurrent access to the files would need to be controlled by O/S resources like mutex. It would be helpful if some one with multithread programming experience in Windows could shed some light here. Regards, Waleed -----Original Message----- Sent: Monday, December 02, 2002 2:49 PM To: Multiple recipients of list ORACLE-L On UNIX, when a user process needs to access data, it will open the files of interest. The background processes 'attach' to all of the files when the OPEN state of the database is achieved. They do not open each file when they need to read/write. For example, CKPT attaches to the files and will maintain the handle as long as the process is running. Why do I know this, you ask? One afternoon, a support tech moved a datafile since the device was 95% full. User queries would fail when trying to open the file, but checkpoints were succeeding and we could even dump the file headers without any problem. After discussing this situation with the SAs, we postulated that the background processes were keeping the files open and thus were still attached to the files original location. If we shutdown the background processes, the files would have been closed and the original blocks released. Once we resolved the issue, the support techs were scheduled for Oracle 101 training immediately! On Windows, they handle files slightly differently and I am not sure. -----Original Message----- Sent: Friday, November 29, 2002 3:34 PM To: Multiple recipients of list ORACLE-L On Friday 29 November 2002 08:43, Jeff Herrick wrote: > My understanding > from the question was that he was wondering whether each > user's process in a dedicated-server configuration opened > all of the datafiles too Maybe not all of the data files, but the users dedicated server process will open datafiles as needed to read data into the block buffer. Now I don't know if I've helped any, or just added to the confusion. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
