Re: Want to BAARF - Recommendations for 10 36G Drive config
David - I just registered you as Party member # 30. You obviously have the right attitudes :-). Mogens Dave Phillips wrote: A client runs our app with the following layout. Since their intial 6 drive config they have procured more drives for a total of 10 36Gig Drives. They have also upgraded memory from 1 to 4 gig. I have the opportunity to recommend changes to the current structure to improve performance. So, any recommendations from the BAARF committee are welcome. Current System Ora 8.1.7 Win 2k Size 30Gig Logical Array 1 - Raid 1 - OS and Oracle Logical Array 2 - Raid 1 - App and Index TS Logical Array 3 - Raid 5 - The rest (Data,Rbs,redo,etc) David Phillips Support DBA BAARF member wanna-be -- 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: Rule Based Optimizer
Pete - I love it when you talk dirty. It will probably only get worse in the next 24 hours, since - if I recall correctly - you're having the "I'm going back to Australia, so let's empty all the bottles in my house" party tonight? Thanks for the note on 6.0.27. It's funny how things are introduced early in releases sometimes. OPS was in 5, CBO in 6, some waits in 6 (the x$trace stuff). And it's all still around in 9 :-))). Mogens Pete Sharman wrote: Yup, I remember praying exactly the same thing! Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long term Oracle DBA. -Original Message- Jared Still Sent: Wednesday, June 11, 2003 10:10 PM To: Multiple recipients of list ORACLE-L 7.0.13. Ah yes, I remember that. Mostly I remember praying that 7.0.16 would be in the mail RSN. Jared On Wednesday 11 June 2003 18:14, Pete Sharman wrote: Much as I hate to say that Jared's confidence in Mogens is misplaced, we must all remember Mogens has now reached the grand old age of 42 and the brain cells are starting to slip. :) To be absolutely 100% picky and correct, there was an event setting introduced in (I believe) 6.0.27-ish that you could use to turn on the CBO. However, Mogens is correct in that it was first officially released and supported in the first Production release of Oracle7, 7.0.13. Sorry, Mogens, couldn't resist! :) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long term Oracle DBA. -Original Message- Mogens Nørgaard Sent: Tuesday, June 10, 2003 7:55 PM To: Multiple recipients of list ORACLE-L Thanks for the confidence, Jared. It was introduced in 7.0 and the world hasn't been the same since. Mogens Jacques Kilchoer wrote: I am 99% confident that I remember the CBO existing on VAX/VMS in 7.1.5, and for sure in 7.1.6 (on VAX/VMS) -Original Message- I first saw the CBO in 1994 if IIRC. Seems to me it was introduced in 7.2. I'm sure Mogens knows for sure. :)
Re: World premier performance of the BAARF party logo
Dan, Excellent idea. We will of course put your comment into the official BAARF paper version 2 (which I think I can have ready in about 42 seconds from now) as an important (and so far the only) footnote. What I like about your idea is that it got me wondering if the future has already started? I mean, I have seen RAID-40 sold (albeit under the name RAID-50), and I have seen RAID-50 sold (albeit under names like "Disaster Recovery Site"), and such. It must be a challenge to sell a huge RAID-4 SAN... and then mirror it. Respect! It might also be possible to create a new BAARF logo (the old one is kind of outdated and people are getting tired of looking at it now after several days of availability on the open market) where it ends with a sentence like ".And all the powers that be.." I have actually just added your comment in the BAARF vers 2.doc and .htm documents. Should be available on the Internet RSN. Thanks for your idea. Best regards, Mogens Daniel W. Fink wrote: Mogens, As a futuristic thinker, I challenge you to go beyond todays technology and consider what the next millenium may bring. While it is all good and well to be against RAID-Free/Four/Five, we should also issue a policy statement against the newer, though not currently production ready, configurations listed below. RAID-Firteen/Fourteen/Fifteen, Free hundred through Five hundred ninety nine (inclusive), Free thousand through Five thousand nine hundred ninety nine (inclusive) and all RAIDS that are powers of Free/Four/Five. Dan -- 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: SQL Query Help
select from A) where and datecreated = (select min(datecreated) from b where b.cid = a.cid and b.pid = a.pid) At 08:14 PM 6/13/2003 -0800, you wrote: I have a table with records like this CID S TO_CHAR(DATECREATED, MESSAGE PID - - -- 2 N 01-feb-1974 19:45:45 service change1* 3 N 01-feb-1974 19:45:45 service change1* 3 N 01-feb-1974 21:45:45 service change1 1 N 01-jan-1974 12:34:45 msisdn change 1* 1 N 01-jan-1974 19:45:45 service change1 2 N 01-jan-1974 19:45:45 service change1 1 N 01-nov-1974 17:45:45 service change1 1 N 01-nov-1974 19:45:45 service change1 I want to display only the records with the *(not a value stored in the database.just used as a marker here). i.e the records which meet the following. 1.earliest date 2.if there are multiple occurances of records with the same cid and pid combination i want only the record for the combination of cid-pid and with the most earliest record(oldest time stamp). i want to achieve this CID S TO_CHAR(DATECREATED, MESSAGE PID - - -- 2 N 01-feb-1974 19:45:45 service change1* 3 N 01-feb-1974 19:45:45 service change1* 1 N 01-jan-1974 12:34:45 msisdn change 1* I need some help in getting the query that can get the results like that. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL Query Help
I have a table with records like this CID S TO_CHAR(DATECREATED, MESSAGE PID - - -- 2 N 01-feb-1974 19:45:45 service change1* 3 N 01-feb-1974 19:45:45 service change1* 3 N 01-feb-1974 21:45:45 service change1 1 N 01-jan-1974 12:34:45 msisdn change 1* 1 N 01-jan-1974 19:45:45 service change1 2 N 01-jan-1974 19:45:45 service change1 1 N 01-nov-1974 17:45:45 service change1 1 N 01-nov-1974 19:45:45 service change1 I want to display only the records with the *(not a value stored in the database.just used as a marker here). i.e the records which meet the following. 1.earliest date 2.if there are multiple occurances of records with the same cid and pid combination i want only the record for the combination of cid-pid and with the most earliest record(oldest time stamp). i want to achieve this CID S TO_CHAR(DATECREATED, MESSAGE PID - - -- 2 N 01-feb-1974 19:45:45 service change1* 3 N 01-feb-1974 19:45:45 service change1* 1 N 01-jan-1974 12:34:45 msisdn change 1* I need some help in getting the query that can get the results like that. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Inverse 9i Question
Ramon, I think you are right, Frankly speaking I missed 'c'. What our judge(Robert) says? Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 13 Jun 2003 15:19:39 -0800 I would go with A and C Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- CP Sent: Friday, June 13, 2003 6:15 PM To: Multiple recipients of list ORACLE-L I think, it should c: (The ability to rename a tablespace). Thanks CP [EMAIL PROTECTED] wrote: > Robert > > If I am not wrong..without looking at your book or any 9i doc...The > answer is > > a. The ability to Rename a Column > > Regards > Rafiq > > > > > > > Reply-To: [EMAIL PROTECTED] > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Date: Fri, 13 Jun 2003 12:09:54 -0800 > > Just in the mood to do one of these > Which of the following is *not* a feature of Oracle 9i? > > a. The ability to Rename a Column > b. The ability to Rename a Constraint > c. The ability to rename a tablespace > d. The ability to drop a column > e. The utl_xplan function to format execution plans from the SQL > prompt. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Freeman Robert - IL > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > > _ > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. > http://join.msn.com/?page=features/virus > -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with [EMAIL PROTECTED] http://shopnow.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CP INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Inverse 9i Question
I would go with A and C Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- CP Sent: Friday, June 13, 2003 6:15 PM To: Multiple recipients of list ORACLE-L I think, it should c: (The ability to rename a tablespace). Thanks CP [EMAIL PROTECTED] wrote: > Robert > > If I am not wrong..without looking at your book or any 9i doc...The > answer is > > a. The ability to Rename a Column > > Regards > Rafiq > > > > > > > Reply-To: [EMAIL PROTECTED] > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Date: Fri, 13 Jun 2003 12:09:54 -0800 > > Just in the mood to do one of these > Which of the following is *not* a feature of Oracle 9i? > > a. The ability to Rename a Column > b. The ability to Rename a Constraint > c. The ability to rename a tablespace > d. The ability to drop a column > e. The utl_xplan function to format execution plans from the SQL > prompt. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Freeman Robert - IL > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > > _ > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. > http://join.msn.com/?page=features/virus > -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with [EMAIL PROTECTED] http://shopnow.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CP INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Inverse 9i Question
I'm gonna say 'c.' Jared Freeman Robert - IL <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/13/2003 01:09 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Inverse 9i Question Just in the mood to do one of these Which of the following is *not* a feature of Oracle 9i? a. The ability to Rename a Column b. The ability to Rename a Constraint c. The ability to rename a tablespace d. The ability to drop a column e. The utl_xplan function to format execution plans from the SQL prompt. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trigger double firing apparently double inserts
I shall suggest to check dual table having more then 1 row. Or is there any possibility whether you have more then 1 dual table on your system meaning one owned by sys and other owned by some user having count > 1. Regards rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 13 Jun 2003 13:49:37 -0800 I have come across situation like this earlier. Looks like "at runtime" two rows are getting selected. create a dummy table and insert the key values/relevant values to see what "extra" row is being selected. HTH GovindanK > Hi Listers > > I have a trigger that is an on update trigger that is somehow writing two > records when a record is updated in the table that the trigger is > associated with. > I have run the select statement to see if it will retrieve multiple > records and the msf071 table that has the record that causes the trigger > to fire has only on record for the equip_no > Why does it do this and how do I fix it. > As you might notice it inserts across a link > I have had a loom at Metalink but wasn't able to locate anything > > Trigger code below > > create or replace trigger msf071_archibus_update > after update on msf071 > for each row > declare > -- local variables here > v_equip_number msf071.ENTITY_value%TYPE; > v_equip_class msf600.equip_class%TYPE; > v_attrib_value MSF6A4.Attrib_value%TYPE; > v_ref_value msf071.Ref_code%TYPE; > v_entity_type msf071.entity_type%TYPE; > > > > begin > > v_equip_number := :old.Entity_value; > v_entity_type := :old.entity_type; > v_ref_value := :new.ref_code; > IF v_ref_value = ('U') AND v_entity_type = 'EQP' THEN > > INSERT INTO [EMAIL PROTECTED] (equip_no, > dstrct_code, > NAME, > assoc_value, > equip_status, > active_flag, > parent_equip, > equip_classif_3, > sizecell, > sizem, > aream, > suburb, > postcode, > street_no, > street_name, > state) > SELECT c.equip_no, > dstrct_code, > c.item_name_1, > substr(h.assoc_rec, 1, 1), > equip_status, > active_flg, > parent_equip, > equip_classifx3, > to_number(d.attrib_value_num_9), > To_number(e.attrib_value_num_9) "SIZE", > to_number(f.attrib_value_num_9) "AREASQM", > substr(g.suburb, 1, 30), > substr(g.zip_code, 1, 4), > street_no, > substr((g.street_name|| ' ' || a.table_desc) > ,1,50)"STREET_TYPE", > substr(b.table_desc, 1, 30) "STATE" > FROM MSF600 c, view_MSF6a4_cellsize d, view_msf6a4_size e, > view_msf6a4_area f, MSF011 g, view_msf010_assoc_value h, > view_msf010_streettype a, view_msf010_state b > WHERE c.equip_no = v_equip_number AND > c.Equip_no = d.equip_no(+) AND > c.Equip_no = e.equip_no(+) AND > c.Equip_no = f.equip_no(+)AND > c.equip_class = h.table_code AND > c.location = g.location(+) AND > g.street_type = a.table_code(+) AND > g.state = b.table_code(+) ; > > /*end loop;*/ > > END IF; > > end msf071_archibus_update; > = > Peter McLarty E-mail: [EMAIL PROTECTED] -- 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). _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from t
RE: Inverse 9i Question
Trick question, they're not features, they're bugs! But seriously - without looking at your book - I guess c) > -Original Message- > From: Freeman Robert - IL [mailto:[EMAIL PROTECTED] > > Just in the mood to do one of these > Which of the following is *not* a feature of Oracle 9i? > > a. The ability to Rename a Column > b. The ability to Rename a Constraint > c. The ability to rename a tablespace > d. The ability to drop a column > e. The utl_xplan function to format execution plans from the > SQL prompt. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Inverse 9i Question
I think, it should c: (The ability to rename a tablespace). Thanks CP [EMAIL PROTECTED] wrote: Robert If I am not wrong..without looking at your book or any 9i doc...The answer is a. The ability to Rename a Column Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 13 Jun 2003 12:09:54 -0800 Just in the mood to do one of these Which of the following is *not* a feature of Oracle 9i? a. The ability to Rename a Column b. The ability to Rename a Constraint c. The ability to rename a tablespace d. The ability to drop a column e. The utl_xplan function to format execution plans from the SQL prompt. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with [EMAIL PROTECTED] http://shopnow.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: CP INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
report related
One of the developer here is trying to use global temp table for passing param to report from form. Now he is complaining that report if called using run_product doesn't see the values in table . My guess is report is creatiing another session . Does anybody here have any idea ? and how to avoid not creating another session but use the same sesssion during the course from rununig form to end of report . thanks, -ak
change a LMTS parameters
Hi all: Is there a way to change an extent size for a localy managed tablespace? Or do I have to create a new TS with a right extent size? I'm not finding it in a manual (so far) so if this is in RTFM please mention which exactly FM I should R :) thanks __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Inverse 9i Question
has been an option, just change it in ts$, bwahahaha justkidding newbies ;) Joe Jamadagni, Rajendra wrote: C) 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- From: Freeman Robert - IL [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 4:10 PM To: Multiple recipients of list ORACLE-L Subject: Inverse 9i Question Just in the mood to do one of these Which of the following is *not* a feature of Oracle 9i? a. The ability to Rename a Column b. The ability to Rename a Constraint c. The ability to rename a tablespace d. The ability to drop a column e. The utl_xplan function to format execution plans from the SQL prompt. 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.*2 -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the "CACHE" -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trigger double firing apparently double inserts
I have come across situation like this earlier. Looks like "at runtime" two rows are getting selected. create a dummy table and insert the key values/relevant values to see what "extra" row is being selected. HTH GovindanK > Hi Listers > > I have a trigger that is an on update trigger that is somehow writing two > records when a record is updated in the table that the trigger is > associated with. > I have run the select statement to see if it will retrieve multiple > records and the msf071 table that has the record that causes the trigger > to fire has only on record for the equip_no > Why does it do this and how do I fix it. > As you might notice it inserts across a link > I have had a loom at Metalink but wasn't able to locate anything > > Trigger code below > > create or replace trigger msf071_archibus_update > after update on msf071 > for each row > declare > -- local variables here > v_equip_number msf071.ENTITY_value%TYPE; > v_equip_class msf600.equip_class%TYPE; > v_attrib_value MSF6A4.Attrib_value%TYPE; > v_ref_value msf071.Ref_code%TYPE; > v_entity_type msf071.entity_type%TYPE; > > > > begin > > v_equip_number := :old.Entity_value; > v_entity_type := :old.entity_type; > v_ref_value := :new.ref_code; > IF v_ref_value = ('U') AND v_entity_type = 'EQP' THEN > > INSERT INTO [EMAIL PROTECTED] (equip_no, > dstrct_code, > NAME, > assoc_value, > equip_status, > active_flag, > parent_equip, > equip_classif_3, > sizecell, > sizem, > aream, > suburb, > postcode, > street_no, > street_name, > state) > SELECT c.equip_no, > dstrct_code, > c.item_name_1, > substr(h.assoc_rec, 1, 1), > equip_status, > active_flg, > parent_equip, > equip_classifx3, > to_number(d.attrib_value_num_9), > To_number(e.attrib_value_num_9) "SIZE", > to_number(f.attrib_value_num_9) "AREASQM", > substr(g.suburb, 1, 30), > substr(g.zip_code, 1, 4), > street_no, > substr((g.street_name|| ' ' || a.table_desc) > ,1,50)"STREET_TYPE", > substr(b.table_desc, 1, 30) "STATE" > FROM MSF600 c, view_MSF6a4_cellsize d, view_msf6a4_size e, > view_msf6a4_area f, MSF011 g, view_msf010_assoc_value h, > view_msf010_streettype a, view_msf010_state b > WHERE c.equip_no = v_equip_number AND > c.Equip_no = d.equip_no(+) AND > c.Equip_no = e.equip_no(+) AND > c.Equip_no = f.equip_no(+)AND > c.equip_class = h.table_code AND > c.location = g.location(+) AND > g.street_type = a.table_code(+) AND > g.state = b.table_code(+) ; > > /*end loop;*/ > > END IF; > > end msf071_archibus_update; > = > Peter McLarty E-mail: [EMAIL PROTECTED] -- 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: Inverse 9i Question
Robert If I am not wrong..without looking at your book or any 9i doc...The answer is a. The ability to Rename a Column Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 13 Jun 2003 12:09:54 -0800 Just in the mood to do one of these Which of the following is *not* a feature of Oracle 9i? a. The ability to Rename a Column b. The ability to Rename a Constraint c. The ability to rename a tablespace d. The ability to drop a column e. The utl_xplan function to format execution plans from the SQL prompt. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RedHat AS Dev edition
Title: RE: db file sequential read [WAS:wait event puzzler] Hallo list, I would like to play a little bit with RAC and decided to download RedHat AdvacedServer Dev Edition (in February there was a thread about this topic in the list ). The problem is that the link http://www.redhat.com/software/advancedserver/developer/ doesn't offer this "promotion" (60 USD)anymore. Is this offer really gone or am I missing sth ? Where could I find RH AS Dev Edition ? Any help will be appreciated. Milen Kulev
RE: Inverse 9i Question
Title: RE: Inverse 9i Question C) 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- From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]] Sent: Friday, June 13, 2003 4:10 PM To: Multiple recipients of list ORACLE-L Subject: Inverse 9i Question Just in the mood to do one of these Which of the following is *not* a feature of Oracle 9i? a. The ability to Rename a Column b. The ability to Rename a Constraint c. The ability to rename a tablespace d. The ability to drop a column e. The utl_xplan function to format execution plans from the SQL prompt. 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.*2
RE: Fragmentation ?
Aaah - now I understand. The LRU rule does not hold good once the Goddess applies her personal touch and 'accesses' these blocks (sorry - books) :) So they need to stay in the DB B(l)ock buffer cache as they now migrate to the MRU end of the cache chain... The blocks that do need to go out of the (book) cache are actually those that have been updated! Couldn't resist the rambling - it is Friday! John > -Original Message- > From: Rachel Carmichael [mailto:[EMAIL PROTECTED] > Sent: Friday, June 13, 2003 12:45 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Fragmentation ? > > > your wife's rule wouldn't work in my case... every few years (usually > less than 10 but on occasion 10 works too) I go on a "re-reading > spree". back to old friends, "comfort food" of books. > > I'd have to buy all new copies if I threw books out. > > I do, on rare occasion, get rid of books. My oracle books that tell me > how to tune Version 7 are one example :) > > --- Niall Litchfield <[EMAIL PROTECTED]> wrote: > > I worked with a really smart guy once whom I won't name for obvious > > reasons. He had previously worked for a software co that said "Our > > product includes an archive routine". It didn't, they never had to > > write > > one because hey disks held 3 times the storage for half the price > > before > > anyone wanted to archive anything - at which point you just bought > > some > > more storage. > > > > I also probably ought to include the ongoing marital dispute that I > > am > > having regarding books, my wife maintains that anything I haven't > > accessed for a decade could be disposed of (think Tolkien, > Donaldson, > > Asimov, Shakespeare, Auden). *I* maintain "well we could always buy > > another bookcase". Logic tends to dictate my wifes approach, > > management > > I feel confident would say "ah well doesn't cost much lets buy > > another > > bookcase". > > > > In summary Niall's 2nd rule states that "data always goes in but > > never > > comes out". It's parkinsons law for databases > > > > Niall > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > > Behalf Of Stephen Lee > > > Sent: 13 June 2003 18:45 > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: Fragmentation ? > > > > > > > > > > > > That's one thing good about the databases here. Tablespace > > > fragmentation is rarely a problem. Most of the database here > > > are a Database Roach Motel: "Data checks in. It doesn't > > > check out." Somehow, the data purge part of the application > > > -- that they intended to put in "one of these days" -- never > > > got written. > > > > > > > > > > > > (For non-USA dwellers, Roach Motel is a trap for roaches. It > > > has a sticky floor, and the sales motto is "Roaches check in. > > > They don't check out.") > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Stephen Lee > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting > services > > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > > and in the message BODY, include a line containing: UNSUB > > ORACLE-L (or the name of mailing list you want to be 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: Niall Litchfield > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- 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
Inverse 9i Question
Just in the mood to do one of these Which of the following is *not* a feature of Oracle 9i? a. The ability to Rename a Column b. The ability to Rename a Constraint c. The ability to rename a tablespace d. The ability to drop a column e. The utl_xplan function to format execution plans from the SQL prompt. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fragmentation ?
your wife's rule wouldn't work in my case... every few years (usually less than 10 but on occasion 10 works too) I go on a "re-reading spree". back to old friends, "comfort food" of books. I'd have to buy all new copies if I threw books out. I do, on rare occasion, get rid of books. My oracle books that tell me how to tune Version 7 are one example :) --- Niall Litchfield <[EMAIL PROTECTED]> wrote: > I worked with a really smart guy once whom I won't name for obvious > reasons. He had previously worked for a software co that said "Our > product includes an archive routine". It didn't, they never had to > write > one because hey disks held 3 times the storage for half the price > before > anyone wanted to archive anything - at which point you just bought > some > more storage. > > I also probably ought to include the ongoing marital dispute that I > am > having regarding books, my wife maintains that anything I haven't > accessed for a decade could be disposed of (think Tolkien, Donaldson, > Asimov, Shakespeare, Auden). *I* maintain "well we could always buy > another bookcase". Logic tends to dictate my wifes approach, > management > I feel confident would say "ah well doesn't cost much lets buy > another > bookcase". > > In summary Niall's 2nd rule states that "data always goes in but > never > comes out". It's parkinsons law for databases > > Niall > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Stephen Lee > > Sent: 13 June 2003 18:45 > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Fragmentation ? > > > > > > > > That's one thing good about the databases here. Tablespace > > fragmentation is rarely a problem. Most of the database here > > are a Database Roach Motel: "Data checks in. It doesn't > > check out." Somehow, the data purge part of the application > > -- that they intended to put in "one of these days" -- never > > got written. > > > > > > > > (For non-USA dwellers, Roach Motel is a trap for roaches. It > > has a sticky floor, and the sales motto is "Roaches check in. > > They don't check out.") > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Stephen Lee > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting > services > > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > > and in the message BODY, include a line containing: UNSUB > > ORACLE-L (or the name of mailing list you want to be 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: Niall Litchfield > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- 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: Want to BAARF - Recommendations for 10 36G Drive config
>At which point you will no doubt discover that your IO capacity was fine >and it was the damn data that was the issue. That can be simply resolved by certain truncate commands. :) > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Dave Phillips > Sent: 13 June 2003 16:26 > To: Multiple recipients of list ORACLE-L > Subject: Want to BAARF - Recommendations for 10 36G Drive config > > > A client runs our app with the following layout. Since their > intial 6 drive config they have procured more drives for a > total of 10 36Gig Drives. They have also upgraded memory from > 1 to 4 gig. I have the opportunity to recommend changes to > the current structure to improve performance. > So, any recommendations from the BAARF committee are welcome. > > Current System > > Ora 8.1.7 > Win 2k > Size 30Gig > Logical Array 1 - Raid 1 - OS and Oracle > Logical Array 2 - Raid 1 - App and Index TS > Logical Array 3 - Raid 5 - The rest (Data,Rbs,redo,etc) > > > > > David Phillips > Support DBA > BAARF member wanna-be > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Dave Phillips > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (or the name of mailing list you want to be 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: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SYS not able to GRANT -- Strange !
Yep, 9i allows sys to grant privs on objects in other schemas. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/12/2003 11:34 PM its always been that way, its not strange, sys has NEVER been able to grant privs on other owner's objects. i think that has changed in 9i but its late and my brain is fuzzy. joe Prem Khanna J wrote: >Guys, > >CONNECT SYS AS SYSDBA; > > create user testuser1 identified by testuser1 ; > grant connect, resource to testuser1; > > create user testuser2 identified by testuser2 ; > grant create session to testuser2; > > create table testuser1.table1 ( a int ) ; > > grant select on testuser1.table1 to testuser2; > error at line 1: > ora-01031: insufficient privileges > >WHERE AS : > > connect testuser1/testuser1; > > grant select on testuser1.table1 to testuser2; > > grant succeeded. > > >why is it so ? >why sys is not able to GRANT ? >seems to be strange ! > >the env. is 8.1.6.0./win2k. > >Jp. > > > > -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the "CACHE" -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: db file sequential read [WAS:wait event puzzler]
Title: RE: db file sequential read [WAS:wait event puzzler] A Wild guess ... are those people who want more than thirtycharacternamesfortablecolumn by any chance used to work with JAVA or VB? One of our developer complained here that the limit of 30 characters on procedure name was too small (he had landed in an Oracle shop from MS shop), so we gently hinted to him that "a column name is a column name, we have Microsoft Word installed to write position papers and technical memos" ... he was a good sport though .. that helped. 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- From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] Sent: Friday, June 13, 2003 2:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: db file sequential read [WAS:wait event puzzler] Clarifying: 1 - has been shown to be impossible. 2 - Most people on the list disagree with this. Even if someone wants to try it for testing it won't help you in production. 3 - Was a JOKE! 4 - True. 5 - True. 6 - True. 7 - True. Dangerous advice should always be accompanied by a ton of caveats. 8 - was a JOKE! 9 - good advice. Read The Fine Manual. Summary - updating the data dictionary directly means that Oracle will not support your database. Unless you're not paying for any support, nothing you do is worth that risk. Why is the limit 30 characters? It has always been that way. Who decided 30 characters when Oracle was first built? The answer is probably lost in the mists of time. Why is it still 30 characters? I am guessing because changing that size would cause millions of lines of code (Oracle software, third-party software, customer homegrown software) to have to be modified and there is not enough demand for Oracle to make that change. *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.*1
RE: Fragmentation ?
I worked with a really smart guy once whom I won't name for obvious reasons. He had previously worked for a software co that said "Our product includes an archive routine". It didn't, they never had to write one because hey disks held 3 times the storage for half the price before anyone wanted to archive anything - at which point you just bought some more storage. I also probably ought to include the ongoing marital dispute that I am having regarding books, my wife maintains that anything I haven't accessed for a decade could be disposed of (think Tolkien, Donaldson, Asimov, Shakespeare, Auden). *I* maintain "well we could always buy another bookcase". Logic tends to dictate my wifes approach, management I feel confident would say "ah well doesn't cost much lets buy another bookcase". In summary Niall's 2nd rule states that "data always goes in but never comes out". It's parkinsons law for databases Niall > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Stephen Lee > Sent: 13 June 2003 18:45 > To: Multiple recipients of list ORACLE-L > Subject: RE: Fragmentation ? > > > > That's one thing good about the databases here. Tablespace > fragmentation is rarely a problem. Most of the database here > are a Database Roach Motel: "Data checks in. It doesn't > check out." Somehow, the data purge part of the application > -- that they intended to put in "one of these days" -- never > got written. > > > > (For non-USA dwellers, Roach Motel is a trap for roaches. It > has a sticky floor, and the sales motto is "Roaches check in. > They don't check out.") > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephen Lee > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (or the name of mailing list you want to be 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: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ADO and bind variables (was RE: Performance improvement required :-))
This is interesting--if I use ADO with the ODBC provider (as the code does below), I get the same results. But if I use just ADO (that is, ms' OLE DB provider for oracle (MSDAORA.1)) then I don't get bind vars. (I'm doing INSERTs in my code, not SELECTs). I wonder if oracle's native OLE DB provider works any differently--I would bet that it does... Cheers, -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Friday, June 13, 2003 11:05 AM To: Multiple recipients of list ORACLE-L I'm sure you can. You should see it in an ODBC trace log, or you can use trace events on the database. Here's a really simplistic test I did to verify it. I ran this VB code that executes a really dumb query that could not have come from anywhere else - SELECT DUMMY FROM DUAL WHERE DUMMY = 'X' but passed 'X' as a bind variable Private Sub Form_Load() Dim conn1 As New ADODB.Connection Dim cmd1 As New ADODB.Command Dim rs1 As New ADODB.Recordset Dim STRSQLSTRING As String Dim param1 As New Parameter strConnect = "UID=produser;PWD=prodpass;DSN=WAREHOUSE;" STRSQLSTRING = "SELECT DUMMY FROM DUAL WHERE DUMMY = ?" With conn1 .ConnectionTimeout = 0 .CommandTimeout = 0 .CursorLocation = adUseClient .Mode = adModeRead .Open strConnect End With If Err.Number Then MsgBox Err.Number Exit Sub End If With cmd1 .ActiveConnection = conn1 .CommandText = STRSQLSTRING .CommandType = adCmdText Set param1 = .CreateParameter("DummyValue", adChar, adParamInput, 1, "X") param1.Value = "X" .Parameters.Append param1 Set rs1 = .Execute End With MsgBox rs1.Fields("DUMMY") End Sub Afterward, executed this on the database - SQL> select sql_text from v$sqlarea where sql_text like 'SELECT DUMMY %'; SQL_TEXT SELECT DUMMY FROM DUAL WHERE DUMMY = :1 It shows the parameter was definitely passed as a bind variable. Check out this document on Metalink - Retrieving Record Set from Stored Proc Using ADO and VB (SCR 782) It appears to have an example of passing a cursor back to a recordset, though I've never tried it. HTH. Beth -Original Message- Sent: Friday, June 13, 2003 1:20 PM To: Multiple recipients of list ORACLE-L > > Why can't you use bind variables? I thought using .Parameters method > (property?) of ADODB.Command would use bind variables. I thought it didn't. Any way of checking (other than to get the developers to try it? > > What function, and where can't you use it? > Stored Procedure type function (i.e. user-written) called from VB. 'Cos it's a Stored Procedure it will use bind variables, but you can't return a result set to VB. Craig -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle JMS
Hi All, I am an Oracle DBA/Developer.I want to start setting up and using Oracle JMS.How do I get started. I have a database Oracle EE 8.1.7.4.Do I have to install anything,how to configure for oracle jms? Any available documents that gives a tutorial on this .I have checked metalink and didn't find anything good. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Want to BAARF - Recommendations for 10 36G Drive config
I figure you have disks set out so Drive 1 + Drive 2 = OS Drive 2 + Drive 3 = Two tablespaces Drive 4 + 5 + 6 = Oracle Default Tablespaces. And you have bought 4 more disks. I "theorize", like test this to infinity and beyond, that changing this to the following will improve IO performance. Drive 1 + Drive 2 = OS Drive 3 + Drive 4 = swap + archive logs Drive 5 + Drive 6 (mirroring) Drive 7 + Drive 8 = oracle data files. Drive 9 + Drive 10 = redo logs. I.E. stick your data on raid 10,stick redo and archive on two separate mirror sets and separate swap from os. At which point you will no doubt discover that your IO capacity was fine and it was the damn data that was the issue. Niall > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Dave Phillips > Sent: 13 June 2003 16:26 > To: Multiple recipients of list ORACLE-L > Subject: Want to BAARF - Recommendations for 10 36G Drive config > > > A client runs our app with the following layout. Since their > intial 6 drive config they have procured more drives for a > total of 10 36Gig Drives. They have also upgraded memory from > 1 to 4 gig. I have the opportunity to recommend changes to > the current structure to improve performance. > So, any recommendations from the BAARF committee are welcome. > > Current System > > Ora 8.1.7 > Win 2k > Size 30Gig > Logical Array 1 - Raid 1 - OS and Oracle > Logical Array 2 - Raid 1 - App and Index TS > Logical Array 3 - Raid 5 - The rest (Data,Rbs,redo,etc) > > > > > David Phillips > Support DBA > BAARF member wanna-be > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Dave Phillips > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (or the name of mailing list you want to be 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: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: db file sequential read [WAS:wait event puzzler]
Clarifying: 1 - has been shown to be impossible. 2 - Most people on the list disagree with this. Even if someone wants to try it for testing it won't help you in production. 3 - Was a JOKE! 4 - True. 5 - True. 6 - True. 7 - True. Dangerous advice should always be accompanied by a ton of caveats. 8 - was a JOKE! 9 - good advice. Read The Fine Manual. Summary - updating the data dictionary directly means that Oracle will not support your database. Unless you're not paying for any support, nothing you do is worth that risk. Why is the limit 30 characters? It has always been that way. Who decided 30 characters when Oracle was first built? The answer is probably lost in the mists of time. Why is it still 30 characters? I am guessing because changing that size would cause millions of lines of code (Oracle software, third-party software, customer homegrown software) to have to be modified and there is not enough demand for Oracle to make that change. > -Original Message- > From: Bhaskar Viswanathan [mailto:[EMAIL PROTECTED] > > To sum up the suggestions: > > 1)You can modify col$.NAME to varchar2(60) and try.. > 2)I do agree with you. But some times we may need go beyond the > scopes. > For testing purpose we can do these kind of R&D's.(alterning the > col.Cname size) > Nothing wrong in this. > 3)That is a Very Good Idea... > We will do away with DDL Stmts will start writing directly into > the Data Dictionary ... > 4)Oracle does not support column names that are longer than 30 > characters. > This is a hard standard and can not be changed. > 5)Ur not supposed to Update Data Dictionaly Tables Directly ... > Oracle has A Limit of 30 Chrs and is Hardcoded.. So ReName your > Columns within 30 Chrs... > 6)Updating a data dictionary is simply not done. Remember, we're > the DBA (you will be assimilated) and not fun loving students > who can play with their alma mater's equipment. > Updating the data dictionary directly would cause the database > to lose support from > Oracle Corp. and the perpetrator would be liable. > 7)telling him to do a Update on COL$... He Ends up Doing that in > his Production Database.. > And he is going to be in a HOT soup > 8)Write a compress / decompress algorithm that will take your > 200-character table names from > the application and pass them to the database as <= 30 > characters; then uncompress them from > the database back to the application. > 9)references to DB naming conventions. > > I would want to go with the majority. "Do not Do it!!". > > But then, the problem is like, I cannot afford to shorten > names as there > are a lot of other problems which crops up. > Though right now, thatz what we do and which is what I am > attempting to > avoid. > Ofcourse, the suggestion to have an algo. translate the names > is a good > one, which is thought of and is the current > Decision. > > Whew!, if oralce supports more than 30 characters for column > names, life > would be easier. > > Can somebody explain in brief, why this is being restricted to 30 > characters? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: db file sequential read [WAS:wait event puzzler]
We should probably clarify this. 1 - has bee > -Original Message- > From: Bhaskar Viswanathan [mailto:[EMAIL PROTECTED] > Sent: vendredi, 13. juin 2003 00:29 > To: Multiple recipients of list ORACLE-L > Subject: RE: db file sequential read [WAS:wait event puzzler] > > > > Hi, > > Thanks to all for you responses. > > To sum up the suggestions: > > 1)You can modify col$.NAME to varchar2(60) and try.. > 2)I do agree with you. But some times we may need go beyond the > scopes. > For testing purpose we can do these kind of R&D's.(alterning the > col.Cname size) > Nothing wrong in this. > 3)That is a Very Good Idea... > We will do away with DDL Stmts will start writing directly into > the Data Dictionary ... > 4)Oracle does not support column names that are longer than 30 > characters. > This is a hard standard and can not be changed. > 5)Ur not supposed to Update Data Dictionaly Tables Directly ... > Oracle has A Limit of 30 Chrs and is Hardcoded.. So ReName your > Columns within 30 Chrs... > 6)Updating a data dictionary is simply not done. Remember, we're > the DBA (you will be assimilated) and not fun loving students > who can play with their alma mater's equipment. > Updating the data dictionary directly would cause the database > to lose support from > Oracle Corp. and the perpetrator would be liable. > 7)telling him to do a Update on COL$... He Ends up Doing that in > his Production Database.. > And he is going to be in a HOT soup > 8)Write a compress / decompress algorithm that will take your > 200-character table names from > the application and pass them to the database as <= 30 > characters; then uncompress them from > the database back to the application. > 9)references to DB naming conventions. > > I would want to go with the majority. "Do not Do it!!". > > But then, the problem is like, I cannot afford to shorten > names as there > are a lot of other problems which crops up. > Though right now, thatz what we do and which is what I am > attempting to > avoid. > Ofcourse, the suggestion to have an algo. translate the names > is a good > one, which is thought of and is the current > Decision. > > Whew!, if oralce supports more than 30 characters for column > names, life > would be easier. > > Can somebody explain in brief, why this is being restricted to 30 > characters? > > And once again, thanks a lot! > > Baski > > -Original Message- > Sent: Thursday, June 12, 2003 7:10 PM > To: Multiple recipients of list ORACLE-L > > > Modifying data dictionary tables is definitely not a good > idea and I > am sure Oracle will not support this. > > CP > > > [EMAIL PROTECTED] wrote: > > >Dear Bhaskar, > > > >You can modify col$.NAME to varchar2(60) and try. > > > >If this fails, I'll give a procedure you can use that to > change it to > >whatever size you want. > > > >Senthil Kumar > >Sr Oracle DBA > >Summitworks Technologies Pvt Ltd > > > >-Original Message- > >Bhaskar Viswanathan > >Sent: Thursday, June 12, 2003 4:00 PM > >To: Multiple recipients of list ORACLE-L > > > > > > > >hi, > > > >We use Oracle 8 DB. > > > >I am not a Oracle technical guy. So lemme try explaining the problem. > > > >We need to create tables with columns, whose names(column-names) are > >more than 30 characters long. This is being restricted because, all > >columns of all tables have entries in a table called 'col'. > >Thit table is defined as: > > > >SQL> desc col > > Name Null?Type > > - > > > > TNAME NOT NULL VARCHAR2(30) > > COLNO NOT NULL NUMBER > > CNAME NOT NULL VARCHAR2(30) > > COLTYPEVARCHAR2(106) > > WIDTH NOT NULL NUMBER > > SCALE NUMBER > > PRECISION NUMBER > > NULLS VARCHAR2(19) > > DEFAULTVAL LONG > > CHARACTER_SET_NAME VARCHAR2(44) > >SQL> > > > >since CNAME is defined as VARCHAR2(30), we are forced to > retrict column > > >names to a max of 30 characters long. > > > >For eg. create table T1(x31 > varchar2(50)); > >The above statement will be rejected with the error: > > * > >ERROR at line 1: > >ORA-00972: identifier is too long > > > >However, the statement "create table > T1(30 > >varchar2(50))" Succeeds in creating the table; > > > >I guess this table col is created by the system itself. how can we > >change this size So that the 30 character restriction in > colum
RE: Fragmentation ?
I think those guys work here now :-) -Original Message- Sent: Friday, June 13, 2003 1:45 PM To: Multiple recipients of list ORACLE-L That's one thing good about the databases here. Tablespace fragmentation is rarely a problem. Most of the database here are a Database Roach Motel: "Data checks in. It doesn't check out." Somehow, the data purge part of the application -- that they intended to put in "one of these days" -- never got written. (For non-USA dwellers, Roach Motel is a trap for roaches. It has a sticky floor, and the sales motto is "Roaches check in. They don't check out.") -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Query Tuning Question - new discovery
Title: RE: Query Tuning Question - new discovery A Ha ... it is refers to _B_TREE_BITMAP_PLANS variable ... it is true by default and what you see is the side effect. If you are not using BMI, set it to false. http://tinyurl.com/e8ws for more info 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- From: Meng, Dennis [mailto:[EMAIL PROTECTED]] Sent: Friday, June 13, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: Query Tuning Question - new discovery I did a sql trace and tkprof and here is the output. It looks like 'bitmap conversion to rowids' is the hogger. Anybody know what this implies? Should I try dropping and recreating the index as b-tree? We don't have an identical test system here so I need a 'warm and fuzzy' before doing that in our production. Dennis 0 SORT GROUP BY 0 NESTED LOOPS 0 NESTED LOOPS 0 NESTED LOOPS 0 HASH JOIN 0 HASH JOIN 7 INDEX RANGE SCAN (object id 44819) 0 NESTED LOOPS 156 NESTED LOOPS 9 HASH JOIN 2 TABLE ACCESS FULL REG_MGR 9 TABLE ACCESS FULL SHIPTO_SALESTYP 164 TABLE ACCESS BY INDEX ROWID CUST_SHIPTO 164 INDEX RANGE SCAN (object id 447931) 231 TABLE ACCESS BY INDEX ROWID INVC_LINE 1323618 BITMAP CONVERSION TO ROWIDS 346 BITMAP INDEX SINGLE VALUE 0 TABLE ACCESS FULL SALESREP_DTL 0 TABLE ACCESS BY INDEX ROWID MTL 0 INDEX UNIQUE SCAN (object id 46433) 0 TABLE ACCESS BY INDEX ROWID CUST_SOLDTO 0 INDEX UNIQUE SCAN (object id 89347) 0 TABLE ACCESS BY INDEX ROWID INVC_LINE_ATTRB 0 INDEX UNIQUE SCAN (object id 43441) -Original Message- Sent: Thursday, June 12, 2003 3:41 PM To: Multiple recipients of list ORACLE-L has anythign changed in the table? inserts, updates, deletes? if so considering doing a move on the table to rebuild it and possibly rebuilding the indexes in question. have you gather statistics lately? Is it using the same plan it was using a fwe weeks ago? > > From: "Meng, Dennis" <[EMAIL PROTECTED]> > Date: 2003/06/12 Thu PM 03:54:59 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Query Tuning Question > > Hi fellow DBAs, > This is kind of the follow-up of my last E-mail on wait event. > I have a query that is taking hours to complete and the plan looks ok. While one of the tables is huge (267mil rows) it is being accessed using one of its indexes. > I recorded some stats from v$session_wait while the query is running to see which segment is query is hanging up on and the result is the big table with 267mil rows. > Funny thing is, according to the user community, this query took only minutes to run couple of weeks ago. > What could be the cause of this wait? When index is being used, oracle will go directly to the data block and retrieve the data, which should be very efficient correct? > > > TIA > > Dennis > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Meng, Dennis INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Query Tuning Question - new discovery
not necessarily. can you post the lines immediately above those you've provided? (call, count, cpu, elapsed, etc.) > It looks like 'bitmap conversion to rowids' is the > hogger. Anybody know what this implies? Should I try > dropping and recreating the index as b-tree? We > don't have an identical test system here so I need a > 'warm and fuzzy' before doing that in our > production. > Dennis > > 0 SORT GROUP BY > 0 NESTED LOOPS > 0NESTED LOOPS > 0 NESTED LOOPS > 0 HASH JOIN > 0 HASH JOIN > 7INDEX RANGE SCAN (object id 44819) > 0NESTED LOOPS > 156 NESTED LOOPS > 9 HASH JOIN > 2 TABLE ACCESS FULL REG_MGR > 9 TABLE ACCESS FULL SHIPTO_SALESTYP > 164 TABLE ACCESS BY INDEX ROWID > CUST_SHIPTO > 164 INDEX RANGE SCAN (object id > 447931) > 231 TABLE ACCESS BY INDEX ROWID > INVC_LINE > 1323618 BITMAP CONVERSION TO ROWIDS > 346 BITMAP INDEX SINGLE VALUE > 0 TABLE ACCESS FULL SALESREP_DTL > 0 TABLE ACCESS BY INDEX ROWID MTL > 0 INDEX UNIQUE SCAN (object id 46433) > 0 TABLE ACCESS BY INDEX ROWID CUST_SOLDTO > 0 INDEX UNIQUE SCAN (object id 89347) > 0TABLE ACCESS BY INDEX ROWID > INVC_LINE_ATTRB > 0 INDEX UNIQUE SCAN (object id 43441) > > -Original Message- > Sent: Thursday, June 12, 2003 3:41 PM > To: Multiple recipients of list ORACLE-L > > > has anythign changed in the table? inserts, updates, > deletes? if so considering doing a move on the table > to rebuild it and possibly rebuilding the indexes in > question. > > have you gather statistics lately? Is it using the > same plan it was using a fwe weeks ago? > > > > > > From: "Meng, Dennis" <[EMAIL PROTECTED]> > > Date: 2003/06/12 Thu PM 03:54:59 EDT > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > Subject: Query Tuning Question > > > > Hi fellow DBAs, > > This is kind of the follow-up of my last E-mail on > wait event. > > I have a query that is taking hours to complete > and the plan looks ok. While one of the tables is > huge (267mil rows) it is being accessed using one of > its indexes. > > I recorded some stats from v$session_wait while > the query is running to see which segment is query > is hanging up on and the result is the big table > with 267mil rows. > > Funny thing is, according to the user community, > this query took only minutes to run couple of weeks > ago. > > What could be the cause of this wait? When index > is being used, oracle will go directly to the data > block and retrieve the data, which should be very > efficient correct? > > > > > > TIA > > > > Dennis > > > > > > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Meng, Dennis > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (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! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance improvement required :-)
I'm sure you can. You should see it in an ODBC trace log, or you can use trace events on the database. Here's a really simplistic test I did to verify it. I ran this VB code that executes a really dumb query that could not have come from anywhere else - SELECT DUMMY FROM DUAL WHERE DUMMY = 'X' but passed 'X' as a bind variable Private Sub Form_Load() Dim conn1 As New ADODB.Connection Dim cmd1 As New ADODB.Command Dim rs1 As New ADODB.Recordset Dim STRSQLSTRING As String Dim param1 As New Parameter strConnect = "UID=produser;PWD=prodpass;DSN=WAREHOUSE;" STRSQLSTRING = "SELECT DUMMY FROM DUAL WHERE DUMMY = ?" With conn1 .ConnectionTimeout = 0 .CommandTimeout = 0 .CursorLocation = adUseClient .Mode = adModeRead .Open strConnect End With If Err.Number Then MsgBox Err.Number Exit Sub End If With cmd1 .ActiveConnection = conn1 .CommandText = STRSQLSTRING .CommandType = adCmdText Set param1 = .CreateParameter("DummyValue", adChar, adParamInput, 1, "X") param1.Value = "X" .Parameters.Append param1 Set rs1 = .Execute End With MsgBox rs1.Fields("DUMMY") End Sub Afterward, executed this on the database - SQL> select sql_text from v$sqlarea where sql_text like 'SELECT DUMMY %'; SQL_TEXT SELECT DUMMY FROM DUAL WHERE DUMMY = :1 It shows the parameter was definitely passed as a bind variable. Check out this document on Metalink - Retrieving Record Set from Stored Proc Using ADO and VB (SCR 782) It appears to have an example of passing a cursor back to a recordset, though I've never tried it. HTH. Beth -Original Message- Sent: Friday, June 13, 2003 1:20 PM To: Multiple recipients of list ORACLE-L > > Why can't you use bind variables? I thought using .Parameters method > (property?) of ADODB.Command would use bind variables. I thought it didn't. Any way of checking (other than to get the developers to try it? > > What function, and where can't you use it? > Stored Procedure type function (i.e. user-written) called from VB. 'Cos it's a Stored Procedure it will use bind variables, but you can't return a result set to VB. Craig -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Want to BAARF - Recommendations for 10 36G Drive config
Put SQL Server files on RAID5, Oracle files on the good stuff. Then stand around and say "Well gosh, I guess that SQL Server is just crappy and slow." > -Original Message- > So, any recommendations from the BAARF committee are welcome. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance improvement required :-)
Using REFCURSOR you can return result set from stored procedure. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Craig Healey Sent: 13. júna 2003 12:20 To: Multiple recipients of list ORACLE-L > > Why can't you use bind variables? I thought using .Parameters method > (property?) of ADODB.Command would use bind variables. I thought it didn't. Any way of checking (other than to get the developers to try it? > > What function, and where can't you use it? > Stored Procedure type function (i.e. user-written) called from VB. 'Cos it's a Stored Procedure it will use bind variables, but you can't return a result set to VB. Craig ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Listener showing 2 service handlers for the same service
Naveen, Do you have local_listener set in your init.ora file? -Ravi. --- Naveen Nahata <[EMAIL PROTECTED]> wrote: > Hi All, > > When I start the listener, after sometimes the > instance registers itself with > the listener. After this the status of the listener > shows 2 service handlers > for the same service. > > For the sake of clarity I'm pasting the output and > listener.ora file. > > Initial Status: > --- > Services Summary... > PLSExtProchas 1 service handler(s) > The command completed successfully > > After instance registers itself: > > Services Summary... > PLSExtProchas 1 service handler(s) > salesnet has 2 service handler(s) > The command completed successfully > > listener.ora > - > SID_LIST_817_LISTENER = > (SID_LIST = > (SID_DESC = > (SID_NAME = PLSExtProc) > (ORACLE_HOME = F:\Oracle\Ora817) > (PROGRAM = extproc) > ) > ) > > 817_LISTENER = > (DESCRIPTION_LIST = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = > DT309-NaveenN)(PORT = 1521)) > ) > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) > ) > ) > ) > > Any help or pointers on what can be the issue? > > Regards > Naveen > > > > DISCLAIMER: > This message (including attachment if any) is > confidential and may be privileged. Before opening > attachments please check them for viruses and > defects. MindTree Consulting Private Limited > (MindTree) will not be responsible for any viruses > or defects or any forwarded attachments emanating > either from within MindTree or outside. If you have > received this message by mistake please notify the > sender by return e-mail and delete this message > from your system. Any unauthorized use or > dissemination of this message in whole or in part is > strictly prohibited. Please note that e-mails are > susceptible to change and MindTree shall not be > liable for any improper, untimely or incomplete > transmission. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Naveen Nahata > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (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! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ravi Kulkarni INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Fragmentation ?
That's one thing good about the databases here. Tablespace fragmentation is rarely a problem. Most of the database here are a Database Roach Motel: "Data checks in. It doesn't check out." Somehow, the data purge part of the application -- that they intended to put in "one of these days" -- never got written. (For non-USA dwellers, Roach Motel is a trap for roaches. It has a sticky floor, and the sales motto is "Roaches check in. They don't check out.") -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rebuilding MLOG tables
It looks like I must carefully go through all the replication stuff in the O'Reilly Oracle Built-in Packages and pick this stuff apart. This book puts the DBMS_REPCAT biz under Advanced Replication, so I have to see what differences there are (if any) and/or how applicable it is when doing simple snapshot replication -- which is what we have in this case. We have refresh groups on the clients, but since there is so much shuffling things around and changing things that goes on here, I really don't want to hard code any stuff in the script so it goes out to each client and tells them to lay low while I fiddle with the master. I guess I could have the script dig through dba_registered_snapshots to see what clients are out there, but geez, do I really have to make it that big of a chore? I'm trying to write a robust, reliably automated thing here. (What's the point in running Unix if you don't script all maintenance?) One of the Murphy's Law issues I was thinking about was: What if I don't do anything with the clients and one of them decides the best time to update a snapshot is exactly the same time the MLOG table is getting moved around (Well sure!)? Does that get handled gracefully; or does it get handled like a bug on the windshield of high speed car? There seems to be a dearth of info out there on the finer points of tidying up MLOG files. > -Original Message- > From: Arup Nanda [mailto:[EMAIL PROTECTED] > Sent: Friday, June 13, 2003 10:50 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Rebuilding MLOG tables > > > You are very welcome. > > I agree, Oracle must have had a wave of those PHBs in their > development side > each with their own trumpet to blow and each left his or her > legacy with a > new package. Otherwise why they cose to have so many of > these packages to > do a few simple, very correlated things beats me. Even though > I have been > doing replication for seven years now, I have a hard time > remembering which > package has what. > > As to the last part of your post (the question actually), you > always had to > create a master group and associate a refresh group to that. > The decision to > include which tables in a master group depends on the > relationship among the > tables and whether they must be refreshed in one shot to > maintain logical > integerity. But I almost always found it better to have a > group per a table. > > HTH. > > Arup Nanda > www.proligence.com > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, June 13, 2003 10:09 AM > > > > > > Didn't know about this one. Thanky thanky. > > > > So now we have dbms_refresh, dbms_repcat, and dbms_mview > (more?) each with > > its own bucket of procedures. It gives one the impression > that there is > > some significant developer turnover at Oracle with each new batch of > > programmers imposing their own ideas about things ought to done. > > > > I guess, for this to work, a master group (as opposed to a > refresh group > on > > the client) must be created, eh? > > > > > -Original Message- > > > > > > The safest and recommended way is to queisce the replication > > > master group by > > > > > > dbms_repcat.suspend_master_activity('GroupName'); > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Stephen Lee > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web > hosting services > > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be 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: Arup Nanda > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be 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 Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
how to hint a unique index scan?
Is there anyway to hint a specific type of scan? I know you can hint a fast full scan. I have something odd happening. I made a copy of a tablespace and transported that copy with in the same instance. So in the one instance. I have two copies of this tablespace. I have two tables that are 99% identical. IE one has about 1% more records and if you validate the indexes on each they are also less than 1% apart. Now in one tablespace an update does an Unique Scan and in the other the EXACT same update does a full scan and runs ALOT slower. I want to mess around. anyway to force a unique index scan? Both tables are analyzed. -- 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: Want to BAARF - Recommendations for 10 36G Drive config
With the limited number of drives, that you have, I'd at least: - move RBS from Raid5 onto first Raid1 (with OA and Oracle); - move redo from Raid5 onto second Raid1; - move Index TS back onto Raid5 Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Dave Phillips Sent: 13. júna 2003 10:26 To: Multiple recipients of list ORACLE-L A client runs our app with the following layout. Since their intial 6 drive config they have procured more drives for a total of 10 36Gig Drives. They have also upgraded memory from 1 to 4 gig. I have the opportunity to recommend changes to the current structure to improve performance. So, any recommendations from the BAARF committee are welcome. Current System Ora 8.1.7 Win 2k Size 30Gig Logical Array 1 - Raid 1 - OS and Oracle Logical Array 2 - Raid 1 - App and Index TS Logical Array 3 - Raid 5 - The rest (Data,Rbs,redo,etc) David Phillips Support DBA BAARF member wanna-be -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Phillips INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Performance improvement required :-)
> > Why can't you use bind variables? I thought using .Parameters method > (property?) of ADODB.Command would use bind variables. I thought it didn't. Any way of checking (other than to get the developers to try it? > > What function, and where can't you use it? > Stored Procedure type function (i.e. user-written) called from VB. 'Cos it's a Stored Procedure it will use bind variables, but you can't return a result set to VB. Craig ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Names
What do you need to know about EMC SANs? If I don't know the answer, I can probably point you in the right direction of who to talk to @ EMC. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Goulet, Dick > Sent: Friday, June 13, 2003 9:20 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Names > > > Dennis, > > Your welcome, Now if only I could get 10% of the > response on HP & EMC Sans that you got on Names!! > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Thursday, June 12, 2003 7:04 PM > To: Multiple recipients of list ORACLE-L > > > Jared, Brad, Jacques, Stephen, Thomas, Jose, Richard, Rich, > Mladen, Ravi, John, Gene, Dick, and anyone I left out. Thanks > very much for sharing the information on not only Oracle > Names but the other alternatives. You have given me a gold > mine of information to approach this issue. This list is > WONDERFUL!! Thanks everyone. >Even if we choose not to implement Names, it will give me > some incentive to study those chapters for the OCP Net > Administration module, which is the only one I have left. > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Thursday, June 12, 2003 2:42 PM > To: Multiple recipients of list ORACLE-L > > > Re pushing the tnsnames.ora out to desktops: > > I considered that, but there were too many versions of it out there, > and the users may have ODBC DSN' s dependent on the contents > of their tnsnames.ora. > > Re the share drive: Considered that too, but it's too easy > for net admins to re-arrange drives without advance warning. > ( it has happened ) > > I compromised. The tnsnames.ora stays on the desktops. > > The sqlnet.ora has this line: > > > NAMES.DIRECTORY_PATH = (ONAMES, TNSNAMES) > > so that their tnsnames will still work, but I can make > changes in the name servers without worrying about their > tnsnames files. > > Updating the names servers is pretty simple, and I don't have > to schedule a change to all the desktops. > > Works for me anyway. > > Jared > > > > > > Stephen Lee <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 06/12/2003 12:01 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: Oracle Names > > > > I never liked names, but that's just me. I thought keeping > the names servers up to date, and making sure every client > was configured to use the name servers, was a pain in the > butt. You can have multiple names servers to eliminate a > single point of failure. > > The method I liked the best was to have the PC admin people > push a new tnsnames.ora out to client machines using push > software. Let THEM fuss > with > it! > > Another method that works is to have the tnsnames.ora on a > share and stick > a > shortcut on the client desktop that will update the local > tnsnames.ora > when > the user clicks on it. > > > -Original Message- > > > > 1. Are any of you using the Oracle Names? > > 2. Is it as easy to configure as Oracle makes it sound, or is > > it difficult? > > 3. Is Names reasonably robust? I can see this as yet another > > single point of > > failure. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephen Lee > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (or the name of mailing list you want to be 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: http://www.orafaq.net > -- > Author: DENNIS WILLI
Re: standby archivelogs
Jim, Modify the parameter log_archive_dest_2 to "service=X optional reopen=300". Note the keyword "optional". This will ensure that even if the archive has not created the file at the standby location, the primary will not hang. HTH. Arup Nanda www.proligence.com - Original Message - From: Jim Neugebauer To: Multiple recipients of list ORACLE-L Sent: Friday, June 13, 2003 12:14 PM Subject: standby archivelogs I would like to pose a question to the group in hopes of saving some testing time. I am reconfiguring an 8.1.7 managed standby server after moving it to a new data center. The network link between the primary and standby is now 1/4 of what it used to be and I think this is going to be an issue. During periods of intense activity we can generate a LOT of archive logs very quickly. relevent parameters: log_archive_max_processes = 5log_archive_dest_1 = 'LOCATION=/oradata/xxx/arch MANDATORY REOPEN=120'log_archive_dest_2 = "service=X reopen=300"log_archive_min_succeed_dest = 1 my question is this.. will the primary database hang if all the redo logs are full and the archive process cannot keep up due to the slw network connection to the standby? i.e. will all 5 archive processes get tied up writing to the standby and be unavailable to archive local logs? do archivers give priority to local logs somehow? Is there a way to separate local archive processes vs. remote archive processes? I do not want to increase the number of archivers because this will only saturate the network more... Thanks! Jim Jim NeugebauerOracle DBAAmeritrade Holding Corp Do you Yahoo!?The New Yahoo! Search - Faster. Easier. Bingo.
RE: utl_file performance
Title: RE: utl_file performance John, http://tinyurl.com/e8d1 ... not much info there. But mostly performance cannot be general, because everyone's processign is different. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Friday, June 13, 2003 2:30 PM To: Multiple recipients of list ORACLE-L I am told that utl_file performance is improved under Oracle 9 . Does anyone have any comparisons of UTL_FILE performance between 8.1.7 and 9.2? John 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.*2
Re: Rebuilding MLOG tables
You are very welcome. I agree, Oracle must have had a wave of those PHBs in their development side each with their own trumpet to blow and each left his or her legacy with a new package. Otherwise why they cose to have so many of these packages to do a few simple, very correlated things beats me. Even though I have been doing replication for seven years now, I have a hard time remembering which package has what. As to the last part of your post (the question actually), you always had to create a master group and associate a refresh group to that. The decision to include which tables in a master group depends on the relationship among the tables and whether they must be refreshed in one shot to maintain logical integerity. But I almost always found it better to have a group per a table. HTH. Arup Nanda www.proligence.com - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 10:09 AM > > Didn't know about this one. Thanky thanky. > > So now we have dbms_refresh, dbms_repcat, and dbms_mview (more?) each with > its own bucket of procedures. It gives one the impression that there is > some significant developer turnover at Oracle with each new batch of > programmers imposing their own ideas about things ought to done. > > I guess, for this to work, a master group (as opposed to a refresh group on > the client) must be created, eh? > > > -Original Message- > > > > The safest and recommended way is to queisce the replication > > master group by > > > > dbms_repcat.suspend_master_activity('GroupName'); > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephen Lee > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be 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: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
standby archivelogs
I would like to pose a question to the group in hopes of saving some testing time. I am reconfiguring an 8.1.7 managed standby server after moving it to a new data center. The network link between the primary and standby is now 1/4 of what it used to be and I think this is going to be an issue. During periods of intense activity we can generate a LOT of archive logs very quickly. relevent parameters: log_archive_max_processes = 5log_archive_dest_1 = 'LOCATION=/oradata/xxx/arch MANDATORY REOPEN=120'log_archive_dest_2 = "service=X reopen=300"log_archive_min_succeed_dest = 1 my question is this.. will the primary database hang if all the redo logs are full and the archive process cannot keep up due to the slw network connection to the standby? i.e. will all 5 archive processes get tied up writing to the standby and be unavailable to archive local logs? do archivers give priority to local logs somehow? Is there a way to separate local archive processes vs. remote archive processes? I do not want to increase the number of archivers because this will only saturate the network more... Thanks! Jim Jim NeugebauerOracle DBAAmeritrade Holding Corp Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.
Re: Performance improvement required :-)
Just guessing, but it seems as if the longer initial run is because the data is being pulled into the buffers. After that the query is being answered without disk i/o. See if you can cache the table and if that gets rid of the initial long run. "Craig Healey" @hhsuk.com> cc: Sent by: Subject: Performance improvement required :-) ml-errors 06/13/2003 09:59 AM Please respond to ORACLE-L It's Friday, and I'm having a brain storm. Just to check: The developers are using ADO to connect to a VB application and want to pull back a record set. Using ADO means they can't use bind variables. Returning more than 1 record means they can't use a function (which WOULD use bind variables). Am I correct in saying that other than tuning the SQL (done that, it isn't a complex query) or playing around with Oracle session parameters, there isn't anything else I can do? (The query takes 1 second the first time it is run, but 10 ms after. It is used all the time in the callcentre to search postcodes.) TIA Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Fragmentation ?
Well said. For people that can only comprehend a simple solution, it is much more comfortable to have a single answer. The old "reorganize to a single extent" was always easy to understand. Along the way as a side-effect it cured other types of fragmentation, but if the underlying causes of the fragmentation are understood, then fewer reorganizations would be needed. The paper "Stop Defragmenting . . ." isn't one of those you can skim and then set aside. It needs to be intensively studied. LMT isn't completely foolproof, so you need to understand the underlying premises. As to the types of fragmentation, read the introduction. It explains which chapter discusses which type of fragmentation. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 13, 2003 9:15 AM To: Multiple recipients of list ORACLE-L there was a debate on here 2 weeks ago where it was concluded that until you get to thousands of extents it just doesnt matter how many you have. > > From: "VIVEK_SHARMA" <[EMAIL PROTECTED]> > Date: 2003/06/13 Fri AM 06:39:36 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Fragmentation ? > > Dennis , List > > What may be the OTHER forms of fragmentation ? > > What Number of Extents may be considered Critical warranting RE-Organization for Manually Sized Objects existing in LMTs ? > > Thanks for the great paper . Had read it previously though . > > Thanks > > > -Original Message- > Sent: Wednesday, June 11, 2003 8:25 PM > To: Multiple recipients of list ORACLE-L > > > Vivek >Make sure you've read "How to Stop Defragmenting and Start Living" > http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049 > The authors point out that uniform extents stop fragmentation at the > tablespace level. However they point out that there are other forms of > fragmentation. > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Wednesday, June 11, 2003 9:15 AM > To: Multiple recipients of list ORACLE-L > > > > Qs What is the advantage of having dba_tablespaces.ALLOCATION_TYPE = > "UNIFORM" OVER dba_tablespaces.ALLOCATION_TYPE = "USER" ? > > With ALLOCATION_TYPE = "UNIFORM" , NEXT_EXTENT Size of the Object can NOT be > Manually defined in the Table Creation Script )> , > which is allowed when having allocation_type="USER" . > > Allocation_type="USER" allows Objects with Different NEXT_EXTENT Sizes to be Created > in the SAME LOCALLY managed Tablespace & thus reduces Total Number of Extents for > the respective Table. Our Application does have Objects of Dissimilar Sizes > Existing tin the Same Tablespace . > > Does ALLOCATION_TYPE = "UNIFORM" automatically imply NO Fragmentation > Irrespective of the Number of Extents of the Object (in a Locally Managed > Tablespace) ? Does it further imply NO further need to Look at Number of > Extents of an Object in a Locally Managed Tablespace ? > > NOTE Allocation_type can be made = "USER" by using the stored procedures :- > dbms_space_admin.tablespace_migrate_from_local / > dbms_space_admin.tablespace_migrate_to_local > > Am i still Lost in the World of Oracle 7 ? > > Thanks > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be 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: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yours
RE: RE: Fragmentation ?
Title: RE: RE: Fragmentation ? Depends ... who you ask ... If you ask Microsoft 1. you are fragmented if you have at-least _one_ non-windows server in your corporation 2. Your thinking is fragmented if you are even _considering_ LINUX If you ask SCO 1. You are fragmented if you use AIX 2. You are fragmented if you read every line of GPL If you ask Oracle Experts 1. Some will say "Do you have a problem? if none, don't worry" 2. Some will say "More than x extents is bad" but X varies from 2 to 1024 to 4096 3. Some will advise use LMT with Uniform extents and live happily there after. I could think of some political ones, but this is a technical list ... TGIF 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 ! > > From: "VIVEK_SHARMA" <[EMAIL PROTECTED]> > Date: 2003/06/13 Fri AM 06:39:36 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Fragmentation ? > > Dennis , List > What may be the OTHER forms of fragmentation ? > What Number of Extents may be considered Critical warranting RE-Organization for Manually Sized Objects existing in LMTs ? > Thanks for the great paper . Had read it previously though . > Thanks > *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.*1
Want to BAARF - Recommendations for 10 36G Drive config
A client runs our app with the following layout. Since their intial 6 drive config they have procured more drives for a total of 10 36Gig Drives. They have also upgraded memory from 1 to 4 gig. I have the opportunity to recommend changes to the current structure to improve performance. So, any recommendations from the BAARF committee are welcome. Current System Ora 8.1.7 Win 2k Size 30Gig Logical Array 1 - Raid 1 - OS and Oracle Logical Array 2 - Raid 1 - App and Index TS Logical Array 3 - Raid 5 - The rest (Data,Rbs,redo,etc) David Phillips Support DBA BAARF member wanna-be -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dave Phillips INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: [SPAM:#] Re: SYS not able to GRANT -- Strange !
Sorry, I meant without having to do anything special... according to the docs it's a DBA account, so it might work with any account granted DBA. I haven't looked through the docs to see if there is a "grant all" privilege equivalent to "create any" etc... It might just be part of the kernel code I'm on 9.2 We skipped 9.0 entirely, mostly based on the reports I'd heard of all the problems. --- "MacGregor, Ian A." <[EMAIL PROTECTED]> wrote: > System can definitely grant privileges in another schema before 9. > It just takes some preparation. > > As system create a procedure in the other schema > > CREATE OR REPLACE procedure .grantit > (privilege in varchar2, object in varchar2, grantee in varchar2) is > begin > execute immediate ('grant ' ||privilege ||' on ' ||object ||' to ' > ||grantee); > end; > / > > Then as system invoke it as > > exec .grantit(, , ) > > This works beause the procedure runs under the security domain of > the "other user", and of course because system has the ability to > create and execute privileges in other schemas. > > Are you on 9.0.1 or 9.2? I thought the ability to do the granting > without using a procedure was available beginning with 9.2. > > Ian MacGregor > Stanford Linear Accelerator Center > [EMAIL PROTECTED] > > -Original Message- > Sent: Friday, June 13, 2003 3:55 AM > To: Multiple recipients of list ORACLE-L > > > haven't tried it with SYS but in 9i SYSTEM (maybe any account with > DBA privs -- have to try it) can definitely grant privileges on other > owner's objects. > > Makes my scripts that have to pass through a hosting company easy > now... they have the system password, and I don't have to tell anyone > the schema owner password > > Rachel > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- 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: Performance improvement required :-)
Title: RE: Performance improvement required :-) Craig, any query when run first time will take more time, because it has to do _all_ the work, i.e. do physical reads. Subsequent executions usually benefit from finding the required data blocks in buffer cache, thus minimizing physical reads and hence may be faster. Nothing wrong with that. 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- From: Craig Healey [mailto:[EMAIL PROTECTED]] Sent: Friday, June 13, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Subject: Performance improvement required :-) It's Friday, and I'm having a brain storm. Just to check: The developers are using ADO to connect to a VB application and want to pull back a record set. Using ADO means they can't use bind variables. Returning more than 1 record means they can't use a function (which WOULD use bind variables). Am I correct in saying that other than tuning the SQL (done that, it isn't a complex query) or playing around with Oracle session parameters, there isn't anything else I can do? (The query takes 1 second the first time it is run, but 10 ms after. It is used all the time in the callcentre to search postcodes.) TIA Craig Healey 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.*2
RE: utl_file performance
I thought question was about performance comparison... Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Regis Biassala Sent: 13. júna 2003 9:09 To: Multiple recipients of list ORACLE-L You could do alter session set UTL_FILE_DIR for instancebut the ora docs has it all -Original Message- Sent: Friday, June 13, 2003 2:30 PM To: Multiple recipients of list ORACLE-L I am told that utl_file performance is improved under Oracle 9 . Does anyone have any comparisons of UTL_FILE performance between 8.1.7 and 9.2? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible. This footnote also confirms that this message has been swept for computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Regis Biassala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Query Tuning Question - new discovery
I did a sql trace and tkprof and here is the output. It looks like 'bitmap conversion to rowids' is the hogger. Anybody know what this implies? Should I try dropping and recreating the index as b-tree? We don't have an identical test system here so I need a 'warm and fuzzy' before doing that in our production. Dennis 0 SORT GROUP BY 0 NESTED LOOPS 0NESTED LOOPS 0 NESTED LOOPS 0 HASH JOIN 0 HASH JOIN 7INDEX RANGE SCAN (object id 44819) 0NESTED LOOPS 156 NESTED LOOPS 9 HASH JOIN 2 TABLE ACCESS FULL REG_MGR 9 TABLE ACCESS FULL SHIPTO_SALESTYP 164 TABLE ACCESS BY INDEX ROWID CUST_SHIPTO 164 INDEX RANGE SCAN (object id 447931) 231 TABLE ACCESS BY INDEX ROWID INVC_LINE 1323618 BITMAP CONVERSION TO ROWIDS 346 BITMAP INDEX SINGLE VALUE 0 TABLE ACCESS FULL SALESREP_DTL 0 TABLE ACCESS BY INDEX ROWID MTL 0 INDEX UNIQUE SCAN (object id 46433) 0 TABLE ACCESS BY INDEX ROWID CUST_SOLDTO 0 INDEX UNIQUE SCAN (object id 89347) 0TABLE ACCESS BY INDEX ROWID INVC_LINE_ATTRB 0 INDEX UNIQUE SCAN (object id 43441) -Original Message- Sent: Thursday, June 12, 2003 3:41 PM To: Multiple recipients of list ORACLE-L has anythign changed in the table? inserts, updates, deletes? if so considering doing a move on the table to rebuild it and possibly rebuilding the indexes in question. have you gather statistics lately? Is it using the same plan it was using a fwe weeks ago? > > From: "Meng, Dennis" <[EMAIL PROTECTED]> > Date: 2003/06/12 Thu PM 03:54:59 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Query Tuning Question > > Hi fellow DBAs, > This is kind of the follow-up of my last E-mail on wait event. > I have a query that is taking hours to complete and the plan looks ok. While one of > the tables is huge (267mil rows) it is being accessed using one of its indexes. > I recorded some stats from v$session_wait while the query is running to see which > segment is query is hanging up on and the result is the big table with 267mil rows. > Funny thing is, according to the user community, this query took only minutes to run > couple of weeks ago. > What could be the cause of this wait? When index is being used, oracle will go > directly to the data block and retrieve the data, which should be very efficient > correct? > > > TIA > > Dennis > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Meng, Dennis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: World premier performance of the BAARF party logo
Title: RE: World premier performance of the BAARF party logo Nice going there Dan, After reading this 'Free/Four/Five ...' stuff only thing that comes to my mind is ... 'What the F..ive'? or maybe someone can be insulted by calling them 'you-raid-five-loving-zealot' ... TGIF 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- From: Daniel W. Fink [mailto:[EMAIL PROTECTED]] Sent: Friday, June 13, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Subject: Re: World premier performance of the BAARF party logo Mogens, As a futuristic thinker, I challenge you to go beyond todays technology and consider what the next millenium may bring. While it is all good and well to be against RAID-Free/Four/Five, we should also issue a policy statement against the newer, though not currently production ready, configurations listed below. RAID-Firteen/Fourteen/Fifteen, Free hundred through Five hundred ninety nine (inclusive), Free thousand through Five thousand nine hundred ninety nine (inclusive) and all RAIDS that are powers of Free/Four/Five. Dan *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.*1
RE: Performance improvement required :-)
Why can't you use bind variables? I thought using .Parameters method (property?) of ADODB.Command would use bind variables. What function, and where can't you use it? -Original Message- Sent: Friday, June 13, 2003 9:59 AM To: Multiple recipients of list ORACLE-L It's Friday, and I'm having a brain storm. Just to check: The developers are using ADO to connect to a VB application and want to pull back a record set. Using ADO means they can't use bind variables. Returning more than 1 record means they can't use a function (which WOULD use bind variables). Am I correct in saying that other than tuning the SQL (done that, it isn't a complex query) or playing around with Oracle session parameters, there isn't anything else I can do? (The query takes 1 second the first time it is run, but 10 ms after. It is used all the time in the callcentre to search postcodes.) TIA Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Names
Now, what do you want to now about HP & EMC? Oxford is running 8.1.7.1.0 on HP-UX 11 (4x9000/N, OPS) and our disks are on EMC. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 13, 2003 10:20 AM To: Multiple recipients of list ORACLE-L Dennis, Your welcome, Now if only I could get 10% of the response on HP & EMC Sans that you got on Names!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, June 12, 2003 7:04 PM To: Multiple recipients of list ORACLE-L Jared, Brad, Jacques, Stephen, Thomas, Jose, Richard, Rich, Mladen, Ravi, John, Gene, Dick, and anyone I left out. Thanks very much for sharing the information on not only Oracle Names but the other alternatives. You have given me a gold mine of information to approach this issue. This list is WONDERFUL!! Thanks everyone. Even if we choose not to implement Names, it will give me some incentive to study those chapters for the OCP Net Administration module, which is the only one I have left. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 12, 2003 2:42 PM To: Multiple recipients of list ORACLE-L Re pushing the tnsnames.ora out to desktops: I considered that, but there were too many versions of it out there, and the users may have ODBC DSN' s dependent on the contents of their tnsnames.ora. Re the share drive: Considered that too, but it's too easy for net admins to re-arrange drives without advance warning. ( it has happened ) I compromised. The tnsnames.ora stays on the desktops. The sqlnet.ora has this line: NAMES.DIRECTORY_PATH = (ONAMES, TNSNAMES) so that their tnsnames will still work, but I can make changes in the name servers without worrying about their tnsnames files. Updating the names servers is pretty simple, and I don't have to schedule a change to all the desktops. Works for me anyway. Jared Stephen Lee <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/12/2003 12:01 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Oracle Names I never liked names, but that's just me. I thought keeping the names servers up to date, and making sure every client was configured to use the name servers, was a pain in the butt. You can have multiple names servers to eliminate a single point of failure. The method I liked the best was to have the PC admin people push a new tnsnames.ora out to client machines using push software. Let THEM fuss with it! Another method that works is to have the tnsnames.ora on a share and stick a shortcut on the client desktop that will update the local tnsnames.ora when the user clicks on it. > -Original Message- > > 1. Are any of you using the Oracle Names? > 2. Is it as easy to configure as Oracle makes it sound, or is > it difficult? > 3. Is Names reasonably robust? I can see this as yet another > single point of > failure. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: 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 co
RE: Rebuilding MLOG tables
Mebbe this has something to do with the implicit commit stuff associated with DDL (iirc)? I keep coming back to what Einstein said (I think it was him): Education is what is left over after you have forgotten everything you have learned. (quote might not be exactly correct) > -Original Message- > > IIRC you need to lock the parent table in one session and > then do whatever > you need to do to the mlog table in a SECOND session > (because, as another > poster pointed out, the lock will be released too soon otherwise). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mail delivery problem
Try Unsubscribing and Subscribing again. Might help. Govindan > I'm getting all the fatcity mails twice. > > Y is like this??? strange > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Senthil Kumar D > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be 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: [SPAM:#] Re: SYS not able to GRANT -- Strange !
System can definitely grant privileges in another schema before 9. It just takes some preparation. As system create a procedure in the other schema CREATE OR REPLACE procedure .grantit (privilege in varchar2, object in varchar2, grantee in varchar2) is begin execute immediate ('grant ' ||privilege ||' on ' ||object ||' to ' ||grantee); end; / Then as system invoke it as exec .grantit(, , ) This works beause the procedure runs under the security domain of the "other user", and of course because system has the ability to create and execute privileges in other schemas. Are you on 9.0.1 or 9.2? I thought the ability to do the granting without using a procedure was available beginning with 9.2. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, June 13, 2003 3:55 AM To: Multiple recipients of list ORACLE-L haven't tried it with SYS but in 9i SYSTEM (maybe any account with DBA privs -- have to try it) can definitely grant privileges on other owner's objects. Makes my scripts that have to pass through a hosting company easy now... they have the system password, and I don't have to tell anyone the schema owner password Rachel --- Joe Testa <[EMAIL PROTECTED]> wrote: > its always been that way, its not strange, sys has NEVER been able to > grant privs on other owner's objects. > > i think that has changed in 9i but its late and my brain is fuzzy. > > joe > > > Prem Khanna J wrote: > > >Guys, > > > >CONNECT SYS AS SYSDBA; > > > > create user testuser1 identified by testuser1 ; > > grant connect, resource to testuser1; > > > > create user testuser2 identified by testuser2 ; > > grant create session to testuser2; > > > > create table testuser1.table1 ( a int ) ; > > > > grant select on testuser1.table1 to testuser2; > > error at line 1: > > ora-01031: insufficient privileges > > > >WHERE AS : > > > > connect testuser1/testuser1; > > > > grant select on testuser1.table1 to testuser2; > > > > grant succeeded. > > > > > >why is it so ? > >why sys is not able to GRANT ? > >seems to be strange ! > > > >the env. is 8.1.6.0./win2k. > > > >Jp. > > > > > > > > > > -- > Joseph S Testa > Chief Technology Officer > Data Management Consulting > 614-791-9000 > It's all about the "CACHE" > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Joe Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Performance improvement required :-)
It's Friday, and I'm having a brain storm. Just to check: The developers are using ADO to connect to a VB application and want to pull back a record set. Using ADO means they can't use bind variables. Returning more than 1 record means they can't use a function (which WOULD use bind variables). Am I correct in saying that other than tuning the SQL (done that, it isn't a complex query) or playing around with Oracle session parameters, there isn't anything else I can do? (The query takes 1 second the first time it is run, but 10 ms after. It is used all the time in the callcentre to search postcodes.) TIA Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: db file sequential read [WAS:wait event puzzler]
Oh no! I was just kidding! OK how about this one: This will not work for columns, but let's say you need to have table names that exceed 30 characters but do not exceed 61 characters. If you don't mind a '.' in the name, then you can have table names like EENY_MEENY_MINEY_MOE_CATCH.WHATEVER_BY_THE_TOE_YEEHAAA And all you have to do is create a database user for whatever is in front the dot. Now, you can have a 100% Dilbert approved database. > -Original Message- > Ofcourse, the suggestion to have an algo. translate the names > is a good > one, which is thought of and is the current > Decision. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Names
Dennis, Your welcome, Now if only I could get 10% of the response on HP & EMC Sans that you got on Names!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, June 12, 2003 7:04 PM To: Multiple recipients of list ORACLE-L Jared, Brad, Jacques, Stephen, Thomas, Jose, Richard, Rich, Mladen, Ravi, John, Gene, Dick, and anyone I left out. Thanks very much for sharing the information on not only Oracle Names but the other alternatives. You have given me a gold mine of information to approach this issue. This list is WONDERFUL!! Thanks everyone. Even if we choose not to implement Names, it will give me some incentive to study those chapters for the OCP Net Administration module, which is the only one I have left. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 12, 2003 2:42 PM To: Multiple recipients of list ORACLE-L Re pushing the tnsnames.ora out to desktops: I considered that, but there were too many versions of it out there, and the users may have ODBC DSN' s dependent on the contents of their tnsnames.ora. Re the share drive: Considered that too, but it's too easy for net admins to re-arrange drives without advance warning. ( it has happened ) I compromised. The tnsnames.ora stays on the desktops. The sqlnet.ora has this line: NAMES.DIRECTORY_PATH = (ONAMES, TNSNAMES) so that their tnsnames will still work, but I can make changes in the name servers without worrying about their tnsnames files. Updating the names servers is pretty simple, and I don't have to schedule a change to all the desktops. Works for me anyway. Jared Stephen Lee <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/12/2003 12:01 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Oracle Names I never liked names, but that's just me. I thought keeping the names servers up to date, and making sure every client was configured to use the name servers, was a pain in the butt. You can have multiple names servers to eliminate a single point of failure. The method I liked the best was to have the PC admin people push a new tnsnames.ora out to client machines using push software. Let THEM fuss with it! Another method that works is to have the tnsnames.ora on a share and stick a shortcut on the client desktop that will update the local tnsnames.ora when the user clicks on it. > -Original Message- > > 1. Are any of you using the Oracle Names? > 2. Is it as easy to configure as Oracle makes it sound, or is > it difficult? > 3. Is Names reasonably robust? I can see this as yet another > single point of > failure. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Rebuilding MLOG tables
Didn't know about this one. Thanky thanky. So now we have dbms_refresh, dbms_repcat, and dbms_mview (more?) each with its own bucket of procedures. It gives one the impression that there is some significant developer turnover at Oracle with each new batch of programmers imposing their own ideas about things ought to done. I guess, for this to work, a master group (as opposed to a refresh group on the client) must be created, eh? > -Original Message- > > The safest and recommended way is to queisce the replication > master group by > > dbms_repcat.suspend_master_activity('GroupName'); > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Fragmentation ?
there was a debate on here 2 weeks ago where it was concluded that until you get to thousands of extents it just doesnt matter how many you have. > > From: "VIVEK_SHARMA" <[EMAIL PROTECTED]> > Date: 2003/06/13 Fri AM 06:39:36 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: Fragmentation ? > > Dennis , List > > What may be the OTHER forms of fragmentation ? > > What Number of Extents may be considered Critical warranting RE-Organization for > Manually Sized Objects existing in LMTs ? > > Thanks for the great paper . Had read it previously though . > > Thanks > > > -Original Message- > Sent: Wednesday, June 11, 2003 8:25 PM > To: Multiple recipients of list ORACLE-L > > > Vivek >Make sure you've read "How to Stop Defragmenting and Start Living" > http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049 > The authors point out that uniform extents stop fragmentation at the > tablespace level. However they point out that there are other forms of > fragmentation. > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Wednesday, June 11, 2003 9:15 AM > To: Multiple recipients of list ORACLE-L > > > > Qs What is the advantage of having dba_tablespaces.ALLOCATION_TYPE = > "UNIFORM" OVER dba_tablespaces.ALLOCATION_TYPE = "USER" ? > > With ALLOCATION_TYPE = "UNIFORM" , NEXT_EXTENT Size of the Object can NOT be > Manually defined in the Table Creation Script )> , > which is allowed when having allocation_type="USER" . > > Allocation_type="USER" allows Objects with Different NEXT_EXTENT Sizes to be Created > in the SAME LOCALLY managed Tablespace & thus reduces Total Number of Extents for > the respective Table. Our Application does have Objects of Dissimilar Sizes > Existing tin the Same Tablespace . > > Does ALLOCATION_TYPE = "UNIFORM" automatically imply NO Fragmentation > Irrespective of the Number of Extents of the Object (in a Locally Managed > Tablespace) ? Does it further imply NO further need to Look at Number of > Extents of an Object in a Locally Managed Tablespace ? > > NOTE Allocation_type can be made = "USER" by using the stored procedures :- > dbms_space_admin.tablespace_migrate_from_local / > dbms_space_admin.tablespace_migrate_to_local > > Am i still Lost in the World of Oracle 7 ? > > Thanks > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be 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: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you wa
utl_file performance
I am told that utl_file performance is improved under Oracle 9 . Does anyone have any comparisons of UTL_FILE performance between 8.1.7 and 9.2? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: utl_file performance
You could do alter session set UTL_FILE_DIR for instancebut the ora docs has it all -Original Message- Sent: Friday, June 13, 2003 2:30 PM To: Multiple recipients of list ORACLE-L I am told that utl_file performance is improved under Oracle 9 . Does anyone have any comparisons of UTL_FILE performance between 8.1.7 and 9.2? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible. This footnote also confirms that this message has been swept for computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Regis Biassala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: World premier performance of the BAARF party logo
Mogens, As a futuristic thinker, I challenge you to go beyond todays technology and consider what the next millenium may bring. While it is all good and well to be against RAID-Free/Four/Five, we should also issue a policy statement against the newer, though not currently production ready, configurations listed below. RAID-Firteen/Fourteen/Fifteen, Free hundred through Five hundred ninety nine (inclusive), Free thousand through Five thousand nine hundred ninety nine (inclusive) and all RAIDS that are powers of Free/Four/Five. Dan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SYS not able to GRANT -- Strange !
At least it cannot until 9.2: $ sqlplus / SQL*Plus: Release 9.2.0.3.0 - Production on Fri Jun 13 07:55:40 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production With the Partitioning option JServer Release 9.2.0.3.0 - Production SQL> SQL> SQL> grant select on scott.emp to public; Grant succeeded. SQL> On 2003.06.13 06:20, Hemant K Chitale wrote: No user, not even SYS, can grant on another user's objects. You have two options 1. Login as the owner of the object on which grants are to be provided and provide the grants 2. Create a grants package[which can give grants on specified objects] in the owner's schema, grant execute on that package to SYS or whichever DBA account you use and then use the package from SYS or the DBA account. The package runs in Owner's Rights ! Hemant --- Prem Khanna J <[EMAIL PROTECTED]> wrote: > Guys, > > CONNECT SYS AS SYSDBA; > >create user testuser1 identified by testuser1 ; >grant connect, resource to testuser1; > >create user testuser2 identified by testuser2 ; >grant create session to testuser2; > >create table testuser1.table1 ( a int ) ; > >grant select on testuser1.table1 to testuser2; >error at line 1: >ora-01031: insufficient privileges > > WHERE AS : > >connect testuser1/testuser1; > >grant select on testuser1.table1 to testuser2; > >grant succeeded. > > > why is it so ? > why sys is not able to GRANT ? > seems to be strange ! > > the env. is 8.1.6.0./win2k. > > Jp. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Prem Khanna J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting > services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like > subscribing). > Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SYS not able to GRANT -- Strange !
Try granting to sys with grant option SQL> create user t1 identified by t1 quota unlimited on users; User created. SQL> create user t2 identified by t2; User created. SQL> grant connect to t1; Grant succeeded. SQL> grant connect to t2; Grant succeeded. SQL> SQL> create table t1.firsttab(col1 varchar2(10)) tablespace users; Table created. SQL> insert into t1.firsttab values('somedata'); 1 row created. SQL> SQL> connect t1/t1; Connected. SQL> GRANT SELECT ON T1.FIRSTTAB TO SYS WITH GRANT OPTION; Grant succeeded. SQL> SQL> connect sys/password; Connected. SQL> SQL> grant select on t1.firsttab to t2; Grant succeeded. SQL> connect t2/t2 Connected. SQL> select * from t1.firsttab; COL1 -- somedata 1 row selected. >>> [EMAIL PROTECTED] 06/13/03 05:20AM >>> No user, not even SYS, can grant on another user's objects. You have two options 1. Login as the owner of the object on which grants are to be provided and provide the grants 2. Create a grants package[which can give grants on specified objects] in the owner's schema, grant execute on that package to SYS or whichever DBA account you use and then use the package from SYS or the DBA account. The package runs in Owner's Rights ! Hemant --- Prem Khanna J <[EMAIL PROTECTED]> wrote: > Guys, > > CONNECT SYS AS SYSDBA; > > create user testuser1 identified by testuser1 ; > grant connect, resource to testuser1; > > create user testuser2 identified by testuser2 ; > grant create session to testuser2; > > create table testuser1.table1 ( a int ) ; > > grant select on testuser1.table1 to testuser2; > error at line 1: > ora-01031: insufficient privileges > > WHERE AS : > > connect testuser1/testuser1; > > grant select on testuser1.table1 to testuser2; > > grant succeeded. > > > why is it so ? > why sys is not able to GRANT ? > seems to be strange ! > > the env. is 8.1.6.0./win2k. > > Jp. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Prem Khanna J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting > services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like > subscribing). > Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Single Block Read
Naveen: Table Access by INDEX ROWID Best Regards, K Gopalakrishnan -Original Message- Naveen Nahata Sent: Friday, June 13, 2003 3:21 AM To: Multiple recipients of list ORACLE-L > -Original Message- > From: K Gopalakrishnan [mailto:[EMAIL PROTECTED] > > Starting from 8i the db file sequential read is always a single block > read which TYPICALLY happens during index scans.. > > K Gopalakrishnan KG, What are the scenarios other than index scans when a single block read can happen (>8i as you said) and hence "db file sequential read" be reported? Regards Naveen DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: db file sequential read [WAS:wait event puzzler]
Hi, Finally our group concluded this is not possible, let it as it is. But it is possible by cheating the oracle kernel. So let me take a back. :-)) Senthil -Original Message- Naveen Nahata Sent: Friday, June 13, 2003 3:50 PM To: Multiple recipients of list ORACLE-L Senthil, Could you please send me the script which can modify col$.NAME? I tried this (of course on a trashable DB) but it doesn't work, and as far as my understanding goes(looking at the error), "NOTHING" can make it work. Following is the error I get in 8.1.7.0.0 SQL> alter table col$ modify name varchar2(60); alter table col$ modify name varchar2(60) * ERROR at line 1: ORA-00701: object necessary for warmstarting database cannot be altered Regards Naveen DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Senthil Kumar D INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Single Block Read
> -Original Message- > From: K Gopalakrishnan [mailto:[EMAIL PROTECTED] > > Starting from 8i the db file sequential read is always a single block > read which TYPICALLY happens during index scans.. > > K Gopalakrishnan KG, What are the scenarios other than index scans when a single block read can happen (>8i as you said) and hence "db file sequential read" be reported? Regards Naveen DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SYS not able to GRANT -- Strange !
haven't tried it with SYS but in 9i SYSTEM (maybe any account with DBA privs -- have to try it) can definitely grant privileges on other owner's objects. Makes my scripts that have to pass through a hosting company easy now... they have the system password, and I don't have to tell anyone the schema owner password Rachel --- Joe Testa <[EMAIL PROTECTED]> wrote: > its always been that way, its not strange, sys has NEVER been able to > grant privs on other owner's objects. > > i think that has changed in 9i but its late and my brain is fuzzy. > > joe > > > Prem Khanna J wrote: > > >Guys, > > > >CONNECT SYS AS SYSDBA; > > > > create user testuser1 identified by testuser1 ; > > grant connect, resource to testuser1; > > > > create user testuser2 identified by testuser2 ; > > grant create session to testuser2; > > > > create table testuser1.table1 ( a int ) ; > > > > grant select on testuser1.table1 to testuser2; > > error at line 1: > > ora-01031: insufficient privileges > > > >WHERE AS : > > > > connect testuser1/testuser1; > > > > grant select on testuser1.table1 to testuser2; > > > > grant succeeded. > > > > > >why is it so ? > >why sys is not able to GRANT ? > >seems to be strange ! > > > >the env. is 8.1.6.0./win2k. > > > >Jp. > > > > > > > > > > -- > Joseph S Testa > Chief Technology Officer > Data Management Consulting > 614-791-9000 > It's all about the "CACHE" > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Joe Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- 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: SYS not able to GRANT -- Strange !
No user, not even SYS, can grant on another user's objects. You have two options 1. Login as the owner of the object on which grants are to be provided and provide the grants 2. Create a grants package[which can give grants on specified objects] in the owner's schema, grant execute on that package to SYS or whichever DBA account you use and then use the package from SYS or the DBA account. The package runs in Owner's Rights ! Hemant --- Prem Khanna J <[EMAIL PROTECTED]> wrote: > Guys, > > CONNECT SYS AS SYSDBA; > > create user testuser1 identified by testuser1 ; > grant connect, resource to testuser1; > > create user testuser2 identified by testuser2 ; > grant create session to testuser2; > > create table testuser1.table1 ( a int ) ; > > grant select on testuser1.table1 to testuser2; > error at line 1: > ora-01031: insufficient privileges > > WHERE AS : > > connect testuser1/testuser1; > > grant select on testuser1.table1 to testuser2; > > grant succeeded. > > > why is it so ? > why sys is not able to GRANT ? > seems to be strange ! > > the env. is 8.1.6.0./win2k. > > Jp. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Prem Khanna J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting > services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like > subscribing). > Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: db file sequential read [WAS:wait event puzzler]
Bhaskar, Wisely you chose to take 30 char limit in your stride but I'm sure the "name translation algorithm" suggestion was intended as a joke and so was "doing away with DDL". Don't make things overly complicated. Have good naming conventions and shorten the name wherever wise. Name translation is going to make more problems than name abbreviation. Can you give a brief of what problems you anticipate by shortening the names? Agreed, that 30 chars is a bit too mean, but thats the way it is. So better learn to live with it rather than doing fancy things with a DB. Regards Naveen > -Original Message- > From: Bhaskar Viswanathan [mailto:[EMAIL PROTECTED] > Sent: Friday, June 13, 2003 12:59 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: db file sequential read [WAS:wait event puzzler] > > > > Hi, > > Thanks to all for you responses. > > To sum up the suggestions: > > 1)You can modify col$.NAME to varchar2(60) and try.. > 2)I do agree with you. But some times we may need go beyond the > scopes. > For testing purpose we can do these kind of R&D's.(alterning the > col.Cname size) > Nothing wrong in this. > 3)That is a Very Good Idea... > We will do away with DDL Stmts will start writing directly into > the Data Dictionary ... > 4)Oracle does not support column names that are longer than 30 > characters. > This is a hard standard and can not be changed. > 5)Ur not supposed to Update Data Dictionaly Tables Directly ... > Oracle has A Limit of 30 Chrs and is Hardcoded.. So ReName your > Columns within 30 Chrs... > 6)Updating a data dictionary is simply not done. Remember, we're > the DBA (you will be assimilated) and not fun loving students > who can play with their alma mater's equipment. > Updating the data dictionary directly would cause the database > to lose support from > Oracle Corp. and the perpetrator would be liable. > 7)telling him to do a Update on COL$... He Ends up Doing that in > his Production Database.. > And he is going to be in a HOT soup > 8)Write a compress / decompress algorithm that will take your > 200-character table names from > the application and pass them to the database as <= 30 > characters; then uncompress them from > the database back to the application. > 9)references to DB naming conventions. > > I would want to go with the majority. "Do not Do it!!". > > But then, the problem is like, I cannot afford to shorten > names as there > are a lot of other problems which crops up. > Though right now, thatz what we do and which is what I am > attempting to > avoid. > Ofcourse, the suggestion to have an algo. translate the names > is a good > one, which is thought of and is the current > Decision. > > Whew!, if oralce supports more than 30 characters for column > names, life > would be easier. > > Can somebody explain in brief, why this is being restricted to 30 > characters? > > And once again, thanks a lot! > > Baski > > -Original Message- > Sent: Thursday, June 12, 2003 7:10 PM > To: Multiple recipients of list ORACLE-L > > > Modifying data dictionary tables is definitely not a good > idea and I > am sure Oracle will not support this. > > CP > > > [EMAIL PROTECTED] wrote: > > >Dear Bhaskar, > > > >You can modify col$.NAME to varchar2(60) and try. > > > >If this fails, I'll give a procedure you can use that to > change it to > >whatever size you want. > > > >Senthil Kumar > >Sr Oracle DBA > >Summitworks Technologies Pvt Ltd > > > >-Original Message- > >Bhaskar Viswanathan > >Sent: Thursday, June 12, 2003 4:00 PM > >To: Multiple recipients of list ORACLE-L > > > > > > > >hi, > > > >We use Oracle 8 DB. > > > >I am not a Oracle technical guy. So lemme try explaining the problem. > > > >We need to create tables with columns, whose names(column-names) are > >more than 30 characters long. This is being restricted because, all > >columns of all tables have entries in a table called 'col'. > >Thit table is defined as: > > > >SQL> desc col > > Name Null?Type > > - > > > > TNAME NOT NULL VARCHAR2(30) > > COLNO NOT NULL NUMBER > > CNAME NOT NULL VARCHAR2(30) > > COLTYPEVARCHAR2(106) > > WIDTH NOT NULL NUMBER > > SCALE NUMBER > > PRECISION NUMBER > > NULLS VARCHAR2(19) > > DEFAULTVAL LONG > > CHARACTER_SET_NAME VARCHAR2(44) > >SQL> > > > >since CNAME is defined as VARCHAR2(30), we are forced to > retri
RE: Fragmentation ?
Dennis , List What may be the OTHER forms of fragmentation ? What Number of Extents may be considered Critical warranting RE-Organization for Manually Sized Objects existing in LMTs ? Thanks for the great paper . Had read it previously though . Thanks -Original Message- Sent: Wednesday, June 11, 2003 8:25 PM To: Multiple recipients of list ORACLE-L Vivek Make sure you've read "How to Stop Defragmenting and Start Living" http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049 The authors point out that uniform extents stop fragmentation at the tablespace level. However they point out that there are other forms of fragmentation. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 11, 2003 9:15 AM To: Multiple recipients of list ORACLE-L Qs What is the advantage of having dba_tablespaces.ALLOCATION_TYPE = "UNIFORM" OVER dba_tablespaces.ALLOCATION_TYPE = "USER" ? With ALLOCATION_TYPE = "UNIFORM" , NEXT_EXTENT Size of the Object can NOT be Manually defined in the Table Creation Script )> , which is allowed when having allocation_type="USER" . Allocation_type="USER" allows Objects with Different NEXT_EXTENT Sizes to be Created in the SAME LOCALLY managed Tablespace & thus reduces Total Number of Extents for the respective Table. Our Application does have Objects of Dissimilar Sizes Existing tin the Same Tablespace . Does ALLOCATION_TYPE = "UNIFORM" automatically imply NO Fragmentation Irrespective of the Number of Extents of the Object (in a Locally Managed Tablespace) ? Does it further imply NO further need to Look at Number of Extents of an Object in a Locally Managed Tablespace ? NOTE Allocation_type can be made = "USER" by using the stored procedures :- dbms_space_admin.tablespace_migrate_from_local / dbms_space_admin.tablespace_migrate_to_local Am i still Lost in the World of Oracle 7 ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Mail delivery problem
I'm getting all the fatcity mails twice. Y is like this??? strange -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar D INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: db file sequential read [WAS:wait event puzzler]
Senthil, Could you please send me the script which can modify col$.NAME? I tried this (of course on a trashable DB) but it doesn't work, and as far as my understanding goes(looking at the error), "NOTHING" can make it work. Following is the error I get in 8.1.7.0.0 SQL> alter table col$ modify name varchar2(60); alter table col$ modify name varchar2(60) * ERROR at line 1: ORA-00701: object necessary for warmstarting database cannot be altered Regards Naveen DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ??? Linux/Oracle 8.1.7 2GB file size limit ???
DO NOT USE AUTOEXTEND on these datafiles. There is a bug when datafile autoextend into 2GB or 4GB (I do not remember exactly now) on NT. We had a database down permanently because of this. We do not work with any X OS here so I am talking about NT only. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, June 09, 2003 7:34 PM > FWIW, we use 2048m here. > > --Walt (who feels obligated to make some posts since Steve's off today) Weaver > Bozeman, Montana > > > -Original Message- > > From: Jared Still [mailto:[EMAIL PROTECTED] > > Sent: Sunday, June 08, 2003 11:00 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ??? > > > > > > > > Just curious how you arrived at the 1900 meg number. > > > > Why not use 2000m? > > > > Oracle defines gigabytes in binary, not decimal as > > drive mfg's do, so 2000m would be fine. > > > > Not a criticism, just wondering. > > > > Jared > > > > On Sunday 08 June 2003 09:29, Yechiel Adar wrote: > > > We have been hit by a bug in autoextend that corrupted a > > database (8.1.6) > > > on NT. > > > It seems that the bug was exported to Linux as well. > > > > > > We now use all datafiles with autoextend up to 1900 MB. > > > We also define a second datafile with 200MB initial and > > autoextend to 1900 > > > MB. > > > Whenever the last datafile starts to grow we define a new > > one with 200MB > > > etc. > > > > > > Seems to work so far. > > > > > > Yechiel Adar > > > Mehish > > > - Original Message - > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > Sent: Wednesday, June 04, 2003 5:40 PM > > > > > > > I've just been informed that there is a 2GB datafile size > > limit with > > > > > > Oracle 8.1.7 on Linux... PERIOD. This despite the fact that > > we've had files > > > in excess of this for some time and they work just fine. > > The problem occurs > > > when the autoextend "feature" reaches the 2GB threshhold. > > Of course, Oracle > > > didn't tell me this until after about 4 days of back and > > forth testing for > > > them. (There is no such O/S file size limit.) I've reviewed > > the Linux > > > release notes, the Linux install guide, the Linux admin > > guide and the > > > contents of $ORACLE_HOME/relnotes and I don't find any such > > limitation in > > > the documentation. Did I miss it? Can anyone find any such published > > > limitation in the docs? Is this a secret? > > > > > > > Peeved at Oracle... AGAIN, > > > > Steve Orr > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > > -- > > > > Author: Orr, Steve > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services-- 858-538-5051 > > http://www.fatcity.com > > > > San Diego, California-- Mailing list and web > > hosting services > > > > > > - > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > (or the name of mailing list you want to be removed > > from). You may > > > > also send the HELP command for other information (like > > subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: 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: Weaver, Walt > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: World premier performance of the BAARF party logo
You have just become member # 26 in the BAARF Party. You have been raised to Bold Member status. You seem to both deserver it and need it :-))) [EMAIL PROTECTED] wrote: Our storage team won't even respond to me anymore when I ask for the manufacturer's rating for non-cached I/Os per second & number of controllers, RAID level, striping, etc... All I get is 'why do you want to know that' and 'what application is this for'... BARRF will stop the debilitating headaches since I will just refuse to talk about it anymore. Happy Day!! Mogens Nørgaard <[EMAIL PROTECTED]> T To: Multiple recipients of list ORACLE-L Sent by: <[EMAIL PROTECTED]> [EMAIL PROTECTED]cc: bcc: Subject: World 06/10/03 06:19 PMpremier performance of the BAARF party logo Please respond to ORACLE-L Friends, James Morle has done it again. Nobody does it better. For the first public showing of his BAARF animation, please GoTo www.MiracleAS.dk . Then get back to your work or mailing list fast :-). Let me know if you want to become a BAARF party member, and I'll assign you a BAARF party membership number right away. You can reach Bold Membership Status if you can argue that you've been fighting RAID-F for a long time, a medium time, a short time or an extremely short time. Best regards, Mogens -- 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: =?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: SYS not able to GRANT -- Strange !
No user, not even SYS, can grant on another user's objects. You have two options 1. Login as the owner of the object on which grants are to be provided and provide the grants 2. Create a grants package[which can give grants on specified objects] in the owner's schema, grant execute on that package to SYS or whichever DBA account you use and then use the package from SYS or the DBA account. The package runs in Owner's Rights ! Hemant --- Prem Khanna J <[EMAIL PROTECTED]> wrote: > Guys, > > CONNECT SYS AS SYSDBA; > > create user testuser1 identified by testuser1 ; > grant connect, resource to testuser1; > > create user testuser2 identified by testuser2 ; > grant create session to testuser2; > > create table testuser1.table1 ( a int ) ; > > grant select on testuser1.table1 to testuser2; > error at line 1: > ora-01031: insufficient privileges > > WHERE AS : > > connect testuser1/testuser1; > > grant select on testuser1.table1 to testuser2; > > grant succeeded. > > > why is it so ? > why sys is not able to GRANT ? > seems to be strange ! > > the env. is 8.1.6.0./win2k. > > Jp. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Prem Khanna J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting > services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like > subscribing). > Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SYS not able to GRANT -- Strange !
There's a new sys priv in 9i called "grant any object privilege" that can be used for this. regards Jo Joe Testa <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/13/2003 06:34 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: SYS not able to GRANT -- Strange ! its always been that way, its not strange, sys has NEVER been able to grant privs on other owner's objects. i think that has changed in 9i but its late and my brain is fuzzy. joe Prem Khanna J wrote: >Guys, > >CONNECT SYS AS SYSDBA; > >create user testuser1 identified by testuser1 ; >grant connect, resource to testuser1; > >create user testuser2 identified by testuser2 ; >grant create session to testuser2; > >create table testuser1.table1 ( a int ) ; > >grant select on testuser1.table1 to testuser2; >error at line 1: >ora-01031: insufficient privileges > >WHERE AS : > >connect testuser1/testuser1; > >grant select on testuser1.table1 to testuser2; > >grant succeeded. > > >why is it so ? >why sys is not able to GRANT ? >seems to be strange ! > >the env. is 8.1.6.0./win2k. > >Jp. > > > > -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the "CACHE" -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: World premier performance of the BAARF party logo
Dear Paul, Welcome to the Party! You have just become member (and a Bold Member as it were) no 24 (that's 42 backwards). Thanks. EiE (Enough is Enough). Mogens Paul Baumgartel wrote: Dear Mogens, When I arrived at my new job, I found RAID 5 everywhere, and a sys admin who wanted to build my new database servers that way...I smote the old systems and set the new ones on the right path. I would be proud to be associated with your movement. --- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote: Friends, James Morle has done it again. Nobody does it better. For the first public showing of his BAARF animation, please GoTo www.MiracleAS.dk . Then get back to your work or mailing list fast :-). Let me know if you want to become a BAARF party member, and I'll assign you a BAARF party membership number right away. You can reach Bold Membership Status if you can argue that you've been fighting RAID-F for a long time, a medium time, a short time or an extremely short time. Best regards, Mogens -- 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! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com
Re: Trigger double firing apparently double inserts
your doing an insert select. have you checked to see if you are selecting two records? you can add where rownum < 2 and you can verify that two records are being inserted by added a primary key to the recipient table and you should get a constraint error if this is correct. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 3:09 AM > Hi Listers > > I have a trigger that is an on update trigger that is somehow writing two > records when a record is updated in the table that the trigger is > associated with. > I have run the select statement to see if it will retrieve multiple > records and the msf071 table that has the record that causes the trigger > to fire has only on record for the equip_no > Why does it do this and how do I fix it. > As you might notice it inserts across a link > I have had a loom at Metalink but wasn't able to locate anything > > Trigger code below > > create or replace trigger msf071_archibus_update > after update on msf071 > for each row > declare > -- local variables here > v_equip_number msf071.ENTITY_value%TYPE; > v_equip_class msf600.equip_class%TYPE; > v_attrib_value MSF6A4.Attrib_value%TYPE; > v_ref_value msf071.Ref_code%TYPE; > v_entity_type msf071.entity_type%TYPE; > > > > begin > > v_equip_number := :old.Entity_value; > v_entity_type := :old.entity_type; > v_ref_value := :new.ref_code; > IF v_ref_value = ('U') AND v_entity_type = 'EQP' THEN > > INSERT INTO [EMAIL PROTECTED] (equip_no, > dstrct_code, > NAME, > assoc_value, > equip_status, > active_flag, > parent_equip, > equip_classif_3, > sizecell, > sizem, > aream, > suburb, > postcode, > street_no, > street_name, > state) > SELECT c.equip_no, > dstrct_code, > c.item_name_1, > substr(h.assoc_rec, 1, 1), > equip_status, > active_flg, > parent_equip, > equip_classifx3, > to_number(d.attrib_value_num_9), > To_number(e.attrib_value_num_9) "SIZE", > to_number(f.attrib_value_num_9) "AREASQM", > substr(g.suburb, 1, 30), > substr(g.zip_code, 1, 4), > street_no, > substr((g.street_name|| ' ' || a.table_desc) > ,1,50)"STREET_TYPE", > substr(b.table_desc, 1, 30) "STATE" > FROM MSF600 c, view_MSF6a4_cellsize d, view_msf6a4_size e, > view_msf6a4_area f, MSF011 g, view_msf010_assoc_value h, > view_msf010_streettype a, view_msf010_state b > WHERE c.equip_no = v_equip_number AND > c.Equip_no = d.equip_no(+) AND > c.Equip_no = e.equip_no(+) AND > c.Equip_no = f.equip_no(+)AND > c.equip_class = h.table_code AND > c.location = g.location(+) AND > g.street_type = a.table_code(+) AND > g.state = b.table_code(+) ; > > /*end loop;*/ > > END IF; > > end msf071_archibus_update; > > > > > -- > = > Peter McLarty E-mail: [EMAIL PROTECTED] > Technical ConsultantWWW: http://www.mincom.com > APAC Technical Services Phone: +61 (0)7 3303 3461 > Brisbane, AustraliaMobile: +61 (0)402 094 238 > Facsimile: +61 (0)7 3303 3048 > = > A great pleasure in life is doing what people say you cannot do. > > - Walter Bagehot (1826-1877 British Economist) > = > Mincom "The People, The Experience, The Vision" > > = > > This transmission is for the intended addressee only and is confidential > information. If you have received this transmission in error, please > delete it and notify the sender. The contents of this e-mail are the > opinion of the writer only and are not endorsed by the Mincom Group of > companies unless expressly stated otherwise. > > > -- > 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 PROT
RE: World premier performance of the BAARF party logo
Hey its always nice to put faces to the names. Now I know how 1 List member looks like. :-) Regards Naveen > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, June 13, 2003 12:20 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: World premier performance of the BAARF party logo > > > Here are pics if interested. > > http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_1.jpg > http://www.cybcon.com/~jkstill/no_raid_5/no_raid5_2.jpg > > I too do not understand why vendors push RAID 5 when > RAID 10 is clearly more profitable. I speculate that they > may be afraid of being accused of overselling when > PHB's discover the RAID 10's they just purchased could > have been RAID 5's for less money. > > > Jared > > > > > > "Niall Litchfield" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 06/12/2003 10:04 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: World premier performance of the > BAARF party logo > > > Jared writes > > At the meeting last week I wore my 'No RAID 5' hat. > > > > Those of you at IOUG 99 in Denver may have seen it, I > > wore it every day there. ;) > > I'm curious now. Pictures required. > > Meanwhile I have never understood why storage vendors would prefer > selling RAID5 over RAID10. More disks=more profit surely? Also 10 > 5 > therefore self evidently twice as good for all applications. Meanwhile > we have this strange situation where performance consultants are > publicising the fact that you have less need for performance > consultants > with RAID10 than with RAID5. > > Niall > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Niall Litchfield > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be 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). > DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test mail -- please ignore
test mail -- please ignore -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nilesh Darji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: db file sequential read [WAS:wait event puzzler]
Hi, Thanks to all for you responses. To sum up the suggestions: 1) You can modify col$.NAME to varchar2(60) and try.. 2) I do agree with you. But some times we may need go beyond the scopes. For testing purpose we can do these kind of R&D's.(alterning the col.Cname size) Nothing wrong in this. 3) That is a Very Good Idea... We will do away with DDL Stmts will start writing directly into the Data Dictionary ... 4) Oracle does not support column names that are longer than 30 characters. This is a hard standard and can not be changed. 5) Ur not supposed to Update Data Dictionaly Tables Directly ... Oracle has A Limit of 30 Chrs and is Hardcoded.. So ReName your Columns within 30 Chrs... 6) Updating a data dictionary is simply not done. Remember, we're the DBA (you will be assimilated) and not fun loving students who can play with their alma mater's equipment. Updating the data dictionary directly would cause the database to lose support from Oracle Corp. and the perpetrator would be liable. 7) telling him to do a Update on COL$... He Ends up Doing that in his Production Database.. And he is going to be in a HOT soup 8) Write a compress / decompress algorithm that will take your 200-character table names from the application and pass them to the database as <= 30 characters; then uncompress them from the database back to the application. 9) references to DB naming conventions. I would want to go with the majority. "Do not Do it!!". But then, the problem is like, I cannot afford to shorten names as there are a lot of other problems which crops up. Though right now, thatz what we do and which is what I am attempting to avoid. Ofcourse, the suggestion to have an algo. translate the names is a good one, which is thought of and is the current Decision. Whew!, if oralce supports more than 30 characters for column names, life would be easier. Can somebody explain in brief, why this is being restricted to 30 characters? And once again, thanks a lot! Baski -Original Message- Sent: Thursday, June 12, 2003 7:10 PM To: Multiple recipients of list ORACLE-L Modifying data dictionary tables is definitely not a good idea and I am sure Oracle will not support this. CP [EMAIL PROTECTED] wrote: >Dear Bhaskar, > >You can modify col$.NAME to varchar2(60) and try. > >If this fails, I'll give a procedure you can use that to change it to >whatever size you want. > >Senthil Kumar >Sr Oracle DBA >Summitworks Technologies Pvt Ltd > >-Original Message- >Bhaskar Viswanathan >Sent: Thursday, June 12, 2003 4:00 PM >To: Multiple recipients of list ORACLE-L > > > >hi, > >We use Oracle 8 DB. > >I am not a Oracle technical guy. So lemme try explaining the problem. > >We need to create tables with columns, whose names(column-names) are >more than 30 characters long. This is being restricted because, all >columns of all tables have entries in a table called 'col'. >Thit table is defined as: > >SQL> desc col > Name Null?Type > - > > TNAME NOT NULL VARCHAR2(30) > COLNO NOT NULL NUMBER > CNAME NOT NULL VARCHAR2(30) > COLTYPEVARCHAR2(106) > WIDTH NOT NULL NUMBER > SCALE NUMBER > PRECISION NUMBER > NULLS VARCHAR2(19) > DEFAULTVAL LONG > CHARACTER_SET_NAME VARCHAR2(44) >SQL> > >since CNAME is defined as VARCHAR2(30), we are forced to retrict column >names to a max of 30 characters long. > >For eg. create table T1(x31 varchar2(50)); >The above statement will be rejected with the error: > * >ERROR at line 1: >ORA-00972: identifier is too long > >However, the statement "create table T1(30 >varchar2(50))" Succeeds in creating the table; > >I guess this table col is created by the system itself. how can we >change this size So that the 30 character restriction in column names >can be avoided??? > >baski > >**Disclaimer*** >* > >Information contained in this E-MAIL being proprietary to Wipro Limited >is 'privileged' and 'confidential' and intended for use only by the >individual or entity to which it is addressed. You are notified that >any use, copying or dissemination of the information contained in the >E-MAIL in any manner whatsoever is strictly prohibited. > >***
RE: Rebuilding MLOG tables
IIRC you need to lock the parent table in one session and then do whatever you need to do to the mlog table in a SECOND session (because, as another poster pointed out, the lock will be released too soon otherwise). hth, Jo Stephen Lee <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/12/2003 22:41 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Rebuilding MLOG tables I don't think we can go with the truncate table thing since there is too much weirdness around here in when a client -- and there are multiple clients -- might update: Network problems, box crashed, sunspots (Don't forget about the sunspots!). So if there are entries still hanging around in the MLOG table, we want to keep them. > -Original Message- > > I do it all the time. Actually you don't have to lock the > table; you may > simply quiesce the table, meaning no transations will be allowed. > > Steps: > > Quiesce the table > Apply all the pending logs in the deferred trans queue on > secondary database > Truncate The MLOG$ table. > > No issues; in fact I think (note sure) it is supported by > Oracle. And it > should be; MLOG$ tables are just plain simple tables anyway. > > Hope this helps. > > Arup Nanda > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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).
Trigger double firing apparently double inserts
Hi Listers I have a trigger that is an on update trigger that is somehow writing two records when a record is updated in the table that the trigger is associated with. I have run the select statement to see if it will retrieve multiple records and the msf071 table that has the record that causes the trigger to fire has only on record for the equip_no Why does it do this and how do I fix it. As you might notice it inserts across a link I have had a loom at Metalink but wasn't able to locate anything Trigger code below create or replace trigger msf071_archibus_update after update on msf071 for each row declare -- local variables here v_equip_number msf071.ENTITY_value%TYPE; v_equip_class msf600.equip_class%TYPE; v_attrib_value MSF6A4.Attrib_value%TYPE; v_ref_value msf071.Ref_code%TYPE; v_entity_type msf071.entity_type%TYPE; begin v_equip_number := :old.Entity_value; v_entity_type := :old.entity_type; v_ref_value := :new.ref_code; IF v_ref_value = ('U') AND v_entity_type = 'EQP' THEN INSERT INTO [EMAIL PROTECTED] (equip_no, dstrct_code, NAME, assoc_value, equip_status, active_flag, parent_equip, equip_classif_3, sizecell, sizem, aream, suburb, postcode, street_no, street_name, state) SELECT c.equip_no, dstrct_code, c.item_name_1, substr(h.assoc_rec, 1, 1), equip_status, active_flg, parent_equip, equip_classifx3, to_number(d.attrib_value_num_9), To_number(e.attrib_value_num_9) "SIZE", to_number(f.attrib_value_num_9) "AREASQM", substr(g.suburb, 1, 30), substr(g.zip_code, 1, 4), street_no, substr((g.street_name|| ' ' || a.table_desc) ,1,50)"STREET_TYPE", substr(b.table_desc, 1, 30) "STATE" FROM MSF600 c, view_MSF6a4_cellsize d, view_msf6a4_size e, view_msf6a4_area f, MSF011 g, view_msf010_assoc_value h, view_msf010_streettype a, view_msf010_state b WHERE c.equip_no = v_equip_number AND c.Equip_no = d.equip_no(+) AND c.Equip_no = e.equip_no(+) AND c.Equip_no = f.equip_no(+)AND c.equip_class = h.table_code AND c.location = g.location(+) AND g.street_type = a.table_code(+) AND g.state = b.table_code(+) ; /*end loop;*/ END IF; end msf071_archibus_update; -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom "The People, The Experience, The Vision" = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- 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).
Thanx --> SYS not able to GRANT
Ops ! I was not knowing this so long :( So , it's something strange with ME not SYS ;-) Thanx a lot CP,Dhanvir and Joe. Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA600 [2103] [0] [0] [1] [900]
It is a local filesystem Kind Regards, Hatzistavrou Yannis -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 7:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: ORA600 [2103] [0] [0] [1] [900] 1. Try writing the backup to another location alter database backup controlfile to '/tmp/cntrlfilebk.dbf' 2. Try it again with the reuse clause 3. Is the file system '/hot_backup/siebelp1' local or NFS mounted ? Hemant At 02:45 AM 12-06-03 -0800, you wrote: Dear All, I have encountered the following message during alter database backup controlfile to && reuse after a hot backup. We have opened a tar but still waiting. The strange think is that our Oracle versions range from 8.1.7.3 to 8.1.7.4 which according to what I have read resolved this problem. Another strange fact is that this happened concurrently on three clusters of Sun Solaris 8. Attached please find extracts from alert and trace files a) alert hread 1 advanced to log sequence 41062 Thu Jun 12 02:33:43 2003 ARC1: Beginning to archive log# 1 seq# 41061 Thu Jun 12 02:33:43 2003 Current log# 2 seq# 41062 mem# 0: /be/prod/crm_oss/oracle/siebel/redo_logs/sbl_redo_2A.log Current log# 2 seq# 41062 mem# 1: /be/prod/crm_oss/oracle/siebel/redo_logs/sbl_redo_2B.log Thu Jun 12 02:33:44 2003 Completed: alter database backup controlfile to trace Thu Jun 12 02:33:44 2003 alter database backup controlfile to '/hot_backup/siebelp1/control01.bak' reuse Thu Jun 12 02:49:10 2003 Errors in file /be/prod/crm/siebel/oracle/siebelp1/admin/bdump/siebelp1_arc1_16563.trc: ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [2103] [0] [0] [1] [900] Thu Jun 12 02:49:12 2003 Errors in file /be/prod/crm/siebel/oracle/siebelp1/admin/bdump/siebelp1_arc1_16563.trc: ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [2103] [0] [0] [1] [900] Thu Jun 12 02:49:12 2003 ARC1: terminating instance due to error 600 Instance terminated by ARC1, pid = 16563 Thu Jun 12 02:49:47 2003 Starting ORACLE instance (normal) b) trace Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production ORACLE_HOME = /oracle_home/product/8.1.7 System name: SunOS Node name: apps01-n01 Release: 5.8 Version: Generic_108528-21 Machine: sun4u Instance name: siebelp1 Redo thread mounted by this instance: 1 Oracle process number: 21 Unix process pid: 16563, image: [EMAIL PROTECTED] (ARC1) *** 2003-06-12 02:49:08.500 *** SESSION ID:(137.947) 2003-06-12 02:49:08.463 TIMEOUT ON CONTROL FILE ENQUEUE mode=X, type=0, wait=1, eqt=900 === SYSTEM STATE System global information: Number of NUMA instances : 1 processes: base 9010fe44, size 250, cleanup 90110864 allocation: free sessions(0) 90174724, free calls(0) 1 control alloc errors: 0 (process), 0 (session), 0 (call) system statistics: 0 47997 logons cumulative 0 1052 logons current 0 1649040 opened cursors cumulative 0 41528 opened cursors current 0 1311839 user commits 0 7201 user rollbacks 0 30519546 user calls 0 22909587 recursive calls 0 1827715 recursive cpu usage 0 1553098488 session logical reads 0 0 session stored procedure space 0 6209740 CPU used when call started 0 143359357 CPU used by this session 8236 791247589 session connect time 8236 791247589 process last non-idle time 1020 304666384 session uga memory Has anybody encountered such problem before? How can it be resolved? Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).