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:
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 Vax
-- [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 to
of 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 advance
Roland
0 06 * * 6 d31/appl/konto/bat/laddabilbo.sh
/d31/appl/konto/log/laddabilbo.log 21
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
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
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
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
0 6 * * 6 /d31/appl/konto/bat/laddabilbo.sh
/d31/appl/konto/log/laddabilbo.log
21
__ 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 run only
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
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
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
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
[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]
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 DBA
[EMAIL
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 that is
)
[EMAIL PROTECTED] Asunto: RE: Cronjob
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
Roland
man crontab
--
--
Bill Shrek
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
: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 Anyway? )
Jared
:
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
Roland
man crontab
--
--
Bill Shrek Thater ORACLE
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 Wed, 24 Apr 2002
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]
cc:
Subject:Re: Cronjob
]
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] wrote:
Anyone whom can tell me how to delete a job
-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 installed
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: Re: Cronjob
]
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] wrote:
Anyone
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] wrote:
Anyone whom can tell me how to delete a job that is created by
crontab.
Thanks
: Asunto: RE: Cronjob
[EMAIL PROTECTED
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]
cc:
Subject:Re: Cronjob
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
crontab
? )
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 Wed, 24 Apr 2002, bill thater wrote:
[EMAIL
: [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!
1000 points if you can figure out why.
( guess I'm watching too much 'Whose Line Is It Anyway? )
Jared
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] wrote:
Anyone whom can tell me how
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]
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' /ops/scripts
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
0 5 *
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
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:
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
40 matches
Mail list logo
