Hello,
Has anyone ever tried setting dml_locks to zero or disabling table locks on
an OPS (2-node, 8.1.7.2.1, 32-bit; HP 11.0, 64-bit) as a way of reducing
contention and freeing up resources ? We currently use 7,250
dml_locks/instance. Oracle's OPS Admin manual (8i) had the following to say:
Ob
-- [EMAIL PROTECTED]
> Dear Tom,
> Would you send me example of the script. Because I'm new with VMS
> environment.
>
> thanks in advance,
This is gonna be living hell to deal with in DCL.
Suggestion: grab a copy of perl5 and use Schedule::Cron
to cycle the jobs with the vms-ish file system t
Dear Tom,
Would you send me example of the script. Because I'm new with VMS
environment.
thanks in advance,
Ahmadsyah
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 25, 2002 11:43 PM
> Ahmadsyah,
>
> If I remember correctly (my
Ahmadsyah,
If I remember correctly (my Vax is a couple of years old), we set up two
jobs to accomplish this. One job ran every day. All this job did was to
start the real job schedule job. the job schedule job interrogated what day
of the week it was and ran other jobs. For example, if today
tching too much 'Whose Line Is It Anyway?" )
Jared
Alex <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/24/2002 10:07 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: Cronjob
I wrote a DCL script called crontab that re-submits itself every day. In the script,
it checks what day it is and submits those jobs. A lot easier than running multiple
submit jobs. I need to change something, I goto the crontab, just like Unix.
Gene
PS. Each OS has its advantages, still lo
I have the same problem but with our vax/vms machine..
could I submit a job queue on every week or maybe every month...
$Submi/Noprin/Notif/Que=Parm_Deplan/log=[diga.digu]dige.log -
_$/After = "tomorrow+06:00" -
_$sys$geology:[diga.digu]dige.com
I usually submit que every day.. but I want to sub
Roland,
The crontab fields are defined as:
1 2 3 4 5 "program to execite"
1 = minutes after the hour 0-59
2 = hours of the day 0-23
3 = days of the month 1-31
4 = months of the year 1-12
5 = days of the week 0-6 0=Sunday
* = all possible values
0 6 * * 6 job to be run is placed here.
States
Roland,
Use the following command from the unix prompt:
man crontab
It'll tell you everything you need to know about changing the times of jobs
scheduled via cron. If you look it up and figure it out yourself, you'll
never need to ask about it again. However, if you just cut and paste
some
0 6 * * 6 /d31/appl/konto/bat/laddabilbo.sh
>/d31/appl/konto/log/laddabilbo.log
2>&1
__ www.cichomitiko.cjb.net __
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 25, 2002 1:43 PM
> Hallo,
>
> I would like to have this cronjob
Use vi.
-Original Message-
Sent: 25 April 2002 12:43
To: Multiple recipients of list ORACLE-L
Hallo,
I would like to have this cronjob run only in saturday mornings at 6 am. How
could I easy change this script?
0 18 * * * /d31/appl/konto/bat/laddabilbo.sh
>/d31/appl/konto/log/laddabil
man cron
man crontab
you really need to do some research on your questions before posting
--- [EMAIL PROTECTED] wrote:
> Hallo,
>
> I would like to have this cronjob run only in saturday mornings at 6
> am. How could I easy change this script?
>
> 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh
0 6 * * 6 /d31/app .
Look at man for crontab (on my linux it's man 5 crontab);
The time and date fields are:
field allowed values
- --
minute 0-59
hour 0-23
day of
0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh
>/d31/appl/konto/log/laddabilbo.log 2>&1
Samir
Samir Sarkar
Oracle DBA
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6028
EPABX : +44 (0) 115 - 957 6418 Ext. 76028
Fax : +44 (0) 115 - 957 6018
; > Alex <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 04/24/2002 10:07 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECTED]> cc:
> > Subject:
gure out why.
> ( guess I'm watching too much 'Whose Line Is It Anyway?" )
>
> Jared
>
>
>
>
>
> Alex <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 04/24/2002 10:07 AM
> Please respond to ORACLE-L
>
>
> To: Multiple reci
7
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 24, 2002 4:19 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject:Re: Cronjob
> >
> > crontab -e is bad!
> >
> > 1
'Whose Line Is It Anyway?" )
Jared
Alex <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/24/2002 10:07 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: Cronjob
crontab -e
On
)
> >
> >Jared
> >
> >
> >
> >
> >
> >Alex <[EMAIL PROTECTED]>
> >Sent by: [EMAIL PROTECTED]
> >04/24/2002 10:07 AM
> >Please respond to ORACLE-L
> >
> >
> >To: Multiple recipients of list O
>
> >Jared
> >
> >
> >
> >
> >
> >Alex <[EMAIL PROTECTED]>
> >Sent by: [EMAIL PROTECTED]
> >04/24/2002 10:07 AM
> >Please respond to ORACLE-L
> >
> >
> >To: Multiple recipients of list ORACLE-L
> &l
amoca"
lud.com.pe> cc: (cco: Ivan Llamoca/NOVASALUD)
Enviado por: Asunto:
t;
>Jared
>
>
>
>
>
>Alex <[EMAIL PROTECTED]>
>Sent by: [EMAIL PROTECTED]
>04/24/2002 10:07 AM
>Please respond to ORACLE-L
>
>
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>cc:
>Subject:R
ay?" )
>
> Jared
>
> Alex <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 04/24/2002 10:07 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
> Subject:
Come on, Jared, its more fun to:
crontab < /dev/null
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 4:19 PM
> To: Multiple recipients of list ORACLE-L
> Subject
> -e Edit the current crontab using the editor specified by the
>VISUAL or EDITOR environment variables. The specified editor must
>edit the file in place; any editor that unlinks the file and
>recreates it cannot be used. After you exit from the editor, the
>modified crontab will be instal
AIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/24/2002 10:07 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: Cronjob
crontab -e
On Wed, 24 Apr 2002, bill thater wrote:
> [EMAIL PROTECTED] w
f you can figure out why.
( guess I'm watching too much 'Whose Line Is It Anyway?" )
Jared
Alex <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/24/2002 10:07 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
g too much 'Whose Line Is It Anyway?" )
>
> Jared
>
>
>
>
>
> Alex <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 04/24/2002 10:07 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE
<[EMAIL PROTECTED]>
cc:
Subject:Re: Cronjob
crontab -e
On Wed, 24 Apr 2002, bill thater wrote:
> [EMAIL PROTECTED] wrote:
>
> > Anyone whom can tell me how to delete a job that is created by
crontab.
> >
> > Thanks in advance
> >
]
Web:www.compuware.com
-Original Message-
Sent: Wednesday, April 24, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Cronjob
crontab -e is bad!
1000 points if you can figure out why.
( guess I'm watching too much 'Whose Line Is It An
Title: RE: Cronjob
A wrong keystroke could blow away the entire crontab file by accident. %:|
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Cronjob
crontab -e is
list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: Cronjob
crontab -e
On Wed, 24 Apr 2002, bill thater wrote:
> [EMAIL PROTECTED] wrote:
>
> > Anyone whom can tell me how to delete a job that is created by
crontab.
> >
> > Thanks in adva
ASALUD)
[EMAIL PROTECTED] Asunto: RE: C
"man kill"
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 9:29 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Cronjob
>
> Anyone whom can tell me how to delete a job th
crontab -e
On Wed, 24 Apr 2002, bill thater wrote:
> [EMAIL PROTECTED] wrote:
>
> > Anyone whom can tell me how to delete a job that is created by crontab.
> >
> > Thanks in advance
> >
> >
> > Roland
> >
> >
>
> man crontab
>
>
> --
> --
> Bill "Shrek" Thater ORACLE DB
[EMAIL PROTECTED] wrote:
> Anyone whom can tell me how to delete a job that is created by crontab.
>
> Thanks in advance
>
>
> Roland
>
>
man crontab
--
--
Bill "Shrek" Thater ORACLE DBA
[EMAIL PROTECTED]
--
Hi James,Connor, Hallas, Hemant
Receive my heartfelt and sincere vote of thanx to you all for the brotherly
guidance - I solved this and promise to pay back by helping someone else out
there in turn.
Simon
-Original Message-
Sent: Saturday, March 23, 2002 7:33 AM
To: Multiple recipients
Simon --
One of the things that many people (even some of the more experienced unix
types) tend to forget is that cron doesn't source the user's profile. This is
why a script might work just fine from the prompt, but fail when submitted
through cron.
So, the solution would be either:
a)
Thanx.
A lot of development work is going on and I need a daily report on the
changes made in the packages. Recompiled Invalid objects suppliment my
report.
Ciao,
CSW
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 11:58 AM
To: Multiple recipients of list ORACLE
Set your Oracle environment as the first thing in the
cron job (typically by setting ORACLE_SID and calling
oraenv)
hth
connor
--- Simon Waibale <[EMAIL PROTECTED]> wrote: > Hi
all,
> Thanx for all the good work U R doing for Oracle.
> I have a misbehaving cronjob
>
> -Cron Entry
>
Title: RE: Cronjob misbehaving
It looks as if your ORACLE_HOME is not being set up.
Try either or both of the following
1) Amend your cron job to look like the following (I assume you are running this as user oracle)
0 5 * * * su - oracle 'usr/scripts/recompile.sh' >
Your CRON script should also define the ORACLE_HOME, ORACLE_SID and PATH.
Why do you need a CRON job to recompile database objects every day ? Why
are the being invalidated
every day ?
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
"Simon Waibale" <[EMAIL PROTECTED]>
42 matches
Mail list logo
