系统性能问题
1.服务器最大连接数:
<local-tx-datasource>? ? <jndi-name>jdbc/</jndi-name>? ? <connection-url>jdbc:oracle:thin:@172.16.100.18:1521:orcl</connection-url>? ? <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>? ? <user-name>TETD_QT</user-name>? ? <password>Hpoui&bmn$m#e$m_n20uytwe@iil</password>? ? ? ? <min-pool-size>10</min-pool-size>? ? ? ?<max-pool-size>20</max-pool-size> ?设置大? ? <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>2.数据库最大连接数 == 查看ORACLE连接数设置??SQL>select count(*) from v$process --当前的连接数显示为45SQL>select value from v$parameter where name = 'processes' --数据库允许的最大连接数显示为600#修改oracle最大连接数:alter system set processes = 1000 ?scope = spfile;重启数据库:shutdown immediate;startup;?