Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> short of memory ?
Hi,
(oracle 9.2.0.1 HP-UX 11.0)
I have the following problem
each connection => server process 68 MB
so my memory is quickly full
How can I reduce this amount ?
pga_aggregate_target ?
Thanks
Here my SPFILE:
*.aq_tm_processes=1
*.background_dump_dest='/tools/oracle/9.2.0/admin/DB9IDEV/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/data/oracle/DB9IDEV/control01.ctl','/data/oracle/DB9IDEV/c
ontr
ol02.ctl','/data/oracle/DB9IDEV/control03.ctl'
*.core_dump_dest='/tools/oracle/9.2.0/admin/DB9IDEV/cdump'
*.db_block_size=8192
*.db_cache_size=16777216
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='DB9IDEV'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=DB9IDEVXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='DB9IDEV'
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=8388608
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=100
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=33554432
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/tools/oracle/9.2.0/admin/DB9IDEV/udump'
Received on Thu Apr 22 2004 - 14:18:28 CDT