Home » RDBMS Server » Server Administration » Oracle Jobs are Not Running (oracle,10.2.0.1.0,Window Server 2003)
Oracle Jobs are Not Running [message #422234] Tue, 15 September 2009 04:00 Go to next message
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.
Re: Oracle Jobs are Not Running [message #422240 is a reply to message #422234] Tue, 15 September 2009 04:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And does this job do?
I bet it takes all server resources.

By the way, the trace file has nothing to do with your problem.

Regards
Michel

[Updated on: Tue, 15 September 2009 04:28]

Report message to a moderator

Re: Oracle Jobs are Not Running [message #422241 is a reply to message #422240] Tue, 15 September 2009 04:29 Go to previous messageGo to next message
deep0983
Messages: 28
Registered: April 2009
Junior Member
This refresh oracle database yes you are right it take all my database resources.

[Updated on: Tue, 15 September 2009 04:31]

Report message to a moderator

Re: Oracle Jobs are Not Running [message #422252 is a reply to message #422241] Tue, 15 September 2009 04:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So nothing strange just optimize your job or limit its work.

Regards
Michel
Re: Oracle Jobs are Not Running [message #422253 is a reply to message #422234] Tue, 15 September 2009 04:51 Go to previous messageGo to next message
deep0983
Messages: 28
Registered: April 2009
Junior Member
Thanks for your reply but when i run this job manually it run succesfully without any problem.
Re: Oracle Jobs are Not Running [message #422256 is a reply to message #422253] Tue, 15 September 2009 05:06 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As we have no information on what it does and what happens we can give no help.

Regards
Michel
Previous Topic: Process & Session
Next Topic: Addition of datafile (merged 3)
Goto Forum:
  


Current Time: Wed Dec 07 08:39:53 CST 2016

Total time taken to generate the page: 0.13071 seconds