or would i have
to do an export import.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: david hill
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
o background and run fine
coudl someone tell me why this happens
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: david hill
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-
of connections,
should i be using 1 over the other, are there performance benefits from
making a local connection?
David Hill
DBA
Le Chateau
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: david hill
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX
Title: Server Performance
Hi everybody
We were have some Oracle licensing Issues
They have just changed their Minimum licenses from 10/cpu to 25/cpu
Anywayz
I was debating whether or not my HP 6-way 220 mhz machine would be faster than a 2-way intel 2.4 XEON machine
Any ideas anybody?
Try doing a google on pkzip for unix
We have it our HP-UX box it works fine
-Original Message-
From: WLSH
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 17, 2002
11:35 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: How to zip a file on
>From Unix shell script
You have to use uuencode
Something like this
(echo TEST
uuencode file1 file1 ) |mail dba
-Original Message-
From: Markham, Richard
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 17, 2002
12:34 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: How to zip a
: http://www.orafaq.com
--
Author: david hill
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself
.
Thanks
David Hill
DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David Hill
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Hi Guys, I was wondering if someone could
help me
I'm trying to create an AFTER
SERVERERROR trigger that will log all errors and the SQL that caused the error.
Here's what I have so far
CREATE OR REPLACE TRIGGER server_error_trig
AFTER SERVERERROR ON DATABASE
DECLARE text
I was just wondering if I'm allowed to apply a new patch after I have
already installed patch. Say from 8.1.7.3 to 8.1.7.4.
Do I have to uninstall the .3 patch and then install the .4 or what?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: david hill
INET
experienced any similiar kind of problems with corruption that wasn't
there
Thanks for any Help
David Hill
DBA
LeChateau
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: david hill
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538
of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: david hill
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
done
rm -f $tmpfile
Thanks
David Hill
DBA
Le Chateau Stores
-Original Message-
Sent: Tuesday, January 15, 2002 10:06 AM
To: Multiple recipients of list ORACLE-L
Attached are the scripts we use to kill sniped sessions. This is part of a
series of monitoring
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: david hill
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Points to the current month without having to recreate the view every month.
Is there anyway anybody can think of doing this?
Thanks
David Hill
DBA
Le Chateau
Title: RE: Ltrim?
Should be something like this
0 6 * * 1 ksh myscript.ksh
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 22, 2002 9:19 AM
To: Multiple recipients of list ORACLE-L
Subject: Ltrim?
Hallo,
Anyone whom could help me
Title: RE: password
I created a user test identified by test on 2 separate systems in db's with different names
The password value was the same
Can someone verify if it is the same on their system
Create user test identified by test;
select password from dba_users where username = 'TEST';
Title: RE: password
This works too
A password calculator
http://lastbit.com/pswcalc.asp
-Original Message-
From: Paul Heely [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 17, 2002 4:19 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: password
UGH! Should have been
Title: RE: Oracle bug 2316137
You could always install oracle in another oracle home, Patch that home
Then all you need is 1 min down time to shutdown the db and bring it up with the other patched oracle.
-Original Message-
From: Glenn Stauffer [mailto:[EMAIL PROTECTED]]
Sent:
Title: Itanium 2
Has anybody out there tried and Itanium 2 system?
I read that oracle is supposed to certify 9i on it at the end of the month.
But I was wondering if anybody had installed one of the Developer Release's.
If so what kind of performance did it give you? Anywhere close to what
Title: OT: Logitech Give Away
Just to let everybody know to try and visit www.logitech.com
They are giving away 20,000 mice and keyboards today
Hopefully it'll make somebody's holiday's
Merry Christmas
David Hill
Oracle DBA
Le Chateau
Title: RE: Out of topic -Unx question
The cheap easy way
Is to have a cron job that runs at midnight and echo's today's date to a file called today.date
But before that it copies that file to yesterday.date
Then all you have to do is cat yesterday.date to get the date.
It may not be the
Title: RE: AUTORAID and VA7100 disk arrays for rp7400
Yep I have same thing to say
We have a HP N class with 3 HP AutoRaid's
I recently did a test to import our 50 gig database
On the HP it took 4 hours to do a Full export of DB and 12+ hours to import
I then proceeded to import the exact
, is giving me a transfer rate of about 15Megs a sec
These should be up around 60 - 80 megs
right?
My sysadmin says there is nothing he can
do.
Can someone tell if there is some sort
setting he hasn't set or a config somewhere?
Thanks.
David Hill
someone tell if there is some sort setting he hasn't set or a config
somewhere?
Thanks.
David Hill
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California
Title: RE: HPUX SCSI Performance
It turns out it's a bug with vxfs on
all Itanium system's
HP is starting to work on a patch for it hopefully
it'll be out soon
Thanks for the input though.
David Hill
-Original Message-
From: Rich Holland
[mailto:[EMAIL PROTECTED]]
Sent
Title: Gather_system_stats
Hi everyone
I was trying to migrate one of our applications to 9.2 and put in cost at the same time
I came across Gather_system_stats and was wondering if anyone had used it?
Did it improve the executions plan choice at all?
Thanks
David Hill
DBA
Here a fast little script I wrote that can
be ran every minute
Emails only when it finds a new message
And pages if it finds a new message
between 6pm and 5am
FPATH=/prod/dba/scr
autoload f_xmail
logfile=/prod/dba/logs/`cat
/prod/dba/sys_data/newpath`/misc_logs/chk_alerts.log
Title: RE: Oracle Licences Req on Intel Xeon CPU
Yes Redhat Advanced Server 2.1 does support hyperthreading.
Its not to bad either. I ran some tests and we get about a 15% increase in performance with hyperthreading turned on.
-Original Message-
From: Michael Brown [mailto:[EMAIL
Title: RE: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1
1 Important Difference
RHAS 2.1 is the only certified version if you are using 9.2
-Original Message-
From: Kulev, Milen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 04, 2003 4:59 AM
To: Multiple recipients of list
Title: RE: sqlplus prompt question in 9i
It could be your sql
Here is the prompt I have been using for a while with no problems at all
If the db is down you get a prompt of
Nolog
set termout off
define new_prompt='nolog'
column value new_value new_prompt
select SYS_CONTEXT('USERENV',
31 matches
Mail list logo