WARNING: This web is not used anymore. Please use PDBService.10gMemoryParameters instead!
 
Update 25.04.2005: On the meeting we discuss on setting SGA_MAX_SIZE=SGA_TARGET=40% / PGA_AGGREGATE_TARGET=40% of system memory.

Taking from a original 10g installation:

Parameter Type 10g Original
sga_max_size big integer 900M 300M
sga_target big integer 900M -
pga_aggregate_target big integer 900M 92M
java_pool_size big integer 0 52M
java_soft_sessionspace_limit integer 0 10M
db_cache_size big integer 0 128M
shared_pool_reserved_size big integer 15M 5M
shared_pool_size big integer 0 100M

  • To change them you need to edit the PFILE (not possible to change with ALTER SYSTEM the ('db_cache_size=0'):
SQL> CREATE PFILE FROM SPFILE;
SQL> EXIT
$vi $ORACLE_HOME/dbs/init<SID>.ora
  • Change the following values:
sga_max_size=900M
sga_target=900M
pga_aggregate_target=900M
java_soft_sessionspace_limit=0
shared_pool_reserved_size=15M
  • Remove, if exist, the following paramenters
db_cache_size
java_pool_size
shared_pool_size
  • Recreate a SPFILE
SQL> CREATE SPFILE FROM PFILE
  • Bounce the database

  • On 10g if we set SGA_TARGET!=0 then the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE and JAVA_POOL_SIZE would be tunned automatically. It's a better option.

  • On pdblhcb I've putted SGA_MAX_SIZE=900M and SGA_TARGET=900M with good results.

Update 20.10.2005: Some of the instance parameters should be adjusted after the database installation specifically for our internal needs. These are:

processes=300

-- MiguelAnjo - 21 Mar 2005

Edit | Attach | Watch | Print version | History: r10 < r9 < r8 < r7 < r6 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r10 - 2005-11-29 - unknown
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright &© 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback