| Oracle Jobs are Not Running [message #422234] |
Tue, 15 September 2009 04:00  |
deep0983
Messages: 28
Registered: April 2009
|
Junior Member |
|
|
Hi Friend,
I am facing one problem regarding oracle jobs. i have created differnt jobs in my database for doint rotuine activity but now a days i am facing problem to start these jobs when i start these jobs in my database it will not allow any user to connect and if we run any query in our database it will take huge time to execute so that is why i have disabled all the jobs but i want to start this jobs as soon as possible. Below is entry of job trace file which was genrated by oracle.
*** 2009-09-14 13:39:27.052
*** SERVICE NAME:(SYS$USERS) 2009-09-14 13:39:27.036
*** SESSION ID:(102.1) 2009-09-14 13:39:27.036
Memory Notification: Library Cache Object loaded into SGA
Heap size 4842K exceeds notification threshold (2048K)
LIBRARY OBJECT HANDLE: handle=b9c068b4 mutex=B9C06968(0)
name=CPAMEMO53.DE_TEMPCASEDATA
hash=f4c77266c1b97063db4d748abe0e3733 timestamp=09-14-2009 13:39:26
namespace=TABL flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-001f-20bf lock=X pin=X latch#=2 hpc=0002 hlc=0002
lwt=B9C06910[B9C06910,B9C06910] ltm=B9C06918[B9C06918,B9C06918]
pwt=B9C068F4[B9C068F4,B9C068F4] ptm=B9C068FC[B9C068FC,B9C068FC]
ref=B9C06930[B9C06930,B9C06930] lnd=B9C0693C[B9C0693C,B9C0693C]
LOCK OWNERS:
lock user session count mode flags
-------- -------- -------- ----- ---- ------------------------
c666e038 ca32f334 ca32f334 2 X [00]
PIN OWNERS:
pin user session lock count mode mask
-------- -------- -------- -------- ----- ---- ----
c6269b18 ca32f334 ca32f334 0 2 X 00bf
LIBRARY OBJECT: object=c008ce7c
type=FNCT flags=EXS/LOC[0005] pflags=NST/SWR[0009] status=VALD load=0
DEPENDENCIES: count=45 size=48
dependency# table reference handle position flags
----------- -------- --------- -------- -------- -------------------
0 c008d238 c008cfd0 c2af42ec 0 DEP[01]
1 c008d238 c008d004 c9a7d5a4 0 DEP[01]
2 c008d238 c008d038 b9fb6770 27482 DEP[01]
3 c008d238 c008d06c b9b6a14c 27460 DEP[01]
4 c008d238 c008d0a0 b9e2f6b8 27448 DEP[01]
5 c008d238 c008d0d4 c2a65648 0 DEP[01]
6 c008d238 c008d108 c9867328 0 DEP[01]
please help on solving this problem.
Thanks in advance.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
