| NAGPURE |
Posted: Feb 23, 2008 09:51:03 AM |
Total Post: 8
Joined: Jul, 2007
|
any one tell me
(1)My database is in open stage and i execute below two commands
alter system set control_files='c:\____';
create table <table_name>;
will informations about both above statement go in controlfile ?
(2)which background process will start when we startup a database ?
(a) server process
(b) user process
(c) smon
(d) lgwr
(e) dbwr
pls specify server process & user process are background process ????
thanks in advance |
|
|
 Mohammed Taj |
| Posted: Feb 23, 2008 10:48:42 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
Read this: about controlfile http://download.oracle.com/docs/cd/B14117_01/server.101/b10743/intro.htm#sthref30
about background process:
http://download.oracle.com/docs/cd/B14117_01/server.101/b10743/intro.htm#sthref98
|
|
|
|
|
| anil |
| Posted: Feb 25, 2008 09:22:01 AM | |
|
Total Post: 27
Joined: Dec, 2007
|
Server process start when a user issue a command to server and user process start when server send back the user request.
when u issue a comman STARTUP
according to u the SMON background process is start because
i dont know the privious shutdown mode
smon works the instance recovery it is depend on the shutdown mode
if i m wrong please someone clear my doubts!
thanks in advance
joshi
|
|
|
|
|
| Kaiz |
| Posted: Mar 17, 2008 01:32:54 AM | |
|
Total Post: 104
Joined: Sep, 2007
|
any one tell me
(1)My database is in open stage and i execute below two commands
alter system set control_files='c:\____';
create table <table_name>;
will informations about both above statement go in controlfile ?
Ans. : No, only informatin about the second command will go into the control file.....
(2)which background process will start when we startup a database ?
(a) server process
(b) user process
(c) smon
(d) lgwr
(e) dbwr
Ans. : a and b processes dosent depend on the database startup they are started before and rest of the processes are started when you startup the database...
I tried to explain with whatever knowledge I have , still confirm it...
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
