RE: Sql Tuning Thoughts?
Hi Tracy, A few observations 1. Can we use a more selective where clause?( Currently we are going for a PK Range Scan. Can we change the where clause to go for a PK Uniq scan?) 2. The Fetch time is very high.I guessthe fetch is a single row fetch. We can tune the code for bulk fetch by fetching say 1000 to 5000 rows at a time? Best Regards Sriram Kumar From: Tracy Rahmlow [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 10:54 PMTo: Multiple recipients of list ORACLE-LSubject: 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 elapseddisk query currentrows --- -- -- -- -- -- -- Parse 1 0.000.01 0 0 0 0 Execute 43814 1.95 1.57 0 0 0 0 Fetch 43814 55.88 599.11 408248 568098 043814 --- -- -- -- -- -- -- 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: CHOOSE0 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 followingannotations 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."**==DISCLAIMER:This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.
Re: What to look for in STATSPACK report
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).
RE: How to find the last execution time of a Procedure.
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 ** 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:
RE: !!Please Read - Oracle-L is moving!!
Title: Message 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. David LordSenior DBAIron Mountain (UK) Ltd -Original Message-From: Johnston, Tim [mailto:[EMAIL PROTECTED] Sent: 22 January 2004 20:19To: Multiple recipients of list ORACLE-LSubject: RE: !!Please Read - Oracle-L is moving!! I was trying to sign up this morning... The response was fast but I keep getting booted on the final confirmation email... The message I get is... Invalid number of parameters. Not sure why... Figured I'd wait and see if anyone else is having the same problem... Anyone else experience this? FYI... I've triedreplying to the email...Copying the message text and sending a new email... And, even when you sign up through the web site, you still need to perform a final confirmation via email... Argh! I'm guessing it may be Outlook since I'm using a beta version of Outlook 2003... Tim From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 2:39 PMTo: Multiple recipients of list ORACLE-LSubject: Re: !!Please Read - Oracle-L is moving!! Well, I did check with them first to ensure the volume would be OK. It is running a bit slow. I'm not sure if it is just freelists.org, or a general internet slowdown. Sending mail from work to home it seems that it is taking much too long. Jared "Ron Thomas" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004 10:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: !!Please Read - Oracle-L is moving!!The list members must be really hammering their servers now. I've tried to sign up using both theweb and email methods and have yet to receive a conformation/response.I can see the headlines now, "oracle-l slashdots freelists.org";-)Ron ThomasHypercom, Inc[EMAIL PROTECTED]"The box said I needed to have windows 98 or better...So I installed linux." [EMAIL PROTECTED] m To:[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: !!Please Read - Oracle-L is moving!! .com 01/21/2004 11:49 PM Please respond to ORACLE-L Dear Oracle-L subscriber,Due to changing circumstances, the Oracle-L mailing list hasfound a new home.Fatcity.com has graciously hosted Oracle-L for several years, and Ithank Bruce Bergman for his hard work on our behalf, but the time hascome 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 toautomatically subscribe people to the new address, thinking I wasproviding a service. To avoid dealing with irate users that forgot theyhad subscribed (where does their mail go?) and their attorneys (don'tcare 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 ifyou wish to remain on the Oracle-L mailing list.This email is being sent to you once individually, and will also appearin the regular Oracle-L traffic.After a period of time (2 weeks or so) [EMAIL PROTECTED] willbe shut down.At this time, I
RE: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!
A BIG thanks to Jared Bruce for all your efforts guys. And as bruce says See you in a minute on the new list. Thank you, Venu! -Original Message- Bruce A. Bergman Sent: Thursday, January 22, 2004 9:44 PM To: Multiple recipients of list ORACLE-L Yes, this is legitimate. Jared and I have been talking recently about this. This list has just outgrown what Fat City can handle. While I'd like to think that I've always provided adequate-to-good service for the list, it's never been great, and with the list growing, and traffic growing, my concern is that I just won't be able to continue to give the list good service. It makes me sick to think that, because I really have enjoyed giving back to the Oracle-L community, and because y'all have supported ME so well in the past, but I just don't want to see anything deteriorate simply because the volume exceeds what we can handle here. The list archives here will be available as long as Fat City continues to be in existence, so those of you who are searching for old topics are quite welcome to use the facilities here. It won't be going away. Jared has always been an awesome list owner, and I know he'll continue to make sure the list is successful. This move is just an indication of the relevancy and successful growth of the Oracle-L list, and I know it will continue. I wish you all the best in your new home, and I'll see you over there in a minute. :-) thanks, bruce bergman ListMaster, Fat City Hosting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 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).
Trigger, how?
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).
RE: Trace output
Title: RE: Trace output Satheesh, Row source operation is the run time execution plan. The execution plan is added when you run tkprof and you use parameter explain=user/password Connect to ORACLE and issue EXPLAIN PLAN and this is theoretical plan. In version 9.2 those two plans can differ. The reason for that is how CBO deals with bind variables in explain plan and when statement is optimized for real execution. For explain plan you don't need to supply any values for bind variables. But when CBO prepares the runtime execution plan (here comes the quote from Database Performance Tuning Guide and Reference 9.2) quote it peeks at the values of user-defined bind variables on the first invocation of a cursor. This feature lets the optimizer determine the selectivity of any WHERE clause condition, as well as if literals have been used instead of bind variables. On subsequent invocations of the cursor, no peeking takes place, and the cursor is shared, based on the standard cursor-sharing criteria, even if subsequent invocations use different bind values. /quote So in Row source operation you see the actual plan while in explain plan you see only theoretical plan that doesn't take into account the values for bind variables. That's the reason why those two plans can differ. There are many cases when this can cause problems because the existing plan is not optimal for subsequent execution. Regards, Joze -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, January 23, 2004 5:59 AM To: Multiple recipients of list ORACLE-L Subject: Trace output Hi, I am generating the trace using the event 10046, level 12. In the trace file I am seeing Row source operation following by execution plan. What is the different between these 2, as I am seeing diffent execution plan for both of them? Thanks and Regards, Satheesh Babu.S DISCLAIMER: This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -- 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).
OT: Solaris: Finding the cause for disk space growth
Title: Message 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: 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).
are the 9.2.0.3 memory leaks critical?
There are a series of metalink notes detailing memory leaks with the PGA in 9203. Has anyone had critical problems? Oracle recommends patching to 9204 to fix this, but it just came out and we prefer to be conservative with our patches. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 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).
commit for triggers
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).
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 from any virus, but advise the recipient to ensure they are
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 only and may be confidential. If they have come to
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 communications medium. We advise that you understand
Jobs are not working
Hello everybody Im woriking on NT and there are two 8i databases on it One database can execute jobs normally, but the other one not execute any job. I proved submitting the same procedure to both database and worked on the first one but not on the second one. How can I resolve this? Mauricio Vélez Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!
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
[Q] create tablespace with different block size error???
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).
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 wish to select a more secure alternate means of
winders email client.
have you tried firebird? 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: !!Please Read - Oracle-L is moving!! om 01/23/2004 07:09 AM Please respond to ORACLE-L -Original Message- Sent: Friday, January 23, 2004 9:00 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' 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 that, sir, is an understatement.;-) just wish i could fine an email client that would deal with MAPI other than Outlook. here at work we don't have IMAP enabled so i don't seem to have much choice.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents. - Nathaniel Borenstein -- 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: !!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 communications medium. If you are requesting
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 PROTECTED] (note EXACT spelling of
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
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: [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 that
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 any data that may be so transmitted. Transmission of
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 between the parties and any data that may be so
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).
rman expired vs obsolete
Hi, I'm getting a little confused between expired backups and obsolete backups. As I understand it, expired means the backups are no longer on disk. Obsolete means the backup is too old(?). Since I have a data ware house, I only have room on disk for 1 backup. Prior to running my weekly backup, do I issue a Delete Expired or Delete Obsolete, to remove last weeks backup that is currently on disk. Thanks Randy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steiner, Randy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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
pl/sql tables in pga and ora-4030 was pga_aggregate_target and a
I contined testing with pl/sql testprogram and found some interesting prove about this 1 gb limit for pga with pat set. All tests are done on hpux11.11 9.2.0.4 Testprogram create or replace procedure testarray( psize number ) as begin declare TYPE nAllotment_tabtypIS TABLE OF number INDEX BY BINARY_INTEGER; assarray nAllotment_tabtyp; assarray2 nAllotment_tabtyp; assarray3 nAllotment_tabtyp; uitleg varchar2(100); begin uitleg := 'start loop'; for i in 1..psize loop uitleg := 'insert i= ' || i; assarray(i) := i; /* uitleg := 'insert i2= ' || i; assarray2(i) := i; */ end loop; /* EXCEPTION WHEN OTHERS THEN dbms_output.enable(2); dbms_output.put_line(' Exception raised ' || uitleg ); */ end; end; Quotes from my last update to the tar: When setting all manual I see the pga going over 2Gb and the showing negative numbers by looking at v$sessstat, os-level I only have top and like I mentioneed earlier you see that going up 2 Gb also and further to 4Gb not above this limit as expected!! Notice I am now testing with a hpux setting datasegment 4Gb (ulimit 4194303) Test 1: workarea_size_policy=manual pat=0 After a few minutes running NAME VALUE -- session uga memory 81312 session uga memory max 112960 session pga memory 2132275152 session pga memory max 2132275152 Still monitoring this, the amount seem to stuck after 15 minutes or so at this 4Gb (value of top) end value: NAME VALUE -- session uga memory 81312 session uga memory max 112960 session pga memory -154903592 session pga memory max -154903592 After more then 30 minutes finally it crashes agaIN VU_2exec testarray( 1 ); begin testarray( 1 ); end; * ERROR at line 1: ORA-06500: PL/SQL: storage error ORA-06512: at VRIJ_UIT.TESTARRAY, line 14 ORA-06512: at line 1 U_2select pool, sum(bytes) from v$sgastat group by pool; POOL SUM(BYTES) --- -- large pool 218103808 shared pool 570425344 68143904 AME TYPE VALUE --- -- pga_aggregate_target big integer 0 23:32:33 SQL show parameter workarea It seems impossible that such a simple pl/sql can eat up 4Gb of memory. Other bugs like 3194895 and docid 3156574 are suggesting a 1Gb pga limit (which might be raised by changing data segment). There is mentioned a patch also according to 3194895 to lift this, can you find this patch and see if it might be Text continued in next action... 23-JAN-04 22:40:10 Text continued from previous action... appropriate? Output from top Memory: 3733508K (3051156K) real, 5720660K (4872688K) virtual, 70976K free Page# 1/14 CPU TTY PID USERNAME PRI NI SIZE RES STATE TIME %WCPU %CPU COMMAND 0 ? 23640 oracle 128 20 4116M 2436M sleep 10:00 2.54 2.53 oracleVU_2 New info : Test 2: workarea_size_policy=auto pat=200M same shared_pool of 500m I am utterly convinced this is all done in pga outside shared pool so enlarging this only gets me the same problem sooner Ahh and now after already 2.5 minutes I get a similar problem at the 1Gb limit U_2exec testarray( 1 ); begin testarray( 1 ); end; * ERROR at line 1: ORA-06500: PL/SQL: storage error ORA-06512: at VRIJ_UIT.TESTARRAY, line 14 ORA-06512: at line 1 Elapsed: 00:02:32.62 23:42:57 SQL / NAME VALUE -- session uga memory 78464 session uga memory max 143872 session pga memory 1071096624 session pga memory max 1071096624 23:44:17 SQL / NAME VALUE -- session uga memory 78464 session uga memory max 143872 session pga memory 1071096624 session pga memory max 1071096624 23:45:08 SQL show parameter pga NAME TYPE VALUE --- -- pga_aggregate_target big integer 209715200 23:47:18 SQL show parameter workarea NAME TYPE VALUE --- -- workarea_size_policy string AUTO So it looks workarea_size_policy is definitely limiting max pga available but strange thing is that the 200Mb for pat is meant to be for sort_area and we are not using sort_area here just filling an array I don't know why you don't get the same results but this is definitely weird and looks familiar with other bugs filed Regards, Jeroen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from
internal date value
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).
internal date format
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. There is a real kludge I can use: select date_field - to_date('01Jan1968','ddmon') as internal_date from table; Is there something built into Oracle to give me this internal format? 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).
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).