It was talked on the list and had been said that 1% of performance it
affects nearly as I remember.
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 02, 2002 4:23 AM
Do you guys think making times statistic =true has any
Check if the processor is P4.
If so , you must replace the symcjit.dll and jvm.dll with the ones in 9i
CD.
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 02, 2002 12:03 AM
One of our developers is having a problem
I didn't mean to be so stiff on the reply -- sorry for that...
You are excused...
Just kidding. :-) I didn't mean that either - my apologies.
And you may be very right on the political perspective. What's done is done.
It could be not the right time for late general setups, but analysis is
Oracle9i New Features is pretty much concise and descriptive at the same
time. Good Job!
I used Oracle8i New Features For Administrators Exam Cram and found it a
helpful resource. Thanks!
Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Hallo,
anyone who has a good example on how to write in the crontab if you want to schedule a
job to run every four week.
Is it possible to do that in unix cron job schedule.
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL
I had a problem.
Trying to drop a column from a Oracle 8i Table (personal edition on a
w2kPro) i got the following message (or similar) you can't drop a table
with 8.0.5 compatibility, you need at least 8.1.0. !
Ok, i changed compatibiliy parameter from 8.0.5 to 8.1.0 (using dba studio)
and all
I had experienced a similar thing too. But I had opened the database with
the compatible parameter database needed to startup..
Try to change the compatible parameter in my opinion to open the database.
,
Bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Jared's passion to regular expessions is understandable after book Perl for
Oracle DBAs :)
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 02, 2002 8:03 AM
Yes, but not nearly as flexible as owa_pattern, and infinitely
more
Hallo,
anyone who has a good example on how to write in
the crontab if you want to schedule a job to run
every four week.
Is it possible to do that in unix cron job
schedule.
Thanks in advance
Roland
Roland,
Please, just for once, couldn't you try to figure out things by yourself and
anyone who has a good example on how to write in the crontab if you want to schedule
a job to run every four week.
Is it possible to do that in unix cron job schedule.
Yes, it is very possible.
Run 'crontab -e' as apropeate user. Your $EDITOR will open.
Write as described in crontab(5)
Hi gurus,
I have a query..Basically we have an OPS set up here (8.0.6) and I have
noticed that the scn on node A is 500 and the scn on node B is 2000. I am
concerned about this w.r.t recovery- surely this would be an issue ??I
logged a call with oracle and they said it wasnt an issue, but then
On metastink check out NOTE:131299.1. This has detailed instructions for three
different work arounds.
Dave
-Original Message-
Sent: Monday, July 01, 2002 8:27 PM
To: Multiple recipients of list ORACLE-L
Hi
I am guessing that he has a P4 cpu in the system and you need to do the
Hi
I would like someone out there to give me a name of a good book and
websites where I can learn more about Replication. From configuration
(setting up replication) to solving problems (conflict resolutions /
trouble shooting).
Please any website and good book. I am involved in big project and
First
off - thanks to Chris and Alexandre for their helpful input on the subject of
iFS.
Brief
question - does anyone know of the status of SQL as an interface to iFS? I know
this has been promised, but whether delivered yet I just don't
know...
thanks,
peter
edinburgh
.
Oracle Distributed Systems
by Charles Dye
Published by O'Reilly
ISBN: 1-56592-432-0
Also check the online docs for the replication sections.
Dave
-Original Message-
Sent: Tuesday, July 02, 2002 8:13 AM
To: Multiple recipients of list ORACLE-L
Hi
I would like someone out there to
We have a couple of new applications in development that are moving to QA.
These databases are currently running 9.0.1.2 on Sun Solaris 2.6. We've
been pretty happy with this version to this point but are at a pivotal spot
in our product development cycle where we have a narrow window in which
Guess who did?
MetaLink V2 - Note
An error occured while trying to query the system.
Please try again later
[CODE : -12541 ]
Be careful what you wish for, you just might get it!!
Dick Goulet
--
Please see the official ORACLE-L FAQ:
Cherie,
For the most part I don't like using version X.0 at any point. Now in
version 8, I did get onto 8.0.5, but I did wait for the .5 to show up. With 8i
it's 8.1.6 that was our baseline although I'm a lot happier with 8.1.7. For 9i
I won't touch anything before 9.2, which is waiting
Peter,
I'm not sure what do you mean by the SQL interface
for iFS. Can you elaborateor give some links to resources?
afaik, iFS is created to store non-relational data.
However, this is mapped to relational schema in DB where iFS stores all the
information. There are also some Views created
Dick,
Thanks for your comments. So, the bottom line is that you are
recommending moving from 9.0.1.2 to 9.2?
Cherie
[EMAIL PROTECTED]
Please don't use 'crontab -e', unless you are saving your
crontab files and using some form of version control on them.
'crontabe -e' is inherently dangerous, as it is too easy to remove
lines unintentionally, and then they are gone for good.
Jared
On Tuesday 02 July 2002 04:28, Nils Höglund
For those of you in the Oracle Partner program, here's what looks like another
little bug to add to the 'Unbreakable' list...
Log into the Oracle partner network at http://oraclepartnernetwork.oracle.com/
and look for the Product Query Tool under 'Pricing' - It gives the cost of the
various
-- [EMAIL PROTECTED] on 07/02/02 00:43:19 -0800
Hallo,
anyone who has a good example on how to write in the crontab if you want to
schedule a job to run every four week. Is it possible to do that in unix cron
job schedule.
Monthly is doable. Every 28 days requires using at,
or a more
-- Nils Höglund [EMAIL PROTECTED] on 07/02/02 03:28:20 -0800
0 */4 * * * your_command
$ man 5 cronttab;
The time and date fields are:
field allowed values
- --
minute 0-59
hour
Hi,
You should not compare tkprof outputs with V$SQL,V$SQLAREA. Because,
recursive/child statistics are included in their parent statements in these
views. But, tkprof substructs recursive statistics. I mean tkprof reports real
values for statements, but dictionary doesn't.
regards...
Orr,
http://www.superscripts.com/tutorial/crontab.html
On Tue, 2 Jul 2002 [EMAIL PROTECTED] wrote:
Hallo,
anyone who has a good example on how to write in the crontab if you want to schedule
a job to run every four week.
Is it possible to do that in unix cron job schedule.
Thanks in advance
Cherie,
Before any upgrade I consider whether or no I really need it. For
mission critical application it would be wise to stick with what you have,
unless you have problems with it.
Now we have 9.0.1.2 in production and 9.1.3 in development and I don't
intend to move to 9.2 in nearest
Cherie,
First off, I had no plans to ever use 9.0 anywhere other than test to see
what was new. In your case your already on 9.0.1 and appear happy with that.
Given that you could deploy o 9.0.1 or upgrade to 9.2 now and hope for a longer
time before the next upgrade. Personally I'd make
Fawzia,
Oracle it self will keep an eye on that also. It will kick the other instance
if it falls behind. So that the redo file will be switched.
Anjo.
Malik, Fawzia wrote:
Hi gurus,
I have a query..Basically we have an OPS set up here (8.0.6) and I have
noticed that the scn on node A
OJNK? Your term Larry? Or do I need to RTFM?
Didn't realize this had a name.
Jared
On Wednesday 26 June 2002 18:48, Larry Elkins wrote:
Greg,
When the situation is appropriate, and I don't want a correlated approach,
I will typically use the hash aj as illustrated by your second
Hi All,
We are trying to install RAC on LINUX Cluster and have gotten a long way,
however when the DBCA tries to create the database we get ORA-03113
(end-of-file on communication channel).
We are sort of lost for ideas and hope that you guys(m/f) have already
struggled your way through the
Title: RE: Unix - scheduling
Is a strick 14 day rule absolutely necessary, if not...a much more hassle free way would be to
simply schedule the cronjob to run on the 1st and 15th of each month, i.e.
# Min Hr Day Mon WkDay Command
0 0 1,15 * * script
-Original Message-
From:
Hello Cherie
I think that I saw somewhere that support for 9.0.1 will go away
about June 2003 while support for 9iR2 will be until 2005.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 02, 2002 4:53 PM
Dick,
Roland,
crontab alone will not meet your needs. Hint: check the date command and
MOD type fuctionality in a shell script.
Good luck,
Mike
-Original Message-
Sent: Tuesday, July 02, 2002 6:14 AM
To: Multiple recipients of list ORACLE-L
Hallo,
anyone who has a good example on how to
Hi,
We are currently testing our application on 9.0.1.2 and it looks stable except some
bugs with function based indexes.
Is it advisable to move to 9.0.1.3 (as it is terminal release of 9.0) or 9.2 which is
just released 2 months back (and may have some bugs)
OR 9.0.1.2 is stable enough
The choice should be between 9.0.1.3 + patch 2121935 or 9.2. The patch is to fix a
serious, serious security problem with ANSI-style joins.If you feel the need to
go to 9i, I'd choose the latter. I don't think 9.2 has been out long enough.
Ian MacGregor
Stanford Linear Accelerator
I have some people who are asking about 3'rd party data extraction tools to
pull data from Oracle into text files for loading a data warehouse. I am
not sure what the size of the project is but I think it is pretty big. The
DW is Terradata. Anyway, they are stating Oracle tools are too slow.
Oracle version 9i release 2
LINUX RH7.3
===
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze
Cherie,
I agree with Dick. As long as you have time to install 9.2 on your
development machine and assure yourself that it, at least, does not hurt
you, I would go with 9.2 now just to give yourself breathing room for the
next year or so.
If you stick with 9.0, you know that you will begin to
He specified that 0 */4 * * * would cause it to run every 4 hours. He provided an
example.
-Original Message-
Sent: Tuesday, July 02, 2002 11:13 AM
To: Multiple recipients of list ORACLE-L
-- Nils Höglund [EMAIL PROTECTED] on 07/02/02 03:28:20 -0800
0 */4 * * * your_command
$
Title: RE: Unix - scheduling
U...think they slipped something into my Mountain
Dew while I wasn't looking so that they could
log
into production directly via SQL*Plus and make some manual changes...I must have
still been
regaining my senses when I sent this...sorry
:)
-Original
0 */4 * * * your_command
The */4 must be linux. This is not available on HP-UX 11.0.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're sober.
--William Butler
Yeats.
Title: RE: Unix - scheduling
Hello Gurus,
Does
anybody have a script to locate objects/segments within a file? I have a
tablespace that spreads into several files, but there is one of this files that
is hot. I would like to know which objects reside in this file. The
Oracle version is HP
try desc dba_tables dba_indexes
Guerra, Abraham
I found couple redo logs in my Oracle8.0.5 database, as shown they are
switched every 5 minutes. I'd like to have only two or three logs out there
and don't want them to be switched until every 4 hours. Is there a way to
control it that way?
Secondly, if redo log switchs every 5 minutes,
Title: Message
He
wanted every 4 weeks -
-Original Message-From: Richard Huntley
[mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002
11:58 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Unix - scheduling
Is a strick 14 day rule absolutely necessary, if
I'd agree with Ian, because (at-least) on AIX, pre 9013 versions had smon
leak, clob leak problems.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't
1. If you have bug 1210242, then using timed_statistics=true will have a
profound impact upon performance. Get a patch, and then go to 3.
2. If you use an HP-UX release older than release 10, then using
timed_statistics=true will have a profound impact upon performance.
Upgrade HP-UX, and then
Aww, come on, crontab -e isn't that bad! The most dangerous thing
about it is accidentally running crontab -r instead of -e. Using crontab
-e is no worse than using a wildcard with the rm command, i.e. 'rm a *'
instead of 'rm a*'. One deletes all files that start with 'a', the other
Sigh. There are way too many packages in Oracle. Thanks Jared. I have to
share this with a developer struggling to write some parsing functions.
I'll take back all the bad reviews I posted on bookpool.com about your
book...
-Original Message-
Sent: Tuesday, July 02, 2002 12:57 AM
To:
Title: Message
Possible could use at, and have the job re-schedule
itself for 4 weeks when it first starts - just a thought
-Original Message-From: Richard Huntley
[mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002
11:58 AMTo: Multiple recipients of list
Roland,
I'm assuming that every 4 weeks means every 28 days which means same day
of the
week (Every 4th Friday for example)
If this meets your requirements then you can try the suggestion at this
link:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x1b397b8d1de3d5118ff40090279
cd0f9,00.html
Did Oracle back port the patch to fix the ANSI-style jonn bug to 9.0.1.2? This bug
allows one to read any table in the database despite the permission set.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 02, 2002 8:23 AM
To:
My sincere and humble apologies to Rachel, if my earlier email has offended
her. That was not the intention. I believe myself and others that tease
and pick on Rachel, do it out of respect and love for her, and would never
intentionally mean to offend her.
I do not know about other locations
They made changes to MetaLink over the weekend, I cannot search for my own
TARs because of the country code.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
I'm pretty sure this has not been done...
NOBODY(!) should be on 9012 in production - unless
you're happy with zero security. As well as the
reading-anything as Ian points out, with a little bit
of playing around its also possible to destroy any
data in the database (since a view is updatable
Sometimes a full table scan is better than an index lookup. Sometimes not.
Kevin Kennedy
First Point Energy Corporation
-Original Message-
Sent: Monday, July 01, 2002 6:27 PM
To: Multiple recipients of list ORACLE-L
My queries are running exceptionally good with a rule based
Folks,
Since good old MetaSh t is once again having problems, as well as the help
line I need to know if any of you have run into the following before:
PENGUIN:8.1:SYS alter package utl_tcp compile body;
alter package utl_tcp compile body
*
ERROR at line 1:
ORA-06544: PL/SQL: internal
You just can't forget about that dbms_output/trigger thing, can you? ;)
Jared
Grabowy, Chris [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/02/2002 10:51 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
If you can't do things carefully, you probably won't
make it too long as a DBA anyway.
Not using 'crontab -e' *is* being careful. :)
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/02/2002 10:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
Really? I didn't realize you were on the advance copy list. :)
Jared
Grabowy, Chris [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/02/2002 10:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
I tried to run LogMiner to view transactions on Oracle8.0 using LogMiner and
received following errors. Can someone please help me to fix errors. This
is HIGH priority that I am working to try to find out who messed up our
database per my Manager.
SQL begin
2 sys.dbms_logmnr.start_logmnr(
And that package would be... ?
Jared
K Gopalakrishnan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/01/2002 01:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: system event waits
John:
SQL desc dbms_system
PROCEDURE DIST_TXN_SYNC
Argument Name TypeIn/Out Default?
-- --- --
INST_NUM NUMBER IN
PROCEDURE KCFRMS
PROCEDURE KSDDDT
PROCEDURE
My note must have been missing the smiley
but you guys WERE picking on me :) (MOO make him stop!
G)
--- Grabowy, Chris [EMAIL PROTECTED] wrote:
My sincere and humble apologies to Rachel, if my earlier email has
offended
her. That was not the intention. I believe myself and
Perl is very fast, very flexible, and quite inexpensive. :)
See my post earlier today that includes the TOC from
Perl for Oracle DBA's
Jared
Post, Ethan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/02/2002 09:28 AM
Please respond to ORACLE-L
To: Multiple recipients of
ok, ok...were even.
-Original Message-
Sent: Tuesday, July 02, 2002 1:13 PM
To: [EMAIL PROTECTED]
Cc: Grabowy, Chris
You just can't forget about that dbms_output/trigger thing, can you? ;)
Jared
Grabowy, Chris [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/02/2002 10:51 AM
-- Ron Thomas [EMAIL PROTECTED] on 07/02/02 09:03:26 -0800
0 */4 * * * your_command
The */4 must be linux. This is not available on HP-UX 11.0.
Introduced by Paul Vixie into vixiecron, subsequently adopted
by a number of cron implementations. HP's is, unfortunately,
not one of them.
Hi,
We are testing our application on 9.2 and getting errors using Microsoft ODBC Driver.
we are having MDAC 2.7 installed on the machine.
Is anyone also encountered some errors using 9.2 with Microsoft odbc driver and how u
reslove the issues??
Thanks
--Harvinder
--
Please see the official
Wild guess dbms_system.KCFRMS ?? If it is true, thanks to Kirti ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
Fawzia, What are you querying to get the SCN
information. I would also be curious where you read
about the recovery issues in OPS environment? Oracle
maintains what is called a snapshot SCN and global
SCN. The snapshot SCN is usually maintained in the SGA
and the global SCN is maintained by the
Could be a Euro conversion problem. I do remember that Oracle had not
completed much of this work in time.
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original
I recently moved from one server to another and found that many of the
system object where invalid. I reran catalog.sql and catproc.sql and this
corrected the problems for me... give that a try.
Melanie
-Original Message-
Sent: Tuesday, July 02, 2002 1:05 PM
To: Multiple recipients of
DBMS_SYSTEM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 02, 2002 12:19 PM
And that package would be... ?
Jared
K Gopalakrishnan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/01/2002 01:53 PM
Please respond to
-- Hand, Michael T [EMAIL PROTECTED] on 07/02/02 08:13:32 -0800
Roland,
crontab alone will not meet your needs. Hint: check the date command and
MOD type fuctionality in a shell script.
The at command will normally take number of days from now
as the when to run argument. Simply have the
Your country code, my country code. I guess we're all One Big Happy World
under Oracle, because I can't work on any of my TARs, either. (Don't even
axe why *I* have to work on them...)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech
I would say it is unbreakable. Can't break what's already broke.
-Original Message-
Sent: Tuesday, July 02, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L
In other words, it is unbreakable. Can't get in... Can't break in...
Thank You
Stephen P. Karniotis
Product Architect
In other words, it is unbreakable. Can't get in... Can't break in...
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Tuesday, July 02,
Wild guess dbms_system.KCFRMS ?? If it is true, thanks to Kirti ...
No luck using this one on 8.1.6/8.1.7/9.0.1... Any gotchas?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Kanagaraj
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
not available on Sun (vers 5.8) - just tried it. nor Digital UNIX.
cool though ;-)
-Original Message-
Sent: Tuesday, July 02, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L
-- Ron Thomas [EMAIL PROTECTED] on 07/02/02 09:03:26 -0800
0 */4 * * * your_command
The */4
I'm trying to recover from an install that bombed. The final step in
the install, and the only step that I still need to perform, was to
execute a configuration assistant for Oracle9i's built-in HTTP
listener. For the life of me, I can't figure out the executable name
to invoke the HTTP
Jared,
Point taken. So I guess I like to live on the edge a little... :)
I've been using crontab -e for years without problems though. knock on
wood.
Alan
Here is the original reply ...
From: Deshpande, Kirti
Date: Thu, 20 Jun 2002 14:35:36 -0500
Subject: RE: DBMS_SYSTEM.KSDWRT question
Addition:
DBMS_SYSTEM.KCFRMS - resets counters displayed by MAX_WAIT in
V$SESSION_EVENT, and MAXIORTM, MAXIOWTM in V$FILESTAT views.
- Kirit
I do not
I'm on 8.1.6.2, Solaris 2.6.
All the unidentified sessions were active but had no SQL associated with
them.
Jay Miller
-Original Message-
Sent: Tuesday, July 02, 2002 3:43 PM
To: '[EMAIL PROTECTED]'
We just had a problem on our datawarehouse where we hit the maximum number
of
The */4 must be linux. This is not available on HP-UX 11.0.
It works on BSD-systems too.
--
/Nils Höglund, Naqua KB
E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18 30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav.
The */4 must be linux. This is not available on HP-UX 11.0.
Introduced by Paul Vixie into vixiecron, subsequently adopted
by a number of cron implementations. HP's is, unfortunately,
not one of them. Sun's might, AIX doesn't.
It does not work on Solaris 8.
--
/Nils Höglund, Naqua KB
Title: Accessing views across a db link
Accessing a view across a db link takes a while (fetch phase) when a *local* select statement uses a where clause (e.g. select * from view_name@remotedb where columnA = '...';). Does anyone know a way (other than a snapshot or materialized view of the
Sigh, There are many answers to this question related
to the environment you will be deploying into. It
sounds like you are actually maintaining many
databases. Are all of them really 24x7 (i.e. less than
a minute of downtime per year) or can you schedule
maintenance in the future that will not
He wanted every 4 weeks -
Whoops! I miss-read.
Thanks for the correction!
--
/Nils Höglund, Naqua KB
E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18 30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
David,
Based on the ls output it seems you may have 4 groups with 1 member in groups 1,2 4
but 3 members in group 3.
Do a select * from v$log; and see how the logs are really setup.
I would suggest you want to have the same number of members in each group.
If you want them to switch less
Raj,
Thanks for the help, but in this case I need to first wash a little egg off
of my face. The problem here was at least was easily recoverable. What had
happen was we moved a database instance from one machine to another. It's
cheaper to run two instances on one box that pay Oracle for
Alan,
This query should be resolved at the remote end. I forget which
version of Oracle was the first to know enough to do that.
Which version are you on?
Have you traced the SQL?
Jared
Martin, Alan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/02/2002 02:28 PM
Please respond to
It does not work on Solaris 8.
SunOS (a.k.a. BSD) used vixiecron; they dumped it when
Solaris went SVR4. You can still find workable copies
of Paul's original work (pretty ancient by now).
Alternative it to use perl with Schedule::Cron to process
the lines. It understands */X notation and
Fellow listers,
After upgrading to the latest greatest Pentium 4 desktop
( 2.3 GHZ, 512 Meg of Ram, 80 Gig disk, Yeehah! )
and dealing with the JIT bugs, I find that Oracle names no
longer works properly.
The folllowing screen dump explains it all. Start names, everything
looks hunky dory,
Title: Accessing views across a db link
Try
this:
select
--+ DRIVING_SITE(rv)
*
from
view_name@remotedb rv
where
columnA = '...';
-
Regards,
Waleed
-Original Message-From: Martin, Alan
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 02, 2002 5:28
PMTo: Multiple
95 matches
Mail list logo
