服务器为windows Server 2019 16Cpus 32GB内存
数据库版本为oracle 21c,插拔库只有一个PDB,在PDB下建有4个用户,各用户对应不同的业务场景,PFILE如下:
pftcloud.__data_transfer_cache_size=0
pftcloud.__db_cache_size=5168m
pftcloud.__inmemory_ext_roarea=0
pftcloud.__inmemory_ext_rwarea=0
pftcloud.__java_pool_size=64m
pftcloud.__large_pool_size=80m
pftcloud.__oracle_base='D:\app\Administrator'#ORACLE_BASE set from environment
pftcloud.__pga_aggregate_target=1648m
pftcloud.__sga_target=8192m
pftcloud.__shared_io_pool_size=128m
pftcloud.__shared_pool_size=2672m
pftcloud.__streams_pool_size=18m
pftcloud.__unified_pga_pool_size=0
*.audit_file_dest=*******************************************
*.audit_trail='none'
*.compatible='21.0.0'
*.control_files=************************************************************************
*.db_block_size=8192
*.db_name='PFTCLOUD'
*.db_recovery_file_dest=*******************************************************
*.db_recovery_file_dest_size=2048m
*.diagnostic_dest='E:\ora_db\db_home'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=PFTCLOUDXDB)'
*.enable_pluggable_database=true
*.local_listener='LISTENER_PFTCLOUD'
*.memory_max_target=9841m
*.memory_target=9840m
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=3000
*.pga_aggregate_target=1639m
*.processes=1280
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=8192m
*.undo_tablespace='UNDOTBS1'
后端4个.NET程序,使用IIS 10.0 发布,程序连接有使用连接池,按照CPU*2+1,连接池为33个,程序池配置为4线程访问
问题:
为什么进程内存会一直涨,初始只有10个G左右,随着使用,大概十来天会涨到20几个,而且没有停止的迹象,百思不得其姐,问题在哪?
(尝试过memory_max_target之类的,没有效果)