RE: OT: RE: Fire your DBA's you don't need them anymore...
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: Gene Sais 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: Hillman, Alex 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: Tim Sawmiller 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).
OT RE: Mean/Median
better than being a pile of pig fundament... [EMAIL PROTECTED] 05/15/01 03:22PM ROFL! I am an idiot || -Original Message- || From: [EMAIL PROTECTED] || [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 15, 2001 2:11 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Mean/Median || || || Are you stupid? || || evil grin || || Scott Shafer || San Antonio, TX || 210-581-6217 || || -Original Message- || From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] || Sent: Tuesday, May 15, 2001 12:27 PM || To:Multiple recipients of list ORACLE-L || Subject: RE: Mean/Median || || geez louise, || || Median := avg(Max,Min) || || || -Original Message- || || From: Pat Hildebrand [mailto:[EMAIL PROTECTED]] || || Sent: Monday, May 14, 2001 10:56 PM || || To: Multiple recipients of list ORACLE-L || || Subject: Re: Mean/Median || || || || || || || || || || Any scripts (sql or pl/sql) out there to compute various || || statistical things || || in Oracle? || || || || || || Would depend on just what you are looking for. A quick look at || || Oracle's SQL functions showed avg, st. deviation, and variance || || although no median but that should be easier to write than || || some of the || || others. || || || ||Pat || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: || 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: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Mean/Median - Another method
median; adjective: (statistics) relating to or constituting the middle value of an ordered set of values (or the average of the middle two in an even-numbered set) This is the definition of median. It's not a calculated value, it's more of a derived value. [EMAIL PROTECTED] 05/15/01 07:38PM Another way to compute median is here: 1. You should know that there is a linear relationship between Mean, Median and Mode. Find that relationship. 2. Find the mean of the data. Its nothing but the average. 3. Next you have find the mode. Mode is nothing but the most frequent data. suppose, sal is the column for which you want to find the median, then proceed like this - select sal, count(*) Number_of_people from emp group by sal order by 2 Desc; Now the first record returned by the above query represents the mode. Caputure the sal from this first record and call it as mode. 4. Now, Using the relationship u determined in step 1, calculate the median values by substituting the mode and mean values. PS: I know this is going to work is salary is an interger field. But I doubt it if its a real number. Listers,letme know if I am wrong. Also, I did not watch earlier mails on this topic,. so, pardon me if its a repeat. Rajaram. -Original Message- From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 3:36 PM To: Multiple recipients of list ORACLE-L Subject:RE: Mean/Median HELP Are you stupid? -- 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). NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram 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: Tim Sawmiller 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: unable to create spatial index via dynamic_sql
Is the user executing the procedure the same user who owns the table for which the index is intended? [EMAIL PROTECTED] 05/15/01 01:45AM hi list, I am able to create index from Sqlplus as... create index i_sptl_test on ADDRESSED_PROPERTY_(polygon_geometry) indextype is mdsys.spatial_index; Thisstatement works fine and I ma able to create index. But the same statement when executing through package - procedure p_crt_sptl_index ( it fails listed error messages. Of course by using Dynamic Sql. DDL Statement: create index i_sptl_test on ADDRESSED_PROPERTY_(polygon_geometry) DDL Statement: indextype is mdsys.spatial_index DDL Statement: ** Fatal Exception p_crt_sptl_index** ORA-29855: error occurred in the execution of ODCIINDEXCREATEroutine ORA-13231: failed to create index table [Create index table failed forI_SPTL_TEST_rt$] during R-tree creation ORA-29400: data cartridge error ORA-01031: insufficient privileges ORA-010 ** Fatal Exception incrt_metadata_entries ** *** p_crt_sptl_indexes: creation of SpatialIndex on ADDRESSED_PROPERTY_.polygon_geometry via p_crt_sptl_index failed *** Anybody got ideas why this is Oracle Saptial database 8.1.7 on sunsparc solaris 7. narender.akula http://www.terralinkltd.com Oracle DBA, Terralink Limited Wellington, NZ. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Narender Akula 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: Tim Sawmiller 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: Export question.
Ok, I'll pretend I'm from Missouri (the Show Me State). What's the database block size? What's the average row size? How many rows? What are the pctused and pctfree values? Are you using any weird data types (like LONG, RAW, that kind of stuff). Are you sure you are only exporting the one table? Show us everything please, as I sip my morning coffee... [EMAIL PROTECTED] 05/15/01 05:31AM Well back down to earth with a bang again, back to work and the weather is miserable. I didn't see any replies to this last mail so I will repost. Any help or insight would be greatly appreciated. Regards Lee -Original Message- Sent: 11 May 2001 15:51 To: Multiple recipients of list ORACLE-L OK, To answer a couple of questions, I did use compute statistics to get the stats. I did not use compress=y. The table should have been 420Mb according to the avg_row_len*num_rows calculation. The export file came out at 5.7Gb. When I imported it fell over at 1Gb. I set my initial extent to what I calculated it at earlier and next extent to 4Mb and tablespace (1Gb) filled up. I'm still confused as to how this happened. Never mind its the weekend, out to a top class restaurant tonight, its the English FA Cup Final on Saturday (lots of beer) and the weather is glorious.. Oracle ? Oracle Who Regards Lee -Original Message- Sent: 10 May 2001 17:01 To: Multiple recipients of list ORACLE-L When you export it do not! use compress=Y. When you import the table be sure to prebuild the table with the initial and next extent sizes to be appropriate for this table. This will reorg it unstead of putting it back the way it was. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 11:31 AM All, I have recently ran an analysis on a table and when calculating the table size using num_rows*avg_row_len this came out at about 420Mb. Nothing strange about that, however the amount of space this table is taking up is about 4.6Gb ! Instant case for a reorg I thought, however, I am currently exporting this table and suddenly noticed that the dump file is now in excess of 1.5Gb and still going strong. Does export merely backup the data or does it also backup other stuff (unused blocks, preallocated etc.) Regards Lee Robertson The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini 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: Robertson Lee - lerobe 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: Robertson Lee - lerobe 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: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City
RE: Export question.
No kidding...it's got to be at least 38. 38 * 57351031 = 2.03 gigabytes, and I'm sure it's bigger than that... [EMAIL PROTECTED] 05/15/01 10:25AM OK here goes and thanks for the response Definitely one table and from the top :-) DB Block size = 8192 Avg. Row Size = 6 Num Rows = 57351031 Pct free = 0 Pct Used = 40 Table definition (column names removed) = Type NOT NULL NUMBER(9) NOT NULL NUMBER(9) NOT NULL NUMBER(9) NOT NULL NUMBER(9) NUMBER(9) CHAR(2) CHAR(3) CHAR(4) VARCHAR2(100) VARCHAR2(60) VARCHAR2(50) VARCHAR2(60) VARCHAR2(7) NUMBER(6) NUMBER(6) NUMBER(9) DATE VARCHAR2(50) A - ha I think the penny drops - how on earth could this be right - average row length of 6 with a table definition like this. Is this the problem. The average row length must be wrong, yet the table was definitely analyzed with compute statistics. Lee Robertson The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Tim Sawmiller 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: DB Link Between Prod and Test?
Can he be trusted NOT to run some horrible query that would bring Prod to its knees? [EMAIL PROTECTED] 05/15/01 03:00PM If all he needs is select he cannot corrupt the DB if the DBA does not grant unnecessary privileges. Folks use dblinks all the time. Rick -Original Message- Sent: Tuesday, May 15, 2001 2:26 PM To: Multiple recipients of list ORACLE-L One of our development DBAs suggested today to build a private database link between production and test database so that he can run some queries against both at the same time. I am a little concerned because he might make a mistake and accidentally corrupt the prod database. Anybody out there who is doing the same thing? Are there any other potential ramifications? TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: Cale, Rick T (Richard) 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: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Mean/Median
Well, no, it doesn't work at all. The definition of Median is a value where half your list of values is above, and half is below. If the values all tend toward the mininum or the maximum, this equation would be way out of line. [EMAIL PROTECTED] 05/15/01 01:35PM Oops, this only works for *even* numbers of samplesgeez || -Original Message- || From: Mohan, Ross || Sent: Tuesday, May 15, 2001 12:28 PM || To: '[EMAIL PROTECTED]' || Subject: RE: Mean/Median || || || geez louise, || || Median := avg(Max,Min) || || || -Original Message- || || From: Pat Hildebrand [mailto:[EMAIL PROTECTED]] || || Sent: Monday, May 14, 2001 10:56 PM || || To: Multiple recipients of list ORACLE-L || || Subject: Re: Mean/Median || || || || || || || || || || Any scripts (sql or pl/sql) out there to compute various || || statistical things || || in Oracle? || || || || || || Would depend on just what you are looking for. A quick look at || || Oracle's SQL functions showed avg, st. deviation, and variance || || although no median but that should be easier to write than || || some of the || || others. || || || ||Pat || || -- || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || -- || || Author: Pat Hildebrand || || INET: [EMAIL PROTECTED] || || || || Fat City Network Services-- (858) 538-5051 FAX: || (858) 538-5051 || || San Diego, California-- Public Internet access / || || Mailing Lists || || || || || To REMOVE yourself from this mailing list, send an E-Mail message || || to: [EMAIL PROTECTED] (note EXACT spelling of || 'ListGuru') and in || || the message BODY, include a line containing: UNSUB ORACLE-L || || (or the name of mailing list you want to be removed || from). You may || || also send the HELP command for other information (like || subscribing). || || || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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 error -20001
Unless things have changed, 2 thru 20999 are user specified error numbers, not generated by Oracle. [EMAIL PROTECTED] 05/11/01 01:20PM Has anyone any idea what this means? It is coming up when trying to use a procedure in a PL/SQL package to display a web page. With some negative errors we are able to remove them by reloading all for the application in the OAS manager but not this one. Searching MetaLink I come up with suggestions to patch Applications 11i or upgrade Developer 6 - neither of which are in use here. I also came up with cause not determined. Environment: Sun OS 5.7 Oracle8i Enterprise Edition release 8.1.6.0.0 OAS 4.0 - we are using a secure server Both the package and package body are valid. Any help in unraveling this would be greaterly appreciated. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: sys.IDL_UB1$
I believe that table holds the PL/SQL source code. [EMAIL PROTECTED] 05/14/01 03:30PM Does anyone know what the SYS.IDL_UB1$ table is? It suddenly grew to app. 100Meg in my Development database. I tried searching on it on Ixora on Friday but as soon as I did my computer crashed. Now that I'm back up I decided it might be safer to post here :). Thanks in advance, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Tim Sawmiller 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: Question of the day
Surely you meant idyllic symbol? :-) BTW, the buildings are really giant disk drives... [EMAIL PROTECTED] 05/09/01 05:06PM SATIRE, SARCASMS ON (just got our 2002 price quote) Does any person know of a statue / figure/ object that stands outside the Oracle Corporate Headquarters that stands as their idolic symbol? All I have found is the registered trademark ORACLE. I guess the cylindrical tower buildings are a gothic resemblance in themselves. SATIRE, SARCASMS OFF ROR mô¿ôm -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: tkprof and security?
list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: consistency in cost?
Interesting...CHOOSE means Oracle will decide whether to use RULE or COST. But a CHOOSE hint will force use of COST. Kind of diminishes the meaning of CHOOSE, doesn't it? Seems like a pointless hint... [EMAIL PROTECTED] 05/08/01 11:45PM If the system is Rule based and you code Hints, the CBO will be automatically invoked Sam - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 10:12 PM Forgive my ignorance but I thought hints were only for cost based optimizer. Have you checked in case anybody has changed any parameters while the system is running as I know that changing the hash_area_size can change the execution plan?. Are you using parallelism as if a table had to be recreated for any reason and its degree changed it might do a FTS? Cheers Iain Nicoll -Original Message- Sent: 08 May 2001 17:31 To: Multiple recipients of list ORACLE-L Jared, The only difference is about a weeks worth of extra data. Well, the hardware is also different (Ultra450 vs. Ultra 5000. Also 1 vs 4 CPU). But regardless, shouldn't init.ora optimizer_mode=choose be identical to optimizer_mode=rule with hint=choose? If I have the time, I'll try to set up a couple of systems and examine by moving stats and taking some 10053 dumps. (one of the ones giving me a problem is in production so I have limited play time there). Henry -Original Message- Sent: Tuesday, May 08, 2001 12:56 AM To: [EMAIL PROTECTED]; Henry Poras Henry, You say 'nearly identical'. What are the differences? Are the 2 databases on the same platform? If not, what are the differences, hardware and OS? Jared On Monday 07 May 2001 21:55, Henry Poras wrote: I am working with an 8.1.6 database on Solaris 2.6 and I am wondering if there is any consistency in the optimizer. We have two nearly identical databases (one a clone from two weeks ago). A five table join has nearly the identical execution plan on the two databases. The difference is in the access method of the fourth table in the join; in one case it is accessed by a FTS and in the other, by Index. This difference has a large effect on performance. Statistics are nearly identical for this table in both databases (I looked at dba_tables, dba_indexes, dba_col_tables). Also, the init.ora is the same. When I changed the optimizer_mode to rule and added a 'choose' hint to the query, the execution plan was different again. I will look into this a bit further and post my results. Just wondering about other's experiences. Thanks. Henry -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicoll, Iain (Calanais) 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: Sam Roberts 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: Tim Sawmiller 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
RE: join across database link
This wouldn't be the one and only Bambi Bellows, would it? [EMAIL PROTECTED] 05/09/01 01:42PM Ooh! Ooh! I did that once! What fun! I had two windows up... both logged in as system. And when I described across the link, it shut down the window I was working in and displayed the error in the other one. And it was reproducible! Ah, the fun stuff Oracle puts in for the adventuresome! Although, nothing really beats Digital and their help on Wombats. Bambi. -Original Message- Date: Tue, 08 May 2001 18:20:21 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Actually there is a similar bug in 8.1.7. Basically, don't describe across db links. -Original Message- Sent: Tuesday, May 08, 2001 6:41 PM To: Multiple recipients of list ORACLE-L Let's do the ez one first. On Tuesday 08 May 2001 11:42, [EMAIL PROTECTED] wrote: When I do a describe across the link I get ORA-12663-Services required by the client not available on the server. This is a bug, don't worry about it. The only fix is to upgrade your database from 7.3 to 8.something. It only affects the 'describe' command. When I connect to the NT and run the query by hand it also hangs. But I can join the NT table to each of the AIX tables and get instant results - I just cannot join all three. Turn tracing on for the session and check out the trace file. In all likelihood the session is not actually hung, just running very slowly. You can also monitor v$sess_io to see what activity is taking place for the session. Check out the explain plan. Do you have a copy of the explain plan from when it worked? Of course you don't, neither does anyone else. If you did, you could compare them. As it is, take a look at it, as it may be rather revealing. Jared -- Please see the official ORACLE-L FAQ: A HREF=http://www.orafaq.com; TARGET=_newFONT COLOR=BLUEhttp://www.orafaq.com/FONT/A -- Author: Jared Still 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: A HREF=http://www.orafaq.com; TARGET=_newFONT COLOR=BLUEhttp://www.orafaq.com/FONT/A -- 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). -- ___ Get your free email from http://www.mail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambi Bellows 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: Tim Sawmiller 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: Cool way to crash an Oracle database, any time, any place
Not as pissed off as the time he trusted me with the root password, and I absent mindedly ran this command from the root partition: chown me * [EMAIL PROTECTED] 05/09/01 03:16PM On Wed, 9 May 2001,Mohan, Ross scribbled on the wall in glitter crayon: -make exponentially growing files and processes And make your SA REALLY pissed off.;-) -- Bill Thater Certifieable ORACLE DBA Telergy, Inc.[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. ~~ I know the answer! The answer lies within the heart of all mankind! The answer is twelve? I think I'm in the wrong building. -- Charles Schulz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: Tim Sawmiller 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-06573 ???
Do what the action says...add the pragma. Consult your fine manual (or at least it's electronic equivalent on CD) for more details. [EMAIL PROTECTED] 05/08/01 10:25AM Tim Sawmiller schrieb: oerr ora 6573 06573, 0, Function %s modifies package state, cannot be used here // *Cause: There are two possible causes for this message: // * A SQL statement references a packaged, PL/SQL function that //does not contain a pragma containing the 'Write no Package //State' (WNPS). // * A SQL statement references a stand-alone, PL/SQL function //that modifies a package state. A stand-alone, PL/SQL function //referenced by a SQL statement cannot modify a package state. // *Action: If the function is a packaged, PL/SQL function: Recreate // the function and include a pragma containing the 'Write no // Package State' (WNPS). // If the function is a stand-alone, PL/SQL function: Delete // the function from the SQL statement. [EMAIL PROTECTED] 05/08/01 07:15AM Hi, I get this error if I give a (standalone) function in a where clause: ORA-06573: Function WSNADDR modifies package state, cannot be used here What exactly does it mean and how can I workaround it ? The statement I tried to issue looks like this: select rtrim(substr(wsnaddr(env_wsnaddr),45,3)) IP, db_instance_node MACHINE from environment e, dbinstancenode dn where rtrim(substr(wsnaddr(env_wsnaddr),45,3))=rtrim(substr(db_inst_node_desc,11,3)); * - here's the problem. WSNADDR is a self-defined function that looks like this: CREATE OR REPLACE FUNCTION WSNADDR (v_WSNAddress IN VARCHAR2) RETURN VARCHAR2 IS v_Port VARCHAR2(8); v_IPAddrVARCHAR2(8); v_IPDecode VARCHAR2(16); v_IPPartVARCHAR2(3); v_DecodeWSN VARCHAR2(60); BEGIN DBMS_OUTPUT.ENABLE(64000); v_Port := SUBSTR(v_WSNAddress,3,8); v_IPAddr := SUBSTR(v_WSNAddress,11,8); v_IPDecode := ''; FOR v_Index IN 0 .. 3 LOOP v_IPPart := TO_CHAR(HEXTONUMBER(SUBSTR(v_IPAddr,2*v_Index+1,2))); IF (v_Index 3) THEN v_IPDecode := v_IPDecode || v_IPPart || '.'; ELSE v_IPDecode := v_IPDecode || v_IPPart; END IF; END LOOP; v_DecodeWSN := 'Port: ' || v_Port || ' 0xIP: ' || v_IPAddr || ' IP: ' || v_IPDecode; RETURN v_DecodeWSN; END WSNADDR; / The above used function HEXTONUMBER just converts a hex into a number (what a surprise ;). The purpose of this function is to turn Tuxedo WSN addresses into a readable format. WSN addresses look like this: 0x000285ca8b07ca49 They contain the IP and the port where the service runs. The function's output looks like this: Port: 000285ca 0xIP: 8b07ca49 IP: 139.7.202.73 Any ideas ? -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM AMS-Gebäude: E6 R08 Tel.: 0211/533-4893 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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: Tim Sawmiller 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). --- This Mail has been checked for Viruses Attention: Encrypted Mails can NOT be checked ! *** Diese Mail wurde auf Viren ueberprueft Hinweis: Verschluesselte Mails koennen NICHT geprueft werden! Hi, I already read the documentation ;). I just don't really get what the problem is and why it is caused. Any hints ? -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
Re: Taking your time when a crisis occurs
copies of the redo logs locally so you don't have to restore them from tape. Jared On Wednesday 02 May 2001 07:24, [EMAIL PROTECTED] wrote: Jonathan, It would appear that your friend has hit upon one of the problems of hot backups that everyone misses and actually Oracle recommends against. That is backing up your online redo log files and doing that LAST. The reason is that there are more than likely active transactions that were recorded therein and those logs are not available. Can he complete the recovery, maybe if he has the remaining logs from the active system, I'm assuming he is recovering to somewhere other than his production system. Otherwise his only recourse is OTS. Dick Goulet Oracle Certified 8i DBA Reply Separator Author: Jonathan Gennick [EMAIL PROTECTED] Date: 5/1/2001 8:55 PM Fellow list members, I received the following email from a reader a few minutes ago. If you skip down to where he talks about backup, you'll see that he's in trouble with a database that won't recover. I've already suggested that he open a TAR, and that he supply more specifics as to error messages and the like, but maybe someone on this list can draw some conclusions from what he's told me so far. If you're good at recovery, have a look at what he says. I'll post his email address later if he says its ok, === message truncated === = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: William Beilstein 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: Tim Sawmiller 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: Taking your time when a crisis occurs
Work smarter not harderis that anything like, Know the difference between doing things right and doing the right thing? [EMAIL PROTECTED] 05/07/01 01:51PM PHB comes from Dilbert: Pointy Haired Boss. Those managers who wander around in a clueless state of perceived self-importance offering wonderful platitudes like Work smarter not harder and such. Generally they wind up being the chickens discussed in a related response. Rodd Original Message dated 5/7/01, 11:50:27 AM Author: Koivu, Lisa [EMAIL PROTECTED] Re: RE: Taking your time when a crisis occurs: Yes, Rodd, you are right. There are times when being blunt is warranted. I do it now - I couldn't a few months ago. At my last employer I was very very good at it and my boss let us do our jobs without interference. However, the real question is, what's PHB? :P -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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: Tim Sawmiller 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: Getting ORA-01732 trying to insert into table (NOT view)
Are you sure the public synonym isn't pointing to an object in some other database thru a link? [EMAIL PROTECTED] 05/03/01 04:55PM Why do I keep getting this error even though this object is not a view??? I am in as the owner of the table, which has the DBA role to boot. SQL show user USER is FARS_OWNER SQL select owner, object_name, object_type from dba_objects where object_name like '%ALIASTYPE%'; OWNER OBJECT_NAME OBJECT_TYPE --- -- -- PUBLIC MFGALIASTYPE SYNONYM FARS_OWNER MFGALIASTYPE TABLE FARS_OWNER MFGALIASTYPE_VALUE_PK INDEX SQL select * from MFGALIASTYPE; VA I ATTRIBUTE PROMPTNAME SORTORDER -- - -- --- - T F SN Temic Accelerometer SN 30 T SN Actual Serial Number 10 A F SN Accelerometer SN 40 C F SN Customer SN 20 D F SN Daughter Board SN 60 S F SN Sensor SN 50 6 rows selected. SQL insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80); insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80) * ERROR at line 1: ORA-01732: data manipulation operation not legal on this view BTW, the synonym is for the table so other users can access it without adding the owner's name. I had already tried insert into FARS_OWNER.MFGALIASTYPE ... as well, but didn't include that here. Here's the table definition: CREATE TABLE FARS_OWNER.MFGALIASTYPE (VALUE VARCHAR2(2), ISDEFAULT VARCHAR2(1), ATTRIBUTE VARCHAR2(45), PROMPTNAME VARCHAR2(45) NOT NULL ENABLE, SORTORDER NUMBER(2, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING TABLESPACE TBL_TINY ; ALTER TABLE FARS_OWNER.MFGALIASTYPE ADD CONSTRAINT MFGALIASTYPE_VALUE_PK PRIMARY KEY (PROMPTNAME) USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE USER_DATA ENABLE NOVALIDATE ; This is using 8.1.5 EE on NT 4 SP6a. Michael Ray Oracle DBA TRW, Marshall, IL 217-826-3011 x2438 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Ray 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: Tim Sawmiller 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: Getting ORA-01732 trying to insert into table (NOT view)
..or that the public synonym is really pointing at the object you think it is? [EMAIL PROTECTED] 05/03/01 04:55PM Why do I keep getting this error even though this object is not a view??? I am in as the owner of the table, which has the DBA role to boot. SQL show user USER is FARS_OWNER SQL select owner, object_name, object_type from dba_objects where object_name like '%ALIASTYPE%'; OWNER OBJECT_NAME OBJECT_TYPE --- -- -- PUBLIC MFGALIASTYPE SYNONYM FARS_OWNER MFGALIASTYPE TABLE FARS_OWNER MFGALIASTYPE_VALUE_PK INDEX SQL select * from MFGALIASTYPE; VA I ATTRIBUTE PROMPTNAME SORTORDER -- - -- --- - T F SN Temic Accelerometer SN 30 T SN Actual Serial Number 10 A F SN Accelerometer SN 40 C F SN Customer SN 20 D F SN Daughter Board SN 60 S F SN Sensor SN 50 6 rows selected. SQL insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80); insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80) * ERROR at line 1: ORA-01732: data manipulation operation not legal on this view BTW, the synonym is for the table so other users can access it without adding the owner's name. I had already tried insert into FARS_OWNER.MFGALIASTYPE ... as well, but didn't include that here. Here's the table definition: CREATE TABLE FARS_OWNER.MFGALIASTYPE (VALUE VARCHAR2(2), ISDEFAULT VARCHAR2(1), ATTRIBUTE VARCHAR2(45), PROMPTNAME VARCHAR2(45) NOT NULL ENABLE, SORTORDER NUMBER(2, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING TABLESPACE TBL_TINY ; ALTER TABLE FARS_OWNER.MFGALIASTYPE ADD CONSTRAINT MFGALIASTYPE_VALUE_PK PRIMARY KEY (PROMPTNAME) USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE USER_DATA ENABLE NOVALIDATE ; This is using 8.1.5 EE on NT 4 SP6a. Michael Ray Oracle DBA TRW, Marshall, IL 217-826-3011 x2438 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Ray 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: Tim Sawmiller 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: Q: might be really old topic, but please take a look
In each case, it's good versus evil... [EMAIL PROTECTED] 05/03/01 01:36PM Probably this has been posed million times, but I really like to know. We'll have a meeting about this in our company, and I'd love to contribute someting. Any idea on the following issue, any link, paper, etc, will be greatly appreciated. pros and cons of 1. Oracle vs Sybase 2. Unix vs NT Leslie __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu 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: Tim Sawmiller 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
The column named PROCESS. [EMAIL PROTECTED] 05/02/01 12:00PM Hi Which column in v$session indicate os process? Thanks -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Tim Sawmiller 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).
Virus Found in Attachment (Subject: Uniquely Weird - duplicate
Lisa, your attachment had a virus in it. My local server detected it. Everyone, DO NOT OPEN THE ATTACHMENT in emails with the Subject: Uniquely Weird - duplicate rows. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: Constraint dependencies
Basically you should drop the constraints of type 'R' first, then drop the constraints of type 'P' and 'U'. See the CONSTRAINT_TYPE in the USER_CONSTRAINTS view. [EMAIL PROTECTED] 05/01/01 05:50PM Hi - When dropping and/or re-applying constraints for an entire schema, is there a dictionary table that can be queried (or some other way) to determine constraint dependencies - or do you just keep running the script until you do not get those errors? I would like to be able to identify the order that the constraints should be dropped (or added) so that I can write a script to be automated ( for example, to refresh test data from production). If anyone has any good ideas on how to do this, I'd really be interested in hearing from you. Thanks - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: OT -- marketing (was Windows vs. UNIX)
-- Author: Roy Ferguson INET: [EMAIL PROTECTED] mailto:[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] mailto:[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] mailto:[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] mailto:[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] mailto:[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] mailto:[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Tim Sawmiller 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: Actual size of database
set echo off set pagesize 60 @my_tabs spool sp_used rem Calculate Percent of Space Used in Each Table Space rem column tablespace_name format a20 column tablespace heading TSPACE_NAME column megs_alloc format 999,999.99 column megs_free format 999,999.99 column pct_used format 999.99 column megs_used format 999,999.99 column free_extents format 999,999 column free_extents heading FREE_EXT break on report compute sum of megs_alloc on report compute sum of megs_free on report compute sum of megs_used on report ttitle 'Space Used' select a.tablespace_name, (a.bytes/1048576) megs_alloc, (b.bytes/1048576) megs_free, ((a.bytes - b.bytes)/1048576) megs_used, (100 - ((b.bytes/a.bytes) * 100)) pct_used, b.free_extents from tjs_allocated_space a, tjs_free_space b where a.tablespace_name = b.tablespace_name (+) order by a.tablespace_name; spool off set pagesize 20 set feedback off drop table tjs_dba_extents; drop table tjs_free_space; drop table tjs_allocated_space ; set feedback on ttitle off [EMAIL PROTECTED] 05/01/01 02:11PM Hi All, Oracle 8.0.5 NT 4 Does anyone have a script they would share that can calculate the ACTUAL size of a database(space_used) not what has been allocated? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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: Tim Sawmiller 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-24347 (null column in aggregate function) - SQL*Plus
Looks like you have user with no objects. Try count(*) instead of count(object_name); [EMAIL PROTECTED] 04/30/01 02:25PM I'm a little stumped. I'm using SQL*Plus 8.1.6.0.0 client to connect to an Oracle 8.0.5 database on a Windows NT server. I want to get the count of objects for each user, with a 0 count for users without any objects. But when i run the query, errors message ORA-24347 is returned. Why would that be? When I run the query directly on the server, using a SQL*Plus 8.0.5 client, the query returns the expected data with no errors. Is there a bug in Metalink for this? I didn't find anything, but maybe my searching skills need some honing. Should I stick with older versions of the SQL*Plus client? Results with 8.1.6 client to 8.0.5 database: SQL select count (*) from dba_users where username is null ; COUNT(*) -- 0 SQL select count (*) from dba_objects where owner is null ; COUNT(*) -- 0 SQL select count (*) from dba_objects where object_name is null ; COUNT(*) -- 0 SQL select a.username, count (object_name) 2 from dba_users a, dba_objects b 3 where a.username = b.owner (+) 4 group by a.username ; ERROR: ORA-24347: Warning of a NULL column in an aggregate function -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: transaction recovery error
Not good news from my source: POSSIBLE CORRUPTION Versions: 7.3.x, 8.0.x, 8.1.x Attempting to back out an undo record and cannot find a corresponding sys.ts$ entry generating this exception. Suggestion: Attempt to rebuild the database, or restore from a valid backup and rollforward to a point in time prior to receiving the error. For repeatable occurences, please submit the trace files and alert.log to Oracle Support. [EMAIL PROTECTED] 04/30/01 02:05PM My 8.1.7 DB on Solaris 2.7 is throwing trace files about every five minutes. The alert log entries say: SMON: Parallel transaction recovery slave got internal error Mon Apr 30 12:17:32 2001 Errors in file /oracle/admin/ipdevla/bdump/ipdevla_smon_8665.trc: ORA-00600: internal error code, arguments: [4142], [46137989], [], [], [], [], [], [] And the trace file starts with: KTUNDO: cannot find ts$ entry The database is running fine, but I'd like to clear this. Calling Oracle Support is not an option at the moment (we're between support contracts). I'd appreciate any ideas or suggestions. Thanks! Paul Baumgartel InstiPro Group, Inc. [EMAIL PROTECTED] 212 813-0829 x103 -- 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: Tim Sawmiller 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-07445: exception encountered: core dump [kxsdmp()+188]
This sounds like a heap (memory) error. Check for system memory errors. [EMAIL PROTECTED] 04/30/01 01:40PM Hi, One of our databases has just started producing the following errors over the weekend... Errors in file /Volumes/app/oracle/admin/dmps_tst/udump/dmps_tst_ora_16040.trc: ORA-07445: exception encountered: core dump [kxsdmp()+188] [SIGBUS] [Invalid address alignment] [1679844977] [] [] ORA-07445: exception encountered: core dump [kxsdmp()+188] [SIGBUS] [Invalid address alignment] [1679844977] [] [] ORA-07445: exception encountered: core dump [kxsdmp()+188] [SIGBUS] [Invalid address alignment] [1679844977] [] [] ORA-00600: internal error code, arguments: [17182], [2205248016], [], [], [], [], [], [] Another DBA I work with opened a TAR (1535656.999) but I was wondering if anyone else has seen this also? The database is at version 8.1.6.2 on Solaris 2.6. Thanks, Ken _ Clinical and Regulatory Informatics - Groton/New London Coordinator, Business and Technical Services Tel: (860) 732-0026Fax: (860) 715-8346 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fowler, Kenneth 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: Please Advice on Performance Tuning
Trace each process with timed statistics = true and run tkprof on the trace files, then compare. [EMAIL PROTECTED] 04/27/01 01:25AM Hi all, We have got a Payroll Application develeoped in-house. It takes 30-34 Minutes to Run this Batch Application. General feeling is - it should be able to process it within 10-15 Minutes may be less than that. I am to look into this problem and give a solution to it. Steps I had followed as 1. Import the payroll user to another Oracle User in the same database. 2. Removed unnecessary Index , Put parallelism into few tables by Alter table tab1 Parallel(DEGREE 5) 3. Analyze the tables with compute statistics; 4. Run the payroll without checking any inefficient SQL or wrong programming logic in the those Packages( It has only two Package in it no other stand alone Procedure or function). Payroll under this new Oracle User runs in 22-24 Minutes, 6-9 Minutes less. So, I asked Payroll Person to remove those unnecessary Index, asked him to put parallelism into those tables which I had done. He runs the Payroll with no Improvement at all. I asked again to drop those table and recreate it with new storage parameter same as the one created at New User. Still no visible Improvement. At this stage every table in both user has same storage parameter,same index ,and also analyzed. The question is why in One User it runs in 22-24 Min and in another 30-34 Min ? Now Please advice me what do I check or to do, so that the it time takes to run comes down to 22-24 Min, same as the new user. Oracle 8.1.4 Optimize goal : choose Biggest table haiving record less than 6 rows. Thanks in Advance Naba -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: OT: Reading the Oracle Tea Leaves
As long as it doesn't really take hold for about 10 years or so, then I can retire before I become obsolete... 8-) [EMAIL PROTECTED] 04/25/01 06:36PM I foresee the database being sold as a turn key product configured by Oracle at a reduced price. In order to receive the discount the purchaser would have to agree not to mess with the initSID.ora parameters, nor take any action which would enable or disable any database options. What?!, not change init.ora parameters, you scoff. Remember that Oracle 9i has some autotuning capability. I expect, at first, autotuning will not work as advertised, but over time will mature into a powerful product. Ian MacGregor -Original Message- Sent: Wednesday, April 25, 2001 2:06 PM To: Multiple recipients of list ORACLE-L b May I ask, just what type of restrictions do you envision when the database software is made available at a reduced cost? - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: MacGregor, Ian A. [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 11:17 AM To: Multiple recipients of list ORACLE-L Subject: RE: MORE NEWS: ANOTHER ELLISON GUARANTEE - RE: News flash - IBM b The most interesting part of the gaurantee is the proscription against customization. Ellison, at last year's OOW in San Franciso, spoke about the problem of supporting so many different configurations. I suspect the CRM offer is only the start, and that Oracle will eventually offer their database software at a reduced cost with the same restriction. Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] Original Message- Sent: Tuesday, April 24, 2001 11:05 PM To: Multiple recipients of list ORACLE-L b I'm really sorry, but with these restrictions, they should be able to install it in a business week or less. what losers! -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Tim Sawmiller 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: OT: Reading the Oracle Tea Leaves
Nope, still in demand. It seems the more init.ora parameters and other stuff becomes self tuning, the more our knowledge and skill set is required at higher levels. As a for instance, it seems like CBO is finally working pretty well, but, there are more init.ora parameter settings that can influence CBO's logic, so they will still need us for awhile yet (hopefully). [EMAIL PROTECTED] 04/26/01 09:10AM lol -- me too! This is something Larry has been predicting for a long time (quote you will not need DBAs with release fill in the blank) I haven't noticed any dearth of work available, have you? Rachel From: Tim Sawmiller [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OT: Reading the Oracle Tea Leaves Date: Thu, 26 Apr 2001 04:30:22 -0800 As long as it doesn't really take hold for about 10 years or so, then I can retire before I become obsolete... 8-) [EMAIL PROTECTED] 04/25/01 06:36PM I foresee the database being sold as a turn key product configured by Oracle at a reduced price. In order to receive the discount the purchaser would have to agree not to mess with the initSID.ora parameters, nor take any action which would enable or disable any database options. What?!, not change init.ora parameters, you scoff. Remember that Oracle 9i has some autotuning capability. I expect, at first, autotuning will not work as advertised, but over time will mature into a powerful product. Ian MacGregor -Original Message- Sent: Wednesday, April 25, 2001 2:06 PM To: Multiple recipients of list ORACLE-L b May I ask, just what type of restrictions do you envision when the database software is made available at a reduced cost? - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: MacGregor, Ian A. [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 11:17 AM To: Multiple recipients of list ORACLE-L Subject:RE: MORE NEWS: ANOTHER ELLISON GUARANTEE - RE: News flash - IBM b The most interesting part of the gaurantee is the proscription against customization. Ellison, at last year's OOW in San Franciso, spoke about the problem of supporting so many different configurations. I suspect the CRM offer is only the start, and that Oracle will eventually offer their database software at a reduced cost with the same restriction. Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] Original Message- Sent: Tuesday, April 24, 2001 11:05 PM To: Multiple recipients of list ORACLE-L b I'm really sorry, but with these restrictions, they should be able to install it in a business week or less. what losers! -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Tim Sawmiller 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel
Re: ORA-04031
Increase it... [EMAIL PROTECTED] 04/26/01 12:00PM Hi All After upgrading from 8.1.6.0. to 8.1.6.3 I am getting the following error repeatedly. ORA-04031: unable to allocate 4096 bytes of shared memory(shared pool,TRIG_OWSSUBS,PL/SQL MPCODE,BAMIMA: Bam Buffer) Also this error appears in the Oracle Alert log (not sure wether its connected) Errors in file /u01/app/oracle/admin/ukdb/udump/ukdb_ora_8432.trc: ORA-07445: exception encountered: core dump [kkects()+64] [SIGSEGV] [Address not mapped to object] [8] [] [] This is my shared pool size at the moment. shared_pool_size = 52428800 TIA Saj -- Sajid Iqbal Database Team Leader -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal 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: Tim Sawmiller 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: OT: Reading the Oracle Tea Leaves
I would say chances of getting impaled are about 50-50 in either choice [EMAIL PROTECTED] 04/26/01 11:46AM On Thu, 26 Apr 2001,Tim Sawmiller scribbled on the wall in glitter crayon: -Nope, still in demand. It seems the more init.ora parameters and other stuff becomes self tuning, the more our knowledge and skill set is required at higher levels. As a for instance, it seems like CBO is finally working pretty well, but, there are more init.ora parameter settings that can influence CBO's logic, so they will still need us for awhile yet (hopefully). The question is, do I want them to or do I want to pursue my other career choice of javelin catcher? ;-) -- Bill Thater Certifieable ORACLE DBA Telergy, Inc.[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. ~~ What this country needs is a good five-cent microcomputer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: Tim Sawmiller 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: Q: Oracle Year End???
Yes, May 31 is Oracle's fiscal year end. I wouldn't know about the other item. [EMAIL PROTECTED] 04/26/01 11:41AM I have heard, but have not been able to confirm that May is Oracle's fiscal year-end. Does anyone have any information regarding this? I have also heard that May, being Oracles' year-end is the best month to buy. Has anyone had experience with this? -- Howard County Public School System, Maryland, USA [EMAIL PROTECTED] The views expressed in this message do not represent the views of the Howard County Public School System, blaa, blaa, blaa. You get the idea. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Schruefer 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: Tim Sawmiller 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: HYPER VOLUMES - RE: Never split index and data files ...
://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: Haskins, Ed || 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: 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: Mark Leith || 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: Tim Sawmiller 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 vs DB2
because Oracle delivers a higher quality of service than DB2. IBM touts its lower database price, but why risk your business on DB2, a product with many hidden costs? Technology Innovation Is Key By far, the largest hidden cost of running DB2 is IBM's low rate of innovation. Innovation is key to a robust but flexible IT infrastructure. Information systems must evolve constantly as end-user demand changes. They need to evolve rapidly to respond to business changes such as company acquisitions or unexpected competitive pressure. An IT infrastructure based on software products that lack innovation becomes legacy very rapidly. And legacy is expensive to maintain or replace. Oracle has been the database technology innovator for 20 years. In 1979, Oracle delivered the first commercial relational database. In 2001, Oracle delivers the first database caching technology that improves web performance and allows IT organizations to reduce hardware costs. Oracle has not stopped innovating over the past 20 years. Buying DB2 means buying into an infrastructure that is less advanced than your competitors' and that quickly will become legacy in no time. In the long run, buying DB2 equals additional and unnecessary costs as systems need to be upgraded or replaced to reap of the business benefits of more innovative technology. Customers Are The Real Proof Customer acceptance is the real proof, and customers are choosing Oracle: Oracle has been growing its software business at an average rate of 20% per year while IBM's software business has been flat or declining for nearly six years in a row. Customers vote with their pocketbooks and, clearly, they are voting for Oracle, not IBM. Oracle has a higher customer retention rate than IBM (AMR Research, November 2000) 11% of IBM DB2 customers plan on switching to a different database over the next 2 years. (AMR Research, November 2000) Oracle is the most commonly used database across all industries, with usage rates that are, on average, 3 to 4 times higher than IBM DB2 (AMR Research, November 2000) Oracle database is the most commonly used database for developers: a recent EvansData survey shows that 55% of developers use Oracle, only 25% use IBM DB2. The Oracle leadership fact page is on www.oracle.com Oracle Worldwide Marketing [EMAIL PROTECTED] 04/24/01 11:57AM Disclaimer: I am *not* trying to start a religious war, and I am *not* trying to advocate DB2. I am simply offended. Thus this post. As some may remember, I'm doing an evaluation of Oracle vs DB2 vs SQLServer to determine our future direction. Here's a datum that makes a significant difference to us, dollar-wise. With Oracle, in order to make a database accessible to the internet through a web page, you have to buy an unlimited-user enterprise license. We had a senior sales person in our office yesterday, and we asked this question a number of different ways. He bobbed and he weaved, but he did not deny it. And the quote he supplied afterwards does not address the issue at all. Cost of unlimited-user Enterprise version for our installation (your mileage may vary) = Approx $160,000 Cdn. IBM, for the same purpose, will sell you DB2 UDB Workgroup edition (1 user), and something called WE Internet Access, for a total price of $6000 Cdn. I have a written quote from an IBM salescritter to this effect. $6000. $160,000. $6000. $160,000. Hm. Let me think. I respectfully submit that Oracle's pricing structure is out of line with market realities, and may have to undergo significant revision. Dennis Taylor Don't be fooled by old cliches - He who laughs last may have just figured out the joke. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor 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: Tim Sawmiller 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
Re: List of user sessions
Use this script: rem Display Active User Sessions on the Data Base rem column username format a11 column the_command format a22 column serial# heading 'SER#' column serial# format 99 column process heading Unix Process select username, sid, serial#, process, command || '-' || ACT.name the_command ,to_char(logon_time,'mm/dd/yy hh24:mi') Logged On @: from v$session SES ,audit_actions ACT where command = ACT.action order by username; [EMAIL PROTECTED] 04/23/01 07:45AM Hi, i want to know that how will i get to know how many users (along with their identities) who are logged in at any one particular moment of time. mainak __ 123India.com - India's Premier Portal Get your Free Email Account at http://www.123india.com -- 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: Tim Sawmiller 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: Where can I find real-life-examples about ORACLE
I'd be curious to see your definitions of un-normalized and de-normalized... [EMAIL PROTECTED] 04/23/01 01:55PM On 20 Apr 2001, at 19:15, Jared Still wrote: Date sent: Fri, 20 Apr 2001 19:15:20 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Well, why would you *not* want to denormalize during design? It seems to me that (theoretically) ***if*** you are doing structured denormalization correctly, that is exactly when you would want to do it, no? Unless you detect a performance problem, why denormalize at all? We always have folks that want to denormalize because they *think* there will be a performance problem. This usually occurs because they think that joining 3 or 4 tables will be too slow. I guess I've been under the impression that a good design process would be done with proper methods, including having (legitimately tested) performance metrics. Are you saying that is an overly idealistic approach for most real world situations? :) ... ... Only one table was highly denormalized, and that was nobody could figure out a reasonable way to normalize it. Not sure if I could yet. :) Well, as i said before, my understanding is that it was unnormalized, which is different from denormalized. This may be different for really large OLTP databases with a very high number of users, but I've never had the privilege of working on one that big. e.g. Amazon.com, etc. ok. cool. last time I really paid any attention to this topic was around Oracle v6. :) I'll be migrating a departmental database to Oracle8/9 on NT over the next 6 months or so. It is in severe need of normalization. I'll start with a highly normalized model, and see how it goes. ep -- 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: Tim Sawmiller 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: SQLTrace
a trace and run tkprof without having to jump through a bunch of hoops. Anyone set up trace so someone other than oracle can do this? The permissions on the trace files only allow reading by the file owner, so setting the user into the dba group won't help. Thanks, Dave Turner -- And you thought James Bond's watch was cool... http://www.tellme.com Call 1-800-555-TELL for stocks, sports, news... much more! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: Mark Leith 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: Tim Sawmiller 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: Awfully annoying SQLLDR problem
I don't you *can* avoid the larger issue. Oracle 8 has undergone some radical changes underneath the covers. I would expect SQLLDR to have changed just as radically... [EMAIL PROTECTED] 04/23/01 02:06PM No you are reading correctly. I have the data on a server with a 7.3.2.3 database and am using that databases' binary sqlldr to load into the 8.1.5 database. The problem is a timing issue. I need to execute the load from the 7.3.2.3 server as part of a larger script. I cannot ensure that the load will be executed i a timely manner if it is run on the distant server. Whether or not you agree with the timing issue I describe, I'd really appreciate an answer to the Oracle problem. I don't want to get into the larger issue of why I have to run it from one server vs. another. From an Oracle POV it should work either way. thanks, ..tom -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 12:27 PM To: Multiple recipients of list ORACLE-L Subject: RE: Awfully annoying SQLLDR problem Ok,maybe i am lazy or a poor reader, but are you using 732 sqlldr binaries to load an 815 db? Why not the 815 sqlldr binaries? I mean, it sounds like you have to ship data over the wire no matter what you do, so...why not use the latest version of the sqlldr bits? == -Original Message- == From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] == Sent: Monday, April 23, 2001 11:10 AM == To: Multiple recipients of list ORACLE-L == Subject: Awfully annoying SQLLDR problem == == == I am executing a SQLLDR shell file from a server :: == sourceserv; RDBMS 7.3.2.3 == AIX 4.3.2 == into a database on server:: destserv; RDBMS 8.1.5 AIX 4.3.3 == using a SQL*Net connect string destserv_destSID. == == This connect string is defined in the local tnsnames.ora == and works. I confirmed == this by doing sqlplus user/pass@destserv_destSID and == verifying that I am == connected to the correct instance. == == The target table exists. I am connecting as the owner == of the target table. That == owner has DBA. == == but when I run == == sqlldr userid=tabowner/pass@destserv_destSID == CONTROL=localcontrolfile.ctl == (controlfile is below) == == I get SQL*Loader-925: Error while parsing a cursor (via ocisq3) == ORA-00942: table or view does not exist == == Help! Does anyone have any ideas? == == tia, == == ..tom == == here's the controlfile == == LOAD DATA == INFILE data1.dat BADFILE load.bad == DISCARDFILE load.dsc == INSERT == INTO TABLE OWNER.TEST_LOAD == FIELDS TERMINATED BY ',' == TRAILING NULLCOLS == (COL1,COL2,COL3) == == == -- == 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: 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: 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: Tim Sawmiller INET: [EMAIL PROTECTED
RE: Awfully annoying SQLLDR problem
see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: Tim Sawmiller 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: REP: Locally Managed Tablespaces
And just who is it that told you that? [EMAIL PROTECTED] 04/23/01 02:40PM Are you using uniform extents? We are told they are not really = and actually are not the same at all over time. Thanks, --- TheOracleDBA [EMAIL PROTECTED] On Thu, 19 Apr 2001 15:25:31 Peter Barnett wrote: We are using LMTs with several of our databases. No problems. With these databases we are also running large file systems. Although our OS imposes a theoretical limit of 31.G, we have kept our datafiles to 20G or less. Again, no problems. Pete Barnett Oracle Database Administrator Regence BlueCross BlueShield [EMAIL PROTECTED] On Tue, 17 Apr 2001, Patricia Ashe wrote: I am interested in some statistics on Oracle locally managed tablespaces. I have been looking for any bugs or negative info about them. Are they in use at alot of sites? Seems like all the information I have come across is positive. Which is great! But maybe they aren't being used at alot of sites. Can I hear about experiences from others on this list? how many sites are actually using them? I have several databases that I am getting ready to go production soon and would like to create the tablespaces as locally managed, but need more statistics. PA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Patricia Ashe 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: Peter Barnett 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). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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: Tim Sawmiller 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).
Fwd: Re: Where can I find real-life-examples about ORACLE
I'm an admitted purist...I look at denormalized and unnormalized as being the same. I've been on projects that wanted to introduce denormalization because the developers expected a performance issue. After I look at it and disagree, then the war begins. On the other hand, on my latest project, I agreed with a suggested denormalization after I heard all the facts. I like your point about calling it structured denormalization. Makes sense to me. As far as people making business decisions, why do they need to know about denormalization? That's an implementation issue. If they hired good IT people, then they're ok. If they didn't, they're screwed. Such is life in the big city. We need to get some successes under our belt so we can preach with confidence and having refenceable clients available. Eric D. Pierce [EMAIL PROTECTED] 04/23/01 02:06PM And I'd be curious to know why you are curious! What I have gathered so far from the discussion is that normalization zealotry, probably similar to other purist perspectives in life, doesn't get any particularly huge respect in the real world. In other words, people that make business decisions have never heard of any conventional wisdom that violating normalized db designs will automatically wreck their organization. Like many other things, their IT infrastructure will inefficiently plod along, and suffer the burden of crappy models (grumbling dbas and all) in spite of a lack of conformance to theoretical orthodoxy. I would guess that in some cases, an organization's IT folks might be able to present a coherent business case for zealous normalization, but doing so is probably a rare skill, and perhaps even more rarely appreciated by the organization. Unfortunately the situation for structured denormalization is probably about the same, except that it may not have quite the political baggage, and so can just be used as a technical method. ep ps, don't forget that the word structured needs to be in front of denormalized. on the other hand, unnormalized (non-normal) by definition can't be structured. unnormalized implies a *lack* of methodology, whereas structured denormalization implies method/rules/order/metrics/analysis/etc. pss, do you remember reading the Oracle Magazine article on denormalization by Ulka Rogers back in the Oracle v6 (or maybe early v7) days? On 23 Apr 2001, at 10:15, Tim Sawmiller wrote: Date sent: Mon, 23 Apr 2001 10:15:29 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ORACLE I'd be curious to see your definitions of un-normalized and de-normalized... [EMAIL PROTECTED] 04/23/01 01:55PM On 20 Apr 2001, at 19:15, Jared Still wrote: Date sent:Fri, 20 Apr 2001 19:15:20 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Well, why would you *not* want to denormalize during design? It seems to me that (theoretically) ***if*** you are doing structured denormalization correctly, that is exactly when you would want to do it, no? Unless you detect a performance problem, why denormalize at all? We always have folks that want to denormalize because they *think* there will be a performance problem. This usually occurs because they think that joining 3 or 4 tables will be too slow. I guess I've been under the impression that a good design process would be done with proper methods, including having (legitimately tested) performance metrics. Are you saying that is an overly idealistic approach for most real world situations? :) ... ... Only one table was highly denormalized, and that was nobody could figure out a reasonable way to normalize it. Not sure if I could yet. :) Well, as i said before, my understanding is that it was unnormalized, which is different from denormalized. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: Weird link problem
What happens if you do select count(name) from tab1.table? [EMAIL PROTECTED] 04/18/01 09:55AM AIX 4.3 RDBMS 8.1.6.2 When I select through a database link I have having a strange problem. If I select a field or fields it works. If I select a count it hangs. Any ideas? select count(*) from tab1.table; **hangs** select name, address from tab1.table; **works fine** Help!!! ..tom -- 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: Tim Sawmiller 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).
Designer 6i Versioning vs. ?
Anyone familiar with Designer 6i's versioning capabilties? Does it compare well with Clearcase, PVCS, etc? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: Temporary Tablespace Design
ling 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: Hillman, Alex 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: Tim Sawmiller 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).
Don't Let Microsoft's Claim of Superior Database Security Fool
curity? Oracle, IBM zero in on database security - eWeek (March 2001) Securing Oracle - Information Security Magazine (Sept 2000) Oracle8i: Polished for Web - eWeek (March 2000) Oracle Internet Directory: A Mission-Critical Directory Built for Heavy Lifting - Aberdeen Group (2000) Who are some of the customers and partners using Oracle's security technology? Excite@Home U.S. Air Force FirstWorld Communications Trusted Computer Solutions (E-Leaders) U.S. Department of Interior Chase Manhatten Bank Braintree Protegrity Kaiser Permanente Tomax Covisint The best reference is Oracle itself: Oracle Global IT Oracle E-Business Suite Exchange.oracle.com Oracle Portal Online Sales.Oracle.com Where can I find more security related information? Respond against Microsoft's C2 certification press release: http://compete3.us.oracle.com/rt/docs/DATABASE/SS2K_SECURITY.HTML Sales/Marketing: http://marketing.us.oracle.com/security Technical information:http://security.us.oracle.com oracle.com:http://www.oracle.com/ip/solve/security/index.html?content.html otn:http://technet.oracle.com/deploy/security/ Who can I contact for security assistance? Product Marketing:[EMAIL PROTECTED] Product Management:[EMAIL PROTECTED] Sales:[EMAIL PROTECTED] Consulting:[EMAIL PROTECTED] Oracle Worldwide Marketing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: Ability for non DBA user to kill session.
I don't think you can kill yourself anymore, at least in 8.1.6. Even as a DBA, Oracle wouldn't let me off myself... Note to ALL: ENOUGH WITH THE POLITICAL CLAPTRAP ALREADY!!! [EMAIL PROTECTED] 04/17/01 11:26AM All, Is there a method for allowing a non DBA user to kill their own (and only their own) session. I have had a trawl through Metalink and have seen various methods (using procedures) of doing it but all of these appear to rely on granting the alter system role to the user. Oracle 8.0.5.0.0 Compaq Tru64 4.0f Regards Lee Lee Robertson Acxiom Tel:0191 525 7344 Fax:0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: current transaction in oracle
set pagesize 1000 spool actual SELECT SID, TYPE, STATUS, USERNAME, SQL_TEXT, EXECUTIONS, LOCKWAIT, SERVER, OSUSER, PROCESS, MACHINE, TERMINAL, PROGRAM FROM V$SQLAREA, V$SESSION WHERE V$SESSION.SQL_ADDRESS = V$SQLAREA.ADDRESS(+) AND V$SESSION.SQL_HASH_VALUE = V$SQLAREA.HASH_VALUE(+) ORDER BY SID / spool off [EMAIL PROTECTED] 04/17/01 01:25PM Try select * from sys.v_$sqlarea Anthony -Original Message- Sent: Tuesday, April 17, 2001 11:07 AM To: Multiple recipients of list ORACLE-L hi, i am looking for a sql statement which can tell me the current sql running in oracle. TIA Srinivas __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: srinivas aradhyula 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: Hsu, Anthony C., ,CPMS 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: Tim Sawmiller 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 get rid off file permanently?
Now won't you feel bad if someone actually follows your tongue-in-cheek suggestion? [EMAIL PROTECTED] 04/12/01 06:10PM Another good way of reclaiming disk space on Unix boxes is to execute "rm -rf /" as "root". That is an excellent way for saving some money for the disk drives -Original Message- Sent: Thursday, April 12, 2001 3:41 PM To: Multiple recipients of list ORACLE-L I have dropped a datafile a couple of times by taking it offline and then dropping it. This was done after I created a new datafile and accidentally put it in the wrong place, got the allocation wrong or misspelled the name. You just have to make absolutely sure that the datafile does not contain any objects. -Original Message- Sent: Thursday, April 12, 2001 2:01 PM To: Multiple recipients of list ORACLE-L You can't just drop a datafile. You need to drop the entire tablespace. -Original Message- Sent: Thursday, April 12, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Hi all, I need to permanently get rid off some files from the database. I did this: 1. alter database datafile '/orafs/ora1/oradata/LUCP/users02.dbf' offline drop 2. rm the file from physical directory After I shutdown and restart the db, I still see the file in dba_data_files table. So how to tell the control file that the file is already gone? Thank you. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: Miller, Jay 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen 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: Tim Sawmiller 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: Should each partition have it's own tablespace and
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Binley Lim 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: Mark Leith 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: Tim Sawmiller 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: Temporary Tablespace Design
I'd be tempted to make it 4 times your largest expected working set, but how you arrive at that figure is beyond me... [EMAIL PROTECTED] 04/12/01 04:05AM What's your experience about the temporary table design? I read Michael Ault's Orcale8 Administartion and Management , it says "For Cost-based optimization, it should be 4 times of the largest table". I have a table of 60 Million records, and it costs 16GB, should I have a 64GB temp tablespace(I don't think so, though it's a 100GB database, and I have a 300GB of diskspace). Thanks for your advice. Chris __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest 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: Tim Sawmiller 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: Problem with database link
Did you look in TNSNAMES.ORA? [EMAIL PROTECTED] 04/11/01 09:10PM Hi there! I'm having a problem with database links here. I am on my SPEEDY database and want to create a link that points to another database called SAM. create database link SAM connect to user identified by pasword using 'SAM'; Then I try and issue that statement: select view_name from user_views@SAM * ERROR at line 2: ORA-02085: database link SAM.VIVONET.COM connects to SAM Where does our domain name appendix (vivonet.com) come from I looked in all the possible config files (e.g. sqlnet.ora etc.) and couldn't find anything. In both databases the init.ora parameter is set to global_names = true. Any idea? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger 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: Tim Sawmiller 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: Full import from Oracle 7.3.4 on NT to Solaris 8.1.7
Just pre-create the tablespaces. The import will not try to create them if they already exist. [EMAIL PROTECTED] 04/10/01 11:13AM Hi All, I have not done subject line before. My question is doing a full export from NT then importing onto Unix. The export file will have a hardcoded path for creating the datafiles. Obviously that will fail on UNIX. What is best way to do full export from NT to UNIX. Should I just pre-create the tablespaces then import with ignore=y option? Thanks Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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: Tim Sawmiller 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: tirggers
Once accessed they should stay in memory the duration of the session. [EMAIL PROTECTED] 04/06/01 01:20PM I do specify Buffer_pool_keep but I was under the impression that you needed to FTS the tables to get them into memory? -Original Message- Sawmiller Sent: Friday, April 06, 2001 9:07 AM To: Multiple recipients of list ORACLE-L Why not just specify BUFFER POOL KEEP in an alter table statement? [EMAIL PROTECTED] 04/05/01 05:56PM What is the problem to write something like Select * from table_name for all tables that you need or if there are too many such tables - create a new table with names of the tables and use dynamic SQL . Alex Hillman -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 5:28 PM To: Multiple recipients of list ORACLE-L Subject:tirggers Hi Intelligent DBA's I was wondering if anyone knows how to create a trigger that would fire off at database startup time and run a script to do full table scans on several tables to get them into the buffer cache keep pool? Right now I do it manually and would like to automate the task. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Hillman, Alex 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: Tim Sawmiller 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: Kevin Kostyszyn 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: Tim Sawmiller 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: Last modification
Nope, nope, and nope. To have this feature, you will have to add such columns yourself, and maintain them, probably by triggers. [EMAIL PROTECTED] 04/09/01 09:10AM I'd like to know when one record had been modified ... Is there a hidden column with that information ? A special table associating the rowid with a date ? Anything else ??? Thanks L.A. -- 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: Tim Sawmiller 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: Parallel index builds can crash
reviewNote:100492.1Via metalink (Metalink - - technical library- - reach with note#) Title: ORA-01652: estimate space needed to create index - Also further researched and found:Bug:377439.-P Abstract: INDEX BUILD FAIL WITH PARALLEL DEGREE 1 - is there any ora-7445 and core dump file in udump directory? - is there an internal error (ora-600) trace file? Please update the tar via metalink. Thank you, Oracle Support Services. Have you tried MetaLink? Search our technical libraries, create/review/update your TARs at: http://metalink.oracle.com -- 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: Tim Sawmiller 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:RE: Parallel index builds can crash
WITH PARALLEL DEGREE gt; 1/FONT /P BR BR PFONT SIZE=2nbsp;- is there any ora-7445 and core dump file in udump directory?/FONT BRFONT SIZE=2nbsp;- is there an internal error (ora-600) trace file?/FONT /P PFONT SIZE=2Please update the tar via metalink./FONT BRFONT SIZE=2nbsp;Thank you,/FONT BRFONT SIZE=2Oracle Support Services./FONT BRFONT SIZE=2nbsp;/FONT BRFONT SIZE=2nbsp; /FONT BRFONT SIZE=2nbsp; /FONT BRFONT SIZE=2Have you tried MetaLink?nbsp;nbsp; /FONT BRFONT SIZE=2Search our technical libraries, create/review/update your TARs at:nbsp;nbsp; /FONT BRFONT SIZE=2A HREF="http://metalink.oracle.com" TARGET="_blank"http://metalink.oracle.com/A /FONT /P BR PFONT SIZE=2-- /FONT BRFONT SIZE=2Please see the official ORACLE-L FAQ: A HREF="http://www.orafaq.com" TARGET="_blank"http://www.orafaq.com/A/FONT BRFONT SIZE=2-- /FONT BRFONT SIZE=2Author: /FONT BRFONT SIZE=2nbsp; INET: [EMAIL PROTECTED]/FONT /P PFONT SIZE=2Fat City Network Servicesnbsp;nbsp;nbsp; -- (858) 538-5051nbsp; FAX: (858) 538-5051/FONT BRFONT SIZE=2San Diego, Californianbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; -- Public Internet access / Mailing Lists/FONT BRFONT SIZE=2/FON T BRFONT SIZE=2To REMOVE yourself from this mailing list, send an E-Mail message/FONT BRFONT SIZE=2to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in/FONT BRFONT SIZE=2the message BODY, include a line containing: UNSUB ORACLE-L/FONT BRFONT SIZE=2(or the name of mailing list you want to be removed from).nbsp; You may/FONT BRFONT SIZE=2also send the HELP command for other information (like subscribing)./FONT /P /BODY /HTML -- 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: Tim Sawmiller 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:RE: Parallel index builds can crash
by the query server processes. Therefore, an index created with an INITIAL of 5MB and a DOP of 12 consumes at least 60MB of storage during index creation because each process starts with an extent of 5MB. When the query coordinator process combines the sorted subindexes, some of the extents may be trimmed, and the resulting index may be smallerthan the requested 60MB. ORA-1652 From version 7.x, we can create certain objects in parallel, or unrecoverable. In order for Oracle to accomplish this, temporary segments are created that eventually become a permanent part of the object, yet Oracle still refers to them as temp segments. Thus, most of the time you receive this error, it will be referring to the tablespace the object is going to be created in. Do the following query to find out if you're out of extents: select max(blocks), max (bytes) from sys.dba_free_space where tablespace_name = 'tablespace in error message'; For example, The above query may return: SQL blocks bytes 614312,580,864 Notice that the biggest CONTIGUOUS block of free space is only 6143 blocks and Oracle needs a contiguous block of free space of 6144 to create an object. You may have a lot of free space in separate blocks in your tablespace, but if it is not contiguous, Oracle cannot use it. Allocating extents requires that there be a contiguous block of free space. SOLUTION: 1. Add a datafile to the tablespace 2. Adjust the storage parameters of the object you are trying to create. Parameters to look at: initial extent, next extent, pct increase. 3. If you have a lot of free space in that tablespace, but the it is very fragmented, you may want to consider rebuilding the tablespace. 4. Enable AUTOEXTEND for the datafile - Also, Please reviewNote:100492.1Via metalink (Metalink - - technical library- - reach with note#) Title: ORA-01652: estimate space needed to create index - Also further researched and found:Bug:377439.-P Abstract: INDEX BUILD FAIL WITH PARALLEL DEGREE 1 - is there any ora-7445 and core dump file in udump directory? - is there an internal error (ora-600) trace file? Please update the tar via metalink. Thank you, Oracle Support Services. Have you tried MetaLink? Search our technical libraries, create/review/update your TARs at: http://metalink.oracle.com -- 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: Tim Sawmiller 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). !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII" META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12" TITLERE: Parallel index builds can crash/TITLE /HEAD BODY PFONT SIZE=2On a partitioned table?nbsp; If you have a slave for each partition, how would this be wrong?nbsp; Or, less slaves than partitions?/FONT/P PFONT SIZE=2It was pounded into my head not to use parallel with non-partitioned tables because without partitions the slaves would not know how to divy up the work.nbsp; Seemed to me that it should be smart enough to split it up by extents, but what do I know.nbsp; Any comments?/FONT/P PFONT SIZE=2I never did claim to be that incredibly bright and I did burn quite a few brain cells over the weekend.nbsp; Forgive my ignorance, people !nbsp; We all have our days and then there are those of us who lie and claim not to./FONT/P BR PFONT SIZE=2-Original Message-/FONT BRFONT SIZE=2From: Tim Sawmiller [A HREF="mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/FONT BRFONT SIZE=2Sent: Monday, April 09, 2001 12:55 PM/FONT BRFONT SIZE=2To: Multiple recipients of list ORACLE-L/FONT BRFONT SI
RE: Recovery from noarchive db corrected
I would tell them that THEY are then responsible for database recovery if a problem should occur. If the DBA is to be responsible, then the DBA should be able to utilize the recovery tools provided by the vendor (Oracle). [EMAIL PROTECTED] 04/06/01 12:45AM The developer application running huge batch inserting data into database, that is what they told me, if you are me what you will do? -Original Message- Testa Sent: Friday, 6 April 2001 11:55 AM To: Multiple recipients of list ORACLE-L assuming you're the dba, since when does the developer dictate recoverability to a DBA about a database. sounds like a role problem there. joe Sinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Tim Sawmiller 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: tirggers
Why not just specify BUFFER POOL KEEP in an alter table statement? [EMAIL PROTECTED] 04/05/01 05:56PM What is the problem to write something like Select * from table_name for all tables that you need or if there are too many such tables - create a new table with names of the tables and use dynamic SQL . Alex Hillman -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 5:28 PM To: Multiple recipients of list ORACLE-L Subject:tirggers Hi Intelligent DBA's I was wondering if anyone knows how to create a trigger that would fire off at database startup time and run a script to do full table scans on several tables to get them into the buffer cache keep pool? Right now I do it manually and would like to automate the task. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Hillman, Alex 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: Tim Sawmiller 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: failed to extent to the next
be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: Is ALTER TABLE ADD COLUMN a time-consuming operation ?
If the new column is nullable, it should very little time, since all that happens is an update to the dictionary. If it is not null, then the column will have to be physically added to each row with a value. [EMAIL PROTECTED] 04/05/01 07:15AM Hello List We are going to change structure of a big table (more than 250.000.000 rows). We need to add a column with NUMBER type. I'm unclear how Oracle do this operation. Does it mean that Oracle have to read and reformat all table blocks in order to update each row header? If yes, I can suggest that estimation of the operation's time is about time of Full Table Scan on the table. Is it correct? Please explain. Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard 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: Tim Sawmiller 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: new DBA/DBO basic training
Teach him to write a resume... [EMAIL PROTECTED] 04/04/01 07:50AM Dear all ! I'm leaving my current job soon , but before i leave i need to teach one of the developers here some very-very basic DBA / DBO stuff. This guy is going to support our existing databases . I'm just wondering what should i teach him . The training must be short and very practical . He knows some basic SQL already . I thought of briefly giving him some Oracle instance/database concepts , i.e. what is instance , SGA , background processes , database , tablespace , rollback segments . Then i thought of just showing him how to shutdown / start up the instance and the listener . Then a short session on SQL*Loader ( we use it a lot here ) , exp/imp . I also gave him the Kevin Looney's "Oracle DBA Handbook" to take a look at . Am i missing something ? Please advice . Please note that taking a course is not an option for us . Thanks a lot . Andrey . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: Unable to open the database,Urgent!!!
I don't think you're having memory problems; check for the number of available semaphores; sounds like that should increase; [EMAIL PROTECTED] 04/04/01 07:00AM Hi, In a Unix Machine I want to create two instance on a single server.Its memory size is 1GB. I am trying to up one instance it is opening well .While Creating other instance I am getting this error. ORA-07279: spcre: semget error, unable to get first semaphore set. SVR4 Error: 28: No space left on device Additional information: 25 Additional information: 2 But I tred to shutdown the first database and open the second one ,the second one open well and Viceversa. But WhenTrying to open both the database it gives the above error. Please tell me what i wil do. Previously the SGA size was 15MB. The new one I tried to 6Mb ,then eror gives. Thne next method I tried SGA is 6Mb for 1st database and second is 2Mb.thne still error Tell me what I will do. Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) 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: Tim Sawmiller 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: Indexes causing a slowdown
Yep. As you're loading, Oracle keeps trying to re-balance the tree. Oracle 8i handles this better. I have a client who avoided this problem by reversing the order of the digits of the sequence generated key, so, for example, if your next key is 123456789, you would reverse that and use 987654321 instead. [EMAIL PROTECTED] 04/04/01 11:16AM OS HP10.20 Oracle 7.3.3 (ya I know) Every now and then we get the situation were application grows to a standstill as far as loading data. These should all be straight forward inserts. Rebuilding the indexes causes the problem to go away. These indexes are all based on primary key values like sequence numbers. Now I know that indexes that are of that type will not have a balanced tree and will periodically need to be rebuilt but to me that should just affect things that are trying to select from the index. Problem is, it takes a full day to rebuild the indexes on this database and we cannot do this while the app is up due to activity levels keeping the tables locked. Does this sound like normal behavior for indexes? Kimberly Smith Database Administrator EDS - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- 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: Tim Sawmiller 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 - invail declare of char
You didn't spell calanderstring consistently bi guy...(calendarstring...) [EMAIL PROTECTED] 04/04/01 02:41PM Hello, I know I am missing something. I just can't see it right now. Could someone please tell me what is wrong here? We use version 8.1.6 on Spar Solaris 7. I am getting the following error when I try to create this function as sys. PLS-00201: identifier 'CALANDERSTRING' must be declared Here is the function. CREATE OR REPLACE FUNCTION ACADEMICYEARTERM_TO_CAL( ayear4 IN CHAR, aterm2 IN CHAR) RETURN CHAR IS calandarString CHAR(10) := ' '; BEGIN SELECT term_desc || ' ' || to_char(start_date, '') into calanderString from term where term = aterm2 and academic_year = ayear4; RETURN (calanderString); EXCEPTION WHEN OTHERS THEN RETURN(calanderString); END; / TIA! Neil MacDannald, Database Analyst San Joaquin Delta College, Information Services Voice: (209)954-5300, Fax: (209)954-5302 email: [EMAIL PROTECTED] Web Page: http://www.deltacollege.org/emp/nmacdannald -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: Redo log size MAX = ?
So, based on the responses I've seen, this statement can be declared to be false. [EMAIL PROTECTED] 04/03/01 11:05AM hi forget about recovery from online redo logs It doesn't exist in Oracle Regards Tapiwa -Original Message- Sent: Tuesday, April 03, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Hi, My database = noarchive mode (compulsory for our application) In case of instance failure can oracle perform recovery from redo log ? if can what will be tne maximum size of the redo log recommended. Because I need set that size for whole day transaction currently 512K (3 redo logs) switched every 15 - 30 minutes. Can oracle perform recovery from inactive or "other status" redo log ? Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Zhou, Tapiwanashe 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: Tim Sawmiller 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: Good Oracle Apps listserv?
courteously. Pretend you're all in a room together, and that your Mother is watching. If you wouldn't do something to in the same room as a person, don't do it here. That's all that's really asked. This list is made possible through the use of hardware, software and network access provided free of use for the list members by the consulting firm Champagne, Parent Associes Inc. of Montreal, Canada. Champagne, Parent assumes no responsibility for the information flowing through the list, or for the mailing list service provided. They can at any time decide to stop, delay or change the operation of this list. Where to get more information - [Section still under construction] Rules for using the mailing lists on cpa.qc.ca -- This is is intended to be a forum for discussions on issues related to Oracle's suite of business applications. As such, it is not permitted to use the list to distribute advertisements, or job related postings. For Job postings, you are encouraged to use the OraJobs-L mailing list which has been setup specifically for this purpose. [This part is still under construction [EMAIL PROTECTED] 03/31/01 08:50PM Can anyone suggest a good listserv that is specific to Oracle Applications? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken 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: Tim Sawmiller 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: Problems on Sun E450 server.
FWIW, I had a client who experienced occasional performance problems on an E450. It looked like a disk bottleneck, but it was really a memory problem. A process with high I/O activity overloaded the swap area. Adding a couple of gig of memory helped a lot. [EMAIL PROTECTED] 03/30/01 06:35AM Clinton I have run databases on E450s which outperform comparable E3X00 servers. I would therefore believe that the fault is with your set up, SUN or Oracle. You say the same spec but can you clarify eg no of connections, data volumes etc Allan From: Clinton Naude [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Problems on Sun E450 server. Date: Thu, 29 Mar 2001 23:55:22 -0800 Hi. Just curious to know if anyone out there has had any performance problems with Oracle on a Sun E450 server before? Our database is a dog at the moment compared to the same spec database running on a Sun Ultra 10. Any info would be appreciated. Thanks Clint -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Clinton Naude 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). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Allan Robertson 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: Tim Sawmiller 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: select count(col1) from A where col1=col2. Indexes on
Well YOU might be saying that, but is ORACLE understanding that... Try adding two where clauses( and col1 is not null and col2 is not null ) and see what happens. [EMAIL PROTECTED] 03/30/01 08:10AM Hi, I don't want it to count the rows with col1 as null. When I specify col1=col2, I am implicitly saying that they are both non-null and equal to each other. regards, ram -Original Message- Sent: Friday, March 30, 2001 6:25 PM To: Multiple recipients of list ORACLE-L Well, how will it count the rows where col1 is null if it just uses the index? There are no entries in the index for those rows... [EMAIL PROTECTED] 03/30/01 06:30AM Hi, I have a table A with two identical, integer, nullable columns col1 and col2, both of which are indexed. The table A has 100,000 rows and takes up 11,000 blocks. The indexes on the two columns take about 225 leaf blocks each with BLevel=1. The optimizer goal is set to CHOOSE and the table analyzed with compute stats. Oracle version 8.1.7 on Win' 2000. Right, when I now run the query: SELECT COUNT(col1) FROM A WHERE col1=col2; the CBO is doing a full table scan on A (with 11000 physical reads) rather than just joining the two indexes to get the result. I have two questions: 1. Why is the CBO not choosing to join the indexes by default? 2. When I gave an INDEX_JOIN hint /*+ INDEX_JOIN (A COL1IDX COL2IDX) */, it did do a hash join of the two indexes which was faster but still took about 6500 physical reads while the two indexes put together take only about 452 blocks. Any idea what the extra disk reads are doing? Thanks in advance, Ram -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramakrishna V 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: Tim Sawmiller 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: Ramakrishna V 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: Tim Sawmiller 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: OT: RANT ABOUT OCP, Re: Small help
Well done Bill...nicely handled...gotta remember that one! [EMAIL PROTECTED] 03/29/01 08:00AM "Joseph S. Testa" wrote: Lee, i'm with you 200%, oh and for the original addressee(and others) if you can't figure out what the heck that simple pl/sql block is doing(or where to figure it out), then quit diluting the OCP worthiness, people who study just to take the OCP and have no experience just go to further the waste of paper that the certificate is printed on. :) joe you know you really should tell us just how you feel and not beat around the bush that way.;-) i got asked yesterday by damagement why i wasn't certified. when i asked if they would pay for the courses/exams they didn't seem to think that was "in the training budget". so i said they's just have to put up with me the way i was and got back to building the database infrastructure.;-) oh well, guess i'll end up loosing out to someone with an OCP.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [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! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: Tim Sawmiller 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: Why can't I see any Application Systems in my Des 2000
This might have worked better had you created a repository from scratch in your new 8.1.5 database, then exported/imported the application systems from your old repository to your new one. This is how I would have done it. [EMAIL PROTECTED] 03/29/01 08:00AM I just migrated my database that supports Des/2000 version 2.1 from 7.3.4 to 8.1.5. I did not upgrade Designer and don't plan to at this time. Due to lack of any specific documentation anywhere on how to migrate this database, I simply created a brand new database of the same name on a different box as 8.1.5 and imported a full database dump that I had exported from the system Oracle ID on the old 7.3.4 database. I doubted this would work but thought I would try. I changed my tnsnames.ora file on my NT to point to the new database and brought Des/2000 up. The Application System pop-up window comes up and shows me no Application Systems. If I hit cancel on this popup, I can get to and bring up the Repository Adminstration Utility. I selected Upgrade, went through the various steps, and everything says that my repository is already up to date. I feel that I am missing some script. Perhaps a cat for Designer/2000. Is there any such thing? Is there anything else I can run from the Repository Administration Utility that will make my Application Systems show up in the pop-up window? Can anyone point me to any documentation on how to migrate a database supporting Des/2000 without upgrading Designer? I have looked through a lot on online documentation on Technet, Metalink but all of it assumes that you are upgrading Designer. Thanks in advance to any kind soul who can help. I've posted multiple times on this topic but not recieved any specific steps to run. Thanks, Cherie Machler 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: Tim Sawmiller 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 Books on Audio Tapes
Surely there's a Reader's Digest Condensed Version Or how about Cliff Notes? [EMAIL PROTECTED] 03/29/01 10:45AM Also, for Oracle 7 at least, the documentation is about 10,000 pages long, that would take a lot of tapes. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: dana Sent: Thursday, March 29, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Books on Audio Tapes --- Apps Sol [EMAIL PROTECTED] wrote: Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK I doubt it. From what I understand, audio books are primarily made from best-selling fiction. What non-fiction audio books exist are probably limited to stuff with the broadest general appeal (best-sellers). I've personally never heard of technical books on tape/audio CD. However, you might be able to make your own, rather tediously, if you receive a PDF version along with a "dead tree" technical book. 1. Copy-paste the text from the PDF to your word processor of choice. 2. Use text-to-speech software to creave WAV files 3. Burn to CD. Or, you may want to purchase some Oracle Computer-Based-Training CDROMs and burn the audio tracks to an audio CD(if they're in a standard audio format or a format you could convert to WAVs) - or convert and download to an MP3 player. That's probably your best choice, though an expensive one. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana 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: Boivin, Patrice J 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: Tim Sawmiller 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: Standard vs Enterprise Edition
I am compelled to tell you this story... Many years ago I had a gold fish that had some sort of parasite on it...it was green. My gold fish book actually had a remedy for this. Take the fish out of the water, remove the parasite with tweezers, apply a small drop of mecurchrome(sp?), then bathe the fish in a lite saltwater solution for an hour. Sounds weird? Maybe, but I did it, and it worked! The spot on the fish actually healed. [EMAIL PROTECTED] 03/29/01 10:35AM RE: Standard vs Enterprise Edition [growl] This is sort of off topic, but on the subject of "EnterpriseEdition"s As you may remember, I've been doing comparisons betweenOracle, SQLServer, and DB2, pricewise and otherwise. I asked for priceson the "Enterprise" versions of all, so that I could be comparing thefull-featured flagships in all cases. Well, it turns out IBM's DB2 alsocomes in "Extended Enterprise Edition" (E3), which adds clustering to themix (actually pretty good specs on that feature).Apologies to anyone who gets offended, but this is kind of like howcondoms come in "Large", "Larger", and "Huge".Dennis TaylorNo one feels quite as helpless as the owner of a sick goldfish.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Dennis Taylor INET: [EMAIL PROTECTED] City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: nvl affect on idexes
Well, assuming xfoo is a variable, this is not correct...the function is not being used on the indexed field in this case, so the index WILL be used. If xfoo is a column in the table, then I would expect a full table scan to be used. [EMAIL PROTECTED] 03/29/01 11:16AM Eric, Oracle won't use the index in this case. Instead have a function-based index. Prakash -Original Message- Sent: Thursday, March 29, 2001 9:43 AM To: Multiple recipients of list ORACLE-L Does nvl have any effect on indexes. In other words would it slow down a query if you used the nvl function in the where clause on an indexed field. i.e. select * from foo where indexField nvl(xfoo,0); Thanks, Eric -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chesebro, Eric 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: Bala, Prakash 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: Tim Sawmiller 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: Set transaction does not work
I think the big rollback segment needs to be private. [EMAIL PROTECTED] 03/29/01 12:50PM RDBMS 7.3.2.3 I am running this under SQLPLUS set transaction use rollback segment BIG_ROLLBACK select c1, c2 from giant_poorly_indexed_table where unindexed_colum=''; exit; I end up with "snapshot too old" rollback segment RB_07. Why won't it use the giant rollback segment I created for this transaction? The segment is public and it is online. -Original Message- From: Brian Wisniewski [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 7:45 AM To: Multiple recipients of list ORACLE-L Subject: Re: Is terminal release of 8.0.x still supported? I checked yesterday and 8.0.6 which is the terminal 8.0.X release is still supported on Solaris. Freakin' vendor won't certify their product for anything above 8.0.5 which hasn't been supported for nearly a year now. mumble, mumble... - Brian --- [EMAIL PROTECTED] wrote: We have some 8.0.4 databases running on Sun Solaris. I believe that 8.0.4 has been desupported as of December 31, 2000. We are unable to upgrade one of our apps at this time that is running on an 8.0.4 database. Is the terminal release of 8.0.x still supported? If yes, what is that terminal release? Is it 8.0.7? How long before that terminal release will be desupported (if it is currently supported)? Thanks, Cherie Machler 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). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski 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: Tim Sawmiller 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: Tuning Matter == Parameter PCT_USED in a Table
Ok, I'll admit my ignorance. What the heck does "1 row" mean? It can't mean the row length, or you'll end up with a negative PCT_USED. [EMAIL PROTECTED] 03/22/01 09:35PM Hi Bambang, Analyze the table and you'll find the average row length in USER_TABLES.AVG_ROW_LEN. Subtract 90 bytes from the block size before expressing that as a percentage and round it up. Also, the formula should be PCT_USED = 100 - (PCT_FREE + 1 row). There are scripts on the Ixora web site that do this sort of stuff. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Friday, 23 March 2001 11:46 To: Multiple recipients of list ORACLE-L Dear Listers, I've download a presentation talking about Calculating PCT_USED . the formula is quite simple : PCT_USED + PCT_FREE 100 PCT_USED = PCT_FREE + 1 row size but I have no idea to calculate the size of 1 row in a table . is there anyone who knows to calculate it ? or any alternative formula to calculate PCT_USED ? Thanks a lot in advance : ) =bambang= Bambang Setiawan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan 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: Steve Adams 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: Tim Sawmiller 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: Single Code Table or Separate Code tables dilemma
Author: Michael Netrusov 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: Tim Sawmiller 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: EMC TimeFinder, and EMC TimeFinder vs Hot Standby
So, Jared, are you auditioning for Louis Rukeyser's job? 8-) Lisa can probably explain better, but as I recall, BCV is something Backup Control Volumes. It's a third mirror that can be split off from the other two and used for a cold backup (e.g. shutdown Oracle database, split BCVs from the mirror set, restart Oracle (this takes like 5 minutes or less); run cold backup at your leisure). Then they can be re-attached to the mirrored disks at any time and the BCVs are synchronized with the mirrored disks automagically. Right Lisa? [EMAIL PROTECTED] 03/21/01 11:17PM Ok, does someone one to define SRDF and BCV for those of us that don't have any idea what you're talking about? Jared On Wed, 21 Mar 2001, Koivu, Lisa wrote: Hi Yosi, how are you? I can't exactly clarify your fish vs. potatoes, er, timefinder vs. SRDF question but I can tell you that we have BCV's implemented here. We use them for backup and recovery (and it's extremely slick and fast, let me tell you! Worth every penny we paid) However you can also mount the BCV's and access the data. Honestly I don't see any reason why I wouldn't be able to install Oracle on this server and open up a read-only database on the BCV's. Except for maybe the fact that my employer practically chokes when Oracle quotes pricing. We are running HP/UX. If you want more specific info, email me directly and I'll be glad to answer questions. Have a great day... Lisa Rutland Koivu Oracle Database Administrator -- 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: Tim Sawmiller 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: EMC TimeFinder, and EMC TimeFinder vs Hot Standby
Yeah, that's it, Business Continuation Volume. The client site I was at was going to use that for a daily cold backup, and leave it disconnected for use as a "reporting" database. It was going to be a poor man's data warehouse. Not the best idea, but a method to at least get started. The plan was to re-synch in the early evening, then do the whole shutdown, detach, startup, backup process again. I do remember one flaw in the plan was that you couldn't have a second database instance on the same server accessing the BCVs because the disk addressing would conflict with the mirrored disks, so they needed a second, smaller server to mount the BCVs to for handling the second reporting database. The server involved was IBM AIX. I believe HP has the same limitation. Dunno if the limitation is server based or if it's a general disk addressing issue. [EMAIL PROTECTED] 03/22/01 08:15AM [EMAIL PROTECTED] wrote: Ok, does someone one to define SRDF and BCV for those of us that don't have any idea what you're talking about? Jared BCV stands for Business Continuation Volume, in essence an extra mirror of a volume that can be snapped off to use for backup or reporting uses when mounted on another server. [eeep... i just answered a question from the List God(tm);-)] -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [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! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: Tim Sawmiller 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: But all is not gloom and doom for Oracle...
Which is why, when you put all your eggs into that basket, you WATCH THAT BASKET!!! [EMAIL PROTECTED] 03/22/01 09:45AM I don't know if I necessarily agree with that. What if their financial report from the past 3 years shows a lot of growth. Well if you don't investigate the company and find anything out about it, you could be getting yourself into trouble. What if they just replaced mgmt and he/she's a meat head and doesn't like the current staff? Goes out and hires new machanics and they suck, now that historical financial data doesn't mean anyting, current customers will leave and no new ones will be coming. Bye bye repair shop! -Original Message- Sawmiller Sent: Thursday, March 22, 2001 7:47 AM To: Multiple recipients of list ORACLE-L Well the Oracle CFO is naturally going to be bullish. What's wrong with listening to an independent analyst? And your buddy is doing financial analysis, not chemical analysis, so your story is supererogatory. If I want to invest in a car repair shop, I want to know about financial performance. If their mechanics aren't any good, I expect the finances will reflect that. Try using analogies that are valid please. [EMAIL PROTECTED] 03/21/01 03:29PM It's all "accounting" and "Wall street analysts". Most accountants I know can't keep their own check books balanced and I've got an old class mate down in a wallstreet brokerage. He does petrochemical companies. What I don't understand is how he got the job as he flunked chemistry in HS, and I mean REALLY flunked, like 40 as a final grade not to mention what happen to the lab bench!! It just doesn't figure. If you have a car problem you go looking for a qualified mechanic. But when you've got money to invest you listen to an Analyst? What about the opinions coming from the company CFO?? Case of the blind leading the blind deaf. Dick Goulet Reply Separator________ Author: "Tim Sawmiller" [EMAIL PROTECTED] Date: 3/21/2001 11:45 AM But all is not gloom and doom for Oracle. Excerpts from Chuck Phillips of Morgan Stanley on the last quarter It's useful to keep the quarter in perspective. It's a miss but not a financial disaster: - Oracle made $900 million in operating profits in the quarter. This is real business. - Revenue of $2.67 billion was 5% below our $2.75 billion estimate -- not 25% below like some other pre-announcements. - The company booked $1.1 billion in license revenue instead of our $1.2 billion estimate -- so most deals closed. - Applications were up 50% in the quarter. Database was flat to slightly down in the quarter versus a tough compare. Total licenses increased 6%. Oracle was one of the last generals left standing on a brittle technology battlefield, and in the end couldn't avoid the bullets and hand grenades that were showering down from above. It has become clear that in an environment like this one, there are no bulletproof vests. Other software companies have to be concerned and will likely see something in March. Oracle has a strong product line, is well established with customers references and couldn't get quite enough deals done. Most other software companies are in far weaker positions from a product and positioning perspective. [EMAIL PROTECTED] 03/21/01 01:52PM --- Forwarded message follows --- Date sent: Mon, 19 Mar 2001 02:04:08 -0500 (EST) ... *** $1 Billion Savings Gets Even Less Likely For Oracle Oracle's goal to reach one billion dollars in savings by implementing its own financial software just got even more unattainable. Oracle Thursday announced financial results for the third quarter, ending Feb. 28. As expected, the company failed to meet the margins and profits it will need to achieve its savings goals, The operating margin for the third quarter was 33 percent. That's up 2 percent year-over-year, which is good, but it falls far short of the 40 percent margin that the company and financial analysts have said would be needed to achieve the company's goal of saving 1 billion in costs this year over last year. Combine the disappointing operating margin with flat, rather than growing, profits and what you end up with is a cost savings, year- over-year, significantly less than even the $300 million that it seemed was just barely within Oracle's reach two weeks ago. -- Mitch Wagner Read the entire story: http://update.internetweek.com/cgi-bin4/flo?y=eC2a0BdpN70V30LxJk *** ... Did someone forward this to you? Get your own issue... http://update.internetweek.com/cgi-bin4/flo?y=eC2a0BdpN70V30LsYu Still not receiving your own FREE subscription to InternetWeek Magazine? Subscribe by going to http://update.internetweek.com/cgi-bin4/flo?y=eC2a0BdpN70V30LsZv This message powered by FloNetwork http://w
RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby
Just make sure you have a mirror on each side of the fault line... [EMAIL PROTECTED] 03/22/01 10:56AM I believe fiber channel makes this possible because it allow drives to be separated by about 60 kilometers (or is it 100?) without having any latency problems. I read somewhere that some shops have been able to roll their own SRDF/BCV-like triple mirror solution without having to buy huge, expensive 3rd party "boxed" solutions. Has anyone done this or know of anyone else who has? I'd like to have some mirrored drives on opposite sides of the San Francisco Bay... of course this won't help me in a massive earthquake where the entire state of California slips into the Pacific Ocean. ;-) Steve Orr -Original Message- Carmichael Sent: Thursday, March 22, 2001 5:36 AM To: Multiple recipients of list ORACLE-L Tim, That sounds about right. SRDF is something like Symmetrix Remote Data Facility and is basically mirrored disks at a remote site. Rachel From: "Tim Sawmiller" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby Date: Thu, 22 Mar 2001 04:30:26 -0800 So, Jared, are you auditioning for Louis Rukeyser's job? 8-) Lisa can probably explain better, but as I recall, BCV is something Backup Control Volumes. It's a third mirror that can be split off from the other two and used for a cold backup (e.g. shutdown Oracle database, split BCVs from the mirror set, restart Oracle (this takes like 5 minutes or less); run cold backup at your leisure). Then they can be re-attached to the mirrored disks at any time and the BCVs are synchronized with the mirrored disks automagically. Right Lisa? [EMAIL PROTECTED] 03/21/01 11:17PM Ok, does someone one to define SRDF and BCV for those of us that don't have any idea what you're talking about? Jared On Wed, 21 Mar 2001, Koivu, Lisa wrote: Hi Yosi, how are you? I can't exactly clarify your fish vs. potatoes, er, timefinder vs. SRDF question but I can tell you that we have BCV's implemented here. We use them for backup and recovery (and it's extremely slick and fast, let me tell you! Worth every penny we paid) However you can also mount the BCV's and access the data. Honestly I don't see any reason why I wouldn't be able to install Oracle on this server and open up a read-only database on the BCV's. Except for maybe the fact that my employer practically chokes when Oracle quotes pricing. We are running HP/UX. If you want more specific info, email me directly and I'll be glad to answer questions. Have a great day... Lisa Rutland Koivu Oracle Database Administrator -- 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: Tim Sawmiller 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.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: Steve Orr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-
RE: Re[2]: Couple of questions
I'd even give latitude to someone who might not know everything, but who has a basic understanding and will logically and carefully research a problem as opposed to hacking away at it until he/she figures it out. [EMAIL PROTECTED] 03/22/01 12:13PM Gosh I keep mine hush-hush. It is at the very bottom of my resume... Yes I have it but so what? I didn't claim to know a whole lot about backup and recovery until a couple of months ago when I actually had resources and time to PRACTICE. Yes, Gene, you read it right... Lisa don't know JACK! And now I have to learn SA stuff. YUCK Lots of good that OCP does me with that... -Original Message- Sent: Thursday, March 22, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Someone coming into where I work with only their OCP as their claim to fame will most likely not get an interview whereas someone with a number of years Oracle experience will. We were pretty badly burned in the recent past by someone who had their OCP as their sole claim to fame. This particular individual tried, but failed, to lord that certificate over everyone else. He lasted a year two years later we're still picking up the mess. Now an individual with experience and OCP, that's a horse of a different color. Dick Goulet Reply Separator Author: "Rahul Dandekar" [EMAIL PROTECTED] Date: 3/22/2001 8:01 AM Also for those who have Oracle certification how much database experience (Oracle in particular) did you have before you obtained certification? What do you recommend for experience before attempting certification? OCP and Good Oracle DBA are not one of the same things. There might be people who are both. But... OCP does not necessarily mean Good DBA Good DBA, without any exam oriented preparation would not pass OCP so easily. I have heard that ILT notes and STS tests are simplest things to become "Paper OCP" even if you donot have Oracle expertise! I am persuing OCP, Just because after completing it I can commandingly say that OCP is NOT a great achievement. -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar 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: Tim Sawmiller 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: DBA Job at a Chocolate Factory
Well, I spent four days at Rudolph Foods in Lima, Ohio, where they make pork rinds. You could smell the stuff everywhere, and the floors were permanently slippery because of the grease buildup, even though they were mopped twice a day. Gross... [EMAIL PROTECTED] 03/21/01 11:06AM Seven years ago I was offered an Oracle DBA job at a chocolate factory and turned it down. (Please don't tell Rachel, she already thinks I'm crazy.) I had two simultaneous offers for the same salary and took the one closer to home. While on the interview they gave me the full tour of the factory starting with the bags of cocoa beans on the docks. The smell was intoxicating and even wafted into the office area where I would have worked. They had unlimited stashes of chocolate in every cubicle. I asked the employees if they ever got sick of chocolate and the answer was a resounding NO. Now my kids will never forgive me for not having taken the job at the chocolate factory. This begs the question... Where and what are some of the most interesting Oracle DBA jobs out there? I heard of one deep underground at a mining operation in the middle of the Nevada desert. Database is a basic technology that can be applied to just about any business anywhere. Any interesting stories? Personal experiences? Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr 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: Tim Sawmiller 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: Easy Doubt in sql/plus
or this messy way: select column1 || chr(10) || column2 || chr(10) || column3 || chr(10 . || column99 / chr(10) is a return command [EMAIL PROTECTED] 03/21/01 01:20PM With subqueries. Regards. -Mensaje original- De: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]] Enviado el: mircoles 21 de marzo de 2001 19:03 Para: Multiple recipients of list ORACLE-L Asunto: Easy Doubt in sql/plus Hi Friends : How can I do for put each column in new line using sql/plus Example : Select * from tab; and the result sould be : 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' and not 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' Thanks Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo do Carmo Andrietta 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: Trassens, Christian 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: Tim Sawmiller 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-24371
oerr ora 24371 24371, 0, "data would not fit in current prefetch buffer" // *Cause: An internal OCI error has occurred. // *Action: Please contact Oracle customer support. [EMAIL PROTECTED] 03/13/01 05:15PM Hi Gang, One of the developers came to me with this error. There is nothing in the alert log or no trace files were generated. I'm at a complete loss. He was executing a query from a front-end API. This is running on 8.1.6, Solaris 8 on a Sun 450. TIA, -Rocky __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch 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: Tim Sawmiller 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).
Connecting from VAX/VMS to Remote Oracle Data Base
My client is trying to connect from an RDB database on a VAX/VMS machine to an Oracle database on an HP machine. Can this be done? How? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: quotes
Careful now...it's the only thing holding my stock position together... :-) [EMAIL PROTECTED] 03/13/01 09:27AM Isn't that utterly ridiculous. If you didn't call the 2nd server a "failover" server and just manually moved over the filesystems and net address, you wouldn't need a 2nd license! But if you automate the process with failover software, you do! The database and software are only ever going to be on one server at a time so what's the big deal? Oracle licensing has gotten so ridiculous that at our shop they've pretty much priced themselves out of the picture for all new databases. I suspect my managers aren't the only ones looking more seriously at SQL 2000 these days either. I'd look for Oracle to lose market share over the next 18 months. Not because SQL is better (it isn't), but the price performance ratio is much more acceptable. Dennis Taylor [EMAIL PROTECTED] wrote: Just got my oracle quote back. I had asked about backup servers and failover. To quote the salescritter, "In most cases where an environment requires a standby failover server, a license will be required..." Dennis Taylor The light at the end of the tunnel is the headlamp of an oncoming train. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor 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!? Yahoo! Auctions - Buy the things you want at great prices! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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-00922 on create table...
(504), m540VARCHAR2(504), m541VARCHAR2(504), m544VARCHAR2(504), m545VARCHAR2(504), m546VARCHAR2(504), m547VARCHAR2(504), m550VARCHAR2(504), m555VARCHAR2(504), m556VARCHAR2(504), m561VARCHAR2(504), m562VARCHAR2(504), m565VARCHAR2(504), m567VARCHAR2(504), m570VARCHAR2(504), m580VARCHAR2(504), m590VARCHAR2(504), m599VARCHAR2(504), m600_expVARCHAR2(1504), m610VARCHAR2(56), m611VARCHAR2(56), m630VARCHAR2(56), m650VARCHAR2(504), m651VARCHAR2(56), m651_expVARCHAR2(56), m653VARCHAR2(56), m655VARCHAR2(56), m690VARCHAR2(104), m691VARCHAR2(56), m692VARCHAR2(56), m693VARCHAR2(56), m694VARCHAR2(56), m695VARCHAR2(56), m700VARCHAR2(1504), m710VARCHAR2(1504), m711VARCHAR2(1504), m730VARCHAR2(104), m740VARCHAR2(104), m752VARCHAR2(200), m760VARCHAR2(104), m762VARCHAR2(104), m765VARCHAR2(104), m767VARCHAR2(104), m770VARCHAR2(104), m772VARCHAR2(504), m775VARCHAR2(200), m776VARCHAR2(200), m777VARCHAR2(104), m780VARCHAR2(104), m785VARCHAR2(104), m787VARCHAR2(504), m800VARCHAR2(504), m810VARCHAR2(104), m811VARCHAR2(104), m830VARCHAR2(104), m840VARCHAR2(104), m856VARCHAR2(1504), m870VARCHAR2(104), m871VARCHAR2(104), m872VARCHAR2(104), m873VARCHAR2(104), m936VARCHAR2(104), medium VARCHAR2(32), mtype VARCHAR2(32), ne3 VARCHAR2(32), ne4 VARCHAR2(32), ne5 VARCHAR2(32), nissVARCHAR2(32), notes VARCHAR2(2000), oclcVARCHAR2(32), pred_cycle VARCHAR2(32), pred_cycle_nm VARCHAR2(32), pub VARCHAR2(1504), ref VARCHAR2(504), rev_dt VARCHAR2(32), rev_uid VARCHAR2(32), sec_cd VARCHAR2(32), series VARCHAR2(1504), ser_typeVARCHAR2(32), subjVARCHAR2(1504), ti VARCHAR2(1504), titles VARCHAR2(504), vol_enum_type VARCHAR2(32), week_month VARCHAR2(32), week_year VARCHAR2(56), yearVARCHAR2(32) ) / commit; Where's my error? __ Pat Gorden-Ozgul BNL-ISD Systems [EMAIL PROTECTED] 631-344-5159 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gorden-Ozgul, Patricia E 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: Tim Sawmiller 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: Max Extents Error
Check the maxextents value assigned to the table: select max_extents from dba_tables where table_name = 'your_table_name'; Next, see how many extents the table is actually using: select count(*) from dba_extents where table_name = 'your_table_name'; I'll bet the numbers are equal. If so: Alter your_table_name storage(maxextents 999); where 999 is equal to a number larger than that obtained in the earlier scripts._ [EMAIL PROTECTED] 03/08/01 02:00PM Hi, I have a table which consists of Long Raw column in addition to other columns of Number and Varchar2 datatypes. I have the datafile size set to 2GB. The average length of the messages goes up to 100M, sometimes more than that. I have now added three datafiles to that tablespace each greater than the first datafile. But I still keep getting the ORA-01631 Max extents reached for table "A" error. What do I do resolve this error? I am using 8K as the DB block size on SOlaris with Oracle 816. It is not a prod environment instead a dev environment. Thanks Sanjay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: exporting MDSYS schema from an Oracle Apps 11i database?
Somewhere in the rdbms stuff (I can't remember where anymore) there should be a script to create MDSYS and ORDSYS. These should be used instead of exp/imp. [EMAIL PROTECTED] 03/05/01 06:46PM -Original Message- From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] Sent: lundi, 5. mars 2001 11:51 I know that there is an MDSYS schema (see results of SQL below) but export says About to export specified users ... EXP-00010: MDSYS is not a valid username FYI to the list: I found out why the export was unsuccessful. In "catexp.sql" I see the following condition: "u$.name not in ('ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS')" Does anyone know if MDSYS is in fact the Oracle 8i Spatial functions user and/or how I could create that user and its objects in an Oracle 8i database (said database being created to server as an Oracle Apps 11i repository)? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: [Q] why sequence number jump?
Or, just say, "So what"? [EMAIL PROTECTED] 03/06/01 03:13PM do ALTER SEQUENCE xxx nocache; -Original Message- Sent: Tuesday, March 06, 2001 2:35 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] We have ORACLE 8.1.6 on UNIX server. The database has been run 4 years no sequence number probem. Recently, user complaint on couple of sequence nuber jump rapidly. The sequence number jump may 20, 40 or 100. I know I can use "alter sequence XXX nocahe" to avoid this problem. I want know why it jump? Thanks. Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov 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: Tim Sawmiller 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: Rollback segment
Then everybody will use the one that's left. [EMAIL PROTECTED] 03/02/01 11:45PM Hi, Anyone have idea, how Oracle8i make used of multiple rollback segments to reduce system contention? I am currently using 4 rollback segments what will happen if 3 of them are offline? :( Thanxs, -- 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: Tim Sawmiller 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: 2/28/01 - PL/SQL Syntax Request
How about: update table_name set col5 = decode(string1,string2,'PH',string3 'CZ',). ,col6 = decode(string4,string5,'STA',string6, 'REF',) ,col7 =etc ,col8 =etc string1 and string4, etc could be the concatentation of the four determinant columns, string 2,3,5,6, etc would be the determining values. [EMAIL PROTECTED] 02/28/01 11:41AM I need help. I'm sorry if this is a cross-posting for you. I'd like to see some example PL/SQL code, perhaps a procedure, that will pass through each record of a table, test for combinations of column values and based upon a specific value (which would be determined by an IF... THEN... matrix), set a variable. The value stored in this variable would then be used to update a different column of the very same table from which the original record was read. The matrix: (IF) (THEN) Key A M C one two three four five CA IND 1 1 CZ STA OFF BOO AD CA IND 3 1 CZ STA OFF REP AD CA IND 1 4 CZ STA OFF AV AD ... PH IND 1 1 PH STA OFF BOO PO PH OUT 1 1 PH REF NULL RBO PO ... ... The data table IN (before processing): Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9 CA IND 31 CA IND 31 PH IND 11 CA IND 14 PH OUT 11 CA IND 31 ... ... The data table OUT (after processing): Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9 CA IND 31 CZ STA OFF REP AD CA IND 31 CZ STA OFF REP AD PH IND 11 PH STA OFF BOO PO CA IND 14 CZ STA OFF AV AD PH OUT 11 PH REF NULL RBO PO CA IND 31 CZ STA OFF REP AD ... ... I'm looking for the PL/SQL code syntax to perform a task such as this. Wow. That was a mouthful. Good discipline. Any and all help will be appreciated. __ Pat Gorden-Ozgul BNL-ISD Systems [EMAIL PROTECTED] 631-344-5159 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gorden-Ozgul, Patricia E 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: Tim Sawmiller 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: confused about # of extents per segment performance issue
This really depends on the type of access. If it's random using indexes, the extents don't matter much. If you do a lot of full table scans, and the extents are scattered all over, there may be a performance degradation. YMMV as always. [EMAIL PROTECTED] 02/27/01 01:06PM Apparently, it's a widely held myth that a large # of extents (let's say "BETWEEN 5 AND 1000") per table segment is bad for performance. Yet the same sources who label the belief mistaken persist in pushing for fitting all of a table in the INITIAL extent. And that confuses the heck out of me. What gives? Is it that fetching a new extent on the fly, the act of obtaining a new extent, creates too much overhead? And finis, no more concern beyond this? If you approached a database for the first time and it already contained a segment with 500 extents, would that segment's number of extents not be a performance concern unless you expected it to continue grabbing new extents? Let's say it would never have a new insert, update, or delete. Would there be any performance value in crushing the segment down to fit in one extent? What's the definitive answer on this? I remain confused about coalescing as well; anyone know of a good whitepaper or article on coalescing/fragmentation for Oracle 8 and beyond? Thanks. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana mn 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: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What is limit on Search Condition in DBA_CONSTRAINTS table
Try "set long 2000". [EMAIL PROTECTED] 02/23/01 09:01AM One of our developers is wondering why they can't see all of their check constraint options when they query from DBA_CONSTRAINTS, USER_CONSTRAINTS, ALL_CONSTRAINTS. The Search Condition column only shows about 60 characters, no matter what you set your output string to in SQL*Plus. How can we see the rest of the Search Condition? Is there an underlying table that this view is based on? Cherie Machler 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: Tim Sawmiller 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: Designer Error Message - What's wrong?
Where are you importing from, a previous version of designer? It sounds like the export did not include an application/container that is referenced by an object in the stuff you exported. Check the source apps/containers for the MASTER entity and see if there are references to/from it from other apps/containers. [EMAIL PROTECTED] 02/21/01 10:27AM Hi Gurus ! I have an empty workarea and I want to import into it, but is always says the following error: Message --- CDR-01062: Compilation leaves Entity MASTER orphaned. Need to include container Cause - Compilation of the workarea would leave the specified checked out or non-versioned object without its context container. Action -- The workarea specification should be altered to include an appropriate version of the context container into the compiled workarea. What should I do? There's no entity called MASTER in the dump file to export. Thanks in advance. Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: metalink
Actually it runs on a bunch of Commodore 64s. :-) [EMAIL PROTECTED] 02/21/01 09:45AM does anybody know what exactly MetaBlink runs on? last I heard it was clustered 6500's with 6 G of RAM. I actually called client relations to let me know, and they have not returned the call. Sun is good stuff, but the site has been truly flakey for a major corporation's flagship support center. shrug -Original Message- Sent: Wednesday, February 21, 2001 9:21 AM To: Multiple recipients of list ORACLE-L I was trying to use MetaLink yesterday morning (east coast USA) was getting an authorization error. I called OTS customer service who verified they were having a problem. Wonder if some duhveleper got a fat finger in the wrong place. Dick Goulet Reply Separator Author: "Kevin Kostyszyn" [EMAIL PROTECTED] Date: 2/20/2001 12:00 PM Hi all, Is anyone else having problems with metalink today or is it just my network? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Tim Sawmiller 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).