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 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: http
RE: RAC recomended books
Title: Message I'd also recommend the book TruCluster Server Handbook co-authored by Jim Lola. Doesn't cover RAC, but goes into a lot of detail on the Tru64 clustering side. Jim really knows his stuff - I worked with him last year installing RAC at the company he works for in South San Francisco, and the Tru64 knowledge there is just outstanding. Very close relationship with Digital / Compaq / HP / whatever the next company is. 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 Broodbakker, MarioSent: Thursday, February 20, 2003 8:04 AMTo: Multiple recipients of list ORACLE-LSubject: RE: RAC recomended books Vladimir, The official manuals do a good job. Besides from that The O'Reilly Oracle Parallel Processing book is quite OK, but it repeats a lot of the info in the manuals. There happens to be a book called: Tru64 Unix Oracle9i CLuster quick reference (Digital Press) written by Tim Donar. It does a good job on the Tru64 specifics: Advfs, LSM and SAN part. Check out James Morle's Scaling Oracle8i: although 8i, it also containsgood OPS info applicable to 9i too. Also Steve Adam's Oracle Internals has a very good (very 'dense', hard to read: it reads like there's enough info to fill a book crammed in 1 chapter..) part on OPS (7-8), but a lot is still very applicable. Again: don't miss the manuals.. regards, Mario -Original Message-From: Vladimir Barac [mailto:[EMAIL PROTECTED]]Sent: donderdag 20 februari 2003 15:04To: Multiple recipients of list ORACLE-LSubject: RAC recomended books What books are "recomended reading" for RAC? Especially Tru64 based RAC? Beside paper books, are there any goodweb pages(beside metalink, of course) that are dealing with RAC? Thanks, Vladimir Barac
RE: Automatic Segment Space Management
-- -- --- _db_block_max_cr_dba 6 Maximum Allowed Number of CR buffers per dba What if there are more than 6 concurrent update requests for the same block. Would that not result in BBW? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointment is inevitable, but Discouragement is optional! ** The opinions and statements above are entirely my own and not those === message truncated === = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Anjo Kolk http://www.oraperf.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Autoextend on Oracle 7.3.4.5.0
Title: Message IIRC, you needed FILE$ or FILEXT$ - something like that anyway (those brain cells are long gone, I'm afraid!) 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 Sam BootsmaSent: Friday, February 21, 2003 7:44 AMTo: Multiple recipients of list ORACLE-LSubject: Autoextend on Oracle 7.3.4.5.0 We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. I know there is SQL that allows setting a data file to auto extend. I am trying to find out where in the data dictionary you can find out whether a data file is set to auto-extend or not. In later versions of Oracle (8, 8i, 9i) there is an autoextensible column in dba_data_files that provides this information. However, this column does not exist on Oracle 7.3.4: SQL desc dba_data_files Name Null? Type --- FILE_NAME VARCHAR2(257) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTES NUMBER BLOCKS NUMBER STATUS VARCHAR2(9) SQL Can anybody tell me how I can determine (from the data dictionary, not by experimenting) whether an Oracle 7.3.4 data file is set to auto-extend? Thank-you, SB
RE: [Q] ORACLE 9iR2 RAC on SUN server no need for SUN Cluster??
Whoever told you that must have been on some new form of drug. RAC runs on top of cluster software from the vendors. The cluster needs to be working before you can install RAC. How you do that without the OS cluster software is beyond me. 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: Friday, February 21, 2003 8:16 AM To: Multiple recipients of list ORACLE-L I heard from ORACLe sales person the ORACLE 9ir2 RAC come with ORACLE cluster and we don't need SUN cluster. I don't know is it true or NOT? anyone implement that? Thanks. _ -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener/Database shutdown sequence
Sometimes it does matter what is stopped rather than the order, but we can't tell why the original poster was asking. It depends on your environment. For example, one site I worked at had a separate listener for every database in their environment. Their reasoning was they made life easier for themselves when doing maintenance because they could just stop the listener and not worry about whether the database was accessible to normal users or not i.e. they didn't need to start the database in restricted mode, give extra privileges to application owner accounts temporarily while doing the maintenance and so on. This was for maintenance that required the app owner to log in to verify changes). On the other hand, if you have a single listener for all your databases and you want to do maintenance on just one, you would not want to stop the listener at all. Coming back to the original question, though, there is no dependency on the order, as you stated. 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- Mercadante, Thomas F Sent: Monday, March 03, 2003 9:04 AM To: Multiple recipients of list ORACLE-L David, it just doesn't matter. why do you even feel the need to shut the listener down? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, March 03, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases Any comments and/or issues David _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shared tnsnames.ora
IIRC, the announcement was that Oracle Names was obsolescent in 9i, which means it will be desupported completely in a later release. 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: Monday, March 03, 2003 10:36 AM To: Multiple recipients of list ORACLE-L Nope. namectl, names, et al binaries are still there and functional at 9.2 Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] et To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: shared tnsnames.ora 03/03/2003 11:04 AM Please respond to ORACLE-L My understanding was that ONAMES was removed from 9i and that they provided some sort of wrapper that goes around OID to make it look like a names server until you can covert all your clients. Can anyone confirm? I am not running 9i on any of my servers yet. -- Chuck - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 03, 2003 11:54 AM hello to everybody we tried oracle OID. it works fine. check it out, it's worthwhile. btw.:afaik oracle names is deprecated and will be withdrawn (... ok somewhen). pls fogive if i'm wrong about that, but i read it somewhere in the docu that comens with 9i. Apologies for any typing mistakes I failed to notice. Markus Reger Oracle Applications DBA Webmaster MBC University for Music and Performing Art Vienna [EMAIL PROTECTED] 02/27/03 21:48 PM I am looking for info on how you support a large number of PCs (200+) and keep each ones tnsnames.ora file in sync. It seems that most people do not touch them. Some try to modify them and when new databases are created, the tnsnames.ora files must be changes as well. It seems to be that a shared tnsnames.ora file on a network drive may work. I remember a thread awhile back about the order of resolution (home directory, then OH/network/admin .). Again, I am asking about people using the Oracle client to connect to 15+ databases (v7.3.4 - 9.0.x) on 10+ different servers. I have just started to think about this and posted here before I started my MetaLink search. TIA for any info. JF John Fedock K Line America, Inc. www.kline.com * 804.327. * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE
RE: Question related to security
Title: Message Your first statement is no longer true for 9.2 and later (it still remains true for earlier releases). In 9.2 the new system privilege, GRANT ANY OBJECT PRIVILEGE, allows users to grant and revoke privileges on objects on behalf of the object's owner to simplify the installation process. 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 Jacques KilchoerSent: Wednesday, March 05, 2003 12:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Question related to security Only UserA can grant access on a table belonging to UserA (unless another user was granted access with admin option.) However, UserB can create a procedure in the schema of UserA if UserB has CREATE ANY PROCEDURE system privilege. The procedure created will run with the privileges of UserA, and will be able to grant access on tables belonging to UserA. -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: mercredi, 5. mars 2003 09:35 To: Multiple recipients of list ORACLE-L Subject: RE: Question related to security I am surprised ... which user did you run this as? You mention in your original email that you don't jave the password for the owner and sys/system don't have admin rights ... Can you solve the puzzle? If you don't have privs with grant option, how could you grant it to someone else? plus this being dbms_sql, you need to have those privs directly granted to you ... -Original Message- From: Meng, Dennis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 05, 2003 9:35 AM To: Multiple recipients of list ORACLE-L Subject: RE: Question related to security Grant select on all tables is not what we were looking for exactly because of the reason brought up by Pat. The following solution provided by Jacques solved the problem - Execute Immediate is for Oracle 8.1 and later. In 7.3.4 you need to use the dbms_sql package for dynamic SQL. The procedure would be something like: create procedure third_party_app_user.grant_priv (table_name_in in varchar2, privileges_in in varchar2, grantee_in varchar2) as c_dynsql pls_integer ; ignore pls_integer ; begin c_dynsql := dbms_sql.open_cursor ; dbms_sql.parse (c_dynsql, 'grant ' || privileges_in || ' on ' || table_name_in || ' to ' || grantee_in, dbms_sql.native) ; ignore := dbms_sql.execute (c_dynsql) ; dbms_sql.close_cursor (c_dynsql) ; exception when others then if dbms_sql.is_open (c_dynsql) then dbms_sql.close_cursor (c_dynsql) ; end if ; raise ; end ; /
RE: System tablespace Oracle 9202
Title: Message Only if you use DBCA, I believe. 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 Godlewski, MelissaSent: Thursday, March 06, 2003 12:49 PMTo: Multiple recipients of list ORACLE-LSubject: System tablespace Oracle 9202 List, System tablespace for Oracle 9iR2 is defaulting to Dictionary Extent Management. I thought all tablespaces defaulted to Local in this release. Thu Mar 6 15:29:43 2003 create tablespace SYSTEM datafile '/oradb/DEV/system/system01.dbf' size 201M reuse default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online Thu Mar 6 15:29:57 2003 Completed: create tablespace SYSTEM datafile '/oradb/DEV Thu Mar 6 15:29:57 2003 create rollback segment SYSTEM tablespace SYSTEM storage (initial 50K next 50K) Completed: create rollback segment SYSTEM tablespace SYSTEM
RE: System tablespace Oracle 9202
Actually, I think the reason it's not default is because we don't introduce something as a new default (generally!) without giving you a release notice e.g. in reverse, we warned people more than one release beforehand that SVRMGRL would be removed. 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- Egan Sent: Thursday, March 06, 2003 1:59 PM To: Multiple recipients of list ORACLE-L It was only in 9.2 that it was possible to create the system tablespace as locally managed, and rumour says that in 10i system tbs defaults to locally managed. The reason it's not default in 9.2 is most likely because..: 1. Most likely they just didn't update the DBCA default scripts to use this feature when they went from 9i R1 to 9i R2 (read: the scripts was just copied from the 9i R1 source tree) 2. The feature is brand new, so if some problems turn up, most databases wont have it set, because they are created from the DBCA. Regards, Morten Egan Godlewski, Melissa wrote: List, System tablespace for Oracle 9iR2 is defaulting to Dictionary Extent Management. I thought all tablespaces defaulted to Local in this release. Thu Mar 6 15:29:43 2003 create tablespace SYSTEM datafile '/oradb/DEV/system/system01.dbf' size 201M reuse default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online Thu Mar 6 15:29:57 2003 Completed: create tablespace SYSTEM datafile '/oradb/DEV Thu Mar 6 15:29:57 2003 create rollback segment SYSTEM tablespace SYSTEM storage (initial 50K next 50K) Completed: create rollback segment SYSTEM tablespace SYSTEM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Morten Egan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 position on hints
You just gotta wonder about some instructors. :( I haven't heard anything about them going away. 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- Robert - IL Sent: Friday, March 07, 2003 9:01 AM To: Multiple recipients of list ORACLE-L This is facinating, where does this come from? This is the second time in a week that I've heard this statement being made by someone. Hints will never go away IMHO, and Oracle continues to add more and more of them. I was told by someone at a client site that they were told by an Oracle instructor that they should not use hints in 9i RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 3/7/2003 10:04 AM Hi, Does Oracle have an official position on hints ? Will they go away as the optimiser is becoming bettre or they are there to stay ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tél. (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 position on hints
Title: RE: Oracle position on hints The hints, actually, but then I haven't heard anything of the instructors going away either! J 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 Jamadagni, Rajendra Sent: Friday, March 07, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle position on hints Pete when you say ... I haven't heard anything about them going away. you mean the hints or them instructors ?? Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- From: Pete Sharman [mailto:[EMAIL PROTECTED]] Sent: Friday, March 07, 2003 12:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle position on hints You just gotta wonder about some instructors. :( I haven't heard anything about them going away. Pete
RE: Oracle position on hints
a line containing: UNSUB ORACLE-L (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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 position on hints
-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: POLL: Database to DBA ratio
33 DBA's to one database? That's pretty danged good! :) Seriously, this is a question that comes up every so often within Oracle as well, as clients ask Oracle employees what should be expected. There's no simple answer to it. As you might expect, the answer is it depends. :) Depends on (a non-exhaustive list): 1. Requirement for 24x7 DBA coverage 2. Complexity of database 3. Type of applications using the database 4. Database type (OLTP, DW etc.) 5. Number of tiers (two tier, three tier etc.) 6. Amount of input required into development of apps (tuning support and so on) And lots more as well. 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- Hamilton Sent: Tuesday, March 11, 2003 6:59 AM To: Multiple recipients of list ORACLE-L I'm trying to build a case for management that we need additional DBAs so I'd like to take a quick poll if I may. What is the ratio of Oracle databases to DBAs in your shop? This includes development and production databases. At our shop it's 33:1. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Identifying mult instances on Unix system
If it's the instances you're after, and they're running, the easiest way would probably be to issue ps -ef | grep pmon (or some other mandatory process) to get the list. 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- [EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 8:14 PM To: Multiple recipients of list ORACLE-L Hi All, I have multiple instances with multiple datadases (Not oracle parallel server) all running on my unix system. I am wondering how to identify which instances are running on my unix system, say HP-UX. Thanks Manoj -- 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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: OCP
Title: Message I think there are a couple of ways you can do this. Firstly, if you ring Prometric and try to register for the 9iUpgrade exam. IIRC, they'll ask you for your SSN and their system should reject you if you don't have the necessary pre-req certification. Secondly, you can send an email to [EMAIL PROTECTED]. From what it says on http://www.oracle.com/education/certification/faq/index.html?faq8.html, we're attempting to build an automated way of doing this. Problem is of course that all the records are actually held by Prometric as an independent body, so there may be legal issues with Oracle having a way to access that. As for the 50% passing score, sorry that's just wrong. As you can see here (http://www.oracle.com/education/certification/index.html?dba9i_exam.html), the passing score for that exam is 70%. 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 [EMAIL PROTECTED]Sent: Wednesday, March 12, 2003 6:39 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Re: OCP So how can you check the status of your 8i OCP so you can sign up for the 9i OCP upgrade exam? -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 12, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: OCP You only need to get 50% of the questions right on the upgrade tests. Why not set the goal to it get 100% right? ;) - Kirti -Original Message- Sent: Wednesday, March 12, 2003 7:29 AM To: Multiple recipients of list ORACLE-L I didnt realize that you might be able to do the 8i one without handing $2k to oracle for their class and taking the upgrade exams is a better path. anyone know if this is possible? You only need to get 50% of the questions right on the upgrade tests. From: "Darrell Landrum" [EMAIL PROTECTED] Date: 2003/03/12 Wed AM 07:48:43 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Jay, One thing to consider is that just starting the 9i track and if you've not taken any OCP exams prior to September of 2002, there is a requirement to attend one 9i training class in addition to the exams. However (you'll probably need to call Oracle to get a solid answer to this), if you can still take the 8i track with no classroom training and then take the 9i upgrade exam (if they allow this with no classroom training), this would be your least expensive route since the classes are quite expensive. The down side is a total of six exams instead of just four. If your company is willing to send you to one of the 9i classes, I would take advantage of that and just go for the 9i track. Good luck! Darrell -- 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: BMC Patrol
I remember eons ago when I was running Patrol training in Oz for BMC that it averaged something like about 5% or so. Depended on how many things you were monitoring and what the levels were set at IIRC. But that's quite dated now so I'd respect others figures more. 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- Barnett Sent: Wednesday, March 12, 2003 1:45 PM To: Multiple recipients of list ORACLE-L We are in the process of implementing BMC Patrol for monitoring our databases. This is a good thing since we have hundreds of database across several states. Monitoring from a single location with one tool makes sense. However, the question has arisen about the actual load that Patrol will put on the databases. To read Patrol's data, there are words such as, 'negligible' or 'minimal' but they offer no solid metrics. In the not too distant past, BMC's Perform and Predict product literally consumed all of the memory on our database machines and ground them to a halt. It took several weeks before BMC was able to correctly diagnose the problem and come up with a fix. Rather than repeat this experience I would like to hear from others using Patrol. If anyone has any hands on experience with performance problems resulting from implementing the Patrol KMs for Oracle, SQL Server or Sybase, I would appreciate hearing about them. Thanks, = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Create rollback segment under ORACLE 9ir2 failed????
Mike The only way this would have worked under 8i is if you had already created a dummy rollback segment in the SYSTEM tablespace. Something like this should work (before or after the CREATE TABLESPACE rollback_space) SQL connect / as sysdba; SQL CREATE ROLLBACK SEGMENT dummy; 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: Thursday, March 13, 2003 2:30 PM To: Multiple recipients of list ORACLE-L I am create database on ORACLE 9iR2 and fail on create rollback segment. SQL create tablespace rollback_space datafile 2 '/u4/oradata/TRAN/rbs01TRAN.dbf' size 800M 3 default storage ( 4 initial 256k 5 next 256k 6 pctincrease0 7 minextents 8 8 MAXEXTENTS 4096 9 ); Tablespace created. SQL SQL REM * Create rollback segments. SQL REM * SQL create rollback segment rollback_1 tablespace rollback_space 2 storage (initial 256K next 256k minextents 20 optimal 5M); create rollback segment rollback_1 tablespace rollback_space * ERROR at line 1: ORA-01552: cannot use system rollback segment for non-system tablespace 'ROLLBACK_SPACE' SQL create rollback segment rollback_2 tablespace rollback_space 2 storage (initial 256K next 256k minextents 20 optimal 5M); create rollback segment rollback_2 tablespace rollback_space * ERROR at line 1: ORA-01552: cannot use system rollback segment for non-system tablespace 'ROLLBACK_SPACE' Those script used to work under ORACLE 8i. Does anyone know why? Thanks. __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: utl_file_dir and 9i
True, but any DBA who puts utl_file_dir=* into their parameter file should be hung, drawn and quartered anyway! Just imagine what the effect is - you've now given people rights to open system01.dbf, write to it and close it. Hmm, could that cause any problems? :) 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- Landrum Sent: Friday, March 14, 2003 6:19 AM To: Multiple recipients of list ORACLE-L Good points, also consider the security issues that exist because of 'util_file_dir=*'. With that, any user that can run a procedure and write (or overwrite) files in locations that should be accessible only by oracle. [EMAIL PROTECTED] 03/14/03 07:08AM John, In 9i, Oracle is recommending that you make use of 'CREATE DIRECTORY' rather than UTL_FILE_DIR ... firstly because a directory can be created dynamically, so to adda new sub-directory you don't have to bounce the instance. Plus instead of '*', you can dynamically create directory ... read/write and drop the directory if you wish. I'd recommend you make use of this feature John, because UTL_FILE_DIR might just go away because of its limitations. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- Sent: Friday, March 14, 2003 4:44 AM To: Multiple recipients of list ORACLE-L In 8i we set utl_file_dir = * because otherwise we have to specify lots of individual directories. It was not possible to just specify a top level directory. Has this changed in 9i? Is it possible to specify a top level directory and then utl_file can write to subdirectories? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: log buffer space
Really? I thought that condition was there pre-9i as well. Maybe I'm mistaken. 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- WILLIAMS Sent: Friday, March 14, 2003 8:19 AM To: Multiple recipients of list ORACLE-L Add one more condition: New in Oracle 9i, it will write when 1 meg is reached, so the 1/3 criteria is never reached if you use a big buffer. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 14, 2003 8:59 AM To: Multiple recipients of list ORACLE-L KG, Thanks for the response. Just for my curiosity, is it documented somewhere that the log buffer if flushed when 2/3rd full? From the Manual /server.920/a96524/c09procs.htm#3158 (please check the URL in OTN, the first part is not complete), here is an excerpt MANUAL LGWR writes one contiguous portion of the buffer to disk. LGWR writes: a.. A commit record when a user process commits a transaction b.. Redo log buffers a.. Every three seconds b.. When the redo log buffer is one-third full c.. When a DBWn process writes modified buffers to disk, if necessary /MANUAL At least this was the behavior I tested in 8.1.7; although I have not tested in 9i. This has also been stated by several Oracle Support Analysts. Thanks. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 14, 2003 7:32 AM Arup: NO FLAMES The second condition is not quite true. It is 2/3 full in the current versions. /NO FLAMES It is very easy to test with the event 10046^8. KG --- Arup Nanda [EMAIL PROTECTED] wrote: AK, If the log buffer is at least 4MB, then increasing it will not help, rather it may hurt. The log buffer is flushed when any of the the follwoing occur (i) 1 MB is filled up (2) 1/3rd is filled up (3) every 3 seconds (4) when a checkpoint occurs (5) when a commit occurs. Therefore, see if any of these could be the problem. It's easy to check #s 4 and 3. As Kirti suggested, the problem could be due to the redo logs being on a busy disk, or even a slow one. HTH. Arup - Original Message - From: Deshpande, Kirti To: Multiple recipients of list ORACLE-L Sent: Thursday, March 13, 2003 8:13 PM Subject: RE: log buffer space Increasing log_buffer size is an option, if it is really small. I would also check if the redo logs are on a busy disk. If so, try moving those (or other busy data files on the same disk) to other not-so-busy disks. - Kirti = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network
RE: Multiple Instances and 9iRAC
Title: Message RAC is a multiple instance one database configuration. Different instances on different nodes accessing a single database on shared disk. Can you have multiple RAC databases running in a cluster? Sure, if the machine has enough resources. That's about as close as we can say without testing it. I'd be surprised to see the interconnect flood because of three instances though. 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 Thompson, ToddSent: Friday, March 14, 2003 10:29 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple Instances and 9iRAC My company is currently considering using Oracle 9i RAC. One of the proposed environments is to have multiple oracle instances (3 or more) configured on a 4-8 node RAC cluster. Does anyone have any insights as to the viability of this implementation? Will the high speed inter connect be able to handle the traffic from multiple instances? I always thought of RAC as a single instance implementation with each instance needing its own cluster...
RE: File Restoration/Recovery
What can I say? Shoot the danged developer! No, no, no, no, no. The backup is as much use as the proverbial on a bull. Period. 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- Chambers Sent: Friday, March 14, 2003 7:44 AM To: Multiple recipients of list ORACLE-L All... A developer working on a Solaris 2.6 server running Oracle 7.3.4 desires a nightly backup (by simply copying them to a backup directory) of the datafiles of an active instance. I explain that it will be a waste of tape because the files will be corrupt and useless. He counters, As long as these files are there, irrespective of their state, oracle [sic] provides the tools to restore the skeleton database based on these files. Will this be the case? I understand that there will [most likely] be some loss of data, but will Oracle fix itself to a point where it's useful again? TIA Gary Chambers //-- // Lucent Technologies ITO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gary Chambers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: utl_file_dir and 9i
Nah, can't do that! It would make our training courses that use it too difficult to set up! :) 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- Kirti Sent: Friday, March 14, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Precisely But wouldn't it be nice if Oracle made '*', in the utl_file_dir specification, an unacceptable parameter value? - Kirti -Original Message- Sent: Friday, March 14, 2003 9:19 AM To: Multiple recipients of list ORACLE-L True, but any DBA who puts utl_file_dir=* into their parameter file should be hung, drawn and quartered anyway! Just imagine what the effect is - you've now given people rights to open system01.dbf, write to it and close it. Hmm, could that cause any problems? :) 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- Landrum Sent: Friday, March 14, 2003 6:19 AM To: Multiple recipients of list ORACLE-L Good points, also consider the security issues that exist because of 'util_file_dir=*'. With that, any user that can run a procedure and write (or overwrite) files in locations that should be accessible only by oracle. [EMAIL PROTECTED] 03/14/03 07:08AM John, In 9i, Oracle is recommending that you make use of 'CREATE DIRECTORY' rather than UTL_FILE_DIR ... firstly because a directory can be created dynamically, so to adda new sub-directory you don't have to bounce the instance. Plus instead of '*', you can dynamically create directory ... read/write and drop the directory if you wish. I'd recommend you make use of this feature John, because UTL_FILE_DIR might just go away because of its limitations. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- Sent: Friday, March 14, 2003 4:44 AM To: Multiple recipients of list ORACLE-L In 8i we set utl_file_dir = * because otherwise we have to specify lots of individual directories. It was not possible to just specify a top level directory. Has this changed in 9i? Is it possible to specify a top level directory and then utl_file can write to subdirectories? John -- -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: log buffer space
: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 JDBC thin driver
Title: Message No, that's why it's the thin driver. If you want TAF capability, you have to use the JDBC thick driver instead. 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 Rick StephensonSent: Friday, March 14, 2003 10:15 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle JDBC thin driver Oracle 9.2.0.2 Can the Oracle JDBC thin driver be used with RAC to setup failover and load balancing between instances in the same way the thick driver can? Thanks, Rick Stephenson This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, forwarding or otherwise distributing or taking any action in reliance on the contents of this information is strictly prohibited.
RE: 9i RAC - GFS
Yup. I believe it's something we're actively working with Sun on, because other clustered fil systems (like Compaq's) perform fine. Sun's is just too slow for some reason. 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- [EMAIL PROTECTED] Sent: Friday, March 14, 2003 8:39 PM To: Multiple recipients of list ORACLE-L Attached in a quote from an Oracle Rep, asking us to avoid Global file systems on Sun Cluster nodes for 9i RAC. It is very clear that binaries and/or datafiles on GFS are not supported today. The reason for this is the proxy I/O that GFS is based on can be a real performance and scalability bottleneck. However, The use of GFS for archive logs is the one circumstance where GFS may work for you. The caveat here is that this has not been well tested. Noone internally at Oracle is actively testing with GFS in any capacity today, and I'm not personally aware of any customers who have done this. As a best practice recommendation, we suggest it be avoided altogether. However, if you have the luxury of time to be able to test performance both in standard operational peak loads, and the various backup and media recovery scenarios where you would need to access the archive logs, then you will not get any push back from Oracle Support saying you are running an un-supported configuration, we can't help you. Is this true? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 9i - Which Patchset
Ah yes, but they've promised that all the Tru64 capabilities will be in HP-UX by then. And of course, we always believe vendors' promises, don't we? :) 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, March 18, 2003 8:49 AM To: Multiple recipients of list ORACLE-L Stephan, I am wondering why would you not rate Tru64 as a stable platform. We are using it for all our OLTP and datawarehouse needs; and it has been quite stable. It's rather unfortunate that HP is retiring it in 3 years. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 10:59 AM Given my experience here, stable and Tru64 don't go together. As to the patch number, Oracle support usually requires that you be at the latest patch level. -Original Message- Any opinions on which patchset of 9.2 is most stable: 9.2.0.1, 9.2.0.2, 9.2.0.3? We're running HP Tru64. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Value of OCP
Dang, I gotta get a copy of that report to my manager! After going through the 7.3, 8, 8i and 9i OCP AND the OCM, I don't think any of them got me a pay increase! ;) 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- WILLIAMS Sent: Wednesday, March 19, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Foote Partners surveys the value of certifications. They support that over the past two years, the OCP pay premium increased by nearly 40%. In the same period, the value of Microsoft MCP declined by nearly 60%. A good article on the value of certifications. http://www.eweek.com/article2/0,3959,936853,00.asp I don't see where they included the Foote data online. It is in the eWeek magazine 3/17/03 edition, page 50. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- 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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reorganizing tables
You gotta imagine the British accent with it Jared. It's what you need to take into account when a database is accessible over the Internet (otherwise known as the Hacking Factor) ;) 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- [EMAIL PROTECTED] Sent: Monday, March 24, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Jonathan, What is the 'Haken' factor? Jared Jonathan Lewis [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/24/2003 02:24 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Reorganizing tables This may have been mentioned already, but a table re-org can be a positive threat to performance. If your primary tables have (for example) a three-stage life: initial row size is small row grows after a couple of weeks row reaches full size after another 4 weeks, then what value are you going to use for your PCTFREE when you rebuild ? If you set it to zero to avoid wasting space for the vast percentage of rows that are full size then many incomplete rows will end up migrating. If you set it to match the growth requirement of the newest rows, then you leave lots of empty space in the blocks that hold only old rows. (The optimum storage answer is to set the Hakan factor before moving the table - but that's not a trivial exercise because of a bug whose number I can't remember). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk For one-day tutorials: (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___April 8th UK___April 22nd Denmark May 21-23rd USA_(FL)_May 2nd Next dates for the 3-day seminar: (see http://www.jlcomp.demon.co.uk/seminar.html ) UK_(Manchester)_May Estonia___June (provisional) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: 24 March 2003 20:53 Thanks Jared, Rachel, Tom, Dick, Prakash, Ron Excellent points. Very much appreciated. Unfortunately at this point people are asking but have you tested it?. So I need to construct some type of test that will demonstrate how much effect a reorg will have. After I've answered that question, then I can move on to some of the other issues that you mention. I have joked that if the results are strongly positive, they won't see me much after that because I'll be touring the world selling my performance solution that never occurred to anyone else. Our test system is cloned from an RMAN backup of production so the tables should be close to production. I'm thinking of creating a new table and copying the contents of a production table into it and then tracing full-table scans and comparing the results. Jared - is there a way to estimate block-level fragmentation? Comparing the average row length with the number of blocks used? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from 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: Oracle Grid,Streams
I think you're confusing something here, or maybe that's just the way the title of your email reads. Oracle has technology that fits in the grid computing paradigm, and Streams is obviously part of that. But there is no Oracle Grid product that you can buy that I'm aware of. Have you looked at the marketing bumph at http://otn.oracle.com/products/oracle9i/grid_computing/content.html? That might clarify things for you somewhat. And yes, there are customers who have implemented Streams successfully. If you want more details about how Oracle fits in the grid computing space, contact me offline and I can point you to the right contacts in Oracle. 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- [EMAIL PROTECTED] Sent: Friday, March 28, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Hi List What are the Pros and Cons of the above?. Has anyone in the industry implemented the above successfully?. Are there any pitfalls / restrictions to using the above technology? TIA GovindanK -- * *YOU SHOULD TREAT OTHERS THE WAY YOU WANT TO BE TREATED - MAHATMA GANDHI* * __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promos=380455 -- 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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: alert log file
Title: Message No problems, just move it. No need to shutdown, Oracle will just create a new file next time it needs to write to it. Moving the alert log should be something you do on a regular basis. 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 AKSent: Monday, March 31, 2003 7:54 AMTo: Multiple recipients of list ORACLE-LSubject: alert log file for one of the db over here alert log is biggg .Looks like its never been truncated or backup . Is it a problem if i just move this alert log file to another directory , will oracle create a new alert log file ? Do I need to bounce db ? btw its 8.1.6 ( hp-ux ) -ak
RE: PGA
how to fish, and...he will sit in a boat and drink beer all day __ Yahoo! Plus For a better Internet experience http://www.yahoo.co.uk/btoffer -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PGA
Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Yahoo! Plus For a better Internet experience http://www.yahoo.co.uk/btoffer -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Autoallocate vs Uniform extent performance
) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Yahoo! Plus For a better Internet experience http://www.yahoo.co.uk/btoffer -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --- -- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message
RE: skip scan index
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rule Based Optimizer
Much as I hate to say that Jared's confidence in Mogens is misplaced, we must all remember Mogens has now reached the grand old age of 42 and the brain cells are starting to slip. :) To be absolutely 100% picky and correct, there was an event setting introduced in (I believe) 6.0.27-ish that you could use to turn on the CBO. However, Mogens is correct in that it was first officially released and supported in the first Production release of Oracle7, 7.0.13. Sorry, Mogens, couldn't resist! :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long term Oracle DBA. -Original Message- Mogens Nørgaard Sent: Tuesday, June 10, 2003 7:55 PM To: Multiple recipients of list ORACLE-L Thanks for the confidence, Jared. It was introduced in 7.0 and the world hasn't been the same since. Mogens Jacques Kilchoer wrote: I am 99% confident that I remember the CBO existing on VAX/VMS in 7.1.5, and for sure in 7.1.6 (on VAX/VMS) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] I first saw the CBO in 1994 if IIRC. Seems to me it was introduced in 7.2. I'm sure Mogens knows for sure. :) -- 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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rule Based Optimizer
Yup, I remember praying exactly the same thing! Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long term Oracle DBA. -Original Message- Jared Still Sent: Wednesday, June 11, 2003 10:10 PM To: Multiple recipients of list ORACLE-L 7.0.13. Ah yes, I remember that. Mostly I remember praying that 7.0.16 would be in the mail RSN. Jared On Wednesday 11 June 2003 18:14, Pete Sharman wrote: Much as I hate to say that Jared's confidence in Mogens is misplaced, we must all remember Mogens has now reached the grand old age of 42 and the brain cells are starting to slip. :) To be absolutely 100% picky and correct, there was an event setting introduced in (I believe) 6.0.27-ish that you could use to turn on the CBO. However, Mogens is correct in that it was first officially released and supported in the first Production release of Oracle7, 7.0.13. Sorry, Mogens, couldn't resist! :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long term Oracle DBA. -Original Message- Mogens Nørgaard Sent: Tuesday, June 10, 2003 7:55 PM To: Multiple recipients of list ORACLE-L Thanks for the confidence, Jared. It was introduced in 7.0 and the world hasn't been the same since. Mogens Jacques Kilchoer wrote: I am 99% confident that I remember the CBO existing on VAX/VMS in 7.1.5, and for sure in 7.1.6 (on VAX/VMS) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] I first saw the CBO in 1994 if IIRC. Seems to me it was introduced in 7.2. I'm sure Mogens knows for sure. :) -- 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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rule Based Optimizer
Indeed you are right, but I'm sad to say we failed. After 180 or so people passed through the house on Saturday, we probably have MORE alcohol than when we started. What can I say? We'll have to have another party! J 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 Mogens Nørgaard Sent: Saturday, June 14, 2003 12:05 AM To: Multiple recipients of list ORACLE-L Subject: Re: Rule Based Optimizer Pete - I love it when you talk dirty. It will probably only get worse in the next 24 hours, since - if I recall correctly - you're having the I'm going back to Australia, so let's empty all the bottles in my house party tonight? Thanks for the note on 6.0.27. It's funny how things are introduced early in releases sometimes. OPS was in 5, CBO in 6, some waits in 6 (the x$trace stuff). And it's all still around in 9 :-))). Mogens Pete Sharman wrote: Yup, I remember praying exactly the same thing! PeteControlling developers is like herding cats.Kevin Loney, Oracle DBA HandbookOh no, it's not. It's much harder than that!Bruce Pihlamae, long term Oracle DBA.-Original Message-Jared StillSent: Wednesday, June 11, 2003 10:10 PMTo: Multiple recipients of list ORACLE-L7.0.13. Ah yes, I remember that.Mostly I remember praying that 7.0.16 wouldbe in the mail RSN. JaredOn Wednesday 11 June 2003 18:14, Pete Sharman wrote: Much as I hate to say that Jared's confidence in Mogens is misplaced, we must all remember Mogens has now reached the grand old age of 42 and the brain cells are starting to slip. :)To be absolutely 100% picky and correct, there was an event settingintroduced in (I believe) 6.0.27-ish that you could use to turn on theCBO. However, Mogens is correct in that it was first officiallyreleased and supported in the first Production release of Oracle7,7.0.13.Sorry, Mogens, couldn't resist! :)PeteControlling developers is like herding cats.Kevin Loney, Oracle DBA HandbookOh no, it's not. It's much harder than that!Bruce Pihlamae, long term Oracle DBA.-Original Message-Mogens NørgaardSent: Tuesday, June 10, 2003 7:55 PMTo: Multiple recipients of list ORACLE-LThanks for the confidence, Jared. It was introduced in 7.0 and the world hasn't been the same since.MogensJacques Kilchoer wrote: I am 99% confident that I remember the CBO existing on VAX/VMS in 7.1.5, and for sure in 7.1.6 (on VAX/VMS) -Original Message-I first saw the CBO in 1994 if IIRC.Seems to me it was introduced in 7.2.I'm sure Mogens knows for sure. :)
RE: Look's like Larry's at it again...
Excellent, but I really thought he meant to call it Larry Land! :) 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- Jesse, Rich Sent: Friday, June 20, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Oracle Makes Bid to Buy State of Delaware Software giant willing to assume state's $225 million deficit in exchange for legislative control, naming rights Wilmington, DE - Oracle CEO Larry Ellison today announced his intention to purchase the state of Delaware for $300 million in cash and Oracle stock. The move comes on the heels of Oracle's bid for rival software firm PeopleSoft, and is the first time that an offer has been made to buy a U.S. territory. Delaware governor Ruth Ann Minner responded to the bid with shock and seemed certain that the hostile takeover could be avoided. Oracle's bid comes as a big surprise to the government and people of Delaware, said Minner at a press conference. At this point, we are checking into whether or not a company, such as Oracle, can buy a state, and whether or not Delaware is actually for sale. Oracle's announcement sent shockwaves through the political and economic landscape. Oracle shares dropped 8% immediately following the announcement, only to rebound and break even for the day, with heavy volume being traded. Meanwhile, government officials in Washington scrambled to look into the legality of such a purchase, and who actually currently owns Delaware. In an afternoon press conference, Ellison seemed certain that Oracle would own Delaware in the near future. The fact is that the state of Delaware is in a budget crisis that it can not resolve. Oracle's bid will immediately pump $300 million into the state budget, and (Oracle) will also be assuming all current Delaware debt. Call this a 'hostile takeover' if you must, but the people of this great state deserve a better future, and I will be able to give them just that. President Bush, who was giving a speech to coal miners in Kentucky, called the Oracle bid interesting and added that 49 states would be easier for me to handle than 50. Ellison rival Tom Siebel called the move typical, and added Larry thinks he can take over the world, and I guess he thinks this is a good place to start. I personally would have targeted Vermont. Ellison defended his decision, citing fourteen state parks, a minor league baseball franchise, an annual Nascar race in Dover, and the annual Great Delaware Kite Festival as reasons that Delaware is primed for success. Delaware is a state rich in tradition and excitement. None of the existing festivals or events will be changed. I mean, who doesn't love minor league baseball and kites? If the takeover bid is successful, Ellison plans to place several Oracle executives in key state government positions, and is considering re-naming the state either New Ellison or OracleLand. [Couldn't resist, Jared! Hope it's not too OT!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Migrating 8i OPS to RAC 9.2
Well, you always irritate me with your words and more than just a bit! :) (For those unaware of it, Robert and I have reviewed each others books for sometime now, so we feel free to abuse each other on a regular basis!) As I think Dennis said (but I've deleted the message now so I could be wrong), you've added a lot of value to the Oracle community and should keep that going. There are always times when you can feel irritated with work (whether it's Oracle or not). I generally find a few whiskeys help to sort that out! :) 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: Wednesday, June 25, 2003 12:37 PM To: 'Pete Sharman '; 'Multiple recipients of list ORACLE-L ' I'm gonna start callin' ya Pete Mr. Company Line Sharman. Must say I'm rather upset right now... someone on ORACLE-L is making nasty suggestions to Oracle that I am revealing 10i stuff there one case where I just happened to mention that I was on the beta (which I should have thought better of granted) and one where I mentioned a feature in 10i, but didn't mention that it was a feature... in fact, I didn't even think of it in those terms when I wrote the article (it was about default user tablespaces). Oracle and I have had some words about that, and I probably irritated them with my words just a bit. I'm just about to give up on this whole Oracle thing I think. :-) RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 9i OCP Details
Well that not too surprising. Just about everything Scott does (he still works with Oracle) is very, very good. Most recent thing I've seen him working on was the OCM exam, which no doubt explains why it was so hard! I believe the Internals course morphed into a series of internal courses (i.e. only Oracle staff can attend) that are three to five days long. There are now 8 of them. They are also presented to customers as one day seminars, by the same instructors that run the internal versions. Not too sure how you locate them, but they may be marketed with a course code starting with DSI (Data Server Internals). 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- Gogala, Mladen Sent: Thursday, June 26, 2003 8:36 AM To: Multiple recipients of list ORACLE-L You are talking about Scott Gossett jr. I took that internals course and it was good. It was very, very good. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, June 26, 2003 10:25 AM To: Multiple recipients of list ORACLE-L Gudmundur Bjarni Josepsson wrote: If you want real advanced courses go with [...] what Jonathan Lewis or guys at his level provide. I have to agree on this. I've had the good fortune to sit in on Lewis's 'Optimising Oracle' and Cary Millsap's 'Hotsos Clinic 101' and no course I ever took from Oracle Education comes close to what these guys offer (and I've taken quite a few). The only course from Oracle Education that's come close for me is the internals course that I took about 3 or 4 years ago. I haven't seen it offered recently. The instructor was Scott somebody, who was, I was told, THE Scott or Scott/Tiger fame. I second the recommendation for Jonathan Lewis; his Cost-Based Optimization course was well taught and I found it very useful. Craig Shallahamer (www.orapub.com) also offers some worthwhile courses and is a very good instructor. I'll find out about the Hotsos Clinic this August in Denver. Looking forward to it. Glenn Stauffer -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 9i OCP Details
Quite right. It was Bruce Scott (didn't he do something at IOUG this year?) and I believe Tiger is (or presumably was since this was so long ago and the poor beastie has presumably karked it) his cat. 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- Rachel Carmichael Sent: Thursday, June 26, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Scott Gossett taught/teaches the Data Internals class and he is not the Scott of Scott/tiger --- Glenn Stauffer [EMAIL PROTECTED] wrote: Gudmundur Bjarni Josepsson wrote: If you want real advanced courses go with [...] what Jonathan Lewis or guys at his level provide. I have to agree on this. I've had the good fortune to sit in on Lewis's 'Optimising Oracle' and Cary Millsap's 'Hotsos Clinic 101' and no course I ever took from Oracle Education comes close to what these guys offer (and I've taken quite a few). The only course from Oracle Education that's come close for me is the internals course that I took about 3 or 4 years ago. I haven't seen it offered recently. The instructor was Scott somebody, who was, I was told, THE Scott or Scott/Tiger fame. I second the recommendation for Jonathan Lewis; his Cost-Based Optimization course was well taught and I found it very useful. Craig Shallahamer (www.orapub.com) also offers some worthwhile courses and is a very good instructor. I'll find out about the Hotsos Clinic this August in Denver. Looking forward to it. Glenn Stauffer -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance
A.acm_codigo= pCuenta AND A.acm_sucursal = i AND TRUNC(A.ACM_FECACUM) IN (select nvl(max(TRUNC(ACM_FECACUM)), '2001/01/01') FROM TCON_ACUM T WHERE T.Acm_codigo = A.acm_codigo AND T.ACM_Sucursal = A.ACM_SUcursal AND T.ACM_Oficina = A.ACM_Oficina AND T.ACM_Moneda = A.ACM_MOneda) GROUP BY Nvl(A.ACM_ACUMDBANT,0), nvl(A.ACM_ACUMCRANT,0), nvl(A.ACM_ACUMDB,0),nvl(A.ACM_ACUMCR,0); exception when no_data_found then vSaldoAnt := 0; when others then dbms_output.put_line((pCuenta)); end; vFechaIni := vFechaIni + 1; begin SELECT SUM (DECODE(T.TSA_TIPO, 'D', NVL(T.TSA_VALOR,0))) , SUM (DECODE(T.TSA_TIPO, 'C', NVL(T.TSA_VALOR,0))) into vDebito, vCredito FROM TCON_TRANSA T, TCON_DESTRAN D WHERE T.TSA_SUCURSAL = I AND T.TSA_CUENTA = pCuentaAND D.DST_NUMTRAN = T.TSA_NUMTRAN AND D.DST_SUCURSAL = T.TSA_SUCURSAL AND D.DST_FECHA BETWEEN vFechaIni and pFecha AND D.DST_CUADRA = 'S' ; exception when no_data_found then vDebito := 0; vCredito := 0; when others then null; end; vSaldo :=nvl (vSaldo,0) + (nvl(vSaldoAnt,0) + nvl(vDebito,0) - nvl(vCredito,0)) ; end loop; return vSaldo ; end; / Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net === message truncated === __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cary/Others RE: should you seperate indexes from tables in
ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). American Express made the following annotations on 07/15/2003 02:15:07 PM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nature of Oracle-l has changed
this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.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: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Congratulations Arup (DBA of the Year)
And did you really think we DON'T monitor tars raised??? :) 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- Hallas, John, Tech Dev Sent: Friday, August 29, 2003 2:00 AM To: Multiple recipients of list ORACLE-L Not being a party pooper but what does DBA of the Year actually mean. What criteria was used. How can Oracle know about a quarter of a million DBA's unless it monitors tars raised. John -Original Message- [mailto:[EMAIL PROTECTED] Sent: 28 August 2003 15:54 To: Multiple recipients of list ORACLE-L Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our List member) as DBA of the Year. Congratulations Arup. thought I will share this news with the group. CTOUG Board Member, Arup Nanda, Chosen as DBA of the Year Oracle has chosen our very own CTOUG board member, Arup Nanda, as the DBA of the Year, out of some quarter million DBAs worldwide. There will be a felicitation ceremony at OracleWorld and the award recipients will be featured in Nov-Dec issue of Oracle Magazine. Thought you would like to know, as a part of the CTOUG community. In his interview, he has mentioned CTOUG, so watch for it. Arup is President of Proligence (http://www.proligence.com/). Thanks. Best Regards, Prasad -- 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: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 keep root out?
Much as I would like to claim credit, that's the wrong Pete you have there. :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long term Oracle DBA. -Original Message- Jared Still Sent: Friday, August 29, 2003 11:14 AM To: Multiple recipients of list ORACLE-L The security model of Oracle on both unix and Windows precludes any ability to prevent access to the database by a knowledgeable user with root or admin access. Pete Sharman could no doubt go into some detail here. I bought his security book, I'll check it out when I get to work. Could be there's something I've overlooked. :) Jared On Thu, 2003-08-28 at 09:29, DENNIS WILLIAMS wrote: Walter You may be able to approach this from a security aspect. You could discuss with your management whether it is a good idea for the system administrators to be in a database. Depending on the security or SLA requirements of the database, you may have some leverage there. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 28, 2003 11:10 AM To: Multiple recipients of list ORACLE-L Well, first of all, root should not be in your dba group... -Original Message- Sent: Thursday, August 28, 2003 8:34 AM To: Multiple recipients of list ORACLE-L Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W -- 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: 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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Masters exam
And having sat through the beta of the masters exam, let me reiterate what Reichert said in the article. You really do have to have the hands on experience to pass it. I've been using Oracle for something like 15 years now, and training others in the DBA world for 11 or so of those 12 years, and this was the hardest exam I've ever sat through. 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- Boivin, Patrice J Sent: Thursday, September 04, 2003 6:45 AM To: Multiple recipients of list ORACLE-L Oracle Mag has something about the Oracle Masters program... http://otn.oracle.com/oramag/oracle/03-sep/o53news.html Patrice. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Masters exam
Well, I've had the luxury of not only not paying for any of the certification, but actually being paid to DO the certification: 7.3 - original certification as an Oracle instructor paid for by Oracle 8.0 - paid for by the now defunct Coriolis Group so I could review their exam crams for them 8.1 - paid for by Coriolis so I could write an exam cram for them 9i - paid for by Coriolis so I could write an exam cram for them, but the company went south before the book was completed. Wonder who's going to pay me for 10g certification? :) Seriously, the Masters is (to me anyway) well worth it. It's something that really does test you know how to manage a database. You need deep hands on experience before you can even look at it. I was in the first beta test of the exam (an internal test), where we had 19 of the best Oracle people I have ever met doing the exam (ones that I would rank up with some of the Oak Table guys without any qualms), and we all found the two days very tough. 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- Mladen Gogala Sent: Friday, September 05, 2003 1:20 AM To: Multiple recipients of list ORACLE-L So, it's nothing like OCP where you get the certification when you spew out certain amount of the green stuff? I wonder how long will it take before seeing oracle masters who don't know how to take a hot backup. -- Mladen Gogala Oracle DBA -Original Message- Sharman Sent: Wednesday, September 03, 2003 6:39 PM To: Multiple recipients of list ORACLE-L And having sat through the beta of the masters exam, let me reiterate what Reichert said in the article. You really do have to have the hands on experience to pass it. I've been using Oracle for something like 15 years now, and training others in the DBA world for 11 or so of those 12 years, and this was the hardest exam I've ever sat through. 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- Boivin, Patrice J Sent: Thursday, September 04, 2003 6:45 AM To: Multiple recipients of list ORACLE-L Oracle Mag has something about the Oracle Masters program... http://otn.oracle.com/oramag/oracle/03-sep/o53news.html Patrice. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
RE: RE: Oracle Masters exam
Still out there on Amazon, even though I don't get any royalties from it any more (since the publisher went under). It's also available for online purchase chapter by chapter (I think) on http://www.robonerd.com 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- [EMAIL PROTECTED] Sent: Friday, September 05, 2003 5:05 AM To: Multiple recipients of list ORACLE-L well tom kyte isnt certified and refuses to discuss it on his website. OCP is important for most people. Employers want it. Im not sure masters certification means much unless you are a principal consultant or owner of a consultant. You then use that certification to sell your company. Its the same reason why most of the authors seem to be consultants. Helps sell themselves and the companies they work for. Its probably not worth the cost for most people to take it. Its not going to increase our rates. Though it could help sell consulting companies. btw, pete.. I found your 8i exam cram book much better than the osborne books. Well written and concise. Your 8i book is still on the market even though coriolis went under? From: Pete Sharman [EMAIL PROTECTED] Date: 2003/09/04 Thu PM 02:49:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle Masters exam Well, I've had the luxury of not only not paying for any of the certification, but actually being paid to DO the certification: 7.3 - original certification as an Oracle instructor paid for by Oracle 8.0 - paid for by the now defunct Coriolis Group so I could review their exam crams for them 8.1 - paid for by Coriolis so I could write an exam cram for them 9i - paid for by Coriolis so I could write an exam cram for them, but the company went south before the book was completed. Wonder who's going to pay me for 10g certification? :) Seriously, the Masters is (to me anyway) well worth it. It's something that really does test you know how to manage a database. You need deep hands on experience before you can even look at it. I was in the first beta test of the exam (an internal test), where we had 19 of the best Oracle people I have ever met doing the exam (ones that I would rank up with some of the Oak Table guys without any qualms), and we all found the two days very tough. 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- Mladen Gogala Sent: Friday, September 05, 2003 1:20 AM To: Multiple recipients of list ORACLE-L So, it's nothing like OCP where you get the certification when you spew out certain amount of the green stuff? I wonder how long will it take before seeing oracle masters who don't know how to take a hot backup. -- Mladen Gogala Oracle DBA -Original Message- Sharman Sent: Wednesday, September 03, 2003 6:39 PM To: Multiple recipients of list ORACLE-L And having sat through the beta of the masters exam, let me reiterate what Reichert said in the article. You really do have to have the hands on experience to pass it. I've been using Oracle for something like 15 years now, and training others in the DBA world for 11 or so of those 12 years, and this was the hardest exam I've ever sat through. 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- Boivin, Patrice J Sent: Thursday, September 04, 2003 6:45 AM To: Multiple recipients of list ORACLE-L Oracle Mag has something about the Oracle Masters program... http://otn.oracle.com/oramag/oracle/03-sep/o53news.html Patrice. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE
RE: Oracle Masters exam
Just to clarify, the old Oracle Masters was only an indication that you had attended a series of relevant training courses. There was no test, no measure of how well you could perform the role of a DBA. The new Oracle Masters definitely addresses that issue. 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- Ron Rogers Sent: Friday, September 05, 2003 10:39 PM To: Multiple recipients of list ORACLE-L I have a certificate suitable for framing that states that I am a Database Administrator Oracle 7 Oracle Master. Does this new Oracle Master negate my current Oracle Master certification? Is there and upgrade path available? Does it really matter? Every thing that I have accomplished I have done for myself. I use the tests as a yard stick against what I feel I want to accomplish. Does it matter that I have one, or two, or three, or four suitable for framing papers on the wall? With only a few years to go before I retire for the second time, I think that I will concentrate my efforts on my grand kids rather that getting paper for my walls. Ron mª¿ªm [EMAIL PROTECTED] 09/05/03 08:20AM - Original Message - It's too bad. It seems like it would be fun. What for? Make the employer shell out another BIG bunch of notes? To get a piece of paper that says on that date and with that hardware one could perform a backup and a restore? What does that say about the ability to lead a group of developers, or design the strategy for database access or solve a really nasty performance problem without forcing re-development or re-tooling? Or any of a million other tasks truly knowledgeable people get asked to perform? No wonder TK doesn't want to talk about it: it's laughable, and he prides himself in being a serious expert. The single fact the masters was created is the perfect admission at long last the OCP was nothing but a sham. Everyone knows it, some just insist on continuing the good old PC stuff (go with the flow, let it ride, etc). It is the simple truth: its value as a certification was and always will be nill. That the masters is being sold as the new be-all-end-all is even more demeaning. Chris -Original Message- Sent: Thursday, September 04, 2003 10:20 AM To: Multiple recipients of list ORACLE-L So, it's nothing like OCP where you get the certification when you spew out certain amount of the green stuff? I wonder how long will it take before seeing oracle masters who don't know how to take a hot backup. They'll be able to take a hot backup, rest assured. With milk and two sugars, please. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Masters exam
Funny, I found my cost (free) was acceptable ... :) 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- Thater, William Sent: Saturday, September 06, 2003 6:24 AM To: Multiple recipients of list ORACLE-L Pete Sharman scribbled on the wall in glitter crayon: Just to clarify, the old Oracle Masters was only an indication that you had attended a series of relevant training courses. There was no test, no measure of how well you could perform the role of a DBA. The new Oracle Masters definitely addresses that issue. all true, but still priced out of line for many of us that would like to take it and would find it useful. 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. Remember automatic weapons are a good thing. me ;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] The cosmological constant warps space-time the other way so that bodies move apart. - Stephen Hawking on Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Masters exam
Don't worry, nor do most Oracle employees. I was asked to be a beta tester of the masters exam, and in return for my review ( we actually spent three days doing the exam because of the amount of time discussing whether questions were valid, how they should be marked and so on), I got to sit the exam for free. I think (though I could be wrong) that normally (like in the OCP) Oracle employees will be charged a somewhat reduced rate for the masters exam. But anyway, doesn't IBM pay for you to do these sorts of things? :) 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- [EMAIL PROTECTED] Sent: Saturday, September 06, 2003 7:29 AM To: Multiple recipients of list ORACLE-L Free? Vat is dis Free? All of us don't work for Oracle (at least not directly) so we don't get that perk. But thanks for sharing. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] [EMAIL PROTECTED] peter.sharman@ oracle.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Oracle Masters exam ity.com 09/05/2003 03:44 PM Please respond to ORACLE-L Funny, I found my cost (free) was acceptable ... :) 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- Thater, William Sent: Saturday, September 06, 2003 6:24 AM To: Multiple recipients of list ORACLE-L Pete Sharman scribbled on the wall in glitter crayon: Just to clarify, the old Oracle Masters was only an indication that you had attended a series of relevant training courses. There was no test, no measure of how well you could perform the role of a DBA. The new Oracle Masters definitely addresses that issue. all true, but still priced out of line for many of us that would like to take it and would find it useful. 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. Remember automatic weapons are a good thing. me ;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] The cosmological constant warps space-time the other way so that bodies move apart. - Stephen Hawking on Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: Re: Oracle Masters exam
://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Is Cary's new book shipping now?
I can guarantee that won't happen, since Cary's singing is pretty much akin to Mogens's snoring! :) 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- Mladen Gogala Sent: Wednesday, September 17, 2003 4:20 AM To: Multiple recipients of list ORACLE-L Will there be an MP3 version, with Cary singing? -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Is Cary's new book shipping now? the big question is when will the .pdf be available for download on kazaa? (Im kidding and Im buying a copy). From: Jesse, Rich [EMAIL PROTECTED] Date: 2003/09/16 Tue PM 01:44:35 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Is Cary's new book shipping now? Preordered: Qty 1 :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Tuesday, September 16, 2003 11:05 AM To: Multiple recipients of list ORACLE-L Raj, The book will be in the O'Reilly warehouses tomorrow (9/17), presumably outbound to stores on the same or next day. I'd expect preorders to arrive at customers' homes on or near this weekend. Cary Millsap Hotsos Enterprises, Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name
RE: RAC Parallel Query Issues
Shouldn't happen, but one would have to question the use of PQ on such a small table anyway. You may be hitting some lower boundary condition that the developers didn't even look at because the table's so small? 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- Kulkarni Sent: Tuesday, September 16, 2003 10:54 AM To: Multiple recipients of list ORACLE-L We are on 2-Node Rac 9204/Solaris8. We are having intermittent issues with parallel queries (The table has only 470 records, executes 1sec otherwise): SQL / select count(*)from eod * ERROR at line 1: ORA-12805: parallel query server died unexpectedly Trace File has: kxfp_send_callback Send timed out to slave 65535 inst 1 (qref 0x63f85fd0) *** 2003-09-15 18:33:25.034 *** SESSION ID:(63.533) 2003-09-15 18:33:25.034 kxfp_send_callback Send timed out to slave 65535 inst 1 (qref 0x63fc2004) kxfplsig Could not signal error 10388 in server P032 with serial 371201 dp 0x61a822d0, q 0x60f286b0, pr 0x5f457168, cqr 0x63f97584, err 10387 Interrupt Info top=1 size=8 top err=-2147473260 Query May be hanging.Check V$PX_SESSION OPIRIP: Uncaught error 12800. Error stack: ORA-12800: system appears too busy for parallel query execution ORA-10387: parallel query server interrupt (normal) v$px_session : has number of Slave Processes hanging. Truss for process on Instance 1: door_return(0x, 0, 0x, 0) (sleeping...) lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0) (sleeping...) lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0) Err#62 ETIME read(0, 0xFE6C35E4, 1024) (sleeping...) signotifywait() (sleeping...) door_return(0x, 0, 0x, 0) (sleeping...) lwp_cond_wait(0xFE7F5548, 0xFE7F5558, 0xFE7EEDB0) (sleeping...) Instance 2: poll(0x02FF15CC, 2, 2500) (sleeping...) poll(0x02FF15CC, 2, 2500) = 0 poll(0x02FF15CC, 2, 0) = 0 poll(0x02FF15CC, 2, 2500) (sleeping...) poll(0x02FF15CC, 2, 2500) = 0 poll(0x02FF15CC, 2, 0) = 0 poll(0x02FF15CC, 2, 2500) (sleeping...) poll(0x02FF15CC, 2, 2500) = 0 Any inputs would be greatly appreciated. Thanks, Ravi. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ravi Kulkarni INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OOW '03 presentation link
Rich Spoke to Kirk (virtually anyway). I won't send you his initial response since there are ladies present (it was aimed at himself, BTW), but after a bit of looking into it, here's his second response: The link to SP1 is ftp://ftp.suse.com/pub/unitedlinux/1.0/src/ .. for SP2 / SP2a the customer must be member of the Suse support program to get the patch - at Oracle we get this for free. They may be able to get it by opening a TAR with Oracle Support - not sure. HTH. 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- Jesse, Rich Sent: Wednesday, September 17, 2003 6:10 AM To: Multiple recipients of list ORACLE-L In the presentation at https://www.oracleworld2003.com/published/40136/40136_McGowan.ppt there's a link to ftp://suse.us.oracle.com/yaddayaddayadda to patch United Linux to SP 2a. Of course, suse.us.oracle.com doesn't seem to exist. Anyone know where to get this? I've tried SuSE's FTP, but no luck and there ain't a whole lot of anything on United Linux's website. TIA, Rich Jesse Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 10G
Yes, I know for sure. :) 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- Jerome Roa Sent: Tuesday, September 30, 2003 5:05 AM To: Multiple recipients of list ORACLE-L Does anybody know FOR SURE whether 10G will be available on 32 and/or 64 bit? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jerome Roa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RAC and Standby Dr
If I understand you correctly and you want to use DataGuard for site failover and RAC for machine failover, that should work without any problems. It is indeed what I would recommend for a full HA configuration, since RAC only answers the machine failover part, not site failover. 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- [EMAIL PROTECTED] Sent: Sunday, October 12, 2003 4:39 AM To: Multiple recipients of list ORACLE-L Folks, A project team here is flirting with the idea of having standby databases for the two production RAC nodes. The two standy nodes will be at a DR site. Any gotchas with this configuration? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RAC and Standby Dr
A couple of comments on this. First, if you did go the route of using SRDF, the only supported mode for Oracle databases is synchronous. That can be a real performance hit depending on your configuration. Second, since you mentioned RAC I assume you're on 9i and in that release you can switch over and switch back for planned failovers. IIRC, you still need to recreate the primary if you have a unplanned failure of the primary which leads to a period of risk where you have no site failover capability while you rebuild the primary. Having 2 or more standby's can help to address that problem. 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- [EMAIL PROTECTED] Sent: Monday, October 13, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Thanks for the reply, Pete. We recommended EMC SRDF to keep the production and DR in sync, but the budget cannot provide for it. Now, with a standby DR, what I am scared of is, it would take me say 15 minutes tops, to activate the standby in case of a production site failure. But then, making the production back to real production, and DR back to standby, will take much more testing and time. Regards Raj Pete Sharman [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] racle.com cc: Sent by: Subject: RE: RAC and Standby Dr [EMAIL PROTECTED] y.com 10/12/2003 02:59 AM Please respond to ORACLE-L If I understand you correctly and you want to use DataGuard for site failover and RAC for machine failover, that should work without any problems. It is indeed what I would recommend for a full HA configuration, since RAC only answers the machine failover part, not site failover. 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- [EMAIL PROTECTED] Sent: Sunday, October 12, 2003 4:39 AM To: Multiple recipients of list ORACLE-L Folks, A project team here is flirting with the idea of having standby databases for the two production RAC nodes. The two standy nodes will be at a DR site. Any gotchas with this configuration? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Where can I download 10g ?
Sure, I've got an accurate rumour. Of course, I'd have to kill you if I told you. Do you really want to know that much? :) 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- Hately, Mike (LogicaCMG) Sent: Friday, October 17, 2003 3:04 AM To: Multiple recipients of list ORACLE-L Best plan at the moment is : 1) Wait patiently for between 3 and 10 months (anyone got an accurate rumour for a release date?). 2) Download from Technet. Regards, Mike Hately -Original Message- Sent: 16 October 2003 16:49 To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: anyone have opinions on the future of the 'grid'?
Ain't necessarily so. We already have some customers using grid technology with 9iR2 and 9iAS, along with the toolkit that's available on OTN (whose name escapes me at the moment). These are very high end business clients (not government or academia) that the Advanced Technology Solutions group in Oracle Consulting has worked with, but I won't name them because I'm not sure if they're referenceable. I think one thing that a lot of people are missing around the 10g message is that an important part of any grid technology is self management capabilities (autonomics in grid terms). 10g makes huge strides in the manageability area, and that's useful to ANY Oracle customer, not just those who are looking at the grid side. 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- [EMAIL PROTECTED] Sent: Friday, October 17, 2003 1:04 AM To: Multiple recipients of list ORACLE-L I was at the Wash DC Oracle conference yesterday and the key note address was about the future direction of Oracle. It was pretty positive about Grid technology and blade servers. Anyone out there have any opinions? It seems like this technology is probably several years away from being used in the business and government contracting world. Most places you see it are in academia. -- 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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: anyone have opinions on the future of the 'grid'?
Low end servers, usually running Linux, 1 or 2 CPU's, 2 Gb of memory, that can easily be racked (or even RAC'ed). 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- Murali_Pavuloori/[EMAIL PROTECTED] Sent: Friday, October 17, 2003 2:20 AM To: Multiple recipients of list ORACLE-L What are blade servers? Could the listers please shed some light on it thanks, Murali. |-+ | | [EMAIL PROTECTED]| | | | | | Sent by: | | | [EMAIL PROTECTED]| | | .com | | || | || | | 10/16/2003 11:04 | | | AM | | | Please respond to| | | ORACLE-L | | || |-+ --- ---| | | | To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | | cc: | | Subject: anyone have opinions on the future of the 'grid'? | --- ---| I was at the Wash DC Oracle conference yesterday and the key note address was about the future direction of Oracle. It was pretty positive about Grid technology and blade servers. Anyone out there have any opinions? It seems like this technology is probably several years away from being used in the business and government contracting world. Most places you see it are in academia. -- 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: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE:
Title: Message Well, in a small step in our defense, it DOES state at the top of the note: * This article is being delivered in Draft form and may contain errors. Please use the MetaLink "Feedback" button to advise Oracle of any issues related to this article. * and in an even larger step, the author of the document has been asked to review and correct 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 [EMAIL PROTECTED]Sent: Saturday, October 18, 2003 5:35 AMTo: Multiple recipients of list ORACLE-LSubject: Re: re Rebuilding Indexes in Oracle Apps -- was RE: RE:The article states that leaf blocks are not reused, which is indeed incorrect, and has been for a very long time. Hemant K Chitale [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/17/2003 11:42 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: re Rebuilding Indexes in Oracle Apps -- was RE: RE:I wonder if "it is not necessary to rebuild indexes" is also a myth.It IS in some cases necessary1. Indexes on monotonically increasing values [eg Conrurrent_Request_ID based on a Sequenceor even on date columns which signify when the record is created] if the table is alsopurged by the same columns frequently2. Because the disk space used by an Index can be inordinately larged after a couple of yearsand index fast_full_scans are impactedHave you administered an Oracle Applications database ?hemantAt 03:29 AM 17-10-03 -0800, you wrote:Hi Hemant,One word perfectly describes the Metalink article you highlighted:Crap ;)A nice example of how Oracle Corp is the greatest myth generator of themall !! It's all rather sad and embarressing isn't.Thanks for the headsup. Anyone in a position to get the note removed ?CheersRichard Quoting Metalink Note 182699.1 bde_rebuild.sql Validates and RebuildsFragmentated Indexes (8.0-9.0) Index fragmentation occurs when a key value changes, and the index row is deleted from one place (Leaf Block) and inserted into another. Deleted Leaf Rows are not reused. Therefore indexes whose columns are subject to value change must be rebuilt periodically since they becomenaturally fragmentated. An index is considered to be 'fragmentated' when more than 20% of its LeafRows space is empty because of the implicit deletes caused by indexed columns valuechanges. Fragmentated indexes degrade the performance of index range scanoperations.--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: Richard Foote INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Hemant K ChitaleOracle 9i Database Administrator Certified ProfessionalMy personal web site is : http://hkchital.tripod.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Hemant K ChitaleINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: anyone have opinions on the future of the 'grid'?
INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cache a table
Have a look at Steve Adam's web site. He probably knows more about it than just about anyone else I know (as usual!) 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- Mladen Gogala Sent: Wednesday, October 22, 2003 7:14 AM To: Multiple recipients of list ORACLE-L Did anyone try to benchmark the touch count based algorithm against the old LRU list? LRU list had advantage of being intuitive, while touch count algorithm is depending on many parameters for which I don't exactly understand the impact. LRU list parameters were essentially defining the desired length of the free buffers list, while the touch count parameters are all undocumented and are signifying the size of touch pool, the interval in which block has to be touched if the touch count is to increase, the required touch count to be moved to the hot pool and alike. Is it more efficient then the previous easy and understandable LRU lists or not? Touch counts are visible as TCH in X$BH. I still have no clue what TIM is. On 10/21/2003 04:39:33 PM, Wolfgang Breitling wrote: Before Oracle 8 and the new touch count algorithm the cache attribute made sense. If a small, frequently used table was read by a full scan, it would have been put at the end of the LRU chain eligible to be aged out immediately, quite possibly by itself if it consisted of more than ~ db_file_multiblock_read_count blocks, i.e. the 2nd or 3rd full scan read would already override the previously read blocks. Marking the table as CACHEd prevented that. At 01:09 PM 10/21/2003, you wrote: I always wondered why Oracle thought this was a useful table attribute. My gut feeling is that it is an extra that does little. For example, say we want to keep a code table in memory because it is constantly being hit for column verifiction. By definition, if a table is constantly being queried, it's segments will be in memory because they never age out. That sounds like cacheing to me. And then I remember a specific piece of Oracle documentation saying that, even though we may mark a table to be cached, it *still* may be aged out if memory is needed for other data blocks. Like I said, sounds a little like here you have it, and here you don't. I'm sure that my impression is wrong and someone will correct me. But I doubt I will use the CACHE option anytime soon. Tom Mercadante Oracle Certified Professional Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City
RE: Transportable tablespaces
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? The New Yahoo! Shopping - with improved product search 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: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: who writes the OCP tests?
Not I, never even seen the questions to tell you the truth. I believe there's an email address you can raise exam issues with - [EMAIL PROTECTED] You might want to send this to them to see if they have more relevant feedback than I'd ever have on this exam. 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- [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 3:49 AM To: Multiple recipients of list ORACLE-L all oracle employees? Are any of you involved in the 9i PL/SQL test? I just took it today and passed it. I didnt study at all. Id like to state that it is an incredibly stupid test. Ive been told the PErformance tuning one is bad also... Some gripes: 1. Only package that I was asked about was dbms_lob and of the 66 questions maybe 5-7 were on this package so about 10%. 2. 40-50% of the test was on triggers. A bit disproportionate dont you think? 3. I was asked about 6-8 questions on how to call procedures and functions and they slipped in a few defaults to 'trick' you. That is WAY too many. 4. Nothing on Arrays, PL/SQL tables, Bulk Binds, or dynamic sql. 5. In my overview it said I need to study the following(but they never asked me about them) UTL_TCP, UTL_HTTP, dbms_ddl. DBMS_DDL is antiquated and I cant think of anything I need it for. I wrap everything in execute immediate(which wasnt on the test). How many people actually use UTL_TCP and UTL_HTTP anyway? I dont. Far more people use other features that werent covered. im done griping. This was REALLY bad. -- 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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cache a table
I think you have mentioned that once or twice. :) 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- Mladen Gogala Sent: Wednesday, October 22, 2003 8:40 AM To: Multiple recipients of list ORACLE-L Good idea. I located the meaning of TIM column (time to age buffer). BTW, did I tell you that I like your signature? On 10/21/2003 05:39:25 PM, Pete Sharman wrote: Have a look at Steve Adam's web site. He probably knows more about it than just about anyone else I know (as usual!) 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- Mladen Gogala Sent: Wednesday, October 22, 2003 7:14 AM To: Multiple recipients of list ORACLE-L Did anyone try to benchmark the touch count based algorithm against the old LRU list? LRU list had advantage of being intuitive, while touch count algorithm is depending on many parameters for which I don't exactly understand the impact. LRU list parameters were essentially defining the desired length of the free buffers list, while the touch count parameters are all undocumented and are signifying the size of touch pool, the interval in which block has to be touched if the touch count is to increase, the required touch count to be moved to the hot pool and alike. Is it more efficient then the previous easy and understandable LRU lists or not? Touch counts are visible as TCH in X$BH. I still have no clue what TIM is. On 10/21/2003 04:39:33 PM, Wolfgang Breitling wrote: Before Oracle 8 and the new touch count algorithm the cache attribute made sense. If a small, frequently used table was read by a full scan, it would have been put at the end of the LRU chain eligible to be aged out immediately, quite possibly by itself if it consisted of more than ~ db_file_multiblock_read_count blocks, i.e. the 2nd or 3rd full scan read would already override the previously read blocks. Marking the table as CACHEd prevented that. At 01:09 PM 10/21/2003, you wrote: I always wondered why Oracle thought this was a useful table attribute. My gut feeling is that it is an extra that does little. For example, say we want to keep a code table in memory because it is constantly being hit for column verifiction. By definition, if a table is constantly being queried, it's segments will be in memory because they never age out. That sounds like cacheing to me. And then I remember a specific piece of Oracle documentation saying that, even though we may mark a table to be cached, it *still* may be aged out if memory is needed for other data blocks. Like I said, sounds a little like here you have it, and here you don't. I'm sure that my impression is wrong and someone will correct me. But I doubt I will use the CACHE option anytime soon. Tom Mercadante Oracle Certified Professional Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858
RE: Transportable tablespaces
It's because there's more magic behind the scenes that does things like the little endian big endian conversion. It's not transparent as you would need it to be for a straight copy at the OS level to work. 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- Henry Poras Sent: Thursday, October 23, 2003 6:29 AM To: Multiple recipients of list ORACLE-L Pete, Thanks for the reference. I'm still a bit confused, however. If you can't just copy a datafile between OS's because of the differences in the file header formats, why can you copy datafiles between OS's when done as a transportable tablespace? Henry -Original Message- Pete Sharman Sent: Wednesday, October 22, 2003 3:49 PM To: Multiple recipients of list ORACLE-L Rachel is in fact correct. See page 4 of the Self Managing Database paper presented at OracleWorld (https://www.oracleworld2003.com/published/40090/40090.doc). Cloning from one OS to another simply doesn't work because the file header formats are different between the different OS's. You can't just copy a datafile from Linux to Solaris, for example, and expect to read 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- Henry Poras Sent: Thursday, October 23, 2003 2:10 AM To: Multiple recipients of list ORACLE-L I don't see how this would work. You still have to move the physical data file to the new machine. What makes a transportable tablespace trasportable is that you notify the data dictionary of the move. If this works, couldn't you just clone from one OS to another by copying dbf files? Thinking out loud here, a clone would include a few things not in transportable tablespaces: redo logs, control files, rbs tspace, system tspace. Control files can be rebuilt, redo logs aren't necessary with a clean shutdown (you can recreate the shell. Data doesn't matter). Would the physical structure of SYSTEM and RBS be that different??? Hmmm... Any thoughts? Henry -Original Message- Rachel Carmichael Sent: Wednesday, October 22, 2003 10:49 AM To: Multiple recipients of list ORACLE-L I have heard rumors that the 10g tweak on transportable is to allow you to move cross-platform. Rumors only, I have NO inside information! --- Goulet, Dick [EMAIL PROTECTED] wrote: Humm, That's interesting. Transportable tablespaces were introduced in 8i, 9i allowed us to have multiple block sizes at the tablespace level for flexibility. But I've not heard that one can transport a tablespace/datafile across platforms. What a wonderful way to trash all of those Windoze servers out there for Linux!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, October 21, 2003 9:39 PM To: Multiple recipients of list ORACLE-L Hi Listers Saw this on SearchOracle What new features are customers excited about in 10G? Abramson: What they've done is given you complete flexibility. They have introduced transportable table spaces, so all you have to do is export metadata and just copy files across during an upgrade. You don't have to do a full extraction. I've been in a situation were a company was on Sun and moving to HP, and they wanted to know how to do it. I told them that you just unload the database and reload the database. It sounds easy, but with two terabytes of data it's not unless you have transportable table spaces. Can anyone confirm that this is true, that is, the implication that I can copy a transportable tablespace from Sun to HP or vice versa without issue. I suppose then is it big endian - little endian constrained or not Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- This transmission is for the intended addressee only and is confidential information. If you
RE: Mauve databases use least RAM
And with an email address like mine, who do you think I work for? :) 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- Mladen Gogala Sent: Thursday, October 23, 2003 6:00 AM To: Multiple recipients of list ORACLE-L I just received Effective Oracle by Design and reading the foreword I noticed not only the familiar names of Connor McDonald, Anjo Kolk and Mogens Norgaard, but I also saw this list mentioned explicitly. Is Mr. Tom Kyte a member of this list? Does he read it? Does his staff read it? I was wandering why so few oracle employees (to my knowledge, Vladimir is the only one) takes part in this list. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE:
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Your new book
Maybe your memory is suffering. Wasn't it a 42? :) 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- Steve McClure Sent: Thursday, October 23, 2003 10:49 AM To: Multiple recipients of list ORACLE-L If you gave me a quiz on relational algebra today, I'd probably flunk it, like many people that daily work with relational databases. But that doesn't stop us from making use of the fruits of the theory. Similarly, I don't think we need to understand Part II in detail to successfully use Cary's methods to tune an Oracle database. Dennis Williams DBA I certainly hope this is a correct assessment. I will never forget a college course called Math 144 'Discrete Functions in Mathematics'. It was essentially Relational Algebra. I was confident that I had done well on the very first test of the semester. Then I got it back. I had scored a 32. That is out of 100. Apparently I didn't have quite the grasp on relational theory that I had hoped. I doubt the rest of the semester, nor the intervening years, have changed things much. So I certainly hope to be able put Cary's book to good use without relying too heavilly on my mathematical background. I don't dare say I am confident of it though, I still remember that 32. Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mauve databases use least RAM
Apologies not needed - I thought it was rather amusing actually! It's easy to confuse Robert and I. We've worked closely together on a number of books, and we're both equally cute! :) 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- Mladen Gogala Sent: Thursday, October 23, 2003 11:15 AM To: Multiple recipients of list ORACLE-L I apologize. I was somehow connecting you with TUSC and Robert Freeman. Not that it's a bad thing, but I should have noticed. On 2003.10.22 20:54, Pete Sharman wrote: And with an email address like mine, who do you think I work for? :) 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- Mladen Gogala Sent: Thursday, October 23, 2003 6:00 AM To: Multiple recipients of list ORACLE-L I just received Effective Oracle by Design and reading the foreword I noticed not only the familiar names of Connor McDonald, Anjo Kolk and Mogens Norgaard, but I also saw this list mentioned explicitly. Is Mr. Tom Kyte a member of this list? Does he read it? Does his staff read it? I was wandering why so few oracle employees (to my knowledge, Vladimir is the only one) takes part in this list. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: Oracle /db2
Joe Not sure if it's that specific, but there has been material put up on searchDatabase.com that does some of this. I can dig out the URL for you if you haven't already seen that. 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- Testa Sent: Saturday, October 25, 2003 12:49 AM To: Multiple recipients of list ORACLE-L Well i've been tasked to do some crosstraining of db2 DBAs to teach them oracle(dark side, ok more expensive side). Does anyone know of a white paper, document, book, etc that would do DBA tasks comparisons? looking for something like alter database datafile 'filename' resize 1000m; command in oracle is equivalent to that in db2/udb. Does something like that exist? thanks, joe -- 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: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Clone db 9.2 on AIX 5L
, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dual
It's because we designed it that way. In earlier releases (can't remember the specific version we brought this in with), you could put more than one row in DUAL and then select them all, but all the things that should have returned only one row then failed with a 1403 (?) error - single row query returning more than one row. I remember well way way back in time before I joined Oracle having the fun of trying to debug why all our clients apps failed the night after we let a manager do the database maintenance. The forms that the apps used all included the date and time on the screen, and of course the manager had somehow ended up with two rows in DUAL, hence the failure. Very simple to address, by just deleting the extra row (and of course, never letting that manager do database maintenance again!). In due course, Oracle realized that DUAL was a special table and built into the kernel the functionality you mention to ensure that only one row is ever returned and hence those types of problems should not occur any more. 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- [EMAIL PROTECTED] Sent: Friday, October 31, 2003 3:55 AM To: Multiple recipients of list ORACLE-L List, here is a rtfm question which I was scared to ask, but its bothering me too much so I just can't stay quite : why do multiple inserts into sys.dual complete sucessfully when connected as sysdba, but a subsequent select * from dual show only 1 row ? -- 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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: char(1) VS varchar2(1)
Well, there'll be other non-gods there as well. I had two papers accepted - guess I better start writing something for them now! :) 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- Thater, William Sent: Wednesday, November 05, 2003 12:49 AM To: Multiple recipients of list ORACLE-L Tim Gorman scribbled on the wall in glitter crayon: Yes! RMOUG Training Days is going to be an incredible event this year! A 2-day conference in Colorado during ski season with a lineup of speakers that rivals the major international conferences, including keynotes by Bill Inmon and Sue Cook! We're going to have a blast; I'm looking forward to meeting you! oh good lord, i'll be in the company of gods and the goddess! this here going to be right good.;-) now lets hope the schedule me so i can go to your presentations... or maybe i should be scheduled against one of you so nobody comes to mine.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] I bet the human brain is a kludge. - Marvin Minsky -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shareplex: datatype unsupported
You know, from a logistics perspective I'm interested in something here that maybe those that use SharePlex can cast some light on. The only Oracle supported mechanism for mining the redo logs is LogMiner, yes? Now, given that we can change the format of the redo logs from release to release (not sure how granular that goes, so it may even be third digit version changes i.e. something like 8.0.5 to 8.0.6), doesn't it worry you as a SharePlex user that the product may not keep up with changes in the redo log formats and therefore give you garbage? How do you ensure that doesn't happen? Inquiring minds want to know, and all that... 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- Onions Sent: Thursday, November 06, 2003 2:14 AM To: Multiple recipients of list ORACLE-L That goes for Shareplex too (sorry to state the obvious). I've been seriously bitten in recent weeks by problems with their stuff too. _ Tim Onions Head of Oracle Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message- Sent: 05 November 2003 14:59 To: Multiple recipients of list ORACLE-L This isn't a direct answer to your question, but make sure you test logical standby thoroughly--I had to abandon the idea of using it due to serious bugs in the apply process, and due to seriously poor performance of the apply process. --- elain he [EMAIL PROTECTED] wrote: Hi, We are evaluating using either Oracle logical standby or Quest Shareplex replication for reporting purposes. It appears that there are quite a few datatypes not supported by Logical standby. Anyone knows what datatypes are not supported by shareplex replication? Tried looking up at quest website but could not find any documentation. Quest claimed that shareplex can replicate database of different versions, for eg from 9i to 8i as long as the 9i new features are not being utilized. Anyone has any experience with that? Thanks. elain _ MSN Messenger with backgrounds, emoticons and more. http://www.msnmessenger-download.com/tracking/cdp_customize -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: elain he INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tim Onions INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED
RE: How do you genrate primary keys?
, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OCP 9i New Features for DBAs
Runs on 9.2 but there's nothing specific to 9.2 rather than 9.0, IIRC. 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- Dunscombe, Chris Sent: Thursday, November 13, 2003 3:24 AM To: Multiple recipients of list ORACLE-L Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Does anything run on RAC? paper
If you're a member of the UKOUG (probably unlikely, but worth a try!) it's on their web site I believe. I still haven't managed to get Jonathan to add my editorial but every example you give would wreck ANY clustered database, Oracle's or not to his presentation. Oh, well! :) 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- Rognes, Sten Sent: Friday, November 14, 2003 9:04 AM To: Multiple recipients of list ORACLE-L I've been looking for a copy of Jonathan Lewis' Does Anything Run on RAC? paper/presentation without luck. If anyone has a url to where it can be downloaded from or could send me a copy it is very much appreciated. Thanks in advance, Sten -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rognes, Sten INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Grid news
Nope, sorry. This is a fundamental misconception that many people share. :) SETI is a completely different kettle of fish to Oracle's grid story, using spare cycles on desktops to try and achieve something as part of the search for extra-terrestrial intelligence (IIRC that's what SETI stands for, anyway). It's basically a way of breaking up massively parallel problems. Likewise, most scientific applications of grid architecture are designed to solve big batch problems. Oracle's enterprise grid architecture bears almost no resemblance to this at all. It's all about virtualization and provisioning to improve resource utilization. The provisioning technologies are really the key to unlocking the benefits of the grid (dang that sounds like Marketing crap!) where you can provision CPU and data dynamically within and across nodes and databases. Have a look for the paper Brajesh Goyal did at OracleWorld for all the details. 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- Nelson Flores Sent: Friday, November 14, 2003 8:59 AM To: Multiple recipients of list ORACLE-L It's kind of like the SETI project... for those of you that don't know what this is, it's a project where NASA has images that need to be analyzed, but don't have the computing power to do it all in a reasonable time. So they created a system where they distribute the processing of the images over n workstations, each running a separate part of the process. The main problem with this (which I noticed at my university where every single unix workstation had the SETI app running), was the fact that it slowed the machine down (they didn't use the nice command to only use idle time). The question related to all these Grid apps is how they are going to distribute the priorities for the jobs being done. If a general manager needs something ASAP, then do all we lesser mortals have to suffer? Oh well ... food for thought. -Original Message- DENNIS WILLIAMS Sent: Thursday, November 13, 2003 8:50 AM To: Multiple recipients of list ORACLE-L Oracle has announced 10 will be 10g for grid. Many of us have been baffled by what grid is, will it be useful in the real world, etc. Here is a short article on a practical grid application (non Oracle) http://zdnet.com.com/2100-1104_2-5106230.html Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- 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: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Does anything run on RAC? paper
Mr Norgaard, you pedant! :) As you well know, what I meant was that the application coding techniques that Jonathan describes are ones that will limit any database's scalability. Now go and have a few more beers (unless your thief has taken them all! :) Or maybe I should have had some more before I sent yesterday's email? Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long term Oracle DBA. -Original Message- Mogens Nørgaard Sent: Friday, November 14, 2003 6:29 PM To: Multiple recipients of list ORACLE-L I didn't think there were other clustered databases?! Mogens Pete Sharman wrote: If you're a member of the UKOUG (probably unlikely, but worth a try!) it's on their web site I believe. I still haven't managed to get Jonathan to add my editorial but every example you give would wreck ANY clustered database, Oracle's or not to his presentation. Oh, well! :) 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- Rognes, Sten Sent: Friday, November 14, 2003 9:04 AM To: Multiple recipients of list ORACLE-L I've been looking for a copy of Jonathan Lewis' Does Anything Run on RAC? paper/presentation without luck. If anyone has a url to where it can be downloaded from or could send me a copy it is very much appreciated. Thanks in advance, Sten -- 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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: an article comparing Oracle to other databases
Well, there are plenty of objective detailed comparisons on www.oracle.com! :)) 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- Boivin, Patrice J Sent: Friday, November 28, 2003 3:04 AM To: Multiple recipients of list ORACLE-L http://www.ecommercetimes.com/perl/story/32200.html I have yet to see an objective, detailed comparison of Oracle, DB2 and SQL Server. From a technical (i.e. what can it do) as well as from an organisational (i.e. how is it to manage) point of view. Even 3rd party think tanks seem to walk on egg shells when evaluating software from major vendors, possibly to avoid alienating any of them. Patrice. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dc_used_extents ,dc_free_extents and dc_histogram_defs
136 3,840 100 dc_user_grants 4990.00 0 13 22 dc_usernames4570.00 0 21 95 dc_users 1,5150.00 0 17 89 ifs_acl_cache_entries 0 0 0 0 0 - Library Cache Activity for DB: RPT2 Instance: RPT2 Snaps: 681 -682 -Pct Misses should be very low Get PctPinPct Invali- Namespace RequestsMiss Requests Miss Reloads dations --- -- -- -- -- --- - BODY 220.0 220.0 0 0 CLUSTER 350.0 370.0 0 0 INDEX128 16.4149 14.1 0 0 OBJECT 0 0 0 0 PIPE 0 0 0 0 SQL AREA 19,3771.8 1,697,7420.0 12 53 TABLE/PROCEDURE1,455 12.3695,8750.1141 0 TRIGGER0 0 0 0 - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA -- 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dc_used_extents ,dc_free_extents and dc_histogram_defs
Well, I think part of the problem is a perception (how valid it is I don't think I'm in a position to say, but the perception certainly exists) that allowing access to the code too early simply provides ammunition for competitors to be far more prepared than we'd like them to be. :) And no apologies needed. Particularly from someone that's bigger than me! :) 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- Mladen Gogala Sent: Tuesday, December 09, 2003 11:29 AM To: Multiple recipients of list ORACLE-L On 2003.12.08 17:24, Pete Sharman wrote: Well, you could have joined the beta program if you were THAT interested, Mladen! I missed the opportunity because I was amid changing jobs. I tried to lay my hands on the software several times since then, to no avail. Ducks and runs. :) No need, Pete. I've always appreciated your advice and expertize. Your posts have been very useful to me on more then one occasion. I am the one to apologize for blowing off some steam, but I must confess, that I don't understand such secrecy, especially not after it has already been announced. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rebuilding indexes - sure to cause a ruckus
What sort of Oak Table member are you, Richard? Any Oak Table member worth their weight in toilet paper would certainly execute DBMS_POWERNAP part way through, but the strong cup of coffee definitely needs a large shot of whiskey substituted for 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- Richard Foote Sent: Tuesday, December 09, 2003 7:35 PM To: Multiple recipients of list ORACLE-L Hi Tanel, I recommend a strong cup of coffee and a small nap 1/2 way through ;) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 7:44 AM Ouch, I gotta take a day off to read this one ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dc_used_extents ,dc_free_extents and dc_histogram_defs
Well, as you'd suspect I don't have any control over these sorts of decisions! I didn't actually see the announcement on OTN, so I'm not sure who the email would have gone to. There was a way Oracle employees could invite customers to be part of the beta program, sp presumably your sales rep didn't think you were important enough to be on the program. ;) Seriously, before Jared tells us to take this conversation offline, let me make a couple of final points on this: 1. From Oracle's perspective, the beta program is an enormous amount of work, and requires a lot of ongoing management of the customers involved. For that reason, the beta program is not really designed to be open to everyone. 2. If you think you really have a valid interest in being on the beta program for future releases and are prepared to put in the work that's involved with the beta program (logging bugs, testing new functionality and so on), let me know and I can send you information on how to join future beta programs as they occur. Since the beta proposals are actually voted on, a compelling case will help with actually getting on the beta program. 3. If you are simply interested in playing with the new features, rather than seriously stress testing them, then I probably can't help you. Decisions on early adopter sorts of programs that are set up to handle people who want to play are beyond my level at Oracle. As for Mogens, I know he's on the beta program. I got him there, along with a few of the other Oakies. It was a suggestion I came up with because if we can get people like Mogens, Cary, Jonathan and Steve (who are the four I suggested to Development) to say what a wonderful product 10g is, then that's a really telling statement. I'm not sure that any of them have said it yet, though! :) 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- Mladen Gogala Sent: Wednesday, December 10, 2003 5:40 AM To: Multiple recipients of list ORACLE-L There was an announcement on the OTN, but nobody replied to email. When reading this list, I get impression that quite a few people were able to get the software so far and that the shroud of secrecy over the whole thing is maintained in order for them to gain advantage over the rest of customers. Anyway, Christmas is almost here. When do the rest us, not so important customers, get to see 10g? Speaking of Mogens, I believe that he has 10g. Whatever the intention was, it was a marketing blunder. As a customer, I'm less then happy with the impossibility of getting to know 10g despite the multitude of materials posted about it. I even tried to get 10g CDs from my oracle sales rep. but the guy conveniently forgets everything about it whenever he talks to me. Who knows, may be after reading this the marketing guys decide to put out a limited production version? Prolonging the hype would not serve any useful purpose, except may be, to further annoy your customers. On 12/09/2003 12:14:25 PM, Pete Sharman wrote: Generally, the announcements are made at events like OracleWorld, through OTN and so forth that the beta program is open. Depending on the release, the program may not even get announced unless it's big enough. IIRC, the beta program for 9.2 was open to only a small number of customers and wasn't announced to the world at large, whereas the 10g program was announced (again IIRC - it's 4 am for me and I haven't had my first coffee yet!) at OracleWorld in San Fran in September? Of course, there are some companies that are almost always invited to join the beta program for the database because of the type of customer they are and the type of work they do - customers like Amazon, for example, may fall into that category. Customers like Mogens definitely don't. :-) 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- Denny Koovakattu Sent: Tuesday, December 09, 2003 2:14 PM To: Multiple recipients of list ORACLE-L And how do you join one ? Denny Pete Sharman wrote: Well, you could have joined the beta program if you were THAT interested, Mladen! Ducks and runs. :) 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- Mladen Gogala Sent: Tuesday, December 09, 2003 6:59 AM To: Multiple recipients of list ORACLE-L Larry Ellison has publicly stated that his goal is to produce a database with less then 100 tunable parameters. Allegedly, he came rather close with 10g. As far as 10g is concerned, I'm rather disappointed with the marketing hype being created with oracle
RE: dc_used_extents ,dc_free_extents and dc_histogram_defs
From what I understand, hes even bigger than you! J 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 Carel-Jan Engel Sent: Wednesday, December 10, 2003 9:00 AM To: Multiple recipients of list ORACLE-L Subject: RE: dc_used_extents ,dc_free_extents and dc_histogram_defs Pete, Is Mladen bigger than you??? Carel-Jan At 16:44 8-12-03 -0800, you wrote: Well, I think part of the problem is a perception (how valid it is I don't think I'm in a position to say, but the perception certainly exists) that allowing access to the code too early simply provides ammunition for competitors to be far more prepared than we'd like them to be. :) And no apologies needed. Particularly from someone that's bigger than me! :) 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- Mladen Gogala Sent: Tuesday, December 09, 2003 11:29 AM To: Multiple recipients of list ORACLE-L On 2003.12.08 17:24, Pete Sharman wrote: Well, you could have joined the beta program if you were THAT interested, Mladen! I missed the opportunity because I was amid changing jobs. I tried to lay my hands on the software several times since then, to no avail. Ducks and runs. :) No need, Pete. I've always appreciated your advice and expertize. Your posts have been very useful to me on more then one occasion. I am the one to apologize for blowing off some steam, but I must confess, that I don't understand such secrecy, especially not after it has already been announced. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). DBA!ert, Independent Oracle Consultancy Kastanjelaan 61C 2743 BX Waddinxveen The Netherlands tel. +31 (0) 182 640 428 fax +31 (0) 182 640 429 mobile+31 (0) 653 911 950 e-mail [EMAIL PROTECTED]
RE: dc_used_extents ,dc_free_extents and dc_histogram_defs
Hmm, so you're telling me you want me to let Larry know your views on this? Not this bunny! :) The problem in putting out a limited production release is not so much in putting it out - that's dead easy. It's in the expectation that some form of support comes with it usually, and limited production code is usually limited because it's still beta - hence bugs and so on that need support resources to address. Of course, we don't have bugs in our Production code! :) However, I will raise your comments with the Product Management team so they're aware of them. Can't promise that will mean anything in the way of results of course! As for when you'll see the software, what Larry said at OracleWorld is still the only official date I've heard. 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- Mladen Gogala Sent: Wednesday, December 10, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Pete, I'd like to clarify my position first: I don't have any burning problem that would compel me to start testing 10g. I want only to learn the new features. Second, I don't see why would putting a limited production version out for people to learn the new features be so much work. Third, inviting distinguished 10g users and allowing them early access would be fair and acceptable to me if it didn't last too long, thus making the advantage too large. Having this early start for this long is an annoying blunder, pure and simple. Oracle either shouldn't have announced the product that early or should have provided some software. Articles, white papers and veiled testimonies by the privileged ones are not enough. I believe you when you say that you don't have much influence because you really are a nice guy. Nevertheless, someone should tell the big guys that putting out some limited production version would be a good thing to do. If not that, then please tell us when can we expect to see the software. On 2003.12.09 14:39, Pete Sharman wrote: Well, as you'd suspect I don't have any control over these sorts of decisions! I didn't actually see the announcement on OTN, so I'm not sure who the email would have gone to. There was a way Oracle employees could invite customers to be part of the beta program, sp presumably your sales rep didn't think you were important enough to be on the program. ;) Seriously, before Jared tells us to take this conversation offline, let me make a couple of final points on this: 1. From Oracle's perspective, the beta program is an enormous amount of work, and requires a lot of ongoing management of the customers involved. For that reason, the beta program is not really designed to be open to everyone. 2. If you think you really have a valid interest in being on the beta program for future releases and are prepared to put in the work that's involved with the beta program (logging bugs, testing new functionality and so on), let me know and I can send you information on how to join future beta programs as they occur. Since the beta proposals are actually voted on, a compelling case will help with actually getting on the beta program. 3. If you are simply interested in playing with the new features, rather than seriously stress testing them, then I probably can't help you. Decisions on early adopter sorts of programs that are set up to handle people who want to play are beyond my level at Oracle. As for Mogens, I know he's on the beta program. I got him there, along with a few of the other Oakies. It was a suggestion I came up with because if we can get people like Mogens, Cary, Jonathan and Steve (who are the four I suggested to Development) to say what a wonderful product 10g is, then that's a really telling statement. I'm not sure that any of them have said it yet, though! :) 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- Mladen Gogala Sent: Wednesday, December 10, 2003 5:40 AM To: Multiple recipients of list ORACLE-L There was an announcement on the OTN, but nobody replied to email. When reading this list, I get impression that quite a few people were able to get the software so far and that the shroud of secrecy over the whole thing is maintained in order for them to gain advantage over the rest of customers. Anyway, Christmas is almost here. When do the rest us, not so important customers, get to see 10g? Speaking of Mogens, I believe that he has 10g. Whatever the intention was, it was a marketing blunder. As a customer, I'm less then happy with the impossibility of getting to know 10g despite the multitude of materials posted about it. I even tried to get 10g CDs from my oracle sales rep
RE: 24 x 7 x 365
Well, first thing that needs to be noted is that 24 x 7 x 365 indicates uptime for 7 years, which always gives me a chuckle when people say it. Mind you, Ive been guilty of saying it too! J And probably the second thing that needs to be said is that no single product addresses true HA requirements. RAC is no different to that. It provides machine failover capability, and while it can be stretched to a certain extent to give the illusion of site failover capability, you would still need someone like DataGuard to address issues such as human error correction. And probably the third thing that needs to be said is that its not just a technology thing. If you dont have robust change control, for example, a simple coding error can ensure you dont meet your availability requirements. Shameless plug And probably the fourth thing that needs to be said is that its all covered in one of my papers at RMOUG Training Days next February, Real Business Continuity with Oracle10g /Shameless plug. J 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 Tracy Rahmlow Sent: Thursday, December 11, 2003 3:44 AM To: Multiple recipients of list ORACLE-L Subject: 24 x 7 x 365 Hello, Our company would like to know whether or not Oracle supports true 24x7x365 availability for an oltp database. We currently are using the 8.1.7 enterprise edition. Does an architecture exist whereby we can upgrade the database and/or operating system and not cause an outage? Will RAC solve this issue? Are there any other areas of concerns that I should be thinking about? For example, analyzing with the validate clause and its impacts on the transaction system. Thanks American Express made the following annotations on 12/10/2003 09:41:15 AM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** ==
RE: char is going away?
You mean you still need a DBA in 9i?!!? :) 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- Jamadagni, Rajendra Sent: Thursday, December 11, 2003 3:35 AM To: Multiple recipients of list ORACLE-L Another myth ... maybe. I also heard that in 9i DBA will be no longer needed. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, December 10, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Hi all: Someone told me that Oracle is planning to retire char variable and therefore they need to be replaced by varchar2. Has anyone heard anything about it? thanks Gene ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dc_used_extents ,dc_free_extents and dc_histogram_defs
I think he's skipping that one to go direct to Do you really need Oracle? :) 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- Denny Koovakattu Sent: Thursday, December 11, 2003 4:04 AM To: Multiple recipients of list ORACLE-L They will think differently after Mogens comes out with the Do you really need 10g presentation ;) -- Denny Koovakattu Quoting Nuno Souto [EMAIL PROTECTED]: The interesting fact of course is that the beta program of 10g was announced in newsgroups AFTER it had closed for all intents and purposes to the general public... And quite frankly, Oracle could do a LOT WORSE than let customers like Mogens definitely join. Just a feeling, mind you. If Oracle thinks the good old days of in-house elites are back, they're dead wrong. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Generally, the announcements are made at events like OracleWorld, through OTN and so forth that the beta program is open. Depending on the release, the program may not even get announced unless it's big enough. IIRC, the beta program for 9.2 was open to only a small number of customers and wasn't announced to the world at large, whereas the 10g program was announced (again IIRC - it's 4 am for me and I haven't had my first coffee yet!) at OracleWorld in San Fran in September? Of course, there are some companies that are almost always invited to join the beta program for the database because of the type of customer they are and the type of work they do - customers like Amazon, for example, may fall into that category. Customers like Mogens definitely don't. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This message was sent using IMP, the Internet Messaging Program. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 10g new features (was: dc_used_extents ,dc_free_extents and d
Robert, Robert, Robert, when will you ever learn? You've been listening to the marketing people again. :) The whole goal behind this part of the release is not to make the database look easy to manage (which is good because I've never thought it WAS difficult to manage!) It's for those lower end customers who may not have the requirement for a full-time DBA. The idea is to set as few parameters as needed by having sensible defaults (whether they ARE sensible or not is a separate argument), while still having the full power and flexibility of all the other parameters for those lucky DBA's who have more complex systems to manage. Make more sense? I can see I'm gonna have to keep a VERY close eye on you if we ever get around to writing our 10g book! :) 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- Freeman Robert - IL Sent: Thursday, December 11, 2003 10:40 AM To: Multiple recipients of list ORACLE-L d Doesn't matter if there's 30 or 300, you don't usually mess with them other than at database create time. Shh Oracle thinks this is a marketing coup They want to make the database look easy to manage... Parameters? Ha, you only need configure a few basic parameters and the database will take care of itself. WHEN PIGS FLY This just speaks to the general management desire to push costs down stream Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/10/2003 5:24 PM dc_histogram_defs) Much seems to be made of this 'less than 30 init parameter to tune'. Who really spends much time doing that anyway? If you do, you're probably going after the wrong end of a problem. Doesn't matter if there's 30 or 300, you don't usually mess with them other than at database create time. Jared Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/10/2003 01:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: 10g new features (was: dc_used_extents ,dc_free_extents and dc_histogram_defs) Pete, I'd like to clarify my position first: I don't have any burning problem that would compel me to start testing 10g. I want only to learn the new features. Btw, if you want to learn some of the 10g database engine new features (not the marketing buzzwords), then check out one of my presentations from: http://integrid.info/Poder_10g_New_Features.ppt Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Who are certified Oracle Masters?
IIRC, Tanel did the OCM as well, but I suspect most of the others on your list aren't prepared to waste their time attending OCP exams and courses just so they can get the OCM. :) There were some honorary OCM's announced when the program first started (OOW2002?). From memory, Rich Niemic and Jeremiah Wilton are the only names that spring to mind from that group. 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- Mladen Gogala Sent: Friday, December 12, 2003 7:54 AM To: Multiple recipients of list ORACLE-L I know only of Pete Sharman. Who are other Oracle Certified Masters on this group? I suspect Tanel to be one, as well as Steve Adams, Cary Millsap, Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti Deshpande. Am I correct? Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Who are certified Oracle Masters?
Oh, and I forgot. No, the honorary OCM's didn't have to take the test. They were given the OCM in recognition of their contributions to the Oracle world as a whole. Actually, some of them I'd never heard of before either, so that probably explains why I can't recall who they are now. 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- Ryan Sent: Friday, December 12, 2003 8:59 AM To: Multiple recipients of list ORACLE-L you mean niemic didnt actually have to take the test? It was just handed to him? who is jeremiah wilton? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 4:09 PM IIRC, Tanel did the OCM as well, but I suspect most of the others on your list aren't prepared to waste their time attending OCP exams and courses just so they can get the OCM. :) There were some honorary OCM's announced when the program first started (OOW2002?). From memory, Rich Niemic and Jeremiah Wilton are the only names that spring to mind from that group. 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- Mladen Gogala Sent: Friday, December 12, 2003 7:54 AM To: Multiple recipients of list ORACLE-L I know only of Pete Sharman. Who are other Oracle Certified Masters on this group? I suspect Tanel to be one, as well as Steve Adams, Cary Millsap, Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti Deshpande. Am I correct? Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Who are certified Oracle Masters?
Well, I could say Haven't you heard the song? Jeremiah was a bullfrog, was a good friend of mine ..., but that would really date me. :) Last I heard, Jeremiah was at Amazon. He occasionally posts answers on oracle-l, so no doubt he'll correct me if: a) I have his name wrong b) I has his employer wrong c) He actually IS a bullfrog. :) 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- Ryan Sent: Friday, December 12, 2003 8:59 AM To: Multiple recipients of list ORACLE-L you mean niemic didnt actually have to take the test? It was just handed to him? who is jeremiah wilton? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 4:09 PM IIRC, Tanel did the OCM as well, but I suspect most of the others on your list aren't prepared to waste their time attending OCP exams and courses just so they can get the OCM. :) There were some honorary OCM's announced when the program first started (OOW2002?). From memory, Rich Niemic and Jeremiah Wilton are the only names that spring to mind from that group. 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- Mladen Gogala Sent: Friday, December 12, 2003 7:54 AM To: Multiple recipients of list ORACLE-L I know only of Pete Sharman. Who are other Oracle Certified Masters on this group? I suspect Tanel to be one, as well as Steve Adams, Cary Millsap, Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti Deshpande. Am I correct? Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
