Re: system event waits
It was talked on the list and had been said that 1% of performance it affects nearly as I remember. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:23 AM Do you guys think making times statistic =true has any performance impact . Are there any other considerations ? -Bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 01, 2002 12:53 PM Depending on the version of the database, timed_statistics may be dynamic and not require a database bounce. True - but the timing values are meaningless unless the counters (TOTAL_WAITS and TOTAL_TIMEOUTS) are reset. Only a bounce resets the counters and switches on timing at the same time I wouldn't recommend using the time values otherwise. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BigP INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle client won't install on Windows 2000
Check if the processor is P4. If so , you must replace the symcjit.dll and jvm.dll with the ones in 9i CD. Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 12:03 AM One of our developers is having a problem installing Oracle Client (8.1.7). When he inserts the CD the initial screen comes up with the options to Install/Deinstall products, Explore CD, Browse Documentation. When he clicks on Install/Deinstall, however the Oracle Installer never comes up. Any ideas what might be wrong? Thanks Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: performance
I didn't mean to be so stiff on the reply -- sorry for that... You are excused... Just kidding. :-) I didn't mean that either - my apologies. And you may be very right on the political perspective. What's done is done. It could be not the right time for late general setups, but analysis is always a good choice. The most common issues in the redo stream are certainly sizing and I/O. Yes, it can be quite cut-and-dried. But Ravi merely mentioned that performance was slower after enabling ARCHIVELOG mode and for all we know, it truly may have nothing to do with the redo logging stream whatsoever. It could be something else (i.e. bad SQL that someone recently slammed in at the same time) that neither Ravi (nor we) are aware of. It could be anything at all... So, making changes in the complete absence of information can easily end up with the following scenario: Ravi makes the recommended changes (i.e. add redo log groups, change group sizes, pester SysAdmins to create new file-systems to separate online from archived destinations, etc), all with no impact on performance. Thus, his credibility is harmed, if not totally destroyed. Happens all the time...(8 million stories in the naked city)... Better to look first, understand exactly what is happening, and act on real information. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 01, 2002 7:53 AM I've assumed, that nothing changed beside ARCHIVE LOG mode. when Our DB is non-archive mode that was ok,when we moved to Archive, it is dead slow This directs to the question of I/O with archiving redo logs in first turn. Doesn't it? What may be other direct performance issues of ARCHIVE LOG mode? I admit that there is not enough information, which may easily make me mistaken. However, there should be some general setup for archive log mode, and that's what I gave. General setup should be made before moving to archivelog mode and taken as basis for further tuning. Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 01, 2002 2:43 PM Alexandre, I beg to differ. You have assumed, in the complete absence of any information, that he has an I/O problem. He might. He also might not. He should look first, before leaping. -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 01, 2002 1:53 AM Ravi, Make sure you have at least 5-10 redo log groups. That's depends on your workload. You also may need to increase their size. Think how much log info your database can generate and size your logs that it would be enough for 10 mins at least. (Of course that would be pretty rough estimation) Also make sure you put redo logs and arcived redo logs on differend disks! So that's for start. After, you may follow advice given in Tim's reply. hth Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 29, 2002 9:13 PM Dear All, Can any one please give me some hints or tips when we move to archive mode? when Our DB is non-archive mode that was ok,when we moved to Archive, it is dead slow. Obviosuly archive mode performance is slow, is there any other precations to be taken care? Thanks for your help. Cheers, Ravi __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED]
Re: Oracle8i Upgrade Exam Material
Oracle9i New Features is pretty much concise and descriptive at the same time. Good Job! I used Oracle8i New Features For Administrators Exam Cram and found it a helpful resource. Thanks! Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 01, 2002 7:43 PM The Oracle8i New Features For Administrators Exam Cram by Robert Freeman (Tours Truly) is available on Amazon. Not that I get a dime of royalty out of it anymore :-( RF Robert G. Freeman - Oracle8i OCP Oracle Database Architect CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Monday, July 01, 2002 10:44 AM To: Multiple recipients of list ORACLE-L I am going to be taking the Oracle8i: New Features for Administrators (1Z0-020) exam and am looking for study materials. Can anyone recommend and books for this exam? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 - scheduling
Hallo, anyone who has a good example on how to write in the crontab if you want to schedule a job to run every four week. Is it possible to do that in unix cron job schedule. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 8.1 and 8.0.5 compatibility
I had a problem. Trying to drop a column from a Oracle 8i Table (personal edition on a w2kPro) i got the following message (or similar) you can't drop a table with 8.0.5 compatibility, you need at least 8.1.0. ! Ok, i changed compatibiliy parameter from 8.0.5 to 8.1.0 (using dba studio) and all seems to be right. The first time i've restarted the dba machine Oracle did not come up any more (the db was mounted but not opened). Other way i cant go back to 8.0.5 compatibility because the dropped column ! what can i do ? Any help will be appreciated. Marcello -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marcello Savino INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 8.1 and 8.0.5 compatibility
I had experienced a similar thing too. But I had opened the database with the compatible parameter database needed to startup.. Try to change the compatible parameter in my opinion to open the database. , Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 12:03 PM I had a problem. Trying to drop a column from a Oracle 8i Table (personal edition on a w2kPro) i got the following message (or similar) you can't drop a table with 8.0.5 compatibility, you need at least 8.1.0. ! Ok, i changed compatibiliy parameter from 8.0.5 to 8.1.0 (using dba studio) and all seems to be right. The first time i've restarted the dba machine Oracle did not come up any more (the db was mounted but not opened). Other way i cant go back to 8.0.5 compatibility because the dropped column ! what can i do ? Any help will be appreciated. Marcello -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marcello Savino INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Remove numbers from string
Jared's passion to regular expessions is understandable after book Perl for
Oracle DBAs :)
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 02, 2002 8:03 AM
Yes, but not nearly as flexible as owa_pattern, and infinitely
more difficult to read.
Jared
On Monday 01 July 2002 14:33, Kirsch, Walter J (Northrop Grumman) wrote:
Actually, it's simpler to use the trick
select translate('abc123def432', '~1234567890','~') from dual;
-Original Message-
Sent: Monday, July 01, 2002 4:23 PM
To: Multiple recipients of list ORACLE-L
Yes, use regular expressions via the owa_pattern package.
Here's an example:
declare
tstr varchar2(100) := 'this c34ontains s0239everal 2340 numeric 882
dig2its';
begin
dbms_output.put_line( tstr);
-- remove the digits
owa_pattern.change( tstr, '\d', '', 'g');
dbms_output.put_line( tstr);
-- remove the extra spaces
owa_pattern.change( tstr, '\s+', ' ', 'g');
dbms_output.put_line( tstr);
end;
/
Jared
Nils Höglund [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/01/2002 04:18 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Remove numbers from string
Is there any way to remove all numbers from a string?
The string might look like this: 'abc123def432'
and I wan't it to look like this: 'abcdef'.
I'm using Oracle 8.
Thanks in advance!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexandre Gorbatchev
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 - scheduling
Hallo, anyone who has a good example on how to write in the crontab if you want to schedule a job to run every four week. Is it possible to do that in unix cron job schedule. Thanks in advance Roland Roland, Please, just for once, couldn't you try to figure out things by yourself and type 'man crontab'? I am naively optimistic about human nature but you make me despair. I'd be really happy to read one day from one of your posts something you have picked up in a doc I have not had time to read myself. Really. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 - scheduling
anyone who has a good example on how to write in the crontab if you want to schedule
a job to run every four week.
Is it possible to do that in unix cron job schedule.
Yes, it is very possible.
Run 'crontab -e' as apropeate user. Your $EDITOR will open.
Write as described in crontab(5) manual ('man 5 crontab'):
0 */4 * * * your_command
This will run your_command every four hours (first field which minutes,
second field in which hours)
You can also edit the /etc/crontab-file (if avaible on your system.) This
file has a different syntax (you specify the user who is going to run the
command too.)
--
/Nils Höglund, Naqua KB
E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18 30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
OPS and redos
Hi gurus, I have a query..Basically we have an OPS set up here (8.0.6) and I have noticed that the scn on node A is 500 and the scn on node B is 2000. I am concerned about this w.r.t recovery- surely this would be an issue ??I logged a call with oracle and they said it wasnt an issue, but then I read in a document that it WAS an issue and could potentially lose everything between 500 abd 2000..and that the workaround would be to add more logs to A or to modify the check point interval Please can you advise?? Rgds Fawzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle client won't install on Windows 2000
On metastink check out NOTE:131299.1. This has detailed instructions for three different work arounds. Dave -Original Message- Sent: Monday, July 01, 2002 8:27 PM To: Multiple recipients of list ORACLE-L Hi I am guessing that he has a P4 cpu in the system and you need to do the following. There is also a new installer to overcome this as well but don't have the info at hand there is more on Metalink ORACLE ON PENTIUM 4 CONFLICT | by Liviu Obreja Here's a quick tip: The installation of Oracle8i on a Pentium 4 computer will exit without any notice. The reason for this is that the Pentium 4 architecture has problems with the Just In Time installer. To fix this problem, just find all copies of the file symcjit.dll and rename them to symcjit.org. Then the installer will work. Copy the installation CD to the HDD and make the changes, then install from the HDD. Voila! CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci784876,00.html Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Schauss, Peter [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02-07-2002 07:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:Oracle client won't install on Windows 2000 One of our developers is having a problem installing Oracle Client (8.1.7). When he inserts the CD the initial screen comes up with the options to Install/Deinstall products, Explore CD, Browse Documentation. When he clicks on Install/Deinstall, however the Oracle Installer never comes up. Any ideas what might be wrong? Thanks Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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).
ADVANCED_REPLICATION ?
Hi I would like someone out there to give me a name of a good book and websites where I can learn more about Replication. From configuration (setting up replication) to solving problems (conflict resolutions / trouble shooting). Please any website and good book. I am involved in big project and I must learn this fast. Thank you, Tjaros ___ http://www.webmail.co.za the South-African free email service -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jackson Dumas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: iFS
First off - thanks to Chris and Alexandre for their helpful input on the subject of iFS. Brief question - does anyone know of the status of SQL as an interface to iFS? I know this has been promised, but whether delivered yet I just don't know... thanks, peter edinburgh . -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 26 June 2002 16:09To: Multiple recipients of list ORACLE-LSubject: RE: iFS Peter, I have spent some time demonstrating and publicising iFS within my part of the business, mainly as a document management system. I have only demonstrated the basic, out-of-the-box product as I have no budget to develop it further. Although it stimulates initial interest among the user community it is often seen as being abit 'clunky' in comprison to off-the-shelf DMSs. I like the product and the functionality it provides out-of-the-box and am sure that there is a market for it but as mentioned am not in a good position to demo what it is capable of. I have introduced it internally to manage documents centrallyand this seems to have gone down well bit I have had to recommend that only the webui is used as there seems to be problems (that neither I nor Oracle have managed to resolve) with the SMB interface when using certain PCs. Hope this helps, Chris Johnson -Original Message-From: Robson, Peter [mailto:[EMAIL PROTECTED]]Sent: 26 June 2002 12:35To: Multiple recipients of list ORACLE-LSubject: iFS Has anyone experieince with iFS? I would much appreciate any (off-line if preferred) comments on user experiece. thanks, peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk *
RE: ADVANCED_REPLICATION ?
Oracle Distributed Systems by Charles Dye Published by O'Reilly ISBN: 1-56592-432-0 Also check the online docs for the replication sections. Dave -Original Message- Sent: Tuesday, July 02, 2002 8:13 AM To: Multiple recipients of list ORACLE-L Hi I would like someone out there to give me a name of a good book and websites where I can learn more about Replication. From configuration (setting up replication) to solving problems (conflict resolutions / trouble shooting). Please any website and good book. I am involved in big project and I must learn this fast. Thank you, Tjaros ___ http://www.webmail.co.za the South-African free email service -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jackson Dumas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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).
Should we upgrade from 9.0.1.2 to 9.2?
We have a couple of new applications in development that are moving to QA. These databases are currently running 9.0.1.2 on Sun Solaris 2.6. We've been pretty happy with this version to this point but are at a pivotal spot in our product development cycle where we have a narrow window in which we could upgrade to 9.2 before we finish our QA cycle and move the application to production.We will be moving to production in the September timeframe. I know that 9.2 hasn't been out that long so I'm not sure how many people are using it. For those that are using it, what has your experience been? Is it very buggy? Any major problems? We have an OLTP database, a smallish datawarehouse that uses partitioning, and some datamarts that also use partitioning. We do not use MTS or replication. Our character set is UTF8. We will be essentially 24 X 7. These are web-based front-ends. What do you guys think? This OLTP database is very mission critical for us, once it gets to production. Is it worth moving to 9.2 at this point or should we wait awhile until a couple more patchsets come out? How long do people wait for a new release to settle before they move to it? Thanks for your feedback, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9i, can't break it?
Guess who did? MetaLink V2 - Note An error occured while trying to query the system. Please try again later [CODE : -12541 ] Be careful what you wish for, you just might get it!! Dick Goulet -- 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:Should we upgrade from 9.0.1.2 to 9.2?
Cherie, For the most part I don't like using version X.0 at any point. Now in version 8, I did get onto 8.0.5, but I did wait for the .5 to show up. With 8i it's 8.1.6 that was our baseline although I'm a lot happier with 8.1.7. For 9i I won't touch anything before 9.2, which is waiting for a test home right now. On the other hand I think it's a pretty wise idea to be on the latest version before going into production since that way you have a longer period of time before having to upgrade again. I just like having some other poor slob find the bugs first. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/2/2002 5:58 AM We have a couple of new applications in development that are moving to QA. These databases are currently running 9.0.1.2 on Sun Solaris 2.6. We've been pretty happy with this version to this point but are at a pivotal spot in our product development cycle where we have a narrow window in which we could upgrade to 9.2 before we finish our QA cycle and move the application to production.We will be moving to production in the September timeframe. I know that 9.2 hasn't been out that long so I'm not sure how many people are using it. For those that are using it, what has your experience been? Is it very buggy? Any major problems? We have an OLTP database, a smallish datawarehouse that uses partitioning, and some datamarts that also use partitioning. We do not use MTS or replication. Our character set is UTF8. We will be essentially 24 X 7. These are web-based front-ends. What do you guys think? This OLTP database is very mission critical for us, once it gets to production. Is it worth moving to 9.2 at this point or should we wait awhile until a couple more patchsets come out? How long do people wait for a new release to settle before they move to it? Thanks for your feedback, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: iFS
Peter, I'm not sure what do you mean by the SQL interface for iFS. Can you elaborateor give some links to resources? afaik, iFS is created to store non-relational data. However, this is mapped to relational schema in DB where iFS stores all the information. There are also some Views created in iFS schemathat may be used for SELECTs. Basically, it's possible to makeDMLon internal tables of iFS, but... guess what... not recommended/supported by Oracle. Question on another topic about iFS: Has anybody found the solution to restore a single file in iFS? "Oracle9i Release 2 New Features" document says that it's possible. In fact this is the first new feature in the listof changes foriFS coming with 9iR2. However, the Admin. Guide for iFS doesn't say anything about it.there are the same 3 paragraphs on the matter of Backup/Recovery. (Ahrrr... can you believe it?) I'm going to talk to Oracle support regarding this, but if someone has any info, I would much appreciate it. Regards, Alexandre - Original Message - From: Robson, Peter To: Multiple recipients of list ORACLE-L Sent: Tuesday, July 02, 2002 3:23 PM Subject: RE: iFS First off - thanks to Chris and Alexandre for their helpful input on the subject of iFS. Brief question - does anyone know of the status of SQL as an interface to iFS? I know this has been promised, but whether delivered yet I just don't know... thanks, peter edinburgh . -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 26 June 2002 16:09To: Multiple recipients of list ORACLE-LSubject: RE: iFS Peter, I have spent some time demonstrating and publicising iFS within my part of the business, mainly as a document management system. I have only demonstrated the basic, out-of-the-box product as I have no budget to develop it further. Although it stimulates initial interest among the user community it is often seen as being abit 'clunky' in comprison to off-the-shelf DMSs. I like the product and the functionality it provides out-of-the-box and am sure that there is a market for it but as mentioned am not in a good position to demo what it is capable of. I have introduced it internally to manage documents centrallyand this seems to have gone down well bit I have had to recommend that only the webui is used as there seems to be problems (that neither I nor Oracle have managed to resolve) with the SMB interface when using certain PCs. Hope this helps, Chris Johnson -Original Message-From: Robson, Peter [mailto:[EMAIL PROTECTED]]Sent: 26 June 2002 12:35To: Multiple recipients of list ORACLE-LSubject: iFS Has anyone experieince with iFS? I would much appreciate any (off-line if preferred) comments on user experiece. thanks, peter edinburgh *This e-mail message, and any files transmitted with it, areconfidential and intended solely for the use of the addressee. Ifthis message was not addressed to you, you have received it in errorand any copying, distribution or other use of any part of it isstrictly prohibited. Any views or opinions presented are solely thoseof the sender and do not necessarily represent those of the BritishGeological Survey. The security of e-mail communication cannot beguaranteed and the BGS accepts no liability for claims arising as aresult of the use of this medium to transmit messages from or to theBGS. The BGS cannot accept any responsibility for viruses, so pleasescan all attachments. http://www.bgs.ac.uk*
Re:Should we upgrade from 9.0.1.2 to 9.2?
Dick, Thanks for your comments. So, the bottom line is that you are recommending moving from 9.0.1.2 to 9.2? Cherie [EMAIL PROTECTED] om To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re:Should we upgrade from 9.0.1.2 to 9.2? om 07/02/02 09:23 AM Please respond to ORACLE-L Cherie, For the most part I don't like using version X.0 at any point. Now in version 8, I did get onto 8.0.5, but I did wait for the .5 to show up. With 8i it's 8.1.6 that was our baseline although I'm a lot happier with 8.1.7. For 9i I won't touch anything before 9.2, which is waiting for a test home right now. On the other hand I think it's a pretty wise idea to be on the latest version before going into production since that way you have a longer period of time before having to upgrade again. I just like having some other poor slob find the bugs first. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/2/2002 5:58 AM We have a couple of new applications in development that are moving to QA. These databases are currently running 9.0.1.2 on Sun Solaris 2.6. We've been pretty happy with this version to this point but are at a pivotal spot in our product development cycle where we have a narrow window in which we could upgrade to 9.2 before we finish our QA cycle and move the application to production.We will be moving to production in the September timeframe. I know that 9.2 hasn't been out that long so I'm not sure how many people are using it. For those that are using it, what has your experience been? Is it very buggy? Any major problems? We have an OLTP database, a smallish datawarehouse that uses partitioning, and some datamarts that also use partitioning. We do not use MTS or replication. Our character set is UTF8. We will be essentially 24 X 7. These are web-based front-ends. What do you guys think? This OLTP database is very mission critical for us, once it gets to production. Is it worth moving to 9.2 at this point or should we wait awhile until a couple more patchsets come out? How long do people wait for a new release to settle before they move to it? Thanks for your feedback, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
Re: Unix - scheduling
Please don't use 'crontab -e', unless you are saving your
crontab files and using some form of version control on them.
'crontabe -e' is inherently dangerous, as it is too easy to remove
lines unintentionally, and then they are gone for good.
Jared
On Tuesday 02 July 2002 04:28, Nils Höglund wrote:
anyone who has a good example on how to write in the crontab if you want
to schedule a job to run every four week. Is it possible to do that in
unix cron job schedule.
Yes, it is very possible.
Run 'crontab -e' as apropeate user. Your $EDITOR will open.
Write as described in crontab(5) manual ('man 5 crontab'):
0 */4 * * * your_command
This will run your_command every four hours (first field which minutes,
second field in which hours)
You can also edit the /etc/crontab-file (if avaible on your system.) This
file has a different syntax (you specify the user who is going to run the
command too.)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Oracle 9i, can't break it?
For those of you in the Oracle Partner program, here's what looks like another little bug to add to the 'Unbreakable' list... Log into the Oracle partner network at http://oraclepartnernetwork.oracle.com/ and look for the Product Query Tool under 'Pricing' - It gives the cost of the various Oracle options in various currencies. Choose Enterprise Edition, try to get a price in Italy and it completly fails to cope with the currency conversion, resulting in a price of 0. for a two-year user license, with the same for support and upgrade. I can only assume that nobody in Italy is an Oracle Partner, or they're keeping very quiet about getting the Database for free... Somebody tell me this stuff doesn't run on Oracle software. Simon Anderson -- 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: Unix - scheduling
-- [EMAIL PROTECTED] on 07/02/02 00:43:19 -0800 Hallo, anyone who has a good example on how to write in the crontab if you want to schedule a job to run every four week. Is it possible to do that in unix cron job schedule. Monthly is doable. Every 28 days requires using at, or a more flexable scheduling tool. That or cron the job daily and have it decide whether 28 days have passed since it last ran (e.g., based on a time string stored in a file). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- 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: Unix - scheduling
-- Nils Höglund [EMAIL PROTECTED] on 07/02/02 03:28:20 -0800 0 */4 * * * your_command $ man 5 cronttab; The time and date fields are: field allowed values - -- minute 0-59 hour 0-23 day of month 1-31 month 1-12 (or names, see below) day of week0-7 (0 or 7 is Sun, or use names) A field may be an asterisk (*), which always stands for ``first-last''. Ranges of numbers are allowed. Ranges are two numbers separated with a hyphen. The specified range is inclusive. For example, 8-11 for an ``hours'' entry specifies execution at hours 8, 9, 10 and 11. Lists are allowed. A list is a set of numbers (or ranges) separated by commas. Examples: ``1,2,5,9'', ``0-4,8-12''. : Question: how does 0 */4 * * * cause something to run every 4 weeks? Unless your version has a different field order. It might work to try * */628 * * * but I'm not sure that cron allows n24 for the hourly divisor. The combination of date and weekday can approximate the 4-week cycle. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- 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: Questionable V$SQLAREA Statistics
Hi, You should not compare tkprof outputs with V$SQL,V$SQLAREA. Because, recursive/child statistics are included in their parent statements in these views. But, tkprof substructs recursive statistics. I mean tkprof reports real values for statements, but dictionary doesn't. regards... Orr, Steve wrote: Here's the scene: 1) I have a 400,000 row table table which is cached. 2) I have a query against that table and no other with one column referenced in the WHERE clause. (This column is indexed and of course I don't really need the index since the table is cached but it's there so ho hum...) 3) When I run tkprof on the query it shows a full table scan ignoring the index... that's what I want 'cause it's cached. 4) But when I look at V$SQLAREA the DISK_READS column is incremented. 5) This query is executed very often so my StatsPack report lists it as one of the most expensive queries in terms of physical reads. It appears that Oracle is counting full table scans of cached tables as DISK_READS in V$SQLAREA. Seems like this is a bug to me 'cause it's not really a physical disk read but is getting data from the buffers. Don't you think this is a bug? Has anyone seen this before? Steve Orr Looking for cache in Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 - scheduling
http://www.superscripts.com/tutorial/crontab.html On Tue, 2 Jul 2002 [EMAIL PROTECTED] wrote: Hallo, anyone who has a good example on how to write in the crontab if you want to schedule a job to run every four week. Is it possible to do that in unix cron job schedule. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Should we upgrade from 9.0.1.2 to 9.2?
Cherie, Before any upgrade I consider whether or no I really need it. For mission critical application it would be wise to stick with what you have, unless you have problems with it. Now we have 9.0.1.2 in production and 9.1.3 in development and I don't intend to move to 9.2 in nearest time. Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 3:58 PM We have a couple of new applications in development that are moving to QA. These databases are currently running 9.0.1.2 on Sun Solaris 2.6. We've been pretty happy with this version to this point but are at a pivotal spot in our product development cycle where we have a narrow window in which we could upgrade to 9.2 before we finish our QA cycle and move the application to production.We will be moving to production in the September timeframe. I know that 9.2 hasn't been out that long so I'm not sure how many people are using it. For those that are using it, what has your experience been? Is it very buggy? Any major problems? We have an OLTP database, a smallish datawarehouse that uses partitioning, and some datamarts that also use partitioning. We do not use MTS or replication. Our character set is UTF8. We will be essentially 24 X 7. These are web-based front-ends. What do you guys think? This OLTP database is very mission critical for us, once it gets to production. Is it worth moving to 9.2 at this point or should we wait awhile until a couple more patchsets come out? How long do people wait for a new release to settle before they move to it? Thanks for your feedback, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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]:Should we upgrade from 9.0.1.2 to 9.2?
Cherie, First off, I had no plans to ever use 9.0 anywhere other than test to see what was new. In your case your already on 9.0.1 and appear happy with that. Given that you could deploy o 9.0.1 or upgrade to 9.2 now and hope for a longer time before the next upgrade. Personally I'd make the argument to upgrade. Better to be on the bleeding edge at deployment time than on the edge of desupport. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/2/2002 6:53 AM Dick, Thanks for your comments. So, the bottom line is that you are recommending moving from 9.0.1.2 to 9.2? Cherie [EMAIL PROTECTED] om To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re:Should we upgrade from 9.0.1.2 to 9.2? om 07/02/02 09:23 AM Please respond to ORACLE-L Cherie, For the most part I don't like using version X.0 at any point. Now in version 8, I did get onto 8.0.5, but I did wait for the .5 to show up. With 8i it's 8.1.6 that was our baseline although I'm a lot happier with 8.1.7. For 9i I won't touch anything before 9.2, which is waiting for a test home right now. On the other hand I think it's a pretty wise idea to be on the latest version before going into production since that way you have a longer period of time before having to upgrade again. I just like having some other poor slob find the bugs first. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/2/2002 5:58 AM We have a couple of new applications in development that are moving to QA. These databases are currently running 9.0.1.2 on Sun Solaris 2.6. We've been pretty happy with this version to this point but are at a pivotal spot in our product development cycle where we have a narrow window in which we could upgrade to 9.2 before we finish our QA cycle and move the application to production.We will be moving to production in the September timeframe. I know that 9.2 hasn't been out that long so I'm not sure how many people are using it. For those that are using it, what has your experience been? Is it very buggy? Any major problems? We have an OLTP database, a smallish datawarehouse that uses partitioning, and some datamarts that also use partitioning. We do not use MTS or replication. Our character set is UTF8. We will be essentially 24 X 7. These are web-based front-ends. What do you guys think? This OLTP database is very mission critical for us, once it gets to production. Is it worth moving to 9.2 at this point or should we wait awhile until a couple more patchsets come out? How long do people wait for a new release to settle before they move to it? Thanks for your feedback, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services
Re: OPS and redos
Fawzia, Oracle it self will keep an eye on that also. It will kick the other instance if it falls behind. So that the redo file will be switched. Anjo. Malik, Fawzia wrote: Hi gurus, I have a query..Basically we have an OPS set up here (8.0.6) and I have noticed that the scn on node A is 500 and the scn on node B is 2000. I am concerned about this w.r.t recovery- surely this would be an issue ??I logged a call with oracle and they said it wasnt an issue, but then I read in a document that it WAS an issue and could potentially lose everything between 500 abd 2000..and that the workaround would be to add more logs to A or to modify the check point interval Please can you advise?? Rgds Fawzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Sql query
OJNK? Your term Larry? Or do I need to RTFM? Didn't realize this had a name. Jared On Wednesday 26 June 2002 18:48, Larry Elkins wrote: Greg, When the situation is appropriate, and I don't want a correlated approach, I will typically use the hash aj as illustrated by your second example, the NOT IN using a hash aj. That's my preference, when correlation is not appropriate. And I work with some DB's where always_anti_join is set to hash and don't even have to use the HASH_AJ hint, *if* the conditions for using a hash aj are met. And that's where the beauty of the first approach comes in. Suppose the query is such that you *don't* want it correlated, and the conditions for using a hash aj *can't* be met, you can use the first approach, and force a hash join (outer) if required. You will often times get similar performance as the hash aj. For example, if you forced a hash join via hints in your first example, the OJNK approach (outer join null key, pronounced O Junk, no need for a GNU discussion) might provide very similar results as the hash aj approach. And that's when I use the OJNK approach, when I want a hash type of join, but the conditions for using a hash aj can't be met. That is its real strength. I avoid the OJNK approach otherwise simply because some will be confused by the coding, not realizing an anti-join is being performed. And yes, you can include comments saying so, but some folks will still mistake its purpose ;-) Anyway, here is an example similar to yours, but I forced a hash join when using the OJNK approach. But I'm with you, I lean towards using the HASH_AJ, when appropriate, over the OJNK approach, but mileage varies, not one size fits all, fill in your favorite cliché here. Just wanted to point out that the OJNK approach can be a *savior* when the conditions for a hash aj being used can't be met and a correlated approach is the wrong way to go. The numbers: select count(*) from code_master where code not in (select /*+ HASH_AJ */ code from code_detail) call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.03 0.03 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch1 2.33 53.23 5855859144 1 --- -- -- -- -- -- -- total4 2.36 53.26 5855859144 1 Rows Row Source Operation --- --- 1 SORT AGGREGATE 100 HASH JOIN ANTI 10INDEX FAST FULL SCAN (object id 67350) 299600VIEW VW_NSO_1 299600 INDEX FAST FULL SCAN (object id 69013) *** * select /*+ ORDERED USE_HASH(cd) */ count(*) from code_master cm, code_detail cd where cm.code = cd.code (+) and cd.code is null call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.03 0.03 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch1 2.39 57.47 5855859144 1 --- -- -- -- -- -- -- total4 2.42 57.50 5855859144 1 Rows Row Source Operation --- --- 1 SORT AGGREGATE 100 FILTER 299700HASH JOIN OUTER 10 INDEX FAST FULL SCAN (object id 67350) 299600 INDEX FAST FULL SCAN (object id 69013) And you don't want to see the numbers for the correlated nested loops approach, more than an hour. Okay, OJNK a little slower in this case, but if a hash aj *couldn't* be used, and a correlated approach was *not* the way to go, the OJNK approach can save the day and be a nice alternative if you utilize a hash join. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- Sent: Wednesday, June 26, 2002 5:44 PM To: Multiple recipients of list ORACLE-L 2 versions of SQL + TKPROF excerpts 8.1.6, Solaris SQL version #1 select count(*) from customers c , sales s where c.customer_id = s.customer_id(+) and s.customer_id is null count cpu elapsed disk query current rows total 4 7.337.361 200352 41 RowsRow Source Operation --- 1 SORT AGGREGATE 99105FILTER 169049NESTED LOOPS OUTER 10 INDEX FAST FULL SCAN (object id 22199) 69944 INDEX RANGE SCAN (object id 22232)
ORA-3113 while using DBCA RAC on LINUX clusters
Hi All, We are trying to install RAC on LINUX Cluster and have gotten a long way, however when the DBCA tries to create the database we get ORA-03113 (end-of-file on communication channel). We are sort of lost for ideas and hope that you guys(m/f) have already struggled your way through the installation before and can help us solve the problem. TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 - scheduling
Title: RE: Unix - scheduling Is a strick 14 day rule absolutely necessary, if not...a much more hassle free way would be to simply schedule the cronjob to run on the 1st and 15th of each month, i.e. # Min Hr Day Mon WkDay Command 0 0 1,15 * * script -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: Re: Unix - scheduling -- Nils Höglund [EMAIL PROTECTED] on 07/02/02 03:28:20 -0800 0 */4 * * * your_command $ man 5 cronttab; The time and date fields are: field allowed values - -- minute 0-59 hour 0-23 day of month 1-31 month 1-12 (or names, see below) day of week 0-7 (0 or 7 is Sun, or use names) A field may be an asterisk (*), which always stands for ``first-last''. Ranges of numbers are allowed. Ranges are two numbers separated with a hyphen. The specified range is inclusive. For example, 8-11 for an ``hours'' entry specifies execution at hours 8, 9, 10 and 11. Lists are allowed. A list is a set of numbers (or ranges) separated by commas. Examples: ``1,2,5,9'', ``0-4,8-12''. : Question: how does 0 */4 * * * cause something to run every 4 weeks? Unless your version has a different field order. It might work to try * */628 * * * but I'm not sure that cron allows n24 for the hourly divisor. The combination of date and weekday can approximate the 4-week cycle. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re:Should we upgrade from 9.0.1.2 to 9.2?
Hello Cherie I think that I saw somewhere that support for 9.0.1 will go away about June 2003 while support for 9iR2 will be until 2005. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 4:53 PM Dick, Thanks for your comments. So, the bottom line is that you are recommending moving from 9.0.1.2 to 9.2? Cherie [EMAIL PROTECTED] om To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re:Should we upgrade from 9.0.1.2 to 9.2? om 07/02/02 09:23 AM Please respond to ORACLE-L Cherie, For the most part I don't like using version X.0 at any point. Now in version 8, I did get onto 8.0.5, but I did wait for the .5 to show up. With 8i it's 8.1.6 that was our baseline although I'm a lot happier with 8.1.7. For 9i I won't touch anything before 9.2, which is waiting for a test home right now. On the other hand I think it's a pretty wise idea to be on the latest version before going into production since that way you have a longer period of time before having to upgrade again. I just like having some other poor slob find the bugs first. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/2/2002 5:58 AM We have a couple of new applications in development that are moving to QA. These databases are currently running 9.0.1.2 on Sun Solaris 2.6. We've been pretty happy with this version to this point but are at a pivotal spot in our product development cycle where we have a narrow window in which we could upgrade to 9.2 before we finish our QA cycle and move the application to production.We will be moving to production in the September timeframe. I know that 9.2 hasn't been out that long so I'm not sure how many people are using it. For those that are using it, what has your experience been? Is it very buggy? Any major problems? We have an OLTP database, a smallish datawarehouse that uses partitioning, and some datamarts that also use partitioning. We do not use MTS or replication. Our character set is UTF8. We will be essentially 24 X 7. These are web-based front-ends. What do you guys think? This OLTP database is very mission critical for us, once it gets to production. Is it worth moving to 9.2 at this point or should we wait awhile until a couple more patchsets come out? How long do people wait for a new release to settle before they move to it? Thanks for your feedback, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
RE: Unix - scheduling
Roland, crontab alone will not meet your needs. Hint: check the date command and MOD type fuctionality in a shell script. Good luck, Mike -Original Message- Sent: Tuesday, July 02, 2002 6:14 AM To: Multiple recipients of list ORACLE-L Hallo, anyone who has a good example on how to write in the crontab if you want to schedule a job to run every four week. Is it possible to do that in unix cron job schedule. Thanks in advance Roland Roland, Please, just for once, couldn't you try to figure out things by yourself and type 'man crontab'? I am naively optimistic about human nature but you make me despair. I'd be really happy to read one day from one of your posts something you have picked up in a doc I have not had time to read myself. Really. Regards, Stephane Faroult Oriole -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Upgrade from 9.0.1.2
Hi, We are currently testing our application on 9.0.1.2 and it looks stable except some bugs with function based indexes. Is it advisable to move to 9.0.1.3 (as it is terminal release of 9.0) or 9.2 which is just released 2 months back (and may have some bugs) OR 9.0.1.2 is stable enough and we can ship our product on this release. Any feedback on 9.0.1.2 is highly appreciated Function based index bugs are not fixes in either of release. Platform are sun 2.8 and WIN2K We have to make decision this week to give QA enough time for testing 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: Should we upgrade from 9.0.1.2 to 9.2?
The choice should be between 9.0.1.3 + patch 2121935 or 9.2. The patch is to fix a serious, serious security problem with ANSI-style joins.If you feel the need to go to 9i, I'd choose the latter. I don't think 9.2 has been out long enough. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 02, 2002 8:00 AM To: Multiple recipients of list ORACLE-L Cherie, Before any upgrade I consider whether or no I really need it. For mission critical application it would be wise to stick with what you have, unless you have problems with it. Now we have 9.0.1.2 in production and 9.1.3 in development and I don't intend to move to 9.2 in nearest time. Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 3:58 PM We have a couple of new applications in development that are moving to QA. These databases are currently running 9.0.1.2 on Sun Solaris 2.6. We've been pretty happy with this version to this point but are at a pivotal spot in our product development cycle where we have a narrow window in which we could upgrade to 9.2 before we finish our QA cycle and move the application to production.We will be moving to production in the September timeframe. I know that 9.2 hasn't been out that long so I'm not sure how many people are using it. For those that are using it, what has your experience been? Is it very buggy? Any major problems? We have an OLTP database, a smallish datawarehouse that uses partitioning, and some datamarts that also use partitioning. We do not use MTS or replication. Our character set is UTF8. We will be essentially 24 X 7. These are web-based front-ends. What do you guys think? This OLTP database is very mission critical for us, once it gets to production. Is it worth moving to 9.2 at this point or should we wait awhile until a couple more patchsets come out? How long do people wait for a new release to settle before they move to it? Thanks for your feedback, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL*Plus/UTL_FILE vs. 3'rd Party Data Extraction
I have some people who are asking about 3'rd party data extraction tools to pull data from Oracle into text files for loading a data warehouse. I am not sure what the size of the project is but I think it is pretty big. The DW is Terradata. Anyway, they are stating Oracle tools are too slow. They do not define slow so it is hard to argue with them. My opinion is that it is very dependent on hardware (CPU/Disk) in most cases. What are your opinions on the matter, do you need 3'rd party? What tools are you using (I am aware of Informatica and such but I think they are looking for something a little cheaper)? Thanks, Ethan Post -- 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).
More info About RAC, LINUX and ORA-03113
Oracle version 9i release 2 LINUX RH7.3 === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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[2]:Should we upgrade from 9.0.1.2 to 9.2?
Cherie, I agree with Dick. As long as you have time to install 9.2 on your development machine and assure yourself that it, at least, does not hurt you, I would go with 9.2 now just to give yourself breathing room for the next year or so. If you stick with 9.0, you know that you will begin to feel the pressure to upgrade sometime soon. I always go with the highest level possible as soon as possible. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 02, 2002 11:43 AM To: Multiple recipients of list ORACLE-L Cherie, First off, I had no plans to ever use 9.0 anywhere other than test to see what was new. In your case your already on 9.0.1 and appear happy with that. Given that you could deploy o 9.0.1 or upgrade to 9.2 now and hope for a longer time before the next upgrade. Personally I'd make the argument to upgrade. Better to be on the bleeding edge at deployment time than on the edge of desupport. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/2/2002 6:53 AM Dick, Thanks for your comments. So, the bottom line is that you are recommending moving from 9.0.1.2 to 9.2? Cherie [EMAIL PROTECTED] om To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re:Should we upgrade from 9.0.1.2 to 9.2? om 07/02/02 09:23 AM Please respond to ORACLE-L Cherie, For the most part I don't like using version X.0 at any point. Now in version 8, I did get onto 8.0.5, but I did wait for the .5 to show up. With 8i it's 8.1.6 that was our baseline although I'm a lot happier with 8.1.7. For 9i I won't touch anything before 9.2, which is waiting for a test home right now. On the other hand I think it's a pretty wise idea to be on the latest version before going into production since that way you have a longer period of time before having to upgrade again. I just like having some other poor slob find the bugs first. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/2/2002 5:58 AM We have a couple of new applications in development that are moving to QA. These databases are currently running 9.0.1.2 on Sun Solaris 2.6. We've been pretty happy with this version to this point but are at a pivotal spot in our product development cycle where we have a narrow window in which we could upgrade to 9.2 before we finish our QA cycle and move the application to production.We will be moving to production in the September timeframe. I know that 9.2 hasn't been out that long so I'm not sure how many people are using it. For those that are using it, what has your experience been? Is it very buggy? Any major problems? We have an OLTP database, a smallish datawarehouse that uses partitioning, and some datamarts that also use partitioning. We do not use MTS or replication. Our character set is UTF8. We will be essentially 24 X 7. These are web-based front-ends. What do you guys think? This OLTP database is very mission critical for us, once it gets to production. Is it worth moving to 9.2 at this point or should we wait awhile until a couple more patchsets come out? How long do people wait for a new release to settle before they move to it? Thanks for your feedback, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Unix - scheduling
He specified that 0 */4 * * * would cause it to run every 4 hours. He provided an example. -Original Message- Sent: Tuesday, July 02, 2002 11:13 AM To: Multiple recipients of list ORACLE-L -- Nils Höglund [EMAIL PROTECTED] on 07/02/02 03:28:20 -0800 0 */4 * * * your_command $ man 5 cronttab; The time and date fields are: field allowed values - -- minute 0-59 hour 0-23 day of month 1-31 month 1-12 (or names, see below) day of week0-7 (0 or 7 is Sun, or use names) A field may be an asterisk (*), which always stands for ``first-last''. Ranges of numbers are allowed. Ranges are two numbers separated with a hyphen. The specified range is inclusive. For example, 8-11 for an ``hours'' entry specifies execution at hours 8, 9, 10 and 11. Lists are allowed. A list is a set of numbers (or ranges) separated by commas. Examples: ``1,2,5,9'', ``0-4,8-12''. : Question: how does 0 */4 * * * cause something to run every 4 weeks? Unless your version has a different field order. It might work to try * */628 * * * but I'm not sure that cron allows n24 for the hourly divisor. The combination of date and weekday can approximate the 4-week cycle. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This message originated from the internet. Its originator may not be who they claim to be and the information contained herein my or may not be Accurate. All Messages are Scaned to be Virus Free, by IPM, powered by McAfee. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Cupp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 - scheduling
Title: RE: Unix - scheduling U...think they slipped something into my Mountain Dew while I wasn't looking so that they could log into production directly via SQL*Plus and make some manual changes...I must have still been regaining my senses when I sent this...sorry :) -Original Message-From: Richard Huntley [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 02, 2002 11:58 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Unix - scheduling Is a strick 14 day rule absolutely necessary, if not...a much more hassle free way would be to simply schedule the cronjob to run on the 1st and 15th of each month, i.e. # Min Hr Day Mon WkDay Command 0 0 1,15 * * script -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: Re: Unix - scheduling -- Nils Höglund [EMAIL PROTECTED] on 07/02/02 03:28:20 -0800 0 */4 * * * your_command $ man 5 cronttab; The time and date fields are: field allowed values - -- minute 0-59 hour 0-23 day of month 1-31 month 1-12 (or names, see below) day of week 0-7 (0 or 7 is Sun, or use names) A field may be an asterisk (*), which always stands for ``first-last''. Ranges of numbers are allowed. Ranges are two numbers separated with a hyphen. The specified range is inclusive. For example, 8-11 for an ``hours'' entry specifies execution at hours 8, 9, 10 and 11. Lists are allowed. A list is a set of numbers (or ranges) separated by commas. Examples: ``1,2,5,9'', ``0-4,8-12''. : Question: how does "0 */4 * * *" cause something to run every 4 weeks? Unless your version has a different field order. It might work to try "* */628 * * *" but I'm not sure that cron allows n24 for the hourly divisor. The combination of date and weekday can approximate the 4-week cycle. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- 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: Unix - scheduling
0 */4 * * * your_command
The */4 must be linux. This is not available on HP-UX 11.0.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're sober.
--William Butler
Yeats.
[EMAIL PROTECTED]
Sent by: To: [EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
Subject: Re: Unix - scheduling
07/02/02 04:28 AM
Please respond to
ORACLE-L
anyone who has a good example on how to write in the crontab if you want to schedule
a job to run
every four week.
Is it possible to do that in unix cron job schedule.
Yes, it is very possible.
Run 'crontab -e' as apropeate user. Your $EDITOR will open.
Write as described in crontab(5) manual ('man 5 crontab'):
0 */4 * * * your_command
This will run your_command every four hours (first field which minutes,
second field in which hours)
You can also edit the /etc/crontab-file (if avaible on your system.) This
file has a different syntax (you specify the user who is going to run the
command too.)
--
/Nils Höglund, Naqua KB
E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18 30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). 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 Thomas
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Object in hot file
Title: RE: Unix - scheduling Hello Gurus, Does anybody have a script to locate objects/segments within a file? I have a tablespace that spreads into several files, but there is one of this files that is hot. I would like to know which objects reside in this file. The Oracle version is HP 8.1.7-64. All help will be welcome. Thanks. Abraham J. GuerraSenior Oracle DBAAmerican Family Insurance(608) 242-4100 x32026
Re: Object in hot file
try desc dba_tables dba_indexes Guerra, Abraham J To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) m Subject: Object in hot file Sent by: [EMAIL PROTECTED] 02-07-2002 18:38 Please respond to ORACLE-L Hello Gurus, Does anybody have a script to locate objects/segments within a file? I have a tablespace that spreads into several files, but there is one of this files that is hot. I would like to know which objects reside in this file. The Oracle version is HP 8.1.7-64. All help will be welcome. Thanks. Abraham J. Guerra Senior Oracle DBA American Family Insurance (608) 242-4100 x32026 === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
Redo log
I found couple redo logs in my Oracle8.0.5 database, as shown they are switched every 5 minutes. I'd like to have only two or three logs out there and don't want them to be switched until every 4 hours. Is there a way to control it that way? Secondly, if redo log switchs every 5 minutes, does LogMiner have capability to view transaction history from two days ago? Please advise. $ ls -l redo* -rw-r- 1 oracle dba 512512 Jul 2 11:20 redo01.log -rw-r- 1 oracle dba 512512 Jul 2 11:20 redo02.log -rw-r- 1 oracle dba 512512 Jul 2 11:15 redo03.log -rw-r- 1 oracle dba 512512 Jul 2 11:20 redo03_1.log -rw-r- 1 oracle dba 512512 Jul 2 11:20 redo03_2.log -rw-r- 1 oracle dba 512512 Jul 2 11:15 redo04.log Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix - scheduling
Title: Message He wanted every 4 weeks - -Original Message-From: Richard Huntley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 11:58 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Unix - scheduling Is a strick 14 day rule absolutely necessary, if not...a much more hassle free way would be to simply schedule the cronjob to run on the 1st and 15th of each month, i.e. # Min Hr Day Mon WkDay Command 0 0 1,15 * * script -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: Re: Unix - scheduling -- Nils Höglund [EMAIL PROTECTED] on 07/02/02 03:28:20 -0800 0 */4 * * * your_command $ man 5 cronttab; The time and date fields are: field allowed values - -- minute 0-59 hour 0-23 day of month 1-31 month 1-12 (or names, see below) day of week 0-7 (0 or 7 is Sun, or use names) A field may be an asterisk (*), which always stands for ``first-last''. Ranges of numbers are allowed. Ranges are two numbers separated with a hyphen. The specified range is inclusive. For example, 8-11 for an ``hours'' entry specifies execution at hours 8, 9, 10 and 11. Lists are allowed. A list is a set of numbers (or ranges) separated by commas. Examples: ``1,2,5,9'', ``0-4,8-12''. : Question: how does "0 */4 * * *" cause something to run every 4 weeks? Unless your version has a different field order. It might work to try "* */628 * * *" but I'm not sure that cron allows n24 for the hourly divisor. The combination of date and weekday can approximate the 4-week cycle. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This message originated from the internet. Its originator may not be who they claim to be and the information contained herein my or may not be Accurate. All Messages are Scaned to be Virus Free, by IPM, powered by McAfee.
RE: Should we upgrade from 9.0.1.2 to 9.2?
I'd agree with Ian, because (at-least) on AIX, pre 9013 versions had smon leak, clob leak problems. 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! -Original Message- Sent: Tuesday, July 02, 2002 12:23 PM To: Multiple recipients of list ORACLE-L The choice should be between 9.0.1.3 + patch 2121935 or 9.2. The patch is to fix a serious, serious security problem with ANSI-style joins.If you feel the need to go to 9i, I'd choose the latter. I don't think 9.2 has been out long enough. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] *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
RE: system event waits
1. If you have bug 1210242, then using timed_statistics=true will have a profound impact upon performance. Get a patch, and then go to 3. 2. If you use an HP-UX release older than release 10, then using timed_statistics=true will have a profound impact upon performance. Upgrade HP-UX, and then go to 3. 3. Otherwise, set timed_statistics=true at the instance level, and leave it set that way forever. In your first hour of using timing data, you will probably recover more system capacity than the timer mechanism will consume in a year. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 9-11 New York City - Hotsos Clinic, Jul 23-25 Chicago - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas -Original Message- Sent: Monday, July 01, 2002 8:23 PM To: Multiple recipients of list ORACLE-L Do you guys think making times statistic =true has any performance impact . Are there any other considerations ? -Bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 01, 2002 12:53 PM Depending on the version of the database, timed_statistics may be dynamic and not require a database bounce. True - but the timing values are meaningless unless the counters (TOTAL_WAITS and TOTAL_TIMEOUTS) are reset. Only a bounce resets the counters and switches on timing at the same time I wouldn't recommend using the time values otherwise. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: BigP INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 - scheduling
Aww, come on, crontab -e isn't that bad! The most dangerous thing
about it is accidentally running crontab -r instead of -e. Using crontab
-e is no worse than using a wildcard with the rm command, i.e. 'rm a *'
instead of 'rm a*'. One deletes all files that start with 'a', the other
deletes a file named 'a' plus everything else in your directory. Like
anything else, just be careful when you're using crontab and you shouldn't
have any problems. If you can't do things carefully, you probably won't
make it too long as a DBA anyway.
Although, if you are a vi novice and using it to edit your crontab,
then I would agree with Jared. A few wrong keystrokes in command mode and
you can trash a file real quick
Just my $.02,
Alan
P.S. I do recommend making a backup of your crontab occasionally
though
Jared Still
jkstill@cybco To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
n.com cc:
Sent by: Subject: Re: Unix - scheduling
[EMAIL PROTECTED]
om
07/02/02 09:03
AM
Please respond
to ORACLE-L
Please don't use 'crontab -e', unless you are saving your
crontab files and using some form of version control on them.
'crontabe -e' is inherently dangerous, as it is too easy to remove
lines unintentionally, and then they are gone for good.
Jared
On Tuesday 02 July 2002 04:28, Nils Höglund wrote:
anyone who has a good example on how to write in the crontab if you
want
to schedule a job to run every four week. Is it possible to do that in
unix cron job schedule.
Yes, it is very possible.
Run 'crontab -e' as apropeate user. Your $EDITOR will open.
Write as described in crontab(5) manual ('man 5 crontab'):
0 */4 * * * your_command
This will run your_command every four hours (first field which minutes,
second field in which hours)
You can also edit the /etc/crontab-file (if avaible on your system.) This
file has a different syntax (you specify the user who is going to run the
command too.)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
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: Remove numbers from string
Sigh. There are way too many packages in Oracle. Thanks Jared. I have to share this with a developer struggling to write some parsing functions. I'll take back all the bad reviews I posted on bookpool.com about your book... -Original Message- Sent: Tuesday, July 02, 2002 12:57 AM To: [EMAIL PROTECTED]; Grabowy, Chris No, I checked on my 8.1.7.3 database first, and it's there. I don't have app server installed. I have the source to the package anyway. Don't know if it's wrapped now or not, but I don't think so... Nope, not wrapped: $ORACLE_HOME/rdbms/admin/pubpat.sql $ORACLE_HOME/rdbms/admin/privpat.sql Jared On Monday 01 July 2002 13:48, Grabowy, Chris wrote: JS, Doesn't that owa_pattern package come from the PL/SQL Web Toolkit, which requires that you have the Oracle App Server licensed?? -Original Message- Sent: Monday, July 01, 2002 4:23 PM To: Multiple recipients of list ORACLE-L Yes, use regular expressions via the owa_pattern package. Here's an example: declare tstr varchar2(100) := 'this c34ontains s0239everal 2340 numeric 882 dig2its'; begin dbms_output.put_line( tstr); -- remove the digits owa_pattern.change( tstr, '\d', '', 'g'); dbms_output.put_line( tstr); -- remove the extra spaces owa_pattern.change( tstr, '\s+', ' ', 'g'); dbms_output.put_line( tstr); end; / Jared Nils Höglund [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/01/2002 04:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Remove numbers from string Is there any way to remove all numbers from a string? The string might look like this: 'abc123def432' and I wan't it to look like this: 'abcdef'. I'm using Oracle 8. Thanks in advance! -- 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).
RE: Unix - scheduling
Title: Message Possible could use at, and have the job re-schedule itself for 4 weeks when it first starts - just a thought -Original Message-From: Richard Huntley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 11:58 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Unix - scheduling Is a strick 14 day rule absolutely necessary, if not...a much more hassle free way would be to simply schedule the cronjob to run on the 1st and 15th of each month, i.e. # Min Hr Day Mon WkDay Command 0 0 1,15 * * script -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: Re: Unix - scheduling -- Nils Höglund [EMAIL PROTECTED] on 07/02/02 03:28:20 -0800 0 */4 * * * your_command $ man 5 cronttab; The time and date fields are: field allowed values - -- minute 0-59 hour 0-23 day of month 1-31 month 1-12 (or names, see below) day of week 0-7 (0 or 7 is Sun, or use names) A field may be an asterisk (*), which always stands for ``first-last''. Ranges of numbers are allowed. Ranges are two numbers separated with a hyphen. The specified range is inclusive. For example, 8-11 for an ``hours'' entry specifies execution at hours 8, 9, 10 and 11. Lists are allowed. A list is a set of numbers (or ranges) separated by commas. Examples: ``1,2,5,9'', ``0-4,8-12''. : Question: how does "0 */4 * * *" cause something to run every 4 weeks? Unless your version has a different field order. It might work to try "* */628 * * *" but I'm not sure that cron allows n24 for the hourly divisor. The combination of date and weekday can approximate the 4-week cycle. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This message originated from the internet. Its originator may not be who they claim to be and the information contained herein my or may not be Accurate. All Messages are Scaned to be Virus Free, by IPM, powered by McAfee.
RE: Unix - scheduling
Roland, I'm assuming that every 4 weeks means every 28 days which means same day of the week (Every 4th Friday for example) If this meets your requirements then you can try the suggestion at this link: http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x1b397b8d1de3d5118ff40090279 cd0f9,00.html Read A. Clay Stephenson's solution to this. Click the little paper clip in the top right hand corner of his post. You will need that attachment to run with your script. Ed -Original Message- Sent: Tuesday, July 02, 2002 4:43 AM To: Multiple recipients of list ORACLE-L Hallo, anyone who has a good example on how to write in the crontab if you want to schedule a job to run every four week. Is it possible to do that in unix cron job schedule. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552 (b) (4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrade from 9.0.1.2
Did Oracle back port the patch to fix the ANSI-style jonn bug to 9.0.1.2? This bug allows one to read any table in the database despite the permission set. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 02, 2002 8:23 AM To: Multiple recipients of list ORACLE-L Hi, We are currently testing our application on 9.0.1.2 and it looks stable except some bugs with function based indexes. Is it advisable to move to 9.0.1.3 (as it is terminal release of 9.0) or 9.2 which is just released 2 months back (and may have some bugs) OR 9.0.1.2 is stable enough and we can ship our product on this release. Any feedback on 9.0.1.2 is highly appreciated Function based index bugs are not fixes in either of release. Platform are sun 2.8 and WIN2K We have to make decision this week to give QA enough time for testing 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: the ora certified masters cert, yet again - OT
My sincere and humble apologies to Rachel, if my earlier email has offended her. That was not the intention. I believe myself and others that tease and pick on Rachel, do it out of respect and love for her, and would never intentionally mean to offend her. I do not know about other locations and cultures, but in my office we constantly pick and tease on each other. It is those who are never teased that have to worry... If I offend you then please do not hesitate to email me privately or publicly. sarcasm From now on I will just pick on Jared... /sarcasm -Original Message- Sent: Tuesday, July 02, 2002 2:03 AM To: Multiple recipients of list ORACLE-L Personal attacks certainly don't belong here. Best not do it at all. Jared On Wednesday 26 June 2002 19:28, Rachel Carmichael wrote: YO! JARED! has this gotten off-topic yet? since when is picking on Rachel part of the on topic list??? --- Joe Testa [EMAIL PROTECTED] wrote: Chris, feel blessed, she stays during all of mine and asks bizarre questions :), like: If 2 control files are being updated at the same time and one is on raid-5 and the other on raid 0+1, which one will be finished updating first. joe Grabowy, Chris wrote: Matt, she walked out in the middle of your presentation?? Your lucky. She walked out of mine at the beginning, shaking her head. Oh well... -Original Message- Sent: Wednesday, June 26, 2002 5:40 PM To: Multiple recipients of list ORACLE-L well, if so, I'll finally get to see you present and won't have to walk out in the middle --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] wrote: Right now, I think Susan has me from 1-2, right after lunch, but I'm not sure. The OOUG web site is a little sparse on details. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Wednesday, June 26, 2002 4:50 PM To: Multiple recipients of list ORACLE-L But Mtt... you were always scheduled at either the same time *I* was presenting (trust me, I'd rather have gone to yours, I get stage fright) or when at LEAST 2 other presentations I wanted to see equally as much were there. Um, what time are you presenting at OOUG? My flight home is at 5, I have to leave around 2:30 or so --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] wrote: But Rachel, you never came to any of my presentations! (in my best whiney voice) At least you'll get to see me present in July at OOUG. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Wednesday, June 26, 2002 3:56 PM To: Multiple recipients of list ORACLE-L that's 'cause you present well and have knowledge or.. to quote one of my favorite shows: he has much knowledge. we must build an altar and worship him :) --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] wrote: Actually, I had to miss this years (even though I was orginally schedule to give two presentations) due to a medical situation. I gave four the year before that. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Wednesday, June 26, 2002 1:09 PM To: Multiple recipients of list ORACLE-L OK. As the DBA Focus Area Manager for the IOUG, we do our best to weed out the fluff. If you were at IOUG this year, you should have noticed a significant reduction in the marketing fluff and more technical content. Yes, some showmanship is necessary when giving a presentation, but the content has to be there. Many people on this forum have submitted presentations to my track and then complained that they were not accepted. Let me give you some concrete numbers. This year, we received over 400 abstracts for the DBA track alone and accepted only 80. If one slips through the cracks, it won't a second time. Believe me when I say that 2002 was the best content-organized IOUG. Further comments? Submit an abstract for 2003 and find out!!! Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 === message truncated === __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services
RE: Oracle 9i, can't break it?
They made changes to MetaLink over the weekend, I cannot search for my own TARs because of the country code. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 02, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject:Oracle 9i, can't break it? Guess who did? MetaLink V2 - Note An error occured while trying to query the system. Please try again later [CODE : -12541 ] Be careful what you wish for, you just might get it!! Dick Goulet -- 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrade from 9.0.1.2 - NOPE!
I'm pretty sure this has not been done... NOBODY(!) should be on 9012 in production - unless you're happy with zero security. As well as the reading-anything as Ian points out, with a little bit of playing around its also possible to destroy any data in the database (since a view is updatable if it is formed correctly) Can't break it, can't break in Hmm :-) hth Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: Did Oracle back port the patch to fix the ANSI-style jonn bug to 9.0.1.2? This bug allows one to read any table in the database despite the permission set. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 02, 2002 8:23 AM To: Multiple recipients of list ORACLE-L Hi, We are currently testing our application on 9.0.1.2 and it looks stable except some bugs with function based indexes. Is it advisable to move to 9.0.1.3 (as it is terminal release of 9.0) or 9.2 which is just released 2 months back (and may have some bugs) OR 9.0.1.2 is stable enough and we can ship our product on this release. Any feedback on 9.0.1.2 is highly appreciated Function based index bugs are not fixes in either of release. Platform are sun 2.8 and WIN2K We have to make decision this week to give QA enough time for testing 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rule Based Hint
Sometimes a full table scan is better than an index lookup. Sometimes not. Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Monday, July 01, 2002 6:27 PM To: Multiple recipients of list ORACLE-L My queries are running exceptionally good with a rule based optimizer and the cost based is doing a full table scan for the same. Is it good idea to put the RULE hint..? or is there anything I am missing. All my tables are properly analyzed. I thought I should avoid RULE hint as much as possible. any suggestions/comments on this pls.. Thanks in Advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kkennedy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Need some advice
Folks, Since good old MetaSh t is once again having problems, as well as the help line I need to know if any of you have run into the following before: PENGUIN:8.1:SYS alter package utl_tcp compile body; alter package utl_tcp compile body * ERROR at line 1: ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [], [] ORA-06553: PLS-801: internal error [56319] We moved this database from one server to a replacement. Same versions of Oracle and the OS. But now these errors are showing up in several places. Haven't released this yet to the assembly line folks, mainly because I don't have to they took the week off. Any ideas? I'm thinking I need to re-run catalog catproc. Dick Goulet -- 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: the ora certified masters cert, yet again - OT
You just can't forget about that dbms_output/trigger thing, can you? ;) Jared Grabowy, Chris [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/02/2002 10:51 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: the ora certified masters cert, yet again - OT My sincere and humble apologies to Rachel, if my earlier email has offended her. That was not the intention. I believe myself and others that tease and pick on Rachel, do it out of respect and love for her, and would never intentionally mean to offend her. I do not know about other locations and cultures, but in my office we constantly pick and tease on each other. It is those who are never teased that have to worry... If I offend you then please do not hesitate to email me privately or publicly. sarcasm From now on I will just pick on Jared... /sarcasm -Original Message- Sent: Tuesday, July 02, 2002 2:03 AM To: Multiple recipients of list ORACLE-L Personal attacks certainly don't belong here. Best not do it at all. Jared On Wednesday 26 June 2002 19:28, Rachel Carmichael wrote: YO! JARED! has this gotten off-topic yet? since when is picking on Rachel part of the on topic list??? --- Joe Testa [EMAIL PROTECTED] wrote: Chris, feel blessed, she stays during all of mine and asks bizarre questions :), like: If 2 control files are being updated at the same time and one is on raid-5 and the other on raid 0+1, which one will be finished updating first. joe Grabowy, Chris wrote: Matt, she walked out in the middle of your presentation?? Your lucky. She walked out of mine at the beginning, shaking her head. Oh well... -Original Message- Sent: Wednesday, June 26, 2002 5:40 PM To: Multiple recipients of list ORACLE-L well, if so, I'll finally get to see you present and won't have to walk out in the middle --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] wrote: Right now, I think Susan has me from 1-2, right after lunch, but I'm not sure. The OOUG web site is a little sparse on details. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Wednesday, June 26, 2002 4:50 PM To: Multiple recipients of list ORACLE-L But Mtt... you were always scheduled at either the same time *I* was presenting (trust me, I'd rather have gone to yours, I get stage fright) or when at LEAST 2 other presentations I wanted to see equally as much were there. Um, what time are you presenting at OOUG? My flight home is at 5, I have to leave around 2:30 or so --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] wrote: But Rachel, you never came to any of my presentations! (in my best whiney voice) At least you'll get to see me present in July at OOUG. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Wednesday, June 26, 2002 3:56 PM To: Multiple recipients of list ORACLE-L that's 'cause you present well and have knowledge or.. to quote one of my favorite shows: he has much knowledge. we must build an altar and worship him :) --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] wrote: Actually, I had to miss this years (even though I was orginally schedule to give two presentations) due to a medical situation. I gave four the year before that. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Wednesday, June 26, 2002 1:09 PM To: Multiple recipients of list ORACLE-L OK. As the DBA Focus Area Manager for the IOUG, we do our best to weed out the fluff. If you were at IOUG this year, you should have noticed a significant reduction in the marketing fluff and more technical content. Yes, some showmanship is necessary when giving a presentation, but the content has to be there. Many people on this forum have submitted presentations to my track and then complained that they were not accepted. Let me give you some concrete numbers. This year, we received over 400 abstracts for the DBA track alone and accepted only 80. If one slips through the cracks, it won't a second time. Believe me when I say that 2002 was the best content-organized IOUG. Further comments? Submit an abstract for 2003 and find out!!! Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350
Re: Unix - scheduling
If you can't do things carefully, you probably won't
make it too long as a DBA anyway.
Not using 'crontab -e' *is* being careful. :)
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/02/2002 10:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Unix - scheduling
Aww, come on, crontab -e isn't that bad! The most dangerous thing
about it is accidentally running crontab -r instead of -e. Using crontab
-e is no worse than using a wildcard with the rm command, i.e. 'rm a *'
instead of 'rm a*'. One deletes all files that start with 'a', the other
deletes a file named 'a' plus everything else in your directory. Like
anything else, just be careful when you're using crontab and you shouldn't
have any problems. If you can't do things carefully, you probably won't
make it too long as a DBA anyway.
Although, if you are a vi novice and using it to edit your crontab,
then I would agree with Jared. A few wrong keystrokes in command mode and
you can trash a file real quick
Just my $.02,
Alan
P.S. I do recommend making a backup of your crontab occasionally
though
Jared Still
jkstill@cybco To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
n.com cc:
Sent by: Subject: Re: Unix -
scheduling
[EMAIL PROTECTED]
om
07/02/02 09:03
AM
Please respond
to ORACLE-L
Please don't use 'crontab -e', unless you are saving your
crontab files and using some form of version control on them.
'crontabe -e' is inherently dangerous, as it is too easy to remove
lines unintentionally, and then they are gone for good.
Jared
On Tuesday 02 July 2002 04:28, Nils Höglund wrote:
anyone who has a good example on how to write in the crontab if you
want
to schedule a job to run every four week. Is it possible to do that in
unix cron job schedule.
Yes, it is very possible.
Run 'crontab -e' as apropeate user. Your $EDITOR will open.
Write as described in crontab(5) manual ('man 5 crontab'):
0 */4 * * * your_command
This will run your_command every four hours (first field which minutes,
second field in which hours)
You can also edit the /etc/crontab-file (if avaible on your system.)
This
file has a different syntax (you specify the user who is going to run
the
command too.)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Remove numbers from string
Really? I didn't realize you were on the advance copy list. :) Jared Grabowy, Chris [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/02/2002 10:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Remove numbers from string Sigh. There are way too many packages in Oracle. Thanks Jared. I have to share this with a developer struggling to write some parsing functions. I'll take back all the bad reviews I posted on bookpool.com about your book... -Original Message- Sent: Tuesday, July 02, 2002 12:57 AM To: [EMAIL PROTECTED]; Grabowy, Chris No, I checked on my 8.1.7.3 database first, and it's there. I don't have app server installed. I have the source to the package anyway. Don't know if it's wrapped now or not, but I don't think so... Nope, not wrapped: $ORACLE_HOME/rdbms/admin/pubpat.sql $ORACLE_HOME/rdbms/admin/privpat.sql Jared On Monday 01 July 2002 13:48, Grabowy, Chris wrote: JS, Doesn't that owa_pattern package come from the PL/SQL Web Toolkit, which requires that you have the Oracle App Server licensed?? -Original Message- Sent: Monday, July 01, 2002 4:23 PM To: Multiple recipients of list ORACLE-L Yes, use regular expressions via the owa_pattern package. Here's an example: declare tstr varchar2(100) := 'this c34ontains s0239everal 2340 numeric 882 dig2its'; begin dbms_output.put_line( tstr); -- remove the digits owa_pattern.change( tstr, '\d', '', 'g'); dbms_output.put_line( tstr); -- remove the extra spaces owa_pattern.change( tstr, '\s+', ' ', 'g'); dbms_output.put_line( tstr); end; / Jared Nils Höglund [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/01/2002 04:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Remove numbers from string Is there any way to remove all numbers from a string? The string might look like this: 'abc123def432' and I wan't it to look like this: 'abcdef'. I'm using Oracle 8. Thanks in advance! -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
LogMiner errors
I tried to run LogMiner to view transactions on Oracle8.0 using LogMiner and
received following errors. Can someone please help me to fix errors. This
is HIGH priority that I am working to try to find out who messed up our
database per my Manager.
SQL begin
2 sys.dbms_logmnr.start_logmnr(
3 DictFileName = '/export/home/oracle/LogMiner/dictionary.ora',
4 StartTime = to_date('01-Jul-2002 08:00:00AM','DD-MON-
HH:MI:SSAM'),
5 EndTime = to_date('02-Jul-2002 12:00:00AM','DD-MON- HH:MI:SSAM'));
6 end;
7 /
begin
*
ERROR at line 1:
ORA-01280: Fatal LogMiner Error.
ORA-06512: at SYS.DBMS_LOGMNR, line 42
ORA-06512: at line 2
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: system event waits
And that package would be... ? Jared K Gopalakrishnan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/01/2002 01:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: system event waits John: There is an undocumented package thru which you can reset few of the timings. (It resets the timing info in X$KCFIO and the MAX_WAIT_TIME (!) in the V$SESSION/SYSTEM event views. --- John Kanagaraj [EMAIL PROTECTED] wrote: Depending on the version of the database, timed_statistics may be dynamic and not require a database bounce. True - but the timing values are meaningless unless the counters (TOTAL_WAITS and TOTAL_TIMEOUTS) are reset. Only a bounce resets the counters and switches on timing at the same time I wouldn't recommend using the time values otherwise. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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: system event waits
SQL desc dbms_system PROCEDURE DIST_TXN_SYNC Argument Name TypeIn/Out Default? -- --- -- INST_NUM NUMBER IN PROCEDURE KCFRMS PROCEDURE KSDDDT PROCEDURE KSDFLS PROCEDURE KSDIND Argument Name TypeIn/Out Default? -- --- -- LVLBINARY_INTEGER IN PROCEDURE KSDWRT Argument Name TypeIn/Out Default? -- --- -- DEST BINARY_INTEGER IN TSTVARCHAR2IN PROCEDURE READ_EV Argument Name TypeIn/Out Default? -- --- -- IEVBINARY_INTEGER IN OEVBINARY_INTEGER OUT PROCEDURE SET_BOOL_PARAM_IN_SESSION Argument Name TypeIn/Out Default? -- --- -- SIDNUMBER IN SERIAL#NUMBER IN PARNAM VARCHAR2IN BVAL BOOLEAN IN PROCEDURE SET_EV Argument Name TypeIn/Out Default? -- --- -- SI BINARY_INTEGER IN SE BINARY_INTEGER IN EV BINARY_INTEGER IN LE BINARY_INTEGER IN NM VARCHAR2IN PROCEDURE SET_INT_PARAM_IN_SESSION Argument Name TypeIn/Out Default? -- --- -- SIDNUMBER IN SERIAL#NUMBER IN PARNAM VARCHAR2IN INTVAL BINARY_INTEGER IN PROCEDURE SET_SQL_TRACE_IN_SESSION Argument Name TypeIn/Out Default? -- --- -- SIDNUMBER IN SERIAL#NUMBER IN SQL_TRACE BOOLEAN IN PROCEDURE WAIT_FOR_EVENT Argument Name TypeIn/Out Default? -- --- -- EVENT VARCHAR2IN EXTENDED_IDBINARY_INTEGER IN TIMEOUTBINARY_INTEGER IN SQL [EMAIL PROTECTED] wrote: And that package would be... ? Jared K Gopalakrishnan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/01/2002 01:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: system event waits John: There is an undocumented package thru which you can reset few of the timings. (It resets the timing info in X$KCFIO and the MAX_WAIT_TIME (!) in the V$SESSION/SYSTEM event views. --- John Kanagaraj [EMAIL PROTECTED] wrote: Depending on the version of the database, timed_statistics may be dynamic and not require a database bounce. True - but the timing values are meaningless unless the counters (TOTAL_WAITS and TOTAL_TIMEOUTS) are reset. Only a bounce resets the counters and switches on timing at the same time I wouldn't recommend using the time values otherwise. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see
RE: the ora certified masters cert, yet again - OT
My note must have been missing the smiley but you guys WERE picking on me :) (MOO make him stop! G) --- Grabowy, Chris [EMAIL PROTECTED] wrote: My sincere and humble apologies to Rachel, if my earlier email has offended her. That was not the intention. I believe myself and others that tease and pick on Rachel, do it out of respect and love for her, and would never intentionally mean to offend her. I do not know about other locations and cultures, but in my office we constantly pick and tease on each other. It is those who are never teased that have to worry... If I offend you then please do not hesitate to email me privately or publicly. sarcasm From now on I will just pick on Jared... /sarcasm -Original Message- Sent: Tuesday, July 02, 2002 2:03 AM To: Multiple recipients of list ORACLE-L Personal attacks certainly don't belong here. Best not do it at all. Jared On Wednesday 26 June 2002 19:28, Rachel Carmichael wrote: YO! JARED! has this gotten off-topic yet? since when is picking on Rachel part of the on topic list??? --- Joe Testa [EMAIL PROTECTED] wrote: Chris, feel blessed, she stays during all of mine and asks bizarre questions :), like: If 2 control files are being updated at the same time and one is on raid-5 and the other on raid 0+1, which one will be finished updating first. joe Grabowy, Chris wrote: Matt, she walked out in the middle of your presentation?? Your lucky. She walked out of mine at the beginning, shaking her head. Oh well... -Original Message- Sent: Wednesday, June 26, 2002 5:40 PM To: Multiple recipients of list ORACLE-L well, if so, I'll finally get to see you present and won't have to walk out in the middle --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] wrote: Right now, I think Susan has me from 1-2, right after lunch, but I'm not sure. The OOUG web site is a little sparse on details. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Wednesday, June 26, 2002 4:50 PM To: Multiple recipients of list ORACLE-L But Mtt... you were always scheduled at either the same time *I* was presenting (trust me, I'd rather have gone to yours, I get stage fright) or when at LEAST 2 other presentations I wanted to see equally as much were there. Um, what time are you presenting at OOUG? My flight home is at 5, I have to leave around 2:30 or so --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] wrote: But Rachel, you never came to any of my presentations! (in my best whiney voice) At least you'll get to see me present in July at OOUG. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Wednesday, June 26, 2002 3:56 PM To: Multiple recipients of list ORACLE-L that's 'cause you present well and have knowledge or.. to quote one of my favorite shows: he has much knowledge. we must build an altar and worship him :) --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] wrote: Actually, I had to miss this years (even though I was orginally schedule to give two presentations) due to a medical situation. I gave four the year before that. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Wednesday, June 26, 2002 1:09 PM To: Multiple recipients of list ORACLE-L OK. As the DBA Focus Area Manager for the IOUG, we do our best to weed out the fluff. If you were at IOUG this year, you should have noticed a significant reduction in the marketing fluff and more technical content. Yes, some showmanship is necessary when giving a presentation, but the content has to be there. Many people on this forum have submitted presentations to my track and then complained that they were not accepted. Let me give you some concrete === message truncated === __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: SQL*Plus/UTL_FILE vs. 3'rd Party Data Extraction
Perl is very fast, very flexible, and quite inexpensive. :) See my post earlier today that includes the TOC from Perl for Oracle DBA's Jared Post, Ethan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/02/2002 09:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:SQL*Plus/UTL_FILE vs. 3'rd Party Data Extraction I have some people who are asking about 3'rd party data extraction tools to pull data from Oracle into text files for loading a data warehouse. I am not sure what the size of the project is but I think it is pretty big. The DW is Terradata. Anyway, they are stating Oracle tools are too slow. They do not define slow so it is hard to argue with them. My opinion is that it is very dependent on hardware (CPU/Disk) in most cases. What are your opinions on the matter, do you need 3'rd party? What tools are you using (I am aware of Informatica and such but I think they are looking for something a little cheaper)? Thanks, Ethan Post -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: the ora certified masters cert, yet again - OT
ok, ok...were even. -Original Message- Sent: Tuesday, July 02, 2002 1:13 PM To: [EMAIL PROTECTED] Cc: Grabowy, Chris You just can't forget about that dbms_output/trigger thing, can you? ;) Jared Grabowy, Chris [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/02/2002 10:51 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: the ora certified masters cert, yet again - OT My sincere and humble apologies to Rachel, if my earlier email has offended her. That was not the intention. I believe myself and others that tease and pick on Rachel, do it out of respect and love for her, and would never intentionally mean to offend her. I do not know about other locations and cultures, but in my office we constantly pick and tease on each other. It is those who are never teased that have to worry... If I offend you then please do not hesitate to email me privately or publicly. sarcasm From now on I will just pick on Jared... /sarcasm -Original Message- Sent: Tuesday, July 02, 2002 2:03 AM To: Multiple recipients of list ORACLE-L Personal attacks certainly don't belong here. Best not do it at all. Jared On Wednesday 26 June 2002 19:28, Rachel Carmichael wrote: YO! JARED! has this gotten off-topic yet? since when is picking on Rachel part of the on topic list??? --- Joe Testa [EMAIL PROTECTED] wrote: Chris, feel blessed, she stays during all of mine and asks bizarre questions :), like: If 2 control files are being updated at the same time and one is on raid-5 and the other on raid 0+1, which one will be finished updating first. joe Grabowy, Chris wrote: Matt, she walked out in the middle of your presentation?? Your lucky. She walked out of mine at the beginning, shaking her head. Oh well... -Original Message- Sent: Wednesday, June 26, 2002 5:40 PM To: Multiple recipients of list ORACLE-L well, if so, I'll finally get to see you present and won't have to walk out in the middle --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] wrote: Right now, I think Susan has me from 1-2, right after lunch, but I'm not sure. The OOUG web site is a little sparse on details. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Wednesday, June 26, 2002 4:50 PM To: Multiple recipients of list ORACLE-L But Mtt... you were always scheduled at either the same time *I* was presenting (trust me, I'd rather have gone to yours, I get stage fright) or when at LEAST 2 other presentations I wanted to see equally as much were there. Um, what time are you presenting at OOUG? My flight home is at 5, I have to leave around 2:30 or so --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] wrote: But Rachel, you never came to any of my presentations! (in my best whiney voice) At least you'll get to see me present in July at OOUG. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Wednesday, June 26, 2002 3:56 PM To: Multiple recipients of list ORACLE-L that's 'cause you present well and have knowledge or.. to quote one of my favorite shows: he has much knowledge. we must build an altar and worship him :) --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] wrote: Actually, I had to miss this years (even though I was orginally schedule to give two presentations) due to a medical situation. I gave four the year before that. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- Sent: Wednesday, June 26, 2002 1:09 PM To: Multiple recipients of list ORACLE-L OK. As the DBA Focus Area Manager for the IOUG, we do our best to weed out the fluff. If you were at IOUG this year, you should have noticed a significant reduction in the marketing fluff and more technical content. Yes, some showmanship is necessary when giving a presentation, but the content has to be there. Many people on this forum have submitted presentations to my track and then complained that they were not accepted. Let me give you some concrete numbers. This year, we received over 400 abstracts for the DBA track alone and accepted only 80. If one slips through the cracks, it won't a second time. Believe me when I say that 2002 was the best content-organized IOUG. Further comments? Submit an abstract for 2003 and find out!!! Thank You
Re: Unix - scheduling
-- Ron Thomas [EMAIL PROTECTED] on 07/02/02 09:03:26 -0800 0 */4 * * * your_command The */4 must be linux. This is not available on HP-UX 11.0. Introduced by Paul Vixie into vixiecron, subsequently adopted by a number of cron implementations. HP's is, unfortunately, not one of them. Sun's might, AIX doesn't. The Schedule::Cron module does support this notation, along with adding any other extenders you like since you can have your own dispatcher. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- 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).
9.2 and Microsoft ODBC driver issues
Hi, We are testing our application on 9.2 and getting errors using Microsoft ODBC Driver. we are having MDAC 2.7 installed on the machine. Is anyone also encountered some errors using 9.2 with Microsoft odbc driver and how u reslove the issues?? 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: system event waits
Wild guess dbms_system.KCFRMS ?? If it is true, thanks to Kirti ... 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! -Original Message- Sent: Tuesday, July 02, 2002 2:19 PM To: Multiple recipients of list ORACLE-L And that package would be... ? Jared *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
Re: OPS and redos
Fawzia, What are you querying to get the SCN information. I would also be curious where you read about the recovery issues in OPS environment? Oracle maintains what is called a snapshot SCN and global SCN. The snapshot SCN is usually maintained in the SGA and the global SCN is maintained by the DLM. All transactions committed in an OPS environment use the global SCN and that SCN is always incrementing even in if both instances are idle. In an OPS environment it is possible for multiple transactions on different nodes to commit with the same SCN but each transaction will commit with an SCN that is greater whether these transactions are on the same node or different nodes. The bottom line is that Oracle basically treats SCN's with committed transactions the same whether it is a single instance or OPS. The snapshot SCN is used for queries and the snapshot SCN could be older than current or global SCN. This SCN only effects queries not DML. The only issue here is using this snapshot SCN could give read consistency on transactions that where committed on the on the other node. an example Time 10:00:00 - Node2 issues DML and commits updates deptno from 10 to 11 committed with current SCN 1000, current SCN is now incremented to 1001 Time 10:00:01 - Node1 issues a select on deptno and sees 10 (should see 11 because the transaction was commmited) because the snapshot SCN is 998 and the transaction was committed with newer SCN we must perform a read consistent read. PMON is the process that synchs current or global SCN with the snapshot SCN and PMON usually does this every 3 seconds so if you issue the query Time 10:00:05 (5 seconds after the commit) - Node1 issues the select on deptno and now sees 11. This is because PMON sync-ed up the snapshot SCN with the current or global SCN and now my SCN for my query is newer than the SCN the transaction you committed with so there is no need to perform a CR you can just use the current version. The above issue is really only a problem is a system if you have a lot of DML on 1 node and a lot of selects on the other node. It this is an issue you can set MAX_COMMIT_PROPAGATION_DELAY=0 and this will force the queries to always use the current or global SCN and now you should see the committed data as soon as it is committed because both the DML and queries are use the current or global SCN. I find odd that you have SCN of 500 and 2000. The way Oracle maintains SCN's in an OPS environment shouldn't allow for this large of a gap in SCN's. This looks more like log sequence numbers not SCN's. If these are indeed log sequence then this gap is not an issue. Recovery is based more on SCN's not log sequence numbers. If the gap in the log sequence gets to big Oracle will force the idle node to do log switches and if you are archiving you will see archive logs 1 OS block in size. When Oracle does this you should a KK #34;Redo log Kick#34; lock being allocated. Hope this helps, Scott --- #34;Malik, Fawzia#34; lt;[EMAIL PROTECTED]gt; wrote: gt; gt; gt; Hi gurus, gt; gt; I have a query..Basically we have an OPS set up here gt; (8.0.6) and I have gt; noticed that the scn on node A is 500 and the scn on gt; node B is 2000. I am gt; concerned about this w.r.t recovery- surely this gt; would be an issue ??I gt; logged a call with oracle and they said it wasnt an gt; issue, but then I read gt; in a document that it WAS an issue and could gt; potentially lose everything gt; between 500 abd 2000..and that the workaround would gt; be to add more logs to A gt; or to modify the check point interval gt; gt; Please can you advise?? gt; gt; Rgds gt; gt; Fawzia gt; gt; gt; ** gt; Information in this email is confidential and may be gt; privileged. gt; It is intended for the addressee only. If you have gt; received it in error, gt; please notify the sender immediately and delete it gt; from your system. gt; You should not otherwise copy it, retransmit it or gt; use or disclose its gt; contents to anyone. gt; Thank you for your co-operation. gt; ** gt; gt; -- gt; Please see the official ORACLE-L FAQ: gt; http://www.orafaq.com gt; -- gt; Author: Malik, Fawzia gt; INET: [EMAIL PROTECTED] gt; gt; Fat City Network Services-- (858) 538-5051 FAX: gt; (858) 538-5051 gt; San Diego, California-- Public Internet gt; access / Mailing Lists gt; gt; To REMOVE yourself from this mailing list, send an gt; E-Mail message gt; to: [EMAIL PROTECTED] (note EXACT spelling of gt; 'ListGuru') and in gt; the message BODY, include a line containing: UNSUB gt; ORACLE-L gt; (or the name of mailing list you want to be removed gt; from). You may gt; also send the HELP command for other information gt; (like subscribing). __ Do You
RE: Oracle 9i, can't break it?
Could be a Euro conversion problem. I do remember that Oracle had not completed much of this work in time. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, July 02, 2002 11:00 AM To: Multiple recipients of list ORACLE-L Subject:Re: Oracle 9i, can't break it? For those of you in the Oracle Partner program, here's what looks like another little bug to add to the 'Unbreakable' list... Log into the Oracle partner network at http://oraclepartnernetwork.oracle.com/ and look for the Product Query Tool under 'Pricing' - It gives the cost of the various Oracle options in various currencies. Choose Enterprise Edition, try to get a price in Italy and it completly fails to cope with the currency conversion, resulting in a price of 0. for a two-year user license, with the same for support and upgrade. I can only assume that nobody in Italy is an Oracle Partner, or they're keeping very quiet about getting the Database for free... Somebody tell me this stuff doesn't run on Oracle software. Simon Anderson -- 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 some advice
I recently moved from one server to another and found that many of the system object where invalid. I reran catalog.sql and catproc.sql and this corrected the problems for me... give that a try. Melanie -Original Message- Sent: Tuesday, July 02, 2002 1:05 PM To: Multiple recipients of list ORACLE-L Folks, Since good old MetaSh t is once again having problems, as well as the help line I need to know if any of you have run into the following before: PENGUIN:8.1:SYS alter package utl_tcp compile body; alter package utl_tcp compile body * ERROR at line 1: ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [], [] ORA-06553: PLS-801: internal error [56319] We moved this database from one server to a replacement. Same versions of Oracle and the OS. But now these errors are showing up in several places. Haven't released this yet to the assembly line folks, mainly because I don't have to they took the week off. Any ideas? I'm thinking I need to re-run catalog catproc. Dick Goulet -- 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: Root, Melanie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: system event waits
DBMS_SYSTEM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 12:19 PM And that package would be... ? Jared K Gopalakrishnan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/01/2002 01:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: system event waits John: There is an undocumented package thru which you can reset few of the timings. (It resets the timing info in X$KCFIO and the MAX_WAIT_TIME (!) in the V$SESSION/SYSTEM event views. --- John Kanagaraj [EMAIL PROTECTED] wrote: Depending on the version of the database, timed_statistics may be dynamic and not require a database bounce. True - but the timing values are meaningless unless the counters (TOTAL_WAITS and TOTAL_TIMEOUTS) are reset. Only a bounce resets the counters and switches on timing at the same time I wouldn't recommend using the time values otherwise. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 - scheduling
-- Hand, Michael T [EMAIL PROTECTED] on 07/02/02 08:13:32 -0800 Roland, crontab alone will not meet your needs. Hint: check the date command and MOD type fuctionality in a shell script. The at command will normally take number of days from now as the when to run argument. Simply have the job re-submit itself and output an error message if at returns non-zero. This will give you one-minute resolution on the start times with arbitrary re-run intervals as required for you program (in this case, 14 or 28 days). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- 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: Oracle 9i, can't break it?
Your country code, my country code. I guess we're all One Big Happy World under Oracle, because I can't work on any of my TARs, either. (Don't even axe why *I* have to work on them...) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 9i, can't break it? They made changes to MetaLink over the weekend, I cannot search for my own TARs because of the country code. Regards, Patrice Boivin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i, can't break it?
I would say it is unbreakable. Can't break what's already broke. -Original Message- Sent: Tuesday, July 02, 2002 2:49 PM To: Multiple recipients of list ORACLE-L In other words, it is unbreakable. Can't get in... Can't break in... Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, July 02, 2002 1:44 PM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle 9i, can't break it? They made changes to MetaLink over the weekend, I cannot search for my own TARs because of the country code. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 02, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject:Oracle 9i, can't break it? Guess who did? MetaLink V2 - Note An error occured while trying to query the system. Please try again later [CODE : -12541 ] Be careful what you wish for, you just might get it!! Dick Goulet -- 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 message originated from the internet. Its originator may not be who they claim to be and the information contained herein my or may not be Accurate. All Messages are Scaned to be Virus Free, by IPM, powered by McAfee. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Cupp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i, can't break it?
In other words, it is unbreakable. Can't get in... Can't break in... Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, July 02, 2002 1:44 PM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle 9i, can't break it? They made changes to MetaLink over the weekend, I cannot search for my own TARs because of the country code. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 02, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject:Oracle 9i, can't break it? Guess who did? MetaLink V2 - Note An error occured while trying to query the system. Please try again later [CODE : -12541 ] Be careful what you wish for, you just might get it!! Dick Goulet -- 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: system event waits
Wild guess dbms_system.KCFRMS ?? If it is true, thanks to Kirti ... No luck using this one on 8.1.6/8.1.7/9.0.1... Any gotchas? John -- 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: Unix - scheduling
not available on Sun (vers 5.8) - just tried it. nor Digital UNIX. cool though ;-) -Original Message- Sent: Tuesday, July 02, 2002 1:39 PM To: Multiple recipients of list ORACLE-L -- Ron Thomas [EMAIL PROTECTED] on 07/02/02 09:03:26 -0800 0 */4 * * * your_command The */4 must be linux. This is not available on HP-UX 11.0. Introduced by Paul Vixie into vixiecron, subsequently adopted by a number of cron implementations. HP's is, unfortunately, not one of them. Sun's might, AIX doesn't. The Schedule::Cron module does support this notation, along with adding any other extenders you like since you can have your own dispatcher. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- 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: STEVE OLLIG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
HTTP Listener configuration assistant
I'm trying to recover from an install that bombed. The final step in the install, and the only step that I still need to perform, was to execute a configuration assistant for Oracle9i's built-in HTTP listener. For the life of me, I can't figure out the executable name to invoke the HTTP configuration assistant. Can anyone enlighten me? Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- 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: Unix - scheduling
Jared,
Point taken. So I guess I like to live on the edge a little... :)
I've been using crontab -e for years without problems though. knock on
wood.
Alan
Jared.Still@ra
disys.comTo: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: Unix - scheduling
om
07/02/02 12:26
PM
Please respond
to ORACLE-L
If you can't do things carefully, you probably won't
make it too long as a DBA anyway.
Not using 'crontab -e' *is* being careful. :)
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/02/2002 10:14 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Unix - scheduling
Aww, come on, crontab -e isn't that bad! The most dangerous thing
about it is accidentally running crontab -r instead of -e. Using crontab
-e is no worse than using a wildcard with the rm command, i.e. 'rm a *'
instead of 'rm a*'. One deletes all files that start with 'a', the other
deletes a file named 'a' plus everything else in your directory. Like
anything else, just be careful when you're using crontab and you shouldn't
have any problems. If you can't do things carefully, you probably won't
make it too long as a DBA anyway.
Although, if you are a vi novice and using it to edit your crontab,
then I would agree with Jared. A few wrong keystrokes in command mode and
you can trash a file real quick
Just my $.02,
Alan
P.S. I do recommend making a backup of your crontab occasionally
though
Jared Still
jkstill@cybco To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
n.com cc:
Sent by: Subject: Re: Unix -
scheduling
[EMAIL PROTECTED]
om
07/02/02 09:03
AM
Please respond
to ORACLE-L
Please don't use 'crontab -e', unless you are saving your
crontab files and using some form of version control on them.
'crontabe -e' is inherently dangerous, as it is too easy to remove
lines unintentionally, and then they are gone for good.
Jared
On Tuesday 02 July 2002 04:28, Nils Höglund wrote:
anyone who has a good example on how to write in the crontab if you
want
to schedule a job to run every four week. Is it possible to do that in
unix cron job schedule.
Yes, it is very possible.
Run 'crontab -e' as apropeate user. Your $EDITOR will open.
Write as described in crontab(5) manual ('man 5 crontab'):
0 */4 * * * your_command
This will run your_command every four hours (first field which minutes,
second field in which hours)
You can also edit the /etc/crontab-file (if avaible on your system.)
This
file has a different syntax (you specify the user who is going to run
the
command too.)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP
RE: system event waits
Here is the original reply ... From: Deshpande, Kirti Date: Thu, 20 Jun 2002 14:35:36 -0500 Subject: RE: DBMS_SYSTEM.KSDWRT question Addition: DBMS_SYSTEM.KCFRMS - resets counters displayed by MAX_WAIT in V$SESSION_EVENT, and MAXIORTM, MAXIOWTM in V$FILESTAT views. - Kirit I do not know the version dependency. 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! -Original Message- Sent: Tuesday, July 02, 2002 3:13 PM To: Multiple recipients of list ORACLE-L Wild guess dbms_system.KCFRMS ?? If it is true, thanks to Kirti ... No luck using this one on 8.1.6/8.1.7/9.0.1... Any gotchas? John -- 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). *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
RE: Unidentified sessions brought us to maximum processes - more
I'm on 8.1.6.2, Solaris 2.6. All the unidentified sessions were active but had no SQL associated with them. Jay Miller -Original Message- Sent: Tuesday, July 02, 2002 3:43 PM To: '[EMAIL PROTECTED]' We just had a problem on our datawarehouse where we hit the maximum number of processes (had never happened before). When I checked in Enterprise Manager and v$sessions I saw dozens of sessions with no username or osusername attached. I was able to resolve the issue with a shutdown abort and restart (after spending 15 minutes to get the requisite approvals). There were no errors in the alert log and no trace files. Nothing odd on the Unix side either. I'll be keeping my eye out for a recurrence and logging a TAR with Oracle but has anyone seen this sort of thing happen before? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Unix - scheduling
The */4 must be linux. This is not available on HP-UX 11.0. It works on BSD-systems too. -- /Nils Höglund, Naqua KB E-mail: [EMAIL PROTECTED] Web:http://www.naqua.se/ Home Phone: +46 (0)18 30 09 19 Cellular Phone: +46 (0)709 91 97 65 Address:Nya Valsätrav. 26 B SE-756 46 Uppsala, Sweden -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?Nils_H=F6glund?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 - scheduling
The */4 must be linux. This is not available on HP-UX 11.0. Introduced by Paul Vixie into vixiecron, subsequently adopted by a number of cron implementations. HP's is, unfortunately, not one of them. Sun's might, AIX doesn't. It does not work on Solaris 8. -- /Nils Höglund, Naqua KB E-mail: [EMAIL PROTECTED] Web:http://www.naqua.se/ Home Phone: +46 (0)18 30 09 19 Cellular Phone: +46 (0)709 91 97 65 Address:Nya Valsätrav. 26 B SE-756 46 Uppsala, Sweden -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?Nils_H=F6glund?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Accessing views across a db link
Title: Accessing views across a db link Accessing a view across a db link takes a while (fetch phase) when a *local* select statement uses a where clause (e.g. select * from view_name@remotedb where columnA = '...';). Does anyone know a way (other than a snapshot or materialized view of the remote data on the local db) to force the result set of data (due to the where clause) to be resolved on the remote side? Thanx, Alan Martin Defense Logistics Information Service Battle Creek, Michigan
Re: Should we upgrade from 9.0.1.2 to 9.2?
Sigh, There are many answers to this question related to the environment you will be deploying into. It sounds like you are actually maintaining many databases. Are all of them really 24x7 (i.e. less than a minute of downtime per year) or can you schedule maintenance in the future that will not affect revenues? Sticking with 9.0.x means having to jump through more hoops in the end and having to live with any issues you have that you cannot address. 9.2 is really more like 9.0.2 with some features bolted on (closer to 8.0.5 in my opinion). You'll have a MUCH easier time getting issues addressed with 9.2 over the long haul ( 8 months). But if you are in a true 24x7 shop, and you have an extensive, exhaustive, thorough QA/UAT cycles with realistic loads, and you are willing to live on an unsupportable system with all that you have running now, then you may want to stick with wherever your testing has put you. In summary, a simplistic view to your situation has you classed into one of two conditions: 1. You do have the ability to patch the OS/Database/Application, but that is very limited AND Your test/QA/UAT cycle will be able to complete with the 9.2 db in place: * Go to 9.2 2. You do NOT have the ability to do anything but put on essential security patches (e.g. less than 60 seconds of downtime in a year) OR You do not have time to go through a test/QA/UAT cycle with 9.2 in place before you go live: * Stick with 9.0.1 I would do all I could to go with 9.2, but some situations simply don't allow for it. --- [EMAIL PROTECTED] wrote: We have a couple of new applications in development that are moving to QA. These databases are currently running 9.0.1.2 on Sun Solaris 2.6. We've been pretty happy with this version to this point but are at a pivotal spot in our product development cycle where we have a narrow window in which we could upgrade to 9.2 before we finish our QA cycle and move the application to production.We will be moving to production in the September timeframe. I know that 9.2 hasn't been out that long so I'm not sure how many people are using it. For those that are using it, what has your experience been? Is it very buggy? Any major problems? We have an OLTP database, a smallish datawarehouse that uses partitioning, and some datamarts that also use partitioning. We do not use MTS or replication. Our character set is UTF8. We will be essentially 24 X 7. These are web-based front-ends. What do you guys think? This OLTP database is very mission critical for us, once it gets to production. Is it worth moving to 9.2 at this point or should we wait awhile until a couple more patchsets come out? How long do people wait for a new release to settle before they move to it? Thanks for your feedback, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Michael P. Sale Author: Oracle9i on Windows 2000 Tips and Techniques __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Sale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 - scheduling
He wanted every 4 weeks - Whoops! I miss-read. Thanks for the correction! -- /Nils Höglund, Naqua KB E-mail: [EMAIL PROTECTED] Web:http://www.naqua.se/ Home Phone: +46 (0)18 30 09 19 Cellular Phone: +46 (0)709 91 97 65 Address:Nya Valsätrav. 26 B SE-756 46 Uppsala, Sweden -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?Nils_H=F6glund?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Redo log
David, Based on the ls output it seems you may have 4 groups with 1 member in groups 1,2 4 but 3 members in group 3. Do a select * from v$log; and see how the logs are really setup. I would suggest you want to have the same number of members in each group. If you want them to switch less often either (a) produce less redo (use logminer to analyse and maybe updates / deletes etc are happening that don't need to) or (b) use bigger logfiles. This assumes they're switching because they're full. How big are the archive logs that are produced - are they all around the same size or are some very small? As for LogMiner - if you're in archive log mode and you've backed up / got a copy of the archive logs from 2 days ago then yes LogMiner will be able to analyse them. Regards, Bruce Reardon -Original Message- Sent: Wednesday, 3 July 2002 2:43 I found couple redo logs in my Oracle8.0.5 database, as shown they are switched every 5 minutes. I'd like to have only two or three logs out there and don't want them to be switched until every 4 hours. Is there a way to control it that way? Secondly, if redo log switchs every 5 minutes, does LogMiner have capability to view transaction history from two days ago? Please advise. $ ls -l redo* -rw-r- 1 oracle dba 512512 Jul 2 11:20 redo01.log -rw-r- 1 oracle dba 512512 Jul 2 11:20 redo02.log -rw-r- 1 oracle dba 512512 Jul 2 11:15 redo03.log -rw-r- 1 oracle dba 512512 Jul 2 11:20 redo03_1.log -rw-r- 1 oracle dba 512512 Jul 2 11:20 redo03_2.log -rw-r- 1 oracle dba 512512 Jul 2 11:15 redo04.log Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Need some advice
Raj, Thanks for the help, but in this case I need to first wash a little egg off of my face. The problem here was at least was easily recoverable. What had happen was we moved a database instance from one machine to another. It's cheaper to run two instances on one box that pay Oracle for 2 boxes, especially when neither is breaking a sweat. OK, not a problem, while one is at it might as well upgrade the original instance from 8.0.5.2.1 to 8.1.7 while we're at it, right? Sure, but make sure you read the CD's first. What I did was install Oracle 8.1.7 32bit instead of 8.1.7 64bit. Damn I hate doing things twice. Dick Goulet Now, where is that bottle of RR?? -- 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: Accessing views across a db link
Alan, This query should be resolved at the remote end. I forget which version of Oracle was the first to know enough to do that. Which version are you on? Have you traced the SQL? Jared Martin, Alan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/02/2002 02:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Accessing views across a db link Accessing a view across a db link takes a while (fetch phase) when a *local* select statement uses a where clause (e.g. select * from view_name@remotedb where columnA = '...';). Does anyone know a way (other than a snapshot or materialized view of the remote data on the local db) to force the result set of data (due to the where clause) to be resolved on the remote side? Thanx, Alan Martin Defense Logistics Information Service Battle Creek, Michigan -- 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: Unix - scheduling
It does not work on Solaris 8. SunOS (a.k.a. BSD) used vixiecron; they dumped it when Solaris went SVR4. You can still find workable copies of Paul's original work (pretty ancient by now). Alternative it to use perl with Schedule::Cron to process the lines. It understands */X notation and passes the entire line to whatever dispatcher you choose -- which can interpret the rest of your cron line as whatever it likes. For example: * */24 * * * */28 /path/to/code Would check for the 28th day ever 24 hours :-) Probably the best bet for something like this is at, however, since it remembers the date + time that the event was scheduled for. This allows re-starting cron any number of times w/o resetting the start date used by at. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- 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).
Oracle names problems on Win2k with Pentium IV
Fellow listers, After upgrading to the latest greatest Pentium 4 desktop ( 2.3 GHZ, 512 Meg of Ram, 80 Gig disk, Yeehah! ) and dealing with the JIT bugs, I find that Oracle names no longer works properly. The folllowing screen dump explains it all. Start names, everything looks hunky dory, exit namesctl, start namesctl again, and it's no longer possible to connect to the names server. Several threads on MetaLink detail the identical problem on Win2k, but none of them provide a solution. Vitals: Oracle 8.1.7.3 Windows 2000 Pentium 4, 2.3 GHZ 512 Meg Ram. Interestingly enough, some have encountered this on Linux, but names on linux is working just fine for me on a Dell box Vitals on the Dell: Dual Pentium 1.3 GHZ 2 Gig Ram Lots o' disk. Any ideas? TIA Jared C:\ C:\namesctl Oracle Names Control for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-JUL-2002 17:33:32 (c) Copyright 1997 Oracle Corporation. All rights reserved. NNL-00018: warning: could not contact default name server Welcome to NAMESCTL, type help for information. NAMESCTL start ns_js001292 Starting names.exe...server successfully started Currently managing name server ns_js001292 Version banner is Oracle Names for 32-bit Windows: Version 8.1.7.2.0 - Production Server name: ns_js001292 Server has been running for: 2.04 seconds Request processing enabled: yes Request forwarding enabled: yes Requests received:0 Requests forwarded: 0 Foreign data items cached:0 Region data next checked for reload in: not set Region data reload check failures:0 Cache next checkpointed in: 59 minutes 57.93 seconds Cache checkpoint interval:1 hour Cache checkpoint file name: C:\oracle\ora81\network\names\ckpcch.ora Statistic counters next reset in: not set Statistic counter reset interval: not set Statistic counters next logged in:not set Statistic counter logging interval: not set Trace level: 6 Trace file name: C:\oracle\ora81\network\trace\names_536.trc Log file name: C:\oracle\ora81\network\log\names.log System parameter file name: C:\oracle\ora81\network\admin\names.ora Command-line parameter file name: Administrative region name: Administrative region description: ApplTable Index: 0 Contact Operational Status0 Save Config on Stop no NAMESCTL exit NL-00851: NAMESCTL finished C:\namesctl Oracle Names Control for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-JUL-2002 17:33:50 (c) Copyright 1997 Oracle Corporation. All rights reserved. NNL-00018: warning: could not contact default name server Welcome to NAMESCTL, type help for information. NAMESCTL set server ns_js001292 NNL-00010: error getting address for server ns_js001292 NNC-00406: name does not exist NAMESCTL -- 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: Accessing views across a db link
Title: Accessing views across a db link Try this: select --+ DRIVING_SITE(rv) * from view_name@remotedb rv where columnA = '...'; - Regards, Waleed -Original Message-From: Martin, Alan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 02, 2002 5:28 PMTo: Multiple recipients of list ORACLE-LSubject: Accessing views across a db link Accessing a view across a db link takes a while (fetch phase) when a *local* select statement uses a "where" clause (e.g. select * from view_name@remotedb where columnA = '...';). Does anyone know a way (other than a snapshot or materialized view of the remote data on the local db) to force the result set of data (due to the "where" clause) to be resolved on the remote side? Thanx, Alan Martin Defense Logistics Information Service Battle Creek, Michigan
