Yeah, you might not be able to open it, but you can nearly always mount it.
Rachel Carmichael wrote:
as opposed to the ever-present Oracle kernel which is arbitrary,
gobbles up all resources in sight and costs the earth to maintain?
--- Noyce, Robert A SITI-ITPSIE [EMAIL PROTECTED] wrote:
:))
Mogens, you are my hero!
On 2004.01.18 19:34, Mogens Nørgaard wrote:
Yeah, you might not be able to open it, but you can nearly always mount it.
Rachel Carmichael wrote:
as opposed to the ever-present Oracle kernel which is arbitrary,
gobbles up all resources in sight and
Apparently to celebrate his new marriage, Larry is releasing the new Oracle 10G
Marriage Builder product, it requires plenty of tuning and costs an absolute fortune.
Other features include Parallel nagging, a new wifemon process that never clears
anything up and after 3 months the whole product
as opposed to the ever-present Oracle kernel which is arbitrary,
gobbles up all resources in sight and costs the earth to maintain?
--- Noyce, Robert A SITI-ITPSIE [EMAIL PROTECTED] wrote:
Apparently to celebrate his new marriage, Larry is releasing the new
Oracle 10G Marriage Builder product,
Melanie Craft is a romance
novelist andthe fourth woman to be known as Mrs. Larry Ellison. This
is from an article is today's WSJ print edition page B4. Mrs. Ellison also
has a web site although I don't know the address.
Mrs. Ellison is 34 years
old and Larry is 59.
My $0.02
worth,
Ken
Well, at least he didn't marry Lara Croft. That would do him in
faster then Bill Gates.
On 01/15/2004 09:19:26 AM, KENNETH JANUSZ wrote:
Melanie Craft is a romance novelist and the fourth woman to be known as Mrs. Larry
Ellison. This is from an article is today's WSJ print edition page B4.
I have just done an Amazon search, I guess that Melanie Craft's book 'A Hard-Hearted
Man (Intimate Moments, No 870)' will bring some terrific change to my usual reading
list. Although one of her other masterpieces, 'Trust Me' looks terribly reminiscent of
the Oracle doc, doesn't it.
SF (almost
http://www.cxotoday.com/cxo/jsp/index.jsp?section=Newssubsection=Businesss
ubsection_code=1file=template1.jspstoryid=505
Or, for the cut-and-paste impaired:
http://tinyurl.com/23wcv
Just adding gasoline to the bar-b-que... :)
Rich
Rich Jesse System/Database
PROTECTED] On
Behalf Of Jesse, Rich
Sent: 09 January 2004 15:00
To: Multiple recipients of list ORACLE-L
Subject: Who said Oracle ran better on Win03?
http://www.cxotoday.com/cxo/jsp/index.jsp?section=Newssubsect
ion=Businesss
ubsection_code=1file=template1.jspstoryid=505
Or, for the cut
Subject: Re: Who fired the trigger
You can identify the user via
sys_context ('userenv', 'sessionid') and raise an exception, or just exit the code block. Jared
"Goulet, Dick" [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/19/200
a need o periodically unscrap stuff. The
question is can a trigger recognize who fired it abort if that is a particular user?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
INET: [EMAIL PROTECTED
has an answer to this. Otherwise I guess it will wait till
Monday.
We have a before update trigger on a table to prevent assemblies on
the line from being unscrapped. But we also have a need o periodically
unscrap stuff. The question is can a trigger recognize who fired it abort
[EMAIL PROTECTED]
cc:
Subject:Who fired the trigger
To All,
I'm feeling in a LAZY mood this afternoon so I'm going to ask the list if someone has an answer to this. Otherwise I guess it will wait till Monday.
We have a before update trigger on a table to prevent
from being unscrapped. But we also have a need o periodically unscrap stuff. The
question is can a trigger recognize who fired it abort if that is a particular user?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
I think Jared means..
sys_context ('userenv', 'session_user')
to identify the username.
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: Who fired the trigger
Date: Fri, 19 Dec 2003 11:59:41 -0800
You can id
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Who fired the trigger
I think Jared means..
sys_context ('userenv', 'session_user')
to identify the username.
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED
So we have to take two advanced Oracle courses...
I have a bad feeling that the Oracle Internals Seminars by Scott Gossett
don't count.
Would that be correct? They are not part of the OCP tracks.
Patrice.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin,
I've taken those for 8i. Scott is a great guy and the course is excellent.
In NYC there was a waiting list for his course.
On 12/17/2003 09:19:26 AM, Boivin, Patrice J wrote:
So we have to take two advanced Oracle courses...
I have a bad feeling that the Oracle Internals Seminars by Scott
I ended up going to Bethesda from NYC to take the class with him
--- Mladen Gogala [EMAIL PROTECTED] wrote:
I've taken those for 8i. Scott is a great guy and the course is
excellent.
In NYC there was a waiting list for his course.
On 12/17/2003 09:19:26 AM, Boivin, Patrice J wrote:
So we
That's correct. I believe the reasoning is that the advanced courses
(listed below) that are included have to include hands on. The
Internals seminars are not hands on. As a couple of asides, Scott is
not the only instructor who runs those internals seminars, and I'm not
even sure if he's
Bethesda city center on Wisconsin Av.? Nice place with some rather fancy
restaurants around. I drove around Washington and Bethesda and I must say that
it is a beautiful area. I would like to live in Reston, VA. Did you know that
propery prices in Reston are comparable to those on LI?
On
high 300K to 0.5M for a townhouse and 500K to 1M for single house
-Original Message-
Sent: Wednesday, December 17, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L
Bethesda city center on Wisconsin Av.? Nice place with some rather fancy
restaurants around. I drove around
This is OT...
3-bedroom Houses in Halifax, Canada sell for about CDN$130K now.
Patrice.
-Original Message-
Sent: December 17, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L
high 300K to 0.5M for a townhouse and 500K to 1M for single house
--
Please see the official ORACLE-L
not optional).
if its more than that let me know...
From: Hsu, Anthony C., ,CPMS [EMAIL PROTECTED]
Date: 2003/12/17 Wed PM 12:09:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Re: Who are certified Oracle Masters?
high 300K to 0.5M for a townhouse and 500K to 1M
Foote [EMAIL PROTECTED]
Date: 2003/12/12 Fri AM 07:54:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Who are certified Oracle Masters?
Hi Robert,
That's all very interesting.
The various press releases at the time (e.g.
http://www.dulcian.com/PRESS
of you that are, has it
helped you in getting work?
From: Richard Foote [EMAIL PROTECTED]
Date: 2003/12/12 Fri AM 07:54:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Who are certified Oracle Masters?
Hi Robert,
That's all very interesting
TED]> Date: 2003/12/12 Fri AM 07:54:26 EST To: Multiple r!
ecipients
of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Who are certified Oracle Masters? Hi Robert, That's all very interesting. The various press releases at the time (e.g. http://www.dulcian.com/PRESS%20RELEASE_OCM.htm)
Sent: Monday, December 15, 2003
4:25 PM
To: Multiple recipients of list
ORACLE-L
Subject: OT - RE: Re: Who are
certified Oracle Masters?
how scary would it be to arrive at the exam, and the
inquisitioner is dressed as Gandalf.
Right after he hands out the exam he slams his staff
Honi soit qui mal y pense
At 04:34 PM 12/13/2003, you wrote:
This is a family oriented mailing list folks. :)
Jared
On Fri, 2003-12-12 at 15:19, Richard Foote wrote:
Hi Jeremiah,
I find the mental image of the six of you holding up your shafts for a
publicity shot profoundly disturbing...
This is a family oriented mailing list folks. :)
Jared
On Fri, 2003-12-12 at 15:19, Richard Foote wrote:
Hi Jeremiah,
I find the mental image of the six of you holding up your shafts for a
publicity shot profoundly disturbing...
Cheers ;o)
Richard
- Original Message -
To:
you mean niemic didnt actually have to take the test? It was just handed
to
him? who is jeremiah wilton?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 4:09 PM
IIRC, Tanel did the OCM as well, but I suspect most
the exam. It was not
just handed to him.
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/11/2003 3:59 PM
you mean niemic didnt actually have to take the test? It was just handed
to
him? who is jeremiah wilton?
- Original Message -
To: Multiple
Jeremiah,
You really had to expose your self to get the shaft as you so
stated. I just have to show up at work.
Congratulation on receiving the certification and being recognized for
the knowledge you so willingly share.
Is there really a live after being a DBA? I prefer creating furniture
for
All this nonsense about who got what and did they deserve it. Only one
questions comes to mind.
Are we all in High School or something? Did I miss the throwback in time?
sheesh.
Tom Mercadante
Oracle Certified Professional
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
how many people are actually OCMs? and those of you that are, has it helped you in
getting work?
From: Richard Foote [EMAIL PROTECTED]
Date: 2003/12/12 Fri AM 07:54:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Who are certified Oracle Masters?
Hi Robert
recipients of list ORACLE-L
you mean niemic didnt actually have to take the test? It was just
handed
to
him? who is jeremiah wilton?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 4:09 PM
IIRC, Tanel did the OCM as well
: Richard Foote [EMAIL PROTECTED]
Date: 2003/12/12 Fri AM 07:54:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Who are certified Oracle Masters?
Hi Robert,
That's all very interesting.
The various press releases at the time (e.g.
http://www.dulcian.com/PRESS
Hi Jeremiah,
I find the mental image of the six of you holding up your shafts for a
publicity shot profoundly disturbing...
Cheers ;o)
Richard
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 5:19 PM
Apology accepted. We
I know only of Pete Sharman. Who are other Oracle Certified Masters on
this group? I suspect Tanel to be one, as well as Steve Adams, Cary Millsap,
Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti Deshpande.
Am I correct?
Mladen Gogala
Oracle DBA
--
Please see the official
Woo Hooo!!
NOT ME!!
I'm a certified oracle bastard!
lol
Brad O.
okay...I'm done...
(back into my cage)
-Original Message-
Sent: Thursday, December 11, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
I know only of Pete Sharman. Who are other Oracle Certified Masters
, December 12, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L
I know only of Pete Sharman. Who are other Oracle Certified Masters on
this group? I suspect Tanel to be one, as well as Steve Adams, Cary
Millsap,
Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti
Deshpande.
Am I
that!
Bruce Pihlamae, long-term Oracle DBA
-Original Message-
Mladen Gogala
Sent: Friday, December 12, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L
I know only of Pete Sharman. Who are other Oracle Certified Masters on
this group? I suspect Tanel to be one, as well
of his
10g presentation.
At 01:54 PM 12/11/2003, you wrote:
I know only of Pete Sharman. Who are other Oracle Certified Masters on
this group? I suspect Tanel to be one, as well as Steve Adams, Cary Millsap,
Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti Deshpande.
Am I correct
you mean niemic didnt actually have to take the test? It was just handed to
him? who is jeremiah wilton?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 4:09 PM
IIRC, Tanel did the OCM as well, but I suspect most
of Pete Sharman. Who are other Oracle Certified Masters on
this group? I suspect Tanel to be one, as well as Steve Adams, Cary
Millsap,
Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti
Deshpande.
Am I correct?
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http
for schedule details...
-Original Message-
Ryan
Sent: Thursday, December 11, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L
you mean niemic didnt actually have to take the test? It was just handed
to
him? who is jeremiah wilton?
- Original Message -
To: Multiple recipients
herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not. It's much harder than that!
Bruce Pihlamae, long-term Oracle DBA
-Original Message-
Mladen Gogala
Sent: Friday, December 12, 2003 7:54 AM
To: Multiple recipients of list ORACLE-L
I know only of Pete Sharman. Who are other
Oh, and I forgot. No, the honorary OCM's didn't have to take the test.
They were given the OCM in recognition of their contributions to the
Oracle world as a whole. Actually, some of them I'd never heard of
before either, so that probably explains why I can't recall who they are
now.
Pete
As I recall Rich talking about it, he did indeed take the exam. It was not
just handed to him.
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 12/11/2003 3:59 PM
you mean niemic didnt actually have to take the test? It was just handed
to
him? who is jeremiah
To: Multiple recipients of list ORACLE-L
you mean niemic didnt actually have to take the test? It was just handed
to
him? who is jeremiah wilton?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 4:09 PM
IIRC, Tanel did the OCM
To: Multiple recipients of list ORACLE-L
you mean niemic didnt actually have to take the test? It was just handed
to
him? who is jeremiah wilton?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 4:09 PM
IIRC, Tanel did the OCM
Ryan wrote:
you mean niemic didnt actually have to take the test?
Scary, eh ?
(couldn't resist)
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services
How do I check who is querying database information via database link?
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
PM
To: Multiple recipients of list ORACLE-L
How do I check who is querying database information via database link?
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
anyone remember who wrote and presented this paper?
Thanks, and Happy Thanksgiving!
Mike
---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
I remember seeing a paper delivered at an IOUG wa back, that spoke
of the 22-disk solution. I know it's old and outdated, but I'd like to
find a copy. Does anyone remember who wrote and presented this paper?
Thanks, and Happy Thanksgiving!
Mike
to
find a copy. Does anyone remember who wrote and presented this
paper?
Thanks, and Happy Thanksgiving!
Mike
---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
--
Please see the official ORACLE-L FAQ
a paper delivered at an IOUG wa back, that
spoke
of the 22-disk solution. I know it's old and outdated, but I'd like
to
find a copy. Does anyone remember who wrote and presented this
paper?
Thanks, and Happy Thanksgiving!
Mike
Hi All,
How can I determine who is using temp tablespace? I have a 1 gb tablespace
and it is almost full. I want to know who and what sql is using most
of it.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City
v$sort_usage and v$session should give you that.
Pawan
-Original Message-
Sent: Tuesday, November 04, 2003 6:49 PM
To: Multiple recipients of list ORACLE-L
Hi All,
How can I determine who is using temp tablespace? I have a 1 gb tablespace
and it is almost full. I want to know
Rick ,
This query will help you to find who is using the space
SELECT
a.username, a.osuser, a.sid||','||a.serial# SID_SERIAL, c.spid Process,
b.tablespace tablespace, a.status, sum(b.extents)* 1024*1024 space
FROM v$session a,v$sort_usage b, v$process c, dba_tablespaces d
WHERE
all oracle employees? Are any of you involved in the 9i PL/SQL test? I just took it
today and passed it. I didnt study at all.
Id like to state that it is an incredibly stupid test. Ive been told the PErformance
tuning one is bad also...
Some gripes:
1. Only package that I was asked about
Not I, never even seen the questions to tell you the truth. I believe
there's an email address you can raise exam issues with -
[EMAIL PROTECTED] You might want to send this to them to see if they
have more relevant feedback than I'd ever have on this exam.
Pete
Controlling developers is like
Probably a Sybase DBA
-Original Message-
Sent: Wednesday, October 22, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L
all oracle employees? Are any of you involved in the 9i PL/SQL test? I just
took it today and passed it. I didnt study at all.
Id like to state that it is an
But now since you've discussed whats on the test, the oracle police will
come and confiscate your certified copy of your completion certificate.
bwahahahahaha
Joe
[EMAIL PROTECTED] wrote:
all oracle employees? Are any of you involved in the 9i PL/SQL test? I just took it today and passed it.
I am using utl_tcp as we speak to send feeds out to our customers ... encrypted of
course. We have a program that uses utl_http to go to espn.com, fetch data, filter
out what we need and use that to populate the database.
Yes, we do use it ... but I am not Oracle employee.
Raj
my point is that relative to 'execute immediate' how many people use
utl_tcp?
execute immediate isnt on the exam at all.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 2:04 PM
I am using utl_tcp as we speak to send
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--- On Wed 09/24, Johnston, Tim [EMAIL PROTECTED] wrote:
From: Johnston, Tim [mailto: [EMAIL PROTECTED]To: [EMAIL PROTECTED]Date: Wed, 24 Sep 2003 14:34:49 -0800Subject: RE: RAC for downloadUm... I'd definitely get that in writing... I just looked at the oraclestore and it looks like
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
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
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
-Original Message-
From: Igor Neyman [mailto:[EMAIL PROTECTED]
In this case performance is not an issue.
I don't 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.
I hear what you're
-Original Message-
From: Igor Neyman [mailto:[EMAIL PROTECTED]
In this case performance is not an issue.
I don't 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.
oops! Forgot the
RE: Who Says Oracle does not listenAgree.
One can improve EXCEPTION section to ignore only relevant errors.
Alex.
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Monday, July 21, 2003 6:19 AM
That's not good enough.
I don't want to discard ANY exception.
When
http://metalink.oracle.com/images/metalink/generic/usaeng/kur_left_top.gif
http://metalink.oracle.com/images/metalink/generic/usaeng/kur_right_top.gif
Update TAR Go to End
http://metalink.oracle.com/images/metalink/generic/usaeng/kur_left_bottom.gif
To avoid those errors in my scripts I'm checking data dictionary for the
existence of the object (fortunately, dynamic sql helps here):
REM Dropping synonym
DECLARE lCounter integer;
begin
SELECT COUNT(*) INTO lSyn
FROM dba_synonyms WHERE synonym_name = 'PRCPV_REPORT_INFO' AND
OWNER =
Igor,
True enough, but wouldn't you like it as part and parcel of the command?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, July 18, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L
To avoid those errors in my scripts I'm
Sure, I would.
But I can't wait till Oracle turns around.
My scripts are executed by our field engineers, who know next to
nothing about Oracle, and the only thing they can do is to check log
files for error messages (and even this is done automatically).
Igor Neyman, OCP DBA
[EMAIL PROTECTED
Title: RE: Who Says Oracle does not listen
From ORACLE own script:
Rem
Rem Drop tables without raising errors if they do not exist
Rem
declare
PROCEDURE drop_force(tab varchar2) IS
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE ' || tab;
EXCEPTION WHEN OTHERS THEN
NULL;
END;
begin
drop_force
The core issue is that OSs have become commodities.
SCO has no other horses in the stable. Even the boys
and girls in Redmond are trying to grow beyond
Windows. Looks like SCO does not have the billions
rquired to muscle their way into the newly defined
world of commodity operating systems so
Peter - Well put. fund raising
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Monday, March 10, 2003 9:29 AM
To: Multiple recipients of list ORACLE-L
The core issue is that OSs have become commodities.
SCO has no other horses in the
I think the underlying issue is Linux. The SCO people are seeing their
licensing fees slip away to the free Linux. As far as I've seen, every major
vendor has a Linux strategy. This is SCO's effort to strike back, discourage
defections. I think it is pretty dumb.
We have been on DEC/Compaq/HP
Title: OT: Who Owns Unix?
Per the below link, SCO owns Unix and they're suing IBM for a paltry $1Billion:
http://www.infoworld.com/article/03/03/06/HNsco_1.html
How can this be?
Title: RE: Who Owns Unix?
Computerworld says:
http://computerworld.com/governmenttopics/government/legalissues/story/0,10801,79153,00.html
IBM has built its own AIX Unix under license since February 1985, when the company entered into a Unix license agreement with ATT Bell Laboratories
But GNU is not UNIX.
--
Lyndon Tiu
Quoting Orr, Steve [EMAIL PROTECTED]:
Per the below link, SCO owns Unix and they're suing IBM for a
paltry
$1Billion:
http://www.infoworld.com/article/03/03/06/HNsco_1.html
How can this be?
--
Please see the official ORACLE-L FAQ:
-Original Message-
Sent: Friday, March 07, 2003 2:44 PM
To: Multiple recipients of list ORACLE-L
Per the below link, SCO owns Unix and they're suing IBM for a paltry
$1Billion:
http://www.infoworld.com/article/03/03/06/HNsco_1.html
How can this be?
Which part? SCO owning 'Unix' or
I've had contact with the recruiter that sent me this 'opportunity' before.
He's above board and honest. If your interested, contact him not me.
Dick Goulet
Good afternoon, if you are available and interested
I realize that a package can't be recompiled while a session has it open.
How do I identify which session has a package open?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
This is from the message Bruce Reardon posted yesterday:
Take a look at Steve Adam's
http://www.ixora.com.au/scripts/sql/executing_packages.sql
This script lists the packages (and other stored code objects) that are
currently being executed, and the SIDs of the executing sessions.
It is listed
Check v$open_cursor, I tested a procedure and it showed up.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 9:14 AM
To: Multiple recipients of list ORACLE-L
I realize that a package can't be recompiled while a session has it open.
How do I identify which
Just wrote this now (9.2). Run it while the compilation is waiting:
select *
from v$session
where saddr in (select kgllkuse
from DBA_KGLLOCK
where kgllktype = 'Pin'
and kgllkreq = 0
and kgllkhdl in
You could try v$open_cursor by SID, but I also use an X$ table (X$KGLLK)
with the following SQL:
select *
from x$kgllk
where KGLLKSNM=sid
This shows what SQL objects a session has touched. It usually gives me what
I need.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 16 January
As I said life is much easier:
select * from v$access where object = 'YOUR_OBJECT_NAME'
Waleed
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L
I realize that a package can't be recompiled while a session
Title: RE: Who has package open
CREATE OR REPLACE PROCEDURE who_is_using wrapped
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
7
200f000
1
4
0
1e
c WHO_IS_USING:
8 OBJ_NAME:
8 VARCHAR2:
b DBMS_OUTPUT:
6 ENABLE:
7 100:
1 I:
1 B:
8 USERNAME:
3 SID:
3 SYS
in case this is a windog machine - install kind of unix shell. and the unix style
commands work perfectly - just tried it. either use unix tools for windog or cygwin
from rh.
or dump the w...
have fun.
[EMAIL PROTECTED] 01/03/03 18:40 PM
Hi everyone,
This may be a stupid question. If so
Title: Perl DBI/SQL question - For those who use it...
Hi everyone,
This may be a stupid question. If so please humor me with a stupid answer. However:
I FINALLY have the fun fun fun chance to change one of my data loads to use the DBI instead of the procedures I hacked together
:
Subject:Perl DBI/SQL question - For those who use it...
Hi everyone,
This may be a stupid question. If so please humor me with a stupid
answer. However:
I FINALLY have the fun fun fun chance to change one of my data loads to
use the DBI instead of the procedures I hacked together
Try
dbish dbi:Oracle:tnsname commands.sql
The dbish is a DBI shell supplied with the DBI.
The version supplied with the DBI is functional but basic.
Tom Lowery is working on an extended version with plugins
adding more functionality. One of his goals is an SQL*Plus clone...
Title: RE: Perl DBI/SQL question - For those who use it...
Jared, thanks for your reply.
One last question: Is SPOOL one of the commands that DBI does not understand? I would need to capture any errors spit out by sql*plus (like my famous ora-1410 error). I have a feeling the answer is yes
1 - 100 of 210 matches
Mail list logo
