Re: data is skewed - what does it mean ?
Gogala, If cardinality is high, then data is evenly distributed. If cardinality is low, then data is not evenly distributed and hence skewed. Is my understanding correct...atleast to some extent ?! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: orababy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Antw: Re: data is skewed - what does it mean ?
Come on, don't try to persuade me of you being old. I'm 42 like you and still feel the blood running through my veins. At least, sometimes ;-) I can remember the (not so) good old times when everyone thought we 'computer wizards' came from outer space. Nowadays almost every school kid has a better equipment at home than me at work. And damagement still wants us to do miracles every single day :( Although it's early morning in Germany: Nice weekend to all list members. Greetings, Guido [EMAIL PROTECTED] 25.07.2003 08.14 Uhr Well, there have been situations when CBO made me use obscene language by stubbornly refusing to use and index which was utilized when RBO was used. I believe that the vast majority of old and balding DBA geezers like me can make the same claims. Thus the name. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: data is skewed - what does it mean ?
It's not this simple... Let's take your low cardinality example... Gender is a good example since there are only two (common) genders - male and female. A table with 10,000 staff would make the gender column low cardinaility - only 2 distinct values. If you had 5,000 males and 5,000 females then the data would be evenly distributed and therefore not skewed. If, however, you had 9,500 females and 500 males then you have skewed data. Hopefully this gives some idea of the difference between cardinality and skewed data. orababy [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: Re: data is skewed - what does it mean ? [EMAIL PROTECTED] .com 25/07/2003 17:34 Please respond to ORACLE-L Gogala, If cardinality is high, then data is evenly distributed. If cardinality is low, then data is not evenly distributed and hence skewed. Is my understanding correct...atleast to some extent ?! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: orababy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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. 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 a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (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 Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services--
Re: Is there any data dictionary to check out the creation statements
SQL select query from user_mviews where mview_name='MV_END_ART'; QUERY SELECT * FROM ARTICLESCATALOG WHERE END_DATE_DTM SYSDATE AND END_DATE_DTM SYS Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 25, 2003 2:24 PM Hi, All, Is there any data dictionary in Oracle to check out creation statements of materialized view? Something like the user_source view about object creation. I have checked user_mviews, user_mview_joins, etc, but I haven't got one. TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 9i (9.2.0.4)- RH AS 2.1 HP Itanium
Anyone know when will patchset 9.2.0.4 be out? Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 24, 2003 11:49 PM Oracle RDBMS 9.2.0.4??? I thought that the latest version was 9.2.0.3? Where did you get 9.2.0.4? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, July 24, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Hi there Who is running this. Would like to hear opinion and experiences. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Cell: (+27) 82 655 2466 Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! This email and all contents are subject to the following disclaimer: http://www.didata.com/disclaimer.asp; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: George Leonard (ZA) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: data is skewed - what does it mean ?
Oh... Thank U Mark. got it now. ...now i can explain it to someone who doesn't know. Cheers. Mark Richard [EMAIL PROTECTED]: It's not this simple... Let's take your low cardinality example... Gender is a good example since there are only two (common) genders - male and female. A table with 10,000 staff would make the gender column low cardinaility - only 2 distinct values. If you had 5,000 males and 5,000 females then the data would be evenly distributed and therefore not skewed. If, however, you had 9,500 females and 500 males then you have skewed data. Hopefully this gives some idea of the difference between cardinality and skewed data. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: orababy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: index not being used
Hi! This plan shows that ICWOIMP is accessed FULL . Actually this table has a Primary Key on WOKEY this is used in JOIN condition . WHy is it not using that index But you also have two joins between ICWOIMP (A) and AFAS_RCPT_DTLS (D) tables in your query: CBO finds that it's better to hash join those two, and it's better to use multiblock reads from table to get the data for join either because of cost or because you do not have indexes / other predicates on those columns. And since you already have read whole ICWOIMP table due CBO decided join order, there's no point of reading any more data from it, thus no index is required and the hint is ignored. Instead the hash joined result set is taken and is joined to rest of tables using nested loops. You have to hint join orders if you definitely want to get join using WOKEY happen first. Tanel. I tried to force this index SELECT /*+ INDEX (ICWOIMP PK_ICWOIMP) */ A.CANNO INVOICE NO, A.CANDATE INVOICE DATE, --B.NAME CUSTOMER NAME, A.CANAMT REVENUE AMOUNT, C.RCPTDOCNO RECEIPT NO., D.RECEIPTAMOUNTRECEIPT AMOUNT, C.RCPTDATE RECEIPT DATE FROM ICWOIMP A, ICADDDRESSDTLS B, AFAS_RCPT_HDR C, AFAS_RCPT_DTLS D WHERE A.WOKEY = B.WOKEY AND D.RECEIPTHDRID = C.RECEIPTHDRID AND ADDTYPE ='SHPR' --AFAS_RCPT_DTLS.RECEIPTHDRID = AFAS_RCPT_HDR.RECEIPTHDRID AND D.DOCLINKREFNUM = A.CANNO AND D.DOCLINKNUM = A.WONO But still with this , execution plan remained the same. AM I missing something ? Can Oracle ignore the hint although provided ? P.S. Statistics are Up-To-Date for all tables. can anybody tell me why my hinet is being ignored Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?hrishy?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Index Usage ?!
Hi! but there are seperate indexes on column PREF, FLAG and SEX. when those indexes are used ,cost=999. whereas when IDX_PROFILE_SHINKI ( a composite index on ENTPC, FLAG,SEX,PREF,ENTDAY) is used , cost=7. 1.whys there is a huge difference in COST ? As Wolfgang said, since your IDX_PROFILE_SHINKI index is unanalyzed, CBO is using default values, which look quite sexy costwise. Are your other indexes analyzed? 2.does it mean that a composite index is better than individual ones ? Always depends. But I use them a lot. Optimizerwise - they might be bigger in sense of bytes blocks, but again if they contain all columns required in qurey, that no table access is required, they can speed up lookups short range scans significantly. Tanel. Kindly throw some light on this. Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: index not being used
Hi Sami Thanks a lot it worked ..:-) my oversight i missed comma :-) regards Hrishy --- Saminathan Seerangan [EMAIL PROTECTED] wrote: Hi Hrishy Just try with /*+INDEX (ICWOIMP,PK_ICWOIMP) */ ^^ ^^ No space Comma I am not sure. hrishy writes: Hi Oracle 8.1.7.0.0 on HP-UX 11.0 We have following query . / SELECT A.CANNO INVOICE NO, A.CANDATE INVOICE DATE, --B.NAME CUSTOMER NAME, A.CANAMT REVENUE AMOUNT, C.RCPTDOCNO RECEIPT NO., D.RECEIPTAMOUNTRECEIPT AMOUNT, C.RCPTDATE RECEIPT DATE FROM ICWOIMP A, ICADDDRESSDTLS B, AFAS_RCPT_HDR C, AFAS_RCPT_DTLS D WHERE A.WOKEY = B.WOKEY AND D.RECEIPTHDRID = C.RECEIPTHDRID AND ADDTYPE ='SHPR' --AFAS_RCPT_DTLS.RECEIPTHDRID = AFAS_RCPT_HDR.RECEIPTHDRID AND D.DOCLINKREFNUM = A.CANNO AND D.DOCLINKNUM = A.WONO / Execution Plan : - SELECT STATEMENT Optimizer=CHOOSE (Cost=1178 Card=1 Bytes=12 1) 0 NESTED LOOPS (Cost=1178 Card=1 Bytes=121) 1 NESTED LOOPS (Cost=1175 Card=1 Bytes=109) 2 HASH JOIN (Cost=1174 Card=1 Bytes=81) 3 TABLE ACCESS (FULL) OF 'AFAS_RCPT_DTLS' (Cost=70 Car d=11603 Bytes=440914) 3 TABLE ACCESS (FULL) OF 'ICWOIMP' (Cost=830 Card=3733 9 Bytes=1605577) 2 TABLE ACCESS (BY INDEX ROWID) OF 'AFAS_RCPT_HDR' (Cost =1 Card=8343 Bytes=233604) 6 INDEX (UNIQUE SCAN) OF 'PK_AFAS_RCPT_HDR' (UNIQUE) 1 TABLE ACCESS (BY INDEX ROWID) OF 'ICADDDRESSDTLS' (Cost= 3 Card=12018 Bytes=144216) 8 INDEX (RANGE SCAN) OF 'INDX_ICADDRESSDTLS_WOKEY' (NON- UNIQUE) (Cost=2 Card=12018) This plan shows that ICWOIMP is accessed FULL . Actually this table has a Primary Key on WOKEY this is used in JOIN condition . WHy is it not using that index I tried to force this index SELECT /*+ INDEX (ICWOIMP PK_ICWOIMP) */ A.CANNO INVOICE NO, A.CANDATE INVOICE DATE, --B.NAME CUSTOMER NAME, A.CANAMT REVENUE AMOUNT, C.RCPTDOCNO RECEIPT NO., D.RECEIPTAMOUNTRECEIPT AMOUNT, C.RCPTDATE RECEIPT DATE FROM ICWOIMP A, ICADDDRESSDTLS B, AFAS_RCPT_HDR C, AFAS_RCPT_DTLS D WHERE A.WOKEY = B.WOKEY AND D.RECEIPTHDRID = C.RECEIPTHDRID AND ADDTYPE ='SHPR' --AFAS_RCPT_DTLS.RECEIPTHDRID = AFAS_RCPT_HDR.RECEIPTHDRID AND D.DOCLINKREFNUM = A.CANNO AND D.DOCLINKNUM = A.WONO But still with this , execution plan remained the same. AM I missing something ? Can Oracle ignore the hint although provided ? P.S. Statistics are Up-To-Date for all tables. can anybody tell me why my hinet is being ignored Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?hrishy?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Saminathan Seerangan Free multi-lingual web-based and POP3 email service with a generous 15MB of storage, a choice of themes for your mailbox, message filtering, plus spam and virus protection Sign up now: http://www.gawab.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saminathan Seerangan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?hrishy?= INET: [EMAIL PROTECTED]
RE: Extproc setup Q?
Hi, Thought I had followed that but obviously not exact enough. Now it works. Thanx jack -Original Message- Sent: Thursday, July 24, 2003 6:09 PM To: Multiple recipients of list ORACLE-L Jack, This is a post from a few weeks ago that gives a setup TNSNAMES: extproc_connection_data.world = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = extproc_agent) --- Key1 ) (CONNECT_DATA = (SID = 11) --- Key2 (server=dedicated)) ) Listener: EXTPROC_LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = extproc_agent) Key1 ) ) SID_LIST_EXTPROC_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = 11) Key2 (ORACLE_HOME = /ora1/81764) (PROGRAM = extproc) ) ) BTW: Oracle's recommendation is to use a seperate listener for extproc calls. -Original Message- Sent: 24 July 2003 15:10 To: Multiple recipients of list ORACLE-L http://www.quantsystems.nl/ Tried that still the same error message. Any other hints tips for me to try? Just curious though ,why is it DLLS if I'm working on LINUX Jack -Original Message- Sent: Thursday, July 24, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Please add the line in red to your listener.ora file. Extproc has been made secure in Oracle 9i. The following line has to be added to execute your own external procedures. LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = plsextproc) (ORACLE_HOME = /oracle/app/product/9.2.0) (PROGRAM = extproc) (ENVS=EXTPROC_DLLS=ANY) ) (SID_DESC = (GLOBAL_DBNAME = Ora92) (ORACLE_HOME = /oracle/app/product/9.2.0) (SID_NAME = ora92) ) ) Regards Munish Bajaj -Original Message- Sent: Thursday, July 24, 2003 16:24 To: Multiple recipients of list ORACLE-L Hi All, I am trying to setup EXTPROC but keep getting ORA-28575 (Check your tnsnames.ora listener.ora) Attached are my files that look OK to me Anybody?? [EMAIL PROTECTED] admin]$ cat tnsnames.ora # TNSNAMES.ORA Network Configuration File: /oracle/app/product/9.2.0/network/admin/tnsnames.ora ORA92 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = Ora92) ) ) extproc_connection_data = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent)) (CONNECT_DATA = (SID = plsextproc)) ) ) [EMAIL PROTECTED] admin]$ cat listener.ora # LISTENER.ORA Network Configuration File: /oracle/app/product/9.2.0/network/admin/listener.ora LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = plsextproc) (ORACLE_HOME = /oracle/app/product/9.2.0) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = Ora92) (ORACLE_HOME = /oracle/app/product/9.2.0) (SID_NAME = ora92) ) ) TIA Jack van Zanen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: index not being used
Hi Taner So do you suggest that i create a index on CANNO or WONO feilds and experiment. D.DOCLINKREFNUM = A.CANNO or D.DOCLINKNUM = A.WONO regards Hrishy --- Tanel Poder [EMAIL PROTECTED] wrote: Hi! This plan shows that ICWOIMP is accessed FULL . Actually this table has a Primary Key on WOKEY this is used in JOIN condition . WHy is it not using that index But you also have two joins between ICWOIMP (A) and AFAS_RCPT_DTLS (D) tables in your query: CBO finds that it's better to hash join those two, and it's better to use multiblock reads from table to get the data for join either because of cost or because you do not have indexes / other predicates on those columns. And since you already have read whole ICWOIMP table due CBO decided join order, there's no point of reading any more data from it, thus no index is required and the hint is ignored. Instead the hash joined result set is taken and is joined to rest of tables using nested loops. You have to hint join orders if you definitely want to get join using WOKEY happen first. Tanel. I tried to force this index SELECT /*+ INDEX (ICWOIMP PK_ICWOIMP) */ A.CANNO INVOICE NO, A.CANDATE INVOICE DATE, --B.NAME CUSTOMER NAME, A.CANAMT REVENUE AMOUNT, C.RCPTDOCNO RECEIPT NO., D.RECEIPTAMOUNTRECEIPT AMOUNT, C.RCPTDATE RECEIPT DATE FROM ICWOIMP A, ICADDDRESSDTLS B, AFAS_RCPT_HDR C, AFAS_RCPT_DTLS D WHERE A.WOKEY = B.WOKEY AND D.RECEIPTHDRID = C.RECEIPTHDRID AND ADDTYPE ='SHPR' --AFAS_RCPT_DTLS.RECEIPTHDRID = AFAS_RCPT_HDR.RECEIPTHDRID AND D.DOCLINKREFNUM = A.CANNO AND D.DOCLINKNUM = A.WONO But still with this , execution plan remained the same. AM I missing something ? Can Oracle ignore the hint although provided ? P.S. Statistics are Up-To-Date for all tables. can anybody tell me why my hinet is being ignored Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?hrishy?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?hrishy?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:Index Usage ?!
Irfan, as u said,yes the data in SEX,FLAG,PREF columns are skewed. do i need to create histograms for the COLUMNS or INDEXES ? The COST of using IDX_PROFILE_SHINKI (composite index - not analyzed ) is 7 The COST of using individual indexes (on SEX,FLAG,PREF - analyzed ) is 999 now. will using histograms reduce the COST inspite of using individual indexes ? Regards, Jp. From: Irfan Khan [EMAIL PROTECTED] To: 'Prem Khanna J' [EMAIL PROTECTED] In this case i will give u only one statement, Ur data is very highly skewed, Play with histograms. Irfan , Khan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Union quries: INTERSECT, MINUS, etc
not very slick but I used MINUS yesterday to find parents with no children so as to purge them we do this a lot in this 3rd party app. RI is sketchy at best and the app blows up if childless parents exists --- [EMAIL PROTECTED] wrote: Jonathan, I've used MINUS heavily in sql scripts and pl/sql to determine the differences in schemas: both structure and data. Of interest to DBA's and developers, and least when I did it it was for the developers. Jared On Thu, 24 Jul 2003, Jonathan Gennick wrote: I'm doing research for an article on union queries. I'm interested in finding examples of problems that were solved using UNION, UNION ALL, INTERSECT, or MINUS, with the latter two being of special interest because I don't see them used very often. If you can think of an interesting problem you've solved using one of these keywords, I'd love to hear about it. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- 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!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Executing stored procedure from diff user
Hi Saminathan, Add the line: authid current_user here: procedure show_space ( p_segname in varchar2, p_owner in varchar2 default user, p_typein varchar2 default 'TABLE', p_partition in varchar2 default NULL ) authid current_user as l_free_blks number; and recreate the procedure as system and then it should run as your other user. for example: SQL connect system/manager Connected. SQL -- add the line authid current_user to show_space.sql SQL @show_space Procedure created. SQL grant execute on show_space to public; Grant succeeded. SQL create public synonym show_space for show_space; Synonym created. SQL connect pete/pete Connected. SQL create cluster phash (hash_key number) hashkeys 1000 size 8192; Cluster created. SQL set serveroutput on size 100 SQL exec show_space('PHASH',user,'CLUSTER'); Free Blocks.0 Total Blocks1456 Total Bytes.11927552 Unused Blocks...446 Unused Bytes3653632 Last Used Ext FileId1 Last Used Ext BlockId...35049 Last Used Block.34 PL/SQL procedure successfully completed. SQL hope this helps kind regards pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: index not being used
Sami Hrishy, do u need a , there ? i have not used it things worked. i don't find in the docs too. so it wroks with a , too. ..tough time ahead ?! Regards, Jp. 25-07-2003 18:49:28, hrishy [EMAIL PROTECTED] wrote: Hi Sami Thanks a lot it worked ..:-) my oversight i missed comma :-) regards Hrishy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: index not being used
Jp, Oracle Docs http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/hintsref.htm#4855 somewhere it has need specified with comma and some places it is not. Prem Khanna J writes: Sami Hrishy, do u need a , there ? i have not used it things worked. i don't find in the docs too. so it wroks with a , too. ...tough time ahead ?! Regards, Jp. 25-07-2003 18:49:28, hrishy [EMAIL PROTECTED] wrote: Hi Sami Thanks a lot it worked ..:-) my oversight i missed comma :-) regards Hrishy Saminathan Seerangan Free multi-lingual web-based and POP3 email service with a generous 15MB of storage, a choice of themes for your mailbox, message filtering, plus spam and virus protection Sign up now: http://www.gawab.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sami INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Index Usage ?!
Tanel, quoteAre your other indexes analyzed?/quote Yes. Case 1: If IDX_PROFILE_SHINKI is analyzed,CBO decides that index scan is costlier. Case 2: Now IDX_PROFILE_SHINKI is not analyzed (which works fine as of now), CBO takes default values and decides that index scan is cheaper. As per case 1,the I/O to read the index will be costlier. So CBO decides not to use the index. But as per case 2 (existing situation): After the decision is made by CBO, it still needs to read the index and then fetch table data. So the same I/O to read the index is going to happen as in case 1. * correct me if i'm wrong * Aren't they contradictory ?! So how does case 2 benefit in terms of CPU or memory consumption ? and there is a big diff. in response time between both cases...how ? ...totally confused :( Regards, Jp. 25-07-2003 18:34:23, Tanel Poder [EMAIL PROTECTED] wrote: Hi! but there are seperate indexes on column PREF, FLAG and SEX. when those indexes are used ,cost=999. whereas when IDX_PROFILE_SHINKI ( a composite index on ENTPC, FLAG,SEX,PREF,ENTDAY) is used , cost=7. 1.whys there is a huge difference in COST ? As Wolfgang said, since your IDX_PROFILE_SHINKI index is unanalyzed, CBO is using default values, which look quite sexy costwise. Are your other indexes analyzed? 2.does it mean that a composite index is better than individual ones ? Always depends. But I use them a lot. Optimizerwise - they might be bigger in sense of bytes blocks, but again if they contain all columns required in qurey, that no table access is required, they can speed up lookups short range scans significantly. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9i refuses to allow client connection -- I need some help.
Title: Message I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974
Re: index not being used
Thanx Sami for letting me know it. Regards, Jp. 25-07-2003 20:34:24, Sami [EMAIL PROTECTED] wrote: Jp, Oracle Docs http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/hintsref.htm#4855 somewhere it has need specified with comma and some places it is not. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i refuses to allow client connection -- I need some h
Title: Message What is the error message (if any) Can you connect thru SQL*Plus (/ as sysdba) -Original Message-From: Wolfe Stephen S GS-11 6 MDSS/SGSI [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle 9i refuses to allow client connection -- I need some help. I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974
Re: Index Usage ?!
Thanx a lot Irfan. let me also go thro' metalink and try out something. Regards, Jp. 25-07-2003 18:46:51, Irfan Khan [EMAIL PROTECTED] wrote: From what i understand when u analyze , use the keyword of size to set the histogram buckets Generally it should be no of distinct values in a column + som ball park no. say ten. U can play around with this analyzing with histograms. I tried and it worked for me and so it should for you as well. I will do more research and will get back to you. Irfan , Khan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Index Usage ?!
Hi! Your original post shows that when index was not analyzed, optimizer used default statistics and found out that index scan is quite cheap. Also, no sorting had to be done, since descending index range scan could be used to satisfy your order by clause. Whe index was analyzed, then CBO actually saw, that index isn't that good as defaul values showed, the number of leaf blocks was higher and also the clustering factor was probably much-mugh higher, meaning that for any non-unique index key value it has to visit several different data blocks to get all matching rows. That means lot's of IOs. Eventually CBO decided that it's cheaper to do let say 1600 multiblock (plus one segment header + possibly bitmap) reads directly and scan through the whole table than to traverse through index branches, scan leaf blocks and visit every data block individually. So, with not-analyzed index, CBO had nothing else to do, than to be super-optimistic about the index (#LB, CLUF) thus using index in your case. But when analyzed, CBO had accurate data, but did make bad decision because too pessimistic values for optimizer_index_cost_adj and optimizer_index_caching. You should set them at session level for testing to let say 50 and 90, but read the document below for understanding those parameters. http://www.evdbt.com/SearchIntelligenceCBO.doc Cheers, Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 25, 2003 2:54 PM Tanel, quoteAre your other indexes analyzed?/quote Yes. Case 1: If IDX_PROFILE_SHINKI is analyzed,CBO decides that index scan is costlier. Case 2: Now IDX_PROFILE_SHINKI is not analyzed (which works fine as of now), CBO takes default values and decides that index scan is cheaper. As per case 1,the I/O to read the index will be costlier. So CBO decides not to use the index. But as per case 2 (existing situation): After the decision is made by CBO, it still needs to read the index and then fetch table data. So the same I/O to read the index is going to happen as in case 1. * correct me if i'm wrong * Aren't they contradictory ?! So how does case 2 benefit in terms of CPU or memory consumption ? and there is a big diff. in response time between both cases...how ? ...totally confused :( Regards, Jp. 25-07-2003 18:34:23, Tanel Poder [EMAIL PROTECTED] wrote: Hi! but there are seperate indexes on column PREF, FLAG and SEX. when those indexes are used ,cost=999. whereas when IDX_PROFILE_SHINKI ( a composite index on ENTPC, FLAG,SEX,PREF,ENTDAY) is used , cost=7. 1.whys there is a huge difference in COST ? As Wolfgang said, since your IDX_PROFILE_SHINKI index is unanalyzed, CBO is using default values, which look quite sexy costwise. Are your other indexes analyzed? 2.does it mean that a composite index is better than individual ones ? Always depends. But I use them a lot. Optimizerwise - they might be bigger in sense of bytes blocks, but again if they contain all columns required in qurey, that no table access is required, they can speed up lookups short range scans significantly. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: index not being used
Hi! Let's start with that: where is your problem? Do you have a performance problem with current execution plan or do you just want to see indexes used? Execution plans might change if you add those indexes, just try and see. It could happen that hash join of A and D tables are replaced with nested loops, with D being driving table... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 25, 2003 1:04 PM Hi Taner So do you suggest that i create a index on CANNO or WONO feilds and experiment. D.DOCLINKREFNUM = A.CANNO or D.DOCLINKNUM = A.WONO regards Hrishy --- Tanel Poder [EMAIL PROTECTED] wrote: Hi! This plan shows that ICWOIMP is accessed FULL . Actually this table has a Primary Key on WOKEY this is used in JOIN condition . WHy is it not using that index But you also have two joins between ICWOIMP (A) and AFAS_RCPT_DTLS (D) tables in your query: CBO finds that it's better to hash join those two, and it's better to use multiblock reads from table to get the data for join either because of cost or because you do not have indexes / other predicates on those columns. And since you already have read whole ICWOIMP table due CBO decided join order, there's no point of reading any more data from it, thus no index is required and the hint is ignored. Instead the hash joined result set is taken and is joined to rest of tables using nested loops. You have to hint join orders if you definitely want to get join using WOKEY happen first. Tanel. I tried to force this index SELECT /*+ INDEX (ICWOIMP PK_ICWOIMP) */ A.CANNO INVOICE NO, A.CANDATE INVOICE DATE, --B.NAME CUSTOMER NAME, A.CANAMT REVENUE AMOUNT, C.RCPTDOCNO RECEIPT NO., D.RECEIPTAMOUNTRECEIPT AMOUNT, C.RCPTDATE RECEIPT DATE FROM ICWOIMP A, ICADDDRESSDTLS B, AFAS_RCPT_HDR C, AFAS_RCPT_DTLS D WHERE A.WOKEY = B.WOKEY AND D.RECEIPTHDRID = C.RECEIPTHDRID AND ADDTYPE ='SHPR' --AFAS_RCPT_DTLS.RECEIPTHDRID = AFAS_RCPT_HDR.RECEIPTHDRID AND D.DOCLINKREFNUM = A.CANNO AND D.DOCLINKNUM = A.WONO But still with this , execution plan remained the same. AM I missing something ? Can Oracle ignore the hint although provided ? P.S. Statistics are Up-To-Date for all tables. can anybody tell me why my hinet is being ignored Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?hrishy?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?hrishy?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L
Re: Oracle 9i refuses to allow client connection -- I need some help.
there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Computing resource consumption
Title: RE: Computing resource consumption So, how do you compute exactly how much CPU was used by user session? 'CPU used' will give you the work done by the session, but how about the work done by background processes for or on behalf of this session? How does on capture that? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Friday, July 25, 2003 1:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: Computing resource consumption There is also usual practice by some companies to charge by the CPU. Charge the customer $100 per user per CPU or $10,000 per CPU for unlimited number of users. That will bring the prices to the same level charged by some very successful software companies. You are bound to stay competitive. *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: Computing resource consumption
Title: RE: Computing resource consumption Thanks Cary, thanks, but here is a question ... you say capturing physical IO is redundant ... what about REDO generated by session? Isn't that part of physical writes? If I just concentrate on LIO (I am currently using Logical IO' (statistic#9 in 9202). Currently I am concentrating on following statistics to create a matrix 9 -- session logical reads 12 -- CPU used by this session 20 -- session pga memory 21 -- session pga memory max 42 -- physical reads 46 -- physical writes 115 -- redo size 236 -- bytes sent via SQL*Net to client 237 -- bytes received via SQL*Net from client not sure if all of them will matter in the end, but at-least it is a start for me. Another problem is capturing the work done by background processes on behalf of these sessions ... how does one go about capturing that workload?? Thanks in advance 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: Cary Millsap [mailto:[EMAIL PROTECTED]] Sent: Friday, July 25, 2003 1:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Computing resource consumption Raj, A pretty common (and actually pretty accurate) charge back unit is the LIO. You can get this information by using the standard AUDIT CONNECT feature, and using the LREAD value as your basis. If you wanted to get fancy, you might also charge by the parse call (which you're already collecting in your V$SESSTAT query). The reason I'd focus on these two metrics is because these are the two operations on an Oracle system that absolutely prevent the system from scaling. You could count physical I/Os as well, but that would be redundant if you're already catching LIO call counts. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Denver, Sydney - Hotsos Symposium 2004 March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jamadagni, Rajendra Sent: Thursday, July 24, 2003 12:04 PM To: Multiple recipients of list ORACLE-L Subject: Computing resource consumption Does anyone know any papers or techniques to compute resource consumption by users in a DB systems? This may or may not be for computing charge-back to the client, but my questions are 1. What do you compute? 2. are there any standard methods and or standard formula? I am collecting v$sesstat when a session exits, but is data alone from session stats sufficient? How about the work done by background processes on user's behalf? Do you do anything like this at your workplace? This is something that might be coming down the line, so I have been asked to start looking for related stuff. Thanks in advance 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 ! This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re[2]: Union quries: INTERSECT, MINUS, etc
Friday, July 25, 2003, 6:39:35 AM, you wrote: RC not very slick but I used MINUS yesterday to find parents with no RC children so as to purge them Offhand, I'd think you could do this without using MINUS. Maybe I'm wrong. But assuming there is a non-MINUS solution, what led you to choose to use MINUS? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]: Union quries: INTERSECT, MINUS, etc
Friday, July 25, 2003, 6:39:35 AM, Rachel wrote: RC not very slick but I used MINUS yesterday to find parents with no RC children so as to purge them Rachel, you make me very glad I have two kids. Please don't purge me, ok? grin Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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[2]: Union quries: INTERSECT, MINUS, etc
I'd purge myself first 'cause I don't have kids. Like the bad joke After I kill myself I'm turning the gun on you --- Jonathan Gennick [EMAIL PROTECTED] wrote: Friday, July 25, 2003, 6:39:35 AM, Rachel wrote: RC not very slick but I used MINUS yesterday to find parents with no RC children so as to purge them Rachel, you make me very glad I have two kids. Please don't purge me, ok? grin Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Union quries: INTERSECT, MINUS, etc
where will you publish this? Id like to read your results. From: Jonathan Gennick [EMAIL PROTECTED] Date: 2003/07/25 Fri AM 10:04:25 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re[2]: Union quries: INTERSECT, MINUS, etc Friday, July 25, 2003, 6:39:35 AM, Rachel wrote: RC not very slick but I used MINUS yesterday to find parents with no RC children so as to purge them Rachel, you make me very glad I have two kids. Please don't purge me, ok? grin Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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: Index Usage ?!
Hi! 25-07-2003 18:46:51, Irfan Khan [EMAIL PROTECTED] wrote: From what i understand when u analyze , use the keyword of size to set the histogram buckets Generally it should be no of distinct values in a column + som ball park no. say ten. Max nr. of buckets is 254 per column, thus in some conditions you can't have a bucket for each value. But more importantly, histograms aren't used with queries using bind values since during next query the bind variable could be set to completely different value and in order to compute a more appropriate execution plan we would have to go through the most expensive parse phase again. Also, when not using bind variables (which is a bad idea in OLTP because additional parses), using histograms makes each individual parse (which involves analyzing predicates on histogrammed columns) even slower. OTOH, histograms are good for processing the data in large quantities, but bad or even unusable in high concurrency OLTP environments. Of course maybe 10G already has some kind of pre-parsing enchancements where multiple execution plans are calculated for each possible bind variable value range (bucket). We'll see ;) Tanel. U can play around with this analyzing with histograms. I tried and it worked for me and so it should for you as well. I will do more research and will get back to you. Irfan , Khan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Re[2]: Union quries: INTERSECT, MINUS, etc
okay, I answered this offlist but... it started out as do we have a problem, indicated by records in the parent table with no children select id from parent minus select parentid from child that identified that we had a problem. next step (I'm a paranoid DBA when it comes to permanently deleting data from production) create holding_table as select * from parent where id in (select id from parent minus select parentid from child) last step delete from parent where id in select id from holding_table elegant? no. Fast? yes. And when I'm doing this 10 minutes before I'm supposed to leave for the day, fast is what I want :) I'm a BIG believer in plain vanilla coding. Slick is fine, but if I have to spend too much more time than the slick query saves me in creating it, it's not worth it. This is a one-off. --- Jonathan Gennick [EMAIL PROTECTED] wrote: Friday, July 25, 2003, 6:39:35 AM, you wrote: RC not very slick but I used MINUS yesterday to find parents with no RC children so as to purge them Offhand, I'd think you could do this without using MINUS. Maybe I'm wrong. But assuming there is a non-MINUS solution, what led you to choose to use MINUS? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Integration with IBM Mqueue series
One of our clients requirement is to replicate data from oracle to IBM mqueue series. We are 100% oracle shop and we do not have any IBM DB experience. Can anyone please shed some light on how this can be done ? Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rakesh Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 9i refuses to allow client connection -- I need
Stephen, I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding. I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the Oracle 101 books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to. I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date. Again, Welcome. Ron mª¿ªm [EMAIL PROTECTED] 07/25/03 08:59AM there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Integration with IBM Mqueue series
Try reading up about Oracle AQ, and particularly the JMS and translation related stuff with 9i AQ. IBM MQ series is a Messaging gateway for EAI integration, It has a number of competitors such as See Beyond, Tibco and MS Biztalk. In simple terms these systems take in a message and through translation rules read the message header and route it to another system, so your Oracle Applications can talk to the SAP system or the Peoplesoft system or our software via a single interface as the MQ server acts as the gateway. All adaptors are generally C++ or Java but not exclusively and the messages are XML Oracle has or did have a product called Interconnect built on AQ that was a competitor for MQ Series HTH Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Rakesh Gupta [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26-07-2003 12:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Integration with IBM Mqueue series One of our clients requirement is to replicate data from oracle to IBM mqueue series. We are 100% oracle shop and we do not have any IBM DB experience. Can anyone please shed some light on how this can be done ? Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rakesh Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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: Integration with IBM Mqueue series
It's MQSeries =8-) It's a form of MOM (Message Oriented Middleware). The thing that it most closely resembles in the Oracle world is Oracle Pipes...except that the a queue can be persistent...i.e. survive a reboot. I'm not familiar with Advanced Queue Option so maybe Oracle now has that feature too. Anyway...it makes no sense to 'replicate' to MQ since your data would only be placed on a message queue from the Oracle end. What would be interesting is what is done with the data after it is put on the queue. =8-) MQ ships with an API that allows you to programatically place messages and retrieve messages on to and from the queues. You would need to make these libraries known to the extproc interface to be able to do anything useful with them. More likely you would write some sort of interface (C,C++,VB,java) between inserted/updated data that could then reference these API's Of course, what is written to the queue is highly dependant on what is reading it from the other (Big BLue!) end...so you could be writing data, XML or even SQL to be read and processed from the other end. HTH Jeff Herrick On Fri, 25 Jul 2003, Rakesh Gupta wrote: One of our clients requirement is to replicate data from oracle to IBM mqueue series. We are 100% oracle shop and we do not have any IBM DB experience. Can anyone please shed some light on how this can be done ? Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rakesh Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Opinions on Oracle InterConnect
We have a new project kicking off and the vendor plans on implementing Oracle InterConnectfor Oracle Application Interfaces. Has anyone used this product? Are there other similar products out there? I have been told Oracle InterConnect is free. Will it work Asyncronously? Thanks for any insight on this product. Gene
Object types remote DB's
This I believe may end up as a No way from here, but here goes anyway. I've a developer who has created a function that returns a table type. We had to create the type and then a table of in this manner: create type gatekeeper_info as object (model_number varchar2(20), product_id integer, grade varchar2(1), test_description varchar2(70), gatekeeper_value varchar2(2), status varchar2(20)); / create or replace type gatekeeper_info_tbl as table of gatekeeper_info; / The function returns gatekeeper_info_tbl it works damned well if your logged onto that database. The problem is that they now want to access this function have it return data from a remote database. Consequently we're getting the ORA-30626 error message. Is there any way known to get around this? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- 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: Does the client hang or disconnect when the server's
Unfortunately, I am not running OPS or RAC. This is a failover-cluster -- if the primary node goes down, the database instance is started on the secondary node. I think Tanel is right that sqlnet.expire_time wouldn't apply. However, Tanel, I didn't understand the paragraph Also, sqlplus is different from normal telnet, because it tries to send a request only when it is on it's prompt, thus issuing a command in sqlplus session, when it is waiting for response from previous command, doesn't send any network packets. Would I be right in understand it to mean that when waiting for a response from the database server, sqlplus doesn't send any network packets. however, if sqlplus is sitting idle and a user enters a command sqlplus attempts to send the request and only then knows that the database or node is down ? So, if my session were sending a fresh request, it would know that the server was unavailable and would return an error [3113 ?] but if it were waiting for a response [last issued an INSERT statement and is waiting for the ACK packet] it would just sit there waiting ? Hemant At 10:04 AM 24-07-03 -0800, you wrote: I agree sqlnet.expire_time does only effect the server, but normally when the server kills the connection the client side will drop. But in this case it won't because there is no network for the client to get the dead connection timeout from the server. It sounds like Hemant is running OPS which AFAIK (version 7.3) he is getting the expected behavior, to get the client to seemlessly switch over to the other instance he needs RAC (again AFAIK). Tanel Poder tanel.poder.003@To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mail.ee cc: Sent by: Subject: Re: Does the client hang or disconnect when the server's [EMAIL PROTECTED] .com 07/24/2003 12:19 PM Please respond to ORACLE-L Hi! This sqlnet.expire_time affects server, not sqlplus itself AFAIK. The issue is likely, that sqlplus has sent a sqlnet request to server, but hasn't got any response since you pulled the network cable. Thus it'll wait until TCP connection gets timeout. Also, sqlplus is different from normal telnet, because it tries to send a request only when it is on it's prompt, thus issuing a command in sqlplus session, when it is waiting for response from previous command, doesn't send any network packets. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 24, 2003 6:54 PM Hemant, You are right it does get a timeout from the TCP stack, but the default for the connection timeout is 30 minutes. There is a sqlnet parameter where you can modify the timeout to make it shorter (sqlnet.expire_time?) Check metalink note 151972.1 for more info. HTH Mike Hemant K Chitale [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .com.sg cc: Sent by: Subject: Does the client hang or disconnect when the server's [EMAIL PROTECTED] .com 07/24/2003 11:24 AM Please respond to ORACLE-L I'm sorry, but I really can't remember how an Oracle SQLPlus client is supposed to behave when the database server's network interface is pulled out. We were testing a new Sun Cluster and tests for Storage FC Path Failure, Instance Failure, Node Failure, HeartBeat failure and single Network Interface failure all went through. However, when the engineer pulled out *both* network interfaces of the running database server node, the SQLPlus client that had been running INSERT statements just hung. It did not exit or error out till we killed the job. At the next restart, of course, it connected to the database which had already failed-over to the second node. The question is : Why does the SQLPlus client hang ? Telnet sessions also might hang [couldnt' test this out as the Servers are Secured and we didn't have SSH on the client], till the user hits the ENTER key, but shouldn't SQLPlus get server disconnect from the TCP stack ? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Re[2]: Union quries: INTERSECT, MINUS, etc
Love it classic execution of KISS, no bull it just works and quick and efficient Waiting for my plane home from Perth Have a good weekend as its Friday night here Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26-07-2003 12:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Re[2]: Union quries: INTERSECT, MINUS, etc okay, I answered this offlist but... it started out as do we have a problem, indicated by records in the parent table with no children select id from parent minus select parentid from child that identified that we had a problem. next step (I'm a paranoid DBA when it comes to permanently deleting data from production) create holding_table as select * from parent where id in (select id from parent minus select parentid from child) last step delete from parent where id in select id from holding_table elegant? no. Fast? yes. And when I'm doing this 10 minutes before I'm supposed to leave for the day, fast is what I want :) I'm a BIG believer in plain vanilla coding. Slick is fine, but if I have to spend too much more time than the slick query saves me in creating it, it's not worth it. This is a one-off. --- Jonathan Gennick [EMAIL PROTECTED] wrote: Friday, July 25, 2003, 6:39:35 AM, you wrote: RC not very slick but I used MINUS yesterday to find parents with no RC children so as to purge them Offhand, I'd think you could do this without using MINUS. Maybe I'm wrong. But assuming there is a non-MINUS solution, what led you to choose to use MINUS? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing:
Re: Update through a DBLink
I can only say that with a rather basic type of update across a dblink we had a problem with it inserting two records, it was done with a trigger will all the code within the trigger, so this could be related, we made a work around to check for the record before trying to insert it Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. John Shaw [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 25-07-2003 02:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Update through a DBLink There is or at least was a problem if you had a autonomous transaction across a dblink with a commit. [EMAIL PROTECTED] 7/24/2003 10:59:27 AM One of or developers is work on a routine that will trigger a procedure that will use a dblink to update a table on another database. It seems like I remember that something about a problem with procedures, dblinks, updates? Does anyone remember anything about that? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Question about EXTPROC and vulnerability
Oracle's Security Alert #29 [Note 175429.1] on the EXTPROC recommends the workaround to disable EXTPROC as 1. Removing the entry for extproc/PLSExtproc/icache_extproc from the listener.ora 2. Removing the entry from the tnsnames.ora 3. Renaming or removing the extproc executable Why should all three actions be necessary ? Why not just removing the entry from the listener.ora ? Can extproc be called without the listener configured ? Security Alert #57 just talks of the CREATE LIBRARY privilege and makes no mention of updating the listener.ora or tnsnames.ora or removing/renaming the extproc executable. Why ? Is it that Oracle wants people to use EXTPROC [or makes use of EXTPROC itself] so it does not specify how EXTPROC can be disabled ? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Does the client hang or disconnect when the server's
Hi! Actually it seems that as long as the network (TCP) connection is up at OS level, Oracle is just gonna wait for reply for it's packets sent. So, probably no 3113 error before OS drops the TCP connection (if sqlplus or OCI doesn't have some kind of timeout implemented). Sorry about confusion... I tested sending new request with sqlplus, by logging on as system and suspending, not killing my server process (this way OS doesn't clear the TCP connection): SQL select server from v$session where username = 'SYSTEM'; SERVER - DEDICATED SQL select p.spid from v$session s, v$process p where s.paddr = p.addr and s.username = 'SYSTEM'; SPID - 3961 SQL !kill -23 3961 SQL select * from dual; ^C ^C ^C kill -23 means killing with SIGSTOP in Solaris and after that my next request waited indefinetly (at least for 10 minutes after which I continued the process with kill -25). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 25, 2003 6:24 PM Unfortunately, I am not running OPS or RAC. This is a failover-cluster -- if the primary node goes down, the database instance is started on the secondary node. I think Tanel is right that sqlnet.expire_time wouldn't apply. However, Tanel, I didn't understand the paragraph Also, sqlplus is different from normal telnet, because it tries to send a request only when it is on it's prompt, thus issuing a command in sqlplus session, when it is waiting for response from previous command, doesn't send any network packets. Would I be right in understand it to mean that when waiting for a response from the database server, sqlplus doesn't send any network packets. however, if sqlplus is sitting idle and a user enters a command sqlplus attempts to send the request and only then knows that the database or node is down ? So, if my session were sending a fresh request, it would know that the server was unavailable and would return an error [3113 ?] but if it were waiting for a response [last issued an INSERT statement and is waiting for the ACK packet] it would just sit there waiting ? Hemant At 10:04 AM 24-07-03 -0800, you wrote: I agree sqlnet.expire_time does only effect the server, but normally when the server kills the connection the client side will drop. But in this case it won't because there is no network for the client to get the dead connection timeout from the server. It sounds like Hemant is running OPS which AFAIK (version 7.3) he is getting the expected behavior, to get the client to seemlessly switch over to the other instance he needs RAC (again AFAIK). Tanel Poder tanel.poder.003@To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mail.ee cc: Sent by: Subject: Re: Does the client hang or disconnect when the server's [EMAIL PROTECTED] .com 07/24/2003 12:19 PM Please respond to ORACLE-L Hi! This sqlnet.expire_time affects server, not sqlplus itself AFAIK. The issue is likely, that sqlplus has sent a sqlnet request to server, but hasn't got any response since you pulled the network cable. Thus it'll wait until TCP connection gets timeout. Also, sqlplus is different from normal telnet, because it tries to send a request only when it is on it's prompt, thus issuing a command in sqlplus session, when it is waiting for response from previous command, doesn't send any network packets. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 24, 2003 6:54 PM Hemant, You are right it does get a timeout from the TCP stack, but the default for the connection timeout is 30 minutes. There is a sqlnet parameter where you can modify the timeout to make it shorter (sqlnet.expire_time?) Check metalink note 151972.1 for more info. HTH Mike Hemant K Chitale [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .com.sg cc: Sent by: Subject: Does the client hang or disconnect when the server's [EMAIL PROTECTED] .com 07/24/2003 11:24 AM Please respond to ORACLE-L I'm sorry, but I really can't remember how an Oracle SQLPlus client is supposed to behave when the database server's network interface is pulled out. We were
RE: Integration with IBM Mqueue series
Have no experience with it, but Oracle does have a procedural gateway to IBM MQseries. I've a copy of V8.0.4.1 that came in my 8.1.7 RDBMS pack. Probably separately licensed. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 25, 2003 10:54 AM To: Multiple recipients of list ORACLE-L One of our clients requirement is to replicate data from oracle to IBM mqueue series. We are 100% oracle shop and we do not have any IBM DB experience. Can anyone please shed some light on how this can be done ? Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rakesh Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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: Union quries: INTERSECT, MINUS, etc
There's nothing like a good high colonic to make you want to have kids! -Original Message- not very slick but I used MINUS yesterday to find parents with no children so as to purge them -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Computing resource consumption
Title: RE: Computing resource consumption You have a good point. Id expect that most bg workload performed on behalf of a session is probably writes, so measuring redo generation might be an excellent addition. It also encourages users (and hence, indirectly, applications developers) to be economical with their redo generation, which is good too. (One example of an application that generates redo when it doesnt need to is an UPDATE that changes a column to a value it already had.) Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic101 in Denver, Sydney - Hotsos Symposium 2004 March 710 Dallas - Visit www.hotsos.com for schedule details... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jamadagni, Rajendra Sent: Friday, July 25, 2003 8:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: Computing resource consumption Thanks Cary, thanks, but here is a question ... you say capturing physical IO is redundant ... what about REDO generated by session? Isn't that part of physical writes? If I just concentrate on LIO (I am currently using Logical IO' (statistic#9 in 9202). Currently I am concentrating on following statistics to create a matrix 9 -- session logical reads 12 -- CPU used by this session 20 -- session pga memory 21 -- session pga memory max 42 -- physical reads 46 -- physical writes 115 -- redo size 236 -- bytes sent via SQL*Net to client 237 -- bytes received via SQL*Net from client not sure if all of them will matter in the end, but at-least it is a start for me. Another problem is capturing the work done by background processes on behalf of these sessions ... how does one go about capturing that workload?? Thanks in advance 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: Cary Millsap [mailto:[EMAIL PROTECTED]] Sent: Friday, July 25, 2003 1:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Computing resource consumption Raj, A pretty common (and actually pretty accurate) charge back unit is the LIO. You can get this information by using the standard AUDIT CONNECT feature, and using the LREAD value as your basis. If you wanted to get fancy, you might also charge by the parse call (which you're already collecting in your V$SESSTAT query). The reason I'd focus on these two metrics is because these are the two operations on an Oracle system that absolutely prevent the system from scaling. You could count physical I/Os as well, but that would be redundant if you're already catching LIO call counts. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Denver, Sydney - Hotsos Symposium 2004 March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jamadagni, Rajendra Sent: Thursday, July 24, 2003 12:04 PM To: Multiple recipients of list ORACLE-L Subject: Computing resource consumption Does anyone know any papers or techniques to compute resource consumption by users in a DB systems? This may or may not be for computing charge-back to the client, but my questions are 1. What do you compute? 2. are there any standard methods and or standard formula? I am collecting v$sesstat when a session exits, but is data alone from session stats sufficient? How about the work done by background processes on user's behalf? Do you do anything like this at your workplace? This is something that might be coming down the line, so I have been asked to start looking for related stuff. Thanks in advance 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 !
Re: Integration with IBM Mqueue series
I thinks Oracle Streams in 9i does the same thing. Please check for doc on otn or metalink. I attended a workshop on Oracle Streams in NJ yesterday and presenter was Indy Johal. A nice presentation. It may be placed at www.njoug.org. He is also going to present it in Oracle OPENWorld in SEP 2003. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 25 Jul 2003 07:19:24 -0800 Try reading up about Oracle AQ, and particularly the JMS and translation related stuff with 9i AQ. IBM MQ series is a Messaging gateway for EAI integration, It has a number of competitors such as See Beyond, Tibco and MS Biztalk. In simple terms these systems take in a message and through translation rules read the message header and route it to another system, so your Oracle Applications can talk to the SAP system or the Peoplesoft system or our software via a single interface as the MQ server acts as the gateway. All adaptors are generally C++ or Java but not exclusively and the messages are XML Oracle has or did have a product called Interconnect built on AQ that was a competitor for MQ Series HTH Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Rakesh Gupta [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26-07-2003 12:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Integration with IBM Mqueue series One of our clients requirement is to replicate data from oracle to IBM mqueue series. We are 100% oracle shop and we do not have any IBM DB experience. Can anyone please shed some light on how this can be done ? Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rakesh Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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). _ Add photos to your e-mail 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: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Union quries: INTERSECT, MINUS, etc
Jonathan, We use MINUS technique heavily in our DW environment to get the source system changes since we last extracted. We do 2-way minus (src to ods and ods to src). Best Regards, Prasad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Question about the list
The answer lies in every mail sent to the list: To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Read the above CAREFULLY! With the HELP sent to the correct address, my guess is that you'd be able to find the command that would allow you to see that your own posts are not sent back to you. It's just a guess... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Guido Konsolke [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 1:00 AM To: Multiple recipients of list ORACLE-L Subject: RE: Question about the list Hi Tanel, you took the words right out of my mouth (anyone recognizing the song?). The same at my place. I tend to think it's a kind of mystery. Answers whithout questions, answers don't appear to be send... But I'm too tired to think about it. As I'm writing this, it's 7 AM here in Germany. Big application launch this weekend. So much work to do. 8-(( Greetings, Guido -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RAC - Configuring Disk Coordinator
- Configuration - Should each of these 3 LUN be on seperate disks?- What is the smallest LUN that Hitachi 9570V can be? I guess I can ask our rep if no ones knows.-Should these LUNs be mirrored? - Coordinator disks are used to support IO fencing can anyone elborate how this happens? Thanks in advance, Lizz Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
RE: sqlnet.expire_time
Hi there, I was just wondering if you change the values in the sqlnet.ora file do you need to bounce the database?? I have looked up the documentation but it does n't mention it so I just wanted to make sure - no point in changing things if the database does not realise that you have changed certain parameters. Thanks, N. :--Original Message- :-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :-Behalf Of :-Schauss, Peter :-Sent: 23 July 2003 22:15 :-To: Multiple recipients of list ORACLE-L :-Subject: sqlnet.expire_time :- :- :-I am trying to use the sqlnet.expire_time parameter in :-my sqlnet.ora file to kill connections from dead processes. :-The entry looks like this: :- :-SQLNET.EXPIRE_TIME=10 :- :- :-It does not seem to be working. Any ideas. :- :-Oracle 8.1.7 :-AIX 4.3.3 :-Client is on w2k. :- :-Thanks, :-Peter Schauss :--- :-Please see the official ORACLE-L FAQ: http://www.orafaq.net :--- :-Author: Schauss, Peter :- INET: [EMAIL PROTECTED] :- :-Fat City Network Services-- 858-538-5051 http://www.fatcity.com :-San Diego, California-- Mailing list and web hosting services :-- :-To REMOVE yourself from this mailing list, send an E-Mail message :-to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in :-the message BODY, include a line containing: UNSUB ORACLE-L :-(or the name of mailing list you want to be removed from). You may :-also send the HELP command for other information (like subscribing). :- :- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuala Cullen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dbms_job
Hello list, I am running 9.2.0.1.0 enterprise edition on win32. Why doesn't the Supplied PLSQL Packages and Types Reference docs mention dbms_system ? It doesn't seem to be explained anywhere in the docs although the admin docs say that it can be used enable sql_trace for another session. I was able to do that only after learning about its parameters thru : sql describe dbms_system while I was logged in as sysdba. .. -- 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).
DBMS_SHARED_POOL
Hello list, 1. Can the following statement be executed sucessfully only by the sysdba ? EXECUTE DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD (25165824 ) ; 2. ?\rdbms\admin\dbmspool.sql creates dbms_shared_pool . And it explicitly grants execute on dbms_shared_pool to execute_catalog_role. Still I cannot run the above statement when connected as system/manager on my 9.2.0.1.0 enterprise edn on windows. I get the following errors : SQL sho user USER is SYSTEM SQL EXECUTE DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( 25165824 ) ; BEGIN DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( 31457280 ) ; END; * ERROR at line 1: ORA-04068: existing state of packages has been discarded ORA-04063: package body SYSTEM.DBMS_SHARED_POOL has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1 3. However When I run as sysdba, no problems SQL sho user USER is SYS SQL EXECUTE DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( 25165824 ) ; PL/SQL procedure successfully completed. Any ideas ? -- 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: Question about the list
No, only few of my posts don't make it back to my mailbox. I don't think that the listserver has an option trash random messages at will ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 25, 2003 7:49 PM The answer lies in every mail sent to the list: To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Read the above CAREFULLY! With the HELP sent to the correct address, my guess is that you'd be able to find the command that would allow you to see that your own posts are not sent back to you. It's just a guess... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Guido Konsolke [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 1:00 AM To: Multiple recipients of list ORACLE-L Subject: RE: Question about the list Hi Tanel, you took the words right out of my mouth (anyone recognizing the song?). The same at my place. I tend to think it's a kind of mystery. Answers whithout questions, answers don't appear to be send... But I'm too tired to think about it. As I'm writing this, it's 7 AM here in Germany. Big application launch this weekend. So much work to do. 8-(( Greetings, Guido -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: RAC - Configuring Disk Coordinator
Sorry all my message got hacked here is the first paragraph Going through the Veritas installation guide (pg 47) and I have a question on the required 3 LUN creation needed to support RAC for Veritas DBE/AC, when setting up Disk Coordinator:laura pena [EMAIL PROTECTED] wrote: - Configuration - Should each of these 3 LUN be on seperate disks?- What is the smallest LUN that Hitachi 9570V can be? I guess I can ask our rep if no ones knows.-Should these LUNs be mirrored? - Coordinator disks are used to support IO fencing can anyone elborate how this happens? Thanks in advance, Lizz Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
RE: dbms_job
It would seem that dbms_system has become undocumented. It used to be partially documented, e.g. there was a description of set_sql_trace_in_session, but they seem to have pulled that as of 8.1. You're supposed to use dbms_support now, but that too seems to be undocumented. At least on Solaris, you have to beg support for the 8i install script, but the 9i install script is included in $ORACLE_HOME/rdbms/admin. There are some notes about this in some of the forums at metalink ( I searched 'dbms_system dbms_support'). HTH, -Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: dbms_job Hello list, I am running 9.2.0.1.0 enterprise edition on win32. Why doesn't the Supplied PLSQL Packages and Types Reference docs mention dbms_system ? It doesn't seem to be explained anywhere in the docs although the admin docs say that it can be used enable sql_trace for another session. I was able to do that only after learning about its parameters thru : sql describe dbms_system while I was logged in as sysdba. .. LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAC - Configuring Disk Coordinator
Title: Message To answer your questions. 1) Ideally, yes, though they don't need to be. 2) Absolutely. Veritas will get very unhappy if it loses access to those disks 3) SCSI-3 Persistent Reservation. When a node "malfunctions", another node will issue a SCSI-3 reservation against the 3 coordinator disks. When the broken node tries to access those disks (as it does every few seconds normally) it will be rejected and the box will panic (I'm pretty sure it panics - test it) Feel free to email me off-list if you have any other questions. Thanks, Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of laura penaSent: Friday, July 25, 2003 1:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: RAC - Configuring Disk Coordinator Sorry all my message got hacked here is the first paragraph Going through the Veritas installation guide (pg 47) and I have a question on the required 3 LUN creation needed to support RAC for Veritas DBE/AC, when setting up Disk Coordinator:laura pena [EMAIL PROTECTED] wrote: - Configuration - Should each of these 3 LUN be on seperate disks?- What is the smallest LUN that Hitachi 9570V can be? I guess I can ask our rep if no ones knows.-Should these LUNs be mirrored? - Coordinator disks are used to support IO fencing can anyone elborate how this happens? Thanks in advance, Lizz Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software
RE: RAC - Configuring Disk Coordinator
Title: Message Whoops - I missed a question in there. Smallest lun possible? On the older HDS thunder systems, you can make teeny-tiny luns - I'm guessing the 9570V is the same way. Make a raid group and carve a few small luns out of it. Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew ZitoSent: Friday, July 25, 2003 1:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RAC - Configuring Disk Coordinator To answer your questions. 1) Ideally, yes, though they don't need to be. 2) Absolutely. Veritas will get very unhappy if it loses access to those disks 3) SCSI-3 Persistent Reservation. When a node "malfunctions", another node will issue a SCSI-3 reservation against the 3 coordinator disks. When the broken node tries to access those disks (as it does every few seconds normally) it will be rejected and the box will panic (I'm pretty sure it panics - test it) Feel free to email me off-list if you have any other questions. Thanks, Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of laura penaSent: Friday, July 25, 2003 1:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: RAC - Configuring Disk Coordinator Sorry all my message got hacked here is the first paragraph Going through the Veritas installation guide (pg 47) and I have a question on the required 3 LUN creation needed to support RAC for Veritas DBE/AC, when setting up Disk Coordinator:laura pena [EMAIL PROTECTED] wrote: - Configuration - Should each of these 3 LUN be on seperate disks?- What is the smallest LUN that Hitachi 9570V can be? I guess I can ask our rep if no ones knows.-Should these LUNs be mirrored? - Coordinator disks are used to support IO fencing can anyone elborate how this happens? Thanks in advance, Lizz Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software
[Q] how to make Develper 6i talk to ORACLE 8i client??
ORACLE Developer 6i come with ORACLE 8.0.6 client sql*net. Does their has way to make Developer 6i use ORACLE 8i (8.1.7) sql*net or NOT? Thanks. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Anyone using onames on win2k server + 8.1.7 ?
All Ive gone round and round with a new install of 8.17 and getting names to work. Initially when a name server was greated and upi opend the NET8 config, it would crash Searching metalink provided the needed patches 1,2,3,4 Aplied all in sequence without errors Import large tnsfile into names, save config and exit All the instances can be querried through the name server both locally (on the machine) and remotely However When the service restarts, or machine reboots all configuration is lost Searched metalnk and diddnt comeup with too much. I opned a TAR and was suggested to move to 9.x Well, Ive spent so much time on this and I need to maintain the 8.1.x version for this particullar server So, my question is anyone using onames on win2k server 8.1.7 My banner is as follows SQL*Plus: Release 8.1.7.0.0 - Production on Fri Jul 25 13:37:17 2003 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production With the Partitioning option JServer Release 8.1.7.4.1 - Production Input truncated to 14 characters [EMAIL PROTECTED] - Thanks and have a good weekend bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: [Q] how to make Develper 6i talk to ORACLE 8i client??
It's been awhile since I worked on this - but I think you can trick it if you make a copy of your net8 directory and name it network. [EMAIL PROTECTED] 7/25/2003 2:39:24 PM ORACLE Developer 6i come with ORACLE 8.0.6 clientsql*net. Does their has way to make Developer 6i useORACLE 8i (8.1.7) sql*net or NOT?Thanks.__Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design softwarehttp://sitebuilder.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: mike mon INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.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).
Emacs on SQLPlus, er uh... SQLPlus on emacs.
vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
massive generalization It seems like DBAs that use Emacs over vi (emacs vs. vi being the classic UNIX holy war) tend to be people who were introduced to UNIX by being either a developer or an end-user. If a DBA favors vi over emacs, it seems that they generally come from a sysadmin background. That's how I ended up a vi user - none of the systems I was ever working on could be counted to have any editor OTHER than vi. For better or worse, its the ubiquitous UNIX text editor. /massive generalization Of course, there are those who use notepad + ftp Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Orr, Steve Sent: Friday, July 25, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Emacs on SQLPlus, er uh... SQLPlus on emacs.
My editor of choice is UltraEdit-32 from IDM, especially since the intergrated FTP into the editor. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 25, 2003 4:24 PM To: Multiple recipients of list ORACLE-L massive generalization It seems like DBAs that use Emacs over vi (emacs vs. vi being the classic UNIX holy war) tend to be people who were introduced to UNIX by being either a developer or an end-user. If a DBA favors vi over emacs, it seems that they generally come from a sysadmin background. That's how I ended up a vi user - none of the systems I was ever working on could be counted to have any editor OTHER than vi. For better or worse, its the ubiquitous UNIX text editor. /massive generalization Of course, there are those who use notepad + ftp Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Orr, Steve Sent: Friday, July 25, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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: Emacs on SQLPlus, er uh... SQLPlus on emacs.
snip Of course, there are those who use notepad + ftp That's me. ggg v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- 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: dbms_job
Hi The package dbms_system is now private, the body and header are both created in $ORACLE_HOME/rdbms/admin/prvtutil.plb. The sql file $ORACLE_HOME/rdbms/admin/dbmsutil.sql has the following in it now: Rem dbms_system - database system level commands (moved to Rem prvtutil.sql for more obscurity) kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Hi I use vi on Unix and textpad on windoze. I like to write macros for vi so it types repetitive code for me...:-), although I should probably use an editor with more powerful macro facilities. cheers Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dbms_job
Title: RE: dbms_job www.orafaq.com/papers/dbms_sys.doc 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: Pete Finnigan [mailto:[EMAIL PROTECTED]] Sent: Friday, July 25, 2003 5:14 PM To: Multiple recipients of list ORACLE-L Subject: Re: dbms_job Hi The package dbms_system is now private, the body and header are both created in $ORACLE_HOME/rdbms/admin/prvtutil.plb. The sql file $ORACLE_HOME/rdbms/admin/dbmsutil.sql has the following in it now: Rem dbms_system - database system level commands (moved to Rem prvtutil.sql for more obscurity) kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: Emacs on SQLPlus, er uh... SQLPlus on emacs.
For Windows work, I love UltraEdit. For *nix work, vi(m)'s the ticket. -- Dwayne Cox Corporate Database Administrator Info Tech, Inc. 5700 SW 34th Street, Suite 1235 Gainesville, FL 32608 email: [EMAIL PROTECTED] phone: 352.381.4521 fax: 352.381. Goulet, Dick wrote: My editor of choice is UltraEdit-32 from IDM, especially since the intergrated FTP into the editor. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 25, 2003 4:24 PM To: Multiple recipients of list ORACLE-L massive generalization It seems like DBAs that use Emacs over vi (emacs vs. vi being the classic UNIX holy war) tend to be people who were introduced to UNIX by being either a developer or an end-user. If a DBA favors vi over emacs, it seems that they generally come from a sysadmin background. That's how I ended up a vi user - none of the systems I was ever working on could be counted to have any editor OTHER than vi. For better or worse, its the ubiquitous UNIX text editor. /massive generalization Of course, there are those who use notepad + ftp Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Orr, Steve Sent: Friday, July 25, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Dwayne Cox Corporate Database Administrator Info Tech, Inc. 5700 SW 34th Street, Suite 1235 Gainesville, FL 32608 email: [EMAIL PROTECTED] phone: 352.381.4521 fax: 352.381. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anyone using onames on win2k server + 8.1.7 ?
We don't do windows here... but the 9.2 names server works just fine with all our 8.1.7.4 databases under unix. 9.2 names also does seam to be more stable than the 8.1.7 version. Just food for thought... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] om To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Anyone using onames on win2k server + 8.1.7 ? .com 07/25/2003 01:54 PM Please respond to ORACLE-L All Ive gone round and round with a new install of 8.17 and getting names to work. Initially when a name server was greated and upi opend the NET8 config, it would crash Searching metalink provided the needed patches 1,2,3,4 Aplied all in sequence without errors Import large tnsfile into names, save config and exit All the instances can be querried through the name server both locally (on the machine) and remotely However When the service restarts, or machine reboots all configuration is lost Searched metalnk and diddnt comeup with too much. I opned a TAR and was suggested to move to 9.x Well, Ive spent so much time on this and I need to maintain the 8.1.x version for this particullar server So, my question is anyone using onames on win2k server 8.1.7 My banner is as follows SQL*Plus: Release 8.1.7.0.0 - Production on Fri Jul 25 13:37:17 2003 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production With the Partitioning option JServer Release 8.1.7.4.1 - Production Input truncated to 14 characters [EMAIL PROTECTED] - Thanks and have a good weekend bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Q] how to make Develper 6i talk to ORACLE 8i client??
The 8.0.6 client works just fine with 8.1.7 databases. Why do you want to make developer 6i use 8.1.7? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: [Q] how to make Develper 6i talk to ORACLE 8i client?? 07/25/2003 01:39 PM Please respond to ORACLE-L ORACLE Developer 6i come with ORACLE 8.0.6 client sql*net. Does their has way to make Developer 6i use ORACLE 8i (8.1.7) sql*net or NOT? Thanks. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Title: RE: Emacs on SQLPlus, er uh... SQLPlus on emacs. vi for unix ... vim for windows 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: Dwayne Cox [mailto:[EMAIL PROTECTED]] Sent: Friday, July 25, 2003 5:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: Emacs on SQLPlus, er uh... SQLPlus on emacs. For Windows work, I love UltraEdit. For *nix work, vi(m)'s the ticket. -- Dwayne Cox Corporate Database Administrator Info Tech, Inc. 5700 SW 34th Street, Suite 1235 Gainesville, FL 32608 email: [EMAIL PROTECTED] phone: 352.381.4521 fax: 352.381. Goulet, Dick wrote: My editor of choice is UltraEdit-32 from IDM, especially since the intergrated FTP into the editor. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 25, 2003 4:24 PM To: Multiple recipients of list ORACLE-L massive generalization It seems like DBAs that use Emacs over vi (emacs vs. vi being the classic UNIX holy war) tend to be people who were introduced to UNIX by being either a developer or an end-user. If a DBA favors vi over emacs, it seems that they generally come from a sysadmin background. That's how I ended up a vi user - none of the systems I was ever working on could be counted to have any editor OTHER than vi. For better or worse, its the ubiquitous UNIX text editor. /massive generalization Of course, there are those who use notepad + ftp Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Orr, Steve Sent: Friday, July 25, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Dwayne Cox Corporate Database Administrator Info Tech, Inc. 5700 SW 34th Street, Suite 1235 Gainesville, FL 32608 email: [EMAIL PROTECTED] phone: 352.381.4521 fax: 352.381. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: dbms_job
Thanks pete - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, July 26, 2003 02:44 Hi The package dbms_system is now private, the body and header are both created in $ORACLE_HOME/rdbms/admin/prvtutil.plb. The sql file $ORACLE_HOME/rdbms/admin/dbmsutil.sql has the following in it now: Rem dbms_system - database system level commands (moved to Rem prvtutil.sql for more obscurity) kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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).
Advice needed on dbms_shared_pool value
Hello list I needed your advice on the following : 1. What value do you all specify in DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( value ) ? (1.a.) Should it be set equal to the shared_pool_size ? (1.b.) Should it be greater than shared_pool_size ? (But wouldn't that be impossible. The free list would not be able to service a user request for a size greater than the shared_pool_size) (1.c) Should it be set equal to shared_pool_size minus shared_pool_reserved_size. ( I am not clear on this . Please tell me : can the free list service a request by taking space from the reserved area AND the rest of shared pool or is it 'one or the other and not both together' ) 2. After sucessfully executing DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( value ) (2.a) why doesn't the 'value' show up in select aborted_request_threshold from v$shared_pool_reserved ; ? (2.b) Where would I look to see the change ? -- 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: [Q] how to make Develper 6i talk to ORACLE 8i client??
the 8.0.6 client also works with 9.2 -Original Message- Ron Thomas Sent: Friday, July 25, 2003 5:50 PM To: Multiple recipients of list ORACLE-L The 8.0.6 client works just fine with 8.1.7 databases. Why do you want to make developer 6i use 8.1.7? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] Sent by: To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .com Subject: [Q] how to make Develper 6i talk to ORACLE 8i client?? 07/25/2003 01:39 PM Please respond to ORACLE-L ORACLE Developer 6i come with ORACLE 8.0.6 client sql*net. Does their has way to make Developer 6i use ORACLE 8i (8.1.7) sql*net or NOT? Thanks. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Blake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dbms_job
Thanks chris. Let me know if you find out anything more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 25, 2003 23:39 It would seem that dbms_system has become undocumented. It used to be partially documented, e.g. there was a description of set_sql_trace_in_session, but they seem to have pulled that as of 8.1. You're supposed to use dbms_support now, but that too seems to be undocumented. At least on Solaris, you have to beg support for the 8i install script, but the 9i install script is included in $ORACLE_HOME/rdbms/admin. There are some notes about this in some of the forums at metalink ( I searched 'dbms_system dbms_support'). HTH, -Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: dbms_job Hello list, I am running 9.2.0.1.0 enterprise edition on win32. Why doesn't the Supplied PLSQL Packages and Types Reference docs mention dbms_system ? It doesn't seem to be explained anywhere in the docs although the admin docs say that it can be used enable sql_trace for another session. I was able to do that only after learning about its parameters thru : sql describe dbms_system while I was logged in as sysdba. .. LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [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: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Steve - I've used Unix for many years at many different sites, mostly with large development staffs. In that time, I've only encountered one emacs user. He said that emacs had many capabilities, but they struggled several months getting it even semi-functional. I'm not sure they had it working when I left, at least he was too frustrated to gloat. Mostly I've seen people use something better than vi. If your site uses a GUI interface like X-Windows, then there will be a GUI editor. Currently people that wish to avoid vi tend to copy and paste over to Notepad. On my first Unix assignment I was doing documentation. So I decided to write documents on vi. Turns out vi has some great word processing features, like word wrap. Anyway I used that assignment to learn vi really well and that has paid off really well over the years. As I said, every site has had something better than vi, but that something has always been different and vi never changes. Why tamper with perfection? ;-) Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, July 25, 2003 3:10 PM To: Multiple recipients of list ORACLE-L vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Question about the list
you took the words right out of my mouth (anyone recognizing the song?). Indeed, but there's no way I'm kissing you :( Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
I use MicroEMACS almost every day, albeit on my Amiga (or now on my UAE Amiga emulator) to edit webpages and not really for DBA work. Hey, us obnoxious Amigans have to get in every plug we can! :) CTRL-XCTRL-F Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle on linux vs. on windows
Title: Message When I eventually found the source article http://www.interealm.com/technotes/roby/pentmark.html, it seemed to me that there were some problems with it. 1. It said the two OS and databases were 'similarly' configured but didn't show what the configuration was. 2. It states that Windows 2000 does not support mount points and so OFA cannot be used. This is incorrect. 3. I waasn't sure how much weight as given to Linux as a Unix alike system being similar to Unix systems. This seems to be a daft comparison. 4. it wasn't clear how the conclusions (use Linux where you don't use clustering - use windows if you don't need to scale) came from the tests. Otherwise it seemed a fair comparison of apples to oranges :( Niall -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boivin, Patrice JSent: 24 July 2003 13:34To: Multiple recipients of list ORACLE-LSubject: Oracle on linux vs. on windows I found this item on the 'net this morning: http://rootprompt.org/article.php3?article=5475 Patrice.
Re: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Our servers (AIX/HP) don't even have emacs on it. Use vi for small stuff otherwise I fall into the ftp with windows environment to work. I use CodeWright. From: Orr, Steve [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. Date: Fri, 25 Jul 2003 12:09:36 -0800 vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your e-mail 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: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle links web page gone -- bummer!
Anyone have a copy of the contents of: http://web.singnet.com.sg/~petermag/oracle.html ..posted somewhere else? I *knew* I should have made a local copy, but didn't want to deal with maintaining it. :( Off to have a weekend... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
I agree with the developer vs. sysadmin generalization but this was not meant to be a post about favorite editors... It's about whether anyone has used or seen a SQLPlus shell running under emacs. Has anyone witnessed SQLPlus running under a well-configured emacs session and have impressions to share? The statistics I've heard are that 9 out of 10 SysAdmin/DBA's use vi. I wonder what the breakdown is for Linux admins? Since emacs is easy to implement I could see it gaining ground on Linux but sometimes old dinosaur type SysAdmins are slow to evolve. :-) Steve Orr-asaurus, with apologies to Don G. -Original Message- Sent: Friday, July 25, 2003 2:24 PM To: Multiple recipients of list ORACLE-L massive generalization It seems like DBAs that use Emacs over vi (emacs vs. vi being the classic UNIX holy war) tend to be people who were introduced to UNIX by being either a developer or an end-user. If a DBA favors vi over emacs, it seems that they generally come from a sysadmin background. That's how I ended up a vi user - none of the systems I was ever working on could be counted to have any editor OTHER than vi. For better or worse, its the ubiquitous UNIX text editor. /massive generalization Of course, there are those who use notepad + ftp Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Orr, Steve Sent: Friday, July 25, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Emacs on SQLPlus, er uh... SQLPlus on emacs. vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Integration with IBM Mqueue series
I'm very interested in that question. We'll feed our ODS (Oracle) in near real time fashion using MQ-Series. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Rakesh Gupta Sent: Friday, July 25, 2003 10:54 AM To: Multiple recipients of list ORACLE-L One of our clients requirement is to replicate data from oracle to IBM mqueue series. We are 100% oracle shop and we do not have any IBM DB experience. Can anyone please shed some light on how this can be done ? Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rakesh Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Advice needed on dbms_shared_pool value
Hi! Why do you want to tune this parameter? I've never needed it? I suggest just to keep it as it is if you don't have very specific shared pool problems. And usually those problems come from bad application or bugs anyway... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, July 26, 2003 12:59 AM Hello list I needed your advice on the following : 1. What value do you all specify in DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( value ) ? (1.a.) Should it be set equal to the shared_pool_size ? (1.b.) Should it be greater than shared_pool_size ? (But wouldn't that be impossible. The free list would not be able to service a user request for a size greater than the shared_pool_size) (1.c) Should it be set equal to shared_pool_size minus shared_pool_reserved_size. ( I am not clear on this . Please tell me : can the free list service a request by taking space from the reserved area AND the rest of shared pool or is it 'one or the other and not both together' ) 2. After sucessfully executing DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( value ) (2.a) why doesn't the 'value' show up in select aborted_request_threshold from v$shared_pool_reserved ; ? (2.b) Where would I look to see the change ? -- 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: 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: Opinions on Oracle InterConnect
Hi! Yes I believe InterConnect comes with Apps (technically with 9iAS). The plus is that Oracle itself is developing it and it's probably a strategic part in whole E-Business Suite. I believe it's running on Advanced Queuing and Workflow. The problem is, afaik, it's quite fresh product Others are Tibco, Microsoft has BizTalk... I just read about them today either from this list or from c.d.oracle.server newsgroup. There were few more. Tanel. - Original Message - From: Gene Sais To: Multiple recipients of list ORACLE-L Sent: Friday, July 25, 2003 6:24 PM Subject: Opinions on Oracle InterConnect We have a new project kicking off and the vendor plans on implementing Oracle InterConnectfor Oracle Application Interfaces. Has anyone used this product? Are there other similar products out there? I have been told Oracle InterConnect is free. Will it work Asyncronously? Thanks for any insight on this product. Gene