Re: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
Probably your clients or the users have in their sqlnet.ora the parameter use_dedicated_server=TRUE or in the entry of the tnsnames.ora a clause like (SERVER=DEDICATED). Also issue an netstat to see if everything is alright. If you find any problem with the ports of the dispatchers, try forcing them in the parameter mts_dispatcher. Regards. --- Harvinder Singh [EMAIL PROTECTED] wrote: Hi, I have configured the server to use MTS and still dedicated connections r used. What might be the reasondatabase is 8.1.6.3.4 LSNRCTL services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) ora2000 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DEDICATED SERVER established:76 refused:0 LOCAL SERVER The command completed successfully init.ora looks like: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: constraint naming
That's precisely the point - we have a bunch of system-generated names that we'd like to change to meaningful names... g -Original Message- Sent: Tuesday, July 24, 2001 2:32 PM To: Multiple recipients of list ORACLE-L g, Why use system generated FK names. does SYS12345 maen any thing to you? We always generate our FK with an ALTER TABLE command and name the FK with something that can be recognized. Very usefull when you have to drop the FK to accomplish an import of data. ROR mª¿ªm [EMAIL PROTECTED] 07/24/01 05:21AM O Wise and Powerful Oracle: Is there a way to change thy system-generated names for foreign key constraints to something sensible without invoking Deep Magic? g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile: +44 (0) 7966 164687 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
4 drives, 2 controller ( 3 drives on the SAME controller !)
list, in my rs/6000, i found the following... # lsdev -Cc adapter ascsi0 Available 00-06Wide SCSI I/O Controller Adapter ascsi1 Available 00-07Wide SCSI I/O Controller Adapter # lsdev -Cc disk hdisk0 Available 00-06-B1-2,0 16 Bit SCSI Disk Drive hdisk1 Available 00-07-A1-3,0 16 Bit SCSI Disk Drive hdisk2 Available 00-07-A1-4,0 16 Bit SCSI Disk Drive hdisk3 Available 00-07-A1-5,0 16 Bit SCSI Disk Drive from the above i can conclude that adapter 06 is controlling hdisk0 and adapter 07 is controlling the other 3 drives.. if the above deduction is correct , then all the three drives are sharing the same IO channel , right ? what kind of effort is required to ammend the above config ? ( TWO drives on ONE controller ) Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Starting Oracle services remotely (Win2K)
Mark, RCMD from the Resource Kit for NT4, and presumably for W2K, might provide a solution. I have not used it myself so can't comment on it's operation etc. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King From: Mark Leith [EMAIL PROTECTED] Date: Tue, 24 Jul 2001 10:57:04 +0100 Subject: Starting Oracle services remotely (Win2K). Hi all, Has anybody come across a way of starting the Oracle services (or indeed any service) on a Win2K box remotely from another Win2K machine? I would be interested in your insight if you have.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
latch free waits on LIBRARY CACHE latch and bind variables
Can someone please explain how to monitor latch free waits on LIBRARY cache and provide examples of using bind variables. THE PL/SQL reference does not seem to make much reference to bind varaiables John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
statement for directory objects
Hello List, I would like to know any statement to know which 'object directory' exists in the oracle instance, for a specified user. TIA, begin:vcard n:Jimenez;Beatriz Martinez x-mozilla-html:FALSE org:Fundación CIDAUT;Departamento de Informática adr:;;Parque Tecnológico de Boecillo p.209;Boecillo;Valladolid;47151;Spain version:2.1 email;internet:[EMAIL PROTECTED] title:Ingeniera Informática fn:Beatriz Martínez Jiménez end:vcard
Capacity of LONG datatype
How many Characters(Alphanumeric) can be inserted into a Field of Datatype LONG ? Why ? -- 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).
OT: Micsoft Technically Correct
A helicopter was flying around above Seattle when an electrical malfunction disabled all of the aircraft's electronic navigation and communications equipment. Due to the clouds and haze, the pilot could not determine the helicopter's position. The pilot saw a tall building, flew toward it, circled, and held up a handwritten sign that said 'WHERE AM I?' in large letters. People in the tall building quickly responded to the aircraft, drew a large sign, and held it in a building window. Their sign said 'YOU ARE IN A HELICOPTER.' The pilot smiled, waved, looked at his map, determined the course to steer to SEATAC airport, and landed safely. After they were on the ground, the copilot asked the pilot how he had done it. I knew it had to be the Microsoft Building, because they gave me a technically correct but completely useless answer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
urgent..! ANSI Standard SQL for Outer Join (ORACLE SQL SERVER)
Dear All, Can anyone of you help me for the following. I want to give a generalized SQL syntax for Outer Join for both oracle SQL server. Can I use ANSI Syntax say for example select empno, ename from emp join dept on emp.deptno = dept.deptno (Something like this) Bye Sundar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
severe lib cache contention !!
list, i just ported a system to 8.1.5, the application DOES NOT make use of bind variables, each and every query (fired from 8 clients every 2-3 seconds) parses and executes, this keeps the shared pool patch also very busy... i cannot tune the app, is there something i can do to reduce the lib cache and shared pool latch contention ?? v$session_wait show all sessions waiting on latch free the sleeps in lib cache latch are not properly spread out also... SQL select * from v$latch_children where latch#=99 order by 8 CHILD#GETSMISSESSLEEPS -- 1 209093 149 117 5 283185 602 221 6 304797 616 264 7 583061 3354 1417 4 2697205191099 33858 211636488 8683396980522 360982875 47012872 8777649 Interestingly, the same app was NOT showing any contention on these latches in 7.3.2 !! how can i solve this problem ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 4 drives, 2 controller ( 3 drives on the SAME controller
Rahul You may need to rebuild the system completely depending on what is currently on those disks. On the other hand if you are using something similar to the HP Logical Volume Manger then you may be able to drop that volume out with out deleting the contents and when you reboot the system and run the tool it will recognize that there is a valid filesystem on that disk and simply create the necessary files and make the data available. HTH Peter At 06:45 PM 25/07/2001, you wrote: list, in my rs/6000, i found the following... # lsdev -Cc adapter ascsi0 Available 00-06Wide SCSI I/O Controller Adapter ascsi1 Available 00-07Wide SCSI I/O Controller Adapter # lsdev -Cc disk hdisk0 Available 00-06-B1-2,0 16 Bit SCSI Disk Drive hdisk1 Available 00-07-A1-3,0 16 Bit SCSI Disk Drive hdisk2 Available 00-07-A1-4,0 16 Bit SCSI Disk Drive hdisk3 Available 00-07-A1-5,0 16 Bit SCSI Disk Drive from the above i can conclude that adapter 06 is controlling hdisk0 and adapter 07 is controlling the other 3 drives.. if the above deduction is correct , then all the three drives are sharing the same IO channel , right ? what kind of effort is required to ammend the above config ? ( TWO drives on ONE controller ) Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter McLarty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Capacity of LONG datatype
Character data of variable length up to 2 gig. The length of LONG datatype values may be limited by the memory available on your computer. Dave -Original Message- Sent: Wednesday, July 25, 2001 6:56 AM To: Multiple recipients of list ORACLE-L How many Characters(Alphanumeric) can be inserted into a Field of Datatype LONG ? Why ? -- 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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: waits on sequential scans - how did i solve it
Jack, I was going to suggest, what you did, but then I noticed the version Rahul was using. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 24, 2001 5:58 PM Igor, How right you are! I answered without looking back at Rahul's original message. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Tuesday, July 24, 2001 10:26 AM To: Multiple recipients of list ORACLE-L I don't think, 7.3.2 supports Index-Organized tables. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 24, 2001 10:36 AM Rahul, If I'd known that there were only 8 columns in the table, I'd have included the recommendation to investigate an Index-Organized Table. That is where the table IS the index and the index IS the table. This saves disc space and cuts I/O in half for DML on the table, since a separate index is not maintained. Check out the docs on IOTs. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Tuesday, July 24, 2001 8:53 AM To: Multiple recipients of list ORACLE-L list, based on the recommendation of posters (Jack) , i re-created the index with all the columns of a table ! (all 8 of them) analyzed the table/index and now all the queries are satisfied off an indexed range scan.. i also put the indexes on raw devices. regards -- From: Jack C. Applewhite[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 8:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: how to improve sequential scans ? Rahul, Could this table be partitioned and the partitions spread across multiple disks? Could the index be partitioned as well? The concept here is, of course, divide and conquer. Could a column or two (or three) be added to the index to satisfy the query without having to hit the table? How frequently are these literal queries being issued? Are they shredding your shared pool and chewing up CPU by making Oracle do extra work in shared pool memory management? Are there aggregation (vs aggravation g) functions or order bys in the queries that might be causing sorts to disk? If aggregation, could you use materialized views to satisfy the queries? ...just a few ideas. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Tuesday, July 17, 2001 7:36 AM To: Multiple recipients of list ORACLE-L list (AIX, 7.3.2) 5 clients are shooting the same sql to read data from an 18 million rows table. each time the sql uses a different literal value in the where clause... no bind variables. I CANNOT TOUCH THE APPLICATION, and have been given the task to re-configure the DB to increase performance. i have moved the table and it;s associated index to separate disks. and iostat show that only that only those two disks are being read. the session wait show that all the times the sessions are waiting on db file sequential read the db file being sequentially read in the above sessiion is the TABLE from which all the sid's are reading the table is analyzed and the sql's issued use the index. how can i further tune this config. ? TIA Rahul PS: my next step is to put the files on raw disks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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
Re: urgent..! ANSI Standard SQL for Outer Join (ORACLE SQL SERVER)
Why don't you try it? Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 25, 2001 8:35 AM Dear All, Can anyone of you help me for the following. I want to give a generalized SQL syntax for Outer Join for both oracle SQL server. Can I use ANSI Syntax say for example select empno, ename from emp join dept on emp.deptno = dept.deptno (Something like this) Bye Sundar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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: books on data modelling
Thanks for all replies. Suren -Original Message- Sent: Tuesday, July 24, 2001 5:58 PM To: Multiple recipients of list ORACLE-L Handbook of Relational Database Design by Candace C. Fleming and Barbara von Halle is pretty solid.Not sure if its still in print or not though. -Original Message- Sent: Tuesday, July 24, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Richard Barker wrote a good book (Data Modelling) . There are also a few good books from James Martin, who has his own method for doing the data modelling. Also, any half way decent UML manual should explain the basics of the data modelling. Last, but not least, the books to read are Catch-22 by Joseph Heller, Doug Adamses Hitchiker's Guide to Galaxy and Heinlein's Stranger in the Strange Land. Without having read the last 3 books, one cannot grokk the depths of the data modelling. -Original Message- From: Tirumala, Surendra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 12:57 PM To: Multiple recipients of list ORACLE-L Subject: books on data modelling Hello All, I have been in the lookout for a good and comprehensive book on data modelling so that I can enhance my knowledge in this area. I am not finding anything related in online Oracle documentation. Please suggest me.. Thanks in Advance, Suren -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Information about User-defined Locks
Listers:
Solved my own problem and thought I would share the solution
with you all.
To find the name of a user-defined lock:
SELECT s.sid
, s.serial#
, DECODE(
s.process
, NULL, DECODE(SUBSTR(p.username, 1, 1), '?', UPPER(s.osuser),
p.username)
, DECODE(p.username, 'oracusr ', LOWER(s.osuser),
s.process)) AS process
, NVL(s.username, 'SYS (' || LOWER(bg.name) || ')') AS
username
, DECODE(s.username, NULL, ' ', DECODE(s.terminal, NULL,
RTRIM(LOWER(p.terminal), CHR(0)), LOWER(s.terminal))) AS terminal
, 'UL' as type
, DECODE(l.lmode, 0, 'none', 1, 'null', 2, 'RS', 3, 'RX',
4, 'S', 5, 'SRX', 6, 'X', TO_CHAR(l.lmode)) AS lmode
, DECODE(l.request, 0, 'none', 1, 'null', 2, 'RS', 3,
'RX', 4, 'S', 5, 'SRX', 6, 'X', TO_CHAR(l.request)) AS lrequest
, 'lock name: ' || la.name || ', expiration date: ' ||
TO_CHAR(la.expiration, 'DD-MON-RR HH24:MI:SS') as detail
FROM sys.v_$lock l
, sys.v_$session s
, sys.v_$process p
, sys.v_$bgprocess bg
, sys.dbms_lock_allocated la
WHERE l.sid = s.sid
AND s.paddr = bg.paddr(+)
AND s.paddr = p.addr(+)
AND l.id1 = la.lockid(+)
AND l.type = 'UL';
Thanks, everyone, for your continued help through this forum.
Jon Walthour
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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, WOW really early
What is required to submit a paper/presentation to IOUGA and get excepted. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 24, 2001 8:41 PM To: Multiple recipients of list ORACLE-L IOUG 2002 call for papers already. Submit your presentation via the IOUG-A Web site at http://www.ioug.org/call-m no later than FRIDAY, SEPTEMBER 14, 2001. Mini Lesson and Technical Session presenters receive complimentary registration at IOUG-A Live! 2002 when your abstract is chosen! New for 2002 - Quick Tips! Share your unique and valuable tips during these new 30-minute presentations. Quick Tips provide great experience for first time presenters and allow experienced presenters to get to the heart of the matter. This is a presentation only - papers are not required. Plus, receive a discount on the Early Bird registration rate! joe -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: severe lib cache contention !!
Set your time_statistics=false i think this is a bug in 8.1.5 we had the same issue. and also I am not sure whether you can set cursor_sharing=force in 8.1.5 if yes try this out this will convert all the literals to bind variables From: Rahul [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: severe lib cache contention !! Date: Wed, 25 Jul 2001 04:35:25 -0800 list, i just ported a system to 8.1.5, the application DOES NOT make use of bind variables, each and every query (fired from 8 clients every 2-3 seconds) parses and executes, this keeps the shared pool patch also very busy... i cannot tune the app, is there something i can do to reduce the lib cache and shared pool latch contention ?? v$session_wait show all sessions waiting on latch free the sleeps in lib cache latch are not properly spread out also... SQL select * from v$latch_children where latch#=99 order by 8 CHILD#GETSMISSESSLEEPS -- 1 209093 149 117 5 283185 602 221 6 304797 616 264 7 583061 3354 1417 4 2697205191099 33858 211636488 8683396980522 360982875 47012872 8777649 Interestingly, the same app was NOT showing any contention on these latches in 7.3.2 !! how can i solve this problem ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: retrieving BLOB column..
I don't remember in ODBC/OLEDB, but in JDBC there's quite a nice streams interface to CLOBs. You open the CLOB, then just read it as any other stream, for example as if it were a disk file, using the CLOB as a handle rather than a file descriptor. g -Original Message-From: Saurabh Sharma [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 24, 2001 2:10 PMTo: Multiple recipients of list ORACLE-LSubject: retrieving BLOB column.. hi all, do any one tell me how can i retrieve from a blob column. these will be displayed in browser through asp page. r there any functions used to retrieved records(jpg files, gif) from a blob. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
Re: OT, WOW really early
Depends on if it's a user-defined exception or not. : ) Seriously, I presented for the first time at IOUG-A 2001. I submitted a topic by the deadline date, which contained a brief ( 250 words, I believe) synopsis of what I wanted to speak about. The accept/reject decision is made from that information. After that, I was given a deadline to submit a white paper on the topic, and another topic to submit a Powerpoint presentation. The conference was in April, and I believe that the paper deadline was in Jan., and the ppt deadline was in March. Overall, I had a great time. I'm probably going to try and do it again. All the details should be available somewhere on http://www.ioug.org. Brian Christopher Spence wrote: What is required to submit a paper/presentation to IOUGA and get excepted. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 24, 2001 8:41 PM To: Multiple recipients of list ORACLE-L IOUG 2002 call for papers already. Submit your presentation via the IOUG-A Web site at http://www.ioug.org/call-m no later than FRIDAY, SEPTEMBER 14, 2001. Mini Lesson and Technical Session presenters receive complimentary registration at IOUG-A Live! 2002 when your abstract is chosen! New for 2002 - Quick Tips! Share your unique and valuable tips during these new 30-minute presentations. Quick Tips provide great experience for first time presenters and allow experienced presenters to get to the heart of the matter. This is a presentation only - papers are not required. Plus, receive a discount on the Early Bird registration rate! joe -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- -- | Brian McGraw -- Oracle DBA | | Central Alabama Oracle Users Group | || | mailto:[EMAIL PROTECTED] | | http://bmcgraw.home.mindspring.com | -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 load options
You can use Materialized Views in Oracle 8i to load data from one database to another (via the DB link) either manually or at scheduled intervals. David David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0695 Email mailto:[EMAIL PROTECTED] Web http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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 Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
UNIX SCRIPT ISSUE - URGENT
I need to extract the first 16 bytes of a filename (AIX 4.3) which consists of an IP address (nnn.nnn.nnn.nnn), and move that to first 16 positions in the file itself, plus adding a pipe (|) sign for a delimiter, and save the IP address as a file name with a .dat extension, before loading the contents into a table. My predecessor concocted the following: #!/usr/bin/ksh FN=$1 IP=`echo $FN|cut -c1-16` sed s/Report by Hosts/$IP| Report by Hosts/ $FN newfile.dat #-- End of file which is great for a single file at a time. Right now I have to perform this surgery on 19 986 files, which is in one place. Using the script above would take me over 20 000 hours. Any way I can grab the files one at the time based on a ls command, and invoke the script, and to end up when the last file has been processed. ALTERNATIVE: Each file contains the IP address which has to move into the first position after a string on line 13 which you guessed it: is called 'IP Address:'. Is their a way vi could be used to achieve the same result? Any input would be appreciated, Johan Muller __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT, WOW really early
Maybe some spelling errors in the abstract -:) Alex Hillman -Original Message- Sent: Wednesday, July 25, 2001 9:46 AM To: Multiple recipients of list ORACLE-L What is required to submit a paper/presentation to IOUGA and get excepted. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 24, 2001 8:41 PM To: Multiple recipients of list ORACLE-L IOUG 2002 call for papers already. Submit your presentation via the IOUG-A Web site at http://www.ioug.org/call-m no later than FRIDAY, SEPTEMBER 14, 2001. Mini Lesson and Technical Session presenters receive complimentary registration at IOUG-A Live! 2002 when your abstract is chosen! New for 2002 - Quick Tips! Share your unique and valuable tips during these new 30-minute presentations. Quick Tips provide great experience for first time presenters and allow experienced presenters to get to the heart of the matter. This is a presentation only - papers are not required. Plus, receive a discount on the Early Bird registration rate! joe -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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: Data load options
Title: RE: Data load options Hi Sean, Others have given you different options. Here's some considerations: 1. SQL Script. Can be SLOW May require intermittent commits in your script Manual and error prone Must go through SQL engine 2. SQL Loader Can be very fast (direct - bypassing SQL engine). Direct path load will invalidate indexes. You can keep track of rejected records easily (.bad file) Dependent upon your file format being EXACT, no errors. 3. Import Requires minimal manual fiddling Can be very slow - I once imported 150GB and it took ~3 days Does not seamlessly handle all object types (INtermedia (domain) indexes is one example) Restarting an import will take a lot longer. If your import fails, be sure and truncate/drop all tables before starting again. Have the option of not including indexes (INDEXES=N) Can also reset your storage parms prior to import (export with data=n, edit file [SSSHHH] and enter new storage parms / import, export with data=y, import data with IGNORE=Y) I'm sure others will have additional considerations to share. My choice has always been exp/imp. Lisa Koivu The Vicodin-enhanced DBA Ft. Lauderdale, FL, USA -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L Subject: Data load options I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 load options
Sean, Depends on what the data is, volume thereof, do you need real time loading, etc... We use to use SQL*Loader, but found a lot of problems scrubbing bad data from our testers during the load process as well as other problems. Consequently we now use Pro*C exclusively. Dick Goulet Reply Separator Author: O'Neill; Sean [EMAIL PROTECTED] Date: 7/25/2001 2:16 AM I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Dangerous AIX Bug!
...just kidding, thought that would get your attention. But seriously: does anyone out there use Oracle 8i on AIX 4.3 or 5L? I'd like to chat w/you if so. Thanks! - Ross p.s. hmmm...maybe there *is* a bug in AIX and that's one of the things I'll learn:-) -Original Message- Sent: Tuesday, July 10, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Ron, I've attached one that I also got from the list some time ago, you may need to use something like bablefish to translate the comments :) HTH Mark -Original Message- L. Sent: Tuesday, July 10, 2001 02:32 To: Multiple recipients of list ORACLE-L Last week I was bit by a corrupt block on an index. I run Analyze every week which I found has been blowing up for some time due to the block corruption. Since Analyze does not create a log I did not know the Analyze was blowing up. Now I know that there are messages in the alert log that would have told me I had problems with the Analyze and the index. To make a long story short I need a good log scan script. Hopefully one that will work on Unix and NT. Mainly Unix. If anyone can help I would appreciate it. Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: OT, WOW really early
to submit a paper, you just need an idea, a title and an abstract. The abstract needs to be somewhat catchy, the idea should be relevant and something that might interest attendees (anything on version 6, Oracle7 or Oracle8 is not a good idea G). To be accepted (to be excepted would be to be left out or excluded, you can do THAT by not submitting an abstract) -- when you learn the secret please tell me. I believe that the selection is not blind -- in that the selection committee members know the name of the presenter for the abstracts they read. So speakers who have presented before and gotten good ratings will be most likely to be asked back. But there are always new speakers each year as well. Some people (like Gaja) are in the you have been accepted, now what are you presenting category, in that they are KNOWN to be excellent speakers who draw standing room only crowds in the largest rooms. Rachel From: Christopher Spence [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT, WOW really early Date: Wed, 25 Jul 2001 05:45:43 -0800 What is required to submit a paper/presentation to IOUGA and get excepted. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 24, 2001 8:41 PM To: Multiple recipients of list ORACLE-L IOUG 2002 call for papers already. Submit your presentation via the IOUG-A Web site at http://www.ioug.org/call-m no later than FRIDAY, SEPTEMBER 14, 2001. Mini Lesson and Technical Session presenters receive complimentary registration at IOUG-A Live! 2002 when your abstract is chosen! New for 2002 - Quick Tips! Share your unique and valuable tips during these new 30-minute presentations. Quick Tips provide great experience for first time presenters and allow experienced presenters to get to the heart of the matter. This is a presentation only - papers are not required. Plus, receive a discount on the Early Bird registration rate! joe -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Data load options
Hi, COPY command. -- Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 04:16 AM To: Multiple recipients of list ORACLE-L Subject: Data load options I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guidry, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need SQL Example
Ethan, Is it possible for you to use your function instead of decode? I guess that way you can evaluate situations wherein decode would not work. That way you could have it work on older versions of Oracle. Shailesh -Original Message- Sent: Tuesday, July 24, 2001 1:29 PM To: Multiple recipients of list ORACLE-L Anyone got a good example of flipping a range of values into columner buckets. I have done this in the past but my solutions always seem so convoluted, it seems I have seen more elegant examples in the past. I want to use decode so it will run on older versions of Oracle. Pseudo Example: select sum(decode(if value between 0 and 64 then return 1 else 0)) count_of_this_bucket, sum(decode(if value between 65 and 128 then return 1 else 0)) count_of_this_bucket,... from table Thanks, Ethan -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yadav, Shailesh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OCI
Title: Blank Hi, Does anyone know about the Oracle Certified Instructor program. I looked in the Oracle site and didn't found anything. Regards Ramón Estévez (809-565-3121 x 225 - [EMAIL PROTECTED] Blank Bkgrd.gif
Re: urgent..! ANSI Standard SQL for Outer Join (ORACLE SQL SERVER)
Hello Rangachari, Oracle9i supports the ANSI join syntax. I just finished an article on it that should appear in the Nov/Dec (I think) issue of Oracle Magazine. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Wednesday, July 25, 2001, 8:35:24 AM, you wrote: RS Dear All, RS Can anyone of you help me for the following. RS I want to give a generalized SQL syntax for Outer Join for both oracle SQL RS server. Can I use ANSI Syntax say for example RS select empno, ename RS from emp RS join dept on emp.deptno = dept.deptno (Something like this) RS Bye RS Sundar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Information about User-defined Locks
Jon, User defined locks do not lock anything, except a very small chunk of the SGA, part of the shared pool. Now the question is: is the procedure hanging while holding the UL or while trying to acquire the UL? A UL must be acquired by using the DBMS_LOCK package, namely the ALLOCATE_UNIQUE and REQUEST procedure/functions. Therefore there must be a snippet of code like the following somewhere in the procedure: BEGIN DBMS_LOCK.ALLOCATE_UNIQUE(:server_lock_name, :server_lock_handle); :server_lock_allocate := DBMS_LOCK.REQUEST (:server_lock_handle, DBMS_LOCK.X_MODE,1, FALSE); END; If you can find the lock request code, look around to see if there is a DBMS_LOCK.CONVERT statement afterwards, which could cause the problem, or what other objects is the procedure trying to get at that may have been locked from elsewhere. Dick Goulet PS: You may find that the amount of time the REQUEST function is set to is 'infinity' namely 86400 seconds which is the default. If so put something reasonable in there and then check the status returned. In the example the amount of time I'll wait is 1 second. Now IF I get the lock the :server_lock_allocate = 0, else it = 1. Reply Separator Author: Viraj Luthra [EMAIL PROTECTED] Date: 7/24/2001 5:50 PM Jon, Try doing the following, it should give you the information, you need :- SELECT o.object_id, s.username, l.sid, object_name, DECODE( l.type, 'MR', 'Media Recovery', 'RT', 'Redo Thread', 'UN', 'User Name', 'TX', 'Transaction', 'TM', 'DML', 'UL', 'PL/SQL User Lock', 'DX', 'Distributed Xaction', 'CF', 'Control File', 'IS', 'Instance State', 'FS', 'File Set', 'IR', 'Instance Recovery', 'ST', 'Disk Space Transaction', 'TS', 'Temp Segment', 'IV', 'Library Cache Invalidation', 'LS', 'Log Start or Switch', 'RW', 'Row Wait', 'SQ', 'Sequence Number', 'TE', 'Extend Table', 'TT', 'Temp Table', l.type ), DECODE( l.lmode, 0, 'None', 1, 'Null', 2, 'Row-s (SS)', 3, 'Row-x (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive', to_char(l.request)) FROM v$lock l, v$session s, dba_objects o WHERE s.sid = l.sid and l.id1 = o.object_id(+) and username is not null ORDER BY username, l.sid / -- On Tue, 24 Jul 2001 16:45:47 Jon Walthour wrote: Listers: I had an interesting question today that I cannot find the answer for, but would love to know about. A developer came to me today and asked how we could find the object that was being locked by a User-defined lock (UL). He works with Oracle Clinical and in one of its blackbox procedures, it appears to hang while holding a UL. He would like to know what object it is holding. Now, as far as I know, in v$lock a UL's id1 and id2 do not provide useful information to this end; both parameters are application dependent. So, where else can I turn? Jon Walthour Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note
RE: OT, WOW really early
Title: RE: OT, WOW really early For those of you who have been speakers before, there appears to be a new wrinkle in the submission process. They now want an outline of the presentation submitted along with the abstract. I don't remember submitting an outline for past conferences. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- From: Joe Testa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 8:41 PM To: Multiple recipients of list ORACLE-L Subject: OT, WOW really early IOUG 2002 call for papers already. Submit your presentation via the IOUG-A Web site at http://www.ioug.org/call-m no later than FRIDAY, SEPTEMBER 14, 2001. Mini Lesson and Technical Session presenters receive complimentary registration at IOUG-A Live! 2002 when your abstract is chosen! New for 2002 - Quick Tips! Share your unique and valuable tips during these new 30-minute presentations. Quick Tips provide great experience for first time presenters and allow experienced presenters to get to the heart of the matter. This is a presentation only - papers are not required. Plus, receive a discount on the Early Bird registration rate! joe -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Metablink .... down again?
Guy Hammond wrote: Is there a web site where we can submit bug reports for MetaLink itself?! yes you can submit an iTAR on metalink.;-) -- Bill Shrek 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. ~~ If a program is useful, it must be changed. -- 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: Data load options
My experience with getting data into Oracle on an NT platform. If a small number of rows are being inserted or updated, use an application or SQL script. If the data already exists in some form outside of Oracle, transform the data into some form of a flat file and use SQL*Loader. If the data already exists in another Oracle database, export it and import it into your database (gotta be careful about tablespaces, schemas and not messing up existing data but that goes with the territory). Other methods include loading it into Access or some other MS product and using an ODBC connection to update Oracle. I've seen that used for everything from single row updates to medium sized (10M) bulk loads. O'Neill, Sean To: Multiple recipients of list ORACLE-L Sean.ONeill@o[EMAIL PROTECTED] rganon.iecc: Sent by: Subject: Data load options [EMAIL PROTECTED] om 07/25/2001 06:16 AM Please respond to ORACLE-L I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
Hi, I have configured the server to use MTS and still dedicated connections r used. What might be the reasondatabase is 8.1.6.3.4 LSNRCTL services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) ora2000 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DEDICATED SERVER established:76 refused:0 LOCAL SERVER The command completed successfully init.ora looks like: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder 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: Data load options
Hydrocodone Acetaminophen. Pain reliever for DBA's most probably; at present jobsite we get dosage of Prosac when we swipe our access badges. --- Hallas John [EMAIL PROTECTED] wrote: Go on then Lisa, I rise to the challenge For us UK based listers what is Vicodin? John -Original Message- Sent: 25 July 01 15:26 To: Multiple recipients of list ORACLE-L Hi Sean, Others have given you different options. Here's some considerations: 1. SQL Script. * Can be SLOW * May require intermittent commits in your script * Manual and error prone * Must go through SQL engine 2. SQL Loader * Can be very fast (direct - bypassing SQL engine). * Direct path load will invalidate indexes. * You can keep track of rejected records easily (.bad file) * Dependent upon your file format being EXACT, no errors. 3. Import * Requires minimal manual fiddling * Can be very slow - I once imported 150GB and it took ~3 days * Does not seamlessly handle all object types (INtermedia (domain) indexes is one example) * Restarting an import will take a lot longer. If your import fails, be sure and truncate/drop all tables before starting again. * Have the option of not including indexes (INDEXES=N) * Can also reset your storage parms prior to import (export with data=n, edit file [SSSHHH] and enter new storage parms / import, export with data=y, import data with IGNORE=Y) I'm sure others will have additional considerations to share. My choice has always been exp/imp. Lisa Koivu The Vicodin-enhanced DBA Ft. Lauderdale, FL, USA -Original Message- Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. ** __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Information about User-defined Locks
Jon,
Your right, thanks. But for the edification of others who may not be using
user defined locks today, here is the results of Jon's query from one of my DB's
that does use them:
SIDSERIAL# PROCESS USERNAME TERMINAL
-- -- --- -- --
TY LMODE
--
LREQUEST
DETAIL
---
45 39789 169:137 WORKENTRY ora_upload
UL X
none
lock name: DlogSrv1, expiration date: 02-AUG-01 17:02:38
55 48632 81:67 WORKENTRY ora_upload
UL X
none
lock name: DlogSrv0, expiration date: 02-AUG-01 17:02:37
Sorry about the mess this Lotus CCMail package makes of things.
Dick Goulet
Reply Separator
Author: Jon Walthour [EMAIL PROTECTED]
Date: 7/25/2001 5:30 AM
Listers:
Solved my own problem and thought I would share the solution
with you all.
To find the name of a user-defined lock:
SELECT s.sid
, s.serial#
, DECODE(
s.process
, NULL, DECODE(SUBSTR(p.username, 1, 1), '?', UPPER(s.osuser),
p.username)
, DECODE(p.username, 'oracusr ', LOWER(s.osuser),
s.process)) AS process
, NVL(s.username, 'SYS (' || LOWER(bg.name) || ')') AS
username
, DECODE(s.username, NULL, ' ', DECODE(s.terminal, NULL,
RTRIM(LOWER(p.terminal), CHR(0)), LOWER(s.terminal))) AS terminal
, 'UL' as type
, DECODE(l.lmode, 0, 'none', 1, 'null', 2, 'RS', 3, 'RX',
4, 'S', 5, 'SRX', 6, 'X', TO_CHAR(l.lmode)) AS lmode
, DECODE(l.request, 0, 'none', 1, 'null', 2, 'RS', 3,
'RX', 4, 'S', 5, 'SRX', 6, 'X', TO_CHAR(l.request)) AS lrequest
, 'lock name: ' || la.name || ', expiration date: ' ||
TO_CHAR(la.expiration, 'DD-MON-RR HH24:MI:SS') as detail
FROM sys.v_$lock l
, sys.v_$session s
, sys.v_$process p
, sys.v_$bgprocess bg
, sys.dbms_lock_allocated la
WHERE l.sid = s.sid
AND s.paddr = bg.paddr(+)
AND s.paddr = p.addr(+)
AND l.id1 = la.lockid(+)
AND l.type = 'UL';
Thanks, everyone, for your continued help through this forum.
Jon Walthour
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Starting Oracle services remotely (Win2K)
Mark, If you have the Resource Kit you can also use NETSVC.EXE. If you do not, you may download freely from microsoft the Resource Kit Support Tools which contains SC.EXE. HTH -- Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 04:31 AM To: Multiple recipients of list ORACLE-L Subject: RE: Starting Oracle services remotely (Win2K) Mark, RCMD from the Resource Kit for NT4, and presumably for W2K, might provide a solution. I have not used it myself so can't comment on it's operation etc. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King From: Mark Leith [EMAIL PROTECTED] Date: Tue, 24 Jul 2001 10:57:04 +0100 Subject: Starting Oracle services remotely (Win2K). Hi all, Has anybody come across a way of starting the Oracle services (or indeed any service) on a Win2K box remotely from another Win2K machine? I would be interested in your insight if you have.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guidry, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT, WOW really early
Christopher Spence wrote: What is required to submit a paper/presentation to IOUGA and get excepted. brains, knowledge and skill? or sheer luck? all i have to depend on is the luck part.;-) now to figure out if it's good or bad.;-) -- Bill Shrek 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. ~~ If a program is useful, it must be changed. -- 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: RE: Data Modeling opinion? Help?
Chris, I don't think anyone is disagreeing with your evaluation of what SHOULD be done (emphasis on purpose). But, you have to deal with the people and politics of the client. As I said before, it sounds like something else is going on in the organization, and someone decided to pull and end-around on you for some reason. I would personally be more concerned about why they felt that they had to do this to get their way. Check your back, and make some friends (and maybe, learn the art of compromise? :) ) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 24, 2001 2:40 PM To: Multiple recipients of list ORACLE-L Hmmm...when the spec is changed because of some business requirement then that's fine. But when it's changed because your own designers cant argue the design on technical merit then what? A spec should quote all the business rules, and some high level details about the overall architecture of the system. But the spec shouldn't tell you that you will have these two specific tables in the database, with these specific fields, etc. In the end the contractor is ultimately responsible for the validity and performance of the system that they deliver. The contractor will never be able to point back to some disclaimer and say We told you so. It will be next to impossible to point to the disclaimer when you start slipping the schedule or when the performance is not quite there. -Original Message- Sent: Tuesday, July 24, 2001 1:09 PM To: Grabowy; Chris; Multiple recipients of list ORACLE-L Chris, True, except when I as the customer change the specs. Then what is right is what I say. Or as a Program Management instructor told the class As it is written, so let it be done. Dick Goulet Reply Separator Author: Grabowy; Chris [EMAIL PROTECTED] Date: 7/24/2001 9:48 AM Exactly. Which is why I am trying to change this now. As for the previous comment, they do not pay me to beat them over the head, BUT they do pay me to do what is right. -Original Message- Sent: Tuesday, July 24, 2001 1:29 PM To: Multiple recipients of list ORACLE-L Yes, but ironically enough, its the consultant they ram to the ground after it goes south, no matter how well you document that you recommended against it. -Original Message- Sent: Tuesday, July 24, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Keep in mind that they pay you to advise them and to do what they want done. They do not pay you to beat them over the head to do what is right. Document to cya This is one of those cases where I would document your concerns and the potential consequences thereof and submit that to damagement, also keep a copy for yourself in the 'Pearl Harbor File'. Then do as they ask. Yeah, I know it's dumb, but what are you as a consultant/contractor going to do? Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
Re: UNIX SCRIPT ISSUE - URGENT
Since you have so many files, you are likely to hit problems with the line length of
the various shells. Assuming that all of the files are in the directory
/usr/myfiles and that the script mentioned below is named cvtip, is executable and
is in /usr/local/bin (or some other directory in the path), you could do the following:
$ cd /usr/myfiles
$ find . -type f -print | xargs cvtip
and that would do exactly what you want IF you modify the scipt as follows (this
processes multiple files at the same invocation of the script):
#!/usr/bin/ksh
for FN
do
IP=`echo $FN|cut -c1-16`
mv $FN ${FN}.old
sed s/Report by Hosts/$IP| Report by Hosts/ ${FN}.old $FN
done
This modification processes multiple filenames on the command line. It also assumes
that the file exists in the current directory (which I don't like, but which I don't
want to work around right now). It first renames the file by tacking .old on the
filename, then converts it as the previous script did and sends the output to the
original filename (i.e., without the .old on the end)
Hope this helps,
larry
On Wed, 25 Jul 2001 06:26:12 -0800
Johan Muller [EMAIL PROTECTED] wrote:
I need to extract the first 16 bytes of a filename (AIX 4.3) which consists of
an IP address (nnn.nnn.nnn.nnn), and move that to first 16 positions in the
file itself, plus adding a pipe (|) sign for a delimiter, and save the IP
address as a file name with a .dat extension, before loading the contents into
a table.
My predecessor concocted the following:
#!/usr/bin/ksh
FN=$1
IP=`echo $FN|cut -c1-16`
sed s/Report by Hosts/$IP| Report by Hosts/ $FN newfile.dat
#-- End of file
which is great for a single file at a time.
Right now I have to perform this surgery on 19 986 files, which is in one
place.
Using the script above would take me over 20 000 hours.
Any way I can grab the files one at the time based on a ls command, and invoke
the script, and to end up when the last file has been processed.
ALTERNATIVE:
Each file contains the IP address which has to move into the first position
after a string on line 13 which you guessed it: is called 'IP Address:'. Is
their a way vi could be used to achieve the same result?
Any input would be appreciated,
Johan Muller
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johan Muller
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Larry Strickland
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 load options
Title: RE: Data load options Cheers John, I wason the verge of asking myself -Original Message-From: Hallas John [mailto:[EMAIL PROTECTED]]Sent: 25 July 2001 15:57To: Multiple recipients of list ORACLE-LSubject: RE: Data load options Go on then Lisa, I rise to the challenge For us UK based listers what is Vicodin? John -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: 25 July 01 15:26To: Multiple recipients of list ORACLE-LSubject: RE: Data load options Hi Sean, Others have given you different options. Here's some considerations: 1. SQL Script. Can be SLOW May require intermittent commits in your script Manual and error prone Must go through SQL engine 2. SQL Loader Can be very fast (direct - bypassing SQL engine). Direct path load will invalidate indexes. You can keep track of rejected records easily (.bad file) Dependent upon your file format being EXACT, no errors. 3. Import Requires minimal manual fiddling Can be very slow - I once imported 150GB and it took ~3 days Does not seamlessly handle all object types (INtermedia (domain) indexes is one example) Restarting an import will take a lot longer. If your import fails, be sure and truncate/drop all tables before starting again. Have the option of not including indexes (INDEXES=N) Can also reset your storage parms prior to import (export with data=n, edit file [SSSHHH] and enter new storage parms / import, export with data=y, import data with IGNORE=Y) I'm sure others will have additional considerations to share. My choice has always been exp/imp. Lisa Koivu The Vicodin-enhanced DBA Ft. Lauderdale, FL, USA -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L Subject: Data load options I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited.Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. ** 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.
RE: UNIX SCRIPT ISSUE - URGENT
Title: RE: UNIX SCRIPT ISSUE - URGENT No unix expert but the first option can be achieved automatically by running the following script for filename in `ls *.file` do unix script as listed done Rename a couple of the files and try out the syntax and work out the timings. Once it all works properly then rename some of the files (extensions at least) and set the scripyt off a numver of times in the background (nohup scriptname ) and the work can be spread around between processors on the system For the 2nd option I would have thought AWK was the required utility but can offer nothing more substantial than that at the moment John -Original Message- From: Johan Muller [mailto:[EMAIL PROTECTED]] Sent: 25 July 01 15:26 To: Multiple recipients of list ORACLE-L Subject: UNIX SCRIPT ISSUE - URGENT I need to extract the first 16 bytes of a filename (AIX 4.3) which consists of an IP address (nnn.nnn.nnn.nnn), and move that to first 16 positions in the file itself, plus adding a pipe (|) sign for a delimiter, and save the IP address as a file name with a .dat extension, before loading the contents into a table. My predecessor concocted the following: #!/usr/bin/ksh FN=$1 IP=`echo $FN|cut -c1-16` sed s/Report by Hosts/$IP| Report by Hosts/ $FN newfile.dat #-- End of file which is great for a single file at a time. Right now I have to perform this surgery on 19 986 files, which is in one place. Using the script above would take me over 20 000 hours. Any way I can grab the files one at the time based on a ls command, and invoke the script, and to end up when the last file has been processed. ALTERNATIVE: Each file contains the IP address which has to move into the first position after a string on line 13 which you guessed it: is called 'IP Address:'. Is their a way vi could be used to achieve the same result? Any input would be appreciated, Johan Muller __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
RE: UNIX SCRIPT ISSUE - URGENT
for i in `ls`
do
YourScript.shl $i
done
Unless you are also processing your newfile.dat in the script you need
to make unique names for the output files.
Something like:
sed s/Report by Hosts/$IP| Report by Hosts/ $FN new_${FN}.dat
so you will get an output file from each input file.
-Original Message-
From: Johan Muller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 25, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L
Subject: UNIX SCRIPT ISSUE - URGENT
I need to extract the first 16 bytes of a filename (AIX 4.3)
which consists of
an IP address (nnn.nnn.nnn.nnn), and move that to first 16
positions in the
file itself, plus adding a pipe (|) sign for a delimiter, and
save the IP
address as a file name with a .dat extension, before loading
the contents into
a table.
My predecessor concocted the following:
#!/usr/bin/ksh
FN=$1
IP=`echo $FN|cut -c1-16`
sed s/Report by Hosts/$IP| Report by Hosts/ $FN newfile.dat
#-- End of file
which is great for a single file at a time.
Right now I have to perform this surgery on 19 986 files,
which is in one
place.
Using the script above would take me over 20 000 hours.
Any way I can grab the files one at the time based on a ls
command, and invoke
the script, and to end up when the last file has been processed.
ALTERNATIVE:
Each file contains the IP address which has to move into the
first position
after a string on line 13 which you guessed it: is called 'IP
Address:'. Is
their a way vi could be used to achieve the same result?
Any input would be appreciated,
Johan Muller
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with
Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johan Muller
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anderson, Brian
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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, WOW really early
ouch it hurt my brain :) joe [EMAIL PROTECTED] 07/25/01 11:16AM "Oracle 9i XML Web Apps for Wireless ERP/CRM Support in Deep DB2/SiebelTerritory"Is that catchy enough? Something you can sink your blueteeth into?;-)-Original Message-Sent: Wednesday, July 25, 2001 10:52 AMTo: Multiple recipients of list ORACLE-Lto submit a paper, you just need an idea, a title and an abstract. The abstract needs to be somewhat catchy, the idea should be relevant and something that might interest attendees (anything on version 6, Oracle7 or Oracle8 is not a good idea G).To be accepted (to be excepted would be to be left out or excluded, you can do THAT by not submitting an abstract) -- when you learn the secret please tell me.I believe that the selection is not blind -- in that the selection committeemembers know the name of the presenter for the abstracts they read. So speakers who have presented before and gotten good ratings will be most likely to be asked back. But there are always new speakers each year as well. Some people (like Gaja) are in the "you have been accepted, now what are you presenting" category, in that they are KNOWN to be excellent speakers who draw standing room only crowds in the largest rooms.RachelFrom: Christopher Spence [EMAIL PROTECTED]Reply-To: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]Subject: RE: OT, WOW really earlyDate: Wed, 25 Jul 2001 05:45:43 -0800What is required to submit a paper/presentation to IOUGA and get excepted."Walking on water and developing software from a specification are easy ifboth are frozen."Christopher R. SpenceOracle DBAFuelspot-Original Message-Sent: Tuesday, July 24, 2001 8:41 PMTo: Multiple recipients of list ORACLE-LIOUG 2002 call for papers already.Submit your presentation via the IOUG-A Web site athttp://www.ioug.org/call-m no later than FRIDAY, SEPTEMBER 14, 2001. MiniLesson and Technical Session presenters receive complimentary registrationat IOUG-A Live! 2002 when your abstract is chosen!New for 2002 - Quick Tips! Share your unique and valuable tips during thesenew 30-minute presentations. Quick Tips provide great experience for firsttime presenters and allow experienced presenters to get to the heart of thematter. This is a presentation only - papers are not required. Plus, receivea discount on the Early Bird registration rate!joe--Joe TestaPerforming Remote DBA Services, need some backup DBA support? For Sale:Oracle-dba.com domain, its not going cheap but feel free to ask :)--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Joe Testa INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in themessage BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list you want to be removed from). You may also send the HELPcommand for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Christopher Spence INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing)._Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Rachel Carmichael INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Mohan, Ross INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto:
RE: statement for directory objects
select * from user_objects; -Original Message- From: Beatriz Martínez Jiménez [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Subject: statement for directory objects Hello List, I would like to know any statement to know which 'object directory' exists in the oracle instance, for a specified user. TIA, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data load options
Title: RE: Data load options Go on then Lisa, I rise to the challenge For us UK based listers what is Vicodin? John -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: 25 July 01 15:26To: Multiple recipients of list ORACLE-LSubject: RE: Data load options Hi Sean, Others have given you different options. Here's some considerations: 1. SQL Script. Can be SLOW May require intermittent commits in your script Manual and error prone Must go through SQL engine 2. SQL Loader Can be very fast (direct - bypassing SQL engine). Direct path load will invalidate indexes. You can keep track of rejected records easily (.bad file) Dependent upon your file format being EXACT, no errors. 3. Import Requires minimal manual fiddling Can be very slow - I once imported 150GB and it took ~3 days Does not seamlessly handle all object types (INtermedia (domain) indexes is one example) Restarting an import will take a lot longer. If your import fails, be sure and truncate/drop all tables before starting again. Have the option of not including indexes (INDEXES=N) Can also reset your storage parms prior to import (export with data=n, edit file [SSSHHH] and enter new storage parms / import, export with data=y, import data with IGNORE=Y) I'm sure others will have additional considerations to share. My choice has always been exp/imp. Lisa Koivu The Vicodin-enhanced DBA Ft. Lauderdale, FL, USA -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L Subject: Data load options I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
RE: Input truncated
Andrea, Look at the last line of your procedure. I'll bet you a dozen donuts that you do not have a carraige return after the last line of typed cdode, and that the last line of code is 35 chars long. Simply add a carraige return at the last line. hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 24, 2001 10:01 AM To: Multiple recipients of list ORACLE-L I don't know why when I try to load error_p1 procedure it's printed Input truncated to 35 characters. SQL @error_p1 Procedure created. Input truncated to 35 characters No errors. Can anybody help me ? Thanks, Andrea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Data load options
Lisa, SQL*Loader in direct path can cause you storage problems since it always appends to the table(s) ignoring blocks on the free block list. I found that out after a developer was using it for our data warehouse. At the end of a year he had burned almost 100GB of disk it kept increasing even though he was trying to keep only a rolling 180 window. On a hunch we exported the data, truncated the table imported the data back in. The amount of tablespace being used dropped 50%. Dick Goulet Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 7/25/2001 6:26 AM Hi Sean, Others have given you different options. Here's some considerations: 1. SQL Script. * Can be SLOW * May require intermittent commits in your script * Manual and error prone * Must go through SQL engine 2. SQL Loader * Can be very fast (direct - bypassing SQL engine). * Direct path load will invalidate indexes. * You can keep track of rejected records easily (.bad file) * Dependent upon your file format being EXACT, no errors. 3. Import * Requires minimal manual fiddling * Can be very slow - I once imported 150GB and it took ~3 days * Does not seamlessly handle all object types (INtermedia (domain) indexes is one example) * Restarting an import will take a lot longer. If your import fails, be sure and truncate/drop all tables before starting again. * Have the option of not including indexes (INDEXES=N) * Can also reset your storage parms prior to import (export with data=n, edit file [SSSHHH] and enter new storage parms / import, export with data=y, import data with IGNORE=Y) I'm sure others will have additional considerations to share. My choice has always been exp/imp. Lisa Koivu The Vicodin-enhanced DBA Ft. Lauderdale, FL, USA -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L Subject: Data load options I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=US-ASCII META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12 TITLERE: Data load options/TITLE /HEAD BODY PFONT COLOR=#FF SIZE=2 FACE=ArialHi Sean, /FONT /P PFONT COLOR=#FF SIZE=2 FACE=ArialOthers have given you different options.nbsp; Here's some considerations:/FONT /P PFONT COLOR=#FF SIZE=2 FACE=Arial1.nbsp; SQL Script. /FONT ULLIFONT COLOR=#FF SIZE=2 FACE=ArialCan be SLOW /FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialMay require intermittent commits in your script/FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialManual and error prone/FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialMust go through SQL engine/FONT/LI BR /UL PFONT COLOR=#FF SIZE=2 FACE=Arial2.nbsp; SQL Loader/FONT ULLIFONT COLOR=#FF SIZE=2 FACE=ArialCan be very fast (direct - bypassing SQL engine). /FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialDirect path load will invalidate indexes. /FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialYou can keep track of rejected records easily (.bad file)/FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialDependent upon your file format being EXACT, no errors./FONT/LI BR /UL PFONT COLOR=#FF SIZE=2 FACE=Arial3.nbsp; Import/FONT ULLIFONT COLOR=#FF SIZE=2 FACE=ArialRequires minimal manual fiddling/FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialCan be very slow - I once imported 150GB and it took ~3 days/FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialDoes not seamlessly handle all object
re-archiving a redo log file
Title: re-archiving a redo log file Is it possible to re-archive an already archived but still online redo log file? the 8.1.6 sql*plus manual says it is, but I can't get the syntax down right apparently. SQL archive log 227 returns a ORA-16013 (does not need archiving) error and SQL archive log 227 to '/tmp' returns SP2-0718 illegal arhicve log option Anybody done this? Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl)
RE: Metablink .... down again?
Is there a web site where we can submit bug reports for MetaLink itself?! -Original Message- Sent: Monday, July 23, 2001 3:21 PM To: Multiple recipients of list ORACLE-L Is it me or everyone? Is Metablink working for anyone this morning ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Rollback Segment Question
Hi All I had a long PL/SQL prg to run . I created a special rollback segment for that script with the storage of (initial 1 m next 1m minextents 2). After a few minutes of running I got the Snapshot too old error. In the v_$rollstat view I got : extents=2, rssize ~ 2 M, hwmsize ~ 2 M. I recreated the RBS with minextents 100, at this time my program run succefully. My question is why in the first case the RBS didn't growth automatically by allocating a new extents until maxetents value ? Thank you Best Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
Check the client's sqlnet.ora. It can override the server config with USE_DEDICATED_SERVER=ON setting. Steve -Original Message- Sent: Wednesday, July 25, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Hi, I have configured the server to use MTS and still dedicated connections r used. What might be the reasondatabase is 8.1.6.3.4 LSNRCTL services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) ora2000 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DEDICATED SERVER established:76 refused:0 LOCAL SERVER The command completed successfully init.ora looks like: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: both dbms_stats dbms_utility are gathering stats on sys objects
Hi Jon,
Thanks for your reply. I am aware of this option and I am currently doing
the same way(i.e.,analyze database and delete SYS schema stats).
But, I was wondering which release of 8.1.7 fixed this problem since Oracle
claims that it is fixed in 8.1.7.
Excerpt from oracle tech support mail:
filed bug 969814 against DBMS_UTILITY.ANALYZE_DATABASE which was not
excluding these tables. This bug is fixed in 8.1.7.
Thanks
Prasad
Jon
WalthourTo: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED][EMAIL PROTECTED]
t cc:
Sent by: Subject: Re: both dbms_stats
dbms_utility are
root@fatcity.gathering stats on sys objects
com
07/24/2001
08:50 PM
Please
respond to
ORACLE-L
Well, first of all, you could use dbms_utility.analyze_schema() and analyze
all the schemas except SYS ... or couldn't you run
dbms_utility.analyze_database() and then
dbms_utility.analyze_schema('SYS','DELETE') to remove SYS's stats. What
about one of those?
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 24, 2001 3:55 PM
Both DBMS_STATS.GATHER_DATABASE_STATS and DBMS_UTILITY.ANALYZE_DATABASE
are
gathering statistics on sys objects. As per oracle, we shouldn't analyze
the objects owned by sys.
When I searched on metalink, I found the following information provided
by
oracle tech support.
filed bug 969814 against DBMS_UTILITY.ANALYZE_DATABASE which was not
excluding these tables.
This bug is fixed in 8.1.7.
I did my tests on 8.1.7 database on hp-ux. Apparently it is not fixed on
8.1.7.0.0.
Is it fixed in later releases? I appreciate your comments.
Best regards,
Prasad
--
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: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: OT, WOW really early
Oracle 9i XML Web Apps for Wireless ERP/CRM Support in Deep DB2/Siebel Territory Is that catchy enough? Something you can sink your blueteeth into? ;-) -Original Message- Sent: Wednesday, July 25, 2001 10:52 AM To: Multiple recipients of list ORACLE-L to submit a paper, you just need an idea, a title and an abstract. The abstract needs to be somewhat catchy, the idea should be relevant and something that might interest attendees (anything on version 6, Oracle7 or Oracle8 is not a good idea G). To be accepted (to be excepted would be to be left out or excluded, you can do THAT by not submitting an abstract) -- when you learn the secret please tell me. I believe that the selection is not blind -- in that the selection committee members know the name of the presenter for the abstracts they read. So speakers who have presented before and gotten good ratings will be most likely to be asked back. But there are always new speakers each year as well. Some people (like Gaja) are in the you have been accepted, now what are you presenting category, in that they are KNOWN to be excellent speakers who draw standing room only crowds in the largest rooms. Rachel From: Christopher Spence [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT, WOW really early Date: Wed, 25 Jul 2001 05:45:43 -0800 What is required to submit a paper/presentation to IOUGA and get excepted. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 24, 2001 8:41 PM To: Multiple recipients of list ORACLE-L IOUG 2002 call for papers already. Submit your presentation via the IOUG-A Web site at http://www.ioug.org/call-m no later than FRIDAY, SEPTEMBER 14, 2001. Mini Lesson and Technical Session presenters receive complimentary registration at IOUG-A Live! 2002 when your abstract is chosen! New for 2002 - Quick Tips! Share your unique and valuable tips during these new 30-minute presentations. Quick Tips provide great experience for first time presenters and allow experienced presenters to get to the heart of the matter. This is a presentation only - papers are not required. Plus, receive a discount on the Early Bird registration rate! joe -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: 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,
RE: Data load options
I will second Lisa's recommendations. If you have much data, and/or will be doing this frequently, SQL*Loader is your friend. It is very fast. Loading from a SQL script is very bad unless you have small amounts of data. I once worked with a duhveloper who could not be dissuaded from loading all data from SQL scripts. We're talking millions of rows here. A single 10 gigabyte SQL script of insert statements. She single handedly brought our DW to it's knee's. It begged for mercy. There was none. Duhveloper was fired. :) Jared Koivu, Lisa lisa.koivu@efair To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] field.com cc: Sent by:Subject: RE: Data load options [EMAIL PROTECTED] 07/25/01 07:26 AM Please respond to ORACLE-L Hi Sean, Others have given you different options. Here's some considerations: 1. SQL Script. Can be SLOW May require intermittent commits in your script Manual and error prone Must go through SQL engine 2. SQL Loader Can be very fast (direct - bypassing SQL engine). Direct path load will invalidate indexes. You can keep track of rejected records easily (.bad file) Dependent upon your file format being EXACT, no errors. 3. Import Requires minimal manual fiddling Can be very slow - I once imported 150GB and it took ~3 days Does not seamlessly handle all object types (INtermedia (domain) indexes is one example) Restarting an import will take a lot longer. If your import fails, be sure and truncate/drop all tables before starting again. Have the option of not including indexes (INDEXES=N) Can also reset your storage parms prior to import (export with data=n, edit file [SSSHHH] and enter new storage parms / import, export with data=y, import data with IGNORE=Y) I'm sure others will have additional considerations to share. My choice has always been exp/imp. Lisa Koivu The Vicodin-enhanced DBA Ft. Lauderdale, FL, USA -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L Subject:Data load options I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send
RE: ERROR IN INSTALING PATCH 8.1.6.3.0
We had a similar problem when installing the patchset for Oracle Client on Windows. We ended up renaming each existing .dll (.dll.old) and continuing. Worked fine. Jay Miller -Original Message- Sent: Tuesday, July 24, 2001 7:55 PM To: Multiple recipients of list ORACLE-L Had a similar problem with a diff. set of files when installing patch 8.1.7.1.0b and that was on AIX. Just removed the offending files which gave a similar error to allow the patch to write a new file and it worked for us. No problems encountered so far, though I would not hesitate to say that it was a wrong practice, but took a chance and it worked. If you have backed up your systems correctly as recommended, I would say go for it. Satish [EMAIL PROTECTED] 07/24/01 02:58PM For what purpose u are installing this patch let me know From: Harvinder Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ERROR IN INSTALING PATCH 8.1.6.3.0 Date: Tue, 24 Jul 2001 12:45:24 -0800 Hi, I am trying to install patch 8.1.6.3.0 on WIN 2 and i am getting error: Error in writing to file f:\ORACLE\ORA81\BIN\ORANCDS8.DLL..and if i ignore this error the same error comes for other DLL...Oracle is shutdown properly and there is no service running of Oracle. What might be the reason. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Harvinder 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: OT, WOW really early
yeppers, if i've got the outline done, then the whole presentation is done at that point, geez. :( joe [EMAIL PROTECTED] 07/25/01 11:06AM For those of you who have been speakers before, there appears to be a new wrinkle in the submission process. They now want an outline of the presentation submitted along with the abstract. I don't remember submitting an outline for past conferences. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- href="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 8:41 PM To: Multiple recipients of list ORACLE-L Subject: OT, WOW really early IOUG 2002 call for papers already. Submit your presentation via the IOUG-A Web site at http://www.ioug.org/call-m no later than FRIDAY, SEPTEMBER 14, 2001. Mini Lesson and Technical Session presenters receive complimentary registration at IOUG-A Live! 2002 when your abstract is chosen! New for 2002 - Quick Tips! Share your unique and valuable tips during these new 30-minute presentations. Quick Tips provide great experience for first time presenters and allow experienced presenters to get to the heart of the matter. This is a presentation only - papers are not required. Plus, receive a discount on the Early Bird registration rate! joe-- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: UNIX SCRIPT ISSUE - URGENT
Try awk or perl. They can handle string manipulation from OS commands
simply and quickly. A simple awk script to take the first 16 characters of
the output of ls and put it into a data file follows:
gawk 'BEGIN { while (ls | getline) print substr($1,1,16) | Report by
Hosts}' new.dat
Defry
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 25, 2001 10:26 AM
I need to extract the first 16 bytes of a filename (AIX 4.3) which
consists of
an IP address (nnn.nnn.nnn.nnn), and move that to first 16 positions in
the
file itself, plus adding a pipe (|) sign for a delimiter, and save the IP
address as a file name with a .dat extension, before loading the contents
into
a table.
My predecessor concocted the following:
#!/usr/bin/ksh
FN=$1
IP=`echo $FN|cut -c1-16`
sed s/Report by Hosts/$IP| Report by Hosts/ $FN newfile.dat
#-- End of file
which is great for a single file at a time.
Right now I have to perform this surgery on 19 986 files, which is in one
place.
Using the script above would take me over 20 000 hours.
Any way I can grab the files one at the time based on a ls command, and
invoke
the script, and to end up when the last file has been processed.
ALTERNATIVE:
Each file contains the IP address which has to move into the first
position
after a string on line 13 which you guessed it: is called 'IP Address:'.
Is
their a way vi could be used to achieve the same result?
Any input would be appreciated,
Johan Muller
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johan Muller
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mustafa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Tuning question - Why did this index help so much?
The other week a new production process was running much more slowly than anticipated. A file needed to be sent out by 6:00pm and at the rate the table was being populated it wouldn't complete until around 9:30pm. The production people and developers came to me for help and I saw that the SQL Explain Plan that was usually being executed (this would run a few million times) was something like select a.col1,a.col2,a.col3,b.col2 from a, b where a.col4=b.col1 and a.col5=:b1 nested loops table a index a1 (unique) table b index b1 (range) This looked pretty good, but it occurred to me that only one column was being selected from table b, so if I added a index (b2) that combined col1 and col2 to table b then it wouldn't be necessary to read table b at all, all the information would be in index b2. This resulted in a plan of: nested loops table a index a1 (unique) index b1 (range) I did so on the fly (this was only a 4,000 row table so it took almost no time to create the index). I anticipated that it would cut about 25% off the processing time (only 3/4 as many block reads). Instead it cut about 75% off the processing time causing it to finish at 5:45 (I was a hero to the developers and production people, but had to warn them not to tell their management about it since I could get in trouble for not following the Change Control Process). My question is, where did the additional 50% efficiency come from? What am I missing? I'm glad it worked so well, but would like to understand why... -- 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).
RE: OT, WOW really early
What is required to submit a paper/presentation to IOUGA and get excepted. Christopher R. Spence Why Chris? Were you excepted? ;) Jared Christopher Spence To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cspence@FuelS cc: pot.com Subject: RE: OT, WOW really early Sent by: [EMAIL PROTECTED] om 07/25/01 06:45 AM Please respond to ORACLE-L What is required to submit a paper/presentation to IOUGA and get excepted. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 24, 2001 8:41 PM To: Multiple recipients of list ORACLE-L IOUG 2002 call for papers already. Submit your presentation via the IOUG-A Web site at http://www.ioug.org/call-m no later than FRIDAY, SEPTEMBER 14, 2001. Mini Lesson and Technical Session presenters receive complimentary registration at IOUG-A Live! 2002 when your abstract is chosen! New for 2002 - Quick Tips! Share your unique and valuable tips during these new 30-minute presentations. Quick Tips provide great experience for first time presenters and allow experienced presenters to get to the heart of the matter. This is a presentation only - papers are not required. Plus, receive a discount on the Early Bird registration rate! joe -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list
RE: Dangerous AIX Bug!
Ross, We're running 8162 OPS on AIX 4.3. Chat away... Durinda -Original Message- Sent: Wednesday, July 25, 2001 9:36 AM To: Multiple recipients of list ORACLE-L ...just kidding, thought that would get your attention. But seriously: does anyone out there use Oracle 8i on AIX 4.3 or 5L? I'd like to chat w/you if so. Thanks! - Ross p.s. hmmm...maybe there *is* a bug in AIX and that's one of the things I'll learn:-) -Original Message- Sent: Tuesday, July 10, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Ron, I've attached one that I also got from the list some time ago, you may need to use something like bablefish to translate the comments :) HTH Mark -Original Message- L. Sent: Tuesday, July 10, 2001 02:32 To: Multiple recipients of list ORACLE-L Last week I was bit by a corrupt block on an index. I run Analyze every week which I found has been blowing up for some time due to the block corruption. Since Analyze does not create a log I did not know the Analyze was blowing up. Now I know that there are messages in the alert log that would have told me I had problems with the Analyze and the index. To make a long story short I need a good log scan script. Hopefully one that will work on Unix and NT. Mainly Unix. If anyone can help I would appreciate it. Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Durinda.Jones INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sun cluster vs Veritas cluster
We're using Sun Cluster 2.2 and a mix of VCS implementations, all on Solaris -- 2.6, 2.7 and 8. It seems likely our HP Service Guard will also migrate to VCS as well. The SC2.2 product has had more sensitivity to the Oracle version than the VCS product. It also seems to have more of its guts exposed, while VCS is better encapsulated in its GUI. I have no experience with SC3.0. We don't use OPS here yet, but it looks like Veritas has an option to support it; not sure if it's in the base VCS product or not -- knowing their $trategie$, it probably i$n't included in the ba$e package. Check out this URL to see the press release on VERITAS Database Edition/Advanced Cluster for Oracle that talks about supporting OPS: http://www.veritas.com/news/press/PressReleaseDetail.jhtml?NewsId=9436 :) sa -Original Message- Sent: Wednesday, July 25, 2001 4:37 AM To: Multiple recipients of list ORACLE-L We had a study made by a third party between Sun cluster and Veritas cluster both version 2.X and 3.x After that study, we have chosen Veritas cluster 2.x Sun Cluster 3 requires Solaris 8, all our boxes are on 7 and Sun Cluster 2.X doesn't handle T300 disk box which we have. Sun software doesn't handle all Sun hardware... --- KC [EMAIL PROTECTED] a écrit : Steve, Thanks for your input, I had previously used HP Service Guard on HP-UX platform, it worked for us. I am now on Sun platform and looking at HA solution using either Sun or Veritas clustering solution, I also heard that the older version of Sun clustering is not very sophisticated compared to other clustering solution, are you using 2.x or the latest 3.0, from what I read on Sun web site, v3.0 seems to do a lot more than the old version, any comments from the list?? The other things I need to check is rather OPS is supported with Veritas Cluster on Sun platform, anyone know?? KC -Original Message- From: Austin, Steve S [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, July 25, 2001 5:31 AM Subject: RE: Sun cluster vs Veritas cluster I have used both and somewhat prefer VCS. In both systems, we've had problems where the cluster was in an unknown state and any action to change the state was risky to all the services in the cluster. This is rare for both products. Our Sun support required for us to pay them to certify our stuff before they'd support the implementation. Don't know if you're subject to this too, but VCS has no such rule. The tests were interesting, but we could conduct the tests without their involvement. Command-line jocks may at first prefer Sun, but I think Veritas is a better bet since it's not as tied to the hardware vendor, and is more likely to be common across Unixes, if you're in a site where you've got more than one Unix vendor's stuff to support, like I am. We are in the process of migrating from Sun cluster to VCS, fyi. my 2¢ Steve -Original Message- From: KC [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 7:51 AM To: Multiple recipients of list ORACLE-L Subject: Sun cluster vs Veritas cluster List, Just wondering if anyone on the list who had experience on both Sun clustering and Veritas clustering software share their experience on both products, strength and weakness or any comparison?? KC = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
RE: OT, WOW really early
Yes, Big Blue-teeth. -Original Message- Sent: Wednesday, July 25, 2001 11:17 AM To: Multiple recipients of list ORACLE-L Oracle 9i XML Web Apps for Wireless ERP/CRM Support in Deep DB2/Siebel Territory Is that catchy enough? Something you can sink your blueteeth into? ;-) -Original Message- Sent: Wednesday, July 25, 2001 10:52 AM To: Multiple recipients of list ORACLE-L to submit a paper, you just need an idea, a title and an abstract. The abstract needs to be somewhat catchy, the idea should be relevant and something that might interest attendees (anything on version 6, Oracle7 or Oracle8 is not a good idea G). To be accepted (to be excepted would be to be left out or excluded, you can do THAT by not submitting an abstract) -- when you learn the secret please tell me. I believe that the selection is not blind -- in that the selection committee members know the name of the presenter for the abstracts they read. So speakers who have presented before and gotten good ratings will be most likely to be asked back. But there are always new speakers each year as well. Some people (like Gaja) are in the you have been accepted, now what are you presenting category, in that they are KNOWN to be excellent speakers who draw standing room only crowds in the largest rooms. Rachel From: Christopher Spence [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT, WOW really early Date: Wed, 25 Jul 2001 05:45:43 -0800 What is required to submit a paper/presentation to IOUGA and get excepted. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 24, 2001 8:41 PM To: Multiple recipients of list ORACLE-L IOUG 2002 call for papers already. Submit your presentation via the IOUG-A Web site at http://www.ioug.org/call-m no later than FRIDAY, SEPTEMBER 14, 2001. Mini Lesson and Technical Session presenters receive complimentary registration at IOUG-A Live! 2002 when your abstract is chosen! New for 2002 - Quick Tips! Share your unique and valuable tips during these new 30-minute presentations. Quick Tips provide great experience for first time presenters and allow experienced presenters to get to the heart of the matter. This is a presentation only - papers are not required. Plus, receive a discount on the Early Bird registration rate! joe -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet
Best way to upgrade database/move data
Hi DBAs, Currently I have NT server 4.0/Oracle 8.0.5 with about 400 million records/450 tables,indices,etc. We will be getting a new NT server with Oracle 8.1.7. We will increase block size from 2k to 8k What would be the best way to move data/users/sequences,etc from existing server to new server? Essentially replicate everything from old server to new server. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT, It's all about Alex
Alex, how did the paper/present go? -Original Message- Sent: Wednesday, July 25, 2001 10:42 AM To: Multiple recipients of list ORACLE-L Maybe some spelling errors in the abstract -:) Alex Hillman -Original Message- Sent: Wednesday, July 25, 2001 9:46 AM To: Multiple recipients of list ORACLE-L What is required to submit a paper/presentation to IOUGA and get excepted. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 24, 2001 8:41 PM To: Multiple recipients of list ORACLE-L IOUG 2002 call for papers already. Submit your presentation via the IOUG-A Web site at http://www.ioug.org/call-m no later than FRIDAY, SEPTEMBER 14, 2001. Mini Lesson and Technical Session presenters receive complimentary registration at IOUG-A Live! 2002 when your abstract is chosen! New for 2002 - Quick Tips! Share your unique and valuable tips during these new 30-minute presentations. Quick Tips provide great experience for first time presenters and allow experienced presenters to get to the heart of the matter. This is a presentation only - papers are not required. Plus, receive a discount on the Early Bird registration rate! joe -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Sun cluster vs Veritas cluster
Austin, Steve Hey, didn't I see you on Monday Night Raw and Smackdown?? :o) -Original Message- Sent: Wednesday, July 25, 2001 10:26 AM To: Multiple recipients of list ORACLE-L We're using Sun Cluster 2.2 and a mix of VCS implementations, all on Solaris -- 2.6, 2.7 and 8. It seems likely our HP Service Guard will also migrate to VCS as well. The SC2.2 product has had more sensitivity to the Oracle version than the VCS product. It also seems to have more of its guts exposed, while VCS is better encapsulated in its GUI. I have no experience with SC3.0. We don't use OPS here yet, but it looks like Veritas has an option to support it; not sure if it's in the base VCS product or not -- knowing their $trategie$, it probably i$n't included in the ba$e package. Check out this URL to see the press release on VERITAS Database Edition/Advanced Cluster for Oracle that talks about supporting OPS: http://www.veritas.com/news/press/PressReleaseDetail.jhtml?NewsId=9436 :) sa -Original Message- Sent: Wednesday, July 25, 2001 4:37 AM To: Multiple recipients of list ORACLE-L We had a study made by a third party between Sun cluster and Veritas cluster both version 2.X and 3.x After that study, we have chosen Veritas cluster 2.x Sun Cluster 3 requires Solaris 8, all our boxes are on 7 and Sun Cluster 2.X doesn't handle T300 disk box which we have. Sun software doesn't handle all Sun hardware... --- KC [EMAIL PROTECTED] a écrit : Steve, Thanks for your input, I had previously used HP Service Guard on HP-UX platform, it worked for us. I am now on Sun platform and looking at HA solution using either Sun or Veritas clustering solution, I also heard that the older version of Sun clustering is not very sophisticated compared to other clustering solution, are you using 2.x or the latest 3.0, from what I read on Sun web site, v3.0 seems to do a lot more than the old version, any comments from the list?? The other things I need to check is rather OPS is supported with Veritas Cluster on Sun platform, anyone know?? KC -Original Message- From: Austin, Steve S [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, July 25, 2001 5:31 AM Subject: RE: Sun cluster vs Veritas cluster I have used both and somewhat prefer VCS. In both systems, we've had problems where the cluster was in an unknown state and any action to change the state was risky to all the services in the cluster. This is rare for both products. Our Sun support required for us to pay them to certify our stuff before they'd support the implementation. Don't know if you're subject to this too, but VCS has no such rule. The tests were interesting, but we could conduct the tests without their involvement. Command-line jocks may at first prefer Sun, but I think Veritas is a better bet since it's not as tied to the hardware vendor, and is more likely to be common across Unixes, if you're in a site where you've got more than one Unix vendor's stuff to support, like I am. We are in the process of migrating from Sun cluster to VCS, fyi. my 2¢ Steve -Original Message- From: KC [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 7:51 AM To: Multiple recipients of list ORACLE-L Subject: Sun cluster vs Veritas cluster List, Just wondering if anyone on the list who had experience on both Sun clustering and Veritas clustering software share their experience on both products, strength and weakness or any comparison?? KC = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Patch Level
How could we check patch level(like c,d etc) for AP module. We are running Oracle Financials 10.7 char with database 7.3.4.5. TIA MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback Segment Question
Kamel, Looks like you may have had multiple transactions in your PL/SQL prg. Since one transaction ended, the slot used by it to store undo information was reused by other transactions. Your query did not find the required undo information and thus Snapshot too old error. Had this been a long running transaction then more extents would have been automatically allocated. My best guess is that you were updating the table that you were querying. Its best in a situation like that to(if possible) avoid reading from the table that you are updating, else do what you did, i.e. pre-allocate extents. HTH Shailesh -Original Message- Sent: Wednesday, July 25, 2001 11:51 AM To: Multiple recipients of list ORACLE-L Hi All I had a long PL/SQL prg to run . I created a special rollback segment for that script with the storage of (initial 1 m next 1m minextents 2). After a few minutes of running I got the Snapshot too old error. In the v_$rollstat view I got : extents=2, rssize ~ 2 M, hwmsize ~ 2 M. I recreated the RBS with minextents 100, at this time my program run succefully. My question is why in the first case the RBS didn't growth automatically by allocating a new extents until maxetents value ? Thank you Best Regards Kamel Benlatreche -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yadav, Shailesh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: both dbms_stats dbms_utility are gathering stats on sys obj
Yep. That's what we do also.
-Original Message-
Sent: Tuesday, July 24, 2001 8:51 PM
To: Multiple recipients of list ORACLE-L
objects
Well, first of all, you could use dbms_utility.analyze_schema() and analyze
all the schemas except SYS ... or couldn't you run
dbms_utility.analyze_database() and then
dbms_utility.analyze_schema('SYS','DELETE') to remove SYS's stats. What
about one of those?
Jon Walthour
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 24, 2001 3:55 PM
Both DBMS_STATS.GATHER_DATABASE_STATS and DBMS_UTILITY.ANALYZE_DATABASE
are
gathering statistics on sys objects. As per oracle, we shouldn't analyze
the objects owned by sys.
When I searched on metalink, I found the following information provided by
oracle tech support.
filed bug 969814 against DBMS_UTILITY.ANALYZE_DATABASE which was not
excluding these tables.
This bug is fixed in 8.1.7.
I did my tests on 8.1.7 database on hp-ux. Apparently it is not fixed on
8.1.7.0.0.
Is it fixed in later releases? I appreciate your comments.
Best regards,
Prasad
--
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: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). 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).
Looking for a tool
Dear friends ! I'm desperately looking for a reporting tool with the following characteristics. It should be able to deploy various types of charts (Bar, Column, Line, Pie etc.) to a web environment. It should be able to extract its raw data from an Oracle (or other) RDBMS , using SQL. It should have some kind of a graph design tools, so new reports could be easily deployed through the help of report templates. Different filters should be applied to a report (i.e.: Specific ISP on specific date range). Aggregation reports should be available (Could be done by SQL aggregation). It should support displaying the data as both graph and tables. It should be platform independent (i.e. Could run on NT, Win2000, Solaris). The component should be database independent (Should be able to extract data from RDBMS like Oracle, DB2, MS-SQL). The component should be able to run from Tomcat/Apache as well as Macromedia JRun and BEA Weblogic. The component could be integrated and called from a web system Preferably, the component could have a Java API. I have tried to search all the known serach engines with no results. Please advice ! Thanks a lot -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Best way to upgrade database/move data
Your best way is to do a full export of the 8.0.5 data and import it into the new 8.1.7 database. Hope this helps, Defry - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 25, 2001 12:02 PM Hi DBAs, Currently I have NT server 4.0/Oracle 8.0.5 with about 400 million records/450 tables,indices,etc. We will be getting a new NT server with Oracle 8.1.7. We will increase block size from 2k to 8k What would be the best way to move data/users/sequences,etc from existing server to new server? Essentially replicate everything from old server to new server. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mustafa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: statement for directory objects
Hello again, Before sending this email,I have done some intents to get this information. One of this was through this view (user_objects) but there is no object directories in it. The way in which I have created it is 'create directory XX AS 'E:\XXX';, and I get no error, the one I think is the correct one. I have made inserted too a parameter in the init.ora file 'UTL_FILE_DIR', but with no luck. Could somebody give me any idea? Am I doing anything wrong? A lot of thanks again Gogala, Mladen wrote: select * from user_objects; -Original Message- From: Beatriz Martínez Jiménez [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Subject: statement for directory objects Hello List, I would like to know any statement to know which 'object directory' exists in the oracle instance, for a specified user. TIA, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:Jimenez;Beatriz Martinez x-mozilla-html:FALSE org:Fundación CIDAUT;Departamento de Informática adr:;;Parque Tecnológico de Boecillo p.209;Boecillo;Valladolid;47151;Spain version:2.1 email;internet:[EMAIL PROTECTED] title:Ingeniera Informática fn:Beatriz Martínez Jiménez end:vcard
Re: Tuning question - Why did this index help so much?
it's possible that the index was small enough to stay cached in the SGA? From: Miller, Jay [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Tuning question - Why did this index help so much? Date: Wed, 25 Jul 2001 08:31:28 -0800 The other week a new production process was running much more slowly than anticipated. A file needed to be sent out by 6:00pm and at the rate the table was being populated it wouldn't complete until around 9:30pm. The production people and developers came to me for help and I saw that the SQL Explain Plan that was usually being executed (this would run a few million times) was something like select a.col1,a.col2,a.col3,b.col2 from a, b where a.col4=b.col1 and a.col5=:b1 nested loops table a index a1 (unique) table b index b1 (range) This looked pretty good, but it occurred to me that only one column was being selected from table b, so if I added a index (b2) that combined col1 and col2 to table b then it wouldn't be necessary to read table b at all, all the information would be in index b2. This resulted in a plan of: nested loops table a index a1 (unique) index b1 (range) I did so on the fly (this was only a 4,000 row table so it took almost no time to create the index). I anticipated that it would cut about 25% off the processing time (only 3/4 as many block reads). Instead it cut about 75% off the processing time causing it to finish at 5:45 (I was a hero to the developers and production people, but had to warn them not to tell their management about it since I could get in trouble for not following the Change Control Process). My question is, where did the additional 50% efficiency come from? What am I missing? I'm glad it worked so well, but would like to understand why... -- 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/intl.asp -- 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:RE: Data load options
Truncation was the solution in this case as I observed in the past that direct load option use empty blocks above HWM thus using lot of space above it. If it is possible target table should be truncated before such loads... Regards MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 25 Jul 2001 07:03:22 -0800 Lisa, SQL*Loader in direct path can cause you storage problems since it always appends to the table(s) ignoring blocks on the free block list. I found that out after a developer was using it for our data warehouse. At the end of a year he had burned almost 100GB of disk it kept increasing even though he was trying to keep only a rolling 180 window. On a hunch we exported the data, truncated the table imported the data back in. The amount of tablespace being used dropped 50%. Dick Goulet Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 7/25/2001 6:26 AM Hi Sean, Others have given you different options. Here's some considerations: 1. SQL Script. * Can be SLOW * May require intermittent commits in your script * Manual and error prone * Must go through SQL engine 2. SQL Loader * Can be very fast (direct - bypassing SQL engine). * Direct path load will invalidate indexes. * You can keep track of rejected records easily (.bad file) * Dependent upon your file format being EXACT, no errors. 3. Import * Requires minimal manual fiddling * Can be very slow - I once imported 150GB and it took ~3 days * Does not seamlessly handle all object types (INtermedia (domain) indexes is one example) * Restarting an import will take a lot longer. If your import fails, be sure and truncate/drop all tables before starting again. * Have the option of not including indexes (INDEXES=N) * Can also reset your storage parms prior to import (export with data=n, edit file [SSSHHH] and enter new storage parms / import, export with data=y, import data with IGNORE=Y) I'm sure others will have additional considerations to share. My choice has always been exp/imp. Lisa Koivu The Vicodin-enhanced DBA Ft. Lauderdale, FL, USA -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L Subject: Data load options I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=US-ASCII META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12 TITLERE: Data load options/TITLE /HEAD BODY PFONT COLOR=#FF SIZE=2 FACE=ArialHi Sean, /FONT /P PFONT COLOR=#FF SIZE=2 FACE=ArialOthers have given you different options.nbsp; Here's some considerations:/FONT /P PFONT COLOR=#FF SIZE=2 FACE=Arial1.nbsp; SQL Script. /FONT ULLIFONT COLOR=#FF SIZE=2 FACE=ArialCan be SLOW /FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialMay require intermittent commits in your script/FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialManual and error prone/FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialMust go through SQL engine/FONT/LI BR /UL PFONT COLOR=#FF SIZE=2 FACE=Arial2.nbsp; SQL Loader/FONT ULLIFONT COLOR=#FF SIZE=2 FACE=ArialCan be very fast (direct - bypassing SQL engine). /FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialDirect path load will invalidate indexes. /FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialYou can keep track of rejected records easily (.bad file)/FONT/LI LIFONT
RE: books on data modelling
I've seen some data models where the only book they read was probably How To Smoke A Big Fat Pipe O' Crack. About the only book I've actually needed was Korth's Database System Concepts - all the rest of the knowledge needed is application-domain specific, for example, understanding how the real-world processes that use your data work. g -Original Message- Sent: Tuesday, July 24, 2001 5:57 PM To: Multiple recipients of list ORACLE-L Hello All, I have been in the lookout for a good and comprehensive book on data modelling so that I can enhance my knowledge in this area. I am not finding anything related in online Oracle documentation. Please suggest me.. Thanks in Advance, Suren -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 files the busiest
The fact that you see the same busy file from your script as Jon's script shows is merely coincidence. Consider the output with varying levels of read and write activity. Jon's approach is more correct. Jared Viraj Luthra viraj999@lyco To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] s.com cc: Sent by: Subject: Re: data files the busiest [EMAIL PROTECTED] om 07/24/01 08:25 PM Please respond to ORACLE-L Jon, well your script also gives me the same busy file. and I am showing the physical reads also, see my script below. I can see from my script, the same busy data file as I see from yours, it is just that I have to compare the 2 figures, that is f.phyrds, f.phywrts. From my script I get :- /u01/app/oracle/product/8.1.5/dbs/oradata/orcl815/users01.dbf 995671 14940 /u01/app/oracle/product/8.1.5/dbs/oradata/orcl815/system01.dbf 116510 271329 which shows the order of busy from least to the max. and the difference between the 2 f.phyrds, f.phywrts, shows me. From your script I get:- /u01/app/oracle/product/8.1.5/dbs/oradata/orcl815/users01.dbf 1002657 71.61 /u01/app/oracle/product/8.1.5/dbs/oradata/orcl815/system01.dbf 387046 27.64 So I think I am okay then??? rgds, raja -- On Tue, 24 Jul 2001 18:20:43 Jon Walthour wrote: Raja: Your query is on the right track, but it only accounts for the physical writes, not the physical reads. Try the attached script. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 24, 2001 9:50 PM Hello all, If I want to know which data files are the busiest, can I assume that from the following query:- SELECT SUBSTR(name, 1, 128), f.phyrds, f.phywrts FROM v$datafile d, v$filestat f WHERE f.file# = d.file# ORDER BY phywrts If there is vast difference between the physical reads and physical writes, then that particular data file would be the busiest? Is this true? rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP
Re: Data load options
Title: RE: Data load options It's a pain-killer: http://www.painmanagementsolutions.com/products/vicodin/vicodin.html BTW, in the US, a lot of Hollywood stars are in rehab due to the addictive effects of this drug. Defry - Original Message - From: Robertson Lee - lerobe To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 25, 2001 11:25 AM Subject: RE: Data load options Cheers John, I wason the verge of asking myself -Original Message-From: Hallas John [mailto:[EMAIL PROTECTED]]Sent: 25 July 2001 15:57To: Multiple recipients of list ORACLE-LSubject: RE: Data load options Go on then Lisa, I rise to the challenge For us UK based listers what is Vicodin? John -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: 25 July 01 15:26To: Multiple recipients of list ORACLE-LSubject: RE: Data load options Hi Sean, Others have given you different options. Here's some considerations: 1. SQL Script. Can be SLOW May require intermittent commits in your script Manual and error prone Must go through SQL engine 2. SQL Loader Can be very fast (direct - bypassing SQL engine). Direct path load will invalidate indexes. You can keep track of rejected records easily (.bad file) Dependent upon your file format being EXACT, no errors. 3. Import Requires minimal manual fiddling Can be very slow - I once imported 150GB and it took ~3 days Does not seamlessly handle all object types (INtermedia (domain) indexes is one example) Restarting an import will take a lot longer. If your import fails, be sure and truncate/drop all tables before starting again. Have the option of not including indexes (INDEXES=N) Can also reset your storage parms prior to import (export with data=n, edit file [SSSHHH] and enter new storage parms / import, export with data=y, import data with IGNORE=Y) I'm sure others will have additional considerations to share. My choice has always been exp/imp. Lisa Koivu The Vicodin-enhanced DBA Ft. Lauderdale, FL, USA -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L Subject: Data load options I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited.Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally
RE: version
Rukmini, select * from V$version Baskar -Original Message- Sent: 22 July 2001 17:17 To: Multiple recipients of list ORACLE-L Hi All, How can we find what version of oracle (standard/enterprise/workgroup) is running in the system. Is there any view/table ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramasamy, Baskar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 load options
At least she didn't have a commit after every insert and ask you to tune the database ;) Denny [EMAIL PROTECTED] wrote: I will second Lisa's recommendations. If you have much data, and/or will be doing this frequently, SQL*Loader is your friend. It is very fast. Loading from a SQL script is very bad unless you have small amounts of data. I once worked with a duhveloper who could not be dissuaded from loading all data from SQL scripts. We're talking millions of rows here. A single 10 gigabyte SQL script of insert statements. She single handedly brought our DW to it's knee's. It begged for mercy. There was none. Duhveloper was fired. :) Jared _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
effect of Initial and Next exents...
Hi Friends I obsered in my big database Tables and Indexes set different Initial and next extents..So How it will effect on performance?? Suppose one my big table has initial 72Mb and next 245Mb..All big indexes(6Gb) was set low Initial and next around 245Mb..Any ideas about the performance and rectification??... TIA Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: re-archiving a redo log file
Title: re-archiving a redo log file I don't think, it's possible. Most probably it checks 'archived' column in v$log. Also, it keeps track of archived files in v$archived_log. Igor - Original Message - From: Adams, Matthew (GEA, 088130) To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 25, 2001 11:55 AM Subject: re-archiving a redo log file Is it possible to re-archive an already archived but still online redo log file? the 8.1.6 sql*plus manual says it is, but I can't get the syntax down right apparently. SQL archive log 227 returns a ORA-16013 (does not need archiving) error and SQL archive log 227 to '/tmp' returns SP2-0718 illegal arhicve log option Anybody done this? Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl)
UNIX command
Hi gurus Which command is for to see disk layout in sun cluster and veritas cluster on sun solaris. Thanks in advance. -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
this option is not set so i assume default is OFF... any other clue... -Original Message- Sent: Wednesday, July 25, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Check the client's sqlnet.ora. It can override the server config with USE_DEDICATED_SERVER=ON setting. Steve -Original Message- Sent: Wednesday, July 25, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Hi, I have configured the server to use MTS and still dedicated connections r used. What might be the reasondatabase is 8.1.6.3.4 LSNRCTL services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) ora2000 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DEDICATED SERVER established:76 refused:0 LOCAL SERVER The command completed successfully init.ora looks like: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder 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: Looking for a tool
Discoverer 9i the demo at ODTUG was capable of doing almost everything that you mention here. Only two problems ... 1. works with Oracle only (AFAIK) 2. It is not available yet (last time I saw, it wasn't). Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tuning question - Why did this index help so much?
Kirti made a similar suggestion. But I had done a select count(*) on the table so that all the table rows would be loaded into memory. I suppose that the index blocks might not have been, but even there the likelihood that any given one of the million plus reads wouldn't find one of the 4,000 rows in memory seems rather small. Hmm, is it possible to Cache an index? I just tried an ALTER INDEX xxx CACHE; command and it didn't work. Jay Miller -Original Message- Sent: Wednesday, July 25, 2001 12:57 PM To: Multiple recipients of list ORACLE-L it's possible that the index was small enough to stay cached in the SGA? From: Miller, Jay [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Tuning question - Why did this index help so much? Date: Wed, 25 Jul 2001 08:31:28 -0800 The other week a new production process was running much more slowly than anticipated. A file needed to be sent out by 6:00pm and at the rate the table was being populated it wouldn't complete until around 9:30pm. The production people and developers came to me for help and I saw that the SQL Explain Plan that was usually being executed (this would run a few million times) was something like select a.col1,a.col2,a.col3,b.col2 from a, b where a.col4=b.col1 and a.col5=:b1 nested loops table a index a1 (unique) table b index b1 (range) This looked pretty good, but it occurred to me that only one column was being selected from table b, so if I added a index (b2) that combined col1 and col2 to table b then it wouldn't be necessary to read table b at all, all the information would be in index b2. This resulted in a plan of: nested loops table a index a1 (unique) index b1 (range) I did so on the fly (this was only a 4,000 row table so it took almost no time to create the index). I anticipated that it would cut about 25% off the processing time (only 3/4 as many block reads). Instead it cut about 75% off the processing time causing it to finish at 5:45 (I was a hero to the developers and production people, but had to warn them not to tell their management about it since I could get in trouble for not following the Change Control Process). My question is, where did the additional 50% efficiency come from? What am I missing? I'm glad it worked so well, but would like to understand why... -- 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/intl.asp -- 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: 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).
Re: Looking for a tool
Hi Andrey, Try Cognos. http://www.cognos.com/ HTH, -Rocky --- Andrey Bronfin [EMAIL PROTECTED] wrote: Dear friends ! I'm desperately looking for a reporting tool with the following characteristics. It should be able to deploy various types of charts (Bar, Column, Line, Pie etc.) to a web environment. It should be able to extract its raw data from an Oracle (or other) RDBMS , using SQL. It should have some kind of a graph design tools, so new reports could be easily deployed through the help of report templates. Different filters should be applied to a report (i.e.: Specific ISP on specific date range). Aggregation reports should be available (Could be done by SQL aggregation). It should support displaying the data as both graph and tables. It should be platform independent (i.e. Could run on NT, Win2000, Solaris). The component should be database independent (Should be able to extract data from RDBMS like Oracle, DB2, MS-SQL). The component should be able to run from Tomcat/Apache as well as Macromedia JRun and BEA Weblogic. The component could be integrated and called from a web system Preferably, the component could have a Java API. I have tried to search all the known serach engines with no results. Please advice ! Thanks a lot -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.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: Tuning question - Why did this index help so much?
I think it's because the optimizxer did not have to go to the table b to satisfy the query - it went to the index only. does this make sense? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 25, 2001 12:57 PM To: Multiple recipients of list ORACLE-L it's possible that the index was small enough to stay cached in the SGA? From: Miller, Jay [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Tuning question - Why did this index help so much? Date: Wed, 25 Jul 2001 08:31:28 -0800 The other week a new production process was running much more slowly than anticipated. A file needed to be sent out by 6:00pm and at the rate the table was being populated it wouldn't complete until around 9:30pm. The production people and developers came to me for help and I saw that the SQL Explain Plan that was usually being executed (this would run a few million times) was something like select a.col1,a.col2,a.col3,b.col2 from a, b where a.col4=b.col1 and a.col5=:b1 nested loops table a index a1 (unique) table b index b1 (range) This looked pretty good, but it occurred to me that only one column was being selected from table b, so if I added a index (b2) that combined col1 and col2 to table b then it wouldn't be necessary to read table b at all, all the information would be in index b2. This resulted in a plan of: nested loops table a index a1 (unique) index b1 (range) I did so on the fly (this was only a 4,000 row table so it took almost no time to create the index). I anticipated that it would cut about 25% off the processing time (only 3/4 as many block reads). Instead it cut about 75% off the processing time causing it to finish at 5:45 (I was a hero to the developers and production people, but had to warn them not to tell their management about it since I could get in trouble for not following the Change Control Process). My question is, where did the additional 50% efficiency come from? What am I missing? I'm glad it worked so well, but would like to understand why... -- 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/intl.asp -- 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: books on data modelling
I haven't yet seen a reference to David Hay's 'Data Model Patterns : Conventions of Thought'. If you haven't read and understood it, then sorry, you don't know data modeling. http://www.amazon.com/exec/obidos/ASIN/0932633293/qid=996081527/sr=2-1/ref=aps_sr_b_1_1/104-1357679-6149513 'A Practical Guide to Logical Data Modeling' by George Tillman is also an excellent book. It will help you appreciate the importance of Data Modeling. http://www.amazon.com/exec/obidos/ASIN/0070646155/qid=996081625/sr=1-4/ref=sc_b_4/104-1357679-6149513 It also contains one of my favorite IT quotes. To paraphrase: 'The reason that there is such a great need for Data Modelers is because developers are so bad at it.' You'll have to read the book to get the non-paraphrased version. Jared Guy Hammond guy.hammond@a To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] vt.co.ukcc: Sent by: Subject: RE: books on data modelling [EMAIL PROTECTED] om 07/25/01 09:50 AM Please respond to ORACLE-L I've seen some data models where the only book they read was probably How To Smoke A Big Fat Pipe O' Crack. About the only book I've actually needed was Korth's Database System Concepts - all the rest of the knowledge needed is application-domain specific, for example, understanding how the real-world processes that use your data work. g -Original Message- Sent: Tuesday, July 24, 2001 5:57 PM To: Multiple recipients of list ORACLE-L Hello All, I have been in the lookout for a good and comprehensive book on data modelling so that I can enhance my knowledge in this area. I am not finding anything related in online Oracle documentation. Please suggest me.. Thanks in Advance, Suren -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data load options
I forgot to add: there was a commit for every 1000 rows. Jared Denny Koovakattu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] denny_vk@yaho cc: o.com Subject: Re: Data load options Sent by: [EMAIL PROTECTED] om 07/25/01 10:16 AM Please respond to ORACLE-L At least she didn't have a commit after every insert and ask you to tune the database ;) Denny [EMAIL PROTECTED] wrote: I will second Lisa's recommendations. If you have much data, and/or will be doing this frequently, SQL*Loader is your friend. It is very fast. Loading from a SQL script is very bad unless you have small amounts of data. I once worked with a duhveloper who could not be dissuaded from loading all data from SQL scripts. We're talking millions of rows here. A single 10 gigabyte SQL script of insert statements. She single handedly brought our DW to it's knee's. It begged for mercy. There was none. Duhveloper was fired. :) Jared _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: 4 drives, 2 controller ( 3 drives on the SAME controller !)
Rahul, The 3 drives are sharing the controller and are daisy-chained. An IBM CE can reroute the cables, and depending on what's currently there, you *may* need to purchase cables/end connectors. Since you have the same Wide SCSI adapters/drives, this is less complicated than it could have been.. So how goes it with Wahid and all the trouble brewing out there? John Kanagaraj -Original Message- From: Rahul [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 1:45 AM To: Multiple recipients of list ORACLE-L Subject: 4 drives, 2 controller ( 3 drives on the SAME controller !) list, in my rs/6000, i found the following... # lsdev -Cc adapter ascsi0 Available 00-06Wide SCSI I/O Controller Adapter ascsi1 Available 00-07Wide SCSI I/O Controller Adapter # lsdev -Cc disk hdisk0 Available 00-06-B1-2,0 16 Bit SCSI Disk Drive hdisk1 Available 00-07-A1-3,0 16 Bit SCSI Disk Drive hdisk2 Available 00-07-A1-4,0 16 Bit SCSI Disk Drive hdisk3 Available 00-07-A1-5,0 16 Bit SCSI Disk Drive from the above i can conclude that adapter 06 is controlling hdisk0 and adapter 07 is controlling the other 3 drives.. if the above deduction is correct , then all the three drives are sharing the same IO channel , right ? what kind of effort is required to ammend the above config ? ( TWO drives on ONE controller ) Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: statement for directory objects
You should be able to see the one you created in dba_directories: select * from dba_directories; Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 25, 2001 1:10 PM Hello again, Before sending this email,I have done some intents to get this information. One of this was through this view (user_objects) but there is no object directories in it. The way in which I have created it is 'create directory XX AS 'E:\XXX';, and I get no error, the one I think is the correct one. I have made inserted too a parameter in the init.ora file 'UTL_FILE_DIR', but with no luck. Could somebody give me any idea? Am I doing anything wrong? A lot of thanks again Gogala, Mladen wrote: select * from user_objects; -Original Message- From: Beatriz Martínez Jiménez [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Subject: statement for directory objects Hello List, I would like to know any statement to know which 'object directory' exists in the oracle instance, for a specified user. TIA, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: books on data modelling
but you haven't lived until David Hay has made an origami animal for you :) From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: books on data modelling Date: Wed, 25 Jul 2001 10:28:37 -0800 I haven't yet seen a reference to David Hay's 'Data Model Patterns : Conventions of Thought'. If you haven't read and understood it, then sorry, you don't know data modeling. http://www.amazon.com/exec/obidos/ASIN/0932633293/qid=996081527/sr=2-1/ref=aps_sr_b_1_1/104-1357679-6149513 'A Practical Guide to Logical Data Modeling' by George Tillman is also an excellent book. It will help you appreciate the importance of Data Modeling. http://www.amazon.com/exec/obidos/ASIN/0070646155/qid=996081625/sr=1-4/ref=sc_b_4/104-1357679-6149513 It also contains one of my favorite IT quotes. To paraphrase: 'The reason that there is such a great need for Data Modelers is because developers are so bad at it.' You'll have to read the book to get the non-paraphrased version. Jared Guy Hammond guy.hammond@a To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] vt.co.ukcc: Sent by: Subject: RE: books on data modelling [EMAIL PROTECTED] om 07/25/01 09:50 AM Please respond to ORACLE-L I've seen some data models where the only book they read was probably How To Smoke A Big Fat Pipe O' Crack. About the only book I've actually needed was Korth's Database System Concepts - all the rest of the knowledge needed is application-domain specific, for example, understanding how the real-world processes that use your data work. g -Original Message- Sent: Tuesday, July 24, 2001 5:57 PM To: Multiple recipients of list ORACLE-L Hello All, I have been in the lookout for a good and comprehensive book on data modelling so that I can enhance my knowledge in this area. I am not finding anything related in online Oracle documentation. Please suggest me.. Thanks in Advance, Suren -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
A couple of things I would check. I don't believe you need the ADDRESS_LIST parameter, unless you will have multiples. I would remove the spaces in the parameter. I would make sure that the HOST equals the machine name, possibly make the entry upper case. As foolish as it sounds, I've seen these things make a difference. Set it up to look like this and see if it helps. LOCAL_LISTENER = (Address=(Protocol=TCP)(Host=ORA2000)(Port=1521)) I recently had a problem where the HOST wasn't the same as the machine name. Fixed that and the problem went away. Hope this helps out, Durinda -Original Message- Sent: Wednesday, July 25, 2001 1:11 PM To: Multiple recipients of list ORACLE-L this option is not set so i assume default is OFF... any other clue... -Original Message- Sent: Wednesday, July 25, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Check the client's sqlnet.ora. It can override the server config with USE_DEDICATED_SERVER=ON setting. Steve -Original Message- Sent: Wednesday, July 25, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Hi, I have configured the server to use MTS and still dedicated connections r used. What might be the reasondatabase is 8.1.6.3.4 LSNRCTL services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) ora2000 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DEDICATED SERVER established:76 refused:0 LOCAL SERVER The command completed successfully init.ora looks like: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: re-archiving a redo log file
Hmm, would it work to do an OS level copy so long as you get to the redo log before it starts being written to again? Just a random thought... -Original Message- Sent: Wednesday, July 25, 2001 12:42 PM To: Multiple recipients of list ORACLE-L I don't think, it's possible. Most probably it checks 'archived' column in v$log. Also, it keeps track of archived files in v$archived_log. Igor - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Wednesday, July 25, 2001 11:55 AM Is it possible to re-archive an already archived but still online redo log file? the 8.1.6 sql*plus manual says it is, but I can't get the syntax down right apparently. SQL archive log 227 returns a ORA-16013 (does not need archiving) error and SQL archive log 227 to '/tmp' returns SP2-0718 illegal arhicve log option Anybody done this? Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -- 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).
OT -- RE: Sun cluster vs Veritas cluster
You're showing your age. ;) I'm more akin the the $6.0 E+06 homo sapien. You know, a man barely alive; we have the technology, blahblahblah -- all that Six Million Dollar Man stuff (whose character was -also- Steve Austin for those who haven't caught it in reruns). It's amazing how much of that junk actually applies in this weird wired world. You wouldn't believe the bionic things my classmates teased me for doing in 4th grade when that show came out in the 70s! Since the wrassler has also made fame with *my* name, I've received phone calls from all over the world (I live in Dallas, TX.) The worst was from a fellow in Japan who could speak four languages, but none of them English, Spanish or French. The best I could do was say No over and over again. Sad. Now my number is unlisted and life is better. Some of my more twisted friends said I should offer to sell signed photographs, cash only. I already have enough karma, so I was straightfoward with all the kiddos. :) sa -Original Message- Sent: Wednesday, July 25, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Austin, Steve Hey, didn't I see you on Monday Night Raw and Smackdown?? :o) -Original Message- Sent: Wednesday, July 25, 2001 10:26 AM To: Multiple recipients of list ORACLE-L We're using Sun Cluster 2.2 and a mix of VCS implementations, all on Solaris -- 2.6, 2.7 and 8. It seems likely our HP Service Guard will also migrate to VCS as well. The SC2.2 product has had more sensitivity to the Oracle version than the VCS product. It also seems to have more of its guts exposed, while VCS is better encapsulated in its GUI. I have no experience with SC3.0. We don't use OPS here yet, but it looks like Veritas has an option to support it; not sure if it's in the base VCS product or not -- knowing their $trategie$, it probably i$n't included in the ba$e package. Check out this URL to see the press release on VERITAS Database Edition/Advanced Cluster for Oracle that talks about supporting OPS: http://www.veritas.com/news/press/PressReleaseDetail.jhtml?NewsId=9436 :) sa -Original Message- Sent: Wednesday, July 25, 2001 4:37 AM To: Multiple recipients of list ORACLE-L We had a study made by a third party between Sun cluster and Veritas cluster both version 2.X and 3.x After that study, we have chosen Veritas cluster 2.x Sun Cluster 3 requires Solaris 8, all our boxes are on 7 and Sun Cluster 2.X doesn't handle T300 disk box which we have. Sun software doesn't handle all Sun hardware... --- KC [EMAIL PROTECTED] a écrit : Steve, Thanks for your input, I had previously used HP Service Guard on HP-UX platform, it worked for us. I am now on Sun platform and looking at HA solution using either Sun or Veritas clustering solution, I also heard that the older version of Sun clustering is not very sophisticated compared to other clustering solution, are you using 2.x or the latest 3.0, from what I read on Sun web site, v3.0 seems to do a lot more than the old version, any comments from the list?? The other things I need to check is rather OPS is supported with Veritas Cluster on Sun platform, anyone know?? KC -Original Message- From: Austin, Steve S [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, July 25, 2001 5:31 AM Subject: RE: Sun cluster vs Veritas cluster I have used both and somewhat prefer VCS. In both systems, we've had problems where the cluster was in an unknown state and any action to change the state was risky to all the services in the cluster. This is rare for both products. Our Sun support required for us to pay them to certify our stuff before they'd support the implementation. Don't know if you're subject to this too, but VCS has no such rule. The tests were interesting, but we could conduct the tests without their involvement. Command-line jocks may at first prefer Sun, but I think Veritas is a better bet since it's not as tied to the hardware vendor, and is more likely to be common across Unixes, if you're in a site where you've got more than one Unix vendor's stuff to support, like I am. We are in the process of migrating from Sun cluster to VCS, fyi. my 2¢ Steve -Original Message- From: KC [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 7:51 AM To: Multiple recipients of list ORACLE-L Subject: Sun cluster vs Veritas cluster List, Just wondering if anyone on the list who had experience on both Sun clustering and Veritas clustering software share their experience on both products, strength and weakness or any comparison?? KC = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED]
RE: Tuning question - Why did this index help so much?
Hi Tom, That's why I expected a 25% decrease in processing time (instead of reading 2 index blocks and 2 table blocks it read 2 index blocks and 1 table block). But why would it give a 75% decrease? Jay -Original Message- Sent: Wednesday, July 25, 2001 2:29 PM To: Multiple recipients of list ORACLE-L I think it's because the optimizxer did not have to go to the table b to satisfy the query - it went to the index only. does this make sense? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 25, 2001 12:57 PM To: Multiple recipients of list ORACLE-L it's possible that the index was small enough to stay cached in the SGA? From: Miller, Jay [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Tuning question - Why did this index help so much? Date: Wed, 25 Jul 2001 08:31:28 -0800 The other week a new production process was running much more slowly than anticipated. A file needed to be sent out by 6:00pm and at the rate the table was being populated it wouldn't complete until around 9:30pm. The production people and developers came to me for help and I saw that the SQL Explain Plan that was usually being executed (this would run a few million times) was something like select a.col1,a.col2,a.col3,b.col2 from a, b where a.col4=b.col1 and a.col5=:b1 nested loops table a index a1 (unique) table b index b1 (range) This looked pretty good, but it occurred to me that only one column was being selected from table b, so if I added a index (b2) that combined col1 and col2 to table b then it wouldn't be necessary to read table b at all, all the information would be in index b2. This resulted in a plan of: nested loops table a index a1 (unique) index b1 (range) I did so on the fly (this was only a 4,000 row table so it took almost no time to create the index). I anticipated that it would cut about 25% off the processing time (only 3/4 as many block reads). Instead it cut about 75% off the processing time causing it to finish at 5:45 (I was a hero to the developers and production people, but had to warn them not to tell their management about it since I could get in trouble for not following the Change Control Process). My question is, where did the additional 50% efficiency come from? What am I missing? I'm glad it worked so well, but would like to understand why... -- 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/intl.asp -- 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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
Re[2]:RE: Data load options
Mohammad, That only works if you can truncate the table. Dick Goulet Reply Separator Author: Mohammad Rafiq [EMAIL PROTECTED] Date: 7/25/2001 9:16 AM Truncation was the solution in this case as I observed in the past that direct load option use empty blocks above HWM thus using lot of space above it. If it is possible target table should be truncated before such loads... Regards MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 25 Jul 2001 07:03:22 -0800 Lisa, SQL*Loader in direct path can cause you storage problems since it always appends to the table(s) ignoring blocks on the free block list. I found that out after a developer was using it for our data warehouse. At the end of a year he had burned almost 100GB of disk it kept increasing even though he was trying to keep only a rolling 180 window. On a hunch we exported the data, truncated the table imported the data back in. The amount of tablespace being used dropped 50%. Dick Goulet Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 7/25/2001 6:26 AM Hi Sean, Others have given you different options. Here's some considerations: 1. SQL Script. * Can be SLOW * May require intermittent commits in your script * Manual and error prone * Must go through SQL engine 2. SQL Loader * Can be very fast (direct - bypassing SQL engine). * Direct path load will invalidate indexes. * You can keep track of rejected records easily (.bad file) * Dependent upon your file format being EXACT, no errors. 3. Import * Requires minimal manual fiddling * Can be very slow - I once imported 150GB and it took ~3 days * Does not seamlessly handle all object types (INtermedia (domain) indexes is one example) * Restarting an import will take a lot longer. If your import fails, be sure and truncate/drop all tables before starting again. * Have the option of not including indexes (INDEXES=N) * Can also reset your storage parms prior to import (export with data=n, edit file [SSSHHH] and enter new storage parms / import, export with data=y, import data with IGNORE=Y) I'm sure others will have additional considerations to share. My choice has always been exp/imp. Lisa Koivu The Vicodin-enhanced DBA Ft. Lauderdale, FL, USA -Original Message- From: O'Neill, Sean [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L Subject: Data load options I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=US-ASCII META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12 TITLERE: Data load options/TITLE /HEAD BODY PFONT COLOR=#FF SIZE=2 FACE=ArialHi Sean, /FONT /P PFONT COLOR=#FF SIZE=2 FACE=ArialOthers have given you different options.nbsp; Here's some considerations:/FONT /P PFONT COLOR=#FF SIZE=2 FACE=Arial1.nbsp; SQL Script. /FONT ULLIFONT COLOR=#FF SIZE=2 FACE=ArialCan be SLOW /FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialMay require intermittent commits in your script/FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialManual and error prone/FONT/LI LIFONT COLOR=#FF SIZE=2 FACE=ArialMust go through SQL engine/FONT/LI BR /UL PFONT COLOR=#FF SIZE=2 FACE=Arial2.nbsp; SQL Loader/FONT ULLIFONT COLOR=#FF SIZE=2 FACE=ArialCan be very fast (direct - bypassing SQL engine). /FONT/LI LIFONT
RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
i tried removing the spaces but it didn't help..if the client and server r on the same machine ... will it use ipc instead of tcp and if so do i have to configure dispacher for ipc and mention ipc in local_listener. -H -Original Message- Sent: Wednesday, July 25, 2001 3:09 PM To: Multiple recipients of list ORACLE-L A couple of things I would check. I don't believe you need the ADDRESS_LIST parameter, unless you will have multiples. I would remove the spaces in the parameter. I would make sure that the HOST equals the machine name, possibly make the entry upper case. As foolish as it sounds, I've seen these things make a difference. Set it up to look like this and see if it helps. LOCAL_LISTENER = (Address=(Protocol=TCP)(Host=ORA2000)(Port=1521)) I recently had a problem where the HOST wasn't the same as the machine name. Fixed that and the problem went away. Hope this helps out, Durinda -Original Message- Sent: Wednesday, July 25, 2001 1:11 PM To: Multiple recipients of list ORACLE-L this option is not set so i assume default is OFF... any other clue... -Original Message- Sent: Wednesday, July 25, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Check the client's sqlnet.ora. It can override the server config with USE_DEDICATED_SERVER=ON setting. Steve -Original Message- Sent: Wednesday, July 25, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Hi, I have configured the server to use MTS and still dedicated connections r used. What might be the reasondatabase is 8.1.6.3.4 LSNRCTL services Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) PLSExtProchas 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D004 machine: ORA2000, pid: 1956 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1393)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D003 machine: ORA2000, pid: 1952 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1391)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D002 machine: ORA2000, pid: 1948 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1390)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D001 machine: ORA2000, pid: 1944 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1387)) DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: ORA2000, pid: 1940 (ADDRESS=(PROTOCOL=tcp)(HOST=ora2000)(PORT=1385)) ora2000 has 1 service handler(s) DEDICATED SERVER established:0 refused:0 LOCAL SERVER ora2000 has 6 service handler(s) DEDICATED SERVER established:76 refused:0 LOCAL SERVER The command completed successfully init.ora looks like: mts_dispatchers = TCP,5 mts_max_dispatchers=50 mts_servers=20 mts_max_servers=50 LOCAL_LISTENER = (ADDRESS_LIST = (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
