Re: Test mesg
JS Just making sure the list is up. I'm up. Though I didn't know we had hours we were supposed to be online on a Sunday. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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[2]: IMP using the same DMP file
I agree with Waleed, I don't see any reason why it couldn't be done. On the other hand, you could very likely find out where the bottlenecks are on the box you are doing this on. If I were on a 4 processor box with lots of free bandwidth to my storage I'd do it in a heartbeat. -rje K I do not see a problem. The file can be read only. K -Original Message- K Sent: Wednesday, November 05, 2003 4:50 PM K To: Multiple recipients of list ORACLE-L K Hi, K We were just wondering if you can IMP into two instances using the same dmp K file at the same time? We need to refresh both our development and test K instances with data from our production database and doing both at once K might save some time. 8.1.7 and Unix. K Jerry Whittle K ASIFICS DBA K NCI Information Systems Inc. K [EMAIL PROTECTED] K 618-622-4145 -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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 to add ' (comma) at the begining and end of each line? Either Unix or Windows
$ cat data.txt
abf
jd
djkhk
jd3
$ awk {print \'\ \$0 \',\;} data.txt
'abf',
'jd',
'djkhk',
'jd3',
$
OD Hi List
OD I have 1000 lines in my data file. I want to add
OD '(comma) at the begining and end of each line.
OD For example,
OD abf
OD jd
OD djkhk
OD jd3
OD Shold be convrted to
OD 'abf',
OD 'jd',
OD 'djkhk',
OD 'jd3',
OD Any help will be really appreciated.
OD Thanks
OD Sami
OD __
OD Do you Yahoo!?
OD The New Yahoo! Shopping - with improved product search
OD http://shopping.yahoo.com
OD --
OD Please see the official ORACLE-L FAQ: http://www.orafaq.net
-rje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Robert Eskridge
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[2]: Cary's Book - new topic
Wolfgang, Tuesday, October 7, 2003, 2:04:24 PM, you wrote: W A totally different point: How come I see your response before I W see my own post? Sounds like you can see into the future. Would you mind reading the Wall Street journal and reporting back to us? -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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[2]: Physical I/O and databases other than oracle
Mladen, Thursday, October 2, 2003, 12:39:32 PM, you wrote: M I do accept your suggestion but I've just received Cary's book M and I'm enjoying myself very much. I do humbly apologize for any M confusion. To make is perfectly clear to anyone, BCHR is no longer M very relevant indicator. My last sentence (database with BCHR 99.9% M must be OK) was formulated in that way as an allusion to Cary Milsap's M known article Why 99% Database Buffer Cache Hit Ratio is NOT Ok. M I was just poking little harmless fun at the silver bullet approach. So I drink Coors Light while I'm looking at my BCHR, there's no reason to poke fun at me -rje [oh and here's the :-) ] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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[4]: DB2 has a foot in the door
Hey, how come my butterfly ballot has a staple in it's navel!?!?? M Nope, that's what voting machines are invented for. M They work almost perfectly in almost every state. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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: GREAT SCOTT!! 1.21 GIGAWATTS!!
Your subject line looks like a quote from Back to the Future. From the perspective of (a) being in Dallas, and (b) having all our database servers in hardened collocations with redundant onsite generators, my experience was pretty much having a few beers. I felt spiritually obligated to follow Bloomberg's advice to drink lots of liquids. We did see three of our monitored client's clients fall off line (about 2%). It's situations like this that make me love collocations. We basically get to be part of a co-op that pays someone else to worry about power, fire and physical security. -rje O Any listers (when you have time) who were effected the Great Blackout of O 2003 please share your experiences. UPS, Y2K backup generators fired up, O scramble to shutdown, communication issues etc... It would be good to hear O how folks handled the situation for future reference. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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[2]: dba age
I think that a typical DBA ages so fast that simple measuring
techniques are suspect
-rje
J insert into dba_tbl values('41'); --- thats mine
J do this for all of the experienced dbas
J select avg(age) from dba_tbl;
J :)
J joe
J AK wrote:
Now this one is difficult folks ..
what is average age of an experienced oracle dba ?
-ak
J --
J Joseph S Testa
J Chief Technology Officer
J Data Management Consulting
J p: 614-791-9000
J f: 614-791-9001
J --
J Please see the official ORACLE-L FAQ: http://www.orafaq.net
-rje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Robert Eskridge
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[2]: dba age
So, your answer is 51.667? Sounds about right. -rje P chronologically i'm 50 P mentally i'm 15 P physically i'm 90 P -Original Message- P Sent: Wednesday, 23 July, 2003 10:55 P To: Multiple recipients of list ORACLE-L P Now this one is difficult folks .. P what is average age of an experienced oracle dba ? P -ak -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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[2]: dba age
S I remember UFI, RPT-RPF, Forms 2.0 (IAD-IAG-IAP), SQL-QMX (for what it S last),ODL (Oracle Data Loader), but I do not remember SQLPME . What was it ? Ow! That makes my brain hurt. I think it was like Protected Memory Executive that allowed Oracle to run up in the above 1M region on 386's and in some special archetectures with 286's. I hadn't relived that nightmare in many years. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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[2]: Recent reports on outages caused by DB2 and 9iRAC issues
Not only should you confess to what you did promptly, confess to everything else too. If you do that often enough they quit believing you }:-) -rje O I've only made one mistake in my life and that was the time when I O thought I was wrong. ;-) O OK, getting serious... I've found it's best to QUICKLY be 100% truthful. O If you get crucified for it then it may be that damagement needs to O lighten up. Unfortunately the fear of damagement causes wheel spinning O work-arounds to compromises of the facts. ;-) O I once inadvertently brought a 24X7 production system down by shutting O down a test database that was managed by Veritas Cluster Server junk. O A hands on type director had added it to the cluster without telling me O so when I shut down the test database the cluster stuff tried to fail O over and everything came crashing down. I got the blame so it was a real O cluster-f*** because the damager wouldn't accept any responsibility O for this episode. Later he decided to change some Unix stuff all on his O own and the result was that the system was down quite some time. He as O rather cavalier about the outage and danced around the truth. Ultimately O his prevarications caught up with him and he was dismissed on the O spot. Justice was served. O -Original Message- O Sent: Friday, July 18, 2003 11:59 AM O To: Multiple recipients of list ORACLE-L O Importance: High O I always admit when I make a mistake. Gives me much more credibility O when I say this time it ISN'T me -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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[2]: (solved?) cannot disable or drop the ON DATABASE trigger !
*2 -- 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). RC === message truncated === RC __ RC Do you Yahoo!? RC SBC Yahoo! DSL - Now only $29.95 per month! RC http://sbc.yahoo.com RC -- RC Please see the official ORACLE-L FAQ: http://www.orafaq.net -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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[2]: utl_smtp error
Joan, MTA=Mail Transport Agent which is what routes and delivers mail usually using SMTP. On most Unix systems its some version of sendmail. Under windows it's often Exchange Server. This is different from the MUA=Mail User Agent which is what the user uses to manipulate his mail. The MUA usually communicates with the MTA with protocols such as POP, IMAP, and MAPI. On Unix that could be mail, mailx, elm, xmail, and such. Under Windows it's often Outlook but could be anything. -rje J Chris, J you got me, what MTA stand for? J Joan J Chris Berry wrote: -Original Message- Sent: Thursday, March 27, 2003 9:14 AM To: Multiple recipients of list ORACLE-L We have 3 databases on test server and one instance on production server. 8.1.7.4 oracle; None of them had those problem before. The email always working and had been tested throughly. Recently we got ORA-20001: 421 Service not available ORA-06512: at SYS.UTL_SMTP, line 83 ORA-06512: at SYS.UTL_SMTP, line 121 ORA-06512: at line 5 these errors. I noticed that some of ctxsys packages became invalid. After I recompiled all the objects, the errors are gone, it seems working. However, after 2 or 3 times success sent email, the errors showed up again. On production server, after I recompiled the packages, first time run successfully, then error out. I am not sure why it start to error out? It is not consistent, sometimes works and sometimes not; I checked all the related documents regarding these errors. Nothing really matches our case. Does anyone can point me where I should look into it? What MTA are you running? Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ 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: Chris Berry 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). J -- J Please see the official ORACLE-L FAQ: http://www.orafaq.net -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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: sar on Solaris 9
[I know this isn't an Oracle question, but I like this list better than the others and someone might just know] We just upgraded to Solaris 9 on our sandbox machine (Ultra 2) for the same reason that the bear went over the mountain. On all our machines, we measure a variety of parameters and graph them with MRTG. For several of these we use sar run from a perl script. Usually the command does 1 second samples for 10 seconds and strips out the Average line for the results. Solaris 9 doesn't seem to report that Average line like earlier versions: # sar 1 3 SunOS s4 5.9 Generic_112233-04 sun4u02/28/2003 08:00:27%usr%sys%wio %idle 08:00:28 64 31 5 0 08:00:29 70 19 11 0 08:00:30 63 10 25 2 # Solaris 7: $ sar 1 3 SunOS s2 5.7 Generic_106541-20 sun4u02/28/03 08:00:38%usr%sys%wio %idle 08:00:39 18 5 0 77 08:00:40 12 3 0 85 08:00:41 4 3 0 93 Average 12 4 0 85 $ Does anyone know how to coax that Average line out of sar on Solaris 9? Or will I need to revise my perl scripts to compute that line for me? Thanks, -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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[2]: Know 1 database, know them all?
Curiously, the basics are common across styles of cooking. You have to learn to coax the flavors out of the fresh ingredients and transform them into the proper texture and finish. Once you've mastered Italian cooking, you may not be a top notch German cook, but you're probably just a recipe or two away from being able to produce a very nice German meal... Databases have a certain similarity. If heading an Oracle project and I was given the choice between two people to work on my project, one having been the lead architect for a top notch product based on Sybase, and the other being an OCP that had worked on lack luster products, it would be hard not to pick the former. F Following the same logic. if I learn to cook a good Italian dish, then I F must automatically be an expert in preparing top-class Chinese, German, F Malay, Hungarian and French cuisine Yeah, right ! F Ferenc Mantfeld -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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[4]: Know 1 database, know them all?
And I'll certainly accept your differing opinion and even agree with it in the realm of installing an application and maintaining it. But I think there are traits in the design phase that are more transcendent. At the risk of torturing a metaphor beyond recognition, if I want to store a meal indefinitely, I want someone well versed in refrigeration and sanitation. If I want it to taste good I want a chef. BTW, cooking is one of my loves. Curiously, my big epiphany for the preparation of Italian, Mexican, Spanish, Vietnamese, Cajun, etc. came out of an Indian cookbook. Yamuna Devi's description of the processes occurring in a chaunk and thus the sequences that needed to be followed turned on a light -- sort of like when I read the YAPP paper. F I don't want to turn this into an OT post, but I beg to differ. When I F worked in Siebel Expert Services, I had to be able to install the app on DB2 F UDB, MS squeal server, and Oracle. BTW, I was hired on the strength on my F Oracle skills. Well, that turned me into a DBB (DB babysitter) instead of a F DBA for both DB2 and squeal server, and if there were tasks more complicated F than write a SQL statement, create a new user, create a table or index, on F DB2 and MS squeal server, I was nothing more than a DBB, but if there were F performance problems at a customer with the application running on Oracle, I F was requested by name to come clean up, where the client would rather wait a F few days for me to become available than for Siebel to send in a hot shot F DB2 whiz-kid, who on Oracle became a novice at best. F Also I should not have chosen cooking as an analogy, because it is one area F where my blatant ignorance on the subject is easily detected. But I know F that you take some ingredients, do some stuff to it (chop, slice, dice, F whatever), optionally heat it and mix it all together, and serve it. Holy F cow ! I think I have just mastered the art of this cooking thing too, what a F productive day this is for me. :-) F Ferenc Mantfeld F Dreaming costs you nothing. Not dreaming costs you everything. F - Original Message - F To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] F Sent: Tuesday, February 18, 2003 7:28 AM Curiously, the basics are common across styles of cooking. You have to learn to coax the flavors out of the fresh ingredients and transform them into the proper texture and finish. Once you've mastered Italian cooking, you may not be a top notch German cook, but you're probably just a recipe or two away from being able to produce a very nice German meal... Databases have a certain similarity. If heading an Oracle project and I was given the choice between two people to work on my project, one having been the lead architect for a top notch product based on Sybase, and the other being an OCP that had worked on lack luster products, it would be hard not to pick the former. F Following the same logic. if I learn to cook a good Italian dish, F then I F must automatically be an expert in preparing top-class Chinese, German, F Malay, Hungarian and French cuisine Yeah, right ! F Ferenc Mantfeld -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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: Send Mail in Unix
Thomas, Thursday, February 13, 2003, 9:44:07 AM, you wrote: M All, M I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun M Unix box to myself when the batch job runs. M Anybody been able to do this? I can send the text of the file, but what I M really want to do is to send the file (it's an Excel Spreadsheet). The trick is to uuencode it. Here's a snippet from a shell script I use to convert an HTML document with images to a .pdf and mail it to myself: echo Latency graphs for `date` /tmp/mailphcsc.$$ echo /tmp/mailphcsc.$$ htmldoc --webpage -f /tmp/latencyphcsc.pdf latencyphcsc.html uuencode /tmp/latencyphcsc.pdf latencyphcsc.pdf /tmp/mailphcsc.$$ cat /tmp/mailphcsc.$$ | mailx -s Latency Graphs [EMAIL PROTECTED] I'm using a tmp file since I'm adding text around the attachment. It can probably be done with just a: cat spreadsheet.xls | uuencode spreadsheet.xls | mail \ [EMAIL PROTECTED] -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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: OT: Cron not working
$ps xea | grep crond Will show you if the cron process is running or not -rje VB Hello to everyone... VB Red Hat 6.2 VB How do I find out what is wrong with cron? From January 15th until today VB cron is not working... My (oracle's) crontab file HAS not changed... VB So I went to the /var/log/cron file. Last activity was on January 15th. VB Since then no activity has been recorderd. VB If I issue crontab my crontab file and afterwards crontab -l, there VB are lines VB oracle (02/04-11:37:14-7686) REPLACE (oracle) VB oracle (02/04-11:37:17-7690) LIST (oracle) VB My job was scheduled on 11:40, however job wasn't executed. VB How do I see whether cron is running or not? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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[2]: awk and ksh question - solved
It still seems like overkill to me. I just put the pager addresses in
a alias in either /etc/aliases or .mailrc as a list for dba_oncall,
eliminating the need for db_oncall.txt.
In /etc/aliases:
db_oncall: [EMAIL PROTECTED], [EMAIL PROTECTED]
Or in .mailrc
alias db_oncall [EMAIL PROTECTED] [EMAIL PROTECTED]
Then when I want to send them a file I do:
$ cat FILE_TO_SEND | mail -s FILE_TO_SEND dba_oncall
No messing with awk or special characters, or worrying what shell it
runs in, I know the mail aliases live where all the other mail aliases
live so I don't have to go hunting for special files when something
needs to change.
KL Stephen, I'm aware of the syntax. My question was, WHY?? Robert hit it on
KL the head, awk and ksh are both interpreting $1.
KL Anyway I solved the problem with shift, like this. Thanks to all that
KL replied.
KL export PAGER=
KL export PAGERFILE=dba_oncall.txt
KL export FILE_TO_SEND=$1
KL shift ;
KL if [[ $# = 1 ]]
KL then
KL export SUBJECT=Subject: $1;
print $SUBJECT $$.log
KL shift ;
KL fi;
cat $FILE_TO_SEND $$.log
KL for PAGER in ${*-$(awk '!/^#/ {print $1}' dba_oncall.txt)};
KL do
KL print $PAGER
KL sendmail $PAGER $$.log
KL done
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Robert Eskridge
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[4]: awk and ksh question - solved
Stephen, Tuesday, February 4, 2003, 8:53:56 AM, you wrote: -Original Message- It still seems like overkill to me. I just put the pager addresses in a alias in either /etc/aliases or .mailrc as a list for dba_oncall, eliminating the need for db_oncall.txt. S -- S In a lot of companies, if a DBA managed to get into this file, the DBA would S have a short career there. Those are the companies that you'd use the $HOME/.mailrc for. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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: awk and ksh question
Lisa,
Awk and sh are competing for the interpretation of $1. I messed
around trying to get the replacement not to happen but didn't have
much luck.
Awk is overkill for this anyway. How about:
export FILE=$1
print File is $FILE
for PAGER in `grep -v ^# $FILE | cut -d -f1`
do
print $PAGER
done
-rje
K Hello everyone,
K I'm trying to awk through a text file and use that with a passed-in message
K to send email. Here's an example of my text file:
K # DBA's on call
K [EMAIL PROTECTED]# Lisa pager
K [EMAIL PROTECTED]# Lisa email
K Here's my awk statement, which works properly
K awk '!/^#/ {print $1}' filename.txt
K prints the first entry in each file and skips any lines starting with #.
K So I put it in a loop. I don't quite understand all the syntax here, I'm
K pulling the exact syntax out of Steve Adams' database check script.
K --
K for PAGER in ${*-$(awk '!/^#/ {print $1}' dba_oncall.txt)}
K do
K print $PAGER
K done
K --
K Works fine.
K Now when I try to pass in a parameter in $1 (which I mean to be the email
K message), awk grabs it and the script no longer works. Like this
K --
K export FILE=$1
K print File is $FILE
K for PAGER in ${*-$(awk '!/^#/ {print $1}' dba_oncall.txt)};
K do
K print $PAGER
K done
-rje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Robert Eskridge
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: awk and ksh question
Lisa,
And you're probably reinventing the wheel. Take a look at:
$ man aliases
$ man mailrc
-rje
K Hello everyone,
K I'm trying to awk through a text file and use that with a passed-in message
K to send email. Here's an example of my text file:
K # DBA's on call
K [EMAIL PROTECTED]# Lisa pager
K [EMAIL PROTECTED]# Lisa email
K Here's my awk statement, which works properly
K awk '!/^#/ {print $1}' filename.txt
K prints the first entry in each file and skips any lines starting with #.
K So I put it in a loop. I don't quite understand all the syntax here, I'm
K pulling the exact syntax out of Steve Adams' database check script.
K --
K for PAGER in ${*-$(awk '!/^#/ {print $1}' dba_oncall.txt)}
K do
K print $PAGER
K done
K --
K Works fine.
K Now when I try to pass in a parameter in $1 (which I mean to be the email
K message), awk grabs it and the script no longer works. Like this
K --
K export FILE=$1
K print File is $FILE
K for PAGER in ${*-$(awk '!/^#/ {print $1}' dba_oncall.txt)};
K do
K print $PAGER
K done
-rje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Robert Eskridge
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 Net connection.
B Is there any possible way to retain/reinstate/continue a SQLNet connection B if there is say a 10-second network outage? B For example: If a session is established and then the network cable is B unplugged for 5 seconds and then replaced. Is there anyway to keep that B connection alive? Assuming you are connecting TCP, I'd be shocked if it didn't stay alive -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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[2]: Americas Cup
Mladen, have you ever seen video of what a Coast Guard .50cal can do to a fishing boat? I don't know what armament Ellison's interceptor could carry, but I suspect the mounts would support something that could easily turn a racing yacht into toothpicks. G Well, Larry Ellison allegedly has MiG 25 which is an interceptor airplane G armed to blow other airplanes out of the sky. It doesn't have any weapon G system to sink a ship. He should purchase few F-16 and A-10 planes. G Those can be used against ships. Speaking of the race, allegedly those GPS G navigation systems they use in the modern yachts are running SQL Server. G Larry couldn't have won with a software like that. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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: BCHR Tuning
Of course it dropped dramatically. That's because you are no longer doing 99% of the buffer gets that you were wasting to begin with. If it drops my resource use and increases my performanc, I'd love to have a BCHR of 1%. (I know that's extreme, but wouldn't it be cool..?) F Here's an excellent real life example of why BCHR is not a good tuning F metric and you should focus on reducing I/Os. F A simple fix for a query and here is the resulting email to the client, who F understands that BCHR is not good. A little techie humor... F I have good news and I have bad news. F The good news is that the elapsed query time and total I/Os for the latest F iteration dropped significantly. Old -- 1:42 min 2,715,659 i/os (15,925 physical) New -- 22 seconds 3318 i/os (2861) F However, the bad news is that the Buffer Cache Hit Ratio dropped F dramatically! Old -- 99.36% New -- 13.77% F So, I have undone all the changes I made and will begin looking at other F methods to improve performance! -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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: BCHR Tuning
Dan, I apologize for not detecting the humor at first and giving a serious reply. Either I had some sort of weird window setting emphasizing the goofball portion of the message, or I need to tune my humor detector. (This is not a good sign on a Friday) -rje F Here's an excellent real life example of why BCHR is not a good tuning F metric and you should focus on reducing I/Os. F A simple fix for a query and here is the resulting email to the client, who F understands that BCHR is not good. A little techie humor... F I have good news and I have bad news. F The good news is that the elapsed query time and total I/Os for the latest F iteration dropped significantly. Old -- 1:42 min 2,715,659 i/os (15,925 physical) New -- 22 seconds 3318 i/os (2861) F However, the bad news is that the Buffer Cache Hit Ratio dropped F dramatically! Old -- 99.36% New -- 13.77% F So, I have undone all the changes I made and will begin looking at other F methods to improve performance! -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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: Metalink and HTML (GRRRRR!)
Rich, While the page is indeed butt ugly, I'll have to say that it's just as ugly in IE as it is in Opera (my browser of choice -- life is too short to wait on IE). It looks like no body even looked at it in a browser. -rje PS Life is also to short to wait on the bloated HTML generated by MS Word or even Front Page J OK, this is getting more than a little frustrating. Over the past few J years, I've put in TARs about the poorly-written HTML on the Metalink pages J because it causes certain articles to be unreadable in browsers other than J IE. I was hoping that the new Metalink (as yet unseen) would fix this, J until today when I read this: J http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab J ase_id=NOTp_id=135677.1 J Seeing that half of the article is double spaced and has margins asserted on J it that cause the code to wrap, I viewed the source: J meta name=Originator content=Microsoft Word 9 J JUST FREAKING GREAT! What happened to Uncle Larry's Linux Mandate? So what J if Oracle is converting to Linux? Why should their customers use Linux if J Oracle makes it more difficult for them? There ain't no browser available J on Linux that'll read that article properly because it's a Microslop-only J webpage! GR! | -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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[2]: Automatic backup on Oracle 9i -- For Jared
R I have philosophical trouble with it. I dislike the abbreviations. I R will use abbreviations to condense phrases (lol for lots of laughs) but R I really dislike seeing you written as u. It's not that hard to R type the extra two letters. And all this time I thought lol was laughing out loud. I guess I should have taken the class -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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: ORA-1410 Silliness
Lisa, Tuesday, December 31, 2002, 7:43:54 AM, you wrote: KL Usually when this happens I can re-fire the load and it will KL complete, no problem. It's a big annoyance and it seems like every KL time I take a day off it happens. How does it know you are taking a day off? Maybe you shouldn't set your mailers auto-reply :-) -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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: API for TNSPING
KL Does anyone happen to have a pointer to documentation on any APIs KL for TNSPING that exist ?? One of our developers is putting KL together a page and he would like to get the value of the 'length KL of time' that TNSPING returns. Do you consider Pro*C as a set of API's? If so, writing a Pro*C program that logs on and reports the results could give what you want. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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[2]: OT: OS/2 is officially dead as of Dec 10, 2002
Patrice, I really don't know much about it. I just remembered a feeling of shock and wonderment when I was reading a webpage where someone was installing eComStation. I just wanted to pass that same wonderment along :-) -rje BPJ Do they have to pay licensing fees to Microsoft for win-os/2 I wonder. B http://www.pcmag.com/article2/0,4149,767456,00.asp BPJ The reports of OS/2's death are somewhat exaggerated: BPJ http://www.russharvey.bc.ca/rhc/os2/ecs.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge 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: OT: OS/2 is officially dead as of Dec 10, 2002
Patrice, Tuesday, December 17, 2002, 2:40:38 PM, you wrote: B http://www.pcmag.com/article2/0,4149,767456,00.asp The reports of OS/2's death are somewhat exaggerated: http://www.russharvey.bc.ca/rhc/os2/ecs.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge 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[2]: Semi-OT: Pics from OracleWorld
I think the site has been slashdotted, err, I mean oracle-l'ed. K Connor: K Perfect pictures. Office looks cool. Perhaps Larry could sell Oracle in K Linux there. Small platform, low cost. K Thank You K Stephen P. Karniotis K Product Architect K Compuware Corporation K Direct: (248) 865-4350 K Mobile: (248) 408-2918 K Email: [EMAIL PROTECTED] K Web:www.compuware.com K -Original Message- K Sent: Tuesday, December 03, 2002 3:35 PM K To: Multiple recipients of list ORACLE-L K Subject:Semi-OT: Pics from OracleWorld K Apologies for the delay (the digital camera died on K the trip over) so apologies as well for the picture K quality (all taken with a throwaway disposable K camera). K But, here they are... the rough bunch that is the K Oracle Fatcity-L crew in San Francisco. K http://www.oracledba.co.uk/sanfran.htm K Cheers K Connor K = K Connor McDonald K http://www.oracledba.co.uk K http://www.oaktable.net K GIVE a man a fish and he will eat for a day. But TEACH him how to fish, K and...he will sit in a boat and drink beer all day K __ K Do You Yahoo!? K Everything you'll ever need on one web page -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge 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[2]: Anyone else had a Virus alert for Stephane Faroult's email ?
Stephane, Don't sweat it. Klez spoofs the sender in it's email, so it probably came from someone else's machine that had your email address somewhere on it. -rje S Sorry for the trouble, folks, but I have trouble understanding. When I S am answering the list, it is either from a Linux machine (and netscape) S - not infected by W32.Klez.H@mm according to the Symantec site - or from S a mail web interface. I sent the e-mail mentioned above on October 22nd S or October 23rd (two answers to the same question) more than one month S ago, and from Linux. I hope that somebody is not harvesting the list ... S If anybody has any hint about how to check for viruses on a Linux S machine, BTW ... S -- S Regards, S Stephane Faroult S Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge 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[2]: Ltrim?
Roland, By now you've seen several messages showing you the cron syntax to get you task to start at the time you want. There is characteristic of cron that seems to catch first time users -- the environment settings. As a shell users you'll be used to having your .profile or .login (or similar script depending on what shell you use) run and set up your environment. And when you run at or batch jobs your current environment is passed on to those scripts. Job's that start from your crontab on the other hand, have a stripped down environment. Try running a crontab command that just does a set and compare the email output to the environment that you have when you are at a shell prompt and the differences will be obvious. You'll probably see major differences in $PATH and $ORACLE_HOME, either of which could keep your script from executing properly. The solution is to set your own environment every time a crontab task starts. I keep a stripped down version of my .profile that I name .cron_profile that has the environment I need to run sqlplus scripts. Then my crontab entries look like: 0 6 * * 1 . $HOME/.cron_profile; script_name -rje J 0 6 * * 1 script_name R Hallo, R Anyone whom could help me how to write in cron when R scheduling the start of a unixprogram. R I would like that the unix script will run every monday on 6 am. R I have tried but it fails. Any suggestions, please help R Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge 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: DROP DEVELOPER not working
Is the application coming from a client? If so, sniff the packets and look for his DROP. That should be pretty conclusive. You can see the packets in a SQL*Net trace by setting TRACE_LEVEL_CLIENT=16 in sqlnet.ora. R We have a developer here, installing a third party application, who claims R one of his delete campaign process is hanging. I looked at the wait R events, saw nothing, and asked him to politely to go look at the code. R After much analysys, the developer now complains, that Oracle is not R executing a drop table command at the end of the process, and hanging R there. He claims he can drop the table from SQLPLUS. R I asked him to rerun the process. I noticed no wait events for that session R in v$session_wait when he claims the process is hanging. I see no DROP R statements in the v$sqlarea. I did a 10046 trace, and the last statement in R the trace file is a select statement. I looked at the sql addresses from R v$session, linked it to v$sqlarea and the sql_text shows the same select R statement as is seen in the trace file. I see no exclusive locks on the R said table. I conclude that the application is not sending a DROP statement R to Oracle for execution. He claims that cannot be the case. They have done R the same installation in a test environment and it worked fine. The jury R seems to be taking sides. I scream SOS. What more should I be doing? And R Does an Oracle 10046 trace write into the trace file after the statement R has executed? R Thanks R Raj R -- R Please see the official ORACLE-L FAQ: http://www.orafaq.com -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge 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[2]: Oracle and NAS (more Q's)
We wrote our own scripts to manage consistency. They manage the following levels of backup: 1. Snapshots of datafiles at the primary location. 2. Standby database at the secondary location. 3. Tape backup of datafiles at the primary location. 4. Tape backup of datafiles at the standby location. BL How do you do backups? BL Do you use RMAN with MML? Do you use NDMP? BL Tia. [EMAIL PROTECTED] 07/16/02 08:28a.m. BL Dick, BL We're using Netapp F720's to store all our datafiles (production and BL test) in a small/medium OLTP environment and are quite happy with the BL setup. YMMV. BL We run out of two sets of collocated servers. At each collocation BL there are at least two filers and at least two servers. The filers and BL the servers currently have three 100BaseT network connections. One BL front channel and two back channels. Each LAN segment is switched. BL Thus any server at a location can connect to any filer at that BL location. Datafiles can be spread across filers or spread across BL channels as performance requires. BL The WAFL does indeed write to the nearest available inode and relinks BL the inode map. The unlinked inode is immediately available for BL rewrite unless it is a member of a snapshot. Thus while reserving BL unlinked blocks is inefficient from a storage perspective, it is a BL factor you get to control by controlling the snapshots. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: Oracle and NAS storage systems
Hmmn, mutation in digital storage. Maybe that's why programs seem to have a shelf life? O So if you have a very busy varchar2(1) column and a 16K db_block_size, a 16K O block is written even if only one character in the block has changed? Seems O like hotspots, er, hot blocks could do a multiplicity thing. You know... O like the more you replicate DNA the more chance for mutation? :-) O Been watching too many movies... R The WAFL does indeed write to the nearest available inode and relinks R the inode map. The unlinked inode is immediately available for R rewrite unless it is a member of a snapshot. Thus while reserving R unlinked blocks is inefficient from a storage perspective, it is a R factor you get to control by controlling the snapshots. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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: OT - a good list for UNIX (Solaris) system administration topics
Another list as good as this one? I put that dream in the same category as cold fusion, the fountain of youth, and a tasty beer that never gives you a hangover -rje A Dear friends ! A Are you aware of a good mailing list for UNIX (Solaris/HP) system A administration - similar to this one ? A I'm also interested in other sources of knowledge for UNIX sysadmin-ism - A URLs , papers etc... A Please share your knowledge ! A Thanks a lot in advance ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: So, What is a 'Production DBA'?
Rachel, So we could distill your definitions down to: Production DBA: deals with real issues Application DBA: babysits developers :-) R that's not a bad definition :) R seriously, everyone will have their own definition, mine is: R production dba -- responsible for all databases that are considered R production. this includes but is not limited to: R backups R recovery testing R contingency testing R production performance tuning (should mostly be database tuning as SQL R really should be tuned at the development stage, with information R passed back from the production DBA) R documentation of all procedures R space management on production systems, including capacity planning and R projection of growth R change management R monitoring external data loads into production database R health checks on production database R application dba -- responsible for all databases in which developers R have access. responsibilities: R SQL tuning (not SQL coding!) R database design, in conjunction with the developers R any and all changes to the application schema R working with the production DBA to ensure production performance (see R SQL tuning!) R backups (these might be weekly offline backups, as development is R usually less critical but then again maybe not) R as deadlines creep closer, the weekends off may not be R this is just the short list R I've usually been both the production and application dba where I've R worked. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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: ORA_ENCRYPT_LOGIN
I'm not using it, but you can look at the packets too and from the client by setting these lines in the clients sqlnet.ora: TRACE_LEVEL_CLIENT = 16 TRACE_DIRECTORY_CLIENT = some directory TRACE_FILE_CLIENT = some file The output is pretty huge, so you don't want to do this for more than a trivial session before you turn the trace off. -rje R Anyone using this and if so, do you know of a way to verify that the R password is actually being encrypted? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[4]: Oracle wants your job
Curiously, as an ASP we've been contracted by some organizations for just that reason. Someone in upper management decides that their ability to enhance shareholder value is hindered by their current business rules. So they mandate using our application with little or no customization, driving their organization to shoehorn their business into rules that we support. It works well for that manager because we get positioned as the bad guys while he gets to reorganize his business without even attending the meetings where all the heated discussions take place. What a way to make a living J Good points all. J Reminds me of Larry E's statement last year that businesses J should be run the way the software works: no customizations. J Can you see why he said that? :) J Oracle corp knows best. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: data cleansing question
Lisa, I'll assume the mainframe application is Cobol or some derivative. Are the original file descriptors available to you? If so they should hold some real clues whether it is a good idea to null out the fields that are all zeroes. If the field is really a number and meant to be used in a calculation, I'd generally leave it as a zero. On the other hand, if the field is described by a list of values for some sort of status, and zero is not listed as a valid code, then I'd null it in a heartbeat. For example, I would not null this field: * SERVICE QUANTITY PASSED BY CLIENT APPLICATION V1.00 * SHOULD BE MINUTES FOR ANESTHESIA V1.00 * 03 CLHC-DET-SERV-QTY PIC 9(4). On the other hand I would certainly null this one: * * OVERALL DISPOSITION OF A CLAIM RETURNED BY IMPULSE * 02 RT-DISPOSITION-CODE PIC 9. 88 RT-DISP-REPRICED VALUE '1'. 88 RT-DISP-NON-REPRICED VALUE '2'. 88 RT-DISP-PENDING VALUE '3'. 88 RT-DISP-ADJUSTED VALUE '4'. 88 RT-DISP-BACK-OUT VALUE '5'. 88 RT-DISP-RE-REPRICEVALUE '6'. 88 RT-DISP-PEND-TIMEOUT VALUE '7'. -rje LK The EBCDIC-ASCII conversion is handled on the mainframe for me. I am sorry LK I don't know much about the mainframe environment here, I want to say it's LK VSAM, there definately is no database. It is so old, it's the type of LK mainframe where everything is on TAPE. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: Number of CPUs vs. Speed of CPUs
Beth, Thursday, April 18, 2002, 4:20:05 PM, you wrote: S I'm not positive, but I'm pretty sure you still pay by power units. a 4 S x 200Mhz costs the same as a 1 x 800Mhz. Everything I'm reading says power unit pricing went away last July and was replaced by flat per processor pricing. It was replaced by the per cpu pricing. If you had SE on a RISC processor at 666MHz the pricing stayed the same, if your processors are slower it got more expensive, with faster processors you got a bargain. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: SQL Tuning - How to avoid TOCHAR function against a date
How about something like: SELECT DATE_KEY FROM DATE_DIM WHERE ORACLE_DATE between trunc(:b1) and trunc(:b1)+86399/86400; It's not the prettiest thing in the world, but it keeps the use of the index on ORACLE_DATE and an adjacent comment that there are 86400 seconds in the day should make it readable enough. -rje R I don't think you can do it.. I mean, you could change it to trunc the R oracle_date field (that eliminates the minutes) and then do a to_date R of :b1 but you will still be operating on the oracle_date field. R Okay, I HATE to suggest this, but since the table is small: R add another field to the table oracle_date_2 as a date field. Update R the table set oracle_date_2=trunc(oracle_date) R add a trigger to fill in oracle_date_2 when you insert a row or update R the oracle_date column R create an index on oracle_date_2 and change the query to use that R column R --- [EMAIL PROTECTED] wrote: I've got the following SQL statement that is running very long on a nightly data load. The problem is the TO_CHAR function which is preventing me from using the index on this small (20,000-row table). This is an 8.0.4 database so it is not possible for me to use make this a function-based index. The problem is that the date field has minutes, etc. included and those need to be eliminated before the comparison can be made. That's why I can't just eliminate the TO_CHAR from both sides of the equation. Isn't there a way that I can pull this function out of the select statement and do it in a preceeding statement? Then I could just pass in both variables to this statement without the TO_CHAR and use my index. Is this realistic? How, exactly could it be done? SELECT DATE_KEY FROM DATE_DIM WHERE TO_CHAR(ORACLE_DATE,'DD-MON-') = TO_CHAR(:b1,'DD-MON-') SQL desc date_dim; NameNull?Type --- DATE_KEYNOT NULL NUMBER(5) ORACLE_DATE NOT NULL DATE DATACOM_DATE NUMBER(6) DATACOM_REVERSE_DATE NUMBER(6) DAY_OF_WEEK NOT NULL VARCHAR2(30) DAY_NUMBER_IN_MONTH NOT NULL NUMBER(3) DAY_NUMBER_OVERALL NOT NULL NUMBER(9) WEEK_NUMBER_IN_YEAR NOT NULL NUMBER(3) WEEK_NUMBER_OVERALL NOT NULL NUMBER(7) MONTH NOT NULL VARCHAR2(30) MONTH_NUMBER_OVERALLNOT NULL NUMBER(7) YEARNOT NULL NUMBER(5) WEEKDAY_IND NOT NULL CHAR(1) LAST_DAY_IN_MONTH_IND NOT NULL CHAR(1) DATA_WAREHOUSE_MOD_DATETIME NOT NULL DATE DATA_MART_MOD_DATETIME NOT NULL DATE SQL select oracle_date from date_dim where rownum=1; ORACLE_DA - 01-JAN-70 Thanks in advance for any help. Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: Fav. Urban Legend...Mem vs Disk
JL For those who aren't familiar with the book, JL the question of Life, The Universe, and Everything JL turned out to be: JL What is six times nine ? JL (And coincidentally, or so the author claimed, JL 6 x 9 = 42 if you are working in base 13). Hmmph. More kowtowing to Douglas Adam's cheap rip off on Kilgore Trout's epic, Venus on the Half Shell. Check the name of the FTL drive in the latter and compare it to The Question. Curious though, how the answer is just one more than the maximum ITL slots with 2k blocks... (he says in a desperate attempt to get back on topic) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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: Another partitioning question
I've never done partitioning but I've got an idea. What about adding a column to hold a value of what partition you want to be in (P1-P6), then populate that with a pre-insert trigger with whatever logic you want...? It's probably a naive idea, but I'm sure I'll learn from the list... :-) -rje S I think what my boss is asking me to do is not possible, but since I don't S have much experience with partitioning I thought I'd ask here (I did read S some of manuals but didn't find an answer that suited my conditions). My S boss wants a table partitioned by 2 columns - seq_no and type. If the type = S 'X' then it's just a range partition, but then he wants another partition S that contains all data that type!='X' but is inclusive of the entire range. S Is this possible? S Something like (I know this syntax isn't correct ) S create table test_part( S id number(11) unique, S owner_id number(11) not null, S type varchar2(30) not null, S name varchar2(40)) S partition by range(owner_id,type) S (partition p1 values less than (2000) and type ='X' tablespace test, S partition p2 values less than (5000) and owner_table ='X' tablespace S test, S partition p3 values less than (1) and owner_table ='X' tablespace S test, S partition p4 values less than (5) and owner_table ='X' tablespace S test, S partition p5 values less than (10) and owner_table ='X' tablespace S test) S partition p6 values less that (10) and owner_table !='X' tablespace S test; -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: Strangeness
Jared, Yeah, they don't want to hear about PL/SQL because then they can't scale it up on the middle tier where they can have dozens of machines with the same poorly written app simultaneously pounding the database thousands of times more intensely than the task requires Hmmph. Topics like this on a Friday make me want to dig deeper into my toolbox (the malted compartment of course). -rje J Lee, J I've had similar experiences. J The problem is not PRO*C, but how the program is designed. J Is it by any chance written in C++? I once had the 'privilege' of J administering an the databases for an application written in C++. J The software featured and award winning design, literaly. The OOP J design was honored in some OOP magazine. J When you consider though that this wonderful OOP design treated every J piece of data from the database as atomic, and retrieved them that way, J you can begin to see the problem. J The average SQL*Net packet size was 200 bytes, sub optimal to say the J least. This is because the app preferred to retrieve it's own information J from the database and do the joins in the software. J In a couple of hours this app could process all of 10k transactions, and J generate several million TCP/IP packets in the process. J I suggested they move the app to the database server: this resulted in J a 40% decrease in runtime. J We offered to rewrite the whole thing in PL/SQL, but that was a J politically incorrect suggestion. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: Secret maximum for INITRANS?
Yes, and that's exactly what I was suspecting. Thanks for the quick confirmation. -rje KG I guess you are looking in 'itc' in block dumps which shows the KG ITL Count. KG And yes.. There is an upper bound for number of ITLs based on the KG block size. The transaction slots (and other headers) can not use KG the more than 50% of the space available for data in the data KG block. Each ITL will take 24 bytes of space in variable header KG part of the data block. KG In 2K block (2048) 50 % is 1024 Bytes. In this we can not use the KG first 48 bytes (fixed headers in cache layer and TX data layers KG uses them. So the space available for ITLs will be 976 bytes. KG So you can get round (976/24) ~41 ITL slots for 2K block size. If KG you set INITRANS more than 41 they are simply ignored and only 41 KG ITLS are created in that block. RE I'm still messing with my enqueue waits on an insert. I'm now able to RE recreate it on a test database by throwing enough simultaneous inserts RE at my table. I was going to make sure which of the tables/indexes was RE actually causing the waits by individually raising the INITRANS above RE what they would naturally expand to, and see how the waiting sessions RE responded. RE I was hitting it with 50 simultaneous inserts and usually had 10 RE sessions go into an enqueue wait until the 40 sessions committed or RE rolled back. So I was going though the indexes and then tables RE raising the INITRANS to 50 to see which one(s) made a difference. RE None of them made a difference. RE So I dumped blocks that had been populated only during this exercise. RE Invariably, there were 0x29 Itl slots. Is there something out there RE that would limit the Itl entries to 41 even when MAXTRANS=255? Is RE there some secret bound based on block size? Ours is 2k (which I RE figure is part of the problem). RE Other vital stats: 8.0.5 on Solaris 2.7. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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).
Secret maximum for INITRANS?
I'm still messing with my enqueue waits on an insert. I'm now able to recreate it on a test database by throwing enough simultaneous inserts at my table. I was going to make sure which of the tables/indexes was actually causing the waits by individually raising the INITRANS above what they would naturally expand to, and see how the waiting sessions responded. I was hitting it with 50 simultaneous inserts and usually had 10 sessions go into an enqueue wait until the 40 sessions committed or rolled back. So I was going though the indexes and then tables raising the INITRANS to 50 to see which one(s) made a difference. None of them made a difference. So I dumped blocks that had been populated only during this exercise. Invariably, there were 0x29 Itl slots. Is there something out there that would limit the Itl entries to 41 even when MAXTRANS=255? Is there some secret bound based on block size? Ours is 2k (which I figure is part of the problem). Other vital stats: 8.0.5 on Solaris 2.7. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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).
Tracing sequences (was re: freelist tesing)
Anjo has convinced me that I was indeed barking up the wrong tree (and even if I was the tree didn't care) He lead me into tests that shows my problem exhibits exactly the same characteristics of trying to insert the same value into a unique index simultaneously. That somehow, one user does an insert with one value, and before he commits, another session (usually different user -- not always) tries to insert the same value. Previously I had examined the developers code and convinced myself that this could not be the case as he selects a sequence nextval into a variable, then immediately uses that variable to create a the value list for the insert. I haven't found anything that makes me want to mistrust a sequence nextval. (If anyone knows of one in 8.0.5 on Solars 2.7 please let me know.) So I've got to mistrust something going on in the developers VB based COM object running under MTX serving up ASP pages for IIS. (Notice the long string of MS products there and you can guess how that influences my suspicions.) Since I've come to this realization, the event has not recurred, so I don't have any statistics. But we do know that when it starts, we see incidents from all 8 webservers simultaneously. Past evidence collected for a blocker and a blocked session shows that they were on the same webserver, but that's just 1 data point and we don't have any other to confirm or deny that relationship. Also when it starts, it happens at a furious rate, dozens of sessions at once. Then it suddenly stops. Curiously, the same applications on the same webservers are handling 30 other databases which experience no problems. This points me back to the database. sigh One of the things I would like to do, is to record what the database thought it answered for the select of the sequence nextval, and have that for comparison when the application tries to do its insert. My dream would be to have a trace/log/journal/something that recorded the nextval returned,user,session,serial#,and sysdate for every time the sequence was read. This would allow me to see discrepancies in the select/insert and sessions that were trying to insert without actually making the select. Has anyone tried this level of tracing/logging before? -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[4]: address parse
MTF Robert must be new to the list. He is MUCH too nice. :) Sh! I'm playing good cop/bad cop.. :-) -rje MTF -Original Message- MTF Sent: Tuesday, February 26, 2002 4:12 PM MTF To: Multiple recipients of list ORACLE-L MTF John, MTF We're actually messing with you a little bit, having fun at your MTF incomplete question. Not only are there many things that could be MTF considered an address, some of them have several components that could MTF be combined in several different ways. Not only that, but there are MTF different ways that you might choose to represent those components. MTF A common street address example would be that given something like: MTF '1293 Incomplete Drive, Suite 2001, Mail Stop H, Specification City, MTF Oklahoma, 74953-0011' MTF And a common set of fields to parse it into would be: MTF AddressLine1 MTF AddressLine2 MTF City MTF State MTF Zip MTF When stating a parsing problem both the input form and the output form MTF need to specified. Also any peculiar rules. Above you'd need to MTF state things like: MTF -Assume USA address MTF -Comma separated fields MTF -City state and zip are last three fields MTF -First field always AddressLine1 MTF -If 4 fields AddressLine2 left null MTF -If 5 fields then field 2 is AddressLine2 MTF -If 6 or more fields, then fields 2 - (n-3) are concatenated separated MTF by commas in AddressLine2 MTF -State will be stored as 2 character state code MTF -Zip can be either 5 digit or 9 digit (no dash) codes MTF Now given all that, a parse routine could be written. But lacking MTF such a specification, the question is very open for various MTF interpretation, any of which has only a remote chance of meeting your MTF needs. MTF -rje S street address S -Original Message- S Sent: Tuesday, February 26, 2002 10:55 AM S To: Multiple recipients of list ORACLE-L S Anybody already have an address string parser (plsql) already written S that S they would care to share? S Address? IP? Internet mail? USPS? Memory address? URL? MTF -rje -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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 to restart SNMP daemon process
N How do I restart a daemon process on UNIX if it dies? First, knowing why it died is a good thing. Especially when it's SNMP for the last couple of weeks. Most implementations have a vulnerability that the vendors have been pumping patches out for. But to answer your question, when this happens to me, I like to go and see how it got started in the first place, so I can replicate any parameters that were missing. In System V based Unix implementations this happens in the /etc/rc?.d directories. Find the one that starts the daemon you want. On Solaris it's /etc/rc.3/S76snmpdx which can be run with either a start or a stop parameter. Of course you can look inside the rc start script and see exactly what commands it uses to start the daemon and do it yourself. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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: address parse
S Anybody already have an address string parser (plsql) already written that S they would care to share? Address? IP? Internet mail? USPS? Memory address? URL? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: address parse
Shaw, S street address How is it formatted? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: address parse
John, We're actually messing with you a little bit, having fun at your incomplete question. Not only are there many things that could be considered an address, some of them have several components that could be combined in several different ways. Not only that, but there are different ways that you might choose to represent those components. A common street address example would be that given something like: '1293 Incomplete Drive, Suite 2001, Mail Stop H, Specification City, Oklahoma, 74953-0011' And a common set of fields to parse it into would be: AddressLine1 AddressLine2 City State Zip When stating a parsing problem both the input form and the output form need to specified. Also any peculiar rules. Above you'd need to state things like: -Assume USA address -Comma separated fields -City state and zip are last three fields -First field always AddressLine1 -If 4 fields AddressLine2 left null -If 5 fields then field 2 is AddressLine2 -If 6 or more fields, then fields 2 - (n-3) are concatenated separated by commas in AddressLine2 -State will be stored as 2 character state code -Zip can be either 5 digit or 9 digit (no dash) codes Now given all that, a parse routine could be written. But lacking such a specification, the question is very open for various interpretation, any of which has only a remote chance of meeting your needs. -rje S street address S -Original Message- S Sent: Tuesday, February 26, 2002 10:55 AM S To: Multiple recipients of list ORACLE-L S Anybody already have an address string parser (plsql) already written S that S they would care to share? S Address? IP? Internet mail? USPS? Memory address? URL? -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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: MIGRATION
Guri, When we move hosting centers, we certainly prefer to do it with some overlap. We usually move our machines with the test databases, create enough room to make standby databases for production. That way we can halt the production databases, activate the standby's and switch our applications over in a matter of minutes. Then leisurely move the production machines and reverse the standby procedures to get the databases back on the original machines. I know when you compare it to power down the machine and move it it's a lot of activity. But there's a lot of peace of mind having an operating database at the new location before you take down production -- you just never have a database dependent on equipment that is in the hands of teamsters. If you don't have the machines to do something like this and can't beg, borrow, rent or steal. Then I'd advise cold backups on removable media transported in a different vehicle than your machine. It's a good idea to have more than one device that can read the media as I've found that removable media devices fail during moves more than most other devices. -rje g I am planning to move our DB servers from one data center to another Data g center.Let me know what precausion should I take care please? g Thx g -Guri -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: MIGRATION
guri, If you don't have the time to get the cold backup to removable media, you'll just have to accept the risk of the box being lost, stolen, or destroyed in an accident. You can still reduce risks in other areas. I don't see what risk you are abating by making a cold backup to another disk partition, unless that partition is on another physical drive. A physical event that causes one file to be unreadable (such as head damage) usually renders the entire disk unreadable, so you don't gain much. If it's a different physical drive, at least you're gaining the probability of one of them surviving the physical abuse. Chances are you'll be able to shut down the database, shut down the OS, power down the machine, carry it to the new location, and power it back up with no problem. Modern equipment is fairly robust. Personally I'd treat it all like a carton of eggs just to be safer. The how much extra precaution you take should be based on what it will cost you if the machine falls off the truck, never to be seen again. One can justify the cost of the precautions as long as they are lower than the cost of the loss. -rje g I don't have machine to buildup the standby database.I don't have much time g to take cold backup also.I think if Can take cold backup on another disk g partition would be fine. g Any suggestion please? g Thx g guri -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: ftp from unix session to your local harddrive-How?
Celine, Monday, February 25, 2002, 2:20:29 PM, you wrote: Since you are using ssh, have your tried using sftp? -rje C Sorry, I guess the description fo my question was C quite vague. But what I really wanted is pretty much C spelt out in the Subject line. C In the meanwhile, thanks to Kirti, I will check out C samba. C Here is my problem:- C When I am on-call on weekends etc. I connect remotely C using ssh to get to my Unix server at work. Now if I C want to download some files from my Unix session to my C PC harddrive, C I expected to be able to open a ftp session from my C unix session to my PC so that when I do a get/put it C would allow me to transfer files to and from my C: C drive to my unix server at work. C ( opening a ftp session from my dos prompt from home, C gives my an authorization error on the server which C is not surprising. Hence the need to do the other way C round.) C I hope I am making myself clear. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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: testing freelists
list
group need to update their free list header records simultaneously. There
are various ways of addressing these problems such as rebuilding the table
with more free list groups, or increasing _bump_highwater_mark_count, or the novel
idea of fixing the application.
To drill down on which segments are causing data block contention, I suggested using
event 10046, level 8. This creates a trace
file much like to one produced by the sql_trace facility, except that for each event
wait a line is printed to the trace
file. In particular, each buffer busy wait is recorded together with the
P1 and P2 values which are the data file and block number of the wait. So
to find which blocks a process has been waiting on, you just grep the trace file for
buffer busy waits lines and produce a histogram of the file and block numbers most
commonly
waited for. Once you have suspect file and block numbers, you can relate
them to a segment by querying DBA_EXTENTS. In the case of free list
contention on a table it is common to have several hot blocks just below
the high water mark for the segment.
If you really want to learn the internals, his book is excellent for that.
It's not normally necessary
IMO to delve that deep into the internals to deal with tuning problems, at
least in my experience.
It will certainly help you develop insight and intuition as to what is
going on with your database though.
HTH
Jared
Robert Eskridge [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/04/02 08:15 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:testing freelists
I've got a database that I'm experiencing blocking locks on insert
statements into the largest, most active transaction table. The
freelists currently=1 and it's on a 4 CPU Sparc under 8.0.5 in a 24/7
environment.
I think this points to freelists needing to be increased. The powers
that be want a guarantee before they give me a maintenance window so I
can go through the rebuild on this table to change the freelists.
(We've got an 8.1.7 conversion project going but this can't wait.)
So I'm trying to put together a test set to prove that the freelist
increase will help. What I've been trying has two parts. A simple
sql script like:
$cat blocktest.sql
insert into block_test values
('
xx');
host sleep 60
commit;
exit;
And a shell script to run it.
$ cat block.sh
itr=1
echo $itr
while :
do
sqlplus me/mypasswd@sid @blocktest
itr=`expr $itr + 1 `
echo $itr
if [ $itr -eq $1 ]
then
break
fi
done
I've run starting up to the max processes allowed by the database, and
still don't get the blocking lock on the database. If I can't get
blocking locks to appear in a test situation, then I can't prove that
increasing the freelists helps the situation.
Any suggestions?
-rje
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robert Eskridge
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself 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: The use of schemas
Multiple schemas can be handy if there's a reason to isolate functional areas. One reason might be so that when you fire up a tool that does ERD's you can tell it to do just the BILLING schema. Or if you wanted to export just a section to load into a test database to do development. You could make use of the multiple schemas to help assign roles. On the other hand, 35 tables really doesn't scream for such a division. Personally, I like to keep logical areas in the 8-20 tables range, but that's just because that's what is easy for me to grasp. Also, such schema divisions should really be part of the original design and should facilitate the design. Shoe horning an existing design into a mold just to be pretty can be frustrating. -rje o Our consultant has presented a schema design which I have never seen o (not that I have seen all the designs in the world) but I also failed o to see the advantage. o Basically our application consists of 35 tables and all is under one o schema named after the application. Granted, the application has many o components such as billing tables, event tables etc. o Now the consultant wants to split all 35 tables into as many as 8 o different schemas! Such as a billing schema, a event schema. To me o this only complicates the whole thing as now you have to manage 8 o schemas and manage many grants, synonyms. Not to mention some tables o are not clear cut as which component it belongs to. I just don't see o what this buys us. o Has anyone seen such a approach? And what's the benefit of doing so? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: Screen
I was just hoping it was really a list. If they were concurrent we might never be able to look Dave in the face again -rje RC In that order? pleae tell me it's just an alphabetical list :) RC --- Dave Morgan [EMAIL PROTECTED] wrote: A list of Dave's favourite things: Snip S:screen, sex, skiing, sleep, sushi Snip Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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).
testing freelists
I've got a database that I'm experiencing blocking locks on insert
statements into the largest, most active transaction table. The
freelists currently=1 and it's on a 4 CPU Sparc under 8.0.5 in a 24/7
environment.
I think this points to freelists needing to be increased. The powers
that be want a guarantee before they give me a maintenance window so I
can go through the rebuild on this table to change the freelists.
(We've got an 8.1.7 conversion project going but this can't wait.)
So I'm trying to put together a test set to prove that the freelist
increase will help. What I've been trying has two parts. A simple
sql script like:
$cat blocktest.sql
insert into block_test values ('
xx');
host sleep 60
commit;
exit;
And a shell script to run it.
$ cat block.sh
itr=1
echo $itr
while :
do
sqlplus me/mypasswd@sid @blocktest
itr=`expr $itr + 1 `
echo $itr
if [ $itr -eq $1 ]
then
break
fi
done
I've run starting up to the max processes allowed by the database, and
still don't get the blocking lock on the database. If I can't get
blocking locks to appear in a test situation, then I can't prove that
increasing the freelists helps the situation.
Any suggestions?
-rje
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robert Eskridge
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself 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[2]: SQL Injection and Oracle?
d Nope, you could do it with any sql based database unless your forms have d protection built in. Thankfully our WEB guys did that by accident. Namely when d they accept a data value they have certain rules that they apply to all fields, d like max length, no unlimited length fields, comment data manipulated via d procedures. It's rather easy, but you have to design it that way. That's what I suspected. I probed the few trival forms that I'd done with CGI/Oracle and found that mine were accidentally safe -- I figure pretty much like a pocket protector keeps you from getting STD's. Limited fields and some javascript pre-processing. But now I've got some concerns about what our developers have done in our big app. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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 Injection and Oracle?
Today I've seen two white papers on a technique called SQL Injection for exploiting databases via web pages. One of the papers was pretty much a step by step tutorial on how to reverse engineer data structures and have your way with a SQL Server database via ASP pages. Both papers were ASP/SQL Server centric. But in my quick reads, I didn't see anything that made me think it would not work against many HTML forms backed by CGI scripts hitting Oracle databases that I've seen. Am I missing something? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: TOAD Software???
Jared, I find it somewhat curious that while the first four tools suggest a preference for the home brew approach, the last five are certainly third party tools. I'm certainly with you on the first four, but I think the others need more research. If you are ever in Dallas, we'll have to go to a lab and compare results -rje J As for the tools that I would steadfastly refuse to give up, sorry, TOAD J doesn't make the cut. J Tools that do make the cut: J SQL*Plus J vi or vim J korn shell J Perl J Guiness J Yukon Jack J Bombay Saphire Gin J Martini and Rossi Vermouth J Lagavulin Single Malt J Not necessarily in that order. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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: Procom NetForce
Someone mentioned that they thought NetApp was the only approved NFS mount for Oracle. (I would have quoted the message but my finger seems real twitchy over the delete key these days.) I thought so to, but decided to look. From what I'm seeing at this Oracle page, that must not be true anymore. The ProCom NetForce is certainly listed there. http://otn.oracle.com/deploy/availability/htdocs/oscp_papers.html So, has anyone seen a features comparison between NetApp and NetForce? -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: using Net8 through NAT router
I am trying to connect to a database on the inside of a NAT. I get a tns connection time-out error. According to Oracle, I have to use Connection Manager. I find this a little hard to believe. I would think a CISCO router doing NAT would be smart enough to translate Net8 packet headers for me. Anyone? We ran into problems with some implementations of dynamic NAT. The dynamic NAT kept a table of which internal address was attached to which connection of the single external address. Everything was cool as long as the number of connections were small. But as connections (of all types) increased the table filled. Then when a new connection was made, older connections were dropped unceremoniously. Dynamic NAT's of this sort are useful for things like surfing where connections are very ephemeral, but not persistent client/server connections. The solution? With this particular router, a static NAT, where each client that needed an individual external IP. That's the only way this router would lock an entry in the translation table. Other routers/firewals/proxy servers may have other methods -- but I didn't investigate further. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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).
Converting UPU Licenses
Hello everyone. I've been off the list for a while, so I hope this subject hasn't been beaten to death while I was gone. I did some searches in the archives but didn't come up with anything. When Oracle announced the new $15,000/$40,000 per CPU pricing back in June, the announcement said there would be an easy formula to convert UPU's to the new scheme within a week. Unfortunately I can't find that formula. Does anyone have it? -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: Converting UPU Licenses
Gene, Perhaps I'm not looking at it right. I can find current pricing on that page but not how to convert existing UPU licenses. For example, lets say someone had a 2x300mhz Sun Sparc and last year licensed the appropriate 2x300x1.5=900 UPU's. Now they are pricing out what it would take to upgrade the processor to 4x400mhz cpu's. Under the UPU scheme you'd just say the new one is 4x400x1.5=2400 UPU's so you would need to purchase licenses for an additional 2400-900=1500 UPU's. Under the new scheme what does one do? Just purchase two new processor licenses? The phrase formula to convert in the press release hints otherwise. I suspect that some X UPU's = 1 processor license -rje G try this site: G https://oraclestore.oracle.com/OA_HTML/ibeCZzpHome.jsp?site=OracleStoreUSrespid=22372 [EMAIL PROTECTED] 12/12/01 12:50PM bry Hello everyone. I've been off the list for a while, so I hope this bry subject hasn't been beaten to death while I was gone. I did some bry searches in the archives but didn't come up with anything. bry When Oracle announced the new $15,000/$40,000 per CPU pricing back in bry June, the announcement said there would be an easy formula to convert bry UPU's to the new scheme within a week. Unfortunately I can't find bry that formula. Does anyone have it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: Network Appliance Options
That's why you use multiple connections (switched or direct with crossover cables) and balance them. That way you change your mount points to isolate certain types of traffic or limit saturation. We have 3 mount points for a NetApp, each on a different 100BaseT named like /mnt_n1e0, /mnt_n1e1, etc. Datafiles are separated into an OFA like directory structure that isolates certain types of behavior. For example, large indexes for database TEST might be in the directory /u09/oradata/TEST. We use symbolic links at this level, like: ln -s /mnt_n1e1/home/u09/oradata/TEST /u09/oradata/TEST If we wanted to isolate that to a different ethernet link, we shutdown the database and rm /u09/oradata/TEST ln -s /mnt_n1e2/home/u09/oradata/TEST /u09/oradata/TEST And start the database. In a few seconds we've moved the datafiles in that directory to a different NFS link without Oracle even knowing it. There are plenty of games to play if you stocked your equipment with plenty of ethernet ports. (One word of warning, on some of the quad ethernet cards on the Sun, I'm told that the overall throughput is far less than 4x a solo card. Be sure and check that out...) -rje D Kathy - We have used them for supplemental storage on our test/development D system (Compaq Tru64, Oracle 8.1.6). The limitation seems to be the NFS D connection is slower than your conventional or real disks. For some D tasks this isn't a problem, but it is easy to start several large tasks that D saturate the NFS connection. For example, when I have to build several large D indexes, I copy the underlying tables to the real disk, and build the D indexes one at a time. I won't deny that I may be overreacting to some D problems. Other than that, it seems to work fine for our test/development D system where it generally receives sporadic and light use. I am told that it D cost much less than conventional disks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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: Network Appliance Options
Kathy, Monday, September 24, 2001, 5:07:28 PM, you wrote: K Has anyone used Network Appliance? K Any options good/bad appreciated as it applies to Unix (Solaris and K HP) and Oracle 8.1.6 and above. K Going to a dog and pony show by them tomorrow. Our databases are running on NetApp 720's and we've had no problems with 7.2.2, 7.3.4 and 8.0.5 databases. I know of no reason to suspect any difference with 8.1.x databases. Our servers are Solaris 2.7 and we operate in an environment that is about 70% transaction processing 30% decision support. We currently operate with 3 100BaseT connections on each server and NetApp, 1 for general LAN access and two dedicated just to the NFS mounts from server to NetApp. We saw good speed improvements over f/w scsi drives directly attached. The WAFL file layout gives nice write performance. We use the NetApps in a very vanilla configuration and only for Oracle datafiles. We don't use their backups, quotas, etc. We love the snapshots -- it's like having a 20 way mirroring system that can be broken at any point. The snaprestore would be cool for rapid testing of different configurations, but another part of the budget got that cash. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[3]: Interesting News..
Besides, some of us read this list just for the drama... wink! -rje E ...Anyone feel free to call me an idiot (HELP), that I'm wrong, or E whatever, but absent the technical merits of a pro-Compaq position E having been presented in detail, all I hear is someone acting like a E pissy little fascist. E ...Of course the good news is that I can now go around telling people E that if they want good services, they should buy IBM since there are E so many a$$holes in the Compaq world. While I can appreciate that your opinion of the Compaq Services division might be less than positive, would you please, for the sake of those who actually work for these companies, be a little less dramatic in your expression of that opinion. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: Yahoo!
Ron, Wednesday, June 20, 2001, 8:11:28 AM, you wrote: R I have often wondered about the pronunciation of the word Yahoo . R Is the a long or short?? Yahoo stands for You Always Have Other R Options (before replying, note that my name is not Merriam Webster and interpret what I write accordingly) Here's how I hear it used: yahoo (yah'-who) - interjection, an exclamation of wild exuberance yahoo (yay'-who) - noun, a person of cloddish and ungenteel behavior, a dolt, a yokel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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[2]: Q: Oracle Year End???
Our Oracle sales rep was hinting the other day that if we wanted to add some power units that deals might be available. -bry T Yes, May 31 is Oracle's fiscal year end. I wouldn't know about the other item. [EMAIL PROTECTED] 04/26/01 11:41AM T I have heard, but have not been able to confirm that May is Oracle's T fiscal year-end. Does anyone have any information regarding this? T I have also heard that May, being Oracles' year-end is the best month to T buy. Has anyone had experience with this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself 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).
