Re: Automatic or Uniform allocation
Ron, I agree, uniform sizing is best. I hardly ever use automatic except for small development databases and small MISC tablespaces and even then I think Why didn't I use use uniform 64K ? Cheers, Chris Quoting Ron Rogers [EMAIL PROTECTED]: Brad, For LMT's I prefer uniform sizing that I can define to meet the needs of the data. If you use automatic the extend sizes will change drimatically as the number if extends increase. With a little planning you can have little waste in the tablespace and use the tablespace for multiple tables of the same size requirements. We have used the partitioning and LMT's for the yearly data we have, about 5 gig per table per year and the extend count is only around 100 with minimal free space. It makes it easier in the planning stage if you can keep it simple. Ron [EMAIL PROTECTED] 01/22/2004 10:14:34 AM for LMTs... Advantages in uniform versus automatic? Uniform 5 MB? 10 MB.100MB etc thoughts would be appreciatd Thanks Brad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- 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: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!
Thanks a lot, Bruce. Much appreciated. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - The list archives here will be available as long as Fat City continues to be in existence, so those of you who are searching for old topics are quite welcome to use the facilities here. It won't be going away. -- 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).
note 216205.1 [was :RE: Process consumes CPU and long time to
Hi, anyone has read and implement as note 216205.1 ? any comment or suggestion ? regards -Original Message- From: hernawan [mailto:[EMAIL PROTECTED] Hi all, I have process in Oracle apps 11.5.8 which need very lot CPUs and long time to complete. for about 17,000 invoices it takes 28 hours !! I have open TAR since month ago, and still get no solution. maybe here someone can share any idea ? im using 11.5.8, sparc. DB 9i rel2 deleted .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: hernawan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: pga_aggregate_target and a memory leak
what are the specs of that box? what does it cost? Ive never worked on something that big. how big is the database your working on? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 11:24 PM So, my intention to set P_A_T to 140G on a new datawarehouse is ill-advised? I'm not kidding, by the way. The Sun E15K belonging to the project I'm currently working on (purportedly) has 160G of RAM. It is still in the box, so I'm not believing anything until I type prtconf... I wasn't planning to use more than 10G or so for SGA, and that much only because I can... wee-hah!... Any thoughts? on 1/21/04 3:14 PM, Jonathan Lewis at [EMAIL PROTECTED] wrote: A comment I picked up from Tom Kyte's Masterclass in Copenhagen last week was that there is an effective limit of 1GB to P_A_T - and although a single session is supposed to be allowed 5% of the P_A_T, you could get about 90MB. So there are some funny things going on in that area which still need fixing. It's a bit tough for big systems, as I've found that the optimizer seems to be much smarter about memory user and access paths when P_A_T and W_S_P are set. What's the book about ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 7:44 PM Replies in line... - Kirti --- [EMAIL PROTECTED] wrote: Kirti, you're back! Thanks. Found some slack time from routine DBA work! Must have finished the book. :) Not yet.. Its tough.. Re the PGA problems, what was the value for 'over allocation count' in v$pgastat? Actually, I never bothered to look at v$pgastat. Should have.. and will, when we do some more testing next week.. -- 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: What to look for in STATSPACK report
well, I can't get to the site at the moment to test it.. if I remember correctly, Anjo said he had leased it to Veritas for a couple of years, while retaining permanent ownership. On the other hand, he's on this list, he can confirm or deny that himself! --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: Hi Tim, Are you sure it's still owned by Veritas? Doesn't look that way when I checked it just now. Mogens Tim Gorman wrote: Helmut, Register with http://www.oraperf.com; and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense. All of the ratio stuff on the STATSPACK report is ignored by the YAPP analyzer, and instead the reformatting looks at things from the standpoint of response-time analysis, as described in the white papers at http://www.oraperf.com/whitepapers.html;. Yes, I know OraPerf is now owned by Veritas and the real URLs are different, but it'll always be just good old oraperf.com hopefully, no matter who Anjo works for... :-) Hope this helps... -Tim on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: TKProf Analyzer
Hi, check out Mogens site, he has a PL/SQL tool for storing trace files in a repository. Its called TraceFile Repository and was written by Torben Holm and its free - have a look http://www.miracleas.dk/tools/Mir TFR104.zip -t might be an alternative for you? - it has a web based front end using htp and htf so is quite handy to view your trace files. hope this helps Kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: Solaris: Finding the cause for disk space growth
Check out the du (disk usage) command. man du [EMAIL PROTECTED] 01/23/04 03:44AM Hi All, Sorry for an OT question, but nowhere else to go. Pretty new to Solaris so might be a naive question. Need a pointer on how to do this. The disk space in the machine is constantly decreasing. And I want to knowwhich files/directories are growing. Is there any way to find out? Regards Naveen
RE: !!Please Read - Oracle-L is moving!!
Title: Message -Original Message-From: Lord David [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 3:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removingline breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein
Re: OT: Solaris: Finding the cause for disk space growth
Naveen, Since you are new to Solaris, how new are you to unix/linux? If you are already aware of anything, I apoligize: spool the output of df -k to a file. I really like the script command for this. Wait some time (long enough for more disk to get used) and do it again (rename the first file if you used script). Then diff list1 list2 This should tell you which mount point changed. Since you are asking this in an Oracle forum, I'll guess that the mount point that is growing is related to an Oracle database. At a similar interval to the df command above, run something like this in your Oracle database. If you have more than one, do it in all, but spool to a instance_specific file name: spool begin (or end) select tablespace_name, sum(bytes)/1024 Kb from dba_extents group by tablespace_name order by 1 asc; spool off diff begin end will tell you which tablespace is growing. You can then modify the query above to see which object is growing in that tablespace. I won't write that one for you or you won't get a chance to learn anything from this grin Good luck and let us know how it goes. Stephen [EMAIL PROTECTED] 01/23/04 01:44AM Hi All, Sorry for an OT question, but nowhere else to go. Pretty new to Solaris so might be a naive question. Need a pointer on how to do this. The disk space in the machine is constantly decreasing. And I want to know which files/directories are growing. Is there any way to find out? Regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: !!Please Read - Oracle-L is moving!!
Re: pga_aggregate_target and a memory leak
I read the paper about the adaptive memory and how it gets wasted, but with 10G SGA you can afford to be a bit wasteful. I would set workarea_size_policy to manual and then set sort_area_size to 32M and hash area size to 128M. With the memory sizes you mentioned, there shouldn't be any problems. Anythingadaptive, on the other hand, is an overhead. That overhead is implemented in the oracle server processes (ora_s000...) and any bug has a great potential to waste more then a little CPU. Also, you don't want segment space management to be set on AUTO in your tablespaces because DW type databases are not update intensive and you don't want to be reading any more blocks then necessary because of the free space in the block that is left to accommodate updates that will never come. Also, if you can get your data files on a file system that supports direct I/O, it would be nice. VxFS is the first thing that comes to mind...If you manage to make it happen, set filesystemio_options parameter to setall, so that oracle will use both asynchronous and direct I/O. You should also minimize the number of DML_LOCKS that you wish to allow and consider using table locking ( row_locking=intent ), to shorten the path through the oracle code. On 01/22/2004 11:24:41 PM, Tim Gorman wrote: So, my intention to set P_A_T to 140G on a new datawarehouse is ill-advised? I'm not kidding, by the way. The Sun E15K belonging to the project I'm currently working on (purportedly) has 160G of RAM. It is still in the box, so I'm not believing anything until I type prtconf... I wasn't planning to use more than 10G or so for SGA, and that much only because I can... wee-hah!... Any thoughts? on 1/21/04 3:14 PM, Jonathan Lewis at [EMAIL PROTECTED] wrote: A comment I picked up from Tom Kyte's Masterclass in Copenhagen last week was that there is an effective limit of 1GB to P_A_T - and although a single session is supposed to be allowed 5% of the P_A_T, you could get about 90MB. So there are some funny things going on in that area which still need fixing. It's a bit tough for big systems, as I've found that the optimizer seems to be much smarter about memory user and access paths when P_A_T and W_S_P are set. What's the book about ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 7:44 PM Replies in line... - Kirti --- [EMAIL PROTECTED] wrote: Kirti, you're back! Thanks. Found some slack time from routine DBA work! Must have finished the book. :) Not yet.. Its tough.. Re the PGA problems, what was the value for 'over allocation count' in v$pgastat? Actually, I never bothered to look at v$pgastat. Should have.. and will, when we do some more testing next week.. -- 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: 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: !!Please Read - Oracle-L is moving!!
Title: Message Bill The line breaks get removed from *incoming* mail, so I don't think it matterswhat your default new mail format is.I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office'in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David LordSenior DBAIron Mountain (UK) LtdTelephone: 029 2054 4000Direct: 029 2054 4013Fax: 029 2069 2464Email: [EMAIL PROTECTED] -Original Message-From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 13:24To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! -Original Message-From: Lord David [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 3:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removingline breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet is not a secure communications medium. If you are requesting or have requested the transmittal of personal data, as defined in applicable privacy laws, by means of email or in an attachment to email, you may wish to select a more secure alternate means of transmittal that better supports your obligations to protect such personal data.If the recipient of this message is not the recipient named above, and/or you have received this email in error, you must take no action based on the information in this email. You are hereby notified that any dissemination, misuse or copying or disclosure of this communication by a recipient who has received this message in error is strictly prohibited. If this message is received in error, please return this email to the sender and immediately highlight any error in transmittal. Thank you. *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** This e-mail and its attachments are intended for the author's addressee only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. Steps have been taken to ensure this e-mail and attachments are free from any virus, but advise the recipient to ensure they are actually virus free. The views, opinions and judgments expressed in this message are solely those of the author. The message contents have not been reviewed or approved by Iron Mountain. *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
RE: Trigger, how?
Use: when updating col1, col2,... clause. Better yet, read oracle docs. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- [EMAIL PROTECTED] Sent: Friday, January 23, 2004 3:19 AM To: Multiple recipients of list ORACLE-L Hallo all, Anyone whom know how to write the trigger if you just want a trigger to be fired if only two fields in a table is changed, not all of them? Any good example? Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: !!Please Read - Oracle-L is moving!!
Title: Message Its easy todisable this "feature": Navigate to the Tools-Options menu Click the "Email Options" Button Uncheck the "Remove extra line breaks in plain text messages" checkbox Click Okay about 30 times and your're done! Kevin -Original Message-From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Bill The line breaks get removed from *incoming* mail, so I don't think it matterswhat your default new mail format is.I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office'in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David LordSenior DBAIron Mountain (UK) LtdTelephone: 029 2054 4000Direct: 029 2054 4013Fax: 029 2069 2464Email: [EMAIL PROTECTED] -Original Message-From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 13:24To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! -Original Message-From: Lord David [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 3:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removingline breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet is not a secure communications medium. If you are requesting or have requested the transmittal of personal data, as defined in applicable privacy laws, by means of email or in an attachment to email, you may wish to select a more secure alternate means of transmittal that better supports your obligations to protect such personal data.If the recipient of this message is not the recipient named above, and/or you have received this email in error, you must take no action based on the information in this email. You are hereby notified that any dissemination, misuse or copying or disclosure of this communication by a recipient who has received this message in error is strictly prohibited. If this message is received in error, please return this email to the sender and immediately highlight any error in transmittal. Thank you.*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** This e-mail and its attachments are intended for theauthor's addressee only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. Please note that this e-mail has been created in theknowledge that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. Steps have been taken to ensure this e-mail and attachments are free fro
RE: !!Please Read - Oracle-L is moving!!
Title: Message Thanks Kevin, couldn't see for looking -- David LordSenior DBAIron Mountain (UK) Ltd-Original Message-From: Kevin Toepke [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 14:30To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Its easy todisable this "feature": Navigate to the Tools-Options menu Click the "Email Options" Button Uncheck the "Remove extra line breaks in plain text messages" checkbox Click Okay about 30 times and your're done! Kevin -Original Message-From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Bill The line breaks get removed from *incoming* mail, so I don't think it matterswhat your default new mail format is.I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office'in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David LordSenior DBAIron Mountain (UK) LtdTelephone: 029 2054 4000Direct: 029 2054 4013Fax: 029 2069 2464Email: [EMAIL PROTECTED] -Original Message-From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 13:24To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! -Original Message-From: Lord David [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 3:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removingline breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet is not a secure communications medium. If you are requesting or have requested the transmittal of personal data, as defined in applicable privacy laws, by means of email or in an attachment to email, you may wish to select a more secure alternate means of transmittal that better supports your obligations to protect such personal data.If the recipient of this message is not the recipient named above, and/or you have received this email in error, you must take no action based on the information in this email. You are hereby notified that any dissemination, misuse or copying or disclosure of this communication by a recipient who has received this message in error is strictly prohibited. If this message is received in error, please return this email to the sender and immediately highlight any error in transmittal. Thank you.*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** This e-mail and its attachments are intended for theauthor's addressee on
RE: !!Please Read - Oracle-L is moving!!
Title: Message I like the fine message provided when you right click on Extra line break in this message were removed. To restore, click here..that is No help topic is associated with this item oh great. Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Toepke Sent: Friday, January 23, 2004 9:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Its easy todisable this feature: Navigate to the Tools-Options menu Click the Email Options Button Uncheck the Remove extra line breaks in plain text messages checkbox Click Okay about 30 times and your're done! Kevin -Original Message- From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Bill The line breaks get removed from *incoming* mail, so I don't think it matterswhat your default new mail format is.I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office'in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David Lord Senior DBA Iron Mountain (UK) Ltd Telephone: 029 2054 4000 Direct: 029 2054 4013 Fax: 029 2069 2464 Email: [EMAIL PROTECTED] -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 13:24 To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! -Original Message- From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 3:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removingline breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet is not a secure communications medium. If you are requesting or have requested the transmittal of personal data, as defined in applicable privacy laws, by means of email or in an attachment to email, you may wish to select a more secure alternate means of transmittal that better supports your obligations to protect such personal data. If the recipient of this message is not the recipient named above, and/or you have received this email in error, you must take no action based on the information in this email. You are hereby notified that any dissemination, misuse or copying or disclosure of this communication by a recipient who has received this message in error is strictly prohibited. If this message is received in error, please return this email to the sender and immediately highlight any error in transmittal. Thank you. *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** This e-mail and its attachments are intended for the author's addressee only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications
Re: What to look for in STATSPACK report
I've tried to get ahold of Anjo off-list several times. I'm sure he is busy, but I really need to get ahold of him. Can someone off-list ask him to e-mail me at either/both of these addresses? [EMAIL PROTECTED] [EMAIL PROTECTED] Thanks Stephen [EMAIL PROTECTED] 01/23/04 12:19AM Hi Tim, Are you sure it's still owned by Veritas? Doesn't look that way when I checked it just now. Mogens Tim Gorman wrote: Helmut, Register with http://www.oraperf.com; and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense. All of the ratio stuff on the STATSPACK report is ignored by the YAPP analyzer, and instead the reformatting looks at things from the standpoint of response-time analysis, as described in the white papers at http://www.oraperf.com/whitepapers.html;. Yes, I know OraPerf is now owned by Veritas and the real URLs are different, but it'll always be just good old oraperf.com hopefully, no matter who Anjo works for... :-) Hope this helps... -Tim on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 find the last execution time of a Procedure.
We for one don't like ANYTHING invalid in production database ... either it is valid or it gets dropped. Raj -Original Message- Sent: Friday, January 23, 2004 2:24 AM To: Multiple recipients of list ORACLE-L Not sure if that is what you want... and not sure if this will really work, just a quick thought... Invalidate the procedure, so next time it will be used, it will be recompiled, and then you can see at LAST_DDL_TIME in ALL_OBJECTS to find out when it was used first after invalidating. Regards Naveen ** 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: !!Please Read - Oracle-L is moving!!
Title: Message Thanks guys! From: Kevin Toepke [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:30 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Its easy todisable this "feature": Navigate to the Tools-Options menu Click the "Email Options" Button Uncheck the "Remove extra line breaks in plain text messages" checkbox Click Okay about 30 times and your're done! Kevin -Original Message-From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Bill The line breaks get removed from *incoming* mail, so I don't think it matterswhat your default new mail format is.I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office'in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David LordSenior DBAIron Mountain (UK) LtdTelephone: 029 2054 4000Direct: 029 2054 4013Fax: 029 2069 2464Email: [EMAIL PROTECTED] -Original Message-From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 13:24To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! -Original Message-From: Lord David [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 3:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removingline breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet is not a secure communications medium. If you are requesting or have requested the transmittal of personal data, as defined in applicable privacy laws, by means of email or in an attachment to email, you may wish to select a more secure alternate means of transmittal that better supports your obligations to protect such personal data.If the recipient of this message is not the recipient named above, and/or you have received this email in error, you must take no action based on the information in this email. You are hereby notified that any dissemination, misuse or copying or disclosure of this communication by a recipient who has received this message in error is strictly prohibited. If this message is received in error, please return this email to the sender and immediately highlight any error in transmittal. Thank you.*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** This e-mail and its attachments are intended for theauthor's addressee only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. Please note that this e-mail has been created in theknowledge that Internet e-mail is not a 100% secure commu
Re: What to look for in STATSPACK report
Jared, Thanks! I'd like to try perl, but I have to admit I am totally naive on this subject. I am thinking to take a course. (free for me) How much efforts in order to set this up? ps, your graph is very impressive. I still have trouble to make the graph from excel. Thanks to Dennis, after I changed text to cloumns, it made a little progress. But I am still struggling to make it work. Joan [EMAIL PROTECTED] wrote: If you're willing to go to the trouble of setting up Perl, DBI, DBD::Oracle, DBD::Chart and its dependent libs ( graphics ), I'll send the Perl/Shell stuff I use to generate charts. It includes some modifications to YAPPPACK. That sound OK Mogens? Jared Joan Hsieh [EMAIL PROTECTED] To:Multiple Sent by: [EMAIL PROTECTED] recipients of list ORACLE-L [EMAIL PROTECTED] 01/22/2004 09:19 AM cc: Please respond to ORACLE-LSubject:Re: What to look for in STATSPACK report Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http
RE: Help - 9ias broke - hostname was changed
Title: Message Help System Admin. got a wild hair and changed the hostname on us for a 9ias v2 server. Now none of the processes work and getting all kinds of unhandled java exceptions regarding hostname oracle.ias.repository.schema.SchemaException:Unable to connect to Directory I have changed references in following: ldap.ora listener.ora tnsnames.ora htppd.conf mod_oc4j Help! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Lord DavidSent: Friday, January 23, 2004 9:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Thanks Kevin, couldn't see for looking -- David LordSenior DBAIron Mountain (UK) Ltd-Original Message-From: Kevin Toepke [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 14:30To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Its easy todisable this "feature": Navigate to the Tools-Options menu Click the "Email Options" Button Uncheck the "Remove extra line breaks in plain text messages" checkbox Click Okay about 30 times and your're done! Kevin -Original Message-From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Bill The line breaks get removed from *incoming* mail, so I don't think it matterswhat your default new mail format is.I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office'in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David LordSenior DBAIron Mountain (UK) LtdTelephone: 029 2054 4000Direct: 029 2054 4013Fax: 029 2069 2464Email: [EMAIL PROTECTED] -Original Message-From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 13:24To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! -Original Message-From: Lord David [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 3:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removingline breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet is not a secure communications medium. If you are requesting or have requested the transmittal of personal data, as defined in applicable privacy laws, by means of email or in an attachment to email, you may wis
RE: !!Please Read - Oracle-L is moving!!
Why not stop using Outlook. I've been happy with Eudora for 1.5 years now. Hemant Hemant At 07:54 AM 23-01-04 -0800, you wrote: Thanks guys! From: Kevin Toepke [mailto:[EMAIL PROTECTED]] Sent: Friday, January 23, 2004 9:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Its easy to disable this feature: Navigate to the Tools-Options menu Click the Email Options Button Uncheck the Remove extra line breaks in plain text messages checkbox Click Okay about 30 times and your're done! Kevin -Original Message- From: Lord David [mailto:[EMAIL PROTECTED]] Sent: Friday, January 23, 2004 9:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Bill The line breaks get removed from *incoming* mail, so I don't think it matters what your default new mail format is. I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office' in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David Lord Senior DBA Iron Mountain (UK) Ltd Telephone: 029 2054 4000 Direct: 029 2054 4013 Fax: 029 2069 2464 Email: [EMAIL PROTECTED] -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: 23 January 2004 13:24 To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! -Original Message- From: Lord David [mailto:[EMAIL PROTECTED]] Sent: Friday, January 23, 2004 3:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removing line breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet is not a secure communications medium. If you are requesting or have requested the transmittal of personal data, as defined in applicable privacy laws, by means of email or in an attachment to email, you may wish to select a more secure alternate means of transmittal that better supports your obligations to protect such personal data. If the recipient of this message is not the recipient named above, and/or you have received this email in error, you must take no action based on the information in this email. You are hereby notified that any dissemination, misuse or copying or disclosure of this communication by a recipient who has received this message in error is strictly prohibited. If this message is received in error, please return this email to the sender and immediately highlight any error in transmittal. Thank you. *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** This e-mail and its attachments are intended for the author's addressee only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. Steps have been taken to ensure this e-mail and attachments are free from any virus, but advise the recipient to ensure they are actually virus free. The views, opinions and judgments expressed in this message are solely those of the author. The message contents
Re: Jobs are not working
I issued commit and job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file so I don't know why the jobs are not working regards, Mauricio Vélez [EMAIL PROTECTED] wrote: A COMMIT is required after "submitting" the job.job_queue_processes = 4 === Must be greater than zero in init_SID.orafileMauricio "Vélez" <[EMAIL PROTECTED] <[EMAIL PROTECTED] ORACLE-L list of recipients Multiple To:>hoo.com cc: Sent by: Subject: Jobs are not working [EMAIL PROTECTED] .com 01/23/2004 08:29 AM Please respond to ORACLE-L Hello everybody= "urn:schemas-microsoft-com:office:office" /I'm woriking on NT and there are two 8i databases on itOne database can execute jobs normally, but the other one not execute anyjob.I proved submitting the same procedure to both database and worked on thefirst one but not on the second one.How can I resolve this?Mauricio VélezDo you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it! Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!
RE: [Q] create tablespace with different block size error???
dba1 I think you must first create a buffer cache for this block size. http://www.oracle-base.com/Articles/9i/MultipleBlockSizes.php Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 23, 2004 10:29 AM To: Multiple recipients of list ORACLE-L I tried to create tablespace with 16K (default on my init.ora blocksize =8k). I have error happen. The database version is 9.2.0.4. SQL create tablespace index1 logging datafile '/u0/oradata/leg92/index1.dbf' size 20m 2 blocksize 16384 3 autoextend on 4 next 1280k 5 maxsize unlimited 6 extent management local 7 segment space management auto 8 uniform size 128k; autoextend on * ERROR at line 3: if I take out blocksize 16384, then it work fine. SQL create tablespace index1 logging datafile '/u0/oradata/leg92/index1.dbf' size 20m 2 reuse autoextend on 3 next 1280k 4 maxsize unlimited 5 extent management local 6 segment space management auto 7 uniform size 128k; Tablespace created. Does anyone know why?? __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dba1 mcc INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: commit for triggers
A two-phase commit is simply a way to make sure that commits happen in a distributed transaction the same way that they do in a local transaction. The absolute rule is: Everything commits or Nothing does. In-between, with some parts committed and some not, is NOT tolerable. So in your transaction, the change to the audit log is NOT committed if any part of the transaction fails. Everything from the beginning of a transaction up to a commit or rollback command is part of the transaction. All DDL commands are transactions unto themselves, so they end the prior transaction (which is committed, if you have autocommit turned on, or rolled back otherwise) and the command following a DDL command starts a new transaction. Triggers execute within the same transaction as the command that triggered them, and may not include a commit or rollback. So any DML in a trigger is only committed if the entire transaction is committed. There is only one exception to this behavior. You can declare a stored procedure as an Autonomous Transaction, which means that you are starting a new transaction that is independant of the current transaction. This means that the new transaction can commit or rollback without affecting or being affected by the current transaction, and can fail without causing the current transaction to fail or succeed, even if the current transaction fails. This is very useful and powerful, but use it with caution, because you are no longer protected by the normal transaction safeguards. -Original Message- Sent: Friday, January 23, 2004 9:15 AM To: Multiple recipients of list ORACLE-L Hi All, I have a before update trigger for a local table. I know Oracle does not commit the inserting audit entry into the audit log table until the user commits the changes on the audited table. Can I assume Oracle issues one commit for both changes? When commit fails, both changes will be rolled back. However, Oracle uses two-phase commit if a trigger updates remote tables in a distributed database. What happens if Oracle commits the change in audit log table and my change subsequently fails? _ Learn how to choose, serve, and enjoy wine at Wine @ MSN. http://wine.msn.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help - 9ias broke - hostname was changed
Have the SysAdmin change the hostname back. Haven't used 9iAS but in the past, the hostname was embedded in the install config files. You can put in a DNS alias for your old hostname for a work around. [EMAIL PROTECTED] 01/23/04 11:44AM Help System Admin. got a wild hair and changed the hostname on us for a 9ias v2 server. Now none of the processes work and getting all kinds of unhandled java exceptions regarding hostname oracle.ias.repository.schema.SchemaException:Unable to connect to Directory I have changed references in following: ldap.ora listener.ora tnsnames.ora htppd.conf mod_oc4j Help! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Lord DavidSent: Friday, January 23, 2004 9:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Thanks Kevin, couldn't see for looking -- David LordSenior DBAIron Mountain (UK) Ltd-Original Message-From: Kevin Toepke [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 14:30To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Its easy todisable this "feature": Navigate to the Tools-Options menu Click the "Email Options" Button Uncheck the "Remove extra line breaks in plain text messages" checkbox Click Okay about 30 times and your're done! Kevin -Original Message-From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Bill The line breaks get removed from *incoming* mail, so I don't think it matterswhat your default new mail format is.I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office'in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David LordSenior DBAIron Mountain (UK) LtdTelephone: 029 2054 4000Direct: 029 2054 4013Fax: 029 2069 2464Email: [EMAIL PROTECTED] -Original Message-From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 13:24To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! -Original Message-From: Lord David [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 3:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removingline breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet is not a secure
Re: What to look for in STATSPACK report
Hi Jared, Is this offer open to everybody -:) I would like to get the perl/shell stuff you are referring to. I had problem to install DBI from ActivePerl before (on Windows 2000). I shall try again. Thanks, Quamrul From: Joan Hsieh <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: What to look for in STATSPACK report Date: Fri, 23 Jan 2004 08:19:25 -0800 Jared, Thanks! I'd like to try perl, but I have to admit I am totally naive on this subject. I am thinking to take a course. (free for me) How much efforts in order to set this up? ps, your graph is very impressive. I still have trouble to make the graph from excel. Thanks to Dennis, after I changed text to cloumns, it made a little progress. But I am still struggling to make it work. Joan [EMAIL PROTECTED] wrote: If you're willing to go to the trouble of setting up Perl, DBI, DBD::Oracle, DBD::Chart and its dependent libs ( graphics ), I'll send the Perl/Shell stuff I use to generate charts. It includes some modifications to YAPPPACK. That sound OK Mogens? Jared Joan Hsieh <[EMAIL PROTECTED]> To:Multiple Sent by: [EMAIL PROTECTED] recipients of list ORACLE-L <[EMAIL PROTECTED]> 01/22/2004 09:19 AM cc: Please respond to ORACLE-LSubject:Re: What to look for in STATSPACK report Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk.It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless.I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times.When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECT
RE: Sql Tuning Thoughts?
Tracy, Take a look at the thing calling this 43,814 times. Can this query be used as an inline view for the thing using this querys result set? If so, then youll eliminate 87,629 database calls. As Tom Kyte says, Tune the QUESTION, not the query. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance Diagnosis101: 1/27 Atlanta - SQL Optimization101: 2/16 Dallas - Hotsos Symposium 2004: March 710 Dallas - Visit www.hotsos.com for schedule details... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Rahmlow Sent: Thursday, January 22, 2004 11:24 AM To: Multiple recipients of list ORACLE-L Subject: Sql Tuning Thoughts? This statement is from a batch program within a pl/sql procedure. (Also, I have many similar ones within the process) The policy table has approximately 6.2 million rows. The procedure is to incrementally(daily) build an extract table from multiple tables. The extract table is then used for reporting purposes. The statement performs well per policy, however it is being executed 43,000+ times. Is there a design option available to me to reduce the number of executions and be more scaleable? I am considering the creation of an index to incorporate both the policy_number and the pol_eff_date hopefully eliminating the table access. We are currently on 8.1.7. *** SELECT MIN(P.POL_EFF_DATE) FROM PHXADM.POLICY P WHERE P.POLICY_NUMBER = :b1 call countcpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 1 0.000.01 0 0 0 0 Execute 43814 1.951.57 0 0 0 0 Fetch 43814 55.88 599.11 408248 568098 0 43814 --- -- -- -- -- -- -- total 87629 57.83 600.69 408248 568098 0 43814 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 547 (RPTADM) (recursive depth: 1) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (AGGREGATE) 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'POLICY' 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'POLICY_PK' (UNIQUE) American Express made the following annotations on 01/22/2004 10:24:24 AM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** ==
Re: OT: Solaris: Finding the cause for disk space growth
One way to determine where to start looking is via find: find / -mtime -1 -type f -print | xargs ls -ld This will find all files touched within the list day. If you get the gnu version of find, you can use '-mmin -30' to find all files touched in the last 30 minutes. You can then play with sort, and sort on the size of the file and pipe it through head to see the most recently touched files. eg. find /u03 -mtime -1 -type f -print | xargs ls -ld | sort -nr -k5.1|head -5 This command finds all files in the /u03 file system that have been touched in the last day, pipes it to ls, sorts in reverse by file size and then shows you the five largest files. You can run this on /, it will probably take several minutes. Jared Naveen, Nahata (IE10) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 12:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:OT: Solaris: Finding the cause for disk space growth Hi All, Sorry for an OT question, but nowhere else to go. Pretty new to Solaris so might be a naive question. Need a pointer on how to do this. The disk space in the machine is constantly decreasing. And I want to know which files/directories are growing. Is there any way to find out? Regards Naveen
Re: [Q] create tablespace with different block size error???
And ... what is the error number that you get ? Note : If you are creating a tablespace with the non-standard blocksize, you must have db_cache_Xk_size configured and running for your instance before you create the tablespace. Hemant At 08:29 AM 23-01-04 -0800, you wrote: I tried to create tablespace with 16K (default on my init.ora blocksize =8k). I have error happen. The database version is 9.2.0.4. SQL create tablespace index1 logging datafile '/u0/oradata/leg92/index1.dbf' size 20m 2 blocksize 16384 3 autoextend on 4 next 1280k 5 maxsize unlimited 6 extent management local 7 segment space management auto 8 uniform size 128k; autoextend on * ERROR at line 3: if I take out blocksize 16384, then it work fine. SQL create tablespace index1 logging datafile '/u0/oradata/leg92/index1.dbf' size 20m 2 reuse autoextend on 3 next 1280k 4 maxsize unlimited 5 extent management local 6 segment space management auto 7 uniform size 128k; Tablespace created. Does anyone know why?? __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dba1 mcc INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://hkchital.tripod.com {last updated 22-Jan-04} -- 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: What to look for in STATSPACK report
I run it on Linux. Should work ok on Win2k, though I haven't tried it. The modified YAPPPACK and Perl scripts are at http://www.cybcon.com/~jkstill/util/zips/yapp_chart.tgz Works in 8i and 9i. Jared Quamrul Polash [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 09:04 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: What to look for in STATSPACK report Hi Jared, Is this offer open to everybody -:) I would like to get the perl/shell stuff you are referring to. I had problem to install DBI from ActivePerl before (on Windows 2000). I shall try again. Thanks, Quamrul From: Joan Hsieh Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Subject: Re: What to look for in STATSPACK report Date: Fri, 23 Jan 2004 08:19:25 -0800 Jared, Thanks! I'd like to try perl, but I have to admit I am totally naive on this subject. I am thinking to take a course. (free for me) How much efforts in order to set this up? ps, your graph is very impressive. I still have trouble to make the graph from excel. Thanks to Dennis, after I changed text to cloumns, it made a little progress. But I am still struggling to make it work. Joan [EMAIL PROTECTED] wrote: If you're willing to go to the trouble of setting up Perl, DBI, DBD::Oracle, DBD::Chart and its dependent libs ( graphics ), I'll send the Perl/Shell stuff I use to generate charts. It includes some modifications to YAPPPACK. That sound OK Mogens? Jared Joan Hsieh To:Multiple Sent by: [EMAIL PROTECTED] recipients of list ORACLE-L 01/22/2004 09:19 AM cc: Please respond to ORACLE-L Subject:Re: What to look for in STATSPACK report Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing
Re: Oracle 8.1.7 can only use the first 15th indexes?
Ah, we've discussed this system a couple times in the past. Jared PS. Ok, ya'll move to the new list now, ya hear! Tim Gorman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004 08:24 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Oracle 8.1.7 can only use the first 15th indexes? Amen to that. I had a table with about 40 indexes on v7.0.16. I don't think that it was possible that any of them could have been ignored, because all of them were used. I can't verify that, because this system was born and died (subsequently cremated) over 10 years ago and I never thought to check while it was breathing, but like I said, all 40 or so indexes were absolutely necessary... Redesign? Well, according to the architect, this was the perfect design. Over 150 logical entities were encapsulated within this single table, which also happened to be the only table in the entire application (at least in the beginning). Appropriately enough, its name was DATA... on 1/21/04 2:44 AM, Nuno Souto at [EMAIL PROTECTED] wrote: Let's be realistic: any table with 15 indexes PROBABLY needs a little bit of a re-design exercise? ;) Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - snip (I assume the report intended to say the first 15 indexes on a specific table, 'cos the data dictionary alone has rather more than 15 indexes). -- 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).
RE: OT: Solaris: Finding the cause for disk space growth
Naveen - Are you using autoextend on any of your datafiles? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 23, 2004 11:39 AM To: Multiple recipients of list ORACLE-L One way to determine where to start looking is via find: find / -mtime -1 -type f -print | xargs ls -ld This will find all files touched within the list day. If you get the gnu version of find, you can use '-mmin -30' to find all files touched in the last 30 minutes. You can then play with sort, and sort on the size of the file and pipe it through head to see the most recently touched files. eg. find /u03 -mtime -1 -type f -print | xargs ls -ld | sort -nr -k5.1|head -5 This command finds all files in the /u03 file system that have been touched in the last day, pipes it to ls, sorts in reverse by file size and then shows you the five largest files. You can run this on /, it will probably take several minutes. Jared Naveen, Nahata (IE10) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 12:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:OT: Solaris: Finding the cause for disk space growth Hi All, Sorry for an OT question, but nowhere else to go. Pretty new to Solaris so might be a naive question. Need a pointer on how to do this. The disk space in the machine is constantly decreasing. And I want to know which files/directories are growing. Is there any way to find out? Regards Naveen -- 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: Views for a table
The table you want to look into is USER_OTN, Column DOCUMENTATION. On 01/23/2004 12:49:34 PM, Mauricio V?lez wrote: Hi everybody I have the following question How can I query a table's views? For example I have the table students and I want to know the views related to this table. Thanks, Mauricio V?lez - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- 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: [Q] create tablespace with different block size error???
Because, you left db_16k_cache_size parameter to the default value of 0 (zero). - Kirti --- dba1 mcc [EMAIL PROTECTED] wrote: I tried to create tablespace with 16K (default on my init.ora blocksize =8k). I have error happen. The database version is 9.2.0.4. SQL create tablespace index1 logging datafile '/u0/oradata/leg92/index1.dbf' size 20m 2 blocksize 16384 3 autoextend on 4 next 1280k 5 maxsize unlimited 6 extent management local 7 segment space management auto 8 uniform size 128k; autoextend on * ERROR at line 3: if I take out blocksize 16384, then it work fine. SQL create tablespace index1 logging datafile '/u0/oradata/leg92/index1.dbf' size 20m 2 reuse autoextend on 3 next 1280k 4 maxsize unlimited 5 extent management local 6 segment space management auto 7 uniform size 128k; Tablespace created. Does anyone know why?? __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help - 9ias broke - hostname was changed
Did you change LDAP configuration files? Which LDAP server was it? WebLogic? WebSphere? iPlanet? iAS? OpenLDAP? Usually, after changing the host name, servers have to be reconfigured and re-started? Does your LDAP server have a GUI admin utility and can you connect to the server by using that utility? On 01/23/2004 11:44:26 AM, [EMAIL PROTECTED] wrote: Help System Admin. got a wild hair and changed the hostname on us for a 9ias v2 server. Now none of the processes work and getting all kinds of unhandled java exceptions regarding hostname oracle.ias.repository.schema.SchemaException:Unable to connect to Directory I have changed references in following: ldap.ora listener.ora tnsnames.ora htppd.conf mod_oc4j Help! -Original Message- Lord David Sent: Friday, January 23, 2004 9:49 AM To: Multiple recipients of list ORACLE-L Thanks Kevin, couldn't see for looking -- David Lord Senior DBA Iron Mountain (UK) Ltd -Original Message- Sent: 23 January 2004 14:30 To: Multiple recipients of list ORACLE-L Its easy to disable this feature: Navigate to the Tools-Options menu Click the Email Options Button Uncheck the Remove extra line breaks in plain text messages checkbox Click Okay about 30 times and your're done! Kevin -Original Message- Sent: Friday, January 23, 2004 9:14 AM To: Multiple recipients of list ORACLE-L Bill The line breaks get removed from *incoming* mail, so I don't think it matters what your default new mail format is. I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office' in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David Lord Senior DBA Iron Mountain (UK) Ltd Telephone: 029 2054 4000 Direct: 029 2054 4013 Fax: 029 2069 2464 Email: [EMAIL PROTECTED] -Original Message- Sent: 23 January 2004 13:24 To: Multiple recipients of list ORACLE-L -Original Message- Sent: Friday, January 23, 2004 3:14 AM To: Multiple recipients of list ORACLE-L Tim Its something to do with outlook removing line breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet is not a secure communications medium. If you are requesting or have requested the transmittal of personal data, as defined in applicable privacy laws, by means of email or in an attachment to email, you may wish to select a more secure alternate means of transmittal that better supports your obligations to protect such personal data. If the recipient of this message is not the recipient named above, and/or you have received this email in error, you must take no action based on the information in this email. You are hereby notified that any dissemination, misuse or copying or disclosure of this communication by a recipient who has received this message in error is strictly prohibited. If this message is received in error, please return this email to the sender and immediately highlight any error in transmittal. Thank you. *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** This e-mail and its attachments are intended for the author's addressee only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error
RE: Help - 9ias broke - hostname was changed
Seriously, and without any trace of a smile, I can say that someone doing that on a high visibility system would stand a very good chance of having the opportunity to seek new employment. PS. If you're reading this, subscribe to the new list. This one's days are limited to about 10. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 08:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Help - 9ias broke - hostname was changed Help System Admin. got a wild hair and changed the hostname on us for a 9ias v2 server. Now none of the processes work and getting all kinds of unhandled java exceptions regarding hostname oracle.ias.repository.schema.SchemaException:Unable to connect to Directory I have changed references in following: ldap.ora listener.ora tnsnames.ora htppd.conf mod_oc4j Help! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Lord David Sent: Friday, January 23, 2004 9:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Thanks Kevin, couldn't see for looking -- David Lord Senior DBA Iron Mountain (UK) Ltd -Original Message- From: Kevin Toepke [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 14:30 To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Its easy to disable this feature: Navigate to the Tools-Options menu Click the Email Options Button Uncheck the Remove extra line breaks in plain text messages checkbox Click Okay about 30 times and your're done! Kevin -Original Message- From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Bill The line breaks get removed from *incoming* mail, so I don't think it matters what your default new mail format is. I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office' in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David Lord Senior DBA Iron Mountain (UK) Ltd Telephone: 029 2054 4000 Direct: 029 2054 4013 Fax: 029 2069 2464 Email: [EMAIL PROTECTED] -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 13:24 To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! -Original Message- From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 3:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: !!Please Read - Oracle-L is moving!! Tim Its something to do with outlook removing line breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet is not a secure communications medium. If you are requesting or have requested the transmittal of personal data, as defined in applicable privacy laws, by means of email or in an attachment to email, you may wish to select a more secure alternate means of transmittal that better supports your obligations to protect such personal data. If the recipient of this message is not the recipient named above, and/or you have received this email in error, you must take no action based on the information in this email. You are hereby notified
Re: [Q] create tablespace with different block size error???
You may want to define DB_16K_CACHE_SIZE in init.ora, or use ALTER SYSTEM to set this value. HTH, Krishna ~~ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ~~ dba1 mcc wrote: I tried to create tablespace with 16K (default on my init.ora blocksize =8k). I have error happen. The database version is 9.2.0.4. SQL create tablespace index1 logging datafile '/u0/oradata/leg92/index1.dbf' size 20m 2 blocksize 16384 3 autoextend on 4 next 1280k 5 maxsize unlimited 6 extent management local 7 segment space management auto 8 uniform size 128k; autoextend on * ERROR at line 3: if I take out blocksize 16384, then it work fine. SQL create tablespace index1 logging datafile '/u0/oradata/leg92/index1.dbf' size 20m 2 reuse autoextend on 3 next 1280k 4 maxsize unlimited 5 extent management local 6 segment space management auto 7 uniform size 128k; Tablespace created. Does anyone know why?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishna Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Views for a table
Title: Message Query DBA_DEPENDENCIES where type='VIEW' and referenced_name='STUDENTS' and referenced_type='TABLE'. -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: Views for a table Hi everybody I have the following question How can I querya table's views? For example I have the table students and I want to know the views related to this table. Thanks, Mauricio Vélez Do you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it!
RE: Jobs are not working
Are the jobs "broken"?? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 12:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Jobs are not working I issued commit and job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file so I don't know why the jobs are not working regards, Mauricio Vélez [EMAIL PROTECTED] wrote: A COMMIT is required after "submitting" the job.job_queue_processes = 4 === Must be greater than zero in init_SID.orafileMauricio "Vélez" <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>hoo.com cc: Sent by: Subject: Jobs are not working [EMAIL PROTECTED] .com 01/23/2004 08:29 AM Please respond to ORACLE-L Hello everybody= "urn:schemas-microsoft-com:office:office" /I'm woriking on NT and there are two 8i databases on itOne database can execute jobs normally, but the other one not execute anyjob.I proved submitting the same procedure to both database and worked on thefirst one but not on the second one.How can I resolve this?Mauricio VélezDo you Yahoo!?Yahoo! SiteBuild! er - Free web site building tool. Try it! Do you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it!
RE: Application Server Caching
SAP R/3 has taken advantage of this approach for a long time now. It buffers tables based on settings in the R/3 data dictionary and can buffer single rows, groups of rows, or entire tables. Tables which are used to store configuration information are typically fully buffered, while transactional tables are buffered using either single rows or generic keys. Tables which have high concurrency arent generally buffered at all to prevent inconsistent views of the data from different application servers. All app servers in a given system synchronize their buffers (default every 60 seconds if memory serves); if a buffered row is updated, its marked dirty in the buffer, then the dirty bits are syncd to the other app servers. The first app server to request that row re-validates the buffer. They also handle sequences in a similar way; SAP uses number ranges rather than relying on vendor specific sequences. A number range is just a table of min, max, current numbers basically. For something like sales orders, it doesnt really matter if you skip a few numbers occasionally, so they allow you to buffer these as well, and control how many are buffered. For example, in a system with 2 app servers and a buffer size of 10 with a number range and current number 1000, the first application server will reset the current field in the table to 1010 and allocate 1000-1009 for itself; all requests for a sequence for that number range are answered locally on that app server. The disadvantage to this is that if the app server crashes, you can lose potentially 10 numbers from your sequence, and your sales orders (or whatever youre numbering) can get out of sequence (i.e. not monotonically increasing over time). Generally this isnt a problem, but they do allow you to disable this for each individual number range if you have contractual or legal requirements for doing so. Having directly seen the performance impact of both table and sequence buffering on the application server, I can attest that its very useful. A buffer access on the app server is a micro-second operation, whereas a database access over the network thats served from the DBs buffers is on the order of 10s of milliseconds. One that has to go clear to disk can be in the 100s of milliseconds from the applications point of view. Granted these numbers improve every year with technology, but the idea is that memory is faster than database buffers, which are in turn faster than going clear to disk for something Cheers! Rich -- Rich Holland (913) 645-1950 SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rich Holland INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Jobs are not working
The Jobs are not broken I haven't resolve this yet, alljobswork fineon one database buton the other not. How can I resolve this? Mauricio Vélez "Goulet, Dick" [EMAIL PROTECTED] wrote: Are the jobs "broken"?? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 233, 2004 12:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Jobs are not working I issued commit and job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file so I don't know why the jobs are not working regards, Mauricio Vélez [EMAIL PROTECTED] wrote: A COMMIT is required after "submitting" the job.job_queue_processes = 4 === Must be greater than zero in init_SID.orafileMauricio "Vélez" <[EMAIL PROTECTED] <[EMAIL PROTECTED] ORACLE-L list of recipients Multiple To:>hoo.com cc: Sent by: Subject: Jobs are not working [EMAIL PROTECTED] .com 01/23/2004 08:29 AM Please respond to ORACLE-L Hello everybody= "urn:schemas-microsoft-com:office:office" /I'm woriking on NT and there are two 8i databases on itOne database can execute jobs normally, but the other one not execute anyjob.I proved submitting the same procedure to both database and worked on thefirst one but not on the second one.How can I resolve this?Mauricio VélezDo you Yahoo!?Yahoo! SiteBuild! er - Free web site building tool. Try it! Do you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it! Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!
RE: Jobs are not working
Can you execute the "what" column's contents in SQL*PLus. Sometimes table permissions get in the way. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:56 PMTo: [EMAIL PROTECTED]Cc: Goulet, DickSubject: RE: Jobs are not working The Jobs are not broken I haven't resolve this yet, alljobswork fineon one database buton the other not. How can I resolve this? Mauricio Vélez "Goulet, Dick" [EMAIL PROTECTED] wrote: Are the jobs "broken"?? Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 12:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Jobs are not working I issued commit and job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file so I don't know why the jobs are not working regards, Mauricio Vélez [EMAIL PROTECTED] wrote: A COMMIT is required after "submitting" the job.job_queue_processes = 4 === Must be greater than zero in init_SID.orafileMauricio "Vélez" <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>hoo.com cc: Sent by: Subject: Jobs are not working [EMAIL PROTECTED] .com 01/23/2004 08:29 AM Please respond to ORACLE-L Hello everybody= "urn:schemas-microsoft-com:office:office" /I'm woriking on NT and there are two 8i databases on itOne database can execute jobs normally, but the other one not execute anyjob.I proved submitting the same procedure to both database and worked on thefirst one but not on the second one.How can I resolve this?Mauricio VélezDo you Yahoo!?Yahoo! SiteBuild! ! er - Free web site building tool. Try it! Do you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it! Do you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it!
Re: Jobs are not working
On 01/23/2004 11:29:32 AM, Mauricio V?lez wrote: How can I resolve this? By reading the administrators guide. -- 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: [Q] create tablespace with different block size error???
On 01/23/2004 12:19:26 PM, Kirtikumar Deshpande wrote: Because, you left db_16k_cache_size parameter to the default value of 0 (zero). - Kirti He probably has left db_16k_cache_size parameter but the problem described here is with syntax, not the cache size. Parser stops looking or file attributes as soon as it encounters the first attribute that isn't a file attribute, like, for instance, block size. If he rearranges the statement, he'll get the right error. -- 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: Help - 9ias broke - hostname was changed
Yes, but how do I fix it? Do I need to reinstall? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Help - 9ias broke - hostname was changedSeriously, and without any trace of a smile, I can say that someone doing that on a high visibility system would stand a very good chance of having the opportunity to seek new employment. PS. If you're reading this, subscribe to the new list. This one's days are limited to about 10. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 08:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Help - 9ias broke - hostname was changedHelp System Admin. got a wild hair and changed the hostname on us for a 9ias v2 server. Now none of the processes work and getting all kinds of unhandled java exceptions regarding hostname oracle.ias.repository.schema.SchemaException:Unable to connect to Directory I have changed references in following: ldap.ora listener.ora tnsnames.ora htppd.conf mod_oc4j Help! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Lord DavidSent: Friday, January 23, 2004 9:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!!Thanks Kevin, couldn't see for looking -- David LordSenior DBAIron Mountain (UK) Ltd-Original Message-From: Kevin Toepke [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 14:30To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!!Its easy to disable this "feature": Navigate to the Tools-Options menu Click the "Email Options" Button Uncheck the "Remove extra line breaks in plain text messages" checkbox Click Okay about 30 times and your're done! Kevin -Original Message-From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!!Bill The line breaks get removed from *incoming* mail, so I don't think it matters what your default new mail format is. I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office' in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David LordSenior DBAIron Mountain (UK) LtdTelephone: 029 2054 4000Direct: 029 2054 4013Fax: 029 2069 2464Email: [EMAIL PROTECTED] -Original Message-From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 13:24To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! -Original Message-From: Lord David [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 3:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!!Tim Its something to do with outlook removing line breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and
RE: internal date value
You gather it wrong :) Oracle stores date in 8 bytes, one for each: year, month, day, hour, min, ... etc. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Droogendyk, Harry Sent: Friday, January 23, 2004 12:40 PM To: Multiple recipients of list ORACLE-L Folks: From what I gather, Oracle stores dates as the number of elapsed days since Jan 1, 1968. When I query a column of type 'DATE', it returns me the default format, dd-mon-yy. I know I can use to_char(date_col,'MMDD') etc... to define many output formats. What can I do to get the raw internal value of the date? i.e. today is 13172. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help - 9ias broke - hostname was changed
I think he lucked out and didn't do this on a highly visible system. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Help - 9ias broke - hostname was changedSeriously, and without any trace of a smile, I can say that someone doing that on a high visibility system would stand a very good chance of having the opportunity to seek new employment. PS. If you're reading this, subscribe to the new list. This one's days are limited to about 10. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 08:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Help - 9ias broke - hostname was changedHelp System Admin. got a wild hair and changed the hostname on us for a 9ias v2 server. Now none of the processes work and getting all kinds of unhandled java exceptions regarding hostname oracle.ias.repository.schema.SchemaException:Unable to connect to Directory I have changed references in following: ldap.ora listener.ora tnsnames.ora htppd.conf mod_oc4j Help! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Lord DavidSent: Friday, January 23, 2004 9:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!!Thanks Kevin, couldn't see for looking -- David LordSenior DBAIron Mountain (UK) Ltd-Original Message-From: Kevin Toepke [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 14:30To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!!Its easy to disable this "feature": Navigate to the Tools-Options menu Click the "Email Options" Button Uncheck the "Remove extra line breaks in plain text messages" checkbox Click Okay about 30 times and your're done! Kevin -Original Message-From: Lord David [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!!Bill The line breaks get removed from *incoming* mail, so I don't think it matters what your default new mail format is. I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office' in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David LordSenior DBAIron Mountain (UK) LtdTelephone: 029 2054 4000Direct: 029 2054 4013Fax: 029 2069 2464Email: [EMAIL PROTECTED] -Original Message-From: Thater, William [mailto:[EMAIL PROTECTED] Sent: 23 January 2004 13:24To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! -Original Message-From: Lord David [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 3:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!!Tim Its something to do with outlook removing line breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications
RE: Jobs are not working
Title: Message Mauricio: Define the exact symptoms of your problem. For example: How are the jobs being submitted? Are you getting an error message upon submission? How do you know they're not running? Have you queries dba_jobs_running? Please respond with any diagnostic error messages, or any other documentation you wish to provide to give us more detail. Michael Fontana Sr. DBA NTT/Verio -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mauricio VXlezSent: Friday, January 23, 2004 11:04 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Jobs are not working I issued commit and job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file so I don't know why the jobs are not working regards, Mauricio Vélez [EMAIL PROTECTED] wrote: A COMMIT is required after "submitting" the job.job_queue_processes = 4 === Must be greater than zero in init_SID.orafileMauricio "Vélez" <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>hoo.com cc: Sent by: Subject: Jobs are not working [EMAIL PROTECTED] .com 01/23/2004 08:29 AM Please respond to ORACLE-L Hello everybody= "urn:schemas-microsoft-com:office:office" /I'm woriking on NT and there are two 8i databases on itOne database can execute jobs normally, but the other one not execute anyjob.I proved submitting the same procedure to both database and worked on thefirst one but not on the second one.How can I resolve this?Mauricio VélezDo you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it! Do you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it!
Re: !!Please Read - Oracle-L is moving!!
Ref: Fix subscription errors after Final Confirmation message I'm on Yahoo. The workaround is to send the Final Confirmation message (with that //job stuff) back using the Forward button (not Reply). You have to cut-paste the address. The problem with Reply is caused by HTML formatting in the Reply scrollable window, which may add a CR to the command and fail. However, if you use Forward instead of Reply there is no editing nor formatting and it works! Good luck, see you there... Regards, Mike Thomas Oracle-L will be hosted by freelists.org, effective immediately. -- to subscribe: send email to [EMAIL PROTECTED] with 'subscribe' in the Subject field OR Subscribe via the web site - http://www.freelists.org/login.html To send email to the list, use this address: [EMAIL PROTECTED] You can unsubscribe from [EMAIL PROTECTED] by: send email to [EMAIL PROTECTED] with 'unsubscribe' in the Subject field OR Unsubscribe via the web site - http://www.freelists.org/login.html Documentation - http://www.freelists.org/help/. Searchable archives - http://www.freelists.org/archives/oracle-l __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: commit for triggers
John, Thanks for your very detail explanation. From: John Flack [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: commit for triggers Date: Fri, 23 Jan 2004 09:09:34 -0800 A two-phase commit is simply a way to make sure that commits happen in a distributed transaction the same way that they do in a local transaction. The absolute rule is: Everything commits or Nothing does. In-between, with some parts committed and some not, is NOT tolerable. So in your transaction, the change to the audit log is NOT committed if any part of the transaction fails. Everything from the beginning of a transaction up to a commit or rollback command is part of the transaction. All DDL commands are transactions unto themselves, so they end the prior transaction (which is committed, if you have autocommit turned on, or rolled back otherwise) and the command following a DDL command starts a new transaction. Triggers execute within the same transaction as the command that triggered them, and may not include a commit or rollback. So any DML in a trigger is only committed if the entire transaction is committed. There is only one exception to this behavior. You can declare a stored procedure as an Autonomous Transaction, which means that you are starting a new transaction that is independant of the current transaction. This means that the new transaction can commit or rollback without affecting or being affected by the current transaction, and can fail without causing the current transaction to fail or succeed, even if the current transaction fails. This is very useful and powerful, but use it with caution, because you are no longer protected by the normal transaction safeguards. -Original Message- Sent: Friday, January 23, 2004 9:15 AM To: Multiple recipients of list ORACLE-L Hi All, I have a before update trigger for a local table. I know Oracle does not commit the inserting audit entry into the audit log table until the user commits the changes on the audited table. Can I assume Oracle issues one commit for both changes? When commit fails, both changes will be rolled back. However, Oracle uses two-phase commit if a trigger updates remote tables in a distributed database. What happens if Oracle commits the change in audit log table and my change subsequently fails? _ Learn how to choose, serve, and enjoy wine at Wine @ MSN. http://wine.msn.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Check out the new MSN 9 Dial-up fast reliable Internet access with prime features! http://join.msn.com/?pgmarket=en-uspage=dialup/homeST=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: internal date value
Igor Sorry but Oracle uses 7 bytes for a date century (1 byte) year (1 byte) month (1 byte) day (1 byte) hour (1 byte) minute (1 byte) second (1 byte) SQL desc d Name Null?Type - D DATE SQL col dump format a40 SQL select to_char(d, 'dd mon hh24:mi:ss'), dump(d) dump from d; TO_CHAR(D,'DDMON DUMP 05 may 0001 15:30:45 Typ=12 Len=7: 100,101,5,5,16,31,46 05 may 0100 15:30:45 Typ=12 Len=7: 101,100,5,5,16,31,46 05 may 0500 15:30:45 Typ=12 Len=7: 105,100,5,5,16,31,46 05 may 1000 15:30:45 Typ=12 Len=7: 110,100,5,5,16,31,46 05 may 1500 15:30:45 Typ=12 Len=7: 115,100,5,5,16,31,46 05 may 1999 15:30:45 Typ=12 Len=7: 119,199,5,5,16,31,46 05 may 2000 15:30:45 Typ=12 Len=7: 120,100,5,5,16,31,46 05 may 2100 15:30:45 Typ=12 Len=7: 121,100,5,5,16,31,46 05 may 2500 15:30:45 Typ=12 Len=7: 125,100,5,5,16,31,46 05 may 2600 15:30:45 Typ=12 Len=7: 126,100,5,5,16,31,46 05 may 2900 15:30:45 Typ=12 Len=7: 129,100,5,5,16,31,46 05 may 3000 15:30:45 Typ=12 Len=7: 130,100,5,5,16,31,46 12 rows selected. /peter Igor Neyman wrote: You gather it wrong :) Oracle stores date in 8 bytes, one for each: year, month, day, hour, min, ... etc. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Droogendyk, Harry Sent: Friday, January 23, 2004 12:40 PM To: Multiple recipients of list ORACLE-L Folks: From what I gather, Oracle stores dates as the number of elapsed days since Jan 1, 1968. When I query a column of type 'DATE', it returns me the default format, dd-mon-yy. I know I can use to_char(date_col,'MMDD') etc... to define many output formats. What can I do to get the raw internal value of the date? i.e. today is 13172. Thanks. -- Best regards/Venlig hilsen /*Peter Gram*/ mailto:[EMAIL PROTECTED] Miracle A/S http://www.miracleas.dk/ Kratvej 2 DK - 2760 Måløv Cell: (+45) 2527 7107 Phone: (+45) 4466 8855 Fax: (+45) 4466 8856 Home: (+45) 3874 5696 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] SQL Server Master Class 8-10 Marts, Database Forum 28-30 October Master Class 17-19 Januar 2005. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: internal date value
Harry, Can you explain why you need to raw internal value? Just curious. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 23, 2004 1:40 PM To: Multiple recipients of list ORACLE-L You gather it wrong :) Oracle stores date in 8 bytes, one for each: year, month, day, hour, min, ... etc. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Droogendyk, Harry Sent: Friday, January 23, 2004 12:40 PM To: Multiple recipients of list ORACLE-L Folks: From what I gather, Oracle stores dates as the number of elapsed days since Jan 1, 1968. When I query a column of type 'DATE', it returns me the default format, dd-mon-yy. I know I can use to_char(date_col,'MMDD') etc... to define many output formats. What can I do to get the raw internal value of the date? i.e. today is 13172. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: internal date value
Thomas: I'm a SAS guy who must pull Oracle data from the back-end DB. SAS stores dates internally as elapsed days since Jan 1, 1960. If I request an Oracle date field, SAS creates a datetime variable, number of seconds since midnight Jan 1, 1960. Rather than use SAS functions to extract the date ( e.g. datepart function ), I'd like to push that back to Oracle if possible and create a simple date field on SAS. I can accomplish the desired effect with: select date_fld - to_date('01Jan1960','ddmon') as sas_date but I was hoping there was an Oracle function to surface the internal value ( appears to be days since Jan 1, 1968 ). Presumably such a function would be more efficient. Thanks for your help. -Original Message- Sent: January 23, 2004 2:50 PM To: Multiple recipients of list ORACLE-L Harry, Can you explain why you need to raw internal value? Just curious. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 23, 2004 1:40 PM To: Multiple recipients of list ORACLE-L You gather it wrong :) Oracle stores date in 8 bytes, one for each: year, month, day, hour, min, ... etc. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Droogendyk, Harry Sent: Friday, January 23, 2004 12:40 PM To: Multiple recipients of list ORACLE-L Folks: From what I gather, Oracle stores dates as the number of elapsed days since Jan 1, 1968. When I query a column of type 'DATE', it returns me the default format, dd-mon-yy. I know I can use to_char(date_col,'MMDD') etc... to define many output formats. What can I do to get the raw internal value of the date? i.e. today is 13172. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: internal date value
Harry This list is moving to freelists, but I'll assume you knew that. Actually the base value for the standard Oracle dates is Jan 1, 4712 BC. There is a Julian function that will return the number of days since the base. To return the Julian, select to_char(sysdate,'J') from dual; Also, Oracle9i has some new date types and you may find one that works better for your purposes: http://otn.oracle.com/products/oracle9i/daily/may02.html Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 23, 2004 11:40 AM To: Multiple recipients of list ORACLE-L Folks: From what I gather, Oracle stores dates as the number of elapsed days since Jan 1, 1968. When I query a column of type 'DATE', it returns me the default format, dd-mon-yy. I know I can use to_char(date_col,'MMDD') etc... to define many output formats. What can I do to get the raw internal value of the date? i.e. today is 13172. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: commit for triggers
John, I agree w/ everything you said, except for the autocommit functionality. Autocommit setting has no impact on whether DDL will commit or rollback any in progress transaction. DDL always commits an in-progress transaction. The short example below speaks for itself. (8.1.7.4 on Solaris 2.8) SQL show autocommit autocommit OFF SQL desc a Name Null?Type - COL1 NUMBER COL2 NUMBER SQL select * from a where col1=-12345; no rows selected SQL insert into a values(-12345,-12345); 1 row created. SQL create table xxx(a number); Table created. SQL select * from a where col1=-12345; COL1 COL2 -- -- -12345 -12345 1 row selected. Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Friday, January 23, 2004 12:10 PM To: Multiple recipients of list ORACLE-L A two-phase commit is simply a way to make sure that commits happen in a distributed transaction the same way that they do in a local transaction. The absolute rule is: Everything commits or Nothing does. In-between, with some parts committed and some not, is NOT tolerable. So in your transaction, the change to the audit log is NOT committed if any part of the transaction fails. Everything from the beginning of a transaction up to a commit or rollback command is part of the transaction. All DDL commands are transactions unto themselves, so they end the prior transaction (which is committed, if you have autocommit turned on, or rolled back otherwise) and the command following a DDL command starts a new transaction. Triggers execute within the same transaction as the command that triggered them, and may not include a commit or rollback. So any DML in a trigger is only committed if the entire transaction is committed. There is only one exception to this behavior. You can declare a stored procedure as an Autonomous Transaction, which means that you are starting a new transaction that is independant of the current transaction. This means that the new transaction can commit or rollback without affecting or being affected by the current transaction, and can fail without causing the current transaction to fail or succeed, even if the current transaction fails. This is very useful and powerful, but use it with caution, because you are no longer protected by the normal transaction safeguards. -Original Message- Sent: Friday, January 23, 2004 9:15 AM To: Multiple recipients of list ORACLE-L Hi All, I have a before update trigger for a local table. I know Oracle does not commit the inserting audit entry into the audit log table until the user commits the changes on the audited table. Can I assume Oracle issues one commit for both changes? When commit fails, both changes will be rolled back. However, Oracle uses two-phase commit if a trigger updates remote tables in a distributed database. What happens if Oracle commits the change in audit log table and my change subsequently fails? _ Learn how to choose, serve, and enjoy wine at Wine @ MSN. http://wine.msn.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California
RE: winders email client.
- -Original Message- - From: Ron Thomas [mailto:[EMAIL PROTECTED] - Sent: Friday, January 23, 2004 11:49 AM - To: Multiple recipients of list ORACLE-L - Subject: winders email client. - - - - have you tried firebird? firebird is a web browser without an email client. thunderbird is the email client and it doesn't gork MAPI. i use firebird for all my browsing.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Time is an illusion, lunchtime doubly so. - Douglas Adams -- 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: Help - 9ias broke - hostname was changed
Paula - You put on your saddest face, match that with your body language, shuffle into the sys admin's cube and solemly announce you're going to have to fix this, change the hostname back. Then brighten a little, come closer and whisper I think I can keep anyone from finding out what you did. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 23, 2004 1:19 PM To: Multiple recipients of list ORACLE-L Yes, but how do I fix it? Do I need to reinstall? -Original Message- [EMAIL PROTECTED] Sent: Friday, January 23, 2004 1:14 PM To: Multiple recipients of list ORACLE-L Seriously, and without any trace of a smile, I can say that someone doing that on a high visibility system would stand a very good chance of having the opportunity to seek new employment. PS. If you're reading this, subscribe to the new list. This one's days are limited to about 10. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 08:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Help - 9ias broke - hostname was changed Help System Admin. got a wild hair and changed the hostname on us for a 9ias v2 server. Now none of the processes work and getting all kinds of unhandled java exceptions regarding hostname oracle.ias.repository.schema.SchemaException:Unable to connect to Directory I have changed references in following: ldap.ora listener.ora tnsnames.ora htppd.conf mod_oc4j Help! -Original Message- David Sent: Friday, January 23, 2004 9:49 AM To: Multiple recipients of list ORACLE-L Thanks Kevin, couldn't see for looking -- David Lord Senior DBA Iron Mountain (UK) Ltd -Original Message- Sent: 23 January 2004 14:30 To: Multiple recipients of list ORACLE-L Its easy to disable this feature: Navigate to the Tools-Options menu Click the Email Options Button Uncheck the Remove extra line breaks in plain text messages checkbox Click Okay about 30 times and your're done! Kevin -Original Message- Sent: Friday, January 23, 2004 9:14 AM To: Multiple recipients of list ORACLE-L Bill The line breaks get removed from *incoming* mail, so I don't think it matters what your default new mail format is. I think its a new 'feature' in Outlook 2003 - I found this quote in the 'Whats new in Microsoft Office' in online help: - Extra line breaks automatically removed in messages Sometimes plain text messages that travel over the Internet acquire extra line breaks that make the message difficult to read. Outlook automatically removes the extra line breaks so it's easier to read the message. Ouch David Lord Senior DBA Iron Mountain (UK) Ltd Telephone: 029 2054 4000 Direct: 029 2054 4013 Fax: 029 2069 2464 Email: [EMAIL PROTECTED] -Original Message- Sent: 23 January 2004 13:24 To: Multiple recipients of list ORACLE-L -Original Message- Sent: Friday, January 23, 2004 3:14 AM To: Multiple recipients of list ORACLE-L Tim Its something to do with outlook removing line breaks and thereby mangling the formatting of the command. In my Outlook, there is a message in the header of the mail saying something like 'Extra line breaks in this message were removed. To restore click here.' When I did click there and replied the subscription went through okay. What on earth lookout is doing removing line breaks I'm not sure. How does it decide which line breaks to remove? I couldn't find any way of stopping it doing this. well, it looks to me as if you're using HTML and/or Word for your email, and Outlook in it's infinite wisdom replaces line brakes with BR or whatever the hell Word uses. as to stopping it, i have no idea. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Yes, we have to divide up our time like that, between our politics and our equations. But to me our equations are far more important, for politics are only a matter of present concern. A mathematical equation stands forever. - Albert Einstein This email and its attachments are confidential under applicable law and are intended for use of the sender's addressee only, unless the sender expressly agrees otherwise, or unless a separate written agreement exists between Iron Mountain and a recipient company governing communications between the parties and any data that may be so transmitted. Transmission of email over the Internet is not a secure communications medium. If you are requesting or have requested the transmittal of personal data, as defined in applicable privacy laws, by means of email or in an attachment to email, you may wish
RE: Views for a table
Mladen, Any privileges required to view this table, or just common sense? :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Mladen Gogala Sent: Friday, January 23, 2004 1:24 PM To: Multiple recipients of list ORACLE-L The table you want to look into is USER_OTN, Column DOCUMENTATION. On 01/23/2004 12:49:34 PM, Mauricio V?lez wrote: Hi everybody I have the following question How can I query a table's views? For example I have the table students and I want to know the views related to this table. Thanks, Mauricio V?lez - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- 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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: internal date value
Oops... Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Peter Gram Sent: Friday, January 23, 2004 2:54 PM To: Multiple recipients of list ORACLE-L Igor Sorry but Oracle uses 7 bytes for a date century (1 byte) year (1 byte) month (1 byte) day (1 byte) hour (1 byte) minute (1 byte) second (1 byte) SQL desc d Name Null?Type - D DATE SQL col dump format a40 SQL select to_char(d, 'dd mon hh24:mi:ss'), dump(d) dump from d; TO_CHAR(D,'DDMON DUMP 05 may 0001 15:30:45 Typ=12 Len=7: 100,101,5,5,16,31,46 05 may 0100 15:30:45 Typ=12 Len=7: 101,100,5,5,16,31,46 05 may 0500 15:30:45 Typ=12 Len=7: 105,100,5,5,16,31,46 05 may 1000 15:30:45 Typ=12 Len=7: 110,100,5,5,16,31,46 05 may 1500 15:30:45 Typ=12 Len=7: 115,100,5,5,16,31,46 05 may 1999 15:30:45 Typ=12 Len=7: 119,199,5,5,16,31,46 05 may 2000 15:30:45 Typ=12 Len=7: 120,100,5,5,16,31,46 05 may 2100 15:30:45 Typ=12 Len=7: 121,100,5,5,16,31,46 05 may 2500 15:30:45 Typ=12 Len=7: 125,100,5,5,16,31,46 05 may 2600 15:30:45 Typ=12 Len=7: 126,100,5,5,16,31,46 05 may 2900 15:30:45 Typ=12 Len=7: 129,100,5,5,16,31,46 05 may 3000 15:30:45 Typ=12 Len=7: 130,100,5,5,16,31,46 12 rows selected. /peter Igor Neyman wrote: You gather it wrong :) Oracle stores date in 8 bytes, one for each: year, month, day, hour, min, ... etc. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Droogendyk, Harry Sent: Friday, January 23, 2004 12:40 PM To: Multiple recipients of list ORACLE-L Folks: From what I gather, Oracle stores dates as the number of elapsed days since Jan 1, 1968. When I query a column of type 'DATE', it returns me the default format, dd-mon-yy. I know I can use to_char(date_col,'MMDD') etc... to define many output formats. What can I do to get the raw internal value of the date? i.e. today is 13172. Thanks. -- Best regards/Venlig hilsen /*Peter Gram*/ mailto:[EMAIL PROTECTED] Miracle A/S http://www.miracleas.dk/ Kratvej 2 DK - 2760 Måløv Cell: (+45) 2527 7107 Phone: (+45) 4466 8855 Fax: (+45) 4466 8856 Home: (+45) 3874 5696 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] SQL Server Master Class 8-10 Marts, Database Forum 28-30 October Master Class 17-19 Januar 2005. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: internal date value
Thomas: I'm aware of the to_char function and the various options. However as you alluded to, that lands in SAS as a character literal, e.g. '22/01/2004' requiring me to convert it to internal format before I can use it in SAS. I think I have to use my work around: select date_fld - to_date('01Jan1960','ddmon') as sas_date Thanks for your time and help. -Original Message- Sent: January 23, 2004 3:32 PM To: '[EMAIL PROTECTED]' Cc: Droogendyk, Harry Harry, Look at the to_char function in Oracle. It will convert a date field to *any* format you want. for example: select to_char(date_field,'mm/dd/ hh24miss') will return a date in the format as noted. You have about as many options as you probably need. You can combine as many format and functions as you think you need. to_char translates dates to chars and to_date does the opposite - but both use the same format statements. This should work fine for you. And for you info - Oracle dates are stored internally based on a date going back many centuries - not just to 1968! Good Luck Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 23, 2004 3:09 PM To: Multiple recipients of list ORACLE-L Thomas: I'm a SAS guy who must pull Oracle data from the back-end DB. SAS stores dates internally as elapsed days since Jan 1, 1960. If I request an Oracle date field, SAS creates a datetime variable, number of seconds since midnight Jan 1, 1960. Rather than use SAS functions to extract the date ( e.g. datepart function ), I'd like to push that back to Oracle if possible and create a simple date field on SAS. I can accomplish the desired effect with: select date_fld - to_date('01Jan1960','ddmon') as sas_date but I was hoping there was an Oracle function to surface the internal value ( appears to be days since Jan 1, 1968 ). Presumably such a function would be more efficient. Thanks for your help. -Original Message- Sent: January 23, 2004 2:50 PM To: Multiple recipients of list ORACLE-L Harry, Can you explain why you need to raw internal value? Just curious. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 23, 2004 1:40 PM To: Multiple recipients of list ORACLE-L You gather it wrong :) Oracle stores date in 8 bytes, one for each: year, month, day, hour, min, ... etc. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Droogendyk, Harry Sent: Friday, January 23, 2004 12:40 PM To: Multiple recipients of list ORACLE-L Folks: From what I gather, Oracle stores dates as the number of elapsed days since Jan 1, 1968. When I query a column of type 'DATE', it returns me the default format, dd-mon-yy. I know I can use to_char(date_col,'MMDD') etc... to define many output formats. What can I do to get the raw internal value of the date? i.e. today is 13172. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Droogendyk, Harry INET:
RE: pga_aggregate_target and a memory leak
Kirti, So is April 12th the latest date you heard for when 10g might be released?? Because it was the end of 2003, but I didn't know it had slipped all the way into April... -Original Message- Kirtikumar Deshpande Sent: Wednesday, January 21, 2004 7:24 PM To: Multiple recipients of list ORACLE-L Thanks, Ryan. Yes, it is on OWI, for those who are new to OWI. Covers OWI from 8i to 10g. Co-authored with Richmond Shee and K.Gopalakrishnan. It will not be out till 10g goes production. Unfortunately, April 12th is not firm. 10g changes Regards, - Kirti --- Ryan [EMAIL PROTECTED] wrote: Im assuming its his wait interface book. Ill get it as soon as it comes out. Hopefully it will be as good as his other tuning book. Is the April 12th date firm? Now the bigger question: Will it be out before the 10G database? http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/qid=1074724628/ sr=1 -2/ref=sr_1_2/104-1361632-8254324?v=glances=books - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 5:14 PM A comment I picked up from Tom Kyte's Masterclass in Copenhagen last week was that there is an effective limit of 1GB to P_A_T - and although a single session is supposed to be allowed 5% of the P_A_T, you could get about 90MB. So there are some funny things going on in that area which still need fixing. It's a bit tough for big systems, as I've found that the optimizer seems to be much smarter about memory user and access paths when P_A_T and W_S_P are set. What's the book about ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 7:44 PM Replies in line... - Kirti --- [EMAIL PROTECTED] wrote: Kirti, you're back! Thanks. Found some slack time from routine DBA work! Must have finished the book. :) Not yet.. Its tough.. Re the PGA problems, what was the value for 'over allocation count' in v$pgastat? Actually, I never bothered to look at v$pgastat. Should have.. and will, when we do some more testing next week.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see
RE: internal date value
Thanks to all who replied with helpful comments, pointers, links etc... -Original Message- Sent: January 23, 2004 3:24 PM To: Multiple recipients of list ORACLE-L Harry This list is moving to freelists, but I'll assume you knew that. Actually the base value for the standard Oracle dates is Jan 1, 4712 BC. There is a Julian function that will return the number of days since the base. To return the Julian, select to_char(sysdate,'J') from dual; Also, Oracle9i has some new date types and you may find one that works better for your purposes: http://otn.oracle.com/products/oracle9i/daily/may02.html Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, January 23, 2004 11:40 AM To: Multiple recipients of list ORACLE-L Folks: From what I gather, Oracle stores dates as the number of elapsed days since Jan 1, 1968. When I query a column of type 'DATE', it returns me the default format, dd-mon-yy. I know I can use to_char(date_col,'MMDD') etc... to define many output formats. What can I do to get the raw internal value of the date? i.e. today is 13172. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 find the last execution time of a Procedure.
Thanks for your input, Naveen. But, It is hard to do that since everything is under Production Support Team control. Best Regards, Prasad Naveen, Nahata (IE10) To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: eywell.com Subject: RE: How to find the last execution time of a Procedure. Sent by: [EMAIL PROTECTED] com 01/23/2004 02:24 AM Please respond to ORACLE-L Not sure if that is what you want... and not sure if this will really work, just a quick thought... Invalidate the procedure, so next time it will be used, it will be recompiled, and then you can see at LAST_DDL_TIME in ALL_OBJECTS to find out when it was used first after invalidating. Regards Naveen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 1:54 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to find the last execution time of a Procedure. Thanks Raj. I have confidence on you and hope we will meet in next CTOUG meeting. Best Regards, Prasad 860 843 8377 Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Rajendra.Jamadagncc: [EMAIL PROTECTED] Subject: RE: How to find the last execution time of a Procedure. Sent by: [EMAIL PROTECTED] com 01/22/2004 01:59 PM Please respond to ORACLE-L But you better check with experts as my knowledge of x$ is feather-weight .. also there is a column on x$kglob called kglhdexc ... to me it seems the execution count (I feel like Mr. Monk already). so if execution count is 0 then you can say that it actually got executed. But if this doesn't work, in the next CTOUG meeting, I'll try to hide away from you. YMMV Raj -- -- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 1:24 PM To: Multiple recipients of list ORACLE-L Thanks for input Raj. I was also thinking on the same lines (Querying v$views periodically and store it in some metadata table) if there is no easier way to figure out from DBA_ views. As far as changing the production code, as you know, It has to go thru the dev/test databases first and then go thru the release process to implement into the production. It is painful process. I will use x$kglob instead of changing production code and all that release stuff. Thanks for your help, Raj. Best Regards, Prasad 860 843 8377
RE: winders email client.
Where can you get this firebird browser? Reginald W. Bailey IBM Global Services JPMC Account - DCI ETS Database Management Your Friendly Neighborhood DBA [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] er.utc.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: winders email client. m 01/23/2004 02:29 PM Please respond to ORACLE-L - -Original Message- - From: Ron Thomas [mailto:[EMAIL PROTECTED] - Sent: Friday, January 23, 2004 11:49 AM - To: Multiple recipients of list ORACLE-L - Subject: winders email client. - - - - have you tried firebird? firebird is a web browser without an email client. thunderbird is the email client and it doesn't gork MAPI. i use firebird for all my browsing.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Time is an illusion, lunchtime doubly so. - Douglas Adams -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: winders email client.
http://texturizer.net/firebird/ [EMAIL PROTECTED] wrote: Where can you get this firebird browser? Reginald W. Bailey IBM Global Services JPMC Account - DCI ETS Database Management Your Friendly Neighborhood DBA [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] er.utc.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: winders email client. m 01/23/2004 02:29 PM Please respond to ORACLE-L - -Original Message- - From: Ron Thomas [mailto:[EMAIL PROTECTED] - Sent: Friday, January 23, 2004 11:49 AM - To: Multiple recipients of list ORACLE-L - Subject: winders email client. - - - - have you tried firebird? firebird is a web browser without an email client. thunderbird is the email client and it doesn't gork MAPI. i use firebird for all my browsing.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Time is an illusion, lunchtime doubly so. - Douglas Adams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: winders email client.
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, January 23, 2004 3:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: winders email client. Where can you get this firebird browser? http://www.mozilla.org/ HTH Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Simpson, Ken INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: winders email client.
Yup. Answered this without drinking coffee first... Firebird, aka phoenix- one of the best browsers out there. I use it exclusively. Thunderbird- email client. I read IMAP not MAPI in your email. Slithering back to my hole... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The box said I needed to have windows 98 or better...So I installed linux. [EMAIL PROTECTED] ier.utc.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: winders email client. om 01/23/2004 01:29 PM Please respond to ORACLE-L - -Original Message- - From: Ron Thomas [mailto:[EMAIL PROTECTED] - Sent: Friday, January 23, 2004 11:49 AM - To: Multiple recipients of list ORACLE-L - Subject: winders email client. - - - - have you tried firebird? firebird is a web browser without an email client. thunderbird is the email client and it doesn't gork MAPI. i use firebird for all my browsing.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Time is an illusion, lunchtime doubly so. - Douglas Adams -- 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: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: winders email client.
[EMAIL PROTECTED] wrote: Where can you get this firebird browser? http://mozilla.org/ -- Bricklen Anderson PresiNET Systems http://www.PresiNET.com Live Demo: https://www.presinet.com/secure/login -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: winders email client.
email client- http://texturizer.net/thunderbird/ browser- http://texturizer.net/firebird/ Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The box said I needed to have windows 98 or better...So I installed linux. [EMAIL PROTECTED] pmorgan.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: winders email client. om 01/23/2004 01:59 PM Please respond to ORACLE-L Where can you get this firebird browser? Reginald W. Bailey IBM Global Services JPMC Account - DCI ETS Database Management Your Friendly Neighborhood DBA [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] er.utc.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: winders email client. m 01/23/2004 02:29 PM Please respond to ORACLE-L - -Original Message- - From: Ron Thomas [mailto:[EMAIL PROTECTED] - Sent: Friday, January 23, 2004 11:49 AM - To: Multiple recipients of list ORACLE-L - Subject: winders email client. - - - - have you tried firebird? firebird is a web browser without an email client. thunderbird is the email client and it doesn't gork MAPI. i use firebird for all my browsing.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Time is an illusion, lunchtime doubly so. - Douglas Adams -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ
RE: internal date value
Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 23, 2004 3:09 PM To: Multiple recipients of list ORACLE-L Thomas: I'm a SAS guy who must pull Oracle data from the back-end DB. SAS stores dates internally as elapsed days since Jan 1, 1960. If I request an Oracle date field, SAS creates a datetime variable, number of seconds since midnight Jan 1, 1960. Rather than use SAS functions to extract the date ( e.g. datepart function ), I'd like to push that back to Oracle if possible and create a simple date field on SAS. I can accomplish the desired effect with: select date_fld - to_date('01Jan1960','ddmon') as sas_date but I was hoping there was an Oracle function to surface the internal value ( appears to be days since Jan 1, 1968 ). Presumably such a function would be more efficient. Thanks for your help. -Original Message- Sent: January 23, 2004 2:50 PM To: Multiple recipients of list ORACLE-L Harry, Can you explain why you need to raw internal value? Just curious. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 23, 2004 1:40 PM To: Multiple recipients of list ORACLE-L You gather it wrong :) Oracle stores date in 8 bytes, one for each: year, month, day, hour, min, ... etc. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Droogendyk, Harry Sent: Friday, January 23, 2004 12:40 PM To: Multiple recipients of list ORACLE-L Folks: From what I gather, Oracle stores dates as the number of elapsed days since Jan 1, 1968. When I query a column of type 'DATE', it returns me the default format, dd-mon-yy. I know I can use to_char(date_col,'MMDD') etc... to define many output formats. What can I do to get the raw internal value of the date? i.e. today is 13172. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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
Re: Views for a table
The only privilege you can grant to yourself : GRANT RTFM TO user [WITH GRANT OPTION]; Igor Neyman wrote: Mladen, Any privileges required to view this table, or just common sense? :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Mladen Gogala Sent: Friday, January 23, 2004 1:24 PM To: Multiple recipients of list ORACLE-L The table you want to look into is USER_OTN, Column DOCUMENTATION. On 01/23/2004 12:49:34 PM, Mauricio V?lez wrote: Hi everybody I have the following question How can I query a table's views? For example I have the table students and I want to know the views related to this table. Thanks, Mauricio V?lez - Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: pga_aggregate_target and a memory leak
Hi, The bug I saw on the course was 3194895, but I am not able to see this one Myself with my account, maybe some internal use only, but take a look at Docs 3156574 or 2790318 this looks similar The teacher also mentioned a patch to lift the 1GB pga limit to 5Gb But I am not able to find this also. I will email him To ask for details. Anybody else experience with this or this patch? Regards, Jeroen -Oorspronkelijk bericht- Van: Arnold, Sandra [mailto:[EMAIL PROTECTED] Verzonden: vrijdag 23 januari 2004 3:19 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: Re: pga_aggregate_target and a memory leak I am interested in the bug number. Currently am having memory problems that may be related to the pga. Sandra -Original Message- Sent: Thursday, January 22, 2004 5:09 PM To: Multiple recipients of list ORACLE-L Yes I have and still have a problem with pga memory leak When using pl/sql tables. I'm on 9i performance and tuning course at oracle Now and discussed this with the teacher. He went looking and found a bug Stating that on 9i (9.2.0.2 and further) there seems to be a limit on total pga per process of 1Gb. Setting pat=0 and work_area_size manual gave me a workaround for my production problem but with a test of just a simple Got a decent explanation today that pat=0 gives me more memory for pl/sql Tables because there are always in pga and pat is about sort areas so setting pat=0 gives more memory and less possibility of not having enough. Pl/sql procedure assigning values to an array of number keeps reproducing A pl/sql storage error also with pat=0 and wasp=manual. I left the bug number in my notes, can get that tomorrow if somebody is interested. Jeroen -Oorspronkelijk bericht- Van: Ryan [mailto:[EMAIL PROTECTED] Verzonden: donderdag 22 januari 2004 11:05 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: Re: pga_aggregate_target and a memory leak Im not sure I see what the size of the PAT has to do with a memory leak. On metalink there is a laundry list of PGA things that were supposedly causing memory leaks prior to 9.2.0.4. Are you certain its PAT causing it? Maybe they didnt fix all the memory leaks with the PGA in general? has anyone had any production issues with pga memory leaks? There are a series of notes on metalink about this. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 11:04 PM --- Kirtikumar Deshpande [EMAIL PROTECTED] wrote: I think it depends on your applications. In DSS type environments we are still stuggling to figure out if P_A_T is helping or not. Initial tests are not in P_A_T's favor. But in another Application, that is 80% OLTP, P_A_T was the only choice to avoid swapping. This 9.2.0.3 database had the S_A_S set to 2MB (S_A_R_S = 1MB)at the instance level. It has over 600 persistent users. No MTS in use. - Kirti Kirti, I saw in a 9.2.0.4 database just this evening, much to my surprise, an ORA-00600 in the alert log with - you guessed it - [723], [10332], [10332], [memory leak]. The database was setup in a less than optimal fashion as far as memory allocations go. The initial pga_aggregate_target was only 64M (server had 3 GB of memory and only one instance up) so I'm calling this one a non-sensical configuration error for the moment, as there is no need to size a PGA so small. If you're running with that small a memory footprint, don't use pga_aggregate_target. After resetting the parameter to 256M and cycling the instance, no ORA-00600's were recorded at instance shutdown. That was not really a good test though, will have to see tomorrow evening after the day's load has hit it. Paul this was on w2k server sp3, 9.2.0.4 std ed From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2004/01/21 Wed PM 02:44:31 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: pga_aggregate_target and a memory leak Replies in line... - Kirti --- [EMAIL PROTECTED] wrote: Kirti, you're back! Thanks. Found some slack time from routine DBA work! Must have finished the book. :) Not yet.. Its tough.. Re the PGA problems, what was the value for 'over allocation count' in v$pgastat? Actually, I never bothered to look at v$pgastat. Should have.. and will, when we do some more testing next week.. Did you try increasing P_A_T to a larger number? Yes... Oracle is supposed to grab the memory it needs, if available, regardless of the P_A_T setting. Also, did your system go in to excessive paging or swapping? Yes, it did with a large P_A_T. I've been curious as to what the effects would be of having P_A_T too low. I saw more disk sorts.. As time permits, I will play with event 10032, 10033 trace for sorts to see
RE: internal date value
Harry, Look at the to_char function in Oracle. It will convert a date field to *any* format you want. for example: select to_char(date_field,'mm/dd/ hh24miss') will return a date in the format as noted. You have about as many options as you probably need. You can combine as many format and functions as you think you need. to_char translates dates to chars and to_date does the opposite - but both use the same format statements. This should work fine for you. And for you info - Oracle dates are stored internally based on a date going back many centuries - not just to 1968! Good Luck Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 23, 2004 3:09 PM To: Multiple recipients of list ORACLE-L Thomas: I'm a SAS guy who must pull Oracle data from the back-end DB. SAS stores dates internally as elapsed days since Jan 1, 1960. If I request an Oracle date field, SAS creates a datetime variable, number of seconds since midnight Jan 1, 1960. Rather than use SAS functions to extract the date ( e.g. datepart function ), I'd like to push that back to Oracle if possible and create a simple date field on SAS. I can accomplish the desired effect with: select date_fld - to_date('01Jan1960','ddmon') as sas_date but I was hoping there was an Oracle function to surface the internal value ( appears to be days since Jan 1, 1968 ). Presumably such a function would be more efficient. Thanks for your help. -Original Message- Sent: January 23, 2004 2:50 PM To: Multiple recipients of list ORACLE-L Harry, Can you explain why you need to raw internal value? Just curious. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 23, 2004 1:40 PM To: Multiple recipients of list ORACLE-L You gather it wrong :) Oracle stores date in 8 bytes, one for each: year, month, day, hour, min, ... etc. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Droogendyk, Harry Sent: Friday, January 23, 2004 12:40 PM To: Multiple recipients of list ORACLE-L Folks: From what I gather, Oracle stores dates as the number of elapsed days since Jan 1, 1968. When I query a column of type 'DATE', it returns me the default format, dd-mon-yy. I know I can use to_char(date_col,'MMDD') etc... to define many output formats. What can I do to get the raw internal value of the date? i.e. today is 13172. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 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: Jobs are not working
Title: Message Mauricio: Is job_queue_processes set to a value higher than 0? Did you commit after submitting the job? John R. Johnson Anheuser-Busch Companies Server Technology and DBA Services Oracle Database Administration -Original Message-From: Michael Fontana [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 1:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Jobs are not working Mauricio: Define the exact symptoms of your problem. For example: How are the jobs being submitted? Are you getting an error message upon submission? How do you know they're not running? Have you queries dba_jobs_running? Please respond with any diagnostic error messages, or any other documentation you wish to provide to give us more detail. Michael Fontana Sr. DBA NTT/Verio -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mauricio VXlezSent: Friday, January 23, 2004 11:04 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Jobs are not working I issued commit and job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file so I don't know why the jobs are not working regards, Mauricio Vélez [EMAIL PROTECTED] wrote: A COMMIT is required after "submitting" the job.job_queue_processes = 4 === Must be greater than zero in init_SID.orafileMauricio "Vélez" <[EMAIL PROTECTED] <[EMAIL PROTECTED] ORACLE-L list of recipients Multiple To:>hoo.com cc: Sent by: Subject: Jobs are not working [EMAIL PROTECTED] .com 01/23/2004 08:29 AM Please respond to ORACLE-L Hello everybody= "urn:schemas-microsoft-com:office:office" /I'm woriking on NT and there are two 8i databases on itOne database can execute jobs normally, but the other one not execute anyjob.I proved submitting the same procedure to both database and worked on thefirst one but not on the second one.How can I resolve this?Mauricio VélezDo you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it! Do you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it!
RE: Jobs are not working
Do you have 4 jobs currently running? Maybe you need more processes. John -Original Message-From: Mauricio "Vélez [mailto:[EMAIL PROTECTED]Sent: Friday, January 23, 2004 11:04 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Jobs are not working I issued commit and job_queue_processes = 4 job_queue_interval = 10 in init_SID.ora file so I don't know why the jobs are not working regards, Mauricio Vélez [EMAIL PROTECTED] wrote: A COMMIT is required after "submitting" the job.job_queue_processes = 4 === Must be greater than zero in init_SID.orafileMauricio "Vélez" <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>hoo.com cc: Sent by: Subject: Jobs are not working [EMAIL PROTECTED] .com 01/23/2004 08:29 AM Please respond to ORACLE-L Hello everybody= "urn:schemas-microsoft-com:office:office" /I'm woriking on NT and there are two 8i databases on itOne database can execute jobs normally, but the other one not execute anyjob.I proved submitting the same procedure to both database and worked on thefirst one but not on the second one.How can I resolve this?Mauricio VélezDo you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it! Do you Yahoo!?Yahoo! SiteBuilder - Free web site building tool. Try it!
Re: [Q] create tablespace with different block size error???
Comment in-line On 01/23/2004 11:29:25 AM, dba1 mcc wrote: I tried to create tablespace with 16K (default on my init.ora blocksize =8k). I have error happen. The database version is 9.2.0.4. SQL create tablespace index1 logging datafile '/u0/oradata/leg92/index1.dbf' size 20m 2 blocksize 16384 3 autoextend on 4 next 1280k 5 maxsize unlimited 6 extent management local 7 segment space management auto 8 uniform size 128k; autoextend on * ERROR at line 3: if I take out blocksize 16384, then it work fine. SQL create tablespace index1 logging datafile '/u0/oradata/leg92/index1.dbf' size 20m 2 reuse autoextend on 3 next 1280k 4 maxsize unlimited 5 extent management local 6 segment space management auto 7 uniform size 128k; Tablespace created. Does anyone know why?? Because autoextend is a datafile attribute, not a tablespace one. When you enter a tablespace attribute, like blocksize, oracle parser thinks that you're done describing your datafiles so it finds the autoextend clause out of context. -- 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: RE: pga_aggregate_target and a memory leak
i heard tom kyte speak in december. He said first quarter 2004 for solaris. most people seem to still be on 8i. We have both 8i and 9i instance here. It will probably be a year before many employers are using it anywy. From: Grabowy, Chris [EMAIL PROTECTED] Date: 2004/01/23 Fri PM 03:24:45 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: pga_aggregate_target and a memory leak Kirti, So is April 12th the latest date you heard for when 10g might be released?? Because it was the end of 2003, but I didn't know it had slipped all the way into April... -Original Message- Kirtikumar Deshpande Sent: Wednesday, January 21, 2004 7:24 PM To: Multiple recipients of list ORACLE-L Thanks, Ryan. Yes, it is on OWI, for those who are new to OWI. Covers OWI from 8i to 10g. Co-authored with Richmond Shee and K.Gopalakrishnan. It will not be out till 10g goes production. Unfortunately, April 12th is not firm. 10g changes Regards, - Kirti --- Ryan [EMAIL PROTECTED] wrote: Im assuming its his wait interface book. Ill get it as soon as it comes out. Hopefully it will be as good as his other tuning book. Is the April 12th date firm? Now the bigger question: Will it be out before the 10G database? http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/qid=1074724628/ sr=1 -2/ref=sr_1_2/104-1361632-8254324?v=glances=books - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 5:14 PM A comment I picked up from Tom Kyte's Masterclass in Copenhagen last week was that there is an effective limit of 1GB to P_A_T - and although a single session is supposed to be allowed 5% of the P_A_T, you could get about 90MB. So there are some funny things going on in that area which still need fixing. It's a bit tough for big systems, as I've found that the optimizer seems to be much smarter about memory user and access paths when P_A_T and W_S_P are set. What's the book about ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 7:44 PM Replies in line... - Kirti --- [EMAIL PROTECTED] wrote: Kirti, you're back! Thanks. Found some slack time from routine DBA work! Must have finished the book. :) Not yet.. Its tough.. Re the PGA problems, what was the value for 'over allocation count' in v$pgastat? Actually, I never bothered to look at v$pgastat. Should have.. and will, when we do some more testing next week.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande
RE: How to find the last execution time of a Procedure.
Raj, I am no X$ expert either, but X$KGLOB is exposed to us lowly DBAs as V$DB_OBJECT_CACHE and KGLHDEXC is actually the EXECUTIONS column. Prasada, you can check V$DB_OBJECT_CACHE for TYPE in ('PACKAGE','PACKAGE BODY') and KEPT = 'NO' and keep pinning these using DBMS_POOL.KEEP via a scheduled job. After a while, all those used packages will not only become KEPT (and provide some side benefit of reducing reloads), you will not have to store them back into the database... The KEPT = NO will avoid having to revisit/manipulate those objects that were previously pinned. Of course, this assumes that there is adeqauet Shared pool space and the Db is not restarted in-between :) YMMV! John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 11:00 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to find the last execution time of a Procedure. But you better check with experts as my knowledge of x$ is feather-weight ... also there is a column on x$kglob called kglhdexc ... to me it seems the execution count (I feel like Mr. Monk already). so if execution count is 0 then you can say that it actually got executed. But if this doesn't work, in the next CTOUG meeting, I'll try to hide away from you. YMMV Raj --- - Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 1:24 PM To: Multiple recipients of list ORACLE-L Thanks for input Raj. I was also thinking on the same lines (Querying v$views periodically and store it in some metadata table) if there is no easier way to figure out from DBA_ views. As far as changing the production code, as you know, It has to go thru the dev/test databases first and then go thru the release process to implement into the production. It is painful process. I will use x$kglob instead of changing production code and all that release stuff. Thanks for your help, Raj. Best Regards, Prasad 860 843 8377 *** *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *** ***4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: pga_aggregate_target and a memory leak
We still have an 8.1.5 database as well as two 8.1.7.4 and one 9.2.04 databases. We are planning on upgrading our 8i databases this year. The rate we are going it probably will be two years before we get to 10g. Sandra -Original Message- Sent: Friday, January 23, 2004 5:39 PM To: Multiple recipients of list ORACLE-L i heard tom kyte speak in december. He said first quarter 2004 for solaris. most people seem to still be on 8i. We have both 8i and 9i instance here. It will probably be a year before many employers are using it anywy. From: Grabowy, Chris [EMAIL PROTECTED] Date: 2004/01/23 Fri PM 03:24:45 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: pga_aggregate_target and a memory leak Kirti, So is April 12th the latest date you heard for when 10g might be released?? Because it was the end of 2003, but I didn't know it had slipped all the way into April... -Original Message- Kirtikumar Deshpande Sent: Wednesday, January 21, 2004 7:24 PM To: Multiple recipients of list ORACLE-L Thanks, Ryan. Yes, it is on OWI, for those who are new to OWI. Covers OWI from 8i to 10g. Co-authored with Richmond Shee and K.Gopalakrishnan. It will not be out till 10g goes production. Unfortunately, April 12th is not firm. 10g changes Regards, - Kirti --- Ryan [EMAIL PROTECTED] wrote: Im assuming its his wait interface book. Ill get it as soon as it comes out. Hopefully it will be as good as his other tuning book. Is the April 12th date firm? Now the bigger question: Will it be out before the 10G database? http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/qid=1074724628/ sr=1 -2/ref=sr_1_2/104-1361632-8254324?v=glances=books - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 5:14 PM A comment I picked up from Tom Kyte's Masterclass in Copenhagen last week was that there is an effective limit of 1GB to P_A_T - and although a single session is supposed to be allowed 5% of the P_A_T, you could get about 90MB. So there are some funny things going on in that area which still need fixing. It's a bit tough for big systems, as I've found that the optimizer seems to be much smarter about memory user and access paths when P_A_T and W_S_P are set. What's the book about ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 7:44 PM Replies in line... - Kirti --- [EMAIL PROTECTED] wrote: Kirti, you're back! Thanks. Found some slack time from routine DBA work! Must have finished the book. :) Not yet.. Its tough.. Re the PGA problems, what was the value for 'over allocation count' in v$pgastat? Actually, I never bothered to look at v$pgastat. Should have.. and will, when we do some more testing next week.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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
RE: How to find the last execution time of a Procedure.
Life is much easier, just use audit execute on proc name No need for the x$tables :) Regards, Waleed -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 11:19 AM To: Multiple recipients of list ORACLE-L Hi All, Is there anyway to find out from data dictionary views when was a database procedure/function last executed. Would like know the solution for 8i and 9i databases. We have some older code in the databases and do not know if any application is using it or not. I appreciate your help. Thanks Best Regards, Prasad * PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies. * -- 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: 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: RE: pga_aggregate_target and a memory leak
On 01/23/2004 07:54:25 PM, Arnold, Sandra wrote: We still have an 8.1.5 database as well as two 8.1.7.4 and one 9.2.04 databases. We are planning on upgrading our 8i databases this year. The rate we are going it probably will be two years before we get to 10g. Sandra That would be a very courageous thing to do. I'm not sure that 10g will be stable enough for a big production database in 2 years. Experience with 9i tells us that nothing before 9.2.0.4 was not fit for a real production use. If I remember correctly, 9i is out for more then 2 years now. Have in mind that 10g is the first version that was written almost entirely outside of the US. I wouldn't rush into upgrading to 10g, if I were you. And the rumor is that 10g is so unstable that even with the standards lowered so much, Oracle doesn't want to release like that. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: commit for triggers
Perhaps I got it wrong, but, John - are you saying that the entries are part of the rollback, i.e. if the transaction that caused the audit trail entries to be created is rolled back, the audit trail enries are rolled back as well? The auditing entry is NOT part of the transaction, it's created via an autonomous one and it stays in the audit trail table, regardless of what happens to the transaction. It will take a very simple test to prove this. Make sure that audit_trail is set to DB. create table atest1 (col1 number, col2 number, col3 number, col4 number); insert into atest1 values (1,1,1,1); audit update on atest1 by access; update atest1 set col1 = 2; Do NOT commit. From another session as user SYS, select action_name, obj_name, ses_actions, returncode from dba_audit_trail; ACTION_NAME OBJ_NAME SES_ACTIONS RETURNCODE --- --- --- --- UPDATE ATEST1 0 The entry is there even if the transaction is not committed. Now rollback the update and check the audit trail; it will be there. If the auditing option were BY SESSION, instead of action, the ACTION_NAME would have been SESSION REC and the column SES_ACTIONS would've been --S-. Hope this helps. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 23, 2004 3:24 PM John, I agree w/ everything you said, except for the autocommit functionality. Autocommit setting has no impact on whether DDL will commit or rollback any in progress transaction. DDL always commits an in-progress transaction. The short example below speaks for itself. (8.1.7.4 on Solaris 2.8) SQL show autocommit autocommit OFF SQL desc a Name Null?Type - COL1 NUMBER COL2 NUMBER SQL select * from a where col1=-12345; no rows selected SQL insert into a values(-12345,-12345); 1 row created. SQL create table xxx(a number); Table created. SQL select * from a where col1=-12345; COL1 COL2 -- -- -12345 -12345 1 row selected. Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Friday, January 23, 2004 12:10 PM To: Multiple recipients of list ORACLE-L A two-phase commit is simply a way to make sure that commits happen in a distributed transaction the same way that they do in a local transaction. The absolute rule is: Everything commits or Nothing does. In-between, with some parts committed and some not, is NOT tolerable. So in your transaction, the change to the audit log is NOT committed if any part of the transaction fails. Everything from the beginning of a transaction up to a commit or rollback command is part of the transaction. All DDL commands are transactions unto themselves, so they end the prior transaction (which is committed, if you have autocommit turned on, or rolled back otherwise) and the command following a DDL command starts a new transaction. Triggers execute within the same transaction as the command that triggered them, and may not include a commit or rollback. So any DML in a trigger is only committed if the entire transaction is committed. There is only one exception to this behavior. You can declare a stored procedure as an Autonomous Transaction, which means that you are starting a new transaction that is independant of the current transaction. This means that the new transaction can commit or rollback without affecting or being affected by the current transaction, and can fail without causing the current transaction to fail or succeed, even if the current transaction fails. This is very useful and powerful, but use it with caution, because you are no longer protected by the normal transaction safeguards. -Original Message- Sent: Friday, January 23, 2004 9:15 AM To: Multiple recipients of list ORACLE-L Hi All, I have a before update trigger for a local table. I know Oracle does not commit the inserting audit entry into the audit log table until the user commits the changes on the audited table. Can I assume Oracle issues one commit for both changes? When commit fails, both changes will be rolled back. However, Oracle uses two-phase commit if a trigger updates remote tables in a distributed database. What happens if Oracle commits the change in audit log table and my change subsequently fails? _ Learn how to choose, serve, and enjoy wine at Wine @ MSN.
RE: commit for triggers
Mark - Thanks for the correction. When I looked at what I said about the transaction before a DDL command a second time, I myself wondered if I'd gotten it right. If you've tested it, and the transaction is always committed, I'll take your word for it. Arup - I don't normally use Oracle's built-in auditing of DML, I write my own audits with triggers, and it works as I said. If you've tested this, I'll take your word for it. That said, if it DOES work the way you say, I personally think it works the wrong way. If I update a table, and then roll back the update, I don't want an audit table record of the update, unless it CLEARLY notes the fact that the update was rolled back. I'm much more interested in the fact that Jack changed the table, than in the fact that Manny started to change it, but then changed his mind. -Original Message- Sent: Friday, January 23, 2004 11:09 PM To: Multiple recipients of list ORACLE-L Perhaps I got it wrong, but, John - are you saying that the entries are part of the rollback, i.e. if the transaction that caused the audit trail entries to be created is rolled back, the audit trail enries are rolled back as well? The auditing entry is NOT part of the transaction, it's created via an autonomous one and it stays in the audit trail table, regardless of what happens to the transaction. It will take a very simple test to prove this. Make sure that audit_trail is set to DB. create table atest1 (col1 number, col2 number, col3 number, col4 number); insert into atest1 values (1,1,1,1); audit update on atest1 by access; update atest1 set col1 = 2; Do NOT commit. From another session as user SYS, select action_name, obj_name, ses_actions, returncode from dba_audit_trail; ACTION_NAME OBJ_NAME SES_ACTIONS RETURNCODE --- --- --- --- UPDATE ATEST1 0 The entry is there even if the transaction is not committed. Now rollback the update and check the audit trail; it will be there. If the auditing option were BY SESSION, instead of action, the ACTION_NAME would have been SESSION REC and the column SES_ACTIONS would've been --S-. Hope this helps. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 23, 2004 3:24 PM John, I agree w/ everything you said, except for the autocommit functionality. Autocommit setting has no impact on whether DDL will commit or rollback any in progress transaction. DDL always commits an in-progress transaction. The short example below speaks for itself. (8.1.7.4 on Solaris 2.8) SQL show autocommit autocommit OFF SQL desc a Name Null?Type - COL1 NUMBER COL2 NUMBER SQL select * from a where col1=-12345; no rows selected SQL insert into a values(-12345,-12345); 1 row created. SQL create table xxx(a number); Table created. SQL select * from a where col1=-12345; COL1 COL2 -- -- -12345 -12345 1 row selected. Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: is this possible ?
What are you trying to get? Column values or (TABLE,COLUMN) combination? You could probably use a function like this: create or replace function trickery(T varchar2,C varchar2, V number) return number deterministic as qry varchar2(2048); cnt number:=0; begin qry='select count(*) from '||T||' where '||C||'='||V; execute immediate qry into cnt; return(cnt); end; / The rest is simply using this function in a query against dba_tab_columns. On 01/23/2004 11:54:26 PM, Rohan Karanjawala wrote: i hv to write an sql query in which i hv to fetch all the tables frm the database having a column say EMPNO and where the value of this empno column is say 9 and this should be thru a single sql query is this possible ? Thanks and Regds, Rohan _ Contact brides grooms FREE! http://www.shaadi.com/ptnr.php?ptnr=hmltag Only on www.shaadi.com. Register now! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rohan Karanjawala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!
Looking at the source (list owner) I'd say it is. Jack -Original Message- Sent: Thursday, January 22, 2004 9:29 AM To: Multiple recipients of list ORACLE-L Is this a genuine mail...? I'm a part of the list. -Original Message- Sent: Thursday, January 22, 2004 1:56 PM To: [EMAIL PROTECTED] Dear Oracle-L subscriber, Due to changing circumstances, the Oracle-L mailing list has found a new home. Fatcity.com has graciously hosted Oracle-L for several years, and I thank Bruce Bergman for his hard work on our behalf, but the time has come to move to a new host. Oracle-L will be hosted by freelists.org, effective immediately. In the past when this list has moved, I used a list of subscribers to automatically subscribe people to the new address, thinking I was providing a service. To avoid dealing with irate users that forgot they had subscribed (where does their mail go?) and their attorneys (don't care to hear from them again ) this new list will be 100% opt in. What this means is that you will need to subscribe to the new address if you wish to remain on the Oracle-L mailing list. This email is being sent to you once individually, and will also appear in the regular Oracle-L traffic. After a period of time (2 weeks or so) [EMAIL PROTECTED] will be shut down. At this time, I don't know for how long the Oracle-L archives at fatcity.com will be available. Instruction for subscribing to the new list are at the end of the message. I look forward to seeing you all at [EMAIL PROTECTED] Jared Still -- to subscribe: send email to [EMAIL PROTECTED] with 'subscribe' in the Subject field OR Subscribe via the web site - http://www.freelists.org/login.html To send email to the list, use this address: [EMAIL PROTECTED] You can unsubscribe from [EMAIL PROTECTED] by: send email to [EMAIL PROTECTED] with 'unsubscribe' in the Subject field OR Unsubscribe via the web site - http://www.freelists.org/login.html Documentation - http://www.freelists.org/help/ Searchable archives - http://www.freelists.org/archives/oracle-l Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Venu Gopal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unusable partition index -- working funny
I would check which index is being reported as unusable, and check the access path for the query when all indexes are useable. Since you have a statement level trigger, I suspect Oracle is producing an execution plan that dictate the use of index X. The plan executes, which means the trigger fires, but the execution engine is committed to using index X - which happens to be unusable, so the statement fails. On the second call, the session parameters have changed, so Oracle re-parses the update, and ignores the unusable index, choosing a different plan. Consequently the update can work. In the case where the index being used to access the data is useable (i.e. where only the index on the updated column is unusable), I would assume that Oracle makes the decision about updating indexes only after columns have been updated, therefore it can notice the effect of session switch in mid-statement. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 12:19 AM Thanks for your reply Jonathan..Here is an update.. The update that i sent you yesterday is updating a column on which there is a local bitmap index. There are also other local bitmsap indexes on that partitions. Yesterday i made all the local indexes pertaining to that partition UNUSABLE and we got the results that i posted yesterday..Today i went and made all the indexes usable and then made only the local index on the column which we are updating unusable while the rest of the local bitmap indexes were usable. and then the update stmt was run. There was NO problem at all. It ran the first time without giving the error of index being in the unusable state. That nmeans the trigger has fired. So what would be the explanation in this case. If i make only that local bitmap index unusable, it works ok but if i make all the local bitmap indexes unusable in that partition, we get the situation that i posted yesterday.. Thanks, Sathish. SQL connect [EMAIL PROTECTED] Enter password: ** Connected. SQL UPDATE nevadmin.DM_MORTGAGE_LOAN_HIST SET ORIGINATION_SOURCE_KEY = 1 where 2 mortgage_loan_key = 1 and period_key = '30-JUN-03'; UPDATE nevadmin.DM_MORTGAGE_LOAN_HIST SET ORIGINATION_SOURCE_KEY = 1166444 where * ERROR at line 1: ORA-01502: index 'NEVADMIN.DM_MORTGAGE_LOAN_HIST_BK13' or partition of such index is in unusable state SQL / 1 row updated. - On Wed, 21 Jan 2004 00:24:25 -0800, Jonathan Lewis [EMAIL PROTECTED] said: It's probably the case that the trigger fires the first time - but at parse/optimise time Oracle had already determined the sequence of actions needed to execute the statement based on the then session state, so that sequence is played out, irrespective of the fact that you changed the session state in the middle of the sequence. By analogy, consider an update to an updatable join view which defaults to using a hash join. If you create a before row update trigger to disable hash joins, would you expect Oracle to not do a hash join the first time the statement executes ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 12:19 AM Hello All, I have a strange problem... I have a table on which i am doing an update. Its a partition table and the local index on the column which is being updated is in an unusable state. I have a database trigger at statement level (before update of col_a for ) where i do an execute immediate ' alter session set skip_unusable_indexes = true
Re: fast commit
Note in-line Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 6:29 AM Hi list, 1)Why fast commit generate no redo ? It's called a fast commit BECAUSE it doesn't generate redo (except for a tiny bit that describes the change to the transaction table entry in the segment header block that marked the transaction as active). It doesn't need to generate redo because it's going to leave (most of) the lock and change information on the blocks that have been changed, and let some other visiter to the blocks clean up the mess. 2)Is delayed cleanout generate redo? Delayed block cleanout - where a later operation simply READS a messy block and cleans it up (by referring back to the transaction table to get the necessary commit details) will generate redo. Delayed-logging block cleanout - which occurs when the first transactions cleans out a few of the blocks it has dirtied but does not log the cleanout - is effectively not going to generate redo, as the next transaction to MODIFY the date will generate some undo which looks as if it started from a clean block, rather than the partly dirty block that is really there - so the cleanout is effectively free. 3)In a block dump even after transactions commit why it shows lock 1 in ITL? Because Oracle doesn't clean the block out properly, it will either not revisit it at all (1), or just revisit the ITL and a couple of header bytes (2). Thanks in advance. Syed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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: pga_aggregate_target and a memory leak
Im not sure I see what the size of the PAT has to do with a memory leak. On metalink there is a laundry list of PGA things that were supposedly causing memory leaks prior to 9.2.0.4. Are you certain its PAT causing it? Maybe they didnt fix all the memory leaks with the PGA in general? has anyone had any production issues with pga memory leaks? There are a series of notes on metalink about this. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 11:04 PM --- Kirtikumar Deshpande [EMAIL PROTECTED] wrote: I think it depends on your applications. In DSS type environments we are still stuggling to figure out if P_A_T is helping or not. Initial tests are not in P_A_T's favor. But in another Application, that is 80% OLTP, P_A_T was the only choice to avoid swapping. This 9.2.0.3 database had the S_A_S set to 2MB (S_A_R_S = 1MB)at the instance level. It has over 600 persistent users. No MTS in use. - Kirti Kirti, I saw in a 9.2.0.4 database just this evening, much to my surprise, an ORA-00600 in the alert log with - you guessed it - [723], [10332], [10332], [memory leak]. The database was setup in a less than optimal fashion as far as memory allocations go. The initial pga_aggregate_target was only 64M (server had 3 GB of memory and only one instance up) so I'm calling this one a non-sensical configuration error for the moment, as there is no need to size a PGA so small. If you're running with that small a memory footprint, don't use pga_aggregate_target. After resetting the parameter to 256M and cycling the instance, no ORA-00600's were recorded at instance shutdown. That was not really a good test though, will have to see tomorrow evening after the day's load has hit it. Paul this was on w2k server sp3, 9.2.0.4 std ed From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2004/01/21 Wed PM 02:44:31 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: pga_aggregate_target and a memory leak Replies in line... - Kirti --- [EMAIL PROTECTED] wrote: Kirti, you're back! Thanks. Found some slack time from routine DBA work! Must have finished the book. :) Not yet.. Its tough.. Re the PGA problems, what was the value for 'over allocation count' in v$pgastat? Actually, I never bothered to look at v$pgastat. Should have.. and will, when we do some more testing next week.. Did you try increasing P_A_T to a larger number? Yes... Oracle is supposed to grab the memory it needs, if available, regardless of the P_A_T setting. Also, did your system go in to excessive paging or swapping? Yes, it did with a large P_A_T. I've been curious as to what the effects would be of having P_A_T too low. I saw more disk sorts.. As time permits, I will play with event 10032, 10033 trace for sorts to see what's going on.. Oracle is supposed to grab whatever memory it needs. I'm assuming at this point that doing so involves a different code path as it needs to alloc the memory. Don't know what the cost of that is, haven't tried to test it. It seems likely that the OS was out of memory, regardless of the P_A_T value. No. The system has 4 GB of physical memory. Over 2GB was free. Jared Kirtikumar Deshpande [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/21/2004 06:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: pga_aggregate_target and a memory leak Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 4.3.3 and 9.2.0.4 caused ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) were all set to 'unlimited'. In a very limited testing, setting P_A_T to less than S_A_S (and S_A_R_S) worked, however, the disk sorts increased. Finally, Developers chose no hash joins, 1GB P_A_T and 'AUTO' workarea_size_policy... seems to run okay... - Kirti --- Stephane Faroult [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 instance due to a possible memory leak. The only note on memory leaks and pga_aggregate_target I can find on metalink is: 334427.995 doesnt seem to apply to pga_aggregate_target. We are on sun solaris. Dont know version offhand. he is under the impression that if we patch to 9.2.0.4 this goes away. not sure about that either... Be careful
Re: Oracle 8.1.7 can only use the first 15th indexes?
Notes in-line Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - From: Kaing, Leng [EMAIL PROTECTED] Brilliant example. Thanks very much for this. (And yes, I meant the first 15th for each index, not the first 15th for the entire database!) I had to ask, as once upon a time people used to say that Oracle was limited to using a maximum of 5 indexes in any one query. (Misunderstanding the manuals comments about the maximum number of indexes that could be used in the AND-EQUAL path of a single table, I believe). And yes, I do think that 15 indexes is a bit excessive but I can't help it at the moment (3rd party, packaged application...) It's not necessarily wrong - just something to be suspicious of when you start from cold at a site. Does this mean that I'm reading another myth? Couldn't confirm it on metalink. I've never seen anything like it claimed before. Maybe it's something to do with the fact that the manuals list 15 rankings in the RBO ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ixora off-line, moved?
I also tried this morning a few times and it was down. -Original Message- Sent: Thursday, January 22, 2004 12:04 PM To: Multiple recipients of list ORACLE-L ixora.com.au seems to be unavailable. Any clue? Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Suhen Pather (S) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!
Yes indeed It is.. :) -Original Message- Venu Gopal Sent: Thursday, January 22, 2004 1:59 PM To: Multiple recipients of list ORACLE-L Is this a genuine mail...? I'm a part of the list. -Original Message- Sent: Thursday, January 22, 2004 1:56 PM To: [EMAIL PROTECTED] Dear Oracle-L subscriber, Due to changing circumstances, the Oracle-L mailing list has found a new home. Fatcity.com has graciously hosted Oracle-L for several years, and I thank Bruce Bergman for his hard work on our behalf, but the time has come to move to a new host. Oracle-L will be hosted by freelists.org, effective immediately. In the past when this list has moved, I used a list of subscribers to automatically subscribe people to the new address, thinking I was providing a service. To avoid dealing with irate users that forgot they had subscribed (where does their mail go?) and their attorneys (don't care to hear from them again ) this new list will be 100% opt in. What this means is that you will need to subscribe to the new address if you wish to remain on the Oracle-L mailing list. This email is being sent to you once individually, and will also appear in the regular Oracle-L traffic. After a period of time (2 weeks or so) [EMAIL PROTECTED] will be shut down. At this time, I don't know for how long the Oracle-L archives at fatcity.com will be available. Instruction for subscribing to the new list are at the end of the message. I look forward to seeing you all at [EMAIL PROTECTED] Jared Still -- to subscribe: send email to [EMAIL PROTECTED] with 'subscribe' in the Subject field OR Subscribe via the web site - http://www.freelists.org/login.html To send email to the list, use this address: [EMAIL PROTECTED] You can unsubscribe from [EMAIL PROTECTED] by: send email to [EMAIL PROTECTED] with 'unsubscribe' in the Subject field OR Unsubscribe via the web site - http://www.freelists.org/login.html Documentation - http://www.freelists.org/help/ Searchable archives - http://www.freelists.org/archives/oracle-l Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Venu Gopal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: fast commit
Thank You Jonathan. Syed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 1:29 PM Note in-line Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 22, 2004 6:29 AM Hi list, 1)Why fast commit generate no redo ? It's called a fast commit BECAUSE it doesn't generate redo (except for a tiny bit that describes the change to the transaction table entry in the segment header block that marked the transaction as active). It doesn't need to generate redo because it's going to leave (most of) the lock and change information on the blocks that have been changed, and let some other visiter to the blocks clean up the mess. 2)Is delayed cleanout generate redo? Delayed block cleanout - where a later operation simply READS a messy block and cleans it up (by referring back to the transaction table to get the necessary commit details) will generate redo. Delayed-logging block cleanout - which occurs when the first transactions cleans out a few of the blocks it has dirtied but does not log the cleanout - is effectively not going to generate redo, as the next transaction to MODIFY the date will generate some undo which looks as if it started from a clean block, rather than the partly dirty block that is really there - so the cleanout is effectively free. 3)In a block dump even after transactions commit why it shows lock 1 in ITL? Because Oracle doesn't clean the block out properly, it will either not revisit it at all (1), or just revisit the ITL and a couple of header bytes (2). Thanks in advance. Syed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Sultan Syed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Has anyone done any scalability work on dbms_lock?
Just remember these words about global contexts ... 'doesn't work correctly in RAC' ... A global context is global only within instance ... not across. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, January 21, 2004 6:54 PM To: Multiple recipients of list ORACLE-L Jonathan Lewis [EMAIL PROTECTED] wrote: Sounds like you just need each user to call allocate_unique on startup to get a group-specific handle, then do a request in exclusive mode before doing the job and a release on completion. Users will then naturally queue and resume with minimum lost time. Yes. We have a stored package with a few global constants and some setup functions that gets called on startup of any forms session. That's where we plan to do the startup work. When needed the forms will then do request/release. You could probably do the thing just as easily by issuing a select for update against a group-id row in a table - but dbms_lock makes it easier because it can bypass the normal commit activity. That is the problem with Forms. It's not always easy to streamline where a commit is gonna be done or not. In fact, the user can initiate the commit or rollback at any stage. So, we needed something a little bit more flexible than the select for update. The dbms_lock was the best I could remember at the time. But I like the global context idea. Will look into that. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Pinto do Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** 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: Trigger question
Enable auditing on COMPANY? Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === Hallo everyone, I have the table system_change and I I have the insert statement here below be run when there is an update or insert of a value in any ofthe fields ORGANIZATION_NUMBER LEGAL_NAME COMPANY_FORM_ID ORDER_STOP in table COMPANY insert into system_change values(system_change_id.nextval, 1, null,null, null, null, null, 1, SYSDATE, 1, SYSDATE,1 ) How can I write the code in the easiest way? Thanks in advance Roland -- 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: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: pga_aggregate_target and a memory leak
Paul, Most of my work is on HP-UX and AIX. I have yet to see any ORA-600 and memory leaks related to P_A_T. All databases that I work with are on 9.2.0.4, except just one running on 9.2.0.3. No memory leak there either. - Kirti --- Paul Drake [EMAIL PROTECTED] wrote: --- Kirtikumar Deshpande [EMAIL PROTECTED] wrote: I think it depends on your applications. In DSS type environments we are still stuggling to figure out if P_A_T is helping or not. Initial tests are not in P_A_T's favor. But in another Application, that is 80% OLTP, P_A_T was the only choice to avoid swapping. This 9.2.0.3 database had the S_A_S set to 2MB (S_A_R_S = 1MB)at the instance level. It has over 600 persistent users. No MTS in use. - Kirti Kirti, I saw in a 9.2.0.4 database just this evening, much to my surprise, an ORA-00600 in the alert log with - you guessed it - [723], [10332], [10332], [memory leak]. The database was setup in a less than optimal fashion as far as memory allocations go. The initial pga_aggregate_target was only 64M (server had 3 GB of memory and only one instance up) so I'm calling this one a non-sensical configuration error for the moment, as there is no need to size a PGA so small. If you're running with that small a memory footprint, don't use pga_aggregate_target. After resetting the parameter to 256M and cycling the instance, no ORA-00600's were recorded at instance shutdown. That was not really a good test though, will have to see tomorrow evening after the day's load has hit it. Paul this was on w2k server sp3, 9.2.0.4 std ed __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Healty ratio of index segment size vs table segment size?
Branimir Beware of simple ratios. The logic is seductive. It seems likely that an easy way to find unnecessary indexes is to look at a ratio such as you describe. And it shouldn't pose much load on a system to do a quick report on ratio. But what would it mean in practice? Just go around dropping indexes on tables that exceed their quota? I haven't used the index monitoring feature, and a cautious DBA always makes a small test before widespread deployment, but from what I've been told, the monitoring feature is pretty low overhead. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 21, 2004 9:39 AM To: Multiple recipients of list ORACLE-L Wondering if there is a rule of thumb, quick'n fast but good enough to be used as an indicator, litmus paper so to speak, of overly indexed table(s)... Can, better yet - should, sheer size comparison of index versus table segments be used as a reliable pointer to problematic table indexing? If it can, what could be considered as average healthy ratio above which would be prudent to have a closer look and investigate? Related to the above dilemma, how expensive is to monitor index usage, say if script is run against all few hundred indexes on app tables, would the additional load noticeably affect application performance or is it better/safer or may be required to monitor not more than just a few most suspected indexes at a time? Thoughts, pointers, opinions - appreciated. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Old thread - trace file location
Thanks Alexander. I wasn't aware of this new feature. It will certainly make my script much simpler. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 3:49 PM To: Multiple recipients of list ORACLE-L For 9.2 users: Alter database backup controlfile to trase as '/disk1/backup/ccf.sql' reuse noresetlogs; Alex. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, January 21, 2004 12:24 PM To: Multiple recipients of list ORACLE-L Okay, I was hallucinating -- and it is only Wednesday! I had been looking through some old emails yesterday. The thread was on September 17 18, 2002. If you are interested, go to Google and enter Oracle-l backup controlfile to trace. Elegant solutions were posted by Waleed Khedr, Richard Markham, and Ron Thomas. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 21, 2004 11:19 AM To: Multiple recipients of list ORACLE-L Unless I am hallucinating (always a distinct possibility), there was a recent discussion on this list about the trace file location when you perform an ALTER DATABASE BACKUP CONTROLFILE TO TRACE, with some ingenious solutions. I didn't think I'd need this, so deleted the postings. Well, guess what I need that. Could someone who saved some of these forward me the date and subject? Do it privately to avoid clogging the bandwidth. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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 http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Trigger question
The easiest way to write code for me is to use a text editor and sqlplus, always works for me. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, January 22, 2004 9:24 AM To: Multiple recipients of list ORACLE-L Hallo, I have the table system_change and I I have the insert statement here below be run when there is an update or insert of any of the fields ORGANIZATION_NUMBER LEGAL_NAME COMPANY_FORM_ID ORDER_STOP in table COMPANY The script bo be run is this one: insert into system_change values(system_change_id.nextval, 1, null,null, null, null, null, 1, SYSDATE, 1, SYSDATE,1 ) How can I write the code in the easiest way? All help is appreciated! Roland -- 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: RE: Healty ratio of index segment size vs table segment size?
comments in line... I may need correction from some of you on this. -Original Message- Sent: Wednesday, January 21, 2004 9:39 AM To: Multiple recipients of list ORACLE-L Wondering if there is a rule of thumb, quick'n fast but good enough to be used as an indicator, litmus paper so to speak, of overly indexed table(s)... the only rule of thumb I have seen is the script on Steve Adams site at www.ixora.com.au that finds unnecessary indexes. The site appears to be down, so you can try google and the cache feature. Can, better yet - should, sheer size comparison of index versus table segments be used as a reliable pointer to problematic table indexing? No. some people would argue that the size of an index is an indicator of needing a rebuild, but many of the big time tuners say this is not true, so I take their advice. Disk space is cheap. If it can, what could be considered as average healthy ratio above which would be prudent to have a closer look and investigate? no,no,no... I hate ratios. Related to the above dilemma, how expensive is to monitor index usage, say if script is run against all few hundred indexes on app tables, would the additional load noticeably affect application performance or is it better/safer or may be required to monitor not more than just a few most suspected indexes at a time? do all monitoring during off peak hours. Can you run it over the weekend? Benchmark it. You can do alot of good monitoring during off peak hours. I run all kinds of high load stuff on the weekends. You may want to run Steven Adams script once a month or so. Do it from a batch job and send yourself an email if something comes up. Thoughts, pointers, opinions - appreciated. Branimir The key to a good index screen is database design and understanding the goal of your system. What are you users trying to do most frequently? What is most critical to the system? Design towards that. Can you make a small change to your data model so that you do not really need to add an extra index and what is the impact of it? (pros and cons to everything). The big question is are your indexes affecting performance of your DML statements? do you foresee any possible problems in the future? Could someone correct me here. Im willing to bet Im half right.. though not sure which half. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: [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).