SGA
in [Oracle]
|
From: Syltrem on 29 Nov 2007 13:41 "noumian" <n.noumia(a)gmail.com> wrote in message news:661ba94d-4022-47a9-b91b-2d2b2220278f(a)e23g2000prf.googlegroups.com... >i think that my problem is here > Cannot set sga_target with db_block_buffers set > so where and which value can i set to db_block_buffers ? Don't set it. Just remove it from the spfile (you will have to create pfile from spfile, remove the line from the pfile in a text editor, and create spfile from pfile, then startup). Or else set sga_target to 0, it's your choice. In any case you have some more config to do but that will get you working. Read on automatic memory management Syltrem Oracle 10.2 on OpenVMS
From: Charles Hooper on 29 Nov 2007 13:59 On Nov 29, 1:41 pm, "Syltrem" <syltremz...(a)videotron.ca> wrote: > "noumian" <n.nou...(a)gmail.com> wrote in message > > news:661ba94d-4022-47a9-b91b-2d2b2220278f(a)e23g2000prf.googlegroups.com... > > >i think that my problem is here > > Cannot set sga_target with db_block_buffers set > > so where and which value can i set to db_block_buffers ? > > Don't set it. Just remove it from the spfile (you will have to create pfile > from spfile, remove the line from the pfile in a text editor, and create > spfile from pfile, then startup). > > Or else set sga_target to 0, it's your choice. > > In any case you have some more config to do but that will get you working. > Read on automatic memory management > > Syltrem > Oracle 10.2 on OpenVMS To the OP: Maybe it is a problem with specifying both DB_BLOCK_BUFFERS and SGA_TARGET - DB_CACHE_SIZE should be used rather than DB_BLOCK_BUFFERS, as the error quoted by Syltrem seems to imply. Brief explanation of the parameters: DB_BLOCK_BUFFERS - Specifies the number of database buffers in the buffer cache. It is one of several parameters that contribute to the total memory requirements of the SGA of an instance. This parameter multiplied by the DB_BLOCK_SIZE determines the total size of the buffer cache. DB_BLOCK_BUFFERS cannot be combined with the dynamic DB_CACHE_SIZE parameter; combining these parameters in the same parameter file will produce an error. DB_CACHE_SIZE - Determines the default cache for the database's standard block size, size is specified in bytes. The value must be at least 4M * number of cpus * granule size (smaller values are automatically rounded up to this value). A user-specified value larger than this is rounded up to the nearest granule size. A value of 0 is illegal. If SGA_TARGET is specified, this parameter indicates the minimum amount of memory to be used for the default buffer pool. Once again, it would be helpful to see the parameter file used to start the server. Charles Hooper IT Mananger/Oracle DBA K&M Machine-Fabricating, Inc.
From: Syltrem on 29 Nov 2007 14:53 "Charles Hooper" <hooperc2000(a)yahoo.com> wrote in message news:3768e79f-43e1-46bb-8641-c8b41857a832(a)j20g2000hsi.googlegroups.com... > On Nov 29, 1:41 pm, "Syltrem" <syltremz...(a)videotron.ca> wrote: >> "noumian" <n.nou...(a)gmail.com> wrote in message >> >> news:661ba94d-4022-47a9-b91b-2d2b2220278f(a)e23g2000prf.googlegroups.com... >> >> >i think that my problem is here >> > Cannot set sga_target with db_block_buffers set >> > so where and which value can i set to db_block_buffers ? >> >> Don't set it. Just remove it from the spfile (you will have to create >> pfile >> from spfile, remove the line from the pfile in a text editor, and create >> spfile from pfile, then startup). >> >> Or else set sga_target to 0, it's your choice. >> >> In any case you have some more config to do but that will get you >> working. >> Read on automatic memory management >> >> Syltrem >> Oracle 10.2 on OpenVMS > > To the OP: Maybe it is a problem with specifying both DB_BLOCK_BUFFERS > and SGA_TARGET - DB_CACHE_SIZE should be used rather than > DB_BLOCK_BUFFERS, Exactly, not maybe :-) But you can make the choice of setting sga_target to zero and change the settings later, or change everything now db_block_buffers = 0 and db_cache_size > 0 large_pool_size >= 0 shared_pool_size >= 0 java_pool_size >= 0 sga_target > 0 and at least = to sum of all above sga_max_size >= sga_target or db_block_buffers > 0 *OR* nd db_cache_size > 0 large_pool_size > 0 shared_pool_size > 0 java_pool_size > 0 sga_target = 0 sga_max_size >= sum of all of the above Syltrem > as the error quoted by Syltrem seems to imply. > > Brief explanation of the parameters: > DB_BLOCK_BUFFERS - Specifies the number of database buffers in the > buffer cache. It is one of several parameters that contribute to the > total memory requirements of the SGA of an instance. This parameter > multiplied by the DB_BLOCK_SIZE determines the total size of the > buffer cache. DB_BLOCK_BUFFERS cannot be combined with the dynamic > DB_CACHE_SIZE parameter; combining these parameters in the same > parameter file will produce an error. > > DB_CACHE_SIZE - Determines the default cache for the database's > standard block size, size is specified in bytes. The value must be at > least 4M * number of cpus * granule size (smaller values are > automatically rounded up to this value). A user-specified value larger > than this is rounded up to the nearest granule size. A value of 0 is > illegal. If SGA_TARGET is specified, this parameter indicates the > minimum amount of memory to be used for the default buffer pool. > > Once again, it would be helpful to see the parameter file used to > start the server. > > Charles Hooper > IT Mananger/Oracle DBA > K&M Machine-Fabricating, Inc.
From: noumian on 29 Nov 2007 15:37 RAM 800 mb
From: noumian on 30 Nov 2007 03:22 here is my init.ora.10272007144620 ############################################################################## # Copyright (c) 1991, 2001, 2002 by Oracle Corporation ############################################################################## ########################################### # Cache and I/O ########################################### db_block_size=8192 db_file_multiblock_read_count=16 ########################################### # Cursors and Library Cache ########################################### open_cursors=300 ########################################### # Database Identification ########################################### db_domain=lanit db_name=sim ########################################### # Diagnostics and Statistics ########################################### background_dump_dest=C:\oracle\product\10.2.0/admin/sim/bdump core_dump_dest=C:\oracle\product\10.2.0/admin/sim/cdump user_dump_dest=C:\oracle\product\10.2.0/admin/sim/udump ########################################### # File Configuration ########################################### control_files=("C:\oracle\product\10.2.0\oradata\sim\control01.ctl", "C:\oracle\product\10.2.0\oradata\sim\control02.ctl", "C:\oracle \product\10.2.0\oradata\sim\control03.ctl") db_recovery_file_dest=C:\oracle\product\10.2.0/flash_recovery_area db_recovery_file_dest_size=2147483648 ########################################### # Job Queues ########################################### job_queue_processes=10 ########################################### # Miscellaneous ########################################### compatible=10.2.0.1.0 ########################################### # NLS ########################################### nls_language="RUSSIAN" nls_territory="RUSSIA" ########################################### # Processes and Sessions ########################################### processes=150 ########################################### # SGA Memory ########################################### sga_target=219152384 ########################################### # Security and Auditing ########################################### audit_file_dest=C:\oracle\product\10.2.0/admin/sim/adump audit_trail=DB remote_login_passwordfile=EXCLUSIVE ########################################### # Shared Server ########################################### dispatchers="(protocol=TCP)" shared_servers=100 ########################################### # Sort, Hash Joins, Bitmap Indexes ########################################### pga_aggregate_target=72351744 ########################################### # System Managed Undo and Rollback Segments ########################################### undo_management=AUTO undo_tablespace=UNDOTBS1 i dont know if iam starting witg pfile or spfile how to choose it? i have done the 'create spfile from pfile' where is the location of my spfile? am still trying to start and i am still having : ORA-00824: cannot set sga_target due to exixting internal settings, see alert log for more information
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 4 Prev: CBO choose full table scan, not index Next: Sql*Loader, Bequeath and ulimit |