RE: Changes to RULE based optimizer between Oracle8 and 9i
Logic says one thing, experience says another. Question one, are the tables analyzed? If so, since RBO is deprecated in 9i even setting OPTIMIZER_MODE=RULE will invoke the CBO. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Keith Moore [mailto:[EMAIL PROTECTED]Sent: Friday, January 30, 2004 11:54 AMTo: Multiple recipients of list ORACLE-LSubject: Changes to RULE based optimizer between Oracle8 and 9i We move an application that uses OPTIMIZER_MODE=RULE from Oracle8 to 9i. Most of it is fine, but there are two queries that have a very different execution plan. In one case, the execution time increases from less than a minute to more than an hour. Neither query uses any of the new Oracle 9i features. My understanding is that the Rule optimizer code has not changed, except to account for new features like IOT's. Has anyone else seen this type of behavior? Keith MooreOracle Certified Professional972-431-5126[EMAIL PROTECTED]
RE: [Fwd: ! READ THIS - Oracle-L@fatcity.com is shutting down as of
RIP old friend! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, January 29, 2004 12:24 PM To: Multiple recipients of list ORACLE-L A repost of a previous message. This is the last day for this address folks. --- [EMAIL PROTECTED] is shutting down as of 1/31/2004 If you have already subscribed to the new location for Oracle-L, then you may discard this message. To those of you still reading: [EMAIL PROTECTED] will be offline as of 1/31/2004. You will not longer receive posts from Oracle-L as of 1/31/2004, and you will not be able to post to [EMAIL PROTECTED] as of 1/31/2004. The last day for this address is 1/30/2004. The new address is [EMAIL PROTECTED], and instructions for subscribing to the new address may be found at the following URL: http://www.cybcon.com/~jkstill/util/maillist/maillist.html Thanks for reading. Jared ( List Owner ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
RE: measuring TPM
Charlie, I use the following to determine this: EXEC SQL SELECT ROUND(VALUE/((SYSDATE-STARTUP_TIME)*1440),1) INTO :tp FROM V$SYSSTAT, V$INSTANCE WHERE NAME='user commits'; Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 10:29 AM To: Multiple recipients of list ORACLE-L I've been asked to provide value for the Transactions Per Minute going through our primary OLTP production database. I believe I can use deltas in SCN values to measure transactions which do INSERT/UPDATE/DELETE and then COMMIT; Is there any way to measure/count the number of SELECTs which occur? If so, how? How would you derive a value for TPM for your DB? -- 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).
RE: !!Please Read - Oracle-L is moving!!
I'm going to agree with Jared on this one. There were a few "dead" addresses in the old list. One individual in particular is now behind some corporate Spam shield that bounced every message sent to him. Time for a clean sweep of those subscribing. And it wasn't that painful anyway. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 28, 2004 12:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!!You sir, have obviously never done this. I have. :) Nor read my first post on the matter. No, it would not be easier, not by a long shot. This is free service, so my thinking is, share the workload. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/27/2004 11:49 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: !!Please Read - Oracle-L is moving!!Hi List Manger- Couldn't a immigration of our subscribed accounts been the most logical and error free option ? All this fire would have been avaoided. CSW Simon.
RE: Jobs are not working
Are the jobs "broken"?? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 12:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Jobs are not working I issued commit and job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file so I don't know why the jobs are not working regards, Mauricio Vélez [EMAIL PROTECTED] wrote: A COMMIT is required after "submitting" the job.job_queue_processes = 4 === Must be greater than zero in init_SID.orafileMauricio "Vélez" <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>hoo.com cc: Sent by: Subject: Jobs are not working [EMAIL PROTECTED] .com 01/23/2004 08:29 AM Please respond to ORACLE-L Hello everybody= "urn:schemas-microsoft-com:office:office" /I'm woriking on NT and there are two 8i databases on itOne database can execute jobs normally, but the other one not execute anyjob.I proved submitting the same procedure to both database and worked on thefirst one but not on the second one.How can I resolve this?Mauricio VélezDo you Yahoo!?Yahoo! SiteBuild! er - Free web site building tool. Try it! Do you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it!
RE: Jobs are not working
Can you execute the "what" column's contents in SQL*PLus. Sometimes table permissions get in the way. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:56 PMTo: [EMAIL PROTECTED]Cc: Goulet, DickSubject: RE: Jobs are not working The Jobs are not broken I haven't resolve this yet, alljobswork fineon one database buton the other not. How can I resolve this? Mauricio Vélez "Goulet, Dick" [EMAIL PROTECTED] wrote: Are the jobs "broken"?? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 12:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Jobs are not working I issued commit and job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file so I don't know why the jobs are not working regards, Mauricio Vélez [EMAIL PROTECTED] wrote: A COMMIT is required after "submitting" the job.job_queue_processes = 4 === Must be greater than zero in init_SID.orafileMauricio "Vélez" <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>hoo.com cc: Sent by: Subject: Jobs are not working [EMAIL PROTECTED] .com 01/23/2004 08:29 AM Please respond to ORACLE-L Hello everybody= "urn:schemas-microsoft-com:office:office" /I'm woriking on NT and there are two 8i databases on itOne database can execute jobs normally, but the other one not execute anyjob.I proved submitting the same procedure to both database and worked on thefirst one but not on the second one.How can I resolve this?Mauricio VélezDo you Yahoo!?Yahoo! SiteBuild! ! er - Free web site building tool. Try it! Do you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it! Do you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it!
RE: Metalink on the blink
Title: Metalink on the blink A little slow, but nothing out of the ordinary. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Adams, Matthew (GECP, MABG, 088130) [mailto:[EMAIL PROTECTED]Sent: Thursday, January 22, 2004 9:59 AMTo: Multiple recipients of list ORACLE-LSubject: Metalink on the blink Is anyone else having problems with Metalink this morning or is it just us? We can't log in at all. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] "The swim only hurt once - from the beginning to the end" - Doc Counsilman on swimming the English Channel at age 58
RE: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!
Bruce, I think I'd characterize the service provided as great, period. Sure we've had the odd hiccup now and again, but on the whole it has been great. Thanks a whole lot, your work has been and is appreciated. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, January 22, 2004 11:14 AM To: Multiple recipients of list ORACLE-L Yes, this is legitimate. Jared and I have been talking recently about this. This list has just outgrown what Fat City can handle. While I'd like to think that I've always provided adequate-to-good service for the list, it's never been great, and with the list growing, and traffic growing, my concern is that I just won't be able to continue to give the list good service. It makes me sick to think that, because I really have enjoyed giving back to the Oracle-L community, and because y'all have supported ME so well in the past, but I just don't want to see anything deteriorate simply because the volume exceeds what we can handle here. The list archives here will be available as long as Fat City continues to be in existence, so those of you who are searching for old topics are quite welcome to use the facilities here. It won't be going away. Jared has always been an awesome list owner, and I know he'll continue to make sure the list is successful. This move is just an indication of the relevancy and successful growth of the Oracle-L list, and I know it will continue. I wish you all the best in your new home, and I'll see you over there in a minute. :-) thanks, bruce bergman ListMaster, Fat City Hosting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: RE: Has anyone done any scalability work on dbms_lock?
Well, I don't know about anyone else, but I make use of it to synchronize data upload programs for our testers. Can't have two instances of the upload program processing the same tester, they'd duplicate data. Anyhow, we normally run 4 instances of this program the dbms_lock package works absolutely fantastically. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 21, 2004 6:14 PM To: Multiple recipients of list ORACLE-L Hmm, that's actually a very good idea. It might actually do the job here. Thanks. Nuno Souto [EMAIL PROTECTED] Jamadagni, Rajendra [EMAIL PROTECTED] wrote: if it is single instance you could also use global application contexts ... (alas they don't work in RAC across node) ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Pinto do Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Re[2]: Oracle vs Mysql
yup Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Carel-Jan Engel [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 20, 2004 5:29 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Re[2]: Oracle vs MysqlAt 03:29 PM 1/20/2004, you wrote: I do indeed. Rumor was that rpt/rpf was written by Larry himself.Now I understand! I once applied for a job at Oracle, and got asked: What do you think about RPT/RPF. My answer: Probably som hobby-project of one or another developer, which, after demonstration to his boss, was turned into a product. That was a disloyal remark, even in Holland, and I wasn't hired. Anyone used HLI, with Lattice-C? Regards, Carel-Jan===If you think education is expensive, try ignorance. (Derek Bok)===
RE: OT : Happy Spring Festival
Title: RE: OT : Happy Spring Festival 60 above zero. Floridians turn the heat on. People in New England plant gardens. 50 above zero. Californians shiver uncontrollably. People in New England sunbathe. 40 above zero. Italian and English cars won't start. People in New England drive with the windows down. 32 above zero. Distilled water freezes. Moosehead Lake's water gets thicker. 20 above zero. Floridians don coats, thermal underwear, gloves and hats. People in New England throw on a flannel shirt. 15 above zero. New York landlords finally turn on the heat. People in New England have the last cookout before it turns cold. Zero. People in Miami die - or return to Cuba. New Englanders close the windows. 10 below zero. Californians go to Mexico. People in New England get out their Winter coats. 25 below zero. Hollywood disintegrates. Girl Scouts in New England are selling cookies door to door. 40 below zero. Washington DC runs out of hot air. People in New England let the dogs sleep inside. 100 below zero. Santa Claus abandons the North Pole. People in New England get frustrated because "the caah won't staaht". 275 below zero. All atomic motion stops. (Absolute zero on the Kelvin scale).People in New England start saying, "cold nuff for ya?" 500 below zero. Hell freezes over. Red Sox win the World Series. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Stefick Ronald S Contr ESC/HRIDA [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 21, 2004 10:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT : Happy Spring Festival At least you probably have a warm fuzzy feeling about your Patriots going to the supberbowl. -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 21, 2004 8:45 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT : Happy Spring Festival On 01/21/2004 07:20:00 AM, Stephane Faroult wrote: ... to whomever is concerned ... Regards, Stephane Faroult Oriole Spring??? What is "spring"? I live in New England, we have record colds and I dunno what the heck is spring? Is that something like 70 degrees? I've heard about that mythical event but at present I'm shoveling snow on -20 degrees. -- 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).
RE: Healty ratio of index segment size vs table segment size?
They appear to be Tango Uniform today!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 21, 2004 12:25 PM To: Multiple recipients of list ORACLE-L www.ixora.com.au there is a script in there that will identify unnecessary redundant indexes. for the record, that is one of the best oracle websites out there. Lots of great stuff on it. From: Branimir Petrovic [EMAIL PROTECTED] Date: 2004/01/21 Wed AM 10:39:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Healty ratio of index segment size vs table segment size? Wondering if there is a rule of thumb, quick'n fast but good enough to be used as an indicator, litmus paper so to speak, of overly indexed table(s)... Can, better yet - should, sheer size comparison of index versus table segments be used as a reliable pointer to problematic table indexing? If it can, what could be considered as average healthy ratio above which would be prudent to have a closer look and investigate? Related to the above dilemma, how expensive is to monitor index usage, say if script is run against all few hundred indexes on app tables, would the additional load noticeably affect application performance or is it better/safer or may be required to monitor not more than just a few most suspected indexes at a time? Thoughts, pointers, opinions - appreciated. Branimir -- 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: [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: 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).
RE: after the discussion yesterday on db2/mysql/postgresql....
Thought PostGreSql smelled a lot like DB2. And although I agree with their definitions on the surface they miss a lot of the underlying capability in Oracle. Sure, one database per instance, but you can them map multiple applications/schema's into that instance. Makes for a lot less fun when one application needs data from another that's in the same instance. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 21, 2004 2:14 PM To: Multiple recipients of list ORACLE-L I thought this might be relevant and interesting... http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci945589,00.html?tr ack=NL-93 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Oracle vs Mysql
Well, PostGreSql has all of those features, but handling 100GB? Not sure not sure I'd trust it that far. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 2:10 PM To: Multiple recipients of list ORACLE-L I think he is talking about 100GB database. Can PostgreSQL and MySQL handle that size? We used MySQL in some of the web projects, but it just stores small set of operational data and later on those data are moved to Oracle as a permenant store. For small set of data, MySQL is quite good, but it lacks features such as foreign key constraints, triggers etc. Eric - 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 what I'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 little pilot 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 of clustering, 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 or a 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: 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: 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).
RE: Oracle vs Mysql
AMEN!! Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Monday, January 19, 2004 8: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 - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: Re[2]: Oracle vs Mysql
Probably because they were dropping RPT RPF SQR smells a lot like it, YUCK! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -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 -Original Message- Sent: Tuesday, January 20, 2004 2:04 AM To: Multiple recipients of list ORACLE-L On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, then there was PRO*Pascal, and a myriad of other exotic stuff that I cannot remember now. I was laughing when I saw UNDO TABLESPACES in 9i. What exactly is a difference between a specialized undo tablespace and a file that was just laying around and couldn't be touched and was named Before Image file or BI file. Logical names (another concept that many youngsters are probably unfamiliar with) were usually VAX$BI or ORACLE$BI. Unfortunately, discussions like that are not part of OCP curriculum. The file is not really part of the database, you can't create any objects in it, it manages itself and it stores the old values of oracle blocks, in case rollback is needed. I could be talking about BI file or UNDO TABLESPACE, there is no difference whatsoever. -- 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: 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: 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: 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).
RE: Oracle vs Mysql
an Oracle EE license on windows. They didnt even use foreign key constraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database 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 what I'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 little pilot 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 of clustering, 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 or a 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 - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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 - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list
RE: Re[2]: Oracle vs Mysql
Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 2:04 AM To: Multiple recipients of list ORACLE-L On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, then there was PRO*Pascal, and a myriad of other exotic stuff that I cannot remember now. I was laughing when I saw UNDO TABLESPACES in 9i. What exactly is a difference between a specialized undo tablespace and a file that was just laying around and couldn't be touched and was named Before Image file or BI file. Logical names (another concept that many youngsters are probably unfamiliar with) were usually VAX$BI or ORACLE$BI. Unfortunately, discussions like that are not part of OCP curriculum. The file is not really part of the database, you can't create any objects in it, it manages itself and it stores the old values of oracle blocks, in case rollback is needed. I could be talking about BI file or UNDO TABLESPACE, there is no difference whatsoever. -- 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: 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).
RE: Oracle vs Mysql
Inprocess actually. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 10:54 AM To: Multiple recipients of list ORACLE-L On 01/20/2004 09:19:44 AM, Goulet, Dick wrote: Well, PostGreSql has all of those features, but handling 100GB? Not sure not sure I'd trust it that far. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA Given the price, I believe that some testing would be warranted, don't you think? -- 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: 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).
RE: Re[2]: Oracle vs Mysql
YES! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 10:10 AM To: Multiple recipients of list ORACLE-L Do you remember IBM System 3/10? RPGII flat files? 120 col. punch cards? No hard drives? My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 8:39 AM Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 2:04 AM To: Multiple recipients of list ORACLE-L On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, SQL*Graph does deserve a honorable mention, then there was PRO*Pascal, and a myriad of other exotic stuff that I cannot remember now. I was laughing when I saw UNDO TABLESPACES in 9i. What exactly is a difference between a specialized undo tablespace and a file that was just laying around and couldn't be touched and was named Before Image file or BI file. Logical names (another concept that many youngsters are probably unfamiliar with) were usually VAX$BI or ORACLE$BI. Unfortunately, discussions like that are not part of OCP curriculum. The file is not really part of the database, you can't create any objects in it, it manages itself and it stores the old values of oracle blocks, in case rollback is needed. I could be talking about BI file or UNDO TABLESPACE, there is no difference whatsoever. -- 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: 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: 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: 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).
RE: All packages under sys is invalid
Either that or someone ran dbmspool.sql out of ORACLE_HOME/rdbms/admin. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 12:45 PM To: Multiple recipients of list ORACLE-L so what's the solution? -Original Message- Sent: Tuesday, January 20, 2004 4:10 AM To: Multiple recipients of list ORACLE-L Someone is messing with standard package ... so it would seem. 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- Sent: Monday, January 19, 2004 5:01 PM To: Multiple recipients of list ORACLE-L All, I have an strange problem, most of the packages under SYS user are invalid when I compile it it's compile without error but when I back again the package still is invalid, anybody have any idea? Thanks in advance Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Oracle vs Mysql
Hence why Sql*Server is out there. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 1:29 PM To: Multiple recipients of list ORACLE-L Back to MySQL and whether Postgres is the way to go, I can recall editorials debating whether Unix/Oracle would ever be industrial strength enough to support critical applications. The point the book The Difference Between God and Larry Ellison tries to make is that the technically superior product isn't always the one that succeeds. Often it is the one that is marketed better. A quick check of Amazon reveals several books devoted to MySQL, but I don't see any devoted to Postgres. The story the author relates has to do with distributed databases. Ingres was developing a distributed database capability. Larry got wind of this and announced an new product SQL*Star, that hadn't even been discussed within Oracle. When Ingres announced their product, the press asked isn't than like Oracle's SQL*Star?. My point is that each time these free databases are discussed, people mention the fact that Postgres is superior from a technical standpoint. But from what I see, often it is the best marketed product that prevails. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 20, 2004 11:45 AM To: Multiple recipients of list ORACLE-L On Wed, 14 Jan 2004, eric king wrote: I think he is talking about 100GB database. Can PostgreSQL and MySQL handle that size? We used MySQL in some of the web projects, but it just stores small set of operational data and later on those data are moved to Oracle as a permenant store. For small set of data, MySQL is quite good, but it lacks features such as foreign key constraints, triggers etc. I seem to recall reports of Monty (the creator of MySQL) supporting terabyte size databases with earlier versions of MySQL. Not sure what types of storage systems were used to achieve that, though. And to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only (iirc) if you use the 'Innodb' table type. Now whether or not a database allowing some tables to have FK support and others not is a good proposition you'll have to judge for yourself. I still prefer Pg to MySQL. Fwiw, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
RE: Re[2]: Oracle vs Mysql
Jonathan, The only reason MySql is known better is that big mouth equal to Bill Gates in Finland. Otherwise PostGreSql is the much better product. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 1:49 PM To: Multiple recipients of list ORACLE-L Tuesday, January 20, 2004, 1:29:25 PM, DENNIS WILLIAMS ([EMAIL PROTECTED]) wrote: DW I can recall editorials debating whether Unix/Oracle would ever be DW industrial strength enough to support critical applications. I admit to not being involved in databases that far back, but I've read enough to believe that Oracle was definitely the upstart in the early days, much like MySQL is now, and that's reason enough for Oracle Corp to worry about this new competition. Oracle grew up and became the heavyweight, and MySQL seems to be trying to follow the same path. All MySQL really needs to do is to add capability fast enough to keep up with the demands of their current customers. Their customers will grow, will continue to use MySQL, and as the product becomes more capable, more customers will jump on the bandwagon. DWThe story the author relates has to do with distributed databases. Ingres DW was developing a distributed database capability. Larry got wind of this and DW announced an new product SQL*Star, that hadn't even been discussed within DW Oracle. LOL! Took guts to do that. Larry must've given the developers heart-burn. DWMy point is that each time these free databases are discussed, people DW mention the fact that Postgres is superior from a technical standpoint. But DW from what I see, often it is the best marketed product that prevails. Someone mention books. Was that you Dennis? From what data I see, MySQL books far outsell PostgreSQL books. MySQL is the product with the mindshare, not PostgreSQL. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Re[2]: Oracle vs Mysql
Eric, They were the precusors to Oracle reports. RPT was the report extraction tool, and RPF was the report formatter. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 3: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: 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).
RE: Re[2]: Oracle vs Mysql
If Mr Torvalds needs a security blanket, I'd be happy to send him several. Yes he crafted a wonderful OS I sincerely hope he knocks Billy Gates down to size. Seems to be doing one heck of a job at it, even with SCO on MicroSlop's side. MS Anderson appears headed for the twilight, thank GOD. As for Michael Monty Widenius of MySql AB. Well, that's another story. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 3:54 PM To: Multiple recipients of list ORACLE-L On 01/20/2004 03:29:33 PM, Goulet, Dick wrote: Jonathan, The only reason MySql is known better is that big mouth equal to Bill Gates in Finland. Otherwise PostGreSql is the much better product. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA Dick, when you are talking about big mouth from Finland, you probably don't refer to Pamela Anderson, also from Finland? The other person from Finland, whom I will not mention except by the first name (Linus) should be given credit for a wonderful OS that is successfully breaking the MS monopoly. I wonder whether this Linus needs a security blanket to carry around. -- 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: 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).
RE: Oracle vs Mysql
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).
RE: most practical 9iR2 features?
Brad, We're primarily using 9i with a third party time accounting system, so I haven't had too much time with a lot of 9i, but the resumable transactions are a REAL time energy saver. The Time accounting system has to do bulk data loads from our HR system as well as it's own batch processing. All things that like to eat up tablespace and you can guess that the vendor's estimates (more like Guesstimates) were not up to the realities. But they did set themselves up to use the resumable transaction capability and I did manage to get the database internals setup, thank you OTS. Then when these batch jobs were run for real the jobs stopped while I got paged. In the old days the job would have failed leading to a lot of finger pointing, etc... In this case I was able to fix it it continued without error. Now that's a FEATURE!!! :-) Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, January 15, 2004 12:15 PM To: Multiple recipients of list ORACLE-L Hey listers I am doing some research and would like to get (in very short answers) features of 9iR2 that folks have implemented that meet the following goals: 1. Ease administration 2. Are not marketing crap 3. Are not already in 8.1.7 4. Increase response time and or perfromance A quick bullet list would be way cool of stuff that make you puff up and say ...this is so cool We are going to be moving our MRP system from 8.1.7 to 9iR2 this year and I'd like to get a feel for which items can help our old MRP app. Reply direct if you desire. We'll be implementing a new box with a SAN and so we already have some plans for actually using some features in 8i that were not feasible on our old AutoRAID. (There's nothing like getting a new box...) (I am already reading the new features doc and another doc by Howard Rogers) Thanks in advance Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
RE: Hi!! Veritas Backup Question
Teresita, One of the CD's is titled documentation. You'll find the RMAN manual thereon. There are two, Recovery Manager Quick Reference and Recovery Manager Reference. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Thursday, January 15, 2004 12:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Hi!! Veritas Backup Question Hi!! TheCD's that we have saidOracle 9.2.0.1.0, but I did not see any that said RMAN,( when I asked the DBA the version of Oracle that we have and he said 9.2.0.2.1.) the RMAN is inside a specify CD? [EMAIL PROTECTED] 01/14/04 09:49PM Teresita, What your DBA is talking about is Oracle's RMAN backup utility. There us an interface from Oracle to Veritas which allows RMAN to use Veritas as a librarian for the backups. The first thing I'd suggest is finding out what version of Oracle your using. There are significant differences in using and setting up the RMAN and Veritas software between the two. Check out the documentation CD on RMAN that shipped with your database. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: Hi!! Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He hasbeen working withVeritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my bossmake mework with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thruSaturday make another incremental backup, butthis one will be done from the last incremental backup of Wednesday to the day we are. - -- -- - - Complete backup 1 2 3 4 5 6 7 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4
RE: data file permissions --
SyncSort is NOT a data unloader. It's purpose, and it does a damned good job of it, is to sort large text files to improve data loading with tools like SQL*Loader. Your user should have zero access to the datafiles, period. They need to be -rw-r so that an ipc dedicated server process will work. But under NO circumstances should that be changed. Doing so can make for a VERY long night of recovering a database. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 13, 2004 5:14 PM To: Multiple recipients of list ORACLE-L Oracle data files are read BY ORACLE SERVER PROCESSES ONLY! The only unloader that reads files directly is the notorious DUL. I haven't had any experiences with DUL, but according to what I know, I wouldn't even want to have it. Now there is a system call named chmod and oracle takes care that only oracle RDBMS can access files. Nobody but the DBA can even sniff database files. Please, execute that user. On 01/13/2004 04:19:25 PM, [EMAIL PROTECTED] wrote: Hello All, I have a question on data file permissions. When i add a new data file, it gets created as -rw-r- Umask for oracle user is 022. There is a unix user who wants read access to the data files since they are read by fastunload process (syncsort). When i do a touch on any file in that same directory the permission reads as -rw-r--r-- which coincides with the umask set. Could someone please tell me how the data files get -rw-r and NOT -rw-r--r--. Oracle file permission reads -rwsr-s--x Thank You, Sathish. -- http://www.fastmail.fm - Choose from over 50 domains or use your own -- 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). -- 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: 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).
RE: kill session privilage
Well, I guess I could agree with that. But here if a duhveloper needs a session killed, he calls. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 3:24 AM To: Multiple recipients of list ORACLE-L I imagine the reason goes something along the lines of Sometimes developers fire off queries that are going to run for an exceptionally long time, often accidentally If you are only talking about killing sessions on a development machine then I think it's a fairly valid request - I can't imagine why a developer would ever want to kill a production session. The earlier suggestion of writing a procedure and granting execute rights on that procedure is an approach I have heard of before. Goulet, Dick [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Sent by: Subject: RE: kill session privilage [EMAIL PROTECTED] .com 14/01/2004 08:44 Please respond to ORACLE-L First question for the boss, WHY? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- From: AK [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 2:44 AM To: Multiple recipients of list ORACLE-L Subject: kill session privilage My boss want me to give kill session privilage one of the developer here . He doesn't have any dba privilage to see session or anything . Is there any way I can give likited access to him. Thanks, ak Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: Shared Pool fragmentation
the apps, I would like to know a little before these errors happen. Any ideas? Thanks, Rick Stephenson This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, forwarding or otherwise distributing or taking any action in reliance on the contents of this information is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
RE: Shared Pool fragmentation
1502 2060 655465161966 2821 4048 71125720 263 4280 7624 8 989584 101 9797 15456 9 rows selected. 08:35:29 SQL alter system flush shared_pool; System altered. 08:36:32 SQL @shared_pool_free_lists BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZEBIGGEST -- -- --- -- 0 14364 330 43 76 1 6528 76 85140 6 3964 1 3964 3964 9 29580 129580 29580 105028636 10348821 65436 11 13860744 15092404 130872 12 32192980 173 186086 261016 13 64490864 172 374946 522764 14 83609184 112 7465101048432 15 79829220 57 14005122068384 16 38149220 14 27249443705320 11 rows selected. -Original Message- Sent: Tuesday, January 13, 2004 9:34 AM To: Multiple recipients of list ORACLE-L Is there a way to catch shared_pool fragmentation before you get the 4031 errors? I have looked at Steve Adams site which has scripts to show the free lists chunks in the shared pool. At what point do I know that it is fragmented too much? I know that I can prevent this by using bind variables, and keeping objects, but until I can modify all the apps, I would like to know a little before these errors happen. Any ideas? Thanks, Rick Stephenson This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, forwarding or otherwise distributing or taking any action in reliance on the contents of this information is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: 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
RE: Application Server Caching
Ryan, He has a point. If you look at 9IAS's architecture there is a cache database at the apps server. The trick is to know when the data your looking for in cache is no longer valid. A certain children's apparel/toys site did that to me back in October. I'm still torqued at them. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Ryan [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: Application Server Caching I heard a presentation from a front end performance analyst last night from www.tangasol.com (im not associated with them at all). He was pretty impressive. He argued that accessing the database is expensive. He also argued in favor of caching data at the application server level. Have any of you worked with this? What are your opinions? His opinion was that people go back to the database to ask the same question way too often and cause a botteneck, if you can cache these frequently asked questions at the front end, it will significantly scale better.
RE: Hi!!
Teresita, What your DBA is talking about is Oracle's RMAN backup utility. There us an interface from Oracle to Veritas which allows RMAN to use Veritas as a librarian for the backups. The first thing I'd suggest is finding out what version of Oracle your using. There are significant differences in using and setting up the RMAN and Veritas software between the two. Check out the documentation CD on RMAN that shipped with your database. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: Hi!! Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He hasbeen working withVeritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my bossmake mework with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thruSaturday make another incremental backup, butthis one will be done from the last incremental backup of Wednesday to the day we are. - -- -- - - Complete backup 1 2 3 4 5 6 7 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4
RE: Shared Pool fragmentation
On a side note, before I kill myself with the Friendly Manual, does anyone have a fast way to determine how much space in the shared pool a package is using? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Rick Stephenson [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 13, 2004 12:34 PMTo: Multiple recipients of list ORACLE-LSubject: Shared Pool fragmentation Is there a way to catch shared_pool fragmentation before you get the 4031 errors? I have looked at Steve Adams site which has scripts to show the free lists chunks in the shared pool. At what point do I know that it is fragmented too much? I know that I can prevent this by using bind variables, and keeping objects, but until I can modify all the apps, I would like to know a little before these errors happen. Any ideas? Thanks, Rick Stephenson This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, forwarding or otherwise distributing or taking any action in reliance on the contents of this information is strictly prohibited.
RE: kill session privilage
First question for the boss, WHY? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 13, 2004 2:44 AMTo: Multiple recipients of list ORACLE-LSubject: kill session privilage My boss want me to give kill session privilage one of the developer here . He doesn't have any dba privilage to see session or anything . Is there any way I can give likited access to him. Thanks, ak
RE: Yep.....it's a Monday......
Title: Yep.it's a Monday.. Yeah, it is a Monday. Vendor shows up to "fix" a minor problem my day gets trashed. Oh well, job justification!! Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Bobak, Mark [mailto:[EMAIL PROTECTED]Sent: Monday, January 12, 2004 11:44 AMTo: Multiple recipients of list ORACLE-LSubject: Yep.it's a Monday.. While doing some SAN work, one of our intrepid Sys Admins unplugged the wrong cable, crashing 20+ production databases at the same time..Yeah, it's a Monday.. So, here I sit, waiting, while they scramble around, re-connecting cables and re-booting boxes..sigh.I have a feeling lunch will be a little late today. At least I wasn't the one who caused the crash..;-) Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown
RE: seperate external procedure listeners for different SIDs
HUMM, I've taken a pretty tight stand against open ended external procedures and Java Stored Procedures. Thankfully the developers here agree. Basically I've told them that can't have an external or java procedure that executes a command send into it. That being the case rsh or sh command processors are verboten. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, January 09, 2004 5:29 AM To: Multiple recipients of list ORACLE-L Dick/John Thanks for all your input. I conclude from this discussion that it is not possible to have different, seperate external procedure listeners for different SIDs in the same instance at least not in 8.1.7. Incidentially, I have been having an issue with running an rsh command via an external procedure. The external procedure is a C .so which uses the C system command to run a Unix command. Sometimes the Unix command is an rsh. What I find is that sometimes the rsh command causes the ORA-28576 lost RPC connection to external procedure agent. However if I make the external procedure listener seperate and start it off as follows from the root crontab or inittab /usr/bin/su - oracle -c /u01/app/oracle/product/8.1.7/bin/lsnrctl start listener_ext Then I never get the error. Just wondered if anyone had any thoughts as to why starting the external procedure listener in this way seems to resolve the ORA-28576 error with rsh commands. John -Original Message- Sent: 08 January 2004 15:59 To: Multiple recipients of list ORACLE-L John, I agree if you have multiple databases under the same home all is well, one extproc sid will do. But if you have several different Oracle homes, with different versions of Oracle then each needs it's own extproc sid. Tried using the latest listener and/or extproc combinations, didn't work. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, January 08, 2004 10:44 AM To: Multiple recipients of list ORACLE-L Thanks - I wasn't sure if each session got its own instance of extproc. The SID associated with an EXTPROC is not the same as a SID associated with a database. I have several databases running under the same Oracle Home, and they are sharing the same external procedure listener - which references that Oracle Home. If you are running databases under several versions of Oracle, you may be able to use the listener for the latest version of Oracle you have to listen for all of them, and use its extproc. But it is probably a better idea to run separate listeners for databases and external procedures, each with its own LISTENER.ORA and TNSNAMES.ORA under its own Oracle Home. Just be careful about how the TNS administration directory is set. -Original Message- Sent: Thursday, January 08, 2004 9:54 AM To: Multiple recipients of list ORACLE-L John, On the contrary. You do need to associate an EXTPROC with a particular SID otherwise running different versions of Oracle on the same box blows the EXTPROC to hell. You'll notice that in listener.ora there needs to be a line SID_NAME= and in TNSNAMES.ora there is a Connect_data = (sid = as well. Now a particular database instance/version can only have one extproc_connect_data entry, but with multiple versions each has it's own, and sure enough each has to have a particular sid otherwise they mess each other up. BTW: Your description of the process is dead on, with one exception. An instance of extproc is connected to one and only one session in the calling database. If two sessions each need to call an external procedure then each gets it's own instance of extproc. Also if you need to update the dll or so file you have to get everyone to let go of extproc, namely by disconnecting from the database. Although it's like a database link, closing the links does not release extproc. Also using TCP to connect to extproc is not an Oracle recommended method, opens a door to hackers. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: seperate external procedure listeners for different SIDs
That's a wrinkle I had not thought about. Here, being a PeopleSoft shop, they like to run SQR's and sure enough they want to run the same sqr's from web pages, forms applications, etc. Well I took the stand that the external procedure could only be passed data. No you can't pass an sqr filename, no you can't pass username and password (I get them from elswhere). It works and damanagement supports the idea. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, January 09, 2004 12:39 PM To: Multiple recipients of list ORACLE-L I'm not sure if I'd mentioned this before: We do use an external procedure to run external OS commands, but the procedure that is mapped to the C program is a private procedure in a package. The public interface to this procedure uses the PRODUCT_PROFILE (aka PRODUCT_USER_PROFILE) table to control who may execute what commands. The default is that no-one may execute any commands. We use the table to allow access much as SQL*Plus uses it to deny access to certain commands. -Original Message- Sent: Friday, January 09, 2004 11:44 AM To: Multiple recipients of list ORACLE-L HUMM, I've taken a pretty tight stand against open ended external procedures and Java Stored Procedures. Thankfully the developers here agree. Basically I've told them that can't have an external or java procedure that executes a command send into it. That being the case rsh or sh command processors are verboten. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, January 09, 2004 5:29 AM To: Multiple recipients of list ORACLE-L Dick/John Thanks for all your input. I conclude from this discussion that it is not possible to have different, seperate external procedure listeners for different SIDs in the same instance at least not in 8.1.7. Incidentially, I have been having an issue with running an rsh command via an external procedure. The external procedure is a C .so which uses the C system command to run a Unix command. Sometimes the Unix command is an rsh. What I find is that sometimes the rsh command causes the ORA-28576 lost RPC connection to external procedure agent. However if I make the external procedure listener seperate and start it off as follows from the root crontab or inittab /usr/bin/su - oracle -c /u01/app/oracle/product/8.1.7/bin/lsnrctl start listener_ext Then I never get the error. Just wondered if anyone had any thoughts as to why starting the external procedure listener in this way seems to resolve the ORA-28576 error with rsh commands. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: seperate external procedure listeners for different SIDs
= EXTPROC_DLLS=ANY) ) ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: seperate external procedure listeners for different SIDs
John, I agree if you have multiple databases under the same home all is well, one extproc sid will do. But if you have several different Oracle homes, with different versions of Oracle then each needs it's own extproc sid. Tried using the latest listener and/or extproc combinations, didn't work. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, January 08, 2004 10:44 AM To: Multiple recipients of list ORACLE-L Thanks - I wasn't sure if each session got its own instance of extproc. The SID associated with an EXTPROC is not the same as a SID associated with a database. I have several databases running under the same Oracle Home, and they are sharing the same external procedure listener - which references that Oracle Home. If you are running databases under several versions of Oracle, you may be able to use the listener for the latest version of Oracle you have to listen for all of them, and use its extproc. But it is probably a better idea to run separate listeners for databases and external procedures, each with its own LISTENER.ORA and TNSNAMES.ORA under its own Oracle Home. Just be careful about how the TNS administration directory is set. -Original Message- Sent: Thursday, January 08, 2004 9:54 AM To: Multiple recipients of list ORACLE-L John, On the contrary. You do need to associate an EXTPROC with a particular SID otherwise running different versions of Oracle on the same box blows the EXTPROC to hell. You'll notice that in listener.ora there needs to be a line SID_NAME= and in TNSNAMES.ora there is a Connect_data = (sid = as well. Now a particular database instance/version can only have one extproc_connect_data entry, but with multiple versions each has it's own, and sure enough each has to have a particular sid otherwise they mess each other up. BTW: Your description of the process is dead on, with one exception. An instance of extproc is connected to one and only one session in the calling database. If two sessions each need to call an external procedure then each gets it's own instance of extproc. Also if you need to update the dll or so file you have to get everyone to let go of extproc, namely by disconnecting from the database. Although it's like a database link, closing the links does not release extproc. Also using TCP to connect to extproc is not an Oracle recommended method, opens a door to hackers. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Trigger Question
Wolfgang, Yes you may, within the trigger only, change values of that row only. it's known as :new.column_name := whatever; Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, January 08, 2004 2:39 PM To: Multiple recipients of list ORACLE-L I'm sure I will be corrected if I'm wrong. Answers inline At 12:24 PM 1/8/2004, you wrote: Hi All, Firstly my apologies if this seems like a very *stupid* question but I'm a tad confused (and it's late in the evening) When an AFTER INSERT trigger is fired (row level) has the row been committed to the database at this stage? No. You could raise an error as part of what the trigger does in order to reject the action. If so is it ok to call a package in the trigger that selects that row and changes some values in the row? a) it is not so and b) you can not do anything with that row (or that table for that matter) in either the trigger or any called package or procedure. You'll get a mutating table error. Thanks, N. 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: 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).
RE: Problem with understanding Optimization methods.
Actually from what is given I'd expect the optimizer to select a full table scan in
anycase, there's no where clause.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, January 07, 2004 1:09 AM
To: Multiple recipients of list ORACLE-L
You can find out by employing the event 10053, lev 8. Looking from afar, however, it
seems more
likely that you haven't configured your CBO properly. Here is something you can try:
Execute the following commands:
alter session set optimizer_index_caching=40;
alter session set optimizer_index_cost_adj=25;
After that, retry the query. If I'm correct, optimizer will now know that index I/O
is much cheaper
then the table one and will be much more likely to select full index scan over the
full table scan.
When you're really, really bored, you can read Practical Oracle 8i - Building
Efficient Databases,
it has a few pages about the parameters above. Read the Gospel of Jonathan and enjoy.
On 2004.01.07 00:29, Denham Eva wrote:
Hello Listers,
A normal sql query from a data warehouse tool called Sagent.
SELECT COL1, COL2, COL3
FROM TABLE
ORDER BY 3;
The table has approximately 2 mil records.
table has 22 indexes.
The database is set up optimizer CHOOSE.
I run DBMS_Stats.Gather_Schema_Stats('SchemaName') regularly.
OS is Win2k
ORACLE 81741
OK, when doing a explain plan on the above sql, I get the following...
SELECT STATEMENT Optimizer Mode=CHOOSE
SORT ORDER BY
TABLE ACCESS FULL TABLENAME -- Very slow and takes
hours!
When adding the hint /*+RULE*/ for example I get
SELECT STATEMENT Optimizer Mode=Hint:RULE
TABLE ACCESS BY INDEX ROWID TABLENAME
INDEX FULL SCAN TABLE_INDEX --
Much faster!!!
Have I given enough info that anyone can explain why the CHOOSE mode insists
on doing a TABLE ACCESS FULL?
Is there anything I can do to improve performance? Please remember that this
query comes from a Data Warehouse tool and hence does not appear to accept
hints.
Any help will be much appreciated!
Denham
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Denham Eva
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
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: 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).
RE: OCP question from Boson practice tests
Well, you've certainly gotten a few decent replies. I've never used Boson so I can't comment on their exams, I prefer going to Oracle Press. Anyway, sizing temp is a combination of things many of which are black magic at best. Number of users is an interesting variable to add, but not of an extreme value since it's actually the number of CONNECTED users that will really affect the value arrived at. Sort_Area_size, Maybe. If it's large enough it may well negate the need for temp in a number of cases, but don't bet on it. Type of Tablespace management? OK, who's smoking what. That's a giveaway toss out. DB_Block_Size, again a giveaway, it has no real bearing since the temp tablespace will have the same size, unless you use 9i features, but even then a MB is a MB. The real answer is know what your database is suppose to be doing. If your setting up an OLTP database you may well get away with a very small temp space. On the other hand a data warehouse or decision support system is, by design, going to consume mountains of temp. Also do not forget things like index rebuilds that you will need to do, they do sorts and consequently consume temp in the process. Then there's always that wild user who lets loose the Cartesian product from haties that will blow all of your calculations off the map. Therefore the answer in this case is E: None of the above. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 07, 2004 5:44 AM To: Multiple recipients of list ORACLE-L Hi List, this is the question . You are calculating the proper size for a temporary tablespace . Which of the following are two most important factors to consider ? A. users B. sort_area_size C. type of tablespace management D. db_block_size my choice is A B . but boson's choice is B D . the explanation given by boson is : when sizing a temporary tablespace , the formula is db_block_size * sort_area_size . is it so ? do we need not take no. of users into account ? kindly explain me . Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna 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: 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).
RE: Apple RAID marketing?
Jesse, If they'll loan you one for a test period that test works out, Maybe. Now if your SAN vendor is worth his/her weight in salt then they'll have a way to connect that Xserve RAID system into their SAN. That way you get the best of both worlds. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 07, 2004 11:00 AM To: Multiple recipients of list ORACLE-L So a co-worker sends me an e-mail about Apple's just-announced Xserve RAID with 3+TB for US $11K. After looking at Apple's page, I poo-poo it because it's 7.2K spin ATA/100 drives, which I figure would lead to all sorts of problems. I see today in Computerworld that it's being touted as blazing with a max thruput of 210MBps. H...I know the mid-range FAStT SAN we're looking at is rated at about 800MBps theoretical max. Just looking for confirmation/rebuttal that I don't think it would be wise to load up an Xserve RAID with Oracle DBs -- even if the BAARF's nemesis is avoided. http://www.apple.com/xserve/raid TIA, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
RE: Re[2]: another OCP question -- help me guys
Rachel, A few years ago I was offered a job by a defense contractor in the area who was looking for a DBA, but more importantly a DBA with a still active clearance. Well all was well in 90% of that company, except HR. Simple answer, no degree no job. I don't have the degree so they absolutely would not let the paperwork through, end of conversation. So yes it does matter even when it makes no sense. BTW: they did fill the job a year later with a person who had a degree in English believe it or not. Her clearance was inactive not current as well. Guess it's better than no clearance. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 07, 2004 10:29 AM To: Multiple recipients of list ORACLE-L Rachel Carmichael scribbled on the wall in glitter crayon: Oh yeah -- how does having a college degree in art history make a person a better DBA? how does my degree, which is in computer science but which is 28 years old, have anything to do with current programming and database work? it gets you past the HR department so you actually get to talk to someone. trust me, i know all about this one having neither a degree or an OCP. and having lost jobs to those art history degree holders. [and yes i have been asked to go back to those same places as a consultant to fix the mess. and no i didn't.] -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] You see, wire telegraph is a kind of a very, very long cat. You pull his tail in New York and his head is meowing in Los Angeles. Do you understand this? And radio operates exactly the same way: you send signals here, they receive them there. The only difference is that there is no cat. - Albert Einstein, when asked to describe radio -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: data warehouse vs regular database??
Janet, A data warehouse is a database. Now if the data warehouse has all of the data structures of the OLTP database and people are using those tables like one would expect, then your just using the same instance for both purposes, which is a recipe for disaster in my opinion. A data warehouse is characterized by several large (both in width and depth) tables with somewhat demoralized and static data and/or a number of star schemas that have very deep fact tables. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 07, 2004 12:04 PM To: Multiple recipients of list ORACLE-L Hi all, I have been working with Oracle 92. I have no experience with Oracle Warehouse. In my current company, I was told the database is a warehouse. I can connect to it using sql plus or pl/sql developer. The warehouse looks the same as the database I worked with before. How do I tell if a database is a warehouse or just a regular database. What's the big difference between the two? Could someone send me some link about data warehouse? Thank you! Janet __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Any good product / option for Source code control
Source Safe Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 07, 2004 1:34 PM To: Multiple recipients of list ORACLE-L Env: Windows 2000/NT/HP-UX/Solaris/Linux Oracle Databases: 7.3 to 9.2.0.4 I am looking for any good product/option for centralized source code control. Any pointer or experiences shall be appreciated. Regards Rafiq _ Have fun customizing MSN Messenger - learn how here! http://www.msnmessenger-download.com/tracking/reach_customize -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Problem with understanding Optimization methods.
Tanel,
True enough as you've demonstrated. I do remember
that there were times in the past when one would intentionally do things to
cripple indexes for RBO. Guess they still exist.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Tanel Poder
[mailto:[EMAIL PROTECTED]Sent: Wednesday, January 07, 2004
4:30 PMTo: Multiple recipients of list ORACLE-LSubject:
Fw: Problem with understanding Optimization methods.
(I suspect my last post didn't go through - sorry
for long repost again)
No, but there's an order by clause on COL3 and
apparently an index as well, so RBO thinks it's cheaper to read keys+rows in
order using index full scan than reading all rows and sorting them. Note that
optimizer needs to know that all table's rows have corresponding entries in
indexes well, in order to order full table using an index (for the reason that
indexes do not index rows where all relevant column values are NULLs). An
example follows:
SQL create table t (a number,
b number);
Table created.
SQL create index i on
t(a);
Index created.
SQL select * from t order by
a;
Execution
Plan--
0 SELECT STATEMENT
Optimizer=CHOOSE 1 0 SORT (ORDER
BY) 2 1 TABLE ACCESS
(FULL) OF 'T'
SQL alter table t modify a
not null;
Table altered.
SQL select * from t order by
a;
Execution
Plan--
0 SELECT STATEMENT
Optimizer=CHOOSE 1 0 TABLE
ACCESS (BY INDEX ROWID) OF 'T' 2
1 INDEX (FULL SCAN) OF 'I' (NON-UNIQUE)
When I added a not null constraint, RBO
knows, that every table row will be in the index and can use it for
sorting.
SQL alter table t modify a
null;
Column A can be null again.
Table altered.
SQL drop index i;
Index dropped.
Lets createa composite index on both
columns.
SQL create index i on
t(a,b);
Index created.
SQL select * from t order by
a;
Execution
Plan--
0 SELECT STATEMENT
Optimizer=CHOOSE 1 0 SORT (ORDER
BY) 2 1 TABLE ACCESS
(FULL) OF 'T'
And set one of the columns not null (now all
entries will be indexed, since at least one field of index entries will have a
value)
SQL alter table t modify b
not null;
Table altered.
SQL select * from t order by
a;
Execution
Plan--
0 SELECT STATEMENT
Optimizer=CHOOSE 1 0 SORT (ORDER
BY) 2 1 TABLE ACCESS
(FULL) OF 'T'
Hm, no change?
SQL analyze table t compute
statistics;
Table analyzed.
SQL select * from t order by
a;
Execution
Plan--
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2
Card=1 Bytes=26) 1 0 INDEX (FULL
SCAN) OF 'I' (NON-UNIQUE) (Cost=1 Card=1
Bytes
=26)
Rule based optimizer was too dumb to take
into account aNOT NULLconstraint of another field of a composite
index. So, here's one reason for upgrading to CBO :)
Tanel.
- Original Message -
From: "Goulet, Dick" [EMAIL PROTECTED]
To: "Multiple recipients of list ORACLE-L"
[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 4:04
PM
Subject: RE: Problem with understanding
Optimization methods.
Actually from what is given I'd expect the optimizer to select a
full table scan in anycase, there's no where clause. Dick
Goulet Senior Oracle DBA Oracle Certified 8i DBA
-Original Message- Sent: Wednesday, January 07, 2004
1:09 AM To: Multiple recipients of list ORACLE-L
You can find out by employing the event 10053, lev 8.
Looking from afar, however, it seems more likely that you haven't
configured your CBO properly. Here is something you can try:
Execute the following commands: alter session set
optimizer_index_caching=40; alter session set
optimizer_index_cost_adj=25;After
that, retry the query. If I'm correct, optimizer will now know that
index I/O is much cheaper then the table one and will be much more
likely to select full index scan over the full table scan. When you're
really, really bored, you can read Practical Oracle 8i - Building Efficient
Databases, it has a few pages about the parameters above. Read
the Gospel of Jonathan and enjoy.On
2004.01.07 00:29, Denham Eva wrote: Hello Listers,
A normal sql query from a data warehouse tool called Sagent.
SELECT COL1, COL2, COL3 FROM TABLE
ORDER BY 3;The table has approximately 2 mil
records. table has 22 indexes.The
database is set up optimizer CHOOSE. I run
DBMS_Stats.Gather_Schema_Stats('SchemaName') regularly. OS is
Win2k ORACLE 81741OK, when doing a
explain plan on
RE: How to remove PL/SQL successfully completed Message
set feedback off Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 06, 2004 3:49 AM To: Multiple recipients of list ORACLE-L Hi, I am trying to spool the result from PL/SQL procedure. At the end of result I am getting PL/SQL successfully completed. Could anyone tell me how to avoid that message?. This is how my sql looks like set linesize 200 set trimspool on set verify off echo off set serveroutput on spool c:\mudhalvan\test.txt declare begin end; / spool off Thank You Mudhalvan M.M -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mudhalvan, Moovarkku INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Upgrade
Well, since my usage of my boat is primarily for fishing, I really like Lake trout Pickerel, an anchor that drags smoothly is a benefit. Besides that old Windoze OS adds a lot of weight to the system. *-) Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 06, 2004 5:54 AM To: Multiple recipients of list ORACLE-L I guess Dick really meant 'paper weight', a rather large, bulky and ugly one and the only paper weight that needs to be reboot twice a day to hold your papers steady. 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- Sent: Monday, January 05, 2004 4:04 PM To: Multiple recipients of list ORACLE-L Dick, What kind of a nautical person are you??? the NT box will not even make a good anchor because the sides are flat and it will drag on the bottom during a small wind or current. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Upgrade
Jared, I'm not into TightVNC just yet, but I do use VNC. It's damned nice over a dial up line as there is less chatter between the server the client. I also prefer it over PCAnyWhere as it runs in less memory. Much easier to set up as well. OH, BTW; did anyone mention that it's FREEWARE vs. $$$ware??? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 06, 2004 11:09 AM To: Multiple recipients of list ORACLE-L Yes, I find it highly amusing that the Linux client for Windows Terminal Services (rdesktop) is in some ways easier to use than the Windows client. Have not had need for TightVNC. How do you use it? On Tue, 2004-01-06 at 07:09, Jesse, Rich wrote: Citrix Metaframe, rdesktop, and TightVNC help a bunch, too. :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Tuesday, January 06, 2004 8:59 AM To: Multiple recipients of list ORACLE-L True, but some of use linux to manage those databaeses on MS. On Tue, 2004-01-06 at 04:44, Mercadante, Thomas F wrote: Now now all you MS bigots. Just leave us alone. There are several of us on this list who are forced into using MS because of management decisions. And our systems are running just fine. Just leave us alone. You don't see us posting all of the other op systems problems (all 2 of them). thank you. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 06, 2004 6:09 AM To: Multiple recipients of list ORACLE-L I'm confused: did you REALLY expect anything out of microslop to work according to expectation? Cheers Nuno Souto -- 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: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
RE: Progress of an index rebuild
Daniel, Check out V$SESSION_LONGOPS. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 06, 2004 12:49 PM To: Multiple recipients of list ORACLE-L Is there any way to check on the progress of an index rebuild? (Oracle 8i). I.e., it would be nice to get some indicator as to how far an index rebuild has gone, something like 75% done As a rough indicator, I've noticed when rebuilding/moving an index to a different tablespace, Oracle will allocate temporary extents in the tablespace to which the index is being moved. So, in theory, I suppose I could see how big (in terms of extents) the index is before moving it and use that as a rough indicator to see how far along the rebuild is by counting the number of temporary extents allocated in the new tablespace (taking into account the extent size in the new tablespace). Are there better ways to see the progress of an index rebuild? Thanks for any help. -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Convert to Locally-Managed Tablespaces
, include a line containing: UNSUB ORACLE-L (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: 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).
RE: Bug with automatic undo management?
Ryan, I agree with OTS. If you had dropped the rollback segment(s) before creating the object then you'd probably never have seen the error. I have found that SCN's do get cached by your session and sometimes don't get updated correctly. Therefore even though you had switched to undo management before creating the object it is possible that the block header on the object has an scn that predated your change. I don't know if it's delayed block cleanout or delayed session cleanout, but one of them is definitely the culprit. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, December 31, 2003 10:29 AM To: Multiple recipients of list ORACLE-L I have a TAR open on this and Im arguing with the Oracle tech support guy. Here is what happened. We upgraded an instance to 9i. Switched to automatic undo management. Set our undo parameters to point to a newly created undo tablespace. 1. took our old rollback tablespace(with rollback segments in it) offline. 2. I created some new objects. Fine. 3. Then I started creating indexes and doing selects. I would periodically get the following error: ORA-00604: error occurred at recursive SQL level 1 ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: 'path/rbs_01.dbf' 4. This is becaus that is the old rollback tablespace that was taken off line and is NOT indicated in the undo parameter as the undo tablespace. 5. Oracle support said the following. 'Most likely what happened is that when you went to create the index it encountered some information in the table in one of the block headers that needed to be retrieved/verified from the rollback segment due to delayed block cleanout. If we see that the rollback segment still exists we try to access it. (It doesn't matter whether we are using auto ot manual at this point.) If we can't access it then we throw an error. If we see that the rollback segment has been dropped then we know for sure that the information in the block header is old because we never drop rollback segments until all active transactions have completed.' 6. Not possible in my opinion. Since the object in question was created AFTER this rollback segment was taken offline. 7. We dropped the old rollback segment and it works fine now. Is this a bug? -- 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: 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).
RE: Upgrade
Look on the Documentation CD for the upgrade manual. Safest way would be to 1) get a Linux box, 2) do a FULL DB export. 3) Create new DB on the Linux server Import the data there. 4) Use the old NT box as a boat anchor or upgrade it to Linux. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, January 05, 2004 12:24 PM To: Multiple recipients of list ORACLE-L Dear List, I want to upgrade from 8.1.5 to 8.1.7 on windows 2000 what's the safest way to do this upgrade. If any body knows any url or have any kind of document it would be very helpful. Thanks happy new year to all of you. Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Delete vs. truncate to free up spaces.
EE has enterprise on the CD, but it's an extra cost option. Make sure the license fees have been paid first, otherwise it could be a messy thing to rip out. BTDT. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, December 22, 2003 7:14 PM To: Multiple recipients of list ORACLE-L Then you should have the partitioning option. Partition your table if you can. -Original Message- Nguyen, David M It's Oracle8i Enterprise Edition. -Original Message- Jacques Kilchoer This is one of the cases where a partitioned table can be of great use. What version of Oracle? Standard or Enterprise Edition? With a partitioned table you can say alter table ... drop partition ... ; to easily get rid of a large chunk of data and release the space. See Oracle9i Database Concepts Release 2 (9.2) Part Number A96524-01 Chapter 11 Partitioned Tables and Indexes http://download-west.oracle.com/docs/cd/B10501_01/server.920/a 96524/c12p arti.htm#464767 or http://tinyurl.com/362ba -Original Message- Nguyen, David M I am using delete command to delete million records in several tables to free up space in tablespace. I understand delete command does not release unused spaces as truncate command but I could not use truncate to delete ALL records in table as I need to keep one month old of records in table. Please advise a better method I can use to free up spaces. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Interesting analysis of MySQL code quality
Well, When your declared intentions is to do one thing and one thing only there are a whole lot less places to make mistakes. Conversly when your intentions are to "rule the world" you also open up the world of oops's. Humm, Wonder if there's a lesson in that for Cousin BillyG??? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, December 23, 2003 1:09 PMTo: Multiple recipients of list ORACLE-LSubject: Interesting analysis of MySQL code qualityhttp://www.eweek.com/article2/0,4149,1420487,00.asp
RE: RE: Hit Ratio
occasionally used. Most ratios could still be distored by a
rogue
user repeatedly doing, say, find / for inodes or find / -exec grep
SomeThing
{} \; for page cache.
In any tuning practice, Oracle or OS, artificially distorting usage
patterns
invalidates your numbers even if you're using a well respected tuning
method.
So only play pranks on a play box, not production.
Yong Huang
At 11:14 22-12-03 -0800, you wrote:
My BCHR is currently 96.62%. In the past, it was normally over 99%.
What
should I do?
I'll be waiting for Mladen's reply... :)
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
Go to www.oracledba.co.uk (Connor) or go to O'Reilly (download page of
Cary's book), and download one of the fabulous BCHR enhancement
scripts.
Especially when your bonus depends on it, this is a good time to
perform
some BCHR tuning.
Regards, Carel-Jan
__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Yong Huang
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Cary Millsap
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Cary Millsap
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
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
RE: RE: Hit Ratio
SORRY!! Regrettably e-mail does not provide the required info, namely a picture. The only other Cary I know is female, in every sense of the word. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, December 23, 2003 3:45 PM To: Multiple recipients of list ORACLE-L At 12:04 23-12-03 -0800, you wrote: Jared, I'm going to take some exception to what Cary has said on the subject, but I believe in the end she'll agree with me. She? Cary, you didn't tell us about this surgery ;-) Dick, last time I saw Cary (October) he was very masculin. I bet this hasn't changed during the last two months. Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: 10g new features question for beta testers
That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give it a directory and then just build tablespaces. The database picks the filenames for you. Now mind you it does work, but I'll be damned if I use it in anything other than a development environment. For some reason Oracle has never gotten over that DUMB SAME (Stripe And Mirror Everything) idea. The concept is great in theory, but in practice it's absolutely abysmal at best. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, December 19, 2003 8:24 AM To: Multiple recipients of list ORACLE-L I saw a presentation from Oracle on 10g new features last night in Reston,VA. I know atleast one other person from the list was there. Since Oracle is releasing details and its going to be released(in theory) in the next 2 weeks, I was wondering if you guys could talk about it. 1. does ASMs work as well as Oracle claims? I always wonder about first generation features... takes most software vendors a couple of generations to get it right(takes any project Im on just as long). This is a radical departure. for those of you who dont know. Oracle claims that they will manage your disks for you. All you do is give Oracle some Raw Disks and Oracle will set up, and handle all your datafiles. All you do is look at logical tablespaces. It will also handle I/O balancing. How well does this work? Anyone test it with a SAN? 2. RAC Load Balancing. Oracle claims that you only need Oracle software from now on. They also claim that you can load balance multiple applications. Lets say you have One application that runs batch loads over night and a transactional application during the day oracle will automatically steal resources from the other when its not busy... anyone test this? 3. Flashback database. Kyte was the presenter and he said that you can keep massive undo areas, so that if you have a failure or delete data you shouldnt have you can have oracle automatically write the DML necessary to bring it back to any point in time. Kyte said that regular EIDE hard drives that you put in home PCs are plenty fast enough for most systems. He recommends getting 4 300 GB drives(1.2 TBs) for about $1400 to do this and to make tape backups off of this since they are really slow. Can any beta testers comment? Im pleased with the rename tablespace feature... that way I dont have to update TS$ anymore... I wonder if it was our complaining that got them to add it :) -- 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: 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).
RE: RE: 10g new features question for beta testers
HUMM, That gives me an even worse feeling. Not something I'll use that's for sure. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, December 19, 2003 9:45 AM To: Multiple recipients of list ORACLE-L no ASMs are considerably different. Its supposed to manage everything. You dont give it a file, you give it entire disks and oracle does everything. Sets up files, manages, I/O, everything. you only look at the tablespace level. you dont even install any software on it. If your on SAN, you dont install SAN software on it. From: Goulet, Dick [EMAIL PROTECTED] Date: 2003/12/19 Fri AM 09:14:27 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 10g new features question for beta testers That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give it a directory and then just build tablespaces. The database picks the filenames for you. Now mind you it does work, but I'll be damned if I use it in anything other than a development environment. For some reason Oracle has never gotten over that DUMB SAME (Stripe And Mirror Everything) idea. The concept is great in theory, but in practice it's absolutely abysmal at best. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, December 19, 2003 8:24 AM To: Multiple recipients of list ORACLE-L I saw a presentation from Oracle on 10g new features last night in Reston,VA. I know atleast one other person from the list was there. Since Oracle is releasing details and its going to be released(in theory) in the next 2 weeks, I was wondering if you guys could talk about it. 1. does ASMs work as well as Oracle claims? I always wonder about first generation features... takes most software vendors a couple of generations to get it right(takes any project Im on just as long). This is a radical departure. for those of you who dont know. Oracle claims that they will manage your disks for you. All you do is give Oracle some Raw Disks and Oracle will set up, and handle all your datafiles. All you do is look at logical tablespaces. It will also handle I/O balancing. How well does this work? Anyone test it with a SAN? 2. RAC Load Balancing. Oracle claims that you only need Oracle software from now on. They also claim that you can load balance multiple applications. Lets say you have One application that runs batch loads over night and a transactional application during the day oracle will automatically steal resources from the other when its not busy... anyone test this? 3. Flashback database. Kyte was the presenter and he said that you can keep massive undo areas, so that if you have a failure or delete data you shouldnt have you can have oracle automatically write the DML necessary to bring it back to any point in time. Kyte said that regular EIDE hard drives that you put in home PCs are plenty fast enough for most systems. He recommends getting 4 300 GB drives(1.2 TBs) for about $1400 to do this and to make tape backups off of this since they are really slow. Can any beta testers comment? Im pleased with the rename tablespace feature... that way I dont have to update TS$ anymore... I wonder if it was our complaining that got them to add it :) -- 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: 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: [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
RE: RE: 10g new features question for beta testers
And the more that vendor, namely the database in this case, controls more and more of the stack the more any performance problem must be a database problem. No thank you. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, December 19, 2003 10:34 AM To: Multiple recipients of list ORACLE-L As with anything I suppose, if a single vendor can be in control of more of the stack between application and physical server structure then there is a greater opportunity for benefits. For example, ASM offers the ability to add disks to a stripe without needing to redistribute(reload) the entire stripeset. A (bug-free) ASM product looks very very impressive to me. Time will tell how close Oracle are to achieving it. hth connor --- [EMAIL PROTECTED] wrote: no ASMs are considerably different. Its supposed to manage everything. You dont give it a file, you give it entire disks and oracle does everything. Sets up files, manages, I/O, everything. you only look at the tablespace level. you dont even install any software on it. If your on SAN, you dont install SAN software on it. From: Goulet, Dick [EMAIL PROTECTED] Date: 2003/12/19 Fri AM 09:14:27 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 10g new features question for beta testers That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give it a directory and then just build tablespaces. The database picks the filenames for you. Now mind you it does work, but I'll be damned if I use it in anything other than a development environment. For some reason Oracle has never gotten over that DUMB SAME (Stripe And Mirror Everything) idea. The concept is great in theory, but in practice it's absolutely abysmal at best. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, December 19, 2003 8:24 AM To: Multiple recipients of list ORACLE-L I saw a presentation from Oracle on 10g new features last night in Reston,VA. I know atleast one other person from the list was there. Since Oracle is releasing details and its going to be released(in theory) in the next 2 weeks, I was wondering if you guys could talk about it. 1. does ASMs work as well as Oracle claims? I always wonder about first generation features... takes most software vendors a couple of generations to get it right(takes any project Im on just as long). This is a radical departure. for those of you who dont know. Oracle claims that they will manage your disks for you. All you do is give Oracle some Raw Disks and Oracle will set up, and handle all your datafiles. All you do is look at logical tablespaces. It will also handle I/O balancing. How well does this work? Anyone test it with a SAN? 2. RAC Load Balancing. Oracle claims that you only need Oracle software from now on. They also claim that you can load balance multiple applications. Lets say you have One application that runs batch loads over night and a transactional application during the day oracle will automatically steal resources from the other when its not busy... anyone test this? 3. Flashback database. Kyte was the presenter and he said that you can keep massive undo areas, so that if you have a failure or delete data you shouldnt have you can have oracle automatically write the DML necessary to bring it back to any point in time. Kyte said that regular EIDE hard drives that you put in home PCs are plenty fast enough for most systems. He recommends getting 4 300 GB drives(1.2 TBs) for about $1400 to do this and to make tape backups off of this since they are really slow. Can any beta testers comment? Im pleased with the rename tablespace feature... that way I dont have to update TS$ anymore... I wonder if it was our complaining that got them to add it :) -- 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: 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
Who fired the trigger
To All, I'm feeling in a LAZY mood this afternoon so I'm going to ask the list if someone has an answer to this. Otherwise I guess it will wait till Monday. We have a before update trigger on a table to prevent assemblies on the line from being unscrapped. But we also have a need o periodically unscrap stuff. The question is can a trigger recognize who fired it abort if that is a particular user? 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).
RE: Finding the most actively DML'd table
Alter table table_name monitoring; then look in DBA_TAB_MODIFICATIONS Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, December 19, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Is it possible to find how many DML operations have ocurred on a given table in a given time period? I'd like to be able to rank the tables in a database based on the number of DML actions performed on them in a given time period. It would be interesting to see which are the 'hot spots' so to speak, and either a) tune access to those tables accordingly, or b) put out the fires. Granted, this strays somewhat from the Millsapian/Holtian doctrine of focusing on the user action with the largest business impact, but I still think it would be interesting to see. Thanks for any help, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Using a '.' in a username
Last time I looked in my ANSI SQL standard usernames and object names were suppose to be : 1) Upper case 2) Could not contain punctuation characters 3) Could not contain spaces 4) etc... But as always Oracle has allowed these exceptions so long as they are imbedded in double quotes which make them a pain in the a to work with. I believe Oracle did this to be all inclusive. If you a database engine vendor you really don't want to say no to anybody. Kinda market limiting!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, December 15, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Thanks, Vladimir. I haven't looked in the manual but as I've said, using those things in usernames or table names is a cruel and unusual practice which should be avoided if possible. On 12/15/2003 12:04:26 PM, Vladimir Begun wrote: Mladen Gogala wrote: To use . in the username is a cruel and unusual practice which exposes funny sqlplus behavior: $ sqlplus test.yogi Mladen, please have a look 1. It's not sqlplus but $SHELL behavior, try this $ sqlplus \test.yogi\ 2. Oracle9i SQL Reference Release 2 (9.2) CREATE USER 3. Oracle9i SQL Reference Release 2 (9.2) Schema Object Naming Rules Schema Object Naming Examples The following examples are valid schema object names: last_name horse hr.hire_date EVEN THIS THAT! a_very_long_and_valid_name -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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: 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).
RE: Using a '.' in a username
Joe, I believe you've hit that nail squarely on the head. But then there are piles of dummies out there who like doing the dumb thing. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, December 15, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Please unless you've been at oracle doing oracle stuff since 1990 back in version 5 days, you can spare me the condescending attitude and the company line, the bottom line is oracle is just like C, it will let you shoot off your own foot(and thats the way most of us like it). its not dumbproof from any means or platform, its just gotten gui-fied in alot of cases and people who can right-click in OEM to resize a datafile and think that makes them a dba have a bit to learn. The bottom line still boils down to this, just because you can, doesn't make it a smart thing to do. joe Vladimir Begun wrote: Joe Testa wrote: besides the point the example is a schema.object_name NOT a user.name, evidently since its NOT in quotes. Does that mean that you cannot create such user(s) and connect as it was shown? Please read what it's written in the documentation -- that's why I put references. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: 3rd Party Oracle Licenses
Rule of thumb, NEVER trust the third party vendor to have it right. Call YOUR Oracle sales rep get his/her advice. We've had an application sold to us with Oracle licenses when the third party vendor was not licensed by Oracle to do so. Mind you as long as the contract between you and the third party vendor states that they are selling you a database license Oracle is nice about things. But still it can get sticky!!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, December 11, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Our apps that use Oracle come with an Application license. By the terms of this license, we get to use that Oracle DB for that app and that app alone. The DB support comes from the app vendor and not Oracle. Not feeling particularly comfortable with this arrangement, we purchased separate Oracle licenses in order to get Silver support directly from Oracle, as I've yet to meet a vendor who had a grip on the DBs they sell with their product. Then again, these were network concurrent user licenses, which unfortunately no longer exist. Perhaps a low-end 5-user named license would work for you. HTH! GL! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Thursday, December 11, 2003 8:14 AM To: Multiple recipients of list ORACLE-L We are purchasing a software package from a vendor. The vendor states that the package includes sufficient Oracle licenses. Since I'm supposed to keep on top of our licensing costs, I'm trying to make sure that there are no surprises down the road - such as additional Oracle support fees or Oracle claiming that we don't have this new box licensed, etc. How can the vendor prove that they are providing a license? When I asked them for some type of proof, they forward the OLSA to me, which is basically generic - it doesn't tell me if the license is SE, EE, SE One, perpertual, term, CPU, Named User, etc. Any thoughts or do I just take their word for it? Thanks, Jay -- 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: 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).
RE: NT - Win2K causes performance degradation..
Mark, I have not done a MicroSlop upgrade, but I have in the past upped the SGA size and gotten when I really did not want, which was database performance degradation. You might ask them to check the pagefile size. If it's system maintained or too small funny things do happen. BTW: My rule of thumb with Win2K is pagefile size = physical memory *1.5. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, December 10, 2003 4:04 AM To: Multiple recipients of list ORACLE-L Hi All, We've been asked a question from one of our clients that I'm a little stumped on. They run an OLTP database (Oracle 8.1.7), and have recently upgraded their NT machine to Windows 2000, they were running with 2gb of memory, and upgraded that to 4gb in the process. As they increased physical memory, they also increased their SGA size db_block_buffers. Since they've upgraded they have noticed a significant decrease in performance (the way it was described to me was it was 7 out of 10, and is now 3 out of 10..). Has anybody else done a system upgrade of this nature that has caused less than desirable effects? Any pointers as to what to look at? We've requested some stats (top wait stats etc.) and I'll feed these back as and when I get them - but I thought I'd throw this out to you guys in the vague hope that someone has experienced some relatively similar experiences. Cheers! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
RE: 24 x 7 x 365
True 24x365 is just about impossible. No if, ands. or buts about it. Why is because of the number of factors outside your control that affect system availability. Sure your web sever and database are up 24x365, but your ISP has 1 hour down time each month for maintenance. OOPS!! from a customer point of view your NOT 24x365. Also that fiber optic cable running out of your building to the phone pole is available for some heavy equipment operator to slice through while working on the sewer system, OOPS!! So you can't have 24x365 no matter what. What you should do is try to adapt the changes you need into the downtime that's imposed on you. That's what we do it works very nicely. Besides being completely redundant is extremely expensive, like two of everything, including building, air-conditioning, fiber optic cables, etc. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Tracy Rahmlow [mailto:[EMAIL PROTECTED]Sent: Wednesday, December 10, 2003 11:44 AMTo: Multiple recipients of list ORACLE-LSubject: 24 x 7 x 365Hello, Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve this issue? Are there any other areas of concerns that I should be thinking about? For example, analyzing with the validate clause and its impacts on the transaction system. Thanks American Express made the followingannotations on 12/10/2003 09:41:15 AM--**"This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you."**==
RE: 10g new features (was: dc_used_extents ,dc_free_extents and d
Tanel, Whthough they may not have the sqlplusw.exe for windoes is the sqlplus.exe still there? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, December 10, 2003 4:45 PM To: Multiple recipients of list ORACLE-L d Excellent slide show Tanel! Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/10/2003 3:34 PM dc_histogram_defs) Pete, I'd like to clarify my position first: I don't have any burning problem that would compel me to start testing 10g. I want only to learn the new features. Btw, if you want to learn some of the 10g database engine new features (not the marketing buzzwords), then check out one of my presentations from: http://integrid.info/Poder_10g_New_Features.ppt Tanel. -- 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: 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: 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).
RE: Database management techniques and frameworks
When I had only one instance to baby sit doing the script thing was OK, but it also missed things like the listener not being up and lost of other problems. Besides it was a pain to add it to each new server as they came along. Therefore I re-wrote those scripts into one C language program with integrated SMTP capabilities, a couple of extprocedures as well as a built in that understands when a DB is suppose to be down for backup or in hot backup mode. I then added common fix it stuff that I've always had to do manually hung it off the side on an NT server we had. It's been here for the past 10 years and even understands Oracle 9i. Sends a message to the pager/cell phone when needed otherwise just sends the old e-mail. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, December 05, 2003 1:50 PM To: Multiple recipients of list ORACLE-L 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: 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).
RE: java package to run OS command
John, I agree and am encouraging the external C procedures since their simpler, and can create log files as well. BTW: Whoever authored the Java procedure on that web page should be shot. I can just see someone passing 'rm -fr $ORACLE_HOME' to it. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, December 04, 2003 12:00 PM To: Multiple recipients of list ORACLE-L yeah, I'm trying to get away from C external procedures ...but java is beginning to look just as much a hassle. Why is running a OS command such hassle? -Original Message- Sent: 04 December 2003 15:40 To: Multiple recipients of list ORACLE-L Here's another link to a good Java Stored Procedure for this: http://www.oracle-base.com/Articles/8i/ShellCommandsFromPLSQL.asp But the same caveats apply. We're using an external procedure written in C for this instead of Java, and I use a shell that checks PRODUCT_PROFILE for authority to run the command, before it will call the extproc. I'm happy to share source code with anyone interested it doing it this way, but external procedures are a bit harder to set up than Java Stored Procedures and open you to a few security hazards. -Original Message- Sent: Thursday, December 04, 2003 10:09 AM To: Multiple recipients of list ORACLE-L John, it is available on asktom as well, but read the caution Tom explains. Restrict it to only executables you want. Asktom has example. 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- Sent: Thursday, December 04, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Which book is that? -Original Message- Sent: 04 December 2003 14:35 To: Multiple recipients of list ORACLE-L its in tom kytes first book. might be on his webpage. From: John Dunn [EMAIL PROTECTED] Date: 2003/12/04 Thu AM 08:49:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: java package to run OS command I need a java package that will allow me to run OS commands(Unix) from a stored procedure. Anyone got one? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Anyone used EMC Timefinder to replicate DB's
YES. Do you have specific questions??? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Loughmiller, Greg [mailto:[EMAIL PROTECTED]Sent: Monday, December 01, 2003 1:54 PMTo: Multiple recipients of list ORACLE-LSubject: Anyone used EMC Timefinder to replicate DB's hey guys - Working on some replication efforts.. And I haven't used EMC Timefinder to push data from one DB to another.. Are there any documents with the details available? I'm working on getting thru the EMC web site as well as metalink, but wanted to throw this out on the list since everyone is so helpful:-) And I'm also in too much of a hurry to RTFM:-) since I need to get something done by Wednesday.. Thanks in advance! Greg Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office)
RE: Happy Thanksgiving
And may you all be back here on Monday, in one piece, safe sound. No DWI's now, you hear! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 10:34 AM To: Multiple recipients of list ORACLE-L Guys, Happy Thanksgiving to everyone. May your bellies be full but your waistline not expand, may you enjoy the time with your family and friends and avoid any of the other drama Thanks so much to everyone for their help and camaraderie. Just enjoy yaself! -- 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: 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).
RE: Happy Thanksgiving
In the UK I believe you simply classify it as driving without due care don't you?? Damn, wish the police around here had that capability. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, November 26, 2003 11:10 AM To: Multiple recipients of list ORACLE-L I reckon its DRIVING WHILE INTOXICATED but I woudn't swear to it as I am in the UK -Original Message- Quintin, Richard Sent: 26 November 2003 15:59 To: Multiple recipients of list ORACLE-L DWI = DDL while inebriated? On Wed, 2003-11-26 at 10:49, Goulet, Dick wrote: And may you all be back here on Monday, in one piece, safe sound. No DWI's now, you hear! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 10:34 AM To: Multiple recipients of list ORACLE-L Guys, Happy Thanksgiving to everyone. May your bellies be full but your waistline not expand, may you enjoy the time with your family and friends and avoid any of the other drama Thanks so much to everyone for their help and camaraderie. Just enjoy yaself! -- 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 Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- A loving person lives in a loving world. A hostile person lives in a hostile world. Everyone you meet is your mirror. -- Ken Keyes Jr. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Move datafiles, but can't delete them
What is most likely happening is that a server, as in client dedicated, has an interest in those files consequently Windoze won't let you delete then until the end user terminates their session. Now while Unix won't give you an error in this situation you'll notice that you don't get the disk space back immediately. Also on Unix, provided you have a helpful SA, you can run an fuser on the files to find out who is using them. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, November 25, 2003 8:24 AM To: Multiple recipients of list ORACLE-L Luc, The next time you bounce the database you will be able to delete the files. Windows keeps a lock on these files for some odd reason. In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my controlfiles to reflect the new path 4- I brought my tablespace back online 5- I backuped up my controlfile to trace to make sure it using the new path 6- When I wanted to delete the 2 old datafiles, Windows gave me an sharing violation error. My question is Who using it? My controlfiles are changed, when I query DBA_DATA_FILES, i'm using the new path. I don't want to bounce my production database Any ideas TIA Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
RE: WebSphere and Oracle
The problem is most likely in the JDBC driver, not the database. I've run into similar problems with JDBC and ODBC drivers in the past. I've got to agree with IBM, upgrade the driver all should be well. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, November 25, 2003 7:44 AM To: Multiple recipients of list ORACLE-L All, We are putting up a new Java application that is running under WebSphere. WebSphere uses two different schema's - the one where the application tables are all built, and another schema that contains one table (SESSIONS) that it uses to keep track of the application. This SESSIONS table has three RAW columns that essentionally hold BLOB information. The Application is connecting using the thin driver. We are getting a java error. According to the IBM web site: When using the LOB columns (BLOBS and CLOBS) with Oracle 8i, you cannot use setCharacterStream or setBinaryStream to set BLOBS and CLOBS when the size of the LOB columns is greater than 4k. Oracle has lifted the restriction in the 9i R2 OCI driver (thick driver). If you have one of these error messages or you know that your data exceeds 4k, update to Oracle 9i R2 and use the OCI driver when connecting to Oracle server. If you cannot update to Oracle 9i R2, contact Oracle Support. I will be contacting Oracle support, but was wondering if anyone else has experienced this and did they find an answer to the problem. thanks Tom Mercadante Oracle Certified Professional -- 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: 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).
RE: WebSphere and Oracle
Absolutely. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, November 25, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Thanks Dick. I agree it's not a database problem, but they try and push it my way because it's Oracle. I'm pushing back. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 9:50 AM To: Multiple recipients of list ORACLE-L The problem is most likely in the JDBC driver, not the database. I've run into similar problems with JDBC and ODBC drivers in the past. I've got to agree with IBM, upgrade the driver all should be well. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, November 25, 2003 7:44 AM To: Multiple recipients of list ORACLE-L All, We are putting up a new Java application that is running under WebSphere. WebSphere uses two different schema's - the one where the application tables are all built, and another schema that contains one table (SESSIONS) that it uses to keep track of the application. This SESSIONS table has three RAW columns that essentionally hold BLOB information. The Application is connecting using the thin driver. We are getting a java error. According to the IBM web site: When using the LOB columns (BLOBS and CLOBS) with Oracle 8i, you cannot use setCharacterStream or setBinaryStream to set BLOBS and CLOBS when the size of the LOB columns is greater than 4k. Oracle has lifted the restriction in the 9i R2 OCI driver (thick driver). If you have one of these error messages or you know that your data exceeds 4k, update to Oracle 9i R2 and use the OCI driver when connecting to Oracle server. If you cannot update to Oracle 9i R2, contact Oracle Support. I will be contacting Oracle support, but was wondering if anyone else has experienced this and did they find an answer to the problem. thanks Tom Mercadante Oracle Certified Professional -- 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: 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: 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: 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).
RE: Beginning of a global unravelling?
Bambi, I'm afraid I read something different in that story, but equally pleasant. Like a lot of things in this world sometimes we need to push the press-to-test button and see how the shoe fits before making up our minds. Companies I believe needed to do the same thing with offshoring their IT activity. I've no doubt that a fair amount of application development will remain offshore just like manufacturing jobs are, but that support and infrastructure jobs that have been previously offshored will come back. I'll put it this way, I support a remote site right now that's 3000 miles away. When the crap hits the fan it can easily take 3 times as long to fix as it does when your right there. It was also the reason I recently spent 2 weeks on the road namely down range at that site. Now if all you want to do is monitor the site from India, sure you can do that. But until they invent a way for me to instantiounsly physically access the tape library or cdrom out there from her! e it ain't happening. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, November 25, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Friends -- Looks like Dell is moving call centers from India to Texas and Tennessee. Seems that the folks in India, while very polite, have thick accents. Um. Thick, non-Texan, accents. Anyway, this may bode well for us technical folks if this [and the previously discussed article] are the beginning of a bring the tech jobs back trend. This may imply that we are [temporarily] moving away from a globalized technical labor force (and therefore global wage equilibrium). Of course, it could mean nothing beyond what it says. Time will tell. In the meantime, here's the link. Enjoy! Bambi. http://www.cnn.com/2003/TECH/biztech/11/24/dell.call.centers.ap/index.html -- 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: 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).
RE: ORA-28595 when calling external proc
Igor, I can't remember exactly where I read it, but under Oracle 9i the DLL or SO file(unix) needs to be in either $ORACLE_HOME/bin or $ORACLE_HOME/lib only. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]Sent: Monday, November 24, 2003 12:19 PMTo: Multiple recipients of list ORACLE-LSubject: ORA-28595 when calling external proc Oracle 9.2.0.1 on Windows XP Im getting ORA-28595: Extproc agent: Invalid DLL Path when calling external procedure. I know, I specified the correct path to my dll, when issuing CREATE LIBRARY statement. I noticed (when switched from 8.1.5 on NT to 9.2 on Win2000) that dll path became case-sensitive (all of a sudden). But, thats not a problem in this case. Any thoughts? Btw, ORA-28595 is not in Error Messages manual. Igor Neyman, OCP DBA [EMAIL PROTECTED]
RE: ORA-28595 when calling external proc
Well!! You didn't say itthat eXtreme Perversion was the OS. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]Sent: Monday, November 24, 2003 1:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-28595 when calling external proc $ORACLE_HOME/bin is where I put my dll. Whats puzzling is that it works under 8.1.5/NT or 9.2/Win2000, but not under 9.2/XP. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Goulet, DickSent: Monday, November 24, 2003 12:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-28595 when calling external proc Igor, I can't remember exactly where I read it, but under Oracle 9i the DLL or SO file(unix) needs to be in either $ORACLE_HOME/bin or $ORACLE_HOME/lib only. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]Sent: Monday, November 24, 2003 12:19 PMTo: Multiple recipients of list ORACLE-LSubject: ORA-28595 when calling external proc Oracle 9.2.0.1 on Windows XP Im getting ORA-28595: Extproc agent: Invalid DLL Path when calling external procedure. I know, I specified the correct path to my dll, when issuing CREATE LIBRARY statement. I noticed (when switched from 8.1.5 on NT to 9.2 on Win2000) that dll path became case-sensitive (all of a sudden). But, thats not a problem in this case. Any thoughts? Btw, ORA-28595 is not in Error Messages manual. Igor Neyman, OCP DBA [EMAIL PROTECTED]
RE: ORA-28595 when calling external proc
Actually, since I use HP-UX, I was of the practice to keep a soft link to all of the SO files that we had in use in a specific directory off of $ORACLE_BASE. It just saved a ton of other problems. Now since Oracle in enforcing that my job becomes a touch easier. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]Sent: Monday, November 24, 2003 3:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-28595 when calling external proc My bad. Thanks to everyone who replied. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Goulet, DickSent: Monday, November 24, 2003 3:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-28595 when calling external proc Well!! You didn't say itthat eXtreme Perversion was the OS. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]Sent: Monday, November 24, 2003 1:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-28595 when calling external proc $ORACLE_HOME/bin is where I put my dll. Whats puzzling is that it works under 8.1.5/NT or 9.2/Win2000, but not under 9.2/XP. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Goulet, DickSent: Monday, November 24, 2003 12:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-28595 when calling external proc Igor, I can't remember exactly where I read it, but under Oracle 9i the DLL or SO file(unix) needs to be in either $ORACLE_HOME/bin or $ORACLE_HOME/lib only. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]Sent: Monday, November 24, 2003 12:19 PMTo: Multiple recipients of list ORACLE-LSubject: ORA-28595 when calling external proc Oracle 9.2.0.1 on Windows XP Im getting ORA-28595: Extproc agent: Invalid DLL Path when calling external procedure. I know, I specified the correct path to my dll, when issuing CREATE LIBRARY statement. I noticed (when switched from 8.1.5 on NT to 9.2 on Win2000) that dll path became case-sensitive (all of a sudden). But, thats not a problem in this case. Any thoughts? Btw, ORA-28595 is not in Error Messages manual. Igor Neyman, OCP DBA [EMAIL PROTECTED]
RE: RE: Development vs. Production DBA
Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: [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: 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: 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).
RE: Oracle 10g Migration
Mladen, Direct 8i(as in 8.1.7.4) to 10 or do you HAVE to go through 9.x first? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, November 21, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Yes. On 11/21/2003 09:29:31 AM, Tracy Rahmlow wrote: Does anybody know whether or not Oracle will support and upgrade of an 8i database to 10? Thanks American Express made the following annotations on 11/21/2003 07:28:27 AM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == Mladen Gogala Oracle DBA 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: 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).
RE: orbitz fiasco
The Orbitz fiasco and what happen was up on Public radio here about a week after the mess. They interviewed the CIO who sounded like a trusting soul looking to get screwed. According to her, she was informed it was a database problem by her smart people. I therefore would conclude that restoring the control file from tape was probably one of their ideas vs. OTS. I have found that OTS seems to believe in the worst case scenario when you call them. BTW, according to the interview the CIO was not informed of the true cause of the problem until just before the interview. Moral: Believe in your people, but know what you, and they, are talking about. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, November 20, 2003 10:05 AM To: Multiple recipients of list ORACLE-L oracle support has a bit to be desired somedays, sceanario: someone(CE) accidentally makes the prod SAN, a scratch pool instead of the new SAN. Literally wipes it clean, think of fdisk like. get OS reloaded, oracle binaries reloaded, need to do restore/recovery via rman, repository wasted also, oracle 8, so we need to manually extract the controlfile from backups, then restore the database, no biggie got the RF rman book in front of me and i've tested this a few dozen times, client wants to talk to support just to be sure, get support on the phone, he starts down the road of we'll have to extract the controlfile and every single data file manually using the dbms_backup_restore package. I'm like wait a minute, if we get the controlfile, the info on the backups is stored there, we can just let rman do the extraction of that stuff, support is like yea that will work also. doooh.. joe Jesse, Rich wrote: Wow. Restoring a control file from tape for this situation? Man, that's not just wrong, it's fundamentally wrong. At a high-profile site that must have Gold Support (or whatever they're calling it today), if this is true someone was really not thinking that day. Kinda interesting about the firmware upgrade, too, because my Oracle DBA instructor used an example exactly like this to explain why control files must be triplicated even if you're RAIDed up the wahzoo. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Thursday, November 20, 2003 7:40 AM To: Multiple recipients of list ORACLE-L I was at an Oracle usergroup meeting last week and a guy at Oracle said the following happened. Can anyone confirm? Just curious. 1. Orbitz did an upgrade to some software other than Oracle. I think it was firmware. They did NOT test it first. Did it directly in production. 2. This corrupted a control file. They did multiplex their control files. 3. However, they chose to restore the control file from tape. This invalidated their database. 4. So the delay was restoring the whole database from tape and rolling forward. Anyone know if that is what what happened? Wouldnt surprise me, however, it is Oracle's side of the story... I know atleast one other person from the list was there. I forget the guys name who said it. He is one the RAC specialists. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: New Virus alert from paypal
Sure have I don't have a PayPall account. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, November 19, 2003 10:40 AM To: Multiple recipients of list ORACLE-L List, Any one else get word of this new virus? Ron Mar-D Greer 11/19/2003 9:34:44 AM There is a new virus that has surfaced since last week. This virus reports that users need to update their PayPal accounts. Do not open this, delete the e-mail as PayPal has not issued this e-mail and the e-mail itself contains a virus. The actual e-mail reads as follows: (Found virus WORM_MIMAIL.J in file www.paypal.com.pif) ** Dear PayPal member, We regret to inform you that your account is about to be expired in next five business days. To avoid suspension of your account you have to reactivate it by providing us with your personal information. To update your personal profile and continue using PayPal services you have to run the attached application to this email. Just run it and follow the instructions. IMPORTANT! If you ignore this alert, your account will be suspended in next five business days and you will not be able to use PayPal anymore. Thank you for using PayPal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Bad performance because of wrong characterset?
I really hate to admit it, but I agree. Doing otherwise is a simple recipe for hypertension, stroke an early death. Besides, it's so much more gratifying be able to say I TOLD YOU SO. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, November 17, 2003 4:50 PM To: Multiple recipients of list ORACLE-L DENNIS WILLIAMS wrote: Being a DBA means learning to live with disappointment. Well said, well spoken, Dennis. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Migration utility to convert 32 bit DB to 64 bit?
It's actually an sql script that's located in the $ORACLEHOME/rdbms/admin directory called utlirp. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 10:39 AM To: Multiple recipients of list ORACLE-L hello, We currently have oracle (32 bit) 9.2.0.3 db running on Win 2000. We got new itanium machines running Win 2003 (64 bit). We want to move the db running on 32 bit win 2000 server to Wiin 2003 (64 bit) server. Someone suggested that (after installing the 64 bit oracle software) we copy the datafiles over and run a migration utility to convert the 32 bit db to 64 bit. I personally have never heard of such utility. Could you please share your experiences. How reliable is this utility and where to find the docs on this Thanks, Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Migration utility to convert 32 bit DB to 64 bit?
To the best of my knowledge, I've done this several times now, you run the appropriate upgrade script then the utlirp.sql script to migrate from 32 to 64 bit. Now you must have the 64 bit executables installed or it creates some interesting results. But you don't have to rebuild the database. UNLESS your changing os platforms like Sun to WinDoze. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 3:29 PM To: Multiple recipients of list ORACLE-L So - this is a stupid question: We cannot use Oracle's migration utility to go from 32-bit 8.1.7 to 64-bit 9i? - Hmmm, create database , export, import. -Original Message- Sent: Thursday, November 13, 2003 2:49 PM To: Multiple recipients of list ORACLE-L It's actually an sql script that's located in the $ORACLEHOME/rdbms/admin directory called utlirp. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 10:39 AM To: Multiple recipients of list ORACLE-L hello, We currently have oracle (32 bit) 9.2.0.3 db running on Win 2000. We got new itanium machines running Win 2003 (64 bit). We want to move the db running on 32 bit win 2000 server to Wiin 2003 (64 bit) server. Someone suggested that (after installing the 64 bit oracle software) we copy the datafiles over and run a migration utility to convert the 32 bit db to 64 bit. I personally have never heard of such utility. Could you please share your experiences. How reliable is this utility and where to find the docs on this Thanks, Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: [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: 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).
RE: Stop using SYS, SYSTEM?
Personal Opinion here: I don't use SYS or system for anything where it is not absolutely required. All of the DBA's have the DBA role granted to them we log on as ourselves. This is simply so that we don't accidentally step on something really important. In general one should never create anything in the SYS schema since it won't get exported when you do a full database export. System is a little safer, but still.. I have seen a couple of white papers that have made statements such as SYS and SYSTEM should be locked and never opened as well as other similar alarming (to the pointy headed non-technical types) statements that indicate that disaster is waiting in the wings. All of them can be summarily dismissed as having been written by those who are similarly non-technical. BTW: Even if you are auditing, a DBA can eliminate the records in V$Audit of they wish. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, November 12, 2003 3:05 PM To: Multiple recipients of list ORACLE-L We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of the DBA's. Don't ask me why. Nothing is being audited in 99% of the databases. They just say it in a paper some where so they said we shouldn't use it. This seems like it would cause lots of problems with exports, imports, installs, etc... Has anyone had to deal with this type of request? Any potential problems with making the change? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Uncle Larry, wake up!!!
AH, My choice in an Open Source DB. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, November 07, 2003 9:45 AM To: Multiple recipients of list ORACLE-L Let's not forget PostgreSQL, arguably more enterprise-ready than MySQL, and now with clustering on Linux: http://www.open-mag.com/0182533982.shtml Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Thursday, November 06, 2003 8:04 PM To: Multiple recipients of list ORACLE-L 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,8590 0,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 -- 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: 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).
RE: Change dedicated server to shared server
Oracle version?? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, November 07, 2003 10:34 AMTo: Multiple recipients of list ORACLE-LSubject: Change dedicated server to shared server Hi Can somebody tell me the steps for changingmy serverconfiguration from dedicated server to shared server? Thanks Do you Yahoo!?Protect your identity with Yahoo! Mail AddressGuard
RE: Uncle Larry, wake up!!!
OH, ANCIENT History!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, November 07, 2003 2:09 PM To: Multiple recipients of list ORACLE-L Nope, we would be using IMS and/or CICS DL/I. On the beginning of my career, when I was a junior programmer using completely outdated, badly overused language (COBOL, for short) an ancient IBM 3084 with only 32M RAM was able to service 800+ users, as long as there weren't too many TSO users. I'd hate to explain what CICS, MVS and TSO are (or were), but those things were way more optimal and way faster then any other database I've ever seen, and that was happenening in the year 1986. At the end of 1986, I was reassigned to check out that wonderful new box with OS that has held so much promiseVAX 3900 with VMS 4.6. Does anybody still remember the NULL.COM and NULL process? On 11/07/2003 01:44:35 PM, [EMAIL PROTECTED] wrote: yes, but as you all know by now ( or should know ), having the best technology does not make you a market leader. MySQL will walk all over PostgreSQL, regardless of the superiority of the latter. Otherwise, we would all be using RDB, wouldn't we? Jared Jesse, Rich [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/07/2003 06:45 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Uncle Larry, wake up!!! Let's not forget PostgreSQL, arguably more enterprise-ready than MySQL, and now with clustering on Linux: http://www.open-mag.com/0182533982.shtml Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Thursday, November 06, 2003 8:04 PM To: Multiple recipients of list ORACLE-L 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,8590 0,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 -- 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). Mladen Gogala Oracle DBA 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
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: 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).
RE: This is just wrong
Your right, take a visit at www.lindows.com. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, November 04, 2003 7:19 PM To: Multiple recipients of list ORACLE-L Redhat recommending windoze for desktop. http://zdnet.com.com/2100-1104_2-5101690.html -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the CACHE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Index behavior
Sami, Your problem is not with the index, but rather the cost based optimizer. Most of us have been beat severely over the head and shoulders through the years that full table scans are a BAD thing, me included BTW. Well, it's time for the old dog to learn new tricks. So that I'm not a long winded person, take a look in Select magazine, 3rd qtr 2003, for the article In Defense of Full Table Scans by Jeff Maresh. For a long time the CBO was a mystery to me as well especially when it did unexpected things like this. I've applied Jeff's ideas on computing an index's efficiency to see if it explained what the CBO did. Amazingly in 95% of the cases I've analyzed it made absolute sense. I'm including Jeff with a courtesy copy of this message so that 1) I can pat him for making the waters clear and 2) so he can add anything he desires. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, November 05, 2003 12:10 PM To: Multiple recipients of list ORACLE-L Hi List, Does someone throw ligts on the following index behavior Note a)name is an unique index column b) table and index has been analyzed b4 running the query 1) select id from table1 where name like 'ABC%'; FULL Table scan 1) select id from table1 where name like 'AB%'; Index scan name is an unique index column Any help would be really appreciated. -Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saminathan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Index behavior
Can I ask for the following: 1) The clustering factor on the index 2) number of distinct keys 3) number of leaf blocks Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, November 05, 2003 4:05 PM To: Multiple recipients of list ORACLE-L But that doesn't really explain why the optimizer chooses an FTS with a predicate that presumable is more selective (name like 'ABC%') and an index scan with a predicate that presumable is less selective (name like 'AB%'). I could understand it if it were the other way around. Is there a histogram on the name column? At 11:34 AM 11/5/2003, you wrote: Sami, Your problem is not with the index, but rather the cost based optimizer. Most of us have been beat severely over the head and shoulders through the years that full table scans are a BAD thing, me included BTW. Well, it's time for the old dog to learn new tricks. So that I'm not a long winded person, take a look in Select magazine, 3rd qtr 2003, for the article In Defense of Full Table Scans by Jeff Maresh. For a long time the CBO was a mystery to me as well especially when it did unexpected things like this. I've applied Jeff's ideas on computing an index's efficiency to see if it explained what the CBO did. Amazingly in 95% of the cases I've analyzed it made absolute sense. I'm including Jeff with a courtesy copy of this message so that 1) I can pat him for making the waters clear and 2) so he can add anything he desires. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA 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: 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).
OT: Need help with SQL*Server
OK folks I'm out on the dark side, once again. Does anyone remember how MicroSlop's BCP utility in SQL*server works? I've got a user who bought a third party SQL*server application, I won't go there, and he needs to move some data from a desktop to a laptop SQL*server database. 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).
RE: Need help with SQL*Server resolved
Thanks all for the help. As with many things, UnSubstantiated Error Reporters (USERS) tell you one thing when they mean another. In this case it wasn't SQL*server, but MSDE that was in use. Got a script off of MicroSlop's site that explained what to do. Damned messy, hope it works!! :-( Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, October 31, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Not sure what you're asking here, but SQL Server Books Online (search on bcp Utility) should give you that information. -Original Message- Sent: Friday, October 31, 2003 11:10 AM To: Multiple recipients of list ORACLE-L OK folks I'm out on the dark side, once again. Does anyone remember how MicroSlop's BCP utility in SQL*server works? I've got a user who bought a third party SQL*server application, I won't go there, and he needs to move some data from a desktop to a laptop SQL*server database. 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: Rothouse, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
