Re: OR Vs UNION
In that simple example the OR is almost certainly faster... 1) UNION forces a sort operation to be performed (UNION ALL is better in this respect). 2) If the query is forced to perform a full table scan then the union option will perform two scans. There will be similar issues if a full index scan is performed. Of course a lot of data will be cached for the second pass but it must still be done. Therefore, in your simple example (not knowing table volumes, indexing strategies, etc) I would suggest the OR option. Having said that, there are examples in complex queries where a union may perform better (and it may be easier to write as well). Regards, Mark. Saminathan_Seeran [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: OR Vs UNION .com 24/06/2003 15:34 Please respond to ORACLE-L Hi All, Could someone explain to me which one is best in the following two queries w.r.t performance? Thanks Sami Query1) select distinct empployee_id from employees where department_id=10 or department_id=20 / Query2) === select employee_id from employees where department_id=10 union select employee_id from employees where department_id=20 / -- 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). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Hi! There's actually no need to migrate any contents of redo logs, since you must have shut down your database cleanly anyway, the logs can be safely reset - no need for keeping them... Tanel. A Basic Qs Do the 2 Sets of Redo Log groups belonging to the different instances undergo Migration from 8i to 9i ? If so , how are the Online Redo Log groups individually Migrated from 8i to 9i ? Could NOT find any reference to individual Redo Log groups getting migrated in the Docs. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 7.3.4 on Win2000
Title: Message My understanding is that it will install and work but Oracle 7 wants to be the first Oracle Home installed on the machine if my memory does not let me down. I once installed 7.3.4 on my laptop after I had installed 8 8i. This required some registry hacking to get it to work properly. Jack -Original Message-From: Smith, Ron L. [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 10:00 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle 7.3.4 on Win2000 I need to load SQL Loader 7.3.4 on a Win2000 server. All I have is ORacle 7.3.4 for NT. Does anyone know if it will load and run ok without messing up something? Is there a CD for 7.3.4 on Win2000? Thanks! Ron If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
Re: Thanks!! What are the type#'s in obj$ ?
Hi! The example given below is tootaly wrong in this concern. Type 10 is used for nagetivec dependancy tracking of objects. This is use in reference of public on object of one schema and used by other schema and oracle internally assume that second schema have the referenced object and have type#10 ( in reality it is not exist). Not correct. Negative dep. tracking is only one of the cases why we see type 10 objects. And if you check my example more closely, I didn't use public synonyms. Not-existing (type 10) objects are needed only in case of public synonyms, to be sure that dependent objects are invalidated if an object with same name is created in current schema. But the second case is just for keeping obj$ table and indexes sane in environments where objects are very frequently dropped and recreated. When dropping sequences, synonyms, procedures-functions, etc.. you actually see that the objects remain in obj$ table with type# 10. No public synonyms or dependencies involved at all! When you create a new same type object with different name, a new entry is added to obj$, but when you recreate the same type object with old, original name, the type 10 entry in obj$ is actually reused (updated back to correct type). There is no index on type# column, thus it's cheaper just to update the type# column instead of delete from table and maintain corresponding index entries (possibly following an insert shortly). The type 10 entries (actually only those which don't have anyone depending on them) are deleted by SMON during next startup (maybe after some time interval too, haven't checked that far). So, there are more cases when type 10 entries might exist in obj$ and my example is correct. Btw, you should proofread your posts, it isn't easy to read what words like 'nagetivec' might mean ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 9:09 AM Wow. Terrific information. Thanks Tanel, Jacques, Richard, and Jared!!! The database and I are having a bit of a disagreement about whether this object really exists. I guess the database wins. Thanks again. Barb --- Tanel Poder [EMAIL PROTECTED] wrote: Hi! Check http://www.jlcomp.demon.co.uk/faq/non_exist.html for explanation. Also, I'll include a little sample, how they might occur. Cheers, Tanel. SQL create table a (b number); Table created. SQL create synonym s for a; Synonym created. SQL select name, type# from obj$ where name = 'A'; NAMETYPE# -- -- A 2 A 2 SQL select name, type# from obj$ where name = 'S'; NAMETYPE# -- -- S 5 SQL drop synonym s; Synonym dropped. SQL select name, type# from obj$ where name = 'S'; NAMETYPE# -- -- S 10 SQL startup force ORACLE instance started. Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes Database mounted. Database opened. SQL select name, type# from obj$ where name = 'S'; no rows selected SQL -- 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).
Oracle Clinical
Hi all, what is Oracle Clinical. I saw some job advertisement Oracle Clinical DAB or programmer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OR Vs UNION
SET TIMING ON SET AUTOTRACE TRACEONLY - --- Original Message --- - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Mon, 23 Jun 2003 21:34:52 Hi All, Could someone explain to me which one is best in the following two queries w.r.t performance? Thanks Sami Query1) select distinct empployee_id from employees where department_id=10 or department_id=20 / Query2) === select employee_id from employees where department_id=10 union select employee_id from employees where department_id=20 / -- 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). --- -- Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OR Vs UNION
Title: RE: OR Vs UNION I believe OR is internally transformed to UNION (or UNION ALL) ?? The answer you are looking is ... test and measure it in _your_ _environment_. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! - --- Original Message --- - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Mon, 23 Jun 2003 21:34:52 Hi All, Could someone explain to me which one is best in the following two queries w.r.t performance? Thanks Sami Query1) select distinct empployee_id from employees where department_id=10 or department_id=20 / Query2) === select employee_id from employees where department_id=10 union select employee_id from employees where department_id=20 / *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Oracle Clinical
Must have something to do with Brill Cream. You know, just put a DAB of it in your hair and you're an instant babe magnet. Dave -Original Message- [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 10:04 AM To: Multiple recipients of list ORACLE-L What's a DAB? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 10:20 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Clinical Hi all, what is Oracle Clinical. I saw some job advertisement Oracle Clinical DAB or programmer. -- 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: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Clinical
Ins't that a synonym for a duhveloper, you know a Dumb A__ B__ Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, June 24, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Must have something to do with Brill Cream. You know, just put a DAB of it in your hair and you're an instant babe magnet. Dave -Original Message- [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 10:04 AM To: Multiple recipients of list ORACLE-L What's a DAB? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 10:20 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Clinical Hi all, what is Oracle Clinical. I saw some job advertisement Oracle Clinical DAB or programmer. -- 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: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Oracle Collaboration Suite Licensing.
Ali, From previous discussion with Oracle on the subject. It includes the Collaborative suite software, and a limited license to use Oracle 9iAS and 9i database. Limited means that you can use it for Collaborative suite purposes only. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, June 24, 2003 2:40 AM To: Multiple recipients of list ORACLE-L Hi All, What is included in Collaboration suite 9.0.2 license? As collaboration suite license cost 60 $ per user, we are not sure that whether Oracle 9i Database and Application server will be included in collaboration suite 9.0.2 license or we need to purchase Oracle Database 9i and 9ias separately. can any body help me because this is very urgent. Regards, Mubarak Ali Software Programmer LMK Resources, A Landmark Graphics Affiliated Company E-mail: [EMAIL PROTECTED] Phone: +92 51 111 101 101 Ext. 712 Fax: +92 51 226 4167, +92 51 225 5989 http://www.lmkr.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mubarik Ali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Re: Thanks!! What are the type#'s in obj$ ?
Interesting. I didn't realize that oracle would keep dropped objects as an unused type rather than delete them. Thanks, Jared On Tuesday 24 June 2003 05:33, Tanel Poder wrote: Hi! The example given below is tootaly wrong in this concern. Type 10 is used for nagetivec dependancy tracking of objects. This is use in reference of public on object of one schema and used by other schema and oracle internally assume that second schema have the referenced object and have type#10 ( in reality it is not exist). Not correct. Negative dep. tracking is only one of the cases why we see type 10 objects. And if you check my example more closely, I didn't use public synonyms. Not-existing (type 10) objects are needed only in case of public synonyms, to be sure that dependent objects are invalidated if an object with same name is created in current schema. But the second case is just for keeping obj$ table and indexes sane in environments where objects are very frequently dropped and recreated. When dropping sequences, synonyms, procedures-functions, etc.. you actually see that the objects remain in obj$ table with type# 10. No public synonyms or dependencies involved at all! When you create a new same type object with different name, a new entry is added to obj$, but when you recreate the same type object with old, original name, the type 10 entry in obj$ is actually reused (updated back to correct type). There is no index on type# column, thus it's cheaper just to update the type# column instead of delete from table and maintain corresponding index entries (possibly following an insert shortly). The type 10 entries (actually only those which don't have anyone depending on them) are deleted by SMON during next startup (maybe after some time interval too, haven't checked that far). So, there are more cases when type 10 entries might exist in obj$ and my example is correct. Btw, you should proofread your posts, it isn't easy to read what words like 'nagetivec' might mean ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 9:09 AM Wow. Terrific information. Thanks Tanel, Jacques, Richard, and Jared!!! The database and I are having a bit of a disagreement about whether this object really exists. I guess the database wins. Thanks again. Barb --- Tanel Poder [EMAIL PROTECTED] wrote: Hi! Check http://www.jlcomp.demon.co.uk/faq/non_exist.html for explanation. Also, I'll include a little sample, how they might occur. Cheers, Tanel. SQL create table a (b number); Table created. SQL create synonym s for a; Synonym created. SQL select name, type# from obj$ where name = 'A'; NAMETYPE# -- -- A 2 A 2 SQL select name, type# from obj$ where name = 'S'; NAMETYPE# -- -- S 5 SQL drop synonym s; Synonym dropped. SQL select name, type# from obj$ where name = 'S'; NAMETYPE# -- -- S 10 SQL startup force ORACLE instance started. Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes Database mounted. Database opened. SQL select name, type# from obj$ where name = 'S'; no rows selected SQL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Clinical
Yes , maybe it is. just put it in hair and thats all -Original Message- Sent: Tuesday, June 24, 2003 5:20 PM To: Multiple recipients of list ORACLE-L Must have something to do with Brill Cream. You know, just put a DAB of it in your hair and you're an instant babe magnet. Dave -Original Message- [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 10:04 AM To: Multiple recipients of list ORACLE-L What's a DAB? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 10:20 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Clinical Hi all, what is Oracle Clinical. I saw some job advertisement Oracle Clinical DAB or programmer. -- 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: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Oracle Clinical
Daintily Access Backer -Original Message- [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 5:04 PM To: Multiple recipients of list ORACLE-L What's a DAB? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 10:20 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Clinical Hi all, what is Oracle Clinical. I saw some job advertisement Oracle Clinical DAB or programmer. -- 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: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Oracle Clinical
On Tue, 24 Jun 2003, Wolfe Stephen S GS-11 6 MDSS/SGSI wrote: What's a DAB? Among the Hmong, a dab is an evil spirit thet makes mad things happen. For instance, a dab might hang out at a particular intersection and make fender-benders happen. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -Original Message- From: [EMAIL PROTECTED] what is Oracle Clinical. I saw some job advertisement Oracle Clinical DAB or programmer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
LOCALLY MANAGED TABLESPACE
Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Clinical
Unfortunately, thats an acronym for DBA too ! -Original Message- Sent: Tuesday, June 24, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Ins't that a synonym for a duhveloper, you know a Dumb A__ B__ Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, June 24, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Must have something to do with Brill Cream. You know, just put a DAB of it in your hair and you're an instant babe magnet. Dave -Original Message- [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 10:04 AM To: Multiple recipients of list ORACLE-L What's a DAB? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 10:20 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Clinical Hi all, what is Oracle Clinical. I saw some job advertisement Oracle Clinical DAB or programmer. -- 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: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Chelur, Jayadas {PBSG} INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: LOCALLY MANAGED TABLESPACE
Seema Oracle version? Have you studied the paper How to Stop Defragmenting . . . so you understand how to configure your LMT? Overall, my results with LMT have been great. Oracle says eventually we will all be LMT. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 24, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Collaboration Suite Licensing.
Ali, This announcement may be of interest to you. http://www.infoworld.com/article/03/06/24/HNoraclecollaboration_1.html Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 24, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Ali, From previous discussion with Oracle on the subject. It includes the Collaborative suite software, and a limited license to use Oracle 9iAS and 9i database. Limited means that you can use it for Collaborative suite purposes only. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, June 24, 2003 2:40 AM To: Multiple recipients of list ORACLE-L Hi All, What is included in Collaboration suite 9.0.2 license? As collaboration suite license cost 60 $ per user, we are not sure that whether Oracle 9i Database and Application server will be included in collaboration suite 9.0.2 license or we need to purchase Oracle Database 9i and 9ias separately. can any body help me because this is very urgent. Regards, Mubarak Ali Software Programmer LMK Resources, A Landmark Graphics Affiliated Company E-mail: [EMAIL PROTECTED] Phone: +92 51 111 101 101 Ext. 712 Fax: +92 51 226 4167, +92 51 225 5989 http://www.lmkr.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mubarik Ali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
log for transaction
Hi there, I got a question on log. If my program crashes, can I check some log to see what recent transaction is? It will give me a big help on trouble shooting. Thanks, Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OR Vs UNION
Title: Message IMHO ... Cannot be.. the Access Path Taken is Different.. "OR" is Transfered to Inlist Iterator usually ... Best Regards,Ganesh RDID : +65-6215-8413HP : +65-9067-8474===Live to learn... forget... and learn again.=== -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, RajendraSent: Tuesday, June 24, 2003 11:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OR Vs UNION I believe OR is internally transformed to UNION (or UNION ALL) ?? The answer you are looking is ... test and measure it in _your_ _environment_. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! - --- Original Message --- - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Mon, 23 Jun 2003 21:34:52 Hi All, Could someone explain to me which one is best in the following two queries w.r.t performance? Thanks Sami Query1) select distinct empployee_id from employees where department_id=10 or department_id=20 / Query2) === select employee_id from employees where department_id=10 union select employee_id from employees where department_id=20 /
DBA Salary in California
Hi guys, just curiosity, any idea about the salary range for an Oracle DBA in California area? More specific in San Diego? Thanks, Gabriel __ 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: Gabriel Aragon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Clinical
Jeremiah Wilton scribbled on the wall in glitter crayon: On Tue, 24 Jun 2003, Wolfe Stephen S GS-11 6 MDSS/SGSI wrote: What's a DAB? Among the Hmong, a dab is an evil spirit thet makes mad things happen. For instance, a dab might hang out at a particular intersection and make fender-benders happen. damn! that describes a lot of people i work with.;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] A computer program does what you tell it to do, not what you want it to do. -- 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).
Re: RE: OR Vs UNION
the algorithm for 'or' is simply a series of key value searches right that is short circuited right? oracle searches to see if the first value exists, if it does, stop, else look for the second value. then turns that into a resultset correct? From: Ganesh Raja [EMAIL PROTECTED] Date: 2003/06/24 Tue PM 12:25:02 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OR Vs UNION IMHO ... Cannot be.. the Access Path Taken is Different.. OR is Transfered to Inlist Iterator usually ... Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- Jamadagni, Rajendra Sent: Tuesday, June 24, 2003 11:10 PM To: Multiple recipients of list ORACLE-L I believe OR is internally transformed to UNION (or UNION ALL) ?? The answer you are looking is ... test and measure it in _your_ _environment_. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! - --- Original Message --- - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Mon, 23 Jun 2003 21:34:52 Hi All, Could someone explain to me which one is best in the following two queries w.r.t performance? Thanks Sami Query1) select distinct empployee_id from employees where department_id=10 or department_id=20 / Query2) === select employee_id from employees where department_id=10 union select employee_id from employees where department_id=20 / Title: Message IMHO ... Cannot be.. the Access Path Taken is Different.. "OR" is Transfered to Inlist Iterator usually ... Best Regards,Ganesh RDID : +65-6215-8413HP : +65-9067-8474===Live to learn... forget... and learn again.=== -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, RajendraSent: Tuesday, June 24, 2003 11:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OR Vs UNION I believe OR is internally transformed to UNION (or UNION ALL) ?? The answer you are looking is ... test and measure it in _your_ _environment_. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! - --- Original Message --- - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Mon, 23 Jun 2003 21:34:52 Hi All, Could someone explain to me which one is best in the following two queries w.r.t performance? Thanks Sami Query1) select distinct empployee_id from employees where department_id=10 or department_id=20 / Query2) === select employee_id from employees where department_id=10 union select employee_id from employees where department_id=20 /
RE: Oracle Clinical
are you sure ? how can it be ? -Original Message- Sent: Tuesday, June 24, 2003 6:09 PM To: Multiple recipients of list ORACLE-L Unfortunately, thats an acronym for DBA too ! -Original Message- Sent: Tuesday, June 24, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Ins't that a synonym for a duhveloper, you know a Dumb A__ B__ Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, June 24, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Must have something to do with Brill Cream. You know, just put a DAB of it in your hair and you're an instant babe magnet. Dave -Original Message- [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 10:04 AM To: Multiple recipients of list ORACLE-L What's a DAB? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 10:20 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Clinical Hi all, what is Oracle Clinical. I saw some job advertisement Oracle Clinical DAB or programmer. -- 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: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Chelur, Jayadas {PBSG} INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: LOCALLY MANAGED TABLESPACE
I will say, welcome to the club. -Original Message- Sent: Tuesday, June 24, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LOCALLY MANAGED TABLESPACE
group view? if you mean, where can you find the information about the tablespace and datafiles, that is in the same set of views as dictionary-managed tablespaces: dba_tablespaces dba_data_files if that's not what you meant... please clarify what it is that you are looking for --- Seema Singh [EMAIL PROTECTED] wrote: Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: LOCALLY MANAGED TABLESPACE
and that including the PEOPLESOFT guys too... -Original Message- Sent: Tuesday, June 24, 2003 5:45 PM To: Multiple recipients of list ORACLE-L Seema Oracle version? Have you studied the paper How to Stop Defragmenting . . . so you understand how to configure your LMT? Overall, my results with LMT have been great. Oracle says eventually we will all be LMT. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 24, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). * This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible. This footnote also confirms that this message has been swept for computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Regis Biassala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBA Salary in California
in the DC area, salaries for jobs that do not require a security clearance have dropped a ton. I saw one DBA job that wanted 5 years experience advertised at $45k/year. I dont know if they filled it, but I have talked to quite a few people that turned them down. id be curious about salaries in california. Seems to me most advertised salaries are very low. Seems like most oracle jobs around here are short term contracts. It also seems like contracting companies are keeping alot more of the rate for themselves. This is evident sicne you often see 3-5 contracters advertising for the same exact job at different rates. The good thing about that is that contracts are no longer sole source bids, so you an negotiate your way up. but id bet if you did that... you would be blacklisted and they wouldnt call you again. From: Gabriel Aragon [EMAIL PROTECTED] Date: 2003/06/24 Tue PM 12:29:50 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: DBA Salary in California Hi guys, just curiosity, any idea about the salary range for an Oracle DBA in California area? More specific in San Diego? Thanks, Gabriel __ 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: Gabriel Aragon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: LOCALLY MANAGED TABLESPACE
8.1.7.4 and 9i From: DENNIS WILLIAMS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: LOCALLY MANAGED TABLESPACE Date: Tue, 24 Jun 2003 08:44:39 -0800 Seema Oracle version? Have you studied the paper How to Stop Defragmenting . . . so you understand how to configure your LMT? Overall, my results with LMT have been great. Oracle says eventually we will all be LMT. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 24, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DBA Salary in California
Title: RE: DBA Salary in California Check out www.salary.com for an estimate. A quick check revealed a range of $68-90K with a median around $79K. Not sure how recent these numbers are. Best regards, David B. Wagoner Database Administrator -Original Message- From: Gabriel Aragon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 24, 2003 12:30 PM To: Multiple recipients of list ORACLE-L Subject: DBA Salary in California Hi guys, just curiosity, any idea about the salary range for an Oracle DBA in California area? More specific in San Diego? Thanks, Gabriel __ 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: Gabriel Aragon INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DBA Salary in California
Of course, if it was a government job, which would seem very possible in DC, it wouldn't seem quite that unusual. Government jobs for experienced DBA's were advertised at 60k during the height of the tech boom. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/24/2003 10:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: DBA Salary in California in the DC area, salaries for jobs that do not require a security clearance have dropped a ton. I saw one DBA job that wanted 5 years experience advertised at $45k/year. I dont know if they filled it, but I have talked to quite a few people that turned them down. id be curious about salaries in california. Seems to me most advertised salaries are very low. Seems like most oracle jobs around here are short term contracts. It also seems like contracting companies are keeping alot more of the rate for themselves. This is evident sicne you often see 3-5 contracters advertising for the same exact job at different rates. The good thing about that is that contracts are no longer sole source bids, so you an negotiate your way up. but id bet if you did that... you would be blacklisted and they wouldnt call you again. From: Gabriel Aragon [EMAIL PROTECTED] Date: 2003/06/24 Tue PM 12:29:50 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: DBA Salary in California Hi guys, just curiosity, any idea about the salary range for an Oracle DBA in California area? More specific in San Diego? Thanks, Gabriel __ 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: Gabriel Aragon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Collaboration Suite Licensing.
Thanks for that. Looks like they are moving ahead fast with this product suite. Patrice. -Original Message- Sent: Tuesday, June 24, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Ali, This announcement may be of interest to you. http://www.infoworld.com/article/03/06/24/HNoraclecollaboration_1.html Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 24, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Ali, From previous discussion with Oracle on the subject. It includes the Collaborative suite software, and a limited license to use Oracle 9iAS and 9i database. Limited means that you can use it for Collaborative suite purposes only. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, June 24, 2003 2:40 AM To: Multiple recipients of list ORACLE-L Hi All, What is included in Collaboration suite 9.0.2 license? As collaboration suite license cost 60 $ per user, we are not sure that whether Oracle 9i Database and Application server will be included in collaboration suite 9.0.2 license or we need to purchase Oracle Database 9i and 9ias separately. can any body help me because this is very urgent. Regards, Mubarak Ali Software Programmer LMK Resources, A Landmark Graphics Affiliated Company E-mail: [EMAIL PROTECTED] Phone: +92 51 111 101 101 Ext. 712 Fax: +92 51 226 4167, +92 51 225 5989 http://www.lmkr.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mubarik Ali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: DBA Salary in California
it was a government contract. not a government jobs. salaries are really down here. not quite $45k, but its a rough job market. From: [EMAIL PROTECTED] Date: 2003/06/24 Tue PM 01:50:00 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: DBA Salary in California Of course, if it was a government job, which would seem very possible in DC, it wouldn't seem quite that unusual. Government jobs for experienced DBA's were advertised at 60k during the height of the tech boom. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/24/2003 10:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: DBA Salary in California in the DC area, salaries for jobs that do not require a security clearance have dropped a ton. I saw one DBA job that wanted 5 years experience advertised at $45k/year. I dont know if they filled it, but I have talked to quite a few people that turned them down. id be curious about salaries in california. Seems to me most advertised salaries are very low. Seems like most oracle jobs around here are short term contracts. It also seems like contracting companies are keeping alot more of the rate for themselves. This is evident sicne you often see 3-5 contracters advertising for the same exact job at different rates. The good thing about that is that contracts are no longer sole source bids, so you an negotiate your way up. but id bet if you did that... you would be blacklisted and they wouldnt call you again. From: Gabriel Aragon [EMAIL PROTECTED] Date: 2003/06/24 Tue PM 12:29:50 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: DBA Salary in California Hi guys, just curiosity, any idea about the salary range for an Oracle DBA in California area? More specific in San Diego? Thanks, Gabriel __ 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: Gabriel Aragon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Re: Thanks!! What are the type#'s in obj$ ?
Jared, It's quite easy to check: alter session set sql_trace = true; drop sequence s; ... or better use 10046 trace with binds. Then search for all occurrences of obj$ in trace file. Also you can set tracing on instance level in init.ora and see what SMON is performing during startup. From there you see that it executes a query finding all type# 10 obj$ entries, which do not have dependants (the negative dep tracking case.) Generally all other base tables (like seg$, dependency$, etc..) get deleted the record(s), but obj$ is only updated to type 10. Thats the case with dropping synonyms, sequences, procedures, functions, probably several other DD objects as well, it's possible to trace it all. But when dropping a segment (table, index) for example, then obj$ gets eventually deleted as well. (btw, I base my claims on tests on Oracle version is 9.2.0.1 on Win, don't know about previous versions) Cheers, Tanel. Interesting. I didn't realize that oracle would keep dropped objects as an unused type rather than delete them. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Thanks!! What are the type#'s in obj$ ?
Another thing to consider is that the object id may be needed for recovery/rollback/read consistency purposes. The object id is one of the fields kept in the undo record. I presume this is for a sanity check to make certain that the undo is being applied to the right object. I wonder if the same field is part of the redo record? If Oracle does not reuse object ids, then an undo record would not be mistakenly applied to the object that has now allocated that file.block.row even if it is not the same object that was originally the source of the undo.begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
Re: log for transaction
Oracle does not have any ready-made logging process to assist you. Some of our developers have utilized 'utl_file' to track the progress of their long running jobs. Entries are made to the job log file at proper intervals to tell them what happened in case the job aborted. - Kirti --- [EMAIL PROTECTED] wrote: Hi there, I got a question on log. If my program crashes, can I check some log to see what recent transaction is? It will give me a big help on trouble shooting. Thanks, Jin -- 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). __ 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: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 for transaction
We use a similiar method which involves inserting periodic rows into a log table, which is dumped to a file at end-of-job. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Kirtikumar Deshpande [SMTP:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 2:05 PM To: Multiple recipients of list ORACLE-L Subject: Re: log for transaction Oracle does not have any ready-made logging process to assist you. Some of our developers have utilized 'utl_file' to track the progress of their long running jobs. Entries are made to the job log file at proper intervals to tell them what happened in case the job aborted. - Kirti --- [EMAIL PROTECTED] wrote: Hi there, I got a question on log. If my program crashes, can I check some log to see what recent transaction is? It will give me a big help on trouble shooting. Thanks, Jin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LOCALLY MANAGED TABLESPACE
What is the group view on your going with the locally managed tablespaces? Well, go ahead, make my data! Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 24, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Re: Event to show Query Rewrite
2 things, one is that our (on 8i, then updgraded to 9.2.0.1) MVs on prebuilt also show a staleness status of unknown, yet work find. Ok with me we just look for that now. The other thing is depending on what you're wanting to accomplish, you can simply turn off query rewrite for your session, then the select count will (should) run against the correct table. alter session set query_rewrite_enabled=false; [EMAIL PROTECTED] 06/24/03 03:04PM Listers, Does anyone know how to set an event, or some other method, to see what query Oracle rewrites for a Materialized View and how it arrives at that decision? I am seeing a problem here in my DW database where the query select count(*) from base_table is rewritten as select count(*) from MV_on_the _base_table, a clearly wrong rewrite of the query. Oracle 9.2.0.3 on Tru64 Unix. The base table is (col1 date, col2 varchar2(20), col3, col4, col5...) range partitioned on col1 and list subpartitioned on col2. the MV is select col1, col2, count(*) totrows from base group by col1, col2, also partitioned in the same manner as the base table. The MV is first as a table and then the MV is built with on prebuilt table clause. Query_rewrite_enabled = true and query_rewrite_integrity = stale_tolerated. A query select count(*) from base is probably rewritten as select count(*) from MV_base, and of course, the results are wrong. Oracle Support asks to provide a test case and I am unable to reproduce it. Upon examination, the STALENESS column in user_mviews is UNKNOWN for this MV; STALE for all others. Oracle Support can't explain what could be the cause of this status except that it happens when an MV is created on a prebuilt table. My only recourse at this time is to identify the decision making process Oracle used to arrive at the query it rewrites to and perhaps explain that somehow. Any help will be greatly appreciated. Thanks a lot in advance. Arup Nanda NOTICE BY ZALE CORPORATION This message, as well as any attached document, contains information from Zale Corporation that is proprietary, confidential and/or privileged. The information is intended only for the use of the addressee named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of this message or its attachments is strictly prohibited, and may be unlawful. If you have received this message in error, please delete all electronic copies of this message and its attachments, if any, destroy any hard copies you may have created, without disclosing the contents, and notify the sender immediately. Unintended transmission does not constitute waiver of any privilege. Unless expressly stated otherwise, nothing contained in this message should be construed as a digital or electronic signature, nor is it intended to reflect an intention to make an agreement by electronic means. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Dimensional Modeling - b-tree vs. bitmapped indexes
Title: RE: Dimensional Modeling - b-tree vs. bitmapped indexes Guys, My understanding is that Oracle's Star Transformation Algorithm does bitmapped merges on the dimensions tables to pull out the FACTS in the FACT table rather efficiently and that you would use bitmapped indexes on your dimensions tables rather than btree. However, noted a posted on data warehousing listserve which said Oracle Expert was strongly recommending b-tree. I haven't used Oracle Expert very much - I don't trust it as much as the various traces, running queries and testing yourself. I guess I feel like Oracle Expert would give you rule-of-thumb stuff and have lots of inherent problems in its recommendations - like exactly what you feed it. I don't trust this over the testing and tracing to see what is happening with the CBO myself. Any opinions?
Event to show Query Rewrite
Listers, Does anyone know how to set an event, or some other method, to see what query Oracle rewrites for a Materialized View and how it arrives at that decision? I am seeing a problem here in my DW database where the query "select count(*) from base_table" is rewritten as "select count(*) from MV_on_the _base_table", a clearly wrong rewrite of the query. Oracle 9.2.0.3 on Tru64 Unix. The base table is (col1 date, col2 varchar2(20), col3, col4, col5...) range partitioned on col1 and list subpartitioned on col2. the MV is "select col1, col2, count(*) totrows from base group by col1, col2", also partitioned in the same manner as the base table. The MV is first as a table and then the MV is built with "on prebuilt table" clause. Query_rewrite_enabled = true and query_rewrite_integrity = stale_tolerated. A query "select count(*) from base" is probably rewritten as "select count(*) from MV_base", and of course, the results are wrong. Oracle Support asks to provide a test case and I am unable to reproduce it. Upon examination, the STALENESS column in user_mviews is "UNKNOWN" for this MV; STALE for all others. Oracle Support can't explain what could be the cause of this status except that "it happens when an MV is created on a prebuilt table". My only recourse at this time is to identify the decision making process Oracle used to arrive at the queryit rewrites to and perhaps explain that somehow. Any help will be greatly appreciated. Thanks a lot in advance. Arup Nanda
RE: Oracle Clinical
Now that makes sense to me ... g v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Clinical On Tue, 24 Jun 2003, Wolfe Stephen S GS-11 6 MDSS/SGSI wrote: What's a DAB? Among the Hmong, a dab is an evil spirit thet makes mad things happen. For instance, a dab might hang out at a particular intersection and make fender-benders happen. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -Original Message- From: [EMAIL PROTECTED] what is Oracle Clinical. I saw some job advertisement Oracle Clinical DAB or programmer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: LOCALLY MANAGED TABLESPACE
I am on 9iR2 , AIX 5L. I have all my tablespaces as locally managed including system. No problem yet. Shaibal Talukder Discover Financial Services Oracle Engineering [EMAIL PROTECTED] From: Seema Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: LOCALLY MANAGED TABLESPACE Date: Tue, 24 Jun 2003 09:19:48 -0800 8.1.7.4 and 9i From: DENNIS WILLIAMS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: LOCALLY MANAGED TABLESPACE Date: Tue, 24 Jun 2003 08:44:39 -0800 Seema Oracle version? Have you studied the paper How to Stop Defragmenting . . . so you understand how to configure your LMT? Overall, my results with LMT have been great. Oracle says eventually we will all be LMT. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 24, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Hi, What is the group view if I will go with locally managed tablespaces? thx -seema _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shaibal Talukder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DATAFILE SIZE
Hi jerome, I think there is still a limit. For example, with Oracle 9i 64 bits on Aix 4.3.3 the limit is around 4 million Oracle blocks (exactly 4194303) for a datafile/tempfile So the real limit depends on your db_block_size but there is one. HTH Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 authentication from windows
Hi Arup, At 21:59 21/06/2003 -0800, you wrote: Snip... An OS user called scott will be able to connect as the database user OPS$SCOTT, not SCOTT - a big difference. This is why the os_authent_prefix parameter is so important to set; don't leave it as null. If it is null, then the OS user scott can connect to database user scott. Maybe I miss the obvious.. Considering remote_os_authent=false, why for LOCAL connections os_authent_prefix='' is inherently less secure than os_authent_prefix=OPS$ or whatever string you choose. In each case, the prerequisite is to create the user identified externally (that's where you MUST be cautious) But if scott is created with a password (i.e create user scott identified by tiger) then no OS user scott can log on whatever the os_authent_prefix is. At least that's how I understand the feature. Can you please elaborate on the security issue ? Any ideas how to restrict the externally identified users so that they have to log in to the database server to access their oracle schemas.? Well, they are mutually exclusive. A user is authenticated by either the database or externally, not both. So if you create user scott identified externally, you are allowing him to bypass database authentication. If you don't want that, then you would create user SCOTT identified by a password. In fact if os_authent_prefix=OPS$ and ONLY in this case, you can still do this (it's inherited from V6 days but still working with Oracle 9i R2) : create user ops$arup identified by nanda; grant create session to ops$arup; And know you can either connect with sqlplus / or sqlplus /nolog connect ops$arup/nanda or sqlplus /nolog connect ops$arup password : nanda Although it doesn't work directly from the command line like sqlplus ops$arup/nanda or sqlplus ops$arup password : nanda (But works again after you get Enter username for a 2nd try) Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Event to show Query Rewrite
Title: Message Its not an event, but maybe this will help. http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/qr.htm#39292 -Original Message-From: Arup Nanda [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 4:05 PMTo: Multiple recipients of list ORACLE-LSubject: Event to show Query Rewrite Listers, Does anyone know how to set an event, or some other method, to see what query Oracle rewrites for a Materialized View and how it arrives at that decision? I am seeing a problem here in my DW database where the query "select count(*) from base_table" is rewritten as "select count(*) from MV_on_the _base_table", a clearly wrong rewrite of the query. Oracle 9.2.0.3 on Tru64 Unix. The base table is (col1 date, col2 varchar2(20), col3, col4, col5...) range partitioned on col1 and list subpartitioned on col2. the MV is "select col1, col2, count(*) totrows from base group by col1, col2", also partitioned in the same manner as the base table. The MV is first as a table and then the MV is built with "on prebuilt table" clause. Query_rewrite_enabled = true and query_rewrite_integrity = stale_tolerated. A query "select count(*) from base" is probably rewritten as "select count(*) from MV_base", and of course, the results are wrong. Oracle Support asks to provide a test case and I am unable to reproduce it. Upon examination, the STALENESS column in user_mviews is "UNKNOWN" for this MV; STALE for all others. Oracle Support can't explain what could be the cause of this status except that "it happens when an MV is created on a prebuilt table". My only recourse at this time is to identify the decision making process Oracle used to arrive at the queryit rewrites to and perhaps explain that somehow. Any help will be greatly appreciated. Thanks a lot in advance. Arup Nanda
Re: Index question
Hi, There are a couple of tables to help you out... user_indexes (or all_indexes) will show you the indexes and their associated tables. user_ind_columns (or all_ind_columns) will show the columns contained within the index (multiple rows per index potentially). In your example, an index on the item column is the only thing which will help. Try: create index ind_itemloc_item on itemloc(item); Then issue: analyze table itemloc estimate statistics; Look at the manuals for additional info on the above statements - you might want to add a tablespace clause to the create index statement for example. The analyze command will provide Oracle with information about the index so that it knows when to use or not use the index. Finally, is the itemloc column a number or string column. If it's a number column then don't wrap quotes around the supplied number - the implicit datatype conversion can cause Oracle to ignore the index. Regards, Mark. Teresita Castro [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] martmx.comcc: Sent by: Subject: Index question [EMAIL PROTECTED] om 25/06/2003 09:44 Please respond to ORACLE-L Hi! I am new using Oracle, and what to ask some doubt about indexes How can I see how many fields of a table have indexes? I am trying to do an update but is too slow, so what I am trying to find is the way to uses an index that can help to do this update more quickly. This is the query example: Update ITEMLOC SET AVERAGE_COST=5.5 WHERE ITEM='0010096' I will like to find the way to set and index that have the item filed include to do this update quicker. Right now it takes like 30 seconds per item and we have to update like 9,000 items. Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DBA Salary in California
Interesting site, thank you very much. Maybe you want to try this one: http://www.payscale.com/research/vid-18563 I recommend you to check the different reports and also fill up the PERSONAL PayScale Report section, prepare yourself to be disappointed if the information doesn't match your actual jobs. Thank you for your responses. Gabriel --- [EMAIL PROTECTED] wrote: it was a government contract. not a government jobs. salaries are really down here. not quite $45k, but its a rough job market. From: [EMAIL PROTECTED] Date: 2003/06/24 Tue PM 01:50:00 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: DBA Salary in California Of course, if it was a government job, which would seem very possible in DC, it wouldn't seem quite that unusual. Government jobs for experienced DBA's were advertised at 60k during the height of the tech boom. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/24/2003 10:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: DBA Salary in California in the DC area, salaries for jobs that do not require a security clearance have dropped a ton. I saw one DBA job that wanted 5 years experience advertised at $45k/year. I dont know if they filled it, but I have talked to quite a few people that turned them down. id be curious about salaries in california. Seems to me most advertised salaries are very low. Seems like most oracle jobs around here are short term contracts. It also seems like contracting companies are keeping alot more of the rate for themselves. This is evident sicne you often see 3-5 contracters advertising for the same exact job at different rates. The good thing about that is that contracts are no longer sole source bids, so you an negotiate your way up. but id bet if you did that... you would be blacklisted and they wouldnt call you again. From: Gabriel Aragon [EMAIL PROTECTED] Date: 2003/06/24 Tue PM 12:29:50 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: DBA Salary in California Hi guys, just curiosity, any idea about the salary range for an Oracle DBA in California area? More specific in San Diego? Thanks, Gabriel __ 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: Gabriel Aragon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Re: Index question
Hi! If you are new to Oracle, it might be easier to use DBA studio (which usually comes with Oracle) or other GUI tool such is Toad (http://www.toadsoft.com/). But if you want to learn how things really work, then open up sqlplus and start experimenting with data dictionary views: select table_name, index_name, column_name, column_position from user_ind_columnswhere table_name = 'your_table_name'order by 1, 3, 4 Note that your table name will likely be upper case even though you created it with lower case name. The column_position column shows you in which order are the columns in composite indexes. Tanel. - Original Message - From: Teresita Castro To: Multiple recipients of list ORACLE-L Sent: Wednesday, June 25, 2003 2:44 AM Subject: Index question Hi! I am new using Oracle, and what to ask some doubt about indexes How can I see how many fields of a table have indexes? I am trying to do an update but is too slow, so what I am trying to find is the way to uses an index that can help to do this update more quickly. This is the query example: UpdateITEMLOC SET AVERAGE_COST=5.5 WHERE ITEM='0010096' I will like to find the way to set and index that have the item filed include to do this update quicker. Right now it takes like 30 seconds per item and we have to update like 9,000 items.
Re: Index question
THANKS!!! I run the next queries and I found the information that I need. select * from ALL_INDEXESwhere table_name='ITEMLOC' select * from all_ind_columnswhere table_name='ITEMLOC' The only problem that I have was that I was trying to find ALL_INDEXES and all_ind_columnson the wrong places they was on the views tab. About the item,yesit is char(32), thanks for the advice is really important to know this kind of things. [EMAIL PROTECTED] 06/24/03 06:24PM Hi,There are a couple of tables to help you out...user_indexes (or all_indexes) will show you the indexes and theirassociated tables.user_ind_columns (or all_ind_columns) will show the columns containedwithin the index (multiple rows per index potentially).In your example, an index on the item column is the only thing which willhelp.Try:create index ind_itemloc_item on itemloc(item);Then issue:analyze table itemloc estimate statistics;Look at the manuals for additional info on the above statements - you mightwant to add a tablespace clause to the "create index" statement forexample. The analyze command will provide Oracle with information aboutthe index so that it knows when to use or not use the index.Finally, is the itemloc column a number or string column. If it's a numbercolumn then don't wrap quotes around the supplied number - the implicitdatatype conversion can cause Oracle to ignore the index.Regards, Mark. "Teresita Castro" [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] martmx.com cc: Sent by: Subject: Index question [EMAIL PROTECTED] om 25/06/2003 09:44 Please respond to ORACLE-L Hi!I am new using Oracle, and what to ask some doubt about indexesHow can I see how many fields of a table have indexes?I am trying to do an update but is too slow, so what I am trying to find isthe way to uses an index that can help to do this update more quickly.This is the query example:Update ITEMLOCSET AVERAGE_COST=5.5WHERE ITEM='0010096'I will like to find the way to set and index that have the item filedinclude to do this update quicker. Right now it takes like 30 seconds peritem and we have to update like 9,000 items. Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone.In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Mark Richard 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).
Oracle 9.2 RAC on Win2K?
I need help with clearing up one conceptual issue: My understanding is that with Oracle RAC one set of physical database files sitting in the middle - shared storage are being accessed by multiple Oracle instances running on multiple physical servers (nodes). All instances attacking (sharing) the very same set of data files at the same time. Right or wrong? Provided the answer on the above question happens to be yes - I'd like to ask List Folks how feasible is to assemble and successfully (smoothly?) run 0.5-1 TB database, use Oracle RAC and high performance shared storage (say SAN) served (pumped) by a number of Windows 2K servers? The number of Win2K servers I have on mind is at least 4 beefy (as beefy as it gets in Windows wrld) Win2K boxes each running Win2K AS with lots of RAM and at least 4 CPUs, with perspective of adding more later. It would be nice (for me) to know if new nodes can be added to the cluster at any later time to improve performance (in order to deal with increase in usage or to accomodate growth over period of time). It would be very nice to know if number of nodes is or is not limited (otherwise than by raw I/O capabilities of the shared storage). Has anyone seen/run/stumbled over similar beast, if so - does it fly or it stinks? Thanks (for any help, hints, links, etc.), Branimir P.S. I've looked at number of metalink articles and found none yet to scratch this specific itch of mine. Oracle RAC on Win2K is for some bizarre reason REQUIREMENT. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 authentication from windows
Gilles, Here is a lowdown on the security aspects related to the OS authentication. (1) The use of remote_os_authent is false, then it simply means that users from another machine can't log in using OPS$ accounts. Needless to say, this reduces the security and must be weighed a bit more carefully than usual. (2) Should you ever have accounts externally identified? I would say, yes, as long as you know the privileges are not sweeping. For instance, you definitely don't want to give DBA privs to an externally identifiable user. (3) Having said that, the next question is - should you leave the value of os_authent_prefix at NULL (). I say absolutely not. Here is the probelm with an externally idefoaable user with os_authent_prefix set to null. A user OPS$SCOTT identified externally is no the same as SCOTT, if the os_authent_prefix is set to OPS$. If that parameter is null, then database user SCOTT is the same as the OS user SCOTT. If someone creates a user in the OS called system and os_authent_prefix is null, what is the database user it connects to? SYSTEM Would you want that? Of couse not. That is why you never, ever, want to set the os_authent_prefix to null. Always set it to a value. You may have a different value such as UNSAFE$, if you wish, to fool the hackers. (4) Thank you for the example. I guess I was not very clear on that issue. I think the original question from Bulbul was how to prevent the OPS$ useers from connecting to the database using user id, isn't that so, Bulbul? The solution is rather simple. Just use either of the two forms of the command create user OPS$SCOTT identified externally or create user SCOTT identified by tiger, not create user OPS$SCOTT identified by tiger. And always set your os_authent_prefix to OPS$ or some non-null value. This way the accounts will be authenticated in only one way, not both. Another trick I use to foll th ehackers using the brute force attack is to use the construct alter user ops$scott identified by values 'somestringinascii' Since the password is hashed and digestedm this will not match any password and therefore will not correspond to a value. By the way, Gilles, the connection will work fine with the userid as a parameter to the sqlplus command. Are you using unix? If so, use sqlplus ops\$arup/nanda (note the backslash before the $ sign) instead of sqlplus ops$arup/nanda $ sign being a unix special character may have confused sqlplus, thinking $arup/nanda being an environmental variable. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 5:19 PM Hi Arup, At 21:59 21/06/2003 -0800, you wrote: Snip... An OS user called scott will be able to connect as the database user OPS$SCOTT, not SCOTT - a big difference. This is why the os_authent_prefix parameter is so important to set; don't leave it as null. If it is null, then the OS user scott can connect to database user scott. Maybe I miss the obvious.. Considering remote_os_authent=false, why for LOCAL connections os_authent_prefix='' is inherently less secure than os_authent_prefix=OPS$ or whatever string you choose. In each case, the prerequisite is to create the user identified externally (that's where you MUST be cautious) But if scott is created with a password (i.e create user scott identified by tiger) then no OS user scott can log on whatever the os_authent_prefix is. At least that's how I understand the feature. Can you please elaborate on the security issue ? Any ideas how to restrict the externally identified users so that they have to log in to the database server to access their oracle schemas.? Well, they are mutually exclusive. A user is authenticated by either the database or externally, not both. So if you create user scott identified externally, you are allowing him to bypass database authentication. If you don't want that, then you would create user SCOTT identified by a password. In fact if os_authent_prefix=OPS$ and ONLY in this case, you can still do this (it's inherited from V6 days but still working with Oracle 9i R2) : create user ops$arup identified by nanda; grant create session to ops$arup; And know you can either connect with sqlplus / or sqlplus /nolog connect ops$arup/nanda or sqlplus /nolog connect ops$arup password : nanda Although it doesn't work directly from the command line like sqlplus ops$arup/nanda or sqlplus ops$arup password : nanda (But works again after you get Enter username for a 2nd try) Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send
FEEDBACK: SMON taking 50% of CPU and certain queries hanging
It seems that the new version of Workflow that we implemented had a massive query running in the background, compound that with we run 9 companies (multi schema) in one database, that was 9 massive queries running in the background. The thing that I didnt notice it at first was that because SMON had all the CPU these processes showed very little CPU usage.Yet the following morning they had increased their CPU usage to about 5% each and SMON was normal. I easily identified the problem then , killed the queries, bollocked the vendor, and all is normal again. Anyhow thanks to the guys who contributed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9.2 RAC on Win2K?
On 2003.06.24 23:29, Branimir Petrovic wrote: I need help with clearing up one conceptual issue: My understanding is that with Oracle RAC one set of physical database files sitting in the middle - shared storage are being accessed by multiple Oracle instances running on multiple physical servers (nodes). All instances attacking (sharing) the very same set of data files at the same time. Right or wrong? Right. Provided the answer on the above question happens to be yes - I'd like to ask List Folks how feasible is to assemble and successfully (smoothly?) run 0.5-1 TB database, use Oracle RAC and high performance shared storage (say SAN) served (pumped) by a number of Windows 2K servers? The number of Win2K servers I have on mind is at least 4 beefy (as beefy as it gets in Windows wrld) Win2K boxes each running Win2K AS with lots of RAM and at least 4 CPUs, with perspective of adding more later. The company that I work for (Oxford Health Plans, http://www.oxhp.com) has several OPS configurations, one of which has 4 HP 9000/N nodes with hyperfabric (CLIC) interface. Unfortunately, we're running HP-UX, not Win2k. Theoretically speaking, having a windoze cluster is possible, although the reputation of Win2k, especially when it comes to the stability, isn't the one that I would like for a fault tolerant and stable system. Fault tolerance and stability are the primary reasons for considering RAC. It would be nice (for me) to know if new nodes can be added to the cluster at any later time to improve performance (in order to deal with increase in usage or to accomodate growth over period of time). Performance of a clustered database is not bound by the CPU power alone, IO throughput is much more important and limiting factor then sheer CPU speed. If you want performance, my advice is to go with a bigger box. Having in mind the price of SAN and RAC licenses, you'll be much better of with one 16 CPU machine then with a cluster of 4 machines with 4 CPUs each. To answer your question, yes, nodes can be added at later stage. It would be very nice to know if number of nodes is or is not limited (otherwise than by raw I/O capabilities of the shared storage). I believe that the limit for windoze is 8 machines per cluster. With Unix, I believe that the limit is 128. Has anyone seen/run/stumbled over similar beast, if so - does it fly or it stinks? Depends on the application system. RAC is a bit more tolerant, but you still want to minimize the block exchange between the nodes. Application system must be functionally partitioned, meaning that related data should be accessed from the same node. Example: let's imagine that we have health care application system which has elements like members/groups/providers, claims and drug utilization/ 3rd party vendors. Each of the listed groups is a complex application system accessing several hundreds of related tables. Good thing would be to put each of the listed application groups on its own node with the 4th node reserved for batch processing. If block exchange is frequent and DLM has a lot of work to do, then flying means free falling until you hit the ground. Thanks (for any help, hints, links, etc.), Branimir P.S. I've looked at number of metalink articles and found none yet to scratch this specific itch of mine. Oracle RAC on Win2K is for some bizarre reason REQUIREMENT. Requirement by who? It usually helps to make a business case for a specific configuration and benchmark it to see whether the performance is satisfactory. Let me suggest a little benchmark: 4 clustered, beefed up PC boxes vs. a single, 16-CPU IBM P690 with the latest 960 CPUs and AIX 5.2. You can benchmark price and performance. I'd be very intrigued to find out the outcome. It is very hard to predict it properly (wink, wink). -- 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).