Oracle Database SQL Certified Expert Exam (1Z0-047) Dumps

Below is the useful URL to find the dumps for 1Z0-047 certification exam.

http://weirdoootamee.yolasite.com/resources/oracle%20sql%20expert.pdf

http://www.gocertify.com/quizzes/oracle/exam-1z0-047-oracle-database-sql-certified-expert-free-practice-questions.html

Hope this will helps you to find Oracle Database dumps.

ORA-00020 maximum number of processes exceeded

Cause: All process state objects are in use.
Action: Increase the value of the PROCESSES initialization parameter.

ORA-00020 comes under "Oracle Database Server Messages". These messages are generated by the Oracle database server when running any Oracle program.

Reference: Oracle Documentation

How to increase PROCESSES initialization parameter:

1.    Login as sysdba
    sqlplus / as sysdba
   
2. Check Current Setting of Parameters
    sql> show parameter sessions
    sql> show parameter processes
    sql> show parameter transactions

3.    If you are planning to increase "PROCESSES" parameter you should also plan to increase "sessions and "transactions" parameters

    A basic formula for determining  these parameter values is as follows:
   
        processes=x
        sessions=x*1.1+5
        transactions=sessions*1.1
       
4.    These paramters can't be modified in memory. You have to modify the spfile only (scope=spfile) and bounce the instance.
    sql> alter system set processes=500 scope=spfile;
    sql> alter system set sessions=555 scope=spfile;
    sql> alter system set transactions=610 scope=spfile;
    sql> shutdown abort
    sql> startup

Steps to Enable display on Linux machine:

Steps:

1. Switch to root user (If not in already):

            $ su -
           Enter password

2. Type the below command as root user:

          # export DISPLAY=machine:0.0;

3. Check it is set or not by entering the below command:

         #echo $DISPLAY

4. Disable the hostname access

         # xhost + (or) # xhost + hostname

5. Check GUI is working or not by entering the below command:

       # xclock

6. Switch to normal user :

      # su - username
     Enter password

7. Type below commands to access the GUI:

     $ xhost  +

8. Type xclock command in the command prompt

Note: If we need the same GUI in windows machine, need to install X client or windows related display tools.

Database Instance Name and version Commands

Database commands to know the Instance Name and Database version

Instance Name:

Select instance_name from v$instance;

Database Version:

Select version from v$database;