Poor performance importing LOBS
Hi, I have a apps 11.0 table that we have been importing with no problem but when we upgraded to apps 11.i the import takes 10 times as long. Upon inspection I found two of the columns have been converted to LOBS. I found a few articles on metalinks that referenced the slow import of LOBS but nothing to really fix it. I bumped the import buffer up to 64M and that helped by about 25% but we need more. I would appreciate any ideas. We are running 8.1.7.4 Thanks Craig Ward Southern Systems Solutions, Inc. 803-817-6438 mail2web - Check your email from the web at http://mail2web.com/ . -- 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).
SQL Question
Hi, My brain is slow today Can someone help me ? I can do : select idu+1 from user_group_members where fk_user in(44541,41402,41813) ; IDU+1 -- 41411 41821 44546 But I can't do : select 'insert into XXX (IDU,PEN_ID,LAST_ACCESS,FK_APPLICATION) values ('||IDU + 1 ||','||PEN_ID||',sysdate,'||FK_APPLICATION||');' from app_users where pen_id in (44541,41402,41813) ; I've got on IDU+1 : ERROR at line 1: ORA-01722: invalid number Best Regards Henrik -- --- There's fun in being serious. -- Wynton Marsalis Henrik EkenbergAnoto AB -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SV: SQL Question
Thanks that solved the problem Regards Henrik -- --- Henrik EkenbergAnoto AB On Tue, 28 Jan 2003, Johan Malmberg wrote: -!-You might want to try using () around the idu+1 part! -!- -!-like: -!- -!-select 'insert into XXX (IDU,PEN_ID,LAST_ACCESS,FK_APPLICATION) -!-values ('||(IDU + 1)||','||PEN_ID||',sysdate,'||FK_APPLICATION||');' -!-from app_users -!-where pen_id in (44541,41402,41813) ; -!- -!-That should do it! -!- -!-Best Regards -!-Johan -!- -!- -!- -!- -Ursprungligt meddelande- -!- Fran: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]For Henrik Ekenberg -!- [EMAIL PROTECTED] -!- Skickat: den 28 januari 2003 07:44 -!- Till: Multiple recipients of list ORACLE-L -!- Amne: SQL Question -!- -!- -!- Hi, -!- -!- My brain is slow today Can someone help me ? -!- -!- I can do : -!- -!- select idu+1 from user_group_members where fk_user -!- in(44541,41402,41813) ; -!- -!- IDU+1 -!- -- -!- 41411 -!- 41821 -!- 44546 -!- -!- But I can't do : -!- select 'insert into XXX (IDU,PEN_ID,LAST_ACCESS,FK_APPLICATION) -!- values ('||IDU + 1 -!- ||','||PEN_ID||',sysdate,'||FK_APPLICATION||');' from app_users -!- where pen_id in (44541,41402,41813) ; -!- -!- I've got on IDU+1 : -!- -!- ERROR at line 1: -!- ORA-01722: invalid number -!- -!- -!- Best Regards -!- Henrik -!- -!- -- -!- -- -!- - -!- There's fun in being serious. -!- -!- -- Wynton Marsalis -!- -!- Henrik EkenbergAnoto AB -!- -!- -!- -- -!- Please see the official ORACLE-L FAQ: http://www.orafaq.net -!- -- -!- Author: Henrik Ekenber -!- INET: [EMAIL PROTECTED] [EMAIL PROTECTED] -!- -!- Fat City Network Services-- 858-538-5051 http://www.fatcity.com -!- San Diego, California-- Mailing list and web hosting services -!- - -!- To REMOVE yourself from this mailing list, send an E-Mail message -!- to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in -!- the message BODY, include a line containing: UNSUB ORACLE-L -!- (or the name of mailing list you want to be removed from). You may -!- also send the HELP command for other information (like subscribing). -!- -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQLPlus Substitution Variables
You can use the SQL*Plus commands DEFINE to provide values for variables and UNDEFINE to reset them. Karen Original Message: - Date: Wed, 15 Jan 2003 07:04:18 -0800 To: [EMAIL PROTECTED] I am using substitution variables in SQLPlus, but don't want to be prompted for their values. I want to set them at the start of the script. Kind of like a preprocessor directive. Is this possible? Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Erik 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). mail2web - Check your email from the web at http://mail2web.com/ . -- 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).
Dead shared server msgs in alert log + core dumps
Has anyone ever seen a similar message to the following showing up in the alert log and creating dump/trace files: Mon Jan 13 09:45:22 2003 found dead shared server 'S000', pid = (9, 13) Mon Jan 13 10:13:46 2003 Errors in file /u01/app/oracle/admin/ndi/bdump/ndi_s000_3556.trc: ORA-07445: exception encountered: core dump [000100E8EAE0] [SIGBUS] [Invalid address alignment] [0x812EA10E] [] [] The trace file noted contains (partially) the following: *** 2003-01-13 10:13:46.200 *** SESSION ID:(55.1326) 2003-01-13 10:13:46.181 Exception signal: 10 (SIGBUS), code: 1 (Invalid address alignment), addr: 0x812ea10e, PC: [0x100e8eae0, 000100E8EAE0] *** 2003-01-13 10:13:46.202 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [000100E8EAE0] [SIGBUS] [Invalid address alignment] [0x812EA10E] [] [] Current SQL statement for this session: select . . . . . (and so on.) I'm not sure if I need to be overly concerned or not as it doesn't seem to be causing any problems of note at this time. I haven't seen this particular thing before. But, I am curious as to what might be causing the shared server to die. any ideas or experience with this? There were several similar trace/dump files created over about a 2 hour period, but it appears to have stopped for now. BTW, the box is Sun OS running Oracle 9.2.0.2. Thanks, Karen Morton mail2web - Check your email from the web at http://mail2web.com/ . -- 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).
OMF question
Hi ! I 've a question regarding OMF realted parameter CREATE_DB_ONLINE_LOG_N. Now y is'nt this parameter mentioned in the list of parameters in the Oracle Documenttion cd of 9i. Is it obsolete or oracle does not recommend it's use. regards Tc
[no subject]
HELP
bioinformatics
is there any strategy from oracle in bioinformatics? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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: Install Oracle 8i on Windows XP?
from a private message: | Suggestion: make it clear to the elitist unix bigots that if they | intend to regularly engage in ad hominem attacks and insults that | are clearly intended to disrupt the purpose of the list, which | would include people discussing oracle technology on windows free | of irrelevant b.s., it will be considered a violation of list | rules. | | I delete 98% of posts that are unix/mainframe related, why can't | the unix people do the same thing, and simply focus on what they | are interested in instead of interfering with other people's | conversations? Original Message: - Date: Mon, 29 Jul 2002 10:43:29 -0800 To: [EMAIL PROTECTED] Eric, Need I remind you that this is an Oracle forum? mail2web - Check your email from the web at http://mail2web.com/ . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SMP on windows2000
iTAR resulted in no info so far. Oracle Tech Support is basically saying all their really good info is confidential. some analysis of overall industry issues w/ SMP: http://www.aceshardware.com/read.jsp?id=45000350 (linked from http://2cpu.com) --- latest URL dump --- http://2cpu.com - http://www.aceshardware.com/read.jsp?id=45000350 - http://www.winntmag.com/Articles/Index.cfm?ArticleID=7486 - http://www.ultratech-llc.com/KB/?File=SMP.TXT - http://www.ultratech-llc.com/KB/?File=SMPOS.TXT - http://www.microsoft.com/windows2000/techinfo/howitworks/default.asp - http://www.microsoft.com/mspress/books/sampchap/4354.asp ( linked from http://www.microsoft.com/mspress/books/4354.asp ) - http://developer.intel.com/technology/hyperthread/ - http://www.microsoft.com/windows2000/server/evaluation/performance/reports/h yper thread.asp ( http://www.microsoft.com/windows2000/docs/hyperthreading.doc ) - http://support.microsoft.com/default.aspx?SCID=KB;EN-US;Q234558 - ( general/introductory material only: ) http://www.2cpu.com/OSs/Windows/win2kintropart1/Win2kintrop1.html - http://2cpu.com/How-To/article2.htm - http://2cpu.com/FAQ/2cpusmpfaq.htm Original Message: - Date: Thu, 25 Jul 2002 10:13:49 -0800 To: [EMAIL PROTECTED] I've been wondering same, logged an iTAR. Will keep you in the loop. background (same old crap, sorry, nothing specific): http://www.winntmag.com/Articles/Index.cfm?ArticleID=7486 mail2web - Check your email from the web at http://mail2web.com/ . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
shutdown abort not advised on NT, memory probs
Doc ID: Note:46001.1 l Bulletin Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 14-JAN-1998 Last Revision Date: 11-APR-2002 1. Purpose == This note explains how Oracle interacts with Windows NT's memory architecture, for addition information about NT's memory architecture see [NOTE:46053.1] e) How session memory is released thread termination consequences --- When a users session completes successfully it deallocates its memory using the Win32 API call VirtualFree with the MEM_DECOMMIT | MEM_RELEASE allocation flags. After all allocations have been freed the stack is also released, leaving the Oracle processes address space free of reference to the completed session. If a users session terminates unexpectedly it will not release the memory it has allocated, the allocated pages will remain in the Oracle processes address space until the process exits. Unexpected termination may occur if a users session if forced to terminate for one of the following reasons : - Shutdown abort. - Alter session kill session. - Oracle command line utility orakill. - Oracle Administration assistant for Windows : kill session. - Other utilities that can kill threads in processes. Oracle Support Services recommends customers minimize the use of the above commands, in particular the shutdown abort command. When shutdown abort is run its calls the Win32 API TerminateThread for each users session, which kills the thread without releasing its memory. On systems with many users a large percentage of the 2GB address space of the Oracle process will become inaccessible, ultimately causing allocation problems when Oracle is next started. The only way to release this memory is to stop and start the Oracle Service (e.g. OracleServiceORCL). ---end--- mail2web - Check your email from the web at http://mail2web.com/ . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: (Fwd/2)
(test, posting from www.mail2web.com) Gary, Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. regards, ep Original Message: - Date: Tue, 16 Jul 2002 08:53:34 -0800 To: [EMAIL PROTECTED] Eric, Have you considered the POSSIBILITY that Larry sold the stock without the benefit of insider trading, and simply got lucky with his timing? After all, the main reason Oracle stock has lost so much value is not due to problems specific to the company, but due to problems in the market and economy as a whole. So where would the insider info come into play? And if he really did have insider info, and was acting unethically, why not sell more shares? The amount he sold was probably less than 5% of his holdings. I don't mean to defend ceo misconduct, corporate fraud, etc, I just think you need look this particular accusation a little more objectively, especially when you consider its source. I have great respect for McCain's war record and heroism, but now he is a politician, a Senator no less. IMHO, one can't take anything any politician says at face value. Given a choice between honesty and self-promotion, I'm afraid politicians too often choose the latter. And without getting into specifics about McCain, he seems to be second in the Senate only to my own Sen. Schumer in his love of getting on TV (Q: What's the most dangerous place in NY? A: Between Chuck Schumer and a TV camera). Larry makes a convenient and easy target, someone a politician knows he can attack, get a good soundbite, and have very little chance of being challenged. Gary -Original Message- Sent: Tuesday, July 16, 2002 1:13 AM To: Multiple recipients of list ORACLE-L trying again... --- Forwarded message follows --- Responsibility / Re: OT Date: Mon, 15 Jul 2002 15:14:39 -0400 | Original Message: | - | From: Johnson, M=2E | Date: Mon, 15 Jul 2002 10:23:21 -0800 | To: ORACLE-L@fatcity=2Ecom | Subject: RE: McCain on Larry Ellison and Corporate Responsibility / Re: = OT | Not defending Ellison for anything,=20 Understood | but it appears | McCain is just another politician who is only interested | in his future and he constantly takes on these reform | ideas and just makes the matter worse That sounds really cynical to me. Are you just speculating, or do you have any info to back that up? Note that Oracle/Ellison attempted to buy off politicians here in Sacramento in order to stop the JLAC (legislative) audit of Oracle's ELA with the State of California Note that Senator Sarbanes was on the same TV program (Meet the Press) as McCain, and generally agreed with McCain that there is a horrible lack of corporate responsibility, and that reforming the institutions designed to protect the public's interests has been made extremely difficult by the influence of corrupt lobbyists and lack of effective campaign reform Tim Russert (a rare TV journalist with some integrity) and the Senators spent most of their time discussing the issue of putting executive stock options on the expense sheets so as to more correctly reflect profitability (or lack thereof) Do you think it better serves the investment community for sleazy corrupt executives to be able to hide their shenanighans from analysts and investors? | Everyone should accept the fact that we are in a bear | market and as such all the boats go down Argh, that is the problem, when you have these outrageous examples of greedy, corrupt corporate executives cashing out (***AFTER COOKING THE BOOKS***), leaving others to sink | Everyone should have been smart enough to sell stocks and | put their money into cash or better yet short stocks | when it was very clear that in the Fall of 2000 after the | initial March 2000 sell off that we were going into | a prolonged Bear market Should have been !?!?! That isn't really the issue. As mentioned above, the issue was how excess greed played out when the books were cooked to create a false impression of profitability | Ellison probably took the money and ran when this | became apparent to him and many others. I know I did. So (regardless of whether Ellison is a good example, or not), do you think that there should be *any* accountability for the social damage caused by greed driven unethical accounting practices? (fwiw, I'm sympathetic to libertarian/Chicago school free market ideology, but I fear that like its
oracle and shared scsi raid array
--FDQSKIOZYLYJZUDZQANS Content-Type: multipart/alternative; boundary=CTAMBEFQWATMTARUCPBS --CTAMBEFQWATMTARUCPBS Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable We are looking into purchasing a shared scsi disk array and placing a 1u = or 2u server on the front end to run oracle. The shared scsi disk array = would contain all the database files with the server containing the = archived log files. We are hoping that this setup would easily allow us = to go to the 9i RAC in the future as our needs arise. Anyway...we have = been looking at a couple of different products and the only information I = can find on them is from the vendors themselves. As always, the vendors = are going to say that their product is the best. Here are the products we = have been looking at. Rocketstor 500-S from zzyzx peripherals NexStor 3000S from NStor Flashdisk Openraid from Winchester Systems. I was just wondering if anyone on the list has had any experience with any = of the above products running their database, the performance of the = product and the reliability of the product. Any help would be appreciated. TIA Danny Hughes DBA Knobias.com 601-978-3399 x103 [EMAIL PROTECTED] www.knobias.com --CTAMBEFQWATMTARUCPBS Content-Type: multipart/related; boundary=DQTUDDRTJMVXEMHYHHMP --DQTUDDRTJMVXEMHYHHMP Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable We are looking into purchasing a shared scsi disk array and placing a 1u = or 2u server on the front end to run oracle. The shared scsi disk array = would contain all the database files with the server containing the = archived log files. We are hoping that this setup would easily allow us = to go to the 9i RAC in the future as our needs arise. Anyway...we have = been looking at a couple of different products and the only information I = can find on them is from the vendors themselves. As always, the vendors = are going to say that their product is the best. Here are the products we = have been looking at. br brRocketstor 500-S from zzyzx peripherals brNexStor 3000S from NStor brFlashdisk Openraid from Winchester Systems. br brI was just wondering if anyone on the list has had any experience with = any of the above products running their database, the performance of the = product and the reliability of the product. br brAny help would be appreciated. br brTIA br br br brDanny Hughes brDBA brKnobias.com br601-978-3399 x103 br[EMAIL PROTECTED] brwww.knobias.com br --DQTUDDRTJMVXEMHYHHMP-- --CTAMBEFQWATMTARUCPBS-- --FDQSKIOZYLYJZUDZQANS Content-Type: application/x-pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=smime.p7s CONTENT-DESCRIPTION: S/MIME Cryptographic Signature MIILJwYJKoZIhvcNAQcCoIILGDCCCxQCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCCCPEw ggKAMIIB6aADAgECAgMGdXIwDQYJKoZIhvcNAQECBQAwgZIxCzAJBgNVBAYTAlpBMRUwEwYDVQQI EwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMGVGhhd3RlMR0wGwYD VQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29uYWwgRnJlZW1haWwgUlNB IDIwMDAuOC4zMDAeFw0wMjAxMDcyMTIyMzdaFw0wMzAxMDcyMTIyMzdaMEUxHzAdBgNVBAMTFlRo YXd0ZSBGcmVlbWFpbCBNZW1iZXIxIjAgBgkqhkiG9w0BCQEWE2RodWdoZXNAa25vYmlhcy5jb20w gZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMXrdagpj6AvCpmZPGKkvOy53AdZE1odXRpY9amb kUqKQ6XRSmX3XlxzAbBXDUumk7axLNESq0ohlECCdXn+Jcey0UX44nk/D9vjCFtar7GgKM/2DYIy HV+8PvN9MsMb52/VHuJYt91d/W9Z9N8fmcuj/f7WKmvyhV7N6ZX46SXTAgMBAAGjMDAuMB4GA1Ud EQQXMBWBE2RodWdoZXNAa25vYmlhcy5jb20wDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQIFAAOB gQA2Y3C7b7yJtA+feXG8+VDMd5AKIgxqpksah7Vp9Y28nwzPAvrMJRYZkO1F9KsmukvuU2gEWXA7 lRG2ystGyzdeB4rN7zBOusdafVGwocemMI8cNxVAhp3IVNC/XSsH/oSI+UGTymkJ6xR/Q0rBX56K BXBB4COeLWxVtP2vRc3ZoTCCAy0wggKWoAMCAQICAQAwDQYJKoZIhvcNAQEEBQAwgdExCzAJBgNV BAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UE ChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2 aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJ ARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw05NjAxMDEwMDAwMDBaFw0yMDEyMzEy MzU5NTlaMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlD YXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0 aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwg Q0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wgZ8wDQYJKoZI hvcNAQEBBQADgY0AMIGJAoGBANRp19SwlGRbcelH2AxRtupykbCEXn0tDY97Et+FJXUodDpCLGMn n5V7S+9+GYcdhuqj3bnOlmQawhRuRKx85o/oTQ9xH0A4pgCjh3j2+ZSGXq3qwF5269kUo11uenwM pUtVfwYZKX+emibVars4JAhqmMex2qOYkf152+VaxBy5AgMBAAGjEzARMA8GA1UdEwEB/wQFMAMB Af8wDQYJKoZIhvcNAQEEBQADgYEAx+ySfk749ZalZ2IqpPBNEWDQb41gWGGsJrtSNVwIzzD7qEqW ih9iQiOMFw/0umScF6xHKd+dmF7SbGBxXKKs3Hnj524ARx+1DSjoAp3kmv0T9KbZfLH43F8jJgmR gHPQFBveQ6mDJfLmnC8Vyv6mq4oHdYsM3VGEa+T40c53ooEwggM4MIICoaADAgECAhBmRXK3zHT1
Re: Software Vs Hardware Firewall.
Hi, On which platform ? On good solution is to have a firewall on each machine and a firewall cluster in front of the production Regards Henrik -- --- There's fun in being serious. -- Wynton Marsalis Henrik EkenbergAnoto AB Direct +46 (0)8 410 78 577 Mäster Samuelsgatan 56 Mobile +46 (0) 733 478 577 111 21 Stockholm, Sweden www.anoto.com Switchb +46(0)8 410 78 500 E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 On Wed, 6 Mar 2002, Abdul Aleem wrote: -!-Hi, -!- -!-We are in a process of selecting for a type of firewall. Any pros-n-cons? -!-Things to consider? Your preference/experience? Which one is difficult to -!-break over the other? Or would it be better to have both? -!- -!-TIA! -!- -!-Aleem -!- -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Replication trouble
Hi, We are running Oracle 8.1.7.2.0 with Solaris 8. (Sparc) We are using read-only snaphots with multiple groups (one/schema), replication every minute. Simple 'select *' replication. One of the snapshot process seems to stall and all access to one of the tables in the actual group is blocked (any select hangs forever). Killing the snapshot job connection (alter session kill) frees the system/table. There is a trace file with WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! . We have seen this with different applications (Java) and on different systems. In these cases the replication was on the same database (but that could be because we have not run as many tests in a distributed environment = target production configuration). So no db link involved in this case. There is no normal locks on the tables. Any advice ? Regards HEnrik -- --- E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Clash of the DBs in eWeek
Hi, I have also an other question. Do you you why they did not test postgressql ? Regards Henrik -- --- E-mail :[EMAIL PROTECTED] On Thu, 28 Feb 2002, Jesse, Rich wrote: -!-Anybody happen to see the cover story on the 02/25/2002 iss of eWeek titled -!-Database Clash? -!- -!-The pretty graphs say that their tests showed that Oracle and MySQL rocked -!-the other DBs they tested (including MS SQueaL Server). So I investigated. -!-I went to http://www.eweek.com/ and downloaded the Online Exclusive: -!-Download our configuration and tuning scripts. -!- -!-According to the Oracle setup docs in there, they're NOT using MTS and -!-processes in init.ora is 150. So then how did they test for 1000 -!-concurrent Web clients? -!- -!-Anyone have a thought? -!- -!- -!-Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Names server
Hi, Works fine for us on Solaris 8 Oracle 8.1.7 20 Dbs in the Nameserver. Regards Henrik E. -- On Mon, 4 Mar 2002, Yahoo wrote: -!-Hi ALL: -!-Is any one using names server out there? How the it works? Any -!-infor are wellcome. -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Linux Cluster
Hi from the Swow storm from Sweden, We wants to try to run Oracle on a Linux Cluster. Is someone using Oracle on a Linux Cluster ? Who is your configuration ? 1- (DELL,HP,Compaq,..) 2- Which Linux version ? 3- Which Oracle version ? 4- Is is fun ? Best Regards, HEnrik -- --- There's fun in being serious. -- Wynton Marsalis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Free dbs / Mysql Ver 2
Hi, Is some using Frontbase ? ( http://www.frontbase.com/ ) Best Regards Henrik E. -!-Hello, -!- -!-We are working with Oracle 8.1.7.2 on Sun Solaris. -!-We want to check if a free db can replace some of our Oracle databases. -!- -!-Is someone using a free database in production ? -!-Any good or bad history ? -!- -!- -!- -!- -!-Regards -!-HEnrik -!- -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Free dbs / Mysql
Hello, We are working with Oracle 8.1.7.2 on Sun Solaris. We want to check if a free db can replace some of our Oracle databases. Is someone using a free database in production ? Any good or bad history ? Regards HEnrik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
help
Title: help HELP ** [This message and any attachment is confidential between the sender and the person it is intended for. If we have sent you this message by mistake, please let us know by return email, and erase all copies of this message and its attachments. Thank you.]
RE: help
Title: help Please remove me from the mailing list, Thank you Mer -Original Message-From: Boag, Merridy [SMTP:[EMAIL PROTECTED]] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 18 December 2001 10:11To: Multiple recipients of list ORACLE-LSubject: help HELP ** [This message and any attachment is confidential between the sender and the person it is intended for. If we have sent you this message by mistake, please let us know by return email, and erase all copies of this message and its attachments. Thank you.] ** [This message and any attachment is confidential between the sender and the person it is intended for. If we have sent you this message by mistake, please let us know by return email, and erase all copies of this message and its attachments. Thank you.]
RE: help
Title: help Does this mean that I am no longer on the mailing list? Thanks you for your help Mer -Original Message-From: Boag, Merridy [SMTP:[EMAIL PROTECTED]] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 18 December 2001 10:26To: Multiple recipients of list ORACLE-LSubject: RE: help Please remove me from the mailing list, Thank you Mer -Original Message-From: Boag, Merridy [SMTP:[EMAIL PROTECTED]] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 18 December 2001 10:11To: Multiple recipients of list ORACLE-LSubject: help HELP ** [This message and any attachment is confidential between the sender and the person it is intended for. If we have sent you this message by mistake, please let us know by return email, and erase all copies of this message and its attachments. Thank you.] ** [This message and any attachment is confidential between the sender and the person it is intended for. If we have sent you this message by mistake, please let us know by return email, and erase all copies of this message and its attachments. Thank you.] ** [This message and any attachment is confidential between the sender and the person it is intended for. If we have sent you this message by mistake, please let us know by return email, and erase all copies of this message and its attachments. Thank you.]
Bind Variables
--CIVUFTDKZVQDOGJWYCGU Content-Type: multipart/alternative; boundary=HALPYZPZYFFYCGAKLKOY --HALPYZPZYFFYCGAKLKOY Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I have a question about using bind variables. It is my understanding that = bind variables are to be used to keep the same SQL from being reparsed and = keeping multiple copies in the SGA, thus *speeding* things up. I also = understand that by using bind variables that the CBO will not be able to = optimally use the statistics to determine the most effective path to = retrieve data. Some documentation states to use hints when you are using = bind variables to tell the CBO which path to take. Other documentation = states that bind variables don't like the CBO and to use the RBO. After we looked at the library cache and saw thousands of copies of the = same sql, and hundreds of different sql, we decided to look into converting= certain web pages to bind variables. After we converted to using bind = variables, the pages that once took 5 seconds to load all of the sudden = took 2 minutes to load. The db server was pegged at 100% from 8-5 every = day while this application was being used. We have converted back to = literals and the pages are loading quickly again. While on bind variables,= we used every possible hint except RULE and had no luck. We didn't want = to resort to using the RULE hint because oracle claims not to use the RBO = (because of no further enhancements and possibly phasing it out), and to = start using the CBO for everything. There are so many confusing documents regarding the use of bind variables. = I wanted to see what the oracle community is doing in regards to using = bind variables and what their experiences are. TIA Danny Hughes DBA Knobias.com [EMAIL PROTECTED] www.knobias.com --HALPYZPZYFFYCGAKLKOY Content-Type: multipart/related; boundary=KMQGUMGTJRAMPYVFBAEF --KMQGUMGTJRAMPYVFBAEF Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable I have a question about using bind variables. It is my understanding that = bind variables are to be used to keep the same SQL from being reparsed and = keeping multiple copies in the SGA, thus *speeding* things up. I also = understand that by using bind variables that the CBO will not be able to = optimally use the statistics to determine the most effective path to = retrieve data. Some documentation states to use hints when you are using = bind variables to tell the CBO which path to take. Other documentation = states that bind variables don't like the CBO and to use the RBO. br brAfter we looked at the library cache and saw thousands of copies of = the same sql, and hundreds of different sql, we decided to look into = converting certain web pages to bind variables. After we converted to = using bind variables, the pages that once took lt; 5 seconds to load all = of the sudden took gt; 2 minutes to load. The db server was pegged at = 100% from 8-5 every day while this application was being used. We have = converted back to literals and the pages are loading quickly again. While = on bind variables, we used every possible hint except RULE and had no = luck. We didn't want to resort to using the RULE hint because oracle = claims not to use the RBO (because of no further enhancements and possibly = phasing it out), and to start using the CBO for everything. br brThere are so many confusing documents regarding the use of bind = variables. I wanted to see what the oracle community is doing in regards = to using bind variables and what their experiences are. br brTIA br brDanny Hughes brDBA brKnobias.com br[EMAIL PROTECTED] brwww.knobias.com br --KMQGUMGTJRAMPYVFBAEF-- --HALPYZPZYFFYCGAKLKOY-- --CIVUFTDKZVQDOGJWYCGU Content-Type: application/x-pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=smime.p7s CONTENT-DESCRIPTION: S/MIME Cryptographic Signature MIIKkwYJKoZIhvcNAQcCoIIKhDCCCoACAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCCCJ4w ggI8MIIBpaADAgECAgMD6X8wDQYJKoZIhvcNAQEEBQAwgZIxCzAJBgNVBAYTAlpBMRUwEwYDVQQI EwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMGVGhhd3RlMR0wGwYD VQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29uYWwgRnJlZW1haWwgUlNB IDIwMDAuOC4zMDAeFw0wMTAxMDUxNTQ3MzdaFw0wMjAxMDUxNTQ3MzdaMEUxHzAdBgNVBAMTFlRo YXd0ZSBGcmVlbWFpbCBNZW1iZXIxIjAgBgkqhkiG9w0BCQEWE2RodWdoZXNAa25vYmlhcy5jb20w XDANBgkqhkiG9w0BAQEFAANLADBIAkEAn8T4J83YTOXIk3iPl8Hpg58yaB/YQk0hWUHIDe26ZCwJ P7MnmKJkyiTRP3Vl7WJdt3SOBuLYsQa4bewJrG5SHQIDAQABozAwLjAeBgNVHREEFzAVgRNkaHVn aGVzQGtub2JpYXMuY29tMAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEEBQADgYEAloEUXE3MsxSe oNIMwOdM7l+j6zat3yCav2T1s06uBaus9hRgruTGI0+HzkPdjj0zJ4Q2krHO1QzKnRz24vExupK+ 2GR13ldRWLfoDphFJyvBXuI0x2AhPpC+KY04jBojgtKmwX//BoKquodT89CzcDrZaU4FRU5OG7cM Hc4q
Info request for installing Ora 7.3 on AIX 4.1
Hi Dba's, in my company they told me to create a DB on an IBM AIX box. I'm new on the AIX environment (I come from VMS) and I have only found the Oracle installation manual (Oracle7 Installation and Configuration Guide for IBM RS/6000 ) that seems to me a little confusing. There is someone, experienced in these tasks, that can suggest me some more practical hints to accomplish the task? ( a check-list or a document or a link to a document; after the creation of DB I have also to import a production DB ). Many thanks, Francesco -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to install the O9i cluster DB on a PC
How to install and deploy Oracle Real Application Clusters on a single Linux server with a minimal configuration (less than $1000 worth of hardware): First of all to install Oracle cluster database you DON'T HAVE to have a cluster, but a single PC may do as well (of course thi kind of installation will not be of much use for a production DB). A minimal server that I HAVE TESTED is: Celeron 750 MhZ, 512 Mb of RAM, 2 IDE HD, Linux Suse 7.2 This document contains the steps needed to deploy a working Oracle 9i Database with a minimal comment. For a complete discussion refer to Oracle documentation, namely: Oracle 9i administrator's reference part number A90347-02 Oracle 9i Linux release notes part number A90356-01 Oracle 9i Real Application Clusters Administration part numebr A89869-01 1) set up the partitions to user for Oracle software and the ones to use as raw devices for the cluster DB. Soppose you want to you use an HD mounted as the 3rd IDE device (/dev/hdc) for the cluster DB. Then you have to partition it with fdisk with a large extended partition (say hdc1). Create a large number of logical partitions inside hdc1 (say hdc5 till hdc20) of about 300 Mb in size (all of the same size for simplicity). 2) Real application clusters wants to store the DB strutures into raw devices or a cluster filesystem. Create the raw devices using the following command (as superuser): raw /dev/raw1 /dev/hdc5 raw /dev/raw2 /dev/hdc6 ... etc till /dev/hdc20 you will need to repeat these steps after every boot 3) Set up the Oracle user (already done with the Suse distribution), environment variables and mount point. Install Oracle software enterprise edition 4) Complete the installation with a custom install of the real application cluster option. This will add a directory called oracm under your oracle home, which contains the cluster manager software 5) edit $ORACLE_HOME/oracm/admin/nmcfg.ora, it contains 3 lines for the set-up of the cluster manager sofware: DefinedNodes=localhost CmDiskFiles=/dev/raw2 CmHostName=localhost 6) edit /var/opt/oracle/srvConfig.loc. It contains 1 line with the location of a raw device used to sync the cluster nodes: srvconfig_loc=/dev/raw1 7) start the cluster manager software (as superuser): $ORACLE_HOME/oracm/bin/ocmstart.sh 8) as the oracle user start the global cache service: gsd 9) you can now create a cluster db. to use the configuration assistant you need to set an extra environment variable: export THREADS_FLAG=native 10) start the configuration assistant: dbca expect some errors in the script the dbca generates, best is to review them before execution 11) after the db creation you'll be able to start two instances on the same DB, which means you will have a cluster DB! 12) the environment variable ORACLE_SID will determine the instance to which you can connect by means of a special syntax: SID.parameter=value this is used for example for paramters like instance_number, thread, etc also the parameter cluster_database must be set to true All these problems are normaly handled by the dbca. NOTE: to set up a multi-node cluster you need to have at least: 2 PC with SCSI controllers (one of them must have a BIOS), at least 1 SCSI HD which is shared between the 2 PCs (it is connected to the 2 controllers). Having all that, you can set up the raw devices on the PCs and share them between the 2 installations of 9i RAC. The cluster manager must be properly configured and started on both nodes in a similar, but extended, step (5). Have fun, Luca Canali OCP-DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: advanced queuing
Hello, Yes you can run Oracle AQ with 250 Req/s. You will not have one queue and one disk. You can contact me and I will explain how you can have 250 req/s with AQ. BUT !! The hell start when one queue stop with an error. Regards H. Ekenberg -!-Thanks, yes I spoke with a guy that said they were replicating 250 transactions a second -!-using AQ, which sounded fishy. I have heard of 800 transactions per minute on Oracle as -!-being high. -!- -!-Dave -!-On Fri, Aug 03, 2001 at 03:36:01PM -0700, A. Bardeen wrote: -!- Dave, -!- -!- Oracle's Advanced Replication uses AQ as the -!- propagation mechanism for asynchronous parallel -!- propagation (serial and synchronous use the two-phase -!- commit process). Or are you asking if anyone has -!- written their own custom replication using AQ? -!- -!- HTH, -!- -!- -- Anita -!- -!- --- David Turner [EMAIL PROTECTED] wrote: -!- Is anyone out there using advanced queuing for -!- replication? -!- -!- Dave -!- -- -!- Please see the official ORACLE-L FAQ: -!- http://www.orafaq.com -!- -- -!- Author: David Turner -!-INET: [EMAIL PROTECTED] -!- -!- Fat City Network Services-- (858) 538-5051 FAX: -!- (858) 538-5051 -!- San Diego, California-- Public Internet -!- access / Mailing Lists -!- -!- -!- To REMOVE yourself from this mailing list, send an -!- E-Mail message -!- to: [EMAIL PROTECTED] (note EXACT spelling of -!- 'ListGuru') and in -!- the message BODY, include a line containing: UNSUB -!- ORACLE-L -!- (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!? -!- Make international calls for as low as $.04/minute with Yahoo! Messenger -!- http://phonecard.yahoo.com/ -!--- -!-Please see the official ORACLE-L FAQ: http://www.orafaq.com -!--- -!-Author: David Turner -!- INET: [EMAIL PROTECTED] -!- -!-Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 -!-San Diego, California-- Public Internet access / Mailing Lists -!- -!-To REMOVE yourself from this mailing list, send an E-Mail message -!-to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in -!-the message BODY, include a line containing: UNSUB ORACLE-L -!-(or the name of mailing list you want to be removed from). You may -!-also send the HELP command for other information (like subscribing). -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Master/master with diff username possible ?
Hello Anita Thanks for your answer. We need to share some tables between different software. So we need to replicate these tables to different schemas. One of these schemas will probably be on an other machine. Then will we replicate these schemas to different sites. You can't replicate one snapshot in 8.1.7, so we can't use snapshot to solve our problem. Regards H. Ekenberg On Sun, 5 Aug 2001, A. Bardeen wrote: -!-Henrik, -!- -!-Multi-master replication requires that the schemas be -!-identical on all sites. In addition you cannot -!-replicate within the same site. -!- -!-9i now allows updatable snapshots of updatable -!-snapshots although it has the same restriction as -!-multi-master in that the schemas must be identical. I -!-believe it also has the restriction that you cannot -!-replicate within the same site. -!- -!-I'm assuming that by replicating from one schema to 3 -!-schemas you were referring to replicating within the -!-same db. I'm not sure why you would need to do this -!-nor how you could accomplish this unless you wrote -!-your own replication code. -!- -!-As far as replicating to different schemas in -!-different db's, the usual workaround is to replicate -!-to the same schema and then use synonyms. -!- -!-HTH, -!- -!--- Anita -!- -! Henrik Ekenberg [EMAIL PROTECTED] -!-[EMAIL PROTECTED] wrote: -!- Hello, -!- -!- We are running 8.1.7 on Solaris 8 on E4500. -!- We need to replicate one table from one schema to 3 -!- other schema and the -!- replicate these 3 schemas to other sites. -!- We can't use snapshot on snapshots because Oracle -!- will do a complete -!- refresh each time. -!- Is there any trick to replicate to different schema -!- with master/master. -!- -!- If you have any advice please let me know. -!- -!- Thanks -!- H. Ekenberg -!- -!- -!- -! -!- Experience is a hard teacher because she gives the -!- test first, -!- the lesson afterward. -!- -!- -- Vernon Law -!- -!- H.Ekenberg -!- Anoto AB -!- E-mail :[EMAIL PROTECTED] Tel -!- +46 (0)8 410 78 500 -!- -!- -!- -!- -- -!- Please see the official ORACLE-L FAQ: -!- http://www.orafaq.com -!- -- -!- Author: Henrik Ekenber -!- INET: [EMAIL PROTECTED] -!- [EMAIL PROTECTED] -!- -!- Fat City Network Services-- (858) 538-5051 FAX: -!- (858) 538-5051 -!- San Diego, California-- Public Internet -!- access / Mailing Lists -!- -!- -!- To REMOVE yourself from this mailing list, send an -!- E-Mail message -!- to: [EMAIL PROTECTED] (note EXACT spelling of -!- 'ListGuru') and in -!- the message BODY, include a line containing: UNSUB -!- ORACLE-L -!- (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!? -!-Make international calls for as low as $.04/minute with Yahoo! Messenger -!-http://phonecard.yahoo.com/ -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Master/master with diff username possible ?
Hello, We are running 8.1.7 on Solaris 8 on E4500. We need to replicate one table from one schema to 3 other schema and the replicate these 3 schemas to other sites. We can't use snapshot on snapshots because Oracle will do a complete refresh each time. Is there any trick to replicate to different schema with master/master. If you have any advice please let me know. Thanks H. Ekenberg --- Experience is a hard teacher because she gives the test first, the lesson afterward. -- Vernon Law H.Ekenberg Anoto AB E-mail :[EMAIL PROTECTED] Tel +46 (0)8 410 78 500 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: JMS vrs AQ
Hello Christopher, How many queues do you have on how many disks ? We have 10 queues on 10 disks E4500 also. Regards Henrik --- Experience is a hard teacher because she gives the test first, the lesson afterward. -- Vernon Law Henrik Ekenberg Anoto AB Direct+46 (0)8 410 78 577 Vasagatan 7 Mobile+46 (0)733 478 577 111 20 Stockholm, Sweden www.anoto.com Switchb. +46 (0)8 410 78 500 E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 On Tue, 31 Jul 2001, Christopher Spence wrote: -!-Using JMS on E450 on Solaris we are lucky to do 4/s without having problems. -!- -!-300/s would be great. -!- -!- -!-Walking on water and developing software from a specification are easy if -!-both are frozen. -!- -!-Christopher R. Spence -!-Oracle DBA -!-Fuelspot -!- -!- -!- -!--Original Message- -!-[mailto:[EMAIL PROTECTED]] -!-Sent: Tuesday, July 31, 2001 4:00 AM -!-To: Multiple recipients of list ORACLE-L -!- -!- -!-Hello, -!- -!-Which performance do you need ? -!-We have really bad performance with AQ (300 req/s) or JMS from Oracle. We -!-will use a JMS driver from an other company. -!- -!-Regards -!-Henrik -!- -! -!-Experience is a hard teacher because she gives the test first, the lesson -!-afterward. -!- -!--- Vernon Law -!- -!-Henrik Ekenberg Anoto AB -!-Direct+46 (0)8 410 78 577 Vasagatan 7 -!-Mobile+46 (0)733 478 577 111 20 Stockholm, Sweden -!-www.anoto.com Switchb. +46 (0)8 410 78 500 -!-E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 -!- -!- -!-On Mon, 30 Jul 2001, Christopher Spence wrote: -!- -!--!-I was wondering if anyone has compared performance of JMS and AQ, used -!--!-both, or know of some good documents. -!--!- -!--!-We currently use JMS, which I have never been a fan off, I am not much -!--!-of an AQ person. -!--!- -!--!-Any feedback would be great, I think I am going to setup some benchmarks -!--!-with AQ and JMS. -!-We use very small amount of JMS right in database, -!-and most of our JMS -!-is via separate JMS file systems. -!--!- -!--!- -!--!-Walking on water and developing software from a specification are easy -!--!-if both are frozen. -!--!- -!--!-Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA -!--!-Oracle DBA -!--!-Phone: (978) 322-5744 -!--!-Fax:(707) 885-2275 -!--!- -!--!-Fuelspot -!--!-73 Princeton Street -!--!-North, Chelmsford 01863 -!--!- -!--!- -!--!- -!--!- -!- -!--- -!-Please see the official ORACLE-L FAQ: http://www.orafaq.com -!--- -!-Author: Henrik Ekenber -!- INET: [EMAIL PROTECTED] [EMAIL PROTECTED] -!- -!-Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 -!-San Diego, California-- Public Internet access / Mailing Lists -!- -!-To REMOVE yourself from this mailing list, send an E-Mail message -!-to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the -!-message BODY, include a line containing: UNSUB ORACLE-L (or the name of -!-mailing list you want to be removed from). You may also send the HELP -!-command for other information (like subscribing). -!--- -!-Please see the official ORACLE-L FAQ: http://www.orafaq.com -!--- -!-Author: Christopher Spence -!- INET: [EMAIL PROTECTED] -!- -!-Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 -!-San Diego, California-- Public Internet access / Mailing Lists -!- -!-To REMOVE yourself from this mailing list, send an E-Mail message -!-to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in -!-the message BODY, include a line containing: UNSUB ORACLE-L -!-(or the name of mailing list you want to be removed from). You may -!-also send the HELP command for other information (like subscribing). -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: JMS vrs AQ
Hello, Which performance do you need ? We have really bad performance with AQ (300 req/s) or JMS from Oracle. We will use a JMS driver from an other company. Regards Henrik --- Experience is a hard teacher because she gives the test first, the lesson afterward. -- Vernon Law Henrik Ekenberg Anoto AB Direct+46 (0)8 410 78 577 Vasagatan 7 Mobile+46 (0)733 478 577 111 20 Stockholm, Sweden www.anoto.com Switchb. +46 (0)8 410 78 500 E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 On Mon, 30 Jul 2001, Christopher Spence wrote: -!-I was wondering if anyone has compared performance of JMS and AQ, used -!-both, or know of some good documents. -!- -!-We currently use JMS, which I have never been a fan off, I am not much -!-of an AQ person. -!- -!-Any feedback would be great, I think I am going to setup some benchmarks -!-with AQ and JMS. -!-We use very small amount of JMS right in database, and most of our JMS -!-is via separate JMS file systems. -!- -!- -!-Walking on water and developing software from a specification are easy -!-if both are frozen. -!- -!-Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA -!-Oracle DBA -!-Phone: (978) 322-5744 -!-Fax:(707) 885-2275 -!- -!-Fuelspot -!-73 Princeton Street -!-North, Chelmsford 01863 -!- -!- -!- -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Out of office until Tuesday 26th June
I will be on annual leave until Tuesday 26th June. For matters that cannot wait until then, please email Ray Feighery at [EMAIL PROTECTED] or phone +61 2 8437 6311 Thanks and regards Jeffrey Lim Infrastructure Consultant RecruitASP Pty Ltd PO Box 300, St Leonards New South Wales 1590 Australia Tel: +61 (2) 8437 6311 Fax: +61 (2) 8437 6399 Email: [EMAIL PROTECTED] Web: www.recruitasp.com.au -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: stupid question about indexes and partitions
Deshpande, Kirti wrote: Hi Joe, Here is a blurb from the 8.1.6 Concepts Guide (Chapter 11, under 'Prefixed and Nonprefixed Global Partitioned Indexes'): 'Nonpartitioned indexes are treated as global prefixed nonpartitioned indexes' I ran into the same stupid question not too long ago. HTH, Regards - Kirti Didn't know that Alan Greenspan was moonlighting as an Oracle technical writer. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult ([EMAIL PROTECTED]) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: what to put in place of null
Harvinder Singh wrote: Hi, I have a cursor declared as cursor c1 is select dd,dd1,dd2,dd3 from dd union select null,null,dd2,dd3 from dd1; i am getting error: * ERROR at line 1: ORA-01790: expression must have same datatype as corresponding expression ORA-06512: at DY.REST, line 4 ORA-06512: at DY.REST, line 10 ORA-06512: at line 1 what to replace null with.. dd1 has only 2 columns dd2 and dd3. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com to_whatevertype_of_corresponding_not_null_column(NULL) NULL can have a type with oracle ... -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult ([EMAIL PROTECTED]) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Standards Document Sought
Dale Edgar wrote: Hi All I've recently been tasked with writing the Oracle Standards Document at work. You know the sort of thing I mean - naming conventions for tables, columns, datafiles, tablespaces etc, mount points, init.ora standards et al. Would anybody be willing to send me the standards document you work from to use as a template? It would be much appreciated. The O/S is AIX - but any doc would be appreciated. Thanks in advance Dale Edgar There are some standards available in the 'Standards' section of the Oriole Web site - not a lot of things, we optimistically relied on external contributions to thicken the section a bit, but ... If you happen to find more interesting things to publish, don't forget us ... -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult ([EMAIL PROTECTED]) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: cannot drop snapshot with partition.
Hello, We had the same problem and here comes one solution : 0. Pray !!! 1. Full backup 2. -- Change u.name and o.name UPDATE tab$ t set t.property = t.property - 67108864 where bitand(t.property, 67108864) = 67108864 and t.obj# = (select o.obj# from sys.user$ u , sys.obj$ o where u.user# = o.owner# and o.obj# = t.obj# and u.name = 'SC' and o.name = 'STOCKS'); commit; Good luck .. Regards Henrik --- Henrik Ekenberg Anoto AB www.anoto.com On Thu, 31 May 2001, A. Bardeen wrote: -!-Sandesh, -!- -!-This is a known bug (1335477) that allows you to -!-rename a snapshot/materialized view, which you -!-shouldn't be allowed to do. What you've got now is -!-data dictionary corruption because not all of the data -!-dictionary entries were changed when the snapshot was -!-renamed. -!- -!-You can try renaming the snapshot back to its original -!-name, but I suspect you'll get an error that the -!-object already exists. -!- -!-Your only option, other than a PITR prior to when the -!-snapshot was renamed, is probably to log a tar with -!-support so they can walk you through correcting the -!-data dictionary corruption. This is not something I'd -!-advise trying on your own unless you can afford to -!-lose this db. -!- -!-HTH, -!- -!--- Anita -!- -!- -! Naik, Sandesh S [EMAIL PROTECTED] wrote: -!- Hi All, -!- I have a 8.1.6.2 database on hp9000. (11.0). I -!- have created one snapshot , -!- with partition. Now I not able to drop snapshot or -!- nor I cam drop last -!- partition. -!- It does not show that snapshot in dba_snapshot. I -!- renamed the snapshot to -!- old. But drop snapshot is not working -!- SQL drop snapshot old; -!- drop snapshot old -!- * -!- ERROR at line 1: -!- ORA-12003: snapshot SYS.OLD does not exist -!- If I try to drop the table then it gives this error -!- SQL drop table old; -!- drop table old -!-* -!- ERROR at line 1: -!- ORA-12083: must use DROP MATERIALIZED VIEW to drop -!- SYS.OLD -!- -!- Does somebody has encountered this error or has -!- solution to this problem. -!- -!- Sandesh -!- -- -!- Please see the official ORACLE-L FAQ: -!- http://www.orafaq.com -!- -- -!- Author: Naik, Sandesh S -!- INET: [EMAIL PROTECTED] -!- -!- Fat City Network Services-- (858) 538-5051 FAX: -!- (858) 538-5051 -!- San Diego, California-- Public Internet -!- access / Mailing Lists -!- -!- -!- To REMOVE yourself from this mailing list, send an -!- E-Mail message -!- to: [EMAIL PROTECTED] (note EXACT spelling of -!- 'ListGuru') and in -!- the message BODY, include a line containing: UNSUB -!- ORACLE-L -!- (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!? -!-Get personalized email addresses from Yahoo! Mail - only $35 -!-a year! http://personal.mail.yahoo.com/ -!--- -!-Please see the official ORACLE-L FAQ: http://www.orafaq.com -!--- -!-Author: A. Bardeen -!- INET: [EMAIL PROTECTED] -!- -!-Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 -!-San Diego, California-- Public Internet access / Mailing Lists -!- -!-To REMOVE yourself from this mailing list, send an E-Mail message -!-to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in -!-the message BODY, include a line containing: UNSUB ORACLE-L -!-(or the name of mailing list you want to be removed from). You may -!-also send the HELP command for other information (like subscribing). -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: V$transaction query?
Seema Singh wrote: Hi If I have sid or serial no of session then how can I know which trasaction is going on in v$trasaction table. Look for statements in 'ACTIVE' state in V$SQLAREA. Another query: some job is haning frequently in our database (Oracle8.1.7).When I try to remove by dbms_jobs.remove packge.It show error. Which one ? You must be the user which created it to be able to remove it, being a DBA is not enough (although you can magically become anybody when you are a DBA - you may find become.sql, in the DBA toolkit on the Oriole site, useful for this, as well as for grants and for toying with private database links or more precisely recompiling stored objects which refer to private database links). When I try to kill session by alter system kill session command then it shows ORA-00031: session marked for kill error.I cann't find more information of metalink.Let me know how can solve this problem. Hmmm, jobs are a bit special. They are Oracle background processes in the same respect as dbwr, lgwr and the like - they execute stored procedures on your behalf, but they are not ordinary sessions. It is not surprising you cannot kill them because the same snpxxx which is running your job right now may be expected to run a job for somebody else shortly after or even possibly refreshing a snapshot. IMHO you should log as the user on whose behalf the job is run and remove it using the dbms_job package. Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult ([EMAIL PROTECTED]) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: LDAP/OID
Dave Morgan wrote: Hi all, OID is not worth the hassle of installing, but, has anyone used a regular LDAP server to hold Oracle database information? Details would be appreciatted. TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 What do you mean, holding Oracle database information ? Storing TNS aliases? They would still need to be mapped to port/host/sid. Or for authentification ? I have been working on this very recently, but it still need to be polished a little. Basically, the idea is to map pseudo-views over information collected from a (Netscape) LDAP server. Applications can then access information from the LDAP server through SQL. I am not madly happy with my current implementation (which uses a flat file, regularly refreshed, as cache. Uh.) but it's promising. e-mail me privately if you want some details. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult ([EMAIL PROTECTED]) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: foreign key
Harvinder Singh wrote: Hi, How to find out that a particular table is referenced by which other tables i.e..other tables having foreign key referncing this particular table.. Thanks Harvinder Not totally straighforward. All the info is in DBA_CONSTRAINTS. First you must find the name of constraints of type 'P' (primary key) or 'U' (unique, can also be referenced by a foreign key) associated with your table, then (auto-join), the name of tables having a constraint of type 'R' referencing this type 'P' or 'U' constraint. There is alos a script named desc8.sql on the Oriole site which is (basically) an improved version of the 'desc' SQL*Plus command and shows, among other things, this type of info. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult ([EMAIL PROTECTED]) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Connection auditing
Hillman, Alex wrote: I am interested to find info about connections with wrong userid/password - which userid/password were used and other tns errors. For example if tnsnames group use wrong sid - it will be recorded in listener.log. I did not try tracing - maybe somebody did it alredy. Alex Hillman -- Alex, There is a possible solution, which would be using 'netcat' - a hacker tool, but a useful one. You can probably (I have not tried it) use it as a front-end to the listener and intercept everything sent to the listener (I have once used it to see what was going on during exchanges). The only snag is that you would also catch GOOD passwords :-) -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mean/Median
I differ If your dataset was: 1, 1, 2, 3, 4, 10, 11 Min = 1 Max = 11 Avg = 4.5+ Avg(Min,Max) = Avg(1,11) = 6 Median = 3 (central value in the dataset) -Original Message- Sent: Tuesday, May 15, 2001 7:27 PM To: Multiple recipients of list ORACLE-L geez louise, Median := avg(Max,Min) || -Original Message- || From: Pat Hildebrand [mailto:[EMAIL PROTECTED]] || Sent: Monday, May 14, 2001 10:56 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: Mean/Median || || || || || Any scripts (sql or pl/sql) out there to compute various || statistical things || in Oracle? || || || Would depend on just what you are looking for. A quick look at || Oracle's SQL functions showed avg, st. deviation, and variance || although no median but that should be easier to write than || some of the || others. || ||Pat || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Pat Hildebrand || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@i-Commerce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ASP Assistance
Hi How about: = 1 UserIP = Request.ServerVariable("REMOTE_HOST") 2 IPCheck = Left(UserIP,7) 3 If IPCheck = "192.168" Then 4 parser.setSingleSessionField "My_Template", "template_i" 5 Else 6 parser.setSingleSessionField "My_Template", "template_o" 7 End If = -Original Message- Sent: Friday, April 20, 2001 3:50 PM To: Multiple recipients of list ORACLE-L I apologize for being off topic here, but I am stuck. I have been struggling for 3 days on what I believe is a simple script. Here is the piece of code which is not functioning as I require: 1 UserIP = Request.ServerVariable("REMOTE_HOST") 2 IPCheck = Left(UserIP,7) 3 If UserIP = "192.168" Then 4 parser.setSingleSessionField "My_Template", "template_i" 5 Else 6 parser.setSingleSessionField "My_Template", "template_o" 7 End If If I comment out all but line 4, I can verify that My_Template is set to 'template_i'. If I comment out all but line 6, I can verify that My_Template is set to 'template_o'. If I run with now lines commented, My_Template winds up blank. What am I doing wrong? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Rogge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@i-Commerce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Installing Oracle 8.1.6 Client on Solaris without x-windows
Hi All Is there a way to install the client on Solaris without running a x-windows session? (i.e. all from command prompt) Regards JL Kind Regards Johan Locke http://www.JohanLocke.co.za Certified Oracle 8 8i DBA Certified Oracle Developer Dimension Data i-Commerce Internet Services Direct Line: +27 11 516 5343 mailto:[EMAIL PROTECTED] http://www.didata.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@iCommerce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Installing Oracle 8.1.6 Client on Solaris without x-windows
Title: RE: Installing Oracle 8.1.6 Client on Solaris without x-windows Thanx! This buggers up my day, but still - thanx -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Monday, April 09, 2001 1:05 PMTo: 'Johan Locke@iCommerce '; 'Multiple recipients of list ORACLE-L 'Subject: RE: Installing Oracle 8.1.6 Client on Solaris without x-windows This would be great, but I think the glory days of DIY are gone daddy gone. I'd love to hear a success story otherwise from the list, though. The most i've heard is that it can be scripted to run in the background from a previous successful install. -Original Message- From: Johan Locke@iCommerce To: Multiple recipients of list ORACLE-L Sent: 4/9/2001 6:35 AM Subject: Installing Oracle 8.1.6 Client on Solaris without x-windows Hi All Is there a way to install the client on Solaris without running a x-windows session? (i.e. all from command prompt) Regards JL Kind Regards Johan Locke http://www.JohanLocke.co.za Certified Oracle 8 8i DBA Certified Oracle Developer Dimension Data i-Commerce Internet Services Direct Line: +27 11 516 5343 mailto:[EMAIL PROTECTED] http://www.didata.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@iCommerce INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Funny Error... Any Ideas what the hell is happening here? Trace F
Hi All Funny Error... Any Ideas what the hell is happening here... Kind Regards Johan Locke http://www.JohanLocke.co.za Certified Oracle 8 8i DBA Certified Oracle Developer Dimension Data i-Commerce Internet Services Direct Line: +27 11 516 5343 mailto:[EMAIL PROTECTED] http://www.didata.com *** The information in this e-mail is confidential and is legally privileged. It is intended solely for the addressee. If this email is not intended for you, you cannot copy, distribute, or disclose the included information to any-one If you are not the intended recipient please delete the mail. Whilst all reasonable steps have been taken to ensure the accuracy and integrity of all data transmitted electronically, no liability is accepted if the data, for whatever reason, is corrupt or does not reach it's intended destination. All business is undertaken, subject to our standard trading conditions which are available on request. *** comdev_ora_29325.zip
RE: Which is faster?
I don't think there is any question. A smart select statement always tends to be a better solution. The one instance where I'd definitly prefer a procedure over a select is when the select contains Oracle's tree-walk method (i.e. connect by prior... start with) Regards JL -Original Message- Sent: Tuesday, February 20, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Hi Gurus ! I'm going to some tables with huge amount of records. There are references between these tables. The question is: Does it worth creating a procedure with several small selects or is it faster to use one select with joins? For example: CUSTOMER(CUST_ID); CONTRACT(CONTR_ID,CUST_ID); CONTRACT_ITEM(CONTR_I_ID,CONTR_ID,PHONE_NUM_ID); PHONE_NUMBER(PHONE_NUM_ID,PHONE_NUM); I have the PHONE_NUM and I need the CUST_ID. Which Faster? SELECT CUST_ID from PHONE_NUM,CONTRACT_ITEM,CONTRACT,CUSTOMER where [JOINS] and PHONE_NUM=searchedone or In procedure or function select phone_num_id into Variable from phone where phone_num=searchedone; select contract_id into Variable2 from contract_item where phone_num_id=Variable; select cust_id into Variable from contract where contr_id=Variable2; Thanks in advance. Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@i-Commerce Services INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
LONG to char
Anybody have any Idee how to conevrt a LONG datatype to char/varchar Regards JL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@i-Commerce Services INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: LONG to char
Hi I'm attemting to write an insert script for a table: Spool out.log SELECT 'INSERT INTO TAB2 VALUES(''' || LONG_TYPE_COLUMN || ''',''' || VARCHAR2_TYPE_COLUMN||''');' FROM TAB1; spool off (It moans about Inconsistant Datatypes - which I can understand) Any ideas on how to get around this? Regards JL -Original Message- Sent: Tuesday, February 20, 2001 5:23 PM To: [EMAIL PROTECTED] Johan, What do you exactly want to do? If you could explain it in more detail, I might be able to help, at least I'll try. --- "Johan Locke@i-Commerce Services" [EMAIL PROTECTED] wrote: Anybody have any Idee how to conevrt a LONG datatype to char/varchar Regards JL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@i-Commerce Services INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Gunawan Yuwono Oracle DBA Kansas City, USA __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@i-Commerce Services INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: When you should use NOLOGGING while creating indexes
Advantages: - Less performance overhead in creating the indexes Disadvantages: - Unrecoverable. Ie. If the Database is not shutdown normally after the creation of the indexes (SHUTDOWN ABORT or crash), you'll have to recreate those indexes. Also look at: - Creating an index in using parallel servers (multiple instances) (I think this can be done - MAYBE SOMEBODY CAN COMMENT) - Analyzing your tables and indexes regularly ie. "ANALYSE INDEX name [COMPUTE|ESTIMATE] STATISTICS " Regards JL -Original Message- Sent: Monday, February 19, 2001 5:35 AM To: Multiple recipients of list ORACLE-L Hi all, when I should use NOLOGGING while creating indexes: what are the advantages and what the dis-advantages... br and thanks, Hessu _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Heikki Jantunen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@i-Commerce Services INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Off Topic: Row Locking - Row Id
Hi Riyaj Thanx for the reply. As it's a web system we'll probably be selecting 20 records at a time (ie. the user sees 20 products of which he can book more than one at a time). So I'd probably not try to select and test each individual record, purely for performance considerations. select * from t1 skip locked I need to unfortunately know which records have been locked - I need to display them as well to the user, because he may want to wait to book them, if the other user doesn't buy them ... this happens frequently. Also, "skip locked" only works when you want to select something for update, ie. select * from t1 FOR UPDATE skip locked. When the user is only browsing, I don't want to lock anything. Thanx for the responses. Cheers JL -Original Message- Sent: Tuesday, February 13, 2001 5:41 PM To: Multiple recipients of list ORACLE-L Hi Johan Will this work ? Person A books the product he wants with 'select * from t1 for update'. At this point, he has lock on the row. Person B comes in, looks at the product and does a 'select * from t1 for update nowait' If the row is locked for update then person B will get ORA-0054. If Person B gets an ORA-0054 then, you know that the person A has booked the product but not bought yet. The locks hold by the person A will be cleaned by the pmon if the process dies away. But the above will only work if each of the web user gets its own database connections. I don't know about your environment, but in most environment, the connection to the database is shared among the web sessions. If that is the case, then you may have to use the flags to track the state changes. If you want to show only rows that are locked then you could use this undocumented feature: 'select * from t1 skip locked'. This will skip all the rows that have been locked. Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA "These are my opinions and does not bind my employer. Use at your risk" "Johan Locke@i-CommeTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rce Services"cc: Johan.Locke Subject: RE: Off Topic: Row Locking - Row Id Sent by: root@fatcity. com 02/13/01 12:50 AM Please respond to ORACLE-L Thanks Riyaj Unfortunately it doesn't solve my problem. It only helps if the transaction is BLOCKING another transaction. This is my requirement, maybe somebody has a good solution. A product selection engine. There are a limited number of products, each unique. Person A comes in over the web (this important). Looks at the products and "books" the product he wants. At this stage I just want to issue a "SELECT FOR UPDATE" - without commiting. Person A goes through the payment selection, and if succesfull, the product is marked as "bought" and the transaction commited. If during the process of payment authorisation for Person A, person B looks through the products, Person B must see the product person A is buying as "Booked - not yet bought". Why don't I just set a flag in the row, commit it, do the payment and commit that? -- If for some reason person A's web session terminates voluntarily or involuntarily, I'd have to run a process in the background which cleans up the flags. As this is a very processing intensive table, it slows down the processing tremendously. Conversly, if I could use the user's web session termination, which will terminate the database session, to make oracle release the lock on that row it makes my life a lot easier. About 90% of the people will access the site within a period of about an 1-2 hours (within which you're aiming to sell 54000 of the 6 products) Why did I want the rowid's? --- I wanted to run a query something like: SELECT PRODUCT, decode(oracle_internal_lock,yes,'Booked','Available') FROM PRODUCTS where status != 'Bought' To get an output like: PRODUCT AVAILABLE --- - PROD A Booked PROD B Available PROD C Available A background process killing flags that have timed out is not a viable solution. Additional Info: OPS 8.1.6 on a Sun Cluster Dynamo Appserver (4.5.0), JDK 1.2.1 Netscape Web Server Ideas??? Regards JL -Original Message- Sent: Monday, February 12, 2001 5:21 PM To: Multiple recipients of list ORACLE-L Hi You could get the following columns from the v$session table and then use dbms_rowid.rowid_
RE: Renaming a Column
Sorry sorry ID-10-T error Cheers JL -Original Message- Sent: Wednesday, February 14, 2001 9:19 AM To: '[EMAIL PROTECTED]' Wait wait wait... Yes you can rename a column in 8i, it just depends to what value your compatibility parameter is set Regards JL -Original Message- Sent: Wednesday, February 14, 2001 8:05 AM To: Multiple recipients of list ORACLE-L In Oracle It's not possible to rename a column.You can instead use alias for that column name in your queries. Or you have to create a new table from existing one Drop existing table.And recreate a table by selecting from new table. Regards Bipin --- Heikki Jantunen [EMAIL PROTECTED] wrote: Hi all, I need to rename some columns on my table. Any idea how to do that... Thanks in advance, Hessu _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Heikki Jantunen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?bipin=20sahani?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@i-Commerce Services INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Renaming a Column
Hi All I think I did send one out earlier. Don't bite. You can't rename a column. The combatibility parameter issue I was thinking of has to do with when you want to drop a column in 8i. That I know, has to be greater or equal to 8.1.0 when you want to drop a column Sorry again Regards JL -Original Message- Sent: Wednesday, February 14, 2001 2:10 PM To: Multiple recipients of list ORACLE-L Ok i'll bite, i try to keep up with the new features and i'm looking at 8i(8.1.7) docs right now and i dont see it, would you like to elaborate? you can rename a table, rename a partition but NOT rename a column, this has been on the wish-list for many years just like drop column was. Feel free to flame me if i'm wrong(it does happen but rarely) :) joe "Johan Locke@i-Commerce Services" wrote: Wait wait wait... Yes you can rename a column in 8i, it just depends to what value your compatibility parameter is set Regards JL -Original Message- Sent: Wednesday, February 14, 2001 8:05 AM To: Multiple recipients of list ORACLE-L In Oracle It's not possible to rename a column.You can instead use alias for that column name in your queries. Or you have to create a new table from existing one Drop existing table.And recreate a table by selecting from new table. Regards Bipin --- Heikki Jantunen [EMAIL PROTECTED] wrote: Hi all, I need to rename some columns on my table. Any idea how to do that... Thanks in advance, Hessu _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Heikki Jantunen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?bipin=20sahani?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@i-Commerce Services INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@i-Commerce Services INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai
RE: Off Topic: Row Locking - Row Id
Hi Jared Thanx for the reply. I'll do some stress testing, and keep you up to date. (I'm not too optimistic though) Cheers JL -Original Message- Sent: Tuesday, February 13, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Depending on your application design, you may find a locking scheme useful. Below is an example that uses rowid to take out a lock. Note that this is not a lock on an object, but simply a lock identified by a rowid. As the demo is setup, the locks are automatically released on rollback or commit, which would include exiting a session. Not for use on OPS w/MTS. See dbmslock.sql for details. Jared -- -- run this part from session A: drop table lock_test; create table lock_test ( name varchar2(10) not null ); insert into lock_test values ( 'nebula'); insert into lock_test values ( 'quasar'); insert into lock_test values ( 'pulsar'); insert into lock_test values ( 'red dwarf'); insert into lock_test values ( 'Lister'); insert into lock_test values ( 'Rimmer'); insert into lock_test values ( 'Cat'); commit; -- Then run this section from session A and session B declare cursor c_hoser ( hoser_name_in lock_test.name%type ) is select rowid from lock_test where name = hoser_name_in; lock_handle pls_integer; v_hoser_rowid rowid; v_lock_handle pls_integer; v_lock_result pls_integer; v_name_to_book lock_test.name%type; begin v_name_to_book := 'Lister'; open c_hoser(v_name_to_book); fetch c_hoser into v_hoser_rowid; close c_hoser; v_lock_handle := dbms_utility.get_hash_value(v_hoser_rowid,100,power(2,20)); v_lock_result := dbms_lock.request( id = v_lock_handle , timeout = 1 , release_on_commit = true ); if v_lock_result = 0 then dbms_output.put_line( 'You have booked ' || v_name_to_book ); elsif v_lock_result = 1 then dbms_output.put_line( v_name_to_book || ' is currently booked'); else dbms_output.put_line( 'Error attempting to lock ' || v_name_to_book || ' return val: ' || to_char(v_lock_result)); end if; end; / -- On Mon, 12 Feb 2001, Johan Locke@i-Commerce Services wrote: Thanks Riyaj Unfortunately it doesn't solve my problem. It only helps if the transaction is BLOCKING another transaction. This is my requirement, maybe somebody has a good solution. A product selection engine. There are a limited number of products, each unique. Person A comes in over the web (this important). Looks at the products and "books" the product he wants. At this stage I just want to issue a "SELECT FOR UPDATE" - without commiting. Person A goes through the payment selection, and if succesfull, the product is marked as "bought" and the transaction commited. If during the process of payment authorisation for Person A, person B looks through the products, Person B must see the product person A is buying as "Booked - not yet bought". Why don't I just set a flag in the row, commit it, do the payment and commit that? -- If for some reason person A's web session terminates voluntarily or involuntarily, I'd have to run a process in the background which cleans up the flags. As this is a very processing intensive table, it slows down the processing tremendously. Conversly, if I could use the user's web session termination, which will terminate the database session, to make oracle release the lock on that row it makes my life a lot easier. About 90% of the people will access the site within a period of about an 1-2 hours (within which you're aiming to sell 54000 of the 6 products) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@i-Commerce Services INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yoursel
RE: Off Topic: Row Locking - Row Id
Hi Not realy what I was looking for. Thanks anyways Regards JL -Original Message- Sent: Monday, February 12, 2001 10:41 AM To: Multiple recipients of list ORACLE-L hi, you can simply include the hidden(or embedded) column in your querry as u write other columns. this is the column which is locked in every table. and can give u the desired value for each row.. try select col1, col2,., rowid from tablename; saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 12, 2001 10:35 AM Hi Anybody have any idea where I can find the rowid of a row that is being locked within a table? Kind Regards JL -Original Message- Sent: Monday, February 12, 2001 5:40 AM To: Multiple recipients of list ORACLE-L Hi In my opinion, this is an ITL issue. When a process need an ITL and have to wait for it , then it pseudo randomly selects a locked row (from that block) and enqueues itself in to the waiters queue. But the row_waited information in v$session will be null. In rare cases, it is possible for the deadlock to occur if the ITL waiter holds the row that is needed by the other process. I would ask, what is the frequency of this deadlock ? Is this the first occurrence ? If it is the first occurrence, then I would wait for the next occurrence and then spend time and resource. Hope this helps!! Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA "These are my opinions and does not bind my employer. Use at your risk" elkinsl@flash .net To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Deadlock Interpretation Assistance Requested com 02/10/01 07:00 PM Please respond to ORACLE-L Listers, HP-UX 11.0, V7.3.4.3. Deadlock trace file snippet: SELECT * FROM UNIT_STATISTICS WHERE UNIT_ID = :b1 AND MONTH = :b2 AND YEAR = :b3 AND RANK_CODE = :b4 FOR UPDATE OF QUANTITY snip Deadlock graph: -Blocker(s) -Waiter(s) -- --- Resource Name process session holds waits process session holds waits TX-00180008-42d6 837 635 X784 481 S TX-00160010-4412 784 481 X837 635 X Rows waited on: Session 481: no row Session 635: obj - rowid = 0722 - 0289.0033.0102 I've never really encountered all that many deadlocks before. The ones I *have* seen in the past were the "classic" TX locks where user A has a row locked that user B needs and vice versa and the mode requested was X. On Friday, the DBA's sent me a trace file from a deadlock (with the info above from that trace file) and asked me to investigate. The deadlocks they had seen in the past were due to application coding issues, hence their tossing this to the development side of the house. After a lot of research on Metalink, the Steve Adams site (http://www.ixora.com.au), and Usenet archive searches (www.deja.com), the S mode wait for session 481 (and no row) makes me think this isn't the typical application induced deadlock due to the way and order in which locks are acquired. There are 3 foreign keys on the table, and, each of them are indexed. There is no bitmap index. PCT_FREE is 10 and PCT_USED is 40. I don't really know all that much about how heavily DML is issued against the table. But, after reading material on when the wait is in S mode, I wonder if this might be an ITL issue. From what I've read the past 2 days, there could be other reasons for the S mode wait, but, waits for Unique/PK enforcement, insufficient ITL slots, and bitmap index were the most common reasons mentioned. Because the statement reported was a SELECT FOR UPDATE, I've eliminated (correctly?) the check for uniqueness wait during inserts, and, with no bitmap index on the table, that leaves the ITL slots as the main candidate. What I need to do is determine if this is indeed an application coding issue, or, if I need to kick this back to the DBA's and let them research it. And I don't mean that in a finger pointing way. The DBA's and developers there work well together. From what I've read and learned so far, this deadlock doesn't seem to be an application coding issue. I am thinking about saying that and asking them (if they haven't already) to open a TAR and provide the trace file to Oracle Support. If anyone has any comments or suggestions, I would appreciate hearing them (because if this could still be due to an application coding issue, more research needs to be done on the development and/or my side of the house). Regards, Lar
Off Topic: Row Locking - Row Id
Hi Anybody have any idea where I can find the rowid of a row that is being locked within a table? Kind Regards JL -Original Message- Sent: Monday, February 12, 2001 5:40 AM To: Multiple recipients of list ORACLE-L Hi In my opinion, this is an ITL issue. When a process need an ITL and have to wait for it , then it pseudo randomly selects a locked row (from that block) and enqueues itself in to the waiters queue. But the row_waited information in v$session will be null. In rare cases, it is possible for the deadlock to occur if the ITL waiter holds the row that is needed by the other process. I would ask, what is the frequency of this deadlock ? Is this the first occurrence ? If it is the first occurrence, then I would wait for the next occurrence and then spend time and resource. Hope this helps!! Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA "These are my opinions and does not bind my employer. Use at your risk" elkinsl@flash .net To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Deadlock Interpretation Assistance Requested com 02/10/01 07:00 PM Please respond to ORACLE-L Listers, HP-UX 11.0, V7.3.4.3. Deadlock trace file snippet: SELECT * FROM UNIT_STATISTICS WHERE UNIT_ID = :b1 AND MONTH = :b2 AND YEAR = :b3 AND RANK_CODE = :b4 FOR UPDATE OF QUANTITY snip Deadlock graph: -Blocker(s) -Waiter(s) -- --- Resource Name process session holds waits process session holds waits TX-00180008-42d6 837 635 X784 481 S TX-00160010-4412 784 481 X837 635 X Rows waited on: Session 481: no row Session 635: obj - rowid = 0722 - 0289.0033.0102 I've never really encountered all that many deadlocks before. The ones I *have* seen in the past were the "classic" TX locks where user A has a row locked that user B needs and vice versa and the mode requested was X. On Friday, the DBA's sent me a trace file from a deadlock (with the info above from that trace file) and asked me to investigate. The deadlocks they had seen in the past were due to application coding issues, hence their tossing this to the development side of the house. After a lot of research on Metalink, the Steve Adams site (http://www.ixora.com.au), and Usenet archive searches (www.deja.com), the S mode wait for session 481 (and no row) makes me think this isn't the typical application induced deadlock due to the way and order in which locks are acquired. There are 3 foreign keys on the table, and, each of them are indexed. There is no bitmap index. PCT_FREE is 10 and PCT_USED is 40. I don't really know all that much about how heavily DML is issued against the table. But, after reading material on when the wait is in S mode, I wonder if this might be an ITL issue. From what I've read the past 2 days, there could be other reasons for the S mode wait, but, waits for Unique/PK enforcement, insufficient ITL slots, and bitmap index were the most common reasons mentioned. Because the statement reported was a SELECT FOR UPDATE, I've eliminated (correctly?) the check for uniqueness wait during inserts, and, with no bitmap index on the table, that leaves the ITL slots as the main candidate. What I need to do is determine if this is indeed an application coding issue, or, if I need to kick this back to the DBA's and let them research it. And I don't mean that in a finger pointing way. The DBA's and developers there work well together. From what I've read and learned so far, this deadlock doesn't seem to be an application coding issue. I am thinking about saying that and asking them (if they haven't already) to open a TAR and provide the trace file to Oracle Support. If anyone has any comments or suggestions, I would appreciate hearing them (because if this could still be due to an application coding issue, more research needs to be done on the development and/or my side of the house). Regards, Larry G. Elkins [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other