Fairly Boring News Article on Oracle
http://story.news.yahoo.com/news?tmpl=storycid=581ncid=738e=2u=/nm/20020409/tc_nm/tech_oracle_dc_7 Cheers, JoJo
RE: Another RMAN Problem --- Urgent !!
Hi Note: I'm still testing RMAN and not using it If you have more than one database managed by the same repository you need to somhow tell RMAN which database to duplicate. Connecting to the one to duplicate sounds like an option. Also RMAN is capable of duplicating upto the current time isn't it? Than it needs the online logfiles no?? Jack John Hallas john.hallas@hcresouTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rces.co.uk cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by:Subject: RE: Another RMAN Problem --- Urgent !! [EMAIL PROTECTED] 08-04-2002 18:57 Please respond to ORACLE-L Tim Gorman wrote For a DUPLICATE DATABASE operation, you don't have to connect to the TARGET at all, if I recall correctly; a DUPLICATE DATABASE operation doesn't involve the TARGET. Sounds funny, until you consider that the operation is reading from tape to the new AUXILIARY database instance. However logical all that sounds Tim, it is incorrect. For some bizarre reason when duplicating a database you have to have 3 connections open (assuming you have a recovery catalogue) The target (which I prefer to call source), the auxiliary (which is the target in my view) and the catalogue. I have raised this question before with Oracle and I did get an answer as to why you still needed to connect to the target database. I cannot remember what the answer was but I though it pretty weak at the time. John -- 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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You
Re: RMAN madness !!
Hi, You are probably encountering BUG 1834502 Fixed in 9.0.2 (duh) don't use to date but instead write set until time 'dd-MON- hh24:mi:ss'; {exact format mask} Jack SARKAR, Samir [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ma.slb.comcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: [EMAIL PROTECTED] Subject: RMAN madness !! 08-04-2002 20:03 Please respond to ORACLE-L Hi All, I am back againand yes, my script didn't work completely. It did write the data files to the respective locations but it returned the following error during the process of duplicating the db : RMAN-03021: executing script: Memory Script RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: set RMAN-03022: compiling command: restore RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08016: channel dupdb_d1: starting datafile backupset restore RMAN-08502: set_count=335 set_stamp=456984311 creation_time=20-MAR-2002 RMAN-08089: channel dupdb_d1: specifying datafile(s) to restore from backup set RMAN-08523: restoring datafile 1 to /disk01/oradata/test/data/system01sid1.dbf RMAN-08523: restoring datafile 2 to /disk01/oradata/test/data/rbs01sid1.dbf RMAN-08523: restoring datafile 3 to /disk01/oradata/test/data/rbslarge01sid1.dbf RMAN-08523: restoring datafile 4 to /disk01/oradata/test/data/temp01sid1.dbf RMAN-08523: restoring datafile 5 to /disk01/oradata/test/data/tools01sid1.dbf RMAN-08523: restoring datafile 6 to /disk01/oradata/test/data/users01sid1.dbf RMAN-08023: channel dupdb_d1: restored backup piece 1 RMAN-08511: piece handle=DB_BKUP_INCR_0_SID1_456984311_335_1 tag=DB_BKUP_INCR_0 params=NULL RMAN-08024: channel dupdb_d1: restore complete RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE test RESETLOGS ARCHIVELOG MAXLOGFILES 48 MAXLOGMEMBERS 2 MAXDATAFILES 1000 MAXINSTANCES10 MAXLOGHISTORY 2042 LOGFILE GROUP 1 ( '/disk03/oradata/test/logs/log01a01sid1.dbf' ) SIZE 188743680 , GROUP 2 ( '/disk03/oradata/test/logs/log02a01sid1.dbf' ) SIZE 188743680 , GROUP 3 ( '/disk03/oradata/test/logs/log03a01sid1.dbf' ) SIZE 188743680 DATAFILE '/disk01/oradata/test/data/system01sid1.dbf' CHARACTER SET WE8ISO8859P1 RMAN-03027: printing stored script: Memory Script { switch clone datafile all; } RMAN-03021: executing script: Memory Script RMAN-03022: compiling command: switch RMAN-03023: executing command: switch RMAN-08015: datafile 2 switched to datafile copy RMAN-08507: input datafilecopy recid=1 stamp=458671845 filename=/disk01/oradata/test/data/rbs01sid1.dbf RMAN-08015: datafile 3 switched to datafile copy RMAN-08507: input datafilecopy recid=2 stamp=458671845 filename=/disk01/oradata/test/data/rbslarge01sid1.dbf RMAN-08015: datafile 4 switched to datafile copy RMAN-08507: input datafilecopy recid=3 stamp=458671845 filename=/disk01/oradata/test/data/temp01sid1.dbf RMAN-08015: datafile 5 switched to datafile copy RMAN-08507: input datafilecopy recid=4 stamp=458671845 filename=/disk01/oradata/test/data/tools01sid1.dbf RMAN-08015:
Enterprise Manager (EM) Questions
* While installing EM 9i, it asked to creating a separate database for its repository to which I said Yes. Now the problem is that the database tools like SQL*Plus and SQL Workseet defaults to EM Repository database and not the original one. How do I specify the database name for database tools to connect to. Please note that (The developer/2000 applications/tools however connect to the right database perhaps because the connect string was created to the database before installing EM). * When I start EM with Login to Management Server, it does not seem to recognize the username/password. The stand alone does start and shows both the databases. The error it reports is VTK-1000 * Does EM allow importing 8i export file to 9i, if it doesn't is there any other GUI for that? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Replication - is it on by default?
Hello Paul Open the replication manager and check there if you have replication working. I concur with Rachel. If you have replication you WILL remember activating it. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 08, 2002 3:13 PM Hi folks, we've never identified any requirement here for using any kind of replication. Consequently I know nothing whatsoever about Oracle Replication. Now I've been asked whether or not we use Oracle Replication and, if so, whether it can be disabled. So can anyone tell me whether Replication is a feature automatically included in Oracle 8i Enterprise Edition? And is there an easy way of telling whether or not it's on? If it's on, can it be turned off (if that's a meaningful question!), and if so, how? I've tried briefly RTFMing, but although the manuals contain a wealth of info about how to use Replication, I can see nothing about how to tell whether it's active or not, and how to switch it on or off. Any pointers, please, anyone? Paul Vincent -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vincent INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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
Well, yes ! When installing Oracle, he needs to run root.sh or orainstRoot.sh as root ! Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Dave Morgan [EMAIL PROTECTED] 05/04/2002 12:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) 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] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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).
this is how i created mount points - AIX
list, i have 3 hdisks, i created ONE volume group for each hdisk, the VG size was just a little less than that of the disk... hdisk1 vg1 hdisk2 vg2 hdisk3 vg3 then i creatd mount points /hd1, /hd2/, and /hd3 and created 3 file systems on 3 volume groups and mounted them on the above mentioned directories.. now i will create further sub-directories under these mount points... for instance data/indexes etc... this setup gives me easy one-to-one mapping, so i;'m sure if i put my files under /hd1, the data is stored to hdisk1 physically !! am i right ?? or is there a more better (complex?) way to do this.. ? Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: this is how i created mount points - AIX
Yes, you're right in your assumption. There are more complex ways to do this but for a 3 disk setup I think you're wise to keep things simple. I don't see any reason to put each LV in a separate VG though. One point I'd make is that you might like to look at raw devices for at least your online redos. Anything you can do to reduce disk contention is bound to be a good thing with so few spindles available. Cheers, Mike -Original Message- Sent: 09 April 2002 11:58 To: Multiple recipients of list ORACLE-L list, i have 3 hdisks, i created ONE volume group for each hdisk, the VG size was just a little less than that of the disk... hdisk1 vg1 hdisk2 vg2 hdisk3 vg3 then i creatd mount points /hd1, /hd2/, and /hd3 and created 3 file systems on 3 volume groups and mounted them on the above mentioned directories.. now i will create further sub-directories under these mount points... for instance data/indexes etc... this setup gives me easy one-to-one mapping, so i;'m sure if i put my files under /hd1, the data is stored to hdisk1 physically !! am i right ?? or is there a more better (complex?) way to do this.. ? Regards Rahul 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).
RE: Table Insert Lock!!
Title: RE: Table Insert Lock!! Hi subra( my ex-pm name), Hope that ur not pricise in ur ?. If suppose to keep at maxinum of 1 record at time( like dual), you can restrict this, by table level trigger of INSERTING. Sorry if i was u/s wrongly. Nirmal. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 15 ãÍÑã, 1423 03:43 PM To: Multiple recipients of list ORACLE-L Subject: Table Insert Lock!! Hi I have to revoke insert from a table where I am the owner of the Schema. is it possible. if so? how?. E.g. Owner a have a table t1 after inserting 1 row owner wish to revoke insert for the table t1. because t1 should not have more than one row. How to incorporate this. it is 8.1.7 on sun Solaris 5.7 Regards Ayyappan.S 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 -- 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).
SQL : where clause to include data for the previous 24 hours
I need a where clause to ACCURATELY (down to the second) calculate the previous 24 hours when a query is run and bump the time by 6 hours (event_date is based on GMT). The default date format has been set to 'S-MM-DD HH24:MI:SS','NLS_CALENDAR=GREGORIAN'. I've tried the following: where event_date (to_date(substr(sysdate,0,22),'/MM/DD HH24:MI:SS') + 6/24) - 1. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Another RMAN Problem --- Urgent !!
It will ask for the necessary archive and active logs. I am still on 8.0.6.3 and will be forever, and there is no duplicate command. You have to fool rman into making a duplicated database. But it works the same way. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 09, 2002 3:48 AM Hi Note: I'm still testing RMAN and not using it If you have more than one database managed by the same repository you need to somhow tell RMAN which database to duplicate. Connecting to the one to duplicate sounds like an option. Also RMAN is capable of duplicating upto the current time isn't it? Than it needs the online logfiles no?? Jack John Hallas john.hallas@hcresouTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rces.co.uk cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by:Subject: RE: Another RMAN Problem --- Urgent !! [EMAIL PROTECTED] 08-04-2002 18:57 Please respond to ORACLE-L Tim Gorman wrote For a DUPLICATE DATABASE operation, you don't have to connect to the TARGET at all, if I recall correctly; a DUPLICATE DATABASE operation doesn't involve the TARGET. Sounds funny, until you consider that the operation is reading from tape to the new AUXILIARY database instance. However logical all that sounds Tim, it is incorrect. For some bizarre reason when duplicating a database you have to have 3 connections open (assuming you have a recovery catalogue) The target (which I prefer to call source), the auxiliary (which is the target in my view) and the catalogue. I have raised this question before with Oracle and I did get an answer as to why you still needed to connect to the target database. I cannot remember what the answer was but I though it pretty weak at the time. John -- 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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL
RE: Fairly Boring News Article on Oracle
I think this is good news, Oracle accepting these user groups. It's probably the most cost-efficient, effective way for Oracle to get honest feedback on how to improve their products. The better their products, the more successful they will be it seems to me. 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-From: JoJo Zawawi [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 09, 2002 4:28 AMTo: Multiple recipients of list ORACLE-LSubject: Fairly Boring News Article on Oracle http://story.news.yahoo.com/news?tmpl=storycid=581ncid=738e=2u=/nm/20020409/tc_nm/tech_oracle_dc_7 Cheers, JoJo
Re: SQL : where clause to include data for the previous 24 hours
Hi Maybe completely misunderstood the Q: where event_date sysdate-18/24 Jack Johan Muller c-johan.muller@wTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com.com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: SQL : where clause to include data for the previous 24 hours [EMAIL PROTECTED] 09-04-2002 14:13 Please respond to ORACLE-L I need a where clause to ACCURATELY (down to the second) calculate the previous 24 hours when a query is run and bump the time by 6 hours (event_date is based on GMT). The default date format has been set to 'S-MM-DD HH24:MI:SS','NLS_CALENDAR=GREGORIAN'. I've tried the following: where event_date (to_date(substr(sysdate,0,22),'/MM/DD HH24:MI:SS') + 6/24) - 1. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and
Re: OCP-Network Exam
Also, be sure of the correct terminology. Know what network service names, connection strings, etc. are. I went into the exam last week knowing exactly what these things LOOKED like in the config files but not what you're meant to call them (although it was possible to work them out from clearly wrong other choices...; being the only guy setting up these files here I've never had to call them anything in real life!) Have a look at the Oracle 8 Cram Session sheet although it doesn't go into enough detail for the exam - the Oracle manual seems to cover things pretty closely to the format of the exam (much more than for the other exams I reckon). - Bill. Oracle 8i OCP (at last :) - or at least waiting for the bit of paper!) At 07:18 08/04/02 -0800, you wrote: 1.You should study gui's. There are about 10 questions . 2.There are a few question about command line utilities and their parameters. 3.Connection Manager is important. thats all which I can remember - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 08, 2002 5:58 PM Hi, Greetings, I am on the preparation for my OCP 8i Network Administration exam. I welcome any tips or questions or model papers. So that i can prepare myself well for the exam. Looking forward to your inputs, With best regards, Muths _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muthaiah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arslan Bahar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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
http://www.infoworld.com/articles/ap/xml/02/04/08/020408aporacle.xml -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 09, 2002 7:23 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Fairly Boring News Article on Oracle I think this is good news, Oracle accepting these user groups. It's probably the most cost-efficient, effective way for Oracle to get honest feedback on how to improve their products. The better their products, the more successful they will be it seems to me. 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-From: JoJo Zawawi [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 09, 2002 4:28 AMTo: Multiple recipients of list ORACLE-LSubject: Fairly Boring News Article on Oracle http://story.news.yahoo.com/news?tmpl=storycid=581ncid=738e=2u=/nm/20020409/tc_nm/tech_oracle_dc_7 Cheers, JoJo
Re: where clause to include data for the previous 24 hours
No conversions required: where event_date (sysdate - 1 + 6/24) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 09, 2002 8:13 AM I need a where clause to ACCURATELY (down to the second) calculate the previous 24 hours when a query is run and bump the time by 6 hours (event_date is based on GMT). The default date format has been set to 'S-MM-DD HH24:MI:SS','NLS_CALENDAR=GREGORIAN'. I've tried the following: where event_date (to_date(substr(sysdate,0,22),'/MM/DD HH24:MI:SS') + 6/24) - 1. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 : where clause to include data for the previous 24 hours
where x sysdate - 18/24 hth connor --- Johan Muller [EMAIL PROTECTED] wrote: I need a where clause to ACCURATELY (down to the second) calculate the previous 24 hours when a query is run and bump the time by 6 hours (event_date is based on GMT). The default date format has been set to 'S-MM-DD HH24:MI:SS','NLS_CALENDAR=GREGORIAN'. I've tried the following: where event_date (to_date(substr(sysdate,0,22),'/MM/DD HH24:MI:SS') + 6/24) - 1. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 : where clause to include data for the previous 24 hours
Johan, There is no need to convert sysdate to a string and back to a data. I'm not sure what you mean by calculate the previous 24 hours when a query is run and bump the time by 6 hours. It looks like you are trying to retrieve all records that have a date/time within the last 18 hours - is this correct? if so, then your query would be: where event_date (sysdate + 6/24) - 1 The default date format really has nothing to do with how the dates are stored within the database - they are all stored the same way. This means you can do simple date math like above. Hope this is what you are looking for. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, April 09, 2002 8:13 AM To: Multiple recipients of list ORACLE-L I need a where clause to ACCURATELY (down to the second) calculate the previous 24 hours when a query is run and bump the time by 6 hours (event_date is based on GMT). The default date format has been set to 'S-MM-DD HH24:MI:SS','NLS_CALENDAR=GREGORIAN'. I've tried the following: where event_date (to_date(substr(sysdate,0,22),'/MM/DD HH24:MI:SS') + 6/24) - 1. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 box with MS SQL on a 2-CPU Intel box. The Intel box was cheaper, but those two CPUs really kill you on licensing! In my mind I am convinced that both setups could offer equivalent performance. - I was provided figures that the average DBA salary (including health, vacation, etc.) on Oracle is $85,000 and on MS SQL $68,500. A lading industry analyst stated that the main reason MS SQL sites have less reliability is
RE: Fairly Boring News Article on Oracle
If people aren't using SAP, Oracle Applications or PeopleSoft, what are they using? PlumTree portals? Is that what they mean by Web services? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 09, 2002 9:53 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Fairly Boring News Article on Oracle http://www.infoworld.com/articles/ap/xml/02/04/08/020408aporacle.xml -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 09, 2002 7:23 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Fairly Boring News Article on Oracle I think this is good news, Oracle accepting these user groups. It's probably the most cost-efficient, effective way for Oracle to get honest feedback on how to improve their products. The better their products, the more successful they will be it seems to me. 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-From: JoJo Zawawi [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 09, 2002 4:28 AMTo: Multiple recipients of list ORACLE-LSubject: Fairly Boring News Article on Oracle http://story.news.yahoo.com/news?tmpl=storycid=581ncid=738e=2u=/nm/20020409/tc_nm/tech_oracle_dc_7 Cheers, JoJo
Re: IOUG conference get together
Do we have a location, date, time??? --- Joe Testa [EMAIL PROTECTED] wrote: So for those of us going to the IOUG Conf, do we want to plan a get together? Throwing this out for ideas, etc. Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ 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: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL Tuning - How to avoid TOCHAR function against a date
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 RROGERS@galot To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tery.orgcc: 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 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
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).
RE: How to read user dump file
What do you mean by user dump file? The result of an Oracle Export? Looking up Oracle dump file on Google, I found the following: http://www.unal-bilisim.com/products/ioradumpreader/ioradumpreader.html http://www.unal-bilisim.com/products/ioradumpreader/ioradumpreader.html Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 08, 2002 5:24 PM To: Multiple recipients of list ORACLE-L 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: 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).
Pl/sql question - if statement
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 an exponent (**) 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.DATUMTO_DATE('''||inDatum||''',''-MM-DD'') ' || -- '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).
RE: Fairly Boring News Article on Oracle
Microgro Great Plains software. www.qci.com Plum Tree portals??? sounds like a fruit farmer's privy. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/09/02 10:08AM If people aren't using SAP, Oracle Applications or PeopleSoft, what are they using? PlumTree portals? Is that what they mean by Web services? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, April 09, 2002 9:53 AM To: Multiple recipients of list ORACLE-L http://www.infoworld.com/articles/ap/xml/02/04/08/020408aporacle.xml http://www.infoworld.com/articles/ap/xml/02/04/08/020408aporacle.xml -Original Message- Sent: Tuesday, April 09, 2002 7:23 AM To: Multiple recipients of list ORACLE-L I think this is good news, Oracle accepting these user groups. It's probably the most cost-efficient, effective way for Oracle to get honest feedback on how to improve their products. The better their products, the more successful they will be it seems to me. 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 4:28 AM To: Multiple recipients of list ORACLE-L http://story.news.yahoo.com/news?tmpl=story http://story.news.yahoo.com/news?tmpl=storycid=581ncid=738e=2u=/nm/2002 0409/tc_nm/tech_oracle_dc_7 cid=581ncid=738e=2u=/nm/20020409/tc_nm/tech_oracle_dc_7 Cheers, JoJo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to read user dump file
Also, what do you want to report on, what version of Oracle, what format does the report have to be in? What does the dump file contain? Does it contain data? We have a tool, but before I plug it, it may be better to know your requirements a little better.. Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- WILLIAMS Sent: 09 April 2002 15:33 To: Multiple recipients of list ORACLE-L What do you mean by user dump file? The result of an Oracle Export? Looking up Oracle dump file on Google, I found the following: http://www.unal-bilisim.com/products/ioradumpreader/ioradumpreader.html http://www.unal-bilisim.com/products/ioradumpreader/ioradumpreader.html Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 08, 2002 5:24 PM To: Multiple recipients of list ORACLE-L 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: 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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Pl/sql question - if statement
You have messed up quotes in IF condition Maybe You can use some coding style other than chaotic? It helps in debugging, believe me. Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Roland.Skoldblom@ ica.se To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Pl/sql question - if statement 2002.04.09 17:43 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 an exponent (**) 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.DATUMTO_DATE(''' ||inDatum||''',''-MM-DD'') ' || -- '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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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, 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).
RE: Fairly Boring News Article on Oracle
(sigh) www.plumtree.com : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, April 09, 2002 12:13 PM To: Multiple recipients of list ORACLE-L Subject:RE: Fairly Boring News Article on Oracle Microgro Great Plains software. www.qci.com Plum Tree portals??? sounds like a fruit farmer's privy. Ron ROR mª¿ªm [EMAIL PROTECTED] 04/09/02 10:08AM If people aren't using SAP, Oracle Applications or PeopleSoft, what are they using? PlumTree portals? Is that what they mean by Web services? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, April 09, 2002 9:53 AM To: Multiple recipients of list ORACLE-L http://www.infoworld.com/articles/ap/xml/02/04/08/020408aporacle.xml http://www.infoworld.com/articles/ap/xml/02/04/08/020408aporacle.xml -Original Message- Sent: Tuesday, April 09, 2002 7:23 AM To: Multiple recipients of list ORACLE-L I think this is good news, Oracle accepting these user groups. It's probably the most cost-efficient, effective way for Oracle to get honest feedback on how to improve their products. The better their products, the more successful they will be it seems to me. 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 4:28 AM To: Multiple recipients of list ORACLE-L http://story.news.yahoo.com/news?tmpl=story http://story.news.yahoo.com/news?tmpl=storycid=581ncid=738e=2u=/nm/2002 0409/tc_nm/tech_oracle_dc_7 cid=581ncid=738e=2u=/nm/20020409/tc_nm/tech_oracle_dc_7 Cheers, JoJo -- 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: 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
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).
RE: Export taking to long
Hi Ron, Why are you using consistent - do you have to? Have you tried bumping up your buffer, to like 10MB? Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 10: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: 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: Fairly Boring News Article on Oracle
Why, in-house developed applications, of course. Tailored to the requirements of your business by real people who actually asked you what your requirements are... 8^) Here's Oracle's take on web services: http://otn.oracle.com/tech/webservices/content.html -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Tuesday, April 09, 2002 7:08 AM To: Multiple recipients of list ORACLE-L If people aren't using SAP, Oracle Applications or PeopleSoft, what are they using? PlumTree portals? Is that what they mean by Web services? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, April 09, 2002 9:53 AM To: Multiple recipients of list ORACLE-L http://www.infoworld.com/articles/ap/xml/02/04/08/020408aporacle.xml -Original Message- Sent: Tuesday, April 09, 2002 7:23 AM To: Multiple recipients of list ORACLE-L I think this is good news, Oracle accepting these user groups. It's probably the most cost-efficient, effective way for Oracle to get honest feedback on how to improve their products. The better their products, the more successful they will be it seems to me. 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 4:28 AM To: Multiple recipients of list ORACLE-L http://story.news.yahoo.com/news?tmpl=storycid=581ncid=738e=2u=/nm/20020 409/tc_nm/tech_oracle_dc_7 Cheers, JoJo -- 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
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).
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
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: 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 an exponent (**) 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.DATUMTO_DATE(''' ||inDatum||''',''-MM-DD'') ' || -- '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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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: 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
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: 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: 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: 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: 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: 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).
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 an exponent (**) 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 an exponent (**) 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.DATUMTO_DATE('''||inDatum||''',''-MM-DD'') ' || -- '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). -- 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).
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).
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).
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).
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: 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 To
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).
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 To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
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).
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 DWILLIAMS@LIFE To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] TOUCH.COMcc: 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
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 box with MS SQL on a 2-CPU Intel box. The Intel box was cheaper, but those two
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: 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).
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 get a comparison. - MS SQL EE with Software Assurance is actually
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).
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: 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 Internet access / Mailing Lists
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). __ Do You Yahoo!? Yahoo! Tax Center -
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
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).
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, California-- Public Internet access / Mailing Lists
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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
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: 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: 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 - 01-JAN-70 Thanks in advance for any help.
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).
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: 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 kaderb To: 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).
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: 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] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ:
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
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) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
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: 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: 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: 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 RROGERS@galot To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tery.orgcc: 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 NULL VARCHAR2(30) DAY_NUMBER_IN_MONTH NOT NULL NUMBER(3) DAY_NUMBER_OVERALL NOT NULL NUMBER(9)
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: Question about Forms Version
Perhaps you're referring to Developer/2000? If so, that name was first usedwith 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: 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, 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
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: 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).
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 usedwith 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: 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: 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 message BODY, include a line containing: UNSUB ORACLE-L (or the name
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: 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
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: 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).
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).
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