Andrey Bronfin wrote:
Hi Paul !
Thanks a lot for your reply .
This is a production DB and can not be upgraded right now.
DBAndrey
* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]
You could probably run ONames on a different box, different version - if
that helps.
Hello,
I receive this book last week...
Regards
Henrik
-Original Message-
Sent: den 5 augusti 2001 06:35
To: Multiple recipients of list ORACLE-L
Oracle High-Performance SQL Tuning
by Donald Burleson. Anyone have
any comments on the book
It won't be published until the end of
--
On Sun, 26 Aug 2001 23:10:20
Paul Drake wrote:
Andrey Bronfin wrote:
Hi Paul !
Thanks a lot for your reply .
This is a production DB and can not be upgraded right now.
DBAndrey
* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]
You could probably run ONames on a
Hello all,
I want to subscribe to some top magazines for oracle unix performance. Do you have
any recommendations for this, I need the best one for both of them. Please while
recommending explain what you liked about the magazines, like eg you like magazine x
because it carries performance
Try v$thread instead
jack
Adams, Matthew (GEA, 088130) [EMAIL PROTECTED]@fatcity.com on
24-08-2001 20:21:31
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Hi
Try www.revealnet.com
Jack
Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED]
@fatcity.com on 25-08-2001 10:25:39
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van
Because of disk access...
-Original Message-
Sent: 25 August 2001 02:15
To: Multiple recipients of list ORACLE-L
sound
system trivia question:
when using windows explorer, etc., dos prompt (e.g., sqlplus) and
running music CD, the sound get choppy intermittently, usually when
Hallo,
How can I schedule a pl/sql job, I want this to happen:
Every Sunday at 11 pm I want to do an insert into a table.
How shoudl I write the code in the DBMS_JOB satement.?
Roland S
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
ORACLE-L NOMAIL
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: GL2Z/ INF DBA BENLATRECHE
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Roland:
This anonymous PL/SQL block submits a job that will insert a row into
mytable:
VARIABLE jobno number;
BEGIN
DBMS_JOB.SUBMIT(:jobno,
'insert into mytable values (''One'',''Two'',''Three'');'
'SYSDATE, 'SYSDATE + 1');
commit;
END;
/
The SYSDATE parameter says, Run this
Re. WindowsXP, there is a little debate going on between a security analyst
and Microsoft.
http://grc.com/dos/sockettome.htm http://grc.com/dos/sockettome.htm
Microsoft posted a response on their web site, on the security page.
I don't know who is right in all this.
Regards,
Patrice Boivin
What's this about Oracle not favoring Sun anymore?
Is this just a rumour, or is it true?
I thought Oracle wrote their rdbms software on SunOS, then ported it to
other platforms.
Is Oracle in the process of changing this?
What happened? Is this related to the MetaLink problems they had over a
I have all of them save two, one of which was mailed to me last week...
I think I have way too many Conan novels, it's like Harlequin for men!
I have many double copies, I think I'll post them on eBay eventually to get
rid of them.
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
See http://www.jlcomp.demon.co.uk/faq/dbms_job.html
hth
connor
--- [EMAIL PROTECTED] wrote: Hallo,
How can I schedule a pl/sql job, I want this to
happen:
Every Sunday at 11 pm I want to do an insert into a
table.
How shoudl I write the code in the DBMS_JOB
satement.?
Roland S
Hi,
not that I want to sound like smart Alec, but I think his name is
Michael Hasenstein.
Literally translated, that would be Mr. Bunnystone. Much better than
Hesselstein ;).
Gogala, Mladen schrieb:
And, above all, they have a very knowledgeable guy helping
people on the Linux-Oracle
Or
http://www.oracledba.co.uk/tips/uptime.htm
hth
connor
--- [EMAIL PROTECTED] wrote:
Try v$thread instead
jack
Adams, Matthew (GEA, 088130)
[EMAIL PROTECTED]@fatcity.com on
24-08-2001 20:21:31
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To:
Taking Java out ?
What about Jinitiator? Will that still work?
And the JRE?
I guess I'll have to try it to find out.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]]
Sent: Friday,
Check Oracle.com, you wil see banners Oracle and HP-UX, your solution or
something like that.
It is true, and not a rumour, why though, I would love to know.
I wonder as HP has talked about getting out of the software market (or was
it hardware) a little while ago.
Do not criticize someone
Title: RE: OT RE: RE: How do you audit a DBA?
C'mon. I'd vote for The Rock instead, along with all The Rock's witty comments. That would be awfully darn distracting, and you could be sure your DBA would get NOTHING done :)
Honestly, if there's a need to audit the dba, maybe he or she should
Title: OT: system trivia (groove/programming): DOS prompt/etc and choppy sound
Really? I thought it was only because my personal pc has so little memory. I run into that behavior with explorer and playing mp3's at the same time. This also becomes a problem when burning a cd or changing
What I've heard is that Larry E. is having a hissy fit and Oracle is
removing all the Sun's that they own, except that Sun is still their
initial development platform.
Christopher
Dear list !
I'm getting affected by the rumors ;-(
Not enough that everybody (well , mainly MS IBM) claim that they'll beat
Oracle up very soon and take it off the market ,
there is also a rumor that Solaris is not Oracle's #1 any more.
I started to learn Solaris sys administration a couple of
Number datatype does not waste space if the column data type is larger than
the stored number.
Take a look at
http://www.vampired.net/forums/viewtopic.php?topic=24forum=150 to see how
number data types are stored.
Do not criticize someone until you walked a mile in their shoes, that way
when
A quick and dirty answer from my background in program management.
Document what your current code does and how it does it so that in case it
doesn't work someone else can easily find your mistake. If they want to
add new functionality to your code, your documentation should guide them in
how
Off Topic: I bought a PC this weekend that had my first every CDROM burner. I
couldn't wait to use it. I burned several game CD's (Age of Empires, Return
Fire II, Roller coaster Tycoon) and none of them worked. The games just hung
when I ran them. Bummer. Is it not possible to make copies
AIX is an operating system. This link down below is to a freeware site
that has many versions of different tools for that operating system.
-Original Message-
Sent: Saturday, August 25, 2001 2:20 AM
To: Multiple recipients of list ORACLE-L
hi...
can you anyone tell me what is aix
For something close try either of the following:
$ps aux | pg
or
$/usr/ucb/ps -aux
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
-Original Message-
Sent: Friday, August 24, 2001 5:16 PM
To: Multiple recipients of list ORACLE-L
Hey man, let me know If you
Title: OT: Cobol Copybook format
Good morning everyone,
I have this messy document that is known as a copybook. I've been searching the web to help me understand what the appropriate way to translate this into a table is. If anyone has a link they are willing to share, or is willing to
Title: RE: OT RE: RE: How do you audit a DBA?
It
would be like in the SNL episode, where the Rock was Nicotrol, to help people
stop smoking. That was very funny!!!
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent:
Monday, August
Lisa,
It is *highly* recommended that you shouldn't do anything else when burning
CDs. Unless your CD burner has high cache, launching multiple applications
can induce the 'buffer under run' problem, and can sometimes render the disk
unusable.
I get into the audio problem even if I am
Title: OT: system trivia (groove/programming): DOS prompt/etc and choppy sound
I had
that problem.Since I am running NT, I increased the priority of
Winamp, and I no longer have that problem unless the hard drive does some
significant amount of I/O.
-Original Message-From: Koivu,
LOL
I haven't done COBOL programming since 1978 but if I remember correctly:
In the file definition section.
01 or 02 would correspond to a table;
The stuff indented below it (10's I think) would correspond to columns.
PIC(99.99) means a numeric field with two positions to the right of the
I personally think it harder to go to Solaris than From it.
I used to work in a shop running AIX Servers for our Oracle database.
There were many good built-ins to use when running AIX. It was a very easy
OS to configure and maintain. Its hardware was solid and well supported by
IBM.
I also
Tom.
A number of things, at least in my experience, can cause the problems you
are having. The media(the blank CD's) depending on what you are recording
certain types of CD's are better than others and the play back device may
not be able to properly read the CD recording. I have recorded music
If I have a table that has a fields of type long, how can I move the data to
a varchar2(300)?
Thanks,
Mark
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Liggayu
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
Use a disk copier ... i.e. copy CD to CD complete (Adaptec CD Copier) not
individual files. Right now there are no (known) copy protected game CDs,
only few music CDs. The music CDs are supposed to include 'hiss' and
'clicks' and 'pops' when you copy them. Someone will soon break that as
well.
Some games, especially microsoft games have some sort of code or something
on them that prevents burned cd's from operating correctly. I know that
it's definatley on Age of Empires. However, if you look around on the
Internet you can find cracks for them, I know there is one for Age of
Empires.
Title: OT: system trivia (groove/programming): DOS prompt/etc and choppy sound
I
don't think its memory related at all. I have more then enough for what I
do and it does
the
same thing. That being said, before I cut a music CD it even tells me not
to launch
any
other applications as it is
Almost EVERY new game CD-ROM is now copy-protected, most of them utilize
SafeDisc. You can find sites out there that will tell you how to make
backup copies of your discs. Check out http://www.gamecopyworld.com. You
must use I/E for this site to work correctly. There are no known
Oracle has over 60% of the database market.
MS/SQL runs only on NT and most of the market is Unix.
IBM is just getting into non-AIX Unix and their DB2 for Unix is never going to catch
up with Oracle. Oracle even out performs DB2 on IBM's big iron.
Sun is a big boy in the Unix environment and
Actually, I have the crack to AOE, you want it?
-Original Message-
Tom
Sent: Monday, August 27, 2001 10:55 AM
To: Multiple recipients of list ORACLE-L
Off Topic: I bought a PC this weekend that had my first every CDROM burner.
I
couldn't wait to use it. I burned several game CD's
Dear gurus !
What is better performance-wise - to declare a variable inside a pl/sql
block (or a trigger) as integer (number , Pls_integer etc..) or as
mytable.mycolumn%TYPE .
Again , i'm concerned ONLY about performance in this question.
Thanks a lot.
DBAndrey
* 03-9254520
* 053-464562
*
Hi Stephen,
I configure all our SQLNET stuff in a directory
called ora_net under the oracle users unix home
directory. I then create links from the various
ORACLE_HOME/network directories into the /home/oracle/ora_net
directory. Works like a charm.
Christopher Spence wrote:
Check Oracle.com, you wil see banners Oracle and HP-UX, your solution or
something like that.
It is true, and not a rumour, why though, I would love to know.
Could Larry Ellison have fell under the charm of Carly Fiorina? :)
--
Regards,
Stephane Faroult
Title: OT: system trivia (groove/programming): DOS prompt/etc and choppy sound
We use
a Plextor at my office and I run Veritas Backup Exec, surf the internet or any
other programs and have never had a problem. Very impressive burner.
Now my one at home is being a big pain in the arse because
Any/All,
In our VMS environment it is SID_ALERT.LOG. Just in case someone was
curious
-Arich
[EMAIL PROTECTED] 08/23/01 09:05PM
Raj,
All the UNIX platforms I have worked on (about 6 so far), the name has
been
alert_SID.log. On my NT workstation it is SIDALRT.log. I have not
found
a way
I have 44 million records in my table.I need to extract the 10 million
records randomly,how to retrieve these records randomly. I used the
dbms_random.sql ,but I have a doubt that I was correct or not.
can U please guide me or just send a piece of code.
Thanking U
srinivas
--
Please see the
I believe that its because they feel that Sun is not a stable platform. Not
that the OS is not stable but that it keeps changing. HP is relatively
stable.
-Original Message-
Sent: Monday, August 27, 2001 7:45 AM
To: Multiple recipients of list ORACLE-L
What I've heard is that Larry
- Update the table by using either PL/SQL or 3gls.
If the LONG is always 32k or less you can do this in plsql.
If it may exceed 32k in size, plsql *cannot* manipulate it in
any way shape or form.
If the long is 32k or less, you simply declare a variable of
type LONG :
declare
my_var
I have a 8.1.6 database on NT on one machine . And
I want to create this database to another machine where oracle is installed but
there is no database. I have the back up of datafiles,control files and
redo log files and archieve files.
Can you tell What I will do step by step ? Is
there
I believe you would still have the option of getting all the plugins
required to run Oracle Apps - that includes jinitiator.
There wouldn't be any built - in Java Support in XP. You would have to
build it from scratch.
JVM, setting classpaths, etc
-Original Message-
Sent: Monday,
Copy protection. A lot of games now use copy protection.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73
Lisa,
These are usually file layouts, in COBOLese.
FILLER is usually unused space, as in:
first-name pic x(20).
filler pic x value space.
last-name pic x(30).
This is the first name, a space, and the last name. FILLERs usually
have a value associated with them, unless they are truly not used,
HELP
-Original Message-
Sent: Friday, August 24, 2001 3:51 PM
To: Multiple recipients of list ORACLE-L
nobody would be that dumb, would they? :)
--
From: Mohan, Ross [EMAIL PROTECTED]
Date: Thu, 23 Aug 2001 11:13:04 -0400
Subject: RE: Installing 73
I just did a quick search on google, here is a good article in reguards:
http://www.pcmech.com/showdoc/34/
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone:
Hi DBAs,
Table1 PK is on columns col1,col2,col3
I want to create a FK on table2 to table1 for col1.
What is the alternative to
ALTER TABLE table2
ADD CONSTRAINT fk_table2
FOREIGN KEY (col1) REFERENCES table1(col1);
I always get ORA-2270: No matching unique or primary key for this
column-list.
70% of games today are now copy protected.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
If all they did was take out J++, and we can still install the JDK and JRE
on WindowxXP, that might actually be an improvement.
: )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Sinha, Shashank (MED, TCS) [SMTP:[EMAIL PROTECTED]]
Rather than think of them as a table, think of each
copybook mapping a record in a file (which is what
cobol is basically designed to do)...
The numeric levels are a hierarchical way of grouping
the levels... For example:
10 date-created
20 year-created pic 99
20
Find a riper (burner) that does a binary rip and they will work.
At 07:46 AM 8/27/2001 -0800, you wrote:
Some games, especially microsoft games have some sort of code or something
on them that prevents burned cd's from operating correctly. I know that
it's definatley on Age of Empires.
Thanks I didn't knew ... and I am not a big fan of PC games anyway, so I
only read about music CD copyright related stuff.
..hmmm I have to catch up on my reading
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot
I think a direct variable declaration (without constraints like not null) is
the fastest. Of course if you are dealing with integers, use pls_integer
instead of number, it is faster.
Because for typecasting, I think it has to (somehow) access the dictionary
to get the column or table
Using Windoze, I downloaded the three Oracle 9i Linux files from
technet.oracle.com. I then rebooted into Suse, copied the files over, but
gunzip is not recognizing the files. I switched back to Windoze and using
Winzip it doesnt like the files either. So I redownloaded just the smaller
third
I can't believe it, they have a beta DB2 v.7.1. for OS/2, same release
number as for AIX.
I thought that OS was dead!
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Isn't OS/2 still used extensively by banks to run ATM's? If that's the case,
then IBM would have a vested interest in keeping DB2 current on OS/2.
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Monday, August 27, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L
I
Lisa,
Thanks for waking up memories of COBOL that I have been trying to run away
from! Anyway a FILLER is just that - a filler or placeholder to pad out
or format a 'record' in the WORKING STORAGE or FILE section (eq. to the
declarative section in PL/SQL). If this is part of a retrieved
That won't work, your primary key is 3 cols, so the foreign key must
reference those same three cols.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978)
I had a similar problem getting 817nt from OTN.
I had to download the file to linux - run gunzip.
then I tar'd it up again and copy to NT - where I used a DOS tar program
to un-tar it. Sheeze! Very painful.
-Original Message-
Sent: Monday, August 27, 2001 10:36 AM
To: Multiple
Title: Oracle Licensing for a Clustered Server Configuration
Hi,
Does Oracle Corp. require you to buy the RDBMS license for the fail-over server (as well) in a
2-node cluster server environment?
Thanks
Nagesh
If you do not use a download manager like getright, you will almost always
download broken files.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
From a pure performance direction,
pls_integer or binary_integer is probably
the fastest.
If you declare a variable to be of
table_name.column_name%type
there are implicit constraints on the
variable and any pl/sql assignments
(in particular arithmetic operations)
have to check that the
I have a developer here who is trying to populate a cursor. Every time he
runs his code he gets the above error stating that the buffer is too small.
We have tried explicitly setting the buffer to 1,000,000 bytes. This is FAR
greater than needed for the amount of data requested. No matter what
You can only FK to field(s) that are unique or primary key
constraints.
if col1 is unique, you can put a unique constraint on it and then FK to it
from the child.
your only other choice is to do FK checkign via triggers(i did it for
distributed databases, where parents were on one db and
windoze shouldnt be the problem(did i really say that), i used that at
work to do the downloads copies them to RH machine(binary ftp), and installed
with no problem.
joe
[EMAIL PROTECTED] 08/27/01 01:35PM
Using Windoze, I downloaded the three Oracle 9i Linux files
The opposite end of a 'foreign key' has to be
a 'unique key' or 'primary key'. You have only
two 'nominally correct' options -
a) declare a unique key on table1.col1
or
b) Create a table where the unique values
of table1.col1 are held, and declare a
primary key on it -
I don't know.
I went to the cinema last week (? A couple of weeks ago?) and one of the
ticket machines had a C:\ prompt on its screen.
Presumably that thing was running DOS...
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From:
There is also the drawback that the
trigger has to do a 'select for update',
with all associated contention problems,
otherwise the effect of read-consistency
would allow a trigger to determine that a
parent existed when in fact it had been
deleted by an uncommitted transaction.
Jonathan Lewis
Bunyamin,
Let's
call the database that already exists the SourceDb, and the new one you want to
create the TargetDB
Do the
following:
On the TargetDB machiine,
create the same directory
structure that exists on the SourceDB
machine. This should include the directories where the database
I think it's simpler than that -- I don't think they really need to be
unzipped.
From: Grabowy, Chris [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Oracle 9i Linux files are erroring during uncompress...
Date: Mon, 27 Aug
Odd thing is that linux/solaris files come down correctly. And I've
down-loaded other zips for NT in the past with no problems.
This seems like a recent problem.
-Original Message-
Sent: Monday, August 27, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L
If you do not use a
Well, they end with .gz, and the instructions under the files specify to use
gunzip to unzip them.
Oh why, oh why does life have to be so difficult...
-Original Message-
Sent: Monday, August 27, 2001 2:29 PM
To: Multiple recipients of list ORACLE-L
I think it's simpler than that --
Title: RE: ORA-10027 in ps/sql block
Rodd, can you post the code?
-Original Message-
From: Holman, Rodney [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L
Subject: ORA-10027 in ps/sql block
I have a developer here who is
You
can do something like this:
CREATE OR REPLACE
TRIGGERyour_triggerAFTER UPDATE OF ename ONEmp_Tab
FOR EACH ROWBEGINNULL; --do whatever you have to do...call
procedure, etc...
END;
HTH
-Original Message-From: novicedba
[mailto:[EMAIL PROTECTED]]Sent: Saturday, August 25, 2001
We often used the FILLER to make the data more presentable in files. i.e.
used filler between columns. W
We also defined our output on reports the same way.
-Original Message-
Sent: Monday, August 27, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L
Lisa,
Thanks for waking
oh i definitely didnt include all of the problems associated with
distributed enforcement of FK. I was denoting the obvious :)
joe
[EMAIL PROTECTED] 08/27/01 02:22PM
There is also the drawback that thetrigger has to do a
'select for update',with all associated contention problems,otherwise
Title: Oracle Licensing for a Clustered Server Configuration
Only
if it's active on the fail over node - if it's passive you don't need a second
license.
-Original Message-From: Srinagesh Battula
[mailto:[EMAIL PROTECTED]]Sent: Monday, August 27, 2001 1:07
PMTo: Multiple
do a file on them in linux and see that the magic number comes back to show
you what it thinks it is.
joe
[EMAIL PROTECTED] 08/27/01 02:53PM
Well, they end with .gz, and the instructions under the files
specify to usegunzip to unzip them. Oh why, oh why does life
have to be so
Title: ach_tran query
Hi Cherie,
Looks like parallel query kicked in. It usually throws some odd looking stuff in the explain plan.
HTH
Lisa
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 3:11 PM
To: Multiple recipients of list
One friend of mine working for Siemens is still programming DOS stuff 'cause
they use MSDOS as OS for chip testing machines (life test for car chips to
use in VW, BMW ...).
Jan Pruner
Dne po 27. srpen 2001 20:28 jste napsal(a):
I don't know.
I went to the cinema last week (? A couple of
I am running tkprof and explain plan on the following SQL statement:
SELECT DISTINCT CNFR_NO,
SPLT_PAY_TYPE, ACH_AMT
FROM whse_dbo.ACH_TRAN
WHERE ACCT_NO = '46807' AND
TRUNC(TRAN_DT) = TRUNC(TO_DATE('20-JUL-01','DD-MON-YY')) AND
STATUS = '2' AND
CNFR_NO 0 AND
I ran it at home for a couple of years (OS/2 2.0, 2.1 and 3.0 warp), I
finally gave up on it because IBM never got permission to support Windows95
applications in a shell.
It worked very well, though - never crashed. DOS and Windows sessions
crashed, but the OS never failed. And it was so
Title: Oracle Licensing for a Clustered Server Configuration
John, are/were you in a similiar
env..
..very curious..coz Oracle is forcing us
to buy a second license for the passive fail-over server ..
Thanks
-Original Message-From: Shaw, John B
[mailto:[EMAIL PROTECTED]]Sent:
Title: RE: Oracle Licensing for a Clustered Server Configuration
Our failover server neither has a standby database nor oracle binaries.
In our Clustered server configuration, when a fail over happens
the entire diskgroups will be de-ported from the primary and imported on the failover
No replies needed!!
This is way too ironically funny
Sometimes ... when you cry ... no one sees your tears ...
Sometimes...when you are worriedno one sees your pain...
Sometimes ... when you are happy ... no one sees your smile ...
But fart
Anything over 2oom, is almost impossible to download from technet without
using a download manager, what happens is during the transfer it aborts and
restarts. Which fouls it up some how, once I started using get right to
downnload the stuff, it worked everytime, not to mention faster.
Do not
Thanks for the offer of help. Developer finally did a
DBMS__OUTPUT.DISABLE
followed by the DBMS_OUTPUT.ENABLE. This cleared the buffer and code
worked. Apparently he had a dirty buffer that didn't clear until the
DISABLE was issued. He has added the DISABLE to his code prior to the
It looks like you have a partitioned table with
a parallel or parallel index definition.
The :Qyyy are the 'table queues' used
by parallel query slaves to pass messages
between the layers of slaves operating the
query.
The SQL with the hints in it is the SQL
generated by the query
Hi Gurus,
I have number of Oracle8i instances on HP-Ux in a 400 servers Data center!!
I want valuble suggestions from Gurus and who maintaining their real Data
ceners.. I appreciate your help.
Thanks in advance
Raghu.
_
Get
I couldnt get it to work for anyone other than someone in the dba group
already on linux. if you're in the dba group you can connect / as sysdba
anyways, so i guess i'm missing where the security hole is.
joe
[EMAIL PROTECTED] 08/23/01 04:41PM
Okay have a look at bug 1919536, it allows a
proactively monitor everything, max extents, datafile percent free, all of
it, its always easier to fix something when you have days/weeks of advance
notice, versus 2AM.
joe
[EMAIL PROTECTED] 08/27/01 04:21PM
Hi Gurus,I have number of Oracle8i
instances on HP-Ux in a 400 servers Data
1 - 100 of 145 matches
Mail list logo