6 Replies Latest reply: May 6, 2013 1:44 AM by Venkateshj RSS

    Reg:- Background Process

    Venkateshj
      Hi all


      (1.)Which Process are responsiible for updating Data Dictionary views in oracle?


      (2.)
      and another probelm am getting is
      ORA-12516, TNS:listener could not find available handler with matching protocol

      for this problem am doing like below.
      ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;

      Then after restarting database, am still getting the above ORA-12516 Error..


      Please give a solution for the above two questions?


      Thanks in advance..
        • 1. Re: Reg:- Background Process
          Fran
          1) http://docs.oracle.com/cd/B28359_01/server.111/b28318/datadict.htm
          One of the most important parts of an Oracle database is its data dictionary, which is a read-only set of tables that provides information about the database.
          *
          *
          *
          The data dictionary is structured in tables and views, just like other database data. All the data dictionary tables and views for a given database are stored in that database's SYSTEM tablespace.
          
          *
          *
          *
          The Oracle Database user SYS owns all base tables and user-accessible views of the data dictionary. No Oracle Database user should ever alter (UPDATE, DELETE, or INSERT) any rows or schema objects contained in the SYS schema, because such activity can compromise data integrity. The security administrator must keep strict control of this central account.
          2) need to rebound database to take effect. First, check if your number of proccess are enough.
          • 2. Re: Reg:- Background Process
            Venkateshj
            Fran wrote:
            1) http://docs.oracle.com/cd/B28359_01/server.111/b28318/datadict.htm
            One of the most important parts of an Oracle database is its data dictionary, which is a read-only set of tables that provides information about the database.
            *
            *
            *
            The data dictionary is structured in tables and views, just like other database data. All the data dictionary tables and views for a given database are stored in that database's SYSTEM tablespace.
            
            *
            *
            *
            The Oracle Database user SYS owns all base tables and user-accessible views of the data dictionary. No Oracle Database user should ever alter (UPDATE, DELETE, or INSERT) any rows or schema objects contained in the SYS schema, because such activity can compromise data integrity. The security administrator must keep strict control of this central account.
            2) need to rebound database to take effect. First, check if your number of proccess are enough.
            (1.) Please just tell the background process sir?
            (2.)how to check number of processes in database & sessions limit in database?
            • 3. Re: Reg:- Background Process
              Fran
              1.- read the link I attached.

              2.- to check how many processes are at this moment in the database:
              select count(*) from v$process;

              to check the max number of process
              show parameter processes.


              scope= spfile, means that you must to rebound database for the new value take effect.

              the new value of your "processes" parameter must be enough or you will have again the problem. If you set at too much high number, you probably will have performance problems.
              • 4. Re: Reg:- Background Process
                Venkateshj
                (1.) ok sir i'l do



                (2.)
                SQL> select count(*) from v$process;

                COUNT(*)
                ----------
                313

                SQL>
                SQL> sho parameter process

                NAME TYPE VALUE
                ------------------------------------ ----------- ------------
                aq_tm_processes integer 0
                cell_offload_processing boolean TRUE
                db_writer_processes integer 2
                gcs_server_processes integer 0
                global_txn_processes integer 1
                job_queue_processes integer 1000
                log_archive_max_processes integer 4
                processes integer 500
                SQL>


                Now i increased process to 500 sir....
                plz check above

                Edited by: Venkateshj on Jan 31, 2013 5:44 PM
                • 5. Re: Reg:- Background Process
                  Niket Kumar
                  Article-ID: Note 240710.1
                  • 6. Re: Reg:- Background Process
                    Venkateshj
                    Server Process is the Process Which updates the Data Dictionary Views..