原帖由 lzj65166 于 2009-3-27 09:52 发表
你这样,你查看一下你运行的job任务,就是redhat上的。
不过这个问题你还真让我为难,这个你最好让你们的dba来处理,已经超出你的工作范围了,我给你一个大体的,你先查查。我不知道你对oracle会多少,sql语句的查询都会吧
SELECT ...
非常感谢你兄弟,真不好意思问了那么多问题来烦你。。。。
但是我们没有专门的dba...
所以所有都只有靠自摸。
我用了SELECT * FROM Dba_Jobs;查询结果节选如下
JOB LOG_USER PRIV_USER
---------- ------------------------------ ------------------------------
SCHEMA_USER LAST_DATE LAST_SEC
------------------------------ --------- --------------------------------
THIS_DATE THIS_SEC NEXT_DATE
--------- -------------------------------- ---------
NEXT_SEC TOTAL_TIME B
-------------------------------- ---------- -
INTERVAL
--------------------------------------------------------------------------------
FAILURES
----------
WHAT
--------------------------------------------------------------------------------
NLS_ENV
--------------------------------------------------------------------------------
MISC_ENV INSTANCE
---------------------------------------------------------------- ----------
0102000200000000 0
JOB LOG_USER PRIV_USER
---------- ------------------------------ ------------------------------
SCHEMA_USER LAST_DATE LAST_SEC
------------------------------ --------- --------------------------------
THIS_DATE THIS_SEC NEXT_DATE
--------- -------------------------------- ---------
NEXT_SEC TOTAL_TIME B
-------------------------------- ---------- -
INTERVAL
--------------------------------------------------------------------------------
FAILURES
----------
WHAT
--------------------------------------------------------------------------------
NLS_ENV
--------------------------------------------------------------------------------
MISC_ENV INSTANCE
---------------------------------------------------------------- ----------
JOB LOG_USER PRIV_USER
---------- ------------------------------ ------------------------------
SCHEMA_USER LAST_DATE LAST_SEC
------------------------------ --------- --------------------------------
THIS_DATE THIS_SEC NEXT_DATE
--------- -------------------------------- ---------
NEXT_SEC TOTAL_TIME B
-------------------------------- ---------- -
INTERVAL
--------------------------------------------------------------------------------
FAILURES
----------
WHAT
--------------------------------------------------------------------------------
NLS_ENV
--------------------------------------------------------------------------------
MISC_ENV INSTANCE
---------------------------------------------------------------- ----------
23 CMSUSER CMSUSER
JOB LOG_USER PRIV_USER
---------- ------------------------------ ------------------------------
SCHEMA_USER LAST_DATE LAST_SEC
------------------------------ --------- --------------------------------
THIS_DATE THIS_SEC NEXT_DATE
--------- -------------------------------- ---------
NEXT_SEC TOTAL_TIME B
-------------------------------- ---------- -
INTERVAL
--------------------------------------------------------------------------------
FAILURES
----------
WHAT
--------------------------------------------------------------------------------
NLS_ENV
--------------------------------------------------------------------------------
MISC_ENV INSTANCE
---------------------------------------------------------------- ----------
CMSUSER 27-MAR-09 09:06:29
JOB LOG_USER PRIV_USER
---------- ------------------------------ ------------------------------
SCHEMA_USER LAST_DATE LAST_SEC
------------------------------ --------- --------------------------------
THIS_DATE THIS_SEC NEXT_DATE
--------- -------------------------------- ---------
NEXT_SEC TOTAL_TIME B
-------------------------------- ---------- -
INTERVAL
--------------------------------------------------------------------------------
FAILURES
----------
WHAT
--------------------------------------------------------------------------------
NLS_ENV
--------------------------------------------------------------------------------
MISC_ENV INSTANCE
---------------------------------------------------------------- ----------
28-MAR-09
JOB LOG_USER PRIV_USER
---------- ------------------------------ ------------------------------
SCHEMA_USER LAST_DATE LAST_SEC
------------------------------ --------- --------------------------------
THIS_DATE THIS_SEC NEXT_DATE
--------- -------------------------------- ---------
NEXT_SEC TOTAL_TIME B
-------------------------------- ---------- -
INTERVAL
--------------------------------------------------------------------------------
FAILURES
----------
WHAT
--------------------------------------------------------------------------------
NLS_ENV
--------------------------------------------------------------------------------