RE: 10046 level 8 trace - help required with 'direct path
John/Tim, The 'direct path read/write' are for cursor #14. The delete is cursor #15. Check the trace file for the preceding cursor #14. Paul -Original Message- Sent: Thursday, October 30, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Tim, As you have seen, this is due to writes to and reads from the TEMPORARY tablespace of that user. This could be due to both SORT segments (SORT_AREA_SIZE overflow) as well as HASH segments due to HASH Joins going to TEMP when they overflow HASH_AREA_SIZE. This can be seen from V$SORT_USAGE.SEGTYPE. Since a DELETE should normally not generate sorting or Hashing, I am assuming that either there are triggers that are forcing this to occur, or this is a view and the INSTEAD OF is performing some inefficient joins... Andy - just curious how a WHERE clause on a DELETE would generate Sort usage (outside of that explained above)... John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Yong Huang [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 9:10 AM To: Multiple recipients of list ORACLE-L Subject: Re: 10046 level 8 trace - help required with 'direct path Hi, Tim, Assuming you don't have more than 1000 files, what's your db_files set to and what's select file#, name from v$tempfile? If you do have more than 1026 files, select file#, name from v$datafile. Also show us select * from v$sort_usage if you can run that DELETE again. XCTEND rlbk=0: your transaction end marker says it's not rolling back; i.e. it's committing. Yong Huang --- Andy Rivenes [EMAIL PROTECTED] wrote: Looks sort spillage to disk due to the where clause. Andy Rivenes [EMAIL PROTECTED] At 06:44 AM 10/30/2003 -0800, Tim Onions wrote: Gurus I've applied many of the things I've learnt from this list over the years and today I tried a 10046 trace for the first time on a reported slow transaction. From what I can tell the biggest offender is a wait seemingly associated with rollback (see below) called 'direct path write'. Is this just a traditional wait for a row lock to be released or something more sinister? Any help much appreciated. Also (daft question time) what units are tim= in? (ie how many seconds between tim=131853898 and tim=131853270). This SE 8.1.7.4.12 on Windows 2000. Thank you T¬ PARSING IN CURSOR #15 len=60 dep=2 uid=38 oct=7 lid=38 tim=131853270 hv=2073223040 ad='8e9a2080' DELETE FROM ROUTING_NEXT_JOB RNJ WHERE RNJ.NEXT_JOB_ID = :b1 END OF STMT PARSE #15:c=0,e=2,p=0,cr=1,cu=0,mis=1,r=0,dep=2,og=0,tim=131853270 WAIT #15: nam='latch free' ela= 0 p1=-1856345836 p2=106 p3=0 EXEC #15:c=0,e=0,p=0,cr=3,cu=14,mis=0,r=2,dep=2,og=4,tim=131853270 XCTEND rlbk=0, rd_only=0 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59401 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59404 p3=1 WAIT #14: nam='direct path write' ela= 1 p1=1026 p2=59407 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59410 p3=1 WAIT #14: nam='direct path write' ela= 2 p1=1026 p2=59411 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59414 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59417 p3=1 WAIT #14: nam='direct path write' ela= 1 p1=1026 p2=59421 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59425 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59428 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59431 p3=1 WAIT #14: nam='direct path write' ela= 0 p1=1026 p2=59434 p3=1 ... WAIT #14: nam='direct path read' ela= 79 p1=1026 p2=41389 p3=7 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41396 p3=1 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41397 p3=7 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41404 p3=1 WAIT #14: nam='direct path read' ela= 0 p1=1026 p2=41405 p3=3 FETCH #14:c=100,e=628,p=221,cr=5629,cu=12,mis=0,r=1,dep=2,og=4,tim=131853898 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Onions __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
RE: Simple Query for Week number
select to_char(sysdate, 'W') from dual; Paul -Original Message- Sent: Thursday, December 19, 2002 10:54 AM To: Multiple recipients of list ORACLE-L Hey Folks, Looking for the simplest of queries to find the week number, given a date. For example, 19th December 2002 falls in the 3rd week, whereas 19th November, 2002, falls in the 4th week. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Migration 8.1.6.0 to 8.1.7.2
Currently going through a migration from 8.1.6.0.0 to 8.1.7.4 1. Had 8.1.6 installed. 2. Install 8.1.7.0 into new ORACLE_HOME 3. Apply pathset to get to 8.1.7.4 4. Upgrade database to 8.1.7.4 You only need to upgrade once, with only 2 oracle homes. Paul -Original Message- Sent: Thursday, July 18, 2002 2:19 PM To: Multiple recipients of list ORACLE-L The server already has 8.1.6.0 and 8.1.7.2 installed in separate oracle homes. We could install 8.1.7.0 in a third oracle home (we have the media) but are trying to avoid that as we would only need it for migration after which we have no use for it. So I was just wondering if we can migrate directly (8.1.6.0 - 8.1.7.2) instead of a two step migration (8.1.6.0 - 8.1.7.0 - 8.1.7.2)... just to avoid installing yet another version of oracle on this server. The docs seem to advise the two step process but don't go as far as stating that it must be done this way so I wondered if others have first hand experience? Thanks, Ken _ Clinical and Regulatory Informatics - Groton/New London Coordinator, Business and Technical Services Tel: (860) 732-0026 Fax: (860) 715-8346 Email: mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, July 18, 2002 12:54 PM To: Fowler; Kenneth R; Multiple recipients of list ORACLE-L Ken, How do you plan on getting to 8.1.7.2? You need to apply the patch set ontop of an 8.1.7.0 install. I'd double check your CD's. Dick Goulet Reply Separator Author: Fowler; Kenneth R [EMAIL PROTECTED] Date: 7/18/2002 9:43 AM List, One of the DBA's here needs to migrate a fairly sizeable database from 8.1.6.0 to 8.1.7.2 on Solaris. The doc's state that it is advisable to migrate to 8.1.7.0 and then go to 8.1.7.2 but we don't have 8.1.7.0 installed and don't want to install it unless we really have to. Anyone know if it is possible to migrate directly to 8.1.7.2 (docs don't explicitly say it can't be done but don't seem to suggest it either). Ken _ Clinical and Regulatory Informatics - Groton/New London Coordinator, Business and Technical Services Tel: (860) 732-0026 Fax: (860) 715-8346 Email: mailto:[EMAIL PROTECTED] LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fowler, Kenneth R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fowler, Kenneth R INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cognos
Totally agree. I didn't make the point of accessing the production OLTP system, as I didn't think that anybody is still doing that :) Any serious reporting should be off of a database setup specifically for that purpose. Through a proper meta-data layer, the joins between dimensions and facts (we are using a proper star schema ala Kimball, right?) is hidden and automatic, thereby reducing the likelihood of bad queries. Obviously end-user training, an understanding of the data, plus others are all pre-requisites to letting the users loose on the database. If it wasn't for users, my database would run perfectly :) Paul -Original Message- Sent: Thursday, July 18, 2002 6:12 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Paul, IMO it depends on where that data resides. If it's in the production OLTP system, it might be their data, but they're aren't responsible for the performance of the database, I am. So they don't get to play there. If it's in their replicated database I've created for reporting, they can do anything they want. They might slow down other users reporting, but they won't impact manufacturing. Depending on the architecture of the BI system, they may not even get access to the DW, but only the DM. Is it their data? Yes. Do they know how to manage it? No. That's our job. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/18/2002 12:32 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Cognos Cognos notwithstanding, isn't the objective in the case of Data Warehouse/DSS/Reporting/BI (or whatever the latest buzzword is for generating reports) to give end-users access to the data. These end-users then generate the own reports, without the need for IT every time they need a new total on a report? Sure I understand the need to prevent cartesian products and other queries from hell, but there are ways to achieve that. I fail to understand why the end-users shouldn't have access to the data, it is THEIR data, after all, not the DBA's. Paul -Original Message- Sent: Thursday, July 18, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cognos
Cognos notwithstanding, isn't the objective in the case of Data Warehouse/DSS/Reporting/BI (or whatever the latest buzzword is for generating reports) to give end-users access to the data. These end-users then generate the own reports, without the need for IT every time they need a new total on a report? Sure I understand the need to prevent cartesian products and other queries from hell, but there are ways to achieve that. I fail to understand why the end-users shouldn't have access to the data, it is THEIR data, after all, not the DBA's. Paul -Original Message- Sent: Thursday, July 18, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: the ora certified masters cert, yet again
Yeh, but he is the Prez ... :) Paul -Original Message- Sent: Wednesday, June 26, 2002 12:39 PM To: Multiple recipients of list ORACLE-L if you are a lousy presenter, giving bad information, you get horrible scores, and... Unfortunately, there is no reliable correlation between giving bad information and getting horrible scores, at either conference. Some of the best-ranked presentations in Oracle conference history have been some of the most damaging. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 9-11 New York City - Hotsos Clinic, Jul 23-25 Chicago - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas -Original Message- Ian A. Sent: Wednesday, June 26, 2002 10:54 AM To: Multiple recipients of list ORACLE-L I'll bet a dynamic animated speaker chockful of amusing anecdotes whose presentation is technically weak scores better than a plodding monotonous one with better information to convey :) Especialy if the audience is composed of nascent DBA's :) Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 25, 2002 5:09 PM To: Multiple recipients of list ORACLE-L one being a marketing venue, the other being a place where you can learn from ohers experiences. and to clarify further, if you are a lousy presenter, giving bad information, you get horrible scores and, since the selection process is not blind, don't get asked back to present again. So having a list of many presentations, at various conferences, can be an indicator of knowledge. --- Karniotis, Stephen [EMAIL PROTECTED] wrote: Let me clarify something. It was at Oracle Open World, not IOUG-A Live where these presentations were made. Please do not confuse the two!! Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email:[EMAIL PROTECTED] Web: www.compuware.com -Original Message- Sent: Tuesday, June 25, 2002 5:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: the ora certified masters cert, yet again A tip o' the hat to all authors and presenters. However writing a book makes no one an expert on anything. There are Oracle books containing fabulous stories of what happens when a tablespace is put in backup mode, and while quite entertaining they do not further a correct understanding of Oracle. Authors take the time to put what they believe to be true on paper. It's often what they have been told, not what they have learned on their own. Richard Niemiec's sp? tuning books have been trashed recently because they tout buffer hit ratios; however there was a consensus in the Oracle community that these were important. It took Cary Millsap's paper and a new tuning paradigm introduced by Gaja Vaidyanatha, Kirtikumar Deshpande, and John Kostelac Jr. to direct us to something more useful. Personally, I was using wait events before Gaja's book, but I was also trying to keep the hit ratio's high as a part of the consensus. If I had written a book before seeing Cary's paper! ! , it would have touted hit ratios. I don't believe Oracle 101 Performance Tuning is a perfect book; it doesn't properly address data collection needs. Why would authorship and presentations be worth more than an OCP? The OCP says that you have achieved a standard. One can debate whether that standard has any meaning. There is no standard at all for authors/presenters. It does seem however that many OCP holders know far less than their certificate would indicate, and some authors are more expert than their books convey. A good author of Oracle tomes and presentations needs a clearer understanding of the subject matter than an OCP. Good authors hold themselves to higher standards than needed to be called an OCP. I just want to point out that not all authors are good authors, and that there are OCP holders who have not written books that are as if not more knowlegeable than most authors. There are people who have done neither who know as much if not more than both. The OCM was introduced for two reasons. Oracle is in business to make money and wanted another revenue stream, and the standards one must meet to become an OCP were being questioned. Unfortunately at last years IOUG-A conference the six people who were given their OCM's were touted as the six most knowledgeable Oracle experts in th world. The awardees did not include Gaja, nor Kirti, nor Anjo Kolk, nor Steve Adams, nor Jonathan Lewis, nor Guy Harrison, nor Larry Elkins... Indeed only one person on the awarded the OCM would I have placed in any top six list, and that's Paul Dorsey who is extremely knowlegeable concerning Oracle's development tools. There were some awardees I know nothing about. Despite this over-the-top rollout,
RE: using a lot of temporary tablespace with large sort area size
Title: RE: using a lot of temporary tablespace with large sort area size What about hash_area_size? Paul x3704 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Friday, June 07, 2002 10:58 AMTo: Multiple recipients of list ORACLE-LSubject: RE: using a lot of temporary tablespace with large sort area size Guys, Have 20Gb and 16CPUS available on host. Need to do large full-table scans/joins to create materialized view. Since I have to do the full-table scans of large tables - decided to use parallel query option. Eliminated significant I/O contention by using DIRECT IO. Using very very large sort_area_size, however, still writing out significant segments to temporary tablespace which doesn't make sense to me. Any ideas?
Oracle-l conference (was RE: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN
I had the pleasure of meeting some of the oracle-l list members during the recent IOUG in San Diego. I also brought my family with me to San Diego, to combine my business with their pleasure. The IOUG (rightly perhaps) did not cater for any family-related events (although the Big Bash may have been a good place to also invite family members). So, I would support and seriously consider a Oracle-l conference, particularly one on a cruise ship. I would even volunteer to assist with organising ... Any other takers or ideas Paul -Original Message- Sent: Tuesday, April 30, 2002 2:24 PM To: Multiple recipients of list ORACLE-L snif! Gee, thanks all! hok! snif OK, I'm better now... grin! On the idea that Mogens started... How about an ORACLE-L conference on a cruise ship? I had a beer or two with Suzy on a cruise from Vancouver to Alaska on a woefully under-attended Geek Cruise (www.geekcruises.com) last summer. I understand that the Oracle Odyssey cruise from San Diego this year was even less well-attended. Too bad, because it is an excellent format with a lot of great content! I'm hopeful that Captain Neil would be all over the idea if he knew that 40-50+ people and families would sign up? These things don't happen quickly, but everyone is hopeful that 2003 will see the uphill side of a better economic picture. Maybe the timing would be good. Neil works with Holland-America, which does Caribbean, Baja, and Alaska cruises, but maybe they might also do something closer (or in the midst of) Europe? Or maybe halfway (i.e. Greenland, Iceland)? Just a thought... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 11:48 AM Tim is an exceptionally good guy, and I've had the pleasure of enjoying a few brews with him here in Denver. I'm all for having an oracle-l conference! Mogens Nørgaard wrote: Sigh. I wish I understood half the words used in this exchange. Or maybe not. But I still think Tim is a cool guy and I'm looking forward to drinking beer with him next time we meet. The first time I met with Tim was in Denver where he tricked me into eating something he called Rocky Mountain Oysters. If he ever makes it to Denmark I'll trick him into eating our world-famous blood sausage. Actually I'd like to drink beer with all you guys next time we meet. Maybe it's time for an Oracle-L Conference... Mogens Eric D. Pierce wrote: You silly! I was talking about the email admin at the guy's company, not fatcity. It has subsequently been explained to me that damagement is at fault (surprise) and ought to be blamed for all evil, not the email admin. http://www.dogdoo.com Ross can explain how brown fits into the metaphysical context of your astral plane. ORACLE-L Digest -- Volume 2002, Number 118 -- From: Tim Gorman [EMAIL PROTECTED] Date: Sat, 27 Apr 2002 10:34:46 -0600 Subject: Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A DIKHEAD / (Fwd) Antigen found =*.*.txt file Eric, A 5th-grade teacher once admonished me on cursing by pointing out that the English language has 100,000 words in frequent usage and how unimaginative it was to constrain myself to the same dozen or so words to describe my feelings... Bruce, the guy who runs FATCITY as a sideline business (because this business doesn't generate enough money to support the typical family), restricts all attachments not only out of concern for viruses, but for the more practical reason of limiting message size and therefore storage and network capacity. It's a good policy -- if you'd like to send attachments, please address people directly... ...and please grow up. -Tim I don't know if this guy (Evans, David) is subscribed to this list, but if so, please tell your email admin that this stuff sucks. A text file attachment is not automatically equivalent to a virus attachment. If their system wasn't set up by such dikheads, they would know that they can implement packet scanning at the email gateway in a non-intrusive manner that is far more effective than this spam cr*pola. http://www.antivirus.com/products/isvw/ regards, ep -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
RE: Decyphering LMT space bitmap
Following on from my previous note: Jeremiah, From your bitmap control, You have FF occurring 3 times followed by 3F which is 255, 255, 255, 63 which is 0011 So, least signficant bit first, 1100 which is used, used, ... (30 times) , free, free This corresponds with the first: 30 (the bit before the first free bit) Paul -Original Message- Sent: Monday, April 08, 2002 3:23 PM To: '[EMAIL PROTECTED]' From the 'Data Management and Storage Internal notes, Bitmapped Tablespace File Structure A new bitmapped tablespace file has the following structure: File Header 1 block Bitmapped File Space Header 1 block Head portion of of Bitmap BlocksN blocks Useful file blocks U units (A unit is a number of blocks) Tail portion of Bitmap Blocks M blocks If a Unit = B blocks, then the total file size = 1 + 1 + N + U*B + M Bitmapped File Space Header .. (lots to type, I can if you really need it) Bitmap blocks have 2 parts : Bitmap control structure Vector Dump The fields in the bitmap control structure are: RelFNo: Relative file number to which the bitmap belongs BeginBlock: Which block number does the first bit represent Flag: Zero for permanent files, one for temp files First: Where to start looking for the free space (bit before first free bit) Free: Number of free slots (bits) in the bitmap (not the file) To read the bitmap, take each two-byte pair, least significant bit first. If there are not eight bits, pad to eight bits with zeroes. Hence 0x0F = 15 = . When written least significant bit first, the bitmap looks like this -- used, used, used, used, free, free, free, free Scanning for the first free extent will start at the 4th bit. HTH Paul -Original Message- Sent: Monday, April 08, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Out of curiosity I decided I wanted to look at what composed the extent map in locally-managed tablespaces. I dumped the first 5 blocks of the tablespace's first datafile with 'alter system dump datafile ...' The results surprised me, as they appeared to consist of almost no data. The LMT in question contains a variety of segments and extents. How is the LMT bitmap organized? Start dump data blocks tsn: 1 file#: 2 minblk 1 maxblk 1 Block 1 (file header) not dumped: use dump file header command Start dump data blocks tsn: 1 file#: 2 minblk 2 maxblk 2 frmt: 0x02 chkval: 0x type: 0x1d=KTFB Bitmapped File Space Header File Space Header Block: Header Control: RelFno: 2, Unit: 8192, Size: 524352, Flag: 1 Initial Area: 3, Tail: 524292, First: 30, Free: 34 Start dump data blocks tsn: 1 file#: 2 minblk 3 maxblk 3 frmt: 0x02 chkval: 0x type: 0x1e=KTFB Bitmapped File Space Bitmap File Space Bitmap Block: BitMap Control: RelFno: 2, BeginBlock: 5, Flag: 0, First: 30, Free: 128994 FF3F ... all zeros Start dump data blocks tsn: 1 file#: 2 minblk 4 maxblk 4 frmt: 0x02 chkval: 0x type: 0x1e=KTFB Bitmapped File Space Bitmap File Space Bitmap Block: BitMap Control: RelFno: 2, BeginBlock: 1056964613, Flag: 0, First: 0, Free: 129024 ... all zeros FWIW: SQL select count (*) from dba_extents where file_id = 2; COUNT(*) -- 30 SQL select extent_management from dba_data_files df, dba_tablespaces ts where df.tablespace_name = ts.tablespace_name and file_id = 2; EXTENT_MAN -- LOCAL -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: very interesting problem with V$SESSION and web applications.
Assuming that the application "knows" the real username, let the first thing that the app does is call dbms_application_info.set_client_info passing the real username as a parameter. This sets v$session.client_info to the real username. T10-PARTS select client_info from v$session 2 where sid = (select sid from v$mystat where rownum = 1) ; CLIENT_INFO T10-PARTS execute dbms_application_info.set_client_info('REAL_USER_NAME'); PL/SQL procedure successfully completed. T10-PARTS select client_info from v$session 2 where sid = (select sid from v$mystat where rownum = 1) ; CLIENT_INFOREAL_USER_NAME T10-PARTS select userenv('CLIENT_INFO') from dual; USERENV('CLIENT_INFO')REAL_USER_NAME T10-PARTS select sys_context('userenv', 'client_info') from dual; SYS_CONTEXT('USERENV','CLIENT_INFO')REAL_USER_NAME Hope this helps Paul-Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Friday, April 05, 2002 4:16 PMTo: Multiple recipients of list ORACLE-LSubject: very interesting problem with V$SESSION and web applications Dear Gurus , I have a comic question . ? We have a db and ias and portal . users log in by using portal login page . The problem is : because application server connects to db , in v$session the machines are all the application server machine . Although the users are db users , when you login from portal , the usernames are portal30 and portal30_sso .. So how will I know which user is which session ? V$session gives no help ... May be comic :) But can not find an answer .. Investigating portal for writing into v$session as the real username ..But no other thing comes into my mind Any idea please ... Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.
RE: SQL using UTL_FILE
Try and determine what it is doing/waiting for. Set up a 10046 trace at level 8. You may get lucky and see the problem within the first few minutes rather than wait the full 7 hours. Paul -Original Message- Sent: Wednesday, March 27, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Group, I have a stored procedure that runs from schema A on machine X, joins a table from another schema on machine X and a table from machine Y via a dblink and writes a file via UTL_FILE on machine X that is used in SQL Loader to insert data into a table for research. Pulls about 90 meg. For the past several months the procedure had been running in about 20 mins., in the last 2 weeks the time has jumped to 7 hours. As far as I can determine there have been no changes (I know, yeah, right !!) . My hardware is a SUN Solaris 5.7. ANY (sane) suggestions ? TIA Al Rusnak 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fav. Urban Legend...
Also, optimizer_search_limit (I think hidden in 8.1) defaults to 5, which means, consider all permutations, including Cartesian product joins, if the # of tables in the from clause is 5 or less. For more than 5 tables, Cartesian products are not considered initially. Another parameter is optimizer_max_permutations which defaults to 80,000 which is the max no. of join orders. Don't know how close anybody has got to this though. Jonathan? Paul -Original Message- Sent: Thursday, March 14, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Oracle eliminates lots of options by tracking 'best cost so far'. The frist step of optimisation is 'single table access path' i.e. if I make each table in turn the driving table for the query, how much does it cost to get all the data I need from just that table. Then assume that the cost of the full query is 88 if the order of tables is A,B,C,D,E but the cost of the single table access path into E was 92, then Oracle can spot that there is no point in trying any access paths that start with table E. That's just eliminated 24 paths out of 120. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 14 March 2002 15:26 |another possible source of the max 5 tables in a join myth could be that |Sybase and SQLServer's query optimizer would only consider all possible join |orders for up to 5 tables. this was true through at least vers 11.5 for |Sybase. do the math - there are 120 possible join orders for 5 tables, 720 |for 6, 5040 for 7 - an optimizer has to draw the line somewhere or we would |spend more time optimizing than executing. | |anybody know how Oracle draws that line? | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fav. Urban Legend...Quotable quotes
This does make you wonder about the recently awarded Master's certification given by Oracle. (Not taking anything away from Jeremiah though) Paul -Original Message- Sent: Thursday, March 14, 2002 3:20 PM To: Multiple recipients of list ORACLE-L ..increasing the buffer hit ratio from 95 to 99 percent can yield performance gains of over 400 percent Retrieving data from memory is over 1 times faster than retrieving it from disk A more efficient method is to have the database write to the redo logs only when all the log buffers are filled or when a commit is issued. This happens when log_checkpoint_interval is set to zero This allowed the O/S to dedicate a specific background process to moving the log buffers upon checkpoint to the redo files At times, specifying multiple hints can mysteriously cause the query to use none of the hints The INDEX_DESC hint causes indexes to be sorted in descending order...This index is overwritten when the query has multiple tables Cheers Connor --- Freeman, Robert [EMAIL PROTECTED] wrote: Ok... one of my favorite Urban Legends is this one: The book is always right. In other words, if it's written down in a book we bought off of Amazon, it must be so. So, I'd like to ask, without anyone taking potshots at specific authors, what is the dumbest, silliest, or most technically incorrect thing you have ever seen in an Oracle book? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fav. Urban Legend...
It has to be that unless your data is all in one extent, you would experience bad performance Paul -Original Message- Sent: Tuesday, March 12, 2002 3:43 PM To: Multiple recipients of list ORACLE-L I'm putting the final touches on my IOUG-A presentation (I got an extension for those who realize that I'm late on it!)... I'm doing Oracle Urban Legends. I've got several in my presentation but I thought I'd ask here, before I put the presentation to bed, what your favorite (or the one you find the most irritating) Oracle Urban legend was RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sql question
How about : select num from NUMBERS, ( select begin, end from RANGE) where num between begin and end; Paul -Original Message- Sent: Friday, February 22, 2002 10:14 AM To: Multiple recipients of list ORACLE-L You are right that the range aren't necessarily contigous. I'd probably have to write it in PL/SQL, I just want to see if one can do this with SQL. Thanks. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: sql question Date: Thu, 21 Feb 2002 21:33:20 -0800 Rich, Are you sure that that is what you want ? Suppose your range values were something like : begin end 1 9 1519 2329 ie, the RANGE table shows that 10-14 and 20-22 are invalid (not allowed) values. Your problem statement and the SQL that Paul provides for the problem statement would return numbers like 10, 11, 20,21 which are, actually, invalid. You'd have to write a cursor to loop through the valid ranges ?? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Paul Baumgartel [EMAIL PROTECTED] 22/02/2002 12:43 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Re: sql question To use your example column names: select num from numbers where num between (select min(begin) from range) and (select max(end) from range); --- oracle dba [EMAIL PROTECTED] wrote: Hi all, I have a SQL question. Suppose I have a table called RANGE looks like this: begin end 1 9 1019 2029 Then I have a table NUMBERS that's full of bunch of numbers like this: num 1 2 3 4 ... 98 99 100 I want to write a SQL that returns the number that are within the ranges defined in the RANGE table. So number 1 through 29 should be returned. Can someone help me with this? Thanks. Rich _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oracle dba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oracle dba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of
RE: Tkprof output
Set you 10046 trace at level 4 or 12, and then check the trace file. Paul -Original Message- Sent: Friday, February 22, 2002 3:53 PM To: Multiple recipients of list ORACLE-L Hi Listers, I got the following statement in the tkprof output file : update EMP set ENAME=:V001,EMPNO=:V002 where rowid = :V003 I'm just wondering how to get the value of that variables (instead of :V001, :V002 and :V003). Is there a way to do that ? Thanks. Aldi _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ROWID datatype columns and primary keys
Patrice, The only reason I can think of creating a column with a datatype of ROWID, is in order to store a rowid. Why you need to store the rowid escapes me as the rowid is available as a pseudocolumn anyway. It is also dangerous to store this rowid in a column, as it can change. During and import/export as you said, but also on partitioned tables if the partitioning key value changes and the table has been setup to allow the row movement Just my 2c Paul -Original Message- Sent: Thursday, February 21, 2002 1:18 PM To: Multiple recipients of list ORACLE-L Can someone explain to me why some developers like to create ROWID datatype columns in their tables? I am wondering why they sometimes do that instead of using primary keys. I searched for info on this on the Web, but nothing. ROWID access is probably faster than index access, I guess. I vaguely remember my Oracle instructor saying about four years ago that using ROWIDs was bad practice in most cases, but I can't remember exactly why he said that. ROWIDs are not reliable, when exports/imports take place and between COMMITS if many users access the same table, if the row could be dropped and re-created. Are there other reasons why someone might not want to use ROWID columns? I am just fishing for opinions. Thanks. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LOCKS - Reading Block Dumps
Hi Larry, the lb (lock byte) in the row piece of the block points to an ITL entry. As for the ITL entry, there is a slight confusion in that the headings don't line up exactly with values. In your case, when uncommitted, the contents are : Itl 0x01(ITL no.) Xid xid: 0x0002.018.0482 (transaction ID) Uba uba: 0x0080c4a8.0340.0e (undo block address) Flag(state of transaction) Lck 1 (no. of rows locked by this transaction within this block) Scn/Fsc fsc 0x0006. (SCN or Free Space Credit) Steve Adams and Jonathan Lewis' sites have some info on block dumps. Also, Scaling Oracle 8i by James Morle also has some info. HTH, Paul -Original Message- Sent: Tuesday, December 04, 2001 12:36 PM To: Multiple recipients of list ORACLE-L Listers, Playing around with dumping a block to determine rows which are locked. I did an update to a single row in a table and did not commit. I dumped the block. Here is the relevant info: tab 0, row 0, @0x19c3 tl: 21 fb: --H-FL-- lb: 0x1 cc: 3 After rolling back and dumping the block, I get the following: tab 0, row 0, @0x1977 tl: 27 fb: --H-FL-- lb: 0x0 cc: 3 It looks like to me that the lb: value indicates the presence of a lock on the row -- 0x1 for a lock, 0x0 for not locked. I've been googling for a bit, searching usenet, and the typical web sites for info on this and came up empty handed. So, can anyone confirm this idea of lb: 0x0 meaning no lock and 0x1 meaning the row is locked? Also, there seems to be some differences in the block header info related to ITL's: Lock present: Itl Xid Uba Flag LckScn/Fsc 0x01 xid: 0x0002.018.0482uba: 0x0080c4a8.0340.0e 1 fsc 0x0006. No lock: Itl Xid Uba Flag LckScn/Fsc 0x01 xid: 0x0001.037.04c3uba: 0x00800107.06dc.31 C---0 scn 0x.00594c1b Can I assume that Scn/Fsc value of non-zero means there is a lock? And last but not least, any good info anywhere on reading block dumps? Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Number of Transactions per 24hr period? - Urgent
Title: RE: Number of Transactions per 24hr period? - Urgent Denham, Craig Shallahamer explores this issue in a paper on www.orapub.comabout Response Time Analysis. In essence, one way of calculating the no. of transactions can be from 'user commits' + 'user rollbacks', but it appears that you also want to calculate the "response time" for these transactions. A slightly "harder" problem, as Craig suggests. Good luck Paul PS. Good to see another South African on the list :) -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 27, 2001 7:35 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Number of Transactions per 24hr period? - Urgent Thanks, I have followed this line of thought, however, What parameter do I use as a yard stick? Perhaps execute count, parse(hard), OR parse(total) - This is what I am not sure of:) Thanks Denham -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 1:50 PM To: Multiple recipients of list ORACLE-L Subject: Re: Number of Transactions per 24hr period? - Urgent Denham Eva wrote: Hello List, Please help, I would like to determine the number of transactions processed by Oracle during a 24 hr period. Is this possible? TIA Denham -- This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com -- This is typically the kind of information you find in V$SYSSTAT. Look at V$INSTANCE to get the exact time when your instance was started, V$SYSSTAT holds (mostly) cumulated values. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax: +44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
RE: range checking ??? URGENT
Which version? Does it have the case clause? -Original Message- Sent: Wednesday, November 14, 2001 4:50 PM To: Multiple recipients of list ORACLE-L Hi all, Can decode work on a range, like if Code is 100 and 200, then name is A; if code200 and code300, then name is B; I have about 20 ranges to check. If decode cannot handle that, what's an easy way to do that? Thank you! Leslie __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sqlloader - important
Roland, You are missing a comma and a quote. It should be (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID), not (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), See the difference? Paul -Original Message- Sent: Tuesday, November 13, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Average response time
!! Please do not post Off Topic to this List !! Hi List, I am trying to calculate the average database response time for a data center audit currently underway. Without expensive monitoring tools, is it possible to determine this from database statistics. So far, I'm using (Service Time + Wait Time) / calls where this translates into Service Time= 'CPU used by this session' from v$sysstat Wait Time = sum(time_waited) from v$system_event (excluding idle events) User calls = 'user calls' from v$sysstat Am I way off the mark here? Interestingly, it seems as if Craig Shallahamer (www.orapub.com) is preparing a paper which addresses this very issue - determing response time from database statistics - but it is only due out later this year. Anybody with any ideas or reasons why the above is not feasible? TIA Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DataWarehouse Configuration
Hi Bill, Is 200GB the total size of the database? If so, have you considered only loading "new" data into production? Paul --- Bill Becker [EMAIL PROTECTED] wrote: Hello, Some data warehousing questions: We are considering a setup where we have two separate machines, 1 for doing the ETL (ExtractTransformLoad)processing, and 1 for the production machine. Our env is Oracle 8.1.6 on Sun. The main idea is to insulate the production machine from the effects of ETL processing; the only impact ETL would have on the production machine would be when the ETL has completed and the data is copied over to the production machine, which leads me to my question: what methods have been used to minimize the time needed for this copy step? The amount of data to be transferred would be around 200GB, but expected to grow very fast. Both machines would be part of an existing ethernet network, and we've considered the following: 1) Just do the transfer over the existing ethernet network (figure about 150GB/hour) 2) Position the machines close to each other, and run a short (6-foot or less) cable between serial ports or parallel ports on both machines 3) Set up a separate network; install an ethernet card in each machine, and connect them with ethernet 4) Go to a "disk-farm" setup - don't know a lot about this, but both machines would access subsets of a large shared disk array (is this EMC? or other vendors?) The consensus is that fiberoptic, although faster, would be a waste since then the limiting factor would be disk read and write speeds. Anyway, I would appreciate any comments/suggestions regarding the above, especially #4, and any other approaches. Thanks to any responders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Becker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Parker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ksedmp
Not a bad thought, Ross. Both Steve Adams' and Jonathan Lewis' books are by far the best literature out there on Oracle. Most of the other publications (not detracting from the effort and knowledge of other authors) are merely rehashes of the Oracle documentation. Whilst I am sure that us (the list) bugging them to bring out Book II won't necessarily get it accomplished, I would certainly would buy it if it did come out. So, Steve and Jonathan - if you are listening - can you guys do any better with a future publication? Paul --- "Mohan, Ross" [EMAIL PROTECTED] wrote: Note to list Many moons ago, before Steve got anywhere near finishing his book, it was to be a glorious oeuvre, a Magnus Opus, a.well, nevermind, but it was going to be big Big BIG. Including everything about Oracle. (Steve had even decided to include a section on the kernel compilation flags for the engine computer in Ellison's Ferrari, but later cut it, due to an inability to obtain reliable test data.) Events intervened, as they must. (You may use the preceding sentence as a Total Explanation for Everyting in Reality) Steve could not do the book he originally envisioned. Rest assured, if he had, you'd probably have a copy of the Oracle source code on your desk now. Maybejust maybe.if the list bugs Steve ( and Jonathan Lewis and...) enough, he'll go for Book II. :-) just a thought - Ross -Original Message- Sent: Thursday, February 15, 2001 1:32 PM To: Multiple recipients of list ORACLE-L Hi Patrice, Ross is right. Sorry that you did not find anything helpful in my book. I did not include the error handling module in the scope for my book, because I don't think it's very interesting. Here is what the introduction of my book says about the services layer in general, and then about the scope ... The services layer provides low-level services that are used by all the higher layers, such as error handling, debugging, and tracing facilities, as well as parameter control and memory services. In particular, the service layer is responsible for generic concurrency control facilities such as latches, event waits, enqueue locks, and instance locks. This layer is also responsible for the management of the data structures for background and user processes and sessions, as well as state objects, inter-process messages, and system statistics. ... This book covers the kernel services for waits, latches, locks, and memory. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ http://www.ixora.com.au/ @ http://www.christianity.net.au/ http://www.christianity.net.au/ -Original Message- Sent: Friday, 16 February 2001 1:56 To: Multiple recipients of list ORACLE-L Kernel Services Error DuMP or somesuch. shows up in virtually all traces i have seen . -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, February 15, 2001 7:05 AM To: Multiple recipients of list ORACLE-L Would anyone know what this refers to? I have a trace file with cryptic information in it, and can't make sense of it. I thought perhaps I could figure out what this is by looking in the Oracle Internals book by O'Reilly, but no success. It does say that KS is a layer used by the other layers for memory management, cursor space and other things, but that's all the information I could get out of that book. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Parker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Consistent Gets?
Thanks for your response Riyaj. I initially had the same thought so I had re-run the queries a no. of times, all giving the same (inconsistent) results. I also confirmed from v$mystat that "consistent gets" as reported by autotrace were being reported proportionately to "no work - consistent read gets" - an indication to me anyway that it was not having to re-create the blocks for the consistent view. Any other ideas? Paul --- [EMAIL PROTECTED] wrote: Hi This may be due to commit cleanout mechanism. After populating the table, your commit simply marks the transaction as completed in the rollback segment header and does not clean the rows in the block. So the flags in the row header portion of the block indicates that the transaction is open and active. When you do a select on those rows Oracle sees that the transaction is open and goes to the rollback segment header to check the status of the transaction, and then marks the row headers to committed state. When you do the select second time, since the row headers indicates the commit status, the session doesn't need to do that much work to get the consistent data. To verify this behavior, do the first select again and you could see comparable consistent gets. Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA "This is my opinion and does not bind my employer. Use at your own risk" Paul Parker paul_g_parker@To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] yahoo.com cc: Sent by: Subject: Consistent Gets? [EMAIL PROTECTED] m 02/12/01 11:30 AM Please respond to ORACLE-L Hi all, Could someone attempt to explain the difference in the no. of "consistent gets" reported for these 2 queries? I have a table (TEST1) made up of 11,333 blocks. No indexes on this table. I run two queries, both reported to do full table scans (as expected), one returning all the rows from the table and one with a bogus condition resulting in no rows returned. I expected, that since both queries did full table scans, that the amount of IO would be the same. Yet the query which returned data did 3 times as much IO as the one which did not. Output follows : 12:08:16 T10-SERVCBO-CH @p2 12:08:22 T10-SERVCBO-CH set autotrace traceonly exp stat 12:08:22 T10-SERVCBO-CH select 12:08:22 2 * 12:08:22 3 from 12:08:22 4 test1 12:08:22 5 where 12:08:22 6 pay_dealer_date = '01/01/2000' 12:08:22 7 -- and state_code = 'AB' BOGUS CONDITION 12:08:22 8 ; 375043 rows selected. Elapsed: 00:00:55.46 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 10 TABLE ACCESS (FULL) OF 'TEST1' Statistics -- 0 recursive calls 15 db block gets 35581 consistent gets 10575 physical reads 0 redo size 66817080 bytes sent via SQL*Net to client 2775646 bytes received via SQL*Net from client 25004 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 375043 rows processed 12:09:18 T10-SERVCBO-CH ed p2 12:09:33 T10-SERVCBO-CH @p2 12:09:35 T10-SERVCBO-CH set autotrace traceonly exp stat 12:09:35 T10-SERVCBO-CH select 12:09:35 2 * 12:09:35 3 fro
Re: Consistent Gets?
Thanks for your response Riyaj. I initially had the same thought so I had re-run the queries a no. of times, all giving the same (inconsistent) results. I also confirmed from v$mystat that "consistent gets" as reported by autotrace were being reported proportionately to "no work - consistent read gets" - an indication to me anyway that it was not having to re-create the blocks for the consistent view. Any other ideas? Paul --- [EMAIL PROTECTED] wrote: Hi This may be due to commit cleanout mechanism. After populating the table, your commit simply marks the transaction as completed in the rollback segment header and does not clean the rows in the block. So the flags in the row header portion of the block indicates that the transaction is open and active. When you do a select on those rows Oracle sees that the transaction is open and goes to the rollback segment header to check the status of the transaction, and then marks the row headers to committed state. When you do the select second time, since the row headers indicates the commit status, the session doesn't need to do that much work to get the consistent data. To verify this behavior, do the first select again and you could see comparable consistent gets. Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA "This is my opinion and does not bind my employer. Use at your own risk" Paul Parker paul_g_parker@To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] yahoo.com cc: Sent by: Subject: Consistent Gets? [EMAIL PROTECTED] m 02/12/01 11:30 AM Please respond to ORACLE-L Hi all, Could someone attempt to explain the difference in the no. of "consistent gets" reported for these 2 queries? I have a table (TEST1) made up of 11,333 blocks. No indexes on this table. I run two queries, both reported to do full table scans (as expected), one returning all the rows from the table and one with a bogus condition resulting in no rows returned. I expected, that since both queries did full table scans, that the amount of IO would be the same. Yet the query which returned data did 3 times as much IO as the one which did not. Output follows : 12:08:16 T10-SERVCBO-CH @p2 12:08:22 T10-SERVCBO-CH set autotrace traceonly exp stat 12:08:22 T10-SERVCBO-CH select 12:08:22 2 * 12:08:22 3 from 12:08:22 4 test1 12:08:22 5 where 12:08:22 6 pay_dealer_date = '01/01/2000' 12:08:22 7 -- and state_code = 'AB' BOGUS CONDITION 12:08:22 8 ; 375043 rows selected. Elapsed: 00:00:55.46 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 10 TABLE ACCESS (FULL) OF 'TEST1' Statistics -- 0 recursive calls 15 db block gets 35581 consistent gets 10575 physical reads 0 redo size 66817080 bytes sent via SQL*Net to client 2775646 bytes received via SQL*Net from client 25004 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 375043 rows processed 12:09:18 T10-SERVCBO-CH ed p2 12:09:33 T10-SERVCBO-CH @p2 12:09:35 T10-SERVCBO-CH set autotrace traceonly exp stat 12:09:35 T10-SERVCBO-CH select 12:09:35 2 * 12:09:35 3 fro
RE: Consistent Gets?
-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Parker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Parker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).