RE: Waits on latch free for shared_pool library Cache
Bull's eye . Will Check out the Steve Adams' Book revert Thanks -Original Message- From: yong huang [SMTP:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 10:30 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Waits on latch free for shared_pool library Cache Hi, Vivek, I can't answer your question. But I know where you get the understanding of freeabl and perm chunks of shared pool memory (Richard Niemiec, "Oracle Performance Tuning", p.615). I don't comment on the overall quality of the book here but I seriously doubt his explanation of "perm". Steve Adams's note says "perm: Permanent memory chunks contain persistent objects..." (Steve Adams' book, p.94) Yong Huang [EMAIL PROTECTED] you wrote: - Waits on Latch Free for shared_pool , Library Cache Phenominally High Qs. What may be Done for the Same ? [snipped] freeabl - most probably stands for the memory that has been used but is freeable perm - most probably stands for the free memory not yet moved to free area for use __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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: ***Problem***
select empid, empname, dept from employees where rownum = 3546; When you are looking for scott.. That is pretty unreliable, and I think that is what Bunyamin(?) was getting at.. Regards Mark -Original Message- Sent: Sunday, February 04, 2001 02:40 To: Multiple recipients of list ORACLE-L I agree with your solution. But why, using a ronum on a single select statement may not be reliable ? Mark Leith wrote: In this case, the rownum should not be a problem when using it in a sub select? You are only trying to get the first seven rows from the sub select.. Whats the problem? Fair enough, using a rownum on a single select may not be reliable, but in this case it should work like a charm.. -Original Message- K.Karadeniz Sent: Thursday, February 01, 2001 12:31 To: Multiple recipients of list ORACLE-L No, No not for this statement , my group leader tells that rownum is not used so much in applications becouse it can give wrong results sometimes. I do not know if it is correct . I ask you for approve him or not.. Thanks - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 1:25 PM paresh mehta, what was wrong with the sql-statement using rownum It works perfeclty, or am I wrong ?? regards Frank Foelz _ Scheidt Bachmann GmbH Gestaltung Parkhaussysteme Breite Strasse 132 41238 Moenchengladbach Phone : ++49 2166 / 266 - 837 Fax: ++49 2166 / 266 - 615 e-mail : mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] URL: http://www.scheidt-bachmann.de http://www.scheidt-bachmann.de/ -Ursprngliche Nachricht- Von: Local Folders [mailto:[EMAIL PROTECTED]] Gesendet am: Donnerstag, 1. Februar 2001 08:35 An: Multiple recipients of list ORACLE-L Betreff: ***Problem*** Consider the following case. TABLE : DEPT empid number, deptid number, deptnamevarchar2(30) primary key (empid, deptid) now i want to fetch first seven records from a cursor whose deptid is maximum and empid is minimum. kindly let me know how to write this cursor statement.for example. SQL select deptid, empid from dept; DEPTID EMPID - - 2 94204 2 94205 2 94206 2 94207 2 94208 5 94209 5 94210 5 94211 5 94212 5 94213 7 94214 7 94215 7 94216 7 94217 7 94218 15 rows selected. i want output as following by single query. DEPTID EMPID - - 7 94214 7 94215 7 94216 7 94217 7 94218 5 94209 5 94210 7 rows selected kindly reply.. thanks in advance. regards paresh mehta -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Foelz.Frank 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K.Karadeniz 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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
Need help - Database link - Please!!
I have a public database link defined with userid-1. Userid-1 has update permissions on table-a in database-b. Userid-2 has no permissions on table-a in database-b. Userid-2, in database-a, calls a package that contains the database link and tries to update table-a in database-b. The result is an Oracle error that states insufficient privileges on table-a. Can anyone help? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Thunderstone.com: Texis
Title: OT:Thunderstone.com: Texis Yes I have somewhat, context searches are fast. You need to keep three copies of the data and indexes (things get corrupted easily). If you do alot of updates, you will have the rebuild the tables and/or redo the indexes all of the time. But it is cheap, fast and pretty easy but can be high maintenance. Kathy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: Monday, February 05, 2001 5:35 AMTo: Multiple recipients of list ORACLE-LSubject: OT:Thunderstone.com: Texis Good morning all - Anyone using this product? If so please email me directly. (Yes, I am still employed and $50 poorer. It's only money...) Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."
Re:Oracle Vs Tera Data
Surjit, I think your "hardcore Tera Data" fans are also bigots. I've a friend at Fidelity Investments where they swear by SUN Oracle. The last time I talked to him their datawarehouse was fast approaching 2PB without any problems. They use all of 8i's datawarehousing stuff like partitioning, hash star joins, etc... and haven't had a single problem. Now if an investment banker can be happy, why can't your bigots??? There are two basic problems with data warehouses that I've seen it should be noted that I'm in the middle of specing a re-wtite of ours. 1) people create then in a normalized manner, not in the idea of a series of stars. COnsequently you end up with too much data in a single table making that table a real bear to manage. 2) end users have this ungodly desire for speed. My GOD, if your searching through 2 or 3 billion rows of data of course it's going to take a while. Dick Goulet Reply Separator Author: "Surjit Sharma" [EMAIL PROTECTED] Date: 2/4/2001 4:15 PM All I wonder if anyone out there has faced the same dilemma as I am facing currently. Our database is likely to grow to a couple of Tera bytes. The existing hardware is Sun E6500 (8 Gig RAM and 10 CPUs) running SunOs 2.6 and Oracle 8.1.5. There is suspicion amongst certain hard core Tera Data fans that Oracle can't do the following: Start schema in Oracle is not suitable for datawarehouses. Oracle is not scalable to deal with Tera bytes databases. Oracle partitioning is not good enough to do the job. I feel that Oracle has been working fine on a Sun box with about 200-300 Gig of data. What is the price/performance of say a Sun Box vs Tera Data. I am sure there is a huge difference. I appreciate your valuable thoughts. Regards Surjit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Surjit Sharma 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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:Oracle Vs Tera Data
On Mon, 5 Feb 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon: -There are two basic problems with data warehouses that I've seen it should -be noted that I'm in the middle of specing a re-wtite of ours. 1) people create -then in a normalized manner, not in the idea of a series of stars. COnsequently -you end up with too much data in a single table making that table a real bear to -manage. 2) end users have this ungodly desire for speed. My GOD, if your -searching through 2 or 3 billion rows of data of course it's going to take a -while. i'm currently fighting with damagement over the same issues. "no datawrehousing is not the same as creating a production database." "no i can't get the warehouse to run as fast as the production database and do it right." repeat the above two statments several times a day.;-) -- Bill Thater Certified ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~ "We are different, in essence from other men. If you want to will something run 100m. If you want to experience something run a marathon" Emil Zatopek ~ How do I love thee? My accumulator overflows. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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: Need help - Database link - Please!!
I'm sorry. The error is not that the user cannot use the database link. The error is that Oracle does not want the user to update table-a in database-b even though the user has update permissions. Ron -Original Message- Sent: Monday, February 05, 2001 8:30 AM To: Multiple recipients of list ORACLE-L You should set up synonyms which define the tables@public_dblink in database b. Put these synonyms in database a. Then anyone can use the linked tables from the package in database a. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, February 05, 2001 8:35 AM I have a public database link defined with userid-1. Userid-1 has update permissions on table-a in database-b. Userid-2 has no permissions on table-a in database-b. Userid-2, in database-a, calls a package that contains the database link and tries to update table-a in database-b. The result is an Oracle error that states insufficient privileges on table-a. Can anyone help? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Index Usage Monitoring
Hi, Why not to use otrace? Of cource, you may need some space to save trace results, but you'll definitely get complete statistics. Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, January 30, 2001 3:57 PM To: Multiple recipients of list ORACLE-L We have a purchased application with over 1,300 indexes. Can someone suggest a method to monitor the system to determine which indexes are actively being used over time? I'm assuming that some are old/not necessary and would like to save the overhead of maintaining them. Oracle 8.0.6 Patrick Prince email: [EMAIL PROTECTED] Omaha Public Power District voice: (402) 636-3762 444 S 16th St. Mall, Omaha, NE 68102fax: (402) 636-3931 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PRINCE, PATRICK W. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov 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).
User objects in System tablespace
Hi, I have a situation where in all the user related objects (tables) have been created in System tablespace. I believe there is no convention followed while creating these tables. Now, how do I separate these user related objects and put them in Users tablespace? Vinay
Pinning Tables
Hi all, I have been trying to find some reference on pinning tables in the SGA. I haven't found anything, all that I am finding is table caching and the keep buffer pool. Is this all that there is, can I "pin" a table in the memory? Thanks in advance. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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-07445
Did you try re-running catalog and catproc and then recompiling invalid objects? We were getting ora-7445 errors on one of our databases last week, and this fixed it. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ora-07445 Date: Mon, 05 Feb 2001 06:55:26 -0800 I posted a question to the list last week regarding this error and didn't get any responses. I'm trying again. We're on Oracle 8.0.5.2.1, and Solaris 6. A few days ago we started receiving ora-07445 errors in the alert log. This happened when had to reboot the server. If we shutdown/restart the database the errors went away. Starting Friday the errors are happening when shutting down/starting up the db. We shutdown the db at midnight and start it at 2:15 am every day. We get lots of core dumps and trace files filling up the file system. We clean up the files and start the db, after that we don't receive the errors anymore until next stop/start the db. I have submitted a tar to Oracle support, but so far they haven't come up with a solution or a cause for this. We made the changes they suggested but it didn't help. Sun suggested some changes to the hardware, but it hasn't help either. Can anyone out there provide some insights on this? Here is one of our trace files: Dump file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_4674.trc Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production ORACLE_HOME = /oracle02/app/oracle/product/8.0.5 System name:SunOS Node name: auoracle1 Release:5.6 Version:Generic_105181-23 Machine:sun4u Instance name: ORTE Redo thread mounted by this instance: 1 Oracle process number: 35 Unix process pid: 4674, image: oracleORTE Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x626c6568, PC: lxdgetobj()+60 *** 2001.02.05.09.20.39.000 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV] [Address not mapped to object] [1651271016] [] [] - Call Stack Trace - calling call entryargument values in hex location type point(? means dubious value) Thanks Ana E. Choto American University Washington, DC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough 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).
OEM/IA and DB shutdown
So, there I am, with an HP/UX server hosting 3 production Oracle DBs. The node is also running Oracle Intelligent Agent, and I have OEM events to e-mail/page me if there's problems with productions DBs and servers. Anyone else running something similar? How do you shutdown a single production DB without causing OEM to freak? If I kill IA, OEM freaks, and sends e-mail and pages about all the DBs and node being unavailable. If I SHUTDOWN NORMAL the production DB, like a good DBA, I need to manually kill the DBSNMP processes that are still connected. If I SHUTDOWN IMMEDIATE, then STARTUP RESTRICT (in order to SHUTDOWN NORMAL), can the DBSNMP process still connect? I have been doing the SHUTDOWN NORMAL and killing the DBSNMP processes, but that somehow just seems hokey to me. Anyone? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA --- This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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 RE: Async I/O on Windows
Title: RE: Async I/O on Windows WHOOO a SQLServer vs. Oracle debate again!! Come on guys in the field, lets hear you comments from all those using both in the field. I personally have been trained in administration on both, and - like you Ross - have to agree that Oracle is my personal favourite, though SQLServer DOES perform better on my machine here... In terms of admin costs etc. SQLServer does kick ass, and still has all those pointy clicky admin wizards - That Oracle is apparently getting with 9i - and have attempted quite poorly with OEM. Bet the guy in the Nova will NEVER beat me in my H reg Cavalier with FLUFFY DICE IN THE WINDOW!!! When they swing they add to my forward momentum!! Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: Monday, February 05, 2001 03:56To: Multiple recipients of list ORACLE-LSubject: OT RE: Async I/O on Windows "NT still pants"...LOL!!! It must be panting alot, It has BLOWN THE DOORS OFF of "Oracle on Unix" in running SQLServer on NT, as has DB2. The general public ( and anyone else ) can wake up and smell the coffee at www.tpc.org. Check out the Top Ten TPC-C marks, by pure performance. Not interested in pure peformance? Check out the Price/Performance leaders. Oracle doesn't even SHOW UP in the top ten. What a shocker, eh? It's painful to lose our illusions Oh, what's that? You don't like TPC-C? It's outmoded or somesuch? Fine, check out ANY of the TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't even show up. I mean, I like Oracle, too, butby the time you turn on the multimode airconditioner, use the 12-way adjustable power bucket seats, activate the object-oriented OnStar Satellite navigational system, power up the heated side view mirrors and all the other tools, trinkets, and toys that make it my personal favorite database, there *is* the chance that the twenty year old genius mechanic in the the tricked out Nova next to you at the light is going to kick your ass when the light turns green. But really, I still love Oracle. Warts and all. Wanna drag? (heh heh heh)
OT RE: Async I/O on Windows
Title: RE: Async I/O on Windows "NT still pants"...LOL!!! It must be panting alot, It has BLOWN THE DOORS OFF of "Oracle on Unix" in running SQLServer on NT, as has DB2. The general public ( and anyone else ) can wake up and smell the coffee at www.tpc.org. Check out the Top Ten TPC-C marks, by pure performance. Not interested in pure peformance? Check out the Price/Performance leaders. Oracle doesn't even SHOW UP in the top ten. What a shocker, eh? It's painful to lose our illusions Oh, what's that? You don't like TPC-C? It's outmoded or somesuch? Fine, check out ANY of the TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't even show up. I mean, I like Oracle, too, butby the time you turn on the multimode airconditioner, use the 12-way adjustable power bucket seats, activate the object-oriented OnStar Satellite navigational system, power up the heated side view mirrors and all the other tools, trinkets, and toys that make it my personal favorite database, there *is* the chance that the twenty year old genius mechanic in the the tricked out Nova next to you at the light is going to kick your ass when the light turns green. But really, I still love Oracle. Warts and all. Wanna drag? (heh heh heh) -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED]]Sent: Saturday, February 03, 2001 6:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Async I/O on Windows I have actually been doing a fair it of reading on this since the topic was brought up, and stand corrected, as earlier mentioned. But I have to say guys that NT is still fairly "pants" when it comes to handling multi threaded processes.. Win2K is a great improvement but M$ still has a lot of work to do on in my view. (only when you compare this against UNIX) Now don't get me wrong, there is enough traffic on this list about this at the moment, so I dont want more bandwith added with this thread if at all possible :) Thanks for the reply anyway Yong, I think I will wait for a "good" book on Win2k to come out (unless you know one?) before I go out and buy one (books come out of my pocket as I ama sales person mostly).. NT as far as I am concerned is now in Win2K's shadow, and I think that is the way of the future for Windowze bound people. For all out there that have used NT and not Win2K - TRY IT.. Services are handled a LOT better, file management and sharing.. All sorts of new fun stuff to sink your teeth in to.. As a side note, for the last line of my first paragraph - I also feel that UNIX cannot be compared in anyway toWindows at this time. Windowze O/S's are designed for pointy clicky people that prefer to look at a nice GUI interface, and generally don't have the indepth technical knowledge that a good UNIX sys admin does.. (If there any NT admins out there don't flame me, I have to deal with it every day of my life...) Regards Mark The views expressed here are soley those coming out of my coffee deprived hungover mind.. They do not express those of my employers, though I'm sure they agree :^) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: Friday, February 02, 2001 07:00To: Multiple recipients of list ORACLE-LSubject: RE: Async I/O on Windows Oracle on NT runs as ONE PROCESS with MULTIPLE THREADS for performance reasons (no more need for shared memorycontext switches are a LOT less expensive, etc.) -Original Message- From: yong huang [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Subject: Async I/O on Windows Hi, Mark, Async I/O is available on Windows, at least NT. It's not an easy topic. If you think you already know enough about operating systems in general, I suggest you read David Solomon's "Inside WindowsNT". For a lab test, launch Performance Monitor on your NT box and look at the counters for Cache. I'm not sure by "single thread management" whether you mean NT can't have multiple processes or Oracle on NT runs as one thread. The former is obviously wrong. The latter is a design issue inside Oracle Corporation and the question as to why was asked on this forum before without an answer (without an answer I can remember, that is). Yong Huang [EMAIL PROTECTED] you wrote: Asynch I/O on a Windowze box? supresses a snigger... To the best of my knowledge there are no Windows based system that can take advantage of this, single thread management can be enough a problem sometimes.. But, I may be wrong.. List? __ Get personalized email addresses from Yahoo! Mail -
RE: ora-07445
Here is what I get in the alert log: Errors in file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_15115.trc: ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV] [Address not mapped to object] [1651271016] [] [] Mon Feb 5 12:55:20 2001 Errors in file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_15641.trc: ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV] [Address not mapped to object] [1651271016] [] [] Mon Feb 5 12:57:44 2001 Errors in file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_16105.trc: ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV] [Address not mapped to object] [1651271016] [] [] Thanks Ana "Mohan, Ross" MohanR@STARSTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] -SMI.comcc: Sent by: Subject: RE: ora-07445 root@fatcity. com 02/05/01 11:55 AM Please respond to ORACLE-L you show a file from your udump. what is in your bdump? including your alert log. -Original Message- Sent: Monday, February 05, 2001 9:55 AM To: Multiple recipients of list ORACLE-L I posted a question to the list last week regarding this error and didn't get any responses. I'm trying again. We're on Oracle 8.0.5.2.1, and Solaris 6. A few days ago we started receiving ora-07445 errors in the alert log. This happened when had to reboot the server. If we shutdown/restart the database the errors went away. Starting Friday the errors are happening when shutting down/starting up the db. We shutdown the db at midnight and start it at 2:15 am every day. We get lots of core dumps and trace files filling up the file system. We clean up the files and start the db, after that we don't receive the errors anymore until next stop/start the db. I have submitted a tar to Oracle support, but so far they haven't come up with a solution or a cause for this. We made the changes they suggested but it didn't help. Sun suggested some changes to the hardware, but it hasn't help either. Can anyone out there provide some insights on this? Here is one of our trace files: Dump file /oracle02/app/oracle/admin/ORTE/udump/orte_ora_4674.trc Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production ORACLE_HOME = /oracle02/app/oracle/product/8.0.5 System name:SunOS Node name: auoracle1 Release:5.6 Version:Generic_105181-23 Machine:sun4u Instance name: ORTE Redo thread mounted by this instance: 1 Oracle process number: 35 Unix process pid: 4674, image: oracleORTE Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x626c6568, PC: lxdgetobj()+60 *** 2001.02.05.09.20.39.000 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [lxdgetobj()+60] [SIGSEGV] [Address not mapped to object] [1651271016] [] [] - Call Stack Trace - calling call entryargument values in hex location type point(? means dubious value) Thanks Ana E. Choto American University Washington, DC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
RE: Thanks and another book request
Yeah, but Rachel, think of the FAME! Didn't I hear you were opening for Billy Joel and Elton John in LA on Feb 6? :-) Yosi -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 04, 2001 1:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: Thanks and another book request Djordje, the $5 was for each book sold. not per hour. My rate (before the book) was more than the average. The $150/hour is really an average, I know people getting more than that and they haven't written a book, or done lots of presentations etc. NY is a higher paying market. And in any case, even at $10/hour, it's still NOT worth spending the time writing instead of consulting. And the real question is, since I write in my limited, minimal spare time, what is the value per hour of THAT time? Time not spent with family and friends, or doing the things that feed my soul? Rachel From: "djordjej" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Thanks and another book request Date: Sat, 03 Feb 2001 23:45:21 -0800 Hi Rachel, I definitively believe that the prime drive for writing a book must come from the love to teach, to help other people and share some of the experience and knowledge that you came to the hard way with others. And I agree that one should not think of writing a book to make money. But for the math you did to be fair, I guess it should be mentioned that having a name on a good book also helps to reach $150 per hour. I would not say that this is an average that a senior/experienced/expert/knowledgeable/... DBA gets even in NY ? If the name on the book can bring this number up by at least, say $10/hour, this changes your math by at least $1600*10 = $16,000. Am I right in this assumption? Djordje - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 02, 2001 8:05 PM well, let's do the math. let's say I get $5 for each book that is sold (I don't, and the royalties change depending on if the book has sold at full price or from a discount house) but the $5 makes the math easier (and it's less than minimum wage in the US!) let's round the numbers, and say that an independent DBA consultant can earn $150/hr in New York, where I live. (That's an average, some make more, some less) and 150/5 = 30 so I'd have to work 30 times as many hours writing books as I would as a consultant to make the same amount of money Most personnel departments assume that there are 200 workdays in a year (vacation, weekends and holidays excluded), and that a workday is 8 hours long. Yes, I know no DBA works a 40 hour week, this is just an example. so 200*8 = 1600 hours work in a year. 1600/500= 3.2 books a year and 1600*5=$8000 a year 1600*150=$240,000 don't know about you, I'd rather be a consultant! I repeat -- you don't make money writing books, and if that is why you are writing them, you'd be better off just consulting. Even if you write in your "spare time", you lose -- I worked evenings, and all day all weekend writing. I didn't see my friends or family for the time I was writing. Oh, and since my name does show up when my messages post, so it's easy to see how it is spelled it's Rachel, not Rachael From: "orclbabu" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Thanks and another book request Date: Fri, 02 Feb 2001 12:32:11 -0800 Rachael consultant for that number of hours Not profitable to write one. The very fact that you often repeat this in response to mails that refer to your books, makes us think otherwise $$$ ;-) babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orclbabu 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael
Re: OEM/IA and DB shutdown
I run about 20+ databases from one OEM session, albeit on NT, and I never shutdown the agent when I shutdown a database. You must have OEM sending email for all events. Just use email for selected events that you want to know about. OEM won't freak if you don't shutdown the repository database. If you do it will stop working at all. I use a small database on one of my servers to hold the repository and the recovery catalog. Then no matter what I do with the other databases OEM doesn't care. I don't know if this answers all of your questions but I hope it helps, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, February 05, 2001 10:50 AM So, there I am, with an HP/UX server hosting 3 production Oracle DBs. The node is also running Oracle Intelligent Agent, and I have OEM events to e-mail/page me if there's problems with productions DBs and servers. Anyone else running something similar? How do you shutdown a single production DB without causing OEM to freak? If I kill IA, OEM freaks, and sends e-mail and pages about all the DBs and node being unavailable. If I SHUTDOWN NORMAL the production DB, like a good DBA, I need to manually kill the DBSNMP processes that are still connected. If I SHUTDOWN IMMEDIATE, then STARTUP RESTRICT (in order to SHUTDOWN NORMAL), can the DBSNMP process still connect? I have been doing the SHUTDOWN NORMAL and killing the DBSNMP processes, but that somehow just seems hokey to me. Anyone? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA --- This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: Sar Loader Script?
My problem is that the timestamp, which is just that--no date, is only on the first record of each sample rather than every record and I don't want the blank lines in between the samples. Perhaps this is a simple awk routine but I don't know awk well enough to do this. awk '{ if (NF7) {time=$1;print $0} else print time,$0}' This is off the top of my head. I'm sure there is a more elegant method. This will add the time field to each record. I didn't take it any further. The next problem is quoting the correct fields. (You can hard code it) I just didn't feel like it. 8) (I would've used perl/DBD w/ bind variables.) HTH Shawn M Ferris Oracle DBA - Time Warner Telecom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferris, Shawn 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).
Group/Sort by date field
Hi I am wondering about some results I am getting back when I am querying based on date fields. I have a large table partitioned on source year. When I run the following query the results are not correct results, it seems to be grouping the year incorrectly. select to_char(landed_dt,''), count(distinct vessel_code),sum(landed_value) from landing_hist where to_char(landed_dt, '') in ('1994','1995','1996') and source_year in ('1994','1995','1996') group by to_char(landed_dt, '') order by to_char(landed_dt, '') When I run the query for individual years the data returned is correct and when I rewrite the query so that it is not being grouped by to_char(landed_dt,'') (see below) the results are correct. select source_year, count(distinct vessel_code), sum(landed_value) from landing_hist where to_char(landed_dt, '') in ('1994','1995','1996') and source_year in ('1994','1995','1996') group by source_year order by source_year Can anyone help me out with what I am missing - it seems like it has to be something obvious - but I don't know what. Thanks Jane -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 RE: Async I/O on Windows
Title: RE: Async I/O on Windows LOL!!! Amen! -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 12:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Async I/O on Windows WHOOO a SQLServer vs. Oracle debate again!! Come on guys in the field, lets hear you comments from all those using both in the field. I personally have been trained in administration on both, and - like you Ross - have to agree that Oracle is my personal favourite, though SQLServer DOES perform better on my machine here... In terms of admin costs etc. SQLServer does kick ass, and still has all those pointy clicky admin wizards - That Oracle is apparently getting with 9i - and have attempted quite poorly with OEM. Bet the guy in the Nova will NEVER beat me in my H reg Cavalier with FLUFFY DICE IN THE WINDOW!!! When they swing they add to my forward momentum!! Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: Monday, February 05, 2001 03:56To: Multiple recipients of list ORACLE-LSubject: OT RE: Async I/O on Windows "NT still pants"...LOL!!! It must be panting alot, It has BLOWN THE DOORS OFF of "Oracle on Unix" in running SQLServer on NT, as has DB2. The general public ( and anyone else ) can wake up and smell the coffee at www.tpc.org. Check out the Top Ten TPC-C marks, by pure performance. Not interested in pure peformance? Check out the Price/Performance leaders. Oracle doesn't even SHOW UP in the top ten. What a shocker, eh? It's painful to lose our illusions Oh, what's that? You don't like TPC-C? It's outmoded or somesuch? Fine, check out ANY of the TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't even show up. I mean, I like Oracle, too, butby the time you turn on the multimode airconditioner, use the 12-way adjustable power bucket seats, activate the object-oriented OnStar Satellite navigational system, power up the heated side view mirrors and all the other tools, trinkets, and toys that make it my personal favorite database, there *is* the chance that the twenty year old genius mechanic in the the tricked out Nova next to you at the light is going to kick your ass when the light turns green. But really, I still love Oracle. Warts and all. Wanna drag? (heh heh heh)
RE: Oracle Vs Tera Data
Title: RE: Oracle Vs Tera Data Surjit, In my experience, Sun storage ( the A5000 stuff, etc. ) does not do the best possible job. But, then again, you may be on Fujitsu, EMC, or some other good storage vendor. (Dick, liked your comments about normalization and adjustment expectations...) hth Ross -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 9:41 AM To: Multiple recipients of list ORACLE-L Subject: Re:Oracle Vs Tera Data Surjit, I think your hardcore Tera Data fans are also bigots. I've a friend at Fidelity Investments where they swear by SUN Oracle. The last time I talked to him their datawarehouse was fast approaching 2PB without any problems. They use all of 8i's datawarehousing stuff like partitioning, hash star joins, etc... and haven't had a single problem. Now if an investment banker can be happy, why can't your bigots??? There are two basic problems with data warehouses that I've seen it should be noted that I'm in the middle of specing a re-wtite of ours. 1) people create then in a normalized manner, not in the idea of a series of stars. COnsequently you end up with too much data in a single table making that table a real bear to manage. 2) end users have this ungodly desire for speed. My GOD, if your searching through 2 or 3 billion rows of data of course it's going to take a while. Dick Goulet Reply Separator Author: Surjit Sharma [EMAIL PROTECTED] Date: 2/4/2001 4:15 PM All I wonder if anyone out there has faced the same dilemma as I am facing currently. Our database is likely to grow to a couple of Tera bytes. The existing hardware is Sun E6500 (8 Gig RAM and 10 CPUs) running SunOs 2.6 and Oracle 8.1.5. There is suspicion amongst certain hard core Tera Data fans that Oracle can't do the following: Start schema in Oracle is not suitable for datawarehouses. Oracle is not scalable to deal with Tera bytes databases. Oracle partitioning is not good enough to do the job. I feel that Oracle has been working fine on a Sun box with about 200-300 Gig of data. What is the price/performance of say a Sun Box vs Tera Data. I am sure there is a huge difference. I appreciate your valuable thoughts. Regards Surjit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Surjit Sharma 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Pondering Question of the Day-RESPECT
I have taken the stance with one junior that he now has to prove me wrong in anything I tell him. Loser buys the beer. He owes me quite a bit right now:-) -Original Message- Sent: Friday, February 02, 2001 9:16 AM To: Multiple recipients of list ORACLE-L Kimberly, I could say the same thing of course, the other part is that I convinced the programmers here that I knew what I was doing by letting them have their way in development and watching it die... then converting it to what I wanted to do and watching it fly. Now they ask my opinion before they do anything. Rachel From: Kimberly Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Pondering Question of the Day-RESPECT Date: Fri, 02 Feb 2001 08:11:03 -0800 I have had that same issue in the past but I don't have it here. I find that as long as you have your managements support and the development team knows that then life will be much easier. I am very lucky here in that I have good management and a very well trained senior development team to work with. Not that there are never disagreements but comprise is the name of the game. You just got to be picky on what you let them think you are compromising on:-) I always have more issues with junior/intermediate developers. -Original Message- Sent: Friday, February 02, 2001 7:20 AM To: Multiple recipients of list ORACLE-L "Hello Oracle Guru" Now why is it that I get more respect on the Internet than I do in my workplace. ?? How many of you have this problem? It's like an ongoing fight with developers, they want carte blanche in the production database, and they do whatever they want EVEN THOUGH I tell them NO, let's do something different that won't affect production. I go to the CTO because this is like the 3rd time this has happened, and he sends out a let's-be-sure-not-to-offend-anyone email. But the developer(s) will go ahead and do what they want ANYWAY. I'm waiting for the first user-mistake recovery to say STOP, I've had ENOUGH and this is how it's going to be, no ifs, ands or buts. My last job may have been a sweatshop, but at least people respected my authority. Here, it's a free for all no matter what I do. Even when I say, Dude, I own the database. If there's a problem, I have to fix it. Therefore I say what happens in production and what doesn' t happen in production. And yes, I am looking for another position. I can only take this dba/developer/janitor role for so long. I'M SO GLAD IT'S FRIDAY... Bring on the Captain Morgan! It's noon somewhere... Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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).
Sar Loader Script?
By chance, does anyone have a script that will reparse a collection of sar statistics, that came from "sar -d", into a file that can be used by SQL*Loader?My problem is that the timestamp, which is just that--no date, is only on the first record of each sample rather than every record and I don't want the blank lines in between the samples. Perhaps this is a simple awk routine but I don't know awk well enough to do this. Any assistance is appreciated!-wHere is a sample of the data I am trying to work with:SunOS pandora 5.6 Generic_115161-23 sun4u 01/30/01 08:00:00 device %busy avque r+w/s blks/s avwait avserv 08:01:00 nfs1 0 0.0 0 0 0.0 0.0 sd5 4 0.0 7 132 0.0 6.5 sd5,c 0 0.0 0 0 0.0 0.0 sd5,d 0 0.0 0 0 0.0 0.0 sd5,e 4 0.0 6 132 0.0 7.2 sd22 1 0.1 1 21 0.0 81.3 sd22,a 0 0.0 0 0 0.0 0.0 sd22,b 0 0.0 0 0 0.0 0.0 sd22,c 0 0.0 0 0 0.0 0.0sd22,d 0 0.0 0 0 0.0 0.0 sd22,e 0 0.0 0 0 0.0 0.0 sd22,g 1 0.1 1 21 0.0 81.3 sd22,h 0 0.0 0 0 0.0 0.0 sd23 2 0.0 3 101 0.0 7.1 sd23,c 0 0.0 0 0 0.0 0.0 sd23,d 0 0.0 0 0 0.0 0.0 sd23,e 2 0.0 3 101 0.0 7.1 sd34 0 0.0 0 0 0.0 0.0 sd45 1 0.1 1 21 0.0 96.4 sd45,a 0 0.0 0 0 0.0 0.0 sd45,b 0 0.0 0 0 0.0 0.0 sd45,c 0 0.0 0 0 0.0 0.0 sd45,d 0 0.0 0 0 0.0 0.0 sd45,e 1 0.1 1 21 0.0 96.4 sd45,g 0 0.0 0 0 0.0 0.0 sd45,h 0 0.0 0 0 0.0 0.0 sd46 0 0.0 0 0 0.0 0.0 sd46,c 0 0.0 0 0 0.0 0.0 sd46,d 0 0.0 0 0 0.0 0.0 sd46,e 0 0.0 0 0 0.0 0.0 sd66 0 0.0 0 0 0.0 0.0 sd125 0 0.0 0 0 0.0 0.0 sd126 0 0.0 0 0 0.0 0.0 sd127 0 0.0 0 0 0.0 0.0 sd127,a 0 0.0 0 0 0.0 0.0 sd127,b 0 0.0 0 0 0.0 0.0 sd127,c 0 0.0 0 0 0.0 0.0 sd127,d 0 0.0 0 0 0.0 0.0 sd127,e 0 0.0 0 0 0.0 0.0 sd127,g 0 0.0 0 0 0.0 0.0 sd328 2 0.0 4 70 0.0 4.9sd328,c 0 0.0 0 0 0.0 0.0 sd328,d 0 0.0 0 0 0.0 0.0 sd328,e 2 0.0 4 70 0.0 4.9 sd329 0 0.0 0 0 0.0 0.0 sd329,c 0 0.0 0 0 0.0 0.0 sd329,d 0 0.0 0 0 0.0 0.0 sd329,e 0 0.0 0 0 0.0 0.0 sd330 0 0.0 0 0 0.0 0.0 st32 0 0.0 0 0 0.0 0.0 st33 0 0.0 0 0 0.0 0.0 08:02:00 nfs1 0 0.0 0 0 0.0 0.0 sd5 2 0.0 3 82 0.0 7.4 sd5,c 0 0.0 0 0 0.0 0.0 sd5,d 0 0.0 0 0 0.0 0.0 sd5,e 2 0.0 3 82 0.0 9.1 sd22 1 0.0 1 11 0.0 53.6 sd22,a 0 0.0 0 0 0.0 0.0 sd22,b 0 0.0 0 0 0.0 0.0 sd22,c 0 0.0 0 0 0.0 0.0 sd22,d 0 0.0 0 0 0.0 0.0 sd22,e 0 0.0 0 0 0.0 0.0 sd22,g 1 0.0 1 11 0.0 53.6 sd22,h 0 0.0 0 0 0.0 0.0 sd23 1 0.0 1 49 0.0 12.7 sd23,c 0 0.0 0 0 0.0 0.0 sd23,d 0 0.0 0 0 0.0 0.0 sd23,e 1 0.0 1 49 0.0 12.7 sd34 0 0.0 0 0 0.0 0.0sd45 1 0.0 1 11 0.0 63.4 sd45,a 0 0.0 0 0 0.0 0.0 sd45,b 0 0.0 0 0 0.0 0.0 sd45,c 0 0.0 0 0 0.0 0.0 sd45,d 0 0.0 0 0 0.0 0.0 sd45,e 1 0.0 1 11 0.0 63.4 sd45,g 0 0.0 0 0 0.0 0.0 sd45,h 0 0.0 0 0 0.0 0.0 sd46 0 0.0 0 0 0.0 0.0 sd46,c 0 0.0 0 0 0.0 0.0 sd46,d 0 0.0 0 0 0.0 0.0 sd46,e 0 0.0 0 0 0.0 0.0 sd66 0 0.0 0 0 0.0 0.0 sd125 0 0.0 0 0 0.0 0.0 sd126 0 0.0 0 0 0.0 0.0 sd127 0 0.0 0 0 0.0 0.0 sd127,a 0 0.0 0 0 0.0 0.0 sd127,b 0 0.0 0 0 0.0 0.0 sd127,c 0 0.0 0 0 0.0 0.0 sd127,d 0 0.0 0 0 0.0 0.0 sd127,e 0 0.0 0 0 0.0 0.0 sd127,g 0 0.0 0 0 0.0 0.0 sd328 1 0.0 3 37 0.0 3.7 sd328,c 0 0.0 0 0 0.0 0.0 sd328,d 0 0.0 0 0 0.0 0.0 sd328,e 1 0.0 3 37 0.0 3.7 sd329 0 0.0 0 0 0.0 0.0 sd329,c 0 0.0 0 0 0.0 0.0 sd329,d 0 0.0 0 0 0.0 0.0 sd329,e 0 0.0 0 0 0.0 0.0 sd330 0 0.0 0 0 0.0 0.0 st32 0 0.0 0 0 0.0 0.0st33 0 0.0 0 0 0.0 0.0
Linux as a production machine
Hi Dick, A couple of campanies I consult for are using Linux and Oracle (8.0.5, 8.1.6) as production databases. Neither is really high transaction volume but one is holding about 1.5 GB of data. One install occured because Oracle on NT was choking the box and the company did not want to buy new hardware. I find you usually get a 20 -30% performance boost with Oracle on Linux vs NT for the same hardware. The 8.0.5 Linux release has some problems so I would recommend the 8.1.6 release which is of the same quality as all other UNIX Oracle releases (Notice I didn't comment on the quality, just the similarity :) Both machines are in archive log mode and show typical unix uptimes (Months). WARNING: My original kernel is Slackware 1.2.13 (I think) and I have maintained my own kernel and system for the past 5-6 years (Currently 2.2.14). This gives me an extremely reliable (but custom) system. My builds are of better quality than any commercial linux packages I have tested. I would recommend Caldera over Redhat based on my tests and what I have heard from other admins. The feeling seems to be Redhat is going after the consumer market while Caldera is concentrating on the server market. In summary, Linux, once properly configured is quite suitable as a production Oracle platform. HTH Dave -- Dave Morgan Senior Database Administrator Internet Barter Inc. www.bartertrust.com 408-910-4183 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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: Pinning Tables
No, pinning is for the code: sql, procedures/functions/packages and sequences. Take a look of the package dbms_shared_pool. Regards. -Mensaje original- De: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Enviado el: lunes 5 de febrero de 2001 16:36 Para: Multiple recipients of list ORACLE-L Asunto: Pinning Tables Hi all, I have been trying to find some reference on pinning tables in the SGA. I haven't found anything, all that I am finding is table caching and the keep buffer pool. Is this all that there is, can I "pin" a table in the memory? Thanks in advance. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trassens, Christian 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: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows
I am running ORacle8i on Windows2000 and for what I use it for I see no difference from NT. -Original Message- Sent: Monday, February 05, 2001 11:06 AM To: Multiple recipients of list ORACLE-L Ross Mark, There are no major performance concerns here (and we get Oracle "free" {system wide educational site license} - unlike MS/SQL), so what I want to know is: does Oracle8 generally work well on Windows 2000 server (compared to running it on NT4)? We will be running on this hardware: IBM Netfinity5100 w/ RAID (dedicated Oracle server, w/ web server on same box, if possible). My assumption is that Win2k/Oracle8 is "ok". Are there any horror stories out there about running Oracle8 on Win2K where running on NT4 would have been better? thanks! ep On 5 Feb 2001, at 9:25, Mark Leith wrote: Date sent: Mon, 05 Feb 2001 09:25:25 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] RE: Async I/O on WindowsWHOOO a SQLServer vs. Oracle debate again!! ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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: Ascii code of tab?
I believe chr(9). -- Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] -Original Message- From: Viktor [SMTP:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 11:57 AM To: Multiple recipients of list ORACLE-L Subject: Ascii code of tab? What is ascii code of TAB? Thanks __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guidry, Chris 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).
ORA-01187: cannot read from file 1 because it failed verification
Title: RE: Async I/O on Windows Does anyone know what this error means? What caused this error? TIA SVRMGR alter database open; alter database open * ORA-01187: cannot read from file 1 because it failed verification tests ORA-01110: data file 1: '/opt/oracle/oradata/system01.dbf'
RE: Need help - Database link - Please!!
Let me rephrase it. The user defined in the database link has insert permissions on table-a. The user calling the database link does not have any permissions on any table in database-b. Ron -Original Message- Sent: Monday, February 05, 2001 10:11 AM To: Multiple recipients of list ORACLE-L Doesn't your second example say that ' Userid-2 has no permissions on table-a in database-b'? Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, February 05, 2001 10:30 AM I'm sorry. The error is not that the user cannot use the database link. The error is that Oracle does not want the user to update table-a in database-b even though the user has update permissions. Ron -Original Message- Sent: Monday, February 05, 2001 8:30 AM To: Multiple recipients of list ORACLE-L You should set up synonyms which define the tables@public_dblink in database b. Put these synonyms in database a. Then anyone can use the linked tables from the package in database a. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, February 05, 2001 8:35 AM I have a public database link defined with userid-1. Userid-1 has update permissions on table-a in database-b. Userid-2 has no permissions on table-a in database-b. Userid-2, in database-a, calls a package that contains the database link and tries to update table-a in database-b. The result is an Oracle error that states insufficient privileges on table-a. Can anyone help? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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).
Bitmap index
Hi DBAs, Oracle 8.1.6 on Sun; DW environment: Have a table that gets populated by SQL*Loader and thereafter lots of queries go against this table using different combinations of 4 columns (date, varchar2(6), varchar2(5), char(1)). Once a row is processed, the char(1) column gets updated from null to 'Y'. There are no updates to any other columns or no deletes. Roughly 1000 rows gets inserted to this table every day. When I tried 'explain plain' for different queries, I find that a bitmap index on these 4 columns performs much better than a normal index. Before implementing this, would like to get your ideas on this. Appreciate any help! Prakash -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash 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).
Ascii code of tab?
What is ascii code of TAB? Thanks __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor 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: Ascii code of tab?
It is CHR(9): SELECT column_1||chr(9)||column_2 FROM table_name; Best regards, -Ari Kaplan Independent Oracle DBA Consultant Founder/CEO, PocketDBA Systems -- Wireless Database Management Now www.pocketdba.com -- - For 400+ Oracle tips, visit: - -- - www.arikaplan.com - -- - email: [EMAIL PROTECTED] - -- On Mon, 5 Feb 2001, Viktor wrote: What is ascii code of TAB? Thanks __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ari D Kaplan 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 RE: Async I/O on Windows
-Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 9:56 AM To: Multiple recipients of list ORACLE-L Subject: OT RE: Async I/O on Windows SNIP Wanna drag? (heh heh heh) Well, I'd have to shave my legs, but for the right amount of money... I'm game... --Scott "I was meant to be born rich and shameless. One out of two isn't bad..." -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Ascii code of tab?
^I Dec - 9 Oct - 011 Hex - 09 David A. Barbour Oracle DBA - ConnectSouth 512-681-9438 [EMAIL PROTECTED] -Original Message- Sent: Monday, February 05, 2001 12:57 PM To: Multiple recipients of list ORACLE-L What is ascii code of TAB? Thanks __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Barbour 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: Pondering Question of the Day-RESPECT
Rachel: I miss a couple of my old jobs where I has other roles (developer/dba and network admin/helpdesk/etc) where I got quite a few people trained real well :) I could count on a snack from several people a week. Although I guess that could be seen from their side as "We sure got this guy trained better than the last IT guy here!" Stephen [EMAIL PROTECTED] 02/05 11:35 AM hm, I like that. I've been working on training people here on the proper bribes for the DBA, but they are SLOWWW learners. From: Kimberly Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Pondering Question of the Day-RESPECT Date: Mon, 05 Feb 2001 08:55:48 -0800 I have taken the stance with one junior that he now has to prove me wrong in anything I tell him. Loser buys the beer. He owes me quite a bit right now:-) -Original Message- Sent: Friday, February 02, 2001 9:16 AM To: Multiple recipients of list ORACLE-L Kimberly, I could say the same thing of course, the other part is that I convinced the programmers here that I knew what I was doing by letting them have their way in development and watching it die... then converting it to what I wanted to do and watching it fly. Now they ask my opinion before they do anything. Rachel From: Kimberly Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Pondering Question of the Day-RESPECT Date: Fri, 02 Feb 2001 08:11:03 -0800 I have had that same issue in the past but I don't have it here. I find that as long as you have your managements support and the development team knows that then life will be much easier. I am very lucky here in that I have good management and a very well trained senior development team to work with. Not that there are never disagreements but comprise is the name of the game. You just got to be picky on what you let them think you are compromising on:-) I always have more issues with junior/intermediate developers. -Original Message- Sent: Friday, February 02, 2001 7:20 AM To: Multiple recipients of list ORACLE-L "Hello Oracle Guru" Now why is it that I get more respect on the Internet than I do in my workplace. ?? How many of you have this problem? It's like an ongoing fight with developers, they want carte blanche in the production database, and they do whatever they want EVEN THOUGH I tell them NO, let's do something different that won't affect production. I go to the CTO because this is like the 3rd time this has happened, and he sends out a let's-be-sure-not-to-offend-anyone email. But the developer(s) will go ahead and do what they want ANYWAY. I'm waiting for the first user-mistake recovery to say STOP, I've had ENOUGH and this is how it's going to be, no ifs, ands or buts. My last job may have been a sweatshop, but at least people respected my authority. Here, it's a free for all no matter what I do. Even when I say, Dude, I own the database. If there's a problem, I have to fix it. Therefore I say what happens in production and what doesn' t happen in production. And yes, I am looking for another position. I can only take this dba/developer/janitor role for so long. I'M SO GLAD IT'S FRIDAY... Bring on the Captain Morgan! It's noon somewhere... Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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
RE: OT RE: Async I/O on Windows
Title: RE: OT RE: Async I/O on Windows LOL! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 2:11 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT RE: Async I/O on Windows -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 9:56 AM To: Multiple recipients of list ORACLE-L Subject: OT RE: Async I/O on Windows SNIP Wanna drag? (heh heh heh) Well, I'd have to shave my legs, but for the right amount of money... I'm game... --Scott I was meant to be born rich and shameless. One out of two isn't bad... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 RE: Async I/O on Windows
Title: RE: OT RE: Async I/O on Windows TPC doesn't really matter - You are correct: no single metric covers it all. But, Oracle is sure all over the ad pages when it FINALLY manages to get one near the top. Which isn't often. And right now, hands down, SS2K is about FOUR TIMES AS FAST as Oracle. Hang on to yer doors, there's a REAL POWER UNIT coming by! OraMag says - Uh huh. Sure. Right. Fine. Whatever. Industry Sources say... - see above. Quoting independent sources permits verifiability. NT crashes once a week - See the current Aberdeen Report, January 2001 on the reliability of Win2K. After SS2K blows your doors off, this report will blow your mind. (User must open mind first! :-) They note, across a range of NT5 sites, 99.99% uptime. Bet most Unix sites don't match that. Only one Unix site that I've worked on has - hardware, software, something causes problems. The worst offender, by far? Sun. (Think E-bay) But, this is purely anecdotal evidence. Locking Problems...dirty reads - You mean in SS6.5, right? Because they were fixed in SS7.0. The only thing worse than having purely anecdotal information is having OLD anecdotal information. Here's something to bring you closer to up-to-date: http://www.microsoft.com/SQL/productinfo/transadv.htm Well, I gotta go now. I need to continue solving Oracle database problems using my ( spell it with me, folks ) iTAR. LOL! -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 2:42 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT RE: Async I/O on Windows Actually, not that it matters from what I can tell, but Oracle is tops if you consider clustered vs. non-clustered. It seems that Oracle doesn't even have tests for clustered systems. I wonder what happened to the VLDB tests in the huge DEC/Compaq Alpha cluster? As far as SQL (pronounced: SQueaL) Server blown the doors off, there are factors that TPC does not consider. First, is reliability. According to Oracle Magazine, Jan/Feb 2001, p38, ...a 12-computer configuration from Microsoft, such as that used in recent TPC-C benchmarks, is estimated to experience a catastophic failure once every 7.5 days, according to Microsoft's own estimates. Granted, the quote is from Oramag, but I've heard the same from other Industry Sources. I know of a specific implementation where the NT database servers would dog and/or crash when approximately 500 concurrent users were attached (note: attached active) to the database. The decision was made to dump NT for DB serving and go with a major (HP or Sun or IBM) flavor of Unix for it's scalability and reliability. Second, when was the last time you needed a 500K TPC-C from only 48 clients? From a couple thousand, yes, but only 48? And who's gonna buy everyone in their company a $7500 desktop PC with twin PIII-800s in them for clients? While those numbers are specific to the top TPC-C Compaq/MS result, that's how all these companies get their numbers. I'm not betting my job on TPC-C numbers. The numbers just don't reflect real-life situations. And I didn't even touch upon the potential locking problems on SQL Server, or how it can do dirty reads... :) Just my $.02. I need to go create some Oracle databases on HP/UX now. ;) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, February 05, 2001 09:56 To: Multiple recipients of list ORACLE-L NT still pants...LOL!!! It must be panting alot, It has BLOWN THE DOORS OFF of Oracle on Unix in running SQLServer on NT, as has DB2. The general public ( and anyone else ) can wake up and smell the coffee at www.tpc.org http://www.tpc.org . Check out the Top Ten TPC-C marks, by pure performance. Not interested in pure peformance? Check out the Price/Performance leaders. Oracle doesn't even SHOW UP in the top ten. What a shocker, eh? It's painful to lose our illusions Oh, what's that? You don't like TPC-C? It's outmoded or somesuch? Fine, check out ANY of the TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't even show up. I mean, I like Oracle, too, butby the time you turn on the multimode airconditioner, use the 12-way adjustable power bucket seats, activate the object-oriented OnStar Satellite navigational system, power up the heated side view mirrors and all the other tools, trinkets, and toys that make it my personal favorite database, there *is* the chance that the twenty year old genius mechanic in the the tricked out Nova next to you at the light is going to kick your ass when the light turns green. But really, I still love Oracle. Warts and all. Wanna drag? (heh heh heh) -Original Message- Sent: Saturday, February 03, 2001 6:45 AM To: Multiple recipients of list ORACLE-L I have actually been doing a fair it of reading on this since the topic
RE: ORA-01187: cannot read from file 1 because it failed verifica
Title: RE: Async I/O on Windows H - did you mount the database first? David A. Barbour Oracle DBA - ConnectSouth 512-681-9438 [EMAIL PROTECTED] -Original Message-From: Tony Guo [mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 2:12 PMTo: Multiple recipients of list ORACLE-LSubject: ORA-01187: cannot read from file 1 because it failed verification Does anyone know what this error means? What caused this error? TIA SVRMGR alter database open; alter database open * ORA-01187: cannot read from file 1 because it failed verification tests ORA-01110: data file 1: '/opt/oracle/oradata/system01.dbf'
Alter session, NLS parameters
Hello list, Is there a possibility to know a specific session's NLS parameters querying from another session ? Regards, Radu Caulea Senior Oracle Consultant www.caulea.fr.st -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Radu Caulea 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: Pinning Tables
Try: ALTER TABLE tablename CACHE; The table will stay in the buffer cache and not get rolled out. This is basically used for small lookup tables like security tables that are accessed over and over. Ron Smith Database Administration [EMAIL PROTECTED] -Original Message- Sent: Monday, February 05, 2001 12:46 PM To: Multiple recipients of list ORACLE-L No, pinning is for the code: sql, procedures/functions/packages and sequences. Take a look of the package dbms_shared_pool. Regards. -Mensaje original- De: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Enviado el: lunes 5 de febrero de 2001 16:36 Para: Multiple recipients of list ORACLE-L Asunto: Pinning Tables Hi all, I have been trying to find some reference on pinning tables in the SGA. I haven't found anything, all that I am finding is table caching and the keep buffer pool. Is this all that there is, can I "pin" a table in the memory? Thanks in advance. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trassens, Christian 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows
Title: RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows From what I know, Oracle8 is not yet formally certified on Win2K, believe it or not. But, I could be way wrong about this. Anecdotally, I have colleagues running every from clients through Net8 Names Servers to database servers on Win2K. Typical Win2K uptime, about..well, since they plugged it in, several months ago. Punchline: As a migration from NT4, NT5 (i.e. Win2K) is noticeably better in terms of stability and performance. If you asked me to compare Win2K and current version AIX, i'd pick the latter. hth Ross -Original Message- From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 2:06 PM To: Multiple recipients of list ORACLE-L Subject: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows Ross Mark, There are no major performance concerns here (and we get Oracle free {system wide educational site license} - unlike MS/SQL), so what I want to know is: does Oracle8 generally work well on Windows 2000 server (compared to running it on NT4)? We will be running on this hardware: IBM Netfinity5100 w/ RAID (dedicated Oracle server, w/ web server on same box, if possible). My assumption is that Win2k/Oracle8 is ok. Are there any horror stories out there about running Oracle8 on Win2K where running on NT4 would have been better? thanks! ep On 5 Feb 2001, at 9:25, Mark Leith wrote: Date sent: Mon, 05 Feb 2001 09:25:25 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] RE: Async I/O on WindowsWHOOO a SQLServer vs. Oracle debate again!! ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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 RE: Async I/O on Windows
Title: RE: OT RE: Async I/O on Windows You might want to check those results again. Oracle has the top three in the TP-C, nonclustered results. || I did. The results speak for themselves. You need to click ALL RESULTS. (Or, are you saying that, in 2001, we should focus on NON_CLUSTERED systems?). Unfortunately, TPC rules disallow running the SAME EXACT SYSTEM against two different databases. And - brace yourself, this is really revealing - ORACLE CORPORATION PROHIBITS YOU FROM PUBLISHING ANY REPEAT ANY BENCHMARKS AT ALL. What are they scared of? Does that sound like a Winner to you? With the clustered results Oracle has the highest for 1 CPU/client. Everything above them has 2 CPU/client. The configuration is important. MS SQL Server's configuration for their highest rating was absurd (192 CPU's). || Absurd. Interesting. That's reminiscent of Thomas J. Watson's famous estimate that the world would never need more than a handful of computers. - Paul -Original Message- Sent: Monday, February 05, 2001 8:56 AM To: Multiple recipients of list ORACLE-L NT still pants...LOL!!! It must be panting alot, It has BLOWN THE DOORS OFF of Oracle on Unix in running SQLServer on NT, as has DB2. The general public ( and anyone else ) can wake up and smell the coffee at www.tpc.org http://www.tpc.org . Check out the Top Ten TPC-C marks, by pure performance. Not interested in pure peformance? Check out the Price/Performance leaders. Oracle doesn't even SHOW UP in the top ten. What a shocker, eh? It's painful to lose our illusions Oh, what's that? You don't like TPC-C? It's outmoded or somesuch? Fine, check out ANY of the TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't even show up. I mean, I like Oracle, too, butby the time you turn on the multimode airconditioner, use the 12-way adjustable power bucket seats, activate the object-oriented OnStar Satellite navigational system, power up the heated side view mirrors and all the other tools, trinkets, and toys that make it my personal favorite database, there *is* the chance that the twenty year old genius mechanic in the the tricked out Nova next to you at the light is going to kick your ass when the light turns green. But really, I still love Oracle. Warts and all. Wanna drag? (heh heh heh) -Original Message- Sent: Saturday, February 03, 2001 6:45 AM To: Multiple recipients of list ORACLE-L I have actually been doing a fair it of reading on this since the topic was brought up, and stand corrected, as earlier mentioned. But I have to say guys that NT is still fairly pants when it comes to handling multi threaded processes.. Win2K is a great improvement but M$ still has a lot of work to do on in my view. (only when you compare this against UNIX) Now don't get me wrong, there is enough traffic on this list about this at the moment, so I dont want more bandwith added with this thread if at all possible :) Thanks for the reply anyway Yong, I think I will wait for a good book on Win2k to come out (unless you know one?) before I go out and buy one (books come out of my pocket as I am a sales person mostly).. NT as far as I am concerned is now in Win2K's shadow, and I think that is the way of the future for Windowze bound people. For all out there that have used NT and not Win2K - TRY IT.. Services are handled a LOT better, file management and sharing.. All sorts of new fun stuff to sink your teeth in to.. As a side note, for the last line of my first paragraph - I also feel that UNIX cannot be compared in anyway to Windows at this time. Windowze O/S's are designed for pointy clicky people that prefer to look at a nice GUI interface, and generally don't have the indepth technical knowledge that a good UNIX sys admin does.. (If there any NT admins out there don't flame me, I have to deal with it every day of my life...) Regards Mark The views expressed here are soley those coming out of my coffee deprived hungover mind.. They do not express those of my employers, though I'm sure they agree :^) -Original Message- Sent: Friday, February 02, 2001 07:00 To: Multiple recipients of list ORACLE-L Oracle on NT runs as ONE PROCESS with MULTIPLE THREADS for performance reasons (no more need for shared memorycontext switches are a LOT less expensive, etc.) -Original Message- Sent: Friday, February 02, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Hi, Mark, Async I/O is available on Windows, at least NT. It's not an easy topic. If you think you already know enough about operating systems in general, I suggest you read David Solomon's Inside WindowsNT. For a lab test, launch Performance Monitor on your NT box and look at the counters for Cache. I'm not sure by single thread management whether you mean NT can't have multiple processes or Oracle on NT runs as one thread. The former is obviously wrong. The
Re: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows
"Eric D. Pierce" wrote: Ross Mark, There are no major performance concerns here (and we get Oracle "free" {system wide educational site license} - unlike MS/SQL), so what I want to know is: does Oracle8 generally work well on Windows 2000 server (compared to running it on NT4)? Well, I was surprised to install 8.1.7 on Windows 2000 and discover that none of the Oracle Enterprise Manager features work. They install, but they don't run--it just hangs up an empty window on the screen. The fact that OEM doesn't work is documented in the readme, but I've not seen a patch for it yet. Bill -- __ http://www.datacraft.com/http://plnet.org/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pribyl 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 RE: Async I/O on Windows
Title: RE: Async I/O on Windows Yay, someone is looking at the data!!! On the clustered side, did you notice that the leader, far and away, was SS2K on Win2K. Pure Microsoft Play, and clustering 192 CPUs. WO-WAAA. too bad "Microsoft can't cluster" ( har de har har ) -Original Message-From: Jeffery Stevenson [mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 1:06 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Async I/O on Windows Well, Oracle does have all three of the top spots in TPC-C for Non-clustered results...I wonder how a performance/square foot rating would turn out...hmmm... :) Jeffery StevensonChief Databeast TamerMedical Present Value, Inc.Austin, TX -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 9:56 AMTo: Multiple recipients of list ORACLE-LSubject: OT RE: Async I/O on Windows "NT still pants"...LOL!!! It must be panting alot, It has BLOWN THE DOORS OFF of "Oracle on Unix" in running SQLServer on NT, as has DB2. The general public ( and anyone else ) can wake up and smell the coffee at www.tpc.org. Check out the Top Ten TPC-C marks, by pure performance. Not interested in pure peformance? Check out the Price/Performance leaders. Oracle doesn't even SHOW UP in the top ten. What a shocker, eh? It's painful to lose our illusions Oh, what's that? You don't like TPC-C? It's outmoded or somesuch? Fine, check out ANY of the TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't even show up. I mean, I like Oracle, too, butby the time you turn on the multimode airconditioner, use the 12-way adjustable power bucket seats, activate the object-oriented OnStar Satellite navigational system, power up the heated side view mirrors and all the other tools, trinkets, and toys that make it my personal favorite database, there *is* the chance that the twenty year old genius mechanic in the the tricked out Nova next to you at the light is going to kick your ass when the light turns green. But really, I still love Oracle. Warts and all. Wanna drag? (heh heh heh) -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED]]Sent: Saturday, February 03, 2001 6:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Async I/O on Windows I have actually been doing a fair it of reading on this since the topic was brought up, and stand corrected, as earlier mentioned. But I have to say guys that NT is still fairly "pants" when it comes to handling multi threaded processes.. Win2K is a great improvement but M$ still has a lot of work to do on in my view. (only when you compare this against UNIX) Now don't get me wrong, there is enough traffic on this list about this at the moment, so I dont want more bandwith added with this thread if at all possible :) Thanks for the reply anyway Yong, I think I will wait for a "good" book on Win2k to come out (unless you know one?) before I go out and buy one (books come out of my pocket as I ama sales person mostly).. NT as far as I am concerned is now in Win2K's shadow, and I think that is the way of the future for Windowze bound people. For all out there that have used NT and not Win2K - TRY IT.. Services are handled a LOT better, file management and sharing.. All sorts of new fun stuff to sink your teeth in to.. As a side note, for the last line of my first paragraph - I also feel that UNIX cannot be compared in anyway toWindows at this time. Windowze O/S's are designed for pointy clicky people that prefer to look at a nice GUI interface, and generally don't have the indepth technical knowledge that a good UNIX sys admin does.. (If there any NT admins out there don't flame me, I have to deal with it every day of my life...) Regards Mark The views expressed here are soley those coming out of my coffee deprived hungover mind.. They do not express those of my employers, though I'm sure they agree :^) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: Friday, February 02, 2001 07:00To: Multiple recipients of list ORACLE-LSubject: RE: Async I/O on Windows Oracle on NT runs as ONE PROCESS with MULTIPLE THREADS for performance reasons (no more need for shared memorycontext switches are a LOT less expensive,
RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows
Title: RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows Do you crash weekly? -Original Message- From: Kimberly Smith [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 3:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows I am running ORacle8i on Windows2000 and for what I use it for I see no difference from NT. -Original Message- Sent: Monday, February 05, 2001 11:06 AM To: Multiple recipients of list ORACLE-L Ross Mark, There are no major performance concerns here (and we get Oracle free {system wide educational site license} - unlike MS/SQL), so what I want to know is: does Oracle8 generally work well on Windows 2000 server (compared to running it on NT4)? We will be running on this hardware: IBM Netfinity5100 w/ RAID (dedicated Oracle server, w/ web server on same box, if possible). My assumption is that Win2k/Oracle8 is ok. Are there any horror stories out there about running Oracle8 on Win2K where running on NT4 would have been better? thanks! ep On 5 Feb 2001, at 9:25, Mark Leith wrote: Date sent: Mon, 05 Feb 2001 09:25:25 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] RE: Async I/O on WindowsWHOOO a SQLServer vs. Oracle debate again!! ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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: Pondering Question of the Day-RESPECT
Rocky, She lost the bet and got a raise - go figure ! well done lisa , we still wish you were back in Eden Prairie ! Q Rocky Welch [EMAIL PROTECTED] on 02/05/2001 03:45:33 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Brian McQuillan/GELCO) Anyone heard from Lisa today or is she out job hunting? ;o) Kimberly Smith [EMAIL PROTECTED] wrote: Sounds like you more like the backup DBA then just a developer. Congrs, I believe you wear two hats. Now go ask for a raise. -Original Message- Sent: Friday, February 02, 2001 10:40 AM To: Multiple recipients of list ORACLE-L You are exactly correct. I as a developer am usually the first line of blame when something doesn't work even when it is because the sys admin decided to add a service pack or to tweak some parameters to optimize something else, or the network guys decided to improve the firewalls or the DBA decided to clean up the database without bothering to find out if those tables were actually being used. We are a pretty small shop compared to most of you guys, nobody is on call, and sometimes the DBA is not available or is busy with something else, so I need to be able to stop and start the listener, create and move tables, recreate indexes, drop and add users and privileges. On the plus side for the DBA, I am responsible for fixing my own mistakes, the most he has to do for me is load the backup tape. At 10:05 AM 2/2/01 -0800, you wrote: Pondering Question of the Day-RESPECTcome on! give me an user who prefer we, developers and dbas working in a decent way, instead of get its job done "rigth now in this moment" and I'll shave my head and paint it blue. developers get crazy trying to solve a problem with users on the other side of the phone yelling! and that's first reason of messing everything up. (ok, don't generalize) users' bosses want the same. why can't we talk about the complete organization? and why everybody thinks developers and dbas as separate things? If you can't separate responsabilities and duties, well, it's an organization problem try to take an equilibrium and you'll be happy Gabriel Galanternik - Original Message - To: Multiple recipients of list ORACLE-L Sent: Friday, February 02, 2001 1:10 PM Lisa, Rather than talking to the CTO about this go to the Dir, VP, or whatever of the USERS of the system. In-fact he/she is the actual OWNER of the data in the system. Explain to him/her how dangerous and devious the developers are to the data. Talk about corruption, system downtime, partial and incomplete restores. Use some technical DBA language to make them understand you have the knowledge, but make sure you keep the message at a manager level of understanding. Get them good and scared. Then when the developers are asking for the free ride in production you have an advocate in high postion that can put the CTO in a position of getting a backbone. When the COO starts asking why his people can't work, or why the P/L statement is messed up the CTO will start scrambling for a lockdown on production and more comprehensive testing of new or enhanced code. Remember the politics. We in the IT field are not the production organization we are the service organization. When it comes to power struggles at the Cxx levels the production/operations guys always beat the IT/IS guys. It's a mater of $$$ and performance in front of the CEO. HTH Rodd Holman -Original Message- Sent: Friday, February 02, 2001 9:20 AM To: Multiple recipients of list ORACLE-L "Hello Oracle Guru" Now why is it that I get more respect on the Internet than I do in my workplace. ?? How many of you have this problem? It's like an ongoing fight with developers, they want carte blanche in the production database, and they do whatever they want EVEN THOUGH I tell them NO, let's do something different that won't affect production. I go to the CTO because this is like the 3rd time this has happened, and he sends out a let's-be-sure-not-to-offend-anyone email. But the developer(s) will go ahead and do what they want ANYWAY. I'm waiting for the first user-mistake recovery to say STOP, I've had ENOUGH and this is how it's going to be, no ifs, ands or buts. My last job may have been a sweatshop, but at least people respected my authority. Here, it's a free for all no matter what I do. Even when I say, Dude, I own the database. If there's a problem, I have to fix it. Therefore I say what happens in production and what doesn' t happen in production. And yes, I am looking for another position. I can only take this dba/developer/janitor role for so long. I'M SO GLAD IT'S FRIDAY... Bring on the Captain Morgan! It's noon somewhere... Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the
Patchset installation
Hi, I am looking into installing a patchset with minimum downtime. Standard Oracle procedure for installing a patchset is: 1. Shutdown the database 2. Install the patch binaries, relink. 3. Startup database (restrict ?), run the cat* scripts. I wanted to change the procedure so that instead of having the database down during the patch install and relinking, prior to the procedure I copy the binaries to a newly created home, install the patch on the new home, relink the binaries under the new home, and than just restart the database from the new home. To make sure that everything is OK, I would postpone the cat* scripts run, for a later time, once I am sure that everything is OK. If something goes wrong I haven't changed anything in the database, and I can just go back to the old home. Has anybody tried this ? What is the significance of cat* scripts. As far as I understand them, oracle does not use them and do not care about them, only some apps might break (most of all DBA type of scripts). Thanks. Djordje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djordje Jankovic 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: Pinning Tables
Title: RE: Pinning Tables What is the difference between table caching and pinning, to your thinking? -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Subject: Pinning Tables Hi all, I have been trying to find some reference on pinning tables in the SGA. I haven't found anything, all that I am finding is table caching and the keep buffer pool. Is this all that there is, can I pin a table in the memory? Thanks in advance. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Ascii code of tab?
There is a very helpful Microsoft help file available at http://ourworld.compuserve.com/homepages/r_harvey that contains references for everything from ascii to codepages, and the best part is that it is free. David Barbour [EMAIL PROTECTED] 02/05/01 04:25PM ^I Dec - 9 Oct - 011 Hex - 09 David A. Barbour Oracle DBA - ConnectSouth 512-681-9438 [EMAIL PROTECTED] -Original Message- Sent: Monday, February 05, 2001 12:57 PM To: Multiple recipients of list ORACLE-L What is ascii code of TAB? Thanks __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Barbour 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein 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: Pondering Question of the Day-RESPECT
http://www.theregister.co.uk/content/30/12701.html - http://www.theregister.co.uk/content/archive/16057.html (Prostitutes used to tempt IT staff into jobs) On 5 Feb 2001, at 12:12, Rocky Welch wrote: Date sent: Mon, 05 Feb 2001 12:12:17 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] hm, I like that. I've been working on training people here on the proper bribes for the DBA, but they are SLOWWW learners. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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 RE: Async I/O on Windows
Title: RE: OT RE: Async I/O on Windows Another way of looking at it: So lets say the 12 computer configuration were to have a failure in some *single* wintel box every 7 days .. who cares!! The shared nothing architecture underlying the system load BALANCES users to machines which are up .. no user would even notice ... This is how you hit Five Nines at superlow cost points. This is particularly useful for rolling new machines into and out of the server set to SCALE AS NEEDED...instead of buying BIG IRON that sits and waits for the once a year spike in usage. (But you get to pay for it every day!) Just as sites like DELL who will trippple their site size for xmas than return to fewer machines afterwards. BUCKETS OF Money saved on operational costs ( server contracts, electricity etc ... ) and all users served all the time. Let's not even TALK about the savings on POWER UNITS :) (Larry, you broken toilet of a man!) Low concurrency numbers are historically due too poor configuration (the problem is in the application 80% of the time)...just 'cus someone doesn't know how to write an app doesn't mean it can't be done. Oh, and this just in, News Fans: The idea that it requires a highly skilled, highly trained, expensive DBA to go create a table is stupid ... I'll get a 7 year old to do it in a few clicks when he gets home from school while the database is tuning itself, and I am out studying for me new technical skills...Yay! -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 2:42 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT RE: Async I/O on Windows Actually, not that it matters from what I can tell, but Oracle is tops if you consider clustered vs. non-clustered. It seems that Oracle doesn't even have tests for clustered systems. I wonder what happened to the VLDB tests in the huge DEC/Compaq Alpha cluster? As far as SQL (pronounced: SQueaL) Server blown the doors off, there are factors that TPC does not consider. First, is reliability. According to Oracle Magazine, Jan/Feb 2001, p38, ...a 12-computer configuration from Microsoft, such as that used in recent TPC-C benchmarks, is estimated to experience a catastophic failure once every 7.5 days, according to Microsoft's own estimates. Granted, the quote is from Oramag, but I've heard the same from other Industry Sources. I know of a specific implementation where the NT database servers would dog and/or crash when approximately 500 concurrent users were attached (note: attached active) to the database. The decision was made to dump NT for DB serving and go with a major (HP or Sun or IBM) flavor of Unix for it's scalability and reliability. Second, when was the last time you needed a 500K TPC-C from only 48 clients? From a couple thousand, yes, but only 48? And who's gonna buy everyone in their company a $7500 desktop PC with twin PIII-800s in them for clients? While those numbers are specific to the top TPC-C Compaq/MS result, that's how all these companies get their numbers. I'm not betting my job on TPC-C numbers. The numbers just don't reflect real-life situations. And I didn't even touch upon the potential locking problems on SQL Server, or how it can do dirty reads... :) Just my $.02. I need to go create some Oracle databases on HP/UX now. ;) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, February 05, 2001 09:56 To: Multiple recipients of list ORACLE-L NT still pants...LOL!!! It must be panting alot, It has BLOWN THE DOORS OFF of Oracle on Unix in running SQLServer on NT, as has DB2. The general public ( and anyone else ) can wake up and smell the coffee at www.tpc.org http://www.tpc.org . Check out the Top Ten TPC-C marks, by pure performance. Not interested in pure peformance? Check out the Price/Performance leaders. Oracle doesn't even SHOW UP in the top ten. What a shocker, eh? It's painful to lose our illusions Oh, what's that? You don't like TPC-C? It's outmoded or somesuch? Fine, check out ANY of the TPC benchmarks. Oracle is NEVER in the top three. Usually, it doesn't even show up. I mean, I like Oracle, too, butby the time you turn on the multimode airconditioner, use the 12-way adjustable power bucket seats, activate the object-oriented OnStar Satellite navigational system, power up the heated side view mirrors and all the other tools, trinkets, and toys that make it my personal favorite database, there *is* the chance that the twenty year old genius mechanic in the the tricked out Nova next to you at the light is going to kick your ass when the light turns green. But really, I still love Oracle. Warts and all. Wanna drag? (heh heh heh) -Original Message- Sent: Saturday, February 03, 2001 6:45 AM To: Multiple recipients of list ORACLE-L I have actually been doing a fair it of
RE: Index Usage Monitoring
Hi, Eveleen, you a right, x$bh is the veiw, which contain important information about database buffer. This means, you will find here references to only those database blocks, which are currently in buffer, i.e., most recently used. You even can identify "hot" (often updated) blocks, because Oracle reconstructs block image in memory for different queries, and this will be different records in x$bh. I use the following query select FILE#, DBABLK, count(*) from x$bh group by FILE#, DBABLK having count(*) 10 order by 3 desc; Top line blocks are subjects to revise segment parameters. But this doesn't not completely the same task, as in question. Vadim Gorbounov Oracle DBA -Original Message- Sent: Monday, February 05, 2001 1:57 PM To: Multiple recipients of list ORACLE-L I do know there is a way to tell which indexes are accessed most recently by query x$bh view. Is this what you want or something different? Sorry I forgot the initial posting of this issue. Eveleen Please respond to [EMAIL PROTECTED] Vadim Gorbounov [EMAIL PROTECTED] on 02/05/2001 09:30:47 AM Message - From: Vadim Gorbounov [EMAIL PROTECTED] on 02/05/2001 03:30 PM GMT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: Eveleen Xu/NNIB/NNNG) Subject: RE: Index Usage Monitoring Hi, Why not to use otrace? Of cource, you may need some space to save trace results, but you'll definitely get complete statistics. Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, January 30, 2001 3:57 PM To: Multiple recipients of list ORACLE-L We have a purchased application with over 1,300 indexes. Can someone suggest a method to monitor the system to determine which indexes are actively being used over time? I'm assuming that some are old/not necessary and would like to save the overhead of maintaining them. Oracle 8.0.6 Patrick Prince email: [EMAIL PROTECTED] Omaha Public Power District voice: (402) 636-3762 444 S 16th St. Mall, Omaha, NE 68102fax: (402) 636-3931 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PRINCE, PATRICK W. 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows
Title: RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows :)...so, no Win2K Oracle8, but 8i is cool, all around. Put that in yer pipe and smoke it! (Love the haddock.ani .!) -Original Message- From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 4:43 PM To: Multiple recipients of list ORACLE-L Subject: RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows Ever since I got a cool little animated cartoon icon of Capt. Haddock (in the Tintin books from Belgium) with smoke coming out his pipe to replace my windows houglass, i *LOVE* logging onto METALINK and waiting!!! ( http://www.tintin.be - http://www.tintin.be/Telecharger/download_gb.htm ) AIX is not an option. We have a choice of NT4 or Win2k as the LAN servers that our central campus NetworkGods/SAs will support for departmental database projects. Just asking them to do network support for a few special case Win2k pro desktops elicited the same horrified looks that would greet a proctologist driving around in a rotorooter truck, so asking for AIX probably isn't too good an idea. :) Anyway, here is the ink from METALink: - Certify - Product Version and Other Selections: Oracle Server - Enterprise Edition On Microsoft Windows 2000 Critical Notes For Oracle Server - Enterprise Edition General Notes For Oracle Server - Enterprise Edition On Microsoft Windows 2000: Shipping Information: Starting with release 8.1.6 (Oracle8i Release 2), software for Windows NT and Windows 2000 ships together as one. It's called Oracle8i Enterprise Edition Release 2 for Windows NT/2000. Windows 2000 Editions (production): Microsoft has various editions/versions of Windows 2000. They are: Professional Server Advanced Server Datacenter Server Terminal Services Multi-Language Oracle RDBMS Server products are supported on all available Windows 2000 editions. Release Information: There are no plans to support Oracle 7.3.4 or 8.0.x releases on Windows 2000. Patch Set Information: Patch set 8.1.6.1.0 has been withdrawn on Windows. Replacement patch: 8.1.6.1.1. Additional Search Criteria (Optional): Oracle Server - Enterprise Edition Version(s) 8.1.7 (8i) 8.1.6 (8i) 8.1.5 (8i) Certified combinations only YES Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use. - Certify - Additional Info Oracle Server - Enterprise Edition ver: 8.1.7 (8i) On Microsoft Windows 2000 Operating System: Microsoft Windows 2000 Version:2000 Oracle Server - Enterprise Edition Version: 8.1.7 (8i) N/A Version: N/A Status: Certified Product Version Note: None available for this product. Certification Note: Existing patch sets: 8.1.7.1 planned Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use. - On 5 Feb 2001, at 12:45, Mohan, Ross wrote: Date sent: Mon, 05 Feb 2001 12:45:32 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From what I know, Oracle8 is not yet formally certified on Win2K, believe it or not. But, I could be way wrong about this. Anecdotally, I have colleagues running every from clients through Net8 Names Servers to database servers on Win2K. Typical Win2K uptime, about..well, since they plugged it in, several months ago. Punchline: As a migration from NT4, NT5 (i.e. Win2K) is noticeably better in terms of stability and performance. If you asked me to compare Win2K and current version AIX, i'd pick the latter. (original message:) My assumption is that Win2k/Oracle8 is ok. Are there any horror stories out there about running Oracle8 on Win2K where running on NT4 would have been better? ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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 RE: Async I/O on Windows - Federated Database Foolishness
Title: RE: OT RE: Async I/O on Windows - Federated Database Foolishness What's a federated database || I don't know. Where did you read it? shrug We really need to understand this otherwise we'll be duped by Microsoft's deceptive benchmark claims!! || wow! thanks for saving me, I was just in the process of being duped by Oracle's deceptive benchmark claims!! :-) Seriously, the TPC is *independent*. Comparing the performance of SQLServer in a federated database configuration to Oracle in a parallel server configuration is useless and misleading but that's what Microsoft is doing when they tout their TPC-C benchmarks. In a non-federated database configuration Oracle8 outperforms SQLServer handily. Do we really want performance without fault tolerance? How well does SQLServer perform when it's down because of its fragility? ;-/ || See previous posts on the fragility of a cluster. When was the last time you heard about the DELL site going down? Oh, never? Right, and they use NT. How about Ebay? Oh, several times a year? How about THAT for a BROKEN TOILET of a configuration: Oracle on Sun. Heh heh heh. Microsoft shattered the TPC-C record with the federated database architecture but even a self-confessed pro-Microsoft apologist pointed out that no one in their right mind would actually setup a production OLTP database that way. || That word keeps popping up. Does federated mean anything Does it matter if the opposing football team is named The Federates if they kick your team all over the field? It's not about the name, it's about performanceor...price/performance. And Microsoft wins on both fronts. (This month. Who know when Oracle will submit it's next TPC benchmark...) The point of the demo at OpenWorld || ROFLMMAO NOW, I get it: Are you really citing OpenWorld Oracle Corporation presentations of Microsoft systems. OH MY GOD, is that impartial enough for you? LOL was to highlight the fragility and impracticality of the federated database architecture as a real world || Oh yea, you should have seen the Oracle DEMO at the MICROSOFT CONFERENCE. LOL fault tolerant solution. The demo was quite amusing with smoke and sound effects. While displaying transaction rates, a node in a running cluster was blown up with predictable results. The transaction rate for SQLServer went down to zero because the database was down while the Oracle Parallel Server cluster kept on running. Of course Microsoft does not want to see its products trashed regardless of the truth so, in an attempt to prevent Larry from repeating this demo they sought an injunction based on the fine print of their license agreement which says you can't run benchmark tests without prior written approval from Microsoft. (Does anyone ever read license agreements?) || Two points. One: Oracle Engineers must have misconfigured the Microsoft servers. What a shock! Perhaps they should have gone to the Dell site? Upon failure there is no data loss, and imperceptible slowdown. Two: Try to publish ANYTHING about Oracle sometime, and see what happens based on the agreement you signed with Larry...:-) We need a new, more fair benchmark to measure transaction rates AND fault tolerance of a database cluster. Something like a standard 4 node cluster and a random blow up of a node. This new benchmark would need to run a practical, real world application and measure transaction rates before, during and after the blow up. It would also be nice to measure the linear scalability of adding new nodes (which is impossible under the federated database approach without doing a complete reorg). || This is the best idea i have heard in a long time. Why not throw in a scalability-across-servers part as well. I wish it would happen. But, the major vendors NEVER go head to head in this way. I believe that MS would wipe up the bloody floor in the Price/Performance battle with Oracle. Oh but now I'm dreaming so it's back to reading the reviews and making decisions based on gut feel. || You can always read the Best Buys at Ebay, if it's up. :-)
RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE
Title: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE I have some answers, for the curious: http://www.zdnet.com/eweek/stories/general/0,11011,2623013,00.html It appears that SS can partition data storage among multiple machines, giving it blow your doors off performance. If a machine goes ( gets dynamited at an Oracle demo, for instance) the data goes with it. This would be much in the same way that your data (ALL of it) would go if you blew up the EMC/Hitachi/StorageWorks array. Oracle Parallel Server, in contrast, has a single location for it's data ( read: single point of failure! ) Granted, there are more failure points in a federated architecture, but there is no such thing as a TOTAL failure ( like site down ) since only part of the data needs to be recovered from backup. But, with Oracle Parallel Server, if your disk farm goes down, you lose EVERYTHING. I suppose if i ever need to store a Petabyte or so, I'll do it on more than one box, for disaster recovery. So, this is the way around the weakness in hardware loss for both SqlServer2K and Oracle. And, if I run my PByte database on SS2K, I'll get my answers alot faster. nudge nudge -Original Message- From: Steve Orr [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 3:53 PM To: Multiple recipients of list ORACLE-L Subject: OT RE: Async I/O on Windows - Federated Database Foolishness What's a federated database We really need to understand this otherwise we'll be duped by Microsoft's deceptive benchmark claims!! Comparing the performance of SQLServer in a federated database configuration to Oracle in a parallel server configuration is useless and misleading but that's what Microsoft is doing when they tout their TPC-C benchmarks. In a non-federated database configuration Oracle8 outperforms SQLServer handily. Do we really want performance without fault tolerance? How well does SQLServer perform when it's down because of its fragility? ;-/ Microsoft shattered the TPC-C record with the federated database architecture but even a self-confessed pro-Microsoft apologist pointed out that no one in their right mind would actually setup a production OLTP database that way. The point of the demo at OpenWorld was to highlight the fragility and impracticality of the federated database architecture as a real world fault tolerant solution. The demo was quite amusing with smoke and sound effects. While displaying transaction rates, a node in a running cluster was blown up with predictable results. The transaction rate for SQLServer went down to zero because the database was down while the Oracle Parallel Server cluster kept on running. Of course Microsoft does not want to see its products trashed regardless of the truth so, in an attempt to prevent Larry from repeating this demo they sought an injunction based on the fine print of their license agreement which says you can't run benchmark tests without prior written approval from Microsoft. (Does anyone ever read license agreements?) We need a new, more fair benchmark to measure transaction rates AND fault tolerance of a database cluster. Something like a standard 4 node cluster and a random blow up of a node. This new benchmark would need to run a practical, real world application and measure transaction rates before, during and after the blow up. It would also be nice to measure the linear scalability of adding new nodes (which is impossible under the federated database approach without doing a complete reorg). Oh but now I'm dreaming so it's back to reading the reviews and making decisions based on gut feel. IMHO, Steve Orr -Original Message- Sent: Monday, February 05, 2001 11:42 AM To: Multiple recipients of list ORACLE-L Actually, not that it matters from what I can tell, but Oracle is tops if you consider clustered vs. non-clustered. It seems that Oracle doesn't even have tests for clustered systems. I wonder what happened to the VLDB tests in the huge DEC/Compaq Alpha cluster? As far as SQL (pronounced: SQueaL) Server blown the doors off, there are factors that TPC does not consider. First, is reliability. According to Oracle Magazine, Jan/Feb 2001, p38, ...a 12-computer configuration from Microsoft, such as that used in recent TPC-C benchmarks, is estimated to experience a catastophic failure once every 7.5 days, according to Microsoft's own estimates. Granted, the quote is from Oramag, but I've heard the same from other Industry Sources. I know of a specific implementation where the NT database servers would dog and/or crash when approximately 500 concurrent users were attached (note: attached active) to the database. The decision was made to dump NT for DB serving and go with a major (HP or Sun or IBM) flavor of Unix for it's scalability and reliability. Second, when was the last time you needed a 500K TPC-C from only 48 clients? From a couple thousand, yes, but only 48? And who's gonna buy
Re: SQLNET Question
Yes, you do that in the SQLNET configuration files LISTENER.ORA and TNSNAMES.ORA - use the IP address (instead of the hostname) of the NIC card you want to use. It is not complicated at all! Cheers, Renato Database Services IBM Global Services A/NZ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: SQLNET Question All, Is it possible to force SQL*NET to use a specific NIC on a system that has 2 NIC's? If it is, can you give an example or point me in the right direction? Sun Solaris 7/ Oracle 8.0.5.2.1 Thanks in advance. Roy Author: Roy Ferguson INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Renato Huliganga 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: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows
I'm used to Oracle7.3 command line DBA environment. Is there anything in OEM that I "must have" to run the Oracle8.1.7/Win2k? I'm really not sure -- all I have needed to do with is startup, shutdown, and run SQL PL/SQL scripts. Good luck Bill -- __ http://www.datacraft.com/http://plnet.org/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pribyl 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: OEM/IA and DB shutdown
If you are using OEM v2.1 or higher then you could define a paging / email blackout before the shutdown (either for the node / db in question or a total one). Or you could remove the event and then reinstate it. Regards, Bruce -Original Message- Sent: Tuesday, 6 February 2001 5:06 I run about 20+ databases from one OEM session, albeit on NT, and I never shutdown the agent when I shutdown a database. You must have OEM sending email for all events. Just use email for selected events that you want to know about. OEM won't freak if you don't shutdown the repository database. If you do it will stop working at all. I use a small database on one of my servers to hold the repository and the recovery catalog. Then no matter what I do with the other databases OEM doesn't care. I don't know if this answers all of your questions but I hope it helps, Ruth - Original Message - Sent: Monday, February 05, 2001 10:50 AM So, there I am, with an HP/UX server hosting 3 production Oracle DBs. The node is also running Oracle Intelligent Agent, and I have OEM events to e-mail/page me if there's problems with productions DBs and servers. Anyone else running something similar? How do you shutdown a single production DB without causing OEM to freak? If I kill IA, OEM freaks, and sends e-mail and pages about all the DBs and node being unavailable. If I SHUTDOWN NORMAL the production DB, like a good DBA, I need to manually kill the DBSNMP processes that are still connected. If I SHUTDOWN IMMEDIATE, then STARTUP RESTRICT (in order to SHUTDOWN NORMAL), can the DBSNMP process still connect? I have been doing the SHUTDOWN NORMAL and killing the DBSNMP processes, but that somehow just seems hokey to me. Anyone? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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).
OT - WHAT is a FEDERATED DATABASE ???
Ross, glad to see you're starting to come up to speed here. :) But for the clustering to work, businesses would have to change software and segment the data The CNet authors obviously got tangled up in their notes and didn't understand what they were writing about. (Not a first.) You don't have to "segment the data" in OPS- that's the "federated database" scene where you place different tables for the same database app on different servers. If you segment an enterprise package like SAP or Oracle ERP then you have 1000's of tables to deal with. Chances are, no matter how "intelligently" you segment your data, just losing any random machine, and its attendant subset of tables, will bring the application to a halt and no more transactions will be possible even though the database is still "up." That's a single point a failure and that's the real problem. And to add a machine to the federated cluster you still have to re-segment the data. I don't believe the good folks at Dell have architected a federated database like Microsoft did for the TPC. Here's a challenge... Does anyone know of ANY enterprise ERP type package or any other application where the software vendor supports a "federated" architecture? If not then it's likely no one will ever experience the performance seen in the TPC-C benchmarks by Microsoft. If no real world apps support a federated architecture then we may as well just ignore all those benchmarks. And after we throw all those benchmarks out which database engines consistently score the best on the remaining benchmarks? Here's another challenge... Has anyone ever worked with or even know of anyone who's worked with a federated database? While I wouldn't configure my database exactly like Oracle configures those used for TPC benchmarking, (turning off redo, etc.), in terms of physical design I do believe my databases are at least somewhat similar or recognizably in the same ballpark. I do not believe anyone comes close to configuring SQLServer's physical layout like that used in the Microsoft benchmarks. That's the challenge and until someone can address this challenge we should practically ignore all TPC benchmarks produced from Microsoft's federated database architecture. IMHO. the TPC is *independent*. Yes, and it's flawed and vendors take advantage of this to dupe the unwitting. BTW, Oracle OPS / EMC doesn't have to be a single point of failure if you implement the SRDF option but I've never done it so what do I know? Well I'll answer that by saying I don't know much but I do try to keep an open minded pursuit of the truth. Sometimes I actually succeed... I think. ;-) Steve Orr -Original Message- Sent: Monday, February 05, 2001 3:09 PM To: Multiple recipients of list ORACLE-L Very Interesting! It appears Oracle 9i, is, in fact, a Hybrid Federated Database! http://news.cnet.com/news/0-1003-200-2897140.html?tag=st.ne.ni.metacomm.ni A snippet: "An Oracle spokeswoman said the new Oracle 9i database, due in the first half of next year, will feature new "clustering" technology that will make the company's databases perform faster and more reliably than before. Clustering allows businesses to harness multiple servers to run a very large database, allowing servers to share work or take over from each other if one fails. The company's previous clustering technology, called Oracle Parallel Server, allowed businesses to add as many servers, or high-end computers, as they needed. But for the clustering to work, businesses would have to change software and segment the data, a time-consuming effort for database administrators, said Jeremy Burton, Oracle's senior vice president of products and services marketing..." -Original Message- Sent: Monday, February 05, 2001 5:55 PM To: '[EMAIL PROTECTED]' I have some answers, for the curious: http://www.zdnet.com/eweek/stories/general/0,11011,2623013,00.html It appears that SS can partition data storage among multiple machines, giving it "blow your doors off" performance. If a machine goes ( gets dynamited at an Oracle demo, for instance) the data goes with it. This would be much in the same way that your data (ALL of it) would go if you blew up the EMC/Hitachi/StorageWorks array. Oracle Parallel Server, in contrast, has a single location for it's data ( read: single point of failure! ) Granted, there are more failure points in a federated architecture, but there is no such thing as a TOTAL failure ( like "site down" ) since only part of the data needs to be recovered from backup. But, with Oracle Parallel Server, if your disk farm goes down, you lose EVERYTHING. I suppose if i ever need to store a Petabyte or so, I'll do it on more than one box, for disaster recovery. So, this is the "way around" the weakness in hardware loss for both SqlServer2K and Oracle. And, if I run my PByte database on SS2K, I'll get my answers alot faster. nudge nudge -Original Message- Sent: Monday, February 05, 2001 3:53 PM To:
Re: Patchset installation
Not a good idea. Oracle links some libs in with a direcory that is in Oracle Home. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, February 05, 2001 3:42 PM Hi, I am looking into installing a patchset with minimum downtime. Standard Oracle procedure for installing a patchset is: 1. Shutdown the database 2. Install the patch binaries, relink. 3. Startup database (restrict ?), run the cat* scripts. I wanted to change the procedure so that instead of having the database down during the patch install and relinking, prior to the procedure I copy the binaries to a newly created home, install the patch on the new home, relink the binaries under the new home, and than just restart the database from the new home. To make sure that everything is OK, I would postpone the cat* scripts run, for a later time, once I am sure that everything is OK. If something goes wrong I haven't changed anything in the database, and I can just go back to the old home. Has anybody tried this ? What is the significance of cat* scripts. As far as I understand them, oracle does not use them and do not care about them, only some apps might break (most of all DBA type of scripts). Thanks. Djordje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djordje Jankovic 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Allan Nelson 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 - WHAT is a FEDERATED DATABASE ???
We have a 175 terabyte database in Objectivity. It houses event data from a physics experiments looking at the decay of B-mesons and their antimatter counterparts, trying to find out what's going on with CP violation. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, February 05, 2001 4:56 PM To: Multiple recipients of list ORACLE-L Ross, glad to see you're starting to come up to speed here. :) But for the clustering to work, businesses would have to change software and segment the data The CNet authors obviously got tangled up in their notes and didn't understand what they were writing about. (Not a first.) You don't have to "segment the data" in OPS- that's the "federated database" scene where you place different tables for the same database app on different servers. If you segment an enterprise package like SAP or Oracle ERP then you have 1000's of tables to deal with. Chances are, no matter how "intelligently" you segment your data, just losing any random machine, and its attendant subset of tables, will bring the application to a halt and no more transactions will be possible even though the database is still "up." That's a single point a failure and that's the real problem. And to add a machine to the federated cluster you still have to re-segment the data. I don't believe the good folks at Dell have architected a federated database like Microsoft did for the TPC. Here's a challenge... Does anyone know of ANY enterprise ERP type package or any other application where the software vendor supports a "federated" architecture? If not then it's likely no one will ever experience the performance seen in the TPC-C benchmarks by Microsoft. If no real world apps support a federated architecture then we may as well just ignore all those benchmarks. And after we throw all those benchmarks out which database engines consistently score the best on the remaining benchmarks? Here's another challenge... Has anyone ever worked with or even know of anyone who's worked with a federated database? While I wouldn't configure my database exactly like Oracle configures those used for TPC benchmarking, (turning off redo, etc.), in terms of physical design I do believe my databases are at least somewhat similar or recognizably in the same ballpark. I do not believe anyone comes close to configuring SQLServer's physical layout like that used in the Microsoft benchmarks. That's the challenge and until someone can address this challenge we should practically ignore all TPC benchmarks produced from Microsoft's federated database architecture. IMHO. the TPC is *independent*. Yes, and it's flawed and vendors take advantage of this to dupe the unwitting. BTW, Oracle OPS / EMC doesn't have to be a single point of failure if you implement the SRDF option but I've never done it so what do I know? Well I'll answer that by saying I don't know much but I do try to keep an open minded pursuit of the truth. Sometimes I actually succeed... I think. ;-) Steve Orr -Original Message- Sent: Monday, February 05, 2001 3:09 PM To: Multiple recipients of list ORACLE-L Very Interesting! It appears Oracle 9i, is, in fact, a Hybrid Federated Database! http://news.cnet.com/news/0-1003-200-2897140.html?tag=st.ne.ni.metacomm.ni A snippet: "An Oracle spokeswoman said the new Oracle 9i database, due in the first half of next year, will feature new "clustering" technology that will make the company's databases perform faster and more reliably than before. Clustering allows businesses to harness multiple servers to run a very large database, allowing servers to share work or take over from each other if one fails. The company's previous clustering technology, called Oracle Parallel Server, allowed businesses to add as many servers, or high-end computers, as they needed. But for the clustering to work, businesses would have to change software and segment the data, a time-consuming effort for database administrators, said Jeremy Burton, Oracle's senior vice president of products and services marketing..." -Original Message- Sent: Monday, February 05, 2001 5:55 PM To: '[EMAIL PROTECTED]' I have some answers, for the curious: http://www.zdnet.com/eweek/stories/general/0,11011,2623013,00.html It appears that SS can partition data storage among multiple machines, giving it "blow your doors off" performance. If a machine goes ( gets dynamited at an Oracle demo, for instance) the data goes with it. This would be much in the same way that your data (ALL of it) would go if you blew up the EMC/Hitachi/StorageWorks array. Oracle Parallel Server, in contrast, has a single location for it's data ( read: single point of failure! ) Granted, there are more failure points in a federated architecture, but there is no such thing as a TOTAL failure ( like "site down" ) since only part of the data needs to be recovered from backup. But, with Oracle Parallel Server, if your
Re: Patchset installation
When I am installing the patchset I am giving oracle the new home. For example: 1. My home is /u01/app/oracle/product/8.0.4 2. I copy all the tree under the home to the new home: /u01/app/oracle/product/8.0.4.4 3. For the patch installation session I set: ORACLE_HOME=/u01/app/oracle/product/8.0.4.4, and install the patch, relink, ... . All the linked libreries are with respect to the new home. In the meantime the running instance has no idea of the new home, but uses /u01/app/oracle/product/8.0.4. 4. When I am done with 3, I shutdown the instance change ORACLE_HOME==/u01/app/oracle/product/8.0.4.4 and start the instance. This is very similar to installing a new database version distribution parallel to the existing one, which is a standard procedure, and one of the features of the OFA standard. Djordje - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 05, 2001 8:05 PM Not a good idea. Oracle links some libs in with a direcory that is in Oracle Home. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, February 05, 2001 3:42 PM Hi, I am looking into installing a patchset with minimum downtime. Standard Oracle procedure for installing a patchset is: 1. Shutdown the database 2. Install the patch binaries, relink. 3. Startup database (restrict ?), run the cat* scripts. I wanted to change the procedure so that instead of having the database down during the patch install and relinking, prior to the procedure I copy the binaries to a newly created home, install the patch on the new home, relink the binaries under the new home, and than just restart the database from the new home. To make sure that everything is OK, I would postpone the cat* scripts run, for a later time, once I am sure that everything is OK. If something goes wrong I haven't changed anything in the database, and I can just go back to the old home. Has anybody tried this ? What is the significance of cat* scripts. As far as I understand them, oracle does not use them and do not care about them, only some apps might break (most of all DBA type of scripts). Thanks. Djordje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djordje Jankovic 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Allan Nelson 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: djordjej 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: Patchset installation
We use a similar approach on Open VMS with some success where we 1) re-create a new oracle_root, 2) shutdown the database, 3) change the startup/login scripts. etc 4) start-up database. I would not risk it if the patch modifies some catalogs. (ie a new cat*.sql now exists). Zarir -Original Message- Nelson Sent: 06 February, 2001 05:06 To: Multiple recipients of list ORACLE-L Not a good idea. Oracle links some libs in with a direcory that is in Oracle Home. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, February 05, 2001 3:42 PM Hi, I am looking into installing a patchset with minimum downtime. Standard Oracle procedure for installing a patchset is: 1. Shutdown the database 2. Install the patch binaries, relink. 3. Startup database (restrict ?), run the cat* scripts. I wanted to change the procedure so that instead of having the database down during the patch install and relinking, prior to the procedure I copy the binaries to a newly created home, install the patch on the new home, relink the binaries under the new home, and than just restart the database from the new home. To make sure that everything is OK, I would postpone the cat* scripts run, for a later time, once I am sure that everything is OK. If something goes wrong I haven't changed anything in the database, and I can just go back to the old home. Has anybody tried this ? What is the significance of cat* scripts. As far as I understand them, oracle does not use them and do not care about them, only some apps might break (most of all DBA type of scripts). Thanks. Djordje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djordje Jankovic 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Allan Nelson 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Zarir J Daruwalla 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).
Reg. SPOOL in SQL*PLUS
Hi DBAs, I would like to know the way for specifying a filename dynamically in SQL PLUS. Say, for example The file name should be suffixed with a sequence number available from a SEQUENCE object. ( like SPOOL filename>||seq1.nextval). Any idea? Thank You, Arul.