What are ORA$AT_OS_OPT_SY_665 like 11g jobs?
in [Oracle]
|
Prev: 3 X 18 GB disks
Next: ORA-27086: skgfglk: unable to lock file - already in use -> Instance "BOCHUM", status BLOCKED
From: jstuglik on 1 Jul 2008 04:47 Hi. I'm having a problem with oracle 11g: Once in a while system runs jobs named something like in a title. Those are very resource intensive and in my case last for 4-5 minutes. During this time my application using this db keeps getting errors on trying to connect to a database or create a transaction. Can anybody tell me what are those jobs and if I can do anything about it to stop it from blocking my server? System parameters: Oracle version: Oracle Database 11g Release 11.1.0.0.0 - Production OS: Fedora release 8 (Werewolf), kernel: 2.6.23.1-42 Any help will be much appreciated. Kuba
From: Mladen Gogala on 1 Jul 2008 06:07 On Tue, 01 Jul 2008 01:47:07 -0700, jstuglik wrote: > 11g Release 11.1.0.0.0 Where did you get this version? On Canal St. in NYC? -- Mladen Gogala http://mgogala.freehostia.com
From: jstuglik on 1 Jul 2008 06:43 On 1 Lip, 12:07, Mladen Gogala <mgog...(a)yahoo.com> wrote: > On Tue, 01 Jul 2008 01:47:07 -0700, jstuglik wrote: > > 11g Release 11.1.0.0.0 > > Where did you get this version? On Canal St. in NYC? > > -- > Mladen Gogalahttp://mgogala.freehostia.com I'm not even from americe so it would be hard for me, wouldn't it? I got it from oracle's webpage. But you're right - I mistyped - should be: 11g Release 11.1.0.6.0 - 64bit Production
From: joel garry on 1 Jul 2008 12:54 On Jul 1, 1:47 am, jstuglik <jakub.stug...(a)gmail.com> wrote: > Hi. > > I'm having a problem with oracle 11g: > Once in a while system runs jobs named something like in a title. > Those are very resource intensive and in my case last for 4-5 > minutes. > During this time my application using this db keeps getting errors on > trying to connect to a database or create a transaction. > Can anybody tell me what are those jobs and if I can do anything > about > it to stop it from blocking my server? > > System parameters: > Oracle version: Oracle Database 11g Release 11.1.0.0.0 - Production > OS: Fedora release 8 (Werewolf), kernel: 2.6.23.1-42 > > Any help will be much appreciated. > > Kuba Search in the docs for: manage jobs I'm betting you will see some jobs scheduled that will answer your question. You might also poke around in the EM for it. jg -- @home.com is bogus. MetaLink V2 - Note Your query could not be performed due to technical reasons. Please return later.
From: Mladen Gogala on 1 Jul 2008 17:40
On Tue, 01 Jul 2008 03:43:57 -0700, jstuglik wrote: > I'm not even from americe so it would be hard for me, wouldn't it? I got > it from oracle's webpage. But you're right - I mistyped - should be: 11g > Release 11.1.0.6.0 - 64bit Production Why don't you turn on the trace and see what are those jobs doing. DBMS_MONITOR could probably help you with that. -- http://mgogala.freehostia.com |