How to see it?
RE: Re[2]: sequence numbers
We were asked, not too long ago, to create one Oracle8i database with only *one* table with some 700+ columns. While at it, the consultant (hired by end user dept) also suggested that we make it an IOT using an LMT, and since the table will never grow over 1GB, asked if there was a way to put it in KEEP buffer pool. He was helping re-write/enhance some MS Access Apps. Talk about knowing all the right lingo... ;) - Kirti -Original Message- Sent: Friday, October 11, 2002 8:59 AM To: Multiple recipients of list ORACLE-L April, What can I say? Ouch! I feel your pain. I've been trapped in some pretty ridiculous situations too. (Though, I think you have me beat! A 37 column primary key?? Really??) Well, you at least seem to have the proper attitude. ;-) Without a sense of humor, I'm afraid you'd go insane in short order! ;-) The only other thing I can think of when people shut you down like that is: document. At meeting X, on such and such a date, I identified this problem, and Mr. Z told me to not to worry about it. It may not help, but from a sanity point of view, there is a certain amount of satisfaction in I told you so!, even if you never verbalize it;-) Hang in there, -Mark On Fri, 2002-10-11 at 08:43, April Wells wrote: Mark... If this were the MOST serious design flaw in the whole mess, I wouldn't care so much. There is a point where you just shut up (gee, I have been TOLD to do that in meetings) and wait till it breaks (or worse, one of our clients buys it and we have to TRY to implement). I am the funny one... the one to laugh at and make fun of because I keep trying to tell them that you can't do things. You can't have a totally denormalized Oracle table if there 1500 columns in it... yes queries will fly on a table that can't be built. You can't have 37 columns in a primary key. Date really isn't an acceptable name for a column. April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message- Sent: Thursday, October 10, 2002 7:34 PM To: Multiple recipients of list ORACLE-L Hi Dick, I have to disagree with you here. Particularly in the case where this sequence will see any sort of concurrency, from multiple concurrent sessions accessing it. This is due to the serialization on the SQ enqueue. This will cause far worse scalability issues than any I/O. Not that I/O is insignificant, but in this situation, serialization on the enqueue will be the real showstopper for scalability. As to losing the cached values, well, so what? If your design is such that it's important to have an unbroken contiguous sequence of numbers with no gaps, then I would argue that is a serious design flaw. Also, if that's your requirement, then a sequence is not appropriate, since it can and will end up causing gaps, the first time you roll back a transaction. Finally, as to sequences losing cached values, unless your instance crashes or does a shutdown abort, Oracle should not loose any sequence values. -Mark On Thu, 2002-10-10 at 18:18, [EMAIL PROTECTED] wrote: Actually there is no IO penalty since Oracle has to treat the sequence just like any table with the old LRU algorithm. I have several sequences with a cache of 0 and they perform as well as those with a cache value. The big difference is when you shut down the database and all of those cached values end up in the trash. Dick Goulet Reply Separator Author: Yechiel Adar [EMAIL PROTECTED] Date: 10/10/2002 1:38 PM I think that you will have an update to the sequence number EVERY time instead of every 20 times. That's mean I/o for every nextval. Yechiel Adar Mehish - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, October 10, 2002 7:43 PM Subject: Re: sequence numbers CACHE 20 is the default, so if you remove the clause, it will have absolutely no impact on performance or anything else... ...of course, I get the feeling that that wasn't the gist of your question, was it? - Original Message - From: April Wells To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 09, 2002 8:54 AM Subject: sequence numbers I have been given create scripts for sequences to be used in tables that will be loaded via bulk loads. How huge is the potential performance hit if I take out the cache 20? April Wells Oracle DBA There is neither good nor bad, but thinking makes it so. -Shakespeare !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=text/html; charset=iso-8859-1 http-equiv=Content-Type META content=MSHTML 5.00.2314.1000 name=GENERATOR STYLE/STYLE /HEAD BODY
Re: [Q] ORACLE 9.2 and different version of client?
In theory all three clients will work with 9iRelease2. However, we have encountered a problem where the client is 8.0.6, connects to a 9.2 database which has a database link to an 8.1.7 database -- queries across the db-link result in an ORA-3120 error. The analyst closed the TAR has 8.0.6 is desupported -- we tried even with tha 8.0.6.3 Patchset on the client. A 9.2 client connecting to 7.3.4 is certainly NOT supported. See Note 207319.1 on MetaLink. Hemant At 06:23 AM 11-10-02 -0800, you wrote: we plan to upfrade our database from ORACLE 8.1.7 to 9.2. The database on SUn Solaris server. My question are: 1. will following version of ORACLE client(on PC) work with ORACLE 9.2 server? 7.3.4 client 8.0.5 client 8.1.6 client 2. can ORACLE client 9.2 work with following version of ORACLE server? 7.3.4 server 8.0.5 server 8.1.6 server Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CPU WAIT I/O statistic
Pablo What does your I/O look like while %wio is high? Specifically, I would suggest: - Look at the disk subsystem I/O, is it experiencing a high rate of I/O? - Run STATSPACK and see which tablespaces are hot. - Are a lot of table scans being executed? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 10, 2002 11:13 PM To: Multiple recipients of list ORACLE-L First a minor correction: sar -u has %wio and not sar -q. Now, %wio reports the % of the time the CPU was idle while processes, that otherwise would have run, waited for the outstanding I/O requests to complete. I believe the next few sentences in the book shed more light on %wio and attempt to simplify it further... - Kirti -Original Message- Sent: Thursday, October 10, 2002 4:19 PM To: Multiple recipients of list ORACLE-L Dennis: Thanks for answering, what do you mean by, or may be what do you think Gaja means by: He points out that the Solaris sar -q command has a %wio column, a measure of processes that are currently using the CPU, but are waiting for I/O requests to be serviced and hence are not making prudent use of the CPU How can the processes be using the CPIU if they are waiting for some I/O requests? What I'm trying to say is that that can't consume CPU cicles if they are waiting (SLEEPING). Why does sar shows that these CPU cicles are used in waiting for I/O? Who's using them? TIA Pablo - I posted the following paragraph yesterday: 3) I looked in Oracle Performance Tuning 101 to see what Gaja has to say. He points out that the Solaris sar -q command has a %wio column, a measure of processes that are currently using the CPU, but are waiting for I/O requests to be serviced and hence are not making prudent use of the CPU. He further says that %sys and %wio should be less than 10-15% and if it is consistently higher you need to get to the bottom of it, and usually it is a application causing the problem. No details on how to get to the bottom. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 10, 2002 3:16 PM To: Multiple recipients of list ORACLE-L Hi list Can anyone explain me what exactly does the WAIT I/O column of the sar -u output mean? Does it represent the % of CPU used by the kernel processes to perform I/O? As far as I know the waiting processes do no wait actively when they ask for an I/O. right? The OS uses the SLEEP and WAKEUP primitives. So, Which process is using this CPU? (The WAIT I/O%) Or does this WAIT I/O have to be taken as if the CPU were idle? Please shed some light on this. Thanks ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20Rodriguez?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] ORACLE 9.2 and different version of client?
Using clients 9 be ready for a question from someone that connect internal works with 9i too! :-) One day a developer came to me and said that contrary to what I had told him he was able to connect as internal into a 9iR2 test DB, and he showed me. Later I figured out that he was using 8.0.5 client and concluded that 8 client sends INTERNAL as SYS AS SYSDBA to the server. Regards Naveen -Original Message- Sent: Friday, October 11, 2002 8:29 PM To: Multiple recipients of list ORACLE-L In theory all three clients will work with 9iRelease2. However, we have encountered a problem where the client is 8.0.6, connects to a 9.2 database which has a database link to an 8.1.7 database -- queries across the db-link result in an ORA-3120 error. The analyst closed the TAR has 8.0.6 is desupported -- we tried even with tha 8.0.6.3 Patchset on the client. A 9.2 client connecting to 7.3.4 is certainly NOT supported. See Note 207319.1 on MetaLink. Hemant At 06:23 AM 11-10-02 -0800, you wrote: we plan to upfrade our database from ORACLE 8.1.7 to 9.2. The database on SUn Solaris server. My question are: 1. will following version of ORACLE client(on PC) work with ORACLE 9.2 server? 7.3.4 client 8.0.5 client 8.1.6 client 2. can ORACLE client 9.2 work with following version of ORACLE server? 7.3.4 server 8.0.5 server 8.1.6 server Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: sequence numbers
it's all in the buzzwords, obviously :) --- Deshpande, Kirti [EMAIL PROTECTED] wrote: We were asked, not too long ago, to create one Oracle8i database with only *one* table with some 700+ columns. While at it, the consultant (hired by end user dept) also suggested that we make it an IOT using an LMT, and since the table will never grow over 1GB, asked if there was a way to put it in KEEP buffer pool. He was helping re-write/enhance some MS Access Apps. Talk about knowing all the right lingo... ;) - Kirti -Original Message- Sent: Friday, October 11, 2002 8:59 AM To: Multiple recipients of list ORACLE-L April, What can I say? Ouch! I feel your pain. I've been trapped in some pretty ridiculous situations too. (Though, I think you have me beat! A 37 column primary key?? Really??) Well, you at least seem to have the proper attitude. ;-) Without a sense of humor, I'm afraid you'd go insane in short order! ;-) The only other thing I can think of when people shut you down like that is: document. At meeting X, on such and such a date, I identified this problem, and Mr. Z told me to not to worry about it. It may not help, but from a sanity point of view, there is a certain amount of satisfaction in I told you so!, even if you never verbalize it;-) Hang in there, -Mark On Fri, 2002-10-11 at 08:43, April Wells wrote: Mark... If this were the MOST serious design flaw in the whole mess, I wouldn't care so much. There is a point where you just shut up (gee, I have been TOLD to do that in meetings) and wait till it breaks (or worse, one of our clients buys it and we have to TRY to implement). I am the funny one... the one to laugh at and make fun of because I keep trying to tell them that you can't do things. You can't have a totally denormalized Oracle table if there 1500 columns in it... yes queries will fly on a table that can't be built. You can't have 37 columns in a primary key. Date really isn't an acceptable name for a column. April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message- Sent: Thursday, October 10, 2002 7:34 PM To: Multiple recipients of list ORACLE-L Hi Dick, I have to disagree with you here. Particularly in the case where this sequence will see any sort of concurrency, from multiple concurrent sessions accessing it. This is due to the serialization on the SQ enqueue. This will cause far worse scalability issues than any I/O. Not that I/O is insignificant, but in this situation, serialization on the enqueue will be the real showstopper for scalability. As to losing the cached values, well, so what? If your design is such that it's important to have an unbroken contiguous sequence of numbers with no gaps, then I would argue that is a serious design flaw. Also, if that's your requirement, then a sequence is not appropriate, since it can and will end up causing gaps, the first time you roll back a transaction. Finally, as to sequences losing cached values, unless your instance crashes or does a shutdown abort, Oracle should not loose any sequence values. -Mark On Thu, 2002-10-10 at 18:18, [EMAIL PROTECTED] wrote: Actually there is no IO penalty since Oracle has to treat the sequence just like any table with the old LRU algorithm. I have several sequences with a cache of 0 and they perform as well as those with a cache value. The big difference is when you shut down the database and all of those cached values end up in the trash. Dick Goulet Reply Separator Author: Yechiel Adar [EMAIL PROTECTED] Date: 10/10/2002 1:38 PM I think that you will have an update to the sequence number EVERY time instead of every 20 times. That's mean I/o for every nextval. Yechiel Adar Mehish - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, October 10, 2002 7:43 PM Subject: Re: sequence numbers CACHE 20 is the default, so if you remove the clause, it will have absolutely no impact on performance or anything else... ...of course, I get the feeling that that wasn't the gist of your question, was it? - Original Message - From: April Wells To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 09, 2002 8:54 AM Subject: sequence numbers I have been given create scripts for sequences to be used in tables that will be loaded via bulk loads. How huge is the potential performance hit if I take out the cache 20? April Wells Oracle DBA There is neither good nor bad, but
RE: Oracle list for developers ??
Forgot the smiley ;-) - it was a rough day. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 7:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle list for developers ?? http://groups.google.com/groups?hl=enlr=ie=UTF-8group=comp.databases.or ac le.tools I know Scott, you were being sarcastic... :-) Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle list for developers ?? No there isn't. And a google search certainly wouldn't turn up any. Give up the quest and read your manuals. That is all. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Controlling Users Logons
They can come in from various 'machines'. - Kirti -Original Message- Sent: Friday, October 11, 2002 9:39 AM To: Multiple recipients of list ORACLE-L Could you use machine from v$session? [EMAIL PROTECTED] 10/11/02 09:48AM Hello Listers, I was asked by a co-worker if there was a way in Oracle to prevent users from connecting to the databases if the same OSUSER has already a created a specified number of sessions to a particular instance. We discussed profiles and resource limits etc. However, the requirement is that the user should a get message that they have exceeded their quota and should not be allowed to log in (there goes the log on trigger). The denial of connection *must* be based on 'OSUSER'. In this environment different OSUSERs use the same Oracle Username for these connections, and the expectation is that the DBA find a solution to enforce some rules. Any tricks? Third party software? Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Controlling Users Logons
Try this: --create_LOGON_MULTIPLE_CHECK.sql CREATE OR REPLACE TRIGGER LOGON_MULTIPLE_CHECK AFTER logon ON DATABASE DECLARE client_info_str V$SESSION.CLIENT_INFO%TYPE; var_usernameV$SESSION.USERNAME%TYPE := null; kill_Login EXCEPTION; PRAGMA EXCEPTION_INIT( kill_Login, -20997 ); begin -- Set information string to uniquely identify this session client_info_str := 'Logon_Trigger_' || LTRIM(dbms_random.value,'.'); -- Push information string into v$session DBMS_APPLICATION_INFO.SET_CLIENT_INFO(client_info_str); -- query v$session and see if this user is logged on twice on machines that are not exempt begin SELECT unique(b.username) INTO var_username -- look for more than one logon from v$session a,v$session b where a.username=b.username -- is the user exempt? -- trim off the null character that occasionally gets added to the name AND rtrim(A.USERNAME,CHR(0)) NOT IN (SELECT LME_exemptee FROM LOGON_MULTIPLE_EXEMPTIONS WHERE LME_exemption_type = 'U') -- look for two different machines and a.machine != b.machine -- are any of the machines exempt? -- trim off the null character that occasionally gets added to the machine name AND rtrim(A.MACHINE,CHR(0)) NOT IN (SELECT LME_exemptee FROM LOGON_MULTIPLE_EXEMPTIONS WHERE LME_exemption_type = 'M') AND rtrim(B.MACHINE,CHR(0)) NOT IN (SELECT LME_exemptee FROM LOGON_MULTIPLE_EXEMPTIONS WHERE LME_exemption_type = 'M') -- make sure that we are looking at this logon session and a.client_info=client_info_str; EXCEPTION WHEN OTHERS THEN NULL; end; -- if the user has a logon from more than 1 non-exempt machine then kill this logon! IF var_username is not null THEN RAISE kill_Login; END IF; EXCEPTION WHEN kill_Login THEN RAISE_APPLICATION_ERROR(-20997,'This account is logged on via another machine!'); WHEN OTHERS THEN null; END; / We are allowing multiple logons from the same machine and some userids are allowed to logon from multiple machines but the basic force of this trigger is to allow a userid to be logged on from only one machine. i.e., users are not allowed to share userids. You'll want to change the logic but the basic mechanism is there. We handle exemptions through a table on the database. HTH Deshpande, Kirti To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] kirti.deshpacc: nde Subject: Controlling Users Logons @verizon.com Sent by: root 10/11/2002 09:48 AM Please respond to ORACLE-L Hello Listers, I was asked by a co-worker if there was a way in Oracle to prevent users from connecting to the databases if the same OSUSER has already a created a specified number of sessions to a particular instance. We discussed profiles and resource limits etc. However, the requirement is that the user should a get message that they have exceeded their quota and should not be allowed to log in (there goes the log on trigger). The denial of connection *must* be based on 'OSUSER'. In this environment different OSUSERs use the same Oracle Username for these connections, and the expectation is that the DBA find a solution to enforce some rules. Any tricks? Third party software?
RE: Thanks - Oracle list for developers ??
Thanks to all who responded helpfully. SY. ^^ Hey Scott, I think he was excluding you... :-) -Original Message- Sent: Friday, October 11, 2002 8:34 AM To: Multiple recipients of list ORACLE-L Thanks to all who responded helpfully. SY. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 7:08 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject:Re: Oracle list for developers ?? Importance: High Harry, Check into ODTUG. http://www.odtug.com/web_members/mbrsonly_signup.asp Jared Droogendyk, Harry [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/10/2002 03:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle list for developers ?? Listers: While I certainly appreciate the great range of experience and knowledge by the subscribers on this list, if my rudimentary knowledge is to be trusted, I think 95% of the postings are DBA type stuff. Since I'm interested in developer questions / answers I'm asking, again!!, if an Oracle list exists that is developer oriented rather than DBA oriented. TIA for your answers. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Johnston, Tim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: sequence numbers
But the DOCUMENTATION says 8-0 April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message- Sent: Friday, October 11, 2002 10:20 AM To: Multiple recipients of list ORACLE-L it's all in the buzzwords, obviously :) --- Deshpande, Kirti [EMAIL PROTECTED] wrote: We were asked, not too long ago, to create one Oracle8i database with only *one* table with some 700+ columns. While at it, the consultant (hired by end user dept) also suggested that we make it an IOT using an LMT, and since the table will never grow over 1GB, asked if there was a way to put it in KEEP buffer pool. He was helping re-write/enhance some MS Access Apps. Talk about knowing all the right lingo... ;) - Kirti begin 666 InterScan_Disclaimer.txt M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@ M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!) M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@ M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE +;G0N#0H-@T*#0H end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: CodeNotes for Oracle9i...
I have an odd question about these on-line books. Can I copy-and-paste the text? Like many of you, I seem to end up with long commutes (why are the best jobs never in your neighborhood?). I find listening to books on CD to be a better use of time than reading bumper stickers. Nobody ever seems to issue Oracle books on audio. So I got a text-to-voice program, and it works pretty good to create an audio version of a book. But many of these eBooks zealously protect their text and prevent you from doing copy-and-paste on the text. Fortunately Oracle makes their books readily available. Any ideas are welcome. And my apologies to the authors on the list that are going he wants to do WHAT with my book!!. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 10, 2002 7:54 PM To: Multiple recipients of list ORACLE-L I believe the Book Safari is changing. It is supposed to be more flexible now. http://www.oreilly.com/news/new_safari_0902.html Jared Grabowy, Chris [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/08/2002 01:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:CodeNotes for Oracle9i... So every few months my Lookout reminder pops up to remind me to check out what new Oracle books have been released. I stumbled upon a new book called CodeNotes for Oracle9i on Amazon.com, but the interesting part is that it is available in eBook format. Here's the (probably broken) link... http://www.amazon.com/exec/obidos/tg/detail/-/B6ISCN/qid=1034101493/sr=1 -25/ref=sr_1_25/104-5919725-7522346?v=glance The eBook version is $9.95 and the shipping is free (big grin), while the paperback is $13.97 plus shipping. Are you comfortable reading an eBook? You decide. At any rate, I will probably break down and buy the eBook. Not so much because the book is great (or not) but because I hope to send a message to publishers to publish more books in the eBook format, which is also why I posted this message. I know that O'Reilly has the Safari Bookshelf website, but I found it to be restrictive and pricey. BTW, if for some reason you are or will be using .Net, the CodeNotes eBook version is free... http://www.codenotes.com/do/downloads/downloadsNETbook -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to see it?
You're right... How can I see it? -Original Message-From: hukangang [mailto:[EMAIL PROTECTED]]Sent: Friday, October 11, 2002 3:38 AMTo: Multiple recipients of list ORACLE-LSubject: How to see it?
RE: CodeNotes for Oracle9i...OT
It still seems to be restrictive and pricey to me. The 30 books-a-month at a one time yearly fee is $300. At the end of the year, what do you have? Another $300 bill for the next year. And how many books do you have access too, if you don't dish out another $300, ZERO. With bookpool.com, for $300 I can buy quite a few books, that I will still have after one year. Granted after 3 or 4 years those books will be retired, but they definitely paid for themselves. And if my site is slow to upgrade then I may keep my books for even longer...some sites are still running Oracle7. Additionally, paper books are great since you can highlight, mark, scribble notes, attach tabs to the page, etc. Obviously, if I work for a company that has deep pockets then they can pay the bill, but that doesn't appear to be the case today. I love Oreilly books, I just don't like the Safari Bookshelf website deal. This business model needs more work...perhaps they have snagged 9,999 customers, but if they dropped the prices and dropped the restrictions then they will get 999,999,999,999,999 customers. (stepping down from my soapbox, my apologies for my off-topic ranting and raving, thank God it's Friday) -Original Message- Sent: Thursday, October 10, 2002 8:54 PM To: Multiple recipients of list ORACLE-L I believe the Book Safari is changing. It is supposed to be more flexible now. http://www.oreilly.com/news/new_safari_0902.html Jared Grabowy, Chris [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/08/2002 01:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:CodeNotes for Oracle9i... So every few months my Lookout reminder pops up to remind me to check out what new Oracle books have been released. I stumbled upon a new book called CodeNotes for Oracle9i on Amazon.com, but the interesting part is that it is available in eBook format. Here's the (probably broken) link... http://www.amazon.com/exec/obidos/tg/detail/-/B6ISCN/qid=1034101493/ sr=1-25/ref=sr_1_25/104-5919725-7522346?v=glance The eBook version is $9.95 and the shipping is free (big grin), while the paperback is $13.97 plus shipping. Are you comfortable reading an eBook? You decide. At any rate, I will probably break down and buy the eBook. Not so much because the book is great (or not) but because I hope to send a message to publishers to publish more books in the eBook format, which is also why I posted this message. I know that O'Reilly has the Safari Bookshelf website, but I found it to be restrictive and pricey. BTW, if for some reason you are or will be using .Net, the CodeNotes eBook version is free... http://www.codenotes.com/do/downloads/downloadsNETbook -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PROCESS column in V$SESSION
For folks connecting to the DB server from another Unix box the PROCESS field is the Process ID on the host named in the MACHINE field. For folks connecting to the DB server from a PC the values are in the form of : So what do signify? WENDYC wendyc 1112:1116 HDSWIN\CSCSOPC034 WENDYC wendyc 1172:1140 HDSWIN\CSCSOPC034 MWH williamd22968 pan MWH williamd26653 pan OPS$WILLIAMD williamd26974 titan OPS$WKLINE wkline 22717 titan OPS$WSPENCER wspencer24664 titan OPS$WSPENCER wspencer4824 titan YSULLIVA ysulliva728:300 HDSWIN\CSCCSPC105 YSULLIVA ysulliva1104:1076 HDSWIN\CSCCSPC105 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle9i upgrade exam - Recommended books/material? (Borderin
Thanks a bunch! I'm Looking forward to 10i!! Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 3:50 PM To: Multiple recipients of list ORACLE-L (Borderin Robert, If you don't mind , both books are good as I passed my 9i upgarde with the help of both books and I shall give credit to you and Daniel for writing these books. However, yours was the first one which I bought sometime in Jan'2002 and his book was released end March, 2002. Thanks again for your excellent effort. Now will wait for your book on Rman as you already given the url for that. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 10 Oct 2002 10:28:16 -0800 Thanks Dennis! I'm sitting here dying because one of my stereo headphone speakers i do ng t is t m ri gt n w. ARRRUUU. Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Friday, September 13, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Kieran - I haven't read it because I am still working out the 8i OCP tests, but here is a link to a book by Robert Freeman, who participates on this list. It has been recommended by other list members in the past. http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=0E2CIPD0W 9isbn=0072223855 Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Friday, September 13, 2002 11:53 AM To: Multiple recipients of list ORACLE-L Hi everyone, I'm looking to do the OCP upgrade exam from 8i to 9i (#1Z0-030 Oracle9i New Features for Administrators). Could anyone recommend some good reading material on the matter? I see the Osbourne Book (by Daniel Benjamin) got some fairly mediocre reviews. Your opinions would be very much appreciated, Kieran Murray Development DBA CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin Ireland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray 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: DENNIS WILLIAMS 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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing:
RE: Verrrry interesting article at MetaLink
Allegedly, even cars will have ctrl-alt-del buttons. I leave the automotive implementation of BSOD to your imagination. I can envision people bragging about their brand new cars: I have one, I forgot the maker, but it has 64GB of RAM, 4.8 GHZ CPU and the latest WheelBlaster+ with MS 2007 tires. To quote the good, old Satchmo: what a wonderful world! -Original Message- From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Subject: RE: Vey interesting article at MetaLink (shaking my head) You guys are killing me. Since Microslop is going to include SQL Server Enterprise edition with every copy of Windows, Windows CE, Windows Mobile, etc, Oracle will lose considerable market share. Dozens of lawsuits will be filed, but since MS has paid off all the judges, the President, Congress (like today) it won't matter...Oracle will be history... -Original Message- Sent: Thursday, October 10, 2002 3:50 PM To: Multiple recipients of list ORACLE-L 2007 would not give enough time to complete the class time for the more rigorous OCP 256i requirements. Quit spreading false rumours. -Original Message- Sent: Thursday, October 10, 2002 2:28 PM To: Multiple recipients of list ORACLE-L That's interesting. I'd heard it was for OpenWorld '07. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 10, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Actually, Oracle 256i is slated for a June, 2012 release. -Original Message- Sent: Thursday, October 10, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Wow! That's the way to have your name remembered for eternity! Having your name carved in stone is one thing, but having your name embedded into the oracle source code is something much better. Jared, in a few millenniums, with Oracle 256(i?) you'll be one of the most celebrated individuals in the galaxy, standing next to Hari Seldon or Zaphod Beeblebrox. -Original Message- From: Cary Millsap [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 3:58 AM To: Multiple recipients of list ORACLE-L Subject: RE: Vey interesting article at MetaLink I've learned that those two emotions are not mutually exclusive. If you name's not in Oracle's source code somewhere, then I'd suggest you write someone at Oracle a note. It's an easy problem for them to solve. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas -Original Message- Still Sent: Thursday, October 10, 2002 2:13 AM To: Multiple recipients of list ORACLE-L Dear list, I found something rather interesting on MetaLink today. While doing a little research on UTL_FILE, I came across document # 1050919.6. This document deals with how to dump a table to an ascii file. http://metalink.oracle.com/metalink/plsql/ml2_documents.showDo cument?p_d atabase_id=NOTp_id=1050919.6 I began to think the code looked a little familiar. Then I saw the temporary file name of '_dtmp.sql', which was rather reminiscent of file names I use. Further perusal revealed that the comments were written by yours truly, and match word for word those I added to the dump.sql script years ago. See for yourself: http://www.cybcon.com/~jkstill/util/zips/dump.sql I don't know whether to be flattered or upset. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a
RE: Controlling Users Logons
Title: RE: Controlling Users Logons Kirti ... you can still use the logon trigger ... if total_user_logons max_allowed then raise_application_error ('-20001','You seem to have exceeded your quota,' || 'Please come to the DBA group with a Banker''s Check.' || We no longer accept credit cards or personal checks.'); end if; Once the error is raised, it will log them out in the on logon trigger. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: Controlling Users Logons They can come in from various 'machines'. - Kirti *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Controlling Users Logons
Kirti, I used this to control users not to connect using SQLPLUS, TOAD, NAVIGATOR, etc. Try it to check if it works for you. -- Start of DDL Script for Trigger SYS.LOGON_AUDIT_T -- Generated 20-May-2002 05:31:48 p.m. from U20188@PROD CREATE OR REPLACE TRIGGER sys.logon_audit_t after logon on database declare user_name varchar2(30); program_name varchar2(40); machine_name varchar2(40); user_number number; logon_date date; contador integer; contador1 integer; external_tool boolean := false; cursor c1 is select username, program , machine, sysdate from v$session where audsid=userenv('sessionid'); begin open c1; fetch c1 into user_name, program_name, machine_name, logon_date; close c1; insert into logon_audit values(user_name, program_name,machine_name, logon_date); commit; select count(*) into contador1 from v$session where username = user_name andmachine = machine_name; select user# into user_number from sys.user$ where name = user_name; select count(*) into contador from user$ where type# = 0 and user# in (select privilege# from sysauth$ where grantee# = user_number and privilege# in (select user# from user$ where type#=0 and name in ('DBA_JUNIOR','DBA_SENIOR'))); if ( (upper(program_name) LIKE ('%PLUS%') or upper(program_name) LIKE ('%TOAD%') OR upper(program_name) LIKE ('SQLNAV%')) ) then external_tool := true; end if ; if (external_tool) and (contador=0) then raise_application_error(-20001,'No puede conectarse utilizando esta aplicacion'); end if; if (contador=0) and (contador1=0) then raise_application_error(-20001,'No puede conectarse desde esta terminal'); end if; exception when others then raise_application_error(-20001,'No puede ningun privilegio asignado, contacte del depto de seguridad de sistemas'); end; / Luck, Ramon -Original Message- Kirti Sent: Friday, October 11, 2002 10:14 AM To: Multiple recipients of list ORACLE-L They can come in from various 'machines'. - Kirti -Original Message- Sent: Friday, October 11, 2002 9:39 AM To: Multiple recipients of list ORACLE-L Could you use machine from v$session? [EMAIL PROTECTED] 10/11/02 09:48AM Hello Listers, I was asked by a co-worker if there was a way in Oracle to prevent users from connecting to the databases if the same OSUSER has already a created a specified number of sessions to a particular instance. We discussed profiles and resource limits etc. However, the requirement is that the user should a get message that they have exceeded their quota and should not be allowed to log in (there goes the log on trigger). The denial of connection *must* be based on 'OSUSER'. In this environment different OSUSERs use the same Oracle Username for these connections, and the expectation is that the DBA find a solution to enforce some rules. Any tricks? Third party software? Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
Re: How to see it?
me too :-) Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Johnston, Tim To: Multiple recipients of list ORACLE-L Sent: Friday, October 11, 2002 11:44 AM Subject: RE: How to see it? You're right... How can I see it? -Original Message-From: hukangang [mailto:[EMAIL PROTECTED]]Sent: Friday, October 11, 2002 3:38 AMTo: Multiple recipients of list ORACLE-LSubject: How to see it?
Re: 9.2 on Red Hat 8.0
On Wed, Oct 09, 2002 at 10:53:57AM -0800, Gogala, Mladen wrote: May I subscribe to the results of your undertaking? My home email is mailto:[EMAIL PROTECTED] May the force be with you. Went great! Well, sort of... I didn't even read the install guide (and the results will show below). I was amazed how it sailed past the link phase. I expected it to blow up there. It didn't, no glibc issues to be seen. I don't have enough memory to actually start the db, however. I get: Fri Oct 11 09:53:18 2002 WARNING: EINVAL creating segment of size 0x0f40 fix shm parameters in /etc/system or equivalent $ oerr ora 27123 27123, 0, unable to attach to shared memory segment // *Cause: shmat() call failed // *Action: check permissions on segment, contact Oracle support 0x0f40 = 256MB I don't even have that much real memory. This is a junker pc I resurrected from the dumpster with duct tape and prayer. On the upside the install was one of the smoothest I've ever seen. Mandrake 9.0 and Ora 9.2.0 seem to be a nice fit (as long as ora support is not an issue). Mandrake 9's installer is really slick, one of the best of any os I've ever seen. Alright, break times over! -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9.2 on Red Hat 8.0 I'm going to try mandrake 9.0, which came out this week, with some 8i and 9i this week. I'll post a followup. Mandrake is basically rh with a better installer, actually one of the best installers I've seen ever! No ora support, just for fun. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Verrrry interesting article at MetaLink
(shaking my head) You guys are killing me. Since Microslop is going to include SQL Server Enterprise edition with every copy of Windows, Windows CE, Windows Mobile, etc, Oracle will lose considerable market share. Dozens of lawsuits will be filed, but since MS has paid off all the judges, the President, Congress (like today) it won't matter...Oracle will be history... -Original Message- Sent: Thursday, October 10, 2002 3:50 PM To: Multiple recipients of list ORACLE-L 2007 would not give enough time to complete the class time for the more rigorous OCP 256i requirements. Quit spreading false rumours. -Original Message- Sent: Thursday, October 10, 2002 2:28 PM To: Multiple recipients of list ORACLE-L That's interesting. I'd heard it was for OpenWorld '07. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 10, 2002 1:04 PM To: Multiple recipients of list ORACLE-L Actually, Oracle 256i is slated for a June, 2012 release. -Original Message- Sent: Thursday, October 10, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Wow! That's the way to have your name remembered for eternity! Having your name carved in stone is one thing, but having your name embedded into the oracle source code is something much better. Jared, in a few millenniums, with Oracle 256(i?) you'll be one of the most celebrated individuals in the galaxy, standing next to Hari Seldon or Zaphod Beeblebrox. -Original Message- From: Cary Millsap [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 3:58 AM To: Multiple recipients of list ORACLE-L Subject: RE: Vey interesting article at MetaLink I've learned that those two emotions are not mutually exclusive. If you name's not in Oracle's source code somewhere, then I'd suggest you write someone at Oracle a note. It's an easy problem for them to solve. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas -Original Message- Still Sent: Thursday, October 10, 2002 2:13 AM To: Multiple recipients of list ORACLE-L Dear list, I found something rather interesting on MetaLink today. While doing a little research on UTL_FILE, I came across document # 1050919.6. This document deals with how to dump a table to an ascii file. http://metalink.oracle.com/metalink/plsql/ml2_documents.showDo cument?p_d atabase_id=NOTp_id=1050919.6 I began to think the code looked a little familiar. Then I saw the temporary file name of '_dtmp.sql', which was rather reminiscent of file names I use. Further perusal revealed that the comments were written by yours truly, and match word for word those I added to the dump.sql script years ago. See for yourself: http://www.cybcon.com/~jkstill/util/zips/dump.sql I don't know whether to be flattered or upset. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want
RE: Controlling Users Logons
Hi Thomas, Thanks a lot for the code. Looks like we can do something very similar. - Kirti -Original Message- Sent: Friday, October 11, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Try this: --create_LOGON_MULTIPLE_CHECK.sql CREATE OR REPLACE TRIGGER LOGON_MULTIPLE_CHECK AFTER logon ON DATABASE DECLARE client_info_str V$SESSION.CLIENT_INFO%TYPE; var_usernameV$SESSION.USERNAME%TYPE := null; kill_Login EXCEPTION; PRAGMA EXCEPTION_INIT( kill_Login, -20997 ); begin -- Set information string to uniquely identify this session client_info_str := 'Logon_Trigger_' || LTRIM(dbms_random.value,'.'); -- Push information string into v$session DBMS_APPLICATION_INFO.SET_CLIENT_INFO(client_info_str); -- query v$session and see if this user is logged on twice on machines that are not exempt begin SELECT unique(b.username) INTO var_username -- look for more than one logon from v$session a,v$session b where a.username=b.username -- is the user exempt? -- trim off the null character that occasionally gets added to the name AND rtrim(A.USERNAME,CHR(0)) NOT IN (SELECT LME_exemptee FROM LOGON_MULTIPLE_EXEMPTIONS WHERE LME_exemption_type = 'U') -- look for two different machines and a.machine != b.machine -- are any of the machines exempt? -- trim off the null character that occasionally gets added to the machine name AND rtrim(A.MACHINE,CHR(0)) NOT IN (SELECT LME_exemptee FROM LOGON_MULTIPLE_EXEMPTIONS WHERE LME_exemption_type = 'M') AND rtrim(B.MACHINE,CHR(0)) NOT IN (SELECT LME_exemptee FROM LOGON_MULTIPLE_EXEMPTIONS WHERE LME_exemption_type = 'M') -- make sure that we are looking at this logon session and a.client_info=client_info_str; EXCEPTION WHEN OTHERS THEN NULL; end; -- if the user has a logon from more than 1 non-exempt machine then kill this logon! IF var_username is not null THEN RAISE kill_Login; END IF; EXCEPTION WHEN kill_Login THEN RAISE_APPLICATION_ERROR(-20997,'This account is logged on via another machine!'); WHEN OTHERS THEN null; END; / We are allowing multiple logons from the same machine and some userids are allowed to logon from multiple machines but the basic force of this trigger is to allow a userid to be logged on from only one machine. i.e., users are not allowed to share userids. You'll want to change the logic but the basic mechanism is there. We handle exemptions through a table on the database. HTH Deshpande, Kirti To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] kirti.deshpacc: nde Subject: Controlling Users Logons @verizon.com Sent by: root 10/11/2002 09:48 AM Please respond to ORACLE-L Hello Listers, I was asked by a co-worker if there was a way in Oracle to prevent users from connecting to the databases if the same OSUSER has already a created a specified number of sessions to a particular instance. We discussed profiles and resource limits etc. However, the requirement is that the user should a get message that they have exceeded their quota and should not be allowed to log in (there goes the log on trigger). The denial of connection *must* be based on 'OSUSER'. In this environment different OSUSERs use the same Oracle Username for these connections, and the expectation is that the DBA find a solution to enforce some rules. Any tricks? Third party software? Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
RE: Oracle9i RMAN Backup and Recovery
Thanks Jared! RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 8:13 PM To: Multiple recipients of list ORACLE-L Looks very enticing Robert, can't wait to see it. Jared Freeman, Robert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/10/2002 07:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle9i RMAN Backup and Recovery Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample chapter available and TOC for you all to look at if you like. Here is the URL: http://shop.osborne.com/cgi-bin/osborne/0072226625.html Enjoy! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 9:28 AM To: Multiple recipients of list ORACLE-L We are in the midst of a big move to RMAN. We use EMC's EDM to do backups, and the SAs have been pushing us towards RMAN for a while now, cause the EDM interface intergrates w/ RMAN seamlessly. It really is a nice backup solution. (We started the process by upgrading all our EDM units to 5.0) Anyhow, we are setting up the RMAN catalog databases ringht on the EDM boxes. (The EDMs are Solaris boxes.) It's working well. We haven't yet fully rolled out, but all our testing has worked fine. We're about to start the production database migration next week. -Mark On Thu, 2002-10-10 at 06:23, Connor McDonald wrote: There is a Metalink note (73431.1) which talks about the rman version compatibility, but it also states: Ensure that the RMAN executable version matches the version of the target database that it is backing up which I presume to mean that you need to run rman from each target and push to the catalog storage management node(s). This is how I've always seen it done - but I've often wondered if one could get away driving eveything from the catalog node, pulling client databases over sqlnet - thus only having a single TSM client (and license) on the rman catalog node. Cheers Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: I'm trying to use RMAN and TSM to backup multiple databases spread across various nodes with some nodes hosting more than one database. The RMAN catalog database will reside on a node different from any of the nodes hosting the other databases. I have long used ADSM without the RMAN clothing to backup the databases. I have convinced the SA's to move on to TSM, and now I need to add the RMAN adornments. I assume I need the SA's to install TDP for Oracle on all the nodes requiring RMAN backup. Do I also need to install it on the machine which will host the catalog database. That database will undergo cold backup using naked TSM. The same question applies to the tdpo.opt file. Do I need multiple TDPO_FS values and multiple tdpo.opt files to hold them. I am also assuming I will start RMAN from one of the databases requiring backup and connect also to the RMAN catalog. Is this typical. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
RE: CodeNotes for Oracle9i...OT
Yes, that's 30 books a month -- up to 360 books a year. How often do you reference that Oracle DBA Handbook 7.3 Edition now? How many people can use your current book simultaneously? How many books are covered in coffee (or Jr's peanut butter sandwich)? Who borrowed the book and never brought it back? Just my Devil's Advocate... :) R2 Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: CodeNotes for Oracle9i...OT It still seems to be restrictive and pricey to me. The 30 books-a-month at a one time yearly fee is $300. At the end of the year, what do you have? Another $300 bill for the next year. And how many books do you have access too, if you don't dish out another $300, ZERO. With bookpool.com, for $300 I can buy quite a few books, that I will still have after one year. Granted after 3 or 4 years those books will be retired, but they definitely paid for themselves. And if my site is slow to upgrade then I may keep my books for even longer...some sites are still running Oracle7. Additionally, paper books are great since you can highlight, mark, scribble notes, attach tabs to the page, etc. Obviously, if I work for a company that has deep pockets then they can pay the bill, but that doesn't appear to be the case today. I love Oreilly books, I just don't like the Safari Bookshelf website deal. This business model needs more work...perhaps they have snagged 9,999 customers, but if they dropped the prices and dropped the restrictions then they will get 999,999,999,999,999 customers. (stepping down from my soapbox, my apologies for my off-topic ranting and raving, thank God it's Friday) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Re[2]: sequence numbers
Let's see, 1 table with 700+ columns that can grow to ~1GB that you want to iot and have in the keep pool. What are you smoking! That's one consultant that I'd HAVE to laugh in his/her face. And he/she would NOT get away with it. Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 10/11/2002 7:19 AM it's all in the buzzwords, obviously :) --- Deshpande, Kirti [EMAIL PROTECTED] wrote: We were asked, not too long ago, to create one Oracle8i database with only *one* table with some 700+ columns. While at it, the consultant (hired by end user dept) also suggested that we make it an IOT using an LMT, and since the table will never grow over 1GB, asked if there was a way to put it in KEEP buffer pool. He was helping re-write/enhance some MS Access Apps. Talk about knowing all the right lingo... ;) - Kirti -Original Message- Sent: Friday, October 11, 2002 8:59 AM To: Multiple recipients of list ORACLE-L April, What can I say? Ouch! I feel your pain. I've been trapped in some pretty ridiculous situations too. (Though, I think you have me beat! A 37 column primary key?? Really??) Well, you at least seem to have the proper attitude. ;-) Without a sense of humor, I'm afraid you'd go insane in short order! ;-) The only other thing I can think of when people shut you down like that is: document. At meeting X, on such and such a date, I identified this problem, and Mr. Z told me to not to worry about it. It may not help, but from a sanity point of view, there is a certain amount of satisfaction in I told you so!, even if you never verbalize it;-) Hang in there, -Mark On Fri, 2002-10-11 at 08:43, April Wells wrote: Mark... If this were the MOST serious design flaw in the whole mess, I wouldn't care so much. There is a point where you just shut up (gee, I have been TOLD to do that in meetings) and wait till it breaks (or worse, one of our clients buys it and we have to TRY to implement). I am the funny one... the one to laugh at and make fun of because I keep trying to tell them that you can't do things. You can't have a totally denormalized Oracle table if there 1500 columns in it... yes queries will fly on a table that can't be built. You can't have 37 columns in a primary key. Date really isn't an acceptable name for a column. April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message- Sent: Thursday, October 10, 2002 7:34 PM To: Multiple recipients of list ORACLE-L Hi Dick, I have to disagree with you here. Particularly in the case where this sequence will see any sort of concurrency, from multiple concurrent sessions accessing it. This is due to the serialization on the SQ enqueue. This will cause far worse scalability issues than any I/O. Not that I/O is insignificant, but in this situation, serialization on the enqueue will be the real showstopper for scalability. As to losing the cached values, well, so what? If your design is such that it's important to have an unbroken contiguous sequence of numbers with no gaps, then I would argue that is a serious design flaw. Also, if that's your requirement, then a sequence is not appropriate, since it can and will end up causing gaps, the first time you roll back a transaction. Finally, as to sequences losing cached values, unless your instance crashes or does a shutdown abort, Oracle should not loose any sequence values. -Mark On Thu, 2002-10-10 at 18:18, [EMAIL PROTECTED] wrote: Actually there is no IO penalty since Oracle has to treat the sequence just like any table with the old LRU algorithm. I have several sequences with a cache of 0 and they perform as well as those with a cache value. The big difference is when you shut down the database and all of those cached values end up in the trash. Dick Goulet Reply Separator Author: Yechiel Adar [EMAIL PROTECTED] Date: 10/10/2002 1:38 PM I think that you will have an update to the sequence number EVERY time instead of every 20 times. That's mean I/o for every nextval. Yechiel Adar Mehish - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, October 10, 2002 7:43 PM Subject: Re: sequence numbers CACHE 20 is the default, so if you remove the clause, it will have absolutely no impact on performance or anything else... ...of course, I get the feeling that that wasn't the gist of your question, was it? - Original Message - From: April Wells To: Multiple recipients of list ORACLE-L
Re: Database Trigger not fireing In Delete Mode
Naba, I think you need something like this CREATE OR REPLACE TRIGGER triggername AFTER INSERT OR UPDATE OR DELETE ON tablename FOR EACH ROW WHEN (NVL(new.fldname1,old.fldname1)is not null and NVL(new.fldname2,old.fldname2)is not null) DECLARE BEGIN processing goes here END; hth, Chaim [EMAIL PROTECTED] (N J Neog)@fatcity.com on 10/11/2002 12:13:26 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi all, I have row level table trigger to fire on DELETE or INSERT or UPDATE Mode . It has to fire on certain condition, meaning I have a WHEN condition also. WHEN Condition is like : when ( NEW.CR_ACCOUNT is not null and NEW.CHQ_DT is not null ) Since, in DELETE mode NEW value contains null , it does not fire. This Problem would have solved if could write WHEN Condition as when ((INSERTING or UPDATING) and NEW.CR_ACCOUNT is not null and NEW.CHQ_DT is not null ) OR (DELETING and OLD.CR_ACCOUNT is not null and OLD.CHQ_DT is not null ) But in WHEN condition one can not write INSERTING or UPDATING. How do i go about it ? Any round about way Thanks Regards. Naba -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to see it?
he used white text on a white background -Original Message-From: Johnston, Tim [mailto:[EMAIL PROTECTED]]Sent: Friday, October 11, 2002 11:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: How to see it? You're right... How can I see it? -Original Message-From: hukangang [mailto:[EMAIL PROTECTED]]Sent: Friday, October 11, 2002 3:38 AMTo: Multiple recipients of list ORACLE-LSubject: How to see it?
RE: Thanks - Oracle list for developers ??
Who'd a thunk it? LOL! Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Johnston, Tim [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 10:39 AM To: Multiple recipients of list ORACLE-L Subject: RE: Thanks - Oracle list for developers ?? Thanks to all who responded helpfully. SY. ^^ Hey Scott, I think he was excluding you... :-) -Original Message- Sent: Friday, October 11, 2002 8:34 AM To: Multiple recipients of list ORACLE-L Thanks to all who responded helpfully. SY. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Advice needed on move to Sun 15K (losing spindles)
I obviously left out a lot of information :). We would be using server partitioning, with seperate ORACLE_HOMES for each database (necessary since we have a variety of versions running). The box would be running 1+0, the Sun reps suggest striping across all disks (my first red flag). I hadn't even thought of the problem of not being able to reboot the server, that's an excellent point. Currently we have absolutely no performance problems on our OLTP database. This whole kerfuffle was an outgrowth of my pushing really hard to get a backup box for our datawarehouse (which currently has no standby, no box that it can restored to and no QA box). The suggestion was made that rather than get a separate box for the datawarehouse - get the 15K and have the OLTP and datawarehouse on different partitions. This would certainly speed up the data transfer between them (data is transferred from OLTP - Data Warehouse on a daily basis). We could then put other databases that access my databases on other partitions (several other databases have snapshots on some of my tables). So this would make some processes more efficient, but i/o on my OLTP database is currently tuned so well that it hurts every time I think of giving it up. One spindle has the Oracle executables with the redo logs on the outside of the disk. Another has the various .dat files, shell scripts, etc, with the archive logs on the outside of the disk. Even when we run really intensive updates our wio rarely gets very high. Regarding the load question: We have fairly active transaction activity during the day but most connections are managed by Microsoft Transaction Server in a middle tier so while there are usually app. 200 sessions (including some old client server apps) we rarely have more than 20 or so active at any one time. The datawarehouse has fewer sessions but often has some resource intensive queries running. If anyone can point me to docs/websites saying that a large caches does *not* make up for fewer disks/spindles I would greatly appreciate it. Currently I'm being told that Sun must know what they're talking about. Thanks again, Jay Miller -Original Message- Sent: Wednesday, October 09, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Others have addressed the performance issues. What about the admin issues? If consolidate to a single server, consider a separate ORACLE_HOME for each database. You may need to apply different patches to fix different problems in various databases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared Miller, Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Advice needed on move to Sun 15K (losing spindles) Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were and I kept saying, but we're not CPU bound, we don't need any more CPU. If anyone can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
RE: Controlling Users Logons
Ramon, Thanks a lot. My problem in using logon trigger turned out to be the 8.1.7.2 version of the database. Raising appl error is just dumping a trace file without killing the session. It does work fine with 8.1.7.4 databases. - Kirti -Original Message- Sent: Friday, October 11, 2002 11:00 AM To: Multiple recipients of list ORACLE-L Kirti, I used this to control users not to connect using SQLPLUS, TOAD, NAVIGATOR, etc. Try it to check if it works for you. -- Start of DDL Script for Trigger SYS.LOGON_AUDIT_T -- Generated 20-May-2002 05:31:48 p.m. from U20188@PROD CREATE OR REPLACE TRIGGER sys.logon_audit_t after logon on database declare user_name varchar2(30); program_name varchar2(40); machine_name varchar2(40); user_number number; logon_date date; contador integer; contador1 integer; external_tool boolean := false; cursor c1 is select username, program , machine, sysdate from v$session where audsid=userenv('sessionid'); begin open c1; fetch c1 into user_name, program_name, machine_name, logon_date; close c1; insert into logon_audit values(user_name, program_name,machine_name, logon_date); commit; select count(*) into contador1 from v$session where username = user_name andmachine = machine_name; select user# into user_number from sys.user$ where name = user_name; select count(*) into contador from user$ where type# = 0 and user# in (select privilege# from sysauth$ where grantee# = user_number and privilege# in (select user# from user$ where type#=0 and name in ('DBA_JUNIOR','DBA_SENIOR'))); if ( (upper(program_name) LIKE ('%PLUS%') or upper(program_name) LIKE ('%TOAD%') OR upper(program_name) LIKE ('SQLNAV%')) ) then external_tool := true; end if ; if (external_tool) and (contador=0) then raise_application_error(-20001,'No puede conectarse utilizando esta aplicacion'); end if; if (contador=0) and (contador1=0) then raise_application_error(-20001,'No puede conectarse desde esta terminal'); end if; exception when others then raise_application_error(-20001,'No puede ningun privilegio asignado, contacte del depto de seguridad de sistemas'); end; / Luck, Ramon - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Re[2]: sequence numbers
I wanted to take a picture with him. .. and take him out to lunch to learn from his experience ... ;-) but it turned out he lasted only for less than a week... ;) (Some developers he was working with knew a bit more Oracle than him) - Kirti -Original Message- Sent: Friday, October 11, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Let's see, 1 table with 700+ columns that can grow to ~1GB that you want to iot and have in the keep pool. What are you smoking! That's one consultant that I'd HAVE to laugh in his/her face. And he/she would NOT get away with it. Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 10/11/2002 7:19 AM it's all in the buzzwords, obviously :) --- Deshpande, Kirti [EMAIL PROTECTED] wrote: We were asked, not too long ago, to create one Oracle8i database with only *one* table with some 700+ columns. While at it, the consultant (hired by end user dept) also suggested that we make it an IOT using an LMT, and since the table will never grow over 1GB, asked if there was a way to put it in KEEP buffer pool. He was helping re-write/enhance some MS Access Apps. Talk about knowing all the right lingo... ;) - Kirti -Original Message- Sent: Friday, October 11, 2002 8:59 AM To: Multiple recipients of list ORACLE-L April, What can I say? Ouch! I feel your pain. I've been trapped in some pretty ridiculous situations too. (Though, I think you have me beat! A 37 column primary key?? Really??) Well, you at least seem to have the proper attitude. ;-) Without a sense of humor, I'm afraid you'd go insane in short order! ;-) The only other thing I can think of when people shut you down like that is: document. At meeting X, on such and such a date, I identified this problem, and Mr. Z told me to not to worry about it. It may not help, but from a sanity point of view, there is a certain amount of satisfaction in I told you so!, even if you never verbalize it;-) Hang in there, -Mark On Fri, 2002-10-11 at 08:43, April Wells wrote: Mark... If this were the MOST serious design flaw in the whole mess, I wouldn't care so much. There is a point where you just shut up (gee, I have been TOLD to do that in meetings) and wait till it breaks (or worse, one of our clients buys it and we have to TRY to implement). I am the funny one... the one to laugh at and make fun of because I keep trying to tell them that you can't do things. You can't have a totally denormalized Oracle table if there 1500 columns in it... yes queries will fly on a table that can't be built. You can't have 37 columns in a primary key. Date really isn't an acceptable name for a column. April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message- Sent: Thursday, October 10, 2002 7:34 PM To: Multiple recipients of list ORACLE-L Hi Dick, I have to disagree with you here. Particularly in the case where this sequence will see any sort of concurrency, from multiple concurrent sessions accessing it. This is due to the serialization on the SQ enqueue. This will cause far worse scalability issues than any I/O. Not that I/O is insignificant, but in this situation, serialization on the enqueue will be the real showstopper for scalability. As to losing the cached values, well, so what? If your design is such that it's important to have an unbroken contiguous sequence of numbers with no gaps, then I would argue that is a serious design flaw. Also, if that's your requirement, then a sequence is not appropriate, since it can and will end up causing gaps, the first time you roll back a transaction. Finally, as to sequences losing cached values, unless your instance crashes or does a shutdown abort, Oracle should not loose any sequence values. -Mark On Thu, 2002-10-10 at 18:18, [EMAIL PROTECTED] wrote: Actually there is no IO penalty since Oracle has to treat the sequence just like any table with the old LRU algorithm. I have several sequences with a cache of 0 and they perform as well as those with a cache value. The big difference is when you shut down the database and all of those cached values end up in the trash. Dick Goulet Reply Separator Author: Yechiel Adar [EMAIL PROTECTED] Date: 10/10/2002 1:38 PM I think that you will have an update to the sequence number EVERY time instead of every 20 times. That's mean I/o for every nextval. Yechiel Adar Mehish - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, October 10, 2002 7:43 PM Subject: Re:
RE: Advice needed on move to Sun 15K (losing spindles)
I suggest reviewing James Morle's paper 'Sane SAN' at http://www.oraperf.com/whitepapers.html. - Kirti -Original Message- Sent: Friday, October 11, 2002 11:15 AM To: Multiple recipients of list ORACLE-L I obviously left out a lot of information :). We would be using server partitioning, with seperate ORACLE_HOMES for each database (necessary since we have a variety of versions running). The box would be running 1+0, the Sun reps suggest striping across all disks (my first red flag). I hadn't even thought of the problem of not being able to reboot the server, that's an excellent point. Currently we have absolutely no performance problems on our OLTP database. This whole kerfuffle was an outgrowth of my pushing really hard to get a backup box for our datawarehouse (which currently has no standby, no box that it can restored to and no QA box). The suggestion was made that rather than get a separate box for the datawarehouse - get the 15K and have the OLTP and datawarehouse on different partitions. This would certainly speed up the data transfer between them (data is transferred from OLTP - Data Warehouse on a daily basis). We could then put other databases that access my databases on other partitions (several other databases have snapshots on some of my tables). So this would make some processes more efficient, but i/o on my OLTP database is currently tuned so well that it hurts every time I think of giving it up. One spindle has the Oracle executables with the redo logs on the outside of the disk. Another has the various .dat files, shell scripts, etc, with the archive logs on the outside of the disk. Even when we run really intensive updates our wio rarely gets very high. Regarding the load question: We have fairly active transaction activity during the day but most connections are managed by Microsoft Transaction Server in a middle tier so while there are usually app. 200 sessions (including some old client server apps) we rarely have more than 20 or so active at any one time. The datawarehouse has fewer sessions but often has some resource intensive queries running. If anyone can point me to docs/websites saying that a large caches does *not* make up for fewer disks/spindles I would greatly appreciate it. Currently I'm being told that Sun must know what they're talking about. Thanks again, Jay Miller -Original Message- Sent: Wednesday, October 09, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Others have addressed the performance issues. What about the admin issues? If consolidate to a single server, consider a separate ORACLE_HOME for each database. You may need to apply different patches to fix different problems in various databases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared Miller, Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Advice needed on move to Sun 15K (losing spindles) Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were and I kept saying, but we're not CPU bound, we don't need any more CPU. If anyone can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may
RE: 9.2 on Red Hat 8.0
Cool. Now we can run Oracle on a Microsoft Xbox. http://www.itworld.com/Comp/2362/021011xboxlinux/ Mark Stahlke Denver Newspaper Agency -Original Message- Sent: Friday, October 11, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Subject:Re: 9.2 on Red Hat 8.0 On Wed, Oct 09, 2002 at 10:53:57AM -0800, Gogala, Mladen wrote: May I subscribe to the results of your undertaking? My home email is mailto:[EMAIL PROTECTED] May the force be with you. Went great! Well, sort of... I didn't even read the install guide (and the results will show below). I was amazed how it sailed past the link phase. I expected it to blow up there. It didn't, no glibc issues to be seen. I don't have enough memory to actually start the db, however. I get: Fri Oct 11 09:53:18 2002 WARNING: EINVAL creating segment of size 0x0f40 fix shm parameters in /etc/system or equivalent $ oerr ora 27123 27123, 0, unable to attach to shared memory segment // *Cause: shmat() call failed // *Action: check permissions on segment, contact Oracle support 0x0f40 = 256MB I don't even have that much real memory. This is a junker pc I resurrected from the dumpster with duct tape and prayer. On the upside the install was one of the smoothest I've ever seen. Mandrake 9.0 and Ora 9.2.0 seem to be a nice fit (as long as ora support is not an issue). Mandrake 9's installer is really slick, one of the best of any os I've ever seen. Alright, break times over! -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9.2 on Red Hat 8.0 I'm going to try mandrake 9.0, which came out this week, with some 8i and 9i this week. I'll post a followup. Mandrake is basically rh with a better installer, actually one of the best installers I've seen ever! No ora support, just for fun. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stahlke, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Advice needed on move to Sun 15K (losing spindles)
Why does management trust a salesman over their own IT professionals? Miller, Jay JayMiller To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @TDWaterhousecc: .comSubject: RE: Advice needed on move to Sun 15K (losing spindles) Sent by: root 10/11/2002 12:14 PM Please respond to ORACLE-L I obviously left out a lot of information :). We would be using server partitioning, with seperate ORACLE_HOMES for each database (necessary since we have a variety of versions running). The box would be running 1+0, the Sun reps suggest striping across all disks (my first red flag). I hadn't even thought of the problem of not being able to reboot the server, that's an excellent point. Currently we have absolutely no performance problems on our OLTP database. This whole kerfuffle was an outgrowth of my pushing really hard to get a backup box for our datawarehouse (which currently has no standby, no box that it can restored to and no QA box). The suggestion was made that rather than get a separate box for the datawarehouse - get the 15K and have the OLTP and datawarehouse on different partitions. This would certainly speed up the data transfer between them (data is transferred from OLTP - Data Warehouse on a daily basis). We could then put other databases that access my databases on other partitions (several other databases have snapshots on some of my tables). So this would make some processes more efficient, but i/o on my OLTP database is currently tuned so well that it hurts every time I think of giving it up. One spindle has the Oracle executables with the redo logs on the outside of the disk. Another has the various .dat files, shell scripts, etc, with the archive logs on the outside of the disk. Even when we run really intensive updates our wio rarely gets very high. Regarding the load question: We have fairly active transaction activity during the day but most connections are managed by Microsoft Transaction Server in a middle tier so while there are usually app. 200 sessions (including some old client server apps) we rarely have more than 20 or so active at any one time. The datawarehouse has fewer sessions but often has some resource intensive queries running. If anyone can point me to docs/websites saying that a large caches does *not* make up for fewer disks/spindles I would greatly appreciate it. Currently I'm being told that Sun must know what they're talking about. Thanks again, Jay Miller -Original Message- Sent: Wednesday, October 09, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Others have addressed the performance issues. What about the admin issues? If consolidate to a single server, consider a separate ORACLE_HOME for each database. You may need to apply different patches to fix different problems in various databases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared Miller, Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Advice needed on move to Sun 15K (losing spindles) Our CIO has suggested that we get a Sun 15K to house all of our
RE: CodeNotes for Oracle9i...OT
And 0 books at the end of year, if you don't renew. I always check my Oracle 3.1 book, just before I log in... Zero, I don't want anyone messing with my books. And developers don't touch my books because their full of coffee, and peanut butter AND jelly stains... So Rich when you sign up for Safari Bookshelf let me know your userid/password...thanks buddy. I'll take you out to lunch...someday. -Original Message- Sent: Friday, October 11, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Yes, that's 30 books a month -- up to 360 books a year. How often do you reference that Oracle DBA Handbook 7.3 Edition now? How many people can use your current book simultaneously? How many books are covered in coffee (or Jr's peanut butter sandwich)? Who borrowed the book and never brought it back? Just my Devil's Advocate... :) R2 Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: CodeNotes for Oracle9i...OT It still seems to be restrictive and pricey to me. The 30 books-a-month at a one time yearly fee is $300. At the end of the year, what do you have? Another $300 bill for the next year. And how many books do you have access too, if you don't dish out another $300, ZERO. With bookpool.com, for $300 I can buy quite a few books, that I will still have after one year. Granted after 3 or 4 years those books will be retired, but they definitely paid for themselves. And if my site is slow to upgrade then I may keep my books for even longer...some sites are still running Oracle7. Additionally, paper books are great since you can highlight, mark, scribble notes, attach tabs to the page, etc. Obviously, if I work for a company that has deep pockets then they can pay the bill, but that doesn't appear to be the case today. I love Oreilly books, I just don't like the Safari Bookshelf website deal. This business model needs more work...perhaps they have snagged 9,999 customers, but if they dropped the prices and dropped the restrictions then they will get 999,999,999,999,999 customers. (stepping down from my soapbox, my apologies for my off-topic ranting and raving, thank God it's Friday) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PROCESS column in V$SESSION
Charlie, = NT Domain = Machine Name Hope this helps. PS - do I get a Home Depot Discount Card for this? :) Tom Mercadante Oracle Certified Professional -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 11:59 AM To: Multiple recipients of list ORACLE-L For folks connecting to the DB server from another Unix box the PROCESS field is the Process ID on the host named in the MACHINE field. For folks connecting to the DB server from a PC the values are in the form of : So what do signify? WENDYC wendyc 1112:1116 HDSWIN\CSCSOPC034 WENDYC wendyc 1172:1140 HDSWIN\CSCSOPC034 MWH williamd22968 pan MWH williamd26653 pan OPS$WILLIAMD williamd26974 titan OPS$WKLINE wkline 22717 titan OPS$WSPENCER wspencer24664 titan OPS$WSPENCER wspencer4824 titan YSULLIVA ysulliva728:300 HDSWIN\CSCCSPC105 YSULLIVA ysulliva1104:1076 HDSWIN\CSCCSPC105 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Advice needed on move to Sun 15K (losing spindles)
Salesmen/Saleswomen tell them what they want to hear! - Kirti -Original Message- Sent: Friday, October 11, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Why does management trust a salesman over their own IT professionals? Miller, Jay JayMiller To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @TDWaterhousecc: .comSubject: RE: Advice needed on move to Sun 15K (losing spindles) Sent by: root 10/11/2002 12:14 PM Please respond to ORACLE-L I obviously left out a lot of information :). We would be using server partitioning, with seperate ORACLE_HOMES for each database (necessary since we have a variety of versions running). The box would be running 1+0, the Sun reps suggest striping across all disks (my first red flag). I hadn't even thought of the problem of not being able to reboot the server, that's an excellent point. Currently we have absolutely no performance problems on our OLTP database. This whole kerfuffle was an outgrowth of my pushing really hard to get a backup box for our datawarehouse (which currently has no standby, no box that it can restored to and no QA box). The suggestion was made that rather than get a separate box for the datawarehouse - get the 15K and have the OLTP and datawarehouse on different partitions. This would certainly speed up the data transfer between them (data is transferred from OLTP - Data Warehouse on a daily basis). We could then put other databases that access my databases on other partitions (several other databases have snapshots on some of my tables). So this would make some processes more efficient, but i/o on my OLTP database is currently tuned so well that it hurts every time I think of giving it up. One spindle has the Oracle executables with the redo logs on the outside of the disk. Another has the various .dat files, shell scripts, etc, with the archive logs on the outside of the disk. Even when we run really intensive updates our wio rarely gets very high. Regarding the load question: We have fairly active transaction activity during the day but most connections are managed by Microsoft Transaction Server in a middle tier so while there are usually app. 200 sessions (including some old client server apps) we rarely have more than 20 or so active at any one time. The datawarehouse has fewer sessions but often has some resource intensive queries running. If anyone can point me to docs/websites saying that a large caches does *not* make up for fewer disks/spindles I would greatly appreciate it. Currently I'm being told that Sun must know what they're talking about. Thanks again, Jay Miller -Original Message- Sent: Wednesday, October 09, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Others have addressed the performance issues. What about the admin issues? If consolidate to a single server, consider a separate ORACLE_HOME for each database. You may need to apply different patches to fix different problems in various databases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared Miller, Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Advice needed on move to Sun 15K (losing spindles) Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were and I kept saying, but we're not CPU bound, we don't need any more CPU. If anyone can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ:
8.1.7.2 or 8.1.7.4
Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was 8.1.7.4 for the reason that it was latest. But some of my friends have advised 8.1.7.2 Any opinions? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
O/T - Disk IOs
Can anyone direct me to a method or tool for checking I/O on filesystems. the problem lies with matching up device names given by iostat to filesystem mount point names given by df. I.e. iostat -xdn extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device . 0.6 2.5 23.0 20.1 0.0 0.00.0 14.1 0 4 c3t5d4 3.0 2.1 22.1 17.4 0.0 0.10.0 11.6 0 3 c2t4d0 3.0 1.5 22.1 17.1 0.0 0.00.18.3 0 2 c1t0d0 . (or iostat -x shows devices as 'ssd34'.) I have Solaris 2.7 , veritas volume manager with non journalled filesystems. I'm afraid that I have not been able to keep up with Unix sys admin skills since I looked after SunOS 4.1.3 , HP-UX 9.7/10 and Apollo DomainOS workstations. Regards, Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Making a tablespace read-only - identifying blocking tx
First, I ommitted the ;) when replying to Rachel's post. I was just funnin... Second, in this case TTS will not work. While we can 99.99% guarantee that there will be no tx against the tablespace, there will be active tx in the database and we cannot guarantee that they will not cause the RO command to wait. Interestingly, it is possible to offline the tablespace while there are active tx (even against objects in the ts). If you can offline and then online with active tx, why not alter it to RO? Perhaps, once again, I am missing the obvious. Dan -Original Message- Sent: Thursday, October 10, 2002 8:23 PM To: Multiple recipients of list ORACLE-L yes it's relevant, it explains why you can't use a consistent export only to move the data and have to copy the tablespace as well. It also explains why the tablespace has to be in read-only mode. --- Fink, Dan [EMAIL PROTECTED] wrote: That information is not relevant and should be ignored. I would expect YOU to know as much! -Original Message- Sent: Thursday, October 10, 2002 1:25 PM To: Multiple recipients of list ORACLE-L ah! transportable tablespaces? you did't SAY that --- Fink, Dan [EMAIL PROTECTED] wrote: It is not the export per se that causes the problem. It is the copying of the datafile that is the issue. The tablespace must be made read only so that the datafile can be copied in a consistent version. I can understand (and support) no active tx in the tablespace, but why the whole (*#(*$# database? If I need to take INVOICE_1999 tablespace and migrate it to an ODS, why does it matter if Joe Accountant is adding an expense report in the EXPENSE_2002 ts? In the Oracle doc, it lists the requirements for making a ts read only. On the next page it states (verbatim from doc) You do not have to wait for transactions to complete before issuing the ALTER TABLESPACE ... READ ONLY statement. When the statement is issued, the target tablespace goes into a transitional read-only mode in which no further write operations (DML statements) are allowed against the tablespace. Existing transactions that modified the tablespace are allowed to commit or rollback. Once all transactions (in the database) have completed, the tablespace becomes read-only. I love how Oracle buries a very important consideration in the very last line of a paragraph! We are on 9ir1, so the TABLESPACE parameter is not helpful, but we do have other options. The application architecture is such that I am pretty certain very bad things would happen if I tried to but the database in restricted mode. Dan -Original Message- Sent: Thursday, October 10, 2002 5:09 AM To: Multiple recipients of list ORACLE-L so if it's waiting for any active transaction, I guess you could put the database in restricted mode until existing transactions complete. Of course, that sort of defeats the purpose of putting it in read-only so other people can access it. um, 9ir2 has an export parameter of tablespace, if you want it read-only so nothing changes while you export it, how about using the consistent=y export parameter in conjunction with the tablespace export? --- Deshpande, Kirti [EMAIL PROTECTED] wrote: And with that correction, it seems checking for active transactions (in v$transaction) would address this. However, by the time one gets a 'green' light from v$transaction and issues alter tablespace... there is the slight possibility of someone starting a new transaction locally or just selecting over a dblink... Too bad that the new 'transitional read-only' mode does not allow a graceful exit... Per the Admin Guide one must set compatible to 8.1.0 to make the command fail... I would be interested in learning how you tackle this issue as I am also trying to implement TTS in some of my databases. Thanks. - Kirti -Original Message- Sent: Wednesday, October 09, 2002 4:34 PM To: Multiple recipients of list ORACLE-L Just a slight correction it will wait until any transaction against the entire database, not just the tablespace is completed. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 09, 2002 1:49 PM To: Multiple recipients of list ORACLE-L I am creating a stored proc that will export a tablespace. One task it needs to perform is to place the tablespace(s) in read only mode to make a copy. Based upon the application and proc logic, there should not be any transactions against objects in the ts. However, if there are, the ALTER TABLESPACE command will wait until the transaction is completed. I would rather have the ALTER
RE: Advice needed on move to Sun 15K (losing spindles)
Thanks Kirti! I loved the line The first thing to do, regardless of platform or claims by the vendor, is to completely forget the existence of a cache Any similar references will be greatly appreciated. The more ammunition I have the likelier I am to kill something :) Jay -Original Message- Sent: Friday, October 11, 2002 12:36 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] I suggest reviewing James Morle's paper 'Sane SAN' at http://www.oraperf.com/whitepapers.html. - Kirti -Original Message- Sent: Friday, October 11, 2002 11:15 AM To: Multiple recipients of list ORACLE-L I obviously left out a lot of information :). We would be using server partitioning, with seperate ORACLE_HOMES for each database (necessary since we have a variety of versions running). The box would be running 1+0, the Sun reps suggest striping across all disks (my first red flag). I hadn't even thought of the problem of not being able to reboot the server, that's an excellent point. Currently we have absolutely no performance problems on our OLTP database. This whole kerfuffle was an outgrowth of my pushing really hard to get a backup box for our datawarehouse (which currently has no standby, no box that it can restored to and no QA box). The suggestion was made that rather than get a separate box for the datawarehouse - get the 15K and have the OLTP and datawarehouse on different partitions. This would certainly speed up the data transfer between them (data is transferred from OLTP - Data Warehouse on a daily basis). We could then put other databases that access my databases on other partitions (several other databases have snapshots on some of my tables). So this would make some processes more efficient, but i/o on my OLTP database is currently tuned so well that it hurts every time I think of giving it up. One spindle has the Oracle executables with the redo logs on the outside of the disk. Another has the various .dat files, shell scripts, etc, with the archive logs on the outside of the disk. Even when we run really intensive updates our wio rarely gets very high. Regarding the load question: We have fairly active transaction activity during the day but most connections are managed by Microsoft Transaction Server in a middle tier so while there are usually app. 200 sessions (including some old client server apps) we rarely have more than 20 or so active at any one time. The datawarehouse has fewer sessions but often has some resource intensive queries running. If anyone can point me to docs/websites saying that a large caches does *not* make up for fewer disks/spindles I would greatly appreciate it. Currently I'm being told that Sun must know what they're talking about. Thanks again, Jay Miller -Original Message- Sent: Wednesday, October 09, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Others have addressed the performance issues. What about the admin issues? If consolidate to a single server, consider a separate ORACLE_HOME for each database. You may need to apply different patches to fix different problems in various databases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared Miller, Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Advice needed on move to Sun 15K (losing spindles) Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were and I kept saying, but we're not CPU bound, we don't need any more CPU. If anyone can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,
RE: O/T - Disk IOs
Check options -m , -p Waleed -Original Message- Sent: Friday, October 11, 2002 2:08 PM To: Multiple recipients of list ORACLE-L Can anyone direct me to a method or tool for checking I/O on filesystems. the problem lies with matching up device names given by iostat to filesystem mount point names given by df. I.e. iostat -xdn extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device . 0.6 2.5 23.0 20.1 0.0 0.00.0 14.1 0 4 c3t5d4 3.0 2.1 22.1 17.4 0.0 0.10.0 11.6 0 3 c2t4d0 3.0 1.5 22.1 17.1 0.0 0.00.18.3 0 2 c1t0d0 . (or iostat -x shows devices as 'ssd34'.) I have Solaris 2.7 , veritas volume manager with non journalled filesystems. I'm afraid that I have not been able to keep up with Unix sys admin skills since I looked after SunOS 4.1.3 , HP-UX 9.7/10 and Apollo DomainOS workstations. Regards, Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9.2 on Red Hat 8.0
Thanks, Ray! Well, this is excellent! -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9.2 on Red Hat 8.0 On Wed, Oct 09, 2002 at 10:53:57AM -0800, Gogala, Mladen wrote: May I subscribe to the results of your undertaking? My home email is mailto:[EMAIL PROTECTED] May the force be with you. Went great! Well, sort of... I didn't even read the install guide (and the results will show below). I was amazed how it sailed past the link phase. I expected it to blow up there. It didn't, no glibc issues to be seen. I don't have enough memory to actually start the db, however. I get: Fri Oct 11 09:53:18 2002 WARNING: EINVAL creating segment of size 0x0f40 fix shm parameters in /etc/system or equivalent $ oerr ora 27123 27123, 0, unable to attach to shared memory segment // *Cause: shmat() call failed // *Action: check permissions on segment, contact Oracle support 0x0f40 = 256MB I don't even have that much real memory. This is a junker pc I resurrected from the dumpster with duct tape and prayer. On the upside the install was one of the smoothest I've ever seen. Mandrake 9.0 and Ora 9.2.0 seem to be a nice fit (as long as ora support is not an issue). Mandrake 9's installer is really slick, one of the best of any os I've ever seen. Alright, break times over! -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9.2 on Red Hat 8.0 I'm going to try mandrake 9.0, which came out this week, with some 8i and 9i this week. I'll post a followup. Mandrake is basically rh with a better installer, actually one of the best installers I've seen ever! No ora support, just for fun. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Advice needed on move to Sun 15K (losing spindles)
I've cussed and discussed the topic of one big stripe versus multiple small stripes with different people and have yet to come across anyone who has conducted a real test of various scenarios. If you stripe across all disks, then you have the advantage of guaranteed, perfectly balance I/O -- there's certainly something to be said for that! But, then you have a mix of reads and writes going across all drives too. A good argument can be made for taking those parts of the database that tend to be only one kind of operation -- for example, archive logs are writes -- and putting them in their own area. So the drives handling the writing of archived logs are doing only one kind of operation (or are they?!), but you subtract from the drives allocated for other operations. But then there is the issue of: Just exactly how do hard drives work? For example, when doing a large write only operation (like creating an archived log) is the drive really doing this neat and tidy write only, one track after the next, each track right beside the other? Or does the drive actually write a little bit, read a little bit (like a check sum or verify operation), then write some more. And when writing, does it do this smooth, nicely contiguous write, all in one operation? Or does it write a little bit (like an OS buffer full), then move to a different track to update an allocation table (then perhaps read the allocation table), then perhaps go pick up a timing mark, etc.? I suspect some of the answer is dependent on the number of drives and controllers available. (And I must say, that when I read your original question, I wondered why on earth would an organization ready to drop a bundle on a 15K be scrounging for drives -- if I interpreted your post correctly. Is this a Dilbert sort of thing?) The only time I have striped across all drives was the only time I was in a position to make that decision. This was a few years ago, and it was when I did Solaris/AIX admin. It was on a Sparc 4500 with 6 250Mhz CPU's. Since we did not have an Oracle DBA, and I didn't have the time or inclination to devote to setting up and maintaining and official OFA compliant structure, I just made one giant (considered giant at the time) 250 Gb filesystem that would hold all things Oracle and be done with it. I made two 30-drive (8.4 Gb drives) stripes and mirrored them using Solstice Disk Suite. There were 10 wide scsi controllers. Each controller had a 6-drive JBOD attached to it. An eleventh controller had an additional JBOD to be used for hot spares. As you might guess, with a I/O pipe this big, there was no way the 6 CPU's could generate enough I/O to bog things down or even cause a hint of an I/O wait. So the stripe across all drives does work. In my case, I had 60 drives on 10 controllers to work with. Could this have been made more efficient by making a collection of smaller stripes? I have never found anyone who could answer that. The Disk Suite folk can tell you that there is an optimal striping configuration for Disk Suite if we leave Oracle out of the picture. But with Oracle in the picture, who knows? One configuration that sounds reasonable is to put data files with random reads and writes on one stripe, put even numbered redo logs on a stripe, put odd numbered redo logs on a stripe, put archived logs on a stripe. The reasoning (or arm-chair theory) behind the even/odd redo logs is that at a log switch, one file system can be doing writes, while the other is doing reads for the log archiving. This is sorta kinda the way we do things at our shop here with some modifications depending on the app -- like maybe dedicate a stripe to servicing the outrageous temp requirements of a data warehouse (more correctly, a data landfill). If you have only a few drives, my inclination (with no proof whatsoever) is that the one big stripe approach might be a good idea. Thus far, all I have ever gotten on this subject is a lot of religion and very few proven facts. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.7.2 or 8.1.7.4
Title: RE: 8.1.7.2 or 8.1.7.4 Vaidya I'm running 8.1.7.2 on all instances when I go to upgrade it will probably be 9iR2 starting with a test db, then from there, onto the least important db upwards. Of course I'm stalling to let all the venturous customers test thease new realeases (and abundantly advancing I might add) out for me =). I haven't had an issue where I couldn't get support because I wasn't at .3 or .4, nor has an issue arose in .2 that left me no choice to upgrade... -Original Message- From: Rachna Vaidya [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Subject: 8.1.7.2 or 8.1.7.4 Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was 8.1.7.4 for the reason that it was latest. But some of my friends have advised 8.1.7.2 Any opinions? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Making a tablespace read-only - identifying blocking tx
thanks :) it sort of makes sense that you can offline a tablespace with an active transaction in it. You can offline a rollback segment with an active transaction in it, no new transactions can start in that rbs but the one(s) there will finish. With the tablespace, if I remember what I read in the docs correctly (and if the docs are correct), when you offline a tablespace, the active transactions in it continue to process as long as they do not try to modify a block in that tablespace. Once they try that, the transaction dies. Hm, that doesn't sound right.. maybe it's if the blocks from that tablespace are still in the buffer cache? Okay, found it in the 9ir2 Concepts manual, quoted below: When a tablespace goes offline, Oracle does not permit any subsequent SQL statements to reference objects contained in that tablespace. Active transactions with completed statements that refer to data in that tablespace are not affected at the transaction level. Oracle saves rollback data corresponding to those completed statements in a deferred rollback segment in the SYSTEM tablespace. When the tablespace is brought back online, Oracle applies the rollback data to the tablespace, if needed. When a tablespace goes offline or comes back online, this is recorded in the data dictionary in the SYSTEM tablespace. If a tablespace is offline when you shut down a database, the tablespace remains offline when the database is subsequently mounted and reopened. You can bring a tablespace online only in the database in which it was created because the necessary data dictionary information is maintained in the SYSTEM tablespace of that database. An offline tablespace cannot be read or edited by any utility other than Oracle. Thus, offline tablespaces cannot be transposed to other databases. --- Fink, Dan [EMAIL PROTECTED] wrote: First, I ommitted the ;) when replying to Rachel's post. I was just funnin... Second, in this case TTS will not work. While we can 99.99% guarantee that there will be no tx against the tablespace, there will be active tx in the database and we cannot guarantee that they will not cause the RO command to wait. Interestingly, it is possible to offline the tablespace while there are active tx (even against objects in the ts). If you can offline and then online with active tx, why not alter it to RO? Perhaps, once again, I am missing the obvious. Dan -Original Message- Sent: Thursday, October 10, 2002 8:23 PM To: Multiple recipients of list ORACLE-L yes it's relevant, it explains why you can't use a consistent export only to move the data and have to copy the tablespace as well. It also explains why the tablespace has to be in read-only mode. --- Fink, Dan [EMAIL PROTECTED] wrote: That information is not relevant and should be ignored. I would expect YOU to know as much! -Original Message- Sent: Thursday, October 10, 2002 1:25 PM To: Multiple recipients of list ORACLE-L ah! transportable tablespaces? you did't SAY that --- Fink, Dan [EMAIL PROTECTED] wrote: It is not the export per se that causes the problem. It is the copying of the datafile that is the issue. The tablespace must be made read only so that the datafile can be copied in a consistent version. I can understand (and support) no active tx in the tablespace, but why the whole (*#(*$# database? If I need to take INVOICE_1999 tablespace and migrate it to an ODS, why does it matter if Joe Accountant is adding an expense report in the EXPENSE_2002 ts? In the Oracle doc, it lists the requirements for making a ts read only. On the next page it states (verbatim from doc) You do not have to wait for transactions to complete before issuing the ALTER TABLESPACE ... READ ONLY statement. When the statement is issued, the target tablespace goes into a transitional read-only mode in which no further write operations (DML statements) are allowed against the tablespace. Existing transactions that modified the tablespace are allowed to commit or rollback. Once all transactions (in the database) have completed, the tablespace becomes read-only. I love how Oracle buries a very important consideration in the very last line of a paragraph! We are on 9ir1, so the TABLESPACE parameter is not helpful, but we do have other options. The application architecture is such that I am pretty certain very bad things would happen if I tried to but the database in restricted mode. Dan -Original Message- Sent: Thursday, October 10, 2002 5:09 AM To: Multiple recipients of list ORACLE-L so if it's waiting for any active transaction, I guess you could put the database in restricted mode until existing transactions complete. Of course, that sort of defeats the purpose of putting it in
RE: 8.1.7.2 or 8.1.7.4
Title: RE: 8.1.7.2 or 8.1.7.4 I agree with Richard. If you are running 8.1.7.2, and you are not experiencing a bug that has been corrected in 8.1.7.4, then stay where you are. Wait until 9R2 is stable and then move only when Oracle starts threatening desupport of 8i. let sleeping (content) dogs lie. Tom Mercadante Oracle Certified Professional -Original Message-From: Markham, Richard [mailto:[EMAIL PROTECTED]]Sent: Friday, October 11, 2002 2:46 PMTo: Multiple recipients of list ORACLE-LSubject: RE: 8.1.7.2 or 8.1.7.4 Vaidya I'm running 8.1.7.2 on all instances when I go to upgrade it will probably be 9iR2 starting with a test db, then from there, onto the least important db upwards. Of course I'm stalling to let all the venturous customers test thease new realeases (and abundantly advancing I might add) out for me =). I haven't had an issue where I couldn't get support because I wasn't at .3 or .4, nor has an issue arose in .2 that left me no choice to upgrade... -Original Message- From: Rachna Vaidya [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Subject: 8.1.7.2 or 8.1.7.4 Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was 8.1.7.4 for the reason that it was latest. But some of my friends have advised 8.1.7.2 Any opinions? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.7.2 or 8.1.7.4
I'm investigating an 8.1.7 upgrade also. My impression is that the stability may vary by platform, so it might be helpful to specify the platform that is involved. I'm on HP/Compaq Tru64 myself. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 11, 2002 1:46 PM To: Multiple recipients of list ORACLE-L Vaidya I'm running 8.1.7.2 on all instances when I go to upgrade it will probably be 9iR2 starting with a test db, then from there, onto the least important db upwards. Of course I'm stalling to let all the venturous customers test thease new realeases (and abundantly advancing I might add) out for me =). I haven't had an issue where I couldn't get support because I wasn't at .3 or .4, nor has an issue arose in .2 that left me no choice to upgrade... -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Friday, October 11, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was 8.1.7.4 for the reason that it was latest. But some of my friends have advised 8.1.7.2 Any opinions? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Advice needed on move to Sun 15K (losing spindles)
Jay - Will your server partitioning protect the OLTP users from the DW queries? In the normal situation, a company first adds their DW to an existing system. Then they find that the DW doesn't make a good neighbor and buy a separate server. The DW typically does a LOT of full-table scans, so if you share disks, that may not be good for your OLTP. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 11, 2002 11:15 AM To: Multiple recipients of list ORACLE-L I obviously left out a lot of information :). We would be using server partitioning, with seperate ORACLE_HOMES for each database (necessary since we have a variety of versions running). The box would be running 1+0, the Sun reps suggest striping across all disks (my first red flag). I hadn't even thought of the problem of not being able to reboot the server, that's an excellent point. Currently we have absolutely no performance problems on our OLTP database. This whole kerfuffle was an outgrowth of my pushing really hard to get a backup box for our datawarehouse (which currently has no standby, no box that it can restored to and no QA box). The suggestion was made that rather than get a separate box for the datawarehouse - get the 15K and have the OLTP and datawarehouse on different partitions. This would certainly speed up the data transfer between them (data is transferred from OLTP - Data Warehouse on a daily basis). We could then put other databases that access my databases on other partitions (several other databases have snapshots on some of my tables). So this would make some processes more efficient, but i/o on my OLTP database is currently tuned so well that it hurts every time I think of giving it up. One spindle has the Oracle executables with the redo logs on the outside of the disk. Another has the various .dat files, shell scripts, etc, with the archive logs on the outside of the disk. Even when we run really intensive updates our wio rarely gets very high. Regarding the load question: We have fairly active transaction activity during the day but most connections are managed by Microsoft Transaction Server in a middle tier so while there are usually app. 200 sessions (including some old client server apps) we rarely have more than 20 or so active at any one time. The datawarehouse has fewer sessions but often has some resource intensive queries running. If anyone can point me to docs/websites saying that a large caches does *not* make up for fewer disks/spindles I would greatly appreciate it. Currently I'm being told that Sun must know what they're talking about. Thanks again, Jay Miller -Original Message- Sent: Wednesday, October 09, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Others have addressed the performance issues. What about the admin issues? If consolidate to a single server, consider a separate ORACLE_HOME for each database. You may need to apply different patches to fix different problems in various databases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared Miller, Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Advice needed on move to Sun 15K (losing spindles) Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were and I kept saying, but we're not CPU bound, we don't need any more CPU. If anyone can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: 8.1.7.2 or 8.1.7.4
8.1.7.4 on TRU64 introduced a listener problem (bug 2462125 / 1426414). I am testing the one-off patch 1426414 now. It looks like the problem is fixed. -Original Message- Sent: Friday, October 11, 2002 3:12 PM To: Multiple recipients of list ORACLE-L I'm investigating an 8.1.7 upgrade also. My impression is that the stability may vary by platform, so it might be helpful to specify the platform that is involved. I'm on HP/Compaq Tru64 myself. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 11, 2002 1:46 PM To: Multiple recipients of list ORACLE-L Vaidya I'm running 8.1.7.2 on all instances when I go to upgrade it will probably be 9iR2 starting with a test db, then from there, onto the least important db upwards. Of course I'm stalling to let all the venturous customers test thease new realeases (and abundantly advancing I might add) out for me =). I haven't had an issue where I couldn't get support because I wasn't at .3 or .4, nor has an issue arose in .2 that left me no choice to upgrade... -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Friday, October 11, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was 8.1.7.4 for the reason that it was latest. But some of my friends have advised 8.1.7.2 Any opinions? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gesler, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle9i upgrade exam - Recommended books/material? (Borderin
Excellent idea but try to cover more for OCP candidates for 10i upgrade.. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 11 Oct 2002 07:53:42 -0800 Thanks a bunch! I'm Looking forward to 10i!! Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 3:50 PM To: Multiple recipients of list ORACLE-L (Borderin Robert, If you don't mind , both books are good as I passed my 9i upgarde with the help of both books and I shall give credit to you and Daniel for writing these books. However, yours was the first one which I bought sometime in Jan'2002 and his book was released end March, 2002. Thanks again for your excellent effort. Now will wait for your book on Rman as you already given the url for that. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 10 Oct 2002 10:28:16 -0800 Thanks Dennis! I'm sitting here dying because one of my stereo headphone speakers i do ng t is t m ri gt n w. ARRRUUU. Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Friday, September 13, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Kieran - I haven't read it because I am still working out the 8i OCP tests, but here is a link to a book by Robert Freeman, who participates on this list. It has been recommended by other list members in the past. http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=0E2CIPD0W 9isbn=0072223855 Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Friday, September 13, 2002 11:53 AM To: Multiple recipients of list ORACLE-L Hi everyone, I'm looking to do the OCP upgrade exam from 8i to 9i (#1Z0-030 Oracle9i New Features for Administrators). Could anyone recommend some good reading material on the matter? I see the Osbourne Book (by Daniel Benjamin) got some fairly mediocre reviews. Your opinions would be very much appreciated, Kieran Murray Development DBA CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin Ireland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray 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: DENNIS WILLIAMS 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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: [Q] ORACLE 9.2 and different version of client?
It also depends on the character set being used on the database server. With 9i, there are a few new character sets. Older client will probably not be able to deal with these new character sets. I think there is a patch for the 8i client to handle new character sets, however. HTH, Gerardo -Original Message- Sent: Friday, October 11, 2002 7:59 AM To: Multiple recipients of list ORACLE-L In theory all three clients will work with 9iRelease2. However, we have encountered a problem where the client is 8.0.6, connects to a 9.2 database which has a database link to an 8.1.7 database -- queries across the db-link result in an ORA-3120 error. The analyst closed the TAR has 8.0.6 is desupported -- we tried even with tha 8.0.6.3 Patchset on the client. A 9.2 client connecting to 7.3.4 is certainly NOT supported. See Note 207319.1 on MetaLink. Hemant At 06:23 AM 11-10-02 -0800, you wrote: we plan to upfrade our database from ORACLE 8.1.7 to 9.2. The database on SUn Solaris server. My question are: 1. will following version of ORACLE client(on PC) work with ORACLE 9.2 server? 7.3.4 client 8.0.5 client 8.1.6 client 2. can ORACLE client 9.2 work with following version of ORACLE server? 7.3.4 server 8.0.5 server 8.1.6 server Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 8.1.7.2 or 8.1.7.4
On Fri, Oct 11, 2002 at 11:12:10AM -0800, DENNIS WILLIAMS wrote: I'm investigating an 8.1.7 upgrade also. My impression is that the stability may vary by platform, so it might be helpful to specify the platform that is involved. I'm on HP/Compaq Tru64 myself. My dec unix 4.0f would not stay up more than a week due to a memory leak in 8.1.7.2. Been up for 6 months with a very busy 8.1.7.2 on a redhat 7.1 box. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 11, 2002 1:46 PM To: Multiple recipients of list ORACLE-L Vaidya I'm running 8.1.7.2 on all instances when I go to upgrade it will probably be 9iR2 starting with a test db, then from there, onto the least important db upwards. Of course I'm stalling to let all the venturous customers test thease new realeases (and abundantly advancing I might add) out for me =). I haven't had an issue where I couldn't get support because I wasn't at .3 or .4, nor has an issue arose in .2 that left me no choice to upgrade... -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Friday, October 11, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was 8.1.7.4 for the reason that it was latest. But some of my friends have advised 8.1.7.2 Any opinions? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Advice needed on move to Sun 15K (losing spindles)
Title: RE: Advice needed on move to Sun 15K (losing spindles) Lets say a guy only has one finger on each hand to tie his shoe (mirroring). If he had five fingers (striping) he can accomplish the job quite a bit faster. Now give him 1000 shoes to tie and listen to him bitch about how he could use a work partner (spindle). Now give him the ability to lie so when management asks the team many shoes they have tied, they can stretch the truth a little bit (cacheing) =) -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 2:46 PM To: Multiple recipients of list ORACLE-L Subject: RE: Advice needed on move to Sun 15K (losing spindles) I've cussed and discussed the topic of one big stripe versus multiple small stripes with different people and have yet to come across anyone who has conducted a real test of various scenarios. If you stripe across all disks, then you have the advantage of guaranteed, perfectly balance I/O -- there's certainly something to be said for that! But, then you have a mix of reads and writes going across all drives too. A good argument can be made for taking those parts of the database that tend to be only one kind of operation -- for example, archive logs are writes -- and putting them in their own area. So the drives handling the writing of archived logs are doing only one kind of operation (or are they?!), but you subtract from the drives allocated for other operations. But then there is the issue of: Just exactly how do hard drives work? For example, when doing a large write only operation (like creating an archived log) is the drive really doing this neat and tidy write only, one track after the next, each track right beside the other? Or does the drive actually write a little bit, read a little bit (like a check sum or verify operation), then write some more. And when writing, does it do this smooth, nicely contiguous write, all in one operation? Or does it write a little bit (like an OS buffer full), then move to a different track to update an allocation table (then perhaps read the allocation table), then perhaps go pick up a timing mark, etc.? I suspect some of the answer is dependent on the number of drives and controllers available. (And I must say, that when I read your original question, I wondered why on earth would an organization ready to drop a bundle on a 15K be scrounging for drives -- if I interpreted your post correctly. Is this a Dilbert sort of thing?) The only time I have striped across all drives was the only time I was in a position to make that decision. This was a few years ago, and it was when I did Solaris/AIX admin. It was on a Sparc 4500 with 6 250Mhz CPU's. Since we did not have an Oracle DBA, and I didn't have the time or inclination to devote to setting up and maintaining and official OFA compliant structure, I just made one giant (considered giant at the time) 250 Gb filesystem that would hold all things Oracle and be done with it. I made two 30-drive (8.4 Gb drives) stripes and mirrored them using Solstice Disk Suite. There were 10 wide scsi controllers. Each controller had a 6-drive JBOD attached to it. An eleventh controller had an additional JBOD to be used for hot spares. As you might guess, with a I/O pipe this big, there was no way the 6 CPU's could generate enough I/O to bog things down or even cause a hint of an I/O wait. So the stripe across all drives does work. In my case, I had 60 drives on 10 controllers to work with. Could this have been made more efficient by making a collection of smaller stripes? I have never found anyone who could answer that. The Disk Suite folk can tell you that there is an optimal striping configuration for Disk Suite if we leave Oracle out of the picture. But with Oracle in the picture, who knows? One configuration that sounds reasonable is to put data files with random reads and writes on one stripe, put even numbered redo logs on a stripe, put odd numbered redo logs on a stripe, put archived logs on a stripe. The reasoning (or arm-chair theory) behind the even/odd redo logs is that at a log switch, one file system can be doing writes, while the other is doing reads for the log archiving. This is sorta kinda the way we do things at our shop here with some modifications depending on the app -- like maybe dedicate a stripe to servicing the outrageous temp requirements of a data warehouse (more correctly, a data landfill). If you have only a few drives, my inclination (with no proof whatsoever) is that the one big stripe approach might be a good idea. Thus far, all I have ever gotten on this subject is a lot of religion and very few proven facts. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services
Session Data Unit and tcp.nodelay
We have third party CAD application called VPM which we are using to organize 3d engineering models. It uses an Oracle database to store some information on locations of models and relationships between parts. We are having some performance problems which seem to point to the database access. With sql tracing turned on, we determined that one of the operations in question used more than 1700 sql statements. The consultant we work with is suggesting that we try to improve the Net8 throughput either by seting tcp.nodelay or by adjusting the size of the Session Data Unit. A quick look at the Net8 manual suggests that both of these could potentially improve throughput by forcing packets to be sent out sooner instead of blocking several requests/responses together. Does anyone have any experience with these settings? Any suggestions as to what settings to try as a start? Thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle9i upgrade exam - Recommended books/material? (Borderin
Actually there were some specific reasons we *didn't* cover all the OCP stuff in that book. It's a long story RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Friday, October 11, 2002 3:24 PM To: Multiple recipients of list ORACLE-L (Borderin Excellent idea but try to cover more for OCP candidates for 10i upgrade.. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 11 Oct 2002 07:53:42 -0800 Thanks a bunch! I'm Looking forward to 10i!! Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 3:50 PM To: Multiple recipients of list ORACLE-L (Borderin Robert, If you don't mind , both books are good as I passed my 9i upgarde with the help of both books and I shall give credit to you and Daniel for writing these books. However, yours was the first one which I bought sometime in Jan'2002 and his book was released end March, 2002. Thanks again for your excellent effort. Now will wait for your book on Rman as you already given the url for that. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 10 Oct 2002 10:28:16 -0800 Thanks Dennis! I'm sitting here dying because one of my stereo headphone speakers i do ng t is t m ri gt n w. ARRRUUU. Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Friday, September 13, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Kieran - I haven't read it because I am still working out the 8i OCP tests, but here is a link to a book by Robert Freeman, who participates on this list. It has been recommended by other list members in the past. http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=0E2CIPD0W 9isbn=0072223855 Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Friday, September 13, 2002 11:53 AM To: Multiple recipients of list ORACLE-L Hi everyone, I'm looking to do the OCP upgrade exam from 8i to 9i (#1Z0-030 Oracle9i New Features for Administrators). Could anyone recommend some good reading material on the matter? I see the Osbourne Book (by Daniel Benjamin) got some fairly mediocre reviews. Your opinions would be very much appreciated, Kieran Murray Development DBA CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin Ireland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray 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: DENNIS WILLIAMS 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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also
Re: 8.1.7.2 or 8.1.7.4
We are running Solaris 6. Currently 8.1.6.3 Planning for 8.1.7 Management is pressing for the patch in the same go due to downtime issues. -Rachna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 11, 2002 3:12 PM I'm investigating an 8.1.7 upgrade also. My impression is that the stability may vary by platform, so it might be helpful to specify the platform that is involved. I'm on HP/Compaq Tru64 myself. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 11, 2002 1:46 PM To: Multiple recipients of list ORACLE-L Vaidya I'm running 8.1.7.2 on all instances when I go to upgrade it will probably be 9iR2 starting with a test db, then from there, onto the least important db upwards. Of course I'm stalling to let all the venturous customers test thease new realeases (and abundantly advancing I might add) out for me =). I haven't had an issue where I couldn't get support because I wasn't at .3 or .4, nor has an issue arose in .2 that left me no choice to upgrade... -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Friday, October 11, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was 8.1.7.4 for the reason that it was latest. But some of my friends have advised 8.1.7.2 Any opinions? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Session Data Unit and tcp.nodelay
are they similar 1700 sql statements differing by literals. if ur db is 8.x can u use cursor_sharing? hv u tried 10046 tracing? myabe the parse time for these 1700 sql is more than the perceived tcp gain u r trying to achieve. -Original Message- From: Schauss, Peter [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 1:05 PM To: Multiple recipients of list ORACLE-L Subject: Session Data Unit and tcp.nodelay We have third party CAD application called VPM which we are using to organize 3d engineering models. It uses an Oracle database to store some information on locations of models and relationships between parts. We are having some performance problems which seem to point to the database access. With sql tracing turned on, we determined that one of the operations in question used more than 1700 sql statements. The consultant we work with is suggesting that we try to improve the Net8 throughput either by seting tcp.nodelay or by adjusting the size of the Session Data Unit. A quick look at the Net8 manual suggests that both of these could potentially improve throughput by forcing packets to be sent out sooner instead of blocking several requests/responses together. Does anyone have any experience with these settings? Any suggestions as to what settings to try as a start? Thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Oracle9i upgrade exam - Recommended books/material? (Borderin
Thanks...It was just an ideaIf possible then think of it... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 11 Oct 2002 12:09:20 -0800 Actually there were some specific reasons we *didn't* cover all the OCP stuff in that book. It's a long story RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Friday, October 11, 2002 3:24 PM To: Multiple recipients of list ORACLE-L (Borderin Excellent idea but try to cover more for OCP candidates for 10i upgrade.. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 11 Oct 2002 07:53:42 -0800 Thanks a bunch! I'm Looking forward to 10i!! Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 3:50 PM To: Multiple recipients of list ORACLE-L (Borderin Robert, If you don't mind , both books are good as I passed my 9i upgarde with the help of both books and I shall give credit to you and Daniel for writing these books. However, yours was the first one which I bought sometime in Jan'2002 and his book was released end March, 2002. Thanks again for your excellent effort. Now will wait for your book on Rman as you already given the url for that. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 10 Oct 2002 10:28:16 -0800 Thanks Dennis! I'm sitting here dying because one of my stereo headphone speakers i do ng t is t m ri gt n w. ARRRUUU. Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Friday, September 13, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Kieran - I haven't read it because I am still working out the 8i OCP tests, but here is a link to a book by Robert Freeman, who participates on this list. It has been recommended by other list members in the past. http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=0E2CIPD0W 9isbn=0072223855 Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Friday, September 13, 2002 11:53 AM To: Multiple recipients of list ORACLE-L Hi everyone, I'm looking to do the OCP upgrade exam from 8i to 9i (#1Z0-030 Oracle9i New Features for Administrators). Could anyone recommend some good reading material on the matter? I see the Osbourne Book (by Daniel Benjamin) got some fairly mediocre reviews. Your opinions would be very much appreciated, Kieran Murray Development DBA CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin Ireland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray 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: DENNIS WILLIAMS 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: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an
RE: Advice needed on move to Sun 15K (losing spindles)
Well, there are Gaja's papers : Proactive Storage Management - A Method to Predictable System Performance, and Implementing RAID on Oracle systems available at http://www.quest.com/whitepapers. Scan the page for Title and for not Gaja's name. - Kirti -Original Message- Sent: Friday, October 11, 2002 1:20 PM To: Multiple recipients of list ORACLE-L Thanks Kirti! I loved the line The first thing to do, regardless of platform or claims by the vendor, is to completely forget the existence of a cache Any similar references will be greatly appreciated. The more ammunition I have the likelier I am to kill something :) Jay -Original Message- Sent: Friday, October 11, 2002 12:36 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] I suggest reviewing James Morle's paper 'Sane SAN' at http://www.oraperf.com/whitepapers.html. - Kirti -Original Message- Sent: Friday, October 11, 2002 11:15 AM To: Multiple recipients of list ORACLE-L I obviously left out a lot of information :). We would be using server partitioning, with seperate ORACLE_HOMES for each database (necessary since we have a variety of versions running). The box would be running 1+0, the Sun reps suggest striping across all disks (my first red flag). I hadn't even thought of the problem of not being able to reboot the server, that's an excellent point. Currently we have absolutely no performance problems on our OLTP database. This whole kerfuffle was an outgrowth of my pushing really hard to get a backup box for our datawarehouse (which currently has no standby, no box that it can restored to and no QA box). The suggestion was made that rather than get a separate box for the datawarehouse - get the 15K and have the OLTP and datawarehouse on different partitions. This would certainly speed up the data transfer between them (data is transferred from OLTP - Data Warehouse on a daily basis). We could then put other databases that access my databases on other partitions (several other databases have snapshots on some of my tables). So this would make some processes more efficient, but i/o on my OLTP database is currently tuned so well that it hurts every time I think of giving it up. One spindle has the Oracle executables with the redo logs on the outside of the disk. Another has the various .dat files, shell scripts, etc, with the archive logs on the outside of the disk. Even when we run really intensive updates our wio rarely gets very high. Regarding the load question: We have fairly active transaction activity during the day but most connections are managed by Microsoft Transaction Server in a middle tier so while there are usually app. 200 sessions (including some old client server apps) we rarely have more than 20 or so active at any one time. The datawarehouse has fewer sessions but often has some resource intensive queries running. If anyone can point me to docs/websites saying that a large caches does *not* make up for fewer disks/spindles I would greatly appreciate it. Currently I'm being told that Sun must know what they're talking about. Thanks again, Jay Miller -Original Message- Sent: Wednesday, October 09, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Others have addressed the performance issues. What about the admin issues? If consolidate to a single server, consider a separate ORACLE_HOME for each database. You may need to apply different patches to fix different problems in various databases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared Miller, Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Advice needed on move to Sun 15K (losing spindles) Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were and I kept saying, but we're not CPU bound, we don't need any more CPU. If anyone can either a) tell me I'm worrying for nothing b)
RE: Advice needed on move to Sun 15K (losing spindles)
Check out www.hotsos.com/dnloads/1.Littlefield2000.01.03-Specs.pdf, written a couple of years ago by Jim Littlefield of Real Networks. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas -Original Message- Jay Sent: Friday, October 11, 2002 1:20 PM To: Multiple recipients of list ORACLE-L Thanks Kirti! I loved the line The first thing to do, regardless of platform or claims by the vendor, is to completely forget the existence of a cache Any similar references will be greatly appreciated. The more ammunition I have the likelier I am to kill something :) Jay -Original Message- Sent: Friday, October 11, 2002 12:36 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] I suggest reviewing James Morle's paper 'Sane SAN' at http://www.oraperf.com/whitepapers.html. - Kirti -Original Message- Sent: Friday, October 11, 2002 11:15 AM To: Multiple recipients of list ORACLE-L I obviously left out a lot of information :). We would be using server partitioning, with seperate ORACLE_HOMES for each database (necessary since we have a variety of versions running). The box would be running 1+0, the Sun reps suggest striping across all disks (my first red flag). I hadn't even thought of the problem of not being able to reboot the server, that's an excellent point. Currently we have absolutely no performance problems on our OLTP database. This whole kerfuffle was an outgrowth of my pushing really hard to get a backup box for our datawarehouse (which currently has no standby, no box that it can restored to and no QA box). The suggestion was made that rather than get a separate box for the datawarehouse - get the 15K and have the OLTP and datawarehouse on different partitions. This would certainly speed up the data transfer between them (data is transferred from OLTP - Data Warehouse on a daily basis). We could then put other databases that access my databases on other partitions (several other databases have snapshots on some of my tables). So this would make some processes more efficient, but i/o on my OLTP database is currently tuned so well that it hurts every time I think of giving it up. One spindle has the Oracle executables with the redo logs on the outside of the disk. Another has the various .dat files, shell scripts, etc, with the archive logs on the outside of the disk. Even when we run really intensive updates our wio rarely gets very high. Regarding the load question: We have fairly active transaction activity during the day but most connections are managed by Microsoft Transaction Server in a middle tier so while there are usually app. 200 sessions (including some old client server apps) we rarely have more than 20 or so active at any one time. The datawarehouse has fewer sessions but often has some resource intensive queries running. If anyone can point me to docs/websites saying that a large caches does *not* make up for fewer disks/spindles I would greatly appreciate it. Currently I'm being told that Sun must know what they're talking about. Thanks again, Jay Miller -Original Message- Sent: Wednesday, October 09, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Others have addressed the performance issues. What about the admin issues? If consolidate to a single server, consider a separate ORACLE_HOME for each database. You may need to apply different patches to fix different problems in various databases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared Miller, Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Advice needed on move to Sun 15K (losing spindles) Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were
RE: Advice needed on move to Sun 15K (losing spindles)
Yes, it's entirely separate CPUs and disks. If I can believe the Sun rep (ehem) there should be no interference. -Original Message- Sent: Friday, October 11, 2002 3:30 PM To: Multiple recipients of list ORACLE-L Jay - Will your server partitioning protect the OLTP users from the DW queries? In the normal situation, a company first adds their DW to an existing system. Then they find that the DW doesn't make a good neighbor and buy a separate server. The DW typically does a LOT of full-table scans, so if you share disks, that may not be good for your OLTP. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 11, 2002 11:15 AM To: Multiple recipients of list ORACLE-L I obviously left out a lot of information :). We would be using server partitioning, with seperate ORACLE_HOMES for each database (necessary since we have a variety of versions running). The box would be running 1+0, the Sun reps suggest striping across all disks (my first red flag). I hadn't even thought of the problem of not being able to reboot the server, that's an excellent point. Currently we have absolutely no performance problems on our OLTP database. This whole kerfuffle was an outgrowth of my pushing really hard to get a backup box for our datawarehouse (which currently has no standby, no box that it can restored to and no QA box). The suggestion was made that rather than get a separate box for the datawarehouse - get the 15K and have the OLTP and datawarehouse on different partitions. This would certainly speed up the data transfer between them (data is transferred from OLTP - Data Warehouse on a daily basis). We could then put other databases that access my databases on other partitions (several other databases have snapshots on some of my tables). So this would make some processes more efficient, but i/o on my OLTP database is currently tuned so well that it hurts every time I think of giving it up. One spindle has the Oracle executables with the redo logs on the outside of the disk. Another has the various .dat files, shell scripts, etc, with the archive logs on the outside of the disk. Even when we run really intensive updates our wio rarely gets very high. Regarding the load question: We have fairly active transaction activity during the day but most connections are managed by Microsoft Transaction Server in a middle tier so while there are usually app. 200 sessions (including some old client server apps) we rarely have more than 20 or so active at any one time. The datawarehouse has fewer sessions but often has some resource intensive queries running. If anyone can point me to docs/websites saying that a large caches does *not* make up for fewer disks/spindles I would greatly appreciate it. Currently I'm being told that Sun must know what they're talking about. Thanks again, Jay Miller -Original Message- Sent: Wednesday, October 09, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Others have addressed the performance issues. What about the admin issues? If consolidate to a single server, consider a separate ORACLE_HOME for each database. You may need to apply different patches to fix different problems in various databases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared Miller, Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Advice needed on move to Sun 15K (losing spindles) Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were and I kept saying, but we're not CPU bound, we don't need any more CPU. If anyone can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ:
Re:Session Data Unit and tcp.nodelay
Peter, I've messed with TDU and SDU over the years with mixed and often unpredictable results. TCP.NODELAY has caused some very quirky problems with applications especially when mixed with large values for TDU/SDU. If you do set TDU/SDU set them equal to each other, doing otherwise has again produced some quirky and intermittent problems, like applications appearing to hang or timeout all together. What your trying to control is your server and client's use of the TCP/IP layer. Now if this particular application uses a local database, like our WorkManager CAD application, then these will have no effect since SQL*Net is basically not involved. Dick Goulet Reply Separator Author: Schauss; Peter [EMAIL PROTECTED] Date: 10/11/2002 12:05 PM We have third party CAD application called VPM which we are using to organize 3d engineering models. It uses an Oracle database to store some information on locations of models and relationships between parts. We are having some performance problems which seem to point to the database access. With sql tracing turned on, we determined that one of the operations in question used more than 1700 sql statements. The consultant we work with is suggesting that we try to improve the Net8 throughput either by seting tcp.nodelay or by adjusting the size of the Session Data Unit. A quick look at the Net8 manual suggests that both of these could potentially improve throughput by forcing packets to be sent out sooner instead of blocking several requests/responses together. Does anyone have any experience with these settings? Any suggestions as to what settings to try as a start? Thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Advice needed on move to Sun 15K (losing spindles)
Thanks, I'm reading the first one now. Jay -Original Message- Sent: Friday, October 11, 2002 3:19 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Well, there are Gaja's papers : Proactive Storage Management - A Method to Predictable System Performance, and Implementing RAID on Oracle systems available at http://www.quest.com/whitepapers. Scan the page for Title and for not Gaja's name. - Kirti -Original Message- Sent: Friday, October 11, 2002 1:20 PM To: Multiple recipients of list ORACLE-L Thanks Kirti! I loved the line The first thing to do, regardless of platform or claims by the vendor, is to completely forget the existence of a cache Any similar references will be greatly appreciated. The more ammunition I have the likelier I am to kill something :) Jay -Original Message- Sent: Friday, October 11, 2002 12:36 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] I suggest reviewing James Morle's paper 'Sane SAN' at http://www.oraperf.com/whitepapers.html. - Kirti -Original Message- Sent: Friday, October 11, 2002 11:15 AM To: Multiple recipients of list ORACLE-L I obviously left out a lot of information :). We would be using server partitioning, with seperate ORACLE_HOMES for each database (necessary since we have a variety of versions running). The box would be running 1+0, the Sun reps suggest striping across all disks (my first red flag). I hadn't even thought of the problem of not being able to reboot the server, that's an excellent point. Currently we have absolutely no performance problems on our OLTP database. This whole kerfuffle was an outgrowth of my pushing really hard to get a backup box for our datawarehouse (which currently has no standby, no box that it can restored to and no QA box). The suggestion was made that rather than get a separate box for the datawarehouse - get the 15K and have the OLTP and datawarehouse on different partitions. This would certainly speed up the data transfer between them (data is transferred from OLTP - Data Warehouse on a daily basis). We could then put other databases that access my databases on other partitions (several other databases have snapshots on some of my tables). So this would make some processes more efficient, but i/o on my OLTP database is currently tuned so well that it hurts every time I think of giving it up. One spindle has the Oracle executables with the redo logs on the outside of the disk. Another has the various .dat files, shell scripts, etc, with the archive logs on the outside of the disk. Even when we run really intensive updates our wio rarely gets very high. Regarding the load question: We have fairly active transaction activity during the day but most connections are managed by Microsoft Transaction Server in a middle tier so while there are usually app. 200 sessions (including some old client server apps) we rarely have more than 20 or so active at any one time. The datawarehouse has fewer sessions but often has some resource intensive queries running. If anyone can point me to docs/websites saying that a large caches does *not* make up for fewer disks/spindles I would greatly appreciate it. Currently I'm being told that Sun must know what they're talking about. Thanks again, Jay Miller -Original Message- Sent: Wednesday, October 09, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Others have addressed the performance issues. What about the admin issues? If consolidate to a single server, consider a separate ORACLE_HOME for each database. You may need to apply different patches to fix different problems in various databases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared Miller, Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Advice needed on move to Sun 15K (losing spindles) Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more
Re: Session Data Unit and tcp.nodelay
Yes, Please do so ! Later versions of Oracle have this already enabled by default I believe. Depending on the delay, the savings/improvements can be great ! First set tcp.nodelay = true, then worry about the SDU/TDU settings. The thing to remember here is that the server and the client need to have the same setting (like with tcp.nodelay). SDU/TDU can be set to 4K as a good start. Anjo. On Friday 11 October 2002 22:05, you wrote: We have third party CAD application called VPM which we are using to organize 3d engineering models. It uses an Oracle database to store some information on locations of models and relationships between parts. We are having some performance problems which seem to point to the database access. With sql tracing turned on, we determined that one of the operations in question used more than 1700 sql statements. The consultant we work with is suggesting that we try to improve the Net8 throughput either by seting tcp.nodelay or by adjusting the size of the Session Data Unit. A quick look at the Net8 manual suggests that both of these could potentially improve throughput by forcing packets to be sent out sooner instead of blocking several requests/responses together. Does anyone have any experience with these settings? Any suggestions as to what settings to try as a start? Thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Anjo Kolk http://www.oraperf.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Advice needed on move to Sun 15K (losing spindles)
One thing that should be made clear: Never, ever, stripe with parity (i.e. RAID 5, etc.) unless you are force, at gunpoint, to do it. That is BAD. Your database will run faster on an abacus ... well ... maybe a slide rule. -Original Message- Yes, it's entirely separate CPUs and disks. If I can believe the Sun rep (ehem) there should be no interference. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help on ORA-03113 error and 7445 in the trace file.
Title: RE: Win2000/8.1.7.3.0/SQL Update ... we dont see this problem if we rlogin to the server via a Sun Solaris client box. -Original Message-From: Johnson, Michael Sent: Friday, October 11, 2002 10:38 AMTo: '[EMAIL PROTECTED]'Subject: Help on ORA-03113 error and 7445 in the trace file. We are getting a intermittent problem that happens both from a SQL prompt or if we execute off of a package. We can telnet in or go through the TNS side of things. It doesnt seem to matter. Sun Solaris 2.8 Oracle 8.1.7.4 Here is the scenario ... SQL Create user blah identified by blah default ts blah temporary ts blah; SQL Drop user blah; ORA-03113 end of file blah blah blah The server thread process is disconnected and we have to reconnect. ORA-07445 shows up in the trace file. After reconnecting we do indeed see that the BLAH user was dropped before we disconnected. Note that all DML seems to work on this connection , only DDL type stuff causes a problem. The only thing we can figure is some type of network issue, but what ?? Thanks for your time in advance. Mike
Re: Session Data Unit and tcp.nodelay
Peter, You'll probably get best results by continuing down the path you've begun. You had SQL-traced a process -- have you used TKPROF to aggregate the information into something useful? Reading a .trc file from SQL trace for performance is like reading a person's genome to find their gender; there are faster ways... To run TKPROF, use the syntax tkprof trc-filename out-filename sort=exeqry,fchqry,execu,fchcu explain=un/pw where: * trc-filename is the filename of the .trc file * out-filename is whatever filename into which you'd like to place the ASCII text output * un is an Oracle account username for TKPROF to use in case it need to run EXPLAIN PLAN on a SQL statement * pw is the password to 'un' The sort= parameter will sort the SQL statements by logical reads, from most to least. Therefore, the worst SQL statements (i.e. the ones consuming the most logical reads) will percolate to the top. This is important, as TKPROF will not the information for you otherwise, leaving you again with the search-the-entire-genome problem you had before. Since you have about 1,700 SQL statements to wade through, I would suggest using the additional print=50 parameter with TKPROF, which will tell TKPROF to only bother summarizing, EXPLAIN PLANing, and printing the top 50 SQL... My guess is that you will see the first 1-3 SQL statements consuming over 90% of all logical reads. Tune those and you will solve your performance issue. Fiddling with obscure parameters (especially networking parameters!) is something to consider *after* the more productive avenues have yielded no results... --- TCP.NODELAY is SQL*Net's implementation of the TCP-level TCP_NODELAY functionality. Essentially, it instructs the network layer not to operate in a synchronous fashion (i.e. send message, await ACK, send next message) but rather to send messages when they are queued. It seems to get used in a lot of Windows applications where folks are clickety-clicking away with their mouse, while prior requests are still being processed. Go ahead and try it, but it will probably have no impact. After all, isn't it more important to deal with the reason that the server-side of a client-server connection is not responding? Also, SDU (session data unit) is the SQL*Net packet sizing. It is also unlikely that adjusting this upwards will help unless you are habitually transferring huge amounts of data to and fro. Ironically, the effect of TCP.NODELAY would probably negate setting SDU higher, and would have the impact of sending more (thus smaller) packets to and fro... Hope this helps... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 11, 2002 2:05 PM We have third party CAD application called VPM which we are using to organize 3d engineering models. It uses an Oracle database to store some information on locations of models and relationships between parts. We are having some performance problems which seem to point to the database access. With sql tracing turned on, we determined that one of the operations in question used more than 1700 sql statements. The consultant we work with is suggesting that we try to improve the Net8 throughput either by seting tcp.nodelay or by adjusting the size of the Session Data Unit. A quick look at the Net8 manual suggests that both of these could potentially improve throughput by forcing packets to be sent out sooner instead of blocking several requests/responses together. Does anyone have any experience with these settings? Any suggestions as to what settings to try as a start? Thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may
Help on ORA-03113 error and 7445 in the trace file.
Title: RE: Win2000/8.1.7.3.0/SQL We are getting a intermittent problem that happens both from a SQL prompt or if we execute off of a package. We can telnet in or go through the TNS side of things. It doesnt seem to matter. Sun Solaris 2.8 Oracle 8.1.7.4 Here is the scenario ... SQL Create user blah identified by blah default ts blah temporary ts blah; SQL Drop user blah; ORA-03113 end of file blah blah blah The server thread process is disconnected and we have to reconnect. ORA-07445 shows up in the trace file. After reconnecting we do indeed see that the BLAH user was dropped before we disconnected. Note that all DML seems to work on this connection , only DDL type stuff causes a problem. The only thing we can figure is some type of network issue, but what ?? Thanks for your time in advance. Mike
RE: Oracle list for developers ??
There is the ODTUG list, it is intended for paying members but you may be able to subscribe anyway. Developer List Server: ODTUG-DEV2K-L In order to make changes to your subscription, unsubscribe from the list or change your subscription characteristics, send E-mail to: [EMAIL PROTECTED]-- Note the EXACT spelling of 'listserv' The Subject: line is ignored, so put whatever you want on it. The message body should include the command you want to execute. If you are not familiar with commonly used listserv commands, put the keyword 'HELP' in the message body and you will be sent a detailed description of the commands you can perform. The two most commonly used commands are: sub odtug-dev2k-l Real Name To subscribe to the list unsub odtug-dev2k-l To unsubscribe from the list I don't know if they still send e-mails through the list, all my e-mails tend to end up in the same bin and often I don't notice if they are from odtug or oracle-l... Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 10, 2002 7:44 PM To: Multiple recipients of list ORACLE-L Listers: While I certainly appreciate the great range of experience and knowledge by the subscribers on this list, if my rudimentary knowledge is to be trusted, I think 95% of the postings are DBA type stuff. Since I'm interested in developer questions / answers I'm asking, again!!, if an Oracle list exists that is developer oriented rather than DBA oriented. TIA for your answers. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Thanks - Oracle list for developers ??
Thanks to all who responded helpfully. SY. -Original Message- From: [EMAIL PROTECTED] [mailto:Jared.Still;radisys.com] Sent: Thursday, October 10, 2002 7:08 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject:Re: Oracle list for developers ?? Importance: High Harry, Check into ODTUG. http://www.odtug.com/web_members/mbrsonly_signup.asp Jared Droogendyk, Harry [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/10/2002 03:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle list for developers ?? Listers: While I certainly appreciate the great range of experience and knowledge by the subscribers on this list, if my rudimentary knowledge is to be trusted, I think 95% of the postings are DBA type stuff. Since I'm interested in developer questions / answers I'm asking, again!!, if an Oracle list exists that is developer oriented rather than DBA oriented. TIA for your answers. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database Trigger not fireing In Delete Mode
Title: RE: Avoding Mutation of Table trigger This can be simply solved byeliminating the WHEN condition on the trigger and encapsulating that condition as part of a If .. THEN ... END IF statement. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Friday, October 11, 2002 12:13 AMTo: Multiple recipients of list ORACLE-LSubject: Database Trigger not fireing In Delete Mode Hi all, I have row level table trigger to fire on DELETE or INSERT or UPDATE Mode . It has to fire on certain condition, meaning I have a WHEN condition also. WHEN Condition is like : when ( NEW.CR_ACCOUNT is not null and NEW.CHQ_DT is not null ) Since, in DELETEmodeNEW value contains null , it does not fire. This Problem would have solved if could write WHEN Condition as when ((INSERTING or UPDATING) andNEW.CR_ACCOUNT is not null and NEW.CHQ_DT is not null ) OR (DELETING andOLD.CR_ACCOUNT is not nulland OLD.CHQ_DT is not null ) But in WHEN condition one can not write INSERTING or UPDATING. How do i go about it ? Any round about way ? Thanks Regards. Naba *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: Unix script to stop pwd-protected listener
Hi, we have lsnrctl with 750 and listener.ora with 600 permissions and everything runs fine. For job stopping process you can then use the encrypted password wirtten in listener.ora. HTH, Mike [EMAIL PROTECTED] wrote: Hi, Solaris 8, Oracle 9i listener It seems that anyone who has a login on Solaris can shut the listener down. I have tried with a non-dba userid and could stop the listener. The default file permission for ORACLE_HOME/bin/lsnrctl is 751, and for ORACLE_HOME/network/admin/listener.ora file is 644. I asked Oracle if I could change them to 750 and 640 respectively and they said that you should not change the defaults since they are verified against the system. So I password protected it. However to stop a password-protect listener you need to do the following interactively: run lsnrctl, issue set password command, put in the password, issue stop, issue exit. I need to implement this stop in a Shell script so that I can call the script at the server reboot time. Do you know how to supply a password to lsnrctl set password command in a script? Have attempted with the script but have not got it worked yet. Thanks Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Ing. Michal Zaschke DB Administrator Sokolovska uhelna, a.s. phone: +420 352 465417 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michal Zaschke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: sequence numbers
Mark... If this were the MOST serious design flaw in the whole mess, I wouldn't care so much. There is a point where you just shut up (gee, I have been TOLD to do that in meetings) and wait till it breaks (or worse, one of our clients buys it and we have to TRY to implement). I am the funny one... the one to laugh at and make fun of because I keep trying to tell them that you can't do things. You can't have a totally denormalized Oracle table if there 1500 columns in it... yes queries will fly on a table that can't be built. You can't have 37 columns in a primary key. Date really isn't an acceptable name for a column. April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message- Sent: Thursday, October 10, 2002 7:34 PM To: Multiple recipients of list ORACLE-L Hi Dick, I have to disagree with you here. Particularly in the case where this sequence will see any sort of concurrency, from multiple concurrent sessions accessing it. This is due to the serialization on the SQ enqueue. This will cause far worse scalability issues than any I/O. Not that I/O is insignificant, but in this situation, serialization on the enqueue will be the real showstopper for scalability. As to losing the cached values, well, so what? If your design is such that it's important to have an unbroken contiguous sequence of numbers with no gaps, then I would argue that is a serious design flaw. Also, if that's your requirement, then a sequence is not appropriate, since it can and will end up causing gaps, the first time you roll back a transaction. Finally, as to sequences losing cached values, unless your instance crashes or does a shutdown abort, Oracle should not loose any sequence values. -Mark On Thu, 2002-10-10 at 18:18, [EMAIL PROTECTED] wrote: Actually there is no IO penalty since Oracle has to treat the sequence just like any table with the old LRU algorithm. I have several sequences with a cache of 0 and they perform as well as those with a cache value. The big difference is when you shut down the database and all of those cached values end up in the trash. Dick Goulet Reply Separator Author: Yechiel Adar [EMAIL PROTECTED] Date: 10/10/2002 1:38 PM I think that you will have an update to the sequence number EVERY time instead of every 20 times. That's mean I/o for every nextval. Yechiel Adar Mehish - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, October 10, 2002 7:43 PM Subject: Re: sequence numbers CACHE 20 is the default, so if you remove the clause, it will have absolutely no impact on performance or anything else... ...of course, I get the feeling that that wasn't the gist of your question, was it? - Original Message - From: April Wells To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 09, 2002 8:54 AM Subject: sequence numbers I have been given create scripts for sequences to be used in tables that will be loaded via bulk loads. How huge is the potential performance hit if I take out the cache 20? April Wells Oracle DBA There is neither good nor bad, but thinking makes it so. -Shakespeare !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=text/html; charset=iso-8859-1 http-equiv=Content-Type META content=MSHTML 5.00.2314.1000 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff style=FONT: 10pt Times New Roman; MARGIN-LEFT: 2px; MARGIN-TOP: 2px DIVFONT face=Arial size=3I think that you will have an update to the sequence number EVERY time instead of every 20 times. That's mean I/o for every nextval./FONT/DIV DIVnbsp;/DIV DIVYechiel AdarBRMehish/DIV BLOCKQUOTE dir=ltr style=BORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px DIV style=FONT: 10pt arial- Original Message - /DIV DIV style=BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: blackBFrom:/B A href=mailto:Tim;SageLogix.com [EMAIL PROTECTED]Tim Gorman/A /DIV DIV style=FONT: 10pt arialBTo:/B A href=mailto:ORACLE-L;fatcity.com [EMAIL PROTECTED]Multiple recipients of list ORACLE-L/A /DIV DIV style=FONT: 10pt arialBSent:/B Thursday, October 10, 2002 7:43 PM/DIV DIV style=FONT: 10pt arialBSubject:/B Re: sequence numbers/DIV DIVBR/DIV DIVFONT face=ArialCACHE 20 is the default, so if you remove the clause, it will have absolutely no impact on performance or anything else.../FONT/DIV DIVFONT face=Arial/FONTnbsp;/DIV DIVFONT face=Arial...of course, I get the feeling that that wasn't the gist of your question, was it?/FONT/DIV BLOCKQUOTE dir=ltr style=BORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px;
Re: OT: IBM Ultrium tape drive for AIX
We have LTO 3580 on IBM P660 server. The backup speed normally between 9 Mb - 13 Mb/per second. From: Rahul [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT: IBM Ultrium tape drive for AIX Date: Thu, 10 Oct 2002 22:43:21 -0800 list, we are planning to buy this external device for backup out AIX (2 databases + rootvg) the sales rep says that this device can backup 60GB in 1.5 hours... (our current internal DDS tape drive takes 4-5 hours for the backup.) .. does anyone else on this list has experience with this device ? how fast reliable is this ? regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle list for developers ??
Harry, did you look in Technet.oracle.com? There is a Forum area for asking questions, answered by Oracle staff. Not as good as a Listserv like this, but at least it is something. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 10, 2002 6:44 PM To: Multiple recipients of list ORACLE-L Listers: While I certainly appreciate the great range of experience and knowledge by the subscribers on this list, if my rudimentary knowledge is to be trusted, I think 95% of the postings are DBA type stuff. Since I'm interested in developer questions / answers I'm asking, again!!, if an Oracle list exists that is developer oriented rather than DBA oriented. TIA for your answers. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Droogendyk, Harry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
trigger and stored procedure
Hi, Can someone pls help me with the following problem? thanks harsh Requirement: Whenever a row is deleted from a database table, the client application shall get the deletion details. Based on the studies done the following approach is thought to be more appropriate. 1. Create a trigger on the database table. This trigger will call a stored function. 2. This function will a call a External C procedure. 3. All these triggers and functions are defined in next section. Description of the Table naren_subscribers. Name Null?Type - USERIDNOT NULL NUMBER(38) SUBSCRIBER VARCHAR2(30) HOST NOT NULL VARCHAR2(100) ALIAS VARCHAR2(30) AUTHFAILURENUMBER(38) BLOCKSTATUSNUMBER(38) The trigger is defined as follows CREATE OR REPLACE TRIGGER Pre_del_trigger BEFORE DELETE ON naren_subscribers FOR EACH ROW declare return_value double precision; Begin return_value := senddata(:old.userid, :old.subscriber); end; / The function is defined as follows SQL CREATE OR REPLACE FUNCTION senddata ( arg1 IN NUMBER, arg2 IN NUMBER ) return DOUBLE PRECISION AS EXTERNAL NAME senddata LIBRARY libsenddata LANGUAGE C; / The C procedure is as follows doublesenddata (OCINumber USER_ID, OCINumber AUTHFAILURE ) { /* This c procedure opens a socket connection to client application (which needs the information of the deleted row.) and passes this USER_ID and AUTHFAILURE */. } This C procedure is compiled and senddata.so is generated. This .so is placed in oracle server by creating a library libsenddata. All OCI related headers are included in C procedure Assumptions: The function senddata that is defined above is sending arguments as NUMBER. So the equivalent datatype in C is OCINumber. The problem description: 1. When I am trying to convert the OCINumber to integer in C procedure using OCI library error is returned. 2. Or is there any way to do this conversion from NUMBER to equivalent C data type. as well as VARCHAR equivalent C data type. This message is proprietary to Hughes Software Systems Limited (HSS) and is intended solely for the use of the individual to whom it is addressed. It may contain privileged or confidential information and should not be circulated or used for any purpose other than for what it is intended. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you are notified that you are strictly prohibited from using, copying, altering, or disclosing the contents of this message. HSS accepts no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Controlling Users Logons
Hello Listers, I was asked by a co-worker if there was a way in Oracle to prevent users from connecting to the databases if the same OSUSER has already a created a specified number of sessions to a particular instance. We discussed profiles and resource limits etc. However, the requirement is that the user should a get message that they have exceeded their quota and should not be allowed to log in (there goes the log on trigger). The denial of connection *must* be based on 'OSUSER'. In this environment different OSUSERs use the same Oracle Username for these connections, and the expectation is that the DBA find a solution to enforce some rules. Any tricks? Third party software? Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
trigger and stored procedure related
Hi, Can someone pls help me with the following problem? thanks harsh Requirement: Whenever a row is deleted from a database table, the client application shall get the deletion details. Based on the studies done the following approach is thought to be more appropriate. 1. Create a trigger on the database table. This trigger will call a stored function. 2. This function will a call a External C procedure. 3. All these triggers and functions are defined in next section. Description of the Table naren_subscribers. Name Null?Type - USERIDNOT NULL NUMBER(38) SUBSCRIBER VARCHAR2(30) HOST NOT NULL VARCHAR2(100) ALIAS VARCHAR2(30) AUTHFAILURENUMBER(38) BLOCKSTATUSNUMBER(38) The trigger is defined as follows CREATE OR REPLACE TRIGGER Pre_del_trigger BEFORE DELETE ON naren_subscribers FOR EACH ROW declare return_value double precision; Begin return_value := senddata(:old.userid, :old.subscriber); end; / The function is defined as follows SQL CREATE OR REPLACE FUNCTION senddata ( arg1 IN NUMBER, arg2 IN NUMBER ) return DOUBLE PRECISION AS EXTERNAL NAME senddata LIBRARY libsenddata LANGUAGE C; / The C procedure is as follows doublesenddata (OCINumber USER_ID, OCINumber AUTHFAILURE ) { /* This c procedure opens a socket connection to client application (which needs the information of the deleted row.) and passes this USER_ID and AUTHFAILURE */. } This C procedure is compiled and senddata.so is generated. This .so is placed in oracle server by creating a library libsenddata. All OCI related headers are included in C procedure Assumptions: The function senddata that is defined above is sending arguments as NUMBER. So the equivalent datatype in C is OCINumber. The problem description: 1. When I am trying to convert the OCINumber to integer in C procedure using OCI library error is returned. 2. Or is there any way to do this conversion from NUMBER to equivalent C data type. as well as VARCHAR equivalent C data type. This message is proprietary to Hughes Software Systems Limited (HSS) and is intended solely for the use of the individual to whom it is addressed. It may contain privileged or confidential information and should not be circulated or used for any purpose other than for what it is intended. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you are notified that you are strictly prohibited from using, copying, altering, or disclosing the contents of this message. HSS accepts no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: sequence numbers
April, What can I say? Ouch! I feel your pain. I've been trapped in some pretty ridiculous situations too. (Though, I think you have me beat! A 37 column primary key?? Really??) Well, you at least seem to have the proper attitude. ;-) Without a sense of humor, I'm afraid you'd go insane in short order! ;-) The only other thing I can think of when people shut you down like that is: document. At meeting X, on such and such a date, I identified this problem, and Mr. Z told me to not to worry about it. It may not help, but from a sanity point of view, there is a certain amount of satisfaction in I told you so!, even if you never verbalize it;-) Hang in there, -Mark On Fri, 2002-10-11 at 08:43, April Wells wrote: Mark... If this were the MOST serious design flaw in the whole mess, I wouldn't care so much. There is a point where you just shut up (gee, I have been TOLD to do that in meetings) and wait till it breaks (or worse, one of our clients buys it and we have to TRY to implement). I am the funny one... the one to laugh at and make fun of because I keep trying to tell them that you can't do things. You can't have a totally denormalized Oracle table if there 1500 columns in it... yes queries will fly on a table that can't be built. You can't have 37 columns in a primary key. Date really isn't an acceptable name for a column. April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message- Sent: Thursday, October 10, 2002 7:34 PM To: Multiple recipients of list ORACLE-L Hi Dick, I have to disagree with you here. Particularly in the case where this sequence will see any sort of concurrency, from multiple concurrent sessions accessing it. This is due to the serialization on the SQ enqueue. This will cause far worse scalability issues than any I/O. Not that I/O is insignificant, but in this situation, serialization on the enqueue will be the real showstopper for scalability. As to losing the cached values, well, so what? If your design is such that it's important to have an unbroken contiguous sequence of numbers with no gaps, then I would argue that is a serious design flaw. Also, if that's your requirement, then a sequence is not appropriate, since it can and will end up causing gaps, the first time you roll back a transaction. Finally, as to sequences losing cached values, unless your instance crashes or does a shutdown abort, Oracle should not loose any sequence values. -Mark On Thu, 2002-10-10 at 18:18, [EMAIL PROTECTED] wrote: Actually there is no IO penalty since Oracle has to treat the sequence just like any table with the old LRU algorithm. I have several sequences with a cache of 0 and they perform as well as those with a cache value. The big difference is when you shut down the database and all of those cached values end up in the trash. Dick Goulet Reply Separator Author: Yechiel Adar [EMAIL PROTECTED] Date: 10/10/2002 1:38 PM I think that you will have an update to the sequence number EVERY time instead of every 20 times. That's mean I/o for every nextval. Yechiel Adar Mehish - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Thursday, October 10, 2002 7:43 PM Subject: Re: sequence numbers CACHE 20 is the default, so if you remove the clause, it will have absolutely no impact on performance or anything else... ...of course, I get the feeling that that wasn't the gist of your question, was it? - Original Message - From: April Wells To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 09, 2002 8:54 AM Subject: sequence numbers I have been given create scripts for sequences to be used in tables that will be loaded via bulk loads. How huge is the potential performance hit if I take out the cache 20? April Wells Oracle DBA There is neither good nor bad, but thinking makes it so. -Shakespeare !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META content=text/html; charset=iso-8859-1 http-equiv=Content-Type META content=MSHTML 5.00.2314.1000 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff style=FONT: 10pt Times New Roman; MARGIN-LEFT: 2px; MARGIN-TOP: 2px DIVFONT face=Arial size=3I think that you will have an update to the sequence number EVERY time instead of every 20 times. That's mean I/o for every nextval./FONT/DIV DIVnbsp;/DIV DIVYechiel AdarBRMehish/DIV BLOCKQUOTE dir=ltr style=BORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px DIV style=FONT: 10pt arial- Original Message - /DIV DIV style=BACKGROUND:
[Q] ORACLE 9.2 and different version of client?
we plan to upfrade our database from ORACLE 8.1.7 to 9.2. The database on SUn Solaris server. My question are: 1. will following version of ORACLE client(on PC) work with ORACLE 9.2 server? 7.3.4 client 8.0.5 client 8.1.6 client 2. can ORACLE client 9.2 work with following version of ORACLE server? 7.3.4 server 8.0.5 server 8.1.6 server Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Controlling Users Logons
Could you use machine from v$session? [EMAIL PROTECTED] 10/11/02 09:48AM Hello Listers, I was asked by a co-worker if there was a way in Oracle to prevent users from connecting to the databases if the same OSUSER has already a created a specified number of sessions to a particular instance. We discussed profiles and resource limits etc. However, the requirement is that the user should a get message that they have exceeded their quota and should not be allowed to log in (there goes the log on trigger). The denial of connection *must* be based on 'OSUSER'. In this environment different OSUSERs use the same Oracle Username for these connections, and the expectation is that the DBA find a solution to enforce some rules. Any tricks? Third party software? Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to see it?
The light? The light at the end of the tunnel? The forest for the trees? The ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: O/T - Disk IOs
vxprint can be used to determine which drives make up a filesystem. Jared Jenner Mike [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/11/2002 11:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:O/T - Disk IOs Can anyone direct me to a method or tool for checking I/O on filesystems. the problem lies with matching up device names given by iostat to filesystem mount point names given by df. I.e. iostat -xdn extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device . 0.6 2.5 23.0 20.1 0.0 0.00.0 14.1 0 4 c3t5d4 3.0 2.1 22.1 17.4 0.0 0.10.0 11.6 0 3 c2t4d0 3.0 1.5 22.1 17.1 0.0 0.00.18.3 0 2 c1t0d0 . (or iostat -x shows devices as 'ssd34'.) I have Solaris 2.7 , veritas volume manager with non journalled filesystems. I'm afraid that I have not been able to keep up with Unix sys admin skills since I looked after SunOS 4.1.3 , HP-UX 9.7/10 and Apollo DomainOS workstations. Regards, Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.7.2 or 8.1.7.4
Title: Message There is a new listener bug detailed in security alert 42 which allows someone to execute a Denial of Service attack by crashing or hanging the listener. For Oracle 8i I only see patches at the 8.1.7.4 level. Interestingly, the 8.0 database listener is notvulnerable. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 12:12 PMTo: Multiple recipients of list ORACLE-LSubject: RE: 8.1.7.2 or 8.1.7.4 I agree with Richard. If you are running 8.1.7.2, and you are not experiencing a bug that has been corrected in 8.1.7.4, then stay where you are. Wait until 9R2 is stable and then move only when Oracle starts threatening desupport of 8i. let sleeping (content) dogs lie. Tom Mercadante Oracle Certified Professional -Original Message-From: Markham, Richard [mailto:[EMAIL PROTECTED]]Sent: Friday, October 11, 2002 2:46 PMTo: Multiple recipients of list ORACLE-LSubject: RE: 8.1.7.2 or 8.1.7.4 Vaidya I'm running 8.1.7.2 on all instances when I go to upgrade it will probably be 9iR2 starting with a test db, then from there, onto the least important db upwards. Of course I'm stalling to let all the venturous customers test thease new realeases (and abundantly advancing I might add) out for me =). I haven't had an issue where I couldn't get support because I wasn't at .3 or .4, nor has an issue arose in .2 that left me no choice to upgrade... -Original Message- From: Rachna Vaidya [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Subject: 8.1.7.2 or 8.1.7.4 Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was 8.1.7.4 for the reason that it was latest. But some of my friends have advised 8.1.7.2 Any opinions? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to see it?
You must have faith grasshopper... the substance of things hoped for, the evidence of things not seen. -Original Message- Sent: Friday, October 11, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Importance: High The light? The light at the end of the tunnel? The forest for the trees? The ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Advice needed on move to Sun 15K (losing spindles)
Thank you very much! I can tell what I'll be reading this weekend :). With highlighter in hand... Jay -Original Message- Sent: Friday, October 11, 2002 4:31 PM To: Multiple recipients of list ORACLE-L Check out www.hotsos.com/dnloads/1.Littlefield2000.01.03-Specs.pdf, written a couple of years ago by Jim Littlefield of Real Networks. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas -Original Message- Jay Sent: Friday, October 11, 2002 1:20 PM To: Multiple recipients of list ORACLE-L Thanks Kirti! I loved the line The first thing to do, regardless of platform or claims by the vendor, is to completely forget the existence of a cache Any similar references will be greatly appreciated. The more ammunition I have the likelier I am to kill something :) Jay -Original Message- Sent: Friday, October 11, 2002 12:36 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] I suggest reviewing James Morle's paper 'Sane SAN' at http://www.oraperf.com/whitepapers.html. - Kirti -Original Message- Sent: Friday, October 11, 2002 11:15 AM To: Multiple recipients of list ORACLE-L I obviously left out a lot of information :). We would be using server partitioning, with seperate ORACLE_HOMES for each database (necessary since we have a variety of versions running). The box would be running 1+0, the Sun reps suggest striping across all disks (my first red flag). I hadn't even thought of the problem of not being able to reboot the server, that's an excellent point. Currently we have absolutely no performance problems on our OLTP database. This whole kerfuffle was an outgrowth of my pushing really hard to get a backup box for our datawarehouse (which currently has no standby, no box that it can restored to and no QA box). The suggestion was made that rather than get a separate box for the datawarehouse - get the 15K and have the OLTP and datawarehouse on different partitions. This would certainly speed up the data transfer between them (data is transferred from OLTP - Data Warehouse on a daily basis). We could then put other databases that access my databases on other partitions (several other databases have snapshots on some of my tables). So this would make some processes more efficient, but i/o on my OLTP database is currently tuned so well that it hurts every time I think of giving it up. One spindle has the Oracle executables with the redo logs on the outside of the disk. Another has the various .dat files, shell scripts, etc, with the archive logs on the outside of the disk. Even when we run really intensive updates our wio rarely gets very high. Regarding the load question: We have fairly active transaction activity during the day but most connections are managed by Microsoft Transaction Server in a middle tier so while there are usually app. 200 sessions (including some old client server apps) we rarely have more than 20 or so active at any one time. The datawarehouse has fewer sessions but often has some resource intensive queries running. If anyone can point me to docs/websites saying that a large caches does *not* make up for fewer disks/spindles I would greatly appreciate it. Currently I'm being told that Sun must know what they're talking about. Thanks again, Jay Miller -Original Message- Sent: Wednesday, October 09, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Others have addressed the performance issues. What about the admin issues? If consolidate to a single server, consider a separate ORACLE_HOME for each database. You may need to apply different patches to fix different problems in various databases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared Miller, Jay [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Advice needed on move to Sun 15K (losing spindles) Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping
RE: Advice needed on move to Sun 15K (losing spindles)
Fortunately my SA believes that so we were able to present a united front at the presentation (and yes, the Sun rep said that with a large enough cache RAID 5 works just as well as 1+0 - which is what we would be using). Jay Miller -Original Message- Sent: Friday, October 11, 2002 4:54 PM To: Multiple recipients of list ORACLE-L One thing that should be made clear: Never, ever, stripe with parity (i.e. RAID 5, etc.) unless you are force, at gunpoint, to do it. That is BAD. Your database will run faster on an abacus ... well ... maybe a slide rule. -Original Message- Yes, it's entirely separate CPUs and disks. If I can believe the Sun rep (ehem) there should be no interference. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: O/T - Disk IOs
Jared - Which system is that? I tried it on Solaris and Tru64, but it wasn't there. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 11, 2002 4:54 PM To: Multiple recipients of list ORACLE-L vxprint can be used to determine which drives make up a filesystem. Jared Jenner Mike [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/11/2002 11:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:O/T - Disk IOs Can anyone direct me to a method or tool for checking I/O on filesystems. the problem lies with matching up device names given by iostat to filesystem mount point names given by df. I.e. iostat -xdn extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device . 0.6 2.5 23.0 20.1 0.0 0.00.0 14.1 0 4 c3t5d4 3.0 2.1 22.1 17.4 0.0 0.10.0 11.6 0 3 c2t4d0 3.0 1.5 22.1 17.1 0.0 0.00.18.3 0 2 c1t0d0 . (or iostat -x shows devices as 'ssd34'.) I have Solaris 2.7 , veritas volume manager with non journalled filesystems. I'm afraid that I have not been able to keep up with Unix sys admin skills since I looked after SunOS 4.1.3 , HP-UX 9.7/10 and Apollo DomainOS workstations. Regards, Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 8.1.7.2 or 8.1.7.4
On Fri, Oct 11, 2002 at 12:09:21PM -0800, Rachna Vaidya wrote: We are running Solaris 6. Currently 8.1.6.3 Planning for 8.1.7 Management is pressing for the patch in the same go due to downtime issues. My solaris 5.8/8.1.7.4 is a dream. Up since 7/1/2002 without a burp. A little slow wrt i/o, but that is likely just old slow disk. Really cheap, though. Fast, cheap, good, pick two. -Rachna - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 11, 2002 3:12 PM I'm investigating an 8.1.7 upgrade also. My impression is that the stability may vary by platform, so it might be helpful to specify the platform that is involved. I'm on HP/Compaq Tru64 myself. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 11, 2002 1:46 PM To: Multiple recipients of list ORACLE-L Vaidya I'm running 8.1.7.2 on all instances when I go to upgrade it will probably be 9iR2 starting with a test db, then from there, onto the least important db upwards. Of course I'm stalling to let all the venturous customers test thease new realeases (and abundantly advancing I might add) out for me =). I haven't had an issue where I couldn't get support because I wasn't at .3 or .4, nor has an issue arose in .2 that left me no choice to upgrade... -Original Message- mailto:rachnavaidya;hotmail.com ] Sent: Friday, October 11, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was 8.1.7.4 for the reason that it was latest. But some of my friends have advised 8.1.7.2 Any opinions? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: O/T - Disk IOs
It's part of Veritas volume manager. DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/11/2002 03:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: O/T - Disk IOs Jared - Which system is that? I tried it on Solaris and Tru64, but it wasn't there. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 11, 2002 4:54 PM To: Multiple recipients of list ORACLE-L vxprint can be used to determine which drives make up a filesystem. Jared Jenner Mike [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/11/2002 11:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:O/T - Disk IOs Can anyone direct me to a method or tool for checking I/O on filesystems. the problem lies with matching up device names given by iostat to filesystem mount point names given by df. I.e. iostat -xdn extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device . 0.6 2.5 23.0 20.1 0.0 0.00.0 14.1 0 4 c3t5d4 3.0 2.1 22.1 17.4 0.0 0.10.0 11.6 0 3 c2t4d0 3.0 1.5 22.1 17.1 0.0 0.00.18.3 0 2 c1t0d0 . (or iostat -x shows devices as 'ssd34'.) I have Solaris 2.7 , veritas volume manager with non journalled filesystems. I'm afraid that I have not been able to keep up with Unix sys admin skills since I looked after SunOS 4.1.3 , HP-UX 9.7/10 and Apollo DomainOS workstations. Regards, Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: O/T - Disk IOs
vxprint comes with Veritas. -Original Message- Sent: Friday, October 11, 2002 6:49 PM To: Multiple recipients of list ORACLE-L Jared - Which system is that? I tried it on Solaris and Tru64, but it wasn't there. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 11, 2002 4:54 PM To: Multiple recipients of list ORACLE-L vxprint can be used to determine which drives make up a filesystem. Jared Jenner Mike [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/11/2002 11:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:O/T - Disk IOs Can anyone direct me to a method or tool for checking I/O on filesystems. the problem lies with matching up device names given by iostat to filesystem mount point names given by df. I.e. iostat -xdn extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device . 0.6 2.5 23.0 20.1 0.0 0.00.0 14.1 0 4 c3t5d4 3.0 2.1 22.1 17.4 0.0 0.10.0 11.6 0 3 c2t4d0 3.0 1.5 22.1 17.1 0.0 0.00.18.3 0 2 c1t0d0 . (or iostat -x shows devices as 'ssd34'.) I have Solaris 2.7 , veritas volume manager with non journalled filesystems. I'm afraid that I have not been able to keep up with Unix sys admin skills since I looked after SunOS 4.1.3 , HP-UX 9.7/10 and Apollo DomainOS workstations. Regards, Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] ORACLE 9.2 and different version of client?
How were you able to connect INTERNAL or SYS AS SYSDBA from a remote ORACLE_HOME ? INTERNAL from the same O_H didn't require a passsword, per the default behaviour. SYS AS SYSDBA from a remote O_H requires a Password from the password file. Does your developer has the SYS password ? Hemant At 07:23 AM 11-10-02 -0800, you wrote: Using clients 9 be ready for a question from someone that connect internal works with 9i too! :-) One day a developer came to me and said that contrary to what I had told him he was able to connect as internal into a 9iR2 test DB, and he showed me. Later I figured out that he was using 8.0.5 client and concluded that 8 client sends INTERNAL as SYS AS SYSDBA to the server. Regards Naveen -Original Message- Sent: Friday, October 11, 2002 8:29 PM To: Multiple recipients of list ORACLE-L In theory all three clients will work with 9iRelease2. However, we have encountered a problem where the client is 8.0.6, connects to a 9.2 database which has a database link to an 8.1.7 database -- queries across the db-link result in an ORA-3120 error. The analyst closed the TAR has 8.0.6 is desupported -- we tried even with tha 8.0.6.3 Patchset on the client. A 9.2 client connecting to 7.3.4 is certainly NOT supported. See Note 207319.1 on MetaLink. Hemant At 06:23 AM 11-10-02 -0800, you wrote: we plan to upfrade our database from ORACLE 8.1.7 to 9.2. The database on SUn Solaris server. My question are: 1. will following version of ORACLE client(on PC) work with ORACLE 9.2 server? 7.3.4 client 8.0.5 client 8.1.6 client 2. can ORACLE client 9.2 work with following version of ORACLE server? 7.3.4 server 8.0.5 server 8.1.6 server Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).