游戏的数据库oracle参数设置

最新推荐文章于 2025-12-29 14:56:52 发布

原创最新推荐文章于 2025-12-29 14:56:52 发布 · 522 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #数据库 #游戏 #file #domain #service

数据库（oracle,mysql）专栏收录该内容

1 篇文章

订阅专栏

本文详细介绍了Oracle数据库的具体配置参数，包括内存池大小、文件路径、进程数量等关键设置，旨在支持高并发和大量用户访问。

wapgame.__java_pool_size=16777216
wapgame.__large_pool_size=16777216
wapgame.__shared_pool_size=285212672
wapgame.__streams_pool_size=33554432
*.audit_file_dest='E:/oracle/product/10.2.0/admin/wapgame/adump'
*.background_dump_dest='E:/oracle/product/10.2.0/admin/wapgame/bdump'
*.compatible='10.2.0.1.0'
*.control_files='E:/oracle/product/10.2.0/oradata/wapgame/control01.ctl','E:/oracle/product/10.2.0/oradata/wapgame/control02.ctl','E:/oracle/product/10.2.0/oradata/wapgame/control03.ctl'
*.core_dump_dest='E:/oracle/product/10.2.0/admin/wapgame/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='wapgame'
*.db_recovery_file_dest='E:/oracle/product/10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=wapgameXDB)'
*.job_queue_processes=10
*.pga_aggregate_target=526381824#786381824
*.processes=3000
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=3000
*.sga_max_size=3950585600#internally adjusted
*.sga_target=3950585600
*.undo_management='AUTO'
*.cursor_sharing='FORCE'
*.open_cursors=3000
*.db_writer_processes=2
*.optimizer_mode='RULE'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='E:/oracle/product/10.2.0/admin/wapgame/udump'
能够支持较大的并发和用户量