Re: Top 10 DBA Do's and Don'ts anyone - Here is my list,
Perhaps we depend to much on the force to guide and protect us at times... :-) Laugh you may, but in the last UK census (not a poll mind you but the actual national census) 400,000 people indicated their religion was Jedi. This was more than put their religion as Sikh, Jewish or Buddhist. Of course its just a re-hash of Vitalisim, but (Oh dear, now I've annoyed nearly half a million people and all of 'em on the same tiny island as me :-) -Dale -- Generate HTML schema documentation with the free DDL to HTML converter. DBATool: http://www.DataBee.com/dt_home.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Materialized views not refreshing
Dear list, Have any of you every experienced MV's not refreshing for no particular reason? We have been using some simple MV's for several months with no problem. Now after upgrading our app and database, there seem to be problems. Servers: Master: Win2k SP2 Oracle 8.1.7.4.1 Slave: NT 4 SP6 Oracle 8.1.7.4.1 These databases were previously 8.1.6. The master database now has a UTF8 character set, and all tables have NVARCHAR2 columns. These are being converted in the MV using: translate(COLUMN_NAME using char_cs) COLUMN_NAME when creating the MV. There are no errors, no trace files. Data is updated on the master node and never appears in the slave. The data continues to persist in the MLOG$ tables. I've verified there is only a single MV against each MV LOG, so the data in MLOG$ should be truncated after a refresh, but the fact that it isn't makes it fairly obvious that the refresh is not working properly. I have a serverity 1 TAR open now with Oracle, but so far all that's been accomplished with the TAR is me repeating everything I included initially. Any advice appreciated, as it's rather important to get this working again. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OS Kill
It's one of those oracle processes that for instance takes care of jobs in the job queue. They can be killed on oracle level w/o problems (8.0.5 at least). Test it first in test environment Jack -Original Message- Sent: dinsdag 25 februari 2003 8:04 To: Multiple recipients of list ORACLE-L hi list one session in our database is in ACTIVE state since long. it is doing no activity at all. it has locked one table also. because of this other sessions are also in ACTIVE state. so it is required for us to kill the session. i got the corresponding spid for that session from v$process. i checked the following:: $ps -ef | grep spid oracle 21556 1 0 Feb 20 ?0:09 ora_snp3_TRADEDB1 isn't this the OS process/thread for the oracle background process? i want to kill the process at OS level if it is not working at DB level TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unix variable question
Hi all,
Can someone help me understand this...
ROOT # TEST=${2:-.}
ROOT # echo $TEST
ROOT #.
what is 2:-.
another similar code
ROOT # TEST=${1:-0}
ROOT # echo $TEST
ROOT # 0
they looks like emoticon for me
Thank you
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: GRRRRR OWS
LOL Thank you Stephen ... I needed that laugh. Ciao Fuzzy :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen Lee Sent: Wednesday, February 19, 2003 21:44 To: Multiple recipients of list ORACLE-L Subject: RE: GR OWS A good website for appropriate telephone technique can be found at www.roydmercer.com Roy D. Mercer is such an inspiration that we even have test databases named ROY and MERCER. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OFF TOPIC: Jedis, etc - was Top 10....
Not true. This isn't a list for urban myths - if you're going to go off-topic, you could at least do it accurately. :-) http://www.statistics.gov.uk/cci/nugget.asp?id=293 Sikh - 336,000 people. Jewish - 267,000 people. Buddhist - 152,000 people. Jedi was classified under 'Other religion' along with Druidism, Satanism, Wicca, Pagan, Freethinker, etc, etc. The total for ALL these was only 179,000. Of course, Jedi only got as many 'votes' as it did because of a spoof email which tried to convince people that it would make it into an 'official' religion. Which is, of course, complete twaddle! -- Peter Moore Systems DBA, SchlumbergerSema, Reading -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 08:14 To: Multiple recipients of list ORACLE-L Subject: Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, Perhaps we depend to much on the force to guide and protect us at times... :-) Laugh you may, but in the last UK census (not a poll mind you but the actual national census) 400,000 people indicated their religion was Jedi. This was more than put their religion as Sikh, Jewish or Buddhist. Of course its just a re-hash of Vitalisim, but (Oh dear, now I've annoyed nearly half a million people and all of 'em on the same tiny island as me :-) -Dale -- Generate HTML schema documentation with the free DDL to HTML converter. DBATool: http://www.DataBee.com/dt_home.htm _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MOORE, Peter Rbh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle white papers
Useful white papers and articles on www.nyoug.org under presentation link. John -- 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 - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Third Party Application Madness
Title: RE: Third Party Application Madness That's the situation I'm in now, but the language is Hungarian. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- From: Odland, Brad [mailto:[EMAIL PROTECTED]] Sent: Monday, February 24, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: Third Party Application Madness And the table and column names hopefully are in a language you know... I ran into a app that the table names and columns were in German. Not a problem if you know German... Brad -Original Message- Sent: Monday, February 24, 2003 2:13 PM To: Multiple recipients of list ORACLE-L Congratulations! We, the Annointed Members present you, Jared Still, with the Sadistic Vendor Setup Purple Heart award. Wear it with pride. At least you *have* PKs and FKs... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, February 24, 2003 1:09 PM To: Multiple recipients of list ORACLE-L In need of cathartic release, I find myself sharing my pain with the folks that will understand it best. :) The past two weeks have really been 'fun'. [snip] Now, on to the next crisis. Jared -- 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 -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OFF TOPIC: Jedis, etc - was Top 10....
A little more digging: http://www.statistics.gov.uk/census2001/profiles/commentaries/ethnicity.asp# religion At the time the Census was carried out, there was an internet campaign that encouraged people to answer the religion question Jedi Knight. The number of people who stated Jedi was 390,000 (0.7 per cent of the population). -Original Message- Peter Rbh Sent: 25 February 2003 09:39 To: Multiple recipients of list ORACLE-L Not true. This isn't a list for urban myths - if you're going to go off-topic, you could at least do it accurately. :-) http://www.statistics.gov.uk/cci/nugget.asp?id=293 Sikh - 336,000 people. Jewish - 267,000 people. Buddhist - 152,000 people. Jedi was classified under 'Other religion' along with Druidism, Satanism, Wicca, Pagan, Freethinker, etc, etc. The total for ALL these was only 179,000. Of course, Jedi only got as many 'votes' as it did because of a spoof email which tried to convince people that it would make it into an 'official' religion. Which is, of course, complete twaddle! -- Peter Moore Systems DBA, SchlumbergerSema, Reading -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 08:14 To: Multiple recipients of list ORACLE-L Subject: Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, Perhaps we depend to much on the force to guide and protect us at times... :-) Laugh you may, but in the last UK census (not a poll mind you but the actual national census) 400,000 people indicated their religion was Jedi. This was more than put their religion as Sikh, Jewish or Buddhist. Of course its just a re-hash of Vitalisim, but (Oh dear, now I've annoyed nearly half a million people and all of 'em on the same tiny island as me :-) -Dale -- Generate HTML schema documentation with the free DDL to HTML converter. DBATool: http://www.DataBee.com/dt_home.htm _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MOORE, Peter Rbh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Update and Trigger
Try: alter session set sql_trace = true then you're update both with and without the trigger enabled. This will show the statement(s) that are causing the delay hth connor --- Basavaraja, Ravindra [EMAIL PROTECTED] wrote: Hi, I have an update statement that affects 1 record in a table.There is a trigger associated with this update that updates few other tables and not the parent table that will triiger the update trigger. With the trigger enabled the update of 1 record on the parent table takes about 40 seconds and without the trigger the update takes about 1 second. When the updates are operating on different tables(locking not a issue) why do i see this delay in execution of the update statement. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How long to hold onto old Oracle CDs?
0 was next line. Wasn't 4 Forward and 5 Back? I've CC'ed Michael Möller, who writes DSI (Data Server Internals) classes in Oracle Development. He taught me all I ever needed to know about the EDT editor on VAX/VMS. He really should be able to remember all those wonderful keys. Yes, it was a fantastic editor, by the way. Ah yes - too true. Now we are getting nostalgic... Mogens Gogala, Mladen wrote: Nope, but I do have a 5MB RZ05 drive for interchangeable disks. I don't have a computer to attach it to, but I have good memories of KED and PF1 (Gold) key. KP-6 was cut GOLD-KP-6 was paste, PF2 was help and PF3 was Search. The best editor ever! -Original Message- From: Jan Benjamins [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 3:13 PM To: Multiple recipients of list ORACLE-L Subject: Re: How long to hold onto old Oracle CDs? Do you still have a 5.25 drive ? :) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 24, 2003 4:33 PM I stil have my 4.1.14 installation for DOS 3.3. (3 5.25 floppies) -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Subject: How long to hold onto old Oracle CDs? Hey all, Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs? We've been at 8.1.7 for 18 months now. I can't think of a good reason, other than the software isn't available anymore. Anybody want some old CDs? :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Jan Benjamins INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of
Re: Unix variable question
It's parameter substitution.
Use the first one if not null, otherwise use the second.
Try this:
TEST=${ORACLE_HOME:-NOT SET}
echo $TEST
Now try misspelling ORACLE_HOME
TEST=${ORACLE_JOME:-NOT SET}
echo $TEST
In a script you may have to begin the line with a colon.
e.g. : TEST=${ORACLE_HOME:-NOT SET}
Jared
On Tuesday 25 February 2003 01:28, Sinardy Xing wrote:
Hi all,
Can someone help me understand this...
ROOT # TEST=${2:-.}
ROOT # echo $TEST
ROOT #.
what is 2:-.
another similar code
ROOT # TEST=${1:-0}
ROOT # echo $TEST
ROOT # 0
they looks like emoticon for me
Thank you
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
AW: Unix variable question
Answer1: ROOT # man bash
Answer2(copy paste form answer1)
${parameter}
The value of parameter is substituted. The braces are
required when parameter is a positional
parameter with more than one digit, or when parameter is
followed by a character which is not to be
interpreted as part of its name.
If the first character of parameter is an exclamation point, a level
of variable indirection is intro
duced. Bash uses the value of the variable formed from the rest of
parameter as the name of the variable;
this variable is then expanded and that value is used in the rest of
the substitution, rather than the
value of parameter itself. This is known as indirect expansion.
The exception to this is the expansion
of ${!prefix*} described below.
In each of the cases below, word is subject to tilde expansion,
parameter expansion, command substitution,
and arithmetic expansion. When not performing substring
expansion, bash tests for a parameter that is
unset or null; omitting the colon results in a test only for a
parameter that is unset.
${parameter:-word}
Use Default Values. If parameter is unset or null, the
expansion of word is substituted. Other
wise, the value of parameter is substituted.
${parameter:=word}
Assign Default Values. If parameter is unset or null, the
expansion of word is assigned to parame
ter. The value of parameter is then substituted. Positional
parameters and special parameters may
not be assigned to in this way.
Milen
-Ursprüngliche Nachricht-
Von: Sinardy Xing [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 25. Februar 2003 10:29
An: Multiple recipients of list ORACLE-L
Betreff: Unix variable question
Hi all,
Can someone help me understand this...
ROOT # TEST=${2:-.}
ROOT # echo $TEST
ROOT #.
what is 2:-.
another similar code
ROOT # TEST=${1:-0}
ROOT # echo $TEST
ROOT # 0
they looks like emoticon for me
Thank you
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name 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.net
--
Author: Kulev, Milen
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: How long to hold onto old Oracle CDs?
Title: RE: How long to hold onto old Oracle CDs? It figures. We're one the largest accounts Oracle has got. Heck, Oracle has two people at HQ that deal with nothing but GE business units, and I STILL can't get 7.3.4, 8.0.5 or 8.0.6 for NT. Even my dedicated account rep struck out getting these disks. Oh, well. I'll go back and try it again. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- From: david davis [mailto:[EMAIL PROTECTED]] Sent: Monday, February 24, 2003 5:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: How long to hold onto old Oracle CDs? I cut an iTAR on Metalink back last Oct. It would have been simpler. If someone had maintained our support agreement. But while that was being resolved. The sent me the CD. I got the CD in a couple of days. I was informed by someone at IBM that Oracle could burn new CD's. If you truly have a need for the CD. Such as lost/broken. Put pressure on them via your account rep. I hardly think it is likely for a vendor to say they don't have the code. If we have people on the list with software dating back to Oracle 4, I doubt Oracle is purging its archives of the software. It would be irrational. It is more likely they are just being difficult. Doing nothing is always the easiest route for the vendor. From: Adams, Matthew (GECP, MABG, 088130) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: How long to hold onto old Oracle CDs? Date: Mon, 24 Feb 2003 09:24:11 -0800 Two months ago, I tried to order older non-supported CDs (7.3, 8.0.5, 8.0.6) and they told me they could not ship them. How did you order them? Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Monday, February 24, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Actually the CD's are available. You just have to request them from Oracle. Of course, this does depend upon having a support contract. Ordered a replacement CD a couple of months ago for 7.3.4 (HP/UX) due to cracked media. From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How long to hold onto old Oracle CDs? Date: Mon, 24 Feb 2003 06:58:58 -0800 Hey all, Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs? We've been at 8.1.7 for 18 months now. I can't think of a good reason, other than the software isn't available anymore. Anybody want some old CDs? :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- 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 -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
RE: Materialized views not refreshing
Dear list, Have any of you every experienced MV's not refreshing for no particular reason? We have been using some simple MV's for several months with no problem. Now after upgrading our app and database, there seem to be problems. Servers: Master: Win2k SP2 Oracle 8.1.7.4.1 Slave: NT 4 SP6 Oracle 8.1.7.4.1 These databases were previously 8.1.6. The master database now has a UTF8 character set, and all tables have NVARCHAR2 columns. These are being converted in the MV using: translate(COLUMN_NAME using char_cs) COLUMN_NAME when creating the MV. There are no errors, no trace files. Data is updated on the master node and never appears in the slave. The data continues to persist in the MLOG$ tables. I've verified there is only a single MV against each MV LOG, so the data in MLOG$ should be truncated after a refresh, but the fact that it isn't makes it fairly obvious that the refresh is not working properly. I have a serverity 1 TAR open now with Oracle, but so far all that's been accomplished with the TAR is me repeating everything I included initially. Any advice appreciated, as it's rather important to get this working again. Jared Jared, What about the refresh jobs ? Does DBA_JOBS show failures ? If so, can you wrap the dbms_refresh call into something to catch the error ? (if you feel lazy I think that there is code to this effect on the Oriole site in one of the 'Aunt Augusta' papers). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: select count(case ...) slow in PL/SQL, any better way?
Seems to be different queries to me:
select count(case ... ) into count1,
count(case ... ) into count2
from isi.nametag
suggests a full scan on isi.nametag whereas the two
separate queries:
select count(*) from isi.nametag where geneid=geneid1
select count(*) from isi.nametag where geneid=geneid2
have the benefit of a predicate. You could always try
select count(case ... ) into count1,
count(case ... ) into count2
from isi.nametag
where geneid in (geneid1,geneid2)
hth
connor
--- Darrell Landrum [EMAIL PROTECTED] wrote:
I thought case in PL/SQL was not available until 9i.
I'll have to look that up.
[EMAIL PROTECTED] 02/24/03 04:38PM
I too faced the problem of case not working in
pl/sql procedures. So I
created a view.
Would creating a view work for you ?
-Original Message-
Sent: Monday, February 24, 2003 3:07 PM
To: Multiple recipients of list ORACLE-L
Hi:
Oracle 8173 on Sun Solaris 2.8. I am trying to
optimize the follwoing code
(in an PL/SQL package) into one table call (instead
of two)
select count(1) into count1 from isi.nametag where
geneid=geneid1;
select count(1) into count2 from isi.nametag where
geneid=geneid2;
The following code works in sqlplus, but not in
PL/SQL:
select count(case when geneid=geneid1 then 1 else
null end ) into count1,
count(case when geneid=geneid2 then 1
else null end ) into count2
from isi.nametag ;
I have to use dynamic sql to get around this
problem. But it's perofrmance
is horrible.
SQL set serveroutput on
SQL declare
2i number:=0;
3str varchar2(200);
4 count1 number;
5count2 number;
6 begin
7str := 'select count(case when geneid=:x1
then 1 else null end ) ,
8 count(case when geneid=:x2 then
1 else null end )
9from isi.nametag';
10for x1 in 1 .. 10 Loop
11 for x2 in 20 .. 30 Loop
12 i := i +1;
13 EXECUTE IMMEDIATE str INTO count1,
count2 USING x1, x2;
14 end loop;
15end loop;
16dbms_output.put_line('i =' || i);
17 end;
18 /
i =110
PL/SQL procedure successfully completed.
Elapsed: 00:00:10.96
SQL declare
2 i number:=0;
3 count1 number;
4count2 number;
5 begin
6for x1 in 1 .. 100 Loop
7 for x2 in 200 .. 300 Loop
8i := i +1;
9 select count(1) into count1 from
isi.nametag where geneid=x1;
10 select count(1) into count2 from
isi.nametag where geneid=x2;
11 end loop;
12end loop;
13dbms_output.put_line('i =' || i);
14 end;
15 /
i =10100
PL/SQL procedure successfully completed.
Elapsed: 00:00:04.06
Is there a better way to optimize the orginal code?
TIA.
Guang Mei
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net
--
Author: gmei
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
http://www.fatcity.com
San Diego, California-- Mailing list and web
hosting services
-
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(or the name 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.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
-
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(or the name 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.net
--
Author: Darrell Landrum
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
http://www.fatcity.com
San Diego, California-- Mailing list and web
hosting services
-
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(or the name of mailing list you want to be removed
from). You may
also send the HELP command for other information
(like subscribing).
=
Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: [EMAIL PROTECTED]
GIVE a man a fish and he will eat for a day. But TEACH
Re: Unix variable question
Hello Sinardy,
Tuesday, February 25, 2003, 3:28:42 PM, you wrote:
SX Hi all,
SX Can someone help me understand this...
SX ROOT # TEST=${2:-.}
SX ROOT # echo $TEST
SX ROOT #.
SX what is 2:-.
The construction ${A:-B} is just like oracle nvl function. If variable
A is defined and not null then result is A else B.
--
Best regards,
Sergeymailto:[EMAIL PROTECTED]
ICQ 160079606
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sergey V Dolgov
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Unix variable question
look into man page eg bash or sh and search for ${ (is type in /\$\{ )
and find all necessary details.
lol
Apologies for any typing mistakes I failed to notice.
Markus Reger
Oracle Applications DBA
Webmaster
MBC
University for Music and Performing Art
Vienna
[EMAIL PROTECTED] 02/25/03 11:14 AM
Hi all,
Can someone help me understand this...
ROOT # TEST=${2:-.}
ROOT # echo $TEST
ROOT #.
what is 2:-.
another similar code
ROOT # TEST=${1:-0}
ROOT # echo $TEST
ROOT # 0
they looks like emoticon for me
Thank you
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name 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.net
--
Author: Markus Reger
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Openssl security breach detected - oracle concerned?
hello to everybody recently a security breach was detected with OpenSSL - the password of a user could be decoded within hours, the bank account was robbed - but just for testing purposes - has anyone ever heard about a similar problem regarding to oracle ssl. we use it and i couldn't find a patch for this particular problem if there is any with oracle's ssl. kind regards Apologies for any typing mistakes I failed to notice. Markus Reger Oracle Applications DBA Webmaster MBC University for Music and Performing Art Vienna -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Materialized views not refreshing
Probably a little obvious, but what do you get when you slap a trace on the refresh job (on both source and target db's) - do you see any attempt to read rows from the mview log at all? any updates being attempted on the target? hth connor --- Jared Still [EMAIL PROTECTED] wrote: Dear list, Have any of you every experienced MV's not refreshing for no particular reason? We have been using some simple MV's for several months with no problem. Now after upgrading our app and database, there seem to be problems. Servers: Master: Win2k SP2 Oracle 8.1.7.4.1 Slave: NT 4 SP6 Oracle 8.1.7.4.1 These databases were previously 8.1.6. The master database now has a UTF8 character set, and all tables have NVARCHAR2 columns. These are being converted in the MV using: translate(COLUMN_NAME using char_cs) COLUMN_NAME when creating the MV. There are no errors, no trace files. Data is updated on the master node and never appears in the slave. The data continues to persist in the MLOG$ tables. I've verified there is only a single MV against each MV LOG, so the data in MLOG$ should be truncated after a refresh, but the fact that it isn't makes it fairly obvious that the refresh is not working properly. I have a serverity 1 TAR open now with Oracle, but so far all that's been accomplished with the TAR is me repeating everything I included initially. Any advice appreciated, as it's rather important to get this working again. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OFF TOPIC: Jedis, etc - was Top 10....
Not true. This isn't a list for urban myths - if you're going to go off-topic, you could at least do it accurately. :-) http://www.statistics.gov.uk/cci/nugget.asp?id=293 It would seem you have the definitive source. However, I wasn't just repeating something I heard down the pub. I was actually quoting direct from the most recent issue of The Week a serious UK weekly news magazine. A google search seems to show that many others have also been hoodwinked http://www.channel4.com/news/2003/02/week_2/13census.html http://www.ananova.com/news/story/sm_750289.html Sigh, quality journalism that. I guess I should have dug a bit further before repeating it. Oh bother, I'm still off-topic, soy... -Dale Sikh - 336,000 people. Jewish - 267,000 people. Buddhist - 152,000 people. Jedi was classified under 'Other religion' along with Druidism, Satanism, Wicca, Pagan, Freethinker, etc, etc. The total for ALL these was only 179,000. Of course, Jedi only got as many 'votes' as it did because of a spoof email which tried to convince people that it would make it into an 'official' religion. Which is, of course, complete twaddle! -- Peter Moore Systems DBA, SchlumbergerSema, Reading -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 08:14 To: Multiple recipients of list ORACLE-L Subject: Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, Perhaps we depend to much on the force to guide and protect us at times... :-) Laugh you may, but in the last UK census (not a poll mind you but the actual national census) 400,000 people indicated their religion was Jedi. This was more than put their religion as Sikh, Jewish or Buddhist. Of course its just a re-hash of Vitalisim, but (Oh dear, now I've annoyed nearly half a million people and all of 'em on the same tiny island as me :-) -Dale -- Generate HTML schema documentation with the free DDL to HTML converter. DBATool: http://www.DataBee.com/dt_home.htm _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MOORE, Peter Rbh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OFF TOPIC: Jedis, etc - was Top 10....
Actually Peter, This came under the category of No Religion which had 9+ million people in it (15.5% of respondents, see below). About sixteen per cent of the UK population stated that they had no religion. This category included agnostics, atheists, heathens and those who wrote Jedi Knight. And there is no such thing as an 'unofficial' religion. It's just whether people recognise it or not. DarthK. -Original Message- Sent: 25 February 2003 09:39 To: Multiple recipients of list ORACLE-L Not true. This isn't a list for urban myths - if you're going to go off-topic, you could at least do it accurately. :-) http://www.statistics.gov.uk/cci/nugget.asp?id=293 Sikh - 336,000 people. Jewish - 267,000 people. Buddhist - 152,000 people. Jedi was classified under 'Other religion' along with Druidism, Satanism, Wicca, Pagan, Freethinker, etc, etc. The total for ALL these was only 179,000. Of course, Jedi only got as many 'votes' as it did because of a spoof email which tried to convince people that it would make it into an 'official' religion. Which is, of course, complete twaddle! -- Peter Moore Systems DBA, SchlumbergerSema, Reading -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 08:14 To: Multiple recipients of list ORACLE-L Subject: Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, Perhaps we depend to much on the force to guide and protect us at times... :-) Laugh you may, but in the last UK census (not a poll mind you but the actual national census) 400,000 people indicated their religion was Jedi. This was more than put their religion as Sikh, Jewish or Buddhist. Of course its just a re-hash of Vitalisim, but (Oh dear, now I've annoyed nearly half a million people and all of 'em on the same tiny island as me :-) -Dale -- Generate HTML schema documentation with the free DDL to HTML converter. DBATool: http://www.DataBee.com/dt_home.htm _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MOORE, Peter Rbh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Materialized views not refreshing
You're right, it is obvious, but I hadn't yet done it. The thought had occurred to me to do this at both nodes, but I think lack of sleep has dulled my senses a bit and I forgot to do it. All the work involved in repeating myself in the TAR maybe, I dunno. I've dropped and recreated the offending MV's and associated logs: they seem to be working now. All very strange. I'm going to trace both ends if it acts up again. Thanks, Jared On Tuesday 25 February 2003 02:29, Connor McDonald wrote: Probably a little obvious, but what do you get when you slap a trace on the refresh job (on both source and target db's) - do you see any attempt to read rows from the mview log at all? any updates being attempted on the target? hth connor --- Jared Still [EMAIL PROTECTED] wrote: Dear list, Have any of you every experienced MV's not refreshing for no particular reason? We have been using some simple MV's for several months with no problem. Now after upgrading our app and database, there seem to be problems. Servers: Master: Win2k SP2 Oracle 8.1.7.4.1 Slave: NT 4 SP6 Oracle 8.1.7.4.1 These databases were previously 8.1.6. The master database now has a UTF8 character set, and all tables have NVARCHAR2 columns. These are being converted in the MV using: translate(COLUMN_NAME using char_cs) COLUMN_NAME when creating the MV. There are no errors, no trace files. Data is updated on the master node and never appears in the slave. The data continues to persist in the MLOG$ tables. I've verified there is only a single MV against each MV LOG, so the data in MLOG$ should be truncated after a refresh, but the fact that it isn't makes it fairly obvious that the refresh is not working properly. I have a serverity 1 TAR open now with Oracle, but so far all that's been accomplished with the TAR is me repeating everything I included initially. Any advice appreciated, as it's rather important to get this working again. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: SQL Server developers' kerfuffle
http://www.theregister.co.uk/content/53/29419.html Regards, Pat. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: security alerts #48, 49, 50, 51 - patchsets, 9i
Title: RE: security alerts #48, 49, 50, 51 - patchsets, 9i Here is an article on this topic. http://www3.gartner.com/DisplayDocument?doc_cd=113293 Regards, Pat.
Re: Materialized views not refreshing
No errors, no trace files. Refreshing via refresh group or directly via the snapshot both failed to update the MV. They've since been recreated and are working at the moment. I'll slap a big ole note on my forehead that says 'run a trace on them stupid!' so I will remember to do so if these start failing again. Off to bed for me. Jared On Tuesday 25 February 2003 02:29, Stephane Faroult wrote: Dear list, Have any of you every experienced MV's not refreshing for no particular reason? We have been using some simple MV's for several months with no problem. Now after upgrading our app and database, there seem to be problems. Servers: Master: Win2k SP2 Oracle 8.1.7.4.1 Slave: NT 4 SP6 Oracle 8.1.7.4.1 These databases were previously 8.1.6. The master database now has a UTF8 character set, and all tables have NVARCHAR2 columns. These are being converted in the MV using: translate(COLUMN_NAME using char_cs) COLUMN_NAME when creating the MV. There are no errors, no trace files. Data is updated on the master node and never appears in the slave. The data continues to persist in the MLOG$ tables. I've verified there is only a single MV against each MV LOG, so the data in MLOG$ should be truncated after a refresh, but the fact that it isn't makes it fairly obvious that the refresh is not working properly. I have a serverity 1 TAR open now with Oracle, but so far all that's been accomplished with the TAR is me repeating everything I included initially. Any advice appreciated, as it's rather important to get this working again. Jared Jared, What about the refresh jobs ? Does DBA_JOBS show failures ? If so, can you wrap the dbms_refresh call into something to catch the error ? (if you feel lazy I think that there is code to this effect on the Oriole site in one of the 'Aunt Augusta' papers). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Openssl security breach detected - oracle concerned?
You would have to verify what version of SSL. http://www.theregister.co.uk/content/55/29423.html yesterday posted a notice that the experiment was with an older version of SSL. It could be that iAS and other Oracle products are still using that version, I know they were way behind in the Apache release they bundled in iAS 1.0.2.2 I would be curious to learn what you find out. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 25, 2003 6:50 AM To: Multiple recipients of list ORACLE-L hello to everybody recently a security breach was detected with OpenSSL - the password of a user could be decoded within hours, the bank account was robbed - but just for testing purposes - has anyone ever heard about a similar problem regarding to oracle ssl. we use it and i couldn't find a patch for this particular problem if there is any with oracle's ssl. kind regards Apologies for any typing mistakes I failed to notice. Markus Reger Oracle Applications DBA Webmaster MBC University for Music and Performing Art Vienna -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OFF TOPIC: Jedis, etc - was Top 10....
And there is no such thing as an 'unofficial' religion. It's just whether people recognise it or not. Damn funny! I agree that there's no such thing as an unofficial religion but surely there is nobody (excepting the heavily medicated and chronically deluded) who truly believes that they are a jedi knight. They must be as much fun as the guys with Klingon dictionaries and transporter rooms in their loft. Mike PS I can feel the take this off-list bar lowering even as I speak. -Original Message- Sent: 25 February 2003 11:20 To: Multiple recipients of list ORACLE-L Actually Peter, This came under the category of No Religion which had 9+ million people in it (15.5% of respondents, see below). About sixteen per cent of the UK population stated that they had no religion. This category included agnostics, atheists, heathens and those who wrote Jedi Knight. And there is no such thing as an 'unofficial' religion. It's just whether people recognise it or not. DarthK. ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277. This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Performance Monitor
On iAS 1.0.2.2.0 with 8.1.7.4.x NT Server 4 server. The Oracle performance counters don't load, Metalink hasn't been able to come up with an answer yet. Has anyone been able to load these counters on an iAS server? To confuse the issue further, we installed a db on the iAS server itself -- so we have three Oracle Homes. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OFF TOPIC: Jedis, etc - was Top 10....
GRIN... That buzzing sound you just heard was me powering up!! Back off buster ;O) -Original Message- Sent: 25 February 2003 12:24 To: Multiple recipients of list ORACLE-L And there is no such thing as an 'unofficial' religion. It's just whether people recognise it or not. Damn funny! I agree that there's no such thing as an unofficial religion but surely there is nobody (excepting the heavily medicated and chronically deluded) who truly believes that they are a jedi knight. They must be as much fun as the guys with Klingon dictionaries and transporter rooms in their loft. Mike PS I can feel the take this off-list bar lowering even as I speak. -Original Message- Sent: 25 February 2003 11:20 To: Multiple recipients of list ORACLE-L Actually Peter, This came under the category of No Religion which had 9+ million people in it (15.5% of respondents, see below). About sixteen per cent of the UK population stated that they had no religion. This category included agnostics, atheists, heathens and those who wrote Jedi Knight. And there is no such thing as an 'unofficial' religion. It's just whether people recognise it or not. DarthK. ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277. This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
8.1.7.4.8 patch coming
Last word is that it should be available within 2-3, maybe sooner. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Materialized views not refreshing
Is the job even firing at all? It is a common step in upgrading to set job_queue_processes=0 and this will prevent materialized views from refreshing automatically. Make sure this is greater than 0; I normally set it to 2. [EMAIL PROTECTED] 02/25/03 04:29AM Dear list, Have any of you every experienced MV's not refreshing for no particular reason? We have been using some simple MV's for several months with no problem. Now after upgrading our app and database, there seem to be problems. Servers: Master: Win2k SP2 Oracle 8.1.7.4.1 Slave: NT 4 SP6 Oracle 8.1.7.4.1 These databases were previously 8.1.6. The master database now has a UTF8 character set, and all tables have NVARCHAR2 columns. These are being converted in the MV using: translate(COLUMN_NAME using char_cs) COLUMN_NAME when creating the MV. There are no errors, no trace files. Data is updated on the master node and never appears in the slave. The data continues to persist in the MLOG$ tables. I've verified there is only a single MV against each MV LOG, so the data in MLOG$ should be truncated after a refresh, but the fact that it isn't makes it fairly obvious that the refresh is not working properly. I have a serverity 1 TAR open now with Oracle, but so far all that's been accomplished with the TAR is me repeating everything I included initially. Any advice appreciated, as it's rather important to get this working again. Jared Jared, What about the refresh jobs ? Does DBA_JOBS show failures ? If so, can you wrap the dbms_refresh call into something to catch the error ? (if you feel lazy I think that there is code to this effect on the Oriole site in one of the 'Aunt Augusta' papers). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Materialized views not refreshing
We had the problem where the M$LOG was not being purged after the materialized view was updated. That doesn't seem to be your problem though. Jared Still jkstill To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @cybcon.com cc: Sent by: rootSubject: Re: Materialized views not refreshing 02/25/2003 06:49 AM Please respond to ORACLE-L No errors, no trace files. Refreshing via refresh group or directly via the snapshot both failed to update the MV. They've since been recreated and are working at the moment. I'll slap a big ole note on my forehead that says 'run a trace on them stupid!' so I will remember to do so if these start failing again. Off to bed for me. Jared On Tuesday 25 February 2003 02:29, Stephane Faroult wrote: Dear list, Have any of you every experienced MV's not refreshing for no particular reason? We have been using some simple MV's for several months with no problem. Now after upgrading our app and database, there seem to be problems. Servers: Master: Win2k SP2 Oracle 8.1.7.4.1 Slave: NT 4 SP6 Oracle 8.1.7.4.1 These databases were previously 8.1.6. The master database now has a UTF8 character set, and all tables have NVARCHAR2 columns. These are being converted in the MV using: translate(COLUMN_NAME using char_cs) COLUMN_NAME when creating the MV. There are no errors, no trace files. Data is updated on the master node and never appears in the slave. The data continues to persist in the MLOG$ tables. I've verified there is only a single MV against each MV LOG, so the data in MLOG$ should be truncated after a refresh, but the fact that it isn't makes it fairly obvious that the refresh is not working properly. I have a serverity 1 TAR open now with Oracle, but so far all that's been accomplished with the TAR is me repeating everything I included initially. Any advice appreciated, as it's rather important to get this working again. Jared Jared, What about the refresh jobs ? Does DBA_JOBS show failures ? If so, can you wrap the dbms_refresh call into something to catch the error ? (if you feel lazy I think that there is code to this effect on the Oriole site in one of the 'Aunt Augusta' papers). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
alertlog naming
Hi, On one of our customers site (WINDOWS) we have databases that have alertlogs with the name sidALRT.LOGsidALRT.LOG (double the normal name) and oracle keeps on writing to it. I thought if a file is renamed oracle will create a new alertlog when needed. I have a php script that reads the alrtlogs and reports the errors in web browser and than renames the current alertlog to sidALRT.LOG.mmdd Can it be that when there is writing action in the file oracle will get confused and screw up the renaming bit? (I thought windows did not allow changing filenames of open files) One of the databases on this customers site every now and than hangs with no messages in the alert logs and does not allow any connections anymore(No errors reported back to client). This database needs to be up and running asap so when it happens we don't get much time to investigate and restart the service. We can still connect with svrmgrl and internal (wasn't this supposed to go in 8.1.7). What would be the best course of action to quickly gather the releavnt data next time this happens. Has anybody seen this before and knows the solution? W2K Oracle 8.1.7.0.0 EE Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: mailto:[EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Materialized views not refreshing
Jared, Does it work if you do a manual refresh? Henry -Original Message- Sent: Tuesday, February 25, 2003 3:49 AM To: Multiple recipients of list ORACLE-L Dear list, Have any of you every experienced MV's not refreshing for no particular reason? We have been using some simple MV's for several months with no problem. Now after upgrading our app and database, there seem to be problems. Servers: Master: Win2k SP2 Oracle 8.1.7.4.1 Slave: NT 4 SP6 Oracle 8.1.7.4.1 These databases were previously 8.1.6. The master database now has a UTF8 character set, and all tables have NVARCHAR2 columns. These are being converted in the MV using: translate(COLUMN_NAME using char_cs) COLUMN_NAME when creating the MV. There are no errors, no trace files. Data is updated on the master node and never appears in the slave. The data continues to persist in the MLOG$ tables. I've verified there is only a single MV against each MV LOG, so the data in MLOG$ should be truncated after a refresh, but the fact that it isn't makes it fairly obvious that the refresh is not working properly. I have a serverity 1 TAR open now with Oracle, but so far all that's been accomplished with the TAR is me repeating everything I included initially. Any advice appreciated, as it's rather important to get this working again. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.7.4.8 patch coming
That's weeks, not days. Pat. -Original Message- Sent: Tuesday, February 25, 2003 8:49 AM To: Multiple recipients of list ORACLE-L Last word is that it should be available within 2-3, maybe sooner. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Embeded password in script
Title: RE: Embeded password in script
Thank you, Jared. I have the book you wrote and will look into it.
Regards,
David
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 24, 2003 4:51 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Embeded password in script
The 'hide.c' program can be implemented and compiled to prevent
parameters from appearing to ps. I believe it still works properly on
most flavors of unix.
For the Perl for Oracle DBA's book we wrote one utililty that I had
wanted for some time, a password database.
For jobs that I plan to run regularly from cron, I use the password
daemon pwd.pl and retrieve the passwords across the network
( encrypted with MD5 ).
If the job is a Perl script ( fairly likely around here ) the password
can't appear to PS, as no password is ever used on the command
line.
It's handy for command line stuff as well, as I only need rights to
access the password database via the password daemon. I don't
have to know the database passwords to login to the account.
e.g. sqlplus system/$(pwc.pl -instance dv01 -username jkstill)@dv01
This is the single most useful utility we put in that book IMO.
Jared
On Monday 24 February 2003 14:02, STEVE OLLIG wrote:
i'll take the first one...
on UNIX you could use a secret hidden file with appropriate permissions
where each line has the format ORACLE_SID:USER:password
then use awk to parse the file for the line with the correct $ORACLE_SID
and $USER, and set an environment variable to the password string. Then
your scripts could use that variable with sqlplus instead of the hardcoded
password.
in ksh it could look something like this:
export password=\
`awk -F: '$1 == sid $2 == dbimpl {print $3}' mySecretHiddenFile`
be warned that if you call sqlplus like this in your scripts:
sqlplus dbimpl/${password} @SQLscript.sql
someone could still see the Oracle password with a sneaky ps command while
your script is running.
a very similar approach could be taken with perl if awk isn't your cup of
tea.
-Original Message-
Sent: Monday, February 24, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
I have been tasked to write a script to run SQL. I don't want a password
field to be shown in the script. Does someone have run into this and have
a better idea? For example, I have following line in my script.
Sqlplus dbimpl/password @SQLscript.sql
Also, from command line we go through following steps to shutdown database,
how do I code these steps in the script?
$svrmgrl
SVRMGRLconnect internal
SVRMGRLshutdown
Thanks in advance,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: OFF TOPIC: Jedis, etc - was Top 10....
No, no this is very relevant to a DBA. We should learn the Jedi mind tricks. I need to denormalize this table. No you don't want to denormalize that table. No I don't want to denormalize this table. You want to go back to your desk and not bother the DBA. I want to go back to my desk and not bother the DBA. A religion that you don't need to study a book, just see some movies? Nah. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 25, 2003 6:54 AM To: Multiple recipients of list ORACLE-L GRIN... That buzzing sound you just heard was me powering up!! Back off buster ;O) -Original Message- Sent: 25 February 2003 12:24 To: Multiple recipients of list ORACLE-L And there is no such thing as an 'unofficial' religion. It's just whether people recognise it or not. Damn funny! I agree that there's no such thing as an unofficial religion but surely there is nobody (excepting the heavily medicated and chronically deluded) who truly believes that they are a jedi knight. They must be as much fun as the guys with Klingon dictionaries and transporter rooms in their loft. Mike PS I can feel the take this off-list bar lowering even as I speak. -Original Message- Sent: 25 February 2003 11:20 To: Multiple recipients of list ORACLE-L Actually Peter, This came under the category of No Religion which had 9+ million people in it (15.5% of respondents, see below). About sixteen per cent of the UK population stated that they had no religion. This category included agnostics, atheists, heathens and those who wrote Jedi Knight. And there is no such thing as an 'unofficial' religion. It's just whether people recognise it or not. DarthK. ** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify [EMAIL PROTECTED] (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277. This e-mail may be sent on behalf of a member of the Innogy group of companies. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
MTS config
OK, Someone dope slap me! I added the following to my init.ora file (8.1.7.0 on HP-UX 11.0). The dispatchers start up just fine, but won't register with the listener (also 8.1.7.0). I've already done the RTFM and MetaLink RTFM but can't see the problem. mts_servers=5 mts_max_dispatchers=10 mts_max_servers=40 service_names=05 # mts_dispatchers=(PROTOCOL=ipc)(DISPATCHERS=2) mts_dispatchers=(PROTOCOL=TCP)(DISPATCHERS=4) local_listener=(address_list=(ADDRESS=(PROTOCOL=ipc)(KEY=05)) (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=bart))) Thanks for the second set of eyes. BTW, the end result would be to have all outside TCP connections use MTS only. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Openssl security breach detected - oracle concerned?
The recently installed 9i rel2 pachted to 9.2.0.2.0 uses openssl version 0.9.6b The latest version is 0.9.7a was 0.9.6i. Compile and then just change the file will most likely not work, will it? kr Apologies for any typing mistakes I failed to notice. Markus Reger Oracle Applications DBA Webmaster MBC University for Music and Performing Art Vienna [EMAIL PROTECTED] 02/25/03 13:28 PM You would have to verify what version of SSL. http://www.theregister.co.uk/content/55/29423.html yesterday posted a notice that the experiment was with an older version of SSL. It could be that iAS and other Oracle products are still using that version, I know they were way behind in the Apache release they bundled in iAS 1.0.2.2 I would be curious to learn what you find out. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 25, 2003 6:50 AM To: Multiple recipients of list ORACLE-L hello to everybody recently a security breach was detected with OpenSSL - the password of a user could be decoded within hours, the bank account was robbed - but just for testing purposes - has anyone ever heard about a similar problem regarding to oracle ssl. we use it and i couldn't find a patch for this particular problem if there is any with oracle's ssl. kind regards Apologies for any typing mistakes I failed to notice. Markus Reger Oracle Applications DBA Webmaster MBC University for Music and Performing Art Vienna -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
performance issues on sun
All We are attempting to move some applications off Compaq T64 into Sun Solaris 8 and running into performance issues. I am trying to rebuild an index which is taking more than 3 1/2 hours while it used to take 20 min on T64. I find most of the waits on DIRECT PATH READS and DIRECT PATH WRITES. The index tablespace and the temporary tablespace are on separate mountpoints which reside on separate disks. I am doing a truss on the session and see that its doing the following kaio(AIOWAIT, 0x) Err#22 EINVAL pread(364, \b02\0\0\v\099E1 f h ECB.., 1048576, 0x26784000) = 1048576 kaio(AIOWAIT, 0x) Err#22 EINVAL lwp_cond_wait(0x7CED7F70, 0x7CED7F80, 0x) = 0 pwrite(408, 0602\0\0\nC41007 f h SDD.., 49152, 0x10401C000) = 49152 pwrite(408, 0602\0\0\nC410\n f h SDD.., 49152, 0x104028000) = 49152 pwrite(408, 0602\0\0\nC410\r f h SDD.., 49152, 0x104034000) = 49152 pwrite(408, 0602\0\0\nC41010 f h SDD.., 49152, 0x10404) = 49152 pwrite(408, 0602\0\0\nC41013 f h SDD.., 49152, 0x10404C000) = 49152 pwrite(408, 0602\0\0\nC41016 f h SDD.., 49152, 0x104058000) = 49152 pwrite(408, 0602\0\0\nC41019 f h SDD.., 49152, 0x104064000) = 49152 pwrite(408, 0602\0\0\nC4101C f h SDD.., 49152, 0x10407) = 49152 pwrite(408, 0602\0\0\nC4101F f h SDD.., 49152, 0x10407C000) = 49152 pwrite(408, 0602\0\0\nC410 f h SDD.., 49152, 0x104088000) = 49152 pwrite(408, 0602\0\0\nC410 % f h SDD.., 49152, 0x104094000) = 49152 pwrite(408, 0602\0\0\nC410 ( f h SDD.., 49152, 0x1040A) = 49152 pwrite(408, 0602\0\0\nC410 + f h SDD.., 49152, 0x1040AC000) = 49152 pwrite(408, 0602\0\0\nC410 . f h SDD.., 49152, 0x1040B8000) = 49152 pwrite(408, 0602\0\0\nC410 1 f h SDD.., 49152, 0x1040C4000) = 49152 pwrite(408, 0602\0\0\nC410 4 f h SDD.., 49152, 0x1040D) = 49152 fdsync(408, O_RDONLY|O_SYNC)= 0 pwrite(408, 0602\0\0\nC410 7 f h SDE.., 49152, 0x1040DC000) = 49152 pwrite(408, 0602\0\0\nC410 : f h SDE.., 49152, 0x1040E8000) = 49152 pwrite(408, 0602\0\0\nC410 = f h SDE.., 49152, 0x1040F4000) = 49152 pwrite(408, 0602\0\0\nC410 @ f h SDE.., 49152, 0x10410) = 49152 pwrite(408, 0602\0\0\nC410 C f h SDE.., 49152, 0x10410C000) = 49152 lwp_cond_wait(0x7CF0DF70, 0x7CF0DF80, 0x) = 0 lwp_cond_signal(0x7CF0DF70) = 0 pread(364, \b02\0\0\v\09A ! f h ECB.., 16384, 0x26884000) = 16384 I think it is trying to do a KAIO call and failing. Then it attempts a synchronous PWRITE call. But our SAs are not able to help us to confirm this. Have any of you seen this issue? Any inputs would be greatly appreciated. I'll gladly provide you with addl info if you need. Thanks in advance Babu _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Set Email alert at NT
Do a rewrite in Perl to run it on Windows.
There is am smtp module for Perl that will allow you to inject an message
straight to a mail server.
You could then use that both on Unix and windows
Cheers
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane, AustraliaMobile: +61 (0)402 094 238
Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.
- Walter Bagehot (1826-1877 British Economist)
=
Mincom The People, The Experience, The Vision
=
This transmission is for the intended addressee only and is confidential
information. If you have received this transmission in error, please
delete it and notify the sender. The contents of this e-mail are the
opinion of the writer only and are not endorsed by the Mincom Group of
companies unless expressly stated otherwise.
Mitchell [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
22-02-2003 05:59 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Set Email alert at NT
Hi
The following sh is one I used for monitoring all 20 instances on unix
boxes(aix and sun). So I could receive the ora message by palm. Now there
are 2 nt box with Oracle 8.17 installed. I have no idea how to do it in
windows. Any idea?
This is my ksh and run as cron job every 30 min.
if [$(cat $ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log |
grep 'ORA' | wc -l) -gt 0 ];
then
cat $ORACLE_HOME/admin/$ORACLE_SID/bdump/alert_${ORACLE_SID}.log | grep
'ORA' $HOME/alert_me
mailx -s Warning: ${ORACLE_SID} Oracle Alert: ORA_error !!! [EMAIL PROTECTED]
$HOME/alert_me
fi
Thanks in advance.
Mitchell
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Oracle Performance Monitor
try operfcfg Usage: OPerfCfg [-U username] [-P password] [-D [database name]] steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 6:44 AM On iAS 1.0.2.2.0 with 8.1.7.4.x NT Server 4 server. The Oracle performance counters don't load, Metalink hasn't been able to come up with an answer yet. Has anyone been able to load these counters on an iAS server? To confuse the issue further, we installed a db on the iAS server itself -- so we have three Oracle Homes. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: installation / recovery question
Take a backup of C:\Program Files\Oracle and copy it back if you plan to go with import/export of registry keys Regards Naveen DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.7.4.8 patch coming
What platform? Isn't the 5th number platform-specific? (I forget) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, February 25, 2003 8:11 AM To: Multiple recipients of list ORACLE-L That's weeks, not days. Pat. -Original Message- Sent: Tuesday, February 25, 2003 8:49 AM To: Multiple recipients of list ORACLE-L Last word is that it should be available within 2-3, maybe sooner. Regards, Patrice Boivin -- 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MTS config
Hi, We're unfortunately still on 7.3.4.5 and this is how my mts config looks: mts_dispatchers=ipc,10, tcp,15 mts_servers=10 mts_service=VU_2 mts_listener_address=(ADDRESS=(PROTOCOL=ipc)(KEY=VU_2)) mts_listener_address=(ADDRESS=(PROTOCOL=tcp)(HOST=stirling)(PORT=1526)) mts_max_dispatchers=40 mts_max_servers=40 differences are in mts_service and I don't use / don't have someting like local_listener but just defined an extra entru in tnsnnames for a dedicated connection. I'm not that deep in sqlnet config that I can point out u'r problem but hopes this helps, Regards, Jeroen -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 25 februari 2003 15:04 Aan: Multiple recipients of list ORACLE-L Onderwerp: MTS config OK, Someone dope slap me! I added the following to my init.ora file (8.1.7.0 on HP-UX 11.0). The dispatchers start up just fine, but won't register with the listener (also 8.1.7.0). I've already done the RTFM and MetaLink RTFM but can't see the problem. mts_servers=5 mts_max_dispatchers=10 mts_max_servers=40 service_names=05 # mts_dispatchers=(PROTOCOL=ipc)(DISPATCHERS=2) mts_dispatchers=(PROTOCOL=TCP)(DISPATCHERS=4) local_listener=(address_list=(ADDRESS=(PROTOCOL=ipc)(KEY=05)) (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=bart))) Thanks for the second set of eyes. BTW, the end result would be to have all outside TCP connections use MTS only. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: performance issues on sun
Babu - I would recommend checking: - Where is the tablespace of the table? Shared disk with temp or index tablespace? - Check your SORT_AREA_SIZE on both systems. - Do some basic disk I/O tests. On both the Compaq and Solaris, move a large file from one drive to another, just to see what time it takes. If the Solaris system is significantly slower, discuss this with your system administrators. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 25, 2003 8:11 AM To: Multiple recipients of list ORACLE-L All We are attempting to move some applications off Compaq T64 into Sun Solaris 8 and running into performance issues. I am trying to rebuild an index which is taking more than 3 1/2 hours while it used to take 20 min on T64. I find most of the waits on DIRECT PATH READS and DIRECT PATH WRITES. The index tablespace and the temporary tablespace are on separate mountpoints which reside on separate disks. I am doing a truss on the session and see that its doing the following kaio(AIOWAIT, 0x) Err#22 EINVAL pread(364, \b02\0\0\v\099E1 f h ECB.., 1048576, 0x26784000) = 1048576 kaio(AIOWAIT, 0x) Err#22 EINVAL lwp_cond_wait(0x7CED7F70, 0x7CED7F80, 0x) = 0 pwrite(408, 0602\0\0\nC41007 f h SDD.., 49152, 0x10401C000) = 49152 pwrite(408, 0602\0\0\nC410\n f h SDD.., 49152, 0x104028000) = 49152 pwrite(408, 0602\0\0\nC410\r f h SDD.., 49152, 0x104034000) = 49152 pwrite(408, 0602\0\0\nC41010 f h SDD.., 49152, 0x10404) = 49152 pwrite(408, 0602\0\0\nC41013 f h SDD.., 49152, 0x10404C000) = 49152 pwrite(408, 0602\0\0\nC41016 f h SDD.., 49152, 0x104058000) = 49152 pwrite(408, 0602\0\0\nC41019 f h SDD.., 49152, 0x104064000) = 49152 pwrite(408, 0602\0\0\nC4101C f h SDD.., 49152, 0x10407) = 49152 pwrite(408, 0602\0\0\nC4101F f h SDD.., 49152, 0x10407C000) = 49152 pwrite(408, 0602\0\0\nC410 f h SDD.., 49152, 0x104088000) = 49152 pwrite(408, 0602\0\0\nC410 % f h SDD.., 49152, 0x104094000) = 49152 pwrite(408, 0602\0\0\nC410 ( f h SDD.., 49152, 0x1040A) = 49152 pwrite(408, 0602\0\0\nC410 + f h SDD.., 49152, 0x1040AC000) = 49152 pwrite(408, 0602\0\0\nC410 . f h SDD.., 49152, 0x1040B8000) = 49152 pwrite(408, 0602\0\0\nC410 1 f h SDD.., 49152, 0x1040C4000) = 49152 pwrite(408, 0602\0\0\nC410 4 f h SDD.., 49152, 0x1040D) = 49152 fdsync(408, O_RDONLY|O_SYNC)= 0 pwrite(408, 0602\0\0\nC410 7 f h SDE.., 49152, 0x1040DC000) = 49152 pwrite(408, 0602\0\0\nC410 : f h SDE.., 49152, 0x1040E8000) = 49152 pwrite(408, 0602\0\0\nC410 = f h SDE.., 49152, 0x1040F4000) = 49152 pwrite(408, 0602\0\0\nC410 @ f h SDE.., 49152, 0x10410) = 49152 pwrite(408, 0602\0\0\nC410 C f h SDE.., 49152, 0x10410C000) = 49152 lwp_cond_wait(0x7CF0DF70, 0x7CF0DF80, 0x) = 0 lwp_cond_signal(0x7CF0DF70) = 0 pread(364, \b02\0\0\v\09A ! f h ECB.., 16384, 0x26884000) = 16384 I think it is trying to do a KAIO call and failing. Then it attempts a synchronous PWRITE call. But our SAs are not able to help us to confirm this. Have any of you seen this issue? Any inputs would be greatly appreciated. I'll gladly provide you with addl info if you need. Thanks in advance Babu _ This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of
RE: How long to hold onto old Oracle CDs?
Keep your CDs forever. I once had a job that frequently required producing data for our very efficient legal system. It was not unusual for requests for information from attorneys to go back ten years. We had a really good librarian, the media was always available. Sometimes building an old database or finding the right compression algorithm was a challenge. --- Adams, Matthew (GECP, MABG, 088130) [EMAIL PROTECTED] wrote: It figures. We're one the largest accounts Oracle has got. Heck, Oracle has two people at HQ that deal with nothing but GE business units, and I STILL can't get 7.3.4, 8.0.5 or 8.0.6 for NT. Even my dedicated account rep struck out getting these disks. Oh, well. I'll go back and try it again. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Monday, February 24, 2003 5:24 PM To: Multiple recipients of list ORACLE-L I cut an iTAR on Metalink back last Oct. It would have been simpler. If someone had maintained our support agreement. But while that was being resolved. The sent me the CD. I got the CD in a couple of days. I was informed by someone at IBM that Oracle could burn new CD's. If you truly have a need for the CD. Such as lost/broken. Put pressure on them via your account rep. I hardly think it is likely for a vendor to say they don't have the code. If we have people on the list with software dating back to Oracle 4, I doubt Oracle is purging its archives of the software. It would be irrational. It is more likely they are just being difficult. Doing nothing is always the easiest route for the vendor. From: Adams, Matthew (GECP, MABG, 088130) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: How long to hold onto old Oracle CDs? Date: Mon, 24 Feb 2003 09:24:11 -0800 Two months ago, I tried to order older non-supported CDs (7.3, 8.0.5, 8.0.6) and they told me they could not ship them. How did you order them? Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Monday, February 24, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Actually the CD's are available. You just have to request them from Oracle. Of course, this does depend upon having a support contract. Ordered a replacement CD a couple of months ago for 7.3.4 (HP/UX) due to cracked media. From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How long to hold onto old Oracle CDs? Date: Mon, 24 Feb 2003 06:58:58 -0800 Hey all, Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs? We've been at 8.1.7 for 18 months now. I can't think of a good reason, other than the software isn't available anymore. Anybody want some old CDs? :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ:
RE: MTS config
Dick, here is what I use mts_dispatchers = (ADDRESS=(PROTOCOL=TCP)(HOST=172.16.99.28))(DISPATCHERS=5) local_listener = (ADDRESS=(PROTOCOL=TCP)(HOST=172.16.99.28)(PORT=1521)) mts_max_dispatchers = 10 mts_servers = 10 mts_max_servers = 100 Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, February 25, 2003 9:04 AM To: Multiple recipients of list ORACLE-L OK, Someone dope slap me! I added the following to my init.ora file (8.1.7.0 on HP-UX 11.0). The dispatchers start up just fine, but won't register with the listener (also 8.1.7.0). I've already done the RTFM and MetaLink RTFM but can't see the problem. mts_servers=5 mts_max_dispatchers=10 mts_max_servers=40 service_names=05 # mts_dispatchers=(PROTOCOL=ipc)(DISPATCHERS=2) mts_dispatchers=(PROTOCOL=TCP)(DISPATCHERS=4) local_listener=(address_list=(ADDRESS=(PROTOCOL=ipc)(KEY=05)) (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=bart))) Thanks for the second set of eyes. BTW, the end result would be to have all outside TCP connections use MTS only. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: alertlog naming
Jack, I've seen the same result (alert log funny file name) when I rename the file also doing oracle log maintenace. I'm guessing the same thing you are - that the rename hits at the same time that a write operation is happening. a subsequent rename works fine. For you second problem, I would leave the database in it's stuck state, connect internal and run the wait state queries to see what's going on. these queries are the ones outlined in the Oracle Performance Tuning 101 book written by our friends Kirti, Gaja and John. It will quickly tell you what is happening in your database - it sounds like maybe an init.ora param needs to be adjusted (just a Wild Assed Guess). If you don't have the book - buy it. Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, February 25, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Hi, On one of our customers site (WINDOWS) we have databases that have alertlogs with the name sidALRT.LOGsidALRT.LOG (double the normal name) and oracle keeps on writing to it. I thought if a file is renamed oracle will create a new alertlog when needed. I have a php script that reads the alrtlogs and reports the errors in web browser and than renames the current alertlog to sidALRT.LOG.mmdd Can it be that when there is writing action in the file oracle will get confused and screw up the renaming bit? (I thought windows did not allow changing filenames of open files) One of the databases on this customers site every now and than hangs with no messages in the alert logs and does not allow any connections anymore(No errors reported back to client). This database needs to be up and running asap so when it happens we don't get much time to investigate and restart the service. We can still connect with svrmgrl and internal (wasn't this supposed to go in 8.1.7). What would be the best course of action to quickly gather the releavnt data next time this happens. Has anybody seen this before and knows the solution? W2K Oracle 8.1.7.0.0 EE Jacob A. van Zanen Oracle DBA Quant Systems Europe b.v. Tel : +31 (0) 251 - 268 268 Mobile: +31 (0) 6 51308813 Fax: +31 (0) 251 - 268 269 E-mail: mailto:[EMAIL PROTECTED] Visit our web site at http://www.quantsystems.nl/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle slower ?
We are converting from SQL Server and Sybase to Oracle. To convert functions and stored procedures we have been using the Oracle Migration Workbench (OMWB) which produced WEAK REF CURSOR and TRANCOUNT global variable. I looked at (trace and explain plan) statements in the procedures and functions, it seems everything are OK. Init.ora parameters are big enough, statspack generated good values. The same function and procedure took about 1 minute in Sybase but take 9 minutes in Oracle. The difference is the procedures or functions after migration calling OMWB package (globalpkg). Any idea or tuning tips after migrating to Oracle ? Is Oracle slower than Sybase and SQL Server ? Tia. Rivaldi This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bahar, Rivaldi (BBASSI-CHQ) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.7.4.8 patch coming
sorry... win32. Pat. -Original Message- Sent: Tuesday, February 25, 2003 10:44 AM To: Multiple recipients of list ORACLE-L What platform? Isn't the 5th number platform-specific? (I forget) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, February 25, 2003 8:11 AM To: Multiple recipients of list ORACLE-L That's weeks, not days. Pat. -Original Message- Sent: Tuesday, February 25, 2003 8:49 AM To: Multiple recipients of list ORACLE-L Last word is that it should be available within 2-3, maybe sooner. Regards, Patrice Boivin -- 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MTS config
Looks fine. We only have the following entries on a 9i database.. dispatchers = (protocol = TCP)(dispatchers = 6) max_dispatchers = 12 shared_servers = 10 max_shared_servers = 40 Works fine, we ended up commenting out local_listener. How long have you waited for the dispatchers to register ? It does not happen instantly. Have you tried lsnrctl reload ? -Original Message- Sent: 25 February 2003 14:04 To: Multiple recipients of list ORACLE-L OK, Someone dope slap me! I added the following to my init.ora file (8.1.7.0 on HP-UX 11.0). The dispatchers start up just fine, but won't register with the listener (also 8.1.7.0). I've already done the RTFM and MetaLink RTFM but can't see the problem. mts_servers=5 mts_max_dispatchers=10 mts_max_servers=40 service_names=05 # mts_dispatchers=(PROTOCOL=ipc)(DISPATCHERS=2) mts_dispatchers=(PROTOCOL=TCP)(DISPATCHERS=4) local_listener=(address_list=(ADDRESS=(PROTOCOL=ipc)(KEY=05)) (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=bart))) Thanks for the second set of eyes. BTW, the end result would be to have all outside TCP connections use MTS only. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Embeded password in script
Actually, this would still display the password in the output of ps -ef because the $syspw environment variable is resolved before handing it to sqlplus. Try sqlplus dbimpl/$syspw and then a ps -ef... Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, February 24, 2003 3:31 PM To: Multiple recipients of list ORACLE-L cat pwfile syspw=blah export syspw ^D chmod 700 pwfile Unix Prompt . pwfile Unix Prompt sqlplus dbimpl/$syspw @your_script_here Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- Sent: Monday, February 24, 2003 3:54 PM To: Multiple recipients of list ORACLE-L I have been tasked to write a script to run SQL. I don't want a password field to be shown in the script. Does someone have run into this and have a better idea? For example, I have following line in my script. Sqlplus dbimpl/password @SQLscript.sql Also, from command line we go through following steps to shutdown database, how do I code these steps in the script? $svrmgrl SVRMGRLconnect internal SVRMGRLshutdown -- 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle slower ?
Hi No Oracle isn't slower than alternative RDBMS, at least if it is 9 times slower then it is either misconfigured, or the code is bad, or both. I'd strongly suspect the code to start with. If you treat the output of OMWB as a first cut, or functional prototype then you have a reasonable approach to the migration. If you can post the code for the slow proc I'm sure folk will be very quick to pick up why it isn't performing. Niall Litchfield Oracle DBA Audit Commission 0117 975 7805 -Original Message- Sent: 25 February 2003 15:09 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] We are converting from SQL Server and Sybase to Oracle. To convert functions and stored procedures we have been using the Oracle Migration Workbench (OMWB) which produced WEAK REF CURSOR and TRANCOUNT global variable. I looked at (trace and explain plan) statements in the procedures and functions, it seems everything are OK. Init.ora parameters are big enough, statspack generated good values. The same function and procedure took about 1 minute in Sybase but take 9 minutes in Oracle. The difference is the procedures or functions after migration calling OMWB package (globalpkg). Any idea or tuning tips after migrating to Oracle ? Is Oracle slower than Sybase and SQL Server ? Tia. Rivaldi This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bahar, Rivaldi (BBASSI-CHQ) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or professional privilege. Any dissemination, distribution, copyright or use of this communication without prior permission of the sender is strictly prohibited. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How long to hold onto old Oracle CDs?
WAS an editor? WAS? Some of us still use it! Well, I have migrated to the EVE editor built on TPU, but it still has the same wonderful functionality of the original in addition to a programmable interface (wrote some sweet sweet TPU back in the day). The KB I'm typing this on is an LK450, complete with the WORD-11 (MASS-11) keycaps and all the GOLD keydefs. Yes, your recollection of KP keys 0, 4, and 5 are correct. Remember the vi-like substitution command? Sorry, Jared, for the OT. I MISS VMS! Stability, performance, security. No wonder it didn't sell. Back to planning the removal of our remaining Oracle DBs from OpenVMS :( Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, February 25, 2003 4:41 AM To: Multiple recipients of list ORACLE-L 0 was next line. Wasn't 4 Forward and 5 Back? I've CC'ed Michael Möller, who writes DSI (Data Server Internals) classes in Oracle Development. He taught me all I ever needed to know about the EDT editor on VAX/VMS. He really should be able to remember all those wonderful keys. Yes, it was a fantastic editor, by the way. Ah yes - too true. Now we are getting nostalgic... Mogens Gogala, Mladen wrote: Nope, but I do have a 5MB RZ05 drive for interchangeable disks. I don't have a computer to attach it to, but I have good memories of KED and PF1 (Gold) key. KP-6 was cut GOLD-KP-6 was paste, PF2 was help and PF3 was Search. The best editor ever! -- 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Monitor
Hi DBAs We are reviewing anything related to database monitor. The following is my aware. Is there anything else you recommend Spotlight from quest Pocket DBA from Expand Beyond Oracle Performance Monitor Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MTS config
service_names, I believe is an optional thing. But if you use it, I think it is supposed to be set to a sort of alias name, not a number. -Original Message- can't see the problem. service_names=05 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: performance issues on sun
- Where is the tablespace of the table? Shared disk with temp or index tablespace? Its on a different mountpoint (and disk) from the index or the temp tablespaces - Check your SORT_AREA_SIZE on both systems. Its 1 Mb. I have done the tests with as much as 250M but same results - Do some basic disk I/O tests. On both the Compaq and Solaris, move a large file from one drive to another, just to see what time it takes. If the Solaris system is significantly slower, discuss this with your system administrators. If I do a simple cp, I am not able to see any big performance difference Thanks a lot... Babu DENNIS WILLIAMS [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] UCH.COM cc: Sent by: Subject: RE: performance issues on sun [EMAIL PROTECTED] 02/25/03 10:14 AM Please respond to ORACLE-L Babu - I would recommend checking: - Where is the tablespace of the table? Shared disk with temp or index tablespace? - Check your SORT_AREA_SIZE on both systems. - Do some basic disk I/O tests. On both the Compaq and Solaris, move a large file from one drive to another, just to see what time it takes. If the Solaris system is significantly slower, discuss this with your system administrators. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 25, 2003 8:11 AM To: Multiple recipients of list ORACLE-L All We are attempting to move some applications off Compaq T64 into Sun Solaris 8 and running into performance issues. I am trying to rebuild an index which is taking more than 3 1/2 hours while it used to take 20 min on T64. I find most of the waits on DIRECT PATH READS and DIRECT PATH WRITES. The index tablespace and the temporary tablespace are on separate mountpoints which reside on separate disks. I am doing a truss on the session and see that its doing the following kaio(AIOWAIT, 0x) Err#22 EINVAL pread(364, \b02\0\0\v\099E1 f h ECB.., 1048576, 0x26784000) = 1048576 kaio(AIOWAIT, 0x) Err#22 EINVAL lwp_cond_wait(0x7CED7F70, 0x7CED7F80, 0x) = 0 pwrite(408, 0602\0\0\nC41007 f h SDD.., 49152, 0x10401C000) = 49152 pwrite(408, 0602\0\0\nC410\n f h SDD.., 49152, 0x104028000) = 49152 pwrite(408, 0602\0\0\nC410\r f h SDD.., 49152, 0x104034000) = 49152 pwrite(408, 0602\0\0\nC41010 f h SDD.., 49152, 0x10404) = 49152 pwrite(408, 0602\0\0\nC41013 f h SDD.., 49152, 0x10404C000) = 49152 pwrite(408, 0602\0\0\nC41016 f h SDD.., 49152, 0x104058000) = 49152 pwrite(408, 0602\0\0\nC41019 f h SDD.., 49152, 0x104064000) = 49152 pwrite(408, 0602\0\0\nC4101C f h SDD.., 49152, 0x10407) = 49152 pwrite(408, 0602\0\0\nC4101F f h SDD.., 49152, 0x10407C000) = 49152 pwrite(408, 0602\0\0\nC410 f h SDD.., 49152, 0x104088000) = 49152 pwrite(408, 0602\0\0\nC410 % f h SDD.., 49152, 0x104094000) = 49152 pwrite(408, 0602\0\0\nC410 ( f h SDD.., 49152, 0x1040A) = 49152 pwrite(408, 0602\0\0\nC410 + f h SDD.., 49152, 0x1040AC000) = 49152 pwrite(408, 0602\0\0\nC410 . f h SDD.., 49152, 0x1040B8000) = 49152 pwrite(408, 0602\0\0\nC410 1 f h SDD.., 49152, 0x1040C4000) = 49152 pwrite(408, 0602\0\0\nC410 4 f h SDD.., 49152, 0x1040D) =
RE: Oracle slower ?
We are converting from SQL Server and Sybase to Oracle. To convert functions and stored procedures we have been using the Oracle Migration Workbench (OMWB) which produced WEAK REF CURSOR and TRANCOUNT global variable. I looked at (trace and explain plan) statements in the procedures and functions, it seems everything are OK. Init.ora parameters are big enough, statspack generated good values. The same function and procedure took about 1 minute in Sybase but take 9 minutes in Oracle. The difference is the procedures or functions after migration calling OMWB package (globalpkg). Any idea or tuning tips after migrating to Oracle ? Is Oracle slower than Sybase and SQL Server ? Tia. Rivaldi I have had this kind of problem (only 8mn against 80mn) some months ago ... not exactly the same physical schema in Oracle as in Sybase :-). You cannot say that Oracle is inherently slower or faster than Sybase or SQL Server. It depends on a lot of things, the underlaying hardware, your application of course, the use of some 'native tricks' (and from experience IOTs are not exactly equivalent to clustered indexes). The problem is that automated tools may be good for a first pass, but you really need to dive in the code and tweak it manually if you want good results. A RDBMS is not the 'neutral' component you may think. FYI we managed to bring Oracle performance in line (very slightly better, in fact) with Sybase performance in the case mentioned above. But it hasn't been easy. HTH, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Skill Sets - This may be a dumb question
Title: Skill Sets - This may be a dumb question Hello everyone, Well I've been reassigned. I was responsible for the completely messed up Peoplesoft Oracle/AIX environment but management here decided that it was more important to separate a husband and wife that both work in the same department, and assigned one of them to be primary support in this environment instead of me. (sshh: The new person who is primary doesn't know a thing about Unix.) My primary job is now suppossed to be data modeling and data warehouse/mart design, moving on into Problematica (er, Informatica) development into a Sql Server database. I will not be the admin on the Sql Server database. My new boss referred to this as database architecture. ?? What? They have already decided what they want done and just want someone to take the pretty pictures and implement them with unrealistic deadlines. The main reason why I am upset is because it seems to me that data modeling is such a soft skill. I am concerned about keeping my skills up to date and keeping my hands in an Oracle environment, whether it's a mess or not. Seems to me that data modeling alone isn't something that can land you a new job or really spiff up your resume. I think that having a finite list of skills (Oracle, Unix, Windows 2000, Erwin, Project, crap like that) is more what employers search for, and is what HR depts can easily deal with. Am I wrong? This job pays well and working for a huge company has it's benefits, if you can deal with the bureaucracy similar to what is described in the 1st paragraph. And I know in this market I am just lucky to have a job. And please tell me if I'm whining. I may just need a KITA. Who knows anymore... Lisa Koivu Oracle Drink Beer Again Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Embeded password in script
You can have username/password in the first line of the sqlplus script. sqlplus @your-script.sql Your-script.sql will have id/pw in the first line. Regards, Waleed -Original Message- Sent: Monday, February 24, 2003 3:54 PM To: Multiple recipients of list ORACLE-L I have been tasked to write a script to run SQL. I don't want a password field to be shown in the script. Does someone have run into this and have a better idea? For example, I have following line in my script. Sqlplus dbimpl/password @SQLscript.sql Also, from command line we go through following steps to shutdown database, how do I code these steps in the script? $svrmgrl SVRMGRLconnect internal SVRMGRLshutdown Thanks in advance, 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Monitor
Mitchell - What platform are you on? Do you have any particular criteria, or just trying to monitor anything? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 25, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Hi DBAs We are reviewing anything related to database monitor. The following is my aware. Is there anything else you recommend Spotlight from quest Pocket DBA from Expand Beyond Oracle Performance Monitor Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Monitor
Karma. The price is unbeatable and it's one very good monitor, too. Also, look into DB-Artisan from Embarcadero technologies, BMC Patrol. I'm sure that CA have an oracle RDBMS monitoring product. You also need to look in the capabilities of Tivoli from the Big Blue. -Original Message- From: Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:49 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Monitor Hi DBAs We are reviewing anything related to database monitor. The following is my aware. Is there anything else you recommend Spotlight from quest Pocket DBA from Expand Beyond Oracle Performance Monitor Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Embeded password in script
Or, you can create user OPS$ORACLE and grant DBA privilege to that account. That way , password will never be exposed. -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:25 AM To: Multiple recipients of list ORACLE-L Subject: RE: Embeded password in script Actually, this would still display the password in the output of ps -ef because the $syspw environment variable is resolved before handing it to sqlplus. Try sqlplus dbimpl/$syspw and then a ps -ef... Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, February 24, 2003 3:31 PM To: Multiple recipients of list ORACLE-L cat pwfile syspw=blah export syspw ^D chmod 700 pwfile Unix Prompt . pwfile Unix Prompt sqlplus dbimpl/$syspw @your_script_here Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- Sent: Monday, February 24, 2003 3:54 PM To: Multiple recipients of list ORACLE-L I have been tasked to write a script to run SQL. I don't want a password field to be shown in the script. Does someone have run into this and have a better idea? For example, I have following line in my script. Sqlplus dbimpl/password @SQLscript.sql Also, from command line we go through following steps to shutdown database, how do I code these steps in the script? $svrmgrl SVRMGRLconnect internal SVRMGRLshutdown -- 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Using fully qualified table_name.database_object in
There is also a bug in 8i with set current_schema. We use a login trigger to set current_schema for client database connections. It works great unless the client's code is PL/SQL. They don't get an ORA-600, but instead get PLS-201. Creating the public synonym fixes that problem. Rachel Carmichael wrote: I have, unfortunately, a perfect reason for using synonyms and not fully qualifying names... We've just opened an iTAR on this: some time this afternoon, the other DBA tried to recreate several of the stored procedures, functions and packages. Normal code development in the test database. Unfortunately, and we still don't know why, we got several ora-600 errors and we cannot drop or replace several of the stored procedures. We think that they were in use when he tried this, and that they got locked. We tried bouncing the database. No help, still stuck, can't recreate etc. Developers are sitting around twiddling their thumbs and planning the lynching. Support says something about System types getting dropped, which makes no sense to us, we don't touch Oracle-created types. We don't want to even try to drop the user, in case that makes things worse. Even if it works, we then have nothing to work on with Support so that it doesn't happen again. HOWEVER we use public synonyms for the procedures and no program is hard-coded to use the owner.procedure name. So I told the other DBA to create a new user, create the procedures/packages/functions owned by this user and to drop and recreate the public synonyms. Developers can work and we have the mess still available to work on with Oracle. Oh yeah, the other DBA gets to go home :) --- Jay Hostetter [EMAIL PROTECTED] wrote: We use fully qualified table names to avoid confusion. Ever poke around in Oracle Apps (11i) databases? OK...it references an object owned by APPS, but waitthat's a synonym that points to a table in INV... Synonyms can make your applications portable to another schema. However, in the 8 years that we've been growing our own applications, we've never ported to another schema. The one advantage that I can think of is that you can have multiple application schemas in the same database for testing purposes. Your developers could then reference whichever schema they want to use for testing via synonyms. However, I prefer to spend less time tracking down synonyms by not using them in the first place. Jay [EMAIL PROTECTED] 02/24/03 11:29AM I would like to know if it is advocated to use fully qualified table_name.database objects in application code. Example would be schema.table_name in a PL/SQL code. I would like to know the Pros/Cons if there are any? Thanks in advance. - Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
Re:RE: MTS config
Let's see, how about overnight and yes I have reloaded the listener. Dick Goulet Reply Separator Author: Adrian Roe [EMAIL PROTECTED] Date: 2/25/2003 7:09 AM Looks fine. We only have the following entries on a 9i database.. dispatchers = (protocol = TCP)(dispatchers = 6) max_dispatchers = 12 shared_servers = 10 max_shared_servers = 40 Works fine, we ended up commenting out local_listener. How long have you waited for the dispatchers to register ? It does not happen instantly. Have you tried lsnrctl reload ? -Original Message- Sent: 25 February 2003 14:04 To: Multiple recipients of list ORACLE-L OK, Someone dope slap me! I added the following to my init.ora file (8.1.7.0 on HP-UX 11.0). The dispatchers start up just fine, but won't register with the listener (also 8.1.7.0). I've already done the RTFM and MetaLink RTFM but can't see the problem. mts_servers=5 mts_max_dispatchers=10 mts_max_servers=40 service_names=05 # mts_dispatchers=(PROTOCOL=ipc)(DISPATCHERS=2) mts_dispatchers=(PROTOCOL=TCP)(DISPATCHERS=4) local_listener=(address_list=(ADDRESS=(PROTOCOL=ipc)(KEY=05)) (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=bart))) Thanks for the second set of eyes. BTW, the end result would be to have all outside TCP connections use MTS only. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle slower ?
Oracle isn't slower, you need to analyze the SQL and re-tune it. Indexes, indexes, indices. -Original Message- From: Bahar, Rivaldi (BBASSI-CHQ) [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:10 AM To: Multiple recipients of list ORACLE-L Subject: Oracle slower ? We are converting from SQL Server and Sybase to Oracle. To convert functions and stored procedures we have been using the Oracle Migration Workbench (OMWB) which produced WEAK REF CURSOR and TRANCOUNT global variable. I looked at (trace and explain plan) statements in the procedures and functions, it seems everything are OK. Init.ora parameters are big enough, statspack generated good values. The same function and procedure took about 1 minute in Sybase but take 9 minutes in Oracle. The difference is the procedures or functions after migration calling OMWB package (globalpkg). Any idea or tuning tips after migrating to Oracle ? Is Oracle slower than Sybase and SQL Server ? Tia. Rivaldi ** ** This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. ** ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bahar, Rivaldi (BBASSI-CHQ) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: delete archivelog... backed up 1 times to tape
The archivelogs have to have been backed up by rman for rman to delete them. Thisscript is the one we use. execute script alloc_name1_disk; backup format '/dbback/al_%sdbname_%p' (archivelog all delete input); execute script rel_pa1_disk;} HTH, Ruth - Original Message - From: Ed Bittel To: Multiple recipients of list ORACLE-L Sent: Thursday, February 20, 2003 9:23 AM Subject: RMAN: delete archivelog... backed up 1 times to tape I am trying to use the DELETE ARCHIVELOG command that is available inversion 9.2.0.1. The complete syntax I wish to use is this command: RMAN delete archivelog until time 'trunc(sysdate)-2' backed up 1times to tape; I have tried this as part of a backup script and as a standalone commandafter allocating a maintenance channel, but it doesn't work. Furthermore,this command DOES NOT return records: RMAN list archivelog all backed up 1 times to tape; But this command DOES return records: RMAN list archivelog all backed up 0 times to tape; I know I have backups of archivelogs on tape because they are reported whenI issue this command: RMAN list backup of archivelog from time 'sysdate-3' device type sbt;Does anyone know what is going on here? Thanks, Ed /RDBMS Version: 9.2.0.1OS: Sun Solaris 8Product: RMAN (9.2.0.1)*/-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ed Bittel INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Skill Sets - This may be a dumb question
Title: Skill Sets - This may be a dumb question Lisa: I know you are disappointed, but be happy you have a job. I was laid off a year ago and the job situation here in the TC's area is not improving. I'll trade places with you any day. Ken Janusz, CPIM Hugo, MN - Original Message - From: Koivu, Lisa To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 25, 2003 10:34 AM Subject: Skill Sets - This may be a dumb question Hello everyone, Well I've been "reassigned". I was responsible for the completely messed up Peoplesoft Oracle/AIX environment but management here decided that it was more important to separate a husband and wife that both work in the same department, and assigned one of them to be primary support in this environment instead of me. (sshh: The new person who is primary doesn't know a thing about Unix.) My primary job is now suppossed to be data modeling and data warehouse/mart design, moving on into Problematica (er, Informatica) development into a Sql Server database. I will not be the admin on the Sql Server database. My new boss referred to this as "database architecture". ?? What? They have already decided what they want done and just want someone to take the pretty pictures and implement them with unrealistic deadlines. The main reason why I am upset is because it seems to me that data modeling is such a "soft" skill. I am concerned about keeping my skills up to date and keeping my hands in an Oracle environment, whether it's a mess or not. Seems to me that data modeling alone isn't something that can land you a new job or really spiff up your resume. I think that having a finite list of skills (Oracle, Unix, Windows 2000, Erwin, Project, crap like that) is more what employers search for, and is what HR depts can easily deal with. Am I wrong? This job pays well and working for a huge company has it's benefits, if you can deal with the bureaucracy similar to what is described in the 1st paragraph. And I know in this market I am just lucky to have a job. And please tell me if I'm whining. I may just need a KITA. Who knows anymore... Lisa Koivu Oracle Drink Beer Again Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
A Couple of does and donts
Hi All, Do not tune because a statistic looks bad Do tune because a luser says this is slow and is adversely affecting my productivity. Do not use MTS Yes I know there are a few exceptions, but in general MTS causes more problems than it solves. Dave -- Dave Morgan Operations Manager, Rigskills Canada Canada's Geographical Oilfield Services Locator http://www.rigskills.ca [EMAIL PROTECTED] 403 399 2442 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Monitor
Hi Mitchell, When you say monitor, what exactly do you mean? The definition of a Monitoring tool (in my eyes at least) is a tool that will sit and monitor your database, and tell you when a problem could be, or is, imminent (via background processes and alerts). The list that you specify, whilst all good tools, are not (exactly) monitors. Quest's Spotlight is more of a diagnostics tool, granted it has a lot of monitoring features, but it is essentially a SQL*Net/Net 8 based client, that has to be open for monitoring to occur, and more to the point, you have to be looking at the screen to notice any problems. Quests true monitoring tool is I/Watch (or Foglight, depending..). PocketDBA, again, is not a monitor (we are Expand Beyond's UK distributor). It is more of a diagnostics tool aimed at the mobile market. It has no mechanism to get an alert or to you the DBA, though it DOES allow you to get to the bottom of problems very quickly, once you have received an alert however! ;) I honestly couldn't comment on Oracle Performance Monitor, having not tried it. There are other tools available on the market though. Here's a list of those that I would class as having monitors: Precise (www.precisesoft.com) Quest (www.quest.com) BMC (www.bmc.com) Embarcadero (www.embarcardero.com) - I'm not entirely sure whether Performance Centre has alerting yet. Bradmark (www.bradmark.com) and therefore (www.cool-tools.co.uk as well :D) Oracle (who needs a URL) There are a number of others out there in the market, with tools such as Big Brother (now taken over by Quest I think) orasnap, mamba etc. . The ones listed above however, are those that I would list as the market leaders. shameless plug We sell Bradmark's offering (NORAD) along with PocketDBA, to allow NORAD alerts to be sent to a mobile phone (as well as email, pager, SNMP_TRAPS etc.), and actioned straight away with PocketDBA. /shameless plug Remember, often the main driving force for monitors is to ease the DBAs work load, by giving the day to day monitoring tasks to a tool to handle. If you need to be watching a screen - this defeats the object! :) HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Sent: 25 February 2003 15:49 To: Multiple recipients of list ORACLE-L Hi DBAs We are reviewing anything related to database monitor. The following is my aware. Is there anything else you recommend Spotlight from quest Pocket DBA from Expand Beyond Oracle Performance Monitor Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Skill Sets - This may be a dumb question
One advantage of database architect is that he is less dependent on a specific database. I am some kind of system architect/analyst and in my previous job I worked with Oracle products as well as with some Open source ones. Now my new company is working only with M$ SQL Server and I don't have any big problems. And they even are looking in the Oracle direction for the first time ever and of course I'm strongly supporting that :) Gints -Original Message- Sent: Tuesday, February 25, 2003 6:34 PM To: Multiple recipients of list ORACLE-L Hello everyone, Well I've been reassigned. I was responsible for the completely messed up Peoplesoft Oracle/AIX environment but management here decided that it was more important to separate a husband and wife that both work in the same department, and assigned one of them to be primary support in this environment instead of me. (sshh: The new person who is primary doesn't know a thing about Unix.) My primary job is now suppossed to be data modeling and data warehouse/mart design, moving on into Problematica (er, Informatica) development into a Sql Server database. I will not be the admin on the Sql Server database. My new boss referred to this as database architecture. ?? What? They have already decided what they want done and just want someone to take the pretty pictures and implement them with unrealistic deadlines. The main reason why I am upset is because it seems to me that data modeling is such a soft skill. I am concerned about keeping my skills up to date and keeping my hands in an Oracle environment, whether it's a mess or not. Seems to me that data modeling alone isn't something that can land you a new job or really spiff up your resume. I think that having a finite list of skills (Oracle, Unix, Windows 2000, Erwin, Project, crap like that) is more what employers search for, and is what HR depts can easily deal with. Am I wrong? This job pays well and working for a huge company has it's benefits, if you can deal with the bureaucracy similar to what is described in the 1st paragraph. And I know in this market I am just lucky to have a job. And please tell me if I'm whining. I may just need a KITA. Who knows anymore... Lisa Koivu Oracle Drink Beer Again Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle slower ?
Both Oracle (817) and Sybase running on the same test machine (Sun Solaris 6) but in different mount point. Both not at optimum datafiles and I/O configuration. If I run every SQL in the procedure manually from SQLplus it run at minimum cost (explain plan), indexes used. There are loops in the procedure. I guess it takes more time because more logic (if then else) inside the loops. For example, the following code generated by OMWB is inside the loops. Any other idea ? IF ( TEST_4.TranFlag = 0) THEN BEGIN /* Emulating TRANCOUNT functionality in Oracle model */ IF omwb_emulation.globalPkg.trancount = 1 THEN COMMIT WORK; END IF; IF omwb_emulation.globalPkg.trancount 0 THEN omwb_emulation.globalPkg.trancount:=omwb_emulation.globalPkg.trancount-1; END IF; -Original Message- Sent: Tuesday, February 25, 2003 11:20 AM To: Multiple recipients of list ORACLE-L We are converting from SQL Server and Sybase to Oracle. To convert functions and stored procedures we have been using the Oracle Migration Workbench (OMWB) which produced WEAK REF CURSOR and TRANCOUNT global variable. I looked at (trace and explain plan) statements in the procedures and functions, it seems everything are OK. Init.ora parameters are big enough, statspack generated good values. The same function and procedure took about 1 minute in Sybase but take 9 minutes in Oracle. The difference is the procedures or functions after migration calling OMWB package (globalpkg). Any idea or tuning tips after migrating to Oracle ? Is Oracle slower than Sybase and SQL Server ? Tia. Rivaldi I have had this kind of problem (only 8mn against 80mn) some months ago ... not exactly the same physical schema in Oracle as in Sybase :-). You cannot say that Oracle is inherently slower or faster than Sybase or SQL Server. It depends on a lot of things, the underlaying hardware, your application of course, the use of some 'native tricks' (and from experience IOTs are not exactly equivalent to clustered indexes). The problem is that automated tools may be good for a first pass, but you really need to dive in the code and tweak it manually if you want good results. A RDBMS is not the 'neutral' component you may think. FYI we managed to bring Oracle performance in line (very slightly better, in fact) with Sybase performance in the case mentioned above. But it hasn't been easy. HTH, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bahar, Rivaldi (BBASSI-CHQ) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Skill Sets - This may be a dumb question
Lisa - You can always answer questions on this list to keep your hand in. I wouldn't sweat it too much. I agree with you that the harder skills like Oracle show up better on a resume. But frankly you can still put Oracle on your resume for a LNG time and be perfectly truthful. And if they want to discuss it in more detail, then you'll have a ready response prepared. In the current economic climate the smart idea is to take what you can get and be glad. Personally I take each job assignment as a challenge to learn what I can. In a year you will either a) decide you love the new position b) be reassigned c) find a better DBA position because the economy will have perked up. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 25, 2003 10:34 AM To: Multiple recipients of list ORACLE-L Hello everyone, Well I've been reassigned. I was responsible for the completely messed up Peoplesoft Oracle/AIX environment but management here decided that it was more important to separate a husband and wife that both work in the same department, and assigned one of them to be primary support in this environment instead of me. (sshh: The new person who is primary doesn't know a thing about Unix.) My primary job is now suppossed to be data modeling and data warehouse/mart design, moving on into Problematica (er, Informatica) development into a Sql Server database. I will not be the admin on the Sql Server database. My new boss referred to this as database architecture. ?? What? They have already decided what they want done and just want someone to take the pretty pictures and implement them with unrealistic deadlines. The main reason why I am upset is because it seems to me that data modeling is such a soft skill. I am concerned about keeping my skills up to date and keeping my hands in an Oracle environment, whether it's a mess or not. Seems to me that data modeling alone isn't something that can land you a new job or really spiff up your resume. I think that having a finite list of skills (Oracle, Unix, Windows 2000, Erwin, Project, crap like that) is more what employers search for, and is what HR depts can easily deal with. Am I wrong? This job pays well and working for a huge company has it's benefits, if you can deal with the bureaucracy similar to what is described in the 1st paragraph. And I know in this market I am just lucky to have a job. And please tell me if I'm whining. I may just need a KITA. Who knows anymore... Lisa Koivu Oracle Drink Beer Again Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Skill Sets - This may be a dumb question
Title: Message Ken: My sympathies go out to you too, I spent the time from 04/01 until 12/01 unemployed as well. Tough way to go in any market, try one in a small (30K population) market that is 90+% dependent on asmall state's government for work. I'm very thankful to be working yet (contract could end any day). (Arise to soapbox) And yes Lisa, I am considered by many around here to be more of a Data Architect than a DBA (which I must say irritates me quite a bit)since I have designed (from first cut E/R design through physical implementations in DEV, TEST and PROD)from ground zero more than 10 different systems in the last 7 years. I do try to keep my hand in the tuning and administration of the systems until they are turned over to clients for operational support. I want to get a production support type contract in the future to further enhance my skills, but whatever it takes to keep the mortgage paid. (Step down and don flame proof clothing) Rick Weiss -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:04To: Multiple recipients of list ORACLE-LSubject: Re: Skill Sets - This may be a dumb question Lisa: I know you are disappointed, but be happy you have a job. I was laid off a year ago and the job situation here in the TC's area is not improving. I'll trade places with you any day. Ken Janusz, CPIM Hugo, MN - Original Message - From: Koivu, Lisa To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 25, 2003 10:34 AM Subject: Skill Sets - This may be a dumb question Hello everyone, Well I've been "reassigned". I was responsible for the completely messed up Peoplesoft Oracle/AIX environment but management here decided that it was more important to separate a husband and wife that both work in the same department, and assigned one of them to be primary support in this environment instead of me. (sshh: The new person who is primary doesn't know a thing about Unix.) My primary job is now suppossed to be data modeling and data warehouse/mart design, moving on into Problematica (er, Informatica) development into a Sql Server database. I will not be the admin on the Sql Server database. My new boss referred to this as "database architecture". ?? What? They have already decided what they want done and just want someone to take the pretty pictures and implement them with unrealistic deadlines. The main reason why I am upset is because it seems to me that data modeling is such a "soft" skill. I am concerned about keeping my skills up to date and keeping my hands in an Oracle environment, whether it's a mess or not. Seems to me that data modeling alone isn't something that can land you a new job or really spiff up your resume. I think that having a finite list of skills (Oracle, Unix, Windows 2000, Erwin, Project, crap like that) is more what employers search for, and is what HR depts can easily deal with. Am I wrong? This job pays well and working for a huge company has it's benefits, if you can deal with the bureaucracy similar to what is described in the 1st paragraph. And I know in this market I am just lucky to have a job. And please tell me if I'm whining. I may just need a KITA. Who knows anymore... Lisa Koivu Oracle Drink Beer Again Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Embeded password in script
sqlplus /nolog ! conn dbimpl/password @SQLscript.sql ! -Original Message- Sent: Monday, February 24, 2003 2:54 PM To: Multiple recipients of list ORACLE-L I have been tasked to write a script to run SQL. I don't want a password field to be shown in the script. Does someone have run into this and have a better idea? For example, I have following line in my script. Sqlplus dbimpl/password @SQLscript.sql Also, from command line we go through following steps to shutdown database, how do I code these steps in the script? $svrmgrl SVRMGRLconnect internal SVRMGRLshutdown Thanks in advance, 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Lofstrand INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Skill Sets - This may be a dumb question
Title: Message Don't you just HATE change. You were getting all nice and comfy in your current job, and mgmt throws you a curve ball. This has happened to me a few times, and I have learned to "step into their shoes" to try and better understand why. Why me!!!?!? Not that I ever agreed with their decision. And I hated having to train these naive people on how to take care of MY databases. But I dobelieve that having X amount of time data modeling helps to broaden your DB skills, and pushes you up in the ranks to the more senior levels. And I would have a hard time believing that putting the words Database Archictect on your resume is such a bad thing. After all, when a DBA gets promoted what would they become? CIO? CEO? God? Gasp!!! Senior Perl Developer? (Jared?) Hopefully, you can work your bossand getsome cash out of this. Congrats on your promotion! And having a job... -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 11:34 AMTo: Multiple recipients of list ORACLE-LSubject: Skill Sets - This may be a dumb question Hello everyone, Well I've been "reassigned". I was responsible for the completely messed up Peoplesoft Oracle/AIX environment but management here decided that it was more important to separate a husband and wife that both work in the same department, and assigned one of them to be primary support in this environment instead of me. (sshh: The new person who is primary doesn't know a thing about Unix.) My primary job is now suppossed to be data modeling and data warehouse/mart design, moving on into Problematica (er, Informatica) development into a Sql Server database. I will not be the admin on the Sql Server database. My new boss referred to this as "database architecture". ?? What? They have already decided what they want done and just want someone to take the pretty pictures and implement them with unrealistic deadlines. The main reason why I am upset is because it seems to me that data modeling is such a "soft" skill. I am concerned about keeping my skills up to date and keeping my hands in an Oracle environment, whether it's a mess or not. Seems to me that data modeling alone isn't something that can land you a new job or really spiff up your resume. I think that having a finite list of skills (Oracle, Unix, Windows 2000, Erwin, Project, crap like that) is more what employers search for, and is what HR depts can easily deal with. Am I wrong? This job pays well and working for a huge company has it's benefits, if you can deal with the bureaucracy similar to what is described in the 1st paragraph. And I know in this market I am just lucky to have a job. And please tell me if I'm whining. I may just need a KITA. Who knows anymore... Lisa Koivu Oracle Drink Beer Again Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Skill Sets - This may be a dumb question
Title: Skill Sets - This may be a dumb question Simple, eliminate the married couple. Then you should have your pick of jobs. Dave -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]Sent: Tuesday, February 25, 2003 10:34 AMTo: Multiple recipients of list ORACLE-LSubject: Skill Sets - This may be a dumb question Hello everyone, Well I've been "reassigned". I was responsible for the completely messed up Peoplesoft Oracle/AIX environment but management here decided that it was more important to separate a husband and wife that both work in the same department, and assigned one of them to be primary support in this environment instead of me. (sshh: The new person who is primary doesn't know a thing about Unix.) My primary job is now suppossed to be data modeling and data warehouse/mart design, moving on into Problematica (er, Informatica) development into a Sql Server database. I will not be the admin on the Sql Server database. My new boss referred to this as "database architecture". ?? What? They have already decided what they want done and just want someone to take the pretty pictures and implement them with unrealistic deadlines. The main reason why I am upset is because it seems to me that data modeling is such a "soft" skill. I am concerned about keeping my skills up to date and keeping my hands in an Oracle environment, whether it's a mess or not. Seems to me that data modeling alone isn't something that can land you a new job or really spiff up your resume. I think that having a finite list of skills (Oracle, Unix, Windows 2000, Erwin, Project, crap like that) is more what employers search for, and is what HR depts can easily deal with. Am I wrong? This job pays well and working for a huge company has it's benefits, if you can deal with the bureaucracy similar to what is described in the 1st paragraph. And I know in this market I am just lucky to have a job. And please tell me if I'm whining. I may just need a KITA. Who knows anymore... Lisa Koivu Oracle Drink Beer Again Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL struggle
List Gurus, I need help and I won't be ashamed to ask :) Oracle 8.1.7 on AIX 4.3 Here is what my data looks like in a table called item_w: WHSE_CODEITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR 0 CPD-TGH 111230-OR 0 HL1 50034 .91 MSH-CDS 50034 0 CPD-TGH 50034-OR0 HL1 650300 4.789 TWH-STAT 650300 0 CPD-TWH 650300-OR 0 CPD-TGH 650300-OR 0 If you'll notice, only the items with WHSE_CODE='HL1' have a cost associated with them. What I need to is: Parse ITEM_NUM for those items which have a suffix of -OR in order to compare with an ITEM_NUM without -OR so that I can take the last cost from there and display it beside the one that has -OR. Also note, there are some $0 cost items that don't have a suffix of -OR; I would need to match those up with a cost as well. So in the end, I suppose, this is the result I'm looking for: WHSE_CODEITEM_NUM LAST_COSTLAST_COST_REV - -- HL1 111230 1.12 1.12 CPD-TWH 111230-OR 0 1.12 CPD-TGH 111230-OR 0 1.12 HL1 50034 0.91 0.91 MSH-CDS 50034 0 0.91 CPD-TGH 50034-OR 0 0.91 HL1 650300 4.789 4.789 TWH-STAT 650300 0 4.789 CPD-TWH 650300-OR 0 4.789 CPD-TGH 650300-OR 0 4.789 And if any of you out there use Cognos Impromptu, perhaps you could tell me how I can achieve these results in a report. Thanks in advance for your time, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Skill Sets - This may be a dumb question
Go check one of the on-line salary surveys. Used to be that Oracle DBA was head of the pack. Now it's data architect and web designer. The only reason that it seems like a soft skill to you is because you're so good at it that it's second nature. Leave a regular L'User alone to do their own data architecture and see what they come up with. Data Architect does spiff up your resume. Koivu, Lisa Lisa.Koivu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @efairfield.com cc: Sent by: rootSubject: Skill Sets - This may be a dumb question 02/25/2003 11:34 AM Please respond to ORACLE-L Hello everyone, Well I've been reassigned. I was responsible for the completely messed up Peoplesoft Oracle/AIX environment but management here decided that it was more important to separate a husband and wife that both work in the same department, and assigned one of them to be primary support in this environment instead of me. (sshh: The new person who is primary doesn't know a thing about Unix.) My primary job is now suppossed to be data modeling and data warehouse/mart design, moving on into Problematica (er, Informatica) development into a Sql Server database. I will not be the admin on the Sql Server database. My new boss referred to this as database architecture. ?? What? They have already decided what they want done and just want someone to take the pretty pictures and implement them with unrealistic deadlines. The main reason why I am upset is because it seems to me that data modeling is such a soft skill. I am concerned about keeping my skills up to date and keeping my hands in an Oracle environment, whether it's a mess or not. Seems to me that data modeling alone isn't something that can land you a new job or really spiff up your resume. I think that having a finite list of skills (Oracle, Unix, Windows 2000, Erwin, Project, crap like that) is more what employers search for, and is what HR depts can easily deal with. Am I wrong? This job pays well and working for a huge company has it's benefits, if you can deal with the bureaucracy similar to what is described in the 1st paragraph. And I know in this market I am just lucky to have a job. And please tell me if I'm whining. I may just need a KITA. Who knows anymore... Lisa Koivu Oracle Drink Beer Again Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
RE: performance issues on sun
Babu, I think it is trying to do a KAIO call and failing. Then it attempts a synchronous PWRITE call. But our SAs are not able to help us to confirm this. Have any of you seen this issue? I think you have hit the nail on the head. By default, the Oracle port on Solaris sets 'disk_async_io' to TRUE. Set this to FALSE by introducing such an entry in init.ora. Let us know if tihis solves your issue... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 I don't know what the future holds for me, but I do know who holds my future! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBMS_STATS
Title: Message I have never had good luck with DBMS_STATS. It seems that the old analyze runs much faster. Runs in 45 seconds: analyze table log_trans partition (log_trans_20030104) estimate statisticssample 5 percent; Takes over 2 hours: execute dbms_stats.gather_table_stats(ownname = 'LDGADMIN', - tabname = 'LOG_TRANS', - partname = 'LOG_TRANS_20030102', -estimate_percent = 5); Am I missing something? Aren't both commands the same? Thanks, Tom
Re: SqlNet Response ports
Thank you very much for the information Don. We are using 9i and I think MTS, though I am not certain of that. I will pass this on to our DBA, I am sure he will find this helpful. At 06:03 PM 2/24/2003 -0800, you wrote: I guess I should have asked also: 1) what version of Oracle are you using? 2) Is this using MTS or dedicated servers? Since this is Linux, there are three cases: 1) Dedicated severs - there is no redirection. Client talks to dedicated server on listener port. 2) MTS Oracle 9i - ditto 3) MTS pre-9iR2 - MTS does redirect by default 0 to some (pseudo-)random port above 1024 but this may be overridden by adding a pfile (init.ora) entry like: mts_dispatchers=(address=(protocol=tcp)(host=yourhostname)(port=443))(dispa tchers=1) See: Metalink Bulletin: 1016349.102 Note: 163082.999 Go to advanced search and search on Doc ID with these IDs. There may be multiple mts_dispatchers= lines in the init file and there may be other parameters of interest. For the sake of this particular issue though, the pertinent item is the (port=443) clause. It would force MTS redirects to port 443. Actually, this parameter is obsoleted by the initiiation parameter: local_listener=listener_name_alias where tnsnames.ora has an entry like: listener_name_alias=(address=(protocol= tcp)(host= yourhostname)(port= 443))... and other appriopriate MTs initialization parameters. Please see the documentation for your version for options. Good luck! Don Granaman certified OraSaurus - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 24, 2003 12:39 PM Redhat Linux 7.2 At 07:28 PM 2/21/2003 -0800, you wrote: What platform is this? Windows? Don Granaman OraSaurus - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 21, 2003 5:48 PM Hi listers, Here is a question my client asked me, that I can't seem to find the answer to on metalink, mostly because I am not sure how to frame the search query. If you don't know what NMCI is, just know that it is a government program that is establishing control over the network which our database servers are on. Anyone have any ideas or advice for me? TIA, Regina Then, one of the NMCI technical guys mentioned that NMCI PCs wouldn t allow inbound/outbound 1521 traffic (SQLNET). Hence, no NMCI user would be able to use any client/server application. Wow, that s a major problem. There are a few possible solutions. 1. Configure the database server to listen on port 443, because NMCI allows 443. But, SQLNET uses random high order ports on the return. Anybody know if you can configure SQLNET to use only 443 on the response? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Regina Harter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Regina Harter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
Metalink
Title: Message I retract what I said the other day about Metalink technicians... : ( Pat.
Re: Which is beter a cursor or a for loop?
Proof of pudding is in eating Whip up a couple of examples and check out the timings. I suspect the CURSOR FOR LOOPS would run faster. I recall a similar mention by Tom Kyte in Oracle magazine while answering a question about explicit and implicit cusrsors. Unlike the conventional wisdom (a.k.a Feuerstein's recommendation in his best selling books) to use explicit cursors, he showed via an example how and why the implicit cursors are better (Key difference was the processing PL/SQL had to do for the explicit cursor). It is pretty much the same for FOR LOOP (it opens, closes and fetches from the cursor for you) and is likly to run faster. - Sundeep --- Denham Eva [EMAIL PROTECTED] wrote: Hello, I was just asked by one of our developers which is beter to use:- a cursor or a for loop? I must admit I am not sure Anyway the specific piece of code in discussion is similar to the following FOR X IN (SELECT X FROM TABLE_NAME WHERE COL1 = 'Something')) LOOP Do a whole lot of stuff in database here.. LOOP END; I would guess that the cursor would follow similar execution criteria but using the cursor syntax. Any ideas? TIA regards Denham Eva Oracle DBA The real problem is not whether machines think but whether men do. - B. F. Skinner _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com _ = Sundeep Maini Consultant Currently on Assignement at Caterpillar Peoria [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sundeep maini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Skill Sets - This may be a dumb question
Title: Skill Sets - This may be a dumb question Lisa, I'm sorry for selfish reasons. I liked having someone else on a Peoplesoft/Oracle/AIX environment out there. As far as the new position, just change your job title to Data Architect (what does that do to your tag lines?) Henry -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Koivu, LisaSent: Tuesday, February 25, 2003 11:34 AMTo: Multiple recipients of list ORACLE-LSubject: Skill Sets - This may be a dumb question Hello everyone, Well I've been "reassigned". I was responsible for the completely messed up Peoplesoft Oracle/AIX environment but management here decided that it was more important to separate a husband and wife that both work in the same department, and assigned one of them to be primary support in this environment instead of me. (sshh: The new person who is primary doesn't know a thing about Unix.) My primary job is now suppossed to be data modeling and data warehouse/mart design, moving on into Problematica (er, Informatica) development into a Sql Server database. I will not be the admin on the Sql Server database. My new boss referred to this as "database architecture". ?? What? They have already decided what they want done and just want someone to take the pretty pictures and implement them with unrealistic deadlines. The main reason why I am upset is because it seems to me that data modeling is such a "soft" skill. I am concerned about keeping my skills up to date and keeping my hands in an Oracle environment, whether it's a mess or not. Seems to me that data modeling alone isn't something that can land you a new job or really spiff up your resume. I think that having a finite list of skills (Oracle, Unix, Windows 2000, Erwin, Project, crap like that) is more what employers search for, and is what HR depts can easily deal with. Am I wrong? This job pays well and working for a huge company has it's benefits, if you can deal with the bureaucracy similar to what is described in the 1st paragraph. And I know in this market I am just lucky to have a job. And please tell me if I'm whining. I may just need a KITA. Who knows anymore... Lisa Koivu Oracle Drink Beer Again Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBMS_STATS
Title: Message May have something to do with bug 2649728, which I just heard about for the first time no more than 10 seconds ago. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - RMOUG Training Days 2003, Mar 56 Denver - Hotsos Clinic101, Mar 2527 London -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Terrian, Tom (Contractor) (DAASC) Sent: Tuesday, February 25, 2003 12:13 PM To: Multiple recipients of list ORACLE-L Subject: DBMS_STATS I have never had good luck with DBMS_STATS. It seems that the old analyze runs much faster. Runs in 45 seconds: analyze table log_trans partition (log_trans_20030104) estimate statisticssample 5 percent; Takes over 2 hours: execute dbms_stats.gather_table_stats(ownname = 'LDGADMIN', - tabname = 'LOG_TRANS', - partname = 'LOG_TRANS_20030102', - estimate_percent = 5); Am I missing something? Aren't both commands the same? Thanks, Tom
RE: Embeded password in script
Jared:
How do you do this for an export cron job ?
Thanks
David Jones
ITResource
-Original Message-
Sent: Monday, February 24, 2003 2:51 PM
To: Multiple recipients of list ORACLE-L
The 'hide.c' program can be implemented and compiled to prevent
parameters from appearing to ps. I believe it still works properly on
most flavors of unix.
For the Perl for Oracle DBA's book we wrote one utililty that I had
wanted for some time, a password database.
For jobs that I plan to run regularly from cron, I use the password
daemon pwd.pl and retrieve the passwords across the network
( encrypted with MD5 ).
If the job is a Perl script ( fairly likely around here ) the password
can't appear to PS, as no password is ever used on the command
line.
It's handy for command line stuff as well, as I only need rights to
access the password database via the password daemon. I don't
have to know the database passwords to login to the account.
e.g. sqlplus system/$(pwc.pl -instance dv01 -username jkstill)@dv01
This is the single most useful utility we put in that book IMO.
Jared
On Monday 24 February 2003 14:02, STEVE OLLIG wrote:
i'll take the first one...
on UNIX you could use a secret hidden file with appropriate permissions
where each line has the format ORACLE_SID:USER:password
then use awk to parse the file for the line with the correct $ORACLE_SID
and $USER, and set an environment variable to the password string. Then
your scripts could use that variable with sqlplus instead of the hardcoded
password.
in ksh it could look something like this:
export password=\
`awk -F: '$1 == sid $2 == dbimpl {print $3}' mySecretHiddenFile`
be warned that if you call sqlplus like this in your scripts:
sqlplus dbimpl/${password} @SQLscript.sql
someone could still see the Oracle password with a sneaky ps command while
your script is running.
a very similar approach could be taken with perl if awk isn't your cup of
tea.
-Original Message-
Sent: Monday, February 24, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
I have been tasked to write a script to run SQL. I don't want a password
field to be shown in the script. Does someone have run into this and have
a better idea? For example, I have following line in my script.
Sqlplus dbimpl/password @SQLscript.sql
Also, from command line we go through following steps to shutdown database,
how do I code these steps in the script?
$svrmgrl
SVRMGRLconnect internal
SVRMGRLshutdown
Thanks in advance,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: David Jones
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: DBMS_STATS
Title: Message ok, I will take a look. thanks -Original Message-From: Cary Millsap [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: DBMS_STATS May have something to do with bug 2649728, which I just heard about for the first time no more than 10 seconds ago. Cary MillsapHotsos Enterprises, Ltd.http://www.hotsos.comUpcoming events:- RMOUG Training Days 2003, Mar 5-6 Denver- Hotsos Clinic101, Mar 25-27 London -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Terrian, Tom (Contractor) (DAASC)Sent: Tuesday, February 25, 2003 12:13 PMTo: Multiple recipients of list ORACLE-LSubject: DBMS_STATS I have never had good luck with DBMS_STATS. It seems that the old analyze runs much faster. Runs in 45 seconds: analyze table log_trans partition (log_trans_20030104) estimate statisticssample 5 percent; Takes over 2 hours: execute dbms_stats.gather_table_stats(ownname = 'LDGADMIN', - tabname = 'LOG_TRANS', - partname = 'LOG_TRANS_20030102', -estimate_percent = 5); Am I missing something? Aren't both commands the same? Thanks, Tom
RE: Openssl security breach detected - oracle concerned?
I logged a TAR with Oracle, they responded that this is privileged information. ; ) I recommend sending a question to the Oracle Alerts people. That's what I am doing... Pat. -Original Message- Sent: Tuesday, February 25, 2003 10:11 AM To: Multiple recipients of list ORACLE-L The recently installed 9i rel2 pachted to 9.2.0.2.0 uses openssl version 0.9.6b The latest version is 0.9.7a was 0.9.6i. Compile and then just change the file will most likely not work, will it? kr Apologies for any typing mistakes I failed to notice. Markus Reger Oracle Applications DBA Webmaster MBC University for Music and Performing Art Vienna [EMAIL PROTECTED] 02/25/03 13:28 PM You would have to verify what version of SSL. http://www.theregister.co.uk/content/55/29423.html yesterday posted a notice that the experiment was with an older version of SSL. It could be that iAS and other Oracle products are still using that version, I know they were way behind in the Apache release they bundled in iAS 1.0.2.2 I would be curious to learn what you find out. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 25, 2003 6:50 AM To: Multiple recipients of list ORACLE-L hello to everybody recently a security breach was detected with OpenSSL - the password of a user could be decoded within hours, the bank account was robbed - but just for testing purposes - has anyone ever heard about a similar problem regarding to oracle ssl. we use it and i couldn't find a patch for this particular problem if there is any with oracle's ssl. kind regards Apologies for any typing mistakes I failed to notice. Markus Reger Oracle Applications DBA Webmaster MBC University for Music and Performing Art Vienna -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How long to hold onto old Oracle CDs?
Wild. You would think a business that makes and sells software would keep better track of it. Sounds kind of sloppy. So I guess I got lucky. David From: Mogens Nørgaard [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: How long to hold onto old Oracle CDs? Date: Mon, 24 Feb 2003 21:48:50 -0800 On the local level (eg Denmark) they might have a CD or they might not. There won't be a centralised, systematic archiving effort. Frankly, when I was in Support, I would sometimes contact a customer that I knew had a certain (old) version and have them ship a copy or lend it to me, so that I could help another customer. I'm not sure there's a central archive at HQ either. I've never heard about it, which doesn't say much, but I know for a fact about certain versions on certain platforms that couldn't even be located in Development during their supported cycle - but that's the odd exception, of course. I'd be very surprised if Oracle has a registered copy of version 5 in an archive, although there might still be some sensitive and confidential installations around with that version running. Mogens david davis wrote: I cut an iTAR on Metalink back last Oct. It would have been simpler. If someone had maintained our support agreement. But while that was being resolved. The sent me the CD. I got the CD in a couple of days. I was informed by someone at IBM that Oracle could burn new CD's. If you truly have a need for the CD. Such as lost/broken. Put pressure on them via your account rep. I hardly think it is likely for a vendor to say they don't have the code. If we have people on the list with software dating back to Oracle 4, I doubt Oracle is purging its archives of the software. It would be irrational. It is more likely they are just being difficult. Doing nothing is always the easiest route for the vendor. From: Adams, Matthew (GECP, MABG, 088130) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: How long to hold onto old Oracle CDs? Date: Mon, 24 Feb 2003 09:24:11 -0800 Two months ago, I tried to order older non-supported CDs (7.3, 8.0.5, 8.0.6) and they told me they could not ship them. How did you order them? Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Monday, February 24, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Actually the CD's are available. You just have to request them from Oracle. Of course, this does depend upon having a support contract. Ordered a replacement CD a couple of months ago for 7.3.4 (HP/UX) due to cracked media. From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How long to hold onto old Oracle CDs? Date: Mon, 24 Feb 2003 06:58:58 -0800 Hey all, Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs? We've been at 8.1.7 for 18 months now. I can't think of a good reason, other than the software isn't available anymore. Anybody want some old CDs? :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see
Performance issue
Hi Lisetrs, I have enough free memory from shared_pool_size and I run stats every week but the BD still shows up the low hit ratio and some times the later full down to 15%! Here is some informations: Obj mem: 79503437 bytes Shared sql: 23852410 bytes Cursors: 244875 bytes Free memory: 204512816 bytes (195.04MB) Shared pool utilization (total): 124320866 bytes (118.56MB) Shared pool allocation (actual): 3 bytes (286.1MB) Percentage Utilized: 41% Hit Ratio : 74.2249062 I appreciate to give me some guidelines. Thanks, Ben __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL struggle
Title: RE: SQL struggle (see answer below) -Original Message- From: Saira Somani [mailto:[EMAIL PROTECTED]] Oracle 8.1.7 on AIX 4.3 Here is what my data looks like in a table called item_w: WHSE_CODE ITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR 0 CPD-TGH 111230-OR 0 HL1 50034 .91 MSH-CDS 50034 0 CPD-TGH 50034-OR 0 HL1 650300 4.789 TWH-STAT 650300 0 CPD-TWH 650300-OR 0 CPD-TGH 650300-OR 0 If you'll notice, only the items with WHSE_CODE='HL1' have a cost associated with them. What I need to is: Parse ITEM_NUM for those items which have a suffix of -OR in order to compare with an ITEM_NUM without -OR so that I can take the last cost from there and display it beside the one that has -OR. Also note, there are some $0 cost items that don't have a suffix of -OR; I would need to match those up with a cost as well. So in the end, I suppose, this is the result I'm looking for: WHSE_CODE ITEM_NUM LAST_COST LAST_COST_REV - - - HL1 111230 1.12 1.12 CPD-TWH 111230-OR 0 1.12 CPD-TGH 111230-OR 0 1.12 HL1 50034 0.91 0.91 MSH-CDS 50034 0 0.91 CPD-TGH 50034-OR 0 0.91 HL1 650300 4.789 4.789 TWH-STAT 650300 0 4.789 CPD-TWH 650300-OR 0 4.789 CPD-TGH 650300-OR0 4.789 And if any of you out there use Cognos Impromptu, perhaps you could tell me how I can achieve these results in a report. Would this work? select a.whse_code, a.item_num, a.last_cost, b.last_cost as last_cost_rev from item_w a, item_w b where a.last_cost = 0 and replace (a.item_num, '-OR') = b.item_num and b.last_cost 0 union select c.whse_code, c.item_num, c.last_cost, c.last_cost as last_cost_rev from item_w c where c.last_cost 0 ;
password scripting question
This is somewhat related tothe question earlier about how to encrypt a password in a script... however, what I want to do is also be able to start that database through a script. (Oracle 9.2.0.) Essentially I have a database that I want to shut down at 5pm every night, and start it back up at 8am in the morning. I currently have a script that logs into sqlplus "/ as sysdba" I tried creating a use OPS$ORACLE and granted it dba, sysdba, and set the tablespaces. And I can log in fine doing a $ sqlplus / and when I do a 'select user from dual;' it comes back and says OPS$ORACLE... exactly what I want... however when I try to start or shutdown the database it says I must be logged in as SYSDBA or SYSOPR... or I try $ sqlplus "/ as sysdba" logs into oracle just fine, butwhen I do a 'select user from dual;' it comes back asSYS and not OPS$ORACLE... what am I doing wrong? Thanks! Nick
Passing data in a collection via a dblink
Hi all, A developper wants to pass a collection (varray) between 2 stored procs on 2 databases via a dblink. Can we declared a collection of a remote database locally ? This is on 8172 Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tél. (514) 925-7187 [EMAIL PROTECTED]
Re: Skill Sets - This may be a dumb question
Lisa, You are correct in your needing a vent or whining as you so eloquently put it. Corporate policy can and has ruined a great career if you are not prepared for the unforseen changes that the bean counters produce. Not knowing the knowledge level of your spouse and not wanting to start a family feud, Is the best person for the task assigned to the proper task? Perhaps there can be a compromise made and you can alternate positions periodically to give both of you additional knowledge. That way there would be a win-win situation.(I can't believe I used a corporate buzz word, Sorry just my past sneaking out). If the new position can be in fact a complete solution where suggestions are accepted and considered then perhaps you can point out the pluses of using Oracle for the data-mart. Then you can be in complete control from start to finish and keep your Oracle skill set up with the market. It is a tough time in the Oracle DBA market place. The published job listings have decreased drastically in the past 2 years. There still are openings out there but I feel that they are more prominent in the networking job listings rather than a head hunter or internet job search. I know that it would be an inconvenience to start a new job search now with the economy in question and the recent family increase, but IF you are dissatisfied with the current situation and you have thought it out completely and have complete agreement with your spouse, then I wish you good fortune and good luck. Ron [EMAIL PROTECTED] 02/25/03 11:34AM Hello everyone, Well I've been reassigned. I was responsible for the completely messed up Peoplesoft Oracle/AIX environment but management here decided that it was more important to separate a husband and wife that both work in the same department, and assigned one of them to be primary support in this environment instead of me. (sshh: The new person who is primary doesn't know a thing about Unix.) My primary job is now suppossed to be data modeling and data warehouse/mart design, moving on into Problematica (er, Informatica) development into a Sql Server database. I will not be the admin on the Sql Server database. My new boss referred to this as database architecture. ?? What? They have already decided what they want done and just want someone to take the pretty pictures and implement them with unrealistic deadlines. The main reason why I am upset is because it seems to me that data modeling is such a soft skill. I am concerned about keeping my skills up to date and keeping my hands in an Oracle environment, whether it's a mess or not. Seems to me that data modeling alone isn't something that can land you a new job or really spiff up your resume. I think that having a finite list of skills (Oracle, Unix, Windows 2000, Erwin, Project, crap like that) is more what employers search for, and is what HR depts can easily deal with. Am I wrong? This job pays well and working for a huge company has it's benefits, if you can deal with the bureaucracy similar to what is described in the 1st paragraph. And I know in this market I am just lucky to have a job. And please tell me if I'm whining. I may just need a KITA. Who knows anymore... Lisa Koivu Oracle Drink Beer Again Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
Re: Materialized views not refreshing
Didn't help to do it manually. On Tuesday 25 February 2003 06:14, Henry Poras wrote: Jared, Does it work if you do a manual refresh? Henry -Original Message- Sent: Tuesday, February 25, 2003 3:49 AM To: Multiple recipients of list ORACLE-L Dear list, Have any of you every experienced MV's not refreshing for no particular reason? We have been using some simple MV's for several months with no problem. Now after upgrading our app and database, there seem to be problems. Servers: Master: Win2k SP2 Oracle 8.1.7.4.1 Slave: NT 4 SP6 Oracle 8.1.7.4.1 These databases were previously 8.1.6. The master database now has a UTF8 character set, and all tables have NVARCHAR2 columns. These are being converted in the MV using: translate(COLUMN_NAME using char_cs) COLUMN_NAME when creating the MV. There are no errors, no trace files. Data is updated on the master node and never appears in the slave. The data continues to persist in the MLOG$ tables. I've verified there is only a single MV against each MV LOG, so the data in MLOG$ should be truncated after a refresh, but the fact that it isn't makes it fairly obvious that the refresh is not working properly. I have a serverity 1 TAR open now with Oracle, but so far all that's been accomplished with the TAR is me repeating everything I included initially. Any advice appreciated, as it's rather important to get this working again. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Materialized views not refreshing
Yes, the jobs were firing, verified by timestamps in both the dba_jobs and dba_refresh views. On Tuesday 25 February 2003 05:33, Darrell Landrum wrote: Is the job even firing at all? It is a common step in upgrading to set job_queue_processes=0 and this will prevent materialized views from refreshing automatically. Make sure this is greater than 0; I normally set it to 2. [EMAIL PROTECTED] 02/25/03 04:29AM Dear list, Have any of you every experienced MV's not refreshing for no particular reason? We have been using some simple MV's for several months with no problem. Now after upgrading our app and database, there seem to be problems. Servers: Master: Win2k SP2 Oracle 8.1.7.4.1 Slave: NT 4 SP6 Oracle 8.1.7.4.1 These databases were previously 8.1.6. The master database now has a UTF8 character set, and all tables have NVARCHAR2 columns. These are being converted in the MV using: translate(COLUMN_NAME using char_cs) COLUMN_NAME when creating the MV. There are no errors, no trace files. Data is updated on the master node and never appears in the slave. The data continues to persist in the MLOG$ tables. I've verified there is only a single MV against each MV LOG, so the data in MLOG$ should be truncated after a refresh, but the fact that it isn't makes it fairly obvious that the refresh is not working properly. I have a serverity 1 TAR open now with Oracle, but so far all that's been accomplished with the TAR is me repeating everything I included initially. Any advice appreciated, as it's rather important to get this working again. Jared Jared, What about the refresh jobs ? Does DBA_JOBS show failures ? If so, can you wrap the dbms_refresh call into something to catch the error ? (if you feel lazy I think that there is code to this effect on the Oriole site in one of the 'Aunt Augusta' papers). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Materialized views not refreshing
No, they were not being purged. On Tuesday 25 February 2003 05:59, Thomas Day wrote: We had the problem where the M$LOG was not being purged after the materialized view was updated. That doesn't seem to be your problem though. Jared Still jkstill To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @cybcon.com cc: Sent by: rootSubject: Re: Materialized views not refreshing 02/25/2003 06:49 AM Please respond to ORACLE-L No errors, no trace files. Refreshing via refresh group or directly via the snapshot both failed to update the MV. They've since been recreated and are working at the moment. I'll slap a big ole note on my forehead that says 'run a trace on them stupid!' so I will remember to do so if these start failing again. Off to bed for me. Jared On Tuesday 25 February 2003 02:29, Stephane Faroult wrote: Dear list, Have any of you every experienced MV's not refreshing for no particular reason? We have been using some simple MV's for several months with no problem. Now after upgrading our app and database, there seem to be problems. Servers: Master: Win2k SP2 Oracle 8.1.7.4.1 Slave: NT 4 SP6 Oracle 8.1.7.4.1 These databases were previously 8.1.6. The master database now has a UTF8 character set, and all tables have NVARCHAR2 columns. These are being converted in the MV using: translate(COLUMN_NAME using char_cs) COLUMN_NAME when creating the MV. There are no errors, no trace files. Data is updated on the master node and never appears in the slave. The data continues to persist in the MLOG$ tables. I've verified there is only a single MV against each MV LOG, so the data in MLOG$ should be truncated after a refresh, but the fact that it isn't makes it fairly obvious that the refresh is not working properly. I have a serverity 1 TAR open now with Oracle, but so far all that's been accomplished with the TAR is me repeating everything I included initially. Any advice appreciated, as it's rather important to get this working again. Jared Jared, What about the refresh jobs ? Does DBA_JOBS show failures ? If so, can you wrap the dbms_refresh call into something to catch the error ? (if you feel lazy I think that there is code to this effect on the Oriole site in one of the 'Aunt Augusta' papers). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
