oracle如何查询和停止正在运行的job
原文地址：
http://blog.sina.com.cn/s/blog_60e4205e0100esaf.html
找出正在执行的JOB编号及其会话编号
SELECT SID,JOB from
DBA_JOBS_RUNNING;
停止该JOB的执行
SELECT SID,SERIAL# from
V$SESSION WHERE SID='&SID';
ALTER
SYSTEM KILL SESSION
'&SID,&SERIAL';
EXEC
DBMS_JOB.BROKEN(&JOB,TRUE);
实例分析：
1，查询正在运行的Job，通过查询有两个，和进程占用较多的是两个ORACLE进程符合。
SQL> SELECT SID,JOB from
DBA_JOBS_RUNNING;
SID JOB
----------
----------
12
116
16 117
2，查询正在运行的job的信息
SQL> SELECT SID,SERIAL# from
V$SESSION WHERE SID='12';
SID
SERIAL#
---------- ----------
12 4
SQL> SELECT SID,SERIAL# from
V$SESSION WHERE SID='16';
SID
SERIAL#
---------- ----------
16 1
3，利用查询出来的job信息将job结束掉
SQL> ALTER SYSTEM KILL SESSION
'12,4';
System altered.
SQL> ALTER SYSTEM KILL SESSION
'16,1';
System altered.
4，如果不希望运行上述job的话，可以将job设置为broken.
EXEC DBMS_JOB.BROKEN(116,TRUE);
EXEC DBMS_JOB.BROKEN(117,TRUE
相关文档：
每隔几秒钟listener日志中就出现一次该错误的记录，即使是在没有人使用的情况下也是如此，不过并没有发现客户端机器不能正常连接数据库的情况。
Oracle关于TNS-12502错误的解释:
Error: ORA-12502 / TNS-12502
Text: TNS:listener received no CONNECT_DATA from client
Cause: No CONNECT_DATA was ......
How to land your dream Oracle DBA job
By Don Burleson, Contributor
14 Jan 2010
If you look at the Help Wanted ads, some Oracle DBA jobs look very appealing, with salaries that rival those of engineers and other professionals. Some have starting salaries as high as $85,000, with senior Orac ......
The following items are available in the network listener configuration file (listener.ora).
* Listener Address Section
* SID_LIST_listener_name Static Service Section
* Control Parameters
The listener.ora file is located in $ORACLE_HOME/n ......
用户号码 登陆时间
1300000000 2010-01-01
1300000001 2010-01-01
1300000002 2010-01-02
1300000001 2010-01-02
1300000003 2010-01-03
1300000002 2010-01-03
1300000004 2010-01-04
1300000003 2010-01-04
1300000004 2010-01-02
1300000006 2011-01-04
1300000001 2011-01-04
剔除重复� ......
-- 序列操作 --
-- 创建序列
CREATE SEQUENCE u_sales_SEQ INCREMENT BY 1 START WITH 1 MINVALUE 1 NOCYCLE NOCACHE NOORDER;
-- 查出所有存在的序列
SELECT * from user_sequences
-- 删除序列
DROP SEQUENCE U_SALES_SEQ;
-- 查出下一个序列ID
SELECT U_SALES_SEQ. ......
