RE: Your new book
Ryan Actually the math that queueing theory is based on is not calculus. It may also help if you understand that a queue is a fancy French word for waiting line. See, doesn't it sound much more important academically if you say you study queueing theory than if you say you study waiting lines? Here is a link that may help get you started: http://www.new-destiny.co.uk/andrew/past_work/queueing_theory/Andy/statistic s.html Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 22, 2003 11:00 PM To: Multiple recipients of list ORACLE-L if someone wants to dig into the type of math you are using in your book in more depth, what level of math expertise would you recommend? Do you have to go beyond college level calculus ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 10:54 PM Dennis, Thanks. In fact, I feel the same way about this as many of you who have written about the book in the prior two days. I think the material that ended up being Part II needed to be studied, refined, and documented. And I believe it is important that this material be written in a BOOK instead of only in some electronic medium. Without Part II, I'm not sure many readers would have accepted the possibility of the rather remarkable results I promise in Parts I and III. As it happens, Part II seems to have begun serving a number of uses, some of which I didn't anticipate, including: - Those who want to take our work further can do so without having to reinvent everything we've learned. - Those who want to debate our approach can argue about it on an unambiguous technical foundation. - Forcing ourselves to write everything down in a consumer-ready format guided our making the Hotsos Profiler into a much more robust and complete product than it would have been otherwise. - Similarly, it tightened the content in our educational courses considerably. We now have excellent training material for Hotsos employees, and perhaps (if O'Reilly is lucky) university students of Oracle performance analysis around the world. - Funny enough, it turns out that some of the MySQL guys are at least considering the idea to integrate much better response time instrumentation into their kernel as a result of the book. But Mr. Milligan is absolutely right: you don't have to be able to prove why something works in order to use it. I tried to design Parts I and III to give you what you need to make the method work, regardless of whether you are interested in proving out the theory. I just didn't feel like it would be responsible to sell Part III without including Part II. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- DENNIS WILLIAMS Sent: Wednesday, October 22, 2003 6:15 PM To: Multiple recipients of list ORACLE-L I think Cary deserves a vote of appreciation for Part II of his book. I feel (based on the comments of others, haven't waded through it myself yet) that he has put Oracle performance tuning on a solid mathematical foundation. My first education was engineering and I learned was that a practice that rests on a solid mathematical foundation is not easily overturned. A great example for we DBAs is relational database theory, which rests on relational algebra. Fads come and go that threaten to obsolete the relational database, but since none of them has a solid mathematical foundation, they soon fade. If you gave me a quiz on relational algebra today, I'd probably flunk it, like many people that daily work with relational databases. But that doesn't stop us from making use of the fruits of the theory. Similarly, I don't think we need to understand Part II in detail to successfully use Cary's methods to tune an Oracle database. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 22, 2003 4:10 PM To: Multiple recipients of list ORACLE-L I also am not Cary . I have however read Cary's book from cover to cover (including spending rather too long on a romantic weekend in paris with my wife contemplating a 10046 trace parsing project :(). I Am rereading and intend to require my fellow DBAs and sysadmins to read it. However to attempt to answer your questions. Yes it is different from every other tuning book out there (though there is *some* overlap with Christpher Lawson's 'the art and science of oracle performance tuning'). The difference is exactly in the approach - the central thesis of the book is (something like) that by utilizing well specified and targeted extended sqltrace data for problem user
Re: Mauve databases use least RAM
HJR's saga still rates as one of the all-time dumbass knee-jerk reactions from Oracle damagement. And yes, I sincerely hope this message gets circulatedto as many Oracle VPs as it can. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - At the risk of opening old wounds, after what happened with Howard Rogers, I think it's a brave Oracle employee who participates in extra-curricular activities that involve the products of their employer. We are richer for it when it happens (thanks Pete, Vladimir), but I don't blame anyone at Oracle for their discretion. (And yes, I can give you a dissertation on how the work-for-hire doctrine under Australian copyright and employment law works. Whether or not this leads you to form the same abuse of process conclusions against Oracle as I did, is entirely a matter for the reader :-) ). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno 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).
Re: Re: Your new book
if i want to improve my math skills how much undergraduate math would you recommend? From: Paul Drake [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 02:29:24 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Your new book Ryan, I do not recall seeing a single dy/dx or integrand in the text. The type of math that he used, I saw in high school, and that was in the US, at a public school. Cary easily could have used real math to prove his points. He didn't. He used graphical methods, visual basic and intuition. But mostly algebra. Back in the schools that I attended, pre-algebra was in 8th grade, geometry in ninth, Algebra II in 10th, Trig in 11th and Calculus senior year. Granted, I could have placed out of 3 courses freshman year of college, as my high school kicked arse. If it were more the norm, the US would still be riding a rising productivity curve. Too bad all that what is promoted most here is entertainment. If anything, it underscored the overall problem in the US, that we don't grow grad students natively, we import them. Yeah, you don't have to have a M.S. in Comp. Sci. to be a DBA, but being able to understand (not necessarily derive) things from first principles goes a long way. But then again, I'm skewed. Engineering undergrad at Carnegie Mellon has a way of making or breaking you. And then you realize at some point, how few people get such an opportunity. btw_1, Where is Bill Nye these days? btw_2 , Ryan, in engineering, one takes at least 4 semesters of university level mathematics. If you were on the H SS, H and best dressed or Humanities and Social Sciences track, you might never have seen an ordinary differential equation, even in a calc class. The real question is, did you memorize a few formulas to get by, or did you learn math? did you gain any understanding? understanding you take with you, long after the mesmorized formulas have been dissolved by enough thursday night martinis. one equation could explain more than an entire chapter of text. no sense cutting out the meat just to dumb it down. Paul Ryan [EMAIL PROTECTED] wrote: if someone wants to dig into the type of math you are using in your book in more depth, what level of math expertise would you recommend? Do you have to go beyond college level calculus ? - Original Message - To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 22, 2003 10:54 PM Dennis, Thanks. In fact, I feel the same way about this as many of you who have written about the book in the prior two days. I think the material that ended up being Part II needed to be studied, refined, and documented. And I believe it is important that this material be written in a BOOK instead of only in some electronic medium. Without Part II, I'm not sure many readers would have accepted the possibility of the rather remarkable results I promise in Parts I and III. As it happens, Part II seems to have begun serving a number of uses, some of which I didn't anticipate, including: - Those who want to take our work further can do so without having to reinvent everything we've learned. - Those who want to debate our approach can argue about it on an unambiguous technical foundation. - Forcing ourselves to write everything down in a consumer-ready format guided our making the Hotsos Profiler into a much more robust and complete product than it would have been otherwise. - Similarly, it tightened the content in our educational courses considerably. We now have excellent training material for Hotsos employees, and perhaps (if O'Reilly is lucky) university students of Oracle performance analysis around the world. - Funny enough, it turns out that some of the MySQL guys are at least considering the idea to integrate much better response time instrumentation into their kernel as a result of the book. But Mr. Milligan is absolutely right: you don't have to be able to prove why something works in order to use it. I tried to design Parts I and III to give you what you need to make the method work, regardless of whether you are interested in proving out the theory. I just didn't feel like it would be responsible to sell Part III without including Part II. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- DENNIS WILLIAMS Sent: Wednesday, October 22, 2003 6:15 PM To: Multiple recipients of list ORACLE-L I think Cary deserves a vote of appreciation for Part II of his book. I feel (based on the comments of others, haven't waded through it myself yet) that he has put Oracle performance tuning on a solid mathematical
Re: Re: Your new book
As much as you can get. If not for Cary's book, you'll need abstract algebra for dealing with W2 forms and taxes. On 2003.10.23 08:12, [EMAIL PROTECTED] wrote: if i want to improve my math skills how much undergraduate math would you recommend? From: Paul Drake [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 02:29:24 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Your new book Ryan, I do not recall seeing a single dy/dx or integrand in the text. The type of math that he used, I saw in high school, and that was in the US, at a public school. Cary easily could have used real math to prove his points. He didn't. He used graphical methods, visual basic and intuition. But mostly algebra. Back in the schools that I attended, pre-algebra was in 8th grade, geometry in ninth, Algebra II in 10th, Trig in 11th and Calculus senior year. Granted, I could have placed out of 3 courses freshman year of college, as my high school kicked arse. If it were more the norm, the US would still be riding a rising productivity curve. Too bad all that what is promoted most here is entertainment. If anything, it underscored the overall problem in the US, that we don't grow grad students natively, we import them. Yeah, you don't have to have a M.S. in Comp. Sci. to be a DBA, but being able to understand (not necessarily derive) things from first principles goes a long way. But then again, I'm skewed. Engineering undergrad at Carnegie Mellon has a way of making or breaking you. And then you realize at some point, how few people get such an opportunity. btw_1, Where is Bill Nye these days? btw_2 , Ryan, in engineering, one takes at least 4 semesters of university level mathematics. If you were on the H SS, H and best dressed or Humanities and Social Sciences track, you might never have seen an ordinary differential equation, even in a calc class. The real question is, did you memorize a few formulas to get by, or did you learn math? did you gain any understanding? understanding you take with you, long after the mesmorized formulas have been dissolved by enough thursday night martinis. one equation could explain more than an entire chapter of text. no sense cutting out the meat just to dumb it down. Paul Ryan [EMAIL PROTECTED] wrote: if someone wants to dig into the type of math you are using in your book in more depth, what level of math expertise would you recommend? Do you have to go beyond college level calculus ? - Original Message - To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 22, 2003 10:54 PM Dennis, Thanks. In fact, I feel the same way about this as many of you who have written about the book in the prior two days. I think the material that ended up being Part II needed to be studied, refined, and documented. And I believe it is important that this material be written in a BOOK instead of only in some electronic medium. Without Part II, I'm not sure many readers would have accepted the possibility of the rather remarkable results I promise in Parts I and III. As it happens, Part II seems to have begun serving a number of uses, some of which I didn't anticipate, including: - Those who want to take our work further can do so without having to reinvent everything we've learned. - Those who want to debate our approach can argue about it on an unambiguous technical foundation. - Forcing ourselves to write everything down in a consumer-ready format guided our making the Hotsos Profiler into a much more robust and complete product than it would have been otherwise. - Similarly, it tightened the content in our educational courses considerably. We now have excellent training material for Hotsos employees, and perhaps (if O'Reilly is lucky) university students of Oracle performance analysis around the world. - Funny enough, it turns out that some of the MySQL guys are at least considering the idea to integrate much better response time instrumentation into their kernel as a result of the book. But Mr. Milligan is absolutely right: you don't have to be able to prove why something works in order to use it. I tried to design Parts I and III to give you what you need to make the method work, regardless of whether you are interested in proving out the theory. I just didn't feel like it would be responsible to sell Part III without including Part II. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- DENNIS WILLIAMS Sent: Wednesday, October 22, 2003 6:15 PM To: Multiple recipients of list ORACLE-L I think Cary deserves a vote of appreciation for Part II of his book. I feel (based on the comments of others,
RE: Change Character sets
Thanks. But since it was an import from an US7ASCII database I am completely confident that there'll be no problems. But that's about the only circumstances in which I'd try something like that. Goulet, Dick DGoulet To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @vicr.com cc: Sent by: Subject: RE: Change Character sets ml-errors 10/22/2003 05:24 PM Please respond to ORACLE-L Well, let me know when the shotgun goes off. I'll send the black lab out to find you!! *-) Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, October 22, 2003 4:20 PM To: Multiple recipients of list ORACLE-L I found it. Trying to explain it tripped those last few synapses. Not sure if it should be shared since it can completely destroy your database. But when you're certain about your data, it's a lifesaver. Kids, don't try this at home - Alter database character set INTERNAL_USE new_character_set No restrictions on the new_character_set but if you're wrong about your data you're one dead duck. Goulet, Dick DGoulet To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @vicr.com cc: Sent by: Subject: RE: Change Character sets ml-errors 10/22/2003 03:29 PM Please respond to ORACLE-L Thomas, Well I can't help you on that score. I do remember a discussion on going from US7ACSII to WE8ISO8859P1. And if my memory servers me correctly that is a one way trip. I believe you may well have to re-export the data rebuild the database. Is there a specific reason why you need to do that? Personally I'd leave well enough alone. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, October 22, 2003 3:09 PM To: Multiple recipients of list ORACLE-L But I want to do it the other way round. No, there are no '?'s. The data is all US7ASCII. Yes, you're right, the import was done into a database with the wrong character set. I know about the export/import route but I believe that there is some utility that will do the conversion from WE8ISO8859P1 to US7ASCII as long as all the data in the database is compatible with US7ASCII (as is the case). I just don't remember what it is or where to find it. I remember seeing a discussion of this (I believe it was here) but searching the ORACLE-L archive, GOOGLE, and the Oracle documentation has not turned up anything. Maybe it's just wishful thinking but I'm hoping that someone would have a better memory and could point me in the right direction. SQL SELECT * FROM NLS_DATABASE_PARAMETERS; PARAMETER VALUE -- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET WE8ISO8859P1 NLS_CALENDAR GREGORIAN NLS_DATE_FORMATDD-MON-RR
RE: Change Character sets
Yup. That's the ticket. Quintin, Richard To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rquintincc: @vt.edu Subject: RE: Change Character sets Sent by: ml-errors 10/22/2003 03:49 PM Please respond to ORACLE-L You might try ALTER DATABASE CHARACTER SET internal_use us7ascii; Make sure you know what you're doing. See Metalink Doc Id 100751.996 On Wed, 2003-10-22 at 15:29, Goulet, Dick wrote: Thomas, Well I can't help you on that score. I do remember a discussion on going from US7ACSII to WE8ISO8859P1. And if my memory servers me correctly that is a one way trip. I believe you may well have to re-export the data rebuild the database. Is there a specific reason why you need to do that? Personally I'd leave well enough alone. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, October 22, 2003 3:09 PM To: Multiple recipients of list ORACLE-L But I want to do it the other way round. No, there are no '?'s. The data is all US7ASCII. Yes, you're right, the import was done into a database with the wrong character set. I know about the export/import route but I believe that there is some utility that will do the conversion from WE8ISO8859P1 to US7ASCII as long as all the data in the database is compatible with US7ASCII (as is the case). I just don't remember what it is or where to find it. I remember seeing a discussion of this (I believe it was here) but searching the ORACLE-L archive, GOOGLE, and the Oracle documentation has not turned up anything. Maybe it's just wishful thinking but I'm hoping that someone would have a better memory and could point me in the right direction. SQL SELECT * FROM NLS_DATABASE_PARAMETERS; PARAMETER VALUE -- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET WE8ISO8859P1 NLS_CALENDAR GREGORIAN NLS_DATE_FORMATDD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMATHH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR NLS_TIMESTAMP_TZ_FORMATDD-MON-RR HH.MI.SSXFF AM TZR NLS_DUAL_CURRENCY $ NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCPFALSE NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_RDBMS_VERSION 9.2.0.3.0 SQL ALTER DATABASE CHARACTER SET US7ASCII; ALTER DATABASE CHARACTER SET US7ASCII * ERROR at line 1: ORA-12712: new character set must be a superset of old character set Goulet, Dick DGoulet To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @vicr.com cc: Sent by:
RE: Change Character sets
Developers who know their stuff but don't know Oracle. I don't know Java. US7ASCII works. Other character sets don't. Why? Just one of life's little mysteries as far as I'm concerned. Probably there's something they could do to make it work with other character sets but I don't know what it is and neither do they. Jesse, Rich Rich.Jesse To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @qtiworld.com cc: Sent by: Subject: RE: Change Character sets ml-errors 10/22/2003 07:04 PM Please respond to ORACLE-L How/where did you find this? I know older versions of Perl/DBI/DBD::Oracle silently fail on login attempts, but we've had no problems with Java on 8.1.7.4/HPUX. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Thomas Day [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: Change Character sets Java drivers seem to require US7ASCII. -- 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: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
What happened to Howard Rogers ?
Ok, I'll bite. What happened to Howard Rogers ? - Original Message - HJR's saga still rates as one of the all-time dumbass knee-jerk reactions from Oracle damagement. And yes, I sincerely hope this message gets circulatedto as many Oracle VPs as it can. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sdf INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Do not connect Oracle DB to the Internet. Oracle Alert #59
Important: Please read the following Oracle Alert. We strongly recommend that you do not connect the Oracle Database directly to the Internet. Got your attention? That is what is in the Alert. These alerts are beginning to come all too often. Sounds just like Microsoft's software, yeah? Buffer Overflow in Oracle Database Server Binaries This is with the Oracle kernel/binary itself ie 'oracle' or 'oracleO' file in $ORACLE_HOME/bin. Description A potential buffer overflow has been discovered in the oracle and oracleO (the letter O) binaries of the Oracle Database. A knowledgeable and malicious local user can exploit this buffer overflow to execute code on the operating system hosting the Oracle Database server. Products Affected · Oracle 9i Database Release 2, Version 9.2.x · Oracle 9i Database Release 1, Version 9.0.x Platforms Affected All supported UNIX and Linux operating system variants. Patch only available for Linux right now. So who found out this vulnerability? David Litchfield? Aaron Newman? I know it is a bit silly to ask but does anyone know how to exploit this vulnerability? Send it to me directly if you dont want to reply publicly ta tony 2003alert59.pdf Description: Adobe PDF document
RE: Your new book
Title: Message -Original Message-From: Cary Millsap [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 22, 2003 7:15 PMTo: Multiple recipients of list ORACLE-LSubject: FW: Your new book Niall, This is a very kind, and I believe (maybe it's only hopeful belief) a very accurate depiction of what the book is. I have read Hawking's note to which you refer. Honestly, I included the formulas for two reasons: 1) To communicate the relationships of trace lines to each other would have been virtually impossible to do economically with words. I really don't know how I would have done it, since there are so many necessary references to the central e ~ c + sum(ela) equation. 2) In the queueing chapter, I believe I needed to show people my work. Otherwise, I don't know how they could have confirmed or refuted my statements...[Shrek] oh how the last one brings back memories of teachers yelling at me "yes that's the right answer, but you have to show your work!" and me saying "but that's the only answer that fits!"... i lost every time.;-) and i got bad math grades too.;-) not having read the book yet, i for one, am glad you did show the work even if it is hard to follow. i like authors who don't think the reader has the lights on but no one's home.;-) -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] O'Toole's commentary on Murphy's Law: Murphy was an optimist.
RE: Mauve databases use least RAM
HJR's saga still rates as one of the all-time dumbass knee-jerk reactions from Oracle damagement. I don't mean to rub salt in an open sore, but you've got me curious. What happened with HJR? I don't think I've heard anything about this... -- My employers like me, but not enough to let me speak for them. Greg Norris Sprint LTD Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do not connect Oracle DB to the Internet. Oracle Alert #59
I find it more interesting that the problem doesn't apply to Windows servers... ;) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: 23 October 2003 14:25To: Multiple recipients of list ORACLE-LSubject: Do not connect Oracle DB to the Internet. Oracle Alert #59Important: Please read the following Oracle Alert.We strongly recommend that you do not connect the Oracle Databasedirectly to the Internet.Got your attention? That is what is in the Alert. These alerts are beginning to come all too often. Sounds just like Microsoft's software, yeah?Buffer Overflow in Oracle Database Server BinariesThis is with the Oracle kernel/binary itself ie 'oracle' or 'oracleO' filein $ORACLE_HOME/bin.DescriptionA potential buffer overflow has been discovered in the oracle and oracleO (the letter O) binariesof the Oracle Database. A knowledgeable and malicious local user can exploit this buffer overflowto execute code on the operating system hosting the Oracle Database server.Products Affected· Oracle 9i Database Release 2, Version 9.2.x· Oracle 9i Database Release 1, Version 9.0.xPlatforms AffectedAll supported UNIX and Linux operating system variants.Patch only available for Linux right now. So who found out this vulnerability? David Litchfield? Aaron Newman?I know it is a bit silly to ask but does anyone know how to exploit this vulnerability? Send it to me directly if you dont want to reply publiclytatony
RE: Re[2]: Your new book
Jonathan Gennick scribbled on the wall in glitter crayon: O'Reilly's production people would have been much happier had I given that advice (I didn't), and had Cary taken it (he wouldn't have, I'm sure). There was much wailing and gnashing of teeth over Cary's math. Many battles were fought over it. Much blood was spilled. and why? if the math was needed to make the point without spending twice the amount of words, why did they think the readers would understand that fact at least even if they didn't completely follow the math? sorry i guess i just don't understand. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Too many of us look upon Americans as dollar chasers. This is a cruel libel, even if it is reiterated thoughtlessly by the Americans themselves. - Albert Einstein -- 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).
RE: Do not connect Oracle DB to the Internet. Oracle Alert #59
No problem, it's unbreakable!!! ;-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Thursday, October 23, 2003 8:25 AMTo: Multiple recipients of list ORACLE-LSubject: Do not connect Oracle DB to the Internet. Oracle Alert #59Important: Please read the following Oracle Alert.We strongly recommend that you do not connect the Oracle Databasedirectly to the Internet.Got your attention? That is what is in the Alert. These alerts are beginning to come all too often. Sounds just like Microsoft's software, yeah?Buffer Overflow in Oracle Database Server BinariesThis is with the Oracle kernel/binary itself ie 'oracle' or 'oracleO' filein $ORACLE_HOME/bin.DescriptionA potential buffer overflow has been discovered in the oracle and oracleO (the letter O) binariesof the Oracle Database. A knowledgeable and malicious local user can exploit this buffer overflowto execute code on the operating system hosting the Oracle Database server.Products Affected· Oracle 9i Database Release 2, Version 9.2.x· Oracle 9i Database Release 1, Version 9.0.xPlatforms AffectedAll supported UNIX and Linux operating system variants.Patch only available for Linux right now. So who found out this vulnerability? David Litchfield? Aaron Newman?I know it is a bit silly to ask but does anyone know how to exploit this vulnerability? Send it to me directly if you dont want to reply publiclytatony
Re: What happened to Howard Rogers ?
howard posted on dejanews that he is contracting to oracle. so i doubt he got fired. he probably just quit. We all know alot of people who 'used to work for oracle'. biggest downside is the lydian third site is gone. Had all the copies of his essays on it. apparently oracle theratened to sue him over it. Supposedly in australia companies own you while you work theere and you need special permission to publish. From: sdf [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 09:24:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: What happened to Howard Rogers ? Ok, I'll bite. What happened to Howard Rogers ? - Original Message - HJR's saga still rates as one of the all-time dumbass knee-jerk reactions from Oracle damagement. And yes, I sincerely hope this message gets circulatedto as many Oracle VPs as it can. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sdf INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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).
stupid dbms_job question
im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Your new book
i took a discrete math class last summer at a state university. Id recommend for all technical people. I hadnt had math in 10 years and found it extremely difficult(half the class failed). the problem solving skills you get out of doing are incredible. No you dont learn new oracle commands but your able to solve problems easier. I found that understanding data modelling and general algorithm writing is easier now as well. It also blends well with undergraduate computer science classes(which I found to be more difficult than actually doing my job, btw). Im planning on taking more math over the next few years. Just not sure what to take. I dont really like it. Its one of those things that sucks to do while you learn it,but when your done your glad you did it. thanks for the in depth posts Carrie. From: Thater, William [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 09:39:24 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Your new book -Original Message- Sent: Wednesday, October 22, 2003 7:15 PM To: Multiple recipients of list ORACLE-L Niall, This is a very kind, and I believe (maybe it's only hopeful belief) a very accurate depiction of what the book is. I have read Hawking's note to which you refer. Honestly, I included the formulas for two reasons: 1) To communicate the relationships of trace lines to each other would have been virtually impossible to do economically with words. I really don't know how I would have done it, since there are so many necessary references to the central e ~ c + sum(ela) equation. 2) In the queueing chapter, I believe I needed to show people my work. Otherwise, I don't know how they could have confirmed or refuted my statements... [Shrek] oh how the last one brings back memories of teachers yelling at me yes that's the right answer, but you have to show your work! and me saying but that's the only answer that fits!... i lost every time.;-) and i got bad math grades too.;-) not having read the book yet, i for one, am glad you did show the work even if it is hard to follow. i like authors who don't think the reader has the lights on but no one's home.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] O'Toole's commentary on Murphy's Law: Murphy was an optimist. Title: Message -Original Message-From: Cary Millsap [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 22, 2003 7:15 PMTo: Multiple recipients of list ORACLE-LSubject: FW: Your new book Niall, This is a very kind, and I believe (maybe it's only hopeful belief) a very accurate depiction of what the book is. I have read Hawking's note to which you refer. Honestly, I included the formulas for two reasons: 1) To communicate the relationships of trace lines to each other would have been virtually impossible to do economically with words. I really don't know how I would have done it, since there are so many necessary references to the central e ~ c + sum(ela) equation. 2) In the queueing chapter, I believe I needed to show people my work. Otherwise, I don't know how they could have confirmed or refuted my statements...[Shrek] oh how the last one brings back memories of teachers yelling at me "yes that's the right answer, but you have to show your work!" and me saying "but that's the only answer that fits!"... i lost every time.;-) and i got bad math grades too.;-) not having read the book yet, i for one, am glad you did show the work even if it is hard to follow. i like authors who don't think the reader has the lights on but no one's home.;-) -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] O'Toole's commentary on Murphy's Law: Murphy was an optimist.
Re[4]: Your new book
Thursday, October 23, 2003, 8:49:29 AM, you wrote: TW and why? if the math was needed to make the point TW without spending twice the amount of words, why did they TW think the readers would understand that fact at least TW even if they didn't completely follow the math? sorry i TW guess i just don't understand. It was all our own inadequacy, having nothing to do with readers. We weren't collectively prepared to handle the level of math that Cary put in his book. Our tools weren't up to the task. We couldn't take Cary's equations from Word and build them in Frame, which is the tool our production people use for page layout. In the end, Cary had to supply many of the equations as graphics that we embedded into the text. Then there are all those Greek letters. We had to buy a new font for those, and I know buying a new font sounds simple, but it apparently brought some complication to someone, and the amount of people-time it took to push that font purchase through was quite substantial as well. Publishers aren't magical. They all optimize their tools, processes, and people for the types of book they most often publish. In our case, Cary's book came along and broke the model. I probably overstated the case a bit in my earlier note, but it is true that the level of math caused a fair bit of consternation. Let me point out though, that in the end we did what it took to keep the math intact and get the book out. We learned a lot in the process too. I know enough now that I'm sure the next such book will fly through the production process much more easily than this first one. 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).
Re: What happened to Howard Rogers ?
I am one of those 'used to work for oracle'. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 9:04 AM howard posted on dejanews that he is contracting to oracle. so i doubt he got fired. he probably just quit. We all know alot of people who 'used to work for oracle'. biggest downside is the lydian third site is gone. Had all the copies of his essays on it. apparently oracle theratened to sue him over it. Supposedly in australia companies own you while you work theere and you need special permission to publish. From: sdf [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 09:24:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: What happened to Howard Rogers ? Ok, I'll bite. What happened to Howard Rogers ? - Original Message - HJR's saga still rates as one of the all-time dumbass knee-jerk reactions from Oracle damagement. And yes, I sincerely hope this message gets circulatedto as many Oracle VPs as it can. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sdf INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: 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).
RE: RE: Your new book
Title: RE: RE: Your new book I took a discrete structures for computer science math class as an undergrad. It was great, once I got past the Swedish accent of the instructor and figured out that contraposite was the contra opposite. Yes, a highly recommended class, even if you don't do well in it. It changes how you approach things. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 23, 2003 9:14 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Your new book i took a discrete math class last summer at a state university. Id recommend for all technical people. I hadnt had math in 10 years and found it extremely difficult(half the class failed). the problem solving skills you get out of doing are incredible. No you dont learn new oracle commands but your able to solve problems easier. I found that understanding data modelling and general algorithm writing is easier now as well. It also blends well with undergraduate computer science classes(which I found to be more difficult than actually doing my job, btw). Im planning on taking more math over the next few years. Just not sure what to take. I dont really like it. Its one of those things that sucks to do while you learn it,but when your done your glad you did it. thanks for the in depth posts Carrie. From: Thater, William [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 09:39:24 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Your new book -Original Message- Sent: Wednesday, October 22, 2003 7:15 PM To: Multiple recipients of list ORACLE-L Niall, This is a very kind, and I believe (maybe it's only hopeful belief) a very accurate depiction of what the book is. I have read Hawking's note to which you refer. Honestly, I included the formulas for two reasons: 1) To communicate the relationships of trace lines to each other would have been virtually impossible to do economically with words. I really don't know how I would have done it, since there are so many necessary references to the central e ~ c + sum(ela) equation. 2) In the queueing chapter, I believe I needed to show people my work. Otherwise, I don't know how they could have confirmed or refuted my statements... [Shrek] oh how the last one brings back memories of teachers yelling at me yes that's the right answer, but you have to show your work! and me saying but that's the only answer that fits!... i lost every time.;-) and i got bad math grades too.;-) not having read the book yet, i for one, am glad you did show the work even if it is hard to follow. i like authors who don't think the reader has the lights on but no one's home.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] O'Toole's commentary on Murphy's Law: Murphy was an optimist. The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
Do not connect Oracle DB to the Internet. Oracle Alert #59
Title: Message Theexploit involves passing a large argv[1] argument to the oracle or oracle0 binary. Credit for discovering thevulnerability goes to [EMAIL PROTECTED]. The error was first discovered on a LINUX box but I have seen notes that AIX is vulnerable as well. What is not published in North America yet, is the Oracle alert you mention. The first security note I saw on this was published on 19 October. Yes there are people who know how to exploit the vulnerability. The vulnerability was shown to Oracle over a month ago, according to the comments in a proof of concept exploit. One workaround is to take off the setuid bit from the Oracle binary Isit really necessary to set this. How many places still have users log into the database server? Oracle has recommended putting its databases behind firewalls for some time. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 6:25 AMTo: Multiple recipients of list ORACLE-LSubject: [SPAM:#] Do not connect Oracle DB to the Internet. Oracle Alert #59Important: Please read the following Oracle Alert.We strongly recommend that you do not connect the Oracle Databasedirectly to the Internet.Got your attention? That is what is in the Alert. These alerts are beginning to come all too often. Sounds just like Microsoft's software, yeah?Buffer Overflow in Oracle Database Server BinariesThis is with the Oracle kernel/binary itself ie 'oracle' or 'oracleO' filein $ORACLE_HOME/bin.DescriptionA potential buffer overflow has been discovered in the "oracle" and "oracleO" (the letter O) binariesof the Oracle Database. A knowledgeable and malicious local user can exploit this buffer overflowto execute code on the operating system hosting the Oracle Database server.Products Affected Oracle 9i Database Release 2, Version 9.2.x Oracle 9i Database Release 1, Version 9.0.xPlatforms AffectedAll supported UNIX and Linux operating system variants.Patch only available for Linux right now. So who found out this vulnerability? David Litchfield? Aaron Newman?I know it is a bit silly to ask but does anyone know how to exploit this vulnerability? Send it to me directly if you dont want to reply publiclytatony
RE: Re[4]: Your new book
Jonathan Gennick scribbled on the wall in glitter crayon: It was all our own inadequacy, having nothing to do with readers. We weren't collectively prepared to handle the level of math that Cary put in his book. Our tools weren't up to the task. We couldn't take Cary's equations from Word ah... thank you for the explanation and the insight to the publishing practice. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] We should take care not to make the intellect our god; it has, of course, powerful muscles, but no personality. - Albert Einstein -- 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).
Re[2]: Your new book
Thursday, October 23, 2003, 2:54:26 AM, Niall wrote: NL I wouldn't want anyone to think that I personally think that the math is NL a mistake for the book, my concern is that it may hurt sales NL unnecessarily. We'll never really know, because this is one of those cases where it's just not possible to do things both ways, under the exact same circumstances, and compare the results. Personally, I'm more motivated by good reviews than I am by sales, though I realize that sales are necessary. Let me just add that, since it's release, Cary's book is O'Reilly's top-selling Oracle title. All that math doesn't seem to have hurt, and no one at O'Reilly is complaining, least of all me. 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).
RE: Shutdown takes 20+ minutes
Jeremiah and Jared, Big thanks for your comments. I was going down the path of trying to figure out the cause versus just solving the problem. I understand from a co-worker there was a huge thread on shutdown abort before I got on this listserver. Appreciate the info again! Now I just have to convince mgmt it's OK. Mary Jo -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 22, 2003 3:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Shutdown takes 20+ minutes Uh-oh. I'm sure Jeremiah is digging up some old posts for cut and paste to avoid typing. Here, I'll save him the trouble. = There are unknowns with every feature. ABORT is a feature just asIMMEDIATE is. In version 7, I encountered a bug with IMMEDIATE thatrequired recovery from a backup, and eventually manual BBED'ing of theSYSTEM datafile by Oracle BDE. SO maybe we shouldn't use immediateeither. I'll just call all the users and ask them to log off."Hello? My name is is Jeremiah from Amazon.com, and I was wonderingif you could stop buying books right now..."I would submit that ABORT is one of the most tested features of Oracle8 and 9 - not at Oracle, but at customer sites - because it is one ofthe most used. No serious HA site is still using IMMEDIATE on aconsistent basis, because it is unreliable. Consistent performancerequires the use of ABORT for reliable shutdowns and for clusterfailovers. Oracle even recommends it in their FailSafe manual.So my advice is to cite the exact circumstances, test case and numberof your bug for those few still using version 7. Many features werescrewed in V.7. I would submit that in your case, with anunresponsive instance, you may have had problems outside your databasethat contributed to the need for recovery, and are mistakenlyfingering ABORT as the cause. Since Oracle 7.3.4, I have not heardreliable accounts of any problems with ABORT. This is mainly becausetransactions are transactions, and they have to have a response fromthe O/S and recorded their redo before a COMMIT is returned to theapplication. That makes them recoverable as soon as they areconsidered successful by the app. = "Tortorelli, Mary Jo" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/22/2003 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Shutdown takes 20+ minutesJeremiah,We do shutdown immediate as the standard weekly cycle/cold-backup of this production db. The cluster failover is part of the procedure and is a test - it's not a real failover. We don't want to routinely shutdown abort and increase corruption potential if it's not necessary. We want a clean shutdown for the backup and I'm trying to figure out why it takes so long since it's messing up the fail-over test that follows.-Original Message-Sent: Tuesday, October 21, 2003 7:24 PMTo: Multiple recipients of list ORACLE-LI bet you can get that 4 minutes down to 1 if you dispense with thedown/up/down and just do checkpoint/abort/failover/startup.Why bother with "immediate" for a cluster failover? Isn't it just awaste of time?--Jeremiah Wiltonhttp://www.speakeasy.net/~jwiltonOn Tue, 21 Oct 2003, Tortorelli, Mary Jo wrote: An 8.1.7.4 production database on HP-UX 11.0 running Apps 11.5.7 takes long to shutdown and is causing cluster failover testing to time out. Upon shutdown immediate it takes 1-3 minutes for the DATABASE DISMOUNTED, DATABASE CLOSED, and Archival stopped messages in the alert log but then it takes another 15+ minutes for the ORACLE database shutdown message to return to sqlplus. During this time, a ps -ef shows no background or ghost database processes - only the sqlplus process. If a shutdown abort, startup restrict, shutdown is done after five minutes, the shutdown after the abort/startup takes 4 minutes total. Does anyone know what Oracle does between DATABASE CLOSED, ARCHIVE STOPPED and the ORACLE database shutdown message? Has anyone else run into this?-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jeremiah WiltonINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like
Re[6]: Your new book
Thursday, October 23, 2003, 9:33:14 AM, you wrote: TW ah... thank you for the explanation and the insight to TW the publishing practice. It's an interesting business. Fun to be in at times, and frustrating at others. Cary's book counts as one of the fun times. He changed my thinking completely when it comes to managing performance. There were days when he'd send me a new chapter, I'd read it, and I'd just want to jump up, should Hallalujah!, and do the victory dance all around my office. I learned a LOT while editing his book. 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).
comparison HP-san vs netapp
Hi, I need urgently a qualitative comparison between an SAN (based on eva3000) and netapp F825 environment concerning oracle. We have been tallking to suppliers now for weeks and suddenly a manager comes up with a netapps alternative and we have a deadline to decide already weeks ago. Anybody with real good links or shortlist of conclusions, criteria on this? Thnx in advance, Jeroen
RE: Oracle pricing ain't going down
And this surprises you??? Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, October 22, 2003 5:24 PM To: Multiple recipients of list ORACLE-L Subject:Oracle pricing ain't going down http://www.crn.com/sections/BreakingNews/dailyarchives.asp?ArticleID=45368 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Mauve databases use least RAM
Dennis, Personally I don't care if any Oracle employee ever answers a post on the list. The point is they are out there listening to the REAL world of Oracle use. That's a ton better than their competition, and I believe we've all benefited from that alone. As for when they do post an answer, E-mail I do not consider as an Official communication from anyone. When I see it in black and white on Oracle letter head, then it's Official. Otherwise it's just advise, use at your own risk. Now is there any way we can get Uncle Larry to subscribe/listen??? *-) Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, October 22, 2003 8:59 PM To: Multiple recipients of list ORACLE-L Mladen - I can think of far more reasons why an employee would NOT participate on a public list than reasons why they would. 5. You can easily become the target of wrath for anyone that hates Oracle. 4. The slightest misstatement on your part could easily be interpreted as a lack of knowledge. 3. Any of your statements could be taken as official Oracle statements. 2. Postings from this list do get circulated through Oracle. Some V.P. you never met may decide he doesn't like you. 1. You could easily get fired. That said, how do you know that more Oracle employees don't participate? Easy enough to get a Hotmail account and participate quietly. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 22, 2003 3:00 PM To: Multiple recipients of list ORACLE-L I just received Effective Oracle by Design and reading the foreword I noticed not only the familiar names of Connor McDonald, Anjo Kolk and Mogens Norgaard, but I also saw this list mentioned explicitly. Is Mr. Tom Kyte a member of this list? Does he read it? Does his staff read it? I was wandering why so few oracle employees (to my knowledge, Vladimir is the only one) takes part in this list. 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: 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: stupid dbms_job question
id prefer to handle this in the database. From: Gene Sais [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 10:29:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: stupid dbms_job question It's called cron :). Or you could run a shell script that executes then sleeps for 5 mins. [EMAIL PROTECTED] 10/23/03 10:09AM im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- 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). It's called cron :). Or you could run a shell script that executes then sleeps for 5 mins. [EMAIL PROTECTED] 10/23/03 10:09AM im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows...variable jobno number;variable instno number;begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit;end;i then do:dbms_job.interval(:jobno,'trunc(sysdate+1/96)';commit;my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run.Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- 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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: questions regarding nologging
Mladen, Thanks for your input. Yes, I also rebuilt all relevant indexes with nologging option so no normal redo genearation either. However, the table was moved into LMT tbs from a dictionery managed tbs. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 22 Oct 2003 21:39:25 -0800 Well, Rafiq, when you move the table, indexes are marked stale, which means that you must rebuild them. Marking indexes unusable shouldn't generate any redo log, except for the dictionary block that was altered. Other then that, moving table is an opration roughly analogous to CTAS and I suspect that if the target table is NOLOGGING, that the whole operation is done in the direct fashion, with block prebuild and appended below the high watermark. I tried it and I didn't see any redo log generation either. That is probably the reason why splitting partitions also doesn't generate redo, as Arup has noted. Oracle has highly optimized many of these operations and avoding excessive redo log generarion is one of the best optimizations one can make. On 2003.10.22 23:54, M Rafiq wrote: Waleed, I agree with you as I moved a 5GB table last week with nologging option with extent size 500M and did not see any normal redo generation for that. It is 8.1.7.0 database. that table has 8 indexes for total size of almost 3GB. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 22 Oct 2003 17:14:24 -0800 Alter table ...Move TS nologging is 100% equivalent to CTAS and should generate minimal amount of logging even if it ran serially (no PQ). Actually the type of command is considered CREATE TABLE So I'm not sure how the original poster was able to determine that the operation generated huge redo logs! This could be possible if the redo logs has to do with Extents management and the needed RBS to manage it (specially if the extents are very small and the TS is dictionary based). Waleed -Original Message- Sent: Wednesday, October 22, 2003 4:54 PM To: Multiple recipients of list ORACLE-L That's because nologging attribute only affects the direct operations, i.e. the the operations that prebuild blocks and add them below the flood watermark. That includes sqlloader with direct=y, inserts with /*+ append */ hint and CTAS. Normal SQL based operations are not affected. On 10/22/2003 04:39:34 PM, Roger Xu wrote: Hi Gurus, I have a couple of questions regarding nologging. 1) alter table tabname move tablespace tbsname nologging; How come this sql still generated same amount of redo logs equal to the size of the table? 2) alter index idxname rebuild tablespace tbsname nologging; This sql only generate minimum redo logs. But the index ends up LOGGING=NO in dba_indexes view. How do I turn the logging on for this index? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE:
Yes. However, every time he has replied to me, he has been confident that he IS right. Mind you, Richard, you are immortalised now ! Hemant At 05:04 PM 22-10-03 -0800, you wrote: So now the blame rests solely on Richard for any material in the note that's wrong. :) Check the latest update: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=182699.1 Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Millsap Sent: Wednesday, October 22, 2003 2:35 AM To: Multiple recipients of list ORACLE-L Oops, I didn't see that part. Thanks for the catch, Hemant. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Hemant K Chitale Sent: Tuesday, October 21, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Unfortunately, the lines Unoccupied space on indexes occurs when a key value changes, and the index row is deleted from one place (Leaf Block) and inserted into another. Deleted Leaf Rows are not reused. Therefore, indexes whose columns are subject to intensive value change should be rebuilt periodically, since they become naturally fragmentated. are still visible in Note 182699.1 Hemant At 08:29 AM 20-10-03 -0800, you wrote: Fyi, Oracle updated note 182699.1 last Friday. The inaccurate statements about index fragmentation have been removed. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Richard Foote Sent: Friday, October 17, 2003 6:29 AM To: Multiple recipients of list ORACLE-L Separate Hi Hemant, One word perfectly describes the Metalink article you highlighted: Crap ;) A nice example of how Oracle Corp is the greatest myth generator of them all !! It's all rather sad and embarressing isn't. Thanks for the headsup. Anyone in a position to get the note removed ? Cheers Richard Quoting Metalink Note 182699.1 bde_rebuild.sql Validates and Rebuilds Fragmentated Indexes (8.0-9.0) Index fragmentation occurs when a key value changes, and the index row is deleted from one place (Leaf Block) and inserted into another. Deleted Leaf Rows are not reused. Therefore indexes whose columns are subject to value change must be rebuilt periodically since they become naturally fragmentated. An index is considered to be 'fragmentated' when more than 20% of its Leaf Rows space is empty because of the implicit deletes caused by indexed columns value changes. Fragmentated indexes degrade the performance of index range scan operations. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
RE: What happened to Howard Rogers ?
His essays are still available here http://www.geocities.com/lydian_third/ Lisa. -Original Message- Sent: 23 October 2003 15:04 To: Multiple recipients of list ORACLE-L howard posted on dejanews that he is contracting to oracle. so i doubt he got fired. he probably just quit. We all know alot of people who 'used to work for oracle'. biggest downside is the lydian third site is gone. Had all the copies of his essays on it. apparently oracle theratened to sue him over it. Supposedly in australia companies own you while you work theere and you need special permission to publish. From: sdf [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 09:24:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: What happened to Howard Rogers ? Ok, I'll bite. What happened to Howard Rogers ? - Original Message - HJR's saga still rates as one of the all-time dumbass knee-jerk reactions from Oracle damagement. And yes, I sincerely hope this message gets circulatedto as many Oracle VPs as it can. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sdf INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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). This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk This message is intended only for the use of the person(s) (Intended Recipient) to whom it is addressed. It may contain information, which is privileged and confidential. Accordingly any dissemination, distribution, copying or other use of this message or any of its content by any person other than the Intended Recipient may constitute a breach of civil or criminal law and is strictly prohibited. If you are not the Intended Recipient, please contact the sender as soon as possible. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dobson, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: stupid dbms_job question
I had an issue with dmbs_job where the jobs would become broken if I altered them. Have you checked if the job becomes broken after you change the interval? Gudmundur im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- 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). Þessi póstur var sendur með vefpósti mi, http://www.mi.is -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Performance problem with Shareplex and Oracle
Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT -- ------ -- --- 17 latch free 83 69 1 ,012048193 17 log file sync15 0 9 ,6 17 db file sequential read 52 0 6 ,115384615 17 file open 1 0 00 17 SQL*Net message to client 74791 0 27 ,000361006 17 SQL*Net message from client 74791 05235 ,069995053 I really don't see any Oracle performance problems. My problem is the backlog (queue) of Shareplex is getting bigger and bigger. Where is the bottleneck? The only thing I can see is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? 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).
Re: Cache a table
Hi
It depends on how you define an LRU list I guess. When I close my eyes and
picture the cache, I still see a LRU in there somewhere. Please note I don't
often close my eyes in this manner ;)
Also when you say that the CACHE option has no effect, that's also a little
questionable. This is just a portion of a post I recently sent to
comp.databases.oracle.server in the Cache A Table thread:
Simple demo on 9.2, the BOWIE table is approximately 13,000 blocks, SMALL is
117 blocks:
SQL alter table bowie nocache;
Table altered.
SQL select object_name, object_id, data_object_id from dba_objects where
object
_name in ('BOWIE', 'SMALL');
OBJECT_NAME OBJECT_ID DATA_OBJECT_ID
--- -- --
BOWIE31379 31379
SMALL31457 31457
SQL select * from bowie; (run with autotrace traceonly)
SQL select count(*) from x$bh where obj=31379;
COUNT(*)
--
18
Note that only the last few blocks from the FTS actually remain in memory.
If I repeat the select, I still have the same result from x$bh and the same
number of *physical reads occur each time.
If I run the same thing with my small table which has about 117 blocks,
the same thing happens
SQL alter table small nocache;
Table altered.
SQL select * from small;
SQL select count(*) from x$bh where obj=31457;
COUNT(*)
--
18
Note that again only the last few blocks from the FTS actually remain in
memory. If I repeat the select, I still have the same result from x$bh and
again the same number of physical reads occur each time.
OK, lets change my small table and cache the thing and see if I get a
different result ...
SQL alter table small cache;
Table altered.
SQL select * from small;
SQL select count(*) from x$bh where obj=31457;
COUNT(*)
--
117
I now see that all 117 blocks (that's all data blocks + segment header) are
all now cached as expected. Repeated reruns of the select now generate *no*
physical I/Os.
But what if I now run a select on my big BOWIE table, what effect will
this have on the SMALL cached blocks ?
SQL select * from bowie;
SQL select count(*) from x$bh where obj=31379;
COUNT(*)
--
18
Nothing new here, only the last few blocks again remain from the BOWIE table
with the same physical I/Os generated.
SQL select count(*) from x$bh where obj=31457;
COUNT(*)
--
117
and thankfully nothing has changed with the SMALL table as a result. These
blocks still remain cached and have not been dislodged as a result of the
FTS on the big BOWIE table (as they sit safely somewhere near the middle,
cold side of the LRU)
Finally, what if we play silly buggers and decide to cache the big BOWIE
table ...
SQL alter table bowie cache;
Table altered.
SQL select * from bowie;
SQL select count(*) from x$bh where obj=31379;
COUNT(*)
--
1338
We now see that a whole heap of buffers have now been cached, approximately
10%. However, again the physical I/Os remain constant because we are still
not effectively caching the table (the undocumented parameters behind the
scene kick in to prevent the whole cache from flooding).
But the effect on poor SMALL...
SQL select count(*) from x$bh where obj=31457;
COUNT(*)
--
1
only one poor block (the header) has survived the experience :(
Hope this clears something up !!
Cheers
Richard Foote
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 10:59 PM
Mike:
I guess we are aware there is no concept of LRU or MRU in current
versions of Oracle and I don't think CACHE option will influence the
behavior. With the new algorithm the MFU blocks are already in the hot
end (unless they are read using CR read in that case they will be in
cold end since we set the _db_aging_freeze_cr to TRUE) and we don't
need to cache the blocks explicitely.
You can monitor the behavior of this using the X$BH (espicially the
last two columns TCH and TIM).
=
Have a nice day !!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Richard Foote
INET: [EMAIL
How to trace 3rd party app
Hi DBAs, How can I trace a 3rd party app that produces a ora-3113 error? I am looking into dbms_support package but I am not sure what trace event and level it does. Thanks Rick -- 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).
Oracle 8 support notice?
Hey folks, there was a post late last week that had the details of the 8i Support extension. Would someone be so kind to forward that post to me "off post" please? Specifically - looking for the metalink info that spells that out. Thanks! Greg
Re: Performance problem with Shareplex and Oracle
With 2 CPUs, a Run-Queue of 1.27 isn't high. As SharePlex seems to be the only process taking CPU, it is taking 100% of 1 CPU. If it is one process only, then the CPU speed __could__ [and I'm not saying IS] the constraint. Adding CPUs wouldn't help. However, upgrading to a faster CPU would help. My comments are just a generalisation. Hemant At 07:29 AM 23-10-03 -0800, you wrote: Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT -- ------ -- --- 17 latch free 83 69 1 ,012048193 17 log file sync15 0 9 ,6 17 db file sequential read 52 0 6 ,115384615 17 file open 1 0 00 17 SQL*Net message to client 74791 0 27 ,000361006 17 SQL*Net message from client 74791 05235 ,069995053 I really don't see any Oracle performance problems. My problem is the backlog (queue) of Shareplex is getting bigger and bigger. Where is the bottleneck? The only thing I can see is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: stupid dbms_job question
Just a shot in the dark Have you set initialization parameters in the init file? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 6:14 PM To: Multiple recipients of list ORACLE-L Subject: Re: Re: stupid dbms_job question id prefer to handle this in the database. From: Gene Sais [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 10:29:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: stupid dbms_job question It's called cron :). Or you could run a shell script that executes then sleeps for 5 mins. [EMAIL PROTECTED] 10/23/03 10:09AM im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- 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: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What happened to Howard Rogers ?
Not from here... temporarily unavailable. : ) Pat. -Original Message- Sent: Thursday, October 23, 2003 12:24 PM To: Multiple recipients of list ORACLE-L His essays are still available here http://www.geocities.com/lydian_third/ Lisa. -Original Message- Sent: 23 October 2003 15:04 To: Multiple recipients of list ORACLE-L howard posted on dejanews that he is contracting to oracle. so i doubt he got fired. he probably just quit. We all know alot of people who 'used to work for oracle'. biggest downside is the lydian third site is gone. Had all the copies of his essays on it. apparently oracle theratened to sue him over it. Supposedly in australia companies own you while you work theere and you need special permission to publish. From: sdf [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 09:24:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: What happened to Howard Rogers ? Ok, I'll bite. What happened to Howard Rogers ? - Original Message - HJR's saga still rates as one of the all-time dumbass knee-jerk reactions from Oracle damagement. And yes, I sincerely hope this message gets circulatedto as many Oracle VPs as it can. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sdf INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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). This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk This message is intended only for the use of the person(s) (Intended Recipient) to whom it is addressed. It may contain information, which is privileged and confidential. Accordingly any dissemination, distribution, copying or other use of this message or any of its content by any person other than the Intended Recipient may constitute a breach of civil or criminal law and is strictly prohibited. If you are not the Intended Recipient, please contact the sender as soon as possible. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dobson, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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
Re: stupid dbms_job question
An interval of trunc(sysdate)+(trunc(to_char(sysdate,'s')/900)+1)*5/24/60 ought to give you every 5 minutes. Courtesy of Tom... On Thu, 2003-10-23 at 10:29, Gene Sais wrote: It's called cron :). Or you could run a shell script that executes then sleeps for 5 mins. [EMAIL PROTECTED] 10/23/03 10:09AM im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- 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). Richard Quintin, DBA Information Systems Computing, DBMS Virginia Tech -- Magnificent promises are always to be suspected. -- Theodore Parker -- 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).
RE: Oracle pricing ain't going down
NO, not really, but I was hoping based on Uncle Larry's statements. Lets put it this way, IF we could get a site license from Oracle (As Uncle Larry defined it) for the same price per year, or less, as our current support contract the discussions about SQL*Server and PostGreSql would come to a screeching halt. Then the only fly in the ointment would be HP-UX. Linux will probably replace the it, someday. Now if there's a courageous Oracle employee out there who wants to forward things!!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, October 23, 2003 10:25 AM To: Multiple recipients of list ORACLE-L And this surprises you??? Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, October 22, 2003 5:24 PM To: Multiple recipients of list ORACLE-L Subject:Oracle pricing ain't going down http://www.crn.com/sections/BreakingNews/dailyarchives.asp?ArticleID=45368 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: stupid dbms_job question
what initialization parameters? job_queue_processes is fine. From: Gints Plivna [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 11:49:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Re: stupid dbms_job question Just a shot in the dark Have you set initialization parameters in the init file? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 6:14 PM To: Multiple recipients of list ORACLE-L Subject: Re: Re: stupid dbms_job question id prefer to handle this in the database. From: Gene Sais [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 10:29:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: stupid dbms_job question It's called cron :). Or you could run a shell script that executes then sleeps for 5 mins. [EMAIL PROTECTED] 10/23/03 10:09AM im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- 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: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What happened to Howard Rogers ?
Thanks for this, Lisa. The 9i New Features book on his site seems to be very good On 10/23/2003 11:24:25 AM, Dobson, Lisa wrote: His essays are still available here http://www.geocities.com/lydian_third/ Lisa. -Original Message- Sent: 23 October 2003 15:04 To: Multiple recipients of list ORACLE-L howard posted on dejanews that he is contracting to oracle. so i doubt he got fired. he probably just quit. We all know alot of people who 'used to work for oracle'. biggest downside is the lydian third site is gone. Had all the copies of his essays on it. apparently oracle theratened to sue him over it. Supposedly in australia companies own you while you work theere and you need special permission to publish. From: sdf [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 09:24:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: What happened to Howard Rogers ? Ok, I'll bite. What happened to Howard Rogers ? - Original Message - HJR's saga still rates as one of the all-time dumbass knee-jerk reactions from Oracle damagement. And yes, I sincerely hope this message gets circulatedto as many Oracle VPs as it can. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sdf INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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). This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk This message is intended only for the use of the person(s) (Intended Recipient) to whom it is addressed. It may contain information, which is privileged and confidential. Accordingly any dissemination, distribution, copying or other use of this message or any of its content by any person other than the Intended Recipient may constitute a breach of civil or criminal law and is strictly prohibited. If you are not the Intended Recipient, please contact the sender as soon as possible. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dobson, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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,
RE: Do not connect Oracle DB to the Internet. Oracle Alert #59
Ian - I haven't been able to locate this on Metalink, but can you give a quick idea about how I can ensure I don't have a vulnerability here? Our databases are behind firewalls and all access is through app servers. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 23, 2003 9:25 AM To: Multiple recipients of list ORACLE-L The exploit involves passing a large argv[1] argument to the oracle or oracle0 binary. Credit for discovering the vulnerability goes to [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] . The error was first discovered on a LINUX box but I have seen notes that AIX is vulnerable as well. What is not published in North America yet, is the Oracle alert you mention. The first security note I saw on this was published on 19 October. Yes there are people who know how to exploit the vulnerability. The vulnerability was shown to Oracle over a month ago, according to the comments in a proof of concept exploit. One workaround is to take off the setuid bit from the Oracle binaryIs it really necessary to set this. How many places still have users log into the database server?Oracle has recommended putting its databases behind firewalls for some time. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, October 23, 2003 6:25 AM To: Multiple recipients of list ORACLE-L Important: Please read the following Oracle Alert. We strongly recommend that you do not connect the Oracle Database directly to the Internet. Got your attention? That is what is in the Alert. These alerts are beginning to come all too often. Sounds just like Microsoft's software, yeah? Buffer Overflow in Oracle Database Server Binaries This is with the Oracle kernel/binary itself ie 'oracle' or 'oracleO' file in $ORACLE_HOME/bin. Description A potential buffer overflow has been discovered in the oracle and oracleO (the letter O) binaries of the Oracle Database. A knowledgeable and malicious local user can exploit this buffer overflow to execute code on the operating system hosting the Oracle Database server. Products Affected * Oracle 9i Database Release 2, Version 9.2.x * Oracle 9i Database Release 1, Version 9.0.x Platforms Affected All supported UNIX and Linux operating system variants. Patch only available for Linux right now. So who found out this vulnerability? David Litchfield? Aaron Newman? I know it is a bit silly to ask but does anyone know how to exploit this vulnerability? Send it to me directly if you dont want to reply publicly ta tony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: CBO, RBO and will v5 ever really go away?
You are able to run your SQL without schema-statistics, even if OPTIMIZER_MODE=CHOOSE ? Hemant At 10:54 AM 20-10-03 -0800, you wrote: Didn't I mention that? Bug 2954921... simple query blows away one of their internal views. Here's a snippet of the text from the TAR. select a.* from nt_admin_place a, nt_country c where c.country_id in (select id from TEMP_ADMINPLACE union select id from TEMP_ADMINBORDER ) and a.admin_level = 1 and c.country_id = a.admin_place_id order by a.admin_place_id ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-00904: VW_NSO_1.$nso_col_1: invalid identifier -Original Message- Sent: Monday, October 20, 2003 1:14 PM To: Multiple recipients of list ORACLE-L what is the bug? From: Bellow, Bambi [EMAIL PROTECTED] Date: 2003/10/20 Mon PM 02:04:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: CBO, RBO and will v5 ever really go away? Unfortunately, our applications fall into the second category. And due to the complexity of the queries being run, attempting to turn on CBO also activates a bug for which Oracle has a fix in v10.1 but will not do a backport, and so, until we are ready to go to 10.1, we are stuck with RBO, and because we develop a commercial product in use by the general public, often in realtime situations (while people are driving their vehicles), our need for QA is extraordinarily high, and a change in underlying platform would trigger many many manmonths of labor. In short, if we were to schedule an upgrade for business purposes on our time schedule, it would be one thing, but we do not want to be forced into an upgrade by external circumstance (read: Oracle bug). So, RBO is for us at this juncture. Bambi. -Original Message- Sent: Monday, October 20, 2003 12:44 PM To: Multiple recipients of list ORACLE-L generally speaking there are two groups of people using the RBO. 1. The DBAs who have been around for 15 years and doesnt read release notes and doesnt feel the need to read release notes or documentation because he knows everything. He may have tried the CBO in 1995 and had 1-2 bad experiences. 2. People who have to because they are using off the shelf cross platform applications. They are required to use the RBO or their support contract for these products will be invalidated. They are generally using the RBO for a combination of 3 reasons. 1. They dont know what they are doing. 2. They have a 'layered complex view' model. that goes multi-levels deep, and has complex functions. They do this to make it easier to port to multiple types of databases and keep prices down. CBO doesnt work well in this condition. 3. They tuned for the RBO 10 years ago and do not want to spend the time or money tuning for the CBO because Oracle is just one of many databases that they port to. They are trying to keep costs down for small shops and have to really watch expenses. Most people who buy these applications dont have large budgets. From: Stephane Paquette [EMAIL PROTECTED] Date: 2003/10/20 Mon PM 01:29:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: CBO, RBO and will v5 ever really go away? 38 is my age, Mladen is 42 Stephane -Original Message- Bellow, Bambi Sent: 20 octobre, 2003 13:04 To: Multiple recipients of list ORACLE-L Let's do the time warp again! 2003-1961=42... But, I liked 1999 better... just a jump to the left... One thing about living in the past... The rent sure is cheaper. Bambi (feeling that 38 is a spry young thang) -Original Message- Sent: Monday, October 20, 2003 11:44 AM To: Multiple recipients of list ORACLE-L Is 38 that old ??? Stephane -Original Message- Mladen Gogala Sent: 17 octobre, 2003 18:00 To: Multiple recipients of list ORACLE-L Ah, another one who can claim experience. According to one of the previous post it's a genuine gold mine these days. Being born in the Jurassic (1961) has its advantages, but I have yet to find them. On 10/17/2003 05:29:31 PM, Stephane Paquette wrote: And also SQL*Loader will be rename to ODL (Oracle Data Loader) Stephane -Original Message- Mladen Gogala Sent: 17 octobre, 2003 17:19 To: Multiple recipients of list ORACLE-L Bambi, Oracle 5.1.22 was an exceptionally stable version of oracle, with very few parameters (names were TABLES,INDEXES and alike) and, as such will forever be committed to our memory. Furthermore, RBO is used in the data dictionary, just like the datatype LONG which has also, allegedly, been desupported but someone forgot to tell that to developers. There are things from V5.1.22 that I'm missing even today. There used to be something called rpf/rpt which was a very good thing for writing quick command line reports without huge and buggy gooey interface. I started
RE: Re: stupid dbms_job question
Ryan, remove the trunc() from sysdate+1/96 trunc is removing your time part. or you should be using ROUND(SYSDATE+1/96,'MI') instead. 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 ! ** 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).
RE: Do not connect Oracle DB to the Internet. Oracle Alert #59
This vulnerability is only exploitable by local users. That is to say, if you have a local user (one that uses telnet or (ideally) ssh to log in) that has permissions to execute the oracle binary, you are vulnerable to this. It has nothing to do with whether or not your system is attached to the Internet, it has to do with giving users logins on your system. Now, of course, having your database exposed to the Internet is a terrible idea, but its a generally terrible idea, not one specific to this vulnerability. Let me know if I can clarify any of this. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DENNIS WILLIAMS Sent: Thursday, October 23, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Do not connect Oracle DB to the Internet. Oracle Alert #59 Ian - I haven't been able to locate this on Metalink, but can you give a quick idea about how I can ensure I don't have a vulnerability here? Our databases are behind firewalls and all access is through app servers. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 23, 2003 9:25 AM To: Multiple recipients of list ORACLE-L The exploit involves passing a large argv[1] argument to the oracle or oracle0 binary. Credit for discovering the vulnerability goes to [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] . The error was first discovered on a LINUX box but I have seen notes that AIX is vulnerable as well. What is not published in North America yet, is the Oracle alert you mention. The first security note I saw on this was published on 19 October. Yes there are people who know how to exploit the vulnerability. The vulnerability was shown to Oracle over a month ago, according to the comments in a proof of concept exploit. One workaround is to take off the setuid bit from the Oracle binaryIs it really necessary to set this. How many places still have users log into the database server?Oracle has recommended putting its databases behind firewalls for some time. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, October 23, 2003 6:25 AM To: Multiple recipients of list ORACLE-L Important: Please read the following Oracle Alert. We strongly recommend that you do not connect the Oracle Database directly to the Internet. Got your attention? That is what is in the Alert. These alerts are beginning to come all too often. Sounds just like Microsoft's software, yeah? Buffer Overflow in Oracle Database Server Binaries This is with the Oracle kernel/binary itself ie 'oracle' or 'oracleO' file in $ORACLE_HOME/bin. Description A potential buffer overflow has been discovered in the oracle and oracleO (the letter O) binaries of the Oracle Database. A knowledgeable and malicious local user can exploit this buffer overflow to execute code on the operating system hosting the Oracle Database server. Products Affected * Oracle 9i Database Release 2, Version 9.2.x * Oracle 9i Database Release 1, Version 9.0.x Platforms Affected All supported UNIX and Linux operating system variants. Patch only available for Linux right now. So who found out this vulnerability? David Litchfield? Aaron Newman? I know it is a bit silly to ask but does anyone know how to exploit this vulnerability? Send it to me directly if you dont want to reply publicly ta tony -- 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: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).
RE: Do not connect Oracle DB to the Internet. Oracle Alert #59
Dennis, Note 251910.1 Oracle Security Alert #59 Dated: 20 October 2003 Updated: 22 October 2003 Severity: 2 Buffer Overflow in Oracle Database Server Binaries Description A potential buffer overflow has been discovered in the oracle and oracleO (the letter O) binaries of the Oracle Database. A knowledgeable and malicious local user can exploit this buffer overflow to execute code on the operating system hosting the Oracle Database server. Products Affected Oracle 9i Database Release 2, Version 9.2.x Oracle 9i Database Release 1, Version 9.0.x Platforms Affected All supported UNIX and Linux operating system variants. Required conditions for exploit A valid account on the operating system hosting the Oracle Database server. Risk to exposure The oracle and oracleO (the letter O) binaries are typically owned by the oracle operating system user account and by the dba operating system group. A malicious local user (a user defined in the operating system hosting the Oracle Database) can write code that attempts to exploit the buffer overflow in these binaries to run with the privileges of the oracle owner and potentially compromise the operating system hosting the Oracle Database server. Unless you connect the Oracle Database directly to the Internet (e.g., no intervening application server or firewall), a remote exploit via the Internet is, in our opinion, unlikely. We strongly recommend that you do not connect the Oracle Database directly to the Internet. However, this vulnerability is susceptible to an insider attack originated on an Intranet if the required conditions for exploit are met. Oracle is aware of an exploit for this vulnerability. How to minimize risk See Workaround, below. Follow Oracle's best practices for database http://otn.oracle.com/deploy/security/oracle9i/pdf/9ir2_checklist.pdf http://otn.oracle.com/deploy/security/oracle9i/pdf/9i_checklist.pdf and best practices for operating system security. Ramification for customer Oracle recommends that customers review the severity rating for this Alert and patch accordingly. See http://otn.oracle.com/deploy/security/pdf/oracle_severity_ratings.pdf for a definition of severity ratings. Workaround Remove the execute permission from the operating system group other associated with the affected binaries. Perform the following steps: # cd $ORACLE_HOME/bin # chmod o-x oracle oracleO In addition, verify that only trusted users are in the same group as are the oracle and oracleO binaries. No other changes are required. For example, do not remove setuid or setgid from the affected binaries. NOTE: This workaround protects customers from the potential vulnerability. However, after performing the steps listed above, depending on the configuration of Oracle Net Services, certain users may no longer be able to connect to the Oracle Database. Specifically, if the database is configured to use the bequeath protocol[1], then local users not in the operating system dba group will no longer be able to connect to the database. With the workaround applied, the Oracle Net Listener runs as the same user who owns the oracle binary, or as a user who is a member of the dba group. Although this is already the case for a typical installation/configuration, it is not normally required that the user running the listener has these privileges. For those customers who are unable to implement the workaround as suggested, Oracle recommends applying the patch as soon as it is available. Fixed by An interim (one-off) patch for this issue is available for the following release: Oracle 9i Database Release 9.2.0.4 for Linux x86. Download this one-off patch from the Oracle Support Services web site, Metalink ( http://metalink.oracle.com): 1.Click on the Patches button. 2.Click on the Simple Search. 3.In the Search By option select Patch Number(s) from the drop-down menu, and enter 3157063 in the box. 4.Select the required platform and language. 5.Click on the Go button. 6.Click on the Download button. 7.Recommended: you should also click on the View README button for additional information and instructions. Please review Metalink, or check with Oracle Support Services periodically for patch availability if the patch for your platform is unavailable. Oracle strongly recommends that you backup and comprehensively test the stability of your system upon application of any patch prior to deleting any of the original file(s) that are replaced by the patch. Modification History 20-OCT-03: Initial release, version 1 22-OCT-03: Identified restrictions of the provided workaround, provided patch details for Linux x86, Oracle 8i Database Release 8.1.x and earlier proved not vulnerable. [1] If the client and server exist on the same machine, a client
RE: Cache a table
Thanks for posting this. I agree LRU and MRU are just simple names for too
many methods to achieve the required functionality.
Waleed
-Original Message-
Sent: Thursday, October 23, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L
Hi
It depends on how you define an LRU list I guess. When I close my eyes and
picture the cache, I still see a LRU in there somewhere. Please note I don't
often close my eyes in this manner ;)
Also when you say that the CACHE option has no effect, that's also a little
questionable. This is just a portion of a post I recently sent to
comp.databases.oracle.server in the Cache A Table thread:
Simple demo on 9.2, the BOWIE table is approximately 13,000 blocks, SMALL is
117 blocks:
SQL alter table bowie nocache;
Table altered.
SQL select object_name, object_id, data_object_id from dba_objects where
object
_name in ('BOWIE', 'SMALL');
OBJECT_NAME OBJECT_ID DATA_OBJECT_ID
--- -- --
BOWIE31379 31379
SMALL31457 31457
SQL select * from bowie; (run with autotrace traceonly)
SQL select count(*) from x$bh where obj=31379;
COUNT(*)
--
18
Note that only the last few blocks from the FTS actually remain in memory.
If I repeat the select, I still have the same result from x$bh and the same
number of *physical reads occur each time.
If I run the same thing with my small table which has about 117 blocks,
the same thing happens
SQL alter table small nocache;
Table altered.
SQL select * from small;
SQL select count(*) from x$bh where obj=31457;
COUNT(*)
--
18
Note that again only the last few blocks from the FTS actually remain in
memory. If I repeat the select, I still have the same result from x$bh and
again the same number of physical reads occur each time.
OK, lets change my small table and cache the thing and see if I get a
different result ...
SQL alter table small cache;
Table altered.
SQL select * from small;
SQL select count(*) from x$bh where obj=31457;
COUNT(*)
--
117
I now see that all 117 blocks (that's all data blocks + segment header) are
all now cached as expected. Repeated reruns of the select now generate *no*
physical I/Os.
But what if I now run a select on my big BOWIE table, what effect will
this have on the SMALL cached blocks ?
SQL select * from bowie;
SQL select count(*) from x$bh where obj=31379;
COUNT(*)
--
18
Nothing new here, only the last few blocks again remain from the BOWIE table
with the same physical I/Os generated.
SQL select count(*) from x$bh where obj=31457;
COUNT(*)
--
117
and thankfully nothing has changed with the SMALL table as a result. These
blocks still remain cached and have not been dislodged as a result of the
FTS on the big BOWIE table (as they sit safely somewhere near the middle,
cold side of the LRU)
Finally, what if we play silly buggers and decide to cache the big BOWIE
table ...
SQL alter table bowie cache;
Table altered.
SQL select * from bowie;
SQL select count(*) from x$bh where obj=31379;
COUNT(*)
--
1338
We now see that a whole heap of buffers have now been cached, approximately
10%. However, again the physical I/Os remain constant because we are still
not effectively caching the table (the undocumented parameters behind the
scene kick in to prevent the whole cache from flooding).
But the effect on poor SMALL...
SQL select count(*) from x$bh where obj=31457;
COUNT(*)
--
1
only one poor block (the header) has survived the experience :(
Hope this clears something up !!
Cheers
Richard Foote
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 10:59 PM
Mike:
I guess we are aware there is no concept of LRU or MRU in current
versions of Oracle and I don't think CACHE option will influence the
behavior. With the new algorithm the MFU blocks are already in the hot
end (unless they are read using CR read in that case they will be in
cold end since we set the _db_aging_freeze_cr to TRUE) and we don't
need to cache the blocks explicitely.
You can monitor the behavior of this using the X$BH (espicially the
last two columns TCH and TIM).
=
Have a nice day !!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
RE: Boolean dates...
Oh, hell, I'll play. The word trivia comes from the Latin tri (three) and via (road). As I understand it, back in the day when those words were bantied around, and all roads led to Rome, trading centers and little towns popped up where two roads intersected, but where three roads intersected, there were major markets, and news from far and near could be heard. This news, of course, travelled around, and was referenced as trivia. -Original Message- Sent: Thursday, October 23, 2003 12:04 AM To: Multiple recipients of list ORACLE-L ...and just by way of trivia, the Latin word kalends is the only word in that language to start with the letter K... on 10/22/03 6:09 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: The 15th of March. From http://www.infoplease.com/spot/ides1.html : Kalends (1st day of the month) Nones (the 7th day in March, May, July, and October; the 5th in the other months) Ides (the 15th day in March, May, July, and October; the 13th in the other months Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager, [EMAIL PROTECTED]) [EMAIL PROTECTED] Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/22/2003 04:09 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Boolean dates... When, exactly, were the Ides of March?
RE: comparison HP-san vs netapp
Jeroen, NetApp depends on TCP/IP to use their products. Now that's NOT a bad thing, but you need to isolate the file traffic from your general network. With a SAN your using normal disk io channels into the switch, which effectively isolates file activity from the network. It's your choice, but having to use NFS for everything can become one heck of a bottleneck. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Jeroen van Sluisdam [mailto:[EMAIL PROTECTED]Sent: Thursday, October 23, 2003 10:49 AMTo: Multiple recipients of list ORACLE-LSubject: comparison HP-san vs netapp Hi, I need urgently a qualitative comparison between an SAN (based on eva3000) and netapp F825 environment concerning oracle. We have been tallking to suppliers now for weeks and suddenly a manager comes up with a netapps alternative and we have a deadline to decide already weeks ago. Anybody with real good links or shortlist of conclusions, criteria on this? Thnx in advance, Jeroen
FW: Re: Your new book
Golly. That depends on how much you want to improve and what you already know. Apart from Calculus, I have found Discrete Math, and Finite Math. I didn't think much of my Prob Stat class, but clearly it has its uses, too. I have not used a hair of Transformational Geometry since I took the course in 78. HTH, Bambi. -Original Message- Sent: Thursday, October 23, 2003 7:12 AM To: Multiple recipients of list ORACLE-L if i want to improve my math skills how much undergraduate math would you recommend? From: Paul Drake [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 02:29:24 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Your new book Ryan, I do not recall seeing a single dy/dx or integrand in the text. The type of math that he used, I saw in high school, and that was in the US, at a public school. Cary easily could have used real math to prove his points. He didn't. He used graphical methods, visual basic and intuition. But mostly algebra. Back in the schools that I attended, pre-algebra was in 8th grade, geometry in ninth, Algebra II in 10th, Trig in 11th and Calculus senior year. Granted, I could have placed out of 3 courses freshman year of college, as my high school kicked arse. If it were more the norm, the US would still be riding a rising productivity curve. Too bad all that what is promoted most here is entertainment. If anything, it underscored the overall problem in the US, that we don't grow grad students natively, we import them. Yeah, you don't have to have a M.S. in Comp. Sci. to be a DBA, but being able to understand (not necessarily derive) things from first principles goes a long way. But then again, I'm skewed. Engineering undergrad at Carnegie Mellon has a way of making or breaking you. And then you realize at some point, how few people get such an opportunity. btw_1, Where is Bill Nye these days? btw_2 , Ryan, in engineering, one takes at least 4 semesters of university level mathematics. If you were on the H SS, H and best dressed or Humanities and Social Sciences track, you might never have seen an ordinary differential equation, even in a calc class. The real question is, did you memorize a few formulas to get by, or did you learn math? did you gain any understanding? understanding you take with you, long after the mesmorized formulas have been dissolved by enough thursday night martinis. one equation could explain more than an entire chapter of text. no sense cutting out the meat just to dumb it down. Paul Ryan [EMAIL PROTECTED] wrote: if someone wants to dig into the type of math you are using in your book in more depth, what level of math expertise would you recommend? Do you have to go beyond college level calculus ? - Original Message - To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 22, 2003 10:54 PM Dennis, Thanks. In fact, I feel the same way about this as many of you who have written about the book in the prior two days. I think the material that ended up being Part II needed to be studied, refined, and documented. And I believe it is important that this material be written in a BOOK instead of only in some electronic medium. Without Part II, I'm not sure many readers would have accepted the possibility of the rather remarkable results I promise in Parts I and III. As it happens, Part II seems to have begun serving a number of uses, some of which I didn't anticipate, including: - Those who want to take our work further can do so without having to reinvent everything we've learned. - Those who want to debate our approach can argue about it on an unambiguous technical foundation. - Forcing ourselves to write everything down in a consumer-ready format guided our making the Hotsos Profiler into a much more robust and complete product than it would have been otherwise. - Similarly, it tightened the content in our educational courses considerably. We now have excellent training material for Hotsos employees, and perhaps (if O'Reilly is lucky) university students of Oracle performance analysis around the world. - Funny enough, it turns out that some of the MySQL guys are at least considering the idea to integrate much better response time instrumentation into their kernel as a result of the book. But Mr. Milligan is absolutely right: you don't have to be able to prove why something works in order to use it. I tried to design Parts I and III to give you what you need to make the method work, regardless of whether you are interested in proving out the theory. I just didn't feel like it would be responsible to sell Part III without including Part II. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com
RE: stupid dbms_job question
What is JOB_QUEUE_INTERVAL set to? If it's more than 5 minutes then what your seeing is what you get. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, October 23, 2003 10:09 AM To: Multiple recipients of list ORACLE-L im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- 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: stupid dbms_job question
JOB_QUEUE_INTERVAL I think But I found that it is obsolete in Release 9.0.1 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 7:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re: stupid dbms_job question what initialization parameters? job_queue_processes is fine. From: Gints Plivna [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 11:49:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Re: stupid dbms_job question Just a shot in the dark Have you set initialization parameters in the init file? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 6:14 PM To: Multiple recipients of list ORACLE-L Subject: Re: Re: stupid dbms_job question id prefer to handle this in the database. From: Gene Sais [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 10:29:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: stupid dbms_job question It's called cron :). Or you could run a shell script that executes then sleeps for 5 mins. [EMAIL PROTECTED] 10/23/03 10:09AM im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- 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: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: stupid dbms_job question
Check if the job fails for some reason, any trace files for j??? in udump or bdump Also check job_queue_processes setting Waleed -Original Message- Sent: Thursday, October 23, 2003 11:14 AM To: Multiple recipients of list ORACLE-L id prefer to handle this in the database. From: Gene Sais [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 10:29:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: stupid dbms_job question It's called cron :). Or you could run a shell script that executes then sleeps for 5 mins. [EMAIL PROTECTED] 10/23/03 10:09AM im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- 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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to trace 3rd party app
Rick - What is the configuration? Is the app on the same server or remote across SQL*Net? Metalink has a pretty good paper on the basics of debugging an ORA-3113. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 23, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Hi DBAs, How can I trace a 3rd party app that produces a ora-3113 error? I am looking into dbms_support package but I am not sure what trace event and level it does. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: re Rebuilding Indexes in Oracle Apps -- was RE: RE:
sold out na lahat-yung Tower 3 sa Eastwood is only for Lease?? At 11:34 AM 10/17/2003 -0800, you wrote: The article states that leaf blocks are not reused, which is indeed incorrect, and has been for a very long time. Hemant K Chitale [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 11:42 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: re Rebuilding Indexes in Oracle Apps -- was RE: RE: I wonder if it is not necessary to rebuild indexes is also a myth. It IS in some cases necessary 1. Indexes on monotonically increasing values [eg Conrurrent_Request_ID based on a Sequence or even on date columns which signify when the record is created] if the table is also purged by the same columns frequently 2. Because the disk space used by an Index can be inordinately larged after a couple of years and index fast_full_scans are impacted Have you administered an Oracle Applications database ? hemant At 03:29 AM 17-10-03 -0800, you wrote: Hi Hemant, One word perfectly describes the Metalink article you highlighted: Crap ;) A nice example of how Oracle Corp is the greatest myth generator of them all !! It's all rather sad and embarressing isn't. Thanks for the headsup. Anyone in a position to get the note removed ? Cheers Richard Quoting Metalink Note 182699.1 bde_rebuild.sql Validates and Rebuilds Fragmentated Indexes (8.0-9.0) Index fragmentation occurs when a key value changes, and the index row is deleted from one place (Leaf Block) and inserted into another. Deleted Leaf Rows are not reused. Therefore indexes whose columns are subject to value change must be rebuilt periodically since they become naturally fragmentated. An index is considered to be 'fragmentated' when more than 20% of its Leaf Rows space is empty because of the implicit deletes caused by indexed columns value changes. Fragmentated indexes degrade the performance of index range scan operations. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jerome Roa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance problem with Shareplex and Oracle
How big is the box that is the source for this machine? Have you tried running sp_ctrl and doing a shutdown and startup? Allan -Original Message- Sent: Thursday, October 23, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT -- ------ -- --- 17 latch free 83 69 1 ,012048193 17 log file sync15 0 9 ,6 17 db file sequential read 52 0 6 ,115384615 17 file open 1 0 0 0 17 SQL*Net message to client 74791 0 27 ,000361006 17 SQL*Net message from client 74791 05235 ,069995053 I really don't see any Oracle performance problems. My problem is the backlog (queue) of Shareplex is getting bigger and bigger. Where is the bottleneck? The only thing I can see is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Boolean dates...
So that's what you call trivia about trivia? :-) Actually, that is really interesting. Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 23, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Oh, hell, I'll play. The word trivia comes from the Latin tri (three) and via (road). As I understand it, back in the day when those words were bantied around, and all roads led to Rome, trading centers and little towns popped up where two roads intersected, but where three roads intersected, there were major markets, and news from far and near could be heard. This news, of course, travelled around, and was referenced as trivia. This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Your new book
Cary, Is Mike Tanner's book Practical Queuing Analysis good in your opinion? Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 22, 2003 11:54 PM To: Multiple recipients of list ORACLE-L I don't know exactly how to scope your question, so I'll answer the two things I think it might mean. For every chapter except for Chapter 9 (Queueing Theory), even college calculus would be extreme overkill, even if you're looking to *derive* all the formulas in those chapters. Understanding the formulas in Chapters 1-8 and 9-12 requires only that you understand that capital Sigma means sum. If you want to dig into the field of queueing theory in more depth, then the level of mathematical background depends on what your goals are. If you want to understand where the formulas come from, then you should probably begin with a good probability and statistics course. This is the foundation of queueing theory. If you buy a copy of the Gross Harris queueing theory book (I have a lot of queueing theory books, and this is by far my favorite), you can see where all the formulas come from. Much of the math in GH is way over my head. I haven't contributed much to the body of queueing theory knowledge except for integrating some pieces from different sources into a coherent plan for Oracle practitioners, offering some commonsense explanations of how to use the stuff, and discovering a couple of bugs in the literature (a big one in Jain's CDF, and a tiny one in GH's CDF). What I did do, I accomplished with computer science methods, not mathematical ones. You can see what I mean on page 236, which is probably my favorite page in the whole book. But, as I've said before, you don't have to know how to derive the formulas in order to use them. With the spreadsheet and Perl code I've written (available at oreilly.com), you can solve a large number of problems without even being able to *read* the formulas. personal-hypothesis I think that some people find the presence of Greek letters jarring (well, at least Don Burleson, from the looks of his review at amazon), but the Greek letters are just funny-looking names of things. Some of my friends implored me to use Latin characters instead of Greek ones, and I considered the case carefully. But in the end, I didn't presume to start rearranging the names of things that have been studied carefully by several generations of scientists since the early 1800s. See p228 for more info on this. /personal-hypothesis Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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: stupid dbms_job question
I am so sorry, I replied to the wrong email. -Original Message- Sent: Thursday, October 23, 2003 12:46 PM To: '[EMAIL PROTECTED]' Are you heading out to lunch -Original Message- Sent: Thursday, October 23, 2003 11:14 AM To: Multiple recipients of list ORACLE-L id prefer to handle this in the database. From: Gene Sais [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 10:29:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: stupid dbms_job question It's called cron :). Or you could run a shell script that executes then sleeps for 5 mins. [EMAIL PROTECTED] 10/23/03 10:09AM im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- 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). --- This message and any included attachments are from Siemens Medical Solutions USA, Inc. and are intended only for the addressee(s). The information contained herein may include trade secrets or privileged or otherwise confidential information. Unauthorized review, forwarding, printing, copying, distributing, or using such information is strictly prohibited and may be unlawful. If you received this message in error, or have reason to believe you are not authorized to receive it, please promptly delete this message and notify the sender by e-mail with a copy to [EMAIL PROTECTED] Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cortese Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Mauve databases use least RAM
Goulet, Dick scribbled on the wall in glitter crayon: use at your own risk. Now is there any way we can get Uncle Larry to subscribe/listen??? *-) well, if we could get him to subscribe and *listen*, that's OK... my fear is that he'd subscribe and *talk*.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Murphy's Sixth Law: If you perceive that there are four possible ways in which a procedure can go wrong and circumvent these, then a fifth way, unprepared for, will promptly develop. -- 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).
RE: Performance problem with Shareplex and Oracle
Allan, I don't know about the source machine. I receive around 350Megs of data every day. I'm using sp_ctrl to stop and restart my Post process and monitor the queue. I'm pretty sure that the bottleneck come from Shareplex. Oracle is waiting for Shareplex, we have server's resources available (CPU is 50% idle). How can we speed up Shareplex? Luc -Original Message- Sent: October 23, 2003 12:56 PM To: Multiple recipients of list ORACLE-L How big is the box that is the source for this machine? Have you tried running sp_ctrl and doing a shutdown and startup? Allan -Original Message- Sent: Thursday, October 23, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT -- ------ -- --- 17 latch free 83 69 1 ,012048193 17 log file sync15 0 9 ,6 17 db file sequential read 52 0 6 ,115384615 17 file open 1 0 0 0 17 SQL*Net message to client 74791 0 27 ,000361006 17 SQL*Net message from client 74791 05235 ,069995053 I really don't see any Oracle performance problems. My problem is the backlog (queue) of Shareplex is getting bigger and bigger. Where is the bottleneck? The only thing I can see is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). application/ms-tnef
RE: How to trace 3rd party app
Dennis, The dot net app is on a remote server. I will search MetaLink. Thanks Rick DENNIS WILLIAMS [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] uch.com cc: Sent by: Subject: RE: How to trace 3rd party app [EMAIL PROTECTED] .com 10/23/2003 12:24 PM Please respond to ORACLE-L Rick - What is the configuration? Is the app on the same server or remote across SQL*Net? Metalink has a pretty good paper on the basics of debugging an ORA-3113. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 23, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Hi DBAs, How can I trace a 3rd party app that produces a ora-3113 error? I am looking into dbms_support package but I am not sure what trace event and level it does. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: stupid dbms_job question
Are you heading out to lunch -Original Message- Sent: Thursday, October 23, 2003 11:14 AM To: Multiple recipients of list ORACLE-L id prefer to handle this in the database. From: Gene Sais [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 10:29:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: stupid dbms_job question It's called cron :). Or you could run a shell script that executes then sleeps for 5 mins. [EMAIL PROTECTED] 10/23/03 10:09AM im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- 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). --- This message and any included attachments are from Siemens Medical Solutions USA, Inc. and are intended only for the addressee(s). The information contained herein may include trade secrets or privileged or otherwise confidential information. Unauthorized review, forwarding, printing, copying, distributing, or using such information is strictly prohibited and may be unlawful. If you received this message in error, or have reason to believe you are not authorized to receive it, please promptly delete this message and notify the sender by e-mail with a copy to [EMAIL PROTECTED] Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cortese Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance problem with Shareplex and Oracle
Dan, The process taking 50% is an Oracle process and it is connected on Shareplex Oracle user. I have two different error messages: 1- System call error: sp_cop(dsm) Temporary error (h_errno = 2) gethostbyname (can't add entry for ora4) I got this error every 10 minutes, but I didn't find something about this error. 2- Operation on 'table_name' is took longer then expected. Make sure the proper index si being used If I check my Explain Plan, the Explain Plan says that he taking the proper index. How can he tell me that it took longer that expected? It's true that on some replicated tables, I have lot of indexs. But my v$session_event should not tell me the waits on indexs (db file scattered read)? Luc -Original Message- Sent: October 23, 2003 1:16 PM To: Demanche, Luc Luc, Which process is taking 50% of the CPU? Do you see any messages from SharePlex? Are there indexes on the target tables or maybe a few that may be slowing down replication (you'll see a message in the event_log on any table that posting is taking longer than expected). Has SharePlex been running for a while and this has just started happening? Just some things to start looking at. Dan - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 8:29 AM Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT -- ------ -- --- 17 latch free 83 69 1 ,012048193 17 log file sync15 0 9 ,6 17 db file sequential read 52 0 6 ,115384615 17 file open 1 0 00 17 SQL*Net message to client 74791 0 27 ,000361006 17 SQL*Net message from client 74791 05235 ,069995053 I really don't see any Oracle performance problems. My problem is the backlog (queue) of Shareplex is getting bigger and bigger. Where is the bottleneck? The only thing I can see is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? 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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to trace 3rd party app
Are you talking about .NET? Well, no wonder that you have problems. I'm sure that BSOD will not have any problems working .NET. On 10/23/2003 02:19:24 PM, [EMAIL PROTECTED] wrote: Dennis, The dot net app is on a remote server. I will search MetaLink. Thanks Rick DENNIS WILLIAMS [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] uch.com cc: Sent by: Subject: RE: How to trace 3rd party app [EMAIL PROTECTED] .com 10/23/2003 12:24 PM Please respond to ORACLE-L Rick - What is the configuration? Is the app on the same server or remote across SQL*Net? Metalink has a pretty good paper on the basics of debugging an ORA-3113. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 23, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Hi DBAs, How can I trace a 3rd party app that produces a ora-3113 error? I am looking into dbms_support package but I am not sure what trace event and level it does. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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).
RE: Performance problem with Shareplex and Oracle
Shareplex is fast here. We replicate a 6 CPU db to a 4 CPU machine without excessive loads or problems. We run an average of 29 messages with about 1 GB in the queues. Our data is 0 minutes old. Outside of contacting Quest support I'm sure of how much help I can be. When I have seen SP claim as much CPU as you have stated, I have had to do a shutdown, which kills sp_cop and start it again. This has fixed the high cpu consumption. SP for us is usually around 18% of a single CPU. We are processing about 240MB per day of redo. Sorry not to be of more help. Allan -Original Message- [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Allan, I don't know about the source machine. I receive around 350Megs of data every day. I'm using sp_ctrl to stop and restart my Post process and monitor the queue. I'm pretty sure that the bottleneck come from Shareplex. Oracle is waiting for Shareplex, we have server's resources available (CPU is 50% idle). How can we speed up Shareplex? Luc -Original Message- Sent: October 23, 2003 12:56 PM To: Multiple recipients of list ORACLE-L How big is the box that is the source for this machine? Have you tried running sp_ctrl and doing a shutdown and startup? Allan -Original Message- Sent: Thursday, October 23, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT -- ------ -- --- 17 latch free 83 69 1 ,012048193 17 log file sync15 0 9 ,6 17 db file sequential read 52 0 6 ,115384615 17 file open 1 0 0 0 17 SQL*Net message to client 74791 0 27 ,000361006 17 SQL*Net message from client 74791 05235 ,069995053 I really don't see any Oracle performance problems. My problem is the backlog (queue) of Shareplex is getting bigger and bigger. Where is the bottleneck? The only thing I can see is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message
Re: Performance problem with Shareplex and Oracle
Who's using other 50%? Is SP active or is waiting? On 10/23/2003 02:19:32 PM, [EMAIL PROTECTED] wrote: Allan, I don't know about the source machine. I receive around 350Megs of data every day. I'm using sp_ctrl to stop and restart my Post process and monitor the queue. I'm pretty sure that the bottleneck come from Shareplex. Oracle is waiting for Shareplex, we have server's resources available (CPU is 50% idle). How can we speed up Shareplex? Luc -Original Message- Sent: October 23, 2003 12:56 PM To: Multiple recipients of list ORACLE-L How big is the box that is the source for this machine? Have you tried running sp_ctrl and doing a shutdown and startup? Allan -Original Message- Sent: Thursday, October 23, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT -- ------ -- --- 17 latch free 83 69 1 ,012048193 17 log file sync15 0 9 ,6 17 db file sequential read 52 0 6 ,115384615 17 file open 1 0 0 0 17 SQL*Net message to client 74791 0 27 ,000361006 17 SQL*Net message from client 74791 05235 ,069995053 I really don't see any Oracle performance problems. My problem is the backlog (queue) of Shareplex is getting bigger and bigger. Where is the bottleneck? The only thing I can see is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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--
how to specify tablespace in Designer
Hi Can someone who has used Designer to generate DDL let me know how you specify which tablespace a table or index is to be created in. I am using the Design Editor and the DBAdmin tab and can't seem to find it. Thanks in advance. Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Solved... Was: Boolean dates...
List... I finally found the answer about the infamous 'boolean dates'! (this was the term that my boss used when he told me about the dates... boolean dates). After receiving a lot of mails talking about Julian dates... I started to test in that way. I could find the following which is the solution to my problem. sql select bdate, to_date(bdate + 1721436, 'J') tdate sql from paam sql where rownum 6; BDATE TDATE --- 728464 01-JUL-95 728434 01-JUN-95 728403 01-MAY-95 728495 01-AUG-95 728283 01-JAN-95 As you can see the key is: 1721436 Thanks again to all! Best regards! JL __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: What happened to Howard Rogers ?
there was alot more on howards site. oracle made him take it down and the person who put up taht site didnt copy everything. he has a new site. www.dizwell.com not much yet, but its worth bookmarking. From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/10/23 Thu PM 12:09:34 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: What happened to Howard Rogers ? Thanks for this, Lisa. The 9i New Features book on his site seems to be very good On 10/23/2003 11:24:25 AM, Dobson, Lisa wrote: His essays are still available here http://www.geocities.com/lydian_third/ Lisa. -Original Message- Sent: 23 October 2003 15:04 To: Multiple recipients of list ORACLE-L howard posted on dejanews that he is contracting to oracle. so i doubt he got fired. he probably just quit. We all know alot of people who 'used to work for oracle'. biggest downside is the lydian third site is gone. Had all the copies of his essays on it. apparently oracle theratened to sue him over it. Supposedly in australia companies own you while you work theere and you need special permission to publish. From: sdf [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 09:24:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: What happened to Howard Rogers ? Ok, I'll bite. What happened to Howard Rogers ? - Original Message - HJR's saga still rates as one of the all-time dumbass knee-jerk reactions from Oracle damagement. And yes, I sincerely hope this message gets circulatedto as many Oracle VPs as it can. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sdf INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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). This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk This message is intended only for the use of the person(s) (Intended Recipient) to whom it is addressed. It may contain information, which is privileged and confidential. Accordingly any dissemination, distribution, copying or other use of this message or any of its content by any person other than the Intended Recipient may constitute a breach of civil or criminal law and is strictly prohibited. If you are not the Intended Recipient, please contact the sender as soon as possible. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dobson, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
RE: comparison HP-san vs netapp
Title: Message Depending on the number of hosts on your theoretical SAN, Netapp will make management much much easier. And like Dick says, have at least two gigabit cards in your hosts that are dedicated for your NFS throughput and dual attachments in the 825 and set up VIF on the filer. In the same way you isolate your SAN traffic onto a dedicated link, you need to isolate your NFS traffic. Thinking long-term, Netapp is at the forefront of iSCSI and DAFS - protocols that may or may not be successful long-term in the market (though I think they will), but in a few years you will have an easier upgrade path to take advantage of these when you decide you're ready to. Thanks, Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Goulet, DickSent: Thursday, October 23, 2003 1:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: comparison HP-san vs netapp Jeroen, NetApp depends on TCP/IP to use their products. Now that's NOT a bad thing, but you need to isolate the file traffic from your general network. With a SAN your using normal disk io channels into the switch, which effectively isolates file activity from the network. It's your choice, but having to use NFS for everything can become one heck of a bottleneck. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Jeroen van Sluisdam [mailto:[EMAIL PROTECTED]Sent: Thursday, October 23, 2003 10:49 AMTo: Multiple recipients of list ORACLE-LSubject: comparison HP-san vs netapp Hi, I need urgently a qualitative comparison between an SAN (based on eva3000) and netapp F825 environment concerning oracle. We have been tallking to suppliers now for weeks and suddenly a manager comes up with a netapps alternative and we have a deadline to decide already weeks ago. Anybody with real good links or shortlist of conclusions, criteria on this? Thnx in advance, Jeroen
RE: how to specify tablespace in Designer
Ben, You need to implement the table to assign storage attributes to it. This can be done either in the Ron or Db Designer where you are at. In Db Designer/DbAdmin tab, expand the database|Users|spcific User|Schema|Table Implementations entry. Click the green plus to implement a table in this area, and you should see the properties attribute pop up. Optionally right click on the Table Implementations selection and select Create Table Implementations. Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 23, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Hi Can someone who has used Designer to generate DDL let me know how you specify which tablespace a table or index is to be created in. I am using the Design Editor and the DBAdmin tab and can't seem to find it. Thanks in advance. Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: stupid dbms_job question
Well, you didn't say what version of the database we were talking about. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, October 23, 2003 12:39 PM To: Multiple recipients of list ORACLE-L JOB_QUEUE_INTERVAL I think But I found that it is obsolete in Release 9.0.1 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 7:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re: stupid dbms_job question what initialization parameters? job_queue_processes is fine. From: Gints Plivna [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 11:49:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Re: stupid dbms_job question Just a shot in the dark Have you set initialization parameters in the init file? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 6:14 PM To: Multiple recipients of list ORACLE-L Subject: Re: Re: stupid dbms_job question id prefer to handle this in the database. From: Gene Sais [EMAIL PROTECTED] Date: 2003/10/23 Thu AM 10:29:33 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: stupid dbms_job question It's called cron :). Or you could run a shell script that executes then sleeps for 5 mins. [EMAIL PROTECTED] 10/23/03 10:09AM im trying to submit a job that runs every 5 minuts. Only way I can get the submit to work is as follows... variable jobno number; variable instno number; begin select instance_number into :instno from v$instance; dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); commit; end; i then do: dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; commit; my next_date column in dba_jobs is set to 15 minutes in the future, HOWEVER, it doesnt actually run. The time passes, the next_date does not get set again to nother 15 minutes in the future and the job doesnt run. Ive read the manual. Read metalink. read asktom and Im obvious too stupid to figure this one out. -- 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: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
index full scan over an index fast full scan in an analytic function?
I have an index on the two columns used in this query. Why would the optimizer choose an index full scan over an index fast full scan? My question isnt why an index is used, but the type of index scan? select * from (select col1, col2, dense_rank() over (partition by col1 order by col2 desc)tab from mytable) where tab = 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Mauve databases use least RAM
OH DEAR, now that would require the list to up the bandwidth. Good point!! *-) Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, October 23, 2003 2:09 PM To: Multiple recipients of list ORACLE-L Goulet, Dick scribbled on the wall in glitter crayon: use at your own risk. Now is there any way we can get Uncle Larry to subscribe/listen??? *-) well, if we could get him to subscribe and *listen*, that's OK... my fear is that he'd subscribe and *talk*.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Murphy's Sixth Law: If you perceive that there are four possible ways in which a procedure can go wrong and circumvent these, then a fifth way, unprepared for, will promptly develop. -- 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).
stop compile
is there any way trigger I can write so that no body can compile object (package/procedure) and alter table during business hours in 8.1.7.4 db. -ak
RE: Performance problem with Shareplex and Oracle
Now we don't use Shareplex, but I do know of others who do this is not the first time I hear of performance problems, but I may be able to shed some light on the problem. Since Shareplex reads the redo logs, if one statement on the source database affects more than one row (lets say 10 for arguments sake), then shareplex turns it into 10 distinct statements for the replicated database. Now imagine that your statement affected one row in one table, but due to triggers and constraints affected 1000's of other rown in other tables. DAMN, that could make for a REAL mess on the target system. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, October 23, 2003 2:44 PM To: Multiple recipients of list ORACLE-L Shareplex is fast here. We replicate a 6 CPU db to a 4 CPU machine without excessive loads or problems. We run an average of 29 messages with about 1 GB in the queues. Our data is 0 minutes old. Outside of contacting Quest support I'm sure of how much help I can be. When I have seen SP claim as much CPU as you have stated, I have had to do a shutdown, which kills sp_cop and start it again. This has fixed the high cpu consumption. SP for us is usually around 18% of a single CPU. We are processing about 240MB per day of redo. Sorry not to be of more help. Allan -Original Message- [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Allan, I don't know about the source machine. I receive around 350Megs of data every day. I'm using sp_ctrl to stop and restart my Post process and monitor the queue. I'm pretty sure that the bottleneck come from Shareplex. Oracle is waiting for Shareplex, we have server's resources available (CPU is 50% idle). How can we speed up Shareplex? Luc -Original Message- Sent: October 23, 2003 12:56 PM To: Multiple recipients of list ORACLE-L How big is the box that is the source for this machine? Have you tried running sp_ctrl and doing a shutdown and startup? Allan -Original Message- Sent: Thursday, October 23, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT -- ------ -- --- 17 latch free 83 69 1 ,012048193 17 log file sync15 0 9 ,6 17 db file sequential read 52 0 6 ,115384615 17 file open 1 0 0 0 17 SQL*Net message to client 74791 0 27 ,000361006 17 SQL*Net message from client 74791 05235 ,069995053 I really don't see any Oracle performance problems. My problem is the backlog (queue) of Shareplex is getting bigger and bigger. Where is the bottleneck? The only thing I can see is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: index full scan over an index fast full scan in an analytic function?
i cant attach the 10053 trace. it has proprietary info. There isnt much in analytic explain plan either. does anyone know in general why a full scan would be faster than a fast full scan? From: [EMAIL PROTECTED] Date: 2003/10/23 Thu PM 03:09:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: index full scan over an index fast full scan in an analytic function? I have an index on the two columns used in this query. Why would the optimizer choose an index full scan over an index fast full scan? My question isnt why an index is used, but the type of index scan? select * from (select col1, col2, dense_rank() over (partition by col1 order by col2 desc)tab from mytable) where tab = 1 -- 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: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Cache a table
Craig Shalahamer still refers to the cache as LRU/MRU. What has changed
are the algorithms that determine the lifespan and placement of a buffer
in the cache.
www.orapub.com
Jared
Richard Foote [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/23/2003 08:34 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Cache a table
Hi
It depends on how you define an LRU list I guess. When I close my eyes and
picture the cache, I still see a LRU in there somewhere. Please note I don't
often close my eyes in this manner ;)
Also when you say that the CACHE option has no effect, that's also a little
questionable. This is just a portion of a post I recently sent to
comp.databases.oracle.server in the Cache A Table thread:
Simple demo on 9.2, the BOWIE table is approximately 13,000 blocks, SMALL is
117 blocks:
SQL alter table bowie nocache;
Table altered.
SQL select object_name, object_id, data_object_id from dba_objects where
object
_name in ('BOWIE', 'SMALL');
OBJECT_NAME OBJECT_ID DATA_OBJECT_ID
--- -- --
BOWIE31379 31379
SMALL31457 31457
SQL select * from bowie; (run with autotrace traceonly)
SQL select count(*) from x$bh where obj=31379;
COUNT(*)
--
18
Note that only the last few blocks from the FTS actually remain in memory.
If I repeat the select, I still have the same result from x$bh and the same
number of *physical reads occur each time.
If I run the same thing with my small table which has about 117 blocks,
the same thing happens
SQL alter table small nocache;
Table altered.
SQL select * from small;
SQL select count(*) from x$bh where obj=31457;
COUNT(*)
--
18
Note that again only the last few blocks from the FTS actually remain in
memory. If I repeat the select, I still have the same result from x$bh and
again the same number of physical reads occur each time.
OK, lets change my small table and cache the thing and see if I get a
different result ...
SQL alter table small cache;
Table altered.
SQL select * from small;
SQL select count(*) from x$bh where obj=31457;
COUNT(*)
--
117
I now see that all 117 blocks (that's all data blocks + segment header) are
all now cached as expected. Repeated reruns of the select now generate *no*
physical I/Os.
But what if I now run a select on my big BOWIE table, what effect will
this have on the SMALL cached blocks ?
SQL select * from bowie;
SQL select count(*) from x$bh where obj=31379;
COUNT(*)
--
18
Nothing new here, only the last few blocks again remain from the BOWIE table
with the same physical I/Os generated.
SQL select count(*) from x$bh where obj=31457;
COUNT(*)
--
117
and thankfully nothing has changed with the SMALL table as a result. These
blocks still remain cached and have not been dislodged as a result of the
FTS on the big BOWIE table (as they sit safely somewhere near the middle,
cold side of the LRU)
Finally, what if we play silly buggers and decide to cache the big BOWIE
table ...
SQL alter table bowie cache;
Table altered.
SQL select * from bowie;
SQL select count(*) from x$bh where obj=31379;
COUNT(*)
--
1338
We now see that a whole heap of buffers have now been cached, approximately
10%. However, again the physical I/Os remain constant because we are still
not effectively caching the table (the undocumented parameters behind the
scene kick in to prevent the whole cache from flooding).
But the effect on poor SMALL...
SQL select count(*) from x$bh where obj=31457;
COUNT(*)
--
1
only one poor block (the header) has survived the experience :(
Hope this clears something up !!
Cheers
Richard Foote
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 10:59 PM
Mike:
I guess we are aware there is no concept of LRU or MRU in current
versions of Oracle and I don't think CACHE option will influence the
behavior. With the new algorithm the MFU blocks are already in the hot
end (unless they are read using CR read in that case they will be in
cold end since we set the _db_aging_freeze_cr to TRUE) and we don't
need to cache the blocks explicitely.
You can monitor the behavior of this using the X$BH (espicially the
last two columns TCH and TIM).
=
Have a nice day !!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note
RE: Re: What happened to Howard Rogers ?
He had great stuff on his site. Why did Oracle make him take it down? His stuff his very readable and informative IMHO. This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 compile
Your problem is not an oracle problem. It's an organization problem. To say the least, nobody but DBA should be able to perform a DDL on the production database. All three of you should take care of that. On 10/23/2003 03:04:40 PM, AK wrote: is there any way trigger I can write so that no body can compile object (package/procedure) and alter table during business hours in 8.1.7.4 db. -ak 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).
RE: Performance problem with Shareplex and Oracle
Your DNS is toasty. Gethostbyname is a UNIX system call that takes your ip address and turns it into a name. This could be a big part of your delay. Networked apps do not take kindly to being unable to both forward and reverse lookups. H_errno = 2 is not found. Allan -Original Message- Sent: Thursday, October 23, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Dan, The process taking 50% is an Oracle process and it is connected on Shareplex Oracle user. I have two different error messages: 1- System call error: sp_cop(dsm) Temporary error (h_errno = 2) gethostbyname (can't add entry for ora4) I got this error every 10 minutes, but I didn't find something about this error. 2- Operation on 'table_name' is took longer then expected. Make sure the proper index si being used If I check my Explain Plan, the Explain Plan says that he taking the proper index. How can he tell me that it took longer that expected? It's true that on some replicated tables, I have lot of indexs. But my v$session_event should not tell me the waits on indexs (db file scattered read)? Luc -Original Message- Sent: October 23, 2003 1:16 PM To: Demanche, Luc Luc, Which process is taking 50% of the CPU? Do you see any messages from SharePlex? Are there indexes on the target tables or maybe a few that may be slowing down replication (you'll see a message in the event_log on any table that posting is taking longer than expected). Has SharePlex been running for a while and this has just started happening? Just some things to start looking at. Dan - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 8:29 AM Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT -- ------ -- --- 17 latch free 83 69 1 ,012048193 17 log file sync15 0 9 ,6 17 db file sequential read 52 0 6 ,115384615 17 file open 1 0 0 0 17 SQL*Net message to client 74791 0 27 ,000361006 17 SQL*Net message from client 74791 05235 ,069995053 I really don't see any Oracle performance problems. My problem is the backlog (queue) of Shareplex is getting bigger and bigger. Where is the bottleneck? The only thing I can see is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? 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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ:
RE: Performance problem with Shareplex and Oracle
Since the results of triggers firing in the source will appear in the log files, then in general you do not want the same triggers firing in the target. Similarly since data integrity is usually enforced in the source db you can typically disable it in the target. I suppose something on this order could be the problem. Allan -Original Message- Sent: Thursday, October 23, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Now we don't use Shareplex, but I do know of others who do this is not the first time I hear of performance problems, but I may be able to shed some light on the problem. Since Shareplex reads the redo logs, if one statement on the source database affects more than one row (lets say 10 for arguments sake), then shareplex turns it into 10 distinct statements for the replicated database. Now imagine that your statement affected one row in one table, but due to triggers and constraints affected 1000's of other rown in other tables. DAMN, that could make for a REAL mess on the target system. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, October 23, 2003 2:44 PM To: Multiple recipients of list ORACLE-L Shareplex is fast here. We replicate a 6 CPU db to a 4 CPU machine without excessive loads or problems. We run an average of 29 messages with about 1 GB in the queues. Our data is 0 minutes old. Outside of contacting Quest support I'm sure of how much help I can be. When I have seen SP claim as much CPU as you have stated, I have had to do a shutdown, which kills sp_cop and start it again. This has fixed the high cpu consumption. SP for us is usually around 18% of a single CPU. We are processing about 240MB per day of redo. Sorry not to be of more help. Allan -Original Message- [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Allan, I don't know about the source machine. I receive around 350Megs of data every day. I'm using sp_ctrl to stop and restart my Post process and monitor the queue. I'm pretty sure that the bottleneck come from Shareplex. Oracle is waiting for Shareplex, we have server's resources available (CPU is 50% idle). How can we speed up Shareplex? Luc -Original Message- Sent: October 23, 2003 12:56 PM To: Multiple recipients of list ORACLE-L How big is the box that is the source for this machine? Have you tried running sp_ctrl and doing a shutdown and startup? Allan -Original Message- Sent: Thursday, October 23, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT -- ------ -- --- 17 latch free 83 69 1 ,012048193 17 log file sync15 0 9 ,6 17 db file sequential read 52 0 6 ,115384615 17 file open 1 0 0 0 17 SQL*Net message to client 74791 0 27 ,000361006 17 SQL*Net message from client 74791 05235 ,069995053 I really don't see any Oracle performance problems. My problem is the backlog (queue) of Shareplex is getting bigger and bigger. Where is the bottleneck? The only thing I can see is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this
RE: Performance problem with Shareplex and Oracle
I probably found my problem. My replicated tables have a lot of indexs. I removed all of them, and step by step I will add indexs who will help my replication. Tx Luc -Original Message- Sent: October 23, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Since the results of triggers firing in the source will appear in the log files, then in general you do not want the same triggers firing in the target. Similarly since data integrity is usually enforced in the source db you can typically disable it in the target. I suppose something on this order could be the problem. Allan -Original Message- Sent: Thursday, October 23, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Now we don't use Shareplex, but I do know of others who do this is not the first time I hear of performance problems, but I may be able to shed some light on the problem. Since Shareplex reads the redo logs, if one statement on the source database affects more than one row (lets say 10 for arguments sake), then shareplex turns it into 10 distinct statements for the replicated database. Now imagine that your statement affected one row in one table, but due to triggers and constraints affected 1000's of other rown in other tables. DAMN, that could make for a REAL mess on the target system. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, October 23, 2003 2:44 PM To: Multiple recipients of list ORACLE-L Shareplex is fast here. We replicate a 6 CPU db to a 4 CPU machine without excessive loads or problems. We run an average of 29 messages with about 1 GB in the queues. Our data is 0 minutes old. Outside of contacting Quest support I'm sure of how much help I can be. When I have seen SP claim as much CPU as you have stated, I have had to do a shutdown, which kills sp_cop and start it again. This has fixed the high cpu consumption. SP for us is usually around 18% of a single CPU. We are processing about 240MB per day of redo. Sorry not to be of more help. Allan -Original Message- [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Allan, I don't know about the source machine. I receive around 350Megs of data every day. I'm using sp_ctrl to stop and restart my Post process and monitor the queue. I'm pretty sure that the bottleneck come from Shareplex. Oracle is waiting for Shareplex, we have server's resources available (CPU is 50% idle). How can we speed up Shareplex? Luc -Original Message- Sent: October 23, 2003 12:56 PM To: Multiple recipients of list ORACLE-L How big is the box that is the source for this machine? Have you tried running sp_ctrl and doing a shutdown and startup? Allan -Original Message- Sent: Thursday, October 23, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem Shareplex is the only process running on this database. Here is the output of v$session_event SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT -- ------ -- --- 17 latch free 83 69 1 ,012048193 17 log file sync15 0 9 ,6 17 db file sequential read 52 0 6 ,115384615 17 file open 1 0 0 0 17 SQL*Net message to client 74791 0 27 ,000361006 17 SQL*Net message from client 74791 05235 ,069995053 I really don't see any Oracle performance problems. My problem is the backlog (queue) of Shareplex is getting bigger and bigger. Where is the bottleneck? The only thing I can see is the server. The server is a Ultra-80, 2 CPU 450Mhz, 2048Megs of RAM According to top, this process is taking 50% of the CPU. and my load average is 1.26, 1.27, 1.24 My average load exceed 1, can I conclude that the CPU is the bottleneck? What are my possibilities? 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). __ This email
** temp tablespace
Hi, I have a huge temp tablespace (4GB)and not much usage (current usage is 50MBfrom v$ tables) . However it keeps running out of space. It ran out of space yesterday and I was hoping it would release but it got an error again. The database is only 35GB mostly small tables. IT is temporary (contents). How can i tell how much is *actually* free. dba_free_space shows hardly any free even when there is no activity. Thanks Do you Yahoo!? The New Yahoo! Shopping - with improved product search
dba interview questions
Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 compile
You might try using Fine Grained Access or a database level trigger that fires upon altering of a table. Also look into auditing the objects. To prevent a stored program from being compiled during business hours you can simply remove all object privileges from the the object so that no one will be granted any privileges on the object. If it is a production environment, hopefully the users or application only connect via a run-time userid, and not the schema owner. Then you could revoke object privileges from the run-time userid. You could always switch the stored program to another userid. Or drop the stored program and reimport it after hours. This would also compile it. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] il.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: stop compile ity.com 10/23/2003 02:04 PM Please respond to ORACLE-L is there any way trigger I can write so that no body can compile object (package/procedure) and alter table during business hours in 8.1.7.4 db. -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: comparison HP-san vs netapp
Title: Message What is a"VIF on the filer"? - Original Message - From: Matthew Zito To: Multiple recipients of list ORACLE-L Sent: Friday, October 24, 2003 7:59 AM Subject: RE: comparison HP-san vs netapp Depending on the number of hosts on your theoretical SAN, Netapp will make management much much easier. And like Dick says, have at least two gigabit cards in your hosts that are dedicated for your NFS throughput and dual attachments in the 825 and set up VIF on the filer. In the same way you isolate your SAN traffic onto a dedicated link, you need to isolate your NFS traffic. Thinking long-term, Netapp is at the forefront of iSCSI and DAFS - protocols that may or may not be successful long-term in the market (though I think they will), but in a few years you will have an easier upgrade path to take advantage of these when you decide you're ready to. Thanks, Matt
Re: dba interview questions
Thursday, October 23, 2003, 4:14:34 PM, you wrote: sm Dear List,Can anyone send me a list of dba interview questions? Forget the questions. Somebody send me the answers! :) Heh. Maybe you could do the interview in Jeopardy format, where you state the answer, and force the candidate to back into the question. 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).
Oracle Spatial...
Anybody know of any good docs that can help me get into the bowels of Oracle Spatial without getting dirty? TIA! Bambi. -- 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).
RE: Boolean dates...
Title: RE: Boolean dates... So would that make it meta-trivia? -Original Message- From: Michael Milligan [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 23, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Boolean dates... So that's what you call trivia about trivia? :-) Actually, that is really interesting. Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 23, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Oh, hell, I'll play. The word trivia comes from the Latin tri (three) and via (road). As I understand it, back in the day when those words were bantied around, and all roads led to Rome, trading centers and little towns popped up where two roads intersected, but where three roads intersected, there were major markets, and news from far and near could be heard. This news, of course, travelled around, and was referenced as trivia. This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: Oracle Spatial...
The Oracle manuals are the best documentation by far. Abraham Guerra -Original Message- Sent: Thursday, October 23, 2003 3:54 PM To: Multiple recipients of list ORACLE-L Anybody know of any good docs that can help me get into the bowels of Oracle Spatial without getting dirty? TIA! Bambi. -- 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: Guerra, Abraham J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: What happened to Howard Rogers ?
Because they said so. Signed, -Another former Oracle employee threatened by Oracle Legal about info posted to the internet He had great stuff on his site. Why did Oracle make him take it down? His stuff his very readable and informative IMHO. This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Your new book
That's one book that I don't have. A good friend of mine says it's very good, especially as an introduction. I browsed it in a bookstore once, and if my memory serves me correctly, the only reason I didn't buy it is that I felt like Gross Harris (which I already owned) covered everything I would have gotten had I bought the Tanner book. It's probably not a completely fair assessment, but it's all I had to work with in a 10-minute window. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Michael Milligan Sent: Thursday, October 23, 2003 12:59 PM To: Multiple recipients of list ORACLE-L Cary, Is Mike Tanner's book Practical Queuing Analysis good in your opinion? Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 22, 2003 11:54 PM To: Multiple recipients of list ORACLE-L I don't know exactly how to scope your question, so I'll answer the two things I think it might mean. For every chapter except for Chapter 9 (Queueing Theory), even college calculus would be extreme overkill, even if you're looking to *derive* all the formulas in those chapters. Understanding the formulas in Chapters 1-8 and 9-12 requires only that you understand that capital Sigma means sum. If you want to dig into the field of queueing theory in more depth, then the level of mathematical background depends on what your goals are. If you want to understand where the formulas come from, then you should probably begin with a good probability and statistics course. This is the foundation of queueing theory. If you buy a copy of the Gross Harris queueing theory book (I have a lot of queueing theory books, and this is by far my favorite), you can see where all the formulas come from. Much of the math in GH is way over my head. I haven't contributed much to the body of queueing theory knowledge except for integrating some pieces from different sources into a coherent plan for Oracle practitioners, offering some commonsense explanations of how to use the stuff, and discovering a couple of bugs in the literature (a big one in Jain's CDF, and a tiny one in GH's CDF). What I did do, I accomplished with computer science methods, not mathematical ones. You can see what I mean on page 236, which is probably my favorite page in the whole book. But, as I've said before, you don't have to know how to derive the formulas in order to use them. With the spreadsheet and Perl code I've written (available at oreilly.com), you can solve a large number of problems without even being able to *read* the formulas. personal-hypothesis I think that some people find the presence of Greek letters jarring (well, at least Don Burleson, from the looks of his review at amazon), but the Greek letters are just funny-looking names of things. Some of my friends implored me to use Latin characters instead of Greek ones, and I considered the case carefully. But in the end, I didn't presume to start rearranging the names of things that have been studied carefully by several generations of scientists since the early 1800s. See p228 for more info on this. /personal-hypothesis Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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
Re: OT: How to call unix shell scripts from 'C'?
Ah, then what you really need to do this with is perl. Edit in place, make backup copies or not, all very simple. eg. change all instances of SQLServer to Oracle in the files in a directory perl -pi -e 's/SQLServer/Oracle/goi' * Jared Ryan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/22/2003 08:59 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: OT: How to call unix shell scripts from 'C'? the basics are they i want 'C' so i can use a file pointer. I need to do some search and replace in a group of files. If I use straight scripting I have to redirect the output to a new file and do a 'mv' to rename it back. with the filepointer, I was hoping to be to use fopen in C to open the file and then manipulate it with search and replace. not sure its possible. I Think you run into the same 'random access' issues you do in java. im pretty weak in C programming. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 12:14 PM If you want the C program and the spawned shell script to interact and communicate back and forth with each other, then you'd have to use the pipe() system call to set up a two-way interprocess-communication pipe in the C program, then call fork() to spawn a new identical process (including the IPC pipes), then finally exec() in the child process to bring the image of the desired shell running it's shell script in. Of course, each port of C has variations on those basic function call (i.e. exec() can be execv(), execve(), execle(), etc). If you're just going to have the C program spawn the shell script that will operate independently of its parent, you can just call the system() library call and be done with it... Hope this helps... -Tim The unix and C forums are pretty inactive. Hope its ok to ask this here. Anyone know how to do this? -- 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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
RE: index full scan over an index fast full scan in an analytic function?
Possibly to avoid a sort operation (assuming that you might be able to get away with a NOSORT when doing the full index scan)? It might be deciding that the benefit of the multi-block reads for the fast full scan are more than offset by the sort operation that would be needed (and might not be needed when doing the full index scan). Regards, Larry G. Elkins The Elkins Organization Inc. [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 2:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: index full scan over an index fast full scan in an analytic function? i cant attach the 10053 trace. it has proprietary info. There isnt much in analytic explain plan either. does anyone know in general why a full scan would be faster than a fast full scan? From: [EMAIL PROTECTED] Date: 2003/10/23 Thu PM 03:09:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: index full scan over an index fast full scan in an analytic function? I have an index on the two columns used in this query. Why would the optimizer choose an index full scan over an index fast full scan? My question isnt why an index is used, but the type of index scan? select * from (select col1, col2, dense_rank() over (partition by col1 order by col2 desc)tab from mytable) where tab = 1 -- 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: [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: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dba interview questions
1) What does it mean to grokkk? 2) What is the answer to the question of life, universe and everything? 3) What happened to Sauron when he flipped the bird to Izildur? 4) What is the monolyth and what was its effect on the resident apes? 5) What is damagement? What color of the database saves memory? 6) What can you tell me about lord Edmund Blackadder? Chances are that if someone answers those questions correctly, you've got yourself a worthy DBA. On 10/23/2003 04:14:34 PM, system manager wrote: Dear List,Can anyone send me a list of dba interview questions? Thanks, _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
