RE: Imedia query tuning
Title: RE: Imedia query tuning Hello, Thanks Lisa for your comment but. I try to always use an index hint to return the rows in the required order. This avoids a sort if it's possible to use an index which can avoid both sort and table access - and it often won't be possible - the this index will offer good performance both for retrieval of all rows and the retreival of the first row. Ranganath : What is the name of your index on editor_choice ? Regards Henrik -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: den 16 maj 2001 16:37To: Multiple recipients of list ORACLE-LSubject: RE: Imedia query tuning Henrik, FYI The ordered hint refers to the order in which the tables are accessed in the query. It has nothing to do with an index. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- From: Henrik Ekenberg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 8:56 AM To: Multiple recipients of list ORACLE-L Subject: Re: Imedia query tuning Hello, I'm not a guru : I just try to help you. :- Hint for Query 2 : Have you try to hint so you run on the editor_choice index. If it works. Can you remove the Order command. Because the index is already ordered. Regards Henrik E. On Wed, 16 May 2001, Ranganath K wrote: Dear DBA Gurus, I have the following two queries along with execution plan and statistics. The first one is taking a long time to execute. The second query is taking a long time to execute when I use the order by clause. Is there any way I can reduce the execution time as these queries will be used by a search engine? Any help in this regard will be greatly appreciated. SQL select depth, count(*) a from category, site 2 where (site.fk_category in (select pk_category_id from category 3 where category.status = 0)) and site.status = 0 4 and ((contains (title,'box') 0) or 5 (contains (description, 'box') 0)) 6 and pk_category_id = fk_category group by depth order by a desc; 467 rows selected. Elapsed: 00:00:16.43 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=214936 Card=22470 By tes=136572660) 1 0 SORT (ORDER BY) (Cost=214936 Card=22470 Bytes=136572660) 2 1 SORT (GROUP BY) (Cost=214936 Card=22470 Bytes=136572660) 3 2 NESTED LOOPS (Cost=19 Card=22470 Bytes=136572660) 4 3 NESTED LOOPS (Cost=4 Card=15 Bytes=60945) 5 4 TABLE ACCESS (BY INDEX ROWID) OF 'SITE' (Cost=2 Ca rd=1 Bytes=4037) 6 5 BITMAP CONVERSION (TO ROWIDS) 7 6 BITMAP OR 8 7 BITMAP CONVERSION (FROM ROWIDS) 9 8 SORT (ORDER BY) 10 9 DOMAIN INDEX OF 'SITE2TITLEIDEX' (Cost=1 ) 11 7 BITMAP CONVERSION (FROM ROWIDS) 12 11 SORT (ORDER BY) 13 12 DOMAIN INDEX OF 'SITE1DESCIDX' (Cost=1) 14 4 TABLE ACCESS (BY INDEX ROWID) OF 'CATEGORY' (Cost= 1 Card=1499 Bytes=38974) 15 14 INDEX (UNIQUE SCAN) OF 'SYS_C001314' (UNIQUE) 16 3 TABLE ACCESS (BY INDEX ROWID) OF 'CATEGORY' (Cost=1 Card=149802 Bytes=301851030) 17 16 INDEX (UNIQUE SCAN) OF 'SYS_C001314' (UNIQUE) Statistics -- 786 recursive calls 40 db block gets 5919 consistent gets 1389 physical reads 0 redo size 1829532 bytes sent via SQL*Net to client 69737 bytes received via SQL*Net from client 920 SQL*Net roundtrips to/from client 13 sorts (memory) 0 sorts (disk) 467 rows processed SQL select depth, title, description, url, editor_choice from category,site 2 where (site.fk_category in (select pk_category_id from category 3 where category.status = 0)) and site.status = 0 4 and site.fk_category = category.pk_category_id 5 and ((contains (title, 'box') 0) or 6 (contains (description, 'box' ) 0)) order by editor_choice desc; 552 rows selected. Elapsed: 00:00:16.94 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=142941 Card=22470 By tes=181714890) 1 0 SORT (ORDER BY) (Cost=142941 Card=22470 Bytes=181714890) 2 1 NESTED LOOPS (Cost=19 Card=22470 Bytes=181714890) 3 2 NESTED LOOPS (Cost=4 Card=15 Bytes=91080) 4 3 TABLE ACCESS (BY INDEX ROWID) OF 'SITE' (Cost=2 Card =1 Bytes=6046) 5 4 BITMAP CONVERSION
SQL loader query
Friends, I have the classic case of a comma separated text file which I want to upload and I need to know how can I enforce the following behavior of the SQL Loader: 1. To ignore the first row of the data file (which contains the column titles) 2. Avoid uploading of a column from the middle of the data file Thanks in advance, Pierre -- 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: STOP this THREAD: job offer from SAUDI ARABIA
I disagree. Some of this information may be very useful for people thinking of going to work in Saudi Arabia. The only way it will trigger flames is if someone takes it upon themselves to have a sly crack at the culture over there. However we are all way too professional to do something like that . :-) -Original Message- Sent: 16 May 2001 17:26 To: Multiple recipients of list ORACLE-L Discussing this here will not add any value except triggering flames. Please send directly to the person email address. Regards, Waleed -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: job offer from SAUDI ARABIA
thank you john, bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 16, 2001 10:32 PM Bunyamin, Conditions cut both ways - depends on how you see it... Loss of religious, social and cultural freedom against the possibility of earning (and saving because you can't spend) lots of $$. Having said that, as long as you stick to the straight and narrow path (as defined by the Saudi authorities) you will be on the safest place on earth as far as crime goes. (E.g. stealing is punishable by cutting off your arm/fingers!!) Also, women cannot drive, and have to cover themselves *fully* (not hair alone) in public places. And no public eating/drinking of liquids in public places during the Holy month of Ramadan. There are some who just love it and there are some can't just get enough - there are all kinds in this world. John Kanagaraj -Original Message- Sent: Wednesday, May 16, 2001 5:50 AM To: Multiple recipients of list ORACLE-L Hi all , I have taken an offer from a company in Europe to work in Saudi Arabia for 2 years. But I must learn the living conditions there. Ýf there is an Arabian here , can you answer these.. 1) How are the living conditions?Expensive? 2) Will my wife have to cover her hair? Is it mandatory there? 3) How are the social activities like cinema? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: newbie question
Yep, I've done it before without any problems -Original Message- Sent: 17 May 2001 05:06 To: Multiple recipients of list ORACLE-L Thank you so much for the info, DC. I have another stupid question. Can I have two different ports for two database in the same tnsname.ora on the same server? Cheers, Julia -Original Message- Sent: Wednesday, May 16, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Hi, Yes, you can modify instance parameters in the initXYZ.ora file. After you change them, they take effect when you bounce the instance (shutdown and startup) Also, there are some parameters that can be modify on the fly, without bouncing the instance. check this. SQL desc v$parameter NameNull?Type --- NUM NUMBER NAME VARCHAR2(64) TYPE NUMBER VALUEVARCHAR2(512) ISDEFAULTVARCHAR2(9) ISSES_MODIFIABLE VARCHAR2(5) ISSYS_MODIFIABLE VARCHAR2(9) ISMODIFIED VARCHAR2(10) ISADJUSTED VARCHAR2(5) DESCRIPTION VARCHAR2(64) SQL column name format a60 SQL column value format a20 SQL column ISSYS_MODIFIABLE format a6 SQL select name,value,ISSYS_MODIFIABLE from v$parameter; NAME VALUE ISSYS_ --- - -- processes50 FALSE sessions 60 FALSE timed_statistics TRUE IMMEDIATE--- You can change timed_statistics value with this command: alter system set timed_statistics=true; Hope it helps DC - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 16, 2001 3:19 PM Hi, guru, After I created a XYZ database using the Database Configuration Assistant, can I modify some parameters in the initXYZ.ora file? What steps should I take after the modification? Please advise. Regards, Julia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PHU,JULIA (HP-Sunnyvale,ex2) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PHU,JULIA (HP-Sunnyvale,ex2) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee
Re: SQL loader query
you can use the skip option of the sql loader. in ur case it should be skip=1(if headings are also separated by commas) can have the full help by typing sqlldr help=y at the command prompt. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 1:05 PM Friends, I have the classic case of a comma separated text file which I want to upload and I need to know how can I enforce the following behavior of the SQL Loader: 1. To ignore the first row of the data file (which contains the column titles) 2. Avoid uploading of a column from the middle of the data file Thanks in advance, Pierre -- 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: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
index FS vs index FFS - what's the difference ?
Hi List, I've made two corresponding dumps and ... I must admit I have much less understanding than I had before. Please look at them. = PARSING IN CURSOR #1 len=68 dep=0 uid=32 oct=3 lid=32 tim=219058914 hv=168660475 ad='aa69f79c' select /*+ INDEX(documents pk_documents) */ count(*) from documents END OF STMT PARSE #1:c=12,e=29,p=27,cr=322,cu=6,mis=1,r=0,dep=0,og=4,tim=219058914 EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=219058914 WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #1: nam='file open' ela= 0 p1=0 p2=0 p3=0 WAIT #1: nam='db file sequential read' ela= 1 p1=22 p2=108810 p3=1 WAIT #1: nam='db file sequential read' ela= 1 p1=22 p2=109485 p3=1 WAIT #1: nam='db file sequential read' ela= 0 p1=22 p2=108811 p3=1 WAIT #1: nam='db file scattered read' ela= 1 p1=22 p2=108812 p3=11 [skip] WAIT #1: nam='db file parallel read' ela= 1 p1=1 p2=11 p3=11 WAIT #1: nam='db file parallel read' ela= 0 p1=1 p2=11 p3=11 [skip] WAIT #1: nam='db file scattered read' ela= 0 p1=22 p2=109472 p3=11 WAIT #1: nam='db file sequential read' ela= 0 p1=22 p2=109483 p3=1 WAIT #1: nam='db file sequential read' ela= 0 p1=22 p2=109486 p3=1 WAIT #1: nam='db file parallel read' ela= 0 p1=1 p2=11 p3=11 = PARSING IN CURSOR #1 len=72 dep=0 uid=32 oct=3 lid=32 tim=219108177 hv=3669603672 ad='aa6a4f84' select /*+ INDEX_FFS(documents pk_documents) */ count(*) from documents END OF STMT PARSE #1:c=11,e=13,p=27,cr=322,cu=6,mis=1,r=0,dep=0,og=4,tim=219108177 EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=219108177 WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #1: nam='file open' ela= 0 p1=0 p2=0 p3=0 WAIT #1: nam='db file sequential read' ela= 1 p1=22 p2=108809 p3=1 WAIT #1: nam='db file scattered read' ela= 2 p1=22 p2=108810 p3=8 WAIT #1: nam='db file scattered read' ela= 0 p1=22 p2=108818 p3=8 [skip, all next lines are the same] My questions are 1. Why I get 'db file scattered read' waits for index full scan ? 2. Why p3 for this event is 11 even though my db_file_multiblock_read_count = 8 ? 3. What does mean 'db file parallel read' event? Anjo Kolk's paper doesn't describe it (guess the wait is Oracle8-specific). Oracle 8i Reference says: blockquote This happens during recovery. Database blocks that need to be changed as part of recovery are read in parallel from the database./blockquote But it seems not my case. 4. Finally, what is the difference between the two index paths in that case ? I'm on 8.1.7.0 Solaris, file-based system, LMT Thanks in advance, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: job offer from SAUDI ARABIA
Thank you all gurus, Here there are a lot of professionals working world wide.And This is a good thing to ask directly to people who lived the experience. Yes this is a mail list but I guarantee if somebody want to relocate in Turkey , I will help him/her to learn quicker about the conditions.These questions are not waste of time , more important than an Export question or a query tuning question. These are my ideas. And again thanks to all who replied my questions and who are troubled of my questions.. bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 11:05 AM thank you john, bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 16, 2001 10:32 PM Bunyamin, Conditions cut both ways - depends on how you see it... Loss of religious, social and cultural freedom against the possibility of earning (and saving because you can't spend) lots of $$. Having said that, as long as you stick to the straight and narrow path (as defined by the Saudi authorities) you will be on the safest place on earth as far as crime goes. (E.g. stealing is punishable by cutting off your arm/fingers!!) Also, women cannot drive, and have to cover themselves *fully* (not hair alone) in public places. And no public eating/drinking of liquids in public places during the Holy month of Ramadan. There are some who just love it and there are some can't just get enough - there are all kinds in this world. John Kanagaraj -Original Message- Sent: Wednesday, May 16, 2001 5:50 AM To: Multiple recipients of list ORACLE-L Hi all , I have taken an offer from a company in Europe to work in Saudi Arabia for 2 years. But I must learn the living conditions there. Ýf there is an Arabian here , can you answer these.. 1) How are the living conditions?Expensive? 2) Will my wife have to cover her hair? Is it mandatory there? 3) How are the social activities like cinema? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Decode in PL/Sql
Hi Gurus ! Is there any function that can be used in PL/SQL and just works the way as DECODE does in Sql? Thanks in Advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: enqueue waits -- CI
Hi Diego, If lock type is 'TX', rollback segment number = trunc(p2/65536) and slot number = p2 - 65536*trunc(p2/65536). May I know which table you are looking at to get the following detailed info about enqueue waits? Enqueue Stats -- TY GETS WAITS -- - - CF68 0 CI 1117884 CU 1797012 DL 109 0 DR 102 0 DX 6219 0 IS72 0 MR 140 0 RT 1 0 SQ 2472 5 SS 1 0 ST 320734 TM278918 5 TS 4655 0 TX21005757 UL 3500 0 US 30496 0 WL10 0 18 rows selected. Thanks Jeffery Diego Cutrone wrote: Thanks for answering Unal, John. John, you were right about the query. I've corrected it. And I'm not getting T[ and CK anymore,now I get TX and CI. I've also done further investigation and I also know now what p2 and p3 mean. This is the updated data: (from the dumps) count TYPE MODE 13 CI 6 p2=0 p3=5 ela=0 19 TX 6 p2=262223 p3=53352 ela=301 75 TX 4 p2=524391 p3=50022 ela=301 75 TX 6 p2=720923 p3=5194 ela=301 104TX 6 p2=196736 p3=52393 ela=301 305TX 6 p2=393276 p3=50281 ela=301 Now, how can I get the rollback segment number involved in the TX ? (I know its from p2 and p3, but how?) --just curious. I'll also take John advise, and I'll try to identify the locking session(s). Now, although CI enqueue waits (cross instance call invocation) are brief on this sample, Sometimes it's not. So I'm trying to understand what it means. According to p2 and p3 flags, they are indicating Flush buffers for reuse as new class, that means that a session needs a buffer (in the shared pool I think) and it has to flush some others in order to get space. am I correct?. I've also read a metalink document (1020355.102). According to this, one possible cause is that my application is using dbms_pipe extensively (it may be right, I've seen event pipe get very high). The suggested solution is to increase the shared_pool. I can't access the other documents mentioned in the paper. Can someone explain to me what means this CI enqueue and how can I reduce it. TIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 6:16 PM Hi Diego, Without going into details, an 'enqueue' wait is mostly due to a user/program initated transaction lock and I see it a lot in Financial databases (I see you are on 10.7?). I deduce you were looking at V$SYSTEM_EVENT - If a user locked one row (probably queried a row in Forms, inadvertly changed one character which issues a 'SELECT for UPDATE, thus locking that row) and anotehr user (through a form or a report) needs to perform DML on that particular row, then (I believe) you will clock up time against the 'enqueue' event. What I would suggest is that you use the following query to determine if someone is locking someone else out: select event, count(*) from v$session_wait group by event If you see the 'enqueue' event in this list, some process is probably waiting on a lock... You can then trace the user/process via Lock detection scripts (see Metablink) and kill the blocking process. You could also query from sys.dba_waiters which will present an easier picture in this case.. As far as the SQL goes, see below: select chr(bitand(p1,-16777216)/16777215)||chr(bitand(p1,16711680)/63365) Lock, - I believe the value is '65535', rather than 63365) to_char(bitand(p1,65535)) Mode from dual You can learn a lot from the Oracle 8.1 Reference Manual - Appendix A. Oracle Wait Events and App B Oracle Enqueue Names. While they are applicable for 8.1, most of the info is valid for 7.3 as well... Please let us know if you need additional info. John Kanagaraj (A long time member of the Always look at v$session_wait first camp) Oracle Applications DBA Hitach Data Systems, Santa Clara Work : (408) 970 7002 -Original Message- Sent: Tuesday, May 15, 2001 11:50 AM To: Multiple recipients of list ORACLE-L Hi List, I'm trying to identify the possible cause of contention in a database: Oracle 7.3.4.0.0 // HP-UX 10.20 // FINANCIALS As far I can see, event enqueue is on top (followed by some buffer busy waits) EVENT TIME_WAITED AVERAGE_WAIT enqueue 854176 3746.39 (why is the average wait so high?) buffer busy waits 292770 1.53 Enqueue Stats
RE: SQL loader query
Could you not simply open the .csv file and manually delete the first row? As for your second question, I believe you can just not mention the column you want to leave out in the control file. HTH Mark -Original Message- [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 08:35 To: Multiple recipients of list ORACLE-L Friends, I have the classic case of a comma separated text file which I want to upload and I need to know how can I enforce the following behavior of the SQL Loader: 1. To ignore the first row of the data file (which contains the column titles) 2. Avoid uploading of a column from the middle of the data file Thanks in advance, Pierre -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: STOP this THREAD: job offer from SAUDI ARABIA
Hey Lee...just don't go there man (oops, I didn't mean don't go THERE, I meant don't discuss it.arghh now I'm in trouble :-) ) Martin -Original Message- Sent: 17 May 2001 08:45 To: Multiple recipients of list ORACLE-L I disagree. Some of this information may be very useful for people thinking of going to work in Saudi Arabia. The only way it will trigger flames is if someone takes it upon themselves to have a sly crack at the culture over there. However we are all way too professional to do something like that . :-) -Original Message- Sent: 16 May 2001 17:26 To: Multiple recipients of list ORACLE-L Discussing this here will not add any value except triggering flames. Please send directly to the person email address. Regards, Waleed -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Kendall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 loader query
In a recent mail on a similar topic someone said that in 8i there is a FILLER field in SQL*Loader that allows you to jump over a column. Prior to 8i you are stuck. I have been recommended a brand new book on SQL*Loader. Not yet bought or read it. Jonathan Gennick Sanjay Mishra O'Reilly Associates It is available in the States but not yet in the UK. e.g. Amazon.com Simon Fox Room 205 Rail House Gresty Road CREWE Cheshire CW2 6EA England 01270 533997 -Original Message- Sent: 17 May 2001 09:35 To: Multiple recipients of list ORACLE-L you can use the skip option of the sql loader. in ur case it should be skip=1(if headings are also separated by commas) can have the full help by typing sqlldr help=y at the command prompt. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 1:05 PM Friends, I have the classic case of a comma separated text file which I want to upload and I need to know how can I enforce the following behavior of the SQL Loader: 1. To ignore the first row of the data file (which contains the column titles) 2. Avoid uploading of a column from the middle of the data file Thanks in advance, Pierre -- 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: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema UK Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 make DBA cannot 'see' User's Tables?
Similarly the input text length needs to be a multiple of 8 - a sample of how to do this is on my site somewhere (see sig) hth connor --- A. Bardeen [EMAIL PROTECTED] wrote: You can encrypt using only a 56-bit key (the key length limitation is a requirement of US regulations governing the export of cryptographic products). HTH, -- Anita --- Ahmadsyah Algozhi Nugroho [EMAIL PROTECTED] wrote: I'm using Oracle 8.1.7. there was an error ERROR at line 1: ORA-28232: invalid input length for obfuscation toolkit ORA-06512: at SYS.DBMS_OBFUSCATION_TOOLKIT_FFI, line 0 ORA-06512: at SYS.DBMS_OBFUSCATION_TOOLKIT, line 33 ORA-06512: at SCOTT.IAO_PROTECT, line 15 ORA-06512: at line 1 I check thath my key and my input string is varchar12(10). Key = 0123456789 input string = 'testtestte' dbms_obfuscation_toolkit.desencrypt ( input_string = 'testtestte' , key_string = '1234567890' , encrypted_string = vEncrypted ); Am I forget something? TIA, Ahmadsyah Alghozi Nugroho Database Engineering Specialist PT Infoglobal AutOptima Jl. Baruk Tengah I/49 Surabaya - Jawa Timur phone : +62 (31) 8708456 ext.113 From: Srinagesh Battula [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 7:26 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to make DBA cannot 'see' User's Tables? You can encrypt Decrypt data using the DBMS_OBFUSCATION_TOOLKIT package (comes with 8.1.6) Srinagesh What do I know any way Battula -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to make DBA cannot 'see' User's Tables? Data Encryption? -Original Message- Sent: Wednesday, May 16, 2001 7:01 PM To: Multiple recipients of list ORACLE-L Dear gurus, How to make DBA cannot 'see' user's datas? I build an application which very important and top secret even DBA cannot 'see' this data. But DBA can backup this data.What is the solution for this problem? TIA, Ahmadsyah Alghozi Nugroho Database Engineering Specialist PT Infoglobal AutOptima Jl. Baruk Tengah I/49 Surabaya - Jawa Timur phone : +62 (31) 8708456 ext.113 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srinagesh Battula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
RE: Decode in PL/Sql
Feuerstein recommends replacing with IF statements. Page 517 Oracle PL/SLQ Programming. Simon Fox Room 205 Rail House Gresty Road CREWE Cheshire CW2 6EA England 01270 533997 -Original Message- Sent: 17 May 2001 10:26 To: Multiple recipients of list ORACLE-L Hi Gurus ! Is there any function that can be used in PL/SQL and just works the way as DECODE does in Sql? Thanks in Advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema UK Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 make DBA cannot 'see' User's Tables?
I think they may have changed that last year, didn't the Clinton Administration approve a bill re this? Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: A. Bardeen [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 12:06 AM To: Multiple recipients of list ORACLE-L Subject:RE: How to make DBA cannot 'see' User's Tables? You can encrypt using only a 56-bit key (the key length limitation is a requirement of US regulations governing the export of cryptographic products). HTH, -- Anita --- Ahmadsyah Algozhi Nugroho [EMAIL PROTECTED] wrote: I'm using Oracle 8.1.7. there was an error ERROR at line 1: ORA-28232: invalid input length for obfuscation toolkit ORA-06512: at SYS.DBMS_OBFUSCATION_TOOLKIT_FFI, line 0 ORA-06512: at SYS.DBMS_OBFUSCATION_TOOLKIT, line 33 ORA-06512: at SCOTT.IAO_PROTECT, line 15 ORA-06512: at line 1 I check thath my key and my input string is varchar12(10). Key = 0123456789 input string = 'testtestte' dbms_obfuscation_toolkit.desencrypt ( input_string = 'testtestte' , key_string = '1234567890' , encrypted_string = vEncrypted ); Am I forget something? TIA, Ahmadsyah Alghozi Nugroho Database Engineering Specialist PT Infoglobal AutOptima Jl. Baruk Tengah I/49 Surabaya - Jawa Timur phone : +62 (31) 8708456 ext.113 From: Srinagesh Battula [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 7:26 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to make DBA cannot 'see' User's Tables? You can encrypt Decrypt data using the DBMS_OBFUSCATION_TOOLKIT package (comes with 8.1.6) Srinagesh What do I know any way Battula -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to make DBA cannot 'see' User's Tables? Data Encryption? -Original Message- Sent: Wednesday, May 16, 2001 7:01 PM To: Multiple recipients of list ORACLE-L Dear gurus, How to make DBA cannot 'see' user's datas? I build an application which very important and top secret even DBA cannot 'see' this data. But DBA can backup this data.What is the solution for this problem? TIA, Ahmadsyah Alghozi Nugroho Database Engineering Specialist PT Infoglobal AutOptima Jl. Baruk Tengah I/49 Surabaya - Jawa Timur phone : +62 (31) 8708456 ext.113 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srinagesh Battula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: Script to remove redundant rows in a table?
there is also the case of trying to enable a unique constraint on the underlying table using the exeption option and creating an exception table(utlexcpt.sql). The unique constraint will of caurse fail but inside the exeption table the duplicate rowids will be written . Using this input you can delete from table the duplicates. -Original Message- From: Haskins, Ed [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 04:10 To: Multiple recipients of list ORACLE-L Subject: Script to remove redundant rows in a table? A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores the database connect descriptors in a table within the Region Database. I've loaded these connect descriptors from many SQLNET.ora files throughout the enterprise. My problem is that there exists duplicates from the multiple SQLNET.ora files. I really want to clean this up so that only one entry per connect descriptor exists. I think that a generic script for any table will work in this situation. Thanks, Ed Haskins Oracle DBA Verizon Wireless -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hatzistavrou Giannis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: unhandled user-defined exception
Title: unhandled user-defined exception I am attaching the source code of the trigger ,Please let me know where I made mistake .Thanks.. Venu -Original Message-From: Venugopal, R (GEP, Contractor) Sent: Thursday, May 17, 2001 7:25 PMTo: Multiple recipients of list ORACLE-LSubject: unhandled user-defined exception Hi Gurus I am getting the error attached below when trigger fires. what could be the reasons for this error. DB error: ORA-06510: PL/SQL: unhandled user-defined exception Thanks in Advance Venu CREATE OR REPLACE TRIGGER dcs20.ESS_ORACLE_CUST_TRG1 BEFORE UPDATE OF NAME1, NAME2, KILLDATE, CUVATCD, USERDEFCOLUMN1, OFICUSTPROFCLASS, STREET1, STREET2, STREET3, CITY, USSTATECD, COUNTRYCD, ZIPCODE, TERMSPAY, COMPID ON EHDA.CUSTBILL FOR EACH ROW WHEN ((NEW.COMPNO = 17 OR NEW.COMPNO = 18) AND NEW.COMPID IS NOT NULL) DECLARE var_extraction_dateVARCHAR2(17); TTYPE VARCHAR2(10); CREDIT_FLG ehda.A_ARCREDITPROF.ORDMANREL%TYPE; COLLECTOR ehda.A_ARCREDITPROF.EMPLOYNO%TYPE; CREDIT_LMT ehda.A_ARCREDITPROF.CREDLIM%TYPE; DUMMY NUMBER(6); err_file_dir_GC VARCHAR2(50):='/sngesstst/appl/dcs20/err/GC'; err_file_dir_SEA VARCHAR2(50):='/sngesstst/appl/dcs20/err/SEA'; err_file_name_gl_GC VARCHAR2(300) ; err_file_name_gl_SEA VARCHAR2(300) ; err_file_h_GC UTL_FILE.FILE_TYPE ; err_file_h_SEA UTL_FILE.FILE_TYPE ; var_count NUMBER; l_o_err_numNUMBER:=0; l_n_err_numNUMBER:=0 ; l_s_err_msgVARCHAR2(500):=' '; l_s_err_string VARCHAR2(300); v_rec_countNUMBER; BEGIN /* Record trigger date */ SELECT TO_CHAR(SYSDATE,'MMDDHH24MIS') INTO var_extraction_date FROM dual; SELECT ORDMANREL, EMPLOYNO, CREDLIM INTO CREDIT_FLG, COLLECTOR, CREDIT_LMT FROM ehda.A_ARCREDITPROF WHERE COMPNO = :NEW.COMPNO ANDORGUNITGRP = 'CR' ANDCUSTNOBILL = :NEW.CUSTNOBILL; END IF; EXCEPTION WHEN OTHERS THEN IF (:NEW.COMPNO='17') THEN /* opening the error file for writing - GC*/ err_file_name_gl_GC:='trigger_error_gc_ess_oracle_cust_trg1.'||var_extraction_date; err_file_h_GC := UTL_FILE.FOPEN(err_file_dir_GC, err_file_name_gl_GC, 'w') ; dbms_output.put_line('Very First Exception'); UTL_FILE.PUT_LINE(err_file_h_GC, RPAD('*', 80, '*' )); UTL_FILE.PUT_LINE(err_file_h_GC,'CUSTOMER RETURNS (GL) TRIGGER fired AT : '||TO_CHAR(SYSDATE, 'DD/MM/ HH:MI:SS')); UTL_FILE.PUT_LINE(err_file_h_GC, RPAD('*', 80, '*' )); l_o_err_num := TO_NUMBER(SQLCODE) ; l_s_err_msg := SUBSTR(SQLERRM,1,100) ; dbms_output.put_line('First Exception'); UTL_FILE.PUT_LINE(err_file_h_GC,l_o_err_num||':'||l_s_err_msg) ; UTL_FILE.FCLOSE(err_file_h_GC); END IF; IF (:NEW.COMPNO='18') THEN /* opening the error file for writing - SEA*/ err_file_name_gl_SEA:='trigger_error_sea_ess_oracle_cust_trg1.'||var_extraction_date; err_file_h_SEA := UTL_FILE.FOPEN(err_file_dir_SEA, err_file_name_gl_SEA, 'w') ; UTL_FILE.PUT_LINE(err_file_h_SEA, RPAD('*', 80, '*' )); UTL_FILE.PUT_LINE(err_file_h_SEA,'CUSTOMER RETURNS (GL) TRIGGER fired AT : '||TO_CHAR(SYSDATE, 'DD/MM/ HH:MI:SS')); UTL_FILE.PUT_LINE(err_file_h_SEA, RPAD('*', 80, '*' )); l_o_err_num := TO_NUMBER(SQLCODE) ; l_s_err_msg := SUBSTR(SQLERRM,1,100) ; UTL_FILE.PUT_LINE(err_file_h_SEA,l_o_err_num||':'||l_s_err_msg) ; UTL_FILE.FCLOSE(err_file_h_SEA); END IF; END;
Build my own aggregate function
Title: Build my own aggregate function Dear gurus, How to build a function that work like aggregate function(SUM,COUNT,..). TIA, Ahmadsyah Alghozi Nugroho Database Engineering Specialist PT Infoglobal AutOptima Jl. Baruk Tengah I/49 Surabaya - Jawa Timur phone : +62 (31) 8708456 ext.113
RE: ??? strange database link problem
Title: RE: ??? strange database link problem Check out the global_name init.ora parameter. It is probably set to true, which forces the name of the database link to be the same as the alias. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Andrea Oracle [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 11:30 PM To: Multiple recipients of list ORACLE-L Subject: ??? strange database link problem Hi all, I tried to create a database link like this: create database link test connect icssowner identified by icssowner using 'AU40CNV'; when I used it, I got: ERROR at line 1: ORA-02085: database link TEST.WORLD connects to AU34TD.WORLD I created other links to AU40CNV, but I got that err again, the link ALWAYS goes to AU34TD.WORLD!!! why? Thanks Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: unhandled user-defined exception
Title: unhandled user-defined exception Add an EXCEPTION to your code and try to trap the error 6510 -Message d'origine-De: Venugopal, R (GEP, Contractor) [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 17 mai 2001 13:25À: Multiple recipients of list ORACLE-LObjet: unhandled user-defined exception Hi Gurus I am getting the error attached below when trigger fires. what could be the reasons for this error. DB error: ORA-06510: PL/SQL: unhandled user-defined exception Thanks in Advance Venu
Re: unhandled user-defined exception
Hi, You have to handle the exception explicitly. You can handle them by trapping When too_many_rows, when no_data_found, when zero_divide. After using these exceptions also if you get the error again, then you can go for when others as a final resort. Hope this helps, Muthaiah At 03:25 AM 5/17/01 -0800, you wrote: Hi Gurus I am getting the error attached below when trigger fires. what could be the reasons for this error. DB error: ORA-06510: PL/SQL: unhandled user-defined exception Thanks in Advance Venu Muthaiah Chinnaveerappan (Muths), Systems Analyst, Chennai, India. Tel : 91-44-2435034 Email : [EMAIL PROTECTED]
Re: Decode in PL/Sql
Gyula, I understand, that you want to apply DECODE function to some local variables in your pl/sql block (and not to some columns in some table). The trick is: you can always run DECODE() against 'dual' table: select DECODE(base_expr, compare1, value1, compare2, value2,... default ) into local_variable_out from dual; In this case 'base_expr' does not have to reference any column in any table. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 5:26 AM Hi Gurus ! Is there any function that can be used in PL/SQL and just works the way as DECODE does in Sql? Thanks in Advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: How to make DBA cannot 'see' User's Tables?
to carry this forward (hey Paul and Anita!) you can also look at: http://www.cybcon.com/~jkstill/util/encryption/encryption.html Jared's site with some VERY easy to understand explanations on how to use encryption and yes the string length has to be a multiple of 8 characters Rachel From: Paul Drake [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: How to make DBA cannot 'see' User's Tables? Date: Wed, 16 May 2001 21:56:01 -0800 A. Bardeen wrote: You can encrypt using only a 56-bit key (the key length limitation is a requirement of US regulations governing the export of cryptographic products). HTH, -- Anita Hi Anita. Ahmadsyah, I believe that you also have to pad the string to a length that is a multiple of 8 characters. Your key string was 10 characters. here's the obligatory link to the fine manual: (that includes a code example) http://technet.oracle.com/doc/oracle8i_816/server.816/a76936/dbms_obf.htm#6518 Paul --- Ahmadsyah Algozhi Nugroho [EMAIL PROTECTED] wrote: I'm using Oracle 8.1.7. there was an error ERROR at line 1: ORA-28232: invalid input length for obfuscation toolkit ORA-06512: at SYS.DBMS_OBFUSCATION_TOOLKIT_FFI, line 0 ORA-06512: at SYS.DBMS_OBFUSCATION_TOOLKIT, line 33 ORA-06512: at SCOTT.IAO_PROTECT, line 15 ORA-06512: at line 1 I check thath my key and my input string is varchar12(10). Key = 0123456789 input string = 'testtestte' dbms_obfuscation_toolkit.desencrypt ( input_string = 'testtestte' , key_string = '1234567890' , encrypted_string = vEncrypted ); Am I forget something? TIA, Ahmadsyah Alghozi Nugroho Database Engineering Specialist PT Infoglobal AutOptima Jl. Baruk Tengah I/49 Surabaya - Jawa Timur phone : +62 (31) 8708456 ext.113 From: Srinagesh Battula [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 7:26 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to make DBA cannot 'see' User's Tables? You can encrypt Decrypt data using the DBMS_OBFUSCATION_TOOLKIT package (comes with 8.1.6) Srinagesh What do I know any way Battula -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to make DBA cannot 'see' User's Tables? Data Encryption? -Original Message- Sent: Wednesday, May 16, 2001 7:01 PM To: Multiple recipients of list ORACLE-L Dear gurus, How to make DBA cannot 'see' user's datas? I build an application which very important and top secret even DBA cannot 'see' this data. But DBA can backup this data.What is the solution for this problem? TIA, Ahmadsyah Alghozi Nugroho Database Engineering Specialist PT Infoglobal AutOptima Jl. Baruk Tengah I/49 Surabaya - Jawa Timur phone : +62 (31) 8708456 ext.113 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srinagesh Battula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL
Oracle 8.1.7.1 NEW Installation on SunOS 5.8
SunOS 5.8 , ORA 8.1.7.1 For Creating a NEW Database ( 1st Time ) SVRMGR connect internal; connected SVRMGR startup nomount pfile=/in1/ora817/dbs/initfin61.ora; ORA-03113 end-of-file on communication channel RESULT Database NOT Coming to NOMOUNT OBSERVATIOM - core of 9MB Dumped in the CORE_DUMP_DEST Dir NOTE - Core Dumped only when Attempting STARTUP NOMOUNT thru the $ORACLE_OWNER When Trying the SAME Command thru Another Unix user of DBA Group . NO Core is Dumped though the Error ORA-3113 Continues NOTE - 1) NO SQL*Net being Done 2) TWO_TASK NOT Set 3) RE-Created the oracle Exes using make -f ins_rdbms.mk install Considering Deleting ORA 8.1.7.1 Installing 8.1.7.0 RE-Trying -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Split Script
Rachel, Your scripts are so slick. I have been using them for 2 years now. I haven't tried any of the others but 'if it's not broke done fix it!'. I am going to be on 8.0.6.3 forever because out vendors won't certify the application for 8i, so yours scripts are a life saver. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 16, 2001 5:27 PM there is a note out on Metalink on how to do this. You can also break the export into separate files in later versions of Oracle8i. or you can run the following script (modified to suit your system, it was last tested on Solaris/Oracle 7.3.4) #!/bin/sh # cd $EXPORT_DIR # # set maximum file size for each chunk of the export file # MAXFILESIZE=2000m export MAXFILESIZE # # create filenames for the parts of the backup... for now let's go to 3 # FILENAME1=$EXPORT_DIR/backup1_$ORACLE_SID.dmp FILENAME2=$EXPORT_DIR/backup2_$ORACLE_SID.dmp FILENAME3=$EXPORT_DIR/backup3_$ORACLE_SID.dmp LOGFILE=$EXPORT_DIR/backup_$ORACLE_SID.log # # save off the old ones # mv $FILENAME1 $FILENAME1.old if [ -f $FILENAME2 ] then mv $FILENAME2 $FILENAME2.old fi if [ -f $FILENAME3 ] then mv $FILENAME3 $FILENAME3.old fi mv $LOGFILE $LOGFILE.old # # create the pipes # mkfifo exportpipeaa mkfifo exportpipeab mkfifo exportpipeac mkfifo wrkpipe umask 000 # # start the readers from the pipes to create the export files # dd if=exportpipeaa of=$FILENAME1 dd if=exportpipeab of=$FILENAME2 dd if=exportpipeac of=$FILENAME3 # # start the reader from the wrkpipe to compress and split the export # dd if=wrkpipe|compress|split -b $MAXFILESIZE - exportpipe # # start the export for real # exp / file=wrkpipe full=y compress=n buffer=4096000 LOG=$LOGFILE # # clean up after ourselves # rm exportpipeaa exportpipeab exportpipeac wrkpipe # # if you haven't used all the pipes, the dd may still linger on # make sure to REALLY clean up # ps -ef|grep exportpipe|grep -vi grep|awk '{printf (kill -9 %d; \n,$2)}'kill.lst chmod u+x kill.lst sh kill.lst rm kill.lst now to import from those split files #!/bin/sh # cd $EXPORT_DIR # # create filenames for the parts of the backup... for now let's go to 3 # FILENAME1=$EXPORT_DIR/backup1_$ORACLE_SID.dmp FILENAME2=$EXPORT_DIR/backup2_$ORACLE_SID.dmp FILENAME3=$EXPORT_DIR/backup3_$ORACLE_SID.dmp LOGFILE=$EXPORT_DIR/backup_$ORACLE_SID.log # # create the pipe to import from # mkfifo wrkpipe umask 000 # # start the reader from the import pipe # imp / file=wrkpipe full=y commit=y buffer=4096000 LOG=$LOGFILE # # create the import stream coming from the pipes # cat $FILENAME1 $FILENAME2 $FILENAME3 | uncompress | dd of=wrkpipe # # clean up the import pipe # rm wrkpipe From: Armstead, Michael A [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Export Split Script Date: Wed, 16 May 2001 13:07:24 -0800 Rajaram, Please give me details on how to use mknod to split export files larger than 2 GB. We have broken our jobs into over 50 separate export jobs on the table level just to keep our files less than 2GB. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Rajaram [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject: RE: Export Split Script If you are using Oracle on Unix , You may want to use unix pipes ( mknod). - most people use this method to manage files 2GB. Rajaram (Now that I am at the top of a mountain - I dont know how to get down!) -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 3:57 PM To: Multiple recipients of list ORACLE-L Subject: Export Split Script I tries using a compressed export and the output is still over 2G. Does anyone have the export script that splits the export files into multiple files? Ron Smith Database Administration [EMAIL PROTECTED] NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: ??? strange database link problem
Title: RE: ??? strange database link problem Check NAMES.DEFAULT_DOMAIN in sqlnet.ora Regards Ivo Libal -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 17, 2001 03:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ??? strange database link problem Check out the global_name init.ora parameter. It is probably set to true, which forces the name of the database link to be the same as the alias. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Andrea Oracle [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 11:30 PM To: Multiple recipients of list ORACLE-L Subject: ??? strange database link problemHi all, I tried to create a database link like this: create database link test connect icssowner identified by icssowner using 'AU40CNV'; when I used it, I got: ERROR at line 1: ORA-02085: database link TEST.WORLD connects to AU34TD.WORLD I created other links to AU40CNV, but I got that err again, the link ALWAYS goes to AU34TD.WORLD!!! why? Thanks Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Database Link ORA-02085
I have two Oracle 8.1.6 database on different servers. I created a link on server 'A' called 'instance_link' whish point to the Instance 'B' on server 'B'. It works fine. I then created a link on server 'B' called 'instance_link' that point to Instance 'A' on server 'A'. When I tried the link I get an ORA-02085 which says the link name must be the same as the instance name. Any ideas why they do not work the same? Thanks! Ron Smith Database Administration [EMAIL PROTECTED] -- 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: unhandled user-defined exception
I would say that the problem is with 'w' parameter of fopen function if the file already exists. Try tu usest like this: Kind Regards Ivo Libal traceFileName := NVL(traceFile,'TRACE_'||TO_CHAR(SYSDATE,'MMDD')||'.OUT'); BEGIN iFile := UTL_FILE.fopen(iPath, traceFileName, 'a'); EXCEPTION WHEN OTHERS THEN iFile := UTL_FILE.fopen(iPath, traceFileName, 'w'); END; UTL_FILE.put_line (iFile,'* '||to_char(sysdate,'DD.MM. HH24:MI:SS')||' - '||traceInfo); UTL_FILE.fclose (iFile); -Original Message-From: Muthaiah [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 17, 2001 03:25 PMTo: Multiple recipients of list ORACLE-LSubject: Re: unhandled user-defined exception Hi,You have to handle the exception explicitly. You can handle them by trapping When too_many_rows, when no_data_found, when zero_divide. After using these exceptions also if you get the error again, then you can go for when others as a final resort.Hope this helps,MuthaiahAt 03:25 AM 5/17/01 -0800, you wrote: Hi Gurus I am getting the error attached below when trigger fires. what could be the reasons for this error. DB error: ORA-06510: PL/SQL: unhandled user-defined exception Thanks in Advance Venu Muthaiah Chinnaveerappan (Muths),Systems Analyst,Chennai, India.Tel : 91-44-2435034Email : [EMAIL PROTECTED]
RE: BMC Patrol - 2nd Wave
Wow, you're absolutely right () -Original Message- Sent: Wednesday, May 16, 2001 11:31 PM To: Multiple recipients of list ORACLE-L oh you silly person... it is ALWAYS the DBA's fault, whether or not it has to do with the database, whether or not the DBA was even employed by the company at the time of installation, whether or not the DBA had anything to do with it at all. Repeat after me: I'm wrong, I've always been wrong, I will always BE wrong. Let's move on from there :) From: Miller, Jay [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: BMC Patrol - 2nd Wave Date: Wed, 16 May 2001 13:51:09 -0800 One advantage to never having been consulted on whether it should be done and having consultants installing it is that it would be hard to blame me for anything that goes wrong :). -Original Message- Sent: Wednesday, May 16, 2001 5:13 PM To: Multiple recipients of list ORACLE-L My experience is that BMC leaves a big footprint on the systems it monitors. So unless you have a system with 6+ cpu's the hogs reported are BMC related or the slow system is caused by BMC. And the $$ it costs, ouch. I have seen better results in shops using Big Brother ( http://bb4.com/ http://bb4.com/ ) or NetSaint ( http://netsaint.sourceforge.net/ http://netsaint.sourceforge.net/ ). Maybe Patrol works for some people. But my advise is to stay away so that when the project dies and they try to decide who is to blame for spending $$ on a POS you will not be within ear shot. That's just my opinion, I could be wrong. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, May 16, 2001 1:03 PM To: Multiple recipients of list ORACLE-L So my boss calls me over yesterday and tells me he needs two servers for 2nd Wave to install BMC on to monitor the databases. I say, huh? Apparently the CIO decided to have a consulting company (2nd Wave) install and configure BMC to monitor all the databases (Oracle and SQL Server) in the company. I met with them briefly today (only because I asked to, it hadn't been deemed necessary before that) and I'll admit it doesn't look too bad so far, even if we already get all the information they provide (plus more) from various sql scripts and statspack. Does anyone have any gotchas, warnings, send out your resume NOW recommendations for working with the BMC Patrol product? Any experience with 2nd Wave? Thanks in advance! Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send
RE: Oracle 8.1.7.1 NEW Installation on SunOS 5.8
Hi Vivek, I had a simular problem on DG/UX. It turned out that the shared memory was the problem: after freeing shared memory that had no processes connected to it, the problem was solved. HTH, Remco -Oorspronkelijk bericht- Van: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Verzonden: donderdag 17 mei 2001 16:31 Aan: Multiple recipients of list ORACLE-L Onderwerp: Oracle 8.1.7.1 NEW Installation on SunOS 5.8 SunOS 5.8 , ORA 8.1.7.1 For Creating a NEW Database ( 1st Time ) SVRMGR connect internal; connected SVRMGR startup nomount pfile=/in1/ora817/dbs/initfin61.ora; ORA-03113 end-of-file on communication channel RESULT Database NOT Coming to NOMOUNT OBSERVATIOM - core of 9MB Dumped in the CORE_DUMP_DEST Dir NOTE - Core Dumped only when Attempting STARTUP NOMOUNT thru the $ORACLE_OWNER When Trying the SAME Command thru Another Unix user of DBA Group . NO Core is Dumped though the Error ORA-3113 Continues NOTE - 1) NO SQL*Net being Done 2) TWO_TASK NOT Set 3) RE-Created the oracle Exes using make -f ins_rdbms.mk install Considering Deleting ORA 8.1.7.1 Installing 8.1.7.0 RE-Trying -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ??? strange database link problem
The parameter is the same on both servers. I changed the link name from instance_link to instance and it worked fine. Why is it complaining about the _link in the name? Ron -Original Message- Sent: Thursday, May 17, 2001 9:41 AM To: Multiple recipients of list ORACLE-L Check NAMES.DEFAULT_DOMAIN in sqlnet.ora Regards Ivo Libal -Original Message- Sent: Thursday, May 17, 2001 03:55 PM To: Multiple recipients of list ORACLE-L Check out the global_name init.ora parameter. It is probably set to true, which forces the name of the database link to be the same as the alias. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Andrea Oracle [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Wednesday, May 16, 2001 11:30 PM To: Multiple recipients of list ORACLE-L Subject: ??? strange database link problem Hi all, I tried to create a database link like this: create database link test connect icssowner identified by icssowner using 'AU40CNV'; when I used it, I got: ERROR at line 1: ORA-02085: database link TEST.WORLD connects to AU34TD.WORLD I created other links to AU40CNV, but I got that err again, the link ALWAYS goes to AU34TD.WORLD!!! why? Thanks Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Export Split Script
On Wed, 16 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon: -de nada -- just trying to beat my fan club (thanks Ruth and Bill :) ) to -the punch. Hi, I'm Bill and I'm a Goddess Groupie.;-) - -Now. in 8i (not sure which flavor) you can have export do the split as -part of the export. I don't think it compresses it but it will at least -break the files down I'm using it on 8.1.5, and no it doesn't compress the splits, I do that afterward with gzip -9.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ BASIC is to computer programming as QWERTY is to typing. - Seymour Papert -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ??? strange database link problem
Title: RE: ??? strange database link problem # Global Naming -- enforce that a dblink has same name as the db it connects toglobal_names = true Your problem is this. make it to false or obey the rules. - Original Message - From: Libal, Ivo To: Multiple recipients of list ORACLE-L Sent: Thursday, May 17, 2001 5:41 PM Subject: RE: ??? strange database link problem Check NAMES.DEFAULT_DOMAIN in sqlnet.ora Regards Ivo Libal -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 17, 2001 03:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ??? strange database link problem Check out the global_name init.ora parameter. It is probably set to true, which forces the name of the database link to be the same as the alias. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Andrea Oracle [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 11:30 PM To: Multiple recipients of list ORACLE-L Subject: ??? strange database link problem Hi all, I tried to create a database link like this: create database link test connect icssowner identified by icssowner using 'AU40CNV'; when I used it, I got: ERROR at line 1: ORA-02085: database link TEST.WORLD connects to AU34TD.WORLD I created other links to AU40CNV, but I got that err again, the link ALWAYS goes to AU34TD.WORLD!!! why? Thanks Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: unhandled user-defined exception
Title: unhandled user-defined exception Hi Venu, Did you set the database parameter utl_file_dir ? Remco -Oorspronkelijk bericht-Van: Venugopal, R (GEP, Contractor) [mailto:[EMAIL PROTECTED]]Verzonden: donderdag 17 mei 2001 14:52Aan: Multiple recipients of list ORACLE-LOnderwerp: RE: unhandled user-defined exception I am attaching the source code of the trigger ,Please let me know where I made mistake .Thanks.. Venu -Original Message-From: Venugopal, R (GEP, Contractor) Sent: Thursday, May 17, 2001 7:25 PMTo: Multiple recipients of list ORACLE-LSubject: unhandled user-defined exception Hi Gurus I am getting the error attached below when trigger fires. what could be the reasons for this error. DB error: ORA-06510: PL/SQL: unhandled user-defined exception Thanks in Advance Venu
RE: Temporary files and Quick i/o
Maybe workaround is to precreate files and when creating temporary tablespaces use precreated files with reuse. Alex Hillman -Original Message- Sent: Thursday, May 17, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Hi, After reading Steve Adams' tip on making temp files quick io. I posed this question to Veritas as they had told us not do so. The answer they give is the following. Temporary datafiles should not be converted to quick i/o files. The following is an excerpt from the administrator's Guide: Tablespaces marked TEMPORARY can be sparse, which means that not all blocks in the file are allocated. Quick I/O files cannot be sparse, as Quick I/O provides a raw-type interface to storage. If a sparse file is converted to a Quick I/O file, the Oracle instance can fail if Oracle attempts to write into one of these unallocated blocks. I would appreciate your thoughts on this? Johnson Job __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Script that will remove redundant rows from table
Eric, Yes they did...I am not resending this message. Either the List software is screwing up, or my Company's email servers suck. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, May 16, 2001 9:45 PM To: Multiple recipients of list ORACLE-L didn't 27 1/2 people post the answer to this yesterday??? On 16 May 2001, at 17:10, Haskins, Ed wrote: A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PCTFREE/PCTUSED
PCT_USED = PCT_FREE + 1 row sizePCT_USED + PCT_FREE 100 Are the rules . But what does 1 row size mean here? For ex . My pctfree=30 1 row size (avg.) = 150 bytes . Then what is PCT_USED ? TIA
How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help Please!
Hello: Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today. I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5.I have to install 8.0.6.(new one) Then I need get all those data and schemas into 8.0.6. I know in some way this can be done, Now matter how risk I have to do at client's request. What is the steps and safe procedures??? Thanks in advanceDo You Yahoo!? Yahoo! Auctions $2 Million Sweepstakes - Got something to sell?
How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help Please!
Hello DBAs: Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today. I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5. I have to install 8.0.6.(new one) Then I need get all those data and schemas into 8.0.6. I know in some way this can be done, Now matter how risk I have to do at client's request. What is the steps and safe procedures??? Thanks in advanceDo You Yahoo!? Yahoo! Auctions $2 Million Sweepstakes - Got something to sell?
RE: How to downgrade database from 8.1.5 to 8.0.6 - Urgent
The upgrade doco also has the downgrade steps. Check your documentation. -Original Message- Sent: Thursday, May 17, 2001 9:56 AM To: Multiple recipients of list ORACLE-L Hoo boy...I guess the safest approach is to run the catalog script against the 8.1.6 database that changes the export views to be 8.0.6 compatible, then do a full export and import. [EMAIL PROTECTED] 05/17/01 12:15PM Hello DBAs: Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today. I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5. I have to install 8.0.6.(new one) Then I need get all those data and schemas into 8.0.6. I know in some way this can be done, Now matter how risk I have to do at client's request. What is the steps and safe procedures??? Thanks in advance - Do You Yahoo!? Yahoo! Auctions $2 Million Sweepstakes - Got something to sell? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ??? strange database link problem
That was it. Thanks! -Original Message- Sent: Thursday, May 17, 2001 10:31 AM To: Multiple recipients of list ORACLE-L # Global Naming -- enforce that a dblink has same name as the db it connects to global_names = true Your problem is this. make it to false or obey the rules. - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Thursday, May 17, 2001 5:41 PM Check NAMES.DEFAULT_DOMAIN in sqlnet.ora Regards Ivo Libal -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, May 17, 2001 03:55 PM To: Multiple recipients of list ORACLE-L Check out the global_name init.ora parameter. It is probably set to true, which forces the name of the database link to be the same as the alias. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Andrea Oracle [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Wednesday, May 16, 2001 11:30 PM To: Multiple recipients of list ORACLE-L Subject: ??? strange database link problem Hi all, I tried to create a database link like this: create database link test connect icssowner identified by icssowner using 'AU40CNV'; when I used it, I got: ERROR at line 1: ORA-02085: database link TEST.WORLD connects to AU34TD.WORLD I created other links to AU40CNV, but I got that err again, the link ALWAYS goes to AU34TD.WORLD!!! why? Thanks Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Script that will remove redundant rows from table
Who was the half person? -Original Message- Sent: Wednesday, May 16, 2001 9:37 PM To: Multiple recipients of list ORACLE-L now now, don't exaggerate it was only 25 1/4 people From: Eric D. Pierce [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Script that will remove redundant rows from table Date: Wed, 16 May 2001 17:45:22 -0800 didn't 27 1/2 people post the answer to this yesterday??? On 16 May 2001, at 17:10, Haskins, Ed wrote: A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Aschenbrenner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: unhandled user-defined exception
The trigger code would probably help... --- Venugopal, R (GEP, Contractor) [EMAIL PROTECTED] wrote: Hi Gurus I am getting the error attached below when trigger fires. what could be the reasons for this error. DB error: ORA-06510: PL/SQL: unhandled user-defined exception Thanks in Advance Venu = 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!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- 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: How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help P
The safest way is to do a full database export, to create a new 8.0.6 database instance and to import the datain the new database. You have to see for inter-version specifics - you might need to use 8.1.5 import version to import in the 8.0.6 database - you have to check that, but it is for sure doable. If at all possible, I would not delete the original 8.1.5 database before I am fully done with the import and I test that 8.0.6 is working fine. If you do not have enough space for 8.1.5 + export file + 8.0.5 (and you are on unix) you might use the named pipes for export/import (again make sure that the exp/imp versions are OK): · create a named pipe: $ mknod p_expimp p · export from the source database to the pipe: $ exp userid=src_username/password file=p_expimp OtherParameters · at the same time importing from the pipe is started: $ imp userid=trg_username/password file=p_expimp buffer=1024000 OtherParameters Djordje -Original Message-From: Helen rwulfjeq [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 17, 2001 12:16 PMTo: Multiple recipients of list ORACLE-LSubject: How to downgrade database from 8.1.5 to 8.0.6 - Urgent Help Please! Hello: Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today. I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5.I have to install 8.0.6.(new one) Then I need get all those data and schemas into 8.0.6. I know in some way this can be done, Now matter how risk I have to do at client's request. What is the steps and safe procedures??? Thanks in advance Do You Yahoo!?Yahoo! Auctions $2 Million Sweepstakes - Got something to sell?
Re: Script that will remove redundant rows from table
How about we split the difference? | 1* select (25.25+27.5)/2 from dual |SQL / | |(25.25+27.5)/2 |-- |26.375 | (no this is not the mean) On 16 May 2001, at 19:36, Rachel Carmichael wrote: now now, don't exaggerate it was only 25 1/4 people ... didn't 27 1/2 people post the answer to this yesterday??? ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: BMC Patrol - 2nd Wave
You haven't been a DBA too long have you? ... if you manage the db, you are responsible. period. at least that's the way it's been everywhere for me, but I could be wrong... -Original Message- Sent: Wednesday, May 16, 2001 2:51 PM To: Multiple recipients of list ORACLE-L One advantage to never having been consulted on whether it should be done and having consultants installing it is that it would be hard to blame me for anything that goes wrong :). -Original Message- Sent: Wednesday, May 16, 2001 5:13 PM To: Multiple recipients of list ORACLE-L My experience is that BMC leaves a big footprint on the systems it monitors. So unless you have a system with 6+ cpu's the hogs reported are BMC related or the slow system is caused by BMC. And the $$ it costs, ouch. I have seen better results in shops using Big Brother ( http://bb4.com/ http://bb4.com/ ) or NetSaint ( http://netsaint.sourceforge.net/ http://netsaint.sourceforge.net/ ). Maybe Patrol works for some people. But my advise is to stay away so that when the project dies and they try to decide who is to blame for spending $$ on a POS you will not be within ear shot. That's just my opinion, I could be wrong. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, May 16, 2001 1:03 PM To: Multiple recipients of list ORACLE-L So my boss calls me over yesterday and tells me he needs two servers for 2nd Wave to install BMC on to monitor the databases. I say, huh? Apparently the CIO decided to have a consulting company (2nd Wave) install and configure BMC to monitor all the databases (Oracle and SQL Server) in the company. I met with them briefly today (only because I asked to, it hadn't been deemed necessary before that) and I'll admit it doesn't look too bad so far, even if we already get all the information they provide (plus more) from various sql scripts and statspack. Does anyone have any gotchas, warnings, send out your resume NOW recommendations for working with the BMC Patrol product? Any experience with 2nd Wave? Thanks in advance! Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sqlldr help
I have a data file that looks like this; 100Memo line 1 information. 100more information for record 100. 100extra information again. 200Memo for 200. 200more info for 200 300info for 300 300next memo 300and more 300yet more again. I want to load to a table (col1, infodesc) to look like this; col1infodesc -- 100Memo line 1 information. more information for record 100. extra information again 200extra information again. Memo for 200. more info for 200 300info for 300 next memo and more yet more again. Can this be done with sqlldr or do I need to load the data as is and use PL/SQL (and cursor loops) to concatentate the data? thanks for any help! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 downgrade database from 8.1.5 to 8.0.6 - Urgent Help Please!
Export/Import this was actually mentioned in chapter 3 in the Oracle8i Migration Release (A76957-01) Hello: Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today. I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5. I have to install 8.0.6.(new one) Then I need get all those data and schemas into 8.0.6. I know in some way this can be done, Now matter how risk I have to do at client's request. What is the steps and safe procedures??? Thanks in advance - Do You Yahoo!? Yahoo! Auctions $2 Million Sweepstakes - Got something to sell? Roy E. Ferguson II Intel Sacramento 916-854-1123 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What is the cost of replication?
A., Just out of curiosity, is your paper pertinent to NT/Win2K? Is the replication done strictly within Oracle? what about stuff like this?: http://www.nsisw.com/main/pages/products.html regarding your private question about rifts in space/time continuums, the world is probably safe for the time being since there is a 3,000 mile separation, but here are some ideas that you , Ross and I can work on in case we ever get together w/ the Oracle-L group at a conference or whatever: http://wc4.com/fartfart/index.html - http://www.headscape.com/windbreak.htm And of course lest anyone think that there aren't implications to these issues that threaten the very existence of our species (or more generally the evolutionary process that leads to organisms being capable of excercising powers of higher conciousness), please see below (no pun intended); http://www.electricearl.com/fart/fartnews.html ---excerpt--- ...Now, according to the August 2, 2000, edition of the Daily Sport in London, Great Britain's Agricultural Ministry is spending 267,000 pounds 'to find out what happens when cows fart.' According to the newspaper, 'Scientists say a massive 25 per cent of all methane gas in the world's atmosphere is produced by cows.' One Member of Parliament, Gordon Prentice, said, 'It beggars belief that cows, with their legendary five stomachs, are responsible for doing so much damage.' Stay tuned for more details. ... ---end--- regards, ep On 16 May 2001, at 20:30, A. Bardeen wrote: Replication is not for the faint of heart and it would behoove you to research this to see if replication is really the right way to accomplish your goal. ... -- Anita P.S. I'm sending you my paper which discusses many of the issues you should consider before implementing replication. --- Smith, Ron L. [EMAIL PROTECTED] wrote: We have a small but critical application running on NT. The user wants to implement replication. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Gateway Product for Progress Database
Does anybody know if a gateway exists between the Oracle database and Progress database? Thanks. Sam Bootsma Technical Support Analyst CPAS Systems Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Forms and Reports Server versions vs. RDBMS versions
We are planning to upgrade our databases to 8.1.6. or 8.1.7, and I am trying to figure out which OAS/iAS, Forms / Reports and RDBMS versions go together best. This is my list so far (RDBMS -- Developer/Forms/Reports -- OWS/OAS/iAS -- OEM): Oracle 7.3.3. -- Developer 1.6.1 -- n/a -- n/a Oracle 7.3.4. -- Developer 2.1 -- OWS 3.0.1.1. -- OEM 1.3 (?) Oracle 8.0.4/8.0.5 -- Developer 6 -- OAS 4.0.8.1. -- OEM 1.6 Oracle 8.0.6 -- Forms / Reports 6i patch 2 -- OAS 4.0.8.2. -- OEM 2.0 Oracle 8.1.6. -- Forms / Reports 6i patch 4 (6.0.8.14) -- iAS 1.0.1.0 -- OEM 2.1 Oracle 8.1.7 -- Forms / Reports 6i patch 5 -- iAS 1.0.2.0 -- OEM 2.2 Oracle 9.0 -- Forms / Reports (?) -- iAS (?) -- OEM (?) Is this correct? I wish there was a page on the Oracle web site with a matrix like this. TIA 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 -- 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: enqueue waits -- CI (still remains)
Thanks for the TX information Jeffery. But my question about CI enqueue still remains. Here's the query to get enqueue waits statistics, it's from Steve Adams' site. select q.ksqsttyp type, q.ksqstget gets, q.ksqstwat waits from sys.x_$ksqst q where q.ksqstget 0 / thanks again - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 5:55 AM Hi Diego, If lock type is 'TX', rollback segment number = trunc(p2/65536) and slot number = p2 - 65536*trunc(p2/65536). May I know which table you are looking at to get the following detailed info about enqueue waits? Enqueue Stats -- TY GETS WAITS -- - - CF68 0 CI 1117884 CU 1797012 DL 109 0 DR 102 0 DX 6219 0 IS72 0 MR 140 0 RT 1 0 SQ 2472 5 SS 1 0 ST 320734 TM278918 5 TS 4655 0 TX21005757 UL 3500 0 US 30496 0 WL10 0 18 rows selected. Thanks Jeffery Diego Cutrone wrote: Thanks for answering Unal, John. John, you were right about the query. I've corrected it. And I'm not getting T[ and CK anymore,now I get TX and CI. I've also done further investigation and I also know now what p2 and p3 mean. This is the updated data: (from the dumps) count TYPE MODE 13 CI 6 p2=0 p3=5 ela=0 19 TX 6 p2=262223 p3=53352 ela=301 75 TX 4 p2=524391 p3=50022 ela=301 75 TX 6 p2=720923 p3=5194 ela=301 104TX 6 p2=196736 p3=52393 ela=301 305TX 6 p2=393276 p3=50281 ela=301 Now, how can I get the rollback segment number involved in the TX ? (I know its from p2 and p3, but how?) --just curious. I'll also take John advise, and I'll try to identify the locking session(s). Now, although CI enqueue waits (cross instance call invocation) are brief on this sample, Sometimes it's not. So I'm trying to understand what it means. According to p2 and p3 flags, they are indicating Flush buffers for reuse as new class, that means that a session needs a buffer (in the shared pool I think) and it has to flush some others in order to get space. am I correct?. I've also read a metalink document (1020355.102). According to this, one possible cause is that my application is using dbms_pipe extensively (it may be right, I've seen event pipe get very high). The suggested solution is to increase the shared_pool. I can't access the other documents mentioned in the paper. Can someone explain to me what means this CI enqueue and how can I reduce it. TIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 6:16 PM Hi Diego, Without going into details, an 'enqueue' wait is mostly due to a user/program initated transaction lock and I see it a lot in Financial databases (I see you are on 10.7?). I deduce you were looking at V$SYSTEM_EVENT - If a user locked one row (probably queried a row in Forms, inadvertly changed one character which issues a 'SELECT for UPDATE, thus locking that row) and anotehr user (through a form or a report) needs to perform DML on that particular row, then (I believe) you will clock up time against the 'enqueue' event. What I would suggest is that you use the following query to determine if someone is locking someone else out: select event, count(*) from v$session_wait group by event If you see the 'enqueue' event in this list, some process is probably waiting on a lock... You can then trace the user/process via Lock detection scripts (see Metablink) and kill the blocking process. You could also query from sys.dba_waiters which will present an easier picture in this case.. As far as the SQL goes, see below: select chr(bitand(p1,-16777216)/16777215)||chr(bitand(p1,16711680)/63365) Lock, - I believe the value is '65535', rather than 63365) to_char(bitand(p1,65535)) Mode from dual You can learn a lot from the Oracle 8.1 Reference Manual - Appendix A. Oracle Wait Events and App B Oracle Enqueue Names. While they are applicable for 8.1, most of the info is valid for 7.3 as well... Please let us know if you need additional info. John Kanagaraj (A long time member of the Always look at v$session_wait first camp) Oracle Applications DBA Hitach Data Systems, Santa Clara Work : (408) 970 7002 -Original Message- Sent: Tuesday, May 15, 2001 11:50 AM
Re[2]: How to make DBA cannot 'see' User's Tables?
Yes you can encrypt the data, or you could invest in Trusted Oracle. But the question really becomes one of what are you trying to do. If the problem is that you question the integrity of the DBA that becomes a management problem. On the other hand, if you don't question his/her integrity then what's the problem? Most DBA's that I know of, myself included, don't have the time and/or inclination to browse through application data no matter how sensitive it may be. And on top of all that, the data in your database is not your personal property, but the property of your employer and the DBA is one of his employees. He/she just happens to have GOD privileges and is intrusted with the security and integrity of all of the data. That's why he/she has those privileges. Dick Goulet Reply Separator Author: Paul Drake [EMAIL PROTECTED] Date: 5/16/2001 9:55 PM A. Bardeen wrote: You can encrypt using only a 56-bit key (the key length limitation is a requirement of US regulations governing the export of cryptographic products). HTH, -- Anita Hi Anita. Ahmadsyah, I believe that you also have to pad the string to a length that is a multiple of 8 characters. Your key string was 10 characters. here's the obligatory link to the fine manual: (that includes a code example) http://technet.oracle.com/doc/oracle8i_816/server.816/a76936/dbms_obf.htm#6518 Paul --- Ahmadsyah Algozhi Nugroho [EMAIL PROTECTED] wrote: I'm using Oracle 8.1.7. there was an error ERROR at line 1: ORA-28232: invalid input length for obfuscation toolkit ORA-06512: at SYS.DBMS_OBFUSCATION_TOOLKIT_FFI, line 0 ORA-06512: at SYS.DBMS_OBFUSCATION_TOOLKIT, line 33 ORA-06512: at SCOTT.IAO_PROTECT, line 15 ORA-06512: at line 1 I check thath my key and my input string is varchar12(10). Key = 0123456789 input string = 'testtestte' dbms_obfuscation_toolkit.desencrypt ( input_string = 'testtestte' , key_string = '1234567890' , encrypted_string = vEncrypted ); Am I forget something? TIA, Ahmadsyah Alghozi Nugroho Database Engineering Specialist PT Infoglobal AutOptima Jl. Baruk Tengah I/49 Surabaya - Jawa Timur phone : +62 (31) 8708456 ext.113 From: Srinagesh Battula [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 7:26 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to make DBA cannot 'see' User's Tables? You can encrypt Decrypt data using the DBMS_OBFUSCATION_TOOLKIT package (comes with 8.1.6) Srinagesh What do I know any way Battula -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to make DBA cannot 'see' User's Tables? Data Encryption? -Original Message- Sent: Wednesday, May 16, 2001 7:01 PM To: Multiple recipients of list ORACLE-L Dear gurus, How to make DBA cannot 'see' user's datas? I build an application which very important and top secret even DBA cannot 'see' this data. But DBA can backup this data.What is the solution for this problem? TIA, Ahmadsyah Alghozi Nugroho Database Engineering Specialist PT Infoglobal AutOptima Jl. Baruk Tengah I/49 Surabaya - Jawa Timur phone : +62 (31) 8708456 ext.113 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srinagesh Battula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: index FS vs index FFS - what's the difference ?
Hi Ed I think, For full index scan, oracle server process reads the root block and branch blocks 1 block at a time. It reads the leaf blocks at a db file multiblock -read count blocks per read call. For the fast full scan, it reads all the block from the segment header to high water mark at a db_file_multiblock_read count blocks per read call. So, root blocks and branch blocks are read 1 block at a time, hence the db file sequential read. Where as for the fast full index scan you will see sequential read events only for the root block. Also, for the full index scan apparently knows about the extent boundary and if the next group of blocks to be read (in the current extent) is less than the db file multiblock read count , then it tries to read until the end of the current extent. That's why 11 blocks instead of 8 blocks. For the 'db file parallel read' the segment read are file 1 block 11, which is a system rollback segment extent. If you dump the block, you could see the redo for index leaf operations. I guess, this is due to delayed instance recovery. All these, I found from dumping blocks and doing research myself. Steve, Can you please clarify ? Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Shevtsov, Eduard [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/17/01 03:40 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:index FS vs index FFS - what's the difference ? Hi List, I've made two corresponding dumps and ... I must admit I have much less understanding than I had before. Please look at them. = PARSING IN CURSOR #1 len=68 dep=0 uid=32 oct=3 lid=32 tim=219058914 hv=168660475 ad='aa69f79c' select /*+ INDEX(documents pk_documents) */ count(*) from documents END OF STMT PARSE #1:c=12,e=29,p=27,cr=322,cu=6,mis=1,r=0,dep=0,og=4,tim=219058914 EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=219058914 WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #1: nam='file open' ela= 0 p1=0 p2=0 p3=0 WAIT #1: nam='db file sequential read' ela= 1 p1=22 p2=108810 p3=1 WAIT #1: nam='db file sequential read' ela= 1 p1=22 p2=109485 p3=1 WAIT #1: nam='db file sequential read' ela= 0 p1=22 p2=108811 p3=1 WAIT #1: nam='db file scattered read' ela= 1 p1=22 p2=108812 p3=11 [skip] WAIT #1: nam='db file parallel read' ela= 1 p1=1 p2=11 p3=11 WAIT #1: nam='db file parallel read' ela= 0 p1=1 p2=11 p3=11 [skip] WAIT #1: nam='db file scattered read' ela= 0 p1=22 p2=109472 p3=11 WAIT #1: nam='db file sequential read' ela= 0 p1=22 p2=109483 p3=1 WAIT #1: nam='db file sequential read' ela= 0 p1=22 p2=109486 p3=1 WAIT #1: nam='db file parallel read' ela= 0 p1=1 p2=11 p3=11 = PARSING IN CURSOR #1 len=72 dep=0 uid=32 oct=3 lid=32 tim=219108177 hv=3669603672 ad='aa6a4f84' select /*+ INDEX_FFS(documents pk_documents) */ count(*) from documents END OF STMT PARSE #1:c=11,e=13,p=27,cr=322,cu=6,mis=1,r=0,dep=0,og=4,tim=219108177 EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=219108177 WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #1: nam='file open' ela= 0 p1=0 p2=0 p3=0 WAIT #1: nam='db file sequential read' ela= 1 p1=22 p2=108809 p3=1 WAIT #1: nam='db file scattered read' ela= 2 p1=22 p2=108810 p3=8 WAIT #1: nam='db file scattered read' ela= 0 p1=22 p2=108818 p3=8 [skip, all next lines are the same] My questions are 1. Why I get 'db file scattered read' waits for index full scan ? 2. Why p3 for this event is 11 even though my db_file_multiblock_read_count = 8 ? 3. What does mean 'db file parallel read' event? Anjo Kolk's paper doesn't describe it (guess the wait is Oracle8-specific). Oracle 8i Reference says: blockquote This happens during recovery. Database blocks that need to be changed as part of recovery are read in parallel from the database./blockquote But it seems not my case. 4. Finally, what is the difference between the two index paths in that case ? I'm on 8.1.7.0 Solaris, file-based system, LMT Thanks in advance, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Script that will remove redundant rows from table
Are you an idiot? :-) Alex Hillman -Original Message- Sent: Thursday, May 17, 2001 2:07 PM To: Multiple recipients of list ORACLE-L HELP || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 17, 2001 1:32 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: Script that will remove redundant rows from table || || || How about we split the difference? || || | 1* select (25.25+27.5)/2 from dual || |SQL / || | || |(25.25+27.5)/2 || |-- || |26.375 || | || || (no this is not the mean) || || || On 16 May 2001, at 19:36, Rachel Carmichael wrote: || || now now, don't exaggerate it was only 25 1/4 people || ... || || didn't 27 1/2 people post the answer to this yesterday??? || || ... || || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Eric D. Pierce || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Moving a database to a different machine
Allright, We are physically moving our office, and have an OLTP application that needs to be up and running with minimal downtime. The current plan is to use the development computer as the production platform while the Primary computer is physically moved to the new location. The development system was the production system about 6 months ago, so it will not be under too much strain. I have completely duplicated the filesystems of the Primary machine on the development box. This is my plan. Please comment if there is an obviously better way. Oh the database is version 7.3.4 1.Put the tablespaces of the production database in backup mode. 2.Copy datafiles across the network to the development machine. Approx 3 GB 3.Take the production tablespaces out of backup mode. 4.Force a log switch.(Habit I guess) 5.wait until the production system is brought down. 6.move the control files and redo logs to the development system 7.move the initSID.ora and configSID.ora files. 8.edit configSID.ora to change the host associated to Listener. 9.fire up svrmgrl, and recover the database. 10.change the tnsnames on the client systems to point to the development machine. Of course. This needs to be tested to some degree first. And we(well management at least) don't want to bring the production machine down to roll the databases forward together just for a test. I can use make a backup control file for use during recovery, and move the curently offline redo logs. I am not sure what to do about the most current redo log in this case. I have played with backup and recovery, but not this scenario. I don't currently have my copy of the Velpuri backup and recovery handbook at hand(Loaned it to a colleague). So I am bouncing this off of you folks while I ponder this until I retrieve my backup and recovery bible. Any Comments are appreciated. Thanks, Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Truncate listener.log how?
Gurus I want to truncate listener.log file.I am using oracle 8.1.5 and 8.1.7 on solaris 8.Plese suggest.As I understand go to listener.log file directory copy listener.log listener.old tail -10 listener.log Thanks in advance. -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Script that will remove redundant rows from table
Are you an idiot? ( oh god, I can't believe I said that. might as well finish it ) ALL YOUR BASE ARE BELONG TO US ;^{) On Thursday 17 May 2001 11:07, Mohan, Ross wrote: HELP || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 17, 2001 1:32 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: Script that will remove redundant rows from table || || || How about we split the difference? || || | 1* select (25.25+27.5)/2 from dual || |SQL / || | || |(25.25+27.5)/2 || |-- || |26.375 || || (no this is not the mean) || || On 16 May 2001, at 19:36, Rachel Carmichael wrote: || now now, don't exaggerate it was only 25 1/4 people || || ... || || didn't 27 1/2 people post the answer to this yesterday??? || || ... || || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Eric D. Pierce || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forms and Reports Server versions vs. RDBMS versions
I logged a TAR with Oracle, and their Metalink technician replied that... all the current versions are certified to work together. I knew that. What I want to know is, which versions of OAS , OEM or Developer were designed on concert with which version of the RDBMS. E.g. as part of the server technology track, Application Server CDs, tend to come with an RDBMS CD - iAS 1.0.2 came with 8.1.7. and Jdeveloper 3. Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Subject:Forms and Reports Server versions vs. RDBMS versions We are planning to upgrade our databases to 8.1.6. or 8.1.7, and I am trying to figure out which OAS/iAS, Forms / Reports and RDBMS versions go together best. This is my list so far (RDBMS -- Developer/Forms/Reports -- OWS/OAS/iAS -- OEM): Oracle 7.3.3. -- Developer 1.6.1 -- n/a -- n/a Oracle 7.3.4. -- Developer 2.1 -- OWS 3.0.1.1. -- OEM 1.3 (?) Oracle 8.0.4/8.0.5 -- Developer 6 -- OAS 4.0.8.1. -- OEM 1.6 Oracle 8.0.6 -- Forms / Reports 6i patch 2 -- OAS 4.0.8.2. -- OEM 2.0 Oracle 8.1.6. -- Forms / Reports 6i patch 4 (6.0.8.14) -- iAS 1.0.1.0 -- OEM 2.1 Oracle 8.1.7 -- Forms / Reports 6i patch 5 -- iAS 1.0.2.0 -- OEM 2.2 Oracle 9.0 -- Forms / Reports (?) -- iAS (?) -- OEM (?) Is this correct? I wish there was a page on the Oracle web site with a matrix like this. TIA 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 -- 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: 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: Script that will remove redundant rows from table
Deal! :) From: Eric D. Pierce [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Script that will remove redundant rows from table Date: Thu, 17 May 2001 09:31:33 -0800 How about we split the difference? | 1* select (25.25+27.5)/2 from dual |SQL / | |(25.25+27.5)/2 |-- |26.375 | (no this is not the mean) On 16 May 2001, at 19:36, Rachel Carmichael wrote: now now, don't exaggerate it was only 25 1/4 people ... didn't 27 1/2 people post the answer to this yesterday??? ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Script that will remove redundant rows from table
Mr. Rhet Device (rhet oracle device, that is) On 17 May 2001, at 8:21, Alan Aschenbrenner wrote: Who was the half person? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sqlldr help
Sounds like a job for Perl. Here's an example of cleaning up this data before you send it to the database. Really, this is much easier than doing it with PL/SQL or Java. Jared -- #!/usr/bin/perl our %hashData; while(DATA) { my($key, @data) = split(/\s/); if (defined($hashData{$key} ) ) { $hashData{$key} .= ' ' . join(' ',@data); } else { $hashData{$key} = join(' ',@data); } } foreach my $key ( sort keys %hashData ) { print Key: $key - |$hashData{$key}|\n; } __DATA__ 100 Memo line 1 information. 100 more information for record 100. 100 extra information again. 200 Memo for 200. 200 more info for 200 300 info for 300 300 next memo 300 and more 300 yet more again. -- On Thursday 17 May 2001 10:45, Glenn Travis wrote: I have a data file that looks like this; 100Memo line 1 information. 100more information for record 100. 100extra information again. 200Memo for 200. 200more info for 200 300info for 300 300next memo 300and more 300yet more again. I want to load to a table (col1, infodesc) to look like this; col1infodesc -- 100Memo line 1 information. more information for record 100. extra information again 200extra information again. Memo for 200. more info for 200 300info for 300 next memo and more yet more again. Can this be done with sqlldr or do I need to load the data as is and use PL/SQL (and cursor loops) to concatentate the data? thanks for any help! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Moving a database to a different machine
I think this will work fine. You could play with doing it with a standby database, the only advantage to that is that you could start the backup and move of files earlier in the process and just keep recovering the archived logs as you ship them across. This has the advantage of giving you time to plan, test and play with starting the standby db. So the steps would be: create the standby database ship archived logs to standby site, recover logs when ready to move over: on production db, force log switch, shutdown, and move the last archived log over on standby machine, recover the last log. Open the database. make the necessary changes to various tnsnames.ora and you are in business Then when you move back to the real production machine, you do the same thing. Rachel From: Steve McClure [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Moving a database to a different machine Date: Thu, 17 May 2001 10:25:34 -0800 Allright, We are physically moving our office, and have an OLTP application that needs to be up and running with minimal downtime. The current plan is to use the development computer as the production platform while the Primary computer is physically moved to the new location. The development system was the production system about 6 months ago, so it will not be under too much strain. I have completely duplicated the filesystems of the Primary machine on the development box. This is my plan. Please comment if there is an obviously better way. Oh the database is version 7.3.4 1.Put the tablespaces of the production database in backup mode. 2.Copy datafiles across the network to the development machine. Approx 3 GB 3.Take the production tablespaces out of backup mode. 4.Force a log switch.(Habit I guess) 5.wait until the production system is brought down. 6.move the control files and redo logs to the development system 7.move the initSID.ora and configSID.ora files. 8.edit configSID.ora to change the host associated to Listener. 9.fire up svrmgrl, and recover the database. 10.change the tnsnames on the client systems to point to the development machine. Of course. This needs to be tested to some degree first. And we(well management at least) don't want to bring the production machine down to roll the databases forward together just for a test. I can use make a backup control file for use during recovery, and move the curently offline redo logs. I am not sure what to do about the most current redo log in this case. I have played with backup and recovery, but not this scenario. I don't currently have my copy of the Velpuri backup and recovery handbook at hand(Loaned it to a colleague). So I am bouncing this off of you folks while I ponder this until I retrieve my backup and recovery bible. Any Comments are appreciated. Thanks, Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Truncate listener.log how?
Hi seema, you can do: echo '' listener.log On Thu, 17 May 2001, Seema Singh wrote: Gurus I want to truncate listener.log file.I am using oracle 8.1.5 and 8.1.7 on solaris 8.Plese suggest.As I understand go to listener.log file directory copy listener.log listener.old tail -10 listener.log Thanks in advance. -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Lucy Lin Oracle DBA condenet.com 212-286-3852 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lucy Lin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 make DBA cannot 'see' User's Tables?
oops! My previous post said that the key must be on 8 byte boundaries. That is incorrect. I believe the data must be on 8 byte boundaries. Guess I should re-read my own article. Jared On Wednesday 16 May 2001 18:30, Ahmadsyah Algozhi Nugroho wrote: I'm using Oracle 8.1.7. there was an error ERROR at line 1: ORA-28232: invalid input length for obfuscation toolkit ORA-06512: at SYS.DBMS_OBFUSCATION_TOOLKIT_FFI, line 0 ORA-06512: at SYS.DBMS_OBFUSCATION_TOOLKIT, line 33 ORA-06512: at SCOTT.IAO_PROTECT, line 15 ORA-06512: at line 1 I check thath my key and my input string is varchar12(10). Key = 0123456789 input string = 'testtestte' dbms_obfuscation_toolkit.desencrypt ( input_string = 'testtestte' , key_string = '1234567890' , encrypted_string = vEncrypted ); Am I forget something? TIA, Ahmadsyah Alghozi Nugroho Database Engineering Specialist PT Infoglobal AutOptima Jl. Baruk Tengah I/49 Surabaya - Jawa Timur phone : +62 (31) 8708456 ext.113 From: Srinagesh Battula [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 7:26 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to make DBA cannot 'see' User's Tables? You can encrypt Decrypt data using the DBMS_OBFUSCATION_TOOLKIT package (comes with 8.1.6) Srinagesh What do I know any way Battula -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to make DBA cannot 'see' User's Tables? Data Encryption? -Original Message- Sent: Wednesday, May 16, 2001 7:01 PM To: Multiple recipients of list ORACLE-L Dear gurus, How to make DBA cannot 'see' user's datas? I build an application which very important and top secret even DBA cannot 'see' this data. But DBA can backup this data.What is the solution for this problem? TIA, Ahmadsyah Alghozi Nugroho Database Engineering Specialist PT Infoglobal AutOptima Jl. Baruk Tengah I/49 Surabaya - Jawa Timur phone : +62 (31) 8708456 ext.113 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srinagesh Battula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: job offer from SAUDI ARABIA
Many professional women in the USA have found it necessary to purchase handguns to protect themselves from criminal elements in public places. Children are constantly under psychological assault being exposed to media violence. The liberal education system is devoted to indoctrinating children with mindless PC relativism, materialism/consumerism and hatred of God (or at least arrogant dismissal). Western freedoms can be seen from a variety of perspectives. Conditions cut both ways - depends on how you see it... Loss of religious, social and cultural freedom against the possibility of earning (and saving because you can't spend) lots of $$. Having said that, as long as you stick to the straight and narrow path (as defined by the Saudi authorities) you will be on the safest place on earth as far as crime goes. (E.g. stealing is punishable by cutting off your arm/fingers!!) ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to make DBA cannot 'see' User's Tables?
The key must be on 8 byte boundaries. See my article on encryption at www.cybcon.com/~jkstill/util Jared On Wednesday 16 May 2001 18:30, Ahmadsyah Algozhi Nugroho wrote: I'm using Oracle 8.1.7. there was an error ERROR at line 1: ORA-28232: invalid input length for obfuscation toolkit ORA-06512: at SYS.DBMS_OBFUSCATION_TOOLKIT_FFI, line 0 ORA-06512: at SYS.DBMS_OBFUSCATION_TOOLKIT, line 33 ORA-06512: at SCOTT.IAO_PROTECT, line 15 ORA-06512: at line 1 I check thath my key and my input string is varchar12(10). Key = 0123456789 input string = 'testtestte' dbms_obfuscation_toolkit.desencrypt ( input_string = 'testtestte' , key_string = '1234567890' , encrypted_string = vEncrypted ); Am I forget something? TIA, Ahmadsyah Alghozi Nugroho Database Engineering Specialist PT Infoglobal AutOptima Jl. Baruk Tengah I/49 Surabaya - Jawa Timur phone : +62 (31) 8708456 ext.113 From: Srinagesh Battula [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 7:26 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to make DBA cannot 'see' User's Tables? You can encrypt Decrypt data using the DBMS_OBFUSCATION_TOOLKIT package (comes with 8.1.6) Srinagesh What do I know any way Battula -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to make DBA cannot 'see' User's Tables? Data Encryption? -Original Message- Sent: Wednesday, May 16, 2001 7:01 PM To: Multiple recipients of list ORACLE-L Dear gurus, How to make DBA cannot 'see' user's datas? I build an application which very important and top secret even DBA cannot 'see' this data. But DBA can backup this data.What is the solution for this problem? TIA, Ahmadsyah Alghozi Nugroho Database Engineering Specialist PT Infoglobal AutOptima Jl. Baruk Tengah I/49 Surabaya - Jawa Timur phone : +62 (31) 8708456 ext.113 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Srinagesh Battula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
....A drop schema script ??
All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I A begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
Re: index FS vs index FFS - what's the difference ?
Re the 'scattered read' for full index scan. This term is counter intuitive at first glance, and is commonly seen on full table scans. It makes sense that it would show up on full index scans as well. Here's an explanation of 'scattered read' found at http://fncduh.fnal.gov/supportdb/working/logbook/db_file_multiblock_read_count.htm The Explain Plan for a given query will reveal if a full table scan will be performed. The BSTAT/ESTAT report lists statistics for multi-block reads as db file scattered read. The term scattered read refers to multiple blocks read into DB block buffers that are scattered throughout memory. High values for db file scattered read is often an indicator of many full table scans being performed. BSTAT/ESTAT is a useful tool in tuning this and other init.ora parameters. Jared On Thursday 17 May 2001 01:40, Shevtsov, Eduard wrote: Hi List, I've made two corresponding dumps and ... I must admit I have much less understanding than I had before. Please look at them. = PARSING IN CURSOR #1 len=68 dep=0 uid=32 oct=3 lid=32 tim=219058914 hv=168660475 ad='aa69f79c' select /*+ INDEX(documents pk_documents) */ count(*) from documents END OF STMT PARSE #1:c=12,e=29,p=27,cr=322,cu=6,mis=1,r=0,dep=0,og=4,tim=219058914 EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=219058914 WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #1: nam='file open' ela= 0 p1=0 p2=0 p3=0 WAIT #1: nam='db file sequential read' ela= 1 p1=22 p2=108810 p3=1 WAIT #1: nam='db file sequential read' ela= 1 p1=22 p2=109485 p3=1 WAIT #1: nam='db file sequential read' ela= 0 p1=22 p2=108811 p3=1 WAIT #1: nam='db file scattered read' ela= 1 p1=22 p2=108812 p3=11 [skip] WAIT #1: nam='db file parallel read' ela= 1 p1=1 p2=11 p3=11 WAIT #1: nam='db file parallel read' ela= 0 p1=1 p2=11 p3=11 [skip] WAIT #1: nam='db file scattered read' ela= 0 p1=22 p2=109472 p3=11 WAIT #1: nam='db file sequential read' ela= 0 p1=22 p2=109483 p3=1 WAIT #1: nam='db file sequential read' ela= 0 p1=22 p2=109486 p3=1 WAIT #1: nam='db file parallel read' ela= 0 p1=1 p2=11 p3=11 = PARSING IN CURSOR #1 len=72 dep=0 uid=32 oct=3 lid=32 tim=219108177 hv=3669603672 ad='aa6a4f84' select /*+ INDEX_FFS(documents pk_documents) */ count(*) from documents END OF STMT PARSE #1:c=11,e=13,p=27,cr=322,cu=6,mis=1,r=0,dep=0,og=4,tim=219108177 EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=219108177 WAIT #1: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #1: nam='file open' ela= 0 p1=0 p2=0 p3=0 WAIT #1: nam='db file sequential read' ela= 1 p1=22 p2=108809 p3=1 WAIT #1: nam='db file scattered read' ela= 2 p1=22 p2=108810 p3=8 WAIT #1: nam='db file scattered read' ela= 0 p1=22 p2=108818 p3=8 [skip, all next lines are the same] My questions are 1. Why I get 'db file scattered read' waits for index full scan ? 2. Why p3 for this event is 11 even though my db_file_multiblock_read_count = 8 ? 3. What does mean 'db file parallel read' event? Anjo Kolk's paper doesn't describe it (guess the wait is Oracle8-specific). Oracle 8i Reference says: blockquote This happens during recovery. Database blocks that need to be changed as part of recovery are read in parallel from the database./blockquote But it seems not my case. 4. Finally, what is the difference between the two index paths in that case ? I'm on 8.1.7.0 Solaris, file-based system, LMT Thanks in advance, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forms and Reports Server versions vs. RDBMS versions
It takes a lot of digging for multiple versions, but on Metalink, under product life cycle there is a certification facility with various levels of drill-down. regards, ep -- Certify - Certification Matrix: Oracle Forms 6i on Microsoft Windows 2000 Client Certifications OS Product Server Status Addtl. Info. Components Other Issues 2000 6.0.8.13, (Patch 4) 8.1.7 (8i) Certified Yes Yes Yes None 2000 6.0.8.13, (Patch 4) 8.1.6 (8i) Certified Yes Yes Yes None 2000 6.0.8.12.1(Patch 3A) 8.1.7 (8i) Certified Yes Yes Yes Yes 2000 6.0.8.12.1(Patch 3A) 8.1.6 (8i) Certified Yes Yes Yes Yes 2000 6.0.8.11.3 (Rel 2) 8.1.7 (8i) Certified Yes Yes None None 2000 6.0.8.11.3 (Rel 2) 8.1.6 (8i) Certified Yes Yes None None Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use. -- Certify - Certification Matrix: Oracle (Web) Application Server on Microsoft Windows 2000 Application Tier Certifications OS Product Server Status Addtl. Info. Components Other Issues 2000 4.0.8.2.1 8.1.6 (8i) Certified None None Yes None Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use. -- On 17 May 2001, at 10:41, Boivin, Patrice J wrote: Date sent: Thu, 17 May 2001 10:41:42 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ... What I want to know is, which versions of OAS , OEM or Developer were designed on concert with which version of the RDBMS. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: ....A drop schema script ??
How about: drop user username cascade; --- Luis DeUrioste [EMAIL PROTECTED] wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I A begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Moving a database to a different machine
Title: RE: Moving a database to a different machine Hi Steve, I used this same strategy with a migration last month. It minimized our database related downtime to 30 minutes (and then they unplugged the symmetrix and the app server was down for 12 hours. Oh well) This plan will work. Once your production machine is physically moved and set up, you can do the reverse to apply changes to the prod database without copying over the entire database from dev: Starting with production database down, the following steps will bring prod up to date: 1. Shutdown dev 2. Copy over control files/redo logs/arc logs 3. Start up prod 4. Initiate recovery Voila. Slick. A word of warning, and you probably already know this: you can't have both databases open at the same time or you will end up with incompatible archive logs and control files. Good luck ! Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- From: Steve McClure [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 2:26 PM To: Multiple recipients of list ORACLE-L Subject: Moving a database to a different machine Allright, We are physically moving our office, and have an OLTP application that needs to be up and running with minimal downtime. The current plan is to use the development computer as the production platform while the Primary computer is physically moved to the new location. The development system was the production system about 6 months ago, so it will not be under too much strain. I have completely duplicated the filesystems of the Primary machine on the development box. This is my plan. Please comment if there is an obviously better way. Oh the database is version 7.3.4 1.Put the tablespaces of the production database in backup mode. 2.Copy datafiles across the network to the development machine. Approx 3 GB 3.Take the production tablespaces out of backup mode. 4.Force a log switch.(Habit I guess) 5.wait until the production system is brought down. 6.move the control files and redo logs to the development system 7.move the initSID.ora and configSID.ora files. 8.edit configSID.ora to change the host associated to Listener. 9.fire up svrmgrl, and recover the database. 10.change the tnsnames on the client systems to point to the development machine. Of course. This needs to be tested to some degree first. And we(well management at least) don't want to bring the production machine down to roll the databases forward together just for a test. I can use make a backup control file for use during recovery, and move the curently offline redo logs. I am not sure what to do about the most current redo log in this case. I have played with backup and recovery, but not this scenario. I don't currently have my copy of the Velpuri backup and recovery handbook at hand(Loaned it to a colleague). So I am bouncing this off of you folks while I ponder this until I retrieve my backup and recovery bible. Any Comments are appreciated. Thanks, Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ....A drop schema script ??
Login in as system: drop user user_name cascade; -Original Message- Sent: Thursday, May 17, 2001 12:26 PM To: Multiple recipients of list ORACLE-L All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I A -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: enqueue waits -- CI
As usual, thanks for the answer Steve. I'll try to reduce the number of shrinks in the rollback segments, so this is going to impact on CI enqueue waits. What do you think about Metalink DOC ID 1020355.102 recomendation? (from my previous email) I've also read a metalink document (1020355.102). According to this, one possible cause is that my application is using ***dbms_pipe*** extensively (it may be right, I've seen pipe get event very high). The suggested solution is to increase the shared_pool. I can't access the other documents mentioned in the paper. Eventtotal_waits time_waited pipe get910593342266184 Thank you. DC - Original Message - To: Diego Cutrone [EMAIL PROTECTED]; Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 1:53 AM Hi Diego, No, those are block buffers. When a segment is dropped, truncated or shrunk (normally a rollback segment) then a reuse block range cross instance call is needed to flush the unwanted blocks from cache. Similarly, before a parallel direct read a checkpoint block range or checkpoint object cross instance call is needed (otherwise changes made prior to the start of the query and committed but not yet flushed to disk could be missed by the direct reads). These are cross-instance calls even in single-instance Oracle because the code allows for the possibility of parallel server, and the DBWn processes in all instance need to flush the cache in their own instances. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- From: Diego Cutrone [mailto:[EMAIL PROTECTED]] Sent: Thursday, 17 May 2001 4:11 To: Multiple recipients of list ORACLE-L Subject: RE: enqueue waits -- CI Thanks for answering Unal, John. John, you were right about the query. I've corrected it. And I'm not getting T[ and CK anymore,now I get TX and CI. I've also done further investigation and I also know now what p2 and p3 mean. This is the updated data: (from the dumps) count TYPE MODE 13 CI 6 p2=0 p3=5 ela=0 19 TX 6 p2=262223 p3=53352 ela=301 75 TX 4 p2=524391 p3=50022 ela=301 75 TX 6 p2=720923 p3=5194 ela=301 104TX 6 p2=196736 p3=52393 ela=301 305TX 6 p2=393276 p3=50281 ela=301 Now, how can I get the rollback segment number involved in the TX ? (I know its from p2 and p3, but how?) --just curious. I'll also take John advise, and I'll try to identify the locking session(s). Now, although CI enqueue waits (cross instance call invocation) are brief on this sample, Sometimes it's not. So I'm trying to understand what it means. According to p2 and p3 flags, they are indicating Flush buffers for reuse as new class, that means that a session needs a buffer (in the shared pool I think) and it has to flush some others in order to get space. am I correct?. I've also read a metalink document (1020355.102). According to this, one possible cause is that my application is using dbms_pipe extensively (it may be right, I've seen event pipe get very high). The suggested solution is to increase the shared_pool. I can't access the other documents mentioned in the paper. Can someone explain to me what means this CI enqueue and how can I reduce it. TIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 6:16 PM Hi Diego, Without going into details, an 'enqueue' wait is mostly due to a user/program initated transaction lock and I see it a lot in Financial databases (I see you are on 10.7?). I deduce you were looking at V$SYSTEM_EVENT - If a user locked one row (probably queried a row in Forms, inadvertly changed one character which issues a 'SELECT for UPDATE, thus locking that row) and anotehr user (through a form or a report) needs to perform DML on that particular row, then (I believe) you will clock up time against the 'enqueue' event. What I would suggest is that you use the following query to determine if someone is locking someone else out: select event, count(*) from v$session_wait group by event If you see the 'enqueue' event in this list, some process is probably waiting on a lock... You can then trace the user/process via Lock detection scripts (see Metablink) and kill the blocking process. You could also query from sys.dba_waiters which will present an easier picture in this case.. As far as the SQL goes, see below: select chr(bitand(p1,-16777216)/16777215)||chr(bitand(p1,16711680)/63365) Lock, - I believe the value is '65535', rather than 63365) to_char(bitand(p1,65535)) Mode
Oracle DBA Needed in Cleveland area..
This Client in the Cleveland Ohio area, is dedicated to creating a work environment enabling ALL employees to contribute and to grow into their fullest potential. They have a full-time staff opportunity available for an Oracle DBA. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. *Responsibilities: The qualified candidate will be responsible for the production support of all Oracle and SQL Server databases in a 7X24 environment. Responsibilities include performance monitoring and tuning, the implementation and support of an effective backup and recovery plan, new object installation and some database design. *Requirements: * 2 years prior experience in an Oracle or SQL Server environment is required. * Desired: * Experience with the Solaris and NT operating system. * Ability to work in a team environment with minimal supervision. * Able to provide support in a 7X24 environment. * Strong organizational skills. * Familiarity with UNIX (SUN Solaris), NT, Novell and MVS operating systems. * Familiarity with relational technology. * Familiarity with midrange DBMS's (Oracle SQL Server). * Familiarity with Network technology. - U.S. Citizenship or permanent residency also required. These positions offer: * Stability * The opportunity to become a key member of the team. * Base salary of 50-75K-D.O.E. NO sub contracting positions available. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] ph: 1-800 -549-8502 Please use job code One/Cleve/DBA/Gayle Candidates who we are interested in will be contacted immediately. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ....A drop schema script ??
Or...may be select 'drop user '||username||' cascade;' from dba_users where username not in ('SYS','SYSTEM'); --and perhaps some other user you'd like to conserve ...and then run the spool. hope it helps DC - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 4:48 PM How about: drop user username cascade; --- Luis DeUrioste [EMAIL PROTECTED] wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I A begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: job offer from SAUDI ARABIA
Title: RE: job offer from SAUDI ARABIA God I live in an awful country. I'm sorry for all the tyranny my country has put the world through. I guess I'll just shoot myself. Seriously. I encourage the individual that is looking at working in Saudi Arabia to do so if that is the experiences he wishes to have. I am the first to scream from the highest mountain all the things that are wrong with America, and if it's okay with you, what is right with America. The point being that in America, I CAN if I want to. Have a nice day and I hope you enjoy your move to Saudi Arabia. -Original Message- From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 12:07 PM To: Multiple recipients of list ORACLE-L Subject: Re: job offer from SAUDI ARABIA Many professional women in the USA have found it necessary to purchase handguns to protect themselves from criminal elements in public places. Children are constantly under psychological assault being exposed to media violence. The liberal education system is devoted to indoctrinating children with mindless PC relativism, materialism/consumerism and hatred of God (or at least arrogant dismissal). Western freedoms can be seen from a variety of perspectives. Conditions cut both ways - depends on how you see it... Loss of religious, social and cultural freedom against the possibility of earning (and saving because you can't spend) lots of $$. Having said that, as long as you stick to the straight and narrow path (as defined by the Saudi authorities) you will be on the safest place on earth as far as crime goes. (E.g. stealing is punishable by cutting off your arm/fingers!!) ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Another big bang for Larry
From InformationWeek: ** Oracle Hooks NATO On 11i The North Atlantic Treaty Organization has begun implementing Oracle's 11i E-business software in its 19 regional headquarters. NATO program director David Oakley says NATO's new Automated Financial System will incorporate Oracle's enterprise resource planning and E-business software to manage a range of operations, including budgeting, travel, treasury, disbursement, procurement, and supply functions. NATO also will use Oracle's business-analysis and reporting tools. Oracle will provide training for an estimated 700 NATO personnel. Oakley says NATO's initiative is designed to let the organization adopt international public-sector accounting standards and have access to more meaningful and timely information about its own operations. The new system is expected to reduce the number of paper documents that must be handled by NATO personnel, such as requisitions and travel requests, and let the alliance use financial forecasting tools that Oakley says will help it use funds more efficiently. The value of the deal, and its deployment schedule, weren't released. - Steve Konicki Check out these related stories: Will Oracle Finally Deliver With Release Of 11.5.3? http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2Q0AC Apps Made Easy? http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20Niw0Aj The Big Picture: The Encryption Enigma http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2R0AD -- 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).
OT: RE: job offer from SAUDI ARABIA
rant on ep, Any idiot can see we're the freest country in the world! Free to do what is expected, or get thrown in jail at a rate exceeding most other civilized nations. Free to subsidize tobacco and alcohol (and related deaths) and throw dangerous criminals in jail for using cannabis. Free to have almost the highest teenage pregnancy rate in the world. Free to fight for your rights just as long as your money lasts! Free to buy as much of whatever you want until the money, environment, or patience of the less fortunate runs out. So much freedom, you could almost choke on it. Come on, you commie, admit it: you just stay here for the Burgers and Coca-Cola! You have no chance to survive make your time rm p.s. If you want to reach me, I'll be in the prayer meeting John Ashcroft, the Attorney General, now holds each morning inside the Department of Justice. rant off || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 17, 2001 3:07 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: job offer from SAUDI ARABIA || || || Many professional women in the USA have found it necessary to || purchase handguns to protect themselves from criminal elements in || public places. Children are constantly under psychological assault || being exposed to media violence. The liberal education system is || devoted to indoctrinating children with mindless PC relativism, || materialism/consumerism and hatred of God (or at least arrogant || dismissal). || || Western freedoms can be seen from a variety of perspectives. || || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Script that will remove redundant rows from table
GROAN From: Eric D. Pierce [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Script that will remove redundant rows from table Date: Thu, 17 May 2001 10:50:39 -0800 Mr. Rhet Device (rhet oracle device, that is) On 17 May 2001, at 8:21, Alan Aschenbrenner wrote: Who was the half person? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ....A drop schema script ??
uhhh DUHHH ! I could write the algorithm to solve the logarithm .. IF I ONLY HAD A BRAIN .. Thank you to all of you, and special thanks for not bashing me Luis Octavio Luis DeUrioste wrote: All mighty and powerful DBA supremes ! Do any of you have a drop schema script that would be willing to share ?? It'll be greatly appreciated T I A begin:vcard n:de Urioste;Luis Octavio tel;fax:850.455.0673 tel;work:850.457.3218 x-mozilla-html:FALSE org:Raytheon Aerospace;IT version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Analyst adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A. fn:Luis Octavio de Urioste end:vcard
View v_$session
Hi guys! Since the upgrade of my Oracle server to the version 8.1.6 (I applied all the patches) and the rebuild of the clients applications with the libraries from the same version, the column PROGRAM of the view v_$session is empty. If the application is using the old libs, the program apears in the view. Does anybody know the solution? What to do to see the program that is running? I thank in advance!!! --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- Gilberto Gampert Universidade de Passo Fundo Administrador de Banco de Dados Passo Fundo - RS - Brazil [EMAIL PROTECTED] http://www.upf.tche.br --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilberto Gampert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: RE: job offer from SAUDI ARABIA
And freedom to leave the country any time you wish. Have a nice flight. --- Mohan, Ross [EMAIL PROTECTED] wrote: rant on ep, Any idiot can see we're the freest country in the world! Free to do what is expected, or get thrown in jail at a rate exceeding most other civilized nations. Free to subsidize tobacco and alcohol (and related deaths) and throw dangerous criminals in jail for using cannabis. Free to have almost the highest teenage pregnancy rate in the world. Free to fight for your rights just as long as your money lasts! Free to buy as much of whatever you want until the money, environment, or patience of the less fortunate runs out. So much freedom, you could almost choke on it. Come on, you commie, admit it: you just stay here for the Burgers and Coca-Cola! You have no chance to survive make your time rm p.s. If you want to reach me, I'll be in the prayer meeting John Ashcroft, the Attorney General, now holds each morning inside the Department of Justice. rant off || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 17, 2001 3:07 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: job offer from SAUDI ARABIA || || || Many professional women in the USA have found it necessary to || purchase handguns to protect themselves from criminal elements in || public places. Children are constantly under psychological assault || being exposed to media violence. The liberal education system is || devoted to indoctrinating children with mindless PC relativism, || materialism/consumerism and hatred of God (or at least arrogant || dismissal). || || Western freedoms can be seen from a variety of perspectives. || || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT RE: job offer from SAUDI ARABIA
Brian of MacLean, I guess that's a good way of putting it, too. Sometimes I like to rant about ( i.e. for ) Amerikkka, but that's usually when she's under attack, in a way that is perceived by me as being unfair or misinformed. - Ross -Original Message- Sent: Thursday, May 17, 2001 4:17 PM To: Multiple recipients of list ORACLE-L God I live in an awful country. I'm sorry for all the tyranny my country has put the world through. I guess I'll just shoot myself. Seriously. I encourage the individual that is looking at working in Saudi Arabia to do so if that is the experiences he wishes to have. I am the first to scream from the highest mountain all the things that are wrong with America, and if it's okay with you, what is right with America. The point being that in America, I CAN if I want to. Have a nice day and I hope you enjoy your move to Saudi Arabia. -Original Message- Sent: Thursday, May 17, 2001 12:07 PM To: Multiple recipients of list ORACLE-L Many professional women in the USA have found it necessary to purchase handguns to protect themselves from criminal elements in public places. Children are constantly under psychological assault being exposed to media violence. The liberal education system is devoted to indoctrinating children with mindless PC relativism, materialism/consumerism and hatred of God (or at least arrogant dismissal). Western freedoms can be seen from a variety of perspectives. Conditions cut both ways - depends on how you see it... Loss of religious, social and cultural freedom against the possibility of earning (and saving because you can't spend) lots of $$. Having said that, as long as you stick to the straight and narrow path (as defined by the Saudi authorities) you will be on the safest place on earth as far as crime goes. (E.g. stealing is punishable by cutting off your arm/fingers!!) ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Moving a database to a different machine
Koivu, Lisa said A word of warning, and you probably already know this: you can't have both databases open at the same time or you will end up with incompatible archive logs and control files. Good luck ! hehe I did know, but upon reading your warning it still frightened me for a moment. Because I was planning to do this one time prior to the move to allow for testing. Therefore having both databases up and running at the same time on the two different machines. I know I will have to do the migration again when we actually move, so that the database(s) will recover properly. Oh and thanks for the tip about just moving the arc/redo/control files back to the production machine to resynch the DBs. That will save me from some tedium on moving day. Steve McClure -Original Message- Sent: Thursday, May 17, 2001 11:47 AM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Hi Steve, I used this same strategy with a migration last month. It minimized our database related downtime to 30 minutes (and then they unplugged the symmetrix and the app server was down for 12 hours. Oh well) This plan will work. Once your production machine is physically moved and set up, you can do the reverse to apply changes to the prod database without copying over the entire database from dev: Starting with production database down, the following steps will bring prod up to date: 1. Shutdown dev 2. Copy over control files/redo logs/arc logs 3. Start up prod 4. Initiate recovery Voila. Slick. A word of warning, and you probably already know this: you can't have both databases open at the same time or you will end up with incompatible archive logs and control files. Good luck ! Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- Sent: Thursday, May 17, 2001 2:26 PM To: Multiple recipients of list ORACLE-L Allright, We are physically moving our office, and have an OLTP application that needs to be up and running with minimal downtime. The current plan is to use the development computer as the production platform while the Primary computer is physically moved to the new location. The development system was the production system about 6 months ago, so it will not be under too much strain. I have completely duplicated the filesystems of the Primary machine on the development box. This is my plan. Please comment if there is an obviously better way. Oh the database is version 7.3.4 1.Put the tablespaces of the production database in backup mode. 2.Copy datafiles across the network to the development machine. Approx 3 GB 3.Take the production tablespaces out of backup mode. 4.Force a log switch.(Habit I guess) 5.wait until the production system is brought down. 6.move the control files and redo logs to the development system 7.move the initSID.ora and configSID.ora files. 8.edit configSID.ora to change the host associated to Listener. 9.fire up svrmgrl, and recover the database. 10.change the tnsnames on the client systems to point to the development machine. Of course. This needs to be tested to some degree first. And we(well management at least) don't want to bring the production machine down to roll the databases forward together just for a test. I can use make a backup control file for use during recovery, and move the curently offline redo logs. I am not sure what to do about the most current redo log in this case. I have played with backup and recovery, but not this scenario. I don't currently have my copy of the Velpuri backup and recovery handbook at hand(Loaned it to a colleague). So I am bouncing this off of you folks while I ponder this until I retrieve my backup and recovery bible. Any Comments are appreciated. Thanks, Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
RE: RE: job offer from SAUDI ARABIA
WOW!! I need to pay more attantion, what the hay is going on here? -Original Message- Sent: Thursday, May 17, 2001 4:14 PM To: Multiple recipients of list ORACLE-L rant on ep, Any idiot can see we're the freest country in the world! Free to do what is expected, or get thrown in jail at a rate exceeding most other civilized nations. Free to subsidize tobacco and alcohol (and related deaths) and throw dangerous criminals in jail for using cannabis. Free to have almost the highest teenage pregnancy rate in the world. Free to fight for your rights just as long as your money lasts! Free to buy as much of whatever you want until the money, environment, or patience of the less fortunate runs out. So much freedom, you could almost choke on it. Come on, you commie, admit it: you just stay here for the Burgers and Coca-Cola! You have no chance to survive make your time rm p.s. If you want to reach me, I'll be in the prayer meeting John Ashcroft, the Attorney General, now holds each morning inside the Department of Justice. rant off || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 17, 2001 3:07 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: job offer from SAUDI ARABIA || || || Many professional women in the USA have found it necessary to || purchase handguns to protect themselves from criminal elements in || public places. Children are constantly under psychological assault || being exposed to media violence. The liberal education system is || devoted to indoctrinating children with mindless PC relativism, || materialism/consumerism and hatred of God (or at least arrogant || dismissal). || || Western freedoms can be seen from a variety of perspectives. || || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Another big bang for Larry
It's started. After slick willy was invited to speak the kickbacks are showing up. Oracle will be running the Government. Slick move... you don't dare bust up the monopoly that is running the Governmential department's programs. Will the NEW controling body be called the GOVERACLEMENT??? ROR mô¿ôm [EMAIL PROTECTED] 05/17/01 04:08PM From InformationWeek: ** Oracle Hooks NATO On 11i The North Atlantic Treaty Organization has begun implementing Oracle's 11i E-business software in its 19 regional headquarters. NATO program director David Oakley says NATO's new Automated Financial System will incorporate Oracle's enterprise resource planning and E-business software to manage a range of operations, including budgeting, travel, treasury, disbursement, procurement, and supply functions. NATO also will use Oracle's business-analysis and reporting tools. Oracle will provide training for an estimated 700 NATO personnel. Oakley says NATO's initiative is designed to let the organization adopt international public-sector accounting standards and have access to more meaningful and timely information about its own operations. The new system is expected to reduce the number of paper documents that must be handled by NATO personnel, such as requisitions and travel requests, and let the alliance use financial forecasting tools that Oakley says will help it use funds more efficiently. The value of the deal, and its deployment schedule, weren't released. - Steve Konicki Check out these related stories: Will Oracle Finally Deliver With Release Of 11.5.3? http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2Q0AC Apps Made Easy? http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20Niw0Aj The Big Picture: The Encryption Enigma http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2R0AD -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another big bang for Larry
Don't I feel silly! I didn't even know that 9i was out yet, much less 10i or 11i! I guess I don't dare blink. DM -Original Message- [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 1:09 PM To: Multiple recipients of list ORACLE-L From InformationWeek: ** Oracle Hooks NATO On 11i The North Atlantic Treaty Organization has begun implementing Oracle's 11i E-business software in its 19 regional headquarters. NATO program director David Oakley says NATO's new Automated Financial System will incorporate Oracle's enterprise resource planning and E-business software to manage a range of operations, including budgeting, travel, treasury, disbursement, procurement, and supply functions. NATO also will use Oracle's business-analysis and reporting tools. Oracle will provide training for an estimated 700 NATO personnel. Oakley says NATO's initiative is designed to let the organization adopt international public-sector accounting standards and have access to more meaningful and timely information about its own operations. The new system is expected to reduce the number of paper documents that must be handled by NATO personnel, such as requisitions and travel requests, and let the alliance use financial forecasting tools that Oakley says will help it use funds more efficiently. The value of the deal, and its deployment schedule, weren't released. - Steve Konicki Check out these related stories: Will Oracle Finally Deliver With Release Of 11.5.3? http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2Q0AC Apps Made Easy? http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20Niw0Aj The Big Picture: The Encryption Enigma http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2R0AD -- 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: David Messer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: job offer from SAUDI ARABIA
Only in America, can you rant! Try to criticize China while living there. I have a friend there, her mail is read before she gets it. All she can write is general stuff, nothing negative, fearful of her life. The best thing about America is that you can b*tch if you want. I served for this country and love this country. *GO USA* Not that there are not other great countries! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: RE: job offer from SAUDI ARABIA
Not sorry if I touched a nerve, Rocky. That's what it's all about. It's democracy, suck it up, or spit it out. || -Original Message- || From: Rocky Welch [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 17, 2001 4:36 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: OT: RE: job offer from SAUDI ARABIA || || || And freedom to leave the country any time you wish. Have a || nice flight. || || --- Mohan, Ross [EMAIL PROTECTED] wrote: || rant on || || ep, || || Any idiot can see we're the freest country in the world! || Free to do what is expected, or get thrown in jail at a || rate exceeding most other civilized nations. Free to || subsidize tobacco and alcohol (and related deaths) and || throw dangerous criminals in jail for using cannabis. || Free to have almost the highest teenage pregnancy rate || in the world. Free to fight for your rights just as long || as your money lasts! Free to buy as much of whatever you || want until the money, environment, or patience of the || less fortunate runs out. || || So much freedom, you could almost choke on it. || || Come on, you commie, admit it: you just stay here for || the Burgers and Coca-Cola! || || You have no chance to survive make your time || || rm || || p.s. If you want to reach me, I'll be in the prayer meeting || John Ashcroft, the Attorney General, now holds each morning || inside the Department of Justice. || || rant off || || || -Original Message- || || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || || Sent: Thursday, May 17, 2001 3:07 PM || || To: Multiple recipients of list ORACLE-L || || Subject: Re: job offer from SAUDI ARABIA || || || || || || Many professional women in the USA have found it necessary to || || purchase handguns to protect themselves from criminal || elements in || || public places. Children are constantly under || psychological assault || || being exposed to media violence. The liberal || education system is || || devoted to indoctrinating children with mindless PC || relativism, || || materialism/consumerism and hatred of God (or at least arrogant || || dismissal). || || || || Western freedoms can be seen from a variety of perspectives. || || || || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Mohan, Ross ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like || subscribing). || || || __ || Do You Yahoo!? || Yahoo! Auctions - buy the things you want at great prices || http://auctions.yahoo.com/ || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Rocky Welch || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another big bang for Larry
Well...technically it's not out yet. Like alot of list member's, I got my copies about a month ago in the mail, and the general availability (GA) date is June 10th ( I think..I could be confusing that with IBM's next release ). I wouldn't feel silly. A bunch of us around here in this shop are still getting familiar with new features in 8i. || -Original Message- || From: David Messer [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 17, 2001 4:56 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Another big bang for Larry || || || Don't I feel silly! I didn't even know that 9i was out yet, || much less 10i || or 11i! I guess I don't dare blink. || || DM || || -Original Message- || [EMAIL PROTECTED] || Sent: Thursday, May 17, 2001 1:09 PM || To: Multiple recipients of list ORACLE-L || || || From InformationWeek: || || ** Oracle Hooks NATO On 11i || || The North Atlantic Treaty Organization has begun implementing || Oracle's 11i E-business software in its 19 regional headquarters. || || NATO program director David Oakley says NATO's new Automated || Financial System will incorporate Oracle's enterprise resource || planning and E-business software to manage a range of operations, || including budgeting, travel, treasury, disbursement, procurement, || and supply functions. NATO also will use Oracle's || business-analysis and reporting tools. || || Oracle will provide training for an estimated 700 NATO personnel. || Oakley says NATO's initiative is designed to let the organization || adopt international public-sector accounting standards and have || access to more meaningful and timely information about its own || operations. || || The new system is expected to reduce the number of paper || documents that must be handled by NATO personnel, such as || requisitions and travel requests, and let the alliance use || financial forecasting tools that Oakley says will help it use || funds more efficiently. The value of the deal, and its deployment || schedule, weren't released. - Steve Konicki || || Check out these related stories: || || Will Oracle Finally Deliver With Release Of 11.5.3? || http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2Q0AC || || Apps Made Easy? || http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20Niw0Aj || || The Big Picture: The Encryption Enigma || http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2R0AD || -- || 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: David Messer || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Another big bang for Larry
Actually NATO has been using Oracle's RDBMS product for years. Original Message On 5/17/01, 4:01:34 PM, Ron Rogers [EMAIL PROTECTED] wrote regarding Re: Another big bang for Larry: It's started. After slick willy was invited to speak the kickbacks are showing up. Oracle will be running the Government. Slick move... you don't dare bust up the monopoly that is running the Governmential department's programs. Will the NEW controling body be called the GOVERACLEMENT??? ROR mô¿ôm [EMAIL PROTECTED] 05/17/01 04:08PM From InformationWeek: ** Oracle Hooks NATO On 11i The North Atlantic Treaty Organization has begun implementing Oracle's 11i E-business software in its 19 regional headquarters. NATO program director David Oakley says NATO's new Automated Financial System will incorporate Oracle's enterprise resource planning and E-business software to manage a range of operations, including budgeting, travel, treasury, disbursement, procurement, and supply functions. NATO also will use Oracle's business-analysis and reporting tools. Oracle will provide training for an estimated 700 NATO personnel. Oakley says NATO's initiative is designed to let the organization adopt international public-sector accounting standards and have access to more meaningful and timely information about its own operations. The new system is expected to reduce the number of paper documents that must be handled by NATO personnel, such as requisitions and travel requests, and let the alliance use financial forecasting tools that Oakley says will help it use funds more efficiently. The value of the deal, and its deployment schedule, weren't released. - Steve Konicki Check out these related stories: Will Oracle Finally Deliver With Release Of 11.5.3? http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2Q0AC Apps Made Easy? http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20Niw0Aj The Big Picture: The Encryption Enigma http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2R0AD -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another big bang for Larry
I think it is Oracle Applications ver 11i and not an Oracle server release. -Original Message- Sent: Thursday, May 17, 2001 4:09 PM To: Multiple recipients of list ORACLE-L From InformationWeek: ** Oracle Hooks NATO On 11i The North Atlantic Treaty Organization has begun implementing Oracle's 11i E-business software in its 19 regional headquarters. NATO program director David Oakley says NATO's new Automated Financial System will incorporate Oracle's enterprise resource planning and E-business software to manage a range of operations, including budgeting, travel, treasury, disbursement, procurement, and supply functions. NATO also will use Oracle's business-analysis and reporting tools. Oracle will provide training for an estimated 700 NATO personnel. Oakley says NATO's initiative is designed to let the organization adopt international public-sector accounting standards and have access to more meaningful and timely information about its own operations. The new system is expected to reduce the number of paper documents that must be handled by NATO personnel, such as requisitions and travel requests, and let the alliance use financial forecasting tools that Oakley says will help it use funds more efficiently. The value of the deal, and its deployment schedule, weren't released. - Steve Konicki Check out these related stories: Will Oracle Finally Deliver With Release Of 11.5.3? http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2Q0AC Apps Made Easy? http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20Niw0Aj The Big Picture: The Encryption Enigma http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2R0AD -- 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: Suri, Deepak INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT RE: job offer from SAUDI ARABIA
Gene, Being part of a nation with people (such as yourself) who have a willingness to let other's have their opinions -- some of who are a part of the military force that defends that right -- is why all my tickets out of town are always marked round trip. Above all, thanks for your service. - Ross || -Original Message- || From: Gene Sais [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 17, 2001 4:52 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: job offer from SAUDI ARABIA || || || Only in America, can you rant! Try to criticize China while || living there. I have a friend there, her mail is read || before she gets it. All she can write is general stuff, || nothing negative, fearful of her life. The best thing about || America is that you can b*tch if you want. I served for || this country and love this country. *GO USA* || || Not that there are not other great countries! || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Gene Sais || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
data migration
Hi, We are planning to do two-phase data migration - split by data. In first phase, about 10% of the data will be moved as is - without changing the primary keys (generated from sequences). Once we start using the database with phase 1 data, sequences will generate new primary keys and add to this data - which could be same as primary key for the remaining data, which is not yet migrated. In phase 2, to avoid unique constraint problems, we'll add 1,000,000 to primary keys before we migrate remaining data. This will lead to imbalance of primary keys. After complete migration, we'll have about 10% of the keys with low values and remaining with very high values. What is the impact of this huge gap in primary keys? How will be the performance affected? Is there a way in which we can avoid this huge gap in primary keys (We do not have an option of going for single migration. Business needs force us to test the application with partial data. ) One option I thought of is to use high value keys in first migration itself - but when sequences reach these high values, we'll have same problems of unique constraint being violated. Thanks. - Praful __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Praful Thakkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 big bang for Larry
E-Business is the new term for Oracle Applications, and yes, 11i has been out awhile, running against an 8i database. It's a full time job just keeping up with Oracle's naming convention! Linda -Original Message- Sent: Thursday, May 17, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Don't I feel silly! I didn't even know that 9i was out yet, much less 10i or 11i! I guess I don't dare blink. DM -Original Message- [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 1:09 PM To: Multiple recipients of list ORACLE-L From InformationWeek: ** Oracle Hooks NATO On 11i The North Atlantic Treaty Organization has begun implementing Oracle's 11i E-business software in its 19 regional headquarters. NATO program director David Oakley says NATO's new Automated Financial System will incorporate Oracle's enterprise resource planning and E-business software to manage a range of operations, including budgeting, travel, treasury, disbursement, procurement, and supply functions. NATO also will use Oracle's business-analysis and reporting tools. Oracle will provide training for an estimated 700 NATO personnel. Oakley says NATO's initiative is designed to let the organization adopt international public-sector accounting standards and have access to more meaningful and timely information about its own operations. The new system is expected to reduce the number of paper documents that must be handled by NATO personnel, such as requisitions and travel requests, and let the alliance use financial forecasting tools that Oakley says will help it use funds more efficiently. The value of the deal, and its deployment schedule, weren't released. - Steve Konicki Check out these related stories: Will Oracle Finally Deliver With Release Of 11.5.3? http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2Q0AC Apps Made Easy? http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20Niw0Aj The Big Picture: The Encryption Enigma http://update.informationweek.com/cgi-bin4/flo?y=eDis0BdFGA0V20N2R0AD -- 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: David Messer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seley, Linda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: data migration
Praful, This is a bit of a shot from the hip, but. the gap shouldn't make much of a difference in the end. I'd be more concerned about allocating space for all your stuff initially, not just the first 10%. The gaps should be handled seamlessly by indexes (the way a b*tree works...) and anything that seems to act much differently you can always do select activation of histograms to account for data skew if you come to think that's a problem. (You *are* in cost-mode, yes?) Of course, there's always the design solution. Put another field in there that tells the app whether it's phase I or phase II data. Then you could overlap primary keys, which from your description i gather are sequence-based. (But i think that's weird and sloppy somehow, and I wouldn't do it.) hth, - Ross || -Original Message- || From: Praful Thakkar [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 17, 2001 5:46 PM || To: Multiple recipients of list ORACLE-L || Subject: data migration || || || Hi, || || We are planning to do two-phase data migration - split by data. || In first phase, about 10% of the data will be moved as is - || without changing the primary keys (generated from sequences). || Once we start using the database with phase 1 data, sequences || will generate new primary keys and add to this data - which || could be same as primary key for the remaining data, which is || not yet migrated. In phase 2, to avoid unique constraint || problems, we'll add 1,000,000 to primary keys before we migrate || remaining data. This will lead to imbalance of primary keys. || After complete migration, we'll have about 10% of the keys with || low values and remaining with very high values. What is the || impact of this huge gap in primary keys? How will be the || performance affected? Is there a way in which we can avoid this || huge gap in primary keys (We do not have an option of going for || single migration. Business needs force us to test the || application with partial data. ) One option I thought of is to || use high value keys in first migration itself - but when || sequences reach these high values, we'll have same problems of || unique constraint being violated. || || Thanks. || || - Praful || || || __ || Do You Yahoo!? || Yahoo! Auctions - buy the things you want at great prices || http://auctions.yahoo.com/ || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Praful Thakkar || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: index FS vs index FFS - what's the difference ?
Hi Riyaj, Thanks for your response. Very interesting! I completely agree with you about index fast full scan. But I'm still unclear about index full scan. I've always thought that this operation is serviced with 1-block reads. So it would bepossible to go through 2-way list of leaf blocks.And if my memory services me right the docs say the same about 1-block reads for IFS. But dump file shows db scattered reads. I don't think that 11 blocks per read is due passing the extent boundaries The LMTablespace has big extents (50Mb) andall such events have the same p3 = 11 in the trace file. Certainly I should have given you much more info. I hadrestarted DB (shutdown immediately)before I got each tracefile. I just did it in order to clean db cache and catch 'db file %' waits during the following index scan. So I did clean shutdown.I checked eachexecution plan.Also it's unlikely that someone modified this index at that time. I may be totally wrong here. Just my thoughts. Thanks again I took your tips and will go into detail tomorrow. Ed Hi Ed I think, For full index scan, oracle server process reads the root block and branch blocks 1 block at a time. It reads the leaf blocks at a db file multiblock -read count blocks per read call. For the fast full scan, it reads all the block from the segment header to high water mark at a db_file_multiblock_read count blocks per read call. So, root blocks and branch blocks are read 1 block at a time, hence the db file sequential read. Where as for the fast full index scan you will see sequential read events only for the root block. Also, for the full index scan apparently knows about the extent boundary and if the next group of blocks to be read (in the current extent) is less than the db file multiblock read count , then it tries to read until the end of the current extent. That's why 11 blocks instead of 8 blocks. For the 'db file parallel read' the segment read are file 1 block 11, which is a system rollback segment extent. If you dump the block, you could see the redo for index leaf operations. I guess, this is due to delayed instance recovery. All these, I found from dumping blocks and doing research myself. Steve, Can you please clarify ? ThanksRiyaj "Re-yas" ShamsudeenCertified Oracle DBAi2 technologies www.i2.com
RE: job offer from SAUDI ARABIA
Um, I can critize Canada all I want. Matter of fact, its kind of a requirement. So your first sentence is wrong. I asked one of the guys I work with here if he drinks a lot when he goes out and he said Well, not for a Canadian. He is Canadian. (As am I) -Original Message- Sent: Thursday, May 17, 2001 1:52 PM To: Multiple recipients of list ORACLE-L Only in America, can you rant! Try to criticize China while living there. I have a friend there, her mail is read before she gets it. All she can write is general stuff, nothing negative, fearful of her life. The best thing about America is that you can b*tch if you want. I served for this country and love this country. *GO USA* Not that there are not other great countries! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).