Title: RE: RAC
Kay,
Can we get the Metalink note to run a single node RAC on Linux.
TIA
Suhen
-Original Message-
From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 22 July 2003 4:40 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC
Not required.. We
Suhen:
Check the Metalink note 166830.1 for the details.
KG
--- Suhen Pather [EMAIL PROTECTED] wrote:
Kay,
Can we get the Metalink note to run a single node RAC on Linux.
TIA
Suhen
-Original Message-
Sent: Tuesday, 22 July 2003 4:40 PM
To: Multiple recipients of list
Hi,
Thank you very much for your help, I can compile my program, but unfortulately
it doesn't work. I'd like to use ALERT to notify my program about an event.
Alert works, when I run two sql scripts in two sqlplus terminals. One of them is
listening for an alert and the other one sends an alert.
Dear all,
I am new to Oracle and I am trying to install OAS. Currently, I have
Oracle8i personal edition on my PC and I would like to install OAS... but I
can't figure out which version is suitable for the database.. Thanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
I am in the UK and usually i don't get any messages on this in-box until
the afternoon, until last week that is, thanks Bruce for the improved
service!!
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
iAS or OAS 4.0.8.x?
OAS came after OWS 3.0.1.
The products work with previous versions of the db usually, but here is a
list of roughly what database was current at the time each web server was
released.
OWS -- Oracle 7.3, last release was 7.3.4
OAS -- Oracle 8.0, last release was 8.0.6
iAS
CASE
select * from table gives 1000
records (say)
We want only first ten of these records to
be returned to the front end
then records 11 to 20 so on
How may the above be optimally possible ?
SQL or PL/SQL any for it ?
Thanks
Hi!
Definitely do NOT put your rollback segment tablespaces to non-raid disks,
if you don't want your database to be down in case of media failure. Also,
if your system has to be highly available, I wouldn't put anything except
maybe multiplexed online logs, archive logs and possibly some backups
Hi,
any chance that you let us know what your front end is?
Web? CS-Forms? fill_in_the_appropriate?
Come on, some more infos. Typing isn't that hard ;-)
[EMAIL PROTECTED] 22.07.2003 14.49 Uhr
CASE
select * from table gives 1000 records (say)
We want only first ten of these records
Title: Message
I have
that in place, except that since we are only doing virtual hosting by name, I
used an asterisk instead of an IP address in the tags.
i.e.
NameVirtualHost *
VirtualHost *
...
/VirtualHost
Patrice.
-Original Message-From: RAJESH DAYAL
[mailto:[EMAIL
Doing it my way just seems to be cleaner: why forcing exception, when
it could be avoided?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Alex Feinstein
Sent: Tuesday, July 22, 2003 1:44 AM
To: Multiple recipients of list ORACLE-L
RE: Who Says Oracle does not listenAgree.
On Tue, 22 Jul 2003, you wrote:
Hi Gyuri,
Why not dispense with the dbms_output in main() and simply use printf or
fprintf? If you want to keep it then you need to call
dbms_output.enable(100); before you call put_line, i have found that
you also need to call dbms_output.disable; first
Title: Message
I think with name based virtual hosting you have to have a different virtual
server name and diff IP Address (In port based virtual hosting you can have same
host names but can listen on different ports). The server has to be able to
listen on this new address (probably
Title: RE: Using ALERT in a ProC program
stupid_question
are you commiting after you send the alert? dbms_alert is transactional ...
/stupid_question
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views
Title: Message
From
the httpd.conf file...
###
Section 3: Virtual Hosts## VirtualHost: If you want to maintain multiple
domains/hostnames on your# machine you can setup VirtualHost containers for
them. Most configurations# use only name-based virtual hosts so the server
doesn't need to
Folks,
Unless I'm totally wrong I believe I remember seeing an article on DBMS_OUTPUT
on Metalink that specifically states that it's for use in SQL*Plus for debuging PL/SQL
programs only. Therefore it's rather useless anywhere else.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i
Title: Message
Help!
I have
a production and a test database, both with 3000mg RBS tablespaces with two
datafiles. Both have db_block_buffers set at 1000. The only
difference is the production db has 7rollback segments and thetest
db has 8. The rollback segments are sized at 50mg each on
SHOW PARAMETER performs a 'FIXED TABLE FULL' scan of x$ksppi and x$ksppcv. Exactly
what I would expect.
SHOW USER did not show up in the trace file, which tells me it is internal code path.
SHOW ALL did the same. I think that the difference is that PARAMETERs are database
level information,
-Original Message-
are you commiting after you send the alert? dbms_alert is transactional ...
Yes, of course I execute a commit after sending an alert. Here is my sql
script, that sends an alert:
set serveroutput on size 100
set echo off
set term on
set lines 80
DECLARE
message
During a recent tar I was told by an Oracle tech that Oracle windows
installs done by a domain user (versus local user) would not be
supported by Oracle. We used the domain acct (which is also an
administrator on the machine)so that it could see the tns_admin
directory on the network. We have not
Ron
I'm guessing that one of the loads receives the ORA-01555 and the other
doesn't. Does the load commit occasionally? There are some pretty good
papers on Metalink for this error.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent:
Ron,
Are the sizes of the data manipulated by the batch load the same?
Is the db_block_size the same on each database?
What is the size of the rbs during processing? What is the hwmsize, shrinks,
extends from v$rollstat?
You may be encountering a situation where
They are both processing the same data, the same way.
-Original Message-
Sent: Tuesday, July 22, 2003 10:15 AM
To: Multiple recipients of list ORACLE-L
Ron
I'm guessing that one of the loads receives the ORA-01555 and the
other doesn't. Does the load commit occasionally? There are
Thanks KG for the info . You guys rock .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 21, 2003 11:39 PM
AK:
Very much possible and very simple if you are using Linux or Windoze. I
think there is a note on Metalink with
Joe,
You can certainly use the doamin account; we do it all the time.
I am not sure why the TAR said this - but I can take a guess - generally the
domain users are not privileged enough. Oracle recommends using the
Administrator account to install anything for that reason.
HTH.
Arup Nanda
Snapshot too old also occurs when there is a commit across an open cursor.
Keep the commit on the outermost cursor in your PL/SQL (if you are using
PL/SQL) IN other words committing on the inside of a cursor FOR loop can
cause the cursor snapshot to be overwritten in rollback by activity on the
10gR4 will modify payroll and send me the check.
Jared
On Monday 21 July 2003 19:39, Mladen Gogala wrote:
10gR3 will read programmer's mind and automatically correct all design
errors. RDBMS 11T will look like Arnie Schwartzenegger (T is for
Terminator). I'll be back.
On 2003.07.21 22:04,
None whatsoever that we've seen. We've been running this way (until we can
convert our remaining TSs to LMT) for over a year now on 8.1.7.4 on HP/UX
11.0 32-bit.
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI
As our ops mgr is wont to say, he's on crack.
Nearly all of our Oracle installs on Win2k are by
a domain user that may also be a domain admin.
Never caused any problems, no one has ever asked.
Jared
On Tuesday 22 July 2003 08:04, Joe Armstrong-Champ wrote:
During a recent tar I was told by
Hi,
When I run ORDSYS.ORDImage.setProperties, I got this error:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: ld.so.1: extprocPLSExtProc: fatal:
/others/app/oracle/product/8.1.7/lib/libordim8.so: open failed: No such file
or directory
I don't have /others/app/ dir in my disk, my
I have ALWAYS used a local box admin account for installing and maintining
Oracle software in both NT and W2k.
Brad O.
-Original Message-
Sent: Tuesday, July 22, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L
Joe,
You can certainly use the doamin account; we do it all the
Ron - I think you are feeling that one system is good and the other is bad.
My suggestion is to consider one system at the ragged edge of failing and
the other system over the edge and in the ditch. Next week with a different
set of data, they may both well fail or both succeed. With ORA-01555
Hi there,
I am considering buying an administration tool and programmer's tool. The two
I know are Toad and BMC's XRAY but since I do not know them very well I have
difficulties deciding which of them is the best. What I need more is to tune the
database, trace into time and
Definitely. I just need input like that from those who use it! So far the input as
been far and few between...
I will work on getting the message bodies searchable and let the list know when
they're in there.
thanks,
bruce
- Original Message -
Hey Bruce,
Any possibility of making
Hi!
Yep, show user for example doesn't even generate any sqlnet traffic to
server. The username is retrieved by sqlplus once during logon using select
user from dual query.
One small detail is that when connecting as sysdba, no select user from
dual query is executed during logon, because you'll
Same here.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204
[EMAIL PROTECTED] 7/22/03 11:54:38 AM
As our ops mgr is wont to say, he's on crack.
Nearly all of our Oracle installs on Win2k are by
a
I don't think it is a good habit to get into...
When I set up Win2k boxes with Oracle the first thing I do is create a local
admin account named oracle.
Should be reason enough that if Oracle says they won't support a domain
account install there is probably a good reason for doing so. Unless
Greetings all,
I've set up my login.sql so that my prompt shows my username the sid of the db to
which I'm connected. This works well, but has made it tough to drag-select text b/c
now the first line sticks way out relative to the continuation lines, like so:
[EMAIL PROTECTED] select
Can RMAN backup a
database and leave any traces?
I have a client
site that was maintained with no
documentation and
now evaluating for how bad things
may
be.
We found an export
taking place, but no evidence
of anything else.
The alert.log shows NOTHING
as far as shutdown,
start up,
Title: RE: LMT
Nope. but my experience is strictly on 9i related to LMT
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts,
I haven't used DBXray (yet -- maybe it's not an automated process to
download a trial?), but I don't feel TOAD is the best at DB administration,
especially for performance tuning/monitoring. Then again, it's been awhile
since I've used TOAD's optional DBA module, since it's no longer available
in
The command is set sqlprompt.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, July 22, 2003 12:45 PM
To: Multiple recipients of list ORACLE-L
Greetings all,
I've set up my login.sql so that my prompt shows my username the sid of the db to
Hi!!!I am working with Visual Basic 6.0, Oracle 9.2i, and Crystal
Report 8.5
I made some recordset to feed my reports, they are working find, but my
problem nowis that I don't know how to made an instalation.
I made one with the Packge deployment wizard, but that installation
did not
Assuming that the first line support guy is correct, sure.
Personally, I would like to see it in writing, otherwise it's an urban
myth AFAIK.
URL?
Jared
Odland, Brad [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/22/2003 09:29 AM
Please respond to ORACLE-L
To: Multiple
Sure, just set the following (assuming 9i)
SET SQLNUMBER OFF
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 12:44 PM
Greetings all,
I've set up my login.sql so that my prompt shows my username the sid of
I got the impression that the question is if sql plus has the equivalent of
the Unix PS1, PS2, PS3, PS4 prompts.
-Original Message-
The command is set sqlprompt.
-Original Message-
Greetings all,
I've set up my login.sql so that my prompt shows my username
the
Try DevPartnerDB from us (Compuware). You can create profiles of execution
and compare one profile to another to optimize all of your code. Quite a
cool product.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email:
Mike,
One
other external source to look into is the udump directory. See if an
sbtio.log file exists. Sometimes, Rman will write logs into this
file. If the file doesn't exist, then it is another hint that rman has not
been used.
I
would say that if you can't find any Rman save sets
Title: Message
You
can try committing less frequently in the batch load e.g. if you are committing
every 1 rows then try every 3 (assuming of course that the you have
space left in the RBS to allow for this) or you can try adding rollback
segments.
Metalink docs give some good ideas
I think so too. I think sqlcontinue and sqlnumber is
what this guy is looking for.
-Original Message-
Sent: Tuesday, July 22, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L
I got the impression that the question is if sql plus has the equivalent of
the Unix PS1, PS2, PS3, PS4
I use the A) strategy for medium BD's with good
performance behavior, for the fragmentation issue a
good guide is the document:
How to stop fragmentation and start living.
you can find it in metalink..
regards,
Gabriel
--- AK [EMAIL PROTECTED] wrote:
At present we have one tablespace
ak,
I have located my indexes in different tablespaces according to size
of the index and catagory. Small indexes are in one tablespace with 4K
extents and medium in 1M extents with the large in 20M extends. The
tables that are partitioned also have the indexes partitioned. Some
tables span
For development, take a look at Allround Automations Pl/Sql Developer. Nice
functionality and an affordable price (~$50 in bulk).
http://www.allroundautomations.nl/
AM PST
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list
If the tables in the RMAN instance have not been populated they that
instance did not perform any backup functions. It is not to say that a
different instance on a distant server did not perform any RMAN backup
function.
Read the activity log posted at each server for activities on the
machine.
ORACLE DATABASE GETS NEW NAME | eWEEK
Whatever you do, don't call it 10i. The newest version of Oracle
Corp.'s database, which the company is trying to keep under a tight
lid until it's September OracleWorld debut, will reportedly be called
10G. That's apparently a way to pay homage to the
RMAN writes to the control file(s) when it runs. Try this:
SQL select view_name from dba_views where view_name like '%BACK%';
VIEW_NAME
--
DBA_ROLLBACK_SEGS
GV_$BACKUP
GV_$BACKUP_ASYNC_IO
GV_$BACKUP_CORRUPTION
GV_$BACKUP_DATAFILE
GV_$BACKUP_DEVICE
GV_$BACKUP_PIECE
Hi!
Make sure your extents are in size or multiples of
your block_size*db_file_multiblock_read_count. This might help in performance
when doing index fast full scans. Also, if you use striped disks, you might want
to match it with stripe width.
But number of extents doesn't cause any
OK, I got the e-mail to try a trial of DBXray from BMC. Crap, I tell you.
Crap. Crap, crap, crap. To be truthful, I'm not sure how much we pay for
Spotlight, but for $2500/user, DBXray has a LOT to be desired.
I've apparently been spoiled by Quest's Spotlight interface. After a
15-minute
I don't think Rich likes DBXray. looks like he's gonna pass on it.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, July 22, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
OK, I got the e-mail to try a trial of DBXray from BMC. Crap, I tell you.
That's right--I am looking for an analogue to PSx. I've been playing around
w/sqlcontinue sqlnumber but so far no joy. I'm using sql*plus 8.0.6.0.0 (running
against an 8.1.6 db).
Many thanks to all who responded.
Cheers,
-Roy
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Greetings,
How can I set the interval in my dbms job to have it run on the first
Wednesday of every month? Is this even possible? I have been trying to
noodle it thru for a week to no avail.
tia,
Josh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Josh Collier
Hi,
I got this error when process blob file:
ORA-01691: unable to extend lob segment ELI.SYS_LOB025110C2$$ by
100358 in tablespace DATA2
I added new data file for DATA2, but still the same error.
Please help!
Thanks,
Jack
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Josh Collier would like to recall the message, Job to run first Wednesday.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Josh Collier
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing
Hi, I just RTFM, squared away now.
Josh
-Original Message-
Sent: Tuesday, July 22, 2003 12:14 PM
To: Multiple recipients of list ORACLE-L
Greetings,
How can I set the interval in my dbms job to have it run on the first
Wednesday of every month? Is this even possible? I have been
Hopefully, not a pink one?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 22, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
10gR4 will modify payroll and send me the check.
Jared
On Monday 21 July 2003 19:39,
Title: RE: Job to run first Wednesday
SELECT NEXT_DAY(ADD_MONTHS(TRUNC(SYSDATE,'MM')-1,rnum-1),'WED')
FROM (SELECT ROWNUM rnum FROM ALL_OBJECTS WHERE ROWNUM 12)
/
for next 12 months including this month
Raj
Josh,
How about NEXT_DAY(TRUNC(LAST_DAY(SYSDATE)+1),'WEDNESDAY')+6/24? This
should run your DBMS_JOB's the first Wednesday of the following month at
6:00am.
Abey.
-Original Message-
Sent: Tuesday, July 22, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L
Greetings,
How can I
Reminds me of a song...
I can't remember, I can't recall.
I can't remember anything at all...
Patrice.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
I suggested using SET SQLNUMBER OFF. This sure works in SQL*Plus 8i and
above; not sure if it does in 8.0.6 and I don't have a test executable to
test it. But have you tried it?
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July
Message not able to be recalled from mailbox [EMAIL PROTECTED],
due to ORA-1555 snapshot too old.
Josh Collier wrote:
Josh Collier would like to recall the message, Job to run first Wednesday.
--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f:
What an interesting question.
Alright, DBMS_JOB needs a function which returns the date/time
on which the job will next run. Part of your function is to
take consider the next 31 days (in case the current run of the
job is somewhere random in the month and not on the first
Wednesday of the
Here's a bit of code that will always find the first wednesday of the
following month:
-- find the first wednesday of any month
alter session set nls_date_format = 'mm/dd/';
define testdate = '09/03/2003'
select
trunc(add_months('testdate',1),'mm') +
decode(
Steve,
Are you hoping for a frequent users discount like the airlines?
I did a google search on 'Dynamic Grid Computing' and there are
interesting concept discussed where grid computing is tested. It sounds
like all the computers are accessable at once and the one that has the
info needed
Color may be irrelevant, depending on amount.
Gogala, Mladen [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/22/2003 12:34 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: HP-UX
too late :)
Josh Collier [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/22/2003 12:29 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Recall: Job to run first Wednesday
Josh Collier would like
Hmm... much more elegant than mine, and everyone elses.
Guess I better RTFM the next_day function.
Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/22/2003 12:34 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
sqlcontinue changes the prompt for the continuation of a SQL*Plus command, not a SQL
command.
sqlnumber off will mean that instead of having number prompts on the continuation of a
SQL statement the SQL prompt will be continued (which I personally find annoying).
set sqlnumber off should
Isn't that SETI program that you can run on your PC an example of grid
computing? ... sort of.
-Original Message-
I did a google search on 'Dynamic Grid Computing' and there are
interesting concept discussed where grid computing is tested.
It sounds
like all the computers are
AK
The link for How to Stop Defragmenting and Start Living is here:
http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049
http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049
This is a classic paper and I consider it essential to carefully study this
paper before you embark on your
don't rush off to use it. I tried it, substituting August 1 and got
September.
1* select
next_day(last_day(to_date('08/01/2003','MM/DD/')),'WED') from dual
SQL /
NEXT_DAY(
-
03-SEP-03
--- [EMAIL PROTECTED] wrote:
Hmm... much more elegant than mine, and everyone elses.
Jared,
With your luck the check you refer to will be like the ckeck in a
restaurant. Don't forget the tip.
Ron
[EMAIL PROTECTED] 07/22/03 03:34PM
Hopefully, not a pink one?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July
If that's the impression, then no, there's only one, sqlprompt.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Tuesday, July 22, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L
I got the impression that the question is if sql plus has the
http://www.sysadminday.com/
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
Fat City Network
Jared,
Thanks a lot.
I use 8k block size, so you mean 100358 is block number and I need total
about 781Mb free space?
I have about 300Mb free space for DATA2.
Here is some info about this lob segment:
select segment_name, tablespace_name,segment_type,
bytes,extents,initial_extent, next_extent,
Title: RE: Who Says Oracle does not listen
Performance.
You do check, and the DBMS does check internally.
Alex.
-Original Message-
From: Igor Neyman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 22, 2003 6:34 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Who Says
or simply
SELECT NEXT_DAY(ADD_MONTHS(TRUNC(to_date('31-dec-2002'), 'MM')-1, 1),
'WEDNESDAY')
FROM dual
/
-Original Message-
Sent: Tuesday, July 22, 2003 3:50 PM
To: Multiple recipients of list ORACLE-L
Here's a bit of code that will always find the first wednesday of the
Rachel,
Yeah, Sept 3 is the first Wednesday of September (the next month). You
gotta read the memos :)
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, July 22, 2003 4:15 PM
To: Multiple recipients of list ORACLE-L
don't rush off to use it. I
Are you saying 03-SEP-03 is wrong?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Rachel Carmichael
Sent: Tuesday, July 22, 2003 3:15 PM
To: Multiple recipients of list ORACLE-L
don't rush off to use it. I tried it, substituting August 1 and got
September.
1* select
Rachel,
The assumption is that the current day is already = the first wednesday
of the month,
making it useful for the dbms_job interval.
Did you read the specs? :)
Jared
Rachel Carmichael [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/22/2003 01:14 PM
Please respond to ORACLE-L
The next_extent size on SYS_LOB025110C2$$ is about 800 meg.
Change the next_extent size to something smaller. RTFM on 'alter table'
if needed.
If you're using LMT's, then the minimum size to allocate is whatever the
uniform size
is on that tablespace, assuming it's been set up with
SETI isn't really a grid. It's just few specific servers that feed data to
lots of clients.
Here's a quite fine quote from gridcomputing.com:
Grid is a type of parallel and distributed system that enables the sharing,
selection, and aggregation of geographically distributed autonomous
resources
Jared,
If you will closely examine the specs, the assumption is not documented.
Therefore, the application code must take into account that the 1st Wednesday of the
month may still be in the future.
select CASE WHEN to_char(to_date('08/07/2003','MM/DD/'), 'DD') = 6
THEN
I think that if this schedule job is on unix platform, the cron job is easy
one. You only need to write a short script. Also in windows OS you can schedule
a job there.
Don
[EMAIL PROTECTED] wrote:
Rachel,
The assumption is that the current day is already = the first wednesday
of the
I did. he said I want to submit a job to run the first Wednesday of
the month
if he submits it the first time on August 1, it won't run until
September
--- Mercadante, Thomas F [EMAIL PROTECTED] wrote:
Rachel,
Yeah, Sept 3 is the first Wednesday of September (the next month).
You
gotta
it is if the job is submitted to the batch queue before the first
Wednesday in August
he wants the job to run the first Wednesday of every month. he didn't
say when he would submit the initial request.
I did read the specs. More carefully than everyone else it seems :)
we did an exercise
I was perusing a 10046 trace file and I noticed that timestamps are written to the
trace file. Sometimes they were very regular (3 minutes apart give or take 30 seconds)
while other times they were hours apart. I have noticed that two timestamps are never
written without any intervening
Title: RE: Who Says Oracle does not listen
In this case performance is not an issue.
I dont drop/create/modify
tables/columns/synonyms every minute. The script runs, when we install new
release of our product, happens once in a few months.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
Setting SQLNUMBER OFF will make the SQLPROMPT continuation prompt, not
completely eliminate it.
Isn't it what the OP wanted in the first place?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 3:59 PM
sqlcontinue changes the
I repeat. I read 'em. if he sets the interval to the next_day function,
and submits the job before the first Wednesday of the month IN THE SAME
MONTH, it won't run the first Wednesday of that month
--- [EMAIL PROTECTED] wrote:
Rachel,
The assumption is that the current day is already = the
It does appear wrong to me, maybe I am missing something.
if sysdate = August 1, then function should return August 6th (the first Wed
in August) not September 3. By this logic the job would not run in August.
Josh
-Original Message-
Sent: Tuesday, July 22, 2003 1:30 PM
To: Multiple
1 - 100 of 126 matches
Mail list logo