RE: Who is Melanie Craft?
Apparently to celebrate his new marriage, Larry is releasing the new Oracle 10G Marriage Builder product, it requires plenty of tuning and costs an absolute fortune. Other features include Parallel nagging, a new wifemon process that never clears anything up and after 3 months the whole product becomes totally unreliable. -Original Message- Sent: Thursday, January 15, 2004 3:30 PM To: Multiple recipients of list ORACLE-L Well, at least he didn't marry Lara Croft. That would do him in faster then Bill Gates. On 01/15/2004 09:19:26 AM, KENNETH JANUSZ wrote: Melanie Craft is a romance novelist and the fourth woman to be known as Mrs. Larry Ellison. This is from an article is today's WSJ print edition page B4. Mrs. Ellison also has a web site although I don't know the address. Mrs. Ellison is 34 years old and Larry is 59. My $0.02 worth, Ken Janusz, CPIM -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Noyce, Robert A SITI-ITPSIE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ora-1555 under automatic undo management (resend ?)
I'm having an ora-1555 under Oracle9 database and not sure what I can do to get rid of it. I had some recollecions from Oracle8 days , but the things like adding a new rollback segment or shrinking the segments I don't think are applicable under the auto undo management. Besides separating the long queries from batch programs, is ther anything that I can do here? Hi Gene, Increase UNDO_RETENTION (which determines how long Oracle will attempt to keep your undo before being overwritten) and/or increase the size of your undo tablespace (to ensure Oracle will succeed in meeting your undo_retention target). Check out V%UNDOSTAT to see how it's going. Cheers Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: most practical 9iR2 features?
1. that Set oracle_sid=blah Sqlplus user/password Works on terminal server. 2. I like the workspace memory management features as well. 3. trace file timings in microseconds. 4. Cursor_sharing=similar (still has the odd bug). 5. HTMLDB is marketed for 10g but will install on 9.2 Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Odland, Brad Sent: 15 January 2004 17:15 To: Multiple recipients of list ORACLE-L Subject: most practical 9iR2 features? Hey listers I am doing some research and would like to get (in very short answers) features of 9iR2 that folks have implemented that meet the following goals: 1. Ease administration 2. Are not marketing crap 3. Are not already in 8.1.7 4. Increase response time and or perfromance A quick bullet list would be way cool of stuff that make you puff up and say ...this is so cool We are going to be moving our MRP system from 8.1.7 to 9iR2 this year and I'd like to get a feel for which items can help our old MRP app. Reply direct if you desire. We'll be implementing a new box with a SAN and so we already have some plans for actually using some features in 8i that were not feasible on our old AutoRAID. (There's nothing like getting a new box...) (I am already reading the new features doc and another doc by Howard Rogers) Thanks in advance Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: powerbuilder in rbo and multiple constraint question...
Chris, I've worked on a large Powerbuilder App for a number of years. We used CBO all the time under 7.3.2, 7.3.4 and 8.1.7. You're right Powerbuilder per se requiring RBO is rubbish. Cheers, Chris Dunscombe Quoting Chris Stephens [EMAIL PROTECTED]: I'm working with a 3rd party vendor to resolve some performance issues with there call center app. The app is written in PowerBuilder. When I traced the offending sessions, I noticed the queries are being run under the rbo. When I run those same queries under the cbo the response time is dramatically different. I asked why they insisted on running under the rbo. There response was that it's a limitation of powerbuilder. I don't buy that for a second. ...anyone know for sure? ..and on a side note...my company is developing a call center app in .not. The dba's were conveniently left out of the design process. I just took a look at the schema they are using and noticed redundant constraints on almost every table. i.e. not null, primary key, unique on the same column. Before I investigate myself with a 10046, does anyone know if oracle has to do multiple recursive sql to validate each constraint or is it smart enough to know they are redundant and only validate the pk constraint? .when I saw this, I blasted the developers (admittedly some misdirected aggression) for not having a clue what they were working with and blankly stated that the redundant constraints (among other things if found...no bind variables for one) would negatively affect performance. ..after possibly putting my foot in my mouth I'm looking to validate what I said. ...if I don't get any responses to this, I'll run the trace myself and post my findings. oh yeah...the .not developers responded by saying the redundant constraints wouldn't be a problem in sql server. ...something I'm almost positive they haven't validated either. Thanks! chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Staled Object
List, Gather Stale option of DBMS_STATS gathers statistics only for table which has modified more than 10%. Is there any way i can change this default 10% to any other value? Thanks and Regards, Satheesh Babu.S DISCLAIMER: This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
can't beat them, join them... :) Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Excellent reasoning Nuno. I hadn't thought of that. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Who is Melanie Craft?
as opposed to the ever-present Oracle kernel which is arbitrary, gobbles up all resources in sight and costs the earth to maintain? --- Noyce, Robert A SITI-ITPSIE [EMAIL PROTECTED] wrote: Apparently to celebrate his new marriage, Larry is releasing the new Oracle 10G Marriage Builder product, it requires plenty of tuning and costs an absolute fortune. Other features include Parallel nagging, a new wifemon process that never clears anything up and after 3 months the whole product becomes totally unreliable. -Original Message- Sent: Thursday, January 15, 2004 3:30 PM To: Multiple recipients of list ORACLE-L Well, at least he didn't marry Lara Croft. That would do him in faster then Bill Gates. On 01/15/2004 09:19:26 AM, KENNETH JANUSZ wrote: Melanie Craft is a romance novelist and the fourth woman to be known as Mrs. Larry Ellison. This is from an article is today's WSJ print edition page B4. Mrs. Ellison also has a web site although I don't know the address. Mrs. Ellison is 34 years old and Larry is 59. My $0.02 worth, Ken Janusz, CPIM -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Noyce, Robert A SITI-ITPSIE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
Connection Problem
Hi All, I'm helping out a friend of mine who's having problems with connecting from an NT system to an HP system running Oracle 8.0.5 (don't ask!). They keep getting an 12154 - Could not resolve service name error.. The TNSNAMES.ORA file looks OK, and I feel there is something iffy about their listener set up. Here's there set-up: TNSNAMES.ORA: extproc_connection_data = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = LIVE)) (CONNECT_DATA = (SID = extproc)) ) LIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = LIVE)) ) TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = TEST)) ) ARCHIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = ARCHIVE)) ) LISTENERORA: LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= FROUDE)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = LIVE) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = TEST) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = ARCHIVE) ) (SID_DESC = (SID_NAME = extproc) (ORACLE_HOME = /usr/oracle/product/8.0.5) (PROGRAM = extproc) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = OFF When he tries to connect user/[EMAIL PROTECTED] the connection fails - and the same for TEST and ARCHIVE. The thing that sticks out to me is the GLOBAL_DBNAME parameter being set to l1000 for every instance - do you think this could be causing the problem? Is there anything else that catches your eye? Cheers! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Connection Problem
Hello Mark, all 3 instances are listening on the same port. Cheers Barry. -Original Message- Mark Leith Sent: 16 January 2004 11:14 To: Multiple recipients of list ORACLE-L Hi All, I'm helping out a friend of mine who's having problems with connecting from an NT system to an HP system running Oracle 8.0.5 (don't ask!). They keep getting an 12154 - Could not resolve service name error.. The TNSNAMES.ORA file looks OK, and I feel there is something iffy about their listener set up. Here's there set-up: TNSNAMES.ORA: extproc_connection_data = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = LIVE)) (CONNECT_DATA = (SID = extproc)) ) LIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = LIVE)) ) TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = TEST)) ) ARCHIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = ARCHIVE)) ) LISTENERORA: LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= FROUDE)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = LIVE) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = TEST) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = ARCHIVE) ) (SID_DESC = (SID_NAME = extproc) (ORACLE_HOME = /usr/oracle/product/8.0.5) (PROGRAM = extproc) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = OFF When he tries to connect user/[EMAIL PROTECTED] the connection fails - and the same for TEST and ARCHIVE. The thing that sticks out to me is the GLOBAL_DBNAME parameter being set to l1000 for every instance - do you think this could be causing the problem? Is there anything else that catches your eye? Cheers! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Opinion on Changing Names
Hi list, Every night I update the development DB through a cron job, now I have the requirement of change or scramble the names of our customers to protect and privacy of information. I have been thinking of adding a procedure to the script that update all the names using a REPLACE clause and change some letters. Is there any way or a better one to accomplish that ? Scenario 8.1.7.4 from HP-UX (Prod) to RH AS 1.2 8.1.7.4 (lab). TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 winmail.dat
SQL server and JOB
Hi , How can i create a job in sql server ? Rgds. Arslan. -- 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: Opinion on Changing Names
Ramon, Take a look at the DBMS_RANDOM package. You can replace the name with a random number. That ought to do the trick. Good Luck Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 16, 2004 7:49 AM To: Multiple recipients of list ORACLE-L Hi list, Every night I update the development DB through a cron job, now I have the requirement of change or scramble the names of our customers to protect and privacy of information. I have been thinking of adding a procedure to the script that update all the names using a REPLACE clause and change some letters. Is there any way or a better one to accomplish that ? Scenario 8.1.7.4 from HP-UX (Prod) to RH AS 1.2 8.1.7.4 (lab). TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL server and JOB
Try to have the SQL Server DBA fired. - --- Original Message --- - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Fri, 16 Jan 2004 04:59:26 Hi , How can i create a job in sql server ? Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL server and JOB
Firstly Arslan, it should probably be pointed out that this is an Oracle list, not SQLServer. But, seeing as I deal with both database types, I'll have a stab at this.. You can create jobs under the SQLServer Agent. If you open up SQLServer's Enterprise Manager, and navigate to your Server, there is a directory tree there called Management, and under that will be SQL Server Agent, which manages three things - Alerts, Operators and Jobs.. If you highlight Jobs, then right mouse button click on the (probably) empty window on the right, you'll get a menu option to insert a New Job HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- [EMAIL PROTECTED] Sent: 16 January 2004 12:59 To: Multiple recipients of list ORACLE-L Hi , How can i create a job in sql server ? Rgds. Arslan. -- 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Connection Problem
Mark, The (GLOBAL_DBNAME= l1000.) entry looks strange. Should there be a '.' in there? I've never seen this entry in this file. What does : lsnrctl status lsnrctl services show? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 16, 2004 6:14 AM To: Multiple recipients of list ORACLE-L Hi All, I'm helping out a friend of mine who's having problems with connecting from an NT system to an HP system running Oracle 8.0.5 (don't ask!). They keep getting an 12154 - Could not resolve service name error.. The TNSNAMES.ORA file looks OK, and I feel there is something iffy about their listener set up. Here's there set-up: TNSNAMES.ORA: extproc_connection_data = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = LIVE)) (CONNECT_DATA = (SID = extproc)) ) LIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = LIVE)) ) TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = TEST)) ) ARCHIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = ARCHIVE)) ) LISTENERORA: LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= FROUDE)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = LIVE) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = TEST) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = ARCHIVE) ) (SID_DESC = (SID_NAME = extproc) (ORACLE_HOME = /usr/oracle/product/8.0.5) (PROGRAM = extproc) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = OFF When he tries to connect user/[EMAIL PROTECTED] the connection fails - and the same for TEST and ARCHIVE. The thing that sticks out to me is the GLOBAL_DBNAME parameter being set to l1000 for every instance - do you think this could be causing the problem? Is there anything else that catches your eye? Cheers! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What is Hash Join?
Thanks a lot for the information Kevin :), that's quite a light to me. So... Is it best to try to get hash join on execution plan at all time? Regards, Wendry. -Original Message- Sent: Thursday, January 15, 2004 9:09 PM To: [EMAIL PROTECTED] In my experience, Hash Joins have proven OUTSTANDING for joining two very large tables -- much faster than any other strategy. I copied the following from AskTom.oracle.com. It answers the question What is the difference between a Sort Merge and a Hash Join. From AskTom.Oracle.com: Well, a sort merge of A and B is sort of like this: read A and sort by join key to temp_a read B and sort by join key to temp_b read a record from temp_a read a record from temp_b while NOT eof on temp_a and temp_b loop if ( temp_a.key = temp_b.key ) then output joined record elsif ( temp_a.key = temp_b.key ) read a record from temp_a elsif ( temp_a.key = temp_b.key ) read a record from temp_b ) end loop (its more complex then that, the above logic assumed the join key was unique -- we really need to join every match in temp_a to every match in temp_b but you get the picture) The hash join is conceptually like: create a hash table on one of A or B (say A) on the join key creating temp_a. while NOT eof on B read a record in b hash the join key and look up into temp_a by that hash key for matching records output the matches end loop So, a hash join can sometimes be much more efficient (one hash, not two sorts) Hash joins are used any time a sort merge might be used in most cases. If you don't see hash joins going on, perhaps you have hash_join_enabled turned off... From: Wendry [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Subject: What is Hash Join? Date: Thu, 15 Jan 2004 20:39:29 +0700 Dear all, I understand join is for joining two tables, I know nested loops and sort-merge joins and I know how they work and on what situation theyre used best at. But I really dont understand hash join, how are they working to join tables and on what situation they performed best? And based on what does Oracle use hash join for joining tables in the execution plan? If they use hash value, how does Oracle determine the hash value when performing hash join? I really in the dark here, please give me some light , Thank you all in advance. Regards, Wendry Get today's cartoon: http://www.LazyDBA.com Please don't reply to RTFM questions Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Learn how to choose, serve, and enjoy wine at Wine @ MSN. http://wine.msn.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wendry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: List problems (duplicate?)
For the record, I've been having the same problem at two email addresses. Iguess one question is whether it is consistently the same email that no onegets. If it's my mail gateway seeing it as spam, will everyone see it as spam?For example I got Dan's "Partioning question (duplicate?)" email from lateyesterday afternoon, but I never got the original post (even though I see it onthe fatcity.com website). Obviously Dan never got the original post either. Didanyone? This might help to narrow down the source of the problem. Henry -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Thursday, January 15, 2004 1:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: List problems Is this still being worked on? I'm not seeing a lot of volume nor anything I've sent recently. Funny you should ask.If you go to fatcity.com you will see that all email is arriving there unmolested. Several emails I sent did not appear in my inbox at 2 different addresses, yet they are on the server at fatcity.com. The most likely problem is that something is happening to them after they leave fatcity. The question is what. fatcity is on an ISP (RoadRunner ) that happens to allow dynamic IP addresses, a favorite tactic of spammers. RoadRunner therefore frequently is seen on blacklists, though fatcity is not responsible for any of the spam.That's one possibility. There are others. * your mail gateway is intercepting it as spam * your company's spam filter is deleting it. * ... ? Fatcity ( aka Bruce Bergman ) provides this service to oracle-l free. As such, there's a limit to how much time he can spend on this. Bruce has become an IS director and finds that his time is rather limited. Imagine that? ;) The number of subscribers experiencing this problem, or at least reporting it, is very small. Options are to ride it out, or find a new venue for this list. As moving this list is a fair amount of work, I'm for riding it out for awhile. Jared "Stephen Andert" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/15/2004 08:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: List problemsJared/Bruce:Is this still being worked on? I'm not seeing a lot of volume noranything I've sent recently.Stephen [EMAIL PROTECTED] 01/14/04 07:54AM Folks,It seems that a fair number of emails are notbeing retransmitted to the list. Some of mineand a few others have not appeared in list trafficsent out to subscribers.Searching by author at fatcity.com reveals that the posts made it there, but either are not beingsent out, or getting shanghaied along the way.I'll let you know when I find out.I am of course, assuming that some of you willget this one...Jared-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared StillINET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Stephen AndertINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California-- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: SQL server and JOB
First, you may have to quit your job in Oracle... on 1/16/04 5:59 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: Hi , How can i create a job in sql server ? Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: UTL_FILE_DIR on 9iR2
Ah! - got it. To simplify my question I hadn't mentioned that I had more than one allowed directory, and this was where the problem lay: I did: ALTER SYSTEM SET UTL_FILE_DIR = 'directory1, directory2' SCOPE=spfile; Whereas what is required is: ALTER SYSTEM SET UTL_FILE_DIR = 'directory1','directory2' SCOPE=spfile; The first form is accepted by Oracle and looks ok in v$parameter but clearly doesn't do the same thing underneath! Good: this means I can delay implementing DIRECTORYs for a bit longer... (not that I don't want to use them, just that other things have priority) - Bill Date: Fri, 16 Jan 2004 11:15:35 + To: [EMAIL PROTECTED] From: Bill Buchan [EMAIL PROTECTED] Subject: UTL_FILE_DIR on 9iR2 Hi all, I'm looking for some clarification on UTL_FILE_DIR on 9.2. I understand that this parameter is obsolete (Metalink Note 196939.1) and that CREATE DIRECTORY should be used instead. However we wanted to persist with the old method since we already have lots of existing PL/SQL that uses a look up table to decide where to read/write files; yes we'd move to CREATE DIRECTORY eventually but not right now. I thought that although UTL_FILE_DIR was obsolete it was really just deprecated and we could continue using it as before. If UTL_FILE_DIR = '*' then all is indeed well. However if I try to restrict the directories, i.e. UTL_FILE_DIR = '/only/allowed/here' then it does not work (yes, checked filesystem privs). ERROR at line 1: ORA-29280: invalid directory path ORA-06512: at SYS.UTL_FILE, line 18 ORA-06512: at SYS.UTL_FILE, line 424 ORA-06512: at line 4 I can sort of fudge it to work: SQL create directory /only/allowed/here as '/only/allowed/here'; Directory created. SQL grant read on directory /only/allowed/here to public; Grant succeeded. It's annoying to have to create directories with quoted names the same as the paths. Have I missed something or am I just going to have to use CREATE DIRECTORY like this until we have an opportunity to change the PL/SQL? Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What is Hash Join?
Hi! Note that hash joins are very prone to extreme performance degradation when statistics outdated (don't reflect real rowcounts/sizes in tables). When optimizer decides to go with hash join because it thinks that there is 1000 rows in driving table, but there is 100 instead, all driving table hash buckets (called build partitions) won't fit into hash area and they will spill over to disk causing a multipass operation which hit temp tablespace heavily. So, with big tables, plan hash joins carefully and keep your stats up-to-date (up-to-reality). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 16, 2004 3:24 PM Thanks a lot for the information Kevin :), that's quite a light to me. So... Is it best to try to get hash join on execution plan at all time? Regards, Wendry. -Original Message- Sent: Thursday, January 15, 2004 9:09 PM To: [EMAIL PROTECTED] In my experience, Hash Joins have proven OUTSTANDING for joining two very large tables -- much faster than any other strategy. I copied the following from AskTom.oracle.com. It answers the question What is the difference between a Sort Merge and a Hash Join. From AskTom.Oracle.com: Well, a sort merge of A and B is sort of like this: read A and sort by join key to temp_a read B and sort by join key to temp_b read a record from temp_a read a record from temp_b while NOT eof on temp_a and temp_b loop if ( temp_a.key = temp_b.key ) then output joined record elsif ( temp_a.key = temp_b.key ) read a record from temp_a elsif ( temp_a.key = temp_b.key ) read a record from temp_b ) end loop (its more complex then that, the above logic assumed the join key was unique -- we really need to join every match in temp_a to every match in temp_b but you get the picture) The hash join is conceptually like: create a hash table on one of A or B (say A) on the join key creating temp_a. while NOT eof on B read a record in b hash the join key and look up into temp_a by that hash key for matching records output the matches end loop So, a hash join can sometimes be much more efficient (one hash, not two sorts) Hash joins are used any time a sort merge might be used in most cases. If you don't see hash joins going on, perhaps you have hash_join_enabled turned off... From: Wendry [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Subject: What is Hash Join? Date: Thu, 15 Jan 2004 20:39:29 +0700 Dear all, I understand join is for joining two tables, I know nested loops and sort-merge joins and I know how they work and on what situation they're used best at. But I really don't understand hash join, how are they working to join tables and on what situation they performed best? And based on what does Oracle use hash join for joining tables in the execution plan? If they use hash value, how does Oracle determine the hash value when performing hash join? I really in the dark here, please give me some light., Thank you all in advance. Regards, Wendry Get today's cartoon: http://www.LazyDBA.com Please don't reply to RTFM questions Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] By using this list you agree to these terms:http://www.lazydba.com/legal.html _ Learn how to choose, serve, and enjoy wine at Wine @ MSN. http://wine.msn.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wendry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: Connection Problem
I've asked for the out put on a lsnrctl status already, but haven't heard back from him as yet.. The . does look strange.. Also, what would the impact be to have the GLOBAL_DBNAME set to the same value for all three instances? Would it not be better to set it to the same name as the instance name for each? The same goes for port too.. I thought that all three on the same port would be OK? Cheers Mark -Original Message- Mercadante, Thomas F Sent: 16 January 2004 13:30 To: Multiple recipients of list ORACLE-L Mark, The (GLOBAL_DBNAME= l1000.) entry looks strange. Should there be a '.' in there? I've never seen this entry in this file. What does : lsnrctl status lsnrctl services show? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 16, 2004 6:14 AM To: Multiple recipients of list ORACLE-L Hi All, I'm helping out a friend of mine who's having problems with connecting from an NT system to an HP system running Oracle 8.0.5 (don't ask!). They keep getting an 12154 - Could not resolve service name error.. The TNSNAMES.ORA file looks OK, and I feel there is something iffy about their listener set up. Here's there set-up: TNSNAMES.ORA: extproc_connection_data = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = LIVE)) (CONNECT_DATA = (SID = extproc)) ) LIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = LIVE)) ) TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = TEST)) ) ARCHIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = ARCHIVE)) ) LISTENERORA: LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= FROUDE)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = LIVE) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = TEST) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = ARCHIVE) ) (SID_DESC = (SID_NAME = extproc) (ORACLE_HOME = /usr/oracle/product/8.0.5) (PROGRAM = extproc) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = OFF When he tries to connect user/[EMAIL PROTECTED] the connection fails - and the same for TEST and ARCHIVE. The thing that sticks out to me is the GLOBAL_DBNAME parameter being set to l1000 for every instance - do you think this could be causing the problem? Is there anything else that catches your eye? Cheers! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date:
Re: Checkpoint ...
I don't believe that datafiles in Read Only tablespaces have the scn updated. I've not tested it, but it is logical. Daniel Fink [EMAIL PROTECTED] wrote: All, Whenever checkpoint happens datafile header scn and controlfile scn will be in sink. Is my assumption is right? Is there any other scenarios where checkpoint only update controlfile and doesn't update datafile header? Agreed, during begin backup mode datafile header will be frozen.. Other than that any scenarios? Thanks and Regards, Satheesh Babu.S DISCLAIMER: This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel 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: Connection Problem
Mark, I don't think that all three on the same port is a problem - heck - I do it all the time. I would comment out the GLOBAL_DBNAME entry. It certainly is not required. And output from lsnrctl would be helpful. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 16, 2004 9:20 AM To: Multiple recipients of list ORACLE-L I've asked for the out put on a lsnrctl status already, but haven't heard back from him as yet.. The . does look strange.. Also, what would the impact be to have the GLOBAL_DBNAME set to the same value for all three instances? Would it not be better to set it to the same name as the instance name for each? The same goes for port too.. I thought that all three on the same port would be OK? Cheers Mark -Original Message- Mercadante, Thomas F Sent: 16 January 2004 13:30 To: Multiple recipients of list ORACLE-L Mark, The (GLOBAL_DBNAME= l1000.) entry looks strange. Should there be a '.' in there? I've never seen this entry in this file. What does : lsnrctl status lsnrctl services show? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 16, 2004 6:14 AM To: Multiple recipients of list ORACLE-L Hi All, I'm helping out a friend of mine who's having problems with connecting from an NT system to an HP system running Oracle 8.0.5 (don't ask!). They keep getting an 12154 - Could not resolve service name error.. The TNSNAMES.ORA file looks OK, and I feel there is something iffy about their listener set up. Here's there set-up: TNSNAMES.ORA: extproc_connection_data = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = LIVE)) (CONNECT_DATA = (SID = extproc)) ) LIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = LIVE)) ) TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = TEST)) ) ARCHIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = ARCHIVE)) ) LISTENERORA: LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= FROUDE)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = LIVE) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = TEST) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = ARCHIVE) ) (SID_DESC = (SID_NAME = extproc) (ORACLE_HOME = /usr/oracle/product/8.0.5) (PROGRAM = extproc) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = OFF When he tries to connect user/[EMAIL PROTECTED] the connection fails - and the same for TEST and ARCHIVE. The thing that sticks out to me is the GLOBAL_DBNAME parameter being set to l1000 for every instance - do you think this could be causing the problem? Is there anything else that catches your eye? Cheers! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP
ORA-904 after table rename
We're developing some schema update scripts for an in-house application, which includes renaming an existing table, and creating a new version using the original name. No problem... or so I thought. :( All seems well under OEM and SQL+, but I have a developer who consistently gets an ORA-904 error (invalid column name) when trying to access the new table under TOAD. I can't think of anything weird about this table, except that the original has some column-level grants (but not to his userid... he has select/insert/update/delete on both tables). I had him try exiting and restarting TOAD, in case it was caching something relevant, but that didn't make any apparent difference. Any idea what might be going on? SQL desc tool_request_old NameNull?Type --- TREQ_TOOLS_REQUEST_PKEY NOT NULL NUMBER(6) TREQ_PEOPLE_FKEYNOT NULL NUMBER(6) TREQ_SUBMIT_DATENOT NULL DATE TREQ_COMPLETE_DATE DATE TREQ_STATUS NOT NULL NUMBER(6) TREQ_COMMENTSVARCHAR2(2024) TREQ_BYPASS_STARTDATE TREQ_BYPASS_END DATE SQL desc tool_request NameNull?Type --- TREQ_ID NOT NULL NUMBER(6) TREQ_PERS_IDNOT NULL NUMBER(6) TREQ_STATUS_ID NOT NULL NUMBER(6) TREQ_SUBMIT_TMSTNOT NULL DATE TREQ_BYPASS_START_TMST DATE TREQ_BYPASS_END_TMST DATE TREQ_COMPLETE_TMST DATE TREQ_COMMENTSVARCHAR2(1024) -- My employers like me, but not enough to let me speak for them. Greg Norris Sprint LTD Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-904 after table rename
Does his version of TOAD support your Oracle server version ? We tried to run our (outdated) version of SQL Navigator against a 9i DB and would get weirdness like this from time to time when accessing the Oracle data dictionary. mvg/regards Jo Norris, Gregory T [ITS] [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/16/2004 16:09 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:ORA-904 after table rename We're developing some schema update scripts for an in-house application, which includes renaming an existing table, and creating a new version using the original name. No problem... or so I thought. :( All seems well under OEM and SQL+, but I have a developer who consistently gets an ORA-904 error (invalid column name) when trying to access the new table under TOAD. I can't think of anything weird about this table, except that the original has some column-level grants (but not to his userid... he has select/insert/update/delete on both tables). I had him try exiting and restarting TOAD, in case it was caching something relevant, but that didn't make any apparent difference. Any idea what might be going on? SQL desc tool_request_old NameNull?Type --- TREQ_TOOLS_REQUEST_PKEY NOT NULL NUMBER(6) TREQ_PEOPLE_FKEYNOT NULL NUMBER(6) TREQ_SUBMIT_DATENOT NULL DATE TREQ_COMPLETE_DATE DATE TREQ_STATUS NOT NULL NUMBER(6) TREQ_COMMENTSVARCHAR2(2024) TREQ_BYPASS_STARTDATE TREQ_BYPASS_END DATE SQL desc tool_request NameNull?Type --- TREQ_ID NOT NULL NUMBER(6) TREQ_PERS_IDNOT NULL NUMBER(6) TREQ_STATUS_ID NOT NULL NUMBER(6) TREQ_SUBMIT_TMSTNOT NULL DATE TREQ_BYPASS_START_TMST DATE TREQ_BYPASS_END_TMST DATE TREQ_COMPLETE_TMST DATE TREQ_COMMENTSVARCHAR2(1024) -- My employers like me, but not enough to let me speak for them. Greg Norris Sprint LTD Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Connection Problem
I don't believe a 12154 error has anything to do with the listener. The request never leaves the client. It has all to do with the fact that sqlnet on the client can not find the service name in the tnsnames.ora. What is names.default.domain set to in sqlnet.ora. If there is no sqlnet.ora try appending .world to the servicenames in the tnsnames.ora (e.f. LIVE.WORLD = .) At 04:14 AM 1/16/2004, you wrote: Hi All, I'm helping out a friend of mine who's having problems with connecting from an NT system to an HP system running Oracle 8.0.5 (don't ask!). They keep getting an 12154 - Could not resolve service name error.. The TNSNAMES.ORA file looks OK, and I feel there is something iffy about their listener set up. Here's there set-up: TNSNAMES.ORA: extproc_connection_data = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = LIVE)) (CONNECT_DATA = (SID = extproc)) ) LIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = LIVE)) ) TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = TEST)) ) ARCHIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = ARCHIVE)) ) LISTENERORA: LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= FROUDE)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = LIVE) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = TEST) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = ARCHIVE) ) (SID_DESC = (SID_NAME = extproc) (ORACLE_HOME = /usr/oracle/product/8.0.5) (PROGRAM = extproc) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = OFF When he tries to connect user/[EMAIL PROTECTED] the connection fails - and the same for TEST and ARCHIVE. The thing that sticks out to me is the GLOBAL_DBNAME parameter being set to l1000 for every instance - do you think this could be causing the problem? Is there anything else that catches your eye? Cheers! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Oracle7, 8, 8i, 9i OCP DBA 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).
Re: Checkpoint ...
Yep, you're correct, everything is frozen in datafiles when they're in read only mode (you can have read only datafiles on read only media if you want). Also, no controlfile records (like checkpoint cnt, checkpoint scn) for read only datafiles are not changed, I've verified this with controlfile dumps and diff just in case. As you said, it's logical. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 16, 2004 4:39 PM I don't believe that datafiles in Read Only tablespaces have the scn updated. I've not tested it, but it is logical. Daniel Fink [EMAIL PROTECTED] wrote: All, Whenever checkpoint happens datafile header scn and controlfile scn will be in sink. Is my assumption is right? Is there any other scenarios where checkpoint only update controlfile and doesn't update datafile header? Agreed, during begin backup mode datafile header will be frozen.. Other than that any scenarios? Thanks and Regards, Satheesh Babu.S DISCLAIMER: This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Checkpoint ...
Whenever checkpoint happens datafile header scn and controlfile scn will be in sink. Is my assumption is right? Is there any other scenarios where checkpoint only update controlfile and doesn't update datafile header? Agreed, during begin backup mode datafile header will be frozen.. Other than that any scenarios? Note that not the *whole* header of a datafile is *not* frozen during backup mode, only the checkpoint_scn and checkpoint_time structure in it are (+ possibly few others), but for example checkpoint_count for this datafile still keeps incrementing due checkpoints. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Checkpoint ...
Whenever checkpoint happens datafile header scn and controlfile scn will be in sink. Is my assumption is right? Is there any other scenarios where checkpoint only update controlfile and doesn't update datafile header? Agreed, during begin backup mode datafile header will be frozen.. Other than that any scenarios? Note that not the *whole* header of a datafile is *not* frozen during backup mode, only the checkpoint_scn and checkpoint_time structure in it are (+ possibly few others), but for example checkpoint_count for this datafile still keeps incrementing due checkpoints. I got too carried away with not-s here... Anyway, the idea is that only few structures in datafile header are frozen during backup mode, but some may change as usual. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBMS_OBFUSCATION_TOOLKIT
Hi Listers, Does the Oracle dbms_obfuscation_toolkit (DOT) support generating a non-randomized encrypted result? In other words, can we encrypt something like international and get the same encrypted result each time we pass international to the DOT? - Paula W. Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
RMOUG Training Days 2004
The Rocky Mountain Oracle User Group Training Days is just around the corner. Come join us for 2 days of technical presentations, vendor exhibits and networking. Among the speakers are oracle-l contributors Tim Gorman, Rachel Carmichael, Cary Millsap, Anjo Kolk, Tanel Poder, Daniel Fink, Don Burleson, Stephen Andert, Kirti Deshpande, Peter Sharman, William Thater and April Wells. Other notables include Bill Inmon, Tom Kyte, Craig Shallahamer, John King, Stephen Haisley, John Beresniewicz, Mike Ault, Brad Brown and Gary Dodge. We will be meeting at the Colorado Convention Center in Denver Colorado on February 11th and 12th. Come for the technical sessions and then spend the weekend skiing in the fabulous Rocky Mountains. For more information, including cost (very, very reasonable) and a full schedule, go to www.rmoug.org. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel 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).
How to update maxphys on Solaris 8 ......
Dear List, Could someone tell me how to update the parameter "maxphys" on sun solaris 8 system. At present it is having a default value of 128K. I would like to change it to 1MB. There is no such parameter in /etc/system. I need this parameter to be updated as it seems to be controlling the MAX_IO_SIZE on the platform. -- Janardhana
Reasonable layout for DSS
Does this layout seem reasonable as a starting point for a Windows 2003/Oracle 9.2 DSS database? Volume 0 Mirrored 33 GB OS (Windows 2003) Volume 1 Mirrored 33 GB Oracle Home / Archive Logs / UNDO Volume 2 Mirrored 33 GB Redo / Temp / System Volume 3 RAID 5 409 GB Data1 / Index2 Volume 4 RAID 5 409 GB Data2 / Index1 It's possible I could get the sa to split out another set of Mirrored drives from one of the RAID 5 volumes, but it was like pulling teeth to get any non-RAID 5 volumes. Keith H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry, Keith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how to hide oracle password from a unix ps -ef | grep?
Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it?
a quick pl/sql question
Hi: In pl/sql, I want to add chr(10) into a string in every 70th position. The string can be up to 2000 characters long. The follwoing code works. But is there an even FASTER way to do this? Thanks. Guang --- declare pos number := 1; len number; buf varchar2(2000); x varchar2(2100); begin buf := '012345678901234567890123456789012345678901234567890123456789012345678901234 5678901234567890123456789012345678901234567890123456789012345678901234567890 12345678901234567890123456789012345678901234567890123456789A'; len := length(buf); while pos=len loop x := x || substr(buf, pos, 70) || chr(10); pos := pos+70; end loop; end; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to hide oracle password from a unix ps -ef | grep?
Sure. Create the database userid so that it is authenticated externally (Identfied externally). Then the userid can log in via SQL*Plus using a / instead of a userid or password. The OS userid should be a controlled account so that everyone and his grandmother cannot log into it. If it is a matter of encryption, turn on encryption by adding the encryption login parameter to the sqlnet.ora file. RWB Reginald W. Bailey IBM Global Services JPMC Account - DCI ETS Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] ox.net To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: how to hide oracle password from a unix ps -ef | grep? ity.com 01/16/2004 12:04 PM Please respond to ORACLE-L Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to hide oracle password from a unix ps -ef | grep?
Create a dummy user dummy with pw as dummy and only with create session priv. Execute a sql script which will connect to the username/pw and which does not have read privs at os level for others. May be someone on the list has a better idea. HTH GovindanK On Fri, 16 Jan 2004 10:04:35 -0800, Ryan [EMAIL PROTECTED] said: Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it? -- http://www.fastmail.fm - Same, same, but different -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to hide oracle password from a unix ps -ef | grep?
Ryan wrote: Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it? Try http://asktom.oracle.com/pls/ask/f?p=4950:8:12188015396454707431::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:142212348066, -- Bricklen Anderson, Database Administrator PresiNET Systems http://www.PresiNET.com Live Demo: https://www.presinet.com/secure/login -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to hide oracle password from a unix ps -ef | grep?
Title: Message You can do any of: sqlplus /nolog connect user/[EMAIL PROTECTED] export TWO_TASK=whatever sqlplus user Password: xxx sqlplus [EMAIL PROTECTED] Password: xxx Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown -Original Message-From: Ryan [mailto:[EMAIL PROTECTED] Sent: Friday, January 16, 2004 1:05 PMTo: Multiple recipients of list ORACLE-LSubject: how to hide oracle password from a unix ps -ef | grep? Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it?
RE: how to hide oracle password from a unix ps -ef | grep?
start sqlplus then loginif a script is executing start sqlplus with /nolog then issue a connect command in the script... place the script in a secure location -Original Message-From: Ryan [mailto:[EMAIL PROTECTED]Sent: Friday, January 16, 2004 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: how to hide oracle password from a unix ps -ef | grep? Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it?
Re: how to hide oracle password from a unix ps -ef | grep?
Few ideas: 1) sqlplus /nolog connect user/[EMAIL PROTECTED] 2). $HOME/.orapwd sqlplus user/[EMAIL PROTECTED] (.orapwd script has to set environment variable ORAPWD to the password) 3) sqlplus [EMAIL PROTECTED] $HOME/.orapwd (.orapwd must contain one line, the password) Tanel. - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Friday, January 16, 2004 8:04 PM Subject: how to hide oracle password from a unix ps -ef | grep? Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it?
Re: how to hide oracle password from a unix ps -ef | grep?
Ryan, check this out, if you haven't looked it already, it might help. http://www.orafaq.org/faqunix.htm#HIDEPSW thanks, senthil - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Friday, January 16, 2004 1:04 PM Subject: how to hide oracle password from a unix ps -ef | grep? Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it?
Re: how to hide oracle password from a unix ps -ef | grep?
Google for hide.c -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to hide oracle password from a unix ps -ef | grep?
On 01/16/2004 01:34:45 PM, Tanel Poder wrote: Few ideas: 1) sqlplus /nolog connect user/[EMAIL PROTECTED] This requres putting ASCII (non-encrypted) password in the SQL script. Not very safe. 2) . $HOME/.orapwd sqlplus user/[EMAIL PROTECTED] This will actually show password because shell will interpret the ORAPWD variable before passing the arguments to fork/exec combination. Password will be clearly visible by ps -ef. (.orapwd script has to set environment variable ORAPWD to the password) 3) sqlplus [EMAIL PROTECTED] $HOME/.orapwd (.orapwd must contain one line, the password) This is semi-decent because password is still in an ASCII file, but hidden. Root (SA) can still read it. If that's acceptable, it's OK, provided that the protection mask is set properly. I would add 4) CREATE USER OPS$MLADEN identified externally - that uses OS authorization and can be easily cracked by root (su -) 5) Oracle advanced security. That is the best answer, supporting Radius, Kerberos and biometrics, but costs $$. I would use 4, despite oracle's claims that this type of authorization is discouraged or deprecated. So is RBO and yet it lives on. That is only a marketing pitch. -- 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: Anyone using IBM's Flashcopy for hotbacks?
Rich, As I had indicated in a previous post on a similar topic, you will need to minimize writes to the SAN during a mirror split during FlashCopy (in IBM, BCV in EMC and ShadowImage in Hitachi). In my limited understanding, once the command to split is received by the SAN, it has to make sure that the write cache is *completely* written to disk. Taking on Tim G's excellent analogy of likening a SAN disk cache to a water tank with an inlet at one end and an outlet on the other, and the requirement of all writes to be written to disk during split, it becomes evident that the SAN has to very quickly bleed off the write cache as well as freeze or somehow delay writes during this time. An ALTER SYSTEM SUSPEND might help during the split. I have seen a 'runaway' Hash join very quickly fill up TEMP using direct writes and considerably delay splits. I really don't see any *read* related problems though at the time of split... YMMV! John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Thursday, January 15, 2004 2:39 PM To: Multiple recipients of list ORACLE-L Subject: Anyone using IBM's Flashcopy for hotbacks? We're considering an IBM FAStT SAN for a 30GB Oracle9i DB on HP/UX 11i. One option with the FAStT is called FlashCopy. It's been six months since I've last looked at this, but our original idea was to smack all TSs into backup mode, FlashCopy, then smack all TSs out of backup mode. We'd also need to dump the copy to tape, then startup this copy as another instance, so the Tivoli plugin to have RMAN manage this probably wouldn't be worth the money for us. So, has anyone done this? Which FlashCopy options did you use? Any major gotchas to not do this? Does the Flash cause I/O problems during the backup due to the block reads from the original DB? TIA, Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to hide oracle password from a unix ps -ef | grep?
2) . $HOME/.orapwd sqlplus user/[EMAIL PROTECTED] This will actually show password because shell will interpret the ORAPWD variable before passing the arguments to fork/exec combination. Password will be clearly visible by ps -ef. Yep, you're right... I missed this somehow... Thanks, Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DBMS_OBFUSCATION_TOOLKIT
Yes. As long as your KEY_STRING is same, the encrypted value will be the same. Consider: SQL exec :i := rawtohex(utl_raw.cast_to_raw (dbms_obfuscation_toolkit.DES3Encrypt (input_string='12345678', key_string='123456789012345678901234'))) PL/SQL procedure successfully completed. SQL print i I--FB90F134036ABD29 Do it again. SQL exec :i := rawtohex(utl_raw.cast_to_raw (dbms_obfuscation_toolkit.DES3Encrypt (input_string='12345678', key_string='123456789012345678901234'))) PL/SQL procedure successfully completed. SQL print i IFB90F134036ABD29 The encrypted version is the same. This also brings up another good point - the key plays a vital role in the encryption process and should be as randomized as possible. In Oracle 9i you have the DESGetKey function. The other question is why do you want to do this? Perhaps you are trying to build a integrity assurance system that calculates an encrypted value before delivery, and then after delivery to confirm that data has not been tampered with in transit. If so, I would receommend using a hash, not encryption, i.e. MD5 procedure in the same package. It's less taxing on resources and does exactly what you want to do. Key management becomes easier in hashing, too. Hope this helps. Arup - Original Message - From: Paula Winkler To: Multiple recipients of list ORACLE-L Sent: Friday, January 16, 2004 11:24 AM Subject: DBMS_OBFUSCATION_TOOLKIT Hi Listers, Does the Oracle dbms_obfuscation_toolkit (DOT) support generating a non-randomized encrypted result? In other words, can we encrypt something like international and get the same encrypted result each time we pass international to the DOT? - Paula W. Do you Yahoo!?Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
OT:Legato Network Port
Hi all We are trying to restore thru RMAN/LEGATO and we run into NetWorker: Cannot bind socket to connection port in configured port range on system server.domain A quick search in google and Legato provided the following: quote The message, Cannot bind socket to connection port range on system XXX, can be seen in the savegroup messages or in stdout during manual operations. You must increase the connection port range on system XXX. A corresponding change is also required in the firewall rules. /quote I don't see any port info in the error message i got. Any ideas? TIA GovindanK -- http://www.fastmail.fm - Same, same, but different -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to hide oracle password from a unix ps -ef | grep?
One more... sqlplus EOFusername/password statement1; statement2; exit EOF -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Friday, January 16, 2004 12:35 PMTo: Multiple recipients of list ORACLE-LSubject: Re: how to hide oracle password from a unix ps -ef | grep? Few ideas: 1) sqlplus /nolog connect user/[EMAIL PROTECTED] 2). $HOME/.orapwd sqlplus user/[EMAIL PROTECTED] (.orapwd script has to set environment variable ORAPWD to the password) 3) sqlplus [EMAIL PROTECTED] $HOME/.orapwd (.orapwd must contain one line, the password) Tanel. - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Friday, January 16, 2004 8:04 PM Subject: how to hide oracle password from a unix ps -ef | grep? Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it?
Rename tablespace in 9I
Is there anyway to rename tablespace in Oracle 9202. Thanks DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. -- 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).
Workspace Manager Questions
Hello, I have some Workspace Manager Questions and I'm interested in general opinions/feelings about it. A little bit of background first: Our database is about 450GB, and we maintain a separate production and development instance. Multiple projects share the same instance, and the same tables, but they have different and overlapping data build and release cycles. When we migrate, we clone the database by putting it in online backup mode, copy the datafiles, and then restore as a new (production) instance. Obviously we're currently only in a position to release/migrate at the lowest common denominator, which creates downtime for the projects with significantly faster build cycles. We run 9iR2 on SuSE Enterprise. I'm interested in introducing Oracle's Workspace Manager in hopes of allowing migrations to occur while some projects are still in mid-build, and I'm curious about some of the following issues: 1) Reliability using Workspace Manager -- Each workspace has the potential to be up to 100 GB large and span several hundred tables. 2) Impact of conducting a migration while a workspace is open. -- I assume it wouldn't be a problem-- just extra data to copy, and a little bit of clean up time afterwards in production clearing out the open workspaces? 3) Feasibility of merging a workspace of this size back into the database -- Fortunately I don't foresee there to be significant conflicts during the merger 4) Best I can tell, the use of Workspace Manager wouldn't require any significant code changes. Is this correct? Any other Gotchas or things I should know about Workspace Manager? Any other opinions or approaches to solving this problem? We're also exploring the possibility of just giving each project its own instance, but there are significant shared data and projects which rely on the data as whole. (And yes, we have explored database links as a solution to this last point). Thanks much in advance for the insight wisdom. --Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Saffitz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SLA/metrics for RFP for programming services
Title: SLA/metrics for RFP for programming services If you were to write up a RFP for programming services, what kind, if any, metrics would you include to provide some measurements by which performance of the contract can be assessed? The tasks will typically be writing up ETL runs for our DW. CPU, LIO, wait events, etc? Thanks! Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba
Re: Anyone using IBM's Flashcopy for hotbacks?
We have been using Hitachi and EMC SANs. The procedure is 1. Issue BEGIN BACKUP commands for *ALL* the Tablespaces 2. Use the SAN's commands to split the ShadowImage or FlashCopy for the DataFiles FileSystems 3. Issue END BACKUP commands 4. Issue an ARCHIVELOG CURRENT command [and we also BACKUP CONTROLFILE to the ArchiveLog FileSystem] 5. split the ArchiveLog FileSystem 6. Backup the split images of the DataFiles and ArchiveLogs -- Here I believe that it depends on whether use a SnapShot or SnapClone. If you use a SnapClone [ie an exact duplicate of the data is made available, also called ShadowImage or BCV], you'd have to wait till you backup this complete SnapClone before you proceed to the next step. If you use a SnapShot [ie the storage retains metadata information and maps all changed blocks], you can drop the SnapShot after completing the backup. 6. ReSync/Resilver the image. The active database is continuously available. The ALTER SYSTEM SUSPEND command in Oracle will actually freeze all I/O. Check with IBM about how I/O to disk is completed when you split the images. The Storage must guarantee that all I/O has been completed against the SnapClone image before the command returns to your script which then issues END BACKUP commands. The Storage provider should be providing templates of the command scripts where you can plug-in your Oracle ALTER ... commands. Hemant For information on SnapShot and SnapClone see http://searchstorage.techtarget.com/infoCenter/askTheExpertsAnswer/0,294272,sid5_gci938037_tax294583,00.html Hemant At 02:39 PM 15-01-04 -0800, you wrote: We're considering an IBM FAStT SAN for a 30GB Oracle9i DB on HP/UX 11i. One option with the FAStT is called FlashCopy. It's been six months since I've last looked at this, but our original idea was to smack all TSs into backup mode, FlashCopy, then smack all TSs out of backup mode. We'd also need to dump the copy to tape, then startup this copy as another instance, so the Tivoli plugin to have RMAN manage this probably wouldn't be worth the money for us. So, has anyone done this? Which FlashCopy options did you use? Any major gotchas to not do this? Does the Flash cause I/O problems during the backup due to the block reads from the original DB? TIA, Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
(Non)Unique Index Vs Unique Constraint
All, Please enlighten this Junior DBA. Which method is more efficient? When should I go for option (1)? 1)NON-UNIQUE index Vs Unique Constraint drop table index_test; create table index_test(c1 number,c2 varchar2(20)); create index i1 on index_test(c1); alter table index_test add constraint index_test_uk1 UNIQUE(c1); 2)UNIQUE index Vs Unique Constraint drop table index_test; create table index_test(c1 number,c2 varchar2(20)); create UNIQUE index i1 on index_test(c1); alter table index_test add constraint index_test_uk1 UNIQUE(c1); Thanks in advance, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SLA/metrics for RFP for programming services
Title: Re: SLA/metrics for RFP for programming services How about specific deliverables within a specific period of time for a total amount not-to-exceed? Cant think of any other metrics that matter... on 1/16/04 2:19 PM, Thomas Jeff at [EMAIL PROTECTED] wrote: If you were to write up a RFP for programming services, what kind, if any, metrics would you include to provide some measurements by which performance of the contract can be assessed? The tasks will typically be writing up ETL runs for our DW. CPU, LIO, wait events, etc? Thanks! Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba http://gkmqp.tce.com/tis_dba