10 Replies Latest reply: May 3, 2012 4:46 PM by jgarry RSS

    spfile

    user3266490
      Hi,

      Db : 9i and above

      While executed alter system / session.which process is updated? whether server process or pmon?

      Thanks and Regards,
      VN
        • 1. Re: spfile
          damorgan
          Your question has no context.

          Go to http://tahiti.oracle.com and look up what you are actually asking about.
          • 2. Re: spfile
            Karan
            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

            Regards
            Karan
            • 3. Re: spfile
              Aman....
              user3266490 wrote:
              Hi,

              Db : 9i and above

              While executed alter system / session.which process is updated? whether server process or pmon?

              Thanks and Regards,
              VN
              Where did you read that "process(es)" get updated?

              Aman....
              • 4. Re: spfile
                Karan
                Exactly... Thats what i am waiting from the OP...

                Regards
                Karan
                • 5. Re: spfile
                  hitgon
                  Hi,

                  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

                  http://docs.oracle.com/cd/B19306_01/server.102/b14231/start.htm

                  http://www.dba-oracle.com/concepts/pfile_spfile.htm

                  http://www.dba-oracle.com/tips_oracle_spfile_example.htm

                  http://oraclepitstop.wordpress.com/2008/06/30/how-to-make-changes-to-spfile-pfile-or-generate-spfile-pfile-on-a-rac-database/


                  Regards
                  Hitgon

                  Edited by: hitgon on May 3, 2012 10:34 AM
                  • 6. Re: spfile
                    Aman....
                    hitgon wrote:
                    Hi,

                    SCOPE=spfile
                    It's update spfile with new changes which effect only after the reboot
                    or
                    SCOPE=both;
                    It's update memoery and spfile both with new changes

                    Regards
                    Hitgon
                    Hitesh,

                    How does this comment would help in OP's question ?

                    Aman....
                    • 7. Re: spfile
                      user3266490
                      Hi,

                      Thanks for your reply.

                      I haven't read from anywhere.Just asking.

                      For ex:

                      scott user execute alter session command
                      which process update in spfile/ pga ,sga?

                      I don't know my question is meaning full or not.

                      Thanks & Regards,
                      VN
                      • 8. Re: spfile
                        Aman....
                        user3266490 wrote:
                        Hi,

                        Thanks for your reply.

                        I haven't read from anywhere.Just asking.

                        For ex:

                        scott user execute alter session command
                        which process update in spfile/ pga ,sga?

                        I don't know my question is meaning full or not.
                        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?

                        Aman....
                        • 9. Re: spfile
                          damorgan
                          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.
                          • 10. Re: spfile
                            jgarry
                            >
                            "How does a mouse when it spins?"
                            [url http://www.jwhitham.org/magrathea/ep4.html]42.