Re: Upgrading Database to 8.1.74 - RMAN still 8.1.6
As I suspected, now I have to break the news , without breaking the person thanks jared - Original Message - Date: Tuesday, February 18, 2003 8:43 am You can't register and 8.1.7 database in an 8.1.6 catalog. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/17/2003 08:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L ORACLE- [EMAIL PROTECTED]cc: Subject:Re: Upgrading Database to 8.1.74 - RMAN still 8.1.6 We are upgrading to 8.1.7.4. There are many databases and my DBA college who is in charge of the RMAN Database that is currently 8.1.6. tells me that it is no problem that RMAN (Seperate database by the way) is in 8.1.6 and the Target is in 8.1.7.4. As RMAN is hot topic right now and before I go RTFM can anybody verify this or advise thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --- -- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --- -- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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 make sql prompt like USER@DATABASE ?
Sorry, I missed your question earlier (too busy to check all the mails everyday).. In the last line of my last mail I had mentioned that Alternatively you can create a file with above lines, put that file in bin and call it anytime to make your prompt... So you can create a file say con1.sql (in your bin directory) with following content ACCEPT USER CHAR PROMPT 'User: ' ACCEPT PSWD CHAR PROMPT 'Password: ' HIDE ACCEPT DBNAME CHAR PROMPT 'Database: ' CONNECT USER@DBNAME/PSWD set heading off set term off set feedback off spool myprompt.lst select 'set sqlprompt ' || SYS_CONTEXT ('USERENV', 'session_user') || '@' || SYS_CONTEXT ('USERENV', 'DB_NAME') || '' from dual / spool off @myprompt.lst set heading on set term on set feedback on While reconnecting from existing sql session you can call con1.sql and have your prompt set. Cheers, Rajesh mm... what if i logged in with SYSTEM first then conn sys/pswd@db? it's still show SYSTEM @db. - Original Message - From: Rajesh Dayal To: Multiple recipients of list ORACLE-L Sent: Saturday, February 15, 2003 6:53 PM Subject: RE: how to make sql prompt like USER@DATABASE ? You can add following lines to your glogin.sql ($ORACLE_HOME/sqlplus/admin directory) file. set heading off set term off set feedback off spool myprompt.sql select 'set sqlprompt ' || SYS_CONTEXT ('USERENV', 'session_user') || '@' || SYS_CONTEXT ('USERENV', 'DB_NAME') || '' from dual / spool off @myprompt.sql set heading on set term on set feedback on Alternatively you can create a file with above lines, put that file in bin and call it anytime to make your prompt... Cheers, Rajesh Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Salaheldin Aboali Sent: Saturday, February 15, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: how to make sql prompt like USER@DATABASE ? hi how to make sql prompt like USER@DATABASE ? where USER: connected user DATABASE: database global name, or database local alias Regards, Salaheldin Aboali --- Senior Software Developer Management Information Systems http://www.mis-kuwait.com Phone: +965.240.64.25 +965.240.67.98 +965.240.80.92 Ext. 235 Fax. +965.240.81.53 Cell. +965.790.31.65
RMAN Upgrading to 8.1.74. Voices in my head.
RMAN (non)compatability, Recently I ran into a problem myself: o Target DBs (NT W2k) were at 8.1.7.0 and catalog (Solaris) was at 8.1.7.2 (backups controlled from here using cron). o Test recovery scenarios completed OK (Voice in head says, 'NEW TO RMAN, GOTTA TEST!). o A couple of months ago some NT DBs were upgraded to 8.1.7.4 but RMAN did not complain! o Last week a restore of an 8.1.7.4 datafile was required but RMAN kept giving an error including the text: ...PLS-00302: Component 'LOCKFORCKPT' must be declared... (voices in head says, Got that CV up to date?) Solution: Luckily - we still had nightly cold backups that we hadn't got around to stopping yet! So I was able to do a full cold restore (Also luckily only a test DB) Voice in my head says to me, 'MIKE THIS IS YOUR WARNING - UPGRADE RMAN CATALOG BEFORE A LIVE DATABASE GOES SCREWY!' I upgraded RMAN catalog DB to 8.1.7.4 and issued the upgrade catalog command. SOMETIMES INCOMPATIBILITY WILL LET YOU BACK UP BUT NOT RESTORE! (Voice in head asks, 'RMAN - What is it good for, huh?'. There's an RMAN compatibility matrix on metalink (a bit confusing) and a note that is quite clear regarding 8.1.7.4. I've lost the doc ids but a search will find them. - Mike. -Original Message- Sent: 18 February 2003 04:14 To: Multiple recipients of list ORACLE-L We are upgrading to 8.1.7.4. There are many databases and my DBA college who is in charge of the RMAN Database that is currently 8.1.6. tells me that it is no problem that RMAN (Seperate database by the way) is in 8.1.6 and the Target is in 8.1.7.4. As RMAN is hot topic right now and before I go RTFM can anybody verify this or advise thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: metadata repository
'Databee' may just be appropriate here. Its free. Visit www.databaee.com peter ps - got in there before you, Dale! -Original Message- Sent: 14 February 2003 19:49 To: Multiple recipients of list ORACLE-L Is anybody aware of a freeware metadata repository tool that is configurable enough to capture metadata attributes that the business would value? For example, to capture information about columns such as length, aliases, valid values ... Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reconfiguring datafiles
first, you listed only two datafiles second, why on earth would you want to move the data? just add datafile x2 to the tablespace and let Oracle keep going --- Sony kristanto [EMAIL PROTECTED] wrote: Dear Listers, Would someone on this list help me to solve these problems, 1. I've three datafiles x1 and x2 2. If datafile x1 is full, I want it is automaticaly move to datafile x2 including all data in datafile x1. 3. If it is possible how to do it. Many thanks for respons and all comments would be appreciated. Kind rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Optimizer help, get query to run as good as with RULE hint
Glenn What is the execution plan _without_ the DISTINCT? I'd be willing to bet that it uses the same indexes as the RBO. If so, try the following: SELECT /*+ NO_MERGE(x) */ DISTINCT * FROM(original query without the distinct) x; Kevin -Original Message- Sent: Friday, February 14, 2003 11:04 AM To: Multiple recipients of list ORACLE-L I have a problem query which will not complete. This query is part of a report run within Oracle Applications. Our versions are: Oracle Server 8.1.7.4, Apps 11.5.3, HP-UX 11.11 Listed below is the query and the explain plan. I ran full statistics on all the tables immediately before executing the query. Using the CBO, it never returns. I cancel the query, but it won't die until I kill the unix process. If I use the /*+ RULE */ hint, the query plan (also listed below) changes dramatically and the query executes in 30 seconds. What could cause the optimizer to behave so differently? We cannot change our instance to RBO, as it would adversely affect everything else and Apps requires CBO anyway. Any suggestions on what else I could do to improve the explain plan withou having to use the hint? (I've tried setting optimizer_index_cost_adj=10, and it changes the plan a little but still does not complete). 1 SELECT COUNT(*) 2 FROM HZ_CUST_ACCT_SITES ACCT_SITE,HZ_PARTY_SITES PARTY_SITE, 3 HZ_LOCATIONS LOC,HZ_LOC_ASSIGNMENTS LOC_ASSIGN 4 WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID 5 AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID 6 AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID 7 AND NVL(ACCT_SITE.ORG_ID,-99) = NVL(LOC_ASSIGN.ORG_ID,-99) 8* ; Id Par Pos Ins Plan - -- 0 3218SELECT STATEMENT (choose) Cost,rows,bytes (3218,1,31) 10 1 SORT(aggregate) 21 1NESTED LOOPS Cost,rows,bytes (3218,1466,45446) 32 1 HASH JOIN Cost,rows,bytes (3218,617422807,16052992982) 43 1HASH JOIN Cost,rows,bytes (2681,4307,77526) 54 15 TABLE ACCESS (analyzed) AR HZ_CUST_ACCT_SITES_ALL (full) Cost,rows,bytes (1263,4307,34456) 64 22 TABLE ACCESS (analyzed) AR HZ_PARTY_SITES (full) Cost,rows,bytes (1414,493760,4937600) 73 24 TABLE ACCESS (analyzed) AR HZ_LOC_ASSIGNMENTS (full) Cost,rows,bytes (533,430060,3440480) 82 2 INDEX (analyzed) UNIQUE AR HZ_LOCATIONS_U1 (unique scan) Using the RULE hint (completes in 30 seconds): 1 SELECT /*+ RULE */ COUNT(*) 2 FROM HZ_CUST_ACCT_SITES ACCT_SITE,HZ_PARTY_SITES PARTY_SITE, 3 HZ_LOCATIONS LOC,HZ_LOC_ASSIGNMENTS LOC_ASSIGN 4 WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID 5 AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID 6 AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID 7 AND NVL(ACCT_SITE.ORG_ID,-99) = NVL(LOC_ASSIGN.ORG_ID,-99) 8* ; Id Par Pos Ins Plan - -- 0 SELECT STATEMENT (hint: rule) 10 1 SORT(aggregate) 21 1NESTED LOOPS 32 1 NESTED LOOPS 43 1NESTED LOOPS 54 14 TABLE ACCESS (analyzed) AR HZ_LOC_ASSIGNMENTS (full) 64 2 INDEX (analyzed) UNIQUE AR HZ_LOCATIONS_U1 (unique scan) 73 22 TABLE ACCESS (analyzed) AR HZ_PARTY_SITES (by index rowid) 87 1 INDEX (analyzed) NON-UNIQUE AR HZ_PARTY_SITES_N2 (range scan) 92 25 TABLE ACCESS (analyzed) AR HZ_CUST_ACCT_SITES_ALL (by index rowid) 109 1INDEX (analyzed) NON-UNIQUE AR HZ_CUST_ACCT_SITES_N1 (range scan) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Reconfiguring datafiles
Good point H ;-) -Original Message- Carmichael Sent: Tuesday, February 18, 2003 3:44 PM To: Multiple recipients of list ORACLE-L first, you listed only two datafiles second, why on earth would you want to move the data? just add datafile x2 to the tablespace and let Oracle keep going --- Sony kristanto [EMAIL PROTECTED] wrote: Dear Listers, Would someone on this list help me to solve these problems, 1. I've three datafiles x1 and x2 2. If datafile x1 is full, I want it is automaticaly move to datafile x2 including all data in datafile x1. 3. If it is possible how to do it. Many thanks for respons and all comments would be appreciated. Kind rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: metadata repository
Hi Rabson I think www.databaee.com is not found Can pls send the right one Regards Natesh G.S -Original Message- Sent: Tuesday, February 18, 2003 4:04 PM To: Multiple recipients of list ORACLE-L 'Databee' may just be appropriate here. Its free. Visit www.databaee.com peter ps - got in there before you, Dale! -Original Message- Sent: 14 February 2003 19:49 To: Multiple recipients of list ORACLE-L Is anybody aware of a freeware metadata repository tool that is configurable enough to capture metadata attributes that the business would value? For example, to capture information about columns such as length, aliases, valid values ... Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Q] how to setup OEM check DB down and notify user?
We have OEM 2.X on NT server to monitor the ORACLE 8.1.7 databases. does anyone know how to setup OEM to check databases down and notify DBA either by E-mail or phone? Thanks. _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 alert #51 - is bug fix in 8.1.7.4.7 for win32 (W2K on
The readme is incorrect, the fix for Windows will be available in 8.1.7.4.8. Pat. -Original Message- Sent: Friday, February 14, 2003 4:39 PM To: Multiple recipients of list ORACLE-L on Patrice, Thanks for replying. Others replied stating that the fix for bug 2620726 is not in 8.1.7.4.7. In the Alert #51 body, it listed that the patch was planned to be in Patch Set 7 for Win32. There is some confusion, at least as far as I am concerned, as to whether 8.1.7.4.7 is patch set 7 or not. Apparently, patch_set_7 != '8.1.7.4.7', at least for Win32. The good news then, is no patches to be applied this weekend. Yeah! Paul -Original Message- Sent: Friday, February 14, 2003 3:09 PM To: Multiple recipients of list ORACLE-L on Inte From the readme file, the 8.1.7.4.7. patch for win32 only contains one item over and above 8.1.7.4.6: par Bug Base Bug Category Description \par - --- \par 2790160 2787968 NET INAPPROPRIATE MESSAGE ON ERROR CONDITION \par THAT SHOULD NEVER OCCUR \par Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Friday, February 14, 2003 2:53 PM To: Multiple recipients of list ORACLE-L Inte Hi. I've been on digest mode on this list for quite awhile. When I received the alert from Oracle this morning, I set the list to NODIGEST. I'm just now receiving emails realtime. I'm sure that this subject was already covered on the list today, so I apologize in advance for posting a probably redundant subject. Does anyone know if the fix for the bug #2620726 covered in alert #51 is included in 8.1.7.4.7? It is not mentioned in the readme. Does anyone aware of a known exploit existing for this vulnerability? I have scanned the following sites, but found no annoucements except for those released by Oracle. http://metalink.oracle.com alerts 48-52 http://otn.oracle.com/deploy/security/alerts.htmalerts 48-52 http://www.securityfocus.com/ 2/14/2003 1:02:12 PM nothing http://www.cert.org 2/14/2003 1:02:53 PM nothing http://www.sans.org 2/14/2003 1:04:19 PM nothing http://www.appsecinc.com/resources/alerts/oracle/ 2/14/2003 1:20:23 PM nothing http://www.treachery.net/ 2/14/2003 1:43:18 PM nothing http://online.securityfocus.com/archive/1 2/14/2003 1:44:04 PM nothing http://www.rootprompt.org/ 2/14/2003 1:45:24 PM nothing http://razor.bindview.com/ 2/14/2003 1:47:03 PM nothing http://www.packetstormsecurity.org/ 2/14/2003 1:47:40 PM nothing (I've been away from the grey/black hat sites for a long time). From the readme for 8.1.7.4.7: (only one entry) === Bug fixes included in this patch --- 8.1.7.4.7 Bug Base Bug Category Description - --- 2790160 2787968 NET INAPPROPRIATE MESSAGE ON ERROR CONDITION THAT SHOULD NEVER OCCUR 8.1.7.4.6 === === Oracle Security Alert #51 Dated: 11 February 2003 Severity: 1 Buffer Overflow in ORACLE.EXE binary of Oracle9i Database Server Description A potential security vulnerability has been discovered in the ORACLE.EXE binary of Oracle9i Database. A knowledgeable and malicious user can potentially execute arbitrary code by exploiting a buffer overflow in this binary. Note that this exploit can manifest only when using a client application that does not place proper limits on the size of data sent to the server. Products Affected Oracle9i Database Release 2, Oracle9i Database Release 1, Oracle8i Database v 8.1.7, Oracle Database v 8.0.6. Platforms Affected All platforms. Patch Information Oracle has fixed the potential security vulnerability identified above under the base bug number 2620726. Future releases of the Oracle Database Server will contain the fix by default. This potential security vulnerability is fixed in the last patchset level for each database release on all platforms. It will be available in the Oracle9i Database Release 2 v 9.2.0.3
RE: metadata repository
try 'www.databee.com' gs.natesh@iflexsolutio ns.com T To: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: bcc: Subject: RE: metadata 02/18/03 07:48 AMrepository Please respond to ORACLE-L Hi Rabson I think www.databaee.com is not found Can pls send the right one Regards Natesh G.S -Original Message- Sent: Tuesday, February 18, 2003 4:04 PM To: Multiple recipients of list ORACLE-L 'Databee' may just be appropriate here. Its free. Visit www.databaee.com peter ps - got in there before you, Dale! -Original Message- Sent: 14 February 2003 19:49 To: Multiple recipients of list ORACLE-L Is anybody aware of a freeware metadata repository tool that is configurable enough to capture metadata attributes that the business would value? For example, to capture information about columns such as length, aliases, valid values ... Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
RE: metadata repository
Hi, The URL is http://www.databee.com. The free tool that Peter mentioned (thanks for the plug Peter!), is actually DataBee DBATool (DataBee proper is a data subsetting tool, and has a license fee). A direct link to DBATool is: http://www.databee.com/dt_home.htm Or, also available from Cool-Tools (;)): http://www.cool-tools.co.uk/products/dbatool.html I think that you will find the HTML report generation quite handy.. If you need any help with DBATool, feel free to give myself, or Dale, a shout. 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: 18 February 2003 12:49 To: Multiple recipients of list ORACLE-L Hi Rabson I think www.databaee.com is not found Can pls send the right one Regards Natesh G.S -Original Message- Sent: Tuesday, February 18, 2003 4:04 PM To: Multiple recipients of list ORACLE-L 'Databee' may just be appropriate here. Its free. Visit www.databaee.com peter ps - got in there before you, Dale! -Original Message- Sent: 14 February 2003 19:49 To: Multiple recipients of list ORACLE-L Is anybody aware of a freeware metadata repository tool that is configurable enough to capture metadata attributes that the business would value? For example, to capture information about columns such as length, aliases, valid values ... Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
RE: metadata repository
www.databee.com [EMAIL PROTECTED] 02/18/03 07:48AM Hi Rabson I think www.databaee.com is not found Can pls send the right one Regards Natesh G.S -Original Message- Sent: Tuesday, February 18, 2003 4:04 PM To: Multiple recipients of list ORACLE-L 'Databee' may just be appropriate here. Its free. Visit www.databaee.com peter ps - got in there before you, Dale! -Original Message- Sent: 14 February 2003 19:49 To: Multiple recipients of list ORACLE-L Is anybody aware of a freeware metadata repository tool that is configurable enough to capture metadata attributes that the business would value? For example, to capture information about columns such as length, aliases, valid values ... Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: metadata repository
You are quite correct. Spelling error - try www.databee.com peter -Original Message- Sent: 18 February 2003 12:49 To: Multiple recipients of list ORACLE-L Hi Rabson I think www.databaee.com is not found Can pls send the right one Regards Natesh G.S -Original Message- Sent: Tuesday, February 18, 2003 4:04 PM To: Multiple recipients of list ORACLE-L 'Databee' may just be appropriate here. Its free. Visit www.databaee.com peter ps - got in there before you, Dale! -Original Message- Sent: 14 February 2003 19:49 To: Multiple recipients of list ORACLE-L Is anybody aware of a freeware metadata repository tool that is configurable enough to capture metadata attributes that the business would value? For example, to capture information about columns such as length, aliases, valid values ... Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 does the Oracle Home selector get installed
Hi All, I have installed Oracle 8.1.6 and 8.1.7 on WinNT in different Homes. When I had multiple Oracle homes in the past there was always an Oracle home selector installed. It was not this time. How does this get installed? I want to install this portion. Thanks Rick -- 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: metadata repository
Databee home: http://www.databee.com/main.htm Ofer -Original Message- Sent: Tuesday, February 18, 2003 2:49 PM To: Multiple recipients of list ORACLE-L Hi Rabson I think www.databaee.com is not found Can pls send the right one Regards Natesh G.S -Original Message- Sent: Tuesday, February 18, 2003 4:04 PM To: Multiple recipients of list ORACLE-L 'Databee' may just be appropriate here. Its free. Visit www.databaee.com peter ps - got in there before you, Dale! -Original Message- Sent: 14 February 2003 19:49 To: Multiple recipients of list ORACLE-L Is anybody aware of a freeware metadata repository tool that is configurable enough to capture metadata attributes that the business would value? For example, to capture information about columns such as length, aliases, valid values ... Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ofer Harel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: metadata repository
www.databee.com Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 7:48 AM Hi Rabson I think www.databaee.com is not found Can pls send the right one Regards Natesh G.S -Original Message- Sent: Tuesday, February 18, 2003 4:04 PM To: Multiple recipients of list ORACLE-L 'Databee' may just be appropriate here. Its free. Visit www.databaee.com peter ps - got in there before you, Dale! -Original Message- Sent: 14 February 2003 19:49 To: Multiple recipients of list ORACLE-L Is anybody aware of a freeware metadata repository tool that is configurable enough to capture metadata attributes that the business would value? For example, to capture information about columns such as length, aliases, valid values ... Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
8.1.7 Instance not creating an SGADEF file
I have an 8.1.7 Oracle instance on a server that does not create an SGADEF file when it is started up. There are no errors in the log or trace files. As a result of this file not being created, I cannot connect to the database from a remote client. I get an error that says the instance is not running. I can connect to the instance from SVRMGRL on while logged onto the server. Any ideas why the file would not get created? Thanks! Ron Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reconfiguring datafiles
Sony 1. You can expand a datafile if it is full, assuming your storage device still has space and you are not near your operating system limit. 2. You can move a datafile to another storage device if you need to. 3. If you need to move data out of a datafile, the easiest way to do this is to create a second tablespace, which will have its own datafile(s). Then move the objects stored in the first tablespace into the second tablespace. 4. Within a tablespace that has more than one datafile, you can't tell Oracle where to put the data, or to move data from one datafile to another. I hope one of the above responds to your question. :-) Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 18, 2003 1:24 AM To: Multiple recipients of list ORACLE-L Dear Listers, Would someone on this list help me to solve these problems, 1. I've three datafiles x1 and x2 2. If datafile x1 is full, I want it is automaticaly move to datafile x2 including all data in datafile x1. 3. If it is possible how to do it. Many thanks for respons and all comments would be appreciated. Kind rgrds, Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN Upgrading to 8.1.74. Voices in my head.
Mike - Did you consider doing a recovery using just the control file? It might sound odd, but even if you are doing a catalog backup, the backup information is still stored in the target database's control file. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 18, 2003 3:54 AM To: Multiple recipients of list ORACLE-L RMAN (non)compatability, Recently I ran into a problem myself: o Target DBs (NT W2k) were at 8.1.7.0 and catalog (Solaris) was at 8.1.7.2 (backups controlled from here using cron). o Test recovery scenarios completed OK (Voice in head says, 'NEW TO RMAN, GOTTA TEST!). o A couple of months ago some NT DBs were upgraded to 8.1.7.4 but RMAN did not complain! o Last week a restore of an 8.1.7.4 datafile was required but RMAN kept giving an error including the text: ...PLS-00302: Component 'LOCKFORCKPT' must be declared... (voices in head says, Got that CV up to date?) Solution: Luckily - we still had nightly cold backups that we hadn't got around to stopping yet! So I was able to do a full cold restore (Also luckily only a test DB) Voice in my head says to me, 'MIKE THIS IS YOUR WARNING - UPGRADE RMAN CATALOG BEFORE A LIVE DATABASE GOES SCREWY!' I upgraded RMAN catalog DB to 8.1.7.4 and issued the upgrade catalog command. SOMETIMES INCOMPATIBILITY WILL LET YOU BACK UP BUT NOT RESTORE! (Voice in head asks, 'RMAN - What is it good for, huh?'. There's an RMAN compatibility matrix on metalink (a bit confusing) and a note that is quite clear regarding 8.1.7.4. I've lost the doc ids but a search will find them. - Mike. -Original Message- Sent: 18 February 2003 04:14 To: Multiple recipients of list ORACLE-L We are upgrading to 8.1.7.4. There are many databases and my DBA college who is in charge of the RMAN Database that is currently 8.1.6. tells me that it is no problem that RMAN (Seperate database by the way) is in 8.1.6 and the Target is in 8.1.7.4. As RMAN is hot topic right now and before I go RTFM can anybody verify this or advise thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBMS_JOB
Hi All, Does anybody know a way of to get DBMS_JOB to run a job every 15 minutes, unless the time of day is between X and Y (for example 00:00am 03:00am)? All help appreciated! Pointers to RTFM more than welcome! ;) 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 -- 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: 8.1.7 Instance not creating an SGADEF file
Ron, This is not a problem due to the absence of sgadef file. This file was obsolete with 8i. Your problem seems to be Oracle environment /or Sql*Net related. Please check tnsnames.ora, sqlnet.ora, service names etc. on the client. Can you connect to any other instance from this client? FWIW: The sgadef file had following text in 8.0.x versions: This file is now obsolete. It will be removed in a future release. To determine whether an instance is up, you should check for the existence of the PMON process associated with the instance. HTH, - Kirti -Original Message- Sent: Tuesday, February 18, 2003 8:14 AM To: Multiple recipients of list ORACLE-L I have an 8.1.7 Oracle instance on a server that does not create an SGADEF file when it is started up. There are no errors in the log or trace files. As a result of this file not being created, I cannot connect to the database from a remote client. I get an error that says the instance is not running. I can connect to the instance from SVRMGRL on while logged onto the server. Any ideas why the file would not get created? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Lgwr , CKPT - Some Misc. basic Qs.
Any Brief info on following :- Qs lgwr writes the redo log buffer to disk when posted by the smon process under what conditions ? Qs What is metadata ? How are Changes to metadata managed in the log_buffer ? Qs Why does the Checkpoint process (CKPT) maintains a heartbeat with the control file at a periodic frequency of every 3 seconds ? Qs The number of Disks n in a stripe volume should preferably be a power of 2 namely (2,4,8,16 and so on) for Oracle Databases . For RAID levels 3, 5 and 7, the number of disks should preferably be n+1 . Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.7 Instance not creating an SGADEF file
This file is an Oracle 7 artifact AFAIK. I have looked through our 8.1.7 instances to be sure and I don't have that file anywhere. You might want to start checking your TNS setup. Can you tnsping the instance from the client? On the server can you say sqlplus system/passwd@instance and connect? How about on the client? What does lsnrctl status listener report about your instance? Hope this helps Allan -Original Message- Sent: Tuesday, February 18, 2003 8:14 AM To: Multiple recipients of list ORACLE-L I have an 8.1.7 Oracle instance on a server that does not create an SGADEF file when it is started up. There are no errors in the log or trace files. As a result of this file not being created, I cannot connect to the database from a remote client. I get an error that says the instance is not running. I can connect to the instance from SVRMGRL on while logged onto the server. Any ideas why the file would not get created? Thanks! Ron Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RMAN Upgrading to 8.1.74. Voices in my head.
Good point Dennis. For all you RMAN users out there, always remmeber, no mater what happens to your catalog or even your control file as long as your backup sets are on media somewhere, they are recoverable. You might need Oracle to assist you with such a recovery (and it can be painful), but they are there and can be restored. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/18/2003 8:04 AM Mike - Did you consider doing a recovery using just the control file? It might sound odd, but even if you are doing a catalog backup, the backup information is still stored in the target database's control file. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 18, 2003 3:54 AM To: Multiple recipients of list ORACLE-L RMAN (non)compatability, Recently I ran into a problem myself: o Target DBs (NT W2k) were at 8.1.7.0 and catalog (Solaris) was at 8.1.7.2 (backups controlled from here using cron). o Test recovery scenarios completed OK (Voice in head says, 'NEW TO RMAN, GOTTA TEST!). o A couple of months ago some NT DBs were upgraded to 8.1.7.4 but RMAN did not complain! o Last week a restore of an 8.1.7.4 datafile was required but RMAN kept giving an error including the text: ...PLS-00302: Component 'LOCKFORCKPT' must be declared... (voices in head says, Got that CV up to date?) Solution: Luckily - we still had nightly cold backups that we hadn't got around to stopping yet! So I was able to do a full cold restore (Also luckily only a test DB) Voice in my head says to me, 'MIKE THIS IS YOUR WARNING - UPGRADE RMAN CATALOG BEFORE A LIVE DATABASE GOES SCREWY!' I upgraded RMAN catalog DB to 8.1.7.4 and issued the upgrade catalog command. SOMETIMES INCOMPATIBILITY WILL LET YOU BACK UP BUT NOT RESTORE! (Voice in head asks, 'RMAN - What is it good for, huh?'. There's an RMAN compatibility matrix on metalink (a bit confusing) and a note that is quite clear regarding 8.1.7.4. I've lost the doc ids but a search will find them. - Mike. -Original Message- Sent: 18 February 2003 04:14 To: Multiple recipients of list ORACLE-L We are upgrading to 8.1.7.4. There are many databases and my DBA college who is in charge of the RMAN Database that is currently 8.1.6. tells me that it is no problem that RMAN (Seperate database by the way) is in 8.1.6 and the Target is in 8.1.7.4. As RMAN is hot topic right now and before I go RTFM can anybody verify this or advise thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
Re: DBMS_JOB
The PL/SQL packages that we have running as jobs resubmit themselves when the job is complete. So we can just add logic before calling DBMS_JOB.SUBMIT. Can your PL/SQL be modified in this way? Jay [EMAIL PROTECTED] 02/18/03 09:14AM Hi All, Does anybody know a way of to get DBMS_JOB to run a job every 15 minutes, unless the time of day is between X and Y (for example 00:00am 03:00am)? All help appreciated! Pointers to RTFM more than welcome! ;) 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 -- 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). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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_JOB
use a function: check if 15 minutes after current time is in the don't run interval if it is return the first time after the interval if not return 15 minutes later Pat Hi All, Does anybody know a way of to get DBMS_JOB to run a job every 15 minutes, unless the time of day is between X and Y (for example 00:00am 03:00am)? All help appreciated! Pointers to RTFM more than welcome! ;) Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Know 1 database, know them all?
Title: RE: Know 1 database, know them all? I see it from a slightly different (and probably wrong) angel Angel? Hmmm... is that a veiled reference to the satanic dark side Luke? -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: Know 1 database, know them all? I see it from a slightly different (and probably wrong) angel, at least regarding the performance of things and databases: If you've worked with Oracle databases for some time (and have real experience), and know about the myths and their anti-thesis (use the wait interface instead of the ¤#% ratio crap, know about RAID-5, don't have too many indexes, concentrate on LIO instead of PIO, etc.,etc.) you'll do quite fine. As Peter Gram once said to me: It's all about getting a database to perform on a platform. You can take your old presentations regarding Oracle myths and change it into a SQL Server or mySQL presentation, change a few details, and be king in the new world. Mogens
Re: Teradata baned from IOUG???
It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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_JOB
DOH! You know, I knew that I had read about this somewhere, but couldn't for the life of me remember where. You mentioning Tom kick started my aching brain! ;) The asktom site is down at the moment whilst being upgraded, but I still have the copy of Oracle magazine where Tom discussed this! For all others that may be interested, page 98 of Oracle Magazine (January/February 2003 edition) discusses this (Setting a Complex Interval)! Thanks Kirti! Mark -Original Message- Sent: 18 February 2003 15:09 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Mark, You may want to check http://asktom.oracle.com. I think there are a few examples that you will find come close to what you are looking for. - Kirti -Original Message- Sent: Tuesday, February 18, 2003 8:14 AM To: Multiple recipients of list ORACLE-L Hi All, Does anybody know a way of to get DBMS_JOB to run a job every 15 minutes, unless the time of day is between X and Y (for example 00:00am 03:00am)? All help appreciated! Pointers to RTFM more than welcome! ;) 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 -- 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: 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: RMAN Upgrading to 8.1.74. Voices in my head.
Dennis, Ah, you know that never occurred to me. I'll check it out. Thanks. - Mike. -Original Message- Sent: 18 February 2003 14:04 To: Multiple recipients of list ORACLE-L Mike - Did you consider doing a recovery using just the control file? It might sound odd, but even if you are doing a catalog backup, the backup information is still stored in the target database's control file. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 18, 2003 3:54 AM To: Multiple recipients of list ORACLE-L RMAN (non)compatability, Recently I ran into a problem myself: o Target DBs (NT W2k) were at 8.1.7.0 and catalog (Solaris) was at 8.1.7.2 (backups controlled from here using cron). o Test recovery scenarios completed OK (Voice in head says, 'NEW TO RMAN, GOTTA TEST!). o A couple of months ago some NT DBs were upgraded to 8.1.7.4 but RMAN did not complain! o Last week a restore of an 8.1.7.4 datafile was required but RMAN kept giving an error including the text: ...PLS-00302: Component 'LOCKFORCKPT' must be declared... (voices in head says, Got that CV up to date?) Solution: Luckily - we still had nightly cold backups that we hadn't got around to stopping yet! So I was able to do a full cold restore (Also luckily only a test DB) Voice in my head says to me, 'MIKE THIS IS YOUR WARNING - UPGRADE RMAN CATALOG BEFORE A LIVE DATABASE GOES SCREWY!' I upgraded RMAN catalog DB to 8.1.7.4 and issued the upgrade catalog command. SOMETIMES INCOMPATIBILITY WILL LET YOU BACK UP BUT NOT RESTORE! (Voice in head asks, 'RMAN - What is it good for, huh?'. There's an RMAN compatibility matrix on metalink (a bit confusing) and a note that is quite clear regarding 8.1.7.4. I've lost the doc ids but a search will find them. - Mike. -Original Message- Sent: 18 February 2003 04:14 To: Multiple recipients of list ORACLE-L We are upgrading to 8.1.7.4. There are many databases and my DBA college who is in charge of the RMAN Database that is currently 8.1.6. tells me that it is no problem that RMAN (Seperate database by the way) is in 8.1.6 and the Target is in 8.1.7.4. As RMAN is hot topic right now and before I go RTFM can anybody verify this or advise thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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_JOB
Mark, You may want to check http://asktom.oracle.com. I think there are a few examples that you will find come close to what you are looking for. - Kirti -Original Message- Sent: Tuesday, February 18, 2003 8:14 AM To: Multiple recipients of list ORACLE-L Hi All, Does anybody know a way of to get DBMS_JOB to run a job every 15 minutes, unless the time of day is between X and Y (for example 00:00am 03:00am)? All help appreciated! Pointers to RTFM more than welcome! ;) 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 -- 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Know 1 database, know them all?
Mogens, the only problem with your statement about 'oracle myths king of the new world' is that the only way of looking at SQLServer performance is probably looking at ratio's: there are no wait statistics, there is one(1) latch wait counter though! for the complete system :( (apart from some other almost useless perfmon counters, taht is..) regards, Mario -Original Message- Sent: maandag 17 februari 2003 23:29 To: Multiple recipients of list ORACLE-L I see it from a slightly different (and probably wrong) angel, at least regarding the performance of things and databases: If you've worked with Oracle databases for some time (and have real experience), and know about the myths and their anti-thesis (use the wait interface instead of the ¤#% ratio crap, know about RAID-5, don't have too many indexes, concentrate on LIO instead of PIO, etc.,etc.) you'll do quite fine. As Peter Gram once said to me: It's all about getting a database to perform on a platform. You can take your old presentations regarding Oracle myths and change it into a SQL Server or mySQL presentation, change a few details, and be king in the new world. Mogens Robert Eskridge wrote: Curiously, the basics are common across styles of cooking. You have to learn to coax the flavors out of the fresh ingredients and transform them into the proper texture and finish. Once you've mastered Italian cooking, you may not be a top notch German cook, but you're probably just a recipe or two away from being able to produce a very nice German meal... Databases have a certain similarity. If heading an Oracle project and I was given the choice between two people to work on my project, one having been the lead architect for a top notch product based on Sybase, and the other being an OCP that had worked on lack luster products, it would be hard not to pick the former. F Following the same logic. if I learn to cook a good Italian dish, then I F must automatically be an expert in preparing top-class Chinese, German, F Malay, Hungarian and French cuisine Yeah, right ! F Ferenc Mantfeld -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Broodbakker, Mario INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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_JOB
Just found an online version (in the spirit of sharing solutions ;D): http://otn.oracle.com/oramag/oracle/03-jan/o13asktom.html ---snip--- Setting a Complex Interval I am using DBMS_JOB, and I want to schedule a job that runs every 15 minutes from Monday to Friday, between 6 a.m. and 6 p.m. How do I schedule it? I cannot figure out the interval I should be passing. Well, for figuring out complex intervals for DBMS_JOB, I like to use the new (as of Oracle8i Release 2) CASE statement. For example, the following CASE statement returns the correct interval for your specification: SQL alter session set nls_date_format = 2 'dy mon dd, hh24:mi'; Session altered. SQL select 2 sysdate, 3 case 4when (to_char( sysdate, 'hh24' ) 5 between 6 and 17 6 and to_char(sysdate,'dy') NOT IN 7 ('sat','sun') ) 8then trunc(sysdate)+ 9 (trunc(to_char(sysdate,'s')/ 10 900)+1)*15/24/60 11when (to_char( sysdate, 'dy' ) 12 not in ('fri','sat','sun') ) 13then trunc(sysdate)+1+6/24 14else next_day( trunc(sysdate), 15 'Mon' )+6/24 16 end interval_date 17 from dual 18 / SYSDATE -- INTERVAL_DATE -- sun sep 15, 2002 16:35 mon sep 16, 2002 06:00 The CASE statement gives you great flexibility in generating a complex value such as you need. Unfortunately, DBMS_JOB will allow you to use only an interval that is 200 characters or less, and even if you scrunch up the CASE statement above, you'll find it is about 300 characters minimally. So, you cannot use it directly in the call to DBMS_JOB. My solution to that is one of two things: either I would create a view NEXT_DATE as that select, so that select * from next_date would return the next time the job runs, or I would wrap the above query in a PL/SQL function that returns a date. If I used a view, my call to DBMS_JOB might look like: begin dbms_job.submit ( :n, 'proc;', sysdate, '(select * from next_date)' ); end; / Or, if I used the PL/SQL function approach and created a function NEXT_DATE, it could be: begin dbms_job.submit ( :n, 'proc;', sysdate, 'next_date()' ); end; / ---snip--- Cheers Mark -Original Message- Sent: 18 February 2003 15:29 To: Multiple recipients of list ORACLE-L DOH! You know, I knew that I had read about this somewhere, but couldn't for the life of me remember where. You mentioning Tom kick started my aching brain! ;) The asktom site is down at the moment whilst being upgraded, but I still have the copy of Oracle magazine where Tom discussed this! For all others that may be interested, page 98 of Oracle Magazine (January/February 2003 edition) discusses this (Setting a Complex Interval)! Thanks Kirti! Mark -Original Message- Sent: 18 February 2003 15:09 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Mark, You may want to check http://asktom.oracle.com. I think there are a few examples that you will find come close to what you are looking for. - Kirti -Original Message- Sent: Tuesday, February 18, 2003 8:14 AM To: Multiple recipients of list ORACLE-L Hi All, Does anybody know a way of to get DBMS_JOB to run a job every 15 minutes, unless the time of day is between X and Y (for example 00:00am 03:00am)? All help appreciated! Pointers to RTFM more than welcome! ;) 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 -- 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: 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
Re: Teradata baned from IOUG???
Well said. It becomes a problem when TUSC aka IOUG starts censoring papers and vendors for OW and IOUG-A on the grounds that it doesn't conform with the slick TUSC messages (right or wrong as they were). Just out of curiosity: What is it that Oracle provides that IOUG can't live without? In Denmark (which is about the size of Ada, Oklahoma :) ) we are grateful for being able to borrow a meeting room at the Oracle building for our events, but we could just as easily get a room somewhere else. That's about it. So we get by fine. Mogens Peter Barnett wrote: It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com
RE: Know 1 database, know them all?
Perhaps a philosophical discussion is in order on the roles of Right Angels versus Obtuse Angels versus Acute Angels. I would hypothesize that Right Angels occupy the uppermost regions of Heaven. Obtuse Angels, being obtuse and mentally slow, are responsible for the enforcement of Murphy's Law. And Acute Angel would most likely be a Cupid or, possibly, a synonym for an Earth Angel. -Original Message- I see it from a slightly different (and probably wrong) angel Angel? Hmmm... is that a veiled reference to the satanic dark side Luke? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How does the Oracle Home selector get installed
Did you install the universal installer? My experience is that the home selector app is in the same directory as the Universal installer and probably is installed along with it. The UI may not installed by default , but you can install it from the CD afterwards. -Original Message- Sent: Tuesday, February 18, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Hi All, I have installed Oracle 8.1.6 and 8.1.7 on WinNT in different Homes. When I had multiple Oracle homes in the past there was always an Oracle home selector installed. It was not this time. How does this get installed? I want to install this portion. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wayne Straughn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Know 1 database, know them all?
Yeah, that could be :). OK, OK: Angle, angle, angle, angle. Undskyld. Best regards, The Oracle Angels of Denmark (TOAD) Orr, Steve wrote: RE: Know 1 database, know them all? I see it from a slightly different (and probably wrong) angel Angel? Hmmm... is that a veiled reference to the satanic dark side Luke? -Original Message- From: Mogens Nrgaard [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: Know 1 database, know them all? I see it from a slightly different (and probably wrong) angel, at least regarding the performance of things and databases: If you've worked with Oracle databases for some time (and have real experience), and know about the myths and their anti-thesis (use the wait interface instead of the #% ratio crap, know about RAID-5, don't have too many indexes, concentrate on LIO instead of PIO, etc.,etc.) you'll do quite fine. As Peter Gram once said to me: It's all about getting a database to perform on a platform. You can take your old presentations regarding Oracle myths and change it into a SQL Server or mySQL presentation, change a few details, and be king in the new world. Mogens
Re: Teradata baned from IOUG???
evidently i'm not the only one who thinks that, interesting. joe It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Teradata baned from IOUG???
It would be great to find out what Oracle DOES do for IOUG... and other OUGs for that matter. I can't get them to even tell people about TSOUG... let alone actually GIVE us anything (meeting room, or anything else). Most of the time I can't get OUR sales rep to get back to me to tell me if he is still telling his contacts in the area that we even exist! April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 10:00 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata baned from IOUG???Well said. It becomes a problem when TUSC aka IOUG starts censoring papers and vendors for OW and IOUG-A on the grounds that it doesn't conform with the slick TUSC messages (right or wrong as they were). Just out of curiosity: What is it that Oracle provides that IOUG can't live without? In Denmark (which is about the size of Ada, Oklahoma :) ) we are grateful for being able to borrow a meeting room at the Oracle building for our events, but we could just as easily get a room somewhere else. That's about it. So we get by fine.MogensPeter Barnett wrote: It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
Moving data in 8.1.5.0
Any one, I have a Compaq Tru64 Unix server with an Oracle 8.1.5.0 RDBMS on it. I have over 2tb's of raw-disk (1 gb chunks) of database storage that is comprised in 4 separate volumes(emcxxx). We upgrading the storage (1 volume at a time) and I am trying to see if there is a better option than exporting and importing. The storage is assigned in a non-contiguous manner, so there are tablespaces that have storage attached from all the storage volumes, which makes this very difficult. I was thinking about transportable tablespaces but I am using partition tables in this database. Any thoughts from someone who has ran into this challenge would be greatly appreciated. thanks, D. Holloway -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: donald.holloway INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Programming languages that make DBA's lives easier
On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used?
Re: DB character set
In case anybody is interested in the character set business: I asked this question (best char set for mixed environment of Unix and MS DBs with primarily MS clients and C/S applications) Gilles Briard, the author of article in OraMag on accomodating Euro symbol in a DB (http://www.oracle.com/oramag/webcolumns/2001/index.html?euro.html). After couple of emails I realized that the basic question I should've asked in the first place is much simpler: Q: If DB charater set is WE8ISO8859P1 1-st user on MS Win with client side char set (part of NLS_LANG) WE8MSWIN1252 2-nd user on Unix with client side char set WE8ISO8859P1 Would there be any difference in performance (elapsed time) if both clients (one on Unix, one on MS Win) are located on the same segment with the same network bandwith and latency and run the same simple query (say select * from sys.source$; in SQL* Plus) ? I always thought that the one on MS Win might be slower (in the example above) because Oracle has to go through a char set conversion. The following URL from Oracle Globalization Guide seemed to confirm that: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96529/ch2.htm#100796 Gilles response was that if all other factors are the same and the only difference is the NLS_LANG value on the client, than user on Unix and MS should expirience the same performance (if I understood it correctly). The reason for this is the following steps that Oracle goes through in any case: 1 - DB server: translate char set P15 data to binary 2 - network transmission of binary data 3 - Client: translate binary to P15 back (in case of Unix) OR to WIN1252 (in case of MS Win) 4 - Client: graphical transformation So translation in step 3 or translation with conversion (or is it conversion with translation?) cost the same? I'll be setting up a test maybe next week (not only for performance impications, but also to check if symbols like 1/2 and 1/4 we use here can be stored and retrieved back), but I would appreciate if anybody can comment on the above. Resources used - 1. Globalization Guide 2. 144192.1 Whether or not to change the DB char set to support the Euro sign 3. 225938.1 Do I have incorrect char in the DB and how to recover 4. 140014.1 RDBMS support for the Euro Currency symbol 5. 15095.1 Exp/Imp and NLS considerations 6. 119119.1 UTF8 DB char set implications 7. 181508.1 Choosing the DB char set 8. 137127.1 Char set, Code Pages, Fonts and the NLS_LANG value 9. 158577.1 NLS_LANG explained (how does client-server char converison works?) 10. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96529/ch2.htm#100796 Thanks, Boris Dali. --- Boris Dali [EMAIL PROTECTED] wrote: Dear List, Life was pretty easy here before they came up with this euro symbol :-( We had WE8ISO8859P1 (the default I bevieve) as a char set on all Unix and MS (sorry we have those as well) DBs accross the board. That was also the client side char set (part of NLS_LANG) - most clients here are on MS (code page 1252), some browser based. Well, with euro it looks like they went different directions: - On MS: it's recommended to have WE8MSWIN1252 (super set of good old WE8ISO8859P1) - On Unix: it's WE8ISO8859P15 My question is: 1. if I want to stick with one char set accross the board (as we have now) for all DBs on Unix and MS AND 2. avoid (automatic, but not free) conversion on DB-Client Net communication AND 3. we need euro symbol is there a painless solution out there? Thanks, Boris Dali __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
Re: Programming languages that make DBA's lives easier
Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Programming languages that make DBA's lives easier 02/18/2003 09:56 AM Please respond to ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Teradata baned from IOUG???
me too... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 11:11 AM evidently i'm not the only one who thinks that, interesting. joe It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Programming languages that make DBA's lives easier
C Shell Scripting Perl Pl/SQL - "not really a programming language" Java Now, if the more developer-minded DBA's amongst us could rate them as % important that would be cool! -Original Message-From: Les Ayudo [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 11:56 AMTo: Multiple recipients of list ORACLE-LSubject: Programming languages that make DBA's lives easier On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used?
RE: Teradata baned from IOUG???
Title: Message April I'm afraid I can't answer what Oracle DOES do for IOUG, being a lowly scumbag consultant, but one thing I can suggest to you and any other user group co-ordinator types is to send me (well in advance) notification of your events. I run a DBA mailing list that gets mail sent out monthly if I have the time, and you may hit some of your constituents that way. It's a worldwide distribution list, so I'm not sure whether anyone from your area is on it, but it certainly won't harm anyone to include that information as needed. I missed the beginning of this thread since I only subscribed to oracle-l last night, so I can't comment on the rest of it. Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of April WellsSent: Tuesday, February 18, 2003 8:24 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Teradata baned from IOUG??? It would be great to find out what Oracle DOES do for IOUG... and other OUGs for that matter. I can't get them to even tell people about TSOUG... let alone actually GIVE us anything (meeting room, or anything else). Most of the time I can't get OUR sales rep to get back to me to tell me if he is still telling his contacts in the area that we even exist! April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 10:00 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata baned from IOUG???Well said. It becomes a problem when TUSC aka IOUG starts censoring papers and vendors for OW and IOUG-A on the grounds that it doesn't conform with the slick TUSC messages (right or wrong as they were). Just out of curiosity: What is it that Oracle provides that IOUG can't live without? In Denmark (which is about the size of Ada, Oklahoma :) ) we are grateful for being able to borrow a meeting room at the Oracle building for our events, but we could just as easily get a room somewhere else. That's about it. So we get by fine.MogensPeter Barnett wrote: It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive,
Re: Teradata banned from IOUG???
IOUG is a volunteer organization. If you don't like something about it, you can change it from the inside by becoming involved. Remember, the Board Of Directors election is currently open and it is a way to voice your opinion. Also, send feedback about things you don't like, offer solutions and offer to assist in making the change (the most important!). Don't like the articles in SELECT? Offer to write one or be an editor. Don't like the content on the website? Become a tip miner. IOUG-A Live is also volunteer run. Speakers are volunteers, many of the workers are volunteers. As a speaker, the amount of time (and expenses I pay for myself as do many others) spent on the papers and presentation is high. I think it is worth it, as long as I can help 1 person be a better technician. I try to make the paper and presentation as accurate and helpful as I can. In the past, I have had no support (financial or otherwise) from my employers in attending/speaking at conferences, but I consider it worth my time. If you don't like the lineup of speakers, submit for next year. For those who are attendees, it is important to show support to the speakers you respect and the topics that interest you. How many of you fill out the session evaluations? Do you rate the presentations on entertainment value or meaningful content? Do you encourage other people to attend the 'good' presentations? Do you fill out the conference evaluation? Our local user group has seen Oracle's involvement decrease drastically over the past few years. Recently, thanks to an excellent Oracle contact, who is a long time contributor to our organization, we are meeting together to find ways to help each other. Of course, the sales folks want to know "How many new $$$ can we get by pitching new products at meetings?" (strictly forbidden at our meetings if it parades as a technical session). We are finding creative ways to get the groups together, such as having Oracle host a SIG meeting in exchange for a brief sales pitch at the beginning, establishing a specific Vendor track at our annual Traning Days. Attendees know that the intent of the pitch/presentation and they also know that the technical sessions will be technical and not marketing. IOUG can survive without Oracle, TUSC or myself. The question is whether or not that is for the best. Oracle and TUSC employees can provide some great sessions and information. They can also provide fluff and bad information. If we provide constructive feedback, the organization will either change or begin losing membership and disappear. Dan Fink Peter Barnett wrote: It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day
RE: Programming languages that make DBA's lives easier
On Unix, ksh. VERY useful for automating maintenance. -Original Message- On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Programming languages that make DBA's lives easier
In priority order, I would recommend: SQL Whatever language your apps are written in: its probably Java or PL/SQL, but it might be anything (PHP, Perl, VB, ASP, Python, Tcl, C, C++, C#, ksh, csh, sh, etc.). If youve not found your job yet, then the best bets are Java and PL/SQL. Whatever language your database and system administration staff use to do their jobs. If youve not found your job yet, then Id submit that the best one to start with is Perl. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - RMOUG Training Days 2003, Mar 56 Denver - Hotsos Clinic101, Mar 2527 London -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Les Ayudo Sent: Tuesday, February 18, 2003 10:56 AM To: Multiple recipients of list ORACLE-L Subject: Programming languages that make DBA's lives easier On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used?
RE: Programming languages that make DBA's lives easier
Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Nah! - FORTRAN ! peter * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Programming languages that make DBA's lives easier
I have always found that both C and understanding makefiles were fundamental to running oracle on linux/unix. When the installer breaks, the knowledge comes in handy. And the installer seems to break quite often... -Candi On Tue, 2003-02-18 at 11:56, Les Ayudo wrote: On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boyle Candi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Programming languages that make DBA's lives easier
PL/SQL is not a programming language? What are your criteria that must be met before it's a programming language? Jared On Tuesday 18 February 2003 09:24, [EMAIL PROTECTED] wrote: C Shell Scripting Perl Pl/SQL - not really a programming language Java Now, if the more developer-minded DBA's amongst us could rate them as % important that would be cool! -Original Message- Sent: Tuesday, February 18, 2003 11:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Know 1 database, know them all?
Actually there are wait stats in SQL server that you can only see with Precise Indepth for SQLServer ;-) Broodbakker, Mario wrote: Mogens, the only problem with your statement about 'oracle myths king of the new world' is that the only way of looking at SQLServer performance is probably looking at ratio's: there are no wait statistics, there is one(1) latch wait counter though! for the complete system :( (apart from some other almost useless perfmon counters, taht is..) regards, Mario -Original Message- Sent: maandag 17 februari 2003 23:29 To: Multiple recipients of list ORACLE-L I see it from a slightly different (and probably wrong) angel, at least regarding the performance of things and databases: If you've worked with Oracle databases for some time (and have real experience), and know about the myths and their anti-thesis (use the wait interface instead of the ¤#% ratio crap, know about RAID-5, don't have too many indexes, concentrate on LIO instead of PIO, etc.,etc.) you'll do quite fine. As Peter Gram once said to me: It's all about getting a database to perform on a platform. You can take your old presentations regarding Oracle myths and change it into a SQL Server or mySQL presentation, change a few details, and be king in the new world. Mogens Robert Eskridge wrote: Curiously, the basics are common across styles of cooking. You have to learn to coax the flavors out of the fresh ingredients and transform them into the proper texture and finish. Once you've mastered Italian cooking, you may not be a top notch German cook, but you're probably just a recipe or two away from being able to produce a very nice German meal... Databases have a certain similarity. If heading an Oracle project and I was given the choice between two people to work on my project, one having been the lead architect for a top notch product based on Sybase, and the other being an OCP that had worked on lack luster products, it would be hard not to pick the former. F Following the same logic. if I learn to cook a good Italian dish, then I F must automatically be an expert in preparing top-class Chinese, German, F Malay, Hungarian and French cuisine Yeah, right ! F Ferenc Mantfeld -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Broodbakker, Mario INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Programming languages that make DBA's lives easier
If you are using C/C++ look into www.swig.org to make your life easier On Tue, 18 Feb 2003 [EMAIL PROTECTED] wrote: C Shell Scripting Perl Pl/SQL - not really a programming language Java Now, if the more developer-minded DBA's amongst us could rate them as % important that would be cool! -Original Message- Sent: Tuesday, February 18, 2003 11:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Teradata baned from IOUG???
Pete, I used to get your newsletter, and even resubscribed after your big move, but then lost track of it. Feel free to publish subscription info here on Oracle-L. Welcome aboard! Jared On Tuesday 18 February 2003 09:19, Pete Sharman wrote: April I'm afraid I can't answer what Oracle DOES do for IOUG, being a lowly scumbag consultant, but one thing I can suggest to you and any other user group co-ordinator types is to send me (well in advance) notification of your events. I run a DBA mailing list that gets mail sent out monthly if I have the time, and you may hit some of your constituents that way. It's a worldwide distribution list, so I'm not sure whether anyone from your area is on it, but it certainly won't harm anyone to include that information as needed. I missed the beginning of this thread since I only subscribed to oracle-l last night, so I can't comment on the rest of it. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Wells Sent: Tuesday, February 18, 2003 8:24 AM To: Multiple recipients of list ORACLE-L It would be great to find out what Oracle DOES do for IOUG... and other OUGs for that matter. I can't get them to even tell people about TSOUG... let alone actually GIVE us anything (meeting room, or anything else). Most of the time I can't get OUR sales rep to get back to me to tell me if he is still telling his contacts in the area that we even exist! April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -Original Message- Sent: Tuesday, February 18, 2003 10:00 AM To: Multiple recipients of list ORACLE-L Well said. It becomes a problem when TUSC aka IOUG starts censoring papers and vendors for OW and IOUG-A on the grounds that it doesn't conform with the slick TUSC messages (right or wrong as they were). Just out of curiosity: What is it that Oracle provides that IOUG can't live without? In Denmark (which is about the size of Ada, Oklahoma :) ) we are grateful for being able to borrow a meeting room at the Oracle building for our events, but we could just as easily get a room somewhere else. That's about it. So we get by fine. Mogens Peter Barnett wrote: It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: metadata repository
Neat tool, but not what she's asking for. Jared On Tuesday 18 February 2003 02:33, Robson, Peter wrote: 'Databee' may just be appropriate here. Its free. Visit www.databaee.com peter ps - got in there before you, Dale! -Original Message- Sent: 14 February 2003 19:49 To: Multiple recipients of list ORACLE-L Is anybody aware of a freeware metadata repository tool that is configurable enough to capture metadata attributes that the business would value? For example, to capture information about columns such as length, aliases, valid values ... Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Programming languages that make DBA's lives easier
I tend to agree here. I would say: 1. PL/SQL 2. korn shell (or sh, bash, whatever you choose). 3. Perl These are 3 necessities. -Scott At 09:59 AM 2/18/03 -0800, you wrote: You need to know PL/SQL if you're going to be effective with Oracle. Java is interesting, but not nearly as useful to a DBA as Perl. Jared On Tuesday 18 February 2003 08:56, Les Ayudo wrote: On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Programming languages that make DBA's lives easier
In my opinion, there are languages you learn because you'll have to deal with them whether it is to make use of a good set of scripts that someone has made available, orprograms you'll need to maintain at some level. And there are languages you learn because they allow you to quickly and efficiently get stuff done. There is overlap between categories, but in category 1, I generally place the likes of Perl, C, PL/SQL, ksh, Java and the like. In category 2, I prefer Python;Perl goes here too for many DBA's. Glenn Stauffer - Original Message - From: Les Ayudo To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 18, 2003 11:56 AM Subject: Programming languages that make DBA's lives easier On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used?
Re: Programming languages that make DBA's lives easier
On Tuesday 18 February 2003 09:24, [EMAIL PROTECTED] wrote: C Not much need for most DBA's to ever use C, though not a bad thing to know. Certainly doesn't belong at the top of the list for a DBA. Jraed Shell Scripting Perl Pl/SQL - not really a programming language Java Now, if the more developer-minded DBA's amongst us could rate them as % important that would be cool! -Original Message- Sent: Tuesday, February 18, 2003 11:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Teradata banned from IOUG???
Well said Dan. Jared On Tuesday 18 February 2003 09:30, Daniel W. Fink wrote: IOUG is a volunteer organization. If you don't like something about it, you can change it from the inside by becoming involved. Remember, the Board Of Directors election is currently open and it is a way to voice your opinion. Also, send feedback about things you don't like, offer solutions and offer to assist in making the change (the most important!). Don't like the articles in SELECT? Offer to write one or be an editor. Don't like the content on the website? Become a tip miner. IOUG-A Live is also volunteer run. Speakers are volunteers, many of the workers are volunteers. As a speaker, the amount of time (and expenses I pay for myself as do many others) spent on the papers and presentation is high. I think it is worth it, as long as I can help 1 person be a better technician. I try to make the paper and presentation as accurate and helpful as I can. In the past, I have had no support (financial or otherwise) from my employers in attending/speaking at conferences, but I consider it worth my time. If you don't like the lineup of speakers, submit for next year. For those who are attendees, it is important to show support to the speakers you respect and the topics that interest you. How many of you fill out the session evaluations? Do you rate the presentations on entertainment value or meaningful content? Do you encourage other people to attend the 'good' presentations? Do you fill out the conference evaluation? Our local user group has seen Oracle's involvement decrease drastically over the past few years. Recently, thanks to an excellent Oracle contact, who is a long time contributor to our organization, we are meeting together to find ways to help each other. Of course, the sales folks want to know How many new $$$ can we get by pitching new products at meetings? (strictly forbidden at our meetings if it parades as a technical session). We are finding creative ways to get the groups together, such as having Oracle host a SIG meeting in exchange for a brief sales pitch at the beginning, establishing a specific Vendor track at our annual Traning Days. Attendees know that the intent of the pitch/presentation and they also know that the technical sessions will be technical and not marketing. IOUG can survive without Oracle, TUSC or myself. The question is whether or not that is for the best. Oracle and TUSC employees can provide some great sessions and information. They can also provide fluff and bad information. If we provide constructive feedback, the organization will either change or begin losing membership and disappear. Dan Fink Peter Barnett wrote: It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Programming languages that make DBA's lives easier
Les Ayudo wrote: On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? In (my) order of importance: 1. SQL and PL/SQL 2. Whatever shell scripting language your environment supports (sh,ksh,csh,bash on Unix, typically, and the Windows Batch language if your database is on Windows) 3. Whatever language the applications you're supporting are written in. 4. Perl. Learning the local default scripting language for your environment (ksh or Windows Batch) should be extermely high on your list as you can't always be certain that Perl (or whatever your favorite happens to be) will be installed on a given system. If you're maintaining an Oracle Apps Environment, C would be a good one to learn (or at least familiarize yourself with) as even a basic knowledge of C can help you to troubleshoot the compile/link process used so commonly with the Applications. Also, if you don't know it and you work on a unix environment, I suggest you learn the basics of the vi editor. (It's also basically the only one that you can be certain to have). Emacs may be wonderful, but vi is _always_ there... -- James Nascent Systems, Inc. Senior Technical Consultant -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Teradata baned from IOUG???
Jared Good to hear from you! I'd heard from Cary and Mogens you were still out there alive and kickin' somewhere, but I'd lost your email address (hence the reason you don't get the email any more). For those that want to subscribe to the mailing list, I'd suggest you first look at the back postings available on the Files link on http://www.oaktable.net (shameless plug!) and then send me an email if you're interested in receiving it. All I need is your name and email address. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Sent: Tuesday, February 18, 2003 10:06 AM To: [EMAIL PROTECTED]; Pete Sharman Pete, I used to get your newsletter, and even resubscribed after your big move, but then lost track of it. Feel free to publish subscription info here on Oracle-L. Welcome aboard! Jared On Tuesday 18 February 2003 09:19, Pete Sharman wrote: April I'm afraid I can't answer what Oracle DOES do for IOUG, being a lowly scumbag consultant, but one thing I can suggest to you and any other user group co-ordinator types is to send me (well in advance) notification of your events. I run a DBA mailing list that gets mail sent out monthly if I have the time, and you may hit some of your constituents that way. It's a worldwide distribution list, so I'm not sure whether anyone from your area is on it, but it certainly won't harm anyone to include that information as needed. I missed the beginning of this thread since I only subscribed to oracle-l last night, so I can't comment on the rest of it. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Wells Sent: Tuesday, February 18, 2003 8:24 AM To: Multiple recipients of list ORACLE-L It would be great to find out what Oracle DOES do for IOUG... and other OUGs for that matter. I can't get them to even tell people about TSOUG... let alone actually GIVE us anything (meeting room, or anything else). Most of the time I can't get OUR sales rep to get back to me to tell me if he is still telling his contacts in the area that we even exist! April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -Original Message- Sent: Tuesday, February 18, 2003 10:00 AM To: Multiple recipients of list ORACLE-L Well said. It becomes a problem when TUSC aka IOUG starts censoring papers and vendors for OW and IOUG-A on the grounds that it doesn't conform with the slick TUSC messages (right or wrong as they were). Just out of curiosity: What is it that Oracle provides that IOUG can't live without? In Denmark (which is about the size of Ada, Oklahoma :) ) we are grateful for being able to borrow a meeting room at the Oracle building for our events, but we could just as easily get a room somewhere else. That's about it. So we get by fine. Mogens Peter Barnett wrote: It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ:
Re: Programming languages that make DBA's lives easier
You need to know PL/SQL if you're going to be effective with Oracle. Java is interesting, but not nearly as useful to a DBA as Perl. Jared On Tuesday 18 February 2003 08:56, Les Ayudo wrote: On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Teradata banned from IOUG???
Thanks you, Dan. Very nicely put. - Kirti -Original Message-From: Daniel W. Fink [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 11:31 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata banned from IOUG???IOUG is a volunteer organization. If you don't like something about it, you can change it from the inside by becoming involved. Remember, the Board Of Directors election is currently open and it is a way to voice your opinion. Also, send feedback about things you don't like, offer solutions and offer to assist in making the change (the most important!). Don't like the articles in SELECT? Offer to write one or be an editor. Don't like the content on the website? Become a tip miner.IOUG-A Live is also volunteer run. Speakers are volunteers, many of the workers are volunteers. As a speaker, the amount of time (and expenses I pay for myself as do many others) spent on the papers and presentation is high. I think it is worth it, as long as I can help 1 person be a better technician. I try to make the paper and presentation as accurate and helpful as I can. In the past, I have had no support (financial or otherwise) from my employers in attending/speaking at conferences, but I consider it worth my time. If you don't like the lineup of speakers, submit for next year.For those who are attendees, it is important to show support to the speakers you respect and the topics that interest you. How many of you fill out the session evaluations? Do you rate the presentations on entertainment value or meaningful content? Do you encourage other people to attend the 'good' presentations? Do you fill out the conference evaluation?Our local user group has seen Oracle's involvement decrease drastically over the past few years. Recently, thanks to an excellent Oracle contact, who is a long time contributor to our organization, we are meeting together to find ways to help each other. Of course, the sales folks want to know "How many new $$$ can we get by pitching new products at meetings?" (strictly forbidden at our meetings if it parades as a technical session). We are finding creative ways to get the groups together, such as having Oracle host a SIG meeting in exchange for a brief sales pitch at the beginning, establishing a specific Vendor track at our annual Traning Days. Attendees know that the intent of the pitch/presentation and they also know that the technical sessions will be technical and not marketing.IOUG can survive without Oracle, TUSC or myself. The question is whether or not that is for the best. Oracle and TUSC employees can provide some great sessions and information. They can also provide fluff and bad information. If we provide constructive feedback, the organization will either change or begin losing membership and disappear.Dan FinkPeter Barnett wrote: It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it.
Re: Programming languages that make DBA's lives easier
What's your goal? If you are writing scripts then use perl or python. IMO, python is more maintainable when your codebase gets bigger. If you're writing a system or application python is still good. If your goal is to get on the hype then go java, xml, .net, and throw in a webservice API. Also, you don't need to know how these work, but you do need to know how to use the wizards that can generate code for these. On Tue, 18 Feb 2003, Les Ayudo wrote: On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Teradata baned from IOUG???
On Tuesday 18 February 2003 07:04, Peter Barnett wrote: It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier Jared your right I just see PL/SQL different from other programming languages from the perspective of its openness. For example, I write korn shell scripts to do a number of things not just related to managing an Oracle database itself. I use C language for a number of things. PL/SQL I wouldn't use for anything but writing Oracle server-side code. That is what I meant. -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 1:00 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Programming languages that make DBA's lives easier PL/SQL is not a programming language? What are your criteria that must be met before it's a programming language? Jared On Tuesday 18 February 2003 09:24, [EMAIL PROTECTED] wrote: C Shell Scripting Perl Pl/SQL - not really a programming language Java Now, if the more developer-minded DBA's amongst us could rate them as % important that would be cool! -Original Message- Sent: Tuesday, February 18, 2003 11:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description:
RE: Programming languages that make DBA's lives easier
you can take the (more unix friendly) ksh c c++ Java path, all those languages are very similar, or the (more windows friendly) pl/sql Delphi path... if you know pl/sql... delphi should come pretty easily. If you know ksh, or c, then c++ and Java will come pretty easily... focus on your strengths, you don't want to spend the rest of your days working on something you're not good at. Nick -Original Message-From: Les Ayudo [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 8:56 AMTo: Multiple recipients of list ORACLE-LSubject: Programming languages that make DBA's lives easier On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used?
RE: DB character set
We have been dealing with the same issues here. That is great information. Thanks! Todd Carlson Oracle Database Administrator Tripos, Inc. (314) 647-8837 Ext.3246 -Original Message- Sent: Tuesday, February 18, 2003 11:11 AM To: Multiple recipients of list ORACLE-L In case anybody is interested in the character set business: I asked this question (best char set for mixed environment of Unix and MS DBs with primarily MS clients and C/S applications) Gilles Briard, the author of article in OraMag on accomodating Euro symbol in a DB (http://www.oracle.com/oramag/webcolumns/2001/index.html?euro.html). After couple of emails I realized that the basic question I should've asked in the first place is much simpler: Q: If DB charater set is WE8ISO8859P1 1-st user on MS Win with client side char set (part of NLS_LANG) WE8MSWIN1252 2-nd user on Unix with client side char set WE8ISO8859P1 Would there be any difference in performance (elapsed time) if both clients (one on Unix, one on MS Win) are located on the same segment with the same network bandwith and latency and run the same simple query (say select * from sys.source$; in SQL* Plus) ? I always thought that the one on MS Win might be slower (in the example above) because Oracle has to go through a char set conversion. The following URL from Oracle Globalization Guide seemed to confirm that: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96529/ch2. htm#100796 Gilles response was that if all other factors are the same and the only difference is the NLS_LANG value on the client, than user on Unix and MS should expirience the same performance (if I understood it correctly). The reason for this is the following steps that Oracle goes through in any case: 1 - DB server: translate char set P15 data to binary 2 - network transmission of binary data 3 - Client: translate binary to P15 back (in case of Unix) OR to WIN1252 (in case of MS Win) 4 - Client: graphical transformation So translation in step 3 or translation with conversion (or is it conversion with translation?) cost the same? I'll be setting up a test maybe next week (not only for performance impications, but also to check if symbols like 1/2 and 1/4 we use here can be stored and retrieved back), but I would appreciate if anybody can comment on the above. Resources used - 1. Globalization Guide 2. 144192.1 Whether or not to change the DB char set to support the Euro sign 3. 225938.1 Do I have incorrect char in the DB and how to recover 4. 140014.1 RDBMS support for the Euro Currency symbol 5. 15095.1 Exp/Imp and NLS considerations 6. 119119.1 UTF8 DB char set implications 7. 181508.1 Choosing the DB char set 8. 137127.1 Char set, Code Pages, Fonts and the NLS_LANG value 9. 158577.1 NLS_LANG explained (how does client-server char converison works?) 10. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96529/ch2. htm#100796 Thanks, Boris Dali. --- Boris Dali [EMAIL PROTECTED] wrote: Dear List, Life was pretty easy here before they came up with this euro symbol :-( We had WE8ISO8859P1 (the default I bevieve) as a char set on all Unix and MS (sorry we have those as well) DBs accross the board. That was also the client side char set (part of NLS_LANG) - most clients here are on MS (code page 1252), some browser based. Well, with euro it looks like they went different directions: - On MS: it's recommended to have WE8MSWIN1252 (super set of good old WE8ISO8859P1) - On Unix: it's WE8ISO8859P15 My question is: 1. if I want to stick with one char set accross the board (as we have now) for all DBs on Unix and MS AND 2. avoid (automatic, but not free) conversion on DB-Client Net communication AND 3. we need euro symbol is there a painless solution out there? Thanks, Boris Dali __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--
Re: Teradata baned from IOUG???
On Tuesday 18 February 2003 07:04, Peter Barnett wrote: It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. I can't speak for all of IOUG, but SELECT does not kowtow to Oracle. Not that there is animosity either, but we don't worry unduly about Oracle when selecting content for the magazine. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier Programming languages that make DBA's lives easier: The ones you already know and feel comfortable with. (Of course Oracle connectivity is a basic requirement.) Programming languages that make DBA's lives HARDER: The ones forced on you by others. The ones that you don't know which are harder to learn, harder to read, and/or have a lower productivity quotient: C; Java; Perl. :-) Programs that make DBA's lives hellish: The ones written by someone else. Especially poorly written programs/scripts with poor documentation and poor technique. Attitudes which make a DBA's life easier: Insatiable curiosity and the joy of learning new things. Holy Warrior... -Original Message- From: Robson, Peter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 10:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: Programming languages that make DBA's lives easier Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Nah! - FORTRAN ! peter
RE: Teradata baned from IOUG???
Anyone know if any of the 10 people running for the Board of Directors for IOUG is a TUSC employee? Noone claims it in their statements. Henry -Original Message- Sent: Tuesday, February 18, 2003 12:24 PM To: Multiple recipients of list ORACLE-L me too... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 11:11 AM evidently i'm not the only one who thinks that, interesting. joe It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
[no subject]
SET ORACLE-L DIGEST signature -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Piet de Visser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Programming languages that make DBA's lives easier
See, that depends on how big a shop you run. I have to pull duty as the sysadmin as well. If the installer does not work, a relink fails, etc, I can't call my unix guy and ask for it to be fixed. I have found many problems with the install programs as shipped by oracle, especially on Linux (all the way back to 8.0.5, iirc, up to and including 9iR2). Not all the problems can be fixed with knowledge of C, but if you know what the program is doing, or if you can slog your way through the makefile, you have a better chance of fixing it. If you can't get oracle installed, then there isn't much need for a dba, now is there? -Candi On Tue, 2003-02-18 at 12:59, Jared Still wrote: On Tuesday 18 February 2003 09:24, [EMAIL PROTECTED] wrote: C Not much need for most DBA's to ever use C, though not a bad thing to know. Certainly doesn't belong at the top of the list for a DBA. Jraed Shell Scripting Perl Pl/SQL - not really a programming language Java Now, if the more developer-minded DBA's amongst us could rate them as % important that would be cool! -Original Message- Sent: Tuesday, February 18, 2003 11:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boyle Candi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Programming languages that make DBA's lives easier
My vote as well. If you don't know PL/SQL you are not too effective as a DBA. Just a point and click addict. Knowing the shell you are in and having a utilitiy language to use while you are in it are good additions. Although , if you use Unix I would add AWK and SED to that list. -Original Message- Sent: Tuesday, February 18, 2003 12:20 PM To: Multiple recipients of list ORACLE-L I tend to agree here. I would say: 1. PL/SQL 2. korn shell (or sh, bash, whatever you choose). 3. Perl These are 3 necessities. -Scott At 09:59 AM 2/18/03 -0800, you wrote: You need to know PL/SQL if you're going to be effective with Oracle. Java is interesting, but not nearly as useful to a DBA as Perl. Jared On Tuesday 18 February 2003 08:56, Les Ayudo wrote: On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Teradata baned from IOUG???
I know Stan Yellott is not a TUSC employee. He is the President of RMOUG and a great guy who has worked behind the scenes at many IOUG conferences. He is a tremendous calming influence (as many of us recall from San Diego). I don't think Ian, Mark, Bill, Stephen or Steve are TUSC Employees, unless they have changed jobs recently. Henry Poras wrote: Anyone know if any of the 10 people running for the Board of Directors for IOUG is a TUSC employee? Noone claims it in their statements. Henry -Original Message- Sent: Tuesday, February 18, 2003 12:24 PM To: Multiple recipients of list ORACLE-L me too... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 11:11 AM evidently i'm not the only one who thinks that, interesting. joe It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,
RE: Programming languages that make DBA's lives easier
Microsoft DOS scripting for the Windows side. Patrice Boivin -Original Message- Sent: Tuesday, February 18, 2003 1:59 PM To: Multiple recipients of list ORACLE-L You need to know PL/SQL if you're going to be effective with Oracle. Java is interesting, but not nearly as useful to a DBA as Perl. Jared On Tuesday 18 February 2003 08:56, Les Ayudo wrote: On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Teradata baned from IOUG???
Rich Niemiec - IOUG President Rich Niemiec - TUSC SEO Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 1:29 PM Anyone know if any of the 10 people running for the Board of Directors for IOUG is a TUSC employee? Noone claims it in their statements. Henry -Original Message- Sent: Tuesday, February 18, 2003 12:24 PM To: Multiple recipients of list ORACLE-L me too... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 11:11 AM evidently i'm not the only one who thinks that, interesting. joe It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL
RE: Programming languages that make DBA's lives easier
#1, 2 are a must. #3 should be whatever your favor langauage whether it's Perl or Java or C etc. Richard -Original Message- Sent: Tuesday, February 18, 2003 1:59 PM To: Multiple recipients of list ORACLE-L My vote as well. If you don't know PL/SQL you are not too effective as a DBA. Just a point and click addict. Knowing the shell you are in and having a utilitiy language to use while you are in it are good additions. Although , if you use Unix I would add AWK and SED to that list. -Original Message- Sent: Tuesday, February 18, 2003 12:20 PM To: Multiple recipients of list ORACLE-L I tend to agree here. I would say: 1. PL/SQL 2. korn shell (or sh, bash, whatever you choose). 3. Perl These are 3 necessities. -Scott At 09:59 AM 2/18/03 -0800, you wrote: You need to know PL/SQL if you're going to be effective with Oracle. Java is interesting, but not nearly as useful to a DBA as Perl. Jared On Tuesday 18 February 2003 08:56, Les Ayudo wrote: On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Teradata banned from IOUG???
My turn to chime in. First, thank you Mr. Fink for a great email. How true your statements are. Second, let me state that TUSC has no involvement in the selection of any presentations for Live! As a senior member of the conference committee, there are over 30 (yes thirty) volunteers that read and review each and every abstract sent into the IOUG website. No one from TUSC is involved in this process. So you will ask how TUSC has 31 presentations at IOUG Live! 2002? The answer is elementary. TUSC is a recognized leader in the ability of their employees to deliver quality presentations. Just because you are a technical person with lots of knowledge does not mean that you know how to convey it to an audience. Ever listened to Bill Gates or Andy Mendelson? Their presentations are horrible, but they are very knowledgeable. Now, we also didn't do our own audit last year when the presentations were selected. This year the restrictions are in place. You will not see this type of occurrence again. In fact, the TUSC folks asked to not present at much. SO, if you are going to complain, submit quality abstracts. Submit realistic abstracts and keep submitting. Ari, please chime in if you want. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, February 18, 2003 1:10 PM To: Multiple recipients of list ORACLE-L Subject:Re: Teradata banned from IOUG??? Well said Dan. Jared On Tuesday 18 February 2003 09:30, Daniel W. Fink wrote: IOUG is a volunteer organization. If you don't like something about it, you can change it from the inside by becoming involved. Remember, the Board Of Directors election is currently open and it is a way to voice your opinion. Also, send feedback about things you don't like, offer solutions and offer to assist in making the change (the most important!). Don't like the articles in SELECT? Offer to write one or be an editor. Don't like the content on the website? Become a tip miner. IOUG-A Live is also volunteer run. Speakers are volunteers, many of the workers are volunteers. As a speaker, the amount of time (and expenses I pay for myself as do many others) spent on the papers and presentation is high. I think it is worth it, as long as I can help 1 person be a better technician. I try to make the paper and presentation as accurate and helpful as I can. In the past, I have had no support (financial or otherwise) from my employers in attending/speaking at conferences, but I consider it worth my time. If you don't like the lineup of speakers, submit for next year. For those who are attendees, it is important to show support to the speakers you respect and the topics that interest you. How many of you fill out the session evaluations? Do you rate the presentations on entertainment value or meaningful content? Do you encourage other people to attend the 'good' presentations? Do you fill out the conference evaluation? Our local user group has seen Oracle's involvement decrease drastically over the past few years. Recently, thanks to an excellent Oracle contact, who is a long time contributor to our organization, we are meeting together to find ways to help each other. Of course, the sales folks want to know How many new $$$ can we get by pitching new products at meetings? (strictly forbidden at our meetings if it parades as a technical session). We are finding creative ways to get the groups together, such as having Oracle host a SIG meeting in exchange for a brief sales pitch at the beginning, establishing a specific Vendor track at our annual Traning Days. Attendees know that the intent of the pitch/presentation and they also know that the technical sessions will be technical and not marketing. IOUG can survive without Oracle, TUSC or myself. The question is whether or not that is for the best. Oracle and TUSC employees can provide some great sessions and information. They can also provide fluff and bad information. If we provide constructive feedback, the organization will either change or begin losing membership and disappear. Dan Fink Peter Barnett wrote: It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to
RE: Programming languages that make DBA's lives easier
A list of languages doesnt do much good unless you know why they are needed and how important the language is to your Oracle implementation: 1) PL/SQL. Vital! Needed in order to create database triggers, functions, procedures, and packages. Know it and know how to write it well. This could be the single most important performance killer for systems. 2) Some Unix shell. I prefer Korn. Vital if you are maintaining Oracle DBs on a Unix/Linux platform to be able to debug Oracle problems by knowing where important Oracle files are located and how to examine and manipulate them. Also needed if you want to use Oracle Internet Directory on Windohs, via the CygWin environment. If you support Oracle on OpenVMS, extensive knowledge of DCL, the shell on OpenVMS, is a definite plus. 3) Perl. Very important. Its cross-platform, can do many OS functions with greater control over Korn/Bash/Csh (IMHO), and has a huge development base. I use it for DB functions like some hot backup-and-startup over multiple nodes as well as some external OS file manipulation (Oracle log and trace files) that was just too difficult to do in Korn from the OS and not applicable to do from Java in the DB. Theres also the Perl for Oracle DBAs book, which is very popular among folks on this list. (Sorry, Jared! Its next on my Book List, though! Tax refund soon!) 4) Java. Not critical for us yet, but we are rolling out a few Java apps in one of our DBs. Its needed for us because itll give us a way to replace some icky VB apps whose sole purpose is to e-mail from an app. Ive also setup some PL/SQL procedures that allow a developer to enable 10046 tracing, turn it off, and call Java to tkprof and copy the protected trace file to their directory. I still dont know Java much, but have been able to glean enough to pull this off. 5) Tcl. We dont need it, but it would be helpful if you want to roll your own OEM events, at least up until now. Not sure what the upcoming OEM version uses on the server side. 6) Tk. Cool if you want to roll your own GUI apps in Perl or Tcl. :) Thats my $.02. Enjoy! :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, February 18, 2003 10:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? -- 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).
RE: Programming languages that make DBA's lives easier
Borland tools... We have an app that was built using Borland C++, we are getting bizarre Dr.Watson errors on the NT server, regarding a ShlObj.pas unit and a SHBrowseForFolder API call. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 2:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Programming languages that make DBA's lives easier you can take the (more unix friendly) ksh c c++ Java path, all those languages are very similar, or the (more windows friendly) pl/sql Delphi path... if you know pl/sql... delphi should come pretty easily. If you know ksh, or c, then c++ and Java will come pretty easily... focus on your strengths, you don't want to spend the rest of your days working on something you're not good at. Nick -Original Message-From: Les Ayudo [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 8:56 AMTo: Multiple recipients of list ORACLE-LSubject: Programming languages that make DBA's lives easier On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used?
RE: Teradata baned from IOUG???
Neither is David Teplow (former president of NOUG) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daniel W. FinkSent: Tuesday, February 18, 2003 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata baned from IOUG???I know Stan Yellott is not a TUSC employee. He is the President of RMOUG and a great guy who has worked behind the scenes at many IOUG conferences. He is a tremendous calming influence (as many of us recall from San Diego).I don't think Ian, Mark, Bill, Stephen or Steve are TUSC Employees, unless they have changed jobs recently.Henry Poras wrote: Anyone know if any of the 10 people running for the Board of Directors for IOUG is a TUSC employee? Noone claims it in their statements. Henry -Original Message- Sent: Tuesday, February 18, 2003 12:24 PM To: Multiple recipients of list ORACLE-L me too... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 11:11 AM evidently i'm not the only one who thinks that, interesting. joe It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joseph S Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --
Re: Know 1 database, know them all?
Not quite true, as far as I know There's wait stuff in there, although not enough to my taste. There's cpu in there, and the start and stop time, which makes it possible to at least make a crude R = S + W, where the difficult part is breaking down the W into meaningful stuff. A long way to go, but I think they're aware of it. The guys from SQL Server Development I spoke to about it were very interested in the method and liked the whole idea. But don't forget that I'm always wrong. Mogens Broodbakker, Mario wrote: Mogens, the only problem with your statement about 'oracle myths king of the new world' is that the only way of looking at SQLServer performance is probably looking at ratio's: there are no wait statistics, there is one(1) latch wait counter though! for the complete system :( (apart from some other almost useless perfmon counters, taht is..) regards, Mario -Original Message- Sent: maandag 17 februari 2003 23:29 To: Multiple recipients of list ORACLE-L I see it from a slightly different (and probably wrong) angel, at least regarding the performance of things and databases: If you've worked with Oracle databases for some time (and have real experience), and know about the myths and their anti-thesis (use the wait interface instead of the #% ratio crap, know about RAID-5, don't have too many indexes, concentrate on LIO instead of PIO, etc.,etc.) you'll do quite fine. As Peter Gram once said to me: It's all about getting a database to perform on a platform. You can take your old presentations regarding Oracle myths and change it into a SQL Server or mySQL presentation, change a few details, and be king in the new world. Mogens Robert Eskridge wrote: Curiously, the basics are common across styles of cooking. You have to learn to coax the flavors out of the fresh ingredients and transform them into the proper texture and finish. Once you've mastered Italian cooking, you may not be a top notch German cook, but you're probably just a recipe or two away from being able to produce a very nice German meal... Databases have a certain similarity. If heading an Oracle project and I was given the choice between two people to work on my project, one having been the lead architect for a top notch product based on Sybase, and the other being an OCP that had worked on lack luster products, it would be hard not to pick the former. F Following the same logic. if I learn to cook a good Italian dish, then I F must automatically be an expert in preparing top-class Chinese, German, F Malay, Hungarian and French cuisine Yeah, right ! F Ferenc Mantfeld
Re: Teradata baned from IOUG???
Then why this feeling (in other countries, too) that IOUG should be called TOUG instead? Funny how certain presentations with the word "ratio" and something negative in their heading don't make it through the selection process, while presentations with the word "ratio" and something positive make it through. Funny how an abstract like the following nonsense makes it through the process. Just downright funny, strange and not very convincing... who in their right mind said this was a professional presentation that would be of interest to any serious optimiser guy or girl? Somebody must have said Aye to this. Are you ready? Here we go: "Lately, there has been a big push to ignore your hit ratio with claims that it is meaningless. This shallow minded view (usually by people who sell a tuning tool) ignores why people look at hit ratios and what they are looking for. This quick tip talk will show you what to look for and why. You will definitely know when, where why to look at your hit ratio in the future. Show you why your hit ratio matters. How to analyze the hit ratio. Fallacies by those who want to sell you products and tools instead. " Henry Poras wrote: Neither is David Teplow (former president of NOUG) -Original Message- From: [EMAIL PROTECTED][mailto:[EMAIL PROTECTED]]On Behalf Of Daniel W. Fink Sent:Tuesday, February 18, 2003 1:59 PM To: Multiple recipients of listORACLE-L Subject: Re: Teradata baned fromIOUG??? I know Stan Yellott is not a TUSC employee. He isthe President of RMOUG and a great guy who has worked behind the scenes atmany IOUG conferences. He is a tremendous calming influence (as many of usrecall from San Diego). I don't think Ian, Mark, Bill, Stephen or Steveare TUSC Employees, unless they have changed jobs recently. Henry Poraswrote: Anyone know if any of the 10 people running for the Board of Directors for IOUG is a TUSC employee? Noone claims it in their statements. Henry -Original Message- Sent: Tuesday, February 18, 2003 12:24 PM To: Multiple recipients of list ORACLE-L me too... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 11:11 AM evidently i'm not the only one who thinks that, interesting. joe It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Shopping - Send Flowers
RE: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier No offense but I have noticed in the various Unix/Oracle shops I have worked that more sys. admins. and Unix types knew korn shell prog. and Java then Perl. -Original Message- From: Ron Thomas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: Programming languages that make DBA's lives easier Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Programming languages that make DBA's lives easier 02/18/2003 09:56 AM Please respond to ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Programming languages that make DBA's lives easier
I thought it might be worthwhile to say WHY I prefer ksh for most scripting. As one writer put it, use a language you know. I've used ksh for years, so that is certainly one big factor in preferring it. But, that aside, if you use mostly the Bourne Shell syntax and stay away from the some of the Korn Shell syntactical candy that doesn't do anything extra, then your scripts are very easy to read, and are mostly self-documenting. For me, that is a big advantage. If you use ksh, then you need to become reasonably proficient with a few of the more important utilities such as sed and awk/nawk/gawk and become familiar with good old regular expressions (wonderful stuff!). One area where ksh is weak is its inability to set up a two-way socket with a child process like sqlplus. Perl can do this (for example, by using IPC::Open2). With ksh, you can send to the child, and you can receive from the child, but you can't converse with the child. Even with the coprocess (which is a pain to use), you still have one-way communication at any given time. However, 99% of the time, ksh will work fine. For that other 1% (OK, maybe 2%), you either figure out a workable compromise with ksh, or you use perl. If you want some reading material, my recommendation is: Unix System V: A Practical Guide by Mark G. Sobel (There is also a version for BSD) This is a outstanding overview of Unix including sh, ksh, and csh programming; as well as good introductions to sed, awk, and regular expressions. It also has chapters on emacs and vi (Remember, vi is your friend.). Amazon has the 3rd edition listed with a publish date of 1995. So there probably is some rather outdated info in the book on stuff like gopher, archie, possibly Mosaic (Oh hey, cool!). Just ignore this. All the other stuff is still completely relevant and presented in what I think is the perfect level of detail -- not too verbose; not too terse -- with good examples. Eventually, to get seriously cooking with sed and awk, you will need to get something like the O'Reilly sed and awk book. But, for ksh programming: If you work through the Bourne Shell and Korn Shell chapters of the Sobel book, it is likely that this book is all you will ever need. Another wonderful thing about this book is that it doesn't use the current trend of big fonts with big margins and thick paper to create a monster sized book. Instead, you get lots of information in a book that takes up little shelf space. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Programming languages that make DBA's lives easier
Title: RE: Programming languages that make DBA's lives easier 3, 4, 5, 6 can be replaced with Python or Jython with wx_Python for added GUI-ness. :-) http://www.networkcomputing.com/unixworld/tutorial/005/005.html#Others http://www.linuxjournal.com/article.php?sid=3882 http://www.linuxworld.com/linuxworld/expo/lw-python.html To know Python is to love Python. Language redactionist, minimalist, extremist, pacifist... -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 12:38 PM To: Multiple recipients of list ORACLE-L Subject: RE: Programming languages that make DBA's lives easier A list of languages doesnt do much good unless you know why they are needed and how important the language is to your Oracle implementation: 1) PL/SQL. Vital! Needed in order to create database triggers, functions, procedures, and packages. Know it and know how to write it well. This could be the single most important performance killer for systems. 2) Some Unix shell. I prefer Korn. Vital if you are maintaining Oracle DBs on a Unix/Linux platform to be able to debug Oracle problems by knowing where important Oracle files are located and how to examine and manipulate them. Also needed if you want to use Oracle Internet Directory on Windohs, via the CygWin environment. If you support Oracle on OpenVMS, extensive knowledge of DCL, the shell on OpenVMS, is a definite plus. 3) Perl. Very important. Its cross-platform, can do many OS functions with greater control over Korn/Bash/Csh (IMHO), and has a huge development base. I use it for DB functions like some hot backup-and-startup over multiple nodes as well as some external OS file manipulation (Oracle log and trace files) that was just too difficult to do in Korn from the OS and not applicable to do from Java in the DB. Theres also the Perl for Oracle DBAs book, which is very popular among folks on this list. (Sorry, Jared! Its next on my Book List, though! Tax refund soon!) 4) Java. Not critical for us yet, but we are rolling out a few Java apps in one of our DBs. Its needed for us because itll give us a way to replace some icky VB apps whose sole purpose is to e-mail from an app. Ive also setup some PL/SQL procedures that allow a developer to enable 10046 tracing, turn it off, and call Java to tkprof and copy the protected trace file to their directory. I still dont know Java much, but have been able to glean enough to pull this off. 5) Tcl. We dont need it, but it would be helpful if you want to roll your own OEM events, at least up until now. Not sure what the upcoming OEM version uses on the server side. 6) Tk. Cool if you want to roll your own GUI apps in Perl or Tcl. :) Thats my $.02. Enjoy! :) Rich
RE: Know 1 database, know them all?
If you are always wrong then you must be right about one thing (being always wrong), so there is reason to be cheerful, at least you got one thing right. -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 2:19 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Know 1 database, know them all?Not quite true, as far as I know There's wait stuff in there, although not enough to my taste. There's cpu in there, and the start and stop time, which makes it possible to at least make a crude R = S + W, where the difficult part is breaking down the W into meaningful stuff. A long way to go, but I think they're aware of it. The guys from SQL Server Development I spoke to about it were very interested in the method and liked the whole idea.But don't forget that I'm always wrong.Mogens
Cardinality Hint?
Anyone know anything about a /*+ CARDINALITY */ hint? I noticed it while extracting some MView fast refresh SQL. I can't seem to find anything documented about it. any one have any info they want to share? Robert -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: best way to provide GUI outside of telnet
Guys, Here is an interesting dilemna. Support Oracle (On Unix and/or Windows) and SQL Server (on Windows)and idea is to come up with a common GUI interface for looking at logs, schedule jobs even if it means using crontab -graphics for trend analysis -GUI console Any ideas on best architec. language for this?
RE: Know 1 database, know them all?
Funny..the last time I spoke with the guys in Redmond, they told me: You don't need that... And OK, I must admit there are a few undocumented wait thingies (viewable with dbcc perfmon according to my old notes..), but they are too cryptic too understand.. I like your R=S+W by the way..You should write a SQLserver paper on that! Mario -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: dinsdag 18 februari 2003 21:19To: Multiple recipients of list ORACLE-LSubject: Re: Know 1 database, know them all?Not quite true, as far as I know There's wait stuff in there, although not enough to my taste. There's cpu in there, and the start and stop time, which makes it possible to at least make a crude R = S + W, where the difficult part is breaking down the W into meaningful stuff. A long way to go, but I think they're aware of it. The guys from SQL Server Development I spoke to about it were very interested in the method and liked the whole idea.But don't forget that I'm always wrong.MogensBroodbakker, Mario wrote: Mogens, the only problem with your statement about 'oracle myths king of the new world' is that the only way of looking at SQLServer performance is probably looking at ratio's: there are no wait statistics, there is one(1) latch wait counter though! for the complete system :( (apart from some other almost useless perfmon counters, taht is..) regards, Mario -Original Message- Sent: maandag 17 februari 2003 23:29 To: Multiple recipients of list ORACLE-L I see it from a slightly different (and probably wrong) angel, at least regarding the performance of things and databases: If you've worked with Oracle databases for some time (and have real experience), and know about the myths and their anti-thesis (use the wait interface instead of the ¤#% ratio crap, know about RAID-5, don't have too many indexes, concentrate on LIO instead of PIO, etc.,etc.) you'll do quite fine. As Peter Gram once said to me: It's all about getting a database to perform on a platform. You can take your old presentations regarding Oracle myths and change it into a SQL Server or mySQL presentation, change a few details, and be king in the new world. Mogens Robert Eskridge wrote: Curiously, the basics are common across styles of cooking. You have to learn to coax the flavors out of the fresh ingredients and transform them into the proper texture and finish. Once you've mastered Italian cooking, you may not be a top notch German cook, but you're probably just a recipe or two away from being able to produce a very nice German meal... Databases have a certain similarity. If heading an Oracle project and I was given the choice between two people to work on my project, one having been the lead architect for a top notch product based on Sybase, and the other being an OCP that had worked on lack luster products, it would be hard not to pick the former. F Following the same logic. if I learn to cook a good Italian dish, then I F must automatically be an expert in preparing top-class Chinese, German, F Malay, Hungarian and French cuisine Yeah, right ! F Ferenc Mantfeld
Null Event in v$session_wait
Title: Null Event in v$session_wait All - I'm researching an performance issue with a Java program that appears to be hung in the database. I query v$session wait and it's waiting on a null event. What exactly does this mean ? I've searched several books and cannot find anything specifically on a null event wait event. Any help would be appreciated. Thanks!! -- Brian Chevrier [EMAIL PROTECTED]
Re: Programming languages that make DBA's lives easier
On Tue, Feb 18, 2003 at 12:23:49PM -0800, [EMAIL PROTECTED] wrote: No offense By definition there must be an offense in a holy war! but I have noticed in the various Unix/Oracle shops I have worked that more sys. admins. and Unix types knew korn shell prog. and Java then Perl. -Original Message- Sent: Tuesday, February 18, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Programming languages that make DBA's lives easier 02/18/2003 09:56 AM Please respond to ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Teradata baned from IOUG???
Don't know. Maybe TUSC is more vocal, the IOUG president has a lot of clout, or there are a lot more people than we think that need to take Miracle and Hotsos classes. I was just curious about the TUSC numbers in IOUG (something we can measure), even though that doesn't convey their influence. (Whenever I see TUSC mentioned I think of the alter ego of a Boston DJ who locked himself in the studio and played nothing but Fleetwood Mac's TUSK for hours.) Henry -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mogens NrgaardSent: Tuesday, February 18, 2003 3:34 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata baned from IOUG???Then why this feeling (in other countries, too) that IOUG should be called TOUG instead? Funny how certain presentations with the word "ratio" and something negative in their heading don't make it through the selection process, while presentations with the word "ratio" and something positive make it through. Funny how an abstract like the following nonsense makes it through the process. Just downright funny, strange and not very convincing... who in their right mind said this was a professional presentation that would be of interest to any serious optimiser guy or girl? Somebody must have said Aye to this. Are you ready? Here we go:"Lately, there has been a big push to ignore your hit ratio with claims that it is meaningless. This shallow minded view (usually by people who sell a tuning tool) ignores why people look at hit ratios and what they are looking for. This quick tip talk will show you what to look for and why. You will definitely know when, where why to look at your hit ratio in the future. Show you why your hit ratio matters. How to analyze the hit ratio. Fallacies by those who want to sell you products and tools instead. " Henry Poras wrote: Neither is David Teplow (former president of NOUG) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daniel W. FinkSent: Tuesday, February 18, 2003 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata baned from IOUG???I know Stan Yellott is not a TUSC employee. He is the President of RMOUG and a great guy who has worked behind the scenes at many IOUG conferences. He is a tremendous calming influence (as many of us recall from San Diego).I don't think Ian, Mark, Bill, Stephen or Steve are TUSC Employees, unless they have changed jobs recently.Henry Poras wrote: Anyone know if any of the 10 people running for the Board of Directors for IOUG is a TUSC employee? Noone claims it in their statements. Henry -Original Message- Sent: Tuesday, February 18, 2003 12:24 PM To: Multiple recipients of list ORACLE-L me too... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 11:11 AM evidently i'm not the only one who thinks that, interesting. joe It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this economic climate few can afford to do it. Should IOUG be able to survive without Oracle? Probably. Will it be able to survive without Oracle? I doubt it. --- Jonathan Lewis [EMAIL PROTECTED] wrote: It should be possible for the IOUG to live without Oracle's support. Obviously it would be better for all concerned if there is some measure of co-operation, and there's clearly no need for bloody-minded conflict. But if the IOUG just keeps doing things that the users want, then the users should be able to support it in the complete absence of any input from Oracle. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March 19th USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html MacGregor, Ian A. wrote: The IOUG cannot live without Oracle's support, but Oracle can survive without the IOUG. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -
RE: Programming languages that make DBA's lives easier
Cool! How'd you get Python to run from a DBMS_JOB? :D Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, February 18, 2003 2:34 PM To: Multiple recipients of list ORACLE-L 3, 4, 5, 6 can be replaced with Python or Jython with wx_Python for added GUI-ness. :-) http://www.networkcomputing.com/unixworld/tutorial/005/005.html#Others http://www.linuxjournal.com/article.php?sid=3882 http://www.linuxworld.com/linuxworld/expo/lw-python.html To know Python is to love Python. Language redactionist, minimalist, extremist, pacifist... -Original Message- Sent: Tuesday, February 18, 2003 12:38 PM To: Multiple recipients of list ORACLE-L A list of languages doesn't do much good unless you know why they are needed and how important the language is to your Oracle implementation: 1) PL/SQL. Vital! Needed in order to create database triggers, functions, procedures, and packages. Know it and know how to write it well. This could be the single most important performance killer for systems. 2) Some Unix shell. I prefer Korn. Vital if you are maintaining Oracle DBs on a Unix/Linux platform to be able to debug Oracle problems by knowing where important Oracle files are located and how to examine and manipulate them. Also needed if you want to use Oracle Internet Directory on Windohs, via the CygWin environment. If you support Oracle on OpenVMS, extensive knowledge of DCL, the shell on OpenVMS, is a definite plus. 3) Perl. Very important. It's cross-platform, can do many OS functions with greater control over Korn/Bash/Csh (IMHO), and has a huge development base. I use it for DB functions like some hot backup-and-startup over multiple nodes as well as some external OS file manipulation (Oracle log and trace files) that was just too difficult to do in Korn from the OS and not applicable to do from Java in the DB. There's also the Perl for Oracle DBAs book, which is very popular among folks on this list. (Sorry, Jared! It's next on my Book List, though! Tax refund soon!) 4) Java. Not critical for us yet, but we are rolling out a few Java apps in one of our DBs. It's needed for us because it'll give us a way to replace some icky VB apps whose sole purpose is to e-mail from an app. I've also setup some PL/SQL procedures that allow a developer to enable 10046 tracing, turn it off, and call Java to tkprof and copy the protected trace file to their directory. I still don't know Java much, but have been able to glean enough to pull this off. 5) Tcl. We don't need it, but it would be helpful if you want to roll your own OEM events, at least up until now. Not sure what the upcoming OEM version uses on the server side. 6) Tk. Cool if you want to roll your own GUI apps in Perl or Tcl. :) That's my $.02. Enjoy! :) Rich -- 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).
RE: Programming languages that make DBA's lives easier
No offense taken. Depending on the shop, java may be more critical than perl. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Paula_Stankus@doh. state.fl.us To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Programming languages that make DBA's lives easier 02/18/2003 01:23 PM Please respond to ORACLE-L No offense but I have noticed in the various Unix/Oracle shops I have worked that more sys. admins. and Unix types knew korn shell prog. and Java then Perl. -Original Message- Sent: Tuesday, February 18, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Programming languages that make DBA's lives easier 02/18/2003 09:56 AM Please respond to ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: best way to provide GUI outside of telnet
Also, single console for webserver both Micor. and 9ias -Original Message-From: Stankus, Paula G Sent: Tuesday, February 18, 2003 4:22 PMTo: '[EMAIL PROTECTED]'Subject: RE: best way to provide GUI outside of telnet Guys, Here is an interesting dilemna. Support Oracle (On Unix and/or Windows) and SQL Server (on Windows)and idea is to come up with a common GUI interface for looking at logs, schedule jobs even if it means using crontab -graphics for trend analysis -GUI console Any ideas on best architec. language for this?
RE: Programming languages that make DBA's lives easier
What are the good books you guys recommend for Shell Programming? I have old edition of UNIX shells by example (by Ellie Quigley). I need to replace this with some good book. Do I need to learn perl before reading PERL for DBAs? If so, what are the good perl books do you guys recommend? -- Babu -Original Message- Sent: Tuesday, February 18, 2003 1:04 PM To: Multiple recipients of list ORACLE-L I thought it might be worthwhile to say WHY I prefer ksh for most scripting. As one writer put it, use a language you know. I've used ksh for years, so that is certainly one big factor in preferring it. But, that aside, if you use mostly the Bourne Shell syntax and stay away from the some of the Korn Shell syntactical candy that doesn't do anything extra, then your scripts are very easy to read, and are mostly self-documenting. For me, that is a big advantage. If you use ksh, then you need to become reasonably proficient with a few of the more important utilities such as sed and awk/nawk/gawk and become familiar with good old regular expressions (wonderful stuff!). One area where ksh is weak is its inability to set up a two-way socket with a child process like sqlplus. Perl can do this (for example, by using IPC::Open2). With ksh, you can send to the child, and you can receive from the child, but you can't converse with the child. Even with the coprocess (which is a pain to use), you still have one-way communication at any given time. However, 99% of the time, ksh will work fine. For that other 1% (OK, maybe 2%), you either figure out a workable compromise with ksh, or you use perl. If you want some reading material, my recommendation is: Unix System V: A Practical Guide by Mark G. Sobel (There is also a version for BSD) This is a outstanding overview of Unix including sh, ksh, and csh programming; as well as good introductions to sed, awk, and regular expressions. It also has chapters on emacs and vi (Remember, vi is your friend.). Amazon has the 3rd edition listed with a publish date of 1995. So there probably is some rather outdated info in the book on stuff like gopher, archie, possibly Mosaic (Oh hey, cool!). Just ignore this. All the other stuff is still completely relevant and presented in what I think is the perfect level of detail -- not too verbose; not too terse -- with good examples. Eventually, to get seriously cooking with sed and awk, you will need to get something like the O'Reilly sed and awk book. But, for ksh programming: If you work through the Bourne Shell and Korn Shell chapters of the Sobel book, it is likely that this book is all you will ever need. Another wonderful thing about this book is that it doesn't use the current trend of big fonts with big margins and thick paper to create a monster sized book. Instead, you get lots of information in a book that takes up little shelf space. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).