OraFAQ Forum: Server Administration » Oracle Jobs are Not Running

Home » RDBMS Server » Server Administration » Oracle Jobs are Not Running (oracle,10.2.0.1.0,Window Server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: Oracle Jobs are Not Running [message #422240 is a reply to message #422234]

Tue, 15 September 2009 04:26

Michel Cadot
Messages: 68665
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

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

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So nothing strange just optimize your job or limit its work.

Regards
Michel

Report message to a moderator

Re: Oracle Jobs are Not Running [message #422253 is a reply to message #422234]

Tue, 15 September 2009 04:51

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.

Report message to a moderator

Re: Oracle Jobs are Not Running [message #422256 is a reply to message #422253]

Tue, 15 September 2009 05:06

Michel Cadot
Messages: 68665
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

Report message to a moderator

Previous Topic:	Process & Session
Next Topic:	Addition of datafile (merged 3)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 00:46:55 CDT 2024