Re: Rman ... what do YOU need
Hi I think it was mentioned already, But case studies with real working examples (maybe include the scripts for demo environment) usually make things a lot more clear than plain text and syntax diagrams. Jack "Freeman, Robert "To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Rman ... what do YOU need Sent by: [EMAIL PROTECTED] 09-04-2002 19:53 Please respond to ORACLE-L I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, April 08, 2002 2:54 PM To: Multiple recipients of list ORACLE-L I don't think you can do it.. I mean, you could change it to trunc the oracle_date field (that eliminates the minutes) and then do a to_date of :b1 but you will still be operating on the oracle_date field. Okay, I HATE to suggest this, but since the table is small: add another field to the table oracle_date_2 as a date field. Update the table set oracle_date_2=trunc(oracle_date) add a trigger to fill in oracle_date_2 when you insert a row or update the oracle_date column create an index on oracle_date_2 and change the query to use that column --- [EMAIL PROTECTED] wrote: > > I've got the following SQL statement that is running very long on a > nightly > data load. The problem is the TO_CHAR function which is preventing > me from using the index on this small (20,000-row table). > > This is an 8.0.4 database so it is not possible for me to use > make this a function-based index. > > The problem is that the date field has minutes, etc. included and > those need to be eliminated before the comparison can be made. > That's why I can't just eliminate the TO_CHAR from both sides > of the equation. > > Isn't there a way that I can pull this function out of the select > statement > and do it in a preceeding statement? Then I could just pass in both > variables to this statement without the TO_CHAR and use my index. > > Is this realistic? How, exactly could it be done? > > > SELECT DATE_KEY > FROM DATE_DIM > WHERE TO_CHAR(ORACLE_DATE,'DD-MON-') = > TO_CHAR(:b1,'DD-MON-') > > > SQL> desc date_dim; > NameNull?Type > --- > DATE_KEYNOT NULL NUMBER(5) > ORACLE_DATE NOT NULL DATE > DATACOM_DATE NUMBER(6) > DATACOM_REVERSE_DATE NUMBER(6) > DAY_OF_WEEK NOT NULL VARCHAR2(30) > DAY_NUMBER_IN_MONTH NOT NULL NUMBER(3) > DAY_NUMBER_OVERALL NOT NULL NUMBER(9) > WEEK_NUMBER_IN_YEAR NOT NULL NUMBER(3) > WEEK_NUMBER_OVERALL NOT NULL NUMBER(7) > MONTH NOT NULL VARCHAR2(30) > MONTH_NUMBER_OVERALLNOT NULL NUMBER(7) > YEARNOT NULL NUMBER(5) > WEEKDAY_IND NOT NULL CHAR(1) > LAST_DAY_IN_MONTH_IND NOT NULL CHAR(1) > DATA_WAREHOUSE_MOD_DATETIME NOT NULL DATE > DATA_MART_MOD_DATETIME NOT NULL DATE > > > > SQL> select oracle_date from
RE: collecting statistics
U can user sqlrowcount. This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. Visit us @ www.ssiworldwide.com
collecting statistics
Hi, I have a table in which inserts/updates or deletes are taking place very frequently( in the order of 1/sec) , Now I want to have the information on how many inserts or updates or deletes took place in the table. I might ask for a query like how many inserts took place on a specific date or for a date range. I know that I can use triggers to collect this information. But is it advisable to use triggers on a table where there are frequent operations. If not what is the other alternative ? Prem
LMT's or DMT's
Hi, I know this topic has been done to death, but I've only just migrated to 8.1.7 from 8.0.6 and am looking into LMT's vs DMT's. Do listers reccomend migrating all tablespaces (other than system) or should I do my temp tablespace only?? What is the general thought out there? Also, is the "dbms_space_admin.tablespace_migrate_to_local()" package "reliable" or is there anything that I should be aware of??? Thanks Sujatha --- Sujatha Madan Database Administrator Custom Management Centre Optus Business Operations 'yes' OPTUS PH # +61 2 9775 5316 Mobile # +61 402 354 347 FAX # +61 2 9775 5360 Email [EMAIL PROTECTED] WEB http://www.optusbusiness.com.au/ --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Favourite Urban Myth
Yes, but they have to be unable to reproduce. I agree that mostly as DBA I do not need the root access. As one pointed out earlier, it is required during install, but only in two places. If you had the SA there when you installed the software it wouldn't be a problem. Software istalls can usually be scheduled to work that way too. Rodd -Original Message- Kirti Sent: Tuesday, April 09, 2002 10:03 PM To: Multiple recipients of list ORACLE-L ... Is there a Darwin Award for the Living (DBA)? =;) - Kirti -- 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).
Test
Testing new email address. Testing new email address. Testing new email address. Testing new email address. Testing new email address. Testing new email address. Testing new email address. Testing new email address. Testing new email address. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Does index need rebuilding when table is truncated
Table need to be reanalyzed and with table - indexes. Alex Hillman > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > [EMAIL PROTECTED] > Sent: Tuesday, April 09, 2002 5:11 PM > To: Multiple recipients of list ORACLE-L > Subject: Does index need rebuilding when table is truncated > > > Hi All, > > I know if you delete lots of data using delete the indexes may need > rebuilding. Is this the case if the table is truncated? > > Thanks > Rick > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dbms_alert_info & locks
Hi All We have a Pro C daemon which does a DBMS_aLERT.'waitone' for a specific alert. From the database side applications do a signal to start the daemon. So we have a locking situation where we found out that the rows in sql area for two different users were the same UPDATE DBMS_ALERT_INFO SET CHANGED='Y',MESSAGE=:b1 WHERE NAME = UPPER(:b2) And when we queried the rowid which was locked by the users they were all waiting on this row select * from DBMS_ALERT_INFO where rowid= 'ZwAABVUAAB'; What is the reason for this to caused locks ? Thanks Alroy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alroy Mascranghe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: standby database problem ???
Janet, I have found that on NT a shutdown immediate can still lead to recovery being required when the database is started back up. That is, maybe you didn't really have a consistent cold backup of your primary. I have instead opted for a shutdown immediate, startup, shutdown normal sequence to ensure the database is consistent. Have a look at the alert log of your primary and see if when you started it back up after the "cold" backup it contained a line like "alter database open Beginning crash recovery of 1 threads" That is, did a crash recovery follow the database being opened. HTH, Bruce Reardon -Original Message- Sent: Wednesday, 10 April 2002 12:58 Hi, I created a primary and a standby database. Both are 9i on Win2000, the same host. Everything was fine, except the last step: SQL> RECOVER MANAGED STANDBY DATABASE TIMEOUT 20; ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'C:\ORA_9I\ORADATA\SB1\DATAFILE\SYSTEM01.DBF' ORA-16016: archived log for thread 1 sequence# 7 unavailable I backed up the primary database when the archive was not on. I shutdown the db using shutdown immediate, and made a complete, cold back, I changed the primary database to archive log right after backup. Why the backup is not sufficient? Must the db in archivelog mode before making a backup? Thank you! Janet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ang: RE: Pl/sql question - if statement
Roland, What ever happened to the Access list you were trying to find? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Ang: RE: Pl/sql question - if statement om 04/09/2002 11:48 AM Please respond to ORACLE-L Yes but then it fails onthe word borttags_flagg, thi serrormessage : PLS-00103: Encountered the symbol "BORTTAGS_FLAGG" when expecting one of the following: . ( * @ % & = - + < / > at in mod not rem then <> or != or ~= >= <= <> and or like I reallydont see what the error is: Roland "John Hallas" <[EMAIL PROTECTED]>@fatcity.com den 2002-04-09 07:58 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: Don't you need to start of with a quote before the first A If 'A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 '' John -Original Message- [EMAIL PROTECTED] Sent: 09 April 2002 15:43 To: Multiple recipients of list ORACLE-L anyone whom can tell me why this statement fails in a pl/sqll code: I get this error message PLS-00103: Encountered the symbol "||AvdNr||" when expecting one of the following: . ( * @ % & = - + < / > at in mod not rem then <> or != or ~= >= <= <> and or like betwe when i run this statement If A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 '' then lvSQL := 'SELECT ICA_ARTIKEL.FSGPRIS,ICA_ARTIKEL.PANTBELOPP ' || --PBK.LPKORGEANREL.EANREL,PBK.LPK ORGEANREL.VARUTYP ' || 'FROM A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| ' ' || --PBK.LPKORGEANREL ' || 'WHERE ICA_ARTIKEL.EAN=' || EanLPVara || ' ' || 'AND ICA_ARTIKEL.DATUMhttp://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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 yourse
Parameters Question
Hi again, folks! Can someone please define: Named Parameter Actual Parameter I have an idea that "Named Parameter" is a system-provided parameter, but I want to make sure, and be clear on the difference from Actual Parameter. Thanks in advance!!! Cheers, JoJo
RE: Favourite Urban Myth
We had one dba who (by mistake) issued a 'chown -R oracle:dba' followed by 'chmod -R 750 *' from the '/' directory while logged in as root. Fortunately, it was a server with no production databases on it, just a couple of Development databases. She never new what a '#' prompt was. She is long gone but such memories linger for ever ;) It took a while for the SA's to let Oracle DBAs get root privileges after that episode. And in my previous job, I had a junior DBA who tried to kill a background job (%1) with 'kill -9' as root. The problem was, he forgot to put in '%' before the '1' and then came to me stating that the Server does not respond anymore :( while I was talking to the Customer who had beaten him to place a trouble call about 'the database just hung-up'. Is there a Darwin Award for the Living (DBA)? =;) - Kirti -Original Message- Sent: Thursday, April 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L I try NOT to get root privs. I know just enough to really damage the server and OS, but not enough to do much that is useful --- "Koivu, Lisa" <[EMAIL PROTECTED]> wrote: > Heck I don't WANT root privs... I would rather have an experienced > SA to > help me with the OS. Working as a team with a skilled SA is much > more > preferable than doing it all yourself. Also, having someone else > there > when the sh*t has hit the fan to work through the problem with you > and > possibly provide another point of view is calming and helpful. > > Just my 2 cents > > Lisa Koivu > Oracle Database TANK > Fairfield Resorts, Inc. > 954-935-4117 > > > > -Original Message- > > From: Dave Morgan [SMTP:[EMAIL PROTECTED]] > > Sent: Thursday, April 04, 2002 11:19 AM > > To: Multiple recipients of list ORACLE-L > > Subject:Favourite Urban Myth > > > > The DBA needs root privileges on the server> > > > > This is one of my interview questions. > > > > Dave > > > > -- > > Dave Morgan > > DBA, Cybersurf > > Office: 403 777 2000 ext 284 > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Dave Morgan > > INET: [EMAIL PROTECTED] > > -- 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).
standby database problem ???
Hi, I created a primary and a standby database. Both are 9i on Win2000, the same host. Everything was fine, except the last step: SQL> RECOVER MANAGED STANDBY DATABASE TIMEOUT 20; ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'C:\ORA_9I\ORADATA\SB1\DATAFILE\SYSTEM01.DBF' ORA-16016: archived log for thread 1 sequence# 7 unavailable I backed up the primary database when the archive was not on. I shutdown the db using shutdown immediate, and made a complete, cold back, I changed the primary database to archive log right after backup. Why the backup is not sufficient? Must the db in archivelog mode before making a backup? Thank you! Janet __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Question about Forms Version
I have both running on a laptop here the only thing that will happen is that Developer uses its own net8 client and as such sets the Oracle HOME to teh home you install Dev 6i in. You most likely will want to install a copy of your tnsnames in your Develop home. If you have the Home selector installed you will need to set the default home for the system back to the 8i home, other than that it seems to work OK Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom "The People, The Experience, The Vision" = JoJo Zawawi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/04/2002 10:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Fax to: Subject:Re: Question about Forms Version Hi Peter, Thanks a lot for the book recommendations. I have another question: I have Oracle 8i on an NT box. I just downloaded "Oracle Forms Developer 6i Release 2 for NT" (which has as part of it, "Oracle 9iAS Forms Services for NT"). Can I install it on that same NT box, or is it going to mess up my Oracle 8i? (I couldn't find any earlier versions of Forms Developer on Oracle's site.) Thanks again, JoJo - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 5:38 PM Hi You can try two books for learning Oracle Developer Advanced Forms and Reports by Dorsey and Koletzke I also have another one that Uni is using for a subject on Developer Enhanced Guide to Oracle 8i, Morrison & Morrison both have supporting websites and Peter Koletzke hangs out on the ODTUG Dev2k list http://ourworld.compuserve.com/homepages/Peter_Koletzke/ HTH Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom "The People, The Experience, The Vision" = JoJo Zawawi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/04/2002 09:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Fax to: Subject:Re: Question about Forms Version Thanks. So the most recent version of Forms is called 6i, is this correct? Can anyone recommend a good book for this? I appreciate all suggestions. Also, if I study a 4.5 book, would that work out alright? Thanks in advance, JoJo - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 09, 2002 4:43 PM Perhaps you're referring to Developer/2000? If so, that name was first used with Forms 4.5. I believe it was also used for Forms 5.0, but dropped after that. Marc Perkowitz Senior Consultant TWJ Consulting, LLP - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 09, 2002 5:22 PM Hi folks, Is Oracle Forms 6i the same as Oracle Forms 2000 ? Thanks!, JoJo -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JoJo Zawawi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). STG29483 Description: Binary data
Re: Question about Forms Version
Hi Peter, Thanks a lot for the book recommendations. I have another question: I have Oracle 8i on an NT box. I just downloaded "Oracle Forms Developer 6i Release 2 for NT" (which has as part of it, "Oracle 9iAS Forms Services for NT"). Can I install it on that same NT box, or is it going to mess up my Oracle 8i? (I couldn't find any earlier versions of Forms Developer on Oracle's site.) Thanks again, JoJo - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 5:38 PM Hi You can try two books for learning Oracle Developer Advanced Forms and Reports by Dorsey and Koletzke I also have another one that Uni is using for a subject on Developer Enhanced Guide to Oracle 8i, Morrison & Morrison both have supporting websites and Peter Koletzke hangs out on the ODTUG Dev2k list http://ourworld.compuserve.com/homepages/Peter_Koletzke/ HTH Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom "The People, The Experience, The Vision" = JoJo Zawawi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/04/2002 09:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Fax to: Subject:Re: Question about Forms Version Thanks. So the most recent version of Forms is called 6i, is this correct? Can anyone recommend a good book for this? I appreciate all suggestions. Also, if I study a 4.5 book, would that work out alright? Thanks in advance, JoJo - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 09, 2002 4:43 PM Perhaps you're referring to Developer/2000? If so, that name was first used with Forms 4.5. I believe it was also used for Forms 5.0, but dropped after that. Marc Perkowitz Senior Consultant TWJ Consulting, LLP - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 09, 2002 5:22 PM Hi folks, Is Oracle Forms 6i the same as Oracle Forms 2000 ? Thanks!, JoJo -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JoJo Zawawi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i SE vs EE and options
Faster then the database running on Windows:-) -Original Message- Robert Sent: Tuesday, April 09, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Yea, but just how fast would that used car lookup, sort and group 2 TB of data? :-) RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, April 09, 2002 1:13 PM To: Multiple recipients of list ORACLE-L Dennis is right. We had to pay extra for partitioning, on top of EE. What a lovely day it was. The total (to run on a wimpy w2k machine, named user) could have bought me a new car. Lisa Koivu Oracle Database Dog Catcher Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 12:28 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle 9i SE vs EE and options > > Ron - My interpretation, based on Oracle Partitioning, is that "Option" > means that you need Enterprise Edition and you must pay extra on top of > that. Thanks for passing this along. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, April 09, 2002 10:23 AM > To: Multiple recipients of list ORACLE-L > > > List, > If I read this chart correctly it displays what is provided with the > Standard Edition and the Enterprise Edition. The Option column is what > is extra and you pay for it??? Am I correct in what I read about the > option column. > > http://www.oracle.com/ip/deploy/database/oracle9i/index.html?packagingando > pt > ions.html > > > If this is true it is nice to see it finally displayed rather than > double talk from a salesman. > Ron > 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: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the mess
Re: Question about Forms Version
Hi You can try two books for learning Oracle Developer Advanced Forms and Reports by Dorsey and Koletzke I also have another one that Uni is using for a subject on Developer Enhanced Guide to Oracle 8i, Morrison & Morrison both have supporting websites and Peter Koletzke hangs out on the ODTUG Dev2k list http://ourworld.compuserve.com/homepages/Peter_Koletzke/ HTH Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom "The People, The Experience, The Vision" = JoJo Zawawi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/04/2002 09:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Fax to: Subject:Re: Question about Forms Version Thanks. So the most recent version of Forms is called 6i, is this correct? Can anyone recommend a good book for this? I appreciate all suggestions. Also, if I study a 4.5 book, would that work out alright? Thanks in advance, JoJo - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 09, 2002 4:43 PM Perhaps you're referring to Developer/2000? If so, that name was first used with Forms 4.5. I believe it was also used for Forms 5.0, but dropped after that. Marc Perkowitz Senior Consultant TWJ Consulting, LLP - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 09, 2002 5:22 PM Hi folks, Is Oracle Forms 6i the same as Oracle Forms 2000 ? Thanks!, JoJo -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. STG26619 Description: Binary data
Re: Question about Forms Version
Thanks. So the most recent version of Forms is called 6i, is this correct? Can anyone recommend a good book for this? I appreciate all suggestions. Also, if I study a 4.5 book, would that work out alright? Thanks in advance, JoJo - Original Message - From: Marc Perkowitz To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 09, 2002 4:43 PM Subject: Re: Question about Forms Version Perhaps you're referring to Developer/2000? If so, that name was first used with Forms 4.5. I believe it was also used for Forms 5.0, but dropped after that. Marc PerkowitzSenior ConsultantTWJ Consulting, LLP - Original Message - From: JoJo Zawawi To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 09, 2002 5:22 PM Subject: Question about Forms Version Hi folks, Is Oracle Forms 6i the same as Oracle Forms 2000 ? Thanks!, JoJo
RE: Rman ... what do YOU need
I'm currently struggling with the MML & Veritas NetBackup. What I'd like is cohesive definition and examples showing use of the views (v$backup_sync_io and v$backup_async_io) that are there to supposedly let me know if the tape is streaming, and to compare throughput from the point of view of RMAN with theoretical throughput for both the tape devices and the disk devices. I'm using asynchronous IO, slaved IO processes and multiple channels to tape in an attempt to get a data warehouse backed up in a reasonable time. This takes a great deal of large pool memory, which I'd like to override at times (e.g. when running a job that should give a small amount of output, it'd be nice to be able to override the large pool use, sort of like forcing a dedicated server with sqlnet.ora from the client when connecting to an MTS listener.) Some indication of the balancing act between backup times and recovery times would also be good. So I guess the ideas boil down to this: o how to tell if you're getting the most from your RMAN config o how to plan resources for optimal use by RMAN o balancing time-to-backup with time-to-recovery Hope this helps... Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dedicated server
List, I have a problem for shutdown one of the instances, got error OAR-00106 I was looking for the solution on the net, they recommened connect as internal without using the string connection( I beleive it means service name) but if you have more than one instance how can connect internal to a dedicated server, or how can I make a connection to database as dedicated server? Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Explain: In List Iterator
Wow. Can't believe I didn't see that. She's grabbing every transient customer (cgrno is the customer type), and is not matching any other criteria. This list never ceases to amaze me . . . Thanks. Barb > -- > From: Freeman, Robert [SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Tuesday, April 09, 2002 4:13 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Explain: In List Iterator > > Uh I'm just wondering about the customer table there... anything look > odd about the use of that table in this query or am I missing something > there? > > RF > > -Original Message- > Sent: Tuesday, April 09, 2002 5:44 PM > To: Multiple recipients of list ORACLE-L > > > OMG I thought we were looking at a canned-app query > > If it was my database, I would be turning the query upside down and > educating the developer in a not-so-gentle manner. But that's my style - > hormonal and direct. :) You are the better person if you can get through > to the developer without resorting to my curt type of "people skills" > > Post your tkprof, I am curious to see it. > > > -Original Message- > > From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, April 09, 2002 4:45 PM > > To: '[EMAIL PROTECTED]'; Koivu, Lisa > > Subject:RE: Explain: In List Iterator > > > > Thanks, Lisa! > > I have not tkprof'd it. I'm beginning to wonder if the thing will ever > > complete. > > I think I might instead suggest ever-so-gently to the developer that > this > > doesn't belong in the production database. > > > > (See, Dennis!! I'm becoming the kinder, gentler dba...) > > Barb > > > > > -- > > > From: Koivu, Lisa[SMTP:[EMAIL PROTECTED]] > > > Sent: Tuesday, April 09, 2002 2:42 PM > > > To: '[EMAIL PROTECTED]' > > > Cc: '[EMAIL PROTECTED]' > > > Subject: RE: Explain: In List Iterator > > > > > > Hi Barbara, > > > > > > I believe 'in list iterator' is the way the optimizer is handling one > of > > > your in () statements in your query. Beware in lists with a large > > number > > > of > > > values in the set... as expansion of these in lists can create an > > > incredibly > > > ugly OR'd query.Saw this once and gave it the no_expand hint - > > problem > > > solved. However I don't think that's the problem here - have you > > tkprof'd > > > it? > > > > > > This is one nasty query. Distinct, outer join, trunc on a date, > > cartesian > > > joins... yuck! > > > > > > Lisa Koivu > > > Oracle Database Tank > > > Fairfield Resorts, Inc. > > > 954-935-4117 > > > > > > > > > > -Original Message- > > > > From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] > > > > Sent: Tuesday, April 09, 2002 5:11 PM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject:Explain: In List Iterator > > > > > > > > Hi, list. > > > > I'm trying to find out what's eating my system. I found the query, > > and > > > > explain'ed it. I've never seen an "in list iterator" before. Can > > > anyone > > > > tell me what that is??? > > > > > > > > Thanks!! > > > > > > > > Barb > > > > > > > > Execution Plan > > > > -- > > > >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2398 Card=25814 > > > > Bytes=9964204) > > > >10 SORT (UNIQUE) (Cost=2398 Card=25814 Bytes=9964204) > > > >21 MERGE JOIN (CARTESIAN) (Cost=969 Card=25814 > > Bytes=9964204) > > > >32 NESTED LOOPS (OUTER) (Cost=1 Card=1 Bytes=380) > > > >43 NESTED LOOPS (Cost=8 Card=1 Bytes=324) > > > >54 INLIST ITERATOR (CONCATENATED) > > > >65 TABLE ACCESS (BY INDEX ROWID) OF 'AD' > (Cost=1590 > > > > Card=145 Bytes=20300) > > > >76 BITMAP CONVERSION (TO ROWIDS) > > > >87 BITMAP CONVERSION (FROM ROWIDS) > > > >98 INDEX (RANGE SCAN) OF 'I_AD2' > (NON-UNIQUE) > > > > 104 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1 > > > > Card=3600 > > > > Bytes=662400) > > > > 11 10 INDEX (UNIQUE SCAN) OF 'I_PUB1' (UNIQUE) > > > > 123 TABLE ACCESS (BY INDEX ROWID) OF 'INVROWS' (Cost=1 > > > > Card=627725 Bytes=35152600) > > > > 13 12 INDEX (RANGE SCAN) OF 'I_INVR1' (NON-UNIQUE) > (Cost > > > =1 > > > > Card=627725) > > > > 142 SORT (JOIN) (Cost=968 Card=25814 Bytes=154884) > > > > 15 14 TABLE ACCESS (FULL) OF 'CUSTOMER' (Cost=968 > > Card=25814 > > > > Bytes=154884) > > > > > > > > > > > > > > > > > > > > SELECT DISTINCT a.serieno, p.paper, p.adno, p.pubno, p.class, > p.xsize, > > > > p.ysize, > > > > p.state, trunc(p.mdate) mdate, p.vno, a.unet, trunc(a.rdate) rdate, > > > > trunc(a.startdate) startdate, trunc(a.enddate) enddate, a.ratecode, > > > > a.cus4name, > > > > a.cus2no, i.dcode, i.ino FROM arcdb.ad a, arcdb.pub p, arcdb.invrows > > i,
Re: Question about Forms Version
Perhaps you're referring to Developer/2000? If so, that name was first used with Forms 4.5. I believe it was also used for Forms 5.0, but dropped after that. Marc PerkowitzSenior ConsultantTWJ Consulting, LLP - Original Message - From: JoJo Zawawi To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 09, 2002 5:22 PM Subject: Question about Forms Version Hi folks, Is Oracle Forms 6i the same as Oracle Forms 2000 ? Thanks!, JoJo
RE: Does index need rebuilding when table is truncated
>> Oracle Database Tank Hmmm... so are they going to send you to Afghanistan or Iraq in that database tank Lisa? RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL Tuning - How to avoid TOCHAR function against a date
I am jumping in the middle of this thread so execuse me if I am repeating the past suggestions I haven't read yet. In a DW you'd have a date dim of dates only (no time component to date) and a time_dim (down to seconds). Your fact table should have a date_key and a time_key if both date and time components are significant. In that case your query SELECT DATE_KEY FROM DATE_DIM WHERE TO_CHAR(ORACLE_DATE,'DD-MON-') = TO_CHAR(:b1,'DD-MON-') would be transformed to: SELECT DATE_KEY FROM DATE_DIM WHERE ORACLE_DATE = TRUNC(:b1); You should perhaps update the oracle_date column in date_dim to TRUNC(oracle_date,'DD') and then rebuild the index on oracle_date column and run the above mentioned query. - Sundeep --- [EMAIL PROTECTED] wrote: > > Ron, > > That's an idea. Easy to implement and test. I'll > give it a try tonight > to see if it helps. > > It is a small table. > > Cherie > > > > > > "Ron Rogers" > > > Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > tery.org>cc: > > > Sent by: Subject: > RE: SQL Tuning - How to avoid TOCHAR function > against a date > [EMAIL PROTECTED] > > > om > > > > > > > > > 04/08/02 03:23 > > > PM > > > Please respond > > > to ORACLE-L > > > > > > > > > > > > > Tom, > I realize that there would not be an index but I > was trying to > eliminate some overhead by using the TRUNC function > as compaired to the > to_char for the fields. > Cherie, > If the table is not to large how about pinning it > to save on disk > reads? > Ron > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 04/08/02 03:35PM >>> > Ron, > > the TRUNC function will also prevent the use of an > index on the > oracle_date > column. > > Tom Mercadante > Oracle Certified Professional > > > -Original Message- > Sent: Monday, April 08, 2002 2:54 PM > To: Multiple recipients of list ORACLE-L > > > Cherie, > How about using the TRUNC function on the date > field. That will use > only thre ,MM,DD of the ORACLE_DATE column. Then > you will be > comparing like columns without going through the > to_char conversion. > WHERE TRUNC(ORACLE_DATE) = TRUNC(:b1) > Ron > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 04/08/02 01:56PM >>> > > I've got the following SQL statement that is running > very long on a > nightly > data load. The problem is the TO_CHAR function > which is preventing > me from using the index on this small (20,000-row > table). > > This is an 8.0.4 database so it is not possible for > me to use > make this a function-based index. > > The problem is that the date field has minutes, etc. > included and > those need to be eliminated before the comparison > can be made. > That's why I can't just eliminate the TO_CHAR from > both sides > of the equation. > > Isn't there a way that I can pull this function out > of the select > statement > and do it in a preceeding statement? Then I could > just pass in both > variables to this statement without the TO_CHAR and > use my index. > > Is this realistic? How, exactly could it be done? > > > SELECT DATE_KEY > FROM DATE_DIM > WHERE TO_CHAR(ORACLE_DATE,'DD-MON-') = > TO_CHAR(:b1,'DD-MON-') > > > SQL> desc date_dim; > NameNull?Type > --- > DATE_KEYNOT NULL NUMBER(5) > ORACLE_DATE NOT NULL DATE > DATACOM_DATE NUMBER(6) > DATACOM_REVERSE_DATE NUMBER(6) > DAY_OF_WEEK NOT NU
Question about Forms Version
Hi folks, Is Oracle Forms 6i the same as Oracle Forms 2000 ? Thanks!, JoJo
RE: SQL : where clause to include data for the previous 24 hours
how about sysdate -1 that will give you exact 24 hours up to the second?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
RE: Does index need rebuilding when table is truncated
I'm not sure. My gut says yes... because there's nothing left in the table, why should there be anything "left" in the index in the way of storage... but I don't know for sure. May be a fun thing to play with. (Wow, I need to get out more) List? Someone has to know this. LK, DBT > -Original Message- > From: Sherman, Paul R. [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 5:52 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Does index need rebuilding when table is truncated > > Hello, > > Lisa, what I was wondering when I read Rick's e-mail was... what about the > HWM for the indexes when someone truncates a table. The table's HWM > pointer > gets reset of course, but I can never recall seeing anything about what > happens to the index space. > > Thank you, > > Paul Sherman > DBA > voice - 781-501-4143 (office) > fax- 781-278-8341 (office) > email - [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, April 09, 2002 5:33 PM > To: Multiple recipients of list ORACLE-L > > > Hi Rick, > > Nope. Try it. You'll see that the extents clear up just like the extents > in the table do, if you don't specify the REUSE STORAGE clause. > > Lisa Koivu > Oracle Database Tank > Fairfield Resorts, Inc. > 954-935-4117 > > > > -Original Message- > > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, April 09, 2002 5:11 PM > > To: Multiple recipients of list ORACLE-L > > Subject:Does index need rebuilding when table is truncated > > > > Hi All, > > > > I know if you delete lots of data using delete the indexes may need > > rebuilding. Is this the case if the table is truncated? > > > > Thanks > > Rick > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Koivu, Lisa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sherman, Paul R. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Does index need rebuilding when table is truncated
There is not a HWM indicator for an index as there is for a table. When a truncate occurs, the blocks are cleared in the index and the extents (beyond the initial extent) are deallocated (assuming you do not issue the reuse storage clause). RF -Original Message- Sent: Tuesday, April 09, 2002 5:52 PM To: Multiple recipients of list ORACLE-L Hello, Lisa, what I was wondering when I read Rick's e-mail was... what about the HWM for the indexes when someone truncates a table. The table's HWM pointer gets reset of course, but I can never recall seeing anything about what happens to the index space. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 5:33 PM To: Multiple recipients of list ORACLE-L Hi Rick, Nope. Try it. You'll see that the extents clear up just like the extents in the table do, if you don't specify the REUSE STORAGE clause. Lisa Koivu Oracle Database Tank Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 5:11 PM > To: Multiple recipients of list ORACLE-L > Subject: Does index need rebuilding when table is truncated > > Hi All, > > I know if you delete lots of data using delete the indexes may need > rebuilding. Is this the case if the table is truncated? > > Thanks > Rick > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Differences between Oracle JDBC thin and thick drivers
This is my understanding as well. So if you wanted to use the thick driver, you would need to install SQL*Net on each of your clients. If your clients are all internal and already use SQL*Plus, for example, you should be all set. Otherwise you may have some difficulties with this option. Marc Perkowitz Senior Consultant TWJ Consulting, LLP - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 4:03 PM > Hi > > I believe the difference is that the OCI drivers use SQL*Net > or NET8 or whatever they call it now, whereas the thin driver > does not require SQL*Net on the client machine. > > Ben Poels > Sr. Technical Analyst > Queen's University > > -Original Message- > Avrami > Sent: Tuesday, April 09, 2002 4:29 PM > To: Multiple recipients of list ORACLE-L > > > > > Hello all, > > I have a question concerning the Oracle JDBC thin vs. thick drivers > and how they might affect operations from an application perspective. > > > We're in a Solais 8/Oracle 8.1.7.2 environment. We have several > applications on several servers connecting to the Oracle database. > > > For redundancy, we're looking into setting up TAF (transparent > application failover). Currently, some of our apps use the Oracle > JDBC thin drivers to talk to the database, with a connection > string that like this: > > jdbc:oracle:thin:@host:port:ORACLE_SID > > In a disaster recovery mode, where we would switch the database > from one server to another, the host name in the above string > would become invalid. That means we have to shut down our application > servers and restart them with an updated string. > > Using the Oracle OCI (thick) driver though, allows us to connect > to a Net8 service instead of a specific server: > > jdbc:oracle:oci8:@NET8_SERVICE_NAME > > Coupled with the FAILOVER=ON option configured in Net8, it is > then possible to direct a connection from the first server to > the failover database on another server. This is exactly what > we would like to do. > > My question is, from an application perspective, how is the Oracle > thick driver different from the thin driver? If everything > else is "equal" (i.e. the thick driver is compatible with the > app servers) would there be something within the the thick/OCI > driver that could limit functionality vs. the thin driver? > > My understand, which obviously is sketchy, is that the thick > driver is a superset of the thin driver. If this is the case, > and for example if all database connections were handled through > a configuration file with the above OCI connection string, then > theoretically the thick driver should work. > > If anyone has any info on this that they can share, it would > be greatly appreciated. > > Thanks, > Lou Avrami > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Louis Avrami > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ben Poels > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marc Perkowitz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Explain: In List Iterator
"Baker, Barbara" wrote: > > Hi, list. > I'm trying to find out what's eating my system. I found the query, and > explain'ed it. I've never seen an "in list iterator" before. Can anyone > tell me what that is??? > > Thanks!! > > Barb > > Execution Plan > -- >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2398 Card=25814 > Bytes=9964204) >10 SORT (UNIQUE) (Cost=2398 Card=25814 Bytes=9964204) >21 MERGE JOIN (CARTESIAN) (Cost=969 Card=25814 Bytes=9964204) >32 NESTED LOOPS (OUTER) (Cost=1 Card=1 Bytes=380) >43 NESTED LOOPS (Cost=8 Card=1 Bytes=324) >54 INLIST ITERATOR (CONCATENATED) >65 TABLE ACCESS (BY INDEX ROWID) OF 'AD' (Cost=1590 > Card=145 Bytes=20300) >76 BITMAP CONVERSION (TO ROWIDS) >87 BITMAP CONVERSION (FROM ROWIDS) >98 INDEX (RANGE SCAN) OF 'I_AD2' (NON-UNIQUE) > 104 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1 Card=3600 > Bytes=662400) > 11 10 INDEX (UNIQUE SCAN) OF 'I_PUB1' (UNIQUE) > 123 TABLE ACCESS (BY INDEX ROWID) OF 'INVROWS' (Cost=1 > Card=627725 Bytes=35152600) > 13 12 INDEX (RANGE SCAN) OF 'I_INVR1' (NON-UNIQUE) (Cost =1 > Card=627725) > 142 SORT (JOIN) (Cost=968 Card=25814 Bytes=154884) > 15 14 TABLE ACCESS (FULL) OF 'CUSTOMER' (Cost=968 Card=25814 > Bytes=154884) > > SELECT DISTINCT a.serieno, p.paper, p.adno, p.pubno, p.class, p.xsize, > p.ysize, > p.state, trunc(p.mdate) mdate, p.vno, a.unet, trunc(a.rdate) rdate, > trunc(a.startdate) startdate, trunc(a.enddate) enddate, a.ratecode, > a.cus4name, > a.cus2no, i.dcode, i.ino FROM arcdb.ad a, arcdb.pub p, arcdb.invrows i, > advdb.customer c WHERE p.adno = a.adno AND p.vno = a.vno AND p.adno = > i.adno(+) > AND p.vno = i.vno(+) AND p.pubno = i.pubno(+) AND a.serieno IN > (7,8,24,31,33,39,52,58,60,63,137,144,419,434,440,444,445,451,463) AND > p.paper = > 'DNA' AND p.state IN ('NOT', 'VAR') AND p.adno > 0 AND p.pubno = 1 AND > p.vnoflag > = 'Y'AND c.cgrno = 'TT' AND trunc(a.rdate) BETWEEN to_date('01-MAR-02', > 'DD-MON-YY') AND to_date('07-MAR-02', 'DD-MON-YY') > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- Iteration on your IN (blah, blah, blah ...). Let me guess, you have lots of customers? Step one : get rid of DISTINCT, either by adding the missing joind condition, or by having the relevant condition relegated to a AND EXISTS (blah blah). Then you'l be able to start the serious work. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Explain: In List Iterator
Uh I'm just wondering about the customer table there... anything look odd about the use of that table in this query or am I missing something there? RF -Original Message- Sent: Tuesday, April 09, 2002 5:44 PM To: Multiple recipients of list ORACLE-L OMG I thought we were looking at a canned-app query If it was my database, I would be turning the query upside down and educating the developer in a not-so-gentle manner. But that's my style - hormonal and direct. :) You are the better person if you can get through to the developer without resorting to my curt type of "people skills" Post your tkprof, I am curious to see it. > -Original Message- > From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 4:45 PM > To: '[EMAIL PROTECTED]'; Koivu, Lisa > Subject: RE: Explain: In List Iterator > > Thanks, Lisa! > I have not tkprof'd it. I'm beginning to wonder if the thing will ever > complete. > I think I might instead suggest ever-so-gently to the developer that this > doesn't belong in the production database. > > (See, Dennis!! I'm becoming the kinder, gentler dba...) > Barb > > > -- > > From: Koivu, Lisa[SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, April 09, 2002 2:42 PM > > To: '[EMAIL PROTECTED]' > > Cc: '[EMAIL PROTECTED]' > > Subject:RE: Explain: In List Iterator > > > > Hi Barbara, > > > > I believe 'in list iterator' is the way the optimizer is handling one of > > your in () statements in your query. Beware in lists with a large > number > > of > > values in the set... as expansion of these in lists can create an > > incredibly > > ugly OR'd query.Saw this once and gave it the no_expand hint - > problem > > solved. However I don't think that's the problem here - have you > tkprof'd > > it? > > > > This is one nasty query. Distinct, outer join, trunc on a date, > cartesian > > joins... yuck! > > > > Lisa Koivu > > Oracle Database Tank > > Fairfield Resorts, Inc. > > 954-935-4117 > > > > > > > -Original Message- > > > From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] > > > Sent: Tuesday, April 09, 2002 5:11 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Explain: In List Iterator > > > > > > Hi, list. > > > I'm trying to find out what's eating my system. I found the query, > and > > > explain'ed it. I've never seen an "in list iterator" before. Can > > anyone > > > tell me what that is??? > > > > > > Thanks!! > > > > > > Barb > > > > > > Execution Plan > > > -- > > >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2398 Card=25814 > > > Bytes=9964204) > > >10 SORT (UNIQUE) (Cost=2398 Card=25814 Bytes=9964204) > > >21 MERGE JOIN (CARTESIAN) (Cost=969 Card=25814 > Bytes=9964204) > > >32 NESTED LOOPS (OUTER) (Cost=1 Card=1 Bytes=380) > > >43 NESTED LOOPS (Cost=8 Card=1 Bytes=324) > > >54 INLIST ITERATOR (CONCATENATED) > > >65 TABLE ACCESS (BY INDEX ROWID) OF 'AD' (Cost=1590 > > > Card=145 Bytes=20300) > > >76 BITMAP CONVERSION (TO ROWIDS) > > >87 BITMAP CONVERSION (FROM ROWIDS) > > >98 INDEX (RANGE SCAN) OF 'I_AD2' (NON-UNIQUE) > > > 104 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1 > > > Card=3600 > > > Bytes=662400) > > > 11 10 INDEX (UNIQUE SCAN) OF 'I_PUB1' (UNIQUE) > > > 123 TABLE ACCESS (BY INDEX ROWID) OF 'INVROWS' (Cost=1 > > > Card=627725 Bytes=35152600) > > > 13 12 INDEX (RANGE SCAN) OF 'I_INVR1' (NON-UNIQUE) (Cost > > =1 > > > Card=627725) > > > 142 SORT (JOIN) (Cost=968 Card=25814 Bytes=154884) > > > 15 14 TABLE ACCESS (FULL) OF 'CUSTOMER' (Cost=968 > Card=25814 > > > Bytes=154884) > > > > > > > > > > > > > > > SELECT DISTINCT a.serieno, p.paper, p.adno, p.pubno, p.class, p.xsize, > > > p.ysize, > > > p.state, trunc(p.mdate) mdate, p.vno, a.unet, trunc(a.rdate) rdate, > > > trunc(a.startdate) startdate, trunc(a.enddate) enddate, a.ratecode, > > > a.cus4name, > > > a.cus2no, i.dcode, i.ino FROM arcdb.ad a, arcdb.pub p, arcdb.invrows > i, > > > advdb.customer c WHERE p.adno = a.adno AND p.vno = a.vno AND p.adno = > > > i.adno(+) > > > AND p.vno = i.vno(+) AND p.pubno = i.pubno(+) AND a.serieno IN > > > (7,8,24,31,33,39,52,58,60,63,137,144,419,434,440,444,445,451,463) AND > > > p.paper = > > > 'DNA' AND p.state IN ('NOT', 'VAR') AND p.adno > 0 AND p.pubno = 1 AND > > > p.vnoflag > > > = 'Y'AND c.cgrno = 'TT' AND trunc(a.rdate) BETWEEN > to_date('01-MAR-02', > > > 'DD-MON-YY') AND to_date('07-MAR-02', 'DD-MON-YY') > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Baker, Barbara > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858
RE: Does index need rebuilding when table is truncated
Hello, Lisa, what I was wondering when I read Rick's e-mail was... what about the HWM for the indexes when someone truncates a table. The table's HWM pointer gets reset of course, but I can never recall seeing anything about what happens to the index space. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 5:33 PM To: Multiple recipients of list ORACLE-L Hi Rick, Nope. Try it. You'll see that the extents clear up just like the extents in the table do, if you don't specify the REUSE STORAGE clause. Lisa Koivu Oracle Database Tank Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 5:11 PM > To: Multiple recipients of list ORACLE-L > Subject: Does index need rebuilding when table is truncated > > Hi All, > > I know if you delete lots of data using delete the indexes may need > rebuilding. Is this the case if the table is truncated? > > Thanks > Rick > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Explain: In List Iterator
OMG I thought we were looking at a canned-app query If it was my database, I would be turning the query upside down and educating the developer in a not-so-gentle manner. But that's my style - hormonal and direct. :) You are the better person if you can get through to the developer without resorting to my curt type of "people skills" Post your tkprof, I am curious to see it. > -Original Message- > From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 4:45 PM > To: '[EMAIL PROTECTED]'; Koivu, Lisa > Subject: RE: Explain: In List Iterator > > Thanks, Lisa! > I have not tkprof'd it. I'm beginning to wonder if the thing will ever > complete. > I think I might instead suggest ever-so-gently to the developer that this > doesn't belong in the production database. > > (See, Dennis!! I'm becoming the kinder, gentler dba...) > Barb > > > -- > > From: Koivu, Lisa[SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, April 09, 2002 2:42 PM > > To: '[EMAIL PROTECTED]' > > Cc: '[EMAIL PROTECTED]' > > Subject:RE: Explain: In List Iterator > > > > Hi Barbara, > > > > I believe 'in list iterator' is the way the optimizer is handling one of > > your in () statements in your query. Beware in lists with a large > number > > of > > values in the set... as expansion of these in lists can create an > > incredibly > > ugly OR'd query.Saw this once and gave it the no_expand hint - > problem > > solved. However I don't think that's the problem here - have you > tkprof'd > > it? > > > > This is one nasty query. Distinct, outer join, trunc on a date, > cartesian > > joins... yuck! > > > > Lisa Koivu > > Oracle Database Tank > > Fairfield Resorts, Inc. > > 954-935-4117 > > > > > > > -Original Message- > > > From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] > > > Sent: Tuesday, April 09, 2002 5:11 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Explain: In List Iterator > > > > > > Hi, list. > > > I'm trying to find out what's eating my system. I found the query, > and > > > explain'ed it. I've never seen an "in list iterator" before. Can > > anyone > > > tell me what that is??? > > > > > > Thanks!! > > > > > > Barb > > > > > > Execution Plan > > > -- > > >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2398 Card=25814 > > > Bytes=9964204) > > >10 SORT (UNIQUE) (Cost=2398 Card=25814 Bytes=9964204) > > >21 MERGE JOIN (CARTESIAN) (Cost=969 Card=25814 > Bytes=9964204) > > >32 NESTED LOOPS (OUTER) (Cost=1 Card=1 Bytes=380) > > >43 NESTED LOOPS (Cost=8 Card=1 Bytes=324) > > >54 INLIST ITERATOR (CONCATENATED) > > >65 TABLE ACCESS (BY INDEX ROWID) OF 'AD' (Cost=1590 > > > Card=145 Bytes=20300) > > >76 BITMAP CONVERSION (TO ROWIDS) > > >87 BITMAP CONVERSION (FROM ROWIDS) > > >98 INDEX (RANGE SCAN) OF 'I_AD2' (NON-UNIQUE) > > > 104 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1 > > > Card=3600 > > > Bytes=662400) > > > 11 10 INDEX (UNIQUE SCAN) OF 'I_PUB1' (UNIQUE) > > > 123 TABLE ACCESS (BY INDEX ROWID) OF 'INVROWS' (Cost=1 > > > Card=627725 Bytes=35152600) > > > 13 12 INDEX (RANGE SCAN) OF 'I_INVR1' (NON-UNIQUE) (Cost > > =1 > > > Card=627725) > > > 142 SORT (JOIN) (Cost=968 Card=25814 Bytes=154884) > > > 15 14 TABLE ACCESS (FULL) OF 'CUSTOMER' (Cost=968 > Card=25814 > > > Bytes=154884) > > > > > > > > > > > > > > > SELECT DISTINCT a.serieno, p.paper, p.adno, p.pubno, p.class, p.xsize, > > > p.ysize, > > > p.state, trunc(p.mdate) mdate, p.vno, a.unet, trunc(a.rdate) rdate, > > > trunc(a.startdate) startdate, trunc(a.enddate) enddate, a.ratecode, > > > a.cus4name, > > > a.cus2no, i.dcode, i.ino FROM arcdb.ad a, arcdb.pub p, arcdb.invrows > i, > > > advdb.customer c WHERE p.adno = a.adno AND p.vno = a.vno AND p.adno = > > > i.adno(+) > > > AND p.vno = i.vno(+) AND p.pubno = i.pubno(+) AND a.serieno IN > > > (7,8,24,31,33,39,52,58,60,63,137,144,419,434,440,444,445,451,463) AND > > > p.paper = > > > 'DNA' AND p.state IN ('NOT', 'VAR') AND p.adno > 0 AND p.pubno = 1 AND > > > p.vnoflag > > > = 'Y'AND c.cgrno = 'TT' AND trunc(a.rdate) BETWEEN > to_date('01-MAR-02', > > > 'DD-MON-YY') AND to_date('07-MAR-02', 'DD-MON-YY') > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Baker, Barbara > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (no
RE: Explain: In List Iterator
Thanks, Lisa! I have not tkprof'd it. I'm beginning to wonder if the thing will ever complete. I think I might instead suggest ever-so-gently to the developer that this doesn't belong in the production database. (See, Dennis!! I'm becoming the kinder, gentler dba...) Barb > -- > From: Koivu, Lisa[SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 2:42 PM > To: '[EMAIL PROTECTED]' > Cc: '[EMAIL PROTECTED]' > Subject: RE: Explain: In List Iterator > > Hi Barbara, > > I believe 'in list iterator' is the way the optimizer is handling one of > your in () statements in your query. Beware in lists with a large number > of > values in the set... as expansion of these in lists can create an > incredibly > ugly OR'd query.Saw this once and gave it the no_expand hint - problem > solved. However I don't think that's the problem here - have you tkprof'd > it? > > This is one nasty query. Distinct, outer join, trunc on a date, cartesian > joins... yuck! > > Lisa Koivu > Oracle Database Tank > Fairfield Resorts, Inc. > 954-935-4117 > > > > -Original Message- > > From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, April 09, 2002 5:11 PM > > To: Multiple recipients of list ORACLE-L > > Subject:Explain: In List Iterator > > > > Hi, list. > > I'm trying to find out what's eating my system. I found the query, and > > explain'ed it. I've never seen an "in list iterator" before. Can > anyone > > tell me what that is??? > > > > Thanks!! > > > > Barb > > > > Execution Plan > > -- > >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2398 Card=25814 > > Bytes=9964204) > >10 SORT (UNIQUE) (Cost=2398 Card=25814 Bytes=9964204) > >21 MERGE JOIN (CARTESIAN) (Cost=969 Card=25814 Bytes=9964204) > >32 NESTED LOOPS (OUTER) (Cost=1 Card=1 Bytes=380) > >43 NESTED LOOPS (Cost=8 Card=1 Bytes=324) > >54 INLIST ITERATOR (CONCATENATED) > >65 TABLE ACCESS (BY INDEX ROWID) OF 'AD' (Cost=1590 > > Card=145 Bytes=20300) > >76 BITMAP CONVERSION (TO ROWIDS) > >87 BITMAP CONVERSION (FROM ROWIDS) > >98 INDEX (RANGE SCAN) OF 'I_AD2' (NON-UNIQUE) > > 104 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1 > > Card=3600 > > Bytes=662400) > > 11 10 INDEX (UNIQUE SCAN) OF 'I_PUB1' (UNIQUE) > > 123 TABLE ACCESS (BY INDEX ROWID) OF 'INVROWS' (Cost=1 > > Card=627725 Bytes=35152600) > > 13 12 INDEX (RANGE SCAN) OF 'I_INVR1' (NON-UNIQUE) (Cost > =1 > > Card=627725) > > 142 SORT (JOIN) (Cost=968 Card=25814 Bytes=154884) > > 15 14 TABLE ACCESS (FULL) OF 'CUSTOMER' (Cost=968 Card=25814 > > Bytes=154884) > > > > > > > > > > SELECT DISTINCT a.serieno, p.paper, p.adno, p.pubno, p.class, p.xsize, > > p.ysize, > > p.state, trunc(p.mdate) mdate, p.vno, a.unet, trunc(a.rdate) rdate, > > trunc(a.startdate) startdate, trunc(a.enddate) enddate, a.ratecode, > > a.cus4name, > > a.cus2no, i.dcode, i.ino FROM arcdb.ad a, arcdb.pub p, arcdb.invrows i, > > advdb.customer c WHERE p.adno = a.adno AND p.vno = a.vno AND p.adno = > > i.adno(+) > > AND p.vno = i.vno(+) AND p.pubno = i.pubno(+) AND a.serieno IN > > (7,8,24,31,33,39,52,58,60,63,137,144,419,434,440,444,445,451,463) AND > > p.paper = > > 'DNA' AND p.state IN ('NOT', 'VAR') AND p.adno > 0 AND p.pubno = 1 AND > > p.vnoflag > > = 'Y'AND c.cgrno = 'TT' AND trunc(a.rdate) BETWEEN to_date('01-MAR-02', > > 'DD-MON-YY') AND to_date('07-MAR-02', 'DD-MON-YY') > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Baker, Barbara > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may al
Re: migrate from 8i to 9i
Thanks I'm thinking about this idea, Ben --- [EMAIL PROTECTED] wrote: > > I'm assuming that you're creating a 9i database on > the new machine when you > install Oracle. > > I find it useful to pre-create the tablespaces (and > users) on the new > database, rather than let the import do that. This > gives you more control > over where datafiles end up and do some clearup on > unneeded users, etc. > > > > > > Kader Ben > > Multiple recipients of list ORACLE-L > @yahoo.com> > <[EMAIL PROTECTED]> > Sent by: rootcc: > > Subject: > migrate from 8i to 9i > > > 04/09/2002 > > 03:18 PM > > Please > > respond to > > ORACLE-L > > > > > > > > > > Hi friends, > > I need your advise on the following question. I > have DB on 8i and I want create new one on another > machine with 9i. > I thought do the following steps: > > 1 - Install oracle 9i on a new machine > 2 - make full export of the 8i DB > 3 - import it on the new one (9i) > > So before I proceed I need your input. Am I correct > with these steps? There is something wrong? > > Many thanks for you, > > Kader > > __ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Kader Ben > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). 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). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Does index need rebuilding when table is truncated
Hi Rick, Nope. Try it. You'll see that the extents clear up just like the extents in the table do, if you don't specify the REUSE STORAGE clause. Lisa Koivu Oracle Database Tank Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 5:11 PM > To: Multiple recipients of list ORACLE-L > Subject: Does index need rebuilding when table is truncated > > Hi All, > > I know if you delete lots of data using delete the indexes may need > rebuilding. Is this the case if the table is truncated? > > Thanks > Rick > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman views & one other rman question - long, sorry
Thank you very much Brian for your response. I will read through it. Lisa > -Original Message- > From: Brian McGraw [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 4:50 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: rman views & one other rman question - long, sorry > > Lisa - > > Note 98342.1 might provide you some information. An excerpt: > > RMAN DATA DICTIONARY VIEWS used to query the control file > - > > If you are not using a recovery catalog, RMAN information is stored in > the > target database's control file . > > V$ARCHIVED_LOG >This view displays archived log information from the controlfile >including archive log names. An archive log record is inserted after >the online redo log is successfully archived or cleared (name column >is NULL if the log was cleared). If the log is archived twice, there >will be two archived log records with the same THREAD#, SEQUENCE#, >and FIRST_CHANGE#, but with a different name. An archive log record >is also inserted when an archive log is restored from a backup set >or a copy. >COLUMN DESCRIPTION >RECID Archived log record ID >STAMP Archived log record stamp >NAME Archived log file name >THREAD#Redo thread number >SEQUENCE# Redo log sequence number >RESETLOGS_CHANGE# Resetlogs change# of database when written >RESETLOGS_TIME Resetlogs time of database when written >FIRST_CHANGE# First change# in the archived log >FIRST_TIME Timestamp of the first change >NEXT_CHANGE# First change in the next log >NEXT_TIME Timestamp of the next change >BLOCKS Size of the archived log in blocks >BLOCK_SIZE Redo log block size >COMPLETION_TIMETime when the archiving completed >DELETEDYES/NO > > V$BACKUP_CORRUPTION >This view displays information about corruptions in datafile backups >from the controlfile. Note that corruptions are not tolerated in the >controlfile and archived log backups. >COLUMN DESCRIPTION >RECID Backup corruption record ID >STAMP Backup corruption record stamp >SET_STAMP Backup set stamp >SET_COUNT Backup set count >PIECE# Backup piece number >FILE# Datafile number >BLOCK# First block of the corrupted range >BLOCKS Number of contiguous blocks in corrupted range >CORRUPTION_CHANGE# Change# where logical corruption was detected. >MARKED_CORRUPT YES/NO. If YES the blocks were not marked > corrupted in datafile, but were detected and > marked while making backup > > V$COPY_CORRUPTION >This view displays information about datafile copy corruptions from >the controlfile. >COLUMN DESCRIPTION >RECID Copy corruption record ID >STAMP Copy corruption record stamp >COPY_RECID Datafile copy record ID >COPY_STAMP Datafile copy record stamp >FILE# Datafile number >BLOCK# First block of the corrupted range >BLOCKS Number of contiguous blocks in corrupted range >CORRUPTION_CHANGE# Change# where logical corruption was detected. >MARKED_CORRUPT YES/NO. If YES the blocks were not marked > corrupted in datafile, but were detected and > marked while making the datafile copy > > V$BACKUP_DATAFILE >Useful for creating equal sized backup sets by determining the >number of blocks in each datafile. Can also find the number of >corrupt blocks for the datafile. >COLUMN DESCRIPTION >RECID Backup datafile record ID >STAMP Backup datafile record stamp >SET_STAMP Backup set stamp >SET_COUNT Backup set count >FILE# Datafile number. Set to 0 for controlfile >CREATION_CHANGE# Creation change of the datafile >CREATION_TIME Creation timestamp of the datafile >RESETLOGS_CHANGE# Resetlogs change# of datafile when backed up >RESETLOGS_TIME Resetlogs timestamp of datafile when backed up >INCREMENTAL_LEVEL (0-4) incremental backup level >INCREMENTAL_CHANGE# All blocks changed after incremental change# is >included in this backup. >CHECKPOINT_CHANGE# All changes up to checkpoint change# are included >in this backup >CHECKPOINT_TIMETimestamp of the checkpoint >ABSOLUTE_FUZZY_CHANGE# Highest change# in this backup >MARKED_CORRUPT Number of blocks marked corrupt >MEDIA_CORRUPT Number of blocks med
RE: Explain: In List Iterator
The INLIST INTERATOR takes a result set, and "interates" over that result set returning a result set that matches the values of the IN predicate. This is documented, quite well, in the Oracle9i Documentation. -Original Message- Sent: Tuesday, April 09, 2002 5:11 PM To: Multiple recipients of list ORACLE-L Hi, list. I'm trying to find out what's eating my system. I found the query, and explain'ed it. I've never seen an "in list iterator" before. Can anyone tell me what that is??? Thanks!! Barb Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2398 Card=25814 Bytes=9964204) 10 SORT (UNIQUE) (Cost=2398 Card=25814 Bytes=9964204) 21 MERGE JOIN (CARTESIAN) (Cost=969 Card=25814 Bytes=9964204) 32 NESTED LOOPS (OUTER) (Cost=1 Card=1 Bytes=380) 43 NESTED LOOPS (Cost=8 Card=1 Bytes=324) 54 INLIST ITERATOR (CONCATENATED) 65 TABLE ACCESS (BY INDEX ROWID) OF 'AD' (Cost=1590 Card=145 Bytes=20300) 76 BITMAP CONVERSION (TO ROWIDS) 87 BITMAP CONVERSION (FROM ROWIDS) 98 INDEX (RANGE SCAN) OF 'I_AD2' (NON-UNIQUE) 104 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1 Card=3600 Bytes=662400) 11 10 INDEX (UNIQUE SCAN) OF 'I_PUB1' (UNIQUE) 123 TABLE ACCESS (BY INDEX ROWID) OF 'INVROWS' (Cost=1 Card=627725 Bytes=35152600) 13 12 INDEX (RANGE SCAN) OF 'I_INVR1' (NON-UNIQUE) (Cost =1 Card=627725) 142 SORT (JOIN) (Cost=968 Card=25814 Bytes=154884) 15 14 TABLE ACCESS (FULL) OF 'CUSTOMER' (Cost=968 Card=25814 Bytes=154884) SELECT DISTINCT a.serieno, p.paper, p.adno, p.pubno, p.class, p.xsize, p.ysize, p.state, trunc(p.mdate) mdate, p.vno, a.unet, trunc(a.rdate) rdate, trunc(a.startdate) startdate, trunc(a.enddate) enddate, a.ratecode, a.cus4name, a.cus2no, i.dcode, i.ino FROM arcdb.ad a, arcdb.pub p, arcdb.invrows i, advdb.customer c WHERE p.adno = a.adno AND p.vno = a.vno AND p.adno = i.adno(+) AND p.vno = i.vno(+) AND p.pubno = i.pubno(+) AND a.serieno IN (7,8,24,31,33,39,52,58,60,63,137,144,419,434,440,444,445,451,463) AND p.paper = 'DNA' AND p.state IN ('NOT', 'VAR') AND p.adno > 0 AND p.pubno = 1 AND p.vnoflag = 'Y'AND c.cgrno = 'TT' AND trunc(a.rdate) BETWEEN to_date('01-MAR-02', 'DD-MON-YY') AND to_date('07-MAR-02', 'DD-MON-YY') -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Explain: In List Iterator
Hi Barbara, I believe 'in list iterator' is the way the optimizer is handling one of your in () statements in your query. Beware in lists with a large number of values in the set... as expansion of these in lists can create an incredibly ugly OR'd query.Saw this once and gave it the no_expand hint - problem solved. However I don't think that's the problem here - have you tkprof'd it? This is one nasty query. Distinct, outer join, trunc on a date, cartesian joins... yuck! Lisa Koivu Oracle Database Tank Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: Baker, Barbara [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 5:11 PM > To: Multiple recipients of list ORACLE-L > Subject: Explain: In List Iterator > > Hi, list. > I'm trying to find out what's eating my system. I found the query, and > explain'ed it. I've never seen an "in list iterator" before. Can anyone > tell me what that is??? > > Thanks!! > > Barb > > Execution Plan > -- >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2398 Card=25814 > Bytes=9964204) >10 SORT (UNIQUE) (Cost=2398 Card=25814 Bytes=9964204) >21 MERGE JOIN (CARTESIAN) (Cost=969 Card=25814 Bytes=9964204) >32 NESTED LOOPS (OUTER) (Cost=1 Card=1 Bytes=380) >43 NESTED LOOPS (Cost=8 Card=1 Bytes=324) >54 INLIST ITERATOR (CONCATENATED) >65 TABLE ACCESS (BY INDEX ROWID) OF 'AD' (Cost=1590 > Card=145 Bytes=20300) >76 BITMAP CONVERSION (TO ROWIDS) >87 BITMAP CONVERSION (FROM ROWIDS) >98 INDEX (RANGE SCAN) OF 'I_AD2' (NON-UNIQUE) > 104 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1 > Card=3600 > Bytes=662400) > 11 10 INDEX (UNIQUE SCAN) OF 'I_PUB1' (UNIQUE) > 123 TABLE ACCESS (BY INDEX ROWID) OF 'INVROWS' (Cost=1 > Card=627725 Bytes=35152600) > 13 12 INDEX (RANGE SCAN) OF 'I_INVR1' (NON-UNIQUE) (Cost =1 > Card=627725) > 142 SORT (JOIN) (Cost=968 Card=25814 Bytes=154884) > 15 14 TABLE ACCESS (FULL) OF 'CUSTOMER' (Cost=968 Card=25814 > Bytes=154884) > > > > > SELECT DISTINCT a.serieno, p.paper, p.adno, p.pubno, p.class, p.xsize, > p.ysize, > p.state, trunc(p.mdate) mdate, p.vno, a.unet, trunc(a.rdate) rdate, > trunc(a.startdate) startdate, trunc(a.enddate) enddate, a.ratecode, > a.cus4name, > a.cus2no, i.dcode, i.ino FROM arcdb.ad a, arcdb.pub p, arcdb.invrows i, > advdb.customer c WHERE p.adno = a.adno AND p.vno = a.vno AND p.adno = > i.adno(+) > AND p.vno = i.vno(+) AND p.pubno = i.pubno(+) AND a.serieno IN > (7,8,24,31,33,39,52,58,60,63,137,144,419,434,440,444,445,451,463) AND > p.paper = > 'DNA' AND p.state IN ('NOT', 'VAR') AND p.adno > 0 AND p.pubno = 1 AND > p.vnoflag > = 'Y'AND c.cgrno = 'TT' AND trunc(a.rdate) BETWEEN to_date('01-MAR-02', > 'DD-MON-YY') AND to_date('07-MAR-02', 'DD-MON-YY') > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Baker, Barbara > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Does index need rebuilding when table is truncated
Hi All, I know if you delete lots of data using delete the indexes may need rebuilding. Is this the case if the table is truncated? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Differences between Oracle JDBC thin and thick drivers
Hi I believe the difference is that the OCI drivers use SQL*Net or NET8 or whatever they call it now, whereas the thin driver does not require SQL*Net on the client machine. Ben Poels Sr. Technical Analyst Queen's University -Original Message- Avrami Sent: Tuesday, April 09, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Hello all, I have a question concerning the Oracle JDBC thin vs. thick drivers and how they might affect operations from an application perspective. We're in a Solais 8/Oracle 8.1.7.2 environment. We have several applications on several servers connecting to the Oracle database. For redundancy, we're looking into setting up TAF (transparent application failover). Currently, some of our apps use the Oracle JDBC thin drivers to talk to the database, with a connection string that like this: jdbc:oracle:thin:@host:port:ORACLE_SID In a disaster recovery mode, where we would switch the database from one server to another, the host name in the above string would become invalid. That means we have to shut down our application servers and restart them with an updated string. Using the Oracle OCI (thick) driver though, allows us to connect to a Net8 service instead of a specific server: jdbc:oracle:oci8:@NET8_SERVICE_NAME Coupled with the FAILOVER=ON option configured in Net8, it is then possible to direct a connection from the first server to the failover database on another server. This is exactly what we would like to do. My question is, from an application perspective, how is the Oracle thick driver different from the thin driver? If everything else is "equal" (i.e. the thick driver is compatible with the app servers) would there be something within the the thick/OCI driver that could limit functionality vs. the thin driver? My understand, which obviously is sketchy, is that the thick driver is a superset of the thin driver. If this is the case, and for example if all database connections were handled through a configuration file with the above OCI connection string, then theoretically the thick driver should work. If anyone has any info on this that they can share, it would be greatly appreciated. Thanks, Lou Avrami -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis Avrami INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Explain: In List Iterator
Hi, list. I'm trying to find out what's eating my system. I found the query, and explain'ed it. I've never seen an "in list iterator" before. Can anyone tell me what that is??? Thanks!! Barb Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2398 Card=25814 Bytes=9964204) 10 SORT (UNIQUE) (Cost=2398 Card=25814 Bytes=9964204) 21 MERGE JOIN (CARTESIAN) (Cost=969 Card=25814 Bytes=9964204) 32 NESTED LOOPS (OUTER) (Cost=1 Card=1 Bytes=380) 43 NESTED LOOPS (Cost=8 Card=1 Bytes=324) 54 INLIST ITERATOR (CONCATENATED) 65 TABLE ACCESS (BY INDEX ROWID) OF 'AD' (Cost=1590 Card=145 Bytes=20300) 76 BITMAP CONVERSION (TO ROWIDS) 87 BITMAP CONVERSION (FROM ROWIDS) 98 INDEX (RANGE SCAN) OF 'I_AD2' (NON-UNIQUE) 104 TABLE ACCESS (BY INDEX ROWID) OF 'PUB' (Cost=1 Card=3600 Bytes=662400) 11 10 INDEX (UNIQUE SCAN) OF 'I_PUB1' (UNIQUE) 123 TABLE ACCESS (BY INDEX ROWID) OF 'INVROWS' (Cost=1 Card=627725 Bytes=35152600) 13 12 INDEX (RANGE SCAN) OF 'I_INVR1' (NON-UNIQUE) (Cost =1 Card=627725) 142 SORT (JOIN) (Cost=968 Card=25814 Bytes=154884) 15 14 TABLE ACCESS (FULL) OF 'CUSTOMER' (Cost=968 Card=25814 Bytes=154884) SELECT DISTINCT a.serieno, p.paper, p.adno, p.pubno, p.class, p.xsize, p.ysize, p.state, trunc(p.mdate) mdate, p.vno, a.unet, trunc(a.rdate) rdate, trunc(a.startdate) startdate, trunc(a.enddate) enddate, a.ratecode, a.cus4name, a.cus2no, i.dcode, i.ino FROM arcdb.ad a, arcdb.pub p, arcdb.invrows i, advdb.customer c WHERE p.adno = a.adno AND p.vno = a.vno AND p.adno = i.adno(+) AND p.vno = i.vno(+) AND p.pubno = i.pubno(+) AND a.serieno IN (7,8,24,31,33,39,52,58,60,63,137,144,419,434,440,444,445,451,463) AND p.paper = 'DNA' AND p.state IN ('NOT', 'VAR') AND p.adno > 0 AND p.pubno = 1 AND p.vnoflag = 'Y'AND c.cgrno = 'TT' AND trunc(a.rdate) BETWEEN to_date('01-MAR-02', 'DD-MON-YY') AND to_date('07-MAR-02', 'DD-MON-YY') -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Differences between Oracle JDBC thin and thick drivers
Louis - You may want to pick up the book "Java Programming with Oracle JDBC" by Don Bales. The editor, Jonathan Gennick participates on this list from time to time. It goes into quite a bit of detail on the differences between the thin and thick drivers, even performs benchmarks. Just a guess, but my initial impression would be that the two drivers may share very little code, given that they work so differently. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 3:29 PM To: Multiple recipients of list ORACLE-L Hello all, I have a question concerning the Oracle JDBC thin vs. thick drivers and how they might affect operations from an application perspective. We're in a Solais 8/Oracle 8.1.7.2 environment. We have several applications on several servers connecting to the Oracle database. For redundancy, we're looking into setting up TAF (transparent application failover). Currently, some of our apps use the Oracle JDBC thin drivers to talk to the database, with a connection string that like this: jdbc:oracle:thin:@host:port:ORACLE_SID In a disaster recovery mode, where we would switch the database from one server to another, the host name in the above string would become invalid. That means we have to shut down our application servers and restart them with an updated string. Using the Oracle OCI (thick) driver though, allows us to connect to a Net8 service instead of a specific server: jdbc:oracle:oci8:@NET8_SERVICE_NAME Coupled with the FAILOVER=ON option configured in Net8, it is then possible to direct a connection from the first server to the failover database on another server. This is exactly what we would like to do. My question is, from an application perspective, how is the Oracle thick driver different from the thin driver? If everything else is "equal" (i.e. the thick driver is compatible with the app servers) would there be something within the the thick/OCI driver that could limit functionality vs. the thin driver? My understand, which obviously is sketchy, is that the thick driver is a superset of the thin driver. If this is the case, and for example if all database connections were handled through a configuration file with the above OCI connection string, then theoretically the thick driver should work. If anyone has any info on this that they can share, it would be greatly appreciated. Thanks, Lou Avrami -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis Avrami INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: migrate from 8i to 9i
Ben - For that size, I would go export/import. You will need to do that first anyway to test out 9i. Make a note of how long the entire process takes so you can make sure your business users can give you that much downtime. If you encounter a roadblock, then you can examine the alternatives. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 3:34 PM To: Multiple recipients of list ORACLE-L Thanks guys for your replies' My DB is no big about 2.5Gb. Robert, both DB's (8i and 9i ) are on windows 2000. Ben --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > I (perhaps improperly) assumed that by "another > machine" he meant another > platform. In retrospect, this might not have been > the case > > RF > > -Original Message- > Sent: Tuesday, April 09, 2002 3:44 PM > To: Multiple recipients of list ORACLE-L > > > Ben - How large is your database and how long can > you have it unavailable to > production? If your database isn't large and your > users can be off, for > example, a weekend, then the export/import method is > simple and easy. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, April 09, 2002 2:19 PM > To: Multiple recipients of list ORACLE-L > > > Hi friends, > > I need your advise on the following question. I > have DB on 8i and I want create new one on another > machine with 9i. > I thought do the following steps: > > 1 - Install oracle 9i on a new machine > 2 - make full export of the 8i DB > 3 - import it on the new one (9i) > > So before I proceed I need your input. Am I correct > with these steps? There is something wrong? > > Many thanks for you, > > Kader > > __ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Kader Ben > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Freeman, Robert > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (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! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
RE: rman views & one other rman question - long, sorry
Lisa - Note 98342.1 might provide you some information. An excerpt: RMAN DATA DICTIONARY VIEWS used to query the control file - If you are not using a recovery catalog, RMAN information is stored in the target database's control file . V$ARCHIVED_LOG This view displays archived log information from the controlfile including archive log names. An archive log record is inserted after the online redo log is successfully archived or cleared (name column is NULL if the log was cleared). If the log is archived twice, there will be two archived log records with the same THREAD#, SEQUENCE#, and FIRST_CHANGE#, but with a different name. An archive log record is also inserted when an archive log is restored from a backup set or a copy. COLUMN DESCRIPTION RECID Archived log record ID STAMP Archived log record stamp NAME Archived log file name THREAD#Redo thread number SEQUENCE# Redo log sequence number RESETLOGS_CHANGE# Resetlogs change# of database when written RESETLOGS_TIME Resetlogs time of database when written FIRST_CHANGE# First change# in the archived log FIRST_TIME Timestamp of the first change NEXT_CHANGE# First change in the next log NEXT_TIME Timestamp of the next change BLOCKS Size of the archived log in blocks BLOCK_SIZE Redo log block size COMPLETION_TIMETime when the archiving completed DELETEDYES/NO V$BACKUP_CORRUPTION This view displays information about corruptions in datafile backups from the controlfile. Note that corruptions are not tolerated in the controlfile and archived log backups. COLUMN DESCRIPTION RECID Backup corruption record ID STAMP Backup corruption record stamp SET_STAMP Backup set stamp SET_COUNT Backup set count PIECE# Backup piece number FILE# Datafile number BLOCK# First block of the corrupted range BLOCKS Number of contiguous blocks in corrupted range CORRUPTION_CHANGE# Change# where logical corruption was detected. MARKED_CORRUPT YES/NO. If YES the blocks were not marked corrupted in datafile, but were detected and marked while making backup V$COPY_CORRUPTION This view displays information about datafile copy corruptions from the controlfile. COLUMN DESCRIPTION RECID Copy corruption record ID STAMP Copy corruption record stamp COPY_RECID Datafile copy record ID COPY_STAMP Datafile copy record stamp FILE# Datafile number BLOCK# First block of the corrupted range BLOCKS Number of contiguous blocks in corrupted range CORRUPTION_CHANGE# Change# where logical corruption was detected. MARKED_CORRUPT YES/NO. If YES the blocks were not marked corrupted in datafile, but were detected and marked while making the datafile copy V$BACKUP_DATAFILE Useful for creating equal sized backup sets by determining the number of blocks in each datafile. Can also find the number of corrupt blocks for the datafile. COLUMN DESCRIPTION RECID Backup datafile record ID STAMP Backup datafile record stamp SET_STAMP Backup set stamp SET_COUNT Backup set count FILE# Datafile number. Set to 0 for controlfile CREATION_CHANGE# Creation change of the datafile CREATION_TIME Creation timestamp of the datafile RESETLOGS_CHANGE# Resetlogs change# of datafile when backed up RESETLOGS_TIME Resetlogs timestamp of datafile when backed up INCREMENTAL_LEVEL (0-4) incremental backup level INCREMENTAL_CHANGE# All blocks changed after incremental change# is included in this backup. CHECKPOINT_CHANGE# All changes up to checkpoint change# are included in this backup CHECKPOINT_TIMETimestamp of the checkpoint ABSOLUTE_FUZZY_CHANGE# Highest change# in this backup MARKED_CORRUPT Number of blocks marked corrupt MEDIA_CORRUPT Number of blocks media corrupt LOGICALLY_CORRUPT Number of blocks logically corrupt DATAFILE_BLOCKSSize of the datafile in blocks at backup time. BLOCKS Size of the backup datafile in blocks. BLOCK_SIZE Block size OLDEST_OFFLINE_RANGE The RECID of the oldest offline range record in this backup controlfile. COMPLETION_TIME The time completed. V$BACKUP_REDOLOG This view displays information about archived logs in backup sets from the
Re: migrate from 8i to 9i
I'm assuming that you're creating a 9i database on the new machine when you install Oracle. I find it useful to pre-create the tablespaces (and users) on the new database, rather than let the import do that. This gives you more control over where datafiles end up and do some clearup on unneeded users, etc. Kader Ben <[EMAIL PROTECTED]> Sent by: rootcc: Subject: migrate from 8i to 9i 04/09/2002 03:18 PM Please respond to ORACLE-L Hi friends, I need your advise on the following question. I have DB on 8i and I want create new one on another machine with 9i. I thought do the following steps: 1 - Install oracle 9i on a new machine 2 - make full export of the 8i DB 3 - import it on the new one (9i) So before I proceed I need your input. Am I correct with these steps? There is something wrong? Many thanks for you, Kader __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Function based index
Rick - No you can't parameterize it because Oracle will actually build an index based on your function. That is a physical index populated with actual data. If the Oracle optimizer was smart enough to handle the parameter, then it would be smart enough to not need the function-based index in the first place. However, you could create multiple function-based indexes to cover several situations. Of course, if you get carried away and create many, complex function-based indexes, then your insert and update performance may suffer. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 1:23 PM To: Multiple recipients of list ORACLE-L Hi, If I have a function based index such as CREATE INDEX emp_idx01 on emp(SUBSTR(first_name,1,20)) Is there a way to build index where 1,20 portion can be parameterized? If so how would this be done? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: migrate from 8i to 9i
Thanks guys for your replies' My DB is no big about 2.5Gb. Robert, both DB's (8i and 9i ) are on windows 2000. Ben --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > I (perhaps improperly) assumed that by "another > machine" he meant another > platform. In retrospect, this might not have been > the case > > RF > > -Original Message- > Sent: Tuesday, April 09, 2002 3:44 PM > To: Multiple recipients of list ORACLE-L > > > Ben - How large is your database and how long can > you have it unavailable to > production? If your database isn't large and your > users can be off, for > example, a weekend, then the export/import method is > simple and easy. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, April 09, 2002 2:19 PM > To: Multiple recipients of list ORACLE-L > > > Hi friends, > > I need your advise on the following question. I > have DB on 8i and I want create new one on another > machine with 9i. > I thought do the following steps: > > 1 - Install oracle 9i on a new machine > 2 - make full export of the 8i DB > 3 - import it on the new one (9i) > > So before I proceed I need your input. Am I correct > with these steps? There is something wrong? > > Many thanks for you, > > Kader > > __ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Kader Ben > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Freeman, Robert > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (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! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Differences between Oracle JDBC thin and thick drivers
Hello all, I have a question concerning the Oracle JDBC thin vs. thick drivers and how they might affect operations from an application perspective. We're in a Solais 8/Oracle 8.1.7.2 environment. We have several applications on several servers connecting to the Oracle database. For redundancy, we're looking into setting up TAF (transparent application failover). Currently, some of our apps use the Oracle JDBC thin drivers to talk to the database, with a connection string that like this: jdbc:oracle:thin:@host:port:ORACLE_SID In a disaster recovery mode, where we would switch the database from one server to another, the host name in the above string would become invalid. That means we have to shut down our application servers and restart them with an updated string. Using the Oracle OCI (thick) driver though, allows us to connect to a Net8 service instead of a specific server: jdbc:oracle:oci8:@NET8_SERVICE_NAME Coupled with the FAILOVER=ON option configured in Net8, it is then possible to direct a connection from the first server to the failover database on another server. This is exactly what we would like to do. My question is, from an application perspective, how is the Oracle thick driver different from the thin driver? If everything else is "equal" (i.e. the thick driver is compatible with the app servers) would there be something within the the thick/OCI driver that could limit functionality vs. the thin driver? My understand, which obviously is sketchy, is that the thick driver is a superset of the thin driver. If this is the case, and for example if all database connections were handled through a configuration file with the above OCI connection string, then theoretically the thick driver should work. If anyone has any info on this that they can share, it would be greatly appreciated. Thanks, Lou Avrami -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis Avrami INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: function based index
You need a simple index on the column that gets queried Max(columnname). The index is always sorted. -Original Message- Sent: Tuesday, November 20, 2001 8:00 AM To: Multiple recipients of list ORACLE-L hi everyone we have a query with several max functions in it. The performance of the query is not so well, can i achieve better performance with function based index on max(columnname)? according the manuals this is not allowed because max is a group function. anyone with a solution for this ? vr. gr. g.g. kor rdw ict groningen -- 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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rman ... what do YOU need
Oh... I'm sure I'll be asking for help, particularly where the media management layer is involved :-) RF -Original Message- Sent: Tuesday, April 09, 2002 3:36 PM To: Multiple recipients of list ORACLE-L Robert, Sample queries against the Rman Views - or - how to navigate to find stuff within the structure would be very helpful. As well as standard installation procedures for using Rman against the various SBT software components. Configuring these beasts is where most of the challenge lies. And then, various recover scenarious. Even though Rman does a pretty decent job of this. Good luck, and please feel free to ask for help! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, April 09, 2002 3:09 PM To: Multiple recipients of list ORACLE-L I have the book, and it is a pretty good 101 book. My book seeks to go to the next level, looking at things like the data dictionary views, the recovery catalog tables and how they are used, backup and recovery case studies, and the like. I will look for input from this thread for additional content. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, April 09, 2002 1:40 PM To: [EMAIL PROTECTED]; Freeman, Robert FWIW -- Oracle Press recently published a "Backup & Recovery 101" book by Kenny Smith and Stephan Haisley. I have not yet read it, but it claims to have RMAN coverage. Since it is part of the '101' series, I presume it covers most of the basic stuff. Has anyone purchased it? And read it? I may check it out at IOUG-A next week :) Regards, - Kirti -Original Message- Sent: Tuesday, April 09, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, April 08, 2002 2:54 PM To: Multiple recipients of list ORACLE-L I don't think you can do it.. I mean, you could change it to trunc the oracle_date field (that eliminates the minutes) and then do a to_date of :b1 but you will still be operating on the oracle_date field. Okay, I HATE to suggest this, but since the table is small: add another field to the table oracle_date_2 as a date field. Update the table set oracle_date_2=trunc(oracle_date) add a trigger to fill in oracle_date_2 when you insert a row or update the oracle_date column create an index on oracle_date_2 and change the query to use that column --- [EMAIL PROTECTED] wrote: > > I've got the following SQL statement that is running very long on a > nightly > data load. The problem is the TO_CHAR function which is preventing > me from using the index on this small (20,000-row table). > > This is an 8.0.4 database so it is not possible for me to use > make this a function-based index. > > The problem is that the date field has minutes, etc. included and > those need to be eliminated before the comparison can be made. > That's why I can't just eliminate the TO_CHAR from both sides > of the equation. > > Isn't there a way that I can pull this function out of the select > statement > and do it in a preceeding statement? Then I could just pass in both > variables to this statement without the TO_CHAR and use my index. > > Is this realistic? How, exactly could it be done? > > > SELECT DATE_KEY > FROM DATE_DIM > WHERE TO_CHAR(ORACLE_DATE,'DD-MON-') = > TO_CHAR(:b1,'DD-MON-') > > > SQL> desc date_dim; > NameNull?Type > --- > DATE_KEYNOT NULL NUMBER(5) > ORACLE_DATE NOT NULL DATE > DATACOM_DATE NUMBER(6) > DATACOM_REVERSE_DATE NUMBER(6) > DAY_OF_WEEK NOT NULL VARCHAR2(30) > DAY_NUMBER_IN_MONTH NOT NULL NUMBER(3) > DAY_NUMBER_OVERALL NOT NULL NUMBER(9) > WEEK_NUMBER_IN_YEAR NOT NULL NUMBER(3) > WEEK_NUMBER_OVERALL NOT NULL NUMBER(7) > MONTH NOT NULL VARCHAR2(30) > MONTH_NUMBER_OVERALLNOT NULL NUMBER(7) > YEARNOT NULL NUMBER(5) > WEEKDAY_IND NOT NULL CHAR(1) > LAST_DAY_IN_MONTH_IND NOT NULL CHAR(1) > DATA_WAREHOUSE_MOD_DATETIME NOT NULL DATE > DATA_MART_MOD_DATETIME NOT NULL DATE > > > > SQL> select oracle_date from date_dim where rownum=1; > > ORACLE_DA > ---
RE: Rman ... what do YOU need
Robert, Do you need a co-author ?? ;) We do have IBM/Tivoli TSM/ADSM stuff and DRP is a *very big* thing for usAn active Runway, Airport Fuel Depot and an Airline hanger (where they test those jet engines) surround our office complex (all within less than 1/4 to 1/2 a mile away). We do not have Legato, though. Cheers !! - Kirti -Original Message- Sent: Tuesday, April 09, 2002 2:29 PM To: Multiple recipients of list ORACLE-L >>Hope you cover *all* available MML stuff.. like IBM/Tivoli ADSM/TSM, Legato >>etc.. etc.. and how to setup and use RMAN for Disaster Recovery scenarios I have not yet figured out how I can do all of that (though I'd love to), as my environment only supports the Legato stuff. I might have to find someone that uses the other MML's. RF -Original Message- Sent: Tuesday, April 09, 2002 3:16 PM To: Multiple recipients of list ORACLE-L Robert, That's good to know. A dedicated RMAN book would be great !! Hope you cover *all* available MML stuff.. like IBM/Tivoli ADSM/TSM, Legato etc.. etc.. and how to setup and use RMAN for Disaster Recovery scenarios, where databases would be recovered on different server and different location. Good Luck.. Regards, - Kirti -Original Message- Sent: Tuesday, April 09, 2002 1:12 PM To: 'Deshpande, Kirti'; [EMAIL PROTECTED] I have the book, and it is a pretty good 101 book. My book seeks to go to the next level, looking at things like the data dictionary views, the recovery catalog tables and how they are used, backup and recovery case studies, and the like. I will look for input from this thread for additional content. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, April 09, 2002 1:40 PM To: [EMAIL PROTECTED]; Freeman, Robert FWIW -- Oracle Press recently published a "Backup & Recovery 101" book by Kenny Smith and Stephan Haisley. I have not yet read it, but it claims to have RMAN coverage. Since it is part of the '101' series, I presume it covers most of the basic stuff. Has anyone purchased it? And read it? I may check it out at IOUG-A next week :) Regards, - Kirti -Original Message- Sent: Tuesday, April 09, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, April 08, 2002 2:54 PM To: Multiple recipients of list ORACLE-L I don't think you can do it.. I mean, you could change it to trunc the oracle_date field (that eliminates the minutes) and then do a to_date of :b1 but you will still be operating on the oracle_date field. Okay, I HATE to suggest this, but since the table is small: add another field to the table oracle_date_2 as a date field. Update the table set oracle_date_2=trunc(oracle_date) add a trigger to fill in oracle_date_2 when you insert a row or update the oracle_date column create an index on oracle_date_2 and change the query to use that column --- [EMAIL PROTECTED] wrote: > > I've got the following SQL statement that is running very long on a > nightly > data load. The problem is the TO_CHAR function which is preventing > me from using the index on this small (20,000-row table). > > This is an 8.0.4 database so it is not possible for me to use > make this a function-based index. > > The problem is that the date field has minutes, etc. included and > those need to be eliminated before the comparison can be made. > That's why I can't just eliminate the TO_CHAR from both sides > of the equation. > > Isn't there a way that I can pull this function out of the select > statement > and do it in a preceeding statement? Then I could just pass in both > variables to this statement without the TO_CHAR and use my index. > > Is this realistic? How, exactly could it be done? > > > SELECT DATE_KEY > FROM DATE_DIM > WHERE TO_CHAR(ORACLE_DATE,'DD-MON-') = > TO_CHAR(:b1,'DD-MON-') > > > SQL> desc date_dim; > NameNull?Type > --- > DATE_KEYNOT NULL NUMBER(5) > ORACLE_DATE NOT NULL DATE > DATACOM_DATE NUMBER(6) > DATACOM_REVERSE_DATE NUMBER(6) > DAY_OF_WEEK NOT NULL VARCHAR2(30) > DAY_NUMBER_IN_MONTH NOT NULL NUMBER(3) > DAY_NUMBER_OVERALL NOT NULL NUMBER(9) > WEEK_NUMBER_IN_YEAR
RE: migrate from 8i to 9i
I (perhaps improperly) assumed that by "another machine" he meant another platform. In retrospect, this might not have been the case RF -Original Message- Sent: Tuesday, April 09, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Ben - How large is your database and how long can you have it unavailable to production? If your database isn't large and your users can be off, for example, a weekend, then the export/import method is simple and easy. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Hi friends, I need your advise on the following question. I have DB on 8i and I want create new one on another machine with 9i. I thought do the following steps: 1 - Install oracle 9i on a new machine 2 - make full export of the 8i DB 3 - import it on the new one (9i) So before I proceed I need your input. Am I correct with these steps? There is something wrong? Many thanks for you, Kader __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: migrate from 8i to 9i
Ben - How large is your database and how long can you have it unavailable to production? If your database isn't large and your users can be off, for example, a weekend, then the export/import method is simple and easy. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Hi friends, I need your advise on the following question. I have DB on 8i and I want create new one on another machine with 9i. I thought do the following steps: 1 - Install oracle 9i on a new machine 2 - make full export of the 8i DB 3 - import it on the new one (9i) So before I proceed I need your input. Am I correct with these steps? There is something wrong? Many thanks for you, Kader __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Function based index
[EMAIL PROTECTED] wrote: > > Hi, > > If I have a function based index such as > CREATE INDEX emp_idx01 on emp(SUBSTR(first_name,1,20)) > > Is there a way to build index where 1,20 portion can be parameterized? If > so how would this be done? > > Thanks > Rick > No. The function is simply applied to the column when the index is created, so it's fairly 'static'. My guess is that the index could possibly be used for a search on substr(first_name, 1, 10), à la like 'something%' but I have not tried it. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Insert append generating redo
Stephane, I don't understand what you mean when you say you can select on t1 before any commit. I just tried this on an 8.1.7 database, and there was a signicant reduction in redo. There was only 668 bytes of redo generated vs. 2320 (see below). I think some redo will still be generated as you allocate extents (my tablespace is dictionary managed). Rob Pegram Oracle Certified DBA SQL> create table t as select * from dba_users; Table created. SQL> alter table t nologging; Table altered. SQL> delete from t; 15 rows deleted. SQL> commit; Commit complete. SQL> select value from v$mystat, v$statname where v$mystat.statistic# = v$statname.statistic# and v$statname.name = 'redo size' VALUE -- 117720 SQL> insert /*+ append */ into t as select * from dba_users; insert /*+ append */ into t as select * from dba_users * ERROR at line 1: ORA-00926: missing VALUES keyword SQL> insert /*+ append */ into t select * from dba_users; 15 rows created. SQL> commit; Commit complete. SQL> select value from v$mystat, v$statname where v$mystat.statistic# = v$statname.statistic# and v$statname.name = 'redo size' VALUE -- 118388 SQL> delete from t; 15 rows deleted. SQL> SQL> commit; Commit complete. SQL> select value from v$mystat, v$statname where v$mystat.statistic# = v$statname.statistic# and v$statname.name = 'redo size' VALUE -- 123856 SQL> insert into t select * from dba_users; 15 rows created. SQL> commit; Commit complete. SQL> select value from v$mystat, v$statname where v$mystat.statistic# = v$statname.statistic# and v$statname.name = 'redo size' VALUE -- 126176 --- paquette stephane <[EMAIL PROTECTED]> wrote: > Hi, > > I'm trying the following insert /*+ append */ into > t1 > as select * from t2; > > t1 is created with nologging attribute. > > The insert is not using the hint at all. > I can select on t1 (before any commit) which I > should > not be able to do if the append hint was used. > > Any ways to get the hing used ? > (Oracle 817/NT) > > TIA > > = > Stéphane Paquette > DBA Oracle, consultant entrepôt de données > Oracle DBA, datawarehouse consultant > [EMAIL PROTECTED] > > ___ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et > en français ! > Yahoo! Mail : http://fr.mail.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). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rman ... what do YOU need
Robert, Sample queries against the Rman Views - or - how to navigate to find stuff within the structure would be very helpful. As well as standard installation procedures for using Rman against the various SBT software components. Configuring these beasts is where most of the challenge lies. And then, various recover scenarious. Even though Rman does a pretty decent job of this. Good luck, and please feel free to ask for help! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, April 09, 2002 3:09 PM To: Multiple recipients of list ORACLE-L I have the book, and it is a pretty good 101 book. My book seeks to go to the next level, looking at things like the data dictionary views, the recovery catalog tables and how they are used, backup and recovery case studies, and the like. I will look for input from this thread for additional content. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, April 09, 2002 1:40 PM To: [EMAIL PROTECTED]; Freeman, Robert FWIW -- Oracle Press recently published a "Backup & Recovery 101" book by Kenny Smith and Stephan Haisley. I have not yet read it, but it claims to have RMAN coverage. Since it is part of the '101' series, I presume it covers most of the basic stuff. Has anyone purchased it? And read it? I may check it out at IOUG-A next week :) Regards, - Kirti -Original Message- Sent: Tuesday, April 09, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, April 08, 2002 2:54 PM To: Multiple recipients of list ORACLE-L I don't think you can do it.. I mean, you could change it to trunc the oracle_date field (that eliminates the minutes) and then do a to_date of :b1 but you will still be operating on the oracle_date field. Okay, I HATE to suggest this, but since the table is small: add another field to the table oracle_date_2 as a date field. Update the table set oracle_date_2=trunc(oracle_date) add a trigger to fill in oracle_date_2 when you insert a row or update the oracle_date column create an index on oracle_date_2 and change the query to use that column --- [EMAIL PROTECTED] wrote: > > I've got the following SQL statement that is running very long on a > nightly > data load. The problem is the TO_CHAR function which is preventing > me from using the index on this small (20,000-row table). > > This is an 8.0.4 database so it is not possible for me to use > make this a function-based index. > > The problem is that the date field has minutes, etc. included and > those need to be eliminated before the comparison can be made. > That's why I can't just eliminate the TO_CHAR from both sides > of the equation. > > Isn't there a way that I can pull this function out of the select > statement > and do it in a preceeding statement? Then I could just pass in both > variables to this statement without the TO_CHAR and use my index. > > Is this realistic? How, exactly could it be done? > > > SELECT DATE_KEY > FROM DATE_DIM > WHERE TO_CHAR(ORACLE_DATE,'DD-MON-') = > TO_CHAR(:b1,'DD-MON-') > > > SQL> desc date_dim; > NameNull?Type > --- > DATE_KEYNOT NULL NUMBER(5) > ORACLE_DATE NOT NULL DATE > DATACOM_DATE NUMBER(6) > DATACOM_REVERSE_DATE NUMBER(6) > DAY_OF_WEEK NOT NULL VARCHAR2(30) > DAY_NUMBER_IN_MONTH NOT NULL NUMBER(3) > DAY_NUMBER_OVERALL NOT NULL NUMBER(9) > WEEK_NUMBER_IN_YEAR NOT NULL NUMBER(3) > WEEK_NUMBER_OVERALL NOT NULL NUMBER(7) > MONTH NOT NULL VARCHAR2(30) > MONTH_NUMBER_OVERALLNOT NULL NUMBER(7) > YEARNOT NULL NUMBER(5) > WEEKDAY_IND NOT NULL CHAR(1) > LAST_DAY_IN_MONTH_IND NOT NULL CHAR(1) > DATA_WAREHOUSE_MOD_DATETIME NOT NULL DATE > DATA_MART_MOD_DATETIME NOT NULL DATE > > > > SQL> select oracle_date from date_dim where rownum=1; > > ORACLE_DA > - > 01-JAN-70 > > > Thanks in advance for any help. > > Cherie Machler > Oracle DBA > Gelco Information Network > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author
RE: Rman ... what do YOU need
Kirti - Thanks for mentioning it. I went ahead and ordered it, so maybe I can report to the list in about a week. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 1:41 PM To: Multiple recipients of list ORACLE-L FWIW -- Oracle Press recently published a "Backup & Recovery 101" book by Kenny Smith and Stephan Haisley. I have not yet read it, but it claims to have RMAN coverage. Since it is part of the '101' series, I presume it covers most of the basic stuff. Has anyone purchased it? And read it? I may check it out at IOUG-A next week :) Regards, - Kirti -Original Message- Sent: Tuesday, April 09, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, April 08, 2002 2:54 PM To: Multiple recipients of list ORACLE-L I don't think you can do it.. I mean, you could change it to trunc the oracle_date field (that eliminates the minutes) and then do a to_date of :b1 but you will still be operating on the oracle_date field. Okay, I HATE to suggest this, but since the table is small: add another field to the table oracle_date_2 as a date field. Update the table set oracle_date_2=trunc(oracle_date) add a trigger to fill in oracle_date_2 when you insert a row or update the oracle_date column create an index on oracle_date_2 and change the query to use that column --- [EMAIL PROTECTED] wrote: > > I've got the following SQL statement that is running very long on a > nightly > data load. The problem is the TO_CHAR function which is preventing > me from using the index on this small (20,000-row table). > > This is an 8.0.4 database so it is not possible for me to use > make this a function-based index. > > The problem is that the date field has minutes, etc. included and > those need to be eliminated before the comparison can be made. > That's why I can't just eliminate the TO_CHAR from both sides > of the equation. > > Isn't there a way that I can pull this function out of the select > statement > and do it in a preceeding statement? Then I could just pass in both > variables to this statement without the TO_CHAR and use my index. > > Is this realistic? How, exactly could it be done? > > > SELECT DATE_KEY > FROM DATE_DIM > WHERE TO_CHAR(ORACLE_DATE,'DD-MON-') = > TO_CHAR(:b1,'DD-MON-') > > > SQL> desc date_dim; > NameNull?Type > --- > DATE_KEYNOT NULL NUMBER(5) > ORACLE_DATE NOT NULL DATE > DATACOM_DATE NUMBER(6) > DATACOM_REVERSE_DATE NUMBER(6) > DAY_OF_WEEK NOT NULL VARCHAR2(30) > DAY_NUMBER_IN_MONTH NOT NULL NUMBER(3) > DAY_NUMBER_OVERALL NOT NULL NUMBER(9) > WEEK_NUMBER_IN_YEAR NOT NULL NUMBER(3) > WEEK_NUMBER_OVERALL NOT NULL NUMBER(7) > MONTH NOT NULL VARCHAR2(30) > MONTH_NUMBER_OVERALLNOT NULL NUMBER(7) > YEARNOT NULL NUMBER(5) > WEEKDAY_IND NOT NULL CHAR(1) > LAST_DAY_IN_MONTH_IND NOT NULL CHAR(1) > DATA_WAREHOUSE_MOD_DATETIME NOT NULL DATE > DATA_MART_MOD_DATETIME NOT NULL DATE > > > > SQL> select oracle_date from date_dim where rownum=1; > > ORACLE_DA > - > 01-JAN-70 > > > Thanks in advance for any help. > > Cherie Machler > Oracle DBA > Gelco Information Network > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Califo
RE: Rman ... what do YOU need
>>Hope you cover *all* available MML stuff.. like IBM/Tivoli ADSM/TSM, Legato >>etc.. etc.. and how to setup and use RMAN for Disaster Recovery scenarios I have not yet figured out how I can do all of that (though I'd love to), as my environment only supports the Legato stuff. I might have to find someone that uses the other MML's. RF -Original Message- Sent: Tuesday, April 09, 2002 3:16 PM To: Multiple recipients of list ORACLE-L Robert, That's good to know. A dedicated RMAN book would be great !! Hope you cover *all* available MML stuff.. like IBM/Tivoli ADSM/TSM, Legato etc.. etc.. and how to setup and use RMAN for Disaster Recovery scenarios, where databases would be recovered on different server and different location. Good Luck.. Regards, - Kirti -Original Message- Sent: Tuesday, April 09, 2002 1:12 PM To: 'Deshpande, Kirti'; [EMAIL PROTECTED] I have the book, and it is a pretty good 101 book. My book seeks to go to the next level, looking at things like the data dictionary views, the recovery catalog tables and how they are used, backup and recovery case studies, and the like. I will look for input from this thread for additional content. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, April 09, 2002 1:40 PM To: [EMAIL PROTECTED]; Freeman, Robert FWIW -- Oracle Press recently published a "Backup & Recovery 101" book by Kenny Smith and Stephan Haisley. I have not yet read it, but it claims to have RMAN coverage. Since it is part of the '101' series, I presume it covers most of the basic stuff. Has anyone purchased it? And read it? I may check it out at IOUG-A next week :) Regards, - Kirti -Original Message- Sent: Tuesday, April 09, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, April 08, 2002 2:54 PM To: Multiple recipients of list ORACLE-L I don't think you can do it.. I mean, you could change it to trunc the oracle_date field (that eliminates the minutes) and then do a to_date of :b1 but you will still be operating on the oracle_date field. Okay, I HATE to suggest this, but since the table is small: add another field to the table oracle_date_2 as a date field. Update the table set oracle_date_2=trunc(oracle_date) add a trigger to fill in oracle_date_2 when you insert a row or update the oracle_date column create an index on oracle_date_2 and change the query to use that column --- [EMAIL PROTECTED] wrote: > > I've got the following SQL statement that is running very long on a > nightly > data load. The problem is the TO_CHAR function which is preventing > me from using the index on this small (20,000-row table). > > This is an 8.0.4 database so it is not possible for me to use > make this a function-based index. > > The problem is that the date field has minutes, etc. included and > those need to be eliminated before the comparison can be made. > That's why I can't just eliminate the TO_CHAR from both sides > of the equation. > > Isn't there a way that I can pull this function out of the select > statement > and do it in a preceeding statement? Then I could just pass in both > variables to this statement without the TO_CHAR and use my index. > > Is this realistic? How, exactly could it be done? > > > SELECT DATE_KEY > FROM DATE_DIM > WHERE TO_CHAR(ORACLE_DATE,'DD-MON-') = > TO_CHAR(:b1,'DD-MON-') > > > SQL> desc date_dim; > NameNull?Type > --- > DATE_KEYNOT NULL NUMBER(5) > ORACLE_DATE NOT NULL DATE > DATACOM_DATE NUMBER(6) > DATACOM_REVERSE_DATE NUMBER(6) > DAY_OF_WEEK NOT NULL VARCHAR2(30) > DAY_NUMBER_IN_MONTH NOT NULL NUMBER(3) > DAY_NUMBER_OVERALL NOT NULL NUMBER(9) > WEEK_NUMBER_IN_YEAR NOT NULL NUMBER(3) > WEEK_NUMBER_OVERALL NOT NULL NUMBER(7) > MONTH NOT NULL VARCHAR2(30) > MONTH_NUMBER_OVERALLNOT NULL NUMBER(7) > YEARNOT NULL NUMBER(5) > WEEKDAY_IND NOT NULL CHAR(1) > LAST_DAY_IN_MONTH_IND NOT NULL CHAR(1) > DATA_WAREHOUSE_MOD_DATETIME NOT NULL DATE > DATA_MART_MOD_DATETIME NOT NULL DATE > >
RE: Rman ... what do YOU need
How about an exhaustive list of differences between running with a catalog and without. In the documentation it is so brief. It also seems that the disadvantages of running nocatalog are becoming less and less. I flipped out at first when I found out I wouldn't have another license (and therefore no rcat) but the more I read about it, the more I saw it was OK. There's even a note on Metalink about how to perform TSPITR without a catalog with one of the more recent versions. ??? I would run out and buy a book on this topic in a second if it was very detailed. The documentation is just too brief at times. Lisa Koivu Oracle Database TANK Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: James Howerton [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 3:09 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Rman ... what do YOU need > > I agree with Ethan. > > 1. Please give some good examples for working the various storage > management > products, Veritas, Tivoli, Legato, etc? I've spent a huge ammount of > time trying to get the transport layer working properly. > 2. Cloning (I can share the scripts I've used) again I had a lot of > difficulty getting this to work with Veritas Netbackup. > 3. Anything to enhance business continuity, disaster recovery > procedures. > > Thanks > ...JIM... > > >>> [EMAIL PROTECTED] 4/9/02 1:40:39 PM >>> > A section on itegration and best practices with various storage > management > products. In one case I back up to a Tivoli Storage Management > server. > Storage group said I would need an addtional product to use TSM with > RMAN > and that I would still not be able to have some functionality. Never > cared > enough to try to figure it all out. At the moment I have my own hot > backup > scripts. Would like to know what else is being done and what the > limitations are. > > Ethan Post > perotdba (AIM), epost1 (Yahoo) > > > > -Original Message- > Sent: Tuesday, April 09, 2002 12:54 PM > To: Multiple recipients of list ORACLE-L > > > I'm contemplating doing an Rman backup and recovery handbook. I'm > wondering > what you would like to see in such a book and would you use such a > book? > Ideas and comments welcome. > > Robert G. Freeman - Oracle8i OCP > Oracle DBA Technical Lead > CSX Midtier Database Administration > > The Cigarette Smoking Man: Anyone who can appease a man's conscience > can > take his freedom away from him. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Post, Ethan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: James Howerton > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
migrate from 8i to 9i
Hi friends, I need your advise on the following question. I have DB on 8i and I want create new one on another machine with 9i. I thought do the following steps: 1 - Install oracle 9i on a new machine 2 - make full export of the 8i DB 3 - import it on the new one (9i) So before I proceed I need your input. Am I correct with these steps? There is something wrong? Many thanks for you, Kader __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rman ... what do YOU need
I have the book, and it is a pretty good 101 book. My book seeks to go to the next level, looking at things like the data dictionary views, the recovery catalog tables and how they are used, backup and recovery case studies, and the like. I will look for input from this thread for additional content. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, April 09, 2002 1:40 PM To: [EMAIL PROTECTED]; Freeman, Robert FWIW -- Oracle Press recently published a "Backup & Recovery 101" book by Kenny Smith and Stephan Haisley. I have not yet read it, but it claims to have RMAN coverage. Since it is part of the '101' series, I presume it covers most of the basic stuff. Has anyone purchased it? And read it? I may check it out at IOUG-A next week :) Regards, - Kirti -Original Message- Sent: Tuesday, April 09, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, April 08, 2002 2:54 PM To: Multiple recipients of list ORACLE-L I don't think you can do it.. I mean, you could change it to trunc the oracle_date field (that eliminates the minutes) and then do a to_date of :b1 but you will still be operating on the oracle_date field. Okay, I HATE to suggest this, but since the table is small: add another field to the table oracle_date_2 as a date field. Update the table set oracle_date_2=trunc(oracle_date) add a trigger to fill in oracle_date_2 when you insert a row or update the oracle_date column create an index on oracle_date_2 and change the query to use that column --- [EMAIL PROTECTED] wrote: > > I've got the following SQL statement that is running very long on a > nightly > data load. The problem is the TO_CHAR function which is preventing > me from using the index on this small (20,000-row table). > > This is an 8.0.4 database so it is not possible for me to use > make this a function-based index. > > The problem is that the date field has minutes, etc. included and > those need to be eliminated before the comparison can be made. > That's why I can't just eliminate the TO_CHAR from both sides > of the equation. > > Isn't there a way that I can pull this function out of the select > statement > and do it in a preceeding statement? Then I could just pass in both > variables to this statement without the TO_CHAR and use my index. > > Is this realistic? How, exactly could it be done? > > > SELECT DATE_KEY > FROM DATE_DIM > WHERE TO_CHAR(ORACLE_DATE,'DD-MON-') = > TO_CHAR(:b1,'DD-MON-') > > > SQL> desc date_dim; > NameNull?Type > --- > DATE_KEYNOT NULL NUMBER(5) > ORACLE_DATE NOT NULL DATE > DATACOM_DATE NUMBER(6) > DATACOM_REVERSE_DATE NUMBER(6) > DAY_OF_WEEK NOT NULL VARCHAR2(30) > DAY_NUMBER_IN_MONTH NOT NULL NUMBER(3) > DAY_NUMBER_OVERALL NOT NULL NUMBER(9) > WEEK_NUMBER_IN_YEAR NOT NULL NUMBER(3) > WEEK_NUMBER_OVERALL NOT NULL NUMBER(7) > MONTH NOT NULL VARCHAR2(30) > MONTH_NUMBER_OVERALLNOT NULL NUMBER(7) > YEARNOT NULL NUMBER(5) > WEEKDAY_IND NOT NULL CHAR(1) > LAST_DAY_IN_MONTH_IND NOT NULL CHAR(1) > DATA_WAREHOUSE_MOD_DATETIME NOT NULL DATE > DATA_MART_MOD_DATETIME NOT NULL DATE > > > > SQL> select oracle_date from date_dim where rownum=1; > > ORACLE_DA > - > 01-JAN-70 > > > Thanks in advance for any help. > > Cherie Machler > Oracle DBA > Gelco Information Network > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). ___
RE: Rman ... what do YOU need
Robert, That's good to know. A dedicated RMAN book would be great !! Hope you cover *all* available MML stuff.. like IBM/Tivoli ADSM/TSM, Legato etc.. etc.. and how to setup and use RMAN for Disaster Recovery scenarios, where databases would be recovered on different server and different location. Good Luck.. Regards, - Kirti -Original Message- Sent: Tuesday, April 09, 2002 1:12 PM To: 'Deshpande, Kirti'; [EMAIL PROTECTED] I have the book, and it is a pretty good 101 book. My book seeks to go to the next level, looking at things like the data dictionary views, the recovery catalog tables and how they are used, backup and recovery case studies, and the like. I will look for input from this thread for additional content. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, April 09, 2002 1:40 PM To: [EMAIL PROTECTED]; Freeman, Robert FWIW -- Oracle Press recently published a "Backup & Recovery 101" book by Kenny Smith and Stephan Haisley. I have not yet read it, but it claims to have RMAN coverage. Since it is part of the '101' series, I presume it covers most of the basic stuff. Has anyone purchased it? And read it? I may check it out at IOUG-A next week :) Regards, - Kirti -Original Message- Sent: Tuesday, April 09, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, April 08, 2002 2:54 PM To: Multiple recipients of list ORACLE-L I don't think you can do it.. I mean, you could change it to trunc the oracle_date field (that eliminates the minutes) and then do a to_date of :b1 but you will still be operating on the oracle_date field. Okay, I HATE to suggest this, but since the table is small: add another field to the table oracle_date_2 as a date field. Update the table set oracle_date_2=trunc(oracle_date) add a trigger to fill in oracle_date_2 when you insert a row or update the oracle_date column create an index on oracle_date_2 and change the query to use that column --- [EMAIL PROTECTED] wrote: > > I've got the following SQL statement that is running very long on a > nightly > data load. The problem is the TO_CHAR function which is preventing > me from using the index on this small (20,000-row table). > > This is an 8.0.4 database so it is not possible for me to use > make this a function-based index. > > The problem is that the date field has minutes, etc. included and > those need to be eliminated before the comparison can be made. > That's why I can't just eliminate the TO_CHAR from both sides > of the equation. > > Isn't there a way that I can pull this function out of the select > statement > and do it in a preceeding statement? Then I could just pass in both > variables to this statement without the TO_CHAR and use my index. > > Is this realistic? How, exactly could it be done? > > > SELECT DATE_KEY > FROM DATE_DIM > WHERE TO_CHAR(ORACLE_DATE,'DD-MON-') = > TO_CHAR(:b1,'DD-MON-') > > > SQL> desc date_dim; > NameNull?Type > --- > DATE_KEYNOT NULL NUMBER(5) > ORACLE_DATE NOT NULL DATE > DATACOM_DATE NUMBER(6) > DATACOM_REVERSE_DATE NUMBER(6) > DAY_OF_WEEK NOT NULL VARCHAR2(30) > DAY_NUMBER_IN_MONTH NOT NULL NUMBER(3) > DAY_NUMBER_OVERALL NOT NULL NUMBER(9) > WEEK_NUMBER_IN_YEAR NOT NULL NUMBER(3) > WEEK_NUMBER_OVERALL NOT NULL NUMBER(7) > MONTH NOT NULL VARCHAR2(30) > MONTH_NUMBER_OVERALLNOT NULL NUMBER(7) > YEARNOT NULL NUMBER(5) > WEEKDAY_IND NOT NULL CHAR(1) > LAST_DAY_IN_MONTH_IND NOT NULL CHAR(1) > DATA_WAREHOUSE_MOD_DATETIME NOT NULL DATE > DATA_MART_MOD_DATETIME NOT NULL DATE > > > > SQL> select oracle_date from date_dim where rownum=1; > > ORACLE_DA > - > 01-JAN-70 > > > Thanks in advance for any help. > > Cherie Machler > Oracle DBA > Gelco Information Network > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public In
RE: Rman ... what do YOU need
I agree with Ethan. 1. Please give some good examples for working the various storage management products, Veritas, Tivoli, Legato, etc? I've spent a huge ammount of time trying to get the transport layer working properly. 2. Cloning (I can share the scripts I've used) again I had a lot of difficulty getting this to work with Veritas Netbackup. 3. Anything to enhance business continuity, disaster recovery procedures. Thanks ...JIM... >>> [EMAIL PROTECTED] 4/9/02 1:40:39 PM >>> A section on itegration and best practices with various storage management products. In one case I back up to a Tivoli Storage Management server. Storage group said I would need an addtional product to use TSM with RMAN and that I would still not be able to have some functionality. Never cared enough to try to figure it all out. At the moment I have my own hot backup scripts. Would like to know what else is being done and what the limitations are. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Tuesday, April 09, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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: Oracle vs. MS SQL
I have a buddy that works for Gartner. Says they have a deal that if you call them they will come in free of charge and look at the price you have negotiated with Oracle. They will then make a recommended price or negotiate the deal, not sure which. They get to keep 25% of the total savings. Just heard this the other day and don't have all the details but just wanted to throw it out there. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Tuesday, April 09, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Sorry, my mistake. Just checked the Oracle store: 40k per CPU for EE. Yikes! Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN with Tivoli Data Protection for Oracle
Hi: Anyone using RMAN with TDP backup to tape on AIX system? Do I need to install TDP on every target database or just on recovery catalog database? Thanks!
RE: RE: Oracle vs. MS SQL
MSRP. Of course, the actual price depends on which part of the fiscal year you catch the sales weasels in... :) Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- [EMAIL PROTECTED] Sent: Tuesday, April 09, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Sorry, my mistake. Just checked the Oracle store: 40k per CPU for EE. Yikes! Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/09/02 07:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: RE: Oracle vs. MS SQL Jared - The list prices we were able to find were Standard Edition Unlimited users $15,000 per CPU Enterprise Edition Unlimited users $40,000 per CPU This is list, your organization may be able to get a better deal. Needless to say, for new projects we have been looking VERY hard to see if SE will suffice. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 08, 2002 1:21 PM To: Multiple recipients of list ORACLE-L CPU pricing for enterprise edition is $15k per CPU. $40k is undoubtedly with a number of options, advanced replication, partitioning, ... Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/08/02 07:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: RE: Oracle vs. MS SQL Gene - The $40K is the Enterprise Edition pricing as I recall. Can you move to Standard Edition? If you are using EE features, then chances are that MS SQL won't do the job. Also you can point out the eWeek benchmark between Oracle and MS SQL. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 05, 2002 6:23 PM To: Multiple recipients of list ORACLE-L OK, timing is impeccable. My boss just got the Oracle Bill, new licensing model $40k per processor for web based apps and flipped. I have some MSCE's working here pushing him to switch to SQL*server. Does anyone know where I can find reasons to stay w/ Oracle? Some things already mentioned here, but the MSCE's would say this list is bias, go figure :) Does SQLServer 2000 support blobs, row level locking, etc? Thanks, Gene PS. Do I move on to another Oracle shop or switch to SQLserver? OMG, the thought of working only on windoze makes me puke. I know this answer! >>> [EMAIL PROTECTED] 04/05/02 14:11 PM >>> There are some technical points worth considering. For example, SQL Server does not have true row level locking. It's table level locking, or some really creative SQL to fake it. This has a direct impact on scalability and performance. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Oops, a couple of items I didn't make clear: > - I was never able to compare the cost of Oracle > support with the cost of > Microsoft support. Oracle prices annual maintenance, > which includes the > right to upgrade to a new version of Oracle. MS > prices out per incident or > for all MS software at a location. If you can > estimate the number of > calls/month, then you could compare. > - Oracle DBA salary vs. MS SQL DBA salary. I feel > the difference is > primarily due to less experience, training. I find > it ironic that this > probably causes less reliability for Microsoft > (Microsoft has even > complained that organizations don't assign their > best people to administer > MS products), yet then Microsoft brags about how you > can save money because > their people ar cheaper. > > -Original Message- > Sent: Friday, April 05, 2002 11:14 AM > To: Multiple recipients of list ORACLE-L > > > I recently prepared a total cost comparison between > Oracle and MS SQL. I > appreciate the support several people on this list > provided me. In return, > here are some of the main points I learned. > - For smaller systems, investigate whether Oracle > Standard Edition will > meet your requirements. For example, most people > assume that to use > replication, you need EE. For our purposes the basic > replication that comes > with SE was adequate. > - Microsoft also offers SQL in both EE and SE > versions. Thanks very much > to Gints Plivna for providing me a > feature-by-feature comparison between the > different versions. MS SE is not equivalent to > Oracle SE. In most cases, the > more valid comparison is between MS SQL EE and > Oracle SE. > - For maintenance, there are two parts to > consider: Upgrade privilege and > support. Oracle bundles both of these together. Make > sure Microsoft is > priced with Software Assurance, which gives upgrade > privilege. Microsoft > prices support by the incident or by the location > (all Microsoft software). > I was never able to
RE: Rman ... what do YOU need
FWIW -- Oracle Press recently published a "Backup & Recovery 101" book by Kenny Smith and Stephan Haisley. I have not yet read it, but it claims to have RMAN coverage. Since it is part of the '101' series, I presume it covers most of the basic stuff. Has anyone purchased it? And read it? I may check it out at IOUG-A next week :) Regards, - Kirti -Original Message- Sent: Tuesday, April 09, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, April 08, 2002 2:54 PM To: Multiple recipients of list ORACLE-L I don't think you can do it.. I mean, you could change it to trunc the oracle_date field (that eliminates the minutes) and then do a to_date of :b1 but you will still be operating on the oracle_date field. Okay, I HATE to suggest this, but since the table is small: add another field to the table oracle_date_2 as a date field. Update the table set oracle_date_2=trunc(oracle_date) add a trigger to fill in oracle_date_2 when you insert a row or update the oracle_date column create an index on oracle_date_2 and change the query to use that column --- [EMAIL PROTECTED] wrote: > > I've got the following SQL statement that is running very long on a > nightly > data load. The problem is the TO_CHAR function which is preventing > me from using the index on this small (20,000-row table). > > This is an 8.0.4 database so it is not possible for me to use > make this a function-based index. > > The problem is that the date field has minutes, etc. included and > those need to be eliminated before the comparison can be made. > That's why I can't just eliminate the TO_CHAR from both sides > of the equation. > > Isn't there a way that I can pull this function out of the select > statement > and do it in a preceeding statement? Then I could just pass in both > variables to this statement without the TO_CHAR and use my index. > > Is this realistic? How, exactly could it be done? > > > SELECT DATE_KEY > FROM DATE_DIM > WHERE TO_CHAR(ORACLE_DATE,'DD-MON-') = > TO_CHAR(:b1,'DD-MON-') > > > SQL> desc date_dim; > NameNull?Type > --- > DATE_KEYNOT NULL NUMBER(5) > ORACLE_DATE NOT NULL DATE > DATACOM_DATE NUMBER(6) > DATACOM_REVERSE_DATE NUMBER(6) > DAY_OF_WEEK NOT NULL VARCHAR2(30) > DAY_NUMBER_IN_MONTH NOT NULL NUMBER(3) > DAY_NUMBER_OVERALL NOT NULL NUMBER(9) > WEEK_NUMBER_IN_YEAR NOT NULL NUMBER(3) > WEEK_NUMBER_OVERALL NOT NULL NUMBER(7) > MONTH NOT NULL VARCHAR2(30) > MONTH_NUMBER_OVERALLNOT NULL NUMBER(7) > YEARNOT NULL NUMBER(5) > WEEKDAY_IND NOT NULL CHAR(1) > LAST_DAY_IN_MONTH_IND NOT NULL CHAR(1) > DATA_WAREHOUSE_MOD_DATETIME NOT NULL DATE > DATA_MART_MOD_DATETIME NOT NULL DATE > > > > SQL> select oracle_date from date_dim where rownum=1; > > ORACLE_DA > - > 01-JAN-70 > > > Thanks in advance for any help. > > Cherie Machler > Oracle DBA > Gelco Information Network > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, includ
RE: Rman ... what do YOU need
A section on itegration and best practices with various storage management products. In one case I back up to a Tivoli Storage Management server. Storage group said I would need an addtional product to use TSM with RMAN and that I would still not be able to have some functionality. Never cared enough to try to figure it all out. At the moment I have my own hot backup scripts. Would like to know what else is being done and what the limitations are. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Tuesday, April 09, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rman ... what do YOU need
Robert, Put me on the list for a copy when you finish. Seriously, It is a needed book that will make sense of the information presented in the doc's. A down to earth instruction manual that explains in real terms the usage and options for RMAN. Lisa posed a question about the different views and their interrelations and she wanted to know about deleting old backup sets when you do not use a catalog. It seams that Oracle docs only talk about using a catalog. A lot of us do not have the need for a catalog and tying the command to the non catalog RMAN would be helpful. Answer to simple question like: Do have to use RMAN to backup my read only tablespaces? How do I get the tape drive to work with RMAN? How do I perform a database backup when I only have 5 GIG free space and the data is 20 GIG? If I use OEM to run the backups can I have my OMS on the same server? Does OEM backup use RMAN in a GUI form? Can I use RMAN to restore a database that was backup up with OEM backup? Just a few questions that are encountered each day as we go through the process of backing up our data. Ron ROR mô¿ôm >>> [EMAIL PROTECTED] 04/09/02 01:53PM >>> I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- 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).
Function based index
Hi, If I have a function based index such as CREATE INDEX emp_idx01 on emp(SUBSTR(first_name,1,20)) Is there a way to build index where 1,20 portion can be parameterized? If so how would this be done? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Oracle vs. MS SQL
Sorry, my mistake. Just checked the Oracle store: 40k per CPU for EE. Yikes! Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/09/02 07:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: RE: Oracle vs. MS SQL Jared - The list prices we were able to find were Standard Edition Unlimited users $15,000 per CPU Enterprise Edition Unlimited users $40,000 per CPU This is list, your organization may be able to get a better deal. Needless to say, for new projects we have been looking VERY hard to see if SE will suffice. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 08, 2002 1:21 PM To: Multiple recipients of list ORACLE-L CPU pricing for enterprise edition is $15k per CPU. $40k is undoubtedly with a number of options, advanced replication, partitioning, ... Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/08/02 07:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: RE: Oracle vs. MS SQL Gene - The $40K is the Enterprise Edition pricing as I recall. Can you move to Standard Edition? If you are using EE features, then chances are that MS SQL won't do the job. Also you can point out the eWeek benchmark between Oracle and MS SQL. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 05, 2002 6:23 PM To: Multiple recipients of list ORACLE-L OK, timing is impeccable. My boss just got the Oracle Bill, new licensing model $40k per processor for web based apps and flipped. I have some MSCE's working here pushing him to switch to SQL*server. Does anyone know where I can find reasons to stay w/ Oracle? Some things already mentioned here, but the MSCE's would say this list is bias, go figure :) Does SQLServer 2000 support blobs, row level locking, etc? Thanks, Gene PS. Do I move on to another Oracle shop or switch to SQLserver? OMG, the thought of working only on windoze makes me puke. I know this answer! >>> [EMAIL PROTECTED] 04/05/02 14:11 PM >>> There are some technical points worth considering. For example, SQL Server does not have true row level locking. It's table level locking, or some really creative SQL to fake it. This has a direct impact on scalability and performance. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Oops, a couple of items I didn't make clear: > - I was never able to compare the cost of Oracle > support with the cost of > Microsoft support. Oracle prices annual maintenance, > which includes the > right to upgrade to a new version of Oracle. MS > prices out per incident or > for all MS software at a location. If you can > estimate the number of > calls/month, then you could compare. > - Oracle DBA salary vs. MS SQL DBA salary. I feel > the difference is > primarily due to less experience, training. I find > it ironic that this > probably causes less reliability for Microsoft > (Microsoft has even > complained that organizations don't assign their > best people to administer > MS products), yet then Microsoft brags about how you > can save money because > their people ar cheaper. > > -Original Message- > Sent: Friday, April 05, 2002 11:14 AM > To: Multiple recipients of list ORACLE-L > > > I recently prepared a total cost comparison between > Oracle and MS SQL. I > appreciate the support several people on this list > provided me. In return, > here are some of the main points I learned. > - For smaller systems, investigate whether Oracle > Standard Edition will > meet your requirements. For example, most people > assume that to use > replication, you need EE. For our purposes the basic > replication that comes > with SE was adequate. > - Microsoft also offers SQL in both EE and SE > versions. Thanks very much > to Gints Plivna for providing me a > feature-by-feature comparison between the > different versions. MS SE is not equivalent to > Oracle SE. In most cases, the > more valid comparison is between MS SQL EE and > Oracle SE. > - For maintenance, there are two parts to > consider: Upgrade privilege and > support. Oracle bundles both of these together. Make > sure Microsoft is > priced with Software Assurance, which gives upgrade > privilege. Microsoft > prices support by the incident or by the location > (all Microsoft software). > I was never able to get a comparison. > - MS SQL EE with Software Assurance is actually > more expensive than Oracle > SE. Priced by the CPU. > - Since pricing is by CPU and RISC systems offer > higher database > performance (according to many people on this list) > and Oracle offers higher > performance in a head-to-head comparison (according > to the recently > published Eweek benchmark), I compared Oracle SE on > a 1-CPU Sun
RE: RE: Oracle vs. MS SQL
The last time I checked SE didn't have patch maintenance. So you could get v8.1.7 but not v8.1.7.3. If that works for you, fine. Didn't work for me. Brian P. MacLean Oracle DBA, OCP8i DENNIS WILLIAMS TOUCH.COM>cc: Sent by: Subject: RE: RE: Oracle vs. MS SQL [EMAIL PROTECTED] m 04/09/02 07:03 AM Please respond to ORACLE-L Jared - The list prices we were able to find were Standard Edition Unlimited users $15,000 per CPU Enterprise Edition Unlimited users $40,000 per CPU This is list, your organization may be able to get a better deal. Needless to say, for new projects we have been looking VERY hard to see if SE will suffice. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 08, 2002 1:21 PM To: Multiple recipients of list ORACLE-L CPU pricing for enterprise edition is $15k per CPU. $40k is undoubtedly with a number of options, advanced replication, partitioning, ... Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/08/02 07:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: RE: Oracle vs. MS SQL Gene - The $40K is the Enterprise Edition pricing as I recall. Can you move to Standard Edition? If you are using EE features, then chances are that MS SQL won't do the job. Also you can point out the eWeek benchmark between Oracle and MS SQL. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 05, 2002 6:23 PM To: Multiple recipients of list ORACLE-L OK, timing is impeccable. My boss just got the Oracle Bill, new licensing model $40k per processor for web based apps and flipped. I have some MSCE's working here pushing him to switch to SQL*server. Does anyone know where I can find reasons to stay w/ Oracle? Some things already mentioned here, but the MSCE's would say this list is bias, go figure :) Does SQLServer 2000 support blobs, row level locking, etc? Thanks, Gene PS. Do I move on to another Oracle shop or switch to SQLserver? OMG, the thought of working only on windoze makes me puke. I know this answer! >>> [EMAIL PROTECTED] 04/05/02 14:11 PM >>> There are some technical points worth considering. For example, SQL Server does not have true row level locking. It's table level locking, or some really creative SQL to fake it. This has a direct impact on scalability and performance. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Oops, a couple of items I didn't make clear: > - I was never able to compare the cost of Oracle > support with the cost of > Microsoft support. Oracle prices annual maintenance, > which includes the > right to upgrade to a new version of Oracle. MS > prices out per incident or > for all MS software at a location. If you can > estimate the number of > calls/month, then you could compare. > - Oracle DBA salary vs. MS SQL DBA salary. I feel > the difference is > primarily due to less experience, training. I find > it ironic that this > probably causes less reliability for Microsoft > (Microsoft has even > complained that organizations don't assign their > best people to administer > MS products), yet then Microsoft brags about how you > can save money because > their people ar chea
RE: Oracle 9i SE vs EE and options
Yea, but just how fast would that used car lookup, sort and group 2 TB of data? :-) RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, April 09, 2002 1:13 PM To: Multiple recipients of list ORACLE-L Dennis is right. We had to pay extra for partitioning, on top of EE. What a lovely day it was. The total (to run on a wimpy w2k machine, named user) could have bought me a new car. Lisa Koivu Oracle Database Dog Catcher Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 12:28 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle 9i SE vs EE and options > > Ron - My interpretation, based on Oracle Partitioning, is that "Option" > means that you need Enterprise Edition and you must pay extra on top of > that. Thanks for passing this along. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, April 09, 2002 10:23 AM > To: Multiple recipients of list ORACLE-L > > > List, > If I read this chart correctly it displays what is provided with the > Standard Edition and the Enterprise Edition. The Option column is what > is extra and you pay for it??? Am I correct in what I read about the > option column. > > http://www.oracle.com/ip/deploy/database/oracle9i/index.html?packagingando > pt > ions.html > > > If this is true it is nice to see it finally displayed rather than > double talk from a salesman. > Ron > 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: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Rman ... what do YOU need
I'm contemplating doing an Rman backup and recovery handbook. I'm wondering what you would like to see in such a book and would you use such a book? Ideas and comments welcome. Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, April 08, 2002 2:54 PM To: Multiple recipients of list ORACLE-L I don't think you can do it.. I mean, you could change it to trunc the oracle_date field (that eliminates the minutes) and then do a to_date of :b1 but you will still be operating on the oracle_date field. Okay, I HATE to suggest this, but since the table is small: add another field to the table oracle_date_2 as a date field. Update the table set oracle_date_2=trunc(oracle_date) add a trigger to fill in oracle_date_2 when you insert a row or update the oracle_date column create an index on oracle_date_2 and change the query to use that column --- [EMAIL PROTECTED] wrote: > > I've got the following SQL statement that is running very long on a > nightly > data load. The problem is the TO_CHAR function which is preventing > me from using the index on this small (20,000-row table). > > This is an 8.0.4 database so it is not possible for me to use > make this a function-based index. > > The problem is that the date field has minutes, etc. included and > those need to be eliminated before the comparison can be made. > That's why I can't just eliminate the TO_CHAR from both sides > of the equation. > > Isn't there a way that I can pull this function out of the select > statement > and do it in a preceeding statement? Then I could just pass in both > variables to this statement without the TO_CHAR and use my index. > > Is this realistic? How, exactly could it be done? > > > SELECT DATE_KEY > FROM DATE_DIM > WHERE TO_CHAR(ORACLE_DATE,'DD-MON-') = > TO_CHAR(:b1,'DD-MON-') > > > SQL> desc date_dim; > NameNull?Type > --- > DATE_KEYNOT NULL NUMBER(5) > ORACLE_DATE NOT NULL DATE > DATACOM_DATE NUMBER(6) > DATACOM_REVERSE_DATE NUMBER(6) > DAY_OF_WEEK NOT NULL VARCHAR2(30) > DAY_NUMBER_IN_MONTH NOT NULL NUMBER(3) > DAY_NUMBER_OVERALL NOT NULL NUMBER(9) > WEEK_NUMBER_IN_YEAR NOT NULL NUMBER(3) > WEEK_NUMBER_OVERALL NOT NULL NUMBER(7) > MONTH NOT NULL VARCHAR2(30) > MONTH_NUMBER_OVERALLNOT NULL NUMBER(7) > YEARNOT NULL NUMBER(5) > WEEKDAY_IND NOT NULL CHAR(1) > LAST_DAY_IN_MONTH_IND NOT NULL CHAR(1) > DATA_WAREHOUSE_MOD_DATETIME NOT NULL DATE > DATA_MART_MOD_DATETIME NOT NULL DATE > > > > SQL> select oracle_date from date_dim where rownum=1; > > ORACLE_DA > - > 01-JAN-70 > > > Thanks in advance for any help. > > Cherie Machler > Oracle DBA > Gelco Information Network > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --
Re: Export taking to long
Hi, try setting BUFFER (size of data buffer) big enough and statistics=n if the default is Y By - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 5:33 PM > What about using a direct export? > > Also, you could look at the v$session_wait view to see what it is waiting > on. > > It could be something like you are reading and writing to the same disk. > > Also, have you tried it without trying to compress it? It may not be an > Oracle issue, > > Jim > > -Original Message- > L. > Sent: 09 April 2002 15:28 > To: Multiple recipients of list ORACLE-L > > > I have an export of a 16G database that is consistently taking 6 hours to > export. > It doesn't matter what time of the day or night the script is executed. > There is > very little activity on the server. Any ideas? > > #!/bin/ksh > export ORACLE_SID=adprod > export ORACLE_HOME=`grep $ORACLE_SID /etc/oratab | cut -d : -f2` > PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:. > export USERPASS=system/sysada2 > # > # Create a new pipe each time > # > if [ -p exp_pipe_$ORACLE_SID ] > then rm exp_pipe_$ORACLE_SID > fi > mknod exp_pipe_$ORACLE_SID p > > OUTFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.dmp.Z" > LOGFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.log" > # > # Begin compress job and export to pipe with userid and password hidden > # > compress < /oracle_dba/expimp/adprod/exp_pipe_adprod > $OUTFILE & > exp $USERPASS full=y compress=n consistent=y recordlength=65535 direct=y > file=/oracle_dba/expimp/adprod/exp_pipe_adprod log= > $LOGFILE > > > > Ron Smith > DBA > Kerr-McGee Corp > > > > -- > 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: James McCann > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: claudio cutelli INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 read user dump file
If the user dump file is an output of a traced session, use tkprof to generate a *.prf and the vi *.prf --- CSW > -Original Message- > From: Yahoo [SMTP:[EMAIL PROTECTED]] > Sent: Monday, April 08, 2002 5:24 PM > To: Multiple recipients of list ORACLE-L > Subject: How to read user dump file > > Hi: > Can anyone of you tell me what tool to use in order to get a report > out from user dump file? Many thanks! -- 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: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using OID
Hi Rich, Thanks much for detailed information. I was glad to see an OID implementation out in the field. Couple of more questions: I know TNSNAMES.ORA can be replaced by OID, but have you taken the next step and migrated Oracle accounts to OID? We are looking at OID to centralize user management tasks that have become very resource intensive, given large number of Oracle databases at our site. I was researching Oracle web sites and other sites, but didn't find any white paper about OID and centralized user management. Sure, our goal is to have single-sign-on, but our applications are not SSO compliant yet, and are not going to be SSO-compliant any time soon. So, we are looking at only migrating accounts to OID if that's possible. Could OID be used as a centralize authentication repository? Does it require applications modifications? Any experience with this task? Thanks, Jay -Original Message- Sent: Monday, April 08, 2002 4:48 PM To: Multiple recipients of list ORACLE-L OiD! After several weeks of pain, here's what I've learned: 1) Create your database(s) manually. The GUI creates the traditional "the least we need to get it going without a real DBA" database. Note 159031.1 on Metalink will guide you thru the basic create. 2) If you intend on using replication (a good idea), study up on Oracle ASR, but realize that OiD doesn't use ASR in the traditional way, at least according to Oracle Support. In other words, if OiD has problems replicating, it's an OiD problem and not an ASR problem, as far as Oracle Support is concerned. 3) According to Oracle Support, you cannot use hot backups as a reliable means of backup/recovery for OiD in a replicated environment. While I agree with their reasoning in theory, I believe that a good DBA (and me, too!) can still use it, but with care on the recovery. For more info, see the OiD Admin Guide. 4) Speaking of the OiD Admin Guide: Read it, learn it, study it, know it. All 688 pages of it. The concepts in there are KEY! The one that burned me is the concept of a Remote Definition Site (RDS). You're "primary" server is the MDS (Master Definition Site). We tried to treat our second "backup" OiD server as a read-only. Don't do it. Treat all other replication nodes as RDSs. It will save you tons of headaches. 5) Why isn't "RDS" mentioned specifically in the OiD Admin Guide? Because of a lack of coherent documentation. Lookup all the articles you can on Metalink regarding OiD. Some haven't been updated for v3, but they're still good. 6) Do not use any version below 3.0.1 of OiD, which requires (and comes with) Oracle 9i. We had too many bugs, especially in the OiD Administrator program with v2.x. 7) Use Linux. There are some nasty little gotchas in NT/2000 that I really despise (keep reading). 8) Only use an Oracle Certified platform and version of the OS. Oracle Support will have a cow udderwise. 9+) Use scripts to startup and shutdown OiD. If you try and do it manually and shut the oidmon down before the LDAP and replication daemons, the daemons won't shutdown. On Linux, you can restart the oidmon, and the daemons should shutdown, but on NT/2000 they will hang there forever until you re-freaking-boot. Who writes this crap? There's no rebooting on Linux/Unix! I haven't tried OiD on Unix (I think OiD v3's available on HP/Solaris), so I can't say what'll happen there. As an aside, many OiD tools are Unix/Linux shell script, which are not directly available on Windohs. Just another reason to avoid Windows for OiD. 10) I just started to test moving from ONames to OiD. Apparently there's no way to create the "OracleContext" LDAP tree manually, so you've got to use the Oracle Net Config Assist ("netca"). I'm trying to determine if the "update" it does to the OiD DBs schwanzes up the rest of OiD first before continuing. I intend to make my creation of a replicated OiD setup on RedHat 7.1 available on my website, but I just haven't had the time yet, and my PC and Alpha/Linux box are sitting on a concrete slab at home while I redo my basement. :( HTH! GL! I'll let you know when I get that page up.:) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Yechiel Adar [mailto:[EMAIL PROTECTED]] > Sent: Sunday, April 07, 2002 11:18 AM > To: Multiple recipients of list ORACLE-L > Subject: Using OID > > > Hello list > > We intend to implement OID as replacement for tnsnames (at first). > > Pit falls, Real time experience etc...??? > > Yechiel Adar, Mehish. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Export taking to long
Mmmm. . . Ron - How long do you figure it would take you to re-import the 16-gig? Ever tried it? One thing I do is break the export by table so I get all the little tables, the ones I would have a hope of re-importing, into one export file. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 9:28 AM To: Multiple recipients of list ORACLE-L I have an export of a 16G database that is consistently taking 6 hours to export. It doesn't matter what time of the day or night the script is executed. There is very little activity on the server. Any ideas? #!/bin/ksh export ORACLE_SID=adprod export ORACLE_HOME=`grep $ORACLE_SID /etc/oratab | cut -d : -f2` PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:. export USERPASS=system/sysada2 # # Create a new pipe each time # if [ -p exp_pipe_$ORACLE_SID ] then rm exp_pipe_$ORACLE_SID fi mknod exp_pipe_$ORACLE_SID p OUTFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.dmp.Z" LOGFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.log" # # Begin compress job and export to pipe with userid and password hidden # compress < /oracle_dba/expimp/adprod/exp_pipe_adprod > $OUTFILE & exp $USERPASS full=y compress=n consistent=y recordlength=65535 direct=y file=/oracle_dba/expimp/adprod/exp_pipe_adprod log= $LOGFILE Ron Smith DBA Kerr-McGee Corp -- 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ang: RE: Pl/sql question - if statement
[EMAIL PROTECTED] wrote: > Yes but then it fails onthe word borttags_flagg, thi serrormessage : > > > PLS-00103: Encountered the symbol "BORTTAGS_FLAGG" when expecting one of the >following: > >. ( * @ % & = - + < / > at in mod not rem then > <> or != or ~= >= <= <> and or like > > I reallydont see what the error is: > > > Roland from what's shown below you have an extra ' on the end. > > > > > > > "John Hallas" <[EMAIL PROTECTED]>@fatcity.com den 2002-04-09 07:58 PST > > Sänd svar till [EMAIL PROTECTED] > > Sänt av: [EMAIL PROTECTED] > > > Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Kopia: > > Don't you need to start of with a quote before the first A > > If 'A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 '' > > John > > -Original Message- > [EMAIL PROTECTED] > Sent: 09 April 2002 15:43 > To: Multiple recipients of list ORACLE-L > > anyone whom can tell me why this statement fails in a pl/sqll code: > > > I get this error message > PLS-00103: Encountered the symbol "||AvdNr||" when expecting one of the > following: > >. ( * @ % & = - + < / > at in mod not rem then > <> or != or ~= >= <= <> and or like >betwe > > > when i run this statement > > > > > > > If A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 '' > then > > lvSQL := 'SELECT ICA_ARTIKEL.FSGPRIS,ICA_ARTIKEL.PANTBELOPP ' || >--PBK.LPKORGEANREL.EANREL,PBK.LPK > ORGEANREL.VARUTYP ' || > 'FROM > A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| ' ' || >--PBK.LPKORGEANREL ' || > 'WHERE ICA_ARTIKEL.EAN=' || > EanLPVara || ' ' || > 'AND > ICA_ARTIKEL.DATUM -- 'AND > ICA_ARTIKEL.BORTTAGS_FLAGG = 0 ' || > 'ORDER BY DATUM DESC'; > > -- > DBMS_OUTPUT.PUT_LINE(lvSQL); > > DBMS_OUTPUT.PUT_LINE(SUBSTR(lvSQL,1,250)); > > DBMS_OUTPUT.PUT_LINE(SUBSTR(lvSQL,251,250)); > END IF; > > Please help me. I must be blind. I have tried to look at the first code > line.. > Would appreciate help very much. > > > Thanks in advance. > > Roland > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Hallas > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > > > > > > > -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Enthousiamos is being filled with theos. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: RE: Pl/sql question - if statement
'BORTTAGS_FLAGG = 0 '' Two quotes after BORTTAGS_FLAGG = 0 ? I think one quote to much. regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 9. April 2002 18:48 An: Multiple recipients of list ORACLE-L Betreff: Ang: RE: Pl/sql question - if statement Yes but then it fails onthe word borttags_flagg, thi serrormessage : PLS-00103: Encountered the symbol "BORTTAGS_FLAGG" when expecting one of the following: . ( * @ % & = - + < / > at in mod not rem then <> or != or ~= >= <= <> and or like I reallydont see what the error is: Roland "John Hallas" <[EMAIL PROTECTED]>@fatcity.com den 2002-04-09 07:58 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: Don't you need to start of with a quote before the first A If 'A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 '' John -Original Message- [EMAIL PROTECTED] Sent: 09 April 2002 15:43 To: Multiple recipients of list ORACLE-L anyone whom can tell me why this statement fails in a pl/sqll code: I get this error message PLS-00103: Encountered the symbol "||AvdNr||" when expecting one of the following: . ( * @ % & = - + < / > at in mod not rem then <> or != or ~= >= <= <> and or like betwe when i run this statement If A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 '' then lvSQL := 'SELECT ICA_ARTIKEL.FSGPRIS,ICA_ARTIKEL.PANTBELOPP ' || --PBK.LPKORGEANREL.EANREL,PBK.LPK ORGEANREL.VARUTYP ' || 'FROM A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| ' ' || --PBK.LPKORGEANREL ' || 'WHERE ICA_ARTIKEL.EAN=' || EanLPVara || ' ' || 'AND ICA_ARTIKEL.DATUMhttp://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fairly Boring News Article on Oracle
Patrice - For an introduction to web services, go to http://www.computerworld.com/cwi/story/0,1199,NAV47-68-85-1942_STO64099,00.h tml (or go to http://www.computerworld.com, click on Quickstudies, and scroll down to web services). Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 11:23 AM To: Multiple recipients of list ORACLE-L I read the info quickly, so "Web services" are Java apps served on iAS through Portal, Wireless Portal, or Apache. Would that be correct, in a nutshell? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: UWIN 3.0 and ORA-12560 error
I donot have UWIN so I can not test it. However on UNIX using ksh you not only you set the ORACLE_SID and ORACLE_HOME environment variable, but you need to export them as well. try it, Shakir --- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote: > Hello, > I am getting this ORA-12560: TNS Protocol Adapter error, while > connecting > to the local database on my Windoze NT Workstation. This happens when > using > the ksh environment in UWIN 3.0. I have done all the debugging I can > think > of. Everything works fine via DOS Command window. I have checked > Registry > entry and it looked okay to me (ORACLE_SID, ORACLE_HOME etc). My env > variables (PATH, ORACLE_SID, ORACLE_HOME etc) are all fine. I can > connect > via SQL*Net, no problem there. It's just the regular connection under > ksh > environment that is getting this error. > > Has anyone seen this error with UWIN 3.0? I have UWIN 2.0 on my home > PC and > it works fine. > I sure can use some help in resolving this ORA-12560 error. > > Thanks in advance. > > - Kirti > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FAIL OVER SETTING
Hi I have 3 HP9000 enterprise servers and disk array.One of them are application server on which OiAS 9i is installed.On 2 DB server I installed Oracle9i.I want to set up fail over.The disk array is connected with one of primary db server say db01.Whenever DB01 fail then db02 will take take care of application.I want to set up fail over? Is there any way to have fail over without clustering/parallel server. If some one have such kind of setup let me know. Thx Seema _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- 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).
rman views & one other rman question - long, sorry
Hello everyone, I'm digging through rman again. Wish I had more time to do this ongoing. I've looked at the v$views in the past, but didn't dig into them too deeply. Now that my backup strategy is backup to disk -> wait for media manager to take files to tape, I'll need to be able to intelligently tell my SA what files I need should a restore become necessary. I don't have the luxury of a recovery catalog. However, it looks as if the v$ views in the target database will tell me what I need to know. Has anyone ever seen an erd or some documentation stating the relationship between these views? I know that the important ones (so far - v$backup_set, v$backup_datafile, v$backup_redolog, v$backup_piece) are related by set_stamp and set_count. I'd like to be able to create an erd for the dba that will be covering when I'm out on leave. Does v$log_history relate back in somehow? Another thing I'm looking at is deleting old backups. I've been messing with the CHANGE command but it only references backupset and backuppiece. Would I have to give this command for every archive log that I am ready to get rid of? Or is there a twist to this command that will get rid of the backup piece that contains the archive logs? Thanks in advance for any pointers, websites, etc. Lisa Koivu Oracle Database Dog Catcher Fairfield Resorts, Inc. 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ang: RE: Pl/sql question - if statement
Yes but then it fails onthe word borttags_flagg, thi serrormessage : PLS-00103: Encountered the symbol "BORTTAGS_FLAGG" when expecting one of the following: . ( * @ % & = - + < / > at in mod not rem then <> or != or ~= >= <= <> and or like I reallydont see what the error is: Roland "John Hallas" <[EMAIL PROTECTED]>@fatcity.com den 2002-04-09 07:58 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: Don't you need to start of with a quote before the first A If 'A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 '' John -Original Message- [EMAIL PROTECTED] Sent: 09 April 2002 15:43 To: Multiple recipients of list ORACLE-L anyone whom can tell me why this statement fails in a pl/sqll code: I get this error message PLS-00103: Encountered the symbol "||AvdNr||" when expecting one of the following: . ( * @ % & = - + < / > at in mod not rem then <> or != or ~= >= <= <> and or like betwe when i run this statement If A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 '' then lvSQL := 'SELECT ICA_ARTIKEL.FSGPRIS,ICA_ARTIKEL.PANTBELOPP ' || --PBK.LPKORGEANREL.EANREL,PBK.LPK ORGEANREL.VARUTYP ' || 'FROM A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| ' ' || --PBK.LPKORGEANREL ' || 'WHERE ICA_ARTIKEL.EAN=' || EanLPVara || ' ' || 'AND ICA_ARTIKEL.DATUMhttp://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export taking to long
Ron Let me know which version of oracle you are running? If it taking longer or longer? Following may help you to reduce export time -Try to take export in one file -Try to take on diffrent disk wich has less IO Thx -Seema >From: Hately Mike <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Export taking to long >Date: Tue, 09 Apr 2002 07:58:25 -0800 > >Ron, > >you're taking a lot of steps that I would take myself. >Which part of the machine starts to glow when you run this? >I'll assume that the target file is not on a disk that's shared with any >database files. >Running sar for the first few minutes of the export will probably show you >where your bottleneck is. >I'd suspect disks or memory so sar -du would probably do to give you a >steer. >Do you have any Oracle wait statistics for the period it was running? > >BTW Ron, when you run that export are you sure that your password is >hidden? > >It should show up on the process list if you run it like that. > >Cheers, >Mike > > >-Original Message- > > >I have an export of a 16G database that is consistently taking 6 hours to >export. >It doesn't matter what time of the day or night the script is executed. >There is >very little activity on the server. Any ideas? > >#!/bin/ksh >export ORACLE_SID=adprod >export ORACLE_HOME=`grep $ORACLE_SID /etc/oratab | cut -d : -f2` >PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:. >export USERPASS=system/sysada2 ># ># Create a new pipe each time ># >if [ -p exp_pipe_$ORACLE_SID ] > then rm exp_pipe_$ORACLE_SID >fi >mknod exp_pipe_$ORACLE_SID p > >OUTFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.dmp.Z" >LOGFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.log" ># ># Begin compress job and export to pipe with userid and password hidden ># >compress < /oracle_dba/expimp/adprod/exp_pipe_adprod > $OUTFILE & >exp $USERPASS full=y compress=n consistent=y recordlength=65535 direct=y >file=/oracle_dba/expimp/adprod/exp_pipe_adprod log= >$LOGFILE > >Ron Smith >DBA >Kerr-McGee Corp > > > > > > >This email and any attached to it are confidential and intended only for >the >individual or >entity to which it is addressed. If you are not the intended recipient, >please let us know >by telephoning or emailing the sender. You should also delete the email >and >any attachment >from your systems and should not copy the email or any attachment or >disclose their content >to any other person or entity. The views expressed here are not >necessarily >those of >Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. >Churchill Insurance Group plc. Company Registration Number - 2280426. >England. >Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 >1DP. > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Hately Mike > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(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/intl.asp. -- 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).
RE: Oracle 9i SE vs EE and options
Ron - My interpretation, based on Oracle Partitioning, is that "Option" means that you need Enterprise Edition and you must pay extra on top of that. Thanks for passing this along. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 10:23 AM To: Multiple recipients of list ORACLE-L List, If I read this chart correctly it displays what is provided with the Standard Edition and the Enterprise Edition. The Option column is what is extra and you pay for it??? Am I correct in what I read about the option column. http://www.oracle.com/ip/deploy/database/oracle9i/index.html?packagingandopt ions.html If this is true it is nice to see it finally displayed rather than double talk from a salesman. Ron 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i SE vs EE and options
Dennis is right. We had to pay extra for partitioning, on top of EE. What a lovely day it was. The total (to run on a wimpy w2k machine, named user) could have bought me a new car. Lisa Koivu Oracle Database Dog Catcher Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 09, 2002 12:28 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle 9i SE vs EE and options > > Ron - My interpretation, based on Oracle Partitioning, is that "Option" > means that you need Enterprise Edition and you must pay extra on top of > that. Thanks for passing this along. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, April 09, 2002 10:23 AM > To: Multiple recipients of list ORACLE-L > > > List, > If I read this chart correctly it displays what is provided with the > Standard Edition and the Enterprise Edition. The Option column is what > is extra and you pay for it??? Am I correct in what I read about the > option column. > > http://www.oracle.com/ip/deploy/database/oracle9i/index.html?packagingando > pt > ions.html > > > If this is true it is nice to see it finally displayed rather than > double talk from a salesman. > Ron > 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: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 taking to long
Like someone suggested, use BUFFER=10MB or more so that you have less I/O. -Original Message- Sent: Tuesday, April 09, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Parameters looks ok, Just use gzip instead of compress . File extention should be .gz instead of .Z If you can try larger recordsize than 65K ,try it. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 09 Apr 2002 06:28:20 -0800 I have an export of a 16G database that is consistently taking 6 hours to export. It doesn't matter what time of the day or night the script is executed. There is very little activity on the server. Any ideas? #!/bin/ksh export ORACLE_SID=adprod export ORACLE_HOME=`grep $ORACLE_SID /etc/oratab | cut -d : -f2` PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:. export USERPASS=system/sysada2 # # Create a new pipe each time # if [ -p exp_pipe_$ORACLE_SID ] then rm exp_pipe_$ORACLE_SID fi mknod exp_pipe_$ORACLE_SID p OUTFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.dmp.Z" LOGFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.log" # # Begin compress job and export to pipe with userid and password hidden # compress < /oracle_dba/expimp/adprod/exp_pipe_adprod > $OUTFILE & exp $USERPASS full=y compress=n consistent=y recordlength=65535 direct=y file=/oracle_dba/expimp/adprod/exp_pipe_adprod log= $LOGFILE Ron Smith DBA Kerr-McGee Corp -- 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). MOHAMMAD RAFIQ _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Insert append generating redo
This is code I use and it works. If you see I do not use 'AS' before select. I am not sure if you need it. insert /*+ parallel(&&1, 6) */ into &&1 select /*+ parallel(&&2, 6) */ * from &&2; Shakir --- paquette stephane <[EMAIL PROTECTED]> wrote: > Hi, > > I'm trying the following insert /*+ append */ into t1 > as select * from t2; > > t1 is created with nologging attribute. > > The insert is not using the hint at all. > I can select on t1 (before any commit) which I should > not be able to do if the append hint was used. > > Any ways to get the hing used ? > (Oracle 817/NT) > > TIA > > = > Stéphane Paquette > DBA Oracle, consultant entrepôt de données > Oracle DBA, datawarehouse consultant > [EMAIL PROTECTED] > > ___ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! > Yahoo! Mail : http://fr.mail.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). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fairly Boring News Article on Oracle
No way! I'd say that web services are a collection of standards that allow HTTP-borne remote procedure calls between clients and servers. It's all XML & objects under the skin, if I understand it correctly. The theory is that neither client nor server need to run any specific brand of software, nor know about things like what OS is running on either end, etc. Servers just have to be able to listen for HTTP requests, act on them & respond with XML streams of the expected format. Everybody codes to these standards and boom--instant firewall-permeable interoperability for all. So the server could be as you specify below, or could be IIS using .Net, or anything else that will emit properly formatted XML streams. Clients can be anything that can make sense of the server's output stream--Java, custom coded C++, or what-have-you. But I'm probably wrong about at least some of that... Cheers, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Tuesday, April 09, 2002 9:23 AM To: Multiple recipients of list ORACLE-L I read the info quickly, so "Web services" are Java apps served on iAS through Portal, Wireless Portal, or Apache. Would that be correct, in a nutshell? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- 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: Pardee, Roy 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).
RE: Export taking to long
Every time. -Original Message- Sent: Tuesday, April 09, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Does it happen everytime you do export or just once awhile? David -Original Message- Sent: Tuesday, April 09, 2002 9:28 AM To: Multiple recipients of list ORACLE-L I have an export of a 16G database that is consistently taking 6 hours to export. It doesn't matter what time of the day or night the script is executed. There is very little activity on the server. Any ideas? #!/bin/ksh export ORACLE_SID=adprod export ORACLE_HOME=`grep $ORACLE_SID /etc/oratab | cut -d : -f2` PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:. export USERPASS=system/sysada2 # # Create a new pipe each time # if [ -p exp_pipe_$ORACLE_SID ] then rm exp_pipe_$ORACLE_SID fi mknod exp_pipe_$ORACLE_SID p OUTFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.dmp.Z" LOGFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.log" # # Begin compress job and export to pipe with userid and password hidden # compress < /oracle_dba/expimp/adprod/exp_pipe_adprod > $OUTFILE & exp $USERPASS full=y compress=n consistent=y recordlength=65535 direct=y file=/oracle_dba/expimp/adprod/exp_pipe_adprod log= $LOGFILE Ron Smith DBA Kerr-McGee Corp -- 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: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fairly Boring News Article on Oracle
***inline... Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] > > I think this is good news, Oracle accepting these user groups. > *** Assimilation can not be far off. This is a bad thing. So much for an independent viewpoint. > It's probably the most cost-efficient, effective way for Oracle to get > honest feedback on how to improve their products. > *** Aka, get the marketing materials to damagement types who skulk to techie conferences like parasitic leeches. Oracle doesn't care about honest feedback - just selling more product. Hence the mafia/drug dealer like pricing scale and sales tactics. > > The better their products, the more successful they will be it seems to > me. > *** Wrong. See above. The more people who buy their products, the more successful they will be. Quality is rarely a consideration. It worked for Micro$oft. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fairly Boring News Article on Oracle
I read the info quickly, so "Web services" are Java apps served on iAS through Portal, Wireless Portal, or Apache. Would that be correct, in a nutshell? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- 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).
RE: Export taking to long
Ron, Consistent=y will make it run slow. Is 'consistent=y' a requirement? If your version of the database allows multiple dump files, you may want to consider that option (if disk space is available). Compressing dump file on the fly will add to the slowness. - Kirti -Original Message- Sent: Tuesday, April 09, 2002 9:28 AM To: Multiple recipients of list ORACLE-L I have an export of a 16G database that is consistently taking 6 hours to export. It doesn't matter what time of the day or night the script is executed. There is very little activity on the server. Any ideas? #!/bin/ksh export ORACLE_SID=adprod export ORACLE_HOME=`grep $ORACLE_SID /etc/oratab | cut -d : -f2` PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:. export USERPASS=system/sysada2 # # Create a new pipe each time # if [ -p exp_pipe_$ORACLE_SID ] then rm exp_pipe_$ORACLE_SID fi mknod exp_pipe_$ORACLE_SID p OUTFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.dmp.Z" LOGFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.log" # # Begin compress job and export to pipe with userid and password hidden # compress < /oracle_dba/expimp/adprod/exp_pipe_adprod > $OUTFILE & exp $USERPASS full=y compress=n consistent=y recordlength=65535 direct=y file=/oracle_dba/expimp/adprod/exp_pipe_adprod log= $LOGFILE Ron Smith DBA Kerr-McGee Corp -- 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Pl/sql question - if statement
Check your quotes. Better yet, create a variable as the string then check the variable. If I understand your code, the first line would look like this: If 'A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG' = 0 THEN I suspect you're going to have problems with the rest of your quoting as well. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Pl/sql question - if statement om 04/09/2002 09:43 AM Please respond to ORACLE-L anyone whom can tell me why this statement fails in a pl/sqll code: I get this error message PLS-00103: Encountered the symbol "||AvdNr||" when expecting one of the following: . ( * @ % & = - + < / > at in mod not rem then <> or != or ~= >= <= <> and or like betwe when i run this statement If A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 '' then lvSQL := 'SELECT ICA_ARTIKEL.FSGPRIS,ICA_ARTIKEL.PANTBELOPP ' || --PBK.LPKORGEANREL.EANREL,PBK.LPKORGEANREL.VARUTYP ' || 'FROM A'||AvdNr||'.ICA_ARTIKEL@' ||LookUpServerName|| ' ' || --PBK.LPKORGEANREL ' || 'WHERE ICA_ARTIKEL.EAN=' || EanLPVara || ' ' || 'AND ICA_ARTIKEL.DATUMhttp://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export taking to long
I am just throwing these quickly ... how large are your rollback segments? Consistent=y means Oracle has to remember every data block that existed at the time your export began. I haven't seen recordlength= before, is this the equivalent of the older "buffer=" parameter? Here I often set buffer= to 100, we have enough memory on our server to handle it and I don't have to worry too much about record lengths. This is probably silly too --> your server is not paging, I hope. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 11:28 AM To: Multiple recipients of list ORACLE-L Subject:Export taking to long I have an export of a 16G database that is consistently taking 6 hours to export. It doesn't matter what time of the day or night the script is executed. There is very little activity on the server. Any ideas? #!/bin/ksh export ORACLE_SID=adprod export ORACLE_HOME=`grep $ORACLE_SID /etc/oratab | cut -d : -f2` PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:. export USERPASS=system/sysada2 # # Create a new pipe each time # if [ -p exp_pipe_$ORACLE_SID ] then rm exp_pipe_$ORACLE_SID fi mknod exp_pipe_$ORACLE_SID p OUTFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.dmp.Z" LOGFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.log" # # Begin compress job and export to pipe with userid and password hidden # compress < /oracle_dba/expimp/adprod/exp_pipe_adprod > $OUTFILE & exp $USERPASS full=y compress=n consistent=y recordlength=65535 direct=y file=/oracle_dba/expimp/adprod/exp_pipe_adprod log= $LOGFILE Ron Smith DBA Kerr-McGee Corp -- 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: 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).
RE: RE: Fairly Boring News Article on Oracle
I have worked with a little with PeopleSoft and a lot with J.D. Edwards OneWorld. Also have worked with a lot of people who have worked with them all. I know the finance guys, the sales order guys, inventory etc...My experience is that most of them agree the OneWorld is very capable of being configured to model current business practices without too many mods. From an administration standpoint you will usually only need 1 DBA and 1 CNC (App admin) once you stabilized in production mode. Selling widgets is selling widgets so the idea that you must have a custom tailored application to suit an individual business's is not that really that common. Products like JDE at least have done a good job of allowing you to configure how the application works. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Tuesday, April 09, 2002 10:18 AM To: Multiple recipients of list ORACLE-L Patrice, Since we're in the middle of a PeopleSoft implementation I can say that I agree with the comments in the articles. If you buy one of these prebuilt packages you have the problem of either re-inventing your business or trying to modify the package to meet your requirements. Option 1 is troublesome at best since you may well have to re-orientate people and practices from years of what they were use to. Ugly to say the least. Now option 2 is more like skating on paper thin ice. PeopleSoft is 'modifiable' but there are a lot of other ramifications that one has to think about, like upgrades. The closer to 'plain vanilla' you can stay the better. The farther away you get, the less the vendor supports you and the harder (and longer) upgrades become. SAP and Oracle do not lend themselves to modification. SAP just because those Germans know best (so I've been told by those with experience) and Oracle because it just plain does not fit. What are people doing, PeopleSoft or else roll your own. Now Oracle does make a decent tool set for the later in Designer and Developer. Personally I would prefer that they drop the apps and concentrate on the tools and database. Dick Goulet Reply Separator Author: "Boivin; Patrice J" <[EMAIL PROTECTED]> Date: 4/9/2002 6:08 AM If people aren't using SAP, Oracle Applications or PeopleSoft, what are they using? PlumTree portals? Is that what they mean by Web services? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 taking to long
Parameters looks ok, Just use gzip instead of compress . File extention should be .gz instead of .Z If you can try larger recordsize than 65K ,try it. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 09 Apr 2002 06:28:20 -0800 I have an export of a 16G database that is consistently taking 6 hours to export. It doesn't matter what time of the day or night the script is executed. There is very little activity on the server. Any ideas? #!/bin/ksh export ORACLE_SID=adprod export ORACLE_HOME=`grep $ORACLE_SID /etc/oratab | cut -d : -f2` PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin:. export USERPASS=system/sysada2 # # Create a new pipe each time # if [ -p exp_pipe_$ORACLE_SID ] then rm exp_pipe_$ORACLE_SID fi mknod exp_pipe_$ORACLE_SID p OUTFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.dmp.Z" LOGFILE="/oracle_dba/expimp/adprod/adprod_exp_full_`date '+%m%d%y'`.log" # # Begin compress job and export to pipe with userid and password hidden # compress < /oracle_dba/expimp/adprod/exp_pipe_adprod > $OUTFILE & exp $USERPASS full=y compress=n consistent=y recordlength=65535 direct=y file=/oracle_dba/expimp/adprod/exp_pipe_adprod log= $LOGFILE Ron Smith DBA Kerr-McGee Corp -- 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). MOHAMMAD RAFIQ _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).