Adjustment oracle database connection pool connections

Jun 26 posted in Oracle Database (RSS), 146 views.
First backup $ ORACLE_HOME \ dbs \ spfileSID.ora document

c:> set ORACLE_SID = xxx
c:> sqlplus / nolog
sql> connect / as sysdba

- View the current value of the parameter
sql> show parameter processes;
sql> show parameter sessions;
sql> show parameter sga_target;

- Amend the number of connections
sql> alter system set processes = 500 scope = spfile;
sql> alter system set processes = 555 scope = spfile; / / session = process * 1.1 +5
Modified database can be restarted
  • del.icio.us
  • StumbleUpon
  • Digg
  • TwitThis
  • Mixx
  • Technorati
  • Facebook
  • NewsVine
  • Reddit
  • Google
  • LinkedIn
  • YahooMyWeb

Related Posts of Adjustment oracle database connection pool connections

  • ORACLE10G full version centos5 installed (the installation has passed)

    ORACLE10G full version centos5 installed (the installation has passed) 1. Centos 5.0 install rn GUI must be installed, it is best not to start selinux rn rn rn 2. . Ready to install the software: (this is very important, is the first installation fai ...

  • SGA extended the principle of 32bit oracle

    SGA extended the principle of 32bit oracle From: http://www.itpub.net/247048.html Because the median 32bitrnoracle restrictions can only visit the oracle process 4g (2 of 32 power) following virtual memory address, the time at a lot of people this is ...

  • High Availability Oracle Flashback

    Brief introduction Flashback Database is a point in time (PIT) restore the database approach. This incomplete recovery strategy can be used to restore the logic because of human error cause damage to the database. At the introduction of 10g, it is de ...

  • An example of the use of TKPROF

    First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE

  • Diagnosis and principles of order

    SQL> select disk.value "Disk", mem.value "Mem", 2 (disk.value / mem.value) * 100 "Ratio" 3 from v $ sysstat mem, v $ sysstat disk 4 where mem.name = 'sorts (memory)' 5 and disk.name = 'sorts (disk)'; D ...

  • ORACLE 10G dataguard configuration Step by Step

    oracle dataguard

Leave a Reply

Recent
Recent Entries
Tag Cloud
Oracle SQL Developer auto open session Solaris find older than 1 minute Hotmails databas how to check the iowait on solaris ulimi redhat nofiles 5.4 script to check server memory in aix define oracle 11g net protocol node name in TNSNAMES.ORA Oracle JDBC update insert delay problem md5 pro decrypter online oracle datafile linux lvm large pool size oracle8i encode special characters sqr get permission denied when using vi analyze on parallel table does dbua re-enable archive log mode? DELETE AN EMPTY LINE FROM FILE SQL abap import shared memory example JRE chain length issue in 1.6 oci dll toad error oracle fluent nhibernate .sequence Insert a sequence value in Sybase serviceguard vs vcs enable selinux sles 11 jobs.txt oracle oracle "export only sequences sqlplus login ip doctrine union all voting file add failed ALTER SYSTEM DUMP LOGFILE <filename>;
Random Entries
Latest Comments
Categories
Related