If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I don't think server process is the one who does this....coz when some of the modifications what we do at the mount phase is also reflected in the control file; like when we change the name of the system datafile in the mount phase it is automatically reflected in the control file, during which there is no server proess started.....

Originally posted by Sonia .... in the mount phase it is automatically reflected in the control file, during which there is no server proess started.....

What makes you think there is no server process started when database is mounted? In mount phase, the instance is allready started and functioning - SGA is formed, background processes started, it is only the database files that are not opened yet.

If you check the process scheme (Figure 8-2 in Concepts manual) http://download-west.oracle.com/docs...rocs.htm#18128, it clearly indicates which server processes are responsible for updating control file information: LGWR, CKPT and ARCn. There might be some othere process that interacts with controlfiles that are not indicated on that picture, but those three are the main contributors for controlfile information.

Jurij ModicASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?

Originally posted by jmodic What makes you think there is no server process started when database is mounted? In mount phase, the instance is allready started and functioning - SGA is formed, background processes started, it is only the database files that are not opened yet.

If you check the process scheme (Figure 8-2 in Concepts manual) http://download-west.oracle.com/docs...rocs.htm#18128, it clearly indicates which server processes are responsible for updating control file information: LGWR, CKPT and ARCn. There might be some othere process that interacts with controlfiles that are not indicated on that picture, but those three are the main contributors for controlfile information.

I agree with you that it is not clear which process writes to controlfiles when you change some datafile or logfile names - that's why I said

There might be some othere process that interact with controlfiles that are not indicated on that picture

. However I'm sure of one thing: It is certainly not session's server process. Those processes never write anything to the database, all of their I/O activities are READs and READs only. I'm also cetain it is not ARCn processes (because there might not be any of them in the instance). I would not rule out neither CKPT nor LGWR to be responsible for this job, as well as maybe DBWR. I'm also positive SMON and PMON have nothing to do with that.

Jurij ModicASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?

Originally posted by Sonia Jmodic,
yeh....a server process gets started as soon as you connect...

sql>connect / as sysdba
sql>startup mount

Is this process also responsible for initializing the SGA and starting other background processes....

And one more thing............is the serverprocess also considered as a background process ?
or is it called as a foreground process ?

regards
sonia

We have 2 types of processes. Oracle process and user process. Oracle process is spawned at the server. Oracle processes further devided into two. 1. Server process and 2. Back ground process. Server processes are spawned when an user connects to database. Back ground processes are spawned when Oracle starts. Back ground processes are LGWR, DBWn, ARCn, CKPT etc. User processes can be spawned at either server or user's terminal depending on the configuration. I learnt all these things exactly 310 days when I attened my 1st ever Oracle class

Originally posted by Sonia Jmodic,
yeh....a server process gets started as soon as you connect...

sql>connect / as sysdba
sql>startup mount

Is this process also responsible for initializing the SGA and starting other background processes....

Yes, I would say so.

And one more thing............is the serverprocess also considered as a background process ?
or is it called as a foreground process ?
[/B]

No, server process (a process that is opened by RDBMS on behalf of user's application process) is never considered as "background process" in the context of Oracle's process terminology. AFAIK Oracle documentation allways mention only two tipes of processes that are handled by RDBMS on the server side: "background processes" (PMON, SMON, DBWR, LGWR, ......) and "server processes" (processes that handle user requests against the database). I don't remember coming across the term "foreground process" in this context.

Jurij ModicASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?