bbsanwei
- 浏览: 324672 次
- 性别:
- 来自: 深圳
-
最新评论
-
gaowei52306：
...
Ant常见属性解析--if-else -
myworkfirst：
${input.deploy.property.paths}& ...
Ant常见属性解析--foreach -
liuzl121：
顶一个 学习了
Cookie和Session专题 -
virtuallife：
正需要这个功能，试试~
Ant脚本中使用try-catch -
shutaodream：
，不错，学习
Oracle中to_char函数的用法
文章列表
查看Oracle连接数
- 博客分类：
- Oracle
OracleSQLJDBC.做数据库开发的时候，有时候会遇到连接超出最大限制的问题，这时候，我们需要查看数据库的连接数，下面说说如何查看Oracle的连接数
1.查看Oracle最大连接数
SQL>show parameter processes #最大连接数
2.修改最大连接数
SQL>alter system set processes=value scope=spfile
重启数据库
SQL>shutdown force
SQL>start force
3.查看当前连接数
SQL>select * from V$SESSION wh ...
http://bbs.chinaunix.net/thread-3615609-1-2.html
http://wutaoo.iteye.com/blog/94544
http://edison87915.iteye.com/blog/729203
异常处理
http://www.iteye.com/topic/72170
http://www.iteye.com/topic/11287
http://www.iteye.com/topic/10482
http://www.iteye.com/topic/2038
定时任务
http://www.iteye.com/topic/794865#1731735
http://www.iteye.com/topic/25267
h ...
http://www.iteye.com/topic/472333
http://www.iteye.com/topic/452650
http://www.iteye.com/topic/410718
http://catdoc.iteye.com/blog/776157
http://fehly.iteye.com/blog/662417
http://jayliu.iteye.com/blog/440191
http://guiqing85.iteye.com/blog/524937
http://zyx870805.iteye.com/blog/520161
http:/ ...
http://android.group.iteye.com/group/topic/21364
threadLocal
- 博客分类：
- JAVA
http://www.iteye.com/topic/777716
http://www.iteye.com/topic/71554
http://www.iteye.com/topic/81936
http://www.iteye.com/topic/179040
http://www.iteye.com/topic/608762
http://www.iteye.com/topic/179040
http://www.iteye.com/topic/608762
http://www.iteye.com/topic/82984
http://www.iteye.com/topic/10380 ...
http://www.iteye.com/topic/305642
http://www.iteye.com/topic/349784
http://www.iteye.com/topic/170620
http://www.iteye.com/forums/tag/SOA
http://www.iteye.com/forums/39/search?page=2&query=RPC
http://www.iteye.com/topic/676045
http://www.iteye.com/blogs/tag/Hibernate
------------------ ...
http://hi.baidu.com/zhengenyang/blog/item/e62460228696e8a54723e875.html
http://blog.csdn.net/kkdelta/archive/2010/04/20/5507799.aspx
http://www.iteye.com/topic/483115
http://www.blogjava.net/jerry-zhaoj/archive/2008/11/26/242846.html
http://sailinglee.iteye.com/blog/433097
http://www.blogjava.net/mlzry0612/articles/185170.html
TimeZone
http://www.iteye.com/topic/13720
http://www.iteye.com/topic/102937#338220
http://www.iteye.com/topic/585412
http://archives.postgresql.org/pgsql-jdbc/2008-01/msg00056.php
http://www.iteye.com/topic/159131
http://www.ibm.com/developerworks/cn/java/l-datetime/part2/index.html
http://ww ...
http://www.iteye.com/topic/221662
http://users.belgacombusiness.net/arci/
http://www.iteye.com/topic/39112
log4j
http://www.iteye.com/topic/378077?page=2
http://www.blogjava.net/kxx129/archive/2006/10/10/74280.html
http://buaawhl.iteye.com/blog/6450
http://www.blogjava.net/justfly/archive/2009/02/27 ...
1、修改Oracle最大连接数的方法
a、以sysdba身份登陆PL/SQL 或者 Worksheet
b、查询目前连接数
select count(*) from v$session #连接数
Select count(*) from v$session where status='ACTIVE' #并发连接数
show parameter processes #最大连接
c、更改系统连接数
alter system set processes = value scope = spfi ...
package test.com;
import java.text.SimpleDateFormat;
import java.util.*;
public class Test {
public static void main(String[] args) {
List<Account> list = new ArrayList<Account>();
Calendar c = Calendar.getInstance();
c.add(Calendar.SECOND, 1);
Date date = c.getTime ...
游标是SQL的一个内存工作区，由系统或用户以变量的形式定义。游标的作用就是用于临时存储从数据库中提取的数据块。在某些情况下，需要把数据从存放在磁盘的表中调到计算机内存中进行处理，最后将处理结果显示出来或最终写回数据库。这样数据处理的速度才会提高，否则频繁的磁盘数据交换会降低效率。
Oracle中的游标有两种：显式游标、隐式游标。
显示游标是用cursor...is命令定义的游标，它可以对查询语句(select)返回的多条记录进行处理，而隐式游标是在执行插入(insert)、删除(delete)、修改(update)和返回单条记录的查询(select)语句时由PL/SQL自动定 ...