This content has been marked as final. Show 10 replies
You need to read the oracle doc, first understand what each background process does http://docs.oracle.com/cd/E14072_01/server.112/e10820/bgprocesses.htm
and for your information server process handles the client request.. Read more... And after reading it, tell us that what benefit it gave you of knowing it
spfile is the binary file which keep the oracle initialization parameters configurations
spfile is read by the oracle in nomount stage
please explore the spfile from oracle documents
Edited by: hitgon on May 3, 2012 10:34 AM
user3266490 wrote:Okay, let's do it in this way. When you as Scott user get connected, what do you get to do your work in the database ? In other words, who does your work on your behalf within the db?
Thanks for your reply.
I haven't read from anywhere.Just asking.
scott user execute alter session command
which process update in spfile/ pga ,sga?
I don't know my question is meaning full or not.
When you write: "I haven't read from anywhere.Just asking." my interpretation is not very charitable.
It is your obligation to, if you want to know answers to questions, read the docs. Then, if there are things you do not understand come here and ask us to help you with clarification.
Your original question, to be bluntly honest, read like this:
"How does a mouse when it spins?"
In other words your questions has no meaning.
Read the docs, that is how all of us learn, and then we will be glad to help you.