Hi,
here you go:
CREATE OR REPLACE FUNCTION HEXTONUMBER (v_HexCode IN VARCHAR2) RETURN
NUMBER IS
v_SIG NUMBER;
v_SIGValue NUMBER;
v_Token CHAR(1);
v_TokValue NUMBER;
v_ResultNUMBER;
v_Index NUMBER;
BEGIN
v_Result := 0;
v_SIG :=
Hi,
1) Build an external procedure that uses your C++ stuff.
2) Call this procedure from PL/SQL.
Bhamini Desaic schrieb:
Hi all,
I have requirement of calling C++ component from PL/SQL. What should I
do for this?
For calling Java Class we have to first run initjvm.sql to load
Title: RE: OPS on a single machine ?
That's an interesting concept. Won't there be problems with file sharing. Once the first instance has started will the 2nd one be allowed access to the datafiles?. I don't know much about raw files but I suspect that would be the problem area.
;-) I have to agree with the 'doing things once' approach...grin
Could you possibly supply some info on the shell script you use to produce
the mails? I would be v. much obliged.
hit any user to continue
__
Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
Hi,
did you mount the cdrom as read only ?
If you have it in your fstab, check for an ro entry in the cdrom line.
I personally prefer to build a stage on a disk to install oracle from.
In case of patches being published, you can go ahead and apply the
patches to the stage (if they are of the
Hi Oracle App DBA Gurus,
Does anyone have a list of files that hardcode the APPLSYS APPS password
in the oracle software directory ? I am about to change the APPS APPLSYS
password but worry that the HR application will not run smoothly as I
believe the passwords of APPLSYS APPS accounts are
Hi
I forgot to mention that the database I'm to create the standby for is not
alone on this machine. IP-switching is therefore not an option (I'm not
doing standby for the whole system). We are currently using HACMP with EMC
but this is giving us much grieve (UNIX people anyway) so they want
Hi gurus,
Greetings.
c:\ sqlldr80 userid=msalah/msalah@qtel control=c:\test.ctl
ORA-12203: TNS:unable to connect destination
SQL*Loader-704: Internal error: ulconnect : OCIServerAttach [-1]
But am able to connect with SQL*Plus with the same username/password.
Why it's showing this error,
How can i close the report engine window, which is automatically opened
while calling a report from forms, programatically.
any one any help greately appriciated.
rgds,
nirmal.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL
Hi,
I'm just making assumptions. According to an Oracle guy, with OPS on
8.1.7, the instances communicate via 2 different ways. One way is via
network connections (process to process communication). The other way is
via locking blocks and propagating it via distr. lock manager. So,
according to
Hi Folks,
Need some backing up here!
I have a MSSQL dba at my place of employment who enjoys emailing me with
either Websites or reports that compare MSSQL and ORACLE, with MSSQL in a
favouable light and Oracle usually in a very negative light.
Anyone have anything similar, but from an Oracle
Hi,
sounds stupid, but is your spelling correctly ? Try the pwd and SID
uppercase.
Nirmal Kumar Muthu Kumaran schrieb:
Hi gurus,
Greetings.
c:\ sqlldr80 userid=msalah/msalah@qtel control=c:\test.ctl
ORA-12203: TNS:unable to connect destination
SQL*Loader-704: Internal error:
If its anything like the situation in the job market as I see it then I
would just wave your pay cheque in his face !!
-Original Message-
Sent: 04 September 2001 10:31
To: Multiple recipients of list ORACLE-L
Hi Folks,
Need some backing up here!
I have a MSSQL dba at my place of
Hi,
if you want to check the file consistency, you will have to do it by
hand. RMAN doesn't do it for you.
But, assuming you know the file structure to be backed up, do the
following:
Write the file structure with ls to a file. Then, after you have your
tared-gzipped files, apply a check with
Title: RE: sqlloader-bad file
Try the folling as the calling file load.sh (chmod 555 or similar before running)
sqlldr control=ABS_Load.ctl log=abs.log bad=abs.bad userid=user/pwd rows=2 bindsize=500 direct=true errors=5000
John
-Original Message-
From: [EMAIL PROTECTED]
Hallas John£¬ÄúºÃ£¡
Hi, that is ok.
One of my friend tested ops on single machine and succeeded, i didnot test it
myself.
ÔÚ 2001-09-04 00:45:00 ÄúдµÀ£º
That's an interesting concept. Won't there be problems with file sharing.
Once the first instance has started will the 2nd one
Hi list,
I got the export made with exp V8.1.6 and succesfully imported it with imp
V8.1.7 to oracle 8.1.5 database. A lot of versiosn to use.
Thanks to all who replied
Volker Schön
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-Ursprüngliche Nachricht-
Von: Schoen Volker
Now that's a good point ;)
Robertson Lee - lerobe schrieb:
If its anything like the situation in the job market as I see it then I
would just wave your pay cheque in his face !!
-Original Message-
Sent: 04 September 2001 10:31
To: Multiple recipients of list ORACLE-L
Hi
Hello,
I have problems with the orarp.exe (Reports remote printing) under Win2k.
I searched on Oracle for a new version, but no success.
Mine seems to be version 1.0.2
Has anyone an actual version or sen a link where to download this utility?
Thanks
Stephan
--
Please see the official
I don't know if the Oracle Challenge still applies...
Haven't heard of anyone who managed to win that $1,000,000 bet with Oracle.
At one point MS was telling Larry Ellison to shut up, they were threatening
a law suit.
: O
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin
Jack
Hadn't thought of that yet. Thanks
That'll do the trick for us.
Jack
Rachel Carmichael [EMAIL PROTECTED]@fatcity.com on 04-09-2001
00:36:47
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc:
Hi DBAs,
Sorry for the OT post but can someone tell me how I can reverse engineer an
access database to produce the sql code that will run in ACCESS or
point me to a web site/user group/list server that may be able to help.
Thanks
Rick
--
Please see the official ORACLE-L FAQ:
Hi
There we go again with a possible Larry's huge ego thread ;).
Actually, I can't hear that Oracle vs. DB2 vs. MS SQL Server stuff
anymore.
I have close to zero experience with MS SQL. The best things about
Oracle and DB2 are, as far as I'm concerned, that both of them, taken
together pretty
I would say 512K for Shared Pool, 512K for Buffer Cache, 32K for Log buffer
would be pretty good starting point. That gives you about 3Mb sga in total.
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.
Title: Message
Oracle
guarentees consistency, how can that be forced if parts of the database are
allowed to lag behind.
"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
you don't put it in the control file. When you run sqlldr, just as you have
control=filename you add log=logfilename and it will write to the
logfile
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: sqlloader-bad file
I think I now know why...
http://www.boston.com/dailyglobe2/247/nation/Hewlett_Packard_to_buy_Compaq+.
shtml
http://www.boston.com/dailyglobe2/247/nation/Hewlett_Packard_to_buy_Compaq+
.shtml
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit.
I just love this, I see replies to my e-mail on the listserv before I
receive the e-mail that I sent.
Gotta love the Internet!
: )
I have no issues with your answer, I agree.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Stefan
Do you backup your archivelogs before you delete them? If you do you
shouldn't get the rman-20242 error. We always backup the archivelogs when
we do backup and store the archivelog backup with the database backup.
We don't backup to tape so I can't help you there and we don't use
Netbackup.
Sorry. This page does not exist.
The Oracle Technology Network website is an ever changing collection of
information on Oracle products and technology, and we've either removed or
relocated the document you requested.
I do have a good tutorial of UTIL_SMTP on my website if anyone would like to
There is a command (have a look on metalink) which
resync the archive list to avoid rman-20242. But I've
used the combination you've got several times and had
no problems.
My advice would be ensuring that the netbackup works
perfectly first (ie a backup/restore initiated from
both client and
1 Dba, 4 databases which are 7am-7pm type. 7 duhvelupurs, hmm, I mean, 3
now.
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)
Title: OT: RE: Duhvelopers and DB-ehs?
Really!!
-Original Message-From: Jacques Kilchoer
[mailto:[EMAIL PROTECTED]]Sent: Friday, August 31, 2001
3:20 PMTo: Multiple recipients of list ORACLE-LSubject:
OT: RE: Duhvelopers and DB-ehs?
I am in charge of 273 databases at sites
Stephan,
If I remember right, this utility was written by Duncan Mills of Oracle. You
can find him on odtug-dev2k-l list hosted on fatcity.com. If you post a
question on that list, you might hear from him or someone else who has run
into a similar problem.
The reason you haven't found a newer
Stephan,
A version can be found at
http://otn.oracle.com/sample_code/products/reports/listing.htm. I downloaded
the file and looked at the properties. It said it was version 1.2.2.0.
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
-Original Message-
From: [EMAIL PROTECTED]
If you are using 8i,
select to_number(your_hex_number_in_quotes, 'X') from dual;
Similarly, to encode a number to hex
select to_char(your_number, 'X') from dual;
seems to work.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
We were discussing when to set degree parallelism on a table. You
experts out there, is there a number of rows that it makes sense to set it to
something other than default? I know there are times when parallel can be
slower than serial processing but what is that threshold. We are
Thanks for that Chrisopher, I'll certainly have a nosey...
hit any user to continue
__
Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com
-Original Message-
They just bought compaq, as of Today.
$25 Billion. Damn it, I should have bought it first ;P
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
Hi all,
I have been given an assignment to formulate different backup
strategies for OLTP (24X7) and Datawarehouse applications using RMAN.
Could you please help me on these factors i have considered
1)what type of backup should i take ?
Incremental,cumulative or full and on what
Thought this would interest you guys..
http://www.theitportal.com/ITPFrameSetBottom.asp?Path=http%3A%2F%2Fwww%2Emac
world%2Eco%2Euk%2Fnews%2Fmain%5Fnews%2Ecfm%3FNewsID%3D3442Domain=www.macwor
ld.co.ukAdArea=TEST
Regards
Mark
===
Mark Leith
Some on the list will obviously disagree with me, what else is new, but I set
the archive parameter in init.ora always whether or not I intend to use it.
That way when I need to it's already there.
Dick Goulet
Reply Separator
Author: Ramon Estevez [EMAIL
Title: RE: OT RE: database consistency tools ?
What
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Friday, August 31, 2001
3:20 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: OT RE: database consistency tools ?
If the DBA screams bloody murder
Well , you are annoyed when you do your best to corrupt a tablespace and you succeed
and that you find out you don't know how to recover from this situation :)
Sorry to bother with basic question, I am new to Oracle and to the lists.
/Maya
-Original Message-
From: [EMAIL
Look at OLE importer under Programs menu, it can create packages for all the
methods for the specified ole container.
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is
-From: Thater, William
I'm glad you are back Shrek!!
Dave
-Original Message-
Sent: Sunday, September 02, 2001 9:45 AM
To: Multiple recipients of list ORACLE-L
Rachel Carmichael wrote:
Okay, first the rant they want me to build a new database to hold
logs of every time someone
My commute is 25 miles and takes 30 minutes at the most. It sure beats the
days of Chicago and San Francisco where that 25 mile commute would take 1.5
to 2 hours. No more big cities for me. Actually I consider myself quite
fortunate to be where I am. :o)
Dave
-Original Message-
Hello All
we got a problem with DBMS_ALERT package. On clients we get sometimes an
error message:
ORA-2: ORU-10001: lock request error, status: 2
Where can be a problem? Is it a problem of ENQUEUE_RESOURCES or DML_LOCKS
parameters?
How can I check it?
Thank you for any responce
Regards
Ivo
This script will run for any database on the server, for any version of
Oracle. We run it in cron, and if we add databases, we only have to change
the dba_env.sh file. If we change email addresses or pagers or add or remove
DBAs, we have to change the .profile account and the dba_env.sh
Well, I guess the laws of probability will dictate that at least one of us has
to have it good! :-)
Dick Goulet
Reply Separator
Author: Jared Still [EMAIL PROTECTED]
Date: 9/1/2001 12:35 PM
Just to add to my previous comment:
I'm working at a
Take a look at ER/Win. It is very helpful in these type things.
If your looking to goto SQL Server, there is a migration tool on
technet.microsoft.com
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.
We were just talking about fire alarms.
Funny thing, a company we know was going to lay off 100 people, so they did
a fire alarm, then locked the building.
Told everyone who was to be laid off to leave, then opened it about an hour
later for the rest.
Not really related, but figured someone
I would agree with you Dick.Its just one less bounce of the database if
you do need it.
-Original Message-
Sent: Tuesday, September 04, 2001 8:57 AM
To: Multiple recipients of list ORACLE-L
Some on the list will obviously disagree with me, what else is new, but I
set
the archive
Title: Message
Isn't
that what OJ did?
"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
You bet your arse its interesting considering we are 100% Compaq Tru64
Sent ructions across the UNIX S.As here this morning I can tell you.
I did HP-UX admin training a year or so ago... now where did I put my course
manuals ??
Lee
-Original Message-
Sent: 04 September 2001 15:02
Folks,
The idea behind OPS is to get two or more servers involved in the database
to increase throughput. Therefore it is not possible to install OPS on a single
server, you need two at a minimum. The method of synchronizing file writes is
also OS specific and you need a manager for the
Someone said to 'set feedback on' problem can be that feedback is normally on,
but set to a minimum of 6 rows before it starts talking, Consequently what you
probably need is 'set feedback 1'.
Dick Goulet
Reply Separator
Author: Djaroud Salim [EMAIL
Hi,
I've found the OS configuration files that hardcodes the passwords.
Regds,
New Bee
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 09/04/2001 4:50 PM
Hi Oracle App DBA Gurus,
Does anyone have a list of files that hardcode the APPLSYS APPS
password
in the oracle
Maybe it's just too early in the morning and my sense of humor hasn't kicked
in, but I don't find it funny at all.
What's the name of the company? I want to warn everyone I know not to work
there. Of course, they're probably not hiring anyway...
--Walt Weaver
Bozeman, Montana
-Original
Hi All,
What is the best way to load Access tables into Oracle? I can do Oracle to
Access Ok but not vice-versa.
I could dump it out into csv and use sql*loader but hoping more for a more
automated way.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Rachel,
Thanks a million for that...I'll take the timeout at some point to pour over
it and determine what it's doing...but it looks relatively straight forward.
K.
hit any user to continue
__
Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East
I'd definitely go with the partitioning. The only question that I'd have
is whether I would make the partition large enough to satisfy a single
user's query or small enough that it could reside in the SGA. I guess that
that depends on how many users are querying at one time. Just off the top
List,
Has any one received un solicited emails from [EMAIL PROTECTED] or
[EMAIL PROTECTED] about business opportunities. I can't get the email to respond
to the remove option at [EMAIL PROTECTED] I keep getting invalid recipient.
ROR mª¿ªm
--
Please see the official ORACLE-L FAQ:
Title: RE: Duhvelopers and DB-ehs?
Ok, so right about the time Oracle 6 went
production (we were a beta site), I was thelead DBA for a very large
project that put retail store systems in around 1000 locations around the
country (USA). Each one of those locations had their own Oracle database
Well I think it is funny in a way of approach, just how silly things can be
done.
But it is effective, although not the most pleasant way, but if you see how
most layoffs go, they annouce they are doing layoffs, and they will contact
people, so everyone sits around and gets nervous for the
Hi all,
How do you show swap on hpux?
How about memory? Is there anything like prtdiag on Solaris?
Thanks!
Jerry
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ:
Kevin,
No problem, I believe in sharing (but you notice I removed my database
names)... this way, you have the time to write something cool and share it
with the rest of us. Reinventing the wheel is a waste of time.
And I always try to write plain vanilla code, and comment it heavily. That
NOOO!
You comment your code so other people can read it. You rebel you!
=)
-Original Message-
Sent: Tuesday, September 04, 2001 10:42 AM
To: Multiple recipients of list ORACLE-L
Kevin,
No problem, I believe in sharing (but you notice I removed my database
names)...
-- Jerry C [EMAIL PROTECTED] on 09/04/01 07:42:10 -0800
Hi all,
How do you show swap on hpux?
How about memory? Is there anything like prtdiag on Solaris?
vmstat 5;
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
Is there any way to see CLOB data in
TOAD??
And at the same time how do we map JAVA data type
to CLOB data type in Oracle ..
Looks like our developers are running to all kinds
of problems.. reg this data type ..
Any thoughts ???
TIA
RK
You might also consider a regular e-mail (sort of like Public Television)
where you remind people every 6 months or so of the situation and where to
send voluntary contributions. This way people new to the list will get the
history of the situation.
Now I'm off to make my first donation!
Jay
Here they tapped people on the shoulder from behind. Noone knew how many
were being let go and how long the process would take. You just turned
around quickly whenever you heard footsteps. I thought the tappers should
have been wearing a black cloak and hood and tap you with a staff. After the
A former coworker used to do thise with me, but
we were both good nature about it and both
enjoyed it.
He even sent me a couple of columns from a well
known SQL Server 'guru' where Oracle was subjected
to all kinds of unjust criticism.
I even responded directly to the author on that one
since
I will give these questions a shot. See my replies inline. Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 04, 2001 10:02 AM
Hi all,
I have been given an assignment to formulate different backup
strategies for OLTP
On Tuesday 04 September 2001 08:42, Rachel Carmichael wrote:
And I always try to write plain vanilla code, and comment it heavily. That
way, when I go back to it in 3 months, I can remember what the heck I was
doing with it and why.
Geez Rachel, what fun is that?
Few things are as
We have the following configuration and it has been working all right for more
than a year and half.
The config as follows...
Solaris 2.6
Netbackup 3.2
Oracle 8.1.6 and 8.1.7.1
We always do the following take a full level 0 backup... ( have riun into
problems where it asks for very old arch so
ESPECIALLY with EXCITE. my kids sign up for stuff all the time, and I am
NEVER able to remove their names from the mailing lists.
wish there was a way to send a fire-bomb thru email
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, September 04, 2001
HP Acquiring Compaq?
Yow!
That's big news!
Anyone see this coming? I would have never guessed.
Jared
On Tuesday 04 September 2001 07:02, Mark Leith wrote:
Thought this would interest you guys..
http://www.theitportal.com/ITPFrameSetBottom.asp?Path=http%3A%2F%2Fwww%2Ema
c
You might want to look at Tim Gorman's High Availability and Scalability
for Your Database at
http://www.evdbt.com/
--
From: VIVEK_SHARMA[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Sunday, September 02, 2001 4:45 AM
To: Multiple
ORA-2 is an error raised by raise_application_error.
In other words, you must examine the code, as it is
a custom error message.
Jared
On Tuesday 04 September 2001 07:25, Libal, Ivo wrote:
Hello All
we got a problem with DBMS_ALERT package. On clients we get sometimes an
error message:
So Dave, where are you?
Jared - 6 miles, 10 minutes in Beaverton Oregon, USA
On Tuesday 04 September 2001 06:50, Farnsworth, Dave wrote:
My commute is 25 miles and takes 30 minutes at the most. It sure beats the
days of Chicago and San Francisco where that 25 mile commute would take 1.5
use dbms_lob.substr( clob_column, amount, offset )
to see it's portion.
- Original Message -
From:
Apps Sol
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, September 04, 2001
09:12
Subject: Clob and TOAD
Is there any way to see CLOB data in
I created the database on NT using scripts and I did use auto start for the
service. Sorry for the delay in reply..was out over the long weekend.
- Uma
-Original Message-
Sent: Friday, August 31, 2001 9:28 AM
To: Multiple recipients of list ORACLE-L
Who created the DBs on NT? How?
SOAPBOX
When I comment code, I always do things like:
# put the value 5 in inta
inta = 5;
# does a loop from 5-33430
for (i=5; i 33430; i++)
{
..
}
# calls blah3434 function
blah3434();
Just kidding, but it is kinda of a duhvelupur thing to do to always state
the obvious, and think there is
The option to remove is ussually there so they can't be considered spam
due to the laws. Even though it probably doesn't work.
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
We have 4 dbs ranging form 3gb to 280 GB usin RMAN for backups . It would
really depend on your requirements. I would do a full online backup
everyday. Now that is me and we have a fast dedicated tape library and
all. But to give you an idea the backup times are form 10 mins to 4 hrs.
Anjan
We
That happens whenever I code slightly intoxicated. Code
does tend to work when I do that but damn if I can figure
out why.
-Original Message-
Sent: Tuesday, September 04, 2001 9:26 AM
To: Multiple recipients of list ORACLE-L
On Tuesday 04 September 2001 08:42, Rachel Carmichael wrote:
Well, there is no point of arguing at all. Last time I checked, MsSQL was
running only on Windows platforms. I believe there are certain situations in
life when MsSQL could be much faster than Oracle ( like small shops with low
transaction volume ) and, therefore, better, having in mind that it's
Jared, wish that was entirely true, look at
$ORACLE_HOME/rdbms/admin/dbmsutil.sql some of oracle's code is using low
numbered 2 error nums :((at least thats that the internal docs say)
joe
[EMAIL PROTECTED] 09/04/01 12:32PM
ORA-2 is an error raised by
raise_application_error.In
Jared,
I live in Galesville, WI with a population of about 500 and work in Arcadia,
WI, with a population of about 2000. My place of employment has about as
many employees as the town has population. Ashley Furniture is a furniture
manufacturer(as if the name doesn't give it away). It's kind
Run the following script and check syntex for insert,update and delete which
are generating redos
select
substr(username,1,10)USER,process,sid,serial#,substr(sql_text,1,200),disk_reads,buffer_gets,rows_processed
from v$session,v$sqlarea
where sql_address=address and status = 'ACTIVE'
order
when i was offered to bail out of the military in '92, it worked that
way.
Most of the people who had a skill set and could make it in private
industry, took the offer and left.
I didnt do too bad, 11 years in bail out and a 35K check :)
if enough people didnt take the money, the later
Thanks Larry. Your knowledge of SQL*Plus is unparalleled. Thanks also to Stephane
whose algorithm Larry used.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Saturday, September 01, 2001 8:00 AM
To: Multiple recipients of list ORACLE-L
I think there were a few hints, but the biggest thing with this merger is
now HP has 87 billion in income, compared to IBM's 90 billion. Ibm is
gaining market share and becoming a giant, now they have a decent size
competitor.
Do not criticize someone until you walked a mile in their shoes,
I think a lot of MCSEs, esp. those with 4 or 5-digit MCSE numbers also have
a vested interest in seeing Microsoft shares stay up.
My opinion, my perception.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Jared Still [SMTP:[EMAIL
List,
What's the diffrence between Number(e.g number(5)) Integer base on Space
usage and performance issue and indexing any idea
Thanks in Advance
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
The information contained in this message and any attachments is intended
only for the
Jared:
It's the buzz of the office this morning. No one here seems to have seen it
coming.
Jon Walthour
Oracle Database Administrator
COMPAQ DBA Team
Cincinnati, Ohio
-Original Message-
Sent: Tuesday, September 04, 2001 12:33 PM
To: Multiple recipients of list ORACLE-L
HP Acquiring
Many years ago, when I was a system manager on an HP-3000 system, Compac was
using the HP3000 database. This relationship goes back a long way.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 04, 2001 12:32 PM
HP
I certainly didn't!! Is this going to be like a merge? What I mean is, is
there still going to be Compaq machines and HP machines? Or will it be like
Hewlett Compaqerd? Just wondering?
-Original Message-
Sent: Tuesday, September 04, 2001 12:33 PM
To: Multiple recipients of list
From the Q you have, it sounds like someone's marketing people have been
there! EMC doesn't necessarily replicate the entire array. Whether it is
nearly instantaneous or not depends on a lot of factors - transaction
load, distance, etc. I would also contend that any talk about using
1 - 100 of 203 matches
Mail list logo