Czym zajmuje się KAMIENIARSTWO ?
Temat: [Oracle] =?ISO-8859-2?Q?pami=EA=E6_SGA_-_shared=5Fpool=5F?==?ISO-8859-2?Q?size?=
...parameter
log_checkpoint_interval = 1000000000
log_checkpoint_timeout = 1800
log_buffer = 32768
log_archive_start = false
#
# misc parameter
processes = 50
job_queue_processes = 1
query_rewrite_enabled = true
db_file_multiblock_read_count = 8
#
# auditing and security
oracle_trace_collection_name = ""
remote_login_passwordfile = exclusive
os_authent_prefix = ""
utl_file_dir = *
_trace_files_public = true
# NLS parameter
nls_language = "ARABIC"
nls_territory = "UNITED ARAB EMIRATES"
SELECT * FROM v$sgainfo
daje wynik:
Fixed SGA Size 788044
Redo Buffers 610304
Buffer Cache Size 16777216
Shared Pool Size 104857600
Large Pool Size 0
Java Pool
Size 4194304
Streams Pool Size 0
Granule Size 4194304
Maximum SGA Size 130023424
Startup overhead in Shared Pool 29360128
Free SGA Memory Available 0...
Źródło: forum.hotscripts.pl/showthread.php?t=15401
Temat: [Oracle] =?ISO-8859-2?Q?pami=EA=E6_SGA_-_shared=5Fpool=5F?==?ISO-8859-2?Q?size?=
jerry <j@interia.pl> napisał: > # memory parameter > shared_pool_size = 104857600 > java_pool_size = 0 > open_cursors = 500 > session_cached_cursors = 256 > db_cache_size = 15728640 ?? 15MB db cache - bardzo malo! > # NLS parameter > nls_language = "ARABIC" > nls_territory = "UNITED ARAB EMIRATES" niezłe ;-) > SELECT * FROM v$sgainfo > daje wynik: > Buffer Cache Size 16777216 > Shared Pool Size 104857600 > Large Pool Size 0 > Java Pool Size 4194304 > Maximum SGA Size 130023424 > > Startup overhead in Shared Pool 29360128 > natomiast w Enterprise Managerze shared_pool_size ma wartość 60MB....
Źródło: forum.hotscripts.pl/showthread.php?t=15401
