AW: auditing tables
TNX for your answers. What I need is exactly what Oracle doesn't support. Logging "who" changed "what" in a special area of our database. I think triggering the events will be much more specific and more easy to change. In case all our applications use the same database and user, I am trying to check out what application is changing monitored tables (i.e. c:\app\userapp\app.exe is changing table1). What do you think of that ?? greets > Frank < >Von: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > >what sort of information are you looking to audit? if you want any >sort of detail, you are better off with triggers and possibly an audit >table. Oracle doesn't record WHAT has been changed, just that the >table was accessed. So you don't know the row etc... > > >--- "Foelz.Frank" <[EMAIL PROTECTED]> wrote: >> Hi all, >> >> does anyone have experience in using Oracle's possibilities of >> auditing >> a database ?? >> >> I am interested in performance questions i.e. is it a hughe loss of >> performance >> when auditing tables Inserts/Updates/Deletes. Should I use triggers >> instead >> ? >> >> any hints (comments, websites, etc...) are welcome. >> >> > Frank < >> -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Foelz.Frank 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).
RTFM questions (formally RE: PL/SQL)
Title: RTFM questions (formally RE: PL/SQL) The problem is that if you always ask the group for help, you never learn where the information is within the manuals or other reference documentation and the group also gets cluttered with trivia. I agree with you that the list is here to help people and I personally do not mind the odd naive question from a new DBA, but it is the "...can't be bothered to look up the manual.." attitude that is most frustrating. When you ask the format of a command (for example) to the list, you are potentionally asking 1000's of people the same question who will all have to spend the time to filter these questions - we are all busy people and I personally do not want to use my time in this way. I'm sure you can see that this is a much more expensive option than asking the person next to you. Cheers, Craig. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 29 January 2002 2:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: PL/SQL Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ang: RE: sqlplus question
Well, you can check the manual but use the package dbms_output.put_job that willfix it when you are inoracle but ifyoua re in unix environment you must use crontab Hope this is of help for you Roland "Weaver, Walt" <[EMAIL PROTECTED]>@fatcity.com den 2002-01-28 14:45 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: slightly OT: Debugging package
Compile it in SQLPLUS -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PL/SQL
Why do you bother being on this List: The list is here to help fellow DBA'S. Have you never said to one of your collegues , what is the format of this command, or how can I do that, when you simply cant be bothered to look it up in the manual (either your busy or just down right lazy): Sometimes this list is useful for just that. So why dont u lighten up dude. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle trace file on/off
LoL...yea, not a problem...happy event'ing to you! -Original Message- To: Mohan, Ross; [EMAIL PROTECTED] Sent: 1/28/2002 8:55 PM Thanks you, Darth !! - Luke -Original Message- Sent: Monday, January 28, 2002 7:35 PM To: 'Deshpande, Kirti'; [EMAIL PROTECTED] Dump the session events at group level #1 ( session level ) and parse the second column (Evt3). I didn't say it was elegant. :-) Use this power only for Good, not for Evil, Luke. - Old Bent Wand -Original Message- Sent: Monday, January 28, 2002 7:57 PM To: Mohan, Ross; [EMAIL PROTECTED] You may turn the trace on or off that way, but how do you interrogate it to find its event settings? - Kirti -Original Message- Sent: Monday, January 28, 2002 6:42 PM To: 'Deshpande, Kirti'; [EMAIL PROTECTED] ORADEBUG SETORAPID, would make "current session" whatever you like, no? -Original Message- >From what I know, there is no way to find if a session has turned on the tracing unless it is your own session. DBMS_SYSTEM.read_ev can you tell you if the current session is tracing or not, but it can not interrogate other sessions. The only way I know is to check the trace files generated in the udump directory.. but it is not fool-proof. And since you can not find out who is tracing at the moment, you can not stop it.. Ross, I sure would like to learn the trick. Can you please post it?? :) Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Oh my god. He added the OCP. GEEK! -Original Message- [EMAIL PROTECTED] Sent: Monday, January 28, 2002 12:06 PM To: Multiple recipients of list ORACLE-L Ahem... Is this thing on? OK. For those of you that are new, have short memories or are easily confused, this post was not serious. It was a joke. One look at the senders address will confirm that. How do I turn this thing off? Jared ( the list owner, SA, OCP and Part Time Perl Evangelist ) "Khedr, Waleed" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/28/02 11:35 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Hey guys take it easy! -Original Message- Sent: Monday, January 28, 2002 2:17 PM To: Multiple recipients of list ORACLE-L Are you an idiot? -Original Message- HELP -Original Message- Sent: Monday, January 28, 2002 11:26 AM To: Multiple recipients of list ORACLE-L INDEX ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed 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: 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PL/SQL
Actually, I think the response is justified. Roland has posted many questions, in a steady stream, on basic stuff without even researching. And low and behold, when he did go research he found the answer. Life is so much easier that way. -Original Message- Beth Sent: Monday, January 28, 2002 9:35 AM To: Multiple recipients of list ORACLE-L Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Seefelt, Beth 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle trace file on/off
Thanks you, Darth !! - Luke -Original Message- Sent: Monday, January 28, 2002 7:35 PM To: 'Deshpande, Kirti'; [EMAIL PROTECTED] Dump the session events at group level #1 ( session level ) and parse the second column (Evt3). I didn't say it was elegant. :-) Use this power only for Good, not for Evil, Luke. - Old Bent Wand -Original Message- Sent: Monday, January 28, 2002 7:57 PM To: Mohan, Ross; [EMAIL PROTECTED] You may turn the trace on or off that way, but how do you interrogate it to find its event settings? - Kirti -Original Message- Sent: Monday, January 28, 2002 6:42 PM To: 'Deshpande, Kirti'; [EMAIL PROTECTED] ORADEBUG SETORAPID, would make "current session" whatever you like, no? -Original Message- >From what I know, there is no way to find if a session has turned on the tracing unless it is your own session. DBMS_SYSTEM.read_ev can you tell you if the current session is tracing or not, but it can not interrogate other sessions. The only way I know is to check the trace files generated in the udump directory.. but it is not fool-proof. And since you can not find out who is tracing at the moment, you can not stop it.. Ross, I sure would like to learn the trick. Can you please post it?? :) 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hot backup and TEMP tablespace
Hum, I apologize. Did not read well enough. -Original Message- Thomas F Sent: Monday, January 28, 2002 9:16 AM To: Multiple recipients of list ORACLE-L Kimberly, That is an excellent point! But the original writer was taking a hot backup of the TEMP tablespace, so she must be using an older version of Oracle. Maybe she should migrate to 8i? :) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, January 28, 2002 10:16 AM To: Multiple recipients of list ORACLE-L If you are using a temp tablespace with a temp file you really are not suppose to back it up. This comes from Oracle, not folks trying to save time. You cannot put them into backup mode so how do you recommend backing them up? -Original Message- Thomas F Sent: Monday, January 28, 2002 5:31 AM To: Multiple recipients of list ORACLE-L Traci, Yes, you can skip backing up the TEMP tablespaces, and as Kirti suggested, and have instructions in your recovery manual on how to rebuild the tablespace when you are going thru a recovery. In my humble opinion, I would not do this. It's kinda like using duct tape to cover a crack in the window - it works, but its really not right. Do you really want to be in the position of performing "extra" recovery steps just to save yourself some time during backups? Why stop at backing up the TEMP tablespace - why not the ROLLBACK tablespace - this could be dropped and re-created also. Why not INDEX tablespaces - heck, if you have the scripts, these could be re-created too! My point (as a professional DBA) is that, backups should be intact so that you can recover easily without having to do "extra work". It is really one less thing to remember and have to worry about. If your real issue is that you cannot perform your backup in the time allotted, or that you need more disk space to perform your backup, you should either investigate Rman (as Jared suggested), or buy more disk - both should be considered the "cost of doing business". I am a strong proponent of Rman - it solves MANY backup and recovery problems. Hope this helps! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Saturday, January 26, 2002 10:40 AM To: Multiple recipients of list ORACLE-L I was wondering if anyone could offer any suggestions to this issue, or the pro's and con's... We are trying to shorten the time frame that it takes to complete our Oracle hot backups, and the subsequent file copies to tape. I have read that it is ok to skip the TEMP tablespace, and then do an off-line drop of the datafile(s) in the temporary tablespace, drop the tablespace, and then recreate it. Our temporary tablespaces are 900mb, and they take a chunk of the total time it takes to complete the hot backups. Are there any issues or ramifications of not including that tablespace in the event of a recovery? It seems to me that it would be much quicker to re-create that tablespace if needed. Any suggestions are greatly appreciated. Traci Rebman Oracle Database Administrator R.R. Donnelley & Sons - Financial Division Lancaster, PA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F 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: Kimberly Smith 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)
RE: Operating system choice / ORACLE-L Digest -- Volume 2002, Num
But is is longer? Uh, to learn that is? -Original Message- Sent: Monday, January 28, 2002 8:21 PM To: Multiple recipients of list ORACLE-L Number 026 Unix is harder. ORACLE-L Digest -- Volume 2002, Number 026 > -- > > From: [EMAIL PROTECTED] > Date: Fri, 25 Jan 2002 09:39:53 -0500 > Subject: Operating system choice > > The topic of "Oracle on NT vs. Oracle on UNIX" has been addressed many > times before, but in my searches I have not found hard statistics to > support either choice. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle trace file on/off
Dump the session events at group level #1 ( session level ) and parse the second column (Evt3). I didn't say it was elegant. :-) Use this power only for Good, not for Evil, Luke. - Old Bent Wand -Original Message- Sent: Monday, January 28, 2002 7:57 PM To: Mohan, Ross; [EMAIL PROTECTED] You may turn the trace on or off that way, but how do you interrogate it to find its event settings? - Kirti -Original Message- Sent: Monday, January 28, 2002 6:42 PM To: 'Deshpande, Kirti'; [EMAIL PROTECTED] ORADEBUG SETORAPID, would make "current session" whatever you like, no? -Original Message- >From what I know, there is no way to find if a session has turned on the tracing unless it is your own session. DBMS_SYSTEM.read_ev can you tell you if the current session is tracing or not, but it can not interrogate other sessions. The only way I know is to check the trace files generated in the udump directory.. but it is not fool-proof. And since you can not find out who is tracing at the moment, you can not stop it.. Ross, I sure would like to learn the trick. Can you please post it?? :) Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Operating system choice / ORACLE-L Digest -- Volume 2002, Number 026
Unix is harder. ORACLE-L Digest -- Volume 2002, Number 026 > -- > > From: [EMAIL PROTECTED] > Date: Fri, 25 Jan 2002 09:39:53 -0500 > Subject: Operating system choice > > The topic of "Oracle on NT vs. Oracle on UNIX" has been addressed many > times before, but in my searches I have not found hard statistics to > support either choice. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Mail from PL/SQL without Java
Jared, Thanks a lot for the info. Yes, it will be useful.. - Kirti -Original Message- Sent: Monday, January 28, 2002 5:55 PM To: Multiple recipients of list ORACLE-L Some of you may find this of interest: http://www.total-knowledge.com/progs/ora_mail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
IOUG and Teradata
If you take a look at the IOUG Conference registration page at www.ioug.org, you will see that Teradata is one of the conference sponsors. Does anyone know the story behind that? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle trace file on/off
You may turn the trace on or off that way, but how do you interrogate it to find its event settings? - Kirti -Original Message- Sent: Monday, January 28, 2002 6:42 PM To: 'Deshpande, Kirti'; [EMAIL PROTECTED] ORADEBUG SETORAPID, would make "current session" whatever you like, no? -Original Message- >From what I know, there is no way to find if a session has turned on the tracing unless it is your own session. DBMS_SYSTEM.read_ev can you tell you if the current session is tracing or not, but it can not interrogate other sessions. The only way I know is to check the trace files generated in the udump directory.. but it is not fool-proof. And since you can not find out who is tracing at the moment, you can not stop it.. Ross, I sure would like to learn the trick. Can you please post it?? :) 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle trace file on/off
ORADEBUG SETORAPID, would make "current session" whatever you like, no? -Original Message- >From what I know, there is no way to find if a session has turned on the tracing unless it is your own session. DBMS_SYSTEM.read_ev can you tell you if the current session is tracing or not, but it can not interrogate other sessions. The only way I know is to check the trace files generated in the udump directory.. but it is not fool-proof. And since you can not find out who is tracing at the moment, you can not stop it.. Ross, I sure would like to learn the trick. Can you please post it?? :) Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: not a single-group group function error
Even if you got this to work, the three numbers would all be the same. Maybe you should explain what result you are attempting to show. At 03:05 PM 1/28/02 -0800, you wrote: >Why when I use the following SQL it get a >ORA-00937: not a single-group group function >ORA-06512: at "PRIMUS.LICENSE_USE_EVERY_30", line 14 >ORA-06512: at line 1 > > >Thank you in advance >Lance > >SELECT > ROUND(AVG(COUNT(Time_stamp))), > MIN(COUNT(time_stamp)), > MAX(COUNT(time_stamp)), > Time_stamp > FROM > cp_license_use > Where time_stamp = parmTime > and time_stamp >= SYSDATE-7 > group by Time_Stamp) >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Lance Prais > 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: Regina Harter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sqlplus question
Title: RE: sqlplus question > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > But there is a little detail I failed to mention. My rundays > suppose to > skip weekends( that is easy) and certain holidays. > My OS is Windows NT. > Any suggestion is greatly appreciated. Can you use dbms_job? If so, keep the list of holidays in a database table. Have the stored procedure re-submit the job at the beginning of the procedure, and skip week-ends by checking to_char (sysdate, 'D') and holidays by checking in your holiday table.
RE: Oracle trace file on/off
>From what I know, there is no way to find if a session has turned on the tracing unless it is your own session. DBMS_SYSTEM.read_ev can you tell you if the current session is tracing or not, but it can not interrogate other sessions. The only way I know is to check the trace files generated in the udump directory.. but it is not fool-proof. And since you can not find out who is tracing at the moment, you can not stop it.. Ross, I sure would like to learn the trick. Can you please post it?? :) Thanks. - Kirti -Original Message- Sent: Monday, January 28, 2002 5:05 PM To: Multiple recipients of list ORACLE-L iteratively loop thru ORADEBUG asking sid/serial# if they have events set, as i recall. - Ross "too lazy to rtfm to remember trick" Mohan -Original Message- Sent: Monday, January 28, 2002 5:40 PM To: Multiple recipients of list ORACLE-L Hi all, How do I find out if someone is running trace on oracle database and how do I turn trace off? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
Mail from PL/SQL without Java
Some of you may find this of interest: http://www.total-knowledge.com/progs/ora_mail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sqlplus question
Or, if in NT, ask Jared. He has a nifty fix for AT. Or, schedule a job if you can wrap the thing as a package. -Original Message- Sent: Monday, January 28, 2002 5:45 PM To: Multiple recipients of list ORACLE-L Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Stand by database
--- [EMAIL PROTECTED] wrote: > Hi all: > If anybody has a concise document on > setting up stand by databases, please > send me a copy or send me the links on > the web where I can find one. Try the Oracle8i Standby Database Concepts and Administration guide: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76995/toc.htm Cheers. -Tom = Thomas B. Cox "Saepe in errore sed numquam in dubito" [EMAIL PROTECTED] http://www.geocities.com/tbcox23/ "The whole aim of practical politics is to keep the populace alarmed (and hence clamorous to be led to safety) by menacing it with an endless series of hobgoblins, all of them imaginary." --H.L. Mencken __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas B. Cox INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Not a valid month error
Title: RE: Not a valid month error OK, my first guess was wrong. I can't think of any other idea. What if you do a describe cp_license_use describe pt_client_event and send the results to the list? That might help some of my disused neurons to fire up. Are there any triggers on cp_license_use? Could it be that a trigger fired after an insert on cp_license_use is taking the input field in the format 'MM/DD/ HH:MI' and trying to convert it into a date using a different format? -Original Message- From: Lance Prais [mailto:[EMAIL PROTECTED]] The field type is date for the pt_client_event.pc_date, I am confused thoroughly to why this will not work. -Original Message- From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] > -Original Message- > From: Lance Prais [mailto:[EMAIL PROTECTED]] > > I am trying to use the following insert statement but getting an > error:"ORA-01843: not a valid month" > > What is the problem , I have converted the sysdate using this > before with > out any errors? > > insert into cp_license_use(Select A.Pc_session_id, > a.pc_session_user_name, > To_Char(SYSDATE,'MM/DD/ HH:MI') From pt_client_event A where > A.pc_event_op = 'LAUNCH' and A.pc_date >=SYSDATE -1 > minus > Select B.Pc_session_id, b.pc_session_user_name, > To_Char(SYSDATE,'MM/DD/ > HH:MI') From pt_client_event B where B.Pc_event_op = 'LOGOUT' > and B.pc_date > >=SYSDATE -1); Just a wild guess, but what is the datatype for field pt_client_event.pc_date ? If it has varchar2 for example, and Oracle has to do an implicit conversion to a date for the comparison to sysdate, then you might get error ORA-01843.
Re: sqlplus question
> The script is only suppose > to run certain days of week. > Does anyone have a suggestion how to do that. Yes, just run it on those days, skipping the days that you don't want it to run. ... But seriously, which platform? Unix, win32, OS/390, VMS? On unix use 'cron'. http://www.google.com/search?hl=en&q=cron+tutorial On Win32 use the 'at' command: just type 'at /help' in a command window. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/28/02 02:21 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:sqlplus question Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sqlplus question
Sure. Depending on your operating system, you can submit it through a scheduler (e.g., cron, submit, etc.). If you don't have a snazzy-dazzy scheduler, you can use as part of the where condition something like to_char(sysdate,'DAY') in ('MONDAY','WEDNESDAY','FRIDAY'); or whatever. Or you can class it up with whenevers. HTH, Bambi. -Original Message- Sent: Monday, January 28, 2002 4:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi 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).
not a single-group group function error
Why when I use the following SQL it get a ORA-00937: not a single-group group function ORA-06512: at "PRIMUS.LICENSE_USE_EVERY_30", line 14 ORA-06512: at line 1 Thank you in advance Lance SELECT ROUND(AVG(COUNT(Time_stamp))), MIN(COUNT(time_stamp)), MAX(COUNT(time_stamp)), Time_stamp FROM cp_license_use Where time_stamp = parmTime and time_stamp >= SYSDATE-7 group by Time_Stamp) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sqlplus question
Roland, No fair changing your name. UNIX cron, NT @scheduler, dbms_jobs, or a combination. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 lhoska@calibre sys.com To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: sqlplus question om 01/28/2002 04:21 PM Please respond to ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle trace file on/off
iteratively loop thru ORADEBUG asking sid/serial# if they have events set, as i recall. - Ross "too lazy to rtfm to remember trick" Mohan -Original Message- Sent: Monday, January 28, 2002 5:40 PM To: Multiple recipients of list ORACLE-L Hi all, How do I find out if someone is running trace on oracle database and how do I turn trace off? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sqlplus question
Title: RE: sqlplus question > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > I need to run some script using Oracle Sqlplus. The script > is only suppose > to run certain days of week. > Does anyone have a suggestion how to do that. a) - Use the scheduling software for your OS to schedule an OS script/job. b) - Make your script into a stored procedure and use dbms_job to schedule it. c) - Run the script every day. Start your SQL*Plus script with the following statements: whenever sqlerror exit declare saturday constant pls_integer := 6 ; sunday constant pls_integer := 7 ; today pls_integer ; begin today := to_char (sysdate, 'D') ; if today = saturday or today = sunday then raise_application_error (-20001, 'Script should only run on weekday.') ; end if ; end ; /
RE: FW: ORA-01555 - Delayed Block Cleanout
Hi Barb... Check out Note:45895.1 cause 3... I think this was the same one Jared posted the other day... I've posted part of the note below with an example that relates to your question... Cause #3: = Delayed block cleanout on old committed updates. An update operation completes and commits; the updated blocks are not touched again until a long-running query begins. Delayed Block Cleanout (DBC) has never been done on the blocks. This can result in a scenario which happens only under specific circumstances in VLDB, causing ORA-01555 errors when NO updates or inserts are being committed on the same blocks a query is retrieving. All of the following must be true for an ORA-01555 to occur in this case: (i) An update completes and commits and the blocks are not touched again until... ( Here is the large update - For arguments sake lets say SCN = 990 ) (ii) A long query begins against the previously updated blocks. ( Here is the FTS you are performing to "cleanup" - Read consistent SCN needs to be 1000 ) (iii) During the query, a considerable amount of DML takes place, though not on the previously updated blocks which the query is currently fetching. ( Other sessions are performing DML but not on the table you are interested in - Let's say a SCN of 1010 ) (iv) Under condition (iii) there is so much DML relative to available rollback space that the rollback segment used in the first update wraps around, probably several times. ( Not good ) (v) Under condition (iv), the commit SCN of the first update is cycled out of the rollback segment. ( You know where this is going ) (vi) Under condition (iv) the lowest SCN in the rollback segment is pushed higher than the read consistent SCN in the query. ( Bingo... - Rollback only knows about SCN's greater then 1005 due to this activity ) The above conditions imply that when a query reaches a block that has been updated but not cleaned out, the query quickly learns that the update committed, and accordingly cleans out the block. But because the update SCN is no longer in the rollback segment (condition (v)), the query doesn't know WHEN the update committed. ( Your read consistent SCN is 1000 but the rollback no longer contains this information ) This is important because if the commit happened before the query began, the current value in the block can be used by the query; but if the commit happened after, the old value must be fetched from the rollback segment. ( Read consistency 101 ) Now, because the rollback segment wrapped in (iv), we know that the update SCN can't be higher than the lowest SCN in the rollback segment, which gives us a nice upper bound. ( The upper bound would be 1005 in this example ) If we only knew that the read consistent SCN was higher than this upper bound, we would know that the update committed before the query started. ( This is not the case in my example since the read consistent SCN of 1000 is greater then the SCN of 1005 that is currently available in rollback ) But we don't know this because of condition (vi), so we can't even accurately "estimate" the update SCN. Hence, we get an ORA-01555. ( Since the lowest value SCN in rollback is 1005, we know that the block was committed before SCN 1005... But we do not know if the block committed before or after the start of the query at SCN 1000... Therefore, Oracle can not guarantee read consistency since it does not know if the block it is currently looking at changed before or after it started the query and therefore issues a snapshot too old ) HTH Tim -Original Message- Sent: Monday, January 28, 2002 3:57 PM To: Multiple recipients of list ORACLE-L OK, I'm moving this question back to the list, since my understanding of delayed block cleanout is so weak. Here's the definition I found of delayed block cleanout: When a data or index block is modified in the database and the transaction committed, Oracle does a fast commit by marking the transaction as committed in the rollback segment header but does not clean the datablocks that were modified. The next transaction which does a select on the modified blocks will do the actual cleanout of the block. This is known as a delayed block cleanout. According to this definition, your problem cannot be delayed block cleanout unless a data block has been modified. If delayed block cleanout is the problem, the recommended solution is FTS before you start your query. (Note 40689.1: If it is suspected that the block cleanout variant is the cause, then force block cleanout to occur prior to the transaction that returns the ora-1555. .. [set to rule and select count(*), or don't change optimizer and select count(*) with full hint] Forcing this FTS should not cause an ora-15
RE: sqlplus question
Thanks Jared, that would be great and I did think about applying your suggestion. But there is a little detail I failed to mention. My rundays suppose to skip weekends( that is easy) and certain holidays. My OS is Windows NT. Any suggestion is greatly appreciated. -Original Message- Sent: Monday, January 28, 2002 6:09 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] > The script is only suppose > to run certain days of week. > Does anyone have a suggestion how to do that. Yes, just run it on those days, skipping the days that you don't want it to run. ... But seriously, which platform? Unix, win32, OS/390, VMS? On unix use 'cron'. http://www.google.com/search?hl=en&q=cron+tutorial On Win32 use the 'at' command: just type 'at /help' in a command window. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/28/02 02:21 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:sqlplus question Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Standby database question
Please pardon my poor grammar. I should have said... The status of the data file (on the standby database) shows "RECOVER" unless the standby control file is refreshed. Thanks, Gerardo -Original Message- Sent: Monday, January 28, 2002 2:25 PM To: Multiple recipients of list ORACLE-L Jeremiah, According to the "Oracle8i Standby Database Concepts and Administration Guide" on the online Generic Doc CD (I'm looking at the 8.1.6 Doc CD). Page 4-15 Refreshing the Standby Database Control File The following steps describe how to refresh, or create a copy, of changes you have made to the primary database control file. Refresh the standby database control file after making major structural changes to the primary database, such as adding or dropping files. (Then the steps for refreshing the control file are given). Let me know if this is not the case. One thing we've noticed is that the status (from v$datafile) of the added data file shows "RECOVER" unless standby control file is not refreshed. Thanks, Gerardo -Original Message- Sent: Friday, January 25, 2002 2:00 PM To: Multiple recipients of list ORACLE-L On Fri, 25 Jan 2002, Molina, Gerardo wrote: > There is one last, but important step. > > You need to recreate standby control file... Why do you have to do that? It doesn't say to do that in the documentation. The new datafiles are reflected in the standby controlfile through normal recovery and by issuing the 'alter database create datafile' command. There is no need to re-dump and copy a new standby controlfile, and definitely no need to shut any database down. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 25 Jan 2002, Molina, Gerardo wrote: > on primary: > > alter database create standby controlfile as ''; > > ftp this new file to standby > > on standby: > > shutdown immediate > > copy new control file to appropriate locations with correct file name. > > startup nomount > > alter database mount standby database > > -Original Message- > Sent: Friday, January 25, 2002 12:01 PM > To: Multiple recipients of list ORACLE-L > > > On Fri, 25 Jan 2002, [EMAIL PROTECTED] wrote: > > > One of the co-workers has a hot standby database. Logs are applied > > at some interval. He has to add a tablespace. What is necessay to > > make standby database aware of this? > > This is clearly documented in the Oracle8i Standby Database Concepts > and Administration Manual. > > http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ > a76995/standbys.htm#27363 > > In short, you just add the tablespace to the primary, wait for the > standby to fail with ORA-01157, then issue the following command on > the standby: > > SQL> alter database create datafile '' as ''; > > Where foo is the location of the datafile on the primary, and bar is > the location on the standby (usually the same). > > If you create a tablespace with several datafiles, you will have to > issue this command a few times after recovering the standby and > waiting for the ORA-01157 each time. > > Don't fall into the trap some people do where they think they have to > copy the new file over to the standby every time they create a > datafile. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Molina, Gerardo 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: Molina, Gerardo 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 'ListGur
RE: Interpreting How to Stop Defragmenting and Start Living
Cherie Here is an Oracle document that I found useful: http://otn.oracle.com/deploy/availability/htdocs/fragment.html It is similar to what you have quoted, but states it a little more forcefully: Oracle has a number of recommendations. First, set all the extents in a tablespace to the same size. . . . Second, . . . Choose tablespaces for segments based on three recommended extent sizes: 128K, 4MB, or 128MB. For example, segments smaller than 128MB should be placed in tablespaces with 128KB extent size. Personally, I'm still trying to get my head around the whole uniform extents / LMT philosophy, so I am hardly an expert. In particular, I want to make the last statement say: "smaller than 128MB should be placed in tablespaces with 4MB extent size." I guess that if you are placing the index partitions in separate tablespaces, then the total index size doesn't apply, just the size of the individual partition, since that is the object you are putting in the correct tablespace. Another out would be the statement "where fragmentation is expected". Possibly if you are confident you won't experience fragmentation (maybe through accurate table growth prediction), then you may be less concerned with strict application of these techniques. Please share anything you learn as you apply these new techniques. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 28, 2002 12:35 PM To: Multiple recipients of list ORACLE-L Following is an excerpt from the white paper How to Stop Defragmenting and Start Living: These extent sizes are chosen to be a multiple of five blocks since Oracle7 will round all extent sizes to a multiple of five blocks. In Oracle8 extents won't be rounded to a multiple of five blocks if they are a multiple of the minimum extent size for the tablespace. For Oracle8 databases, choosing the following extent sizes is a little simpler. 1) Segments smaller than 128M should be placed in 128K extent tablespaces. 2) Segments between 128M and 4G should be placed in 4M extent tablespaces. 3) Segments larger than 4G should be placed in 128M extent tablespaces For the remainder of this paper we will assume that the Oracle7 extent sizes are used since they can be used in both releases. I have some partitioned indexes that I am trying to split out into individual tablespaces, one tablespace per partition. In the excerpt below, I'm not sure what the meaning of segment is. My question is this. If the entire index is 152M and an individual index partition is 5m, then what size extent sizes should I use in my index partition tablespaces? Note that this is an 8.0.4 database. Thanks for your clarification on this issue. Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: sqlplus question
Cron? At? -Original Message- Sent: Monday, January 28, 2002 3:21 PM To: Multiple recipients of list ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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).
Oracle trace file on/off
Hi all, How do I find out if someone is running trace on oracle database and how do I turn trace off? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FW: FW: ORA-01555 - Delayed Block Cleanout
Barb, As per my understanding of delayed block count, the definition that you give, is apt for Oracle 7.3 and below. Your statement that it does not clean the datablocks that were modified also holds true. To add further, starting with Oracle 8, Oracle introduced a fast commit mechanism, whereby some of the data blocks are marked with the commit SCN. The number of data blocks that are marked as such, depends on the number of blocks that are updated. If the transaction is a short one, then all the blocks could be marked. However, if its a long transaction, then only a few of the blocks are marked. If a transaction is long or short, is determined by the number of blocks that are updated. The threshold value is 10% of db_block_buffers. Also, the blocks must be presently in the database buffer cache and not flushed out. If this is not so, then the old method of delayed block count takes place, where only the transaction entry in the rollback segment header is marked as commited. And I believe, a snapshot too old could also occur because of some modifications to a data block, before the next transaction reading that block started. Thats what I think. I could stand corrected. Insights?? Raj "Baker, Barbara" <[EMAIL PROTECTED]>@fatcity.com on 01/28/2002 03:56:38 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: OK, I'm moving this question back to the list, since my understanding of delayed block cleanout is so weak. Here's the definition I found of delayed block cleanout: When a data or index block is modified in the database and the transaction committed, Oracle does a fast commit by marking the transaction as committed in the rollback segment header but does not clean the datablocks that were modified. The next transaction which does a select on the modified blocks will do the actual cleanout of the block. This is known as a delayed block cleanout. According to this definition, your problem cannot be delayed block cleanout unless a data block has been modified. If delayed block cleanout is the problem, the recommended solution is FTS before you start your query. (Note 40689.1: If it is suspected that the block cleanout variant is the cause, then force block cleanout to occur prior to the transaction that returns the ora-1555. .. [set to rule and select count(*), or don't change optimizer and select count(*) with full hint] Forcing this FTS should not cause an ora-1555, because you have not modified any blocks. Here's where someone on the list can enlighten me. In your case, I believe you're doing the large data load, then the transaction completes. The dataload is followed by a query against the table as a separate transaction. I'm guessing that the FTS will NOT cause a 1555 because it's query only, and will resolve any outstanding block issues. I would think the follow-on FTS would only cause a 1555 if it was running at the same time as the original transaction that's loading the data. Can anyone on the list confirm this?? Barb > -- > From: Walter K[SMTP:[EMAIL PROTECTED]] > Sent: Monday, January 28, 2002 12:34 PM > To: Baker, Barbara > Subject: Re: FW: ORA-01555 - Delayed Block Cleanout > > No, it's the same issue as before except I am trying > to come up with a way of preventing the 1555 error. > According to my understanding, 1555 due to delayed > block cleanout occurs when a block is left as > "uncommitted", and the corresponding rollback segment > block, which hopefully contains the SCN for when the > block was committed isn't available because the > segment wrapped and the block is no longer in the > rollback segment, thus causing the 1555 error. > > So, according to what I have read, until all blocks > are read, then and only then, or if the DB is bounced, > will the blocks get cleaned out (marked committed). > So, if the FTS fails due to 1555 it would seem to me > that it failed on the first block that it encountered > a problem with, that block gets cleaned but no more > blocks are read in because of the error and therefore > it is possible for the remaining unscanned blocks to > still be flagged as "uncommitted" and the 1555 will > keep occurring until every block has been scanned. If > this is in fact the case then one may need to perform > the FTS numerous times until all the blocks have been > scanned successfully. This is obviously not practical > and is what I am trying to get to the bottom of. > > The table in question is 20 million rows large, is > truncated and loaded weekly, and no DML is ever > performed on it. We put an exclusive lock on the table > to ensure the 1555 wasn't the result of concurrent DML > occurring. I am pretty confident that the 1555 we have > seen is due to delayed block cleanout but again, if > the solution is a FTS to clean the blocks out it would > seem to me that a FTS could need to be done several > times unt
RE: Standby database question
Jeremiah, According to the "Oracle8i Standby Database Concepts and Administration Guide" on the online Generic Doc CD (I'm looking at the 8.1.6 Doc CD). Page 4-15 Refreshing the Standby Database Control File The following steps describe how to refresh, or create a copy, of changes you have made to the primary database control file. Refresh the standby database control file after making major structural changes to the primary database, such as adding or dropping files. (Then the steps for refreshing the control file are given). Let me know if this is not the case. One thing we've noticed is that the status (from v$datafile) of the added data file shows "RECOVER" unless standby control file is not refreshed. Thanks, Gerardo -Original Message- Sent: Friday, January 25, 2002 2:00 PM To: Multiple recipients of list ORACLE-L On Fri, 25 Jan 2002, Molina, Gerardo wrote: > There is one last, but important step. > > You need to recreate standby control file... Why do you have to do that? It doesn't say to do that in the documentation. The new datafiles are reflected in the standby controlfile through normal recovery and by issuing the 'alter database create datafile' command. There is no need to re-dump and copy a new standby controlfile, and definitely no need to shut any database down. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 25 Jan 2002, Molina, Gerardo wrote: > on primary: > > alter database create standby controlfile as ''; > > ftp this new file to standby > > on standby: > > shutdown immediate > > copy new control file to appropriate locations with correct file name. > > startup nomount > > alter database mount standby database > > -Original Message- > Sent: Friday, January 25, 2002 12:01 PM > To: Multiple recipients of list ORACLE-L > > > On Fri, 25 Jan 2002, [EMAIL PROTECTED] wrote: > > > One of the co-workers has a hot standby database. Logs are applied > > at some interval. He has to add a tablespace. What is necessay to > > make standby database aware of this? > > This is clearly documented in the Oracle8i Standby Database Concepts > and Administration Manual. > > http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ > a76995/standbys.htm#27363 > > In short, you just add the tablespace to the primary, wait for the > standby to fail with ORA-01157, then issue the following command on > the standby: > > SQL> alter database create datafile '' as ''; > > Where foo is the location of the datafile on the primary, and bar is > the location on the standby (usually the same). > > If you create a tablespace with several datafiles, you will have to > issue this command a few times after recovering the standby and > waiting for the ORA-01157 each time. > > Don't fall into the trap some people do where they think they have to > copy the new file over to the standby every time they create a > datafile. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Molina, Gerardo 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).
sqlplus question
Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need some help PLEASE on an ora 3113 in svrmgrl
Can you start an instance? -Original Message- Sent: Monday, January 28, 2002 4:42 PM To: Multiple recipients of list ORACLE-L Hi All, i am running oracle 8170 on solaris 7, i had a problem shutting down oracle and ended up having to do a shutdown abort. i reboot the server to clean everything up and when i tried to restart the db i get the ora 3113 inside of svrmgrl. There are 2 other db that start up fine. It creates a 20m core file and there are no errors in the alert log, listener log, sqlnet log etc and no trace files. Any help would be greatly appreciated!! i am lost been looking around metalink for hours and can't find anything useful. Thanks, -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner 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: Khedr, Waleed 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).
Never mind i fixed it but thanks, Need some help PLEASE on an
I found the problem and fixed it thanks. Hi All, i am running oracle 8170 on solaris 7, i had a problem shutting down oracle and ended up having to do a shutdown abort. i reboot the server to clean everything up and when i tried to restart the db i get the ora 3113 inside of svrmgrl. There are 2 other db that start up fine. It creates a 20m core file and there are no errors in the alert log, listener log, sqlnet log etc and no trace files. Any help would be greatly appreciated!! i am lost been looking around metalink for hours and can't find anything useful. Thanks, -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: v$session question
Hi, There is a bug (1237128, http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=BUG&p_id=1237128) that might be related to this. The title of the bug is "V$SESSION.PROGRAM HAS NO VALUE USING WINNT ORACLE8/8I CLIENT CONNECTION" In our case, we see this when 816 NT OCI apps connect to our NT 817 database - we did not see it with the 816 OCI clients connecting to NT 815 database. HTH, Bruce Reardon -Original Message- Sent: Tuesday, 29 January 2002 1:35 Thanks for the info about module. I've got a script myself that show's info like GUI/character users, connect times etc... The piece I was now missing was the module field. Thanks for the info. Joe On Fri, 25 Jan 2002, Catherine LeBlanc wrote: > Yes, that will do it, but module does not have ifrun60, it has the actual > Oracle form name that the user is running. > Joe, I have a script to show all active connections and all that stuff if > you want it. > > Catherine LeBlanc > DBA, Bates College, Lewiston, ME > > At 07:36 AM 1/25/02 -0800, you wrote: > > >Hi, > > > >Try module in v$session (just a guess) > > > >Jack > > > > > >Joe LaCascio <[EMAIL PROTECTED]>@fatcity.com on 25-01-2002 15:35:24 > > > >cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) > > > > > >In the past, I was running Oracle 8.1.5 and the clients were running > >Oracle Forms 4.5. When I queried v$session and looked at the program > >field I could see what clients where running f45run32.exe. > > > >Now we are on Oracle 8.1.6 and the clients are running Forms60. When I > >now query v$session the program filed is null? > > > >What view could I query in 8.1.6 to see which users are running > >ifrun60.exe? > > > >Thanks, > >Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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).
Need some help PLEASE on an ora 3113 in svrmgrl
Hi All, i am running oracle 8170 on solaris 7, i had a problem shutting down oracle and ended up having to do a shutdown abort. i reboot the server to clean everything up and when i tried to restart the db i get the ora 3113 inside of svrmgrl. There are 2 other db that start up fine. It creates a 20m core file and there are no errors in the alert log, listener log, sqlnet log etc and no trace files. Any help would be greatly appreciated!! i am lost been looking around metalink for hours and can't find anything useful. Thanks, -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:bug in cursor FOR loops?
Paul, None that I've noticed & I have one that gets executes some 100,000 times. Dick Goulet Reply Separator Author: Paul Baumgartel <[EMAIL PROTECTED]> Date: 1/28/2002 1:15 PM Is there a bug (8.1.7.2.0 on HP-UX) in the implementation of cursor FOR loops, such that the cursor is not closed upon loop exit? If a function containing such a loop is called many times, eventually the session returns a "too many open cursors" error; an attempt to close the cursor manually after the loop returns "invalid cursor". I've searched MetaLink (including bug database) and haven't found anything. TIA, Paul Baumgartel __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Take two placebos and check back in the morning. --JoJo -Original Message- Walt Sent: Monday, January 28, 2002 12:51 PM To: Multiple recipients of list ORACLE-L HELP -Original Message- Sent: Monday, January 28, 2002 1:34 PM To: Multiple recipients of list ORACLE-L Walt started it. -Original Message- Ahem... Is this thing on? OK. For those of you that are new, have short memories or are easily confused, this post was not serious. It was a joke. One look at the senders address will confirm that. How do I turn this thing off? Jared ( the list owner, SA, OCP and Part Time Perl Evangelist ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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: JoJo Al-Zawawi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
RTFM. ;) -Original Message- Sent: Monday, January 28, 2002 2:51 PM To: Multiple recipients of list ORACLE-L HELP -Original Message- Sent: Monday, January 28, 2002 1:34 PM To: Multiple recipients of list ORACLE-L Walt started it. -Original Message- Ahem... Is this thing on? OK. For those of you that are new, have short memories or are easily confused, this post was not serious. It was a joke. One look at the senders address will confirm that. How do I turn this thing off? Jared ( the list owner, SA, OCP and Part Time Perl Evangelist ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Benchmark Myopia
I love a guy who know how to whip a metaphor into senseless submission. -Original Message- The driver is Bill Gates, the walking man is roadkill, the competition is eliminated, Bill wins no matter what. Later, homicide charges are dropped because prosecution would be bad for the automotive industry and stifle innovation. ;-) -Original Message- Sent: Monday, January 28, 2002 1:38 PM To: Multiple recipients of list ORACLE-L what happens if the man walks and the dragster runs out of gas after four miles? -Original Message- Sent: Monday, January 28, 2002 1:45 PM To: Multiple recipients of list ORACLE-L A few years ago I saw a show where a guy won a bet saying he could win a race against the world's fastest high performance dragster... on foot! Of course the dude on foot got to define the race. The length of the race was only about 10-20 feet. The man on foot and the dragster edged up to the starting line and the tension mounted as the starting lights went down the tree to green. Everything was filmed in slow motion and there was visible proof that the man on foot beat the dragster to the finish line only a few feet away. A few seconds later the dragster was deploying its parachute a quarter a mile away but it lost the 20 foot race. MySQL is like the man on foot... it may win the 20 foot race but who cares because the real race must be a distance that reflects real work. To me the real race is more like the Baja 1000 and I could probably beat the dragster in my Ford Explorer. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
bug in cursor FOR loops?
Is there a bug (8.1.7.2.0 on HP-UX) in the implementation of cursor FOR loops, such that the cursor is not closed upon loop exit? If a function containing such a loop is called many times, eventually the session returns a "too many open cursors" error; an attempt to close the cursor manually after the loop returns "invalid cursor". I've searched MetaLink (including bug database) and haven't found anything. TIA, Paul Baumgartel __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Benchmark Myopia
The driver is Bill Gates, the walking man is roadkill, the competition is eliminated, Bill wins no matter what. Later, homicide charges are dropped because prosecution would be bad for the automotive industry and stifle innovation. ;-) -Original Message- Sent: Monday, January 28, 2002 1:38 PM To: Multiple recipients of list ORACLE-L what happens if the man walks and the dragster runs out of gas after four miles? -Original Message- Sent: Monday, January 28, 2002 1:45 PM To: Multiple recipients of list ORACLE-L A few years ago I saw a show where a guy won a bet saying he could win a race against the world's fastest high performance dragster... on foot! Of course the dude on foot got to define the race. The length of the race was only about 10-20 feet. The man on foot and the dragster edged up to the starting line and the tension mounted as the starting lights went down the tree to green. Everything was filmed in slow motion and there was visible proof that the man on foot beat the dragster to the finish line only a few feet away. A few seconds later the dragster was deploying its parachute a quarter a mile away but it lost the 20 foot race. MySQL is like the man on foot... it may win the 20 foot race but who cares because the real race must be a distance that reflects real work. To me the real race is more like the Baja 1000 and I could probably beat the dragster in my Ford Explorer. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
"Jane! Stop this crazy thing!" - George Jetson, 1968 - Jared Still, 2002 -Original Message- HELP -Original Message- Walt started it. -Original Message- Ahem... Is this thing on? OK. For those of you that are new, have short memories or are easily confused, this post was not serious. It was a joke. One look at the senders address will confirm that. How do I turn this thing off? Jared ( the list owner, SA, OCP and Part Time Perl Evangelist ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: FW: ORA-01555 - Delayed Block Cleanout
OK, I'm moving this question back to the list, since my understanding of delayed block cleanout is so weak. Here's the definition I found of delayed block cleanout: When a data or index block is modified in the database and the transaction committed, Oracle does a fast commit by marking the transaction as committed in the rollback segment header but does not clean the datablocks that were modified. The next transaction which does a select on the modified blocks will do the actual cleanout of the block. This is known as a delayed block cleanout. According to this definition, your problem cannot be delayed block cleanout unless a data block has been modified. If delayed block cleanout is the problem, the recommended solution is FTS before you start your query. (Note 40689.1: If it is suspected that the block cleanout variant is the cause, then force block cleanout to occur prior to the transaction that returns the ora-1555. .. [set to rule and select count(*), or don't change optimizer and select count(*) with full hint] Forcing this FTS should not cause an ora-1555, because you have not modified any blocks. Here's where someone on the list can enlighten me. In your case, I believe you're doing the large data load, then the transaction completes. The dataload is followed by a query against the table as a separate transaction. I'm guessing that the FTS will NOT cause a 1555 because it's query only, and will resolve any outstanding block issues. I would think the follow-on FTS would only cause a 1555 if it was running at the same time as the original transaction that's loading the data. Can anyone on the list confirm this?? Barb > -- > From: Walter K[SMTP:[EMAIL PROTECTED]] > Sent: Monday, January 28, 2002 12:34 PM > To: Baker, Barbara > Subject: Re: FW: ORA-01555 - Delayed Block Cleanout > > No, it's the same issue as before except I am trying > to come up with a way of preventing the 1555 error. > According to my understanding, 1555 due to delayed > block cleanout occurs when a block is left as > "uncommitted", and the corresponding rollback segment > block, which hopefully contains the SCN for when the > block was committed isn't available because the > segment wrapped and the block is no longer in the > rollback segment, thus causing the 1555 error. > > So, according to what I have read, until all blocks > are read, then and only then, or if the DB is bounced, > will the blocks get cleaned out (marked committed). > So, if the FTS fails due to 1555 it would seem to me > that it failed on the first block that it encountered > a problem with, that block gets cleaned but no more > blocks are read in because of the error and therefore > it is possible for the remaining unscanned blocks to > still be flagged as "uncommitted" and the 1555 will > keep occurring until every block has been scanned. If > this is in fact the case then one may need to perform > the FTS numerous times until all the blocks have been > scanned successfully. This is obviously not practical > and is what I am trying to get to the bottom of. > > The table in question is 20 million rows large, is > truncated and loaded weekly, and no DML is ever > performed on it. We put an exclusive lock on the table > to ensure the 1555 wasn't the result of concurrent DML > occurring. I am pretty confident that the 1555 we have > seen is due to delayed block cleanout but again, if > the solution is a FTS to clean the blocks out it would > seem to me that a FTS could need to be done several > times until a clean select can be performed. I'm not > sure if the ANALYZE...COMPUTE that Jared suggested > would fail due to 1555, if not, it would be a better > alternative than multiple FTS's. > > Does this make sense? > > -w > > > > --- "Baker, Barbara" > <[EMAIL PROTECTED]> wrote: > > I confess to knowing little about delayed block > > cleanout. > > However, if you get a 1555 error when doing a fts, > > then I assume someone is > > doing something other than querying the table at the > > same time you're doing > > the fts. > > > > I thought this table was going into a warehouse. Is > > there really that much > > activity on the table that you can't do a fts > > without someone else changing > > data on you at the same time? Or am I missing > > something?? > > Barb > > > > > > > -- > > > From: Walter K[SMTP:[EMAIL PROTECTED]] > > > Reply To: [EMAIL PROTECTED] > > > Sent: Monday, January 28, 2002 8:55 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject: ORA-01555 - Delayed Block Cleanout > > > > > > From what I have read, a full table scan may be > > > necessary to initiate block cleanout in a VLDB to > > > prevent ORA-01555 errors due to delayed block > > > cleanout. However, if the full table scan itself > > falls > > > victim to the ORA-01555 error, how does one > > guarantee > > > that all the blocks in the table are > > visited?--keep > > > run
Re: Date Function.
I have not tested just found on MetaLink Rick SET ECHO off REM NAME: TFSBSDAY.SQL REM USAGE:"@path/tfsbsday" REM REM REQUIREMENTS: REMCREATE PROCEDURE REM REM PURPOSE: REMThe function created by this script will reutrn the number of REMbusiness days between two dates. REM REM EXAMPLE: REMSQL> @dates.sql REM REMFunction created. REM REMSQL> select num_Business_Days('20-jun-95','28-jun-95') "Business REMDays" from dual; REM REMBusiness Days REM REM - REM 5 REM
RE:
HELP -Original Message- Sent: Monday, January 28, 2002 1:34 PM To: Multiple recipients of list ORACLE-L Walt started it. -Original Message- Ahem... Is this thing on? OK. For those of you that are new, have short memories or are easily confused, this post was not serious. It was a joke. One look at the senders address will confirm that. How do I turn this thing off? Jared ( the list owner, SA, OCP and Part Time Perl Evangelist ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Benchmark Myopia
what happens if the man walks and the dragster runs out of gas after four miles? -Original Message- Sent: Monday, January 28, 2002 1:45 PM To: Multiple recipients of list ORACLE-L A few years ago I saw a show where a guy won a bet saying he could win a race against the world's fastest high performance dragster... on foot! Of course the dude on foot got to define the race. The length of the race was only about 10-20 feet. The man on foot and the dragster edged up to the starting line and the tension mounted as the starting lights went down the tree to green. Everything was filmed in slow motion and there was visible proof that the man on foot beat the dragster to the finish line only a few feet away. A few seconds later the dragster was deploying its parachute a quarter a mile away but it lost the 20 foot race. MySQL is like the man on foot... it may win the 20 foot race but who cares because the real race must be a distance that reflects real work. To me the real race is more like the Baja 1000 and I could probably beat the dragster in my Ford Explorer. Steve -Original Message- Sent: Monday, January 28, 2002 10:11 AM To: Multiple recipients of list ORACLE-L HI Steve, A good example of why words ambiguous words like faster are dangerous. I have often asked clients the question which is faster a Ferrari Roadster or a Mack Truck. Invariably the answer would be the Ferrari, I then answer that it depends on what you are trying to do. If you are trying to drive to work, definitely the ferrari, if you trying to move the contents of your house across country you would probably want to take the Mack truck, so the answer is "It depends" again. Until you know the intended usage, faster, doesn't mean alot. My .02, John [EMAIL PROTECTED] wrote: It's faster than Oracle. Oh... You hit a hot button!!!MySQL is faster at performing 1 query in 1 database session and not muchmore. But "comparing" the performance of a database engine withoutconsidering concurrent multi-user OLTP activity is very short-sighted. Ijust finished some benchmark tests of MySQL ISAM, MySQL InnoDB, and Oracleusing Perl DBD. MySQL was fast with individual queries, inserts or updatesbut it barfed as soon as I cranked up the number of sessions. Oracle flewthrough 30 concurrent sessions with each session performing many differentqueries. I was eager to further crank up the number of sessions (via a loopin Perl) but MySQL crapped out so there was no point going any further.MySQL ISAM does table level locking and one session would put all the othersin a wait state. MySQL InnoDB does row level locking but the InnoDBdeveloper (Heikki Tuuri) conceded that it InnoDB also barfs with multi-userselect, ins erts, updates and deletes so he's still working on it. The opensource MySQL community still has a lot of work to do to catch up to Oracle'sperformance when it comes to any real world multi-user database activity.MySQL faster than Oracle? This is a pearlescent example of benchmark myopia.IMHO,Steve OrrBozeman, Montana-Original Message-Sent: Monday, January 28, 2002 6:35 AMTo: Multiple recipients of list ORACLE-LOn Monday 28 January 2002 03:45, Marin Dimitrov wrote: maybe u could consider some free databases?of course the performance, functionality and the ease of use won't becomparable to MS SQL but many sites use such databases quite successfully Actually, the most popular of the free databases is mySql, which is likely faster than MS Sql. It's faster than Oracle. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Not a valid month error
Lance Prais wrote: > > I am trying to use the following insert statement but getting an > error:"ORA-01843: not a valid month" > > What is the problem , I have converted the sysdate using this before with > out any errors? > > Thank you in advance > Lance > > insert into cp_license_use(Select A.Pc_session_id, a.pc_session_user_name, > To_Char(SYSDATE,'MM/DD/ HH:MI') From pt_client_event A where > A.pc_event_op = 'LAUNCH' and A.pc_date >=SYSDATE -1 > minus > Select B.Pc_session_id, b.pc_session_user_name, To_Char(SYSDATE,'MM/DD/ > HH:MI') From pt_client_event B where B.Pc_event_op = 'LOGOUT' and B.pc_date > >=SYSDATE -1); > Are you sure that the 3rd column in cp_license_use is VARCHAR2 ? -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
Date Function.
Hi All, Is there any function in Oracle8i ( or in PHP4.X) to calculate number of Business days ( excluding Saturday and Sunday) between two given dates? Thanks in advance. Sridhar. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sridhar Moparthy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Those who cannot remember the past are condemned to repeat it. (it's a long running joke) Henry -Original Message- Sent: Monday, January 28, 2002 2:36 PM To: Multiple recipients of list ORACLE-L Hey guys take it easy! -Original Message- Sent: Monday, January 28, 2002 2:17 PM To: Multiple recipients of list ORACLE-L Are you an idiot? -Original Message- HELP -Original Message- Sent: Monday, January 28, 2002 11:26 AM To: Multiple recipients of list ORACLE-L INDEX ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed 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: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Walt started it. -Original Message- Ahem... Is this thing on? OK. For those of you that are new, have short memories or are easily confused, this post was not serious. It was a joke. One look at the senders address will confirm that. How do I turn this thing off? Jared ( the list owner, SA, OCP and Part Time Perl Evangelist ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Not a valid month error
Title: RE: Not a valid month error > -Original Message- > From: Lance Prais [mailto:[EMAIL PROTECTED]] > > I am trying to use the following insert statement but getting an > error:"ORA-01843: not a valid month" > > What is the problem , I have converted the sysdate using this > before with > out any errors? > > insert into cp_license_use(Select A.Pc_session_id, > a.pc_session_user_name, > To_Char(SYSDATE,'MM/DD/ HH:MI') From pt_client_event A where > A.pc_event_op = 'LAUNCH' and A.pc_date >=SYSDATE -1 > minus > Select B.Pc_session_id, b.pc_session_user_name, > To_Char(SYSDATE,'MM/DD/ > HH:MI') From pt_client_event B where B.Pc_event_op = 'LOGOUT' > and B.pc_date > >=SYSDATE -1); Just a wild guess, but what is the datatype for field pt_client_event.pc_date ? If it has varchar2 for example, and Oracle has to do an implicit conversion to a date for the comparison to sysdate, then you might get error ORA-01843.
RE:
Ahem... Is this thing on? OK. For those of you that are new, have short memories or are easily confused, this post was not serious. It was a joke. One look at the senders address will confirm that. How do I turn this thing off? Jared ( the list owner, SA, OCP and Part Time Perl Evangelist ) "Khedr, Waleed" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/28/02 11:35 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Hey guys take it easy! -Original Message- Sent: Monday, January 28, 2002 2:17 PM To: Multiple recipients of list ORACLE-L Are you an idiot? -Original Message- HELP -Original Message- Sent: Monday, January 28, 2002 11:26 AM To: Multiple recipients of list ORACLE-L INDEX ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hot backup and TEMP tablespace
On Mon, 28 Jan 2002, John Kanagaraj wrote: > There are two kinds of media recovery : Complete and incomplete. The > former requires that the database be mounted but not open when > recovery is being performed. If the database was just mounted, then > you will not be able to drop the TEMP tablespace. She is talking about offline drop of the datafiles comprising the temporary tablespaces before you begin the recovery. You can do this in mount mode regardless of what type of recovery you are performing. You wait to drop and recreate the tablespace until *after* you are done recovering (complete or incomplete) and have opened the database. The existence of the tablespace in the dictionary has no effect on recovery. > Add to this the fact that Oracle applies archive logs based on the > file header SCNs. If you restore an old copy of the TEMP > tablespace's datafiles, the recovery will require that *all* the > archive logs since the last backup of TEMP. This implies that you > need to be able to get these archive logs from the backup (without > missing even one), and spend time in applying them. This is > something you DON'T want to do in an emergen She is not planning to restore an old copy of the temp datafiles, but just re-create them after open. With careful planning, this is a safe and clever way to conserve resources during backup. It might actually *reduce* MTR for the recovery. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > > > I was wondering if anyone could offer any suggestions to this > > issue, or the > > pro's and con's... > > > > We are trying to shorten the time frame that it takes to complete our > > Oracle hot backups, and the subsequent file copies to tape. > > I have read > > that it is ok to skip the TEMP tablespace, and then do an > > off-line drop of > > the datafile(s) in the temporary tablespace, drop the > > tablespace, and then > > recreate it. > > > > Our temporary tablespaces are 900mb, and they take a chunk of > > the total > > time it takes to complete the hot backups. Are there any issues or > > ramifications of not including that tablespace in the event > > of a recovery? > > It seems to me that it would be much quicker to re-create > > that tablespace > > if needed. > > > > Any suggestions are greatly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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).
Not a valid month error
I am trying to use the following insert statement but getting an error:"ORA-01843: not a valid month" What is the problem , I have converted the sysdate using this before with out any errors? Thank you in advance Lance insert into cp_license_use(Select A.Pc_session_id, a.pc_session_user_name, To_Char(SYSDATE,'MM/DD/ HH:MI') From pt_client_event A where A.pc_event_op = 'LAUNCH' and A.pc_date >=SYSDATE -1 minus Select B.Pc_session_id, b.pc_session_user_name, To_Char(SYSDATE,'MM/DD/ HH:MI') From pt_client_event B where B.Pc_event_op = 'LOGOUT' and B.pc_date >=SYSDATE -1); -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Interpreting How to Stop Defragmenting and Start Living
Cherie, I would use extent sizing that can accomplish 3 things: 1. Is it a multiple of the block size?, 2, Is the extent size chosen used by other tables/tablespaces?( fragmentation prevention) 3, Are there multiple tables/tablespaces in the datafile. I used 4k, 4M and 20M extents for the database. The largest table partition only has 38 extents. My tables grow very little each year except when they are archived to the read only tablespaces. The current data space remains unchanged and can handle the data necessary before the archiving process truncates the tables. With the same sized extents in the same tablespace/datafile there is not an issue with fragmentation. I don't see any hard and fast rule that must be followed. Just make it easier on your self to manage and life will be great. Ron. ROR mª¿ªm >>> Cherie_Machler=Received: from CONNECT-MTA by galotter40gelco.com 01/28/02 01:35PM Following is an excerpt from the white paper How to Stop Defragmenting and Start Living: These extent sizes are chosen to be a multiple of five blocks since Oracle7 will round all extent sizes to a multiple of five blocks. In Oracle8 extents won't be rounded to a multiple of five blocks if they are a multiple of the minimum extent size for the tablespace. For Oracle8 databases, choosing the following extent sizes is a little simpler. 1) Segments smaller than 128M should be placed in 128K extent tablespaces. 2) Segments between 128M and 4G should be placed in 4M extent tablespaces. 3) Segments larger than 4G should be placed in 128M extent tablespaces For the remainder of this paper we will assume that the Oracle7 extent sizes are used since they can be used in both releases. I have some partitioned indexes that I am trying to split out into individual tablespaces, one tablespace per partition. In the excerpt below, I'm not sure what the meaning of segment is. My question is this. If the entire index is 152M and an individual index partition is 5m, then what size extent sizes should I use in my index partition tablespaces? Note that this is an 8.0.4 database. Thanks for your clarification on this issue. Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Hey guys take it easy! -Original Message- Sent: Monday, January 28, 2002 2:17 PM To: Multiple recipients of list ORACLE-L Are you an idiot? -Original Message- HELP -Original Message- Sent: Monday, January 28, 2002 11:26 AM To: Multiple recipients of list ORACLE-L INDEX ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
I think you want to send here - [EMAIL PROTECTED] instead of directly to the list... -Original Message- Sent: Monday, January 28, 2002 1:45 PM To: Multiple recipients of list ORACLE-L HELP -Original Message- Sent: Monday, January 28, 2002 11:26 AM To: Multiple recipients of list ORACLE-L INDEX ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Weaver, Walt 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: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: procedure error
First, do a SHOW ERROR after you compile to see what/where the error is. You can't issue DDL in a procedure. Look at using dynamic sql instead, eg. - EXECUTE IMMEDIATE 'Drop Table PRIMUS_TEMP_DUMP'; HTH, Beth -Original Message- Sent: Monday, January 28, 2002 1:45 PM To: Multiple recipients of list ORACLE-L I am trying to create the following procedure but getting the error "compiled with errors" Can anyone tell me why? Thanks In advance CREATE OR REPLACE PROCEDURE Primus_Report as Begin Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP ( SOLUTION_ID VARCHAR2 (85) NOT NULL, TITLEVARCHAR2 (3498), OWNERVARCHAR2 (255), P_TYPE VARCHAR2 (96), AUTHOR VARCHAR2 (255), MODIFIED_BY VARCHAR2 (255), ESCALATION_GROUP VARCHAR2 (255), TECH_RESOURCEVARCHAR2 (255), P_PARTITION VARCHAR2 (96), STATUS VARCHAR2 (96), HyperLinks VARCHAR2 (96), Style_reviewer VARCHAR2 (96), DATE_CREATED DATE, DATE_MODIFIEDDATE, ALERTVARCHAR2 (96), URGENCY VARCHAR2 (96), NO_PAGEVIEWS_LAST_MONTH VARCHAR2 (255), NO_PAGEVIEWS_QUARTER VARCHAR2 (255), NO_LINKS_LAST_7_DAYS VARCHAR2 (255), NO_LINKS_LAST_120_DAYS VARCHAR2 (255) ); INSERT INTO PRIMUS_TEMP_DUMP (solution_id,Title) SELECT pc_solution_id, pc_title FROM pt_solution; End; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais 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: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: procedure error
You can't run a DDL in a procedure directly, you have to use dynamic_sql to execute DDL statements. 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- Sent: Monday, January 28, 2002 1:45 PM To: Multiple recipients of list ORACLE-L I am trying to create the following procedure but getting the error "compiled with errors" Can anyone tell me why? Thanks In advance CREATE OR REPLACE PROCEDURE Primus_Report as Begin Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP ( SOLUTION_ID VARCHAR2 (85) NOT NULL, TITLEVARCHAR2 (3498), OWNERVARCHAR2 (255), P_TYPE VARCHAR2 (96), AUTHOR VARCHAR2 (255), MODIFIED_BY VARCHAR2 (255), ESCALATION_GROUP VARCHAR2 (255), TECH_RESOURCEVARCHAR2 (255), P_PARTITION VARCHAR2 (96), STATUS VARCHAR2 (96), HyperLinks VARCHAR2 (96), Style_reviewer VARCHAR2 (96), DATE_CREATED DATE, DATE_MODIFIEDDATE, ALERTVARCHAR2 (96), URGENCY VARCHAR2 (96), NO_PAGEVIEWS_LAST_MONTH VARCHAR2 (255), NO_PAGEVIEWS_QUARTER VARCHAR2 (255), NO_LINKS_LAST_7_DAYS VARCHAR2 (255), NO_LINKS_LAST_120_DAYS VARCHAR2 (255) ); INSERT INTO PRIMUS_TEMP_DUMP (solution_id,Title) SELECT pc_solution_id, pc_title FROM pt_solution; End; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais 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). *1 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: ora-27101 errors
[EMAIL PROTECTED] wrote: >Hi, > >Does anyone have problems with database after installing Oracle 9iAS?? > >After I installed 9iAS and configure database cache I can't login directly >to my database and I can't configure portal because I can't access my >database. > >I'm getting some errors: > > ORA-01034: ORACLE not available >ORA-27101 : Shared memory realm does not exist >SVR4 Error: 2: No such file or directory > >Does anyone had same problems? >What can I do? > check to make sure the tnsnames.ora file on the 9iAS server is correct, points to the right instance and that you can both ping and tnsping from the 9iAS server to the database server. and make sure that you have the right tnsnames.ora file in the right place on the 9iAS server. -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Never trust a program unless you have the source. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hot backup and TEMP tablespace
Hi Traci, You need to keep the following in mind before deciding to stop backing up TEMP. There are two kinds of media recovery : Complete and incomplete. The former requires that the database be mounted but not open when recovery is being performed. If the database was just mounted, then you will not be able to drop the TEMP tablespace. Add to this the fact that Oracle applies archive logs based on the file header SCNs. If you restore an old copy of the TEMP tablespace's datafiles, the recovery will require that *all* the archive logs since the last backup of TEMP. This implies that you need to be able to get these archive logs from the backup (without missing even one), and spend time in applying them. This is something you DON'T want to do in an emergen I would look at using RMAN as Jared has suggested. Empty blocks are not backed up, and there are opportunties for incremental backups as well. We have a 13 Gb TEMP tablespace on our Production APPS 10.7 database and back that up everyday. Tape is cheap - time is not. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Fear is the darkroom where Evil develops your negatives. Wanna break free of fear? Click on 'http://www.needhim.org' ** The opinions and statements above are entirely my own and not those of my employer or clients ** > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Saturday, January 26, 2002 7:40 AM > To: Multiple recipients of list ORACLE-L > Subject: Hot backup and TEMP tablespace > > > > I was wondering if anyone could offer any suggestions to this > issue, or the > pro's and con's... > > We are trying to shorten the time frame that it takes to complete our > Oracle hot backups, and the subsequent file copies to tape. > I have read > that it is ok to skip the TEMP tablespace, and then do an > off-line drop of > the datafile(s) in the temporary tablespace, drop the > tablespace, and then > recreate it. > > Our temporary tablespaces are 900mb, and they take a chunk of > the total > time it takes to complete the hot backups. Are there any issues or > ramifications of not including that tablespace in the event > of a recovery? > It seems to me that it would be much quicker to re-create > that tablespace > if needed. > > Any suggestions are greatly appreciated. > > Traci Rebman > Oracle Database Administrator > R.R. Donnelley & Sons - Financial Division > Lancaster, PA > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Are you an idiot? -Original Message- HELP -Original Message- Sent: Monday, January 28, 2002 11:26 AM To: Multiple recipients of list ORACLE-L INDEX ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
ORA-08152: index invalid, or corrupt. Consult your DBA. -Original Message- Sent: Monday, January 28, 2002 1:26 PM To: Multiple recipients of list ORACLE-L INDEX ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Interpreting How to Stop Defragmenting and Start Living
For an index of ~30 segments of 5m each as you describe, I would use 128k extents. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/28/02 10:35 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Interpreting How to Stop Defragmenting and Start Living Following is an excerpt from the white paper How to Stop Defragmenting and Start Living: These extent sizes are chosen to be a multiple of five blocks since Oracle7 will round all extent sizes to a multiple of five blocks. In Oracle8 extents won't be rounded to a multiple of five blocks if they are a multiple of the minimum extent size for the tablespace. For Oracle8 databases, choosing the following extent sizes is a little simpler. 1) Segments smaller than 128M should be placed in 128K extent tablespaces. 2) Segments between 128M and 4G should be placed in 4M extent tablespaces. 3) Segments larger than 4G should be placed in 128M extent tablespaces For the remainder of this paper we will assume that the Oracle7 extent sizes are used since they can be used in both releases. I have some partitioned indexes that I am trying to split out into individual tablespaces, one tablespace per partition. In the excerpt below, I'm not sure what the meaning of segment is. My question is this. If the entire index is 152M and an individual index partition is 5m, then what size extent sizes should I use in my index partition tablespaces? Note that this is an 8.0.4 database. Thanks for your clarification on this issue. Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
ora-27101 errors
Hi, Does anyone have problems with database after installing Oracle9iAS?? After I installed 9iAS and configure database cache I can't login directly to my database and I can't configure portal because I can't access my database. I'm getting some errors: ORA-01034: ORACLE not available ORA-27101 : Shared memory realm does not exist SVR4 Error: 2: No such file or directory Does anyone had same problems? What can I do? Bytheway, my database is ORACLE 8.1.7 and it is running on Solaris. My Oracle9iAS is on Windows 2000. Thansk for your help Gonzalo Romero DBA - UMSS -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gonzalo Romero A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
HELP -Original Message- Sent: Monday, January 28, 2002 11:26 AM To: Multiple recipients of list ORACLE-L INDEX ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed 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: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Benchmark Myopia
A few years ago I saw a show where a guy won a bet saying he could win a race against the world's fastest high performance dragster... on foot! Of course the dude on foot got to define the race. The length of the race was only about 10-20 feet. The man on foot and the dragster edged up to the starting line and the tension mounted as the starting lights went down the tree to green. Everything was filmed in slow motion and there was visible proof that the man on foot beat the dragster to the finish line only a few feet away. A few seconds later the dragster was deploying its parachute a quarter a mile away but it lost the 20 foot race. MySQL is like the man on foot... it may win the 20 foot race but who cares because the real race must be a distance that reflects real work. To me the real race is more like the Baja 1000 and I could probably beat the dragster in my Ford Explorer. Steve -Original Message- Sent: Monday, January 28, 2002 10:11 AM To: Multiple recipients of list ORACLE-L HI Steve, A good example of why words ambiguous words like faster are dangerous. I have often asked clients the question which is faster a Ferrari Roadster or a Mack Truck. Invariably the answer would be the Ferrari, I then answer that it depends on what you are trying to do. If you are trying to drive to work, definitely the ferrari, if you trying to move the contents of your house across country you would probably want to take the Mack truck, so the answer is "It depends" again. Until you know the intended usage, faster, doesn't mean alot. My .02, John [EMAIL PROTECTED] wrote: It's faster than Oracle. Oh... You hit a hot button!!!MySQL is faster at performing 1 query in 1 database session and not muchmore. But "comparing" the performance of a database engine withoutconsidering concurrent multi-user OLTP activity is very short-sighted. Ijust finished some benchmark tests of MySQL ISAM, MySQL InnoDB, and Oracleusing Perl DBD. MySQL was fast with individual queries, inserts or updatesbut it barfed as soon as I cranked up the number of sessions. Oracle flewthrough 30 concurrent sessions with each session performing many differentqueries. I was eager to further crank up the number of sessions (via a loopin Perl) but MySQL crapped out so there was no point going any further.MySQL ISAM does table level locking and one session would put all the othersin a wait state. MySQL InnoDB does row level locking but the InnoDBdeveloper (Heikki Tuuri) conceded that it InnoDB also barfs with multi-userselect, ins erts, updates and deletes so he's still working on it. The opensource MySQL community still has a lot of work to do to catch up to Oracle'sperformance when it comes to any real world multi-user database activity.MySQL faster than Oracle? This is a pearlescent example of benchmark myopia.IMHO,Steve OrrBozeman, Montana-Original Message-Sent: Monday, January 28, 2002 6:35 AMTo: Multiple recipients of list ORACLE-LOn Monday 28 January 2002 03:45, Marin Dimitrov wrote: maybe u could consider some free databases?of course the performance, functionality and the ease of use won't becomparable to MS SQL but many sites use such databases quite successfully Actually, the most popular of the free databases is mySql, which is likely faster than MS Sql. It's faster than Oracle. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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).
procedure error
I am trying to create the following procedure but getting the error "compiled with errors" Can anyone tell me why? Thanks In advance CREATE OR REPLACE PROCEDURE Primus_Report as Begin Drop Table PRIMUS_TEMP_DUMP; CREATE TABLE PRIMUS_TEMP_DUMP ( SOLUTION_ID VARCHAR2 (85) NOT NULL, TITLEVARCHAR2 (3498), OWNERVARCHAR2 (255), P_TYPE VARCHAR2 (96), AUTHOR VARCHAR2 (255), MODIFIED_BY VARCHAR2 (255), ESCALATION_GROUP VARCHAR2 (255), TECH_RESOURCEVARCHAR2 (255), P_PARTITION VARCHAR2 (96), STATUS VARCHAR2 (96), HyperLinks VARCHAR2 (96), Style_reviewer VARCHAR2 (96), DATE_CREATED DATE, DATE_MODIFIEDDATE, ALERTVARCHAR2 (96), URGENCY VARCHAR2 (96), NO_PAGEVIEWS_LAST_MONTH VARCHAR2 (255), NO_PAGEVIEWS_QUARTER VARCHAR2 (255), NO_LINKS_LAST_7_DAYS VARCHAR2 (255), NO_LINKS_LAST_120_DAYS VARCHAR2 (255) ); INSERT INTO PRIMUS_TEMP_DUMP (solution_id,Title) SELECT pc_solution_id, pc_title FROM pt_solution; End; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to track the login attempt to an Oracle Database by
Ashok, Below is a database trigger that I use to capture all successfull logins to a database table. Works great - and I spin reports off daily to see who is connecting with what. Tom Mercadante Oracle Certified Professional CREATE OR REPLACE TRIGGER WTWDBA.catch_login_trg AFTER logon ON DATABASE DECLARE client_info_str V$SESSION.CLIENT_INFO%TYPE; loc_program V$SESSION.PROGRAM%TYPE; loc_usernameV$SESSION.USERNAME%TYPE; loc_osuser v$session.OSUSER%TYPE; loc_terminalv$session.TERMINAL%TYPE; loc_machine v$session.MACHINE%TYPE; kill_Login EXCEPTION; PRAGMA EXCEPTION_INIT( kill_Login, -20999 ); BEGIN -- set a unique string dbms_random.seed(dbms_utility.GET_TIME); client_info_str := 'WTWLOGIN_' || LTRIM(dbms_random.value,'.'); DBMS_APPLICATION_INFO.SET_CLIENT_INFO(client_info_str); SELECT program, username, osuser, terminal, machine INTO loc_program, loc_username, loc_osuser,loc_terminal,loc_machine FROM V$SESSION WHERE client_info=client_info_str; IF loc_username = 'SYS' AND loc_program = 'RESRCMON.EXE' THEN NULL; ELSE INSERT INTO CATCH_LOGIN(username,program,login_date, osuser, terminal, machine) VALUES(loc_username,loc_program,SYSDATE, loc_osuser,loc_terminal,loc_machine); COMMIT; IF loc_username='TESTLOGIN' THEN RAISE kill_Login; END IF; END IF; EXCEPTION WHEN kill_Login THEN RAISE_APPLICATION_ERROR(-20999,'Login''s using this account and this tool are Invalid'); WHEN OTHERS THEN loc_program := SUBSTR(SQLERRM,1,100); INSERT INTO CATCH_LOGIN(username,program,login_date, osuser, terminal, machine) VALUES('*Error*',loc_program,SYSDATE, USER,NULL,SUBSTR(client_info_str,-3,3)); END; / -Original Message- Sent: Monday, January 28, 2002 1:06 PM To: Multiple recipients of list ORACLE-L Greetings, I would like to know if there is a way to track the successful and un-successful login to an oracle database by any users. I enabled tracing and I can see some information about the login to database. But could not differentiate between successful login and the un-successful attempt to login. Any ideas. Thanks, Ashok -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashoke Mandal 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: Mercadante, Thomas F 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).
Interpreting How to Stop Defragmenting and Start Living
Following is an excerpt from the white paper How to Stop Defragmenting and Start Living: These extent sizes are chosen to be a multiple of five blocks since Oracle7 will round all extent sizes to a multiple of five blocks. In Oracle8 extents won't be rounded to a multiple of five blocks if they are a multiple of the minimum extent size for the tablespace. For Oracle8 databases, choosing the following extent sizes is a little simpler. 1) Segments smaller than 128M should be placed in 128K extent tablespaces. 2) Segments between 128M and 4G should be placed in 4M extent tablespaces. 3) Segments larger than 4G should be placed in 128M extent tablespaces For the remainder of this paper we will assume that the Oracle7 extent sizes are used since they can be used in both releases. I have some partitioned indexes that I am trying to split out into individual tablespaces, one tablespace per partition. In the excerpt below, I'm not sure what the meaning of segment is. My question is this. If the entire index is 152M and an individual index partition is 5m, then what size extent sizes should I use in my index partition tablespaces? Note that this is an 8.0.4 database. Thanks for your clarification on this issue. Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Benchmark Myopia
Oh yeah! That's a sensitive button because damagement around here have seriously made such statements. This despite the fact that we have rescued customers by migrating them from MySQL to Oracle in order to fix database "problems." Just the other day with a VP, Walt and I had to dispel myths and untruths about Oracle performance and database administration. (We made a good tag team and the VP was thoroughly defeated and had to slink away :-) Our "benchmark" test were by no means thorough. We ran the same Perl scripts against the 3 different databases with the same data. The only thing different was the DBD connection. Even though our tests were simple, it didn't take long to show that MySQL just can't hack multi-user access. If MySQL ever does lick the row locking and concurrent access problems then it's another story. Steve -Original Message- Sent: Monday, January 28, 2002 10:26 AM To: Multiple recipients of list ORACLE-L LOL! Guess I pushed the right button! Thanks for the benchmark info. Jared "Orr, Steve" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/28/02 08:05 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: > It's faster than Oracle. Oh... You hit a hot button!!! MySQL is faster at performing 1 query in 1 database session and not much more. But "comparing" the performance of a database engine without considering concurrent multi-user OLTP activity is very short-sighted. I just finished some benchmark tests of MySQL ISAM, MySQL InnoDB, and Oracle using Perl DBD. MySQL was fast with individual queries, inserts or updates but it barfed as soon as I cranked up the number of sessions. Oracle flew through 30 concurrent sessions with each session performing many different queries. I was eager to further crank up the number of sessions (via a loop in Perl) but MySQL crapped out so there was no point going any further. MySQL ISAM does table level locking and one session would put all the others in a wait state. MySQL InnoDB does row level locking but the InnoDB developer (Heikki Tuuri) conceded that it InnoDB also barfs with multi-user select, inserts, updates and deletes so he's still working on it. The open source MySQL community still has a lot of work to do to catch up to Oracle's performance when it comes to any real world multi-user database activity. MySQL faster than Oracle? This is a pearlescent example of benchmark myopia. IMHO, Steve Orr Bozeman, Montana -Original Message- Sent: Monday, January 28, 2002 6:35 AM To: Multiple recipients of list ORACLE-L On Monday 28 January 2002 03:45, Marin Dimitrov wrote: > maybe u could consider some free databases? > > of course the performance, functionality and the ease of use won't be > comparable to MS SQL but many sites use such databases quite successfully Actually, the most popular of the free databases is mySql, which is likely faster than MS Sql. It's faster than Oracle. Jared -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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).
[no subject]
INDEX ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kempf, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Access support
www.elementkjournals.com/tips -Original Message- Sent: Monday, January 28, 2002 10:36 AM To: Multiple recipients of list ORACLE-L Hallo, anyone who knows about a website with good Access tips? Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: slightly OT: Debugging package
do a select from user_source (or dba_source) for that package and that line number --- [EMAIL PROTECTED] wrote: > Hi All > > Oracle 8.1.6/NT. > > I am using DB Studio. The package spec compiles. I have 3 errors in > package > body. When I do show errors it states line#/column# of error > however these do not match line# in editor. How can I tell exactly > what > line of code the show error is stating? > > Thanks > Rick > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Public Privileges on system tables?
[EMAIL PROTECTED] wrote: >I have two tables, sys.pstubtbl and sys.user_privs that have grants to >public for insert, update, and delete. Our auditors are wondering why. >I don't really want to remove the privs without knowing why. This is an old >7.3.4 instance. Any ideas? > >Ron Smith > i'm guessing that for at least the sys.user_privs it's so that when a user grants and privs on any of their objects they can insert a row, or if the change it update the row, or delete the row if they revoke it. i think that's where the system checks if access is allowed to anyone but the owner. i'm sure someone will correct me shortly.;-) -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Never trust a program unless you have the source. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: slightly OT: Debugging package
Try following ... SELECTDECODE(TO_CHAR(us.line), '1', ue.text||' Pkg:'||us.name||chr(10)||chr(10)|| ' '||TO_CHAR(us.line,'0')||' '||us.text, TO_CHAR(ue.line-7),ue.text||' Pkg:'||us.name||' ', TO_CHAR(ue.line-6),'', TO_CHAR(ue.line+6),'', TO_CHAR(ue.line) ,'-->'||TO_CHAR(us.line,'0') ||' '||us.text ,' '||TO_CHAR(us.line,'0') ||' '||us.text) outline FROM USER_SOURCE us, USER_ERRORS ue WHERE us.line BETWEEN (ue.line-7) AND (ue.line+6) AND us.name = ue.name AND us.TYPE = ue.TYPE AND ue.text NOT LIKE 'PL/SQL: Statement ignored' AND ue.text NOT LIKE 'PL/SQL: Declaration ignored' ORDER BY ue.name, ue.line, ue.text, us.line / I think this is somewhere written in TOAD installation too. 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! *1 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: PL/SQL
Geez... lay off already. If you don't think the question is worthy of your time, then don't answer it. What a grouch. -Original Message- Sent: Monday, January 28, 2002 11:16 AM To: Multiple recipients of list ORACLE-L RRR TTTFF !! -Original Message- Sent: 28 January 2002 15:46 To: Multiple recipients of list ORACLE-L How can I in a pl/sql block write null if I want null to be inserted in a field when I use dynamic sql.? . I mean nothing is going to be inserted. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin 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: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to track the login attempt to an Oracle Database by
Greetings, I would like to know if there is a way to track the successful and un-successful login to an oracle database by any users. I enabled tracing and I can see some information about the login to database. But could not differentiate between successful login and the un-successful attempt to login. Any ideas. Thanks, Ashok -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashoke Mandal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrade from 8.1.6 to 8.1.7
You should upgrde to 8.1.7.2 if not 8.1.7.3 and recompile all client programs. Don't stop at 8.1.7.1. -Original Message- Sent: Monday, January 28, 2002 8:50 AM To: Multiple recipients of list ORACLE-L technet.oracle.com go look for the documentation and read --- Hamid Alavi <[EMAIL PROTECTED]> wrote: > Hi List, > I have asked this question twice but no answer at all, I don't know > may be > is too easy or not related at all, I just want to know what I have to > do for > upgrading from Oracle 8.1.6 to 8.1.7 on Unix machine, Please if > anybody have > any URL or link or any sort or documentation let me know. > Thanks & hope this time I get an answer. > > > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > The information contained in this message and any attachments is > intended > only for the use of the individual or entity to which it is > addressed, and > may contain information that is PRIVILEGED, CONFIDENTIAL and exempt > from > disclosure under applicable law. If you have received this message in > error, > you are prohibited from copying, distributing, or using the > information. > Please contact the sender immediately by return e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hot backup and TEMP tablespace
Kimberly, That is an excellent point! But the original writer was taking a hot backup of the TEMP tablespace, so she must be using an older version of Oracle. Maybe she should migrate to 8i? :) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, January 28, 2002 10:16 AM To: Multiple recipients of list ORACLE-L If you are using a temp tablespace with a temp file you really are not suppose to back it up. This comes from Oracle, not folks trying to save time. You cannot put them into backup mode so how do you recommend backing them up? -Original Message- Thomas F Sent: Monday, January 28, 2002 5:31 AM To: Multiple recipients of list ORACLE-L Traci, Yes, you can skip backing up the TEMP tablespaces, and as Kirti suggested, and have instructions in your recovery manual on how to rebuild the tablespace when you are going thru a recovery. In my humble opinion, I would not do this. It's kinda like using duct tape to cover a crack in the window - it works, but its really not right. Do you really want to be in the position of performing "extra" recovery steps just to save yourself some time during backups? Why stop at backing up the TEMP tablespace - why not the ROLLBACK tablespace - this could be dropped and re-created also. Why not INDEX tablespaces - heck, if you have the scripts, these could be re-created too! My point (as a professional DBA) is that, backups should be intact so that you can recover easily without having to do "extra work". It is really one less thing to remember and have to worry about. If your real issue is that you cannot perform your backup in the time allotted, or that you need more disk space to perform your backup, you should either investigate Rman (as Jared suggested), or buy more disk - both should be considered the "cost of doing business". I am a strong proponent of Rman - it solves MANY backup and recovery problems. Hope this helps! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Saturday, January 26, 2002 10:40 AM To: Multiple recipients of list ORACLE-L I was wondering if anyone could offer any suggestions to this issue, or the pro's and con's... We are trying to shorten the time frame that it takes to complete our Oracle hot backups, and the subsequent file copies to tape. I have read that it is ok to skip the TEMP tablespace, and then do an off-line drop of the datafile(s) in the temporary tablespace, drop the tablespace, and then recreate it. Our temporary tablespaces are 900mb, and they take a chunk of the total time it takes to complete the hot backups. Are there any issues or ramifications of not including that tablespace in the event of a recovery? It seems to me that it would be much quicker to re-create that tablespace if needed. Any suggestions are greatly appreciated. Traci Rebman Oracle Database Administrator R.R. Donnelley & Sons - Financial Division Lancaster, PA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F 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: Kimberly Smith 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: Mercad
Re: Benchmark Myopia
HI Steve, A good example of why words ambiguous words like faster are dangerous. I have often asked clients the question which is faster a Ferrari Roadster or a Mack Truck. Invariably the answer would be the Ferrari, I then answer that it depends on what you are trying to do. If you are trying to drive to work, definitely the ferrari, if you trying to move the contents of your house across country you would probably want to take the Mack truck, so the answer is "It depends" again. Until you know the intended usage, faster, doesn't mean alot. My .02, John [EMAIL PROTECTED] wrote: It's faster than Oracle. Oh... You hit a hot button!!!MySQL is faster at performing 1 query in 1 database session and not muchmore. But "comparing" the performance of a database engine withoutconsidering concurrent multi-user OLTP activity is very short-sighted. Ijust finished some benchmark tests of MySQL ISAM, MySQL InnoDB, and Oracleusing Perl DBD. MySQL was fast with individual queries, inserts or updatesbut it barfed as soon as I cranked up the number of sessions. Oracle flewthrough 30 concurrent sessions with each session performing many differentqueries. I was eager to further crank up the number of sessions (via a loopin Perl) but MySQL crapped out so there was no point going any further.MySQL ISAM does table level locking and one session would put all the othersin a wait state. MySQL InnoDB does row level locking but the InnoDBdeveloper (Heikki Tuuri) conceded that it InnoDB also barfs with multi-userselect, ins erts, updates and deletes so he's still working on it. The opensource MySQL community still has a lot of work to do to catch up to Oracle'sperformance when it comes to any real world multi-user database activity.MySQL faster than Oracle? This is a pearlescent example of benchmark myopia.IMHO,Steve OrrBozeman, Montana-Original Message-Sent: Monday, January 28, 2002 6:35 AMTo: Multiple recipients of list ORACLE-LOn Monday 28 January 2002 03:45, Marin Dimitrov wrote: maybe u could consider some free databases?of course the performance, functionality and the ease of use won't becomparable to MS SQL but many sites use such databases quite successfully Actually, the most popular of the free databases is mySql, which is likely faster than MS Sql. It's faster than Oracle. Jared
RE: Slight OT : Size of MS SQLServer Databases
Mark, Thank you very much for you help. Regards, Antonio Belloni "Mark Leith" <[EMAIL PROTECTED]> Sent by: cc: root@fatcity.Subject: RE: Slight OT : Size of MS SQLServer com Databases 28/01/02 13:40 Please respond to ORACLE-L Hi Antonio If the database is only 20-30 gig, then I don't think that you'll have any problems with SQLServer managing this - it's not "large" in real terms. If you already know Oracle then (IMHO) the learning curve for SQLServer will be fairly easy going (I've trained on both in this order too, and found it *very* easy to pick up). This is not to say that there won't be an outlay for training though.. You can connect an apache server to a SQLServer database (AH HA! This is freeware though ;P Even though it's bundled with Oracle..). You can't program with VBScript if you don't use IIS, but you aren't using this on your Oracle side of things, and it probably adds more to the learning curve.. Database connectivity to a SQLServer database through Apache is handled with the Perl DBI module, and the relevant DBD:: module. Note that DBD::Sybase is probably the way to go to get to SQLServer. They both share a common code base, and the Sybase driver is reputed to work better than the SQLServer one. Check out: http://www.apache-asp.org/faq.html#How%20is%20databc9095df5 You can also use Tomcat as well AFAIK, and it most probably sets up in the same way as Apache. I'd still push to go with MySQL though personally, it performs better, it's free, and you can run it on a LINUX server with Apache and the Perl DBD::MySQL module just as easily.. Just my £0.02 - but hey, what do I know! ;P HTH Mark -Original Message- [EMAIL PROTECTED] Sent: 28 January 2002 15:30 To: Multiple recipients of list ORACLE-L Hi Mark, It will be a tipically B2C site. We estimate the size on 20-30 Gb and number of concurrent users depends of the sucess of the site. >From all the companies that we have contact and are using SQLServer , the biggest production database was 8 Gb. Being an Oracle shop and considering the costs of training/implementation/installation we think that it is our best option in the commercial databases arena. Management is only considering the price to buy a new software/a new Oracle license. That´s why we are so worried about adopting SQLServer to this project and we want stress all the possibilities and see if it´s able to scale if the database/application grows fast. Another concerning is about the application server. SQLServer will run only in winNT/2000/XPpro. Will we be able to run a different application server than IIS and connect to the database ? Thanks for your help, Antonio Belloni PS.: We are big fans of free software and known the potential of the architecture, but it´s totally out of question in this shop. Kind of "Free software here ?! No way It´s serve only nerds and hackers purposes...". Management..tsk,tsk,tsk. "Mark Leith" <[EMAIL PROTECTED]> Sent by: cc: root@fatcity.Subject: RE: Slight OT : Size of MS SQLServer com Databases 28/01/02 10:00 Please respond to ORACLE-L "if u consider SAP DB then u may take a look at http://www.sap.com/solutions/technology/benchmark/HTML/SD_2_tier_4x.htm which contains some outdated benchmarks for SAP R/3 running on different databases and u'll see that SAP DB outperforms MS SQL in some configurations" I think that Antonio was actually trying to *SAVE* money - not spend *more* ;) Another opt
RE: Hot backup and TEMP tablespace
On Mon, 28 Jan 2002, Mercadante, Thomas F wrote: > Do you really want to be in the position of performing "extra" > recovery steps just to save yourself some time during backups? Why > stop at backing up the TEMP tablespace - why not the ROLLBACK > tablespace - this could be dropped and re-created also... You can't skip the tablespaces containing active rollback segments. You need them to roll back transactions that were uncommitted as of the time up to which you want to recover your database. > My point (as a professional DBA) is that, backups should be intact so that > you can recover easily without having to do "extra work". It is really one > less thing to remember and have to worry about. If well documented and/or automated, I say that it is a legitimate way to save resources, especially if there is a very large temporary tablespace, especially if the majority of users are not big sorters. You could create a small (1Gb) temp tablespace right after opening the recovered dtabase, then assign all users to it. Meanwhile, you can create a large temporary tablespace and assign any large sorters to that when it gets done. I think skipping TEMPORARY tablespaces is a good idea if you iron out the recovery steps. It really isn't complicated or much extra work. You also mentioned skipping indexes in your backups, as though it were an unreasonable thing to do. I think that's a good idea too, if someone deems it appropriate and managable. I guess you'd have to dump the DDL for all indexes with every backup, and you'd have to veryify it is actually faster to rebuild them than to restore. RMAN solves problems like disk space and backing up free space, and is a great utility. But is the cost of implementation worth it, if the original poster is going to successfully buy a couple years with the existing system, just by skipping TEMP? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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).
Public Privileges on system tables?
I have two tables, sys.pstubtbl and sys.user_privs that have grants to public for insert, update, and delete. Our auditors are wondering why. I don't really want to remove the privs without knowing why. This is an old 7.3.4 instance. Any ideas? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Access support
Giving up on Oracle? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Access support om 01/28/2002 09:35 AM Please respond to ORACLE-L Hallo, anyone who knows about a website with good Access tips? Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Oracle Stand by database
Hi all: If anybody has a concise document on setting up stand by databases, please send me a copy or send me the links on the web where I can find one. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Access support
http://www.mvps.org/access/ http://rogersaccesslibrary.com/index.htm Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > > Hallo, > > anyone who knows about a website with good Access tips? > > Thanks in advance > > > Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whittle Jerome Contr NCI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrade from 8.1.6 to 8.1.7
Okay.. Click here : http://tahiti.oracle.com/pls/tahiti/tahiti.homepage Then Click on 'books' and then on 'mig' (for Migration Guide) then read Chapter 7, at least.. Bookmark this link for future reference... - Kirti -Original Message- Sent: Monday, January 28, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Hi List, I have asked this question twice but no answer at all, I don't know may be is too easy or not related at all, I just want to know what I have to do for upgrading from Oracle 8.1.6 to 8.1.7 on Unix machine, Please if anybody have any URL or link or any sort or documentation let me know. Thanks & hope this time I get an answer. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Deshpande, Kirti 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).
slightly OT: Debugging package
Hi All Oracle 8.1.6/NT. I am using DB Studio. The package spec compiles. I have 3 errors in package body. When I do show errors it states line#/column# of error however these do not match line# in editor. How can I tell exactly what line of code the show error is stating? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Access support
- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, January 28, 2002 17:35 > Hallo, > > anyone who knows about a website with good Access tips? > try http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax285199,0 0.html or just go to searchDatabase.com --> Best Web Links --> Other Vendor Specific Resources --> Microsoft Access hth, Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. " -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrade from 8.1.6 to 8.1.7
Hello, I suggest that you go to 8.1.7.2.1, which we just did, from 8.1.6.3.0, and we used the any/all documents that we found on Meta-link. We upgraded on a test server first. Paul -Original Message- Sent: Monday, January 28, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Hi List, I have asked this question twice but no answer at all, I don't know may be is too easy or not related at all, I just want to know what I have to do for upgrading from Oracle 8.1.6 to 8.1.7 on Unix machine, Please if anybody have any URL or link or any sort or documentation let me know. Thanks & hope this time I get an answer. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Benchmark Myopia
LOL! Guess I pushed the right button! Thanks for the benchmark info. Jared "Orr, Steve" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/28/02 08:05 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Benchmark Myopia > It's faster than Oracle. Oh... You hit a hot button!!! MySQL is faster at performing 1 query in 1 database session and not much more. But "comparing" the performance of a database engine without considering concurrent multi-user OLTP activity is very short-sighted. I just finished some benchmark tests of MySQL ISAM, MySQL InnoDB, and Oracle using Perl DBD. MySQL was fast with individual queries, inserts or updates but it barfed as soon as I cranked up the number of sessions. Oracle flew through 30 concurrent sessions with each session performing many different queries. I was eager to further crank up the number of sessions (via a loop in Perl) but MySQL crapped out so there was no point going any further. MySQL ISAM does table level locking and one session would put all the others in a wait state. MySQL InnoDB does row level locking but the InnoDB developer (Heikki Tuuri) conceded that it InnoDB also barfs with multi-user select, inserts, updates and deletes so he's still working on it. The open source MySQL community still has a lot of work to do to catch up to Oracle's performance when it comes to any real world multi-user database activity. MySQL faster than Oracle? This is a pearlescent example of benchmark myopia. IMHO, Steve Orr Bozeman, Montana -Original Message- Sent: Monday, January 28, 2002 6:35 AM To: Multiple recipients of list ORACLE-L On Monday 28 January 2002 03:45, Marin Dimitrov wrote: > maybe u could consider some free databases? > > of course the performance, functionality and the ease of use won't be > comparable to MS SQL but many sites use such databases quite successfully Actually, the most popular of the free databases is mySql, which is likely faster than MS Sql. It's faster than Oracle. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: 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).