RE: Oracle vs Mysql
Title: Message Most people only use a fraction of Oracle's featuresand some are deceived bythe Oracle Marketeerswho tell themthatthey NEED them all. Maybe the 80/20 rule also applies to technology purchases... Especially when the cost differential is huge. My 4X4 pickup works just fine and I don't need a Hummer or Land Rover. Offroad in Montana, Steve -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Monday, January 19, 2004 6:42 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle vs MysqlIf MySQL comes to have the same capabilities that many people expect from Oracle, marketing will have no effect. The huge differential in price point will be all that matters. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2004 04:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle vs MysqlSounds like the old Oracle vs. Ingress battles. Oracle won because it wasbetter at marketing. All detailed in the book "The Difference Between Godand Larry Ellison". I can see it now -- MySQL, the Oracle of the freedatabases.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Wednesday, January 14, 2004 4:39 PMTo: Multiple recipients of list ORACLE-LRyan, It's postgres.org. I'm not sure how they generate the operatingrevenue they need, but that's why they are not advertising like MySql AB is.Dick GouletSenior Oracle DBAOracle Certified 8i DBA-Original Message-Sent: Wednesday, January 14, 2004 5:05 PMTo: Multiple recipients of list ORACLE-Li thought postgre was a for profit company? how do they generate revenues?- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 4:19 PM 1) DBI is a perl module to handle the communication with variousdatabases. 2) Postgres is free. I believe that you can buy commercial support, but Idon't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: what is DBI? is postgre free? Is it like linux where you pay for support? I cant findany licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government hadan Oracle EE license on windows. They didnt even use foreign keyconstraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any freedatabase could have handled that. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: If you have the choice, look at PostgreSQL in addition to MySQL.From whatI've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a littlepilot project with the goal to see "what the heck is Postgres"), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing ofclustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart,but it can be quite a convenient storage space for a small corner shop ora small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -
RE: Re[2]: Oracle vs Mysql
RPT was great stuff. In addition to SELECT statements it could do full DML, DDL, and DCL (I think.) Like Unix it was just particular on who it was friendly with. :-) Then there was RPT2C. Now there's perl. Eschewing the pointy-clicky stuff. -Original Message- Sent: Tuesday, January 20, 2004 10:09 AM To: Multiple recipients of list ORACLE-L The RPT RPF Oracle class was what made me go looking very quickly for a batch Oracle tool. Then I found SQR. (This was all before PL/SQL and the current versions of Oracle Reports). We bought it and the rest was history. Why Oracle didn't buy SQR when they had a chance amazes me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 20, 2004 9:40 AM To: Multiple recipients of list ORACLE-L Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Oracle vs Mysql
Yupp. RPF=report formatter or some such. -Original Message- eric king Sent: Tuesday, January 20, 2004 1:19 PM To: Multiple recipients of list ORACLE-L What RPT and RPF exactly are? Are they some sort of reporting tool? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 11:19 AM RPT was great stuff. In addition to SELECT statements it could do full DML, DDL, and DCL (I think.) Like Unix it was just particular on who it was friendly with. :-) Then there was RPT2C. Now there's perl. Eschewing the pointy-clicky stuff. -Original Message- Sent: Tuesday, January 20, 2004 10:09 AM To: Multiple recipients of list ORACLE-L The RPT RPF Oracle class was what made me go looking very quickly for a batch Oracle tool. Then I found SQR. (This was all before PL/SQL and the current versions of Oracle Reports). We bought it and the rest was history. Why Oracle didn't buy SQR when they had a chance amazes me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 20, 2004 9:40 AM To: Multiple recipients of list ORACLE-L Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: eric king INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: internet secure solutions
Is all SQL*Net traffic between the app server and the database server? In other words, is all traffic secure where packets cannot be sniffed? Or do you need to encrypt the SQL query result set data going from the server to an unknown client? I believe that's what Oracle Advanced Security gives you. If you just want to limit access to the database server and you're using tcp you can put the following entries into the $ORACLE_HOME/network/admin/sqlnet.ora file: TCP.VALIDNODE_CHECKING=yes TCP.INVITED_NODES=(myappserver.mycompany.com,mydbaworkstation.mycompay.c om) Regardless of Oracle implementation, isn't a firewall a mandatory part of the equasion? Steve Orr Bozeman, Montana -Original Message- [EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:29 AM To: Multiple recipients of list ORACLE-L Running Oracle 9i and Solaris 2.9. It appears to me that the solution can be hardware based or Oracle based then. Which brings up questions about cost versus administration versus reliability. Hmmm. -Original Message- Paul Drake Sent: Friday, January 09, 2004 12:49 PM To: Multiple recipients of list ORACLE-L --- [EMAIL PROTECTED] wrote: Guys, Any good doc. on securing data on database on internal network behind firewall with an application server accessing it in the DMZ. I am thinking Advanced security but would appreciate something on this subject. I have stored some documents on security from previous strings but cannot get to my folder do to a system issue. Thanks for any assistance. Hi. how about some OS and database server version info? It wouldn't surprise me if SysAdmin Mag has an article on exactly this. Will more than just OracleNet traffic need to be encrypted? If so, then an ssh tunnel (or some other vpn solution) might make more sense. One method is entirely physical: private network (non-virtual) over additional NICs + crossover cable but that would require that you run a firewall on the server housing the database, as the application server is in an untrusted network. As it circumvents the existing firewall, it could get you fired for violating the site security policy, so it isn't necessarily a good solution. But its one worth considering. I really like using dedicated point to point connections between app server and database server where both servers have dual integrated gigabit cards, no one has coughed up the funds for switched gigabit ethernet ports and one of the integrated gigabit nics is unused (for a fat client/server app). but it does not scale for several hosts. Pd -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
'Twas the Night Before Christmas
'Twas the night before Christmas And all thru the datacenter, Not a virus was stirring, Not even a worm. . . . And if this Saint Nicolas dude Tries to break in our cage, He will be summarily cuffed And we'll get in a rage. . . . So stay away, Leave us alone. No contact by email, Not even by phone. . . . Hackers beware, We don't wanna fight. Others take care, And to all a good night. Security. (Need more lines. What rhymes with datacenter?) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 'Twas the Night Before Christmas
A Computer Christmas 'Twas the night before Christmas, and all through the shop, The computers were whirring; they never do stop. The power was on and the temperature right, In hopes that the input would feed back that night. The system was ready, the program was coded, And memory drums had been carefully loaded; While adding a Christmasy glow to the scene, The lights on the console, flashed red, white and green. When out in the hall there arose such a clatter, The programmer ran to see what was the matter. Away to the hallway he flew like a flash, Forgetting his key in his curious dash. He stood in the hallway and looked all about, When the door slammed behind him, and he was locked out. Then, in the computer room what should appear, But a miniature sleigh and eight tiny reindeer; And a little old man, who with scarcely a pause, Chuckled: My name is Santa...the last name is Claus. The computer was startled, confused by the name, Then it buzzed as it heard the old fellow exclaim: This is Dasher and Dancer and Prancer and Vixen, And Comet and Cupid and Donner and Blitzen. With all these odd names, it was puzzled anew; It hummed and it clanked, and a main circuit blew. It searched in its memory core, trying to think; Then the multi-line printer went out on the blink. Unable to do its electronic job, It said in a voice that was almost a sob: Your eyes - how they twinkle - your dimples so merry, Your cheeks so like roses, your nose like a cherry, Your smile - all these things, I've been programmed to know, And at data-recall, I am more than so-so; But your name and your address (computers can't lie), Are things that I just cannot identify. You've a jolly old face and a little round belly, That shakes when you laugh like a bowlful of jelly; My scanners can see you, but still I insist, Since you're not in my program, you cannot exist! Old Santa just chuckled a merry ho, ho, And sat down to type out a quick word or so. The keyboard clack-clattered, its sound sharp and clean, As Santa fed this data to the machine: Kids everywhere know me; I come every year; The presents I bring add to everyone's cheer; But you won't get anything - that's plain to see; Too bad your programmers forgot about me. Then he faced the machine and said with a shrug, Merry Christmas to All, as he pulled out its plug! Author unknown Please get in touch if you know who to credit -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Career Advice
The question is where do you want to go today? Actually, the question is, Where do you want to go tomorrow? Consult the crystal ball when it comes to career planning. Fixing VCR's may match one's skill set but such service won't be needed much when robots can stamp out new R/W DVD's for $10 a pop. -Original Message- Mladen Gogala Sent: Wednesday, December 17, 2003 2:04 PM To: Multiple recipients of list ORACLE-L On 12/17/2003 03:44:34 PM, Saira Somani-Mendelin wrote: Well, good, now that we have that cleared up. Don't get me wrong, I do like your keen sense of humour and sarcasm - when I know you're joking and at times its hard to tell. Dennis has a point. The question is where do you want to go today? -- Mladen Gogala Oracle DBA -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: connection pooling from an application server to oracle
Correction... Homo sapiens does not have the largest brain in the animal kingdom. Elephants have larger brains and sperm whale brains weigh in at a whopping 20 pounds. So this is not necessarily a case where size matters, it's the spirit within that makes the difference. Of course the size of the cerebral cortex may have something to do with it. ;-) There reason for larger brains in larger animals is the increased need for connection pooling because of the larger size of the nervous system. So you see, even nature recognizes the need for enhanced connectivity requirements. :-) -Original Message- Mladen Gogala Sent: Monday, December 15, 2003 9:24 AM To: Multiple recipients of list ORACLE-L On 12/15/2003 10:54:27 AM, Mercadante, Thomas F wrote: But Mladen, sooner or later, somebody is going to wise-up and catch you in your attempt at passing the blame. When this happens to me, I quote to 80-20 rule. 80% gain in application thruput is brought thru Sql tuning (or rewrite). If they say The database is slow, I say Show me the sql that is slow. If they say I can't because it is coming from the app, i say Then I can't help you. You're very optimistic about your fellow humans. I am not. Homo sapiens sapiens is a funny species. It is bestowed with the largest brain in the animal kingdom and usually very grateful when not forced to use it. As a matter of fact, any excuse is welcome to prevent the little grey cells (here I'm shamelessly stealing from Poirot) from ever getting tired. At any rate, it's politics. I'm trying to achieve something for the benefit of my employer and I'm being obstructed by sleazy sales person aided and abetted by damagement. Chances of them figuring me out are remote. I'm a DBA, I interpret database statistics and it says what I say that it says. There are complications when sleazy sales people bring in their own consultant DBA personnel. Then it is a matter of discrediting the hostile DBA. I have to say that this tactics has to be applied only there where there isn't enough common sense to talk it through with the DBA and make him present the situation as it really is. Those are the places which distrust and fear their own DBAs. That is the first and foremost sign that the damagement has taken over. We, the DBAs hold this truth to be self evident. Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PERL?
class. That means that whatever the pointer is pointing to, becomes a class member. It is exactly like taking a stem and creating an apple or a pear at its end, depending on the need of the moment. Function new doesn't exist. There is no official constructor and there is no official destructor. Destroying objects is based on reference counting which is fast, much faster then Java background garbage collection, but also unreliable because it can be easily prevented. If you want a web version of perl, with a proper syntax and a smaller number of inscrutable undocumented language features, try PHP. On 2003.12.07 22:34, KENNETH JANUSZ wrote: I've read a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PERL?
Title: Message Well I might have disputedyour "almost" dispute until I learned that Perl can run on my Sony PlayStation2 via Linux. (see: http://linux.oreillynet.com/pub/a/linux/2002/03/21/linuxps2.html.) OT: Anyone on the list ever run PlayStation on Linux? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cary MillsapSent: Monday, December 08, 2003 9:00 AMTo: Multiple recipients of list ORACLE-LSubject: RE: PERL? The only thing I think I disagree with is the word almost. Cary MillsapHotsos Enterprises, Ltd.http://www.hotsos.comUpcoming events:- Performance Diagnosis101: 12/16 Detroit, 1/27 Atlanta- SQL Optimization101: 12/8 Dallas, 2/16 Dallas- Hotsos Symposium 2004: March 710 Dallas- Visit www.hotsos.com for schedule details... -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric KingSent: Monday, December 08, 2003 6:39 AMTo: Multiple recipients of list ORACLE-LSubject: Re: PERL? Perl is a full flege programming language, it can do almost anything such as Java or C++ can do. SQL*Plus or Shell is very limited in terms of functionalities. Besides, Perl is portable language. Perl code runs on almost any platforms. - Original Message - From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Sunday, December 07, 2003 22:34 Subject: PERL? I'veread a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. Thanks much, Ken Janusz, CPIM
RE: PERL?
echo s='Perl is portable';print s.replace('Perl','Python')+'
too!'|python
-Original Message-
KENNETH JANUSZ
Sent: Monday, December 08, 2003 9:39 AM
To: Multiple recipients of list ORACLE-L
Then PERL should also run on a TIVO box - it uses Linux.
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 08, 2003 10:24 AM
Well I might have disputed your almost dispute until I learned that
Perl can run on my Sony PlayStation2 via Linux. (see:
http://linux.oreillynet.com/pub/a/linux/2002/03/21/linuxps2.html.)
OT: Anyone on the list ever run PlayStation on Linux?
-Original Message-
Cary Millsap
Sent: Monday, December 08, 2003 9:00 AM
To: Multiple recipients of list ORACLE-L
The only thing I think I disagree with is the word almost.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
Eric King
Sent: Monday, December 08, 2003 6:39 AM
To: Multiple recipients of list ORACLE-L
Perl is a full flege programming language, it can do almost anything
such as Java or C++ can do. SQL*Plus or Shell is very limited in terms
of functionalities.
Besides, Perl is portable language. Perl code runs on almost any
platforms.
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Sunday, December 07, 2003 22:34
I've read a lot about PERL on this list. And, I am wondering what can
you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell
scripts?
Any information will be greatly appreciated.
Thanks much,
Ken Janusz, CPIM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Orr, Steve
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: PERL?
One BIG advantage of Perl is DBI. Via shell you can't use bind variables which sometimes come in handy. An admin dweeb here developed a monitoring shell script that executed 5500 queries an hour each using literals instead of bind variables resulting in shared pool fragmentation and server errors. When the same monitoring was rewritten in Python the load on the server was dramatically reduced. (It could have been done in Perl with the same result.) The usage of literals could have been avoided with PL/SQL but there was also a need for significant file reads, file writes and email so using shell and PL/SQL was cumbersome at best. (Besides, the admin dweeb didn't know PL/SQL.) Another plus is that your oft used routines can be portable between Windoze and *nix. I guess the point is this: Many times you need greater programming power than afforded by shell scripting. If you can easily and productively perform everything that you can do in shell scripting with a complete programming language like Perl or Python then you're one step ahead of the game. Otherwise you may be lamenting limitations. So the remaining challenge is merely learning a programming language that works for you. Steve Orr Bozeman, Montana -Original Message- [EMAIL PROTECTED] Sent: Monday, December 08, 2003 9:14 AM To: Multiple recipients of list ORACLE-L The difference that has affected me the most in writing utility scripts is that PERL can talk to the database like using a telephone. Ksh must talk like using a walkie-talkie; that is, each side of the conversation must talk then release the push-to-talk (PTT) button before the other side can talk. Using a small amount of cleverness (which is good, because that's about how much I have) in ksh, you can program around most of the communication limitations. For example, to deal with sqlplus getting stuck for one reason or the other, you can run the subsection of the script in the background (as a ksh job). Then you check on the job later in the script. If the job is still there longer than it should be, the script can kill the job. THEN, for good measure, look for sqlplus (and possible another ksh that got forked by the script) with parent process ID (PPID) of me and kill them. This is similar to the other side failing to release the PTT button. Unlike PERL, which can maybe yell into to telephone to wake the other side up, ksh must launch an artillery shell onto the other guy which, in a rather violent manner, will cause him to release the PTT button (well ... actually .. the PTT switch kind of got blown up too). Then, depending on the situation, retry the sqlplus or conclude that something is wrong. That being said, ksh is so easy to use and so handy, that I still use it for automating database management and monitoring. I'm sure a big part of that is because I learned shell, sed, awk, etc. programming before perl was standard equipment on Unix boxes. I suppose if you are starting from the beginning, then the way to go would be perl. But you can still do a heck of a lot with ksh (the REAL ksh; not the POS public domain ksh that tends to show up with linux). For an excellent book on getting started with this, go to Amazon and search on Mark G. Sobell (or just Sobell). Here's a tinyurl link to what I think is still must-have book. Even though a lot of it is outdated, the sections on getting around in Unix and shell scripting are still entirely relevant. http://tinyurl.com/y8x6 (Note that the used book sellers are just about giving away the book) There is also a BSD version of the above book. And you want to get O'Reilly's book on Sed and Awk. Those should get you going down the wonderful world of shell scripting .. which is the ORIGINAL, and still great, Rapid Application Development. -Original Message- I've read a lot about PERL on this list. And, I am wondering what can you do with PERL that you cannot do with SQL*Plus, PL/SQL or Unix shell scripts? Any information will be greatly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: dc_used_extents ,dc_free_extents and dc_histogram_defs
Title: Message So I believe your unstated point is that the only thing that needs to be reduced is Mr. E's marketing hype. ;-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Monday, December 08, 2003 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: dc_used_extents ,dc_free_extents and dc_histogram_defsThough there has been an average increase in the total number of init parameter of 83% from versions 7.3.4 - 9.2.0.4, the percentage of tunable/undocumented parameters has gone from 62%/38% in 7.3.4, to 31%/69% in 9.2.0.4. version undoc tunable total %undoc %tunable - 7.3.4 97 158 255 38 62 8.1.7.4 300 204 504 6040 9.2.0.4587 258 845 6931 To achieve the stated goal of 100 tunable parameters in 10g, with an expected growth rate of 30% ( a guesstimate ) or so in the total number of parameters, 10g should look somthing like this: version undoc tunable total %undoc %tunable - 10.0.0 999 100 1099 91 9 ;) Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/08/2003 11:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: dc_used_extents ,dc_free_extents and dc_histogram_defsLarry Ellison has publicly stated that his goal is to produce a database with less then 100 tunable parameters. Allegedly, he came rather close with 10g.As far as 10g is concerned, I'm rather disappointed with the marketing hype being created with oracle not making an early version available. I don't planon migrating to 10g until I learn it well and if some oracle sales guytries to exert pressure on me to migrate, he will get a very stable signused by English archers after the battle at Agincourt to signify that they still have all the fingers needed to operate a longbow. I've had my fill ofwhite papers and articles and now I want to see the software.
RE: Database management techniques and frameworks
in place to monitor changes? How easy is it to deploy this framework? (Does anyone here use Oracle's SNMP agents for monitoring? I've leveraged these -- along with a home-grown SNMP NMS (in Perl) -- to some degree at a multiple database site to good effect.) Are there any 'design patterns for databases' around? Should we come up with some? (I'll post my own notes on the topic of management in a future post -- still compiling.) Adam [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 11:09 AM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject Re: Database management techniques and frameworks We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on windows. I also have development responsibilities, so I dont have time for a checklist. you need to automate tasks. You cant spend your time reading the alert log. you should poll it and get an email when something pops up. Same with chained rows, tablespace sizes, etc... Write scripts for this and send your self emails. Have statspack snapshots run daily. From: [EMAIL PROTECTED] Date: 2003/12/05 Fri PM 01:49:30 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database management techniques and frameworks Folks, I thought it'd be interesting to take a survey on what techniques and frameworks DBA's on this list use to manage their Oracle databases. I imagine that some of us manage only a single database and instance, but in those configurations where there are many instances, multiple databases, different platforms/versions, etc., what are some of the strategies for management in place? What daily tasks do you perform, and how do you organize them? How do you manage user requests (individually or as part of a larger environment)? How do you handle jobs? Organization techniques? Naming standards? User/application deployment framework, etc., etc.? (Obviously we could write a book about this -- there's an idea! -- but summaries and pointers would be interesting. Perhaps we can come up with a best practices document and associated framework for Oracle database management.) Thanks, Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network
RE: rebuilding indexes - sure to cause a ruckus
I think it needs an index. ;-) -Original Message- Paul Baumgartel Sent: Monday, December 08, 2003 3:44 PM To: Multiple recipients of list ORACLE-L somewhat on the longish side??? I'd hate to see a long article! ;-) --- Richard Foote [EMAIL PROTECTED] wrote: Hi Yong, Saying there are a few errors is being a little kind to Don's Inside Oracle Indexing article. In part, these are some of the issues I raised directly with Don in a number of emails (warning somewhat on the longish side ;): -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database management techniques and frameworks
I'm not assuming such a tool exists... It indeed does exist because the salesman who happened to be selling it said so and it must be true. ;-) A former boss saw it, got it (on eval) then tried to get me to use it. Lucky for me I was able to deflect such silliness until the boss was fired. I was also fortunate in that, while some of the Unix dweebs thought the tool was cool, they eventually tired of the scene and I was able to continue with my proven script/monitoring routines. As a happy Bambi below the heavens I did frolic. :-) -Original Message- Mladen Gogala Sent: Monday, December 08, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Here, of course, you're assuming that such a magical GUI, sort of DBA in an ancient oil lamp, tools exist. Well, they do not. Even if you have some useful gooey tools, they do require extensive configuration and customization to become useful and they do require extensive knowledge from the person doing configuration and customization. Other then that, I find it quite questionable how useful it is to fire your own customers and replace them with cheap Elbonian labor. Anyone who has called Oracle support recently knows exactly what I'm talking about. On 12/08/2003 04:44:31 PM, Orr, Steve wrote: No Bambi, No, no, no... This is not what damagement wants. They don't want you to develop your own tools and scripts so they are dependent on you. They want to spent lots of money on a GUI tool they can see and they want a sales drone to show them how easy it is and tell them that anybody can be a DBA if they just had this GUI tool. That way, if they don't like you they can get rid of you and just pluggin another warm body. Sort of like handing a hammer to an unskilled laborer and saying, Here, you are now a master carpenter. By all means stop using that geek stuff like Perl. Stop being subversive to the system by developing your own stuff and use the GUI wizbang tool that damagement likes. -Original Message- Bellow, Bambi Sent: Friday, December 05, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Adam -- I've done this more times than I can count. The answer is it depends on your environment, your desired results, and, more often than not, your corporate structure. Here's some examples: 1) Monitoring script pages DBA group if X happens, Unix group if Y happens, Network group if Z happens. Simultaneously, XTerm windows are popped up in both Operations and HelpDesk with the name and pager number of the person paged (via uucp) 2) Monitoring script sends messages to centralized Error Management System. Error Management System handles it 3) Monitoring script finds problem and corrects problem. If problem continues, email is generated 4) Error Management System has external handles (not APIs) which can be used to call Monitoring Scripts, which need to be modified to ustilize System's internal structures (sometimes written in French -- *that* was fun!) 5) Monitoring script simply sends emails 6) Monitoring script keeps track of the errors in log files which are compared to log files from X time ago and only the differences are reported 7) Monitoring script has redundancy built in such that the first X times a particular problem is encountered, the Monitoring System ignores it, then generates a page 8) Monitoring script has redundnacy built in such that after the first time the problem is encountered, a page is sent, and if there is still a problem 15 minutes later, someone else is paged and so on up the company ladder It goes on and on. This is largely what I've been doing for the past 8 years. Note that the words Monitoring script as used above is generally an inherently complicated conglomeration of several different scripts, generally with a governor and/or one or more driver(s), infrequently on different operating systems, sometimes in multiple languages and/or utilizing, or integrating with, or extending the capabilities of, one or more COTS products, which use different mechanisms to trigger and synchronize them. Generally, there is some kind of IGNORE functionality which allows for specified downtime for maintenance, or ALTERNATE functionality for unusual yet definable situations, and hierarchy of tests (if the database is down, that implies that a subsequent error that a user cannot connect to it has already been dealt with) and, occasionally has sniffers on other boxes to determine whether remote scripts need to be run either dependent upon remote conditions or independent of them. Sometimes, there is a process which kicks off other jobs and manages the security. I particularly enjoy those where there is fault tolerance built in such that if Monitoring script X on Machine Y craps out, Machine Z takes over and runs the scripts until Y is back, then copies the logs back, kicks off Y, make
Copying stats between/amongst schemas
Title: Message 1 database instance, 2 nearly identical schemas. What's the best sanctioned way to copy stats, (including histograms), from one schema to another?
RE: Copying stats between/amongst schemas
I see the schema import/export procedures in the package but they just import/export the stats for a particular schema into or out of the dictionary. There's no procedure to copy stats from one schema to another within the dictionary... At least that's my understanding from reading the docs. -Original Message- Sent: Tuesday, December 02, 2003 4:24 PM To: Multiple recipients of list ORACLE-L dbms_stats is the only sanctioned way to do it. Orr, Steve wrote: 1 database instance, 2 nearly identical schemas. What's the best sanctioned way to copy stats, (including histograms), from one schema to another? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Copying stats between/amongst schemas
Oh... So you exec dbms_stats.export_schema_stats(...) while logged in under the source schema owner user then you exec dbms_stats.import_schema_stats(...) while logged in under the target schema owner user? I wanted to do this under a DBA account which doesn't own anything. alter session set current_schema=Doh / -Original Message- Paul Baumgartel Sent: Tuesday, December 02, 2003 5:34 PM To: Multiple recipients of list ORACLE-L Steve, I've done this: first export the source schema's stats from the dictionary into a user table, then import from that user table into the dictionary for the target schema. (Use CREATE_STAT_TABLE to create the user table.) Paul Baumgartel --- Orr, Steve [EMAIL PROTECTED] wrote: I see the schema import/export procedures in the package but they just import/export the stats for a particular schema into or out of the dictionary. There's no procedure to copy stats from one schema to another within the dictionary... At least that's my understanding from reading the docs. -Original Message- Sent: Tuesday, December 02, 2003 4:24 PM To: Multiple recipients of list ORACLE-L dbms_stats is the only sanctioned way to do it. Orr, Steve wrote: 1 database instance, 2 nearly identical schemas. What's the best sanctioned way to copy stats, (including histograms), from one schema to another? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Uncle Larry, wake up!!!
Can I say I told you so! now? ;) Yeah, I've already sold most of my Oracle stock. :-) The lastest versions of MySQL have been performing quite nicely and their plans to improve transactions are progressing apace. The fact that they are studying Cary's book says something too. DBA's wake up! -Original Message- Sent: Thursday, November 06, 2003 7:04 PM To: Multiple recipients of list ORACLE-L Importance: High Can I say I told you so! now? ;) Goulet, Dick [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/06/2003 02:59 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Uncle Larry, wake up!!! The last statements in the article are really telling: Yet, despite MySQL's progress in the market, we haven't found very much MySQL out there, says Microsoft's Rizzo. That's the best news I could have, retorts Mickos, MYSql AB. As long as Microsoft is in denial, we're fine. Could we add Uncle Larry to the list of those in denial?? MYSQL BREAKS INTO THE DATA CENTER MySQL is changing the nature of the database market with a powerful combination of low cost and high performance. http://www.computerworld.com/databasetopics/data/software/story/0,10801, 85900,00.html Click on the link or copy and paste it into your browser to view the story forwarded to you from Computerworld.com. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: redhat/oracle
Ditto. (But what about OS X? :) Got Oracle9.2 server and client running on my RH9 desktop. Found the following link somewhat informative even though there are some weirdities: http://www.oreillynet.com/lpt/a/4141 Got the RH9 desktop machine a couple of weeks ago but am still struggling to get free of windoze. My desktop only boots redhat but my other computer is a windoze laptop with windoze and redhat 7.2 running under VMWare and I've found it to be too much of a hassle. VMWare is great but the memory requirements for a dual O/S machine, the associated complexities and general slowness were sometimes painful. With the Linux-only machine I haven't missed the MSOffice stuff much. I use the Ximian Evolution interface to MS Exchange. The problems are: MS Outlook rules are only processed when the Outlook client is running; getting calendars; and company distribution lists in Evolution. Because of this I'm still using the laptop just for MS Outlook. I think there's a way to get it to work but haven't gotten to it yet since the futz-factor quotient is up with all this stuff and I have real work that keeps interrupting me. :-) So right now my recommendation to damagement is that all IT employees should have at least 2 or 3 desktop/laptop computers to do their daily work on. Steve -Original Message- Sent: Tuesday, November 04, 2003 12:24 PM To: Multiple recipients of list ORACLE-L As far as I'm concerned, it has already made it. It's my primary desktop at work,with windows for those pesky apps that only run there. I guess I just like a more robust, unix-like os when I have to work on other unix systems all day. ;). The free version of redhat is now called the fedora project. This will continue to be the experimental/desktop version that is along the same line as redhat 8 9 -Brian Boivin, Patrice J wrote: I am still curious to see when linux will make it on the desktop, despite the hype now we know that Red Hat is dropping that initiative. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: interesting article...
Title: Message See the four stepinvestment strategy I laid out in the feedback on the article... It only involves one illegal action. ;-) -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 10:25 AMTo: Multiple recipients of list ORACLE-LSubject: RE: interesting article... it is interesting. but who knows if this person's opinions are correct. should we start "shorting" Oracle stock? -Original Message-From: Chris Stephens [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 08, 2003 11:29 AMTo: Multiple recipients of list ORACLE-LSubject: interesting article... http://www.eweek.com/article2/0,4149,1312906,00.asp
RE: Cary's Book - new topic
So to define response time you must first define response? For acceptance criteria I guess the user has to be specific about what a response is, e.g., when a web app returns a database large result set to a web page, if you have to wait until they entire result set is transmitted to the client the response time would appear to be slower than if you just displayed the rows as they were transmitted. Also, if we are to really address the business case as you suggest then the definition should also include the quality of the response. If the response is quick but incomplete and the user has to ask 10 questions to get at the one real answer he's after then what good is a fast response time? -Original Message- Sent: Tuesday, October 07, 2003 12:09 PM To: Multiple recipients of list ORACLE-L I've got Cary's book for about a week now and I have a comment. On page 12 he defines response time as The elapsed time between the end of an inquiry or demand on a computer system and the beginning of a response; for example, the length of the time between an indication of the end of an inquiry and the display of the first character of the response at a user terminal. I know from the reference provided that he did not create that definition himself. Do you agree with it? I don't. I believe that it depends and that there are cases where the user would define response time as the time from initiating the request until the entire transaction is complete, especially if subsequent work is dependent on the completion. You can easily play the evil genie in these cases by improving the response time such that the first character shows up sooner, yet the last character shows up much later (in the vein of first_rows vs. all_rows), effectively making things worse for the user. So even the definition of response time comes back to the business case. Sometimes the user can continue with the next task as soon as the first pieces of the request arrive, while at other times she can not until the last pieces are complete. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cary's book - Waxing philosophic
In the end... They will remember who you were as a person. Hmmm... Is there a certification test I can take to prove I'm a real live boy. Pinocchio -Original Message- Sent: Friday, October 03, 2003 1:29 PM To: Multiple recipients of list ORACLE-L Since everyone is jumping on this non technical thread I thought I would too... Certainly the first chapter was fresh and brought some aspects of performance tuning into perspective. Specifically keeping a big picture perspectivehow true... in that vein I ask.. Why do we do the work we do...?? Is it because you are good at it and pride yourself on being the alpha-geek? Do you use it as an excuse to hide from society behind a curtain of arcane technology? Are you in it for the money and bennies? The power. Holding all the keys so to speak... Something to keep you busy? Free trips to go to training...? Tote bags, t-shirts, candy and fancy pens from conferences? (My daughter's favorite) Or as Mayo saidI got no place else to go! Whatever the reason Important facts about IT work remain... 1. What you know will be mostly useless in five years. 2. What you are working on now will be mostly replaced or scrapped in five years. 3. You aren't mostly sure if you will still be working here in five years. 4. If you look back at yourself five years ago, you laugh at how silly you were. 5. Five years from now you'll look back and laugh at how silly you were. 6. In five years today's new IT books can bought for 1$. Despite that you get up each morning, go to work, tune SQL queries, set up databases, file TARS, bitch at oracle, bitch at Microsoft, argue with developers, management and run ragged to keep the users happy because heaven forbid if their crappy queries run a second or two slow. We do it because it is good work, for the most part, if we keep things in perspective. (that is my struggle) As Robert said...some battles are best left unfought (or at least given some attention) For me, the most important struggle to remember is the one that defines your life. At the end the worst thing imaginable is to realize a wasted life, one that only enriched your pocket book rather than enriching the lives of others. Experiences passed by because of priorities and some misplaced loyalty to someone or something that makes you work weekends or travel 80% of the time is not healthy. In the end no one will really care or remember that you or I was a DBA. They will remember who you were as a person. Completely understanding the intricacies of database performance rank rather low on my priorities in life (when 80-90% of performance problems are caused by something other than the database). It is refreshing to hear people defining themselves as something other than a DBA...a parent, spouse, friend of cats, dogs and little pigs... Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cary's book
Cary's book, but I have some questions that I want to ask publicly. Recently, I made a comment about Chris Lawson's book being a Dale Carnegie book for a DBA and now I see that Cary is also advising feeding the hungry business users (buy him a sandwich). It is true that many problems are consequences of inadequate communication, general lack of business knowledge in the computer geek culture and even disdain for it, but, in my opinion, many problems are also a consequence of incompetent managers (damagers), office politics, and hard times. Hard times present problems because people do not want to pay for a competent DBA but frequently hire a shaman or a witch doctor who improves on the system based on snake oil type techniques. If I cannot get more money then some bozo after a performance tuning course (example from Chris Lawson's book), why bother reading and investing into myself? A cynical geekish attitude and the old boys network will do just as well. Characteristics of the performance analyst, as described in the book, are the ones of the field general (has the overview of the whole problem, motivates, manages the problem) but performance analysts frequently work for the drill sergeants who mostly care how are they dressed (you guessed it, I hate neckties) and did they show up early enough. Now, after having indulged into lengthy preamble, let's ask the questions: 1) This book is meant for performance analysts. Do you plan on writing one for management, as well? If performance analysts are held back by the damagement,they cannot perform any of the good work you described in your book. You have been both a DBA and a VP, so you have the credibility in both roles. 2) Do you foresee a change for the role of a performance analyst in an organization to be more of a technical manager and less of a computer geek? 3) What will happen to the traditional DBA? Are we an endangered species? Should I be wary of the poachers? Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: x$ constructs and memory
Hi Steve and welcome back, Thanks for that detailed answer BUT... A practical question from the original post remains: What happens when these x$constructs begin to consume large amounts of memory? From your explanation I'm assuming that, beyond monitoring the SGA and PGA, memory consumption of individual X$ in-memory data structures is generally not something we need to worry about. How can we determine how much memory they actually consume? Are there any related tunable parameters of which we should be aware? Thanks, Steve Orr -Original Message- Sent: Monday, September 29, 2003 5:25 PM To: Multiple recipients of list ORACLE-L Hi Daniel and list, There are two types of X$ row sources. X$ tables export in-memory data structures that are inherently tabular, and X$ interfaces that call functions to return data is non-tabular, or not memory resident. For example, the array of structs in the SGA representing processes is exported as the X$ table X$KSUPR. Not all of the struct members are exported as columns, but all of the rows are exported. There is a freelist, implemented as a header that points to the first free slot in the array, and a member of each struct to point to the next free slot. The 'process allocation' latch protects this freelist. The most obvious example of an X$ interface to return non-tabular data is X$KSMSP, which returns one row for each chunk of memory in the shared pool. (There are similar X$ interfaces for other memory heaps). As you may know, heaps are implemented as a heap descriptor and linked list of extents, and within each extent there is a linked list of chunks. So what is done is that when the X$ interface is queried these linked lists are navigated (under the protection of the relevant latch if necessary) an a array is built in the CGA (part of the PGA) from which rows are then returned by the row source. An example of an X$ interface that returns data that is not memory resident is X$KCCLE, which returns one row for each log file member entry in the controlfile. In fact, all the X$KCC* interfaces read data directly from the controlfile. Similarly, the X$KTFB* interfaces return LMT extent information - from the bitmap blocks (for free extents) and from the segment header and extent map blocks (for used extents). Some X$ tables have become X$ interfaces in recent versions, for example X$KTCXB and X$KSQRS. These correspond to the transactions and enqueue resources arrays respectively. The reason is that they are no longer fixed arrays. Instead they are segmented arrays that can be dynamically extended by adding discontiguous chunks of shared pool memory to the array. The freelists and latching for these arrays in unchanged however. All you will notice is that the ADDR column of the X$ output now returns addresses which map into your PGA rather than the SGA. In fact, that is in general a good way to work out whether you are looking at an X$ table or an X$ interface. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.christianity.net.au/ - For all -Original Message- Daniel Fink Sent: Tuesday, 30 September 2003 1:10 AM To: Multiple recipients of list ORACLE-L I was sitting on a mountain here in Colorado, pondering Oracle optimization and an interesting scenario crossed my feeble mind. As I began to ponder this (I asked the resident marmot, but he must be a SQL*Server expert...), I came up with several questions. Where in memory (sga or other) do the x$ constructs reside? Some of them are 'populated' by reading file-based structures (control file, datafile headers, undo segments). Does this information reside in memory or is it loaded each time the x$ construct is accessed? What happens when these x$constructs begin to consume large amounts of memory? Is there an upper bound? Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
RE: RMAN - Compressing using named piped
Title: Message Can you figure out what to name the pipe in advance? Is there a way to reliably determine what file name RMAN will create? -Original Message-From: laura pena [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2003 8:45 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN - Compressing using named piped I am running Oracle 9i R2 and want my RMAN files gzipped to save disk space. Is is possible to either use this new DBMS_PIPE oracle has or just creates a script that uses a namped piped and compresses as rman is performing a backup? If someone has done this before, can you let me know how ? My rman backups are 71g compresed they are 12g. Thanks ahead of time. -Lizz Do you Yahoo!?The New Yahoo! Shopping - with improved product search
RE: x$ constructs and memory
I was sitting on a mountain here in Colorado, pondering Oracle... You are one twisted individual! :-) Here's some SQL for ya: ALTER brain RECOVER STANDBY consciousness CONTINUE UNTIL CANCEL; -Original Message- Sent: Monday, September 29, 2003 9:10 AM To: Multiple recipients of list ORACLE-L I was sitting on a mountain here in Colorado, pondering Oracle optimization and an interesting scenario crossed my feeble mind. As I began to ponder this (I asked the resident marmot, but he must be a SQL*Server expert...), I came up with several questions. Where in memory (sga or other) do the x$ constructs reside? Some of them are 'populated' by reading file-based structures (control file, datafile headers, undo segments). Does this information reside in memory or is it loaded each time the x$ construct is accessed? What happens when these x$constructs begin to consume large amounts of memory? Is there an upper bound? Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: x$ constructs and memory
What happens when these x$constructs begin to consume large amounts of memory? Is there an upper bound? Dan, can you think of a scenario where X$ constructs could consume enough memory that DBA marmots like us should meditate on them? OT: Are there many grizzlies in CO? There are plenty here in MT and I always take my pepper spray with me whenever if go to the mountain top to comtemplate things Oracle and otherwise. Got within 100 yards of one and I saw him but he didn't see me. Steve Orr Bozeman, Montana -Original Message- Sent: Monday, September 29, 2003 9:45 AM To: Multiple recipients of list ORACLE-L You should have asked a grizzly bear. They're much wiser then marmots and they don't run away that easily. Also, when you see a grizzly bear 100ft away from you and realize that you only have a camera with you, then you begin to understand that there are bigger worries in this world then the location of database structures. What a grizzly would tell you is that, according to my sources, those tables are stored in the misc area of shared pool, which can easily be seen when selected * from V$SGASTAT. Here is what a grizzly would have in mind: POOLNAMEBYTES --- -- -- shared pool 1M buffer 2098176 shared pool KGLS heap 4102928 shared pool PX subheap 76920 shared pool parameters 32796 shared pool free memory 101833708 shared pool PL/SQL DIANA 1028660 shared pool FileOpenBlock 3476816 shared pool PL/SQL MPCODE 547852 shared pool library cache30858108 shared pool miscellaneous11656764 shared pool pl/sql source2708 -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Fink Sent: Monday, September 29, 2003 11:10 AM To: Multiple recipients of list ORACLE-L Subject: x$ constructs and memory I was sitting on a mountain here in Colorado, pondering Oracle optimization and an interesting scenario crossed my feeble mind. As I began to ponder this (I asked the resident marmot, but he must be a SQL*Server expert...), I came up with several questions. Where in memory (sga or other) do the x$ constructs reside? Some of them are 'populated' by reading file-based structures (control file, datafile headers, undo segments). Does this information reside in memory or is it loaded each time the x$ construct is accessed? What happens when these x$constructs -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Going to OT with Griz
It's not just any pepper spray but is specially formulated for Griz. Here's what you NEED in Montana: http://www.udap.com/ Last year a hunter was killed by Griz while dressing his elk. Griz has actually learned to head towards gun fire knowing he may find a gut pile left by some hapless hunter. When I go hunting I carry my .44Mag AND pepper spray for close encounters while field dressing my kill. If confronted by Griz I figure my chances are better with the spray. (The .44 is merely for backup on windy days.) My cousin-in-law actually used the spray on griz from 10 feet away and says it was VERY effective. Griz was bouncing off trees as he ran away. Mladen, you ought to take this topic and join us in the Oracle-L OT list. You have a natural talent for it. ;-) http://groups.yahoo.com/group/oracle-l-ot/ Steve Orr Bozeman, Montana -Original Message- Sent: Monday, September 29, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Pepper spray? I would feel much safer with a good Springfield rifle by my side. I'm not sure that a can of pepper spray can stop a 700 lbs animal, charging at 30 MPH, armed with 2 teeth and 5 claws. On short distances, a bear can outrun a deer. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Orr, Steve Sent: Monday, September 29, 2003 12:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: x$ constructs and memory What happens when these x$constructs begin to consume large amounts of memory? Is there an upper bound? Dan, can you think of a scenario where X$ constructs could consume enough memory that DBA marmots like us should meditate on them? OT: Are there many grizzlies in CO? There are plenty here in MT and I always take my pepper spray with me whenever if go to the mountain top to comtemplate things Oracle and otherwise. Got within 100 yards of one and I saw him but he didn't see me. Steve Orr Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle newsgroup
Title: Message You can access it through the Outlook Newsreader via the Tools menu on IE but... you have to have DNS/ISP set up for it and most companies don't give carte blanche to news because of all the other junk out there. ;-) -Original Message-From: AK [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 12:35 PMTo: Multiple recipients of list ORACLE-LSubject: oracle newsgroup How to one subcribe to Comp.database.oracle newsgroup . Can it be added into outlook directly . thanks, -ak
RE: DBA needed in Austin, TX
Title: Message From a cowboy diary as related on the History Channel... "If I owned both Hell and Texas I'd rent out Texas and live in Hell." -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: DBA needed in Austin, TX Nope. It means that it's hot as heck and humid as heck and it makes you wonder why did you turn down that job offer in Anchorage. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mercadante, Thomas FSent: Thursday, September 25, 2003 11:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: DBA needed in Austin, TX ummm.. if it's 100% humidity, doesn't that mean it's raining .. or misting .. or something? I can't imagine it being 100degrees and raining. -Original Message-From: Loughmiller, Greg [mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003 11:25 AMTo: Multiple recipients of list ORACLE-LSubject: RE: DBA needed in Austin, TX dry heat?? Not sure about Austin, butI have some co-workers in Dallas where they say it's 100x100: 100 degrees with 100% humidity... greg -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003 10:05 AMTo: Multiple recipients of list ORACLE-LSubject: RE: DBA needed in Austin, TX I really like that "no DBA left behind" program of yours, but TX is too hot for me. I know it's a dry heat but nevertheless, I do prefer colder climate. You can keep the Dixie Chicks. --Mladen GogalaOracle DBA
RE: guidance
Is that where questions are answered before they are asked? I need a database like that on the stock market. -Original Message- Sent: Wednesday, September 24, 2003 3:55 PM To: Multiple recipients of list ORACLE-L Forget the modern tuning skills and when you're asked what shows the best that your database works optimally; 1) Buffer cache hit ratio is 99% 2) Buffer cache hit ratio is 99,999% 3) Buffer cache hit ratio is 99% 4) Users aren't complaining Then answer 3 for sure ;) Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Cary's book -- Out of stock !
At 1:00PM Seattle time I complained loudly via their online Contact Us form and they got the shipment out before the end of the day and are waiving shipping costs. They tried but were unable to explain why it wasn't shipped out before more recent orders for the same item. They obviously have a bug in their shipping picklist tickler file algorithm. Must have something like ORDER BY order_date DESC... As all DBA's know, everything always comes down to bad SQL. -Original Message- Sent: Monday, September 22, 2003 11:15 PM To: Multiple recipients of list ORACLE-L You got it from the Amazon??? Below is what they replied to me, and I pre-ordered the book on July 13th. I solemnly swear not to order anything from Amazon again, so help me Codd. Of course, the book is available from BN. What is more, Amazon has removed all references to their phone number from their web site, so in case of a problem, you cannot call them. Amazon really sucks! I liked them before because of quick and efficient one click ordering but this is too much. I didn't preorder the book in July to be put on hold by those lying ba***rds. Never again! Subject:Your Amazon.com Order (#102-6863504-6150527) Date: 2003.09.22 22:10 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Thanks for writing to us at Amazon.com. Our latest information indicates that Optimizing Oracle Performance has not yet been released and the expected release date is not known. As soon as a release date has been determined for this item, we will add that information to our web site. While we are confident that copies will be made available, we cannot provide more precise information about the fulfillment of the order. In light of this uncertainty, we will understand if you would prefer to cancel your order. As of yet we have made no changes. * On 2003.09.22 22:44, Freeman Robert - IL wrote: I got my book... I got my book! From Amazon, delivered today! Woo Hoo looks good Cary!! RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Offshore protests
But do we have to beat up people who refuse to join... Or make an offer they can't refuse. ;-) -Original Message- Sent: Monday, September 22, 2003 10:00 AM To: Multiple recipients of list ORACLE-L Definitely steel workers. We are being left to sweat in dark and we frequently get burnt by fire. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of KENNETH JANUSZ Sent: Monday, September 22, 2003 11:30 AM To: Multiple recipients of list ORACLE-L Subject: Re: Offshore protests The labor unions would definitely be interested. Teamsters, Steel Workers, AFSME? Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 22, 2003 10:09 AM We could make a splash by organizing a DBA union. I'm sure that all heads on the Capitol Hill would turn when both members show up with banners, demanding better pay for starved database administrators. What do you think, should we mandate 9i OCP for joining the union? If we were in London, we could have a permanent beer table at the White Heart pub (or is it the Sphere?). We might even encounter Harry Purvis and exchange the union stories. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DENNIS WILLIAMS Sent: Monday, September 22, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Subject: Offshore protests Looks as if tech workers are learning the basics of protesting. http://informationweek.com/story/showArticle.jhtml?articleID=15000146 Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: Cary's book -- Out of stock !
command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone have a copy of DUL ??
Well if they can hack at it with Perl it's not really the tool that's the problem and preventing access to the tool is not a solution. -Original Message- Sent: Thursday, September 18, 2003 10:35 AM To: Multiple recipients of list ORACLE-L One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. How many of you would shout at Cool-Tools for giving away a tool such as this, that your developers can use to hack your data files? ;) Nice idea in concept - huge liability it reality. -Original Message- Rachel Carmichael Sent: 18 September 2003 17:15 To: Multiple recipients of list ORACLE-L 1) it's Field Support not Tech Support that has it 2) Oracle does not sell nor does it release the code for DUL. A field support technician comes to your site, installs it, runs it and removes it. You pay a fee for this. when I used it (in '98), the fee was $5k per every 8 hour period, with a minimum of $10K as the starting fee. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ...
Title: Message Wow! I was atcaully albe to raed taht amolst as fsat as nroaml. I have new funod aprpceaitoin for waht my brian deos for me. -Original Message-From: Sinardy Xing [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 9:50 PMTo: Multiple recipients of list ORACLE-LSubject: ... Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht frist and lsat ltteer is at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit porbelm. Tihs is bcuseae we do not raed ervey lteter by it slef but the wrod as a wlohe. ceehiro
RE: HTML Report Question
Hmmm... Try making this the first line followed by a blank line: Content-Type: text/html Just guessing... -Original Message- Sent: Tuesday, September 09, 2003 7:14 PM To: Multiple recipients of list ORACLE-L Hi DBAs! I am trying to generate an HTML report, and send it through the mail in HTML format. Only one problem...Outlook thinks it's text not html, even though the first line of the report is html. I'm generating the report with... sqlplus -silent -markup HTML ON ...and then using mailx to send the output to my client mailbox. Any suggestions as to how I can make the mail come in as HTML? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: what is a materilized view ?
Philosophically speaking, when the scales fall from the eyes of an idealist and he/she becomes a rationalist, they've adopted a materialized view. ;-) But maybe it only exists if you believe it exists. -Original Message- Sent: Wednesday, September 10, 2003 5:04 AM To: Multiple recipients of list ORACLE-L Dear Freinds, what is a materilized view ? what is the use of it and how to create it. Any docs or notes or white papers will be helpful. TIA, Rajuveera -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent INFO needed.
part of the problem is that very few people can write decent specs - because in any creative process, and software engineering is one, you only converge towards the result through several iterations Good point. If folks speaking the same language aren't communicating well how much more of a challenge is it when there is a language barrier?! Regarding clear specs, here's one of my keeper links about what it takes to write perfect software: http://www.fastcompany.com/online/06/writestuff.html Steve Orr -Original Message- Sent: Wednesday, September 03, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Importance: High I disagree about the 'you get what you pay for'. I have been reviewing in the past weeks code written both in Bangalore and in Paris, and in both cases I have had to reach for my Prozac box. For what had been written in France, it is the product of a big (US) consulting firm which must have been retrospectively happy to change their name a couple of years ago; note that it is in no way specific of them, I can exhibit dreadful code from multiple sources. I can assure you that it was both bad and expensive. Concerning what you pay for, I believe that whatever you outsource is far from being as cheap as it looks like; part of the problem is the existence of a contract, part of the problem is indeed the developers, part of the problem is that very few people can write decent specs - because in any creative process, and software engineering is one, you only converge towards the result through several iterations (just look at famous manuscripts or Old Masters X-ray pictures), and that interaction with end-users is essential. Which means that I agree with the conclusion :-). -- Regards, Stephane Faroult Oriole Software -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: The Coming Job Boom
I was wondering how one performed CPA though... I think some old geezer steered his monstous Cadillac fingers into a wrong turn on the keyboard highway. :-) Peeking over the downhill side of life brings new perspective and I see that we're not getting older, we're just getting wiser. In The Coming Wisdom Boom our accumulated experience will command respect and enhanced compensation. The only downside to this vision is that we'll have to spend time potty training our juniors. Changing junior DBA diapers is a real mess. Now, where did I leave my Leinenkugel medicine? -Original Message- Sent: Friday, August 29, 2003 12:40 PM To: Multiple recipients of list ORACLE-L Oh it's okay... Paula lives in Florida... she has to be more tolerant of old people in their monstrous Cadillacs, driving 40 mph in the passing lane... and snowbirds and bad humor... =) I was wondering how one performed CPA though... April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- Sent: Friday, August 29, 2003 1:24 PM To: Multiple recipients of list ORACLE-L CPR, not CPA. -- Mladen Gogala Oracle DBA -Original Message- Mladen Gogala Sent: Friday, August 29, 2003 2:09 PM To: Multiple recipients of list ORACLE-L Paula, does that mean that the DBA of the future will have to learn how to perform CPA and do a therapeutic massage? I have problems with surgery, except if done on damagement. We'll have to speak louder and be more tolerant to old people in their monstrous Cadillacs, driving 40 mph in the passing lane and not use long beams, horn, our extremities or the combination of the above. -- Mladen Gogala Oracle DBA -Original Message- [EMAIL PROTECTED] Sent: Friday, August 29, 2003 1:54 PM To: Multiple recipients of list ORACLE-L That's nice but what if the companies outsource overseas in response to this concern - hmmm. Still on the up-side they won't be able to do this in all cases and so overall there will likely be a positive demand for DBA skills in relation to the ageing of our Nation. However, how's about (having elderly parents) you are a DBA with experience in the -medical areas The big demand in the workforce will be related to the healthcare industry and spin-offs or retirement issues as the aging population will require this. Interesting to see what it does to our healthcare industry, pharme., medicine. It is insane what the medical profession costs in this country in the face of an aging population with much more and not less need for medical care. Sorry - some O.T. coming up. -Original Message- Sent: Friday, August 29, 2003 12:15 PM To: Multiple recipients of list ORACLE-L Sounds similar to the economic theories of Harry S. Dent, Jr. -- it's all based on birth-rate. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Grabowy, Chris [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 9:31 AM To: Multiple recipients of list ORACLE-L Subject: OT: The Coming Job Boom My apologies for this OT post. There is an article in Business 2.0 magazine, Sept issue, titled The Coming Job Boom that is very interesting. The point of the article is that there will be a labor shortage by 2010 because the Baby Boomer generation will be retiring over the next decade. Obviously, there are critics of these reports but supposedly this is based on demographics, which is supposed to be more reliable. The articles quotes that companies like, Cigna, Intel, SAS, Sprint, Whirlpool, etc. are worried about this problem. Now for the tie into this list...there is a chart that depicts the 10 fastest growing occupations, DBAs are 7th. A 66% increased demand for DBAs by 2010. Software developers are 1st on the chart, with a 100% increase in demand by 2010. So for those of us hurting right now, hang in there. Aside from this article, has anyone else seen articles or reports like these? Below is a link to the article, which requires membership... http://www.business2.com/articles/mag/0,1640,51816,00.html -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Hey Jared!! -90 degree OT Joke
-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to keep root out?
Title: Message By definition, root is all-powerful so if one is entrusted with all power then by extention, said person should be trustworthy. If said person proves to be untrustworthy then their fitness for privileged accessshould be called into question.If said person is not a "team player" with the DBA(s) then their trustworthiness is suspect. "Playing" with stuff outside one's normal realmmay call this into question but there is something to be said for aninquisitive desire to know how things work. Isn't that the nature of our business? If someone really is inquisitive about all things Oracle then you could suggest that they be sent to Oracle DBA training classes. Better yet, suggest a "policy" that no one should not be allowed to touch Oracle unless they are an OCP. Wow, for the first time I just thought of a good reason for the OCP program. :-) I have root access and at first I asked for it to be taken away but I've found myself needing it enough that I'm gladto have it. Part of the problem is that so much software unnecessarily requires root. Fortunately root.sh is all we normally have to do as root for most Oracle install stuff. I work in teamwork with a bunch of top notch SysAdmin pros and we use sudo as much as possible. Having a good team is key. Sometimes you can actually get damagers to help out with this kind of stuff. :-) Steve Orr -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 10:20 AMTo: Multiple recipients of list ORACLE-LSubject: RE: How to keep "root" out? Walter, First question, why are they logging on as "root" in the first place. That is akin to logging into the database as sys all the time, namely something to be avoided at all cost. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Walter K [mailto:[EMAIL PROTECTED]Sent: Thursday, August 28, 2003 11:34 AMTo: Multiple recipients of list ORACLE-LSubject: How to keep "root" out? Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious,is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W
RE: How to keep root out?
Title: Message Yeah but at least it raises the bar significantly. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 2:50 PMTo: Multiple recipients of list ORACLE-LSubject: Re: How to keep "root" out?Importance: HighBut someone determined to get in the database can simply edit sqlnet.ora "Tanel Poder" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/28/2003 10:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: How to keep "root" out?Hi! Put sqlnet.authentication_services = none in your server's sqlnet.ora. Then everyone has to use a password. Tanel. - Original Message - From: Walter K To: Multiple recipients of list ORACLE-L Sent: Thursday, August 28, 2003 6:34 PM Subject: How to keep "root" out? Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W
RE: Hey Jared!!
You're MUCH too merciful! We should start by infecting him or her with worms and viruses of the biologic type. :-) -Original Message- Sent: Tuesday, August 26, 2003 4:09 PM To: Multiple recipients of list ORACLE-L I sure hope so. Then he/she should be publicly tarred Feathered. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, August 26, 2003 4:45 PM To: Multiple recipients of list ORACLE-L I doubt they will ever find the real guy behind this. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 10:19 PM For all you virus/worm lovers out there, justice do come: FBI Subpoenas Arizona ISP In Sobig Probe Easynews says it's cooperating with the bureau to find the person who uploaded the virus to a Usenet group it hosts. informationweek.com/story/showArticle.jhtml?articleID=13800091 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Off Topic Question - Update.inf file
Hey Shrek, that could go both ways... Regarding... ...linux users that are just windows users in disguise. And... someone had installed linux... and he couldn't tell the difference. It depends on your perspective. The above could also be interpreted to mean, There are a lot windoze user that are closet Linux users but just don't know it yet. This is just my misplaced optimism that somehow the MS juggernaut ownership of the desktop could somehow be challenged. I use Gnome and KDE but the shell gives me complete power to do anything I want just like being root on any *nix. You can't say that about the DOS remnant of a command shell with windoze. Regarding Microsoft's macro-hard hegemony, I'm still looking for justice in an unjust world. :-( Steve Orr -Original Message- Sent: Wednesday, August 13, 2003 11:35 AM To: Multiple recipients of list ORACLE-L Joe Testa scribbled on the wall in glitter crayon: Good point, i'm such a bigot as i used linux back when it was minix and have been doing unix admin work for 20 years now ;) joe well, unlike you there are now starting to be a number of linux users that are just windows users in disguise.;-) case in point, duheveloper comes to me with his laptop and tells me his windows oracle doesn't work anymore. someone had installed linux on the laptop with dual boot defaulted to linux running gnome. and he couldn't tell the difference. boot into windows and every thing works fine. -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- Boston Globe job listings
hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- Boston Globe job listings
are. The market has really shrunk in two years! There can't be a huge glut of DBAs out there looking for work... It must be a reduction in demand because companies are not making big infrastructure changes anymore. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- Boston Globe job listings
and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: you can take the user off windows, but... (was RE: Off Topic
...And they're missing so much of the real fun! I'm contemplating a move up to RH9. Anyone get the Oracle client working on it? -Original Message- Sent: Wednesday, August 13, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Topic Apparently those less technical haven't tried building kde3.1 on a RedHat8 box (comes w/3.0), or figuring out how to get Mozilla Firebird compiled on an Alpha RH7.2 box (Firebird rocks, BTW), or even getting the Oracle thin client working w/Perl on Linux. Wait...scratch that last one -- it was easy! :) bin RPMS are for wimps! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Pardee, Roy E [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Subject: you can take the user off windows, but... (was RE: Off Topic Question - Update.inf file) This is an excellent point. Anybody remember when there was (is?) a stigma associated with being an AOL user, as opposed to using a real ISP? AOL made things easy enough that the less adept could 'get on the internet', where they were generally reviled by the old-hands, who were more of a select, 'nerd' elite. My guess is it'll be the same thing as the less technical people start migrating to linux. Cheers, -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, August 13, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Joe Testa scribbled on the wall in glitter crayon: Good point, i'm such a bigot as i used linux back when it was minix and have been doing unix admin work for 20 years now ;) joe well, unlike you there are now starting to be a number of linux users that are just windows users in disguise.;-) case in point, duheveloper comes to me with his laptop and tells me his windows oracle doesn't work anymore. someone had installed linux on the laptop with dual boot defaulted to linux running gnome. and he couldn't tell the difference. boot into windows and every thing works fine. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- Boston Globe job listings
recipients of list ORACLE-L I don't think it has as much to do with no available positions (although that is part of the answer) as most medium to large companies don't use newspaper ads anymore. They are using the internet (especially for technical jobs) and are signed up with Monster, BrassRing, etc. to do their recruiting for them from their own company web sites. I've seen this definite shift here in the Minneapolis / St. Paul, MN area over the past couple of years. Most of these companies also provide e-mail service that sends you an email when a job is posted that meets your specs. So, why waste your time on newspaper ads that only appear every Sunday? My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 14, 2003 6:34 AM I've been keeping an eye on the Boston Globe's Oracle DBA job postings, two years ago it wasn't uncommon to see eight or more per week, now I tend to see one or two, or none. For a while they also announced big IT job fairs, I don't know if they still do that or how successful they now are. The market has really shrunk in two years! There can't be a huge glut of DBAs out there looking for work... It must be a reduction in demand because companies are not making big infrastructure changes anymore. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: OT : Learning curve
Announcing my new book... How to Gain Professional Wisdom and Become an Oracle Sage in Just 24 Hours. -Original Message- Sent: Wednesday, August 06, 2003 4:59 AM To: Multiple recipients of list ORACLE-L I stumbled by chance into the following article http://www.norvig.com/21-days.html which, without being in anyway related to Oracle, will probably ring familiar bells - and what it says about programming could probably be said about administration as well. By the way (and still more OT) I came to this site because of the PowerPoint 'Gettysburgh address' and I was brought there by a reference on Edward Tufte's site (http://www.edwardtufte.com), all of them worth a look if you have imports or installations to run. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: That Veritas thing
Title: Message Thanks for the " rumor gossip" Dick, Is this in reference to the Veritas clustered file systems technology? Or the Veritas Cluster Manager product? Or a file systems manager person? Curiouser and curiouser... -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 9:19 AMTo: Multiple recipients of list ORACLE-LSubject: RE: That Veritas thing Folks, While we're on Veritas's backs, I recently (like Tuesday night) heard from an Oracle employee (to remain nameless) that Orbitz will be issuing a retraction of their claim that their Oracle RAC implementation was the root cause of the outage they had. Seems the true culprit is, guess who, as the file system manager. It is supposedly also causing other problems with non Oracle stuff too. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Michael Kline [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 8:29 PMTo: Multiple recipients of list ORACLE-LSubject: That Veritas thing The database backup is only export. Once in a while they are supposed to be doing a cold backup. Finally found someone that said they can't use the Oracle Veritas agent with Oracle 9.0.2 and Failsafe and/or clustering. They have given them a case number and are working on it. When he brings up the Oracle agent it crashes... Well, that's why we aren't getting any backup... except the export and MAYBE a cold backup once in a while. Thanks list. Michael Alan Kline, Sr.PrincipalConsultantBusiness to Business Solutions, LLCPhone: 804-744-1545 Cell: 804-314-6262ICQ: 1009605, 975313Email: [EMAIL PROTECTED] Web: www.b2bsol.com
RE: 9i-OCP Question
Nah, the answer is 42. :-) -Original Message- Sent: Wednesday, July 30, 2003 11:39 AM To: Multiple recipients of list ORACLE-L I will guess -- 1. - Kirti --- Senthil Kumar [EMAIL PROTECTED] wrote: Hi all, What is the correct answer for this? Q If you have 2 redo log groups with 4 members each, how many disks Q does Oracle recommend to keep the redo log files? 1. 8 2. 2 3. 1 4. 4 Which is the correct answer. TIA Senthil -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Howdy Jeremiah, Based on your testimonial I have given this a try and am beginning to see the coolness of it all. Regarding... There is an emacs OracleSQL mode, but I don't use it. I just start emacs, META-X shell, then sqlplus... I've tried both. Any particular reason for using or not using OracleSQL mode? I've only one complaint, (so far :), the output of SQL statement result sets is slower than just straight SQLPlus. Any way to speed this up? Any way to interrupt the output? AtDhVaAnNkCsE, Steve Orr Bozeman, Montana -Original Message- Sent: Saturday, July 26, 2003 3:09 AM To: Multiple recipients of list ORACLE-L I use SQL*Plus running under emacs shell every day. It is my preferred way of: - Recording my sqlplus sessions so I can go back and search to see what I did - having an up-arrow comand history capability - Having line editing capability - editing SQL scripts in the same window where I am running - everything else I came to prefer emacs because it has capabilities far in excess of vi or any other unix editor. Because it is open source software, many people have contributed over the years, making the package extremely powerful. Also, I started on Vax/VMS edt and eve/tpu, which are more like emacs than vi. There is an emacs OracleSQL mode, but I don't use it. I just start emacs, META-X shell, then sqlplus... -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 25 Jul 2003, Orr, Steve wrote: I agree with the developer vs. sysadmin generalization but this was not meant to be a post about favorite editors... It's about whether anyone has used or seen a SQLPlus shell running under emacs. Has anyone witnessed SQLPlus running under a well-configured emacs session and have impressions to share? The statistics I've heard are that 9 out of 10 SysAdmin/DBA's use vi. I wonder what the breakdown is for Linux admins? Since emacs is easy to implement I could see it gaining ground on Linux but sometimes old dinosaur type SysAdmins are slow to evolve. :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Emacs on SQLPlus, er uh... SQLPlus on emacs.
vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
I agree with the developer vs. sysadmin generalization but this was not meant to be a post about favorite editors... It's about whether anyone has used or seen a SQLPlus shell running under emacs. Has anyone witnessed SQLPlus running under a well-configured emacs session and have impressions to share? The statistics I've heard are that 9 out of 10 SysAdmin/DBA's use vi. I wonder what the breakdown is for Linux admins? Since emacs is easy to implement I could see it gaining ground on Linux but sometimes old dinosaur type SysAdmins are slow to evolve. :-) Steve Orr-asaurus, with apologies to Don G. -Original Message- Sent: Friday, July 25, 2003 2:24 PM To: Multiple recipients of list ORACLE-L massive generalization It seems like DBAs that use Emacs over vi (emacs vs. vi being the classic UNIX holy war) tend to be people who were introduced to UNIX by being either a developer or an end-user. If a DBA favors vi over emacs, it seems that they generally come from a sysadmin background. That's how I ended up a vi user - none of the systems I was ever working on could be counted to have any editor OTHER than vi. For better or worse, its the ubiquitous UNIX text editor. /massive generalization Of course, there are those who use notepad + ftp Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Orr, Steve Sent: Friday, July 25, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Job to run first Wednesday
') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Recent reports on outages caused by DB2 and 9iRAC issues
http://theregister.co.uk/content/archive/30095.html and http://www.danskebank.com/link/ITreport20030403uk/$file/ITreport200304 03 uk.pdf Report on Orbitz blaming an outage on Oracle's 9iRAC [and Orbitz going out of 9iRAC] http://www.eweek.com/article2/0,3959,1196879,00.asp and http://www.computerworld.com/databasetopics/data/software/story/0,1080 1, 83186,00.html Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: oracle10g
Title: Message 10 to the googol power. Pop Quiz... How many goose eggs is that?! -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 1:45 PMTo: Multiple recipients of list ORACLE-LSubject: oracle10g Gotta love oracle. It won't be 10i, it'll be Oracle10g what on earth are they thinking? http://www.oracle.com/oracleworld/paris/conference/
RE: Recent reports on outages caused by DB2 and 9iRAC issues
Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: * Sr. Oracle DBA with 8i and 9i experience needed..
, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the strength of the DBA staff. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please Use Job Code: Minn./DBA/MH Phone: 1-800-549-8502. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Datafiles on SAN?
Has any rolled their own SAN? We've got a bunch of stuff on EMC but now we're looking to build our own fibre channel SAN and replace EMC NFS with clustered file systems. (Of course Oracle is not on NFS.) Disk may be cheap but vendor SAN boxes are not. Steve Orr Bozeman, MT -Original Message- Sent: Tuesday, July 15, 2003 11:24 AM To: Multiple recipients of list ORACLE-L Hundreds, nay, thousands put their datafiles on SAN. All love it. All would trade their children for more SAN storage. None have ever had a problem. :) Seriously, though, some huge percentage of storage being configured today is SAN and a big chunk of that is database storage. It by and large works fine, in that its just as good as SCSI-attached, only generally faster and you can put the array farther away from the host :) The gotchas tend to come up in more complex environments with things like combining multiple san vendors, different operating systems, remote replication, snapshots, etc. etc. But just hooking up hosts to fibre channel storage and sending commands tends to go off flawlessly. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Levatich Sent: Tuesday, July 15, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Subject: Datafiles on SAN? Is anyone putting datafiles on SAN storage? Success? Horror?Tell me a story. ~ Tim Levatich, Database Administrator Cornell Laboratory of Ornithology, 159 Sapsucker Woods Road, Ithaca, New York 14850 [EMAIL PROTECTED]phone 607-254-2113fax 607-254-2415 http://birds.cornell.eduhttp://birdsource.cornell.edu ~ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Levatich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Datafiles on SAN?
Gadzoox!! www.gadzoox.com -Original Message- Sent: Tuesday, July 15, 2003 11:19 AM To: Multiple recipients of list ORACLE-L I have them... one of the things that I can tell you is that... sometimes (at least here at work) the ports switches fail and you lost your connectivity to your filesystems... it does not mean that your database goes down... just have to reassign your LUNs to another SP processor and that's it... anyway, in my case I lost about 30 mins (the time to detect/reassign/correct the problem)... fortunately was a test database... I would like to help/comment you more, but, that's what we have seem until now.! HTH JL --- Tim Levatich [EMAIL PROTECTED] wrote: Is anyone putting datafiles on SAN storage? Success? Horror?Tell me a story. ~ Tim Levatich, Database Administrator Cornell Laboratory of Ornithology, 159 Sapsucker Woods Road, Ithaca, New York 14850 [EMAIL PROTECTED]phone 607-254-2113fax 607-254-2415 http://birds.cornell.edu http://birdsource.cornell.edu ~ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Levatich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Datafiles on SAN?
Last year a U-Haul drove up to the parking lot and some guy came in saying he had big computer stuff in there and we had to get it out. (I think he was a FedX employee.) It turns out it was a NetApp for demo so we rolled it into our little local data center. After lot's of phone calls and even a couple of visits from NetApp engineers we were never able to get decent performance. It seems that NFS/Linux was a little flaky. Maybe things have improved but once bitten... Here's a post I made to this list back then: --- Nattering Nebobs of [Netapp] Negativity We've been testing a toaster we got on eval and surprise, surprise, we are having problems with performance of all things. The plan was to import a copy of some production data and load test with an in house webstress script but we haven't even gotten that far because the import is noticeably SLOOWWWERRR. We have a dedicated 1Gbit connection between the toaster and the server. As an experiment I mounted a toaster file system on another server with only a 100Mbit pipe and the import wasn't nearly so slow. Obviously there's a network performance issue and NetApp support has tried to help our sysadmin/network gurus but no resolution yet. With input from NetApp support I've been playing with the NFS mount settings for UDP vs TCP protocols, rsize/wsize, hardware flow control etc. ad nauseum to no avail. We have a fairly recent yet mainstream versions of Linux and Oracle 8i and 9i. I got a white paper from the NetApp folks and it talks about the difficulty of NFS implementations on that weird Linux open source stuff. ;-) Here's a precious quote, Currently, there is no professionally maintained knowledge base that tracks Linux NFS client issues. And here's my favorite: If you find there are missing features or performance or reliability problems, let us encourage you to participate in the community development process. Like, WOW!!! ...That speaks volumes doesn't it? Why have the added risk of NFS/NAS/network support when you can just get a proven SAN solution? I'll let you know if NetApp support comes through on this. Spiro --- -Original Message- Sent: Tuesday, July 15, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Well, you can run Oracle over Netapp NFS, which is far superior to EMC's Celerra (their NFS product), except in a few niche features. By the way, Netapp just released their FAS250 low-end filer - up to 1TB usable in 3U, pretty speedy, and damn cheap. Rolling your own SAN is certainly doable, but Fibre Channel is fraught with implementation and interop problems. If you're set on doing it, get someone who's done SAN implementations before to oversee it, and get _written_ signoff from each vendor you're using that they'll guarantee interop. Then test the heck out of it. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Orr, Steve Sent: Tuesday, July 15, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: Datafiles on SAN? Has any rolled their own SAN? We've got a bunch of stuff on EMC but now we're looking to build our own fibre channel SAN and replace EMC NFS with clustered file systems. (Of course Oracle is not on NFS.) Disk may be cheap but vendor SAN boxes are not. Steve Orr Bozeman, MT -Original Message- Sent: Tuesday, July 15, 2003 11:24 AM To: Multiple recipients of list ORACLE-L Hundreds, nay, thousands put their datafiles on SAN. All love it. All would trade their children for more SAN storage. None have ever had a problem. :) Seriously, though, some huge percentage of storage being configured today is SAN and a big chunk of that is database storage. It by and large works fine, in that its just as good as SCSI-attached, only generally faster and you can put the array farther away from the host :) The gotchas tend to come up in more complex environments with things like combining multiple san vendors, different operating systems, remote replication, snapshots, etc. etc. But just hooking up hosts to fibre channel storage and sending commands tends to go off flawlessly. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Levatich Sent: Tuesday, July 15, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Subject: Datafiles on SAN? Is anyone putting datafiles on SAN storage? Success? Horror?Tell me a story. ~ Tim Levatich, Database
RE: ROWNUM is driving me nuts - queries suggested produced no res
just what is it you want to return in your query? If the query results are to be displayed a chunk at a time on a web page then you should give strong consideration to using OCI and implementing scrollable cursors with the OCIStmtFetch2() function and its OCI_FETCH_NEXT, OCI_FETCH_PRIOR, OCI_FETCH_FIRST, OCI_FETCH_LAST, OCI_FETCH_ABSOLUTE orientation parameters and nrows parameter. This is Oracle9i only. With Oracle8i you can use OCI_FETCH_NEXT with nrows but you can't go backwards. Oracle recommends migrating all OCIStmtFetch() calls to OCIStmtFetch2() calls. Steve Orr Bozeman, Montana -Original Message- Sent: Wednesday, July 09, 2003 10:35 AM To: Multiple recipients of list ORACLE-L res MaryAnn, the best way to understand rownum is to do the following: SQL SELECT ROWNUM, GENDER 2 FROM (SELECT ROWNUM, GENDER 3 FROM EMP2 4 WHERE ROWNUM = 20) You will quickly see that, no matter how you order the result set, the first record returned is rownum #1, second is rownum #2 etc. The rownum value is assigned as rows are RETURNED or DISPLAYED, not as they are selected. when you run your original query: SQL SELECT ROWNUM, GENDER 2 FROM (SELECT ROWNUM, GENDER 3 FROM EMP2 4 WHERE ROWNUM = 20) 5 WHERE ROWNUM 10; you should *not* get any rows because the first row returned has a value of 1 - hece you get nothing. the next row returned gets the value of 1 - again, nothing gets shown. just what is it you want to return in your query? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 09, 2003 12:19 PM To: Multiple recipients of list ORACLE-L results I definitely dont fully understand ROWNUM yet, and you guys so far provided more info than a couple of books by Oracle, that I have here. For a second I thought I'm beginning to get it, but the queries suggested produced no results... SQL SELECT ROWNUM, GENDER 2 FROM (SELECT ROWNUM, GENDER 3 FROM EMP2 4 WHERE ROWNUM = 20) 5 WHERE ROWNUM 10; no rows selected SQL SELECT r, GENDER 2 FROM (SELECT ROWNUM r, GENDER 3 FROM EMP2 4 WHERE ROWNUM = 20) 5 WHERE ROWNUM 10; no rows selected SQL SELECT r ROWNUM, GENDER 2 FROM (SELECT ROWNUM r, GENDER 3 FROM EMP2 4 WHERE ROWNUM = 20) 5 WHERE ROWNUM 10; no rows selected SQL ... so, any help is appreciated - rownum is driving me nuts... thx maa __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Do Not Call
There have been over 10,000,000 entries made in the National Do Not Call Registry since Friday June 27. Does anyone know the database engine in which this is stored? Curious in Bozeman, MT -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do Not Call
Nah... Too current. It's probably COBOL/ISAM. -Original Message- Sent: Tuesday, July 01, 2003 1:15 PM To: Multiple recipients of list ORACLE-L Probably MS Access. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 12:59 PM There have been over 10,000,000 entries made in the National Do Not Call Registry since Friday June 27. Does anyone know the database engine in which this is stored? Curious in Bozeman, MT -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tech meetings
Title: Message Sounds like that meeting was missing the middle letter "A." -Original Message-From: Johnston, Tim [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 12:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Tech meetings We had these at the last place I was at... The senior folks from the various teams would get together... One person or group was designated to present a topic for the next meeting... Neat idea but it failed at that location... The reason? The VP of App Dev decided he wanted to attend the meetings... Which meant we spent every meeting teaching him the basics and never really getting to the good stuff... It ended up being a huge waste of time for the majority of the people in the room... Tim -Original Message-From: M.Godlewski [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 01, 2003 12:30 PMTo: Multiple recipients of list ORACLE-LSubject: Tech meetings List, Just wondering if your organization has tech meetings, and what is discussed and what the goals of the meetings are? I've been asked about this, and was wondering if there is a quick list out there any where. TIA Do you Yahoo!?The New Yahoo! Search - Faster. Easier. Bingo.
RE: Tech meetings
Title: Message The best meetings should be like the most efficient SQL statements... ;-) -Original Message-From: M.Godlewski [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 10:30 AMTo: Multiple recipients of list ORACLE-LSubject: Tech meetings List, Just wondering if your organization has tech meetings, and what is discussed and what the goals of the meetings are? I've been asked about this, and was wondering if there is a quick list out there any where. TIA Do you Yahoo!?The New Yahoo! Search - Faster. Easier. Bingo.
RE: how to find folder size in unix
What's a folder? GUI's? We don't need no stinkin' GUI's! -Original Message- Sent: Thursday, June 26, 2003 8:00 AM To: Multiple recipients of list ORACLE-L Didn't they tell you that the size doesn't matter, it's the magic in the folder? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 7:00 AM To: Multiple recipients of list ORACLE-L how to find folder size in unix -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle ambushes Peoplesoft with $5.1bn bid
Title: RE: Oracle ambushes Peoplesoft with $5.1bn bid Hmmm... sell short or buy hoping IBM ups the ante? -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 10:30 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle ambushes Peoplesoft with $5.1bn bid Quite frankly, I don't believe that the offer is serious. It's only 6% above the Friday closing price and it has already propelled the PeopleSoft's stock to $18.60 which is far beyond Oracle's offer. In case that those two do merge, I would be interested in the new names. How about "Power to PeopleSoft initiative" or "Pythia initiative"? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 12:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle ambushes Peoplesoft with $5.1bn bid Raj, Good point. People Soft does all of their development work on M$ Sql Server and it's one of their supported platforms. IBM would have a similar desire since you know that once People Soft becomes part of Oracle support for non Oracle DB's will die. Actually according to the press release People Soft will become Oracle E-Business suite. That's why I characterize this as a whale swallowing another whale. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Friday, June 06, 2003 11:10 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle ambushes Peoplesoft with $5.1bn bid I wonder when Micto$oft will step in with a counter offer ... imagine what will this do to their CRM market share dream ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Goulet, Dick [mailto:[EMAIL PROTECTED]] Sent: Friday, June 06, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle ambushes Peoplesoft with $5.1bn bid OK, This is one WHALE swallowing act that I just HAVE to watch!! This is akin to McDonalds acquiring Burger King and Wendy's in one fell swoop!! Wonder what this will do to pricing and support costs??? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA
RE: HP OpenView
- Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
??? Linux/Oracle 8.1.7 2GB file size limit ???
I've just been informed that there is a 2GB datafile size limit with Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files in excess of this for some time and they work just fine. The problem occurs when the autoextend feature reaches the 2GB threshhold. Of course, Oracle didn't tell me this until after about 4 days of back and forth testing for them. (There is no such O/S file size limit.) I've reviewed the Linux release notes, the Linux install guide, the Linux admin guide and the contents of $ORACLE_HOME/relnotes and I don't find any such limitation in the documentation. Did I miss it? Can anyone find any such published limitation in the docs? Is this a secret? Peeved at Oracle... AGAIN, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
See my note: There is no such O/S file size limit. We have datafiles 2GB which work just fine. The problem is with autoextending datafiles that extend from 2GB to 2GB. It's not a Linux limitation but a limitation imposed by Oracle's implementation on Linux. Oracle 9i on Linux doesn't have this problem. And my peeve is that it took OWS 4 days to discover this limit. Still peeved, :-) Steve -Original Message- Sent: Wednesday, June 04, 2003 10:55 AM To: Multiple recipients of list ORACLE-L I think it is the limitation of Linux, not Oracle. Use LVM and don't worry about file size limit. :-) JP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 5:40 PM I've just been informed that there is a 2GB datafile size limit with Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files in excess of this for some time and they work just fine. The problem occurs when the autoextend feature reaches the 2GB threshhold. Of course, Oracle didn't tell me this until after about 4 days of back and forth testing for them. (There is no such O/S file size limit.) I've reviewed the Linux release notes, the Linux install guide, the Linux admin guide and the contents of $ORACLE_HOME/relnotes and I don't find any such limitation in the documentation. Did I miss it? Can anyone find any such published limitation in the docs? Is this a secret? Peeved at Oracle... AGAIN, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
NICE! Thanks. -Original Message- Sent: Wednesday, June 04, 2003 11:57 AM To: Multiple recipients of list ORACLE-L It's a combo problem between oracle and linux. When Linux first implemented largefile support, many of the traditional linux apps were not aware of the concept of 2GB files and were using 32-bit offsets for file pointer storage. So, as a workaround, 32- and 64-bit versions of the various file operation calls were made to specify whether a 32-bit or 64-bit offset should be returned, as well as specifying a flag O_LARGEFILE that could be sent to the traditional open() that indicated the application was largefile aware. When an application is compiled, you can specify to the compiler that you want it to be 64-bit aware and the 64-bit versions of things like open and seek will be used, or the code can use the O_LARGEFILE flag in open(). The end result of this is that while linux is 2GB aware, oracle 8.1.7 is not quite entirely. I bet that the chunk of code that opens a datafile for traditional access in 8.1.7 is 64-bit aware, while the code that grows the file is not. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Pruner Sent: Wednesday, June 04, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ??? I think it is the limitation of Linux, not Oracle. Use LVM and don't worry about file size limit. :-) JP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 5:40 PM I've just been informed that there is a 2GB datafile size limit with Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files in excess of this for some time and they work just fine. The problem occurs when the autoextend feature reaches the 2GB threshhold. Of course, Oracle didn't tell me this until after about 4 days of back and forth testing for them. (There is no such O/S file size limit.) I've reviewed the Linux release notes, the Linux install guide, the Linux admin guide and the contents of $ORACLE_HOME/relnotes and I don't find any such limitation in the documentation. Did I miss it? Can anyone find any such published limitation in the docs? Is this a secret? Peeved at Oracle... AGAIN, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Thanks Branimir for confirming my right to be peeved. :-) I never liked the autoextend feature but we use it because: 1) We have this nifty end user driven feature where they can clone their data via a nice web GUI interface. (This is for web site upgrades scheduled by the end user.) 2) We don't want the user to decide how much disk storage to allocate so we let the datafiles autoextend. 3) As the DBA/DUHveloper (Python/CGI) who bequeathed certain DBA functions to the GUI interface, I depended on autoextend working and was too lazy to algorithm-ize the number of datafiles based on current storage needs. 4) Upon self-chastizement I'm undoing the autoextend feature and am now going to dba_segments to develop a capacity planning algorithm. Developing DBA automation tools driven via events and end user input is a fun and wild ride on the margin of DBA fiefdom. Commiserating with my DBA buddy Walt, Help... we're losing control and we hate giving up 'power.' :-) Staring out the window at the mountains in Big Sky Country, Steve -Original Message- Sent: Wednesday, June 04, 2003 11:25 AM To: Multiple recipients of list ORACLE-L I'd say file size limit/autoextend feature has been Oracle's dirty little secret for quite a while. For a very long period of time there was similar 4GB 'magic' barrier on Windows, that was allegedly fixed. Workaround for the problem was to create datafile 1 MB larger than the 'magic' number, and ether resize it using this trick or add another datafile to tablespace when the time comes (whenever MagicNumber or N x MagicNumber is close). Despite rumours (of having fixed autoextend feature on Windows) I recently witnessed failed imports into Oracle 9.2.0.1.0 caused by too small tablespaces that just wouldn't autoextend. Interestingly, import died beautifully cuz silently in the middle of job without _any_ errors, traces etc. Just gone. There is also interesting myth here at the place where I work that systems tablespace autoextend feature ain't to be trusted as it is known to have caused intermittent data dictionary corruptions while code recompilation takes place under space crunch conditions... On slightly cynical side note: autoextend that doesn't - maps nicely into job safety ;-) Branimir -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED] Sent: June 4, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Subject: ??? Linux/Oracle 8.1.7 2GB file size limit ??? I've just been informed that there is a 2GB datafile size limit with Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files in excess of this for some time and they work just fine. The problem occurs when the autoextend feature reaches the 2GB threshhold. Of course, Oracle didn't tell me this until after about 4 days of back and forth testing for them. (There is no such O/S file size limit.) I've reviewed the Linux release notes, the Linux install guide, the Linux admin guide and the contents of $ORACLE_HOME/relnotes and I don't find any such limitation in the documentation. Did I miss it? Can anyone find any such published limitation in the docs? Is this a secret? Peeved at Oracle... AGAIN, Steve Orr -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Well... datafiles 2GB seem to work okay but since Oracle is being a weenie about supporting them altogether I'm choosing not to. One of the first hoops OWS had me jump thru in the wild goose chase was to manually extend datafiles via maxsize without using unlimited. Eventually the only workarounds suggested by Oracle were: 1) turn off autoextend and manually add datafiles; 2) upgrade to 9i. -Original Message- Sent: Wednesday, June 04, 2003 12:10 PM To: Multiple recipients of list ORACLE-L Steve - are you saying that there is a workaround by increasing the size of the file manually to something larger than 4G? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, June 04, 2003 1:25 PM To: Multiple recipients of list ORACLE-L See my note: There is no such O/S file size limit. We have datafiles 2GB which work just fine. The problem is with autoextending datafiles that extend from 2GB to 2GB. It's not a Linux limitation but a limitation imposed by Oracle's implementation on Linux. Oracle 9i on Linux doesn't have this problem. And my peeve is that it took OWS 4 days to discover this limit. Still peeved, :-) Steve -Original Message- Sent: Wednesday, June 04, 2003 10:55 AM To: Multiple recipients of list ORACLE-L I think it is the limitation of Linux, not Oracle. Use LVM and don't worry about file size limit. :-) JP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 5:40 PM I've just been informed that there is a 2GB datafile size limit with Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files in excess of this for some time and they work just fine. The problem occurs when the autoextend feature reaches the 2GB threshhold. Of course, Oracle didn't tell me this until after about 4 days of back and forth testing for them. (There is no such O/S file size limit.) I've reviewed the Linux release notes, the Linux install guide, the Linux admin guide and the contents of $ORACLE_HOME/relnotes and I don't find any such limitation in the documentation. Did I miss it? Can anyone find any such published limitation in the docs? Is this a secret? Peeved at Oracle... AGAIN, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Yeah, now I call it the outta-extend feature. :-) -Original Message- Sent: Wednesday, June 04, 2003 12:28 PM To: '[EMAIL PROTECTED]' Cc: Orr, Steve nice. either way, you're screwed into doing more work than you had planned. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, June 04, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Well... datafiles 2GB seem to work okay but since Oracle is being a weenie about supporting them altogether I'm choosing not to. One of the first hoops OWS had me jump thru in the wild goose chase was to manually extend datafiles via maxsize without using unlimited. Eventually the only workarounds suggested by Oracle were: 1) turn off autoextend and manually add datafiles; 2) upgrade to 9i. -Original Message- Sent: Wednesday, June 04, 2003 12:10 PM To: Multiple recipients of list ORACLE-L Steve - are you saying that there is a workaround by increasing the size of the file manually to something larger than 4G? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, June 04, 2003 1:25 PM To: Multiple recipients of list ORACLE-L See my note: There is no such O/S file size limit. We have datafiles 2GB which work just fine. The problem is with autoextending datafiles that extend from 2GB to 2GB. It's not a Linux limitation but a limitation imposed by Oracle's implementation on Linux. Oracle 9i on Linux doesn't have this problem. And my peeve is that it took OWS 4 days to discover this limit. Still peeved, :-) Steve -Original Message- Sent: Wednesday, June 04, 2003 10:55 AM To: Multiple recipients of list ORACLE-L I think it is the limitation of Linux, not Oracle. Use LVM and don't worry about file size limit. :-) JP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 5:40 PM I've just been informed that there is a 2GB datafile size limit with Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files in excess of this for some time and they work just fine. The problem occurs when the autoextend feature reaches the 2GB threshhold. Of course, Oracle didn't tell me this until after about 4 days of back and forth testing for them. (There is no such O/S file size limit.) I've reviewed the Linux release notes, the Linux install guide, the Linux admin guide and the contents of $ORACLE_HOME/relnotes and I don't find any such limitation in the documentation. Did I miss it? Can anyone find any such published limitation in the docs? Is this a secret? Peeved at Oracle... AGAIN, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
As per Branimer's previous post, try searching under dirty little secrets. :-) -Original Message- Sent: Wednesday, June 04, 2003 1:30 PM To: Multiple recipients of list ORACLE-L Steve - Is there a Metalink note on this? What would a person search for? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 12:25 PM To: Multiple recipients of list ORACLE-L See my note: There is no such O/S file size limit. We have datafiles 2GB which work just fine. The problem is with autoextending datafiles that extend from 2GB to 2GB. It's not a Linux limitation but a limitation imposed by Oracle's implementation on Linux. Oracle 9i on Linux doesn't have this problem. And my peeve is that it took OWS 4 days to discover this limit. Still peeved, :-) Steve -Original Message- Sent: Wednesday, June 04, 2003 10:55 AM To: Multiple recipients of list ORACLE-L I think it is the limitation of Linux, not Oracle. Use LVM and don't worry about file size limit. :-) JP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 5:40 PM I've just been informed that there is a 2GB datafile size limit with Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files in excess of this for some time and they work just fine. The problem occurs when the autoextend feature reaches the 2GB threshhold. Of course, Oracle didn't tell me this until after about 4 days of back and forth testing for them. (There is no such O/S file size limit.) I've reviewed the Linux release notes, the Linux install guide, the Linux admin guide and the contents of $ORACLE_HOME/relnotes and I don't find any such limitation in the documentation. Did I miss it? Can anyone find any such published limitation in the docs? Is this a secret? Peeved at Oracle... AGAIN, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
It doesn't seem to be a problem on other platforms... Just when I stopped feeling like a neglected step child for running on Linux. Don't worry... Be happy... There's a workaround... Upgrade and buy more software... D'ai jobu desu... er, eh, Ca ne fais rien. -Original Message- Sent: Wednesday, June 04, 2003 12:46 PM To: Multiple recipients of list ORACLE-L This almost sounds like the problem that existed for Oracle 7.3 and the 2G threshold a couple of years ago... J'ai une impression d'avoir déjà vu ceci. : ) Patrice. -Original Message- Sent: Wednesday, June 04, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Steve - are you saying that there is a workaround by increasing the size of the file manually to something larger than 4G? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, June 04, 2003 1:25 PM To: Multiple recipients of list ORACLE-L See my note: There is no such O/S file size limit. We have datafiles 2GB which work just fine. The problem is with autoextending datafiles that extend from 2GB to 2GB. It's not a Linux limitation but a limitation imposed by Oracle's implementation on Linux. Oracle 9i on Linux doesn't have this problem. And my peeve is that it took OWS 4 days to discover this limit. Still peeved, :-) Steve -Original Message- Sent: Wednesday, June 04, 2003 10:55 AM To: Multiple recipients of list ORACLE-L I think it is the limitation of Linux, not Oracle. Use LVM and don't worry about file size limit. :-) JP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 5:40 PM I've just been informed that there is a 2GB datafile size limit with Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files in excess of this for some time and they work just fine. The problem occurs when the autoextend feature reaches the 2GB threshhold. Of course, Oracle didn't tell me this until after about 4 days of back and forth testing for them. (There is no such O/S file size limit.) I've reviewed the Linux release notes, the Linux install guide, the Linux admin guide and the contents of $ORACLE_HOME/relnotes and I don't find any such limitation in the documentation. Did I miss it? Can anyone find any such published limitation in the docs? Is this a secret? Peeved at Oracle... AGAIN, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
We are on 8.1.7.4 and it aflicted us anyway. Maybe I'll just wait a couple of years and let other customers QA this Oracle feature until they get it right. Steve -Original Message- Sent: Wednesday, June 04, 2003 2:35 PM To: Multiple recipients of list ORACLE-L Ahem . . . according to Note 112011.1, these problems can affect all platforms except OS/390 which does NOT support datafile resizing (fiendishly clever those mainframe types). It looks like 8.1.7.4 and above is not affected. I would highly recommend that all Oracle DBAs take a look at this note. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 3:00 PM To: Multiple recipients of list ORACLE-L It doesn't seem to be a problem on other platforms... Just when I stopped feeling like a neglected step child for running on Linux. Don't worry... Be happy... There's a workaround... Upgrade and buy more software... D'ai jobu desu... er, eh, Ca ne fais rien. -Original Message- Sent: Wednesday, June 04, 2003 12:46 PM To: Multiple recipients of list ORACLE-L This almost sounds like the problem that existed for Oracle 7.3 and the 2G threshold a couple of years ago... J'ai une impression d'avoir déjà vu ceci. : ) Patrice. -Original Message- Sent: Wednesday, June 04, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Steve - are you saying that there is a workaround by increasing the size of the file manually to something larger than 4G? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, June 04, 2003 1:25 PM To: Multiple recipients of list ORACLE-L See my note: There is no such O/S file size limit. We have datafiles 2GB which work just fine. The problem is with autoextending datafiles that extend from 2GB to 2GB. It's not a Linux limitation but a limitation imposed by Oracle's implementation on Linux. Oracle 9i on Linux doesn't have this problem. And my peeve is that it took OWS 4 days to discover this limit. Still peeved, :-) Steve -Original Message- Sent: Wednesday, June 04, 2003 10:55 AM To: Multiple recipients of list ORACLE-L I think it is the limitation of Linux, not Oracle. Use LVM and don't worry about file size limit. :-) JP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 5:40 PM I've just been informed that there is a 2GB datafile size limit with Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files in excess of this for some time and they work just fine. The problem occurs when the autoextend feature reaches the 2GB threshhold. Of course, Oracle didn't tell me this until after about 4 days of back and forth testing for them. (There is no such O/S file size limit.) I've reviewed the Linux release notes, the Linux install guide, the Linux admin guide and the contents of $ORACLE_HOME/relnotes and I don't find any such limitation in the documentation. Did I miss it? Can anyone find any such published limitation in the docs? Is this a secret? Peeved at Oracle... AGAIN, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: virtual computer museum
Forget the virtual computer museum, just come to Bozeman. Check it out at: http://www.compustory.com/index.html Steve Orr from guess where... -Original Message- Sent: Wednesday, June 04, 2003 3:40 PM To: Multiple recipients of list ORACLE-L I understand why you wouldn't wish to part with it, but a virtual museum will never work. The 'where to find a leading edge PC' problem has already been mentioned, where to find an industry standard floppy disk will become an issue as well. For my money the best route for a museum would be a source code library and a set of emulators of each architecture that is preserved. Niall Who can't believe that he used the word architecture, despite despising it it deeply and Who moved the last 6.0.36 db we have to MS Access earlier this year :( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeremiah Wilton Sent: 04 June 2003 14:35 To: Multiple recipients of list ORACLE-L Subject: RE: Chris: Thank you! I have a bit of Oracle memorabilia but I probably won't be willing to part with it. Maybe the Oracle Museum should be virtual, with a registry of who has what archaic Oracle stuff. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
And thanks for the note recommendation Dennis... There's too many of these bullets flying around. Need a short list called: Things you should know that Oracle doesn't tell you straight out. Of course there's the bug list but who has time for that and can remember it all? Sigh... Steve -Original Message- Sent: Wednesday, June 04, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Steve Personally I am VERY glad you mentioned this today. Since I run 64-bit Unix, I didn't think this applied to me, but after reading the note, I ran their formula and found a file on one of my databases that was very close to the limit. Plenty happy to dodge that bullet. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 4:15 PM To: Multiple recipients of list ORACLE-L We are on 8.1.7.4 and it aflicted us anyway. Maybe I'll just wait a couple of years and let other customers QA this Oracle feature until they get it right. Steve -Original Message- Sent: Wednesday, June 04, 2003 2:35 PM To: Multiple recipients of list ORACLE-L Ahem . . . according to Note 112011.1, these problems can affect all platforms except OS/390 which does NOT support datafile resizing (fiendishly clever those mainframe types). It looks like 8.1.7.4 and above is not affected. I would highly recommend that all Oracle DBAs take a look at this note. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 3:00 PM To: Multiple recipients of list ORACLE-L It doesn't seem to be a problem on other platforms... Just when I stopped feeling like a neglected step child for running on Linux. Don't worry... Be happy... There's a workaround... Upgrade and buy more software... D'ai jobu desu... er, eh, Ca ne fais rien. -Original Message- Sent: Wednesday, June 04, 2003 12:46 PM To: Multiple recipients of list ORACLE-L This almost sounds like the problem that existed for Oracle 7.3 and the 2G threshold a couple of years ago... J'ai une impression d'avoir déjà vu ceci. : ) Patrice. -Original Message- Sent: Wednesday, June 04, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Steve - are you saying that there is a workaround by increasing the size of the file manually to something larger than 4G? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, June 04, 2003 1:25 PM To: Multiple recipients of list ORACLE-L See my note: There is no such O/S file size limit. We have datafiles 2GB which work just fine. The problem is with autoextending datafiles that extend from 2GB to 2GB. It's not a Linux limitation but a limitation imposed by Oracle's implementation on Linux. Oracle 9i on Linux doesn't have this problem. And my peeve is that it took OWS 4 days to discover this limit. Still peeved, :-) Steve -Original Message- Sent: Wednesday, June 04, 2003 10:55 AM To: Multiple recipients of list ORACLE-L I think it is the limitation of Linux, not Oracle. Use LVM and don't worry about file size limit. :-) JP - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 5:40 PM I've just been informed that there is a 2GB datafile size limit with Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files in excess of this for some time and they work just fine. The problem occurs when the autoextend feature reaches the 2GB threshhold. Of course, Oracle didn't tell me this until after about 4 days of back and forth testing for them. (There is no such O/S file size limit.) I've reviewed the Linux release notes, the Linux install guide, the Linux admin guide and the contents of $ORACLE_HOME/relnotes and I don't find any such limitation in the documentation. Did I miss it? Can anyone find any such published limitation in the docs? Is this a secret? Peeved at Oracle... AGAIN, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: exp, dbms_stats, RMAN and rollback segments
Oh yeah, for the export consistent=N -Original Message- Sent: Thursday, May 29, 2003 9:14 AM To: '[EMAIL PROTECTED]' A certain alignment of the planets occurred creating a good ole ORA-01555 error... A user level export received the snapshot too old error and terminated. Concurrent to this was an RMAN backup and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on the same schema being backed up via the user level export. There was no other end user access to the schema data. Since exp got the error I assume it was reading from the rollback segments but why? I'm suspecting dbms_stats. We have ample RBS. Is there any significant undo generated by dbms_stats or RMAN which could create this problem? (Of course we need to improve our job scheduling but that's another issue, the timing of the user level export is application driven and out of our control). Befuddled in Bozeman, Walt and Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: exp, dbms_stats, RMAN and rollback segments
HELP... Has anyone encountered rollback problems while running dbms_stats? -Original Message- Sent: Thursday, May 29, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Oh yeah, for the export consistent=N -Original Message- Sent: Thursday, May 29, 2003 9:14 AM To: '[EMAIL PROTECTED]' A certain alignment of the planets occurred creating a good ole ORA-01555 error... A user level export received the snapshot too old error and terminated. Concurrent to this was an RMAN backup and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on the same schema being backed up via the user level export. There was no other end user access to the schema data. Since exp got the error I assume it was reading from the rollback segments but why? I'm suspecting dbms_stats. We have ample RBS. Is there any significant undo generated by dbms_stats or RMAN which could create this problem? (Of course we need to improve our job scheduling but that's another issue, the timing of the user level export is application driven and out of our control). Befuddled in Bozeman, Walt and Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: exp, dbms_stats, RMAN and rollback segments
Hi Kirti, Sounds like you have the same suspicions as do we. So far as we know there isn't any heavy duty DML before the export and there isn't any other activity on the schema other than RMAN and DBMS_STATS. We don't understand how RMAN or DBMS_STATS ***could*** be the culprit but we've seen WEIRDNESS before. We host our webapp and upgrades are customer driven. (Shivers and shudders!) Upgrades often entail database changes so the application shuts out end user access and kicks off an export before changing tables, munging data, updating the code, etc. This process has been fairly automagic and the export went along about 5 minutes before it crapped out. The only known difference between this upgrade run and other successful ones is that dbms_stats was running. So now I've copied the data into our test environment in an effort to duplicate the error and walk through our code. Luckily it's not written in Perl so it won't be too hard to read. :-) Also, Walt found some delayed block cleanout issues on Metalink associated with analyzing indexes. The DBMS_STATS.GATHER_TABLE_STATS(...) routine in question is using the cascade option so I'm beginning to smell smoke. There are a few docs on Metalink about how ORA-01555's can occur even when NO updates are being performed but statistics are being gathered. WEIRDNESS!! See DocID's 367016.995; 17730.996; 45895.1; 89633.996; 61552.1. UNFORTUNATELY... the solutions proposed are not very appealing. Meanwhile we're trying to convince others that Oracle is better than MySQL even though MySQL continuously updates its optimizer statistics and doesn't have problems like this. :-( And proposing a blockout period when customers are not allowed to upgrade while maintenance operations are going on would not be very well received. Especially since it's not an issue with MySQL and how we keep talking about how Oracle is a better 24X7 solution for our 24X7 webapp. Arghh! Big sigh while contemplating a lot of tedious work and getting nowhere... And I had to get up at 2:30 A.M. this morning to help fix the outage. Whine, whine, whine... Steve -Original Message- Sent: Thursday, May 29, 2003 11:51 AM To: [EMAIL PROTECTED] Cc: Orr, Steve Steve, You may have to dig a little further... What happened to those table(s) in that schema prior to starting the export? Heavy DML, may be? This could be a case of 'delayed block cleanout'. Export triggered the cleanout and wanted to access the rollback segments. If no table data was modified after export started reading that table, then there is no need to read RBS info (except for the DBC case, IMO). - Kirti --- Orr, Steve [EMAIL PROTECTED] wrote: Oh yeah, for the export consistent=N -Original Message- Sent: Thursday, May 29, 2003 9:14 AM To: '[EMAIL PROTECTED]' A certain alignment of the planets occurred creating a good ole ORA-01555 error... A user level export received the snapshot too old error and terminated. Concurrent to this was an RMAN backup and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on the same schema being backed up via the user level export. There was no other end user access to the schema data. Since exp got the error I assume it was reading from the rollback segments but why? I'm suspecting dbms_stats. We have ample RBS. Is there any significant undo generated by dbms_stats or RMAN which could create this problem? (Of course we need to improve our job scheduling but that's another issue, the timing of the user level export is application driven and out of our control). Befuddled in Bozeman, Walt and Steve __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SAP Hands SAP DB over to MySQL
I knew a guy name Dawson who worked for Lawson which was keen on Informix. -Original Message- Sent: Thursday, May 29, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Thanks, Kip, Jared, Dick - that makes more sense. I now recall that Lawson also ships a free (non-relational) database with its software. Some sites use it for their first year conversion activities (and some much longer). It is much faster than Oracle or the other relational databases. When the customer would spend the big bucks to buy Oracle they would expect it to be faster and were very shocked. When I worked for Lawson one of my duties was to try to reason with the customer on this. The Sybase interface developer Bob sat across the aisle from me and he had a very belligerent customer that wouldn't understand this. Day after day he would harangue Bob. One day he called up and icily said that the Oracle salesman had agreed to apply his Sybase license fee toward Oracle. When he hung up Bob smiled sweetly and said he's all yours now. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 1:05 PM To: Multiple recipients of list ORACLE-L The incentive? $$$, and lots of it. Larry E talked folks into trusting Oracle at it's inception, and I'll bet it was quite a bit less robust then than MySQL is now. Give MySQL a couple years and see what happens. It may never be appropriate for certain apps, but for small to medium plain vanilla RDBMS, it may be a good fit. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/29/2003 07:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SAP Hands SAP DB over to MySQL Okay, I've got a question for you people knowledgeable in SAP. Who would trust their financial and payroll data to MySQL? I'm not saying this to knock MySQL. It is just that your financial and payroll data is among your most valuable data in the corporation. Only recently was a transaction capability added to MySQL, and that was more of an add-on. I manage several databases and my company even makes modest use of MySQL. But of those databases, the financial and payroll data would be the LAST database I would convert to something like MySQL. I'm just curious what is the big incentive in MySQL is. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 28, 2003 5:50 PM To: Multiple recipients of list ORACLE-L Maybe it is just so they can continue to say they're not a database company (insert sound of condescension) to emphasize their focus on applications excellence in the veiled jabs they continue to make at Oracle. On the other hand, I can't imagine they would give up development control because they do make a specialized version of SAP DB for object oriented programming (they say they couldn't find a product that worked correctly...). Kip |I dunno. Though both want to make a profit ( and rightly so ) SAP |doesn't seem to have the same mercenary mentality that MS has. |Jared |Orr, Steve [EMAIL PROTECTED] |Sent by: [EMAIL PROTECTED] | 05/28/2003 11:52 AM | Please respond to ORACLE-L |To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |cc: |Subject:RE: SAP Hands SAP DB over to MySQL |Reminiscent of the M$/Sybase partnership? |-Original Message- |Sent: Wednesday, May 28, 2003 11:40 AM |To: '[EMAIL PROTECTED]' |At http://www.sapdb.org/7.4/pdf/sapdb_letter.pdf SAP offers clarification: |SAP: |Contrary to erroneous press reports, SAP AG has not given up any rights |concerning the SAP DB code base nor handed over or even sold SAP DB to |MySQL AB. |SAP: |SAP AG remains responsible for ongoing development and support. |CNet: |MySQL will take over most of the development of SAP DB. |-Original Message- |Sent: Wednesday, May 28, 2003 12:01 PM |To: Multiple recipients of list ORACLE-L |Importance: High |The past few months I've been wondering when MySQL would start |putting pressure on Oracle in the same way that Linux is putting |pressure on MS. |Maybe sooner than you think: |http://news.com.com/2100-1012_3-1010522.html?tag=fd_top |Jared |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing
RE: SAP Hands SAP DB over to MySQL
At http://www.sapdb.org/7.4/pdf/sapdb_letter.pdf SAP offers clarification: SAP: Contrary to erroneous press reports, SAP AG has not given up any rights concerning the SAP DB code base nor handed over or even sold SAP DB to MySQL AB. SAP: SAP AG remains responsible for ongoing development and support. CNet: MySQL will take over most of the development of SAP DB. -Original Message- Sent: Wednesday, May 28, 2003 12:01 PM To: Multiple recipients of list ORACLE-L Importance: High The past few months I've been wondering when MySQL would start putting pressure on Oracle in the same way that Linux is putting pressure on MS. Maybe sooner than you think: http://news.com.com/2100-1012_3-1010522.html?tag=fd_top Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SAP Hands SAP DB over to MySQL
Reminiscent of the M$/Sybase partnership? -Original Message- Sent: Wednesday, May 28, 2003 11:40 AM To: '[EMAIL PROTECTED]' At http://www.sapdb.org/7.4/pdf/sapdb_letter.pdf SAP offers clarification: SAP: Contrary to erroneous press reports, SAP AG has not given up any rights concerning the SAP DB code base nor handed over or even sold SAP DB to MySQL AB. SAP: SAP AG remains responsible for ongoing development and support. CNet: MySQL will take over most of the development of SAP DB. -Original Message- Sent: Wednesday, May 28, 2003 12:01 PM To: Multiple recipients of list ORACLE-L Importance: High The past few months I've been wondering when MySQL would start putting pressure on Oracle in the same way that Linux is putting pressure on MS. Maybe sooner than you think: http://news.com.com/2100-1012_3-1010522.html?tag=fd_top Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Which method is more efficient
Title: RE: RE: Which method is more efficient And with CTAS you can specify nologging to minimize redo generation. "Cloning" a table, renaming/dropping the source, and renaming the clone to the production table could be interesting. You would have to recreate indexes. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Wednesday, May 28, 2003 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RE: Which method is more efficient Bryan, Can you ... create table my_work_table as select * from changed_parts_table minus select * from existing_parts_table / The result will give you all the rows where _something_ is different between your existing table and changed table. This will cut down a lot on your processing. Afterwards, you can drop the my_work_table. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Rodrigues, Bryan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 28, 2003 2:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: Which method is more efficient The fields that are changed are determined by 1) A loop would start until all records in parts change table are done 2) Select a part record from the part changes table 3) Select the same part from the existing part table 4) Compare the value in the parts changes table against the corresponding field in the part table 5) After comparing all fields in the records, create record in a seperate work table with the values populated with null if the field values matched and the new value if the values did not. 6) This loop would continue until all parts are done. 7) After any records in the work table where all fields (outside of part number) are null are deleted. This process normally will decrease the number of records to be processed after this point by 75%. Hope that helps, Bryan -Original Message- Sent: Wednesday, May 28, 2003 1:21 PM To: Multiple recipients of list ORACLE-L oh i missed part of it. the question is how do you figure out which fields have changed? if you have to do an anti-join on each field, then do an update of every field. the question is how will you determine which fields have changed? From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/05/28 Wed PM 12:59:51 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Which method is more efficient Bryan - If this is a critical issue, I would try it both ways on a test database and use log miner to examine the amount of redo that is generated. My recollection is that you will find that the redo record records the before and after data for each field. So just updating all fields may generate significantly more redo. But don't trust my recollection on this issue, test it yourself. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED]-Original Message- Sent: Wednesday, May 28, 2003 10:50 AM To: Multiple recipients of list ORACLE-LHello everyone, I have a question for the group of which method is more efficient. To set the stage my company has a process to load part changes from vendors into the tables in an 8.1.7.4 Oracle database with archiving on and this database has a standby database at disaster recovery site, so nologging is not an option. There is a discussion going on as to which method is more effective for updating the information in a table. In looking at effectiveness, I am looking at reducing the amount of redo information produced and having the database do the least amount of work. 1) Method 1 is to update the information only for the fields that have changed, 1 field at a time. 2) Method 2 is to update the information for all the fields in the record whether they have changed or not, 1 record at a time. The size of the record is 1843 bytes and the distribution of field sizes: 2 fields varchar2(240). 1 field varchar2(150) 15 fields varchar2(50) 1 field varchar2(3) 2 fields varchar2(20) 4 fields varchar2(40) 3 fields varchar2(1) 2 fields varchar2(25) 2 fields number(10,2) 1 field number(13,2) 1 field number(1) 1 field number 1 field varchar2(6) 1 field number (17,2) 1 field varchar2(4) 3 fields that are date. In the past couple of months the average number of fields changed per record was 3 to 4 fields per record. Thanks for your help, Bryan Rodrigues Oracle DBA Elcom, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network
RE: SAP Hands SAP DB over to MySQL
Agreed, it's a stretch, but I was actually thinking it was MySQL who was looking to leverage off SAP's code because they said it would reduce development time 2 years. Meanwhile SAP folks are saying this partnership gives MySQL customers a robust enterprise alternative. Open source hype and co-opetition? SAP's motivation for SAP DB is to provide a low cost alternative to Oracle, that sentiment is widely shared and gaining traction. Time to selling my Oracle stock? Steve -Original Message- Sent: Wednesday, May 28, 2003 3:08 PM To: [EMAIL PROTECTED] Cc: Orr, Steve Importance: High I dunno. Though both want to make a profit ( and rightly so ) SAP doesn't seem to have the same mercenary mentality that MS has. Jared Orr, Steve [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/28/2003 11:52 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SAP Hands SAP DB over to MySQL Reminiscent of the M$/Sybase partnership? -Original Message- Sent: Wednesday, May 28, 2003 11:40 AM To: '[EMAIL PROTECTED]' At http://www.sapdb.org/7.4/pdf/sapdb_letter.pdf SAP offers clarification: SAP: Contrary to erroneous press reports, SAP AG has not given up any rights concerning the SAP DB code base nor handed over or even sold SAP DB to MySQL AB. SAP: SAP AG remains responsible for ongoing development and support. CNet: MySQL will take over most of the development of SAP DB. -Original Message- Sent: Wednesday, May 28, 2003 12:01 PM To: Multiple recipients of list ORACLE-L Importance: High The past few months I've been wondering when MySQL would start putting pressure on Oracle in the same way that Linux is putting pressure on MS. Maybe sooner than you think: http://news.com.com/2100-1012_3-1010522.html?tag=fd_top Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle encouraging Linux software developers
Actually, I don't think there are ANY automobile manufacturers... There are only assemblers because most of the parts are made by someone else. It's too complicated for any single company. Specialization is the result of increased complexity. Assembling the component output of others into a working unit is more akin to opensource. That's the trend I WANT to see. It's interesting that Oracle and IBM are delving into opensource but Microsoft is not. It's a battle of titanic proportion. All hail the extinction of monoliths and other despots and dictators. Long live freedom and democracy. Oh, but what about Intel? Sigh... When given a choice, choose wisely. -Original Message- Sent: Thursday, March 27, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Lemme quote the infamous Michael Moore's book Stupid White Men: In 1919, twenty years after the invention of the automobile, there were 108 automobile manufacturers in the UnitedStates. Ten years later the number had whittled down to the Big 44 U.S. auto companies. By the end of the fifties it had dropped to 8, and today we have a grand total of 2-1/2 U.S. car manufacturers. Do you see the trend? -Original Message- Sent: Thursday, March 27, 2003 10:39 AM To: Multiple recipients of list ORACLE-L It reminds me a report (Gartner, Meta, ?) I've read in 1997 saying that after year 2000 there should be only 3 players in the rdbms market : Oracle because it has the biggest market share, IBM because it's IBM and Microsoft because Bill was throwing a lot of $$$ to develop Sql Server. In 2003, Ingres, Sybase and Informix have about a 5% marketshare all together. What's for the future ? Stephane -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Value of OCP
Title: RE: RE: Value of OCP Red Green, my hero!!! http://www.ducttapeforever.com/forever.html -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 20, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Value of OCP Good old Duct Tape, the handyman's secret weapon!! Reply Separator Author: Stephen Lee [EMAIL PROTECTED] Date: 3/20/2003 6:34 AM -Original Message- Did you learn anything from the previous crash to prevent it from happening again? Yes. Duct tape the power cord to the floor. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED]
RE: Job Needed
Title: RE: Job Needed Scouting report: I don't know about any jobs but I do know that whoever hires this Kevin guy will have wisely scored a major talent acquisition... a real 1st round draft pick! -Original Message- From: Kevin Toepke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 18, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Subject: Job Needed Greetings! I hope Jared doesn't kick me off the list for this, but I was just layed off this morning and am now in the need of a job. I have over 10 years of experience with Oracle, mostly using SQL and PL/SQL as a developer, but the last 2 years have been as a development support DBA. I am currently in Columbus, Ohio but am willing to relocate to most places in the South-East. I would appreciate any leads that can be thrown my way Thanks Kevin Toepke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Toepke INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Who Owns Unix?
Title: OT: Who Owns Unix? Per the below link, SCO owns Unix and they're suing IBM for a paltry $1Billion: http://www.infoworld.com/article/03/03/06/HNsco_1.html How can this be?
RE: Skill Sets - This may be a dumb question
Title: Skill Sets - This may be a dumb question Bureaucracies don't like husbands and wives to be in the same department because there's a greater chance for collusionwith the notion is that it's easier for two people to steal something when they are working together. So... because they don't trust them you have to adjust? Sounds very Dilbertian. I'd whine too but it may be better to lay low and wait just in case things blow up. In the meantime you can fantasize about the satisfaction you'll feel after you come to the rescue and say "I told you so." ;-) Apologies... -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]Sent: Tuesday, February 25, 2003 9:34 AMTo: Multiple recipients of list ORACLE-LSubject: Skill Sets - This may be a dumb question Hello everyone, Well I've been "reassigned". I was responsible for the completely messed up Peoplesoft Oracle/AIX environment but management here decided that it was more important to separate a husband and wife that both work in the same department, and assigned one of them to be primary support in this environment instead of me. (sshh: The new person who is primary doesn't know a thing about Unix.) My primary job is now suppossed to be data modeling and data warehouse/mart design, moving on into Problematica (er, Informatica) development into a Sql Server database. I will not be the admin on the Sql Server database. My new boss referred to this as "database architecture". ?? What? They have already decided what they want done and just want someone to take the pretty pictures and implement them with unrealistic deadlines. The main reason why I am upset is because it seems to me that data modeling is such a "soft" skill. I am concerned about keeping my skills up to date and keeping my hands in an Oracle environment, whether it's a mess or not. Seems to me that data modeling alone isn't something that can land you a new job or really spiff up your resume. I think that having a finite list of skills (Oracle, Unix, Windows 2000, Erwin, Project, crap like that) is more what employers search for, and is what HR depts can easily deal with. Am I wrong? This job pays well and working for a huge company has it's benefits, if you can deal with the bureaucracy similar to what is described in the 1st paragraph. And I know in this market I am just lucky to have a job. And please tell me if I'm whining. I may just need a KITA. Who knows anymore... Lisa Koivu Oracle Drink Beer Again Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."
RE: Know 1 database, know them all?
Title: RE: Know 1 database, know them all? I see it from a slightly different (and probably wrong) angel Angel? Hmmm... is that a veiled reference to the satanic dark side Luke? -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: Know 1 database, know them all? I see it from a slightly different (and probably wrong) angel, at least regarding the performance of things and databases: If you've worked with Oracle databases for some time (and have real experience), and know about the myths and their anti-thesis (use the wait interface instead of the ¤#% ratio crap, know about RAID-5, don't have too many indexes, concentrate on LIO instead of PIO, etc.,etc.) you'll do quite fine. As Peter Gram once said to me: It's all about getting a database to perform on a platform. You can take your old presentations regarding Oracle myths and change it into a SQL Server or mySQL presentation, change a few details, and be king in the new world. Mogens
RE: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier Programming languages that make DBA's lives easier: The ones you already know and feel comfortable with. (Of course Oracle connectivity is a basic requirement.) Programming languages that make DBA's lives HARDER: The ones forced on you by others. The ones that you don't know which are harder to learn, harder to read, and/or have a lower productivity quotient: C; Java; Perl. :-) Programs that make DBA's lives hellish: The ones written by someone else. Especially poorly written programs/scripts with poor documentation and poor technique. Attitudes which make a DBA's life easier: Insatiable curiosity and the joy of learning new things. Holy Warrior... -Original Message- From: Robson, Peter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: Programming languages that make DBA's lives easier Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Nah! - FORTRAN ! peter
