about sga and pga in oracle

Shared pool in sga in oracle memory

It is a Shared portion of the Sga it contains the Library Cache and Dictionary cache

Library Cache: The library cache contains the current SQL execution plan information. It also holds stored procedures and trigger code.

Dictionary cache: The dictionary cache stores environmental information, which includes referential integrity (like primary key etc), table definitions, indexing information, and other metadata stored within Oracle's internal tables.

To change the shared pool in Sga in oracle

1     open the file using notepad SPFILEXE.ORA in this location C:\oraclexe\app\oracle\product\10.2.0\server\dbs

2     find the parameter of shared_pool_size=88080384(the value is in bytes)

      give the required memory for shared pool

Buffer Cache in sga in oracle memory

It is also called DB Buffer Cache.

The DB buffer cache is read the data from datafiles.

Datafiles: Datafiles store the information contained in the db(i.e our tables,views…. data)

To change the Buffer Cache in Sga in oracle

1     open the file using notepad SPFILEXE.ORA in this location C:\oraclexe\app\oracle\product\10.2.0\server\dbs

       find the parameter of db_cache_size=176160678 (the value is in bytes)

3     give the required memory for shared pool 

 We can also set Sga and Pga

1open the file using notepad SPFILEXE.ORA in this location C:\oraclexe\app\oracle\product\10.2.0\server\dbs

2sga_target=314572800 (to set sga memory using this parameter)

    pga_aggregate_target=90M(to set pga memory using this parameter)

set SGA and PGA in oracle

Hoe to set SGA, PGA in Oracle
------------------------------------------
open oracle db homepage: http://127.0.0.1:8080/apex/
         |
username:system
password:oracle
       |
click on administration
          |
click on memory
         |
click on confugure SGA and give the required memory
          |
click on configure PGA and required memory

how to set session timeout in weblogic
----------------------------------------------------

this is code is there in weblogic.xml in weblogic installation folder


<session-descriptor>
    <session-param>
      <param-name>CookieMaxAgeSecs</param-name>
      <param-value>-1</param-value>
    </session-param>
    <session-param>
      <param-name>InvalidationIntervalSecs</param-name>
      <param-value>60</param-value>
    </session-param>
    <session-param>
      <param-name>TimeoutSecs</param-name>
      <param-value>3600</param-value>
    </session-param>
    <session-param>
      <param-name>CookieName</param-name>
      <param-value>ADMINCONSOLESESSION</param-value>
    </session-param>
  </session-descriptor>

  <jsp-descriptor>
    <keepgenerated>false</keepgenerated>
    <page-check-seconds>-1</page-check-seconds>
    <verbose>true</verbose>
    <debug>true</debug>
  </jsp-descriptor>

How to set jdbc connecton pool in weblogic10
-------------------------------------------------------------

click on environments
       |
click on services
      |
  click on JDBC
       |
click on DataSources
      |
click on jdbcdatasource-0(that is user defined)
     |
click on connection pool
    |
enter values of intial capacity(that is no of db connections used for initially)
    |
enter value of max capacity(that is max db connections used by app server)
     |

  capacity increment is for db connections after reaching the initial connections then connections incrementation  

                             How to set JVM Heap Memory
------------------------------------------------------------------------------------

1) After Installing the weblogic10 then search the file setDomainEnv.sh in weblogic installation folder

2) open in notepad or editplus

3)WLS_MEM_ARGS_64BIT="-Xms256m -Xmx512m"
    export WLS_MEM_ARGS_64BIT
    WLS_MEM_ARGS_32BIT="-Xms256m -Xmx512m"
    export WLS_MEM_ARGS_32BIT


  -Xms256m(is intila size of heap)

  -Xmx512m(is max size of heap)

update these values as per requirement


We can also set perm size of heap meory

MEM_PERM_SIZE_64BIT="-XX:PermSize=128m"
export MEM_PERM_SIZE_64BIT

MEM_PERM_SIZE_32BIT="-XX:PermSize=48m"
export MEM_PERM_SIZE_32BIT