oracle数据库性能问题!!在线等候!高分求救!谢谢了!!! startup sessions就是335了阿??全部kill掉,重新试试 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 注意:HP-UX Error: 23: File table overflow是不是你的hp-ux的配置问题???把打开文件数设大一点,500w左右。 建议:操作系统共享内存分配:2147483648数据库核心参数:db_file_multiblock_read_count = 4kdb_block_size=4kdb_block_buffers = 158720shared_pool_size = 262144000processes = 200dml_locks = 200log_buffer = 524288×cpu个数large_pool_size = 31457280java_pool_size = 20971520sort_area_size == 1048567 可能是你的操作系统参数的问题,参考:metalink,Note:68105.1 This note lists commonly misconfigured HP-UX kernel parameters. parameter | default | recommended | notes ====================================================================== aio_max_ops | 2048 | 2048 | max no of queued AIO ops | | | See Note:139272.1 ---------------------------------------------------------------------- dbc_min_pct | 5 | 2 | min %age of system mem used | | | for buffer cache | | | (valid if nbuf = bufpages = 0) ---------------------------------------------------------------------- dbc_max_pct | 50 |ensure <= 128MB | max %age of system mem used | |used as cache | for buffer cache | | | (valid if nbuf = bufpages = 0) | | | Also see Note:62589.1 ---------------------------------------------------------------------- fsasync | 0 | 0 | async i/o on filesystems | | | See Note:139272.1 ---------------------------------------------------------------------- max_async_ | 50 | see notes | See Note:139272.1 ports | | | ---------------------------------------------------------------------- maxdsiz | 64MB | >=128MB | shadow process' heap size maxdsiz64 | 1GB | 1GB | ---------------------------------------------------------------------- maxfiles | 60 | >= 512 | soft limit | | | no of open files per process ---------------------------------------------------------------------- maxfiles_lim | 1024 | 1024 | hard limit | | | no of open files per process ----------------------------------------------------------------------- maxusers | 32 | no of Oracle | influences nproc, nfile, | | connections+64 | ninode, maxuprc ---------------------------------------------------------------------- maxuprc | 50 | maxusers*5 | no of procs per userid ---------------------------------------------------------------------- nfile | | use SAM formula | open files system wide ---------------------------------------------------------------------- nflocks | 200 | >= (200 + | file locks system wide | |(sum of db files | 8i onwards uses o/s file locking | |for all instances| undersizing will give | |) | HP-UX Error: 46: No locks available | | ) | ---------------------------------------------------------------------- nproc | | use SAM formula | processes system wide ---------------------------------------------------------------------- shmmax | | see notes | >=0x10000000 (267MB) for 64bit RDBMS | | | >=0x2000000 (34MB) for 32bit RDBMS | | | undersizing gives ORA-00600 [SKGMINVALID] ---------------------------------------------------------------------- swapmem_on | 0 | see notes | see Note:68056.1 ---------------------------------------------------------------------- 如何对不规律的小数进行处理? 导出dmp文件,其中有些什么数据? oracle 每天自动重启服务 关于ORACLE8.0.5的问题 PL SQL 临时表使用策略问题 还是不明白Oracle返回值这一块,急用,大家帮忙吧 ************存储过程中能否使用分析函数?************* 为什么啊?? Oracle支持LEFT OUTER JOIN吗? 高手们,你们初学Oracle9i时是怎么安装的?教教我们吧!!!(高手在那??????) 所有的参数都可以在init.ora中设置吗? 真是怪了, 数据库连接出错ORA-01033:!期待大家解决。
是不是你的hp-ux的配置问题???
把打开文件数设大一点,500w左右。
操作系统共享内存分配:2147483648
数据库核心参数:
db_file_multiblock_read_count = 4k
db_block_size=4k
db_block_buffers = 158720
shared_pool_size = 262144000
processes = 200
dml_locks = 200
log_buffer = 524288×cpu个数
large_pool_size = 31457280
java_pool_size = 20971520
sort_area_size == 1048567
This note lists commonly misconfigured HP-UX kernel parameters.
parameter | default | recommended | notes ====================================================================== aio_max_ops | 2048 | 2048 | max no of queued AIO ops | | | See Note:139272.1 ---------------------------------------------------------------------- dbc_min_pct | 5 | 2 | min %age of system mem used | | | for buffer cache | | | (valid if nbuf = bufpages = 0) ---------------------------------------------------------------------- dbc_max_pct | 50 |ensure <= 128MB | max %age of system mem used | |used as cache | for buffer cache | | | (valid if nbuf = bufpages = 0) | | | Also see Note:62589.1 ---------------------------------------------------------------------- fsasync | 0 | 0 | async i/o on filesystems | | | See Note:139272.1 ---------------------------------------------------------------------- max_async_ | 50 | see notes | See Note:139272.1 ports | | | ---------------------------------------------------------------------- maxdsiz | 64MB | >=128MB | shadow process' heap size maxdsiz64 | 1GB | 1GB | ---------------------------------------------------------------------- maxfiles | 60 | >= 512 | soft limit | | | no of open files per process ---------------------------------------------------------------------- maxfiles_lim | 1024 | 1024 | hard limit | | | no of open files per process ----------------------------------------------------------------------- maxusers | 32 | no of Oracle | influences nproc, nfile, | | connections+64 | ninode, maxuprc ---------------------------------------------------------------------- maxuprc | 50 | maxusers*5 | no of procs per userid ---------------------------------------------------------------------- nfile | | use SAM formula | open files system wide ---------------------------------------------------------------------- nflocks | 200 | >= (200 + | file locks system wide | |(sum of db files | 8i onwards uses o/s file locking | |for all instances| undersizing will give | |) | HP-UX Error: 46: No locks available | | ) | ---------------------------------------------------------------------- nproc | | use SAM formula | processes system wide ---------------------------------------------------------------------- shmmax | | see notes | >=0x10000000 (267MB) for 64bit RDBMS | | | >=0x2000000 (34MB) for 32bit RDBMS | | | undersizing gives ORA-00600 [SKGMINVALID] ---------------------------------------------------------------------- swapmem_on | 0 | see notes | see Note:68056.1 ----------------------------------------------------------------------