Re: Any do's and dont's for a 9i oracle installation on RedHat Linux
Hi, Suse7.2 is certified with 9.0.1. It will never be certified with 9.2 and later versions. Suse has a special product SLES - Suse Linux Enterprise Server. It's based on Suse 7.2 and include many official patches and upgrades. Afaik, with Suse 7.2 you may not upgrade your kernel and be certified with Oracle. (7.2 out-of-the-box has 2.4.4) It's not always the problem, but you have a chance to forget about Oracle support when you critically need it. The current politic of Suse regarding Oracle is to support new products from now (or some time in the past) on SLES. So it's certified with 9iR2 (including RAC), iAS 9iR2, Apps 11i. Btw, Suse guys claim that Oracle uses Suse as linux development platform. I know RH has something like Suse's SLES... called RH AS (advanced server), but dunno much about it. We use 7.2 (plus 2.4.16 kernel) for several servers and pretty much happy with it. However, we will move to SLES soon. Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 5:23 PM Linux Hi Ray, I have Oracle 8.1.7 and 9.0.1 running on an Suse 7.2 box configured with ext3 file systems. Both instances are working properly and without major issues. Suse 7.2 comes along with a variety of file systems , including ReiserFS , ext3 , ext2 , Aix´s JFS and other that I can´t recall now. Regards, Antonio Belloni Ray Stell [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L u[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Any do's and dont's for a 9i oracle installation on RedHat Linux 29/08/02 10:38 Please respond to ORACLE-L Not on the oracle topic: RH is pretty insecure out of the box. If you don't take steps to lock it down the machine will be compromised within the hour in our experience. There are some good web pages out on the steps that need to be taken: http://www.sans.org/newlook/projects/bastille_linux.htm http://www.sci.sdsu.edu/People/Bill/basic_sec.html I'd suggest the use of iptables: http://www.cs.princeton.edu/~jns/security/iptables/ That said, I have a screaming 8.1.7.4 server running on RH 7.1. I am unhappy with the oracle support matrix for RH, however. It seems to have stalled a 7.1. I'm thinking of giving SuSE 7.2 a run since it is supported, hoping the ext3 filesystem is there. RH7.1 only has ext2. The seemed to be pushing the RH advanced server with 9i, which seems like a real Redmond, WA thing. On Thu, Aug 29, 2002 at 02:08:19AM -0800, Docherty, Heather wrote: I am installing RedHat Linux and oracle 9i on two RM servers. I have never run Linux before. I usually run HP L-class or Sun Sparc servers with 8/8i. I would welcome emails with tips anybody has for avoiding anything I don't know that I should be avoiding yet, if you see what I mean! OT: Does anyone know why running startx, after boot-up to a Linux text prompt, causes the shutdown -r to hang the box and not reboot? Heather Napier University Edinburgh, Scotland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Docherty, Heather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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 /
RE: Slightly OT: Rounding Negative Numbers
Why are you including -0.870?? In that case you should also include -.880. I think theoretically there is nothing right or wrong about rounding thing. You have to decide upon one way and follow that universally. Naveen -Original Message- Sent: Thursday, August 29, 2002 10:19 PM To: Multiple recipients of list ORACLE-L I have to jump in at this point since the arguments for rounding -0.875 to -0.87 just don't seem quite right (I guess I might be Gaussian about this thing). Let me use a different approach to this argument: Value Rounded -0.870 -0.87 -0.871 -0.87 -0.872 -0.87 -0.873 -0.87 -0.874 -0.87 -0.875 ? -0.876 -0.88 -0.877 -0.88 -0.878 -0.88 -0.879 -0.88 Let's look at the distribution. If -0.875 rounds to -0.87 then 60% of the values round to -0.87 and 40% round to -0.88. But, if -0.875 rounds to -0.88 then 50% of the values round each way. A 50/50 split is much more pleasing to my mind than a 60/40 split. In my opinion, the Java example gave the wrong answer. I have to wonder if the expression (a*100) got cast into an integer before being handed to the round class. The alternative of questioning the validity of the class is less appealing. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 7:18 AM To: Multiple recipients of list ORACLE-L After an intense ask-your-local-mathematician-session, here you go: It depends ;) (That's typical math-guys, isn't it ?). If you define round according to the Gauss function, then it should calculate it using absolute values, that would be -0.88. On the other hand, round is usually defined to go for the higher value from 5 on, so, since -0.87 is higher than -0.875, -0.87 would be correct. You actually don't know wether the function is implemented one or the other way. You can just try. And if you are not content with the results, you have to cook your own. Regards, Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto:[EMAIL PROTECTED] visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Behalten Sie den Ueberblick - mit dem neuen BasicOverView, unserer Seminaruebersicht fuer das 2. Halbjahr 2002. Sie haben noch kein Exemplar? Schreiben Sie eine E-Mail an mailto:[EMAIL PROTECTED] oder rufen Sie uns an unter 0 18 03 / 73 64 62 73! Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Bill Buchan [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 29. August 2002 12:43 An: Multiple recipients of list ORACLE-L Betreff: Re: Slightly OT: Rounding Negative Numbers I know the rule round up, but does up mean the highest value (-0.87) or the highest absolute magnitude (-0.88)? :) - Bill. At 09:53 28/08/2002 -0800, you wrote: I would think -0.875 would round up therefore -0.87 is my guess. Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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--
Re: PL/SQL Editor
We are using TOAD for the DBA team. For the developers we got PlSqlDeveloper and it works fine. You can check also www.quest.com for the new sql editor that they developed recently. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 8:33 AM Hi All, which is the best PL/SQL editor available as a trial version . the editor should support Oracle sql,PL/SQL and may or may not support debugging. The tool should be support Win 9X OS and provide best performance . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slightly OT: Rounding Negative Numbers
Hi if you include -0.870, you should also include -0.880 in which case the split will go 6:5 either way you choose. Jack kkennedy kkennedy@firstpoTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] int.com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: Slightly OT: Rounding Negative Numbers [EMAIL PROTECTED] 29-08-2002 18:48 Please respond to ORACLE-L I have to jump in at this point since the arguments for rounding -0.875 to -0.87 just don't seem quite right (I guess I might be Gaussian about this thing). Let me use a different approach to this argument: Value Rounded -0.870 -0.87 -0.871 -0.87 -0.872 -0.87 -0.873 -0.87 -0.874 -0.87 -0.875 ? -0.876 -0.88 -0.877 -0.88 -0.878 -0.88 -0.879 -0.88 Let's look at the distribution. If -0.875 rounds to -0.87 then 60% of the values round to -0.87 and 40% round to -0.88. But, if -0.875 rounds to -0.88 then 50% of the values round each way. A 50/50 split is much more pleasing to my mind than a 60/40 split. In my opinion, the Java example gave the wrong answer. I have to wonder if the expression (a*100) got cast into an integer before being handed to the round class. The alternative of questioning the validity of the class is less appealing. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 7:18 AM To: Multiple recipients of list ORACLE-L After an intense ask-your-local-mathematician-session, here you go: It depends ;) (That's typical math-guys, isn't it ?). If you define round according to the Gauss function, then it should calculate it using absolute values, that would be -0.88. On the other hand, round is usually defined to go for the higher value from 5 on, so, since -0.87 is higher than -0.875, -0.87 would be correct. You actually don't know wether the function is implemented one or the other way. You can just try. And if you are not content with the results, you have to cook your own. Regards, Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto:[EMAIL PROTECTED] visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Behalten Sie den Ueberblick - mit dem neuen BasicOverView, unserer Seminaruebersicht fuer das 2. Halbjahr 2002. Sie haben noch kein Exemplar? Schreiben Sie eine E-Mail an mailto:[EMAIL PROTECTED] oder rufen Sie uns an unter 0 18 03 / 73 64 62 73! Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Bill Buchan [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 29. August 2002 12:43 An: Multiple recipients of list ORACLE-L Betreff: Re: Slightly OT: Rounding Negative Numbers I know the rule round up, but does up mean the highest value (-0.87) or the highest absolute magnitude (-0.88)? :) -
RE: Index hints?
If you specify a hint Oracle is forced to use the index. Your hint's syntax is wrong. USE - /*+ INDEX(test index_a) */ Don't use the comma *** between the table name and the index name Naveen -Original Message- Sent: Friday, August 30, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Hi, All, On a million row table, test, there is primary key on column a. when I run select /*+ index (test,indx_a) */ a, b, c, from test, according to Oracle, I should get the following explain plan. TABLE ACCESS BY INDEX ROWID test 1 INDEX UNIQUE SCAN PK_test 1 But I acctucally got : TABLE ACCESS FULL test 1 The database optimizer mode is choose, and I gathered the statistics on table and index using dbms_utitlity and analyze. In the session level, I also set optimizer_mode=first_rows to push optimizer to choose the index. According to Oracle Doc use hints to force the optimizer to use the optimal execution plan., to my understanding, the explain plan under such a situation, should be the first one. Does Oracle follow the hint? or to waht extents, it follows? Appreciated if someone guides me to the right direction. Chuan, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Index hints?
Chuan Zhang, hei£¬you statement choose all rows from the table,Of course oracle will use full table scan! There is no where clause in your SQL.If you add: select a,b,c from test where a=some_value, then of course it will use the index. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] === 2002-08-29 23:03:00 ,you wrote£º=== Hi, All, On a million row table, test, there is primary key on column a. when I run select /*+ index (test,indx_a) */ a, b, c, from test, according to Oracle, I should get the following explain plan. TABLE ACCESS BY INDEX ROWID test 1 INDEX UNIQUE SCAN PK_test 1 But I acctucally got : TABLE ACCESS FULL test 1 The database optimizer mode is choose, and I gathered the statistics on table and index using dbms_utitlity and analyze. In the session level, I also set optimizer_mode=first_rows to push optimizer to choose the index. According to Oracle Doc use hints to force the optimizer to use the optimal execution plan., to my understanding, the explain plan under such a situation, should be the first one. Does Oracle follow the hint? or to waht extents, it follows? Appreciated if someone guides me to the right direction. Chuan, = = = = = = = = = = = = = = = = = = = = zhu chao [EMAIL PROTECTED] 2002-08-30 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: arg list too long in unix
Hi all, Is there something like, unix is unable to use commands like ls -ltr (sort etc) when there are huge number of files in a directory(may be thousands/millions). If yes, what is the limit and how to know it on sun solaris 2.8. thnx and regards, srinivas --- Lakhani, Vipul [EMAIL PROTECTED] wrote: maybe use find (check the syntax of below) (just guessing) eg find . -name '*' -exec rm {} \; readt this : http://www.linuxjournal.com/article.php?sid=6060 -Original Message- From: kommareddy sreenivasa [mailto:[EMAIL PROTECTED]] Sent: 29 August 2002 11:59 To: Multiple recipients of list ORACLE-L Subject: arg list too long in unix Hi all, OS: SOlaris 2.8 DB: 8i In the clean up process of the following files, I am trying to list out the files that start with cz. cz-session-returnui177_11Jan02_0959AM_33509.txt cz-session-Applet178_11Jan02_0959AM_34108.txt cz-session-returnui175_11Jan02_0959AM_20504.txt cz-session-DHTML176_11Jan02_0959AM_22335.txt cz-session-returnui179_11Jan02_1000AM_34566.txt cz-session-Applet180_11Jan02_1000AM_34818.txt cz-session-BatchSingle181_11Jan02_1001AM_07757.txt cz-session-BatchSingle182_11Jan02_1001AM_11687.txt cz-session-BatchSingle183_11Jan02_1001AM_14010.txt cz-session-BatchSingle184_11Jan02_1001AM_17708.txt cz-session-BatchSingle185_11Jan02_1001AM_20029.txt but when I issue ls -ltr cz* , I am getting arg list too long error. I 70,000-80,000 files that needs to be removed from the directory. I cant list them using ls -ltr *session* as this string may change. I have to identify the files that srart with cz only. can somebody through somelight on this. thanx in advance, srinivas __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 UP/DOWN scripts
hi we use on sunos 5.8 the same scripts as on linux - as we use on all *nices the bash. kr mr [EMAIL PROTECTED] 08/29/02 21:46 PM Hi Does some one have DB down script on Sun solaris.I mean to say if instance down I will get page . Thx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Configuring 734 and 817 on same machine.
Title: Configuring 734 and 817 on same machine. Hello Gurus, Does anyone have a link to a resource which describes the Installation and configuration of Oracle 734 and Oracle 817 on the same Windows 2000 machine. The configuration of the listeners is my main concern. Any help on this is very much appreciated. Regards Denham Eva DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Contract Forwarding, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
Re: Standby with TAF config. - How to ?
oraora oraora, If you want to implement TAF, you have to use OPS/RAC. and you application must be written via OCI when connect to database. For standby to be in recover, it take some minutes to recover the final redo log from the primary site, which maybe need human interaction. Standby is mainly a backup policy and disaster recovery policy, if you want to use that level HA, i suggest your use OS HA solution like VCS,HACMP etc, or OPS/RAC. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] === 2002-08-29 22:28:00 ,you wrote£º=== Guys , 1# Can Standby database be configured for TAF ? 2# If so , when the Primary DB fails will the client application be automatically failed over to Standby DB ? 3# And thereafter can the client application proceed it's process without any manual intervention ? I have read the Standby Database - Concepts and Admin. manual. What i am not clear about is how to configure Standby DB with TAF so that least manual intervention is required ? Can anyone of u help me ? Any good resource for the same ? TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = zhu chao [EMAIL PROTECTED] 2002-08-30 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Rel1 on SuSE 8.0 Pro
I have several Suse 7.2 running fine with ReiserFS and Ext2. Recently, I've got a problem with RAM (hanging several times) I have changed the ram, but yesterday I have found a couple of corrupted blocks in one database, so I guess memory could possibly be an issue. Are there any other negative symptoms? As a recomendation - move to SuSe 7.2 (if possible) and get suport for 9iR1, or beter to SLES. Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 10:28 PM I thought of the hard drive and took it back to the store and got another one. I had the same problem with Rel2 and 9iAS Rel1 does not work with Rel2 of DB and I need it for my project. Could memory problems cause this problem? Joe -Original Message- Sent: Thursday, August 29, 2002 1:39 PM To: Multiple recipients of list ORACLE-L My first suggestion would be to try release 2. Second suggestion is that your new hard drive is defective. ltiu Joe A Cairns wrote: Help!!! I have load the oracle 9i Database on my Linux Server running SuSE 8.0 Pro. The installation went fine, but the database keeps getting corrupted data blocks. Does anybody know why this keeps happing. I had thing running before and then I had a disk drive crash. 30.7 gig drive). replaced the drive, reinstalled everything and now keep getting corrupted datablock problems. Of course Oracle won't give me any support because of the OS version. I logged a TAR and they closed it. Has anyone else seen this problem; Here is my Config: AMD XP 1800+ MSI K7 Turbo2 Montherboard 1.2 GIG Memory 80 GIG Drive 30 GIG Drive SuSE 8.0 Pro Oracle 9.0.1 (RDBMS) Thanks in advance for your help. Joe Cairns -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe A Cairns INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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: Letting users kill their own sessions
Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle Patrice, I think I posted this not so long ago but I have this one and it works. Regards HTH Lee /***//* *//* Author: Lee Robertson *//* *//* Title: killsession.sql *//* *//* Date: 19/04/01 *//* *//* Description: Enable a non-DBA user to kill their *//* own session but not the current one. *//* *//***/ create or replace procedure killsession (v_sid IN number, v_serial IN number, v_puser IN varchar2) as v_statement varchar2(200); v_user varchar2(10);v_cursor_name integer; v_rows_processed integer; BEGIN dbms_output.enable(1); -- Set up output buffer -- get the details to kill select username into v_user from v$session where v_sid = sid and v_serial = serial# and v_puser = user; -- format the statement to run v_statement := 'alter system kill session '''||v_sid||','||v_serial||; -- set up cursor and run the staement v_cursor_name := dbms_sql.open_cursor; dbms_sql.parse(v_cursor_name, v_statement, dbms_sql.v7); v_rows_processed := dbms_sql.execute(v_cursor_name); dbms_sql.close_cursor(v_cursor_name); -- exception section where details entered are incorrect exception when no_data_found then dbms_output.put_line('One or more of your parameters is wrong. Please Check again'); when others then raise; -- end of procedure end; / -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]Sent: 29 August 2002 21:19To: Multiple recipients of list ORACLE-LSubject: Letting users kill their own sessions Does anyone have a dynamic script that would let users kill their own sessions? I found something in Metalink but the script doesn't appear to verify whether the PID and SID supplied belongs to the person executing the procedure... not ideal. Thanks. 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] * The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.
Re: Configuring 734 and 817 on same machine.
Hi, My guess would be (from memory) Install Oracle 7 first because it wants to be in the first Oracle home than 8i and configure the listener of 8i to listen for all database connections on the machine. I once tried to install Oracle 7 after I had installed 8i and had to fiddle with the registry to get it to install and work properly Jack Denham Eva [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) [EMAIL PROTECTED] Subject: Configuring 734 and 817 on same machine. 30-08-2002 10:28 Please respond to ORACLE-L Hello Gurus, Does anyone have a link to a resource which describes the Installation and configuration of Oracle 734 and Oracle 817 on the same Windows 2000 machine. The configuration of the listeners is my main concern. Any help on this is very much appreciated. Regards Denham Eva DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Contract Forwarding, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com === 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
Re: Re[2]: controlling CPU usage through Oracle
In NT and win2000 you can set Os priorities to the different tasks. If you have the sane facility on aix you can give this db a lower priority so whenever the other databases will need CPU they will get it. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 3:48 PM Kevin, Thanks for your input. Just to clarify; I only want to control this one database. I want to limit its resources so it does not impact the other 4 databases on the box. So, in that case would resource manager be beneficial ? Also, besides profiles, and resource manager, does anyone know of any other tools provided by Oracle which would limit resources ? Or, any 3rd party tools that my be beneficial ? I thank everyone for providing their input; it's much appreciated. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 5:23 PM I don't think Resource Manager is going to do the trick here (I just read about it over the last week while preparing for OCP exam 4). Resource Manager would work great for a single database but Ed is trying to divvy up resources between 5 databases. I don't have any good solution. I suppose if everything running on this one database was less important than anything on the other 4 databases, you could renice the one database. I think that would be ok provided all components of the one database were at the same nice level. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Wednesday, August 28, 2002 9:52 AM To: Multiple recipients of list ORACLE-L -Original Message- From: Ed Lewis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 4:18 PM To: Multiple recipients of list ORACLE-L Subject: controlling CPU usage through Oracle Hi, I'm looking for a way to control CPU usage of particular queries on a database. After exploring, and implementing ways of optimizing the code, these queries can run anywhere from 45 seconds to 2 minutes. This database is 1 of 5 on this box. So, although it's important to build effective queries, it's also important in this environment that these queries do not impact the other 4 databases. What I want to do is place a limit on CPU usage without terminating the query. I've looked at profiles with the cpu_per_call and cpu_per_session settings. I have never used profiles, but from what I understand, these will kill the session once they reach a threshold. I'm also looking at database resource management. This may be more appropriate for this situation. Has anyone used this, and if so what are you experiences ? Would you recommend it ? Would the only way to control CPU usage on this box, be through the operating system ? I welcome any suggestions. I appreciate your time. The environment is Oracle 8.1.7.2, AIX 4.3.3. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Letting users kill their own sessions
Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle very funny, but I asked because sometimes developers create 'zombies' on our UNIX server. Why would being chained to a desk that is connected to Oracle be punishment? I don't understand... ; ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message-From: Rodd Holman [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 29, 2002 6:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Letting users kill their own sessionsFor the really radical there is the 1-finger salute... ;-) Rodd Holman On Thu, 2002-08-29 at 16:37, Fink, Dan wrote: I prefer the Microsoft 3-fingered salute... -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 2:44 PM To: Multiple recipients of list ORACLE-L Subject: RE: Letting users kill their own sessions Yes, the process is called "logging out" and I normally let them do that. Keeping them tied to their computers would be a cruel and unusual punishment, against the company policy and probably illegal. -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 4:19 PM To: Multiple recipients of list ORACLE-L Subject: Letting users kill their own sessions Does anyone have a dynamic script that would let users kill their own sessions? I found something in Metalink but the script doesn't appear to verify whether the PID and SID supplied belongs to the person executing the procedure... not ideal. Thanks. 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]
RE: working with datafile 2Gb in HadHat 7.3
I read something about Oracle on Windows not being able to extend past the 2G limit, but haven't verified. I believe it has to do with Oracle on Windows, not windows or hardware. 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: Thursday, August 29, 2002 5:34 PM To: Multiple recipients of list ORACLE-L Subject:RE: working with datafile 2Gb in HadHat 7.3 Ltiu, Intel hardware can only handle 2Gb files sizes max. Are you sure? I don't think that's true. -Original Message- Sent: Thursday, August 29, 2002 2:44 PM To: Multiple recipients of list ORACLE-L It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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: new email address
Does that mean you didn't get my email about presenting my rman paper? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 7:47 PM the [EMAIL PROTECTED] email addy has evidently been sent on to spam lists, i'm getting way too many. Since I own that domain, i'll be dropping the [EMAIL PROTECTED] and be replacing it with [EMAIL PROTECTED] Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Parner Network
Hey all, While reviewing our annual maintenance agreement ($5,000) and considering an additional $30K license purchase, our savvy network admin suggested we look into Oracle's Partner Network. After some research, phone conversations, and pouring through the license agreement with a fine-tooth comb, I realized that's it's a win-win for us. Instead of spending $35,000 on renewals and new license purchases, we spend $2,000 to join OPN as a member associate and then pay $39.20 per seat for dev support (equivalent to our current Silver level) on the db suite. Yes, the catch is you have to be using Oracle solely for dev (and not for internally deployed apps that run your business) but it has turned out to be a no-brainer moneywise. Curious if anyone else out there has had experience with this . . . not that I'm sceptical or anything, but we tried to find a catch and couldn't! thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ADV OT: Oracle-dba.com domain for sale
hahahah, now thats a kewl domain. joe Post, Ethan wrote: I would but I got to put some money down on www.phatdba.com Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Thursday, August 29, 2002 6:48 PM To: Multiple recipients of list ORACLE-L If you're interested, email me for the asking price. Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: IMPORT sloooowwww
Bingo. It was the grants, as I had tried w/o indexes/constraints. There were some 1800+ grants per table. With grants set to no, an import which creates constraints and indexes is flying. It has been so long since I worked with a product where each user is given direct grants rather than thru a role, that I forgot that it was possible to have that many grants on a single table Thanks again. -Original Message- Sent: Thursday, August 29, 2002 12:39 PM To: Multiple recipients of list ORACLE-L and indexes, too! do the indexes, constraints, grants, etc after the table data imports! -bill -Original Message- Sent: Thursday, August 29, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Creating grants and synonyms on each table? Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - In looking at how long it takes, the table imports in a second or less, but it takes 3 minutes + to start the import of the next table. I'm not sure what it is doing for 3 minutes after the table imports. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
select count(*) = 0, select /*+ full(a) */ count(*) = 5227 ?
On Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production PL/SQL Release 8.1.7.2.0 - Production CORE8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.2.0 - Production NLSRTL Version 3.4.1.0.0 - Production I got a stange result and I wish to find an explanation. Look I did SQL select count(*) from ced_info_mouvement ; cls COUNT(*) -- 0 1 ligne sÚlectionnÚe. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 1 0 SORT (AGGREGATE) 2 1 PARTITION RANGE (ALL) 3 2 PARTITION HASH (ALL) 4 3 INDEX (FAST FULL SCAN) OF 'MVT_ID_LOT_IDX' (NON-UNIQUE) (Cost=2 Card=24507) Statistics -- 0 recursive calls 288 db block gets 120 consistent gets 0 physical reads 0 redo size 203 bytes sent via SQL*Net to client 248 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed I tryed with and order by on the first column_name, I got the exact number of rows in this table, why ? SQL select count(*) from ced_info_mouvement order by IDENTIF_PRODUIT_COMPTABLE; cls COUNT(*) -- 5227 1 ligne sÚlectionnÚe. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=19 Card=1 Bytes=17) 1 0 SORT (AGGREGATE) 2 1 PARTITION RANGE (ALL) 3 2 PARTITION HASH (ALL) 4 3 TABLE ACCESS (FULL) OF 'CED_INFO_MOUVEMENT' (Cost=19 Card=24507 Bytes=416619) Statistics -- 0 recursive calls 116 db block gets 246 consistent gets 0 physical reads 0 redo size 206 bytes sent via SQL*Net to client 248 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed I tryed vith HINTS FULL and I got 5227 rows. Regards. NAME VALUE - - active_instance_count always_anti_join NESTED_LOOPS always_semi_join standard aq_tm_processes 0 audit_file_dest ?/rdbms/audit audit_trail NONE background_core_dump partial background_dump_dest /sscedre/data/sqcedi/admin/log backup_tape_io_slaves FALSE bitmap_merge_area_size1048576 blank_trimmingFALSE buffer_pool_keep buffer_pool_recycle commit_point_strength 1 compatible8.1.0 control_file_record_keep_time 7 control_files /sscedre/data/sqcedi/disk1/ctrl11sqcedi.ctl, /sscedre/data/sqcedi/disk2/ctrl12sqcedi.ctl, /sscedre/data/sqcedi/disk3/ctrl13sqcedi.ctl core_dump_dest?/dbs cpu_count 4 create_bitmap_area_size 8388608 cursor_sharingEXACT cursor_space_for_time FALSE db_block_buffers 3200 db_block_checking FALSE db_block_checksum FALSE db_block_lru_latches 2 db_block_max_dirty_target 3200 db_block_size 8192 db_domain db_file_direct_io_count 64 db_file_multiblock_read_count 32 db_file_name_convert db_files 500 dblink_encrypt_login FALSE db_name sqcedi dbwr_io_slaves0 db_writer_processes 1 disk_asynch_ioTRUE distributed_transactions 23 dml_locks 500 enqueue_resources 5000 event 10262 trace name context forever,level 4096 fast_start_io_target 3200 fast_start_parallel_rollback LOW fixed_date gc_defer_time 10 gc_files_to_locks gc_releasable_locks 0 gc_rollback_locks
Re: Serving BLOB from the database
At 09:43 AM 8/29/2002, Manavendra Gupta wrote: I'm sure there has been discussion in the past about the same, but I'm more interested in the feasibility/performance of serving images (stored as BLOB) from the database. Is there a reason that you're not using interMedia here? interMedia is pretty well optimized for doing exactly this. 1. For a large multi-tier application (client, web-tier, application, database), with about 5 million records upfront (possibly an image associated with each of them), about 300 concurrent users expected, would the gurus recommend serving images from the database? 1.1 The images will not be served in bulk, but one per request (only on the details page would the user get to see the image). I certainly would want to do it that way. From a development point of view, it's a lot easier to deal with 5 million rows of data in a table somewhere than a file system with 5 million images. No worries about how the images are names, how they're stored (most O/S's limit the number of files you can have per directory, the number of subdirectories you can have, etc). Plus, you've got everything in one place for backups. 2. Wouldn't it be better to serve images from a dedicated box, at the web tier? This way I could just farm the web-tier and wouldn't have to worry about the images much? If you use something like webCache on the middle tier, that may accomplish much of what you're after, keeping a the data in the database. 3. Is serving images from the database scalable? Yes. I've seen benchmarks that had interMedia faster than a standard file system in a three-tier configuration. Slightly slower in a two-tier configuration, but certainly scaling. Justin Cave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Identify unused indexes in 8i ?
Yes, you are right. I forgot to mention monitoring, On 2002.08.30 01:23 Khedr, Waleed wrote: Or when you are done moving these suspected indexes to a new Tablespace, you can monitor the read/write statistics for the files in that Tablespace (v$filestat). Another idea is to put the indexes in the unusable state and wait for an error when the index gets used. Regards, Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/30/02 12:53 AM Your methodology is sound and bulletproof, but is also fairly effort-intensive and time-consuming. Another trick is to make a list of all indexes that are suspected for not being used, move them all into the same, otherwise empty, tablespace and take the whole tablespace offline. If any of the existing jobs slow down significantly, then you have disabled a wrong index. It is a gun slinger method but if you are not going to do a significant business damage, you might be able to afford it. The method that I use is to find documentation for the project that has caused the index to be created. Trace files and performance analysis must be attached to the project documentation. If the index was used at one time, I examine the programs that have been using it and run them with SQL_TRACE on (or 10046, level 1). If the index is no longer used, I discard it. I have retired quite a few tables and indexes since the start of all that HIPAA frenzy. Good documentation and a strict process of applying changes to the production database, with a sign-off required for every step along the way is of paramount importance for keeping track of objects in your database. On 2002.08.29 17:37 Cary Millsap wrote: I expect that the answer is probably that an unused index is any index that the Oracle query optimizer will never choose for any SQL statement in the entire application. One way to compute whether an index is unused is: 1. Extract SQL from your application source code (which is nice because you can do it all at once without polling) and from v$sql (which you must do if your apps generate SQL dynamically). 2. Compute the current* execution plan for each statement using explain plan. (*The reason I say current is that many input factors can change these plans, including schema changes, db or instance statistics changes, init.ora changes, and application code changes.) 3. For each index in your application, determine whether that index is referenced in any plan generated in step 2. Any index that is never referenced is almost certain to be unused. We have built a tool under the name Hotsos Project Laredo (www.hotsos.com/products/laredo) that does steps 1 and 2. The difficult trick is collecting *all* of your SQL. The method of just looking at object I/O statistics for a given index, for example, isn't reliable because it is only rearward-looking in time. Just because an index hasn't been used since instance startup doesn't mean that it won't be used tomorrow. Making Laredo do step 3 would probably not be nearly as difficult as the work we've done perfecting steps 1 and 2. Let me know if you're interested. Improving our tools is part of how we make a living... Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Next event: Miracle Database Forum, Sep 20-22 Middelfart Denmark -Original Message- Mladen Sent: Thursday, August 29, 2002 3:39 PM To: Multiple recipients of list ORACLE-L What are unused indexes? -Original Message- From: Bob Robert [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 3:33 PM To: Multiple recipients of list ORACLE-L Subject: Identify unused indexes in 8i ? All, Is there a way to identify unused indexes in Oracle 8i. I know that it is easy to check with 9i. I would appreciate if you could share your experience (or ideas) with me. Thanks, Bob __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob 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
Re: Standby with TAF config. - How to ?
At 02:33 AM 8/30/2002, you wrote: oraora oraora, If you want to implement TAF, you have to use OPS/RAC. and you application must be written via OCI when connect to database. Your application doesn't necessarily have to be written in OCI to use TAF, but whatever layer eventually makes the OCI calls does. Oracle's ODBC driver, for example, implements TAF support, so any ODBC application which uses the Oracle driver will get TAF support. Other Oracle API's likely do the same. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] === 2002-08-29 22:28:00 ,you wrote£º=== Guys , 1# Can Standby database be configured for TAF ? 2# If so , when the Primary DB fails will the client application be automatically failed over to Standby DB ? 3# And thereafter can the client application proceed it's process without any manual intervention ? I have read the Standby Database - Concepts and Admin. manual. What i am not clear about is how to configure Standby DB with TAF so that least manual intervention is required ? Can anyone of u help me ? Any good resource for the same ? TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = zhu chao [EMAIL PROTECTED] 2002-08-30 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Justin Cave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Letting users kill their own sessions
Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle I quite agree with Patrice - and what's more, 'zombies' is the exact right word for them ! peter edinburgh ps - I did get a laugh out of the exchange too -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]Sent: 30 August 2002 12:53To: Multiple recipients of list ORACLE-LSubject: RE: Letting users kill their own sessions very funny, but I asked because sometimes developers create 'zombies' on our UNIX server. Why would being chained to a desk that is connected to Oracle be punishment? I don't understand... ; ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message-From: Rodd Holman [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 29, 2002 6:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Letting users kill their own sessionsFor the really radical there is the 1-finger salute... ;-) Rodd Holman On Thu, 2002-08-29 at 16:37, Fink, Dan wrote: I prefer the Microsoft 3-fingered salute... -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 2:44 PM To: Multiple recipients of list ORACLE-L Subject: RE: Letting users kill their own sessions Yes, the process is called "logging out" and I normally let them do that. Keeping them tied to their computers would be a cruel and unusual punishment, against the company policy and probably illegal. -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 4:19 PM To: Multiple recipients of list ORACLE-L Subject: Letting users kill their own sessions Does anyone have a dynamic script that would let users kill their own sessions? I found something in Metalink but the script doesn't appear to verify whether the PID and SID supplied belongs to the person executing the procedure... not ideal. Thanks. 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] * 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: Table Locks
Thanks Rachel. I spent the train ride reading the chapters on Instance Tuning and Dynamic Performance Views hoping to find something, but no such luck. I learned a lot of other useful things though, so it wasn't a waste of time. Jacques, v$locked_object shows the table, but I already knew which table was locked. I was hoping to find the offending SQL statement. Have a great weekend everyone. Regards, -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 8/29/2002 10:43 PM, Rachel Carmichael [EMAIL PROTECTED] wrote: I'm not sure it's possible to find the locking SQL and SID once the session issues other SQL statements. I spent a lot of time a few years back attempting to find it, without success. I got the people at both Platinum Technology and Savant (yes, I'm showing my age here) to try to find it as well, figuring their technical people were better at this sort of thing than I am... no luck. I don't think Oracle stores the statement and who issued it, just the rollback info necessary and the fact that there is a lock. --- Alan Davey [EMAIL PROTECTED] wrote: Hi All, I've noticed some locks on various tables and I'm trying to figure out which DML statements are causing the locks. In this example, the lock isn't being released because the developer forgot to include a commit/rollback. If I look at v$session which is causing the lock and query v$sqlarea with the values in sql_address and prev_sql_addr, I only see select statements that were issued after the DML (in this case a delete). I can query v$sqlarea with the locked table name and find the delete statement, but how do I link this back to the sid that issued it? Also, what if there had been multiple DML statements by this user, how would I know which was the first/last one executed? I'm RTFMing, but so far no luck. Any help would be greatly appreciated. Regards, -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Davey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Davey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 scripting need help
Unix scripts is one thing I don't worry much and am taking my own time to learn those with Perl. We got a fantastic bunch of Unix admins who are just waiting for challenges and always deliver. It is bad (for me) and good (that I can spend more time on Oracle issues like chasing OWS personnel and explaining them that that feature is indeed a bug etc etc). Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: LIST ADMIN: VIRUS Warning: Please Repsond
My point was that in the corporate world, there is little choice. The only viable software choice is Outlook on WinNT boxes. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L No, I'm not saying that people using M$ products are doing so because they are stupid or lazy. Perhaps they are if they refuse to even consider the alternatives. I don't consider myself stupid or lazy and I'm using M$ products both at home and at work. I don't like them. I suggest alternatives to damagement every time I have the opportunity. For my home machines, I have put my foot down -- neither XP nor W2K will ever be used in my home -- they are just too damn invasive. I'm toying with the idea of getting one of those Lindows machines when I need to replace one of my current machines. The only reason I don't go with full Linux is that I have not found a good Linux alternative to Quicken (and I'm either too busy or too lazy to write one 8-) To restate what I said before: You always have a choice. Some people choose to believe that M$ is the ONLY choice. I don't. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 1:39 PM To: Multiple recipients of list ORACLE-L So basically you're saying that those of us using Microsoft products are doing so because we're stupid or lazy to change? -Original Message- Sent: Thursday, August 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L You always have a choice. Sometimes it is difficult to make the right choice. Consider a high school student who is doing poorly -- they can make the easy choice and drop out or they can make the difficult choice and work harder. In the case of M$, the easy choice is to accept whatever M$ does and produces. The difficult choice is to find a viable alternative (and even more difficult is to sell that to management). In the past, M$ bought out or crushed any viable alternative; they have been finding that more difficult lately. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Gee, that's a helpful reply! As if we have any choice! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Stop using MS products if you are seriously worried about viruses. [EMAIL PROTECTED] wrote: Got trigger happy, so I'm resending. -Original Message- Sent: Thursday, August 29, 2002 10:11 AM To: DBA List (E-mail); Fat Dba (E-mail) Hi, I recieved an email today as follows: Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Address of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Recipient of the infected attachment: Kelly Grigg\Inbox Subject of the message: Happy humour Epiphany One or more attachments were deleted Attachment URL.pif was Deleted for the following reasons: Virus W32.Klez.E@mm was found. Here is the repsonse from my guys: It's sending out from other domains rather sungard.com, eg. diamonddata.com and lazydba.com to you. I attached the description from your first email. It is stating that it's being blocked when it's trying to send to you, in which means it's infected on their end and are being scanned/blocked on it's way out from their systems. Have you contact them about the possible of virus attach on their end. In any case, we were alarmed and run the scan anyway. See what they can find. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: working with datafile 2Gb in HadHat 7.3
It was a bug on windows - with auto extend on and crossing 4Gb filesize. -Original Message- Sent: Friday, August 30, 2002 6:58 AM To: Multiple recipients of list ORACLE-L I read something about Oracle on Windows not being able to extend past the 2G limit, but haven't verified. I believe it has to do with Oracle on Windows, not windows or hardware. 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: Thursday, August 29, 2002 5:34 PM To: Multiple recipients of list ORACLE-L Subject:RE: working with datafile 2Gb in HadHat 7.3 Ltiu, Intel hardware can only handle 2Gb files sizes max. Are you sure? I don't think that's true. -Original Message- Sent: Thursday, August 29, 2002 2:44 PM To: Multiple recipients of list ORACLE-L It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list,
Estimate sample percent question
Hi, I've run across an anomaly while updating statistics. It appears that the sample size specified by the analyze statement is not producing the results I'd hoped for. By my calculations, the 5% estimate has a sample size of 1%, the 10% uses 1.6%, and the 40% uses 5%. Are there any known causes for this type of effect? Has anyone else encountered this before? I'm wondering if it has to do with the way the first few blocks are filled. I'm seeing this for a number of tables. Thanks, Russ Brooks sapsan:SANanalyze table bnka delete statistics; Table analyzed. sapsan:SANanalyze table bnka estimate statistics sample 5 percent; Table analyzed. sapsan:SAN@s TABLE_NAME SAMPLE_SIZE -- --- BNKA 580 sapsan:SANanalyze table bnka delete statistics; Table analyzed. sapsan:SANanalyze table bnka estimate statistics sample 10 percent; Table analyzed. sapsan:SANget s 1 select table_name, sample_size from user_tables 2* where table_name = 'BNKA' TABLE_NAME SAMPLE_SIZE -- --- BNKA 931 sapsan:SANanalyze table bnka delete statistics; Table analyzed. sapsan:SANanalyze table bnka estimate statistics sample 40 percent; Table analyzed. sapsan:SANget s 1 select table_name, sample_size from user_tables 2* where table_name = 'BNKA' sapsan:SANr TABLE_NAME SAMPLE_SIZE -- --- BNKA 2996 sapsan:SANanalyze table bnka compute statistics; Table analyzed. sapsan:SANget s 1 select table_name, sample_size from user_tables 2* where table_name = 'BNKA' sapsan:SANr TABLE_NAME SAMPLE_SIZE -- --- BNKA 57734
RE: Oracle Parner Network
We are OPN members - we have one database for our internal use and pay full price for it and support. In addition we have a bunch of purely development databases - on differing platforms (linux, solaris) that we download and use for no additional fee's. -Original Message- Sent: Friday, August 30, 2002 7:04 AM To: Multiple recipients of list ORACLE-L Hey all, While reviewing our annual maintenance agreement ($5,000) and considering an additional $30K license purchase, our savvy network admin suggested we look into Oracle's Partner Network. After some research, phone conversations, and pouring through the license agreement with a fine-tooth comb, I realized that's it's a win-win for us. Instead of spending $35,000 on renewals and new license purchases, we spend $2,000 to join OPN as a member associate and then pay $39.20 per seat for dev support (equivalent to our current Silver level) on the db suite. Yes, the catch is you have to be using Oracle solely for dev (and not for internally deployed apps that run your business) but it has turned out to be a no-brainer moneywise. Curious if anyone else out there has had experience with this . . . not that I'm sceptical or anything, but we tried to find a catch and couldn't! thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Table Locks
I created following two views for developer's use and so far there have been no complaints .. CREATE OR REPLACE FORCE VIEW SYSTEM.DB$LOCKED_OBJECTS (OBJECT_NAME, SESSION_ID, ORACLE_USERNAME, OS_USER_NAME, SQL_ACTIONS, LOCK_MODE) AS SELECT DO.object_name, lo.SESSION_ID, lo.oracle_username, lo.OS_USER_NAME, DECODE(locked_mode, 1, 'SELECT', 2, 'SELECT FOR UPDATE / LOCK ROW SHARE', 3, 'INSERT/UPDATE/DELETE/LOCK ROW EXCLUSIVE', 4, 'CREATE INDEX/LOCK SHARE', 5, 'LOCK SHARE ROW EXCLUSIVE', 6, 'ALTER TABLE/DROP TABLE/DROP INDEX/TRUNCATE TABLE/LOCK EXCLUSIVE') sql_actions, DECODE(locked_mode, 1, 'NULL', 2, 'SS - SUB SHARE', 3, 'SX - SUB EXCLUSIVE', 4, 'S - SHARE', 5, 'SSX - SHARE/SUB EXCLUSIVE', 6, 'X - EXCLUSIVE') Lock_mode FROM sys.V_$LOCKED_OBJECT lo, DB$OBJECTS DO WHERE DO.object_id = lo.object_id; CREATE PUBLIC SYNONYM DB$LOCKED_OBJECTS FOR SYSTEM.DB$LOCKED_OBJECTS; GRANT SELECT ON SYSTEM.DB$LOCKED_OBJECTS TO PUBLIC; and CREATE OR REPLACE FORCE VIEW SYSTEM.DB$LOCKS (OBJ_OWNER, OBJ_NAME, OBJ_TYPE, OBJ_ROWID, DB_USER, SID, LOCK_TYPE, ROW_WAIT_FILE#, ROW_WAIT_BLOCK#, ROW_WAIT_ROW#) AS SELECT owner obj_owner, object_name obj_name, object_type obj_type, dbms_rowid.rowid_create(1, row_wait_obj#, ROW_WAIT_FILE#, ROW_WAIT_BLOCK#,ROW_WAIT_ROW#) obj_rowid, a.username db_user, a.sid sid, a.TYPE lock_type, a.row_wait_file#, a.row_wait_block#, a.row_wait_row# FROM DB$OBJECTS, (SELECT a.username, a.sid, a.row_wait_obj#, a.ROW_WAIT_FILE#, a.ROW_WAIT_BLOCK#, a.ROW_WAIT_ROW#, b.TYPE FROM sys.V_$SESSION a, sys.V_$LOCK b WHERE a.username IS NOT NULL AND a.row_wait_obj# -1 AND a.sid = b.sid AND b.TYPE IN ('TX','TM') ) a WHERE object_id = a.row_wait_obj#; CREATE PUBLIC SYNONYM DB$LOCKS FOR SYSTEM.DB$LOCKS; GRANT SELECT ON SYSTEM.DB$LOCKS TO PUBLIC; DB$OBJECTs is a snapshot of DBA_OBJECTS, it is too slow to select from DBA_OBJECTS, so I created a snapshot that is refreshed on a daily basis, it works fine for me. Hope this helps some. As others have mentioned, currently locked rows are very difficult to find, what you can find though is the rowid for which a lock is requested. 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: Friday, August 30, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Thanks Rachel. I spent the train ride reading the chapters on Instance Tuning and Dynamic Performance Views hoping to find something, but no such luck. I learned a lot of other useful things though, so it wasn't a waste of time. Jacques, v$locked_object shows the table, but I already knew which table was locked. I was hoping to find the offending SQL statement. Have a great weekend everyone. Regards, -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 8/29/2002 10:43 PM, Rachel Carmichael [EMAIL PROTECTED] wrote: I'm not sure it's possible to find the locking SQL and SID once the session issues other SQL statements. I spent a lot of time a few years back attempting to find it, without success. I got the people at both Platinum Technology and Savant (yes, I'm showing my age here) to try to find it as well, figuring their technical people were better at this sort of thing than I am... no luck. I don't think Oracle stores the statement and who issued it, just the rollback info necessary and the fact that there is a lock. --- Alan Davey [EMAIL PROTECTED] wrote: Hi All, I've noticed some locks on various tables and I'm trying to figure out which DML statements are causing the locks. In this example, the lock isn't being released because the developer forgot to include a commit/rollback. If I look at v$session which is causing the lock and query v$sqlarea with the values in sql_address and prev_sql_addr, I only see select statements that were issued after the DML (in this case a delete). I can query v$sqlarea with the locked table name and find the delete statement, but how do I link this back to the sid that issued it? Also, what if there had been multiple DML statements by this user, how would I know which was the first/last one executed? I'm RTFMing, but so far no luck. Any help would be greatly appreciated. Regards, -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Davey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing
RE: select count(*) = 0, select /*+ full(a) */ count(*) = 5227 ?
Bernard I think this may be a bug in early versions of 8.1.7. I don't know the number, but I had a similar problem recently. Its to do with whether the query is scanning an index or not. Try forcing the query to do a full scan: - SQL select /*full(ced_info_mouvement)*/ count(*) from ced_info_mouvement; The only solution I found was to upgrade to 8.1.7.3+ HTH David Lord -Original Message- From: Bernard, Gilbert [mailto:[EMAIL PROTECTED]] Sent: 30 August 2002 14:23 To: Multiple recipients of list ORACLE-L Subject: select count(*) = 0, select /*+ full(a) */ count(*) = 5227 ? On Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production PL/SQL Release 8.1.7.2.0 - Production CORE8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.2.0 - Production NLSRTL Version 3.4.1.0.0 - Production I got a stange result and I wish to find an explanation. Look I did SQL select count(*) from ced_info_mouvement ; cls COUNT(*) -- 0 1 ligne sÚlectionnÚe. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 1 0 SORT (AGGREGATE) 2 1 PARTITION RANGE (ALL) 3 2 PARTITION HASH (ALL) 4 3 INDEX (FAST FULL SCAN) OF 'MVT_ID_LOT_IDX' (NON-UNIQUE) (Cost=2 Card=24507) Statistics -- 0 recursive calls 288 db block gets 120 consistent gets 0 physical reads 0 redo size 203 bytes sent via SQL*Net to client 248 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed I tryed with and order by on the first column_name, I got the exact number of rows in this table, why ? SQL select count(*) from ced_info_mouvement order by IDENTIF_PRODUIT_COMPTABLE; cls COUNT(*) -- 5227 1 ligne sÚlectionnÚe. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=19 Card=1 Bytes=17) 1 0 SORT (AGGREGATE) 2 1 PARTITION RANGE (ALL) 3 2 PARTITION HASH (ALL) 4 3 TABLE ACCESS (FULL) OF 'CED_INFO_MOUVEMENT' (Cost=19 Card=24507 Bytes=416619) Statistics -- 0 recursive calls 116 db block gets 246 consistent gets 0 physical reads 0 redo size 206 bytes sent via SQL*Net to client 248 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed I tryed vith HINTS FULL and I got 5227 rows. Regards. NAME VALUE - - active_instance_count always_anti_join NESTED_LOOPS always_semi_join standard aq_tm_processes 0 audit_file_dest ?/rdbms/audit audit_trail NONE background_core_dump partial background_dump_dest /sscedre/data/sqcedi/admin/log backup_tape_io_slaves FALSE bitmap_merge_area_size1048576 blank_trimmingFALSE buffer_pool_keep buffer_pool_recycle commit_point_strength 1 compatible8.1.0 control_file_record_keep_time 7 control_files /sscedre/data/sqcedi/disk1/ctrl11sqcedi.ctl, /sscedre/data/sqcedi/disk2/ctrl12sqcedi.ctl, /sscedre/data/sqcedi/disk3/ctrl13sqcedi.ctl core_dump_dest?/dbs cpu_count 4 create_bitmap_area_size 8388608 cursor_sharingEXACT cursor_space_for_time FALSE db_block_buffers 3200 db_block_checking FALSE db_block_checksum FALSE db_block_lru_latches 2 db_block_max_dirty_target 3200 db_block_size 8192 db_domain db_file_direct_io_count 64 db_file_multiblock_read_count 32 db_file_name_convert db_files
RE: select count(*) = 0, select /*+ full(a) */ count(*) = 5227 ?
Rebuild your index and try again -Original Message- Sent: Friday, August 30, 2002 6:53 PM To: Multiple recipients of list ORACLE-L ? On Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production PL/SQL Release 8.1.7.2.0 - Production CORE8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.2.0 - Production NLSRTL Version 3.4.1.0.0 - Production I got a stange result and I wish to find an explanation. Look I did SQL select count(*) from ced_info_mouvement ; cls COUNT(*) -- 0 1 ligne sÚlectionnÚe. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 1 0 SORT (AGGREGATE) 2 1 PARTITION RANGE (ALL) 3 2 PARTITION HASH (ALL) 4 3 INDEX (FAST FULL SCAN) OF 'MVT_ID_LOT_IDX' (NON-UNIQUE) (Cost=2 Card=24507) Statistics -- 0 recursive calls 288 db block gets 120 consistent gets 0 physical reads 0 redo size 203 bytes sent via SQL*Net to client 248 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed I tryed with and order by on the first column_name, I got the exact number of rows in this table, why ? SQL select count(*) from ced_info_mouvement order by IDENTIF_PRODUIT_COMPTABLE; cls COUNT(*) -- 5227 1 ligne sÚlectionnÚe. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=19 Card=1 Bytes=17) 1 0 SORT (AGGREGATE) 2 1 PARTITION RANGE (ALL) 3 2 PARTITION HASH (ALL) 4 3 TABLE ACCESS (FULL) OF 'CED_INFO_MOUVEMENT' (Cost=19 Card=24507 Bytes=416619) Statistics -- 0 recursive calls 116 db block gets 246 consistent gets 0 physical reads 0 redo size 206 bytes sent via SQL*Net to client 248 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed I tryed vith HINTS FULL and I got 5227 rows. Regards. NAME VALUE - - active_instance_count always_anti_join NESTED_LOOPS always_semi_join standard aq_tm_processes 0 audit_file_dest ?/rdbms/audit audit_trail NONE background_core_dump partial background_dump_dest /sscedre/data/sqcedi/admin/log backup_tape_io_slaves FALSE bitmap_merge_area_size1048576 blank_trimmingFALSE buffer_pool_keep buffer_pool_recycle commit_point_strength 1 compatible8.1.0 control_file_record_keep_time 7 control_files /sscedre/data/sqcedi/disk1/ctrl11sqcedi.ctl, /sscedre/data/sqcedi/disk2/ctrl12sqcedi.ctl, /sscedre/data/sqcedi/disk3/ctrl13sqcedi.ctl core_dump_dest?/dbs cpu_count 4 create_bitmap_area_size 8388608 cursor_sharingEXACT cursor_space_for_time FALSE db_block_buffers 3200 db_block_checking FALSE db_block_checksum FALSE db_block_lru_latches 2 db_block_max_dirty_target 3200 db_block_size 8192 db_domain db_file_direct_io_count 64 db_file_multiblock_read_count 32 db_file_name_convert db_files 500 dblink_encrypt_login FALSE db_name sqcedi dbwr_io_slaves0 db_writer_processes 1 disk_asynch_ioTRUE distributed_transactions 23 dml_locks 500 enqueue_resources 5000 event 10262 trace name context forever,level 4096 fast_start_io_target 3200 fast_start_parallel_rollback LOW
RE: select count(*) = 0, select /*+ full(a) */ count(*) = 5227 ?
MVT_ID_LOT_IDX is corrupt? Does rebuilding the index fix the problem? -Original Message- Sent: Friday, August 30, 2002 9:23 AM To: Multiple recipients of list ORACLE-L ? On Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production PL/SQL Release 8.1.7.2.0 - Production CORE8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.2.0 - Production NLSRTL Version 3.4.1.0.0 - Production I got a stange result and I wish to find an explanation. Look I did SQL select count(*) from ced_info_mouvement ; cls COUNT(*) -- 0 1 ligne sÚlectionnÚe. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 1 0 SORT (AGGREGATE) 2 1 PARTITION RANGE (ALL) 3 2 PARTITION HASH (ALL) 4 3 INDEX (FAST FULL SCAN) OF 'MVT_ID_LOT_IDX' (NON-UNIQUE) (Cost=2 Card=24507) Statistics -- 0 recursive calls 288 db block gets 120 consistent gets 0 physical reads 0 redo size 203 bytes sent via SQL*Net to client 248 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed I tryed with and order by on the first column_name, I got the exact number of rows in this table, why ? SQL select count(*) from ced_info_mouvement order by IDENTIF_PRODUIT_COMPTABLE; cls COUNT(*) -- 5227 1 ligne sÚlectionnÚe. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=19 Card=1 Bytes=17) 1 0 SORT (AGGREGATE) 2 1 PARTITION RANGE (ALL) 3 2 PARTITION HASH (ALL) 4 3 TABLE ACCESS (FULL) OF 'CED_INFO_MOUVEMENT' (Cost=19 Card=24507 Bytes=416619) Statistics -- 0 recursive calls 116 db block gets 246 consistent gets 0 physical reads 0 redo size 206 bytes sent via SQL*Net to client 248 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed I tryed vith HINTS FULL and I got 5227 rows. Regards. NAME VALUE - - active_instance_count always_anti_join NESTED_LOOPS always_semi_join standard aq_tm_processes 0 audit_file_dest ?/rdbms/audit audit_trail NONE background_core_dump partial background_dump_dest /sscedre/data/sqcedi/admin/log backup_tape_io_slaves FALSE bitmap_merge_area_size1048576 blank_trimmingFALSE buffer_pool_keep buffer_pool_recycle commit_point_strength 1 compatible8.1.0 control_file_record_keep_time 7 control_files /sscedre/data/sqcedi/disk1/ctrl11sqcedi.ctl, /sscedre/data/sqcedi/disk2/ctrl12sqcedi.ctl, /sscedre/data/sqcedi/disk3/ctrl13sqcedi.ctl core_dump_dest?/dbs cpu_count 4 create_bitmap_area_size 8388608 cursor_sharingEXACT cursor_space_for_time FALSE db_block_buffers 3200 db_block_checking FALSE db_block_checksum FALSE db_block_lru_latches 2 db_block_max_dirty_target 3200 db_block_size 8192 db_domain db_file_direct_io_count 64 db_file_multiblock_read_count 32 db_file_name_convert db_files 500 dblink_encrypt_login FALSE db_name sqcedi dbwr_io_slaves0 db_writer_processes 1 disk_asynch_ioTRUE distributed_transactions 23 dml_locks 500 enqueue_resources 5000 event 10262 trace name context forever,level 4096 fast_start_io_target 3200
Re: Unix Question
-- Pawan Dalmia [EMAIL PROTECTED] My var partition is 99% full of which there are lot of files in /var/tmp directory. Can i delete this files ? Probably. Older ones are a better bet: cd /var/tmp; find . -atime +7 -type f | xargs rm -f; Question is what job leaves files behind in /var/tmp because that needs to be changed. -- 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: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora-1017 invalid username/password when trying to login as internal
Oracle 8.1.6/WinNT I get ora-1017 invalid username/password when trying to connect as internal. I have recreated password file many times to no avail. Usually this all I have had to do in the past for this error. I have tried all combinations of remote_login_passwordfile. I was getting connected earlier. I had to a shutdown but cannot get server up. Luckily it is a relatively used development server. Any ideas on how to correct? After you create a new password file, stop and restart the sid service via oradim or through nt services This happens here from time to time, not sure why, but the above works bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LIST ADMIN: VIRUS Warning: Please Repsond
Next question is, how did this happen? ltiu Mercadante, Thomas F wrote: My point was that in the corporate world, there is little choice. The only viable software choice is Outlook on WinNT boxes. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L No, I'm not saying that people using M$ products are doing so because they are stupid or lazy. Perhaps they are if they refuse to even consider the alternatives. I don't consider myself stupid or lazy and I'm using M$ products both at home and at work. I don't like them. I suggest alternatives to damagement every time I have the opportunity. For my home machines, I have put my foot down -- neither XP nor W2K will ever be used in my home -- they are just too damn invasive. I'm toying with the idea of getting one of those Lindows machines when I need to replace one of my current machines. The only reason I don't go with full Linux is that I have not found a good Linux alternative to Quicken (and I'm either too busy or too lazy to write one 8-) To restate what I said before: You always have a choice. Some people choose to believe that M$ is the ONLY choice. I don't. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 1:39 PM To: Multiple recipients of list ORACLE-L So basically you're saying that those of us using Microsoft products are doing so because we're stupid or lazy to change? -Original Message- Sent: Thursday, August 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L You always have a choice. Sometimes it is difficult to make the right choice. Consider a high school student who is doing poorly -- they can make the easy choice and drop out or they can make the difficult choice and work harder. In the case of M$, the easy choice is to accept whatever M$ does and produces. The difficult choice is to find a viable alternative (and even more difficult is to sell that to management). In the past, M$ bought out or crushed any viable alternative; they have been finding that more difficult lately. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Gee, that's a helpful reply! As if we have any choice! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Stop using MS products if you are seriously worried about viruses. [EMAIL PROTECTED] wrote: Got trigger happy, so I'm resending. -Original Message- Sent: Thursday, August 29, 2002 10:11 AM To: DBA List (E-mail); Fat Dba (E-mail) Hi, I recieved an email today as follows: Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Address of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Recipient of the infected attachment: Kelly Grigg\Inbox Subject of the message: Happy humour Epiphany One or more attachments were deleted Attachment URL.pif was Deleted for the following reasons: Virus W32.Klez.E@mm was found. Here is the repsonse from my guys: It's sending out from other domains rather sungard.com, eg. diamonddata.com and lazydba.com to you. I attached the description from your first email. It is stating that it's being blocked when it's trying to send to you, in which means it's infected on their end and are being scanned/blocked on it's way out from their systems. Have you contact them about the possible of virus attach on their end. In any case, we were alarmed and run the scan anyway. See what they can find.
RE: arg list too long in unix
-- kommareddy sreenivasa [EMAIL PROTECTED] Hi all, Is there something like, unix is unable to use commands like ls -ltr (sort etc) when there are huge number of files in a directory(may be thousands/millions). If yes, what is the limit and how to know it on sun solaris 2.8. This is not an issue with the command, but the buffer used by the O/S to store the comman line arguments. Standard sizes are 4KB or 8KB (i.e., on page). If the command line arg's exceed this size then the command cannot be started. Classic case is a directory with too many files in it; ls may work fine but ls * will blow up because the shell's expanding * overflows the buffer. If the file names are 500 char's long then you may have problems with only 10 files in the directory [don't laugh, I've seen it]. ls is partcularly bad about dealing with over-populated dir's becuse it sorts the result, which can be expensive in a 10 000 file diredtory; find does not sort anything and is better suited to dealing with huge file lists. -- 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: Steven Lembark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: IMPORT sloooowwww
Er. You can use roles in Oracle as well? Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - It has been so long since I worked with a product where each user is given direct grants rather than thru a role, that I forgot that it was possible to have that many grants on a single table -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LIST ADMIN: VIRUS Warning: Please Repsond
oh no, you can always use Lotus Notes with W2K, XP or NT... we are here such lovely choices we have --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: My point was that in the corporate world, there is little choice. The only viable software choice is Outlook on WinNT boxes. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L No, I'm not saying that people using M$ products are doing so because they are stupid or lazy. Perhaps they are if they refuse to even consider the alternatives. I don't consider myself stupid or lazy and I'm using M$ products both at home and at work. I don't like them. I suggest alternatives to damagement every time I have the opportunity. For my home machines, I have put my foot down -- neither XP nor W2K will ever be used in my home -- they are just too damn invasive. I'm toying with the idea of getting one of those Lindows machines when I need to replace one of my current machines. The only reason I don't go with full Linux is that I have not found a good Linux alternative to Quicken (and I'm either too busy or too lazy to write one 8-) To restate what I said before: You always have a choice. Some people choose to believe that M$ is the ONLY choice. I don't. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 1:39 PM To: Multiple recipients of list ORACLE-L So basically you're saying that those of us using Microsoft products are doing so because we're stupid or lazy to change? -Original Message- Sent: Thursday, August 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L You always have a choice. Sometimes it is difficult to make the right choice. Consider a high school student who is doing poorly -- they can make the easy choice and drop out or they can make the difficult choice and work harder. In the case of M$, the easy choice is to accept whatever M$ does and produces. The difficult choice is to find a viable alternative (and even more difficult is to sell that to management). In the past, M$ bought out or crushed any viable alternative; they have been finding that more difficult lately. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Gee, that's a helpful reply! As if we have any choice! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Stop using MS products if you are seriously worried about viruses. [EMAIL PROTECTED] wrote: Got trigger happy, so I'm resending. -Original Message- Sent: Thursday, August 29, 2002 10:11 AM To: DBA List (E-mail); Fat Dba (E-mail) Hi, I recieved an email today as follows: Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Address of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Recipient of the infected attachment: Kelly Grigg\Inbox Subject of the message: Happy humour Epiphany One or more attachments were deleted Attachment URL.pif was Deleted for the following reasons: Virus W32.Klez.E@mm was found. Here is the repsonse from my guys: It's sending out from other domains rather sungard.com, eg. diamonddata.com and lazydba.com to you. I attached the description from your first email. It is stating that it's being blocked when it's trying to send to you, in which means it's infected on their end and are being scanned/blocked on it's way out from their systems. Have you contact them about the possible of virus attach on their end. In any case, we were alarmed and run the scan anyway. See what they can find. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
RE: Standby with TAF config. - How to ?
Not all Oracle API's support TAF. I know that the JDBC thin driver does not support TAF, while the JDBC OCI driver does. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- Cave Sent: Friday, August 30, 2002 8:48 AM To: Multiple recipients of list ORACLE-L At 02:33 AM 8/30/2002, you wrote: oraora oraora, If you want to implement TAF, you have to use OPS/RAC. and you application must be written via OCI when connect to database. Your application doesn't necessarily have to be written in OCI to use TAF, but whatever layer eventually makes the OCI calls does. Oracle's ODBC driver, for example, implements TAF support, so any ODBC application which uses the Oracle driver will get TAF support. Other Oracle API's likely do the same. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] === 2002-08-29 22:28:00 ,you wrote£º=== Guys , 1# Can Standby database be configured for TAF ? 2# If so , when the Primary DB fails will the client application be automatically failed over to Standby DB ? 3# And thereafter can the client application proceed it's process without any manual intervention ? I have read the Standby Database - Concepts and Admin. manual. What i am not clear about is how to configure Standby DB with TAF so that least manual intervention is required ? Can anyone of u help me ? Any good resource for the same ? TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = zhu chao [EMAIL PROTECTED] 2002-08-30 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Justin Cave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: arg list too long in unix
The size of the buffer used to store parameters is actually configurable in most Unix versions I've had a look at. Somewhere around 4K, from memory. Would be very surprised if it wasn't configurable in Solaris. Would also be very surprised if you find one techo at Sun that knows how to change it. It's actually one of the configurable kernel parameters, but you got to edit it directly. Last time I did this was 6 years ago, so don't even dream of asking me to remember the details. I've got enough trouble trying to remember what I had for breakfast today! Dig into the man pages, have a look at xargs command and follow the links from there. That's how I came across this. info(2) is also useful. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - If yes, what is the limit and how to know it on sun solaris 2.8. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: select count(*) = 0, select /*+ full(a) */ count(*) = 5227 ?
There was a bug (still is in 8?) in 7.3 where a parallel index creation would cause an index to be built with 0 entries. This would occur when the index columns could be found in another index. The parallel master process would get confused as to which index was the source and target. The end result...an index with 0 entries. I still fondly recall the panicked call from a developer 'I created an index and it deleted all the rows!'. -Original Message- Sent: Friday, August 30, 2002 8:09 AM To: Multiple recipients of list ORACLE-L 5227 ? MVT_ID_LOT_IDX is corrupt? Does rebuilding the index fix the problem? -Original Message- Sent: Friday, August 30, 2002 9:23 AM To: Multiple recipients of list ORACLE-L ? On Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production PL/SQL Release 8.1.7.2.0 - Production CORE8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.2.0 - Production NLSRTL Version 3.4.1.0.0 - Production I got a stange result and I wish to find an explanation. Look I did SQL select count(*) from ced_info_mouvement ; cls COUNT(*) -- 0 1 ligne sÚlectionnÚe. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 1 0 SORT (AGGREGATE) 2 1 PARTITION RANGE (ALL) 3 2 PARTITION HASH (ALL) 4 3 INDEX (FAST FULL SCAN) OF 'MVT_ID_LOT_IDX' (NON-UNIQUE) (Cost=2 Card=24507) Statistics -- 0 recursive calls 288 db block gets 120 consistent gets 0 physical reads 0 redo size 203 bytes sent via SQL*Net to client 248 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed I tryed with and order by on the first column_name, I got the exact number of rows in this table, why ? SQL select count(*) from ced_info_mouvement order by IDENTIF_PRODUIT_COMPTABLE; cls COUNT(*) -- 5227 1 ligne sÚlectionnÚe. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=19 Card=1 Bytes=17) 1 0 SORT (AGGREGATE) 2 1 PARTITION RANGE (ALL) 3 2 PARTITION HASH (ALL) 4 3 TABLE ACCESS (FULL) OF 'CED_INFO_MOUVEMENT' (Cost=19 Card=24507 Bytes=416619) Statistics -- 0 recursive calls 116 db block gets 246 consistent gets 0 physical reads 0 redo size 206 bytes sent via SQL*Net to client 248 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed I tryed vith HINTS FULL and I got 5227 rows. Regards. NAME VALUE - - active_instance_count always_anti_join NESTED_LOOPS always_semi_join standard aq_tm_processes 0 audit_file_dest ?/rdbms/audit audit_trail NONE background_core_dump partial background_dump_dest /sscedre/data/sqcedi/admin/log backup_tape_io_slaves FALSE bitmap_merge_area_size1048576 blank_trimmingFALSE buffer_pool_keep buffer_pool_recycle commit_point_strength 1 compatible8.1.0 control_file_record_keep_time 7 control_files /sscedre/data/sqcedi/disk1/ctrl11sqcedi.ctl, /sscedre/data/sqcedi/disk2/ctrl12sqcedi.ctl, /sscedre/data/sqcedi/disk3/ctrl13sqcedi.ctl core_dump_dest?/dbs cpu_count 4 create_bitmap_area_size 8388608 cursor_sharingEXACT cursor_space_for_time FALSE db_block_buffers 3200 db_block_checking FALSE db_block_checksum FALSE db_block_lru_latches 2 db_block_max_dirty_target 3200 db_block_size 8192 db_domain db_file_direct_io_count 64 db_file_multiblock_read_count 32 db_file_name_convert db_files 500
RE: IMPORT sloooowwww
Title: RE: IMPORT sl i might add my 2c, even though the problem has been resolved. :-) once upon a time, we had a 2g database that was taking a looong time to import. anyone ever heard of remedy? did everything that has already been mentioned. tracing revealed log file sync waits ... and lots of em' ... (and a few other log type waits ...) we had long datatypes ... we were frustrated ... it's only 2 bloody gig after all ... got rid of the 2nd member of each log group -- byebye log file parallel write waits ... i then threw the remaining logs on /tmp. bingo. an import that was looking to take 24hrs suddenly flew. this was done in test a number of times before we did it on production. but we did put the logs on /tmp in prod. after the import we very quickly moved them off. :-) the real issue was a poor io subsystem, but oracle's handling of longs during import did not help. never followed up on the internals of it. a document on metalink purporting to shed light on issues w/importing longs was ... not available to me (or something like that). the moral here is, in _certain_ situations, odd little tricks like that can save the day. it ain't for everyone, but in our particular case, logs in memory allowed us to complete a nasty little rebuild (can you say 15 extents ...) for a very poorly configured db w/in the allocated time window. cheers, casey ... -Original Message- From: Ball, Terry [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 5:23 PM To: Multiple recipients of list ORACLE-L Subject: IMPORT sl Oracle 8.1.7 on Solaris 8 I am testing and upgrade from 7.3.4 to 8.1.7. Because the test server is solaris 8, and I can't find the patches for 7 anymore, I am trying to upgrade via an export and import. Besides, the DB is small - less than 2G. The export was done with compress=n. There are 200+ tables to be imported. It is taking 3+ minutes per table for the import, even on tables that have 0 rows. (Though it does take longer than that for the few tables with over 50K rows). I have tried: 1) Simple import. 2) Import with indexes=n 3) Import with table and constraints (but not indexes) pre-created and indexes=n ignore=y 4) All of the above with the buffer set to 8M (This actually slows the import down, taking 5+ minutes per table). 5) Increasing the sort_area_size for the DB to twice as large as it was and trying the above. In looking at how long it takes, the table imports in a second or less, but it takes 3 minutes + to start the import of the next table. I'm not sure what it is doing for 3 minutes after the table imports. Does anyone have any ideas how I can speed this up? 10 hours to import a 2G. DB is extreme and unacceptable. TIA. Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LIST ADMIN: VIRUS Warning: Please Repsond
found some way to fake out Linux to run Lotus Notes in a shell if I am not mistaken, too... -Original Message- Sent: Friday, August 30, 2002 9:49 AM To: Multiple recipients of list ORACLE-L oh no, you can always use Lotus Notes with W2K, XP or NT... we are here such lovely choices we have --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: My point was that in the corporate world, there is little choice. The only viable software choice is Outlook on WinNT boxes. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L No, I'm not saying that people using M$ products are doing so because they are stupid or lazy. Perhaps they are if they refuse to even consider the alternatives. I don't consider myself stupid or lazy and I'm using M$ products both at home and at work. I don't like them. I suggest alternatives to damagement every time I have the opportunity. For my home machines, I have put my foot down -- neither XP nor W2K will ever be used in my home -- they are just too damn invasive. I'm toying with the idea of getting one of those Lindows machines when I need to replace one of my current machines. The only reason I don't go with full Linux is that I have not found a good Linux alternative to Quicken (and I'm either too busy or too lazy to write one 8-) To restate what I said before: You always have a choice. Some people choose to believe that M$ is the ONLY choice. I don't. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 1:39 PM To: Multiple recipients of list ORACLE-L So basically you're saying that those of us using Microsoft products are doing so because we're stupid or lazy to change? -Original Message- Sent: Thursday, August 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L You always have a choice. Sometimes it is difficult to make the right choice. Consider a high school student who is doing poorly -- they can make the easy choice and drop out or they can make the difficult choice and work harder. In the case of M$, the easy choice is to accept whatever M$ does and produces. The difficult choice is to find a viable alternative (and even more difficult is to sell that to management). In the past, M$ bought out or crushed any viable alternative; they have been finding that more difficult lately. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Gee, that's a helpful reply! As if we have any choice! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Stop using MS products if you are seriously worried about viruses. [EMAIL PROTECTED] wrote: Got trigger happy, so I'm resending. -Original Message- Sent: Thursday, August 29, 2002 10:11 AM To: DBA List (E-mail); Fat Dba (E-mail) Hi, I recieved an email today as follows: Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Address of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Recipient of the infected attachment: Kelly Grigg\Inbox Subject of the message: Happy humour Epiphany One or more attachments were deleted Attachment URL.pif was Deleted for the following reasons: Virus W32.Klez.E@mm was found. Here is the repsonse from my guys: It's sending out from other domains rather sungard.com, eg. diamonddata.com and lazydba.com to you. I attached the description from your first email. It is stating that it's being blocked when it's trying to send to you, in which means it's infected on their end and are being scanned/blocked on it's way out from their systems. Have you contact them about the possible of virus attach on their end. In any case, we were alarmed and run the scan anyway. See what they can find. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --
RE: LIST ADMIN: VIRUS Warning: Please Repsond
Wine can run lotus notes. I tested it and it works fairly nice. The only problem is that I cannot resize the window, so I have to use another workspace for it. -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] Sent: Friday, August 30, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: LIST ADMIN: VIRUS Warning: Please Repsond found some way to fake out Linux to run Lotus Notes in a shell if I am not mistaken, too... -Original Message- Sent: Friday, August 30, 2002 9:49 AM To: Multiple recipients of list ORACLE-L oh no, you can always use Lotus Notes with W2K, XP or NT... we are here such lovely choices we have --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: My point was that in the corporate world, there is little choice. The only viable software choice is Outlook on WinNT boxes. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L No, I'm not saying that people using M$ products are doing so because they are stupid or lazy. Perhaps they are if they refuse to even consider the alternatives. I don't consider myself stupid or lazy and I'm using M$ products both at home and at work. I don't like them. I suggest alternatives to damagement every time I have the opportunity. For my home machines, I have put my foot down -- neither XP nor W2K will ever be used in my home -- they are just too damn invasive. I'm toying with the idea of getting one of those Lindows machines when I need to replace one of my current machines. The only reason I don't go with full Linux is that I have not found a good Linux alternative to Quicken (and I'm either too busy or too lazy to write one 8-) To restate what I said before: You always have a choice. Some people choose to believe that M$ is the ONLY choice. I don't. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 1:39 PM To: Multiple recipients of list ORACLE-L So basically you're saying that those of us using Microsoft products are doing so because we're stupid or lazy to change? -Original Message- Sent: Thursday, August 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L You always have a choice. Sometimes it is difficult to make the right choice. Consider a high school student who is doing poorly -- they can make the easy choice and drop out or they can make the difficult choice and work harder. In the case of M$, the easy choice is to accept whatever M$ does and produces. The difficult choice is to find a viable alternative (and even more difficult is to sell that to management). In the past, M$ bought out or crushed any viable alternative; they have been finding that more difficult lately. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Gee, that's a helpful reply! As if we have any choice! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Stop using MS products if you are seriously worried about viruses. [EMAIL PROTECTED] wrote: Got trigger happy, so I'm resending. -Original Message- Sent: Thursday, August 29, 2002 10:11 AM To: DBA List (E-mail); Fat Dba (E-mail) Hi, I recieved an email today as follows: Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Address of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Recipient of the infected attachment: Kelly Grigg\Inbox Subject of the message: Happy humour Epiphany One or more attachments were deleted Attachment URL.pif was Deleted for the following reasons: Virus W32.Klez.E@mm was found. Here is the repsonse from my guys: It's sending out from other domains rather sungard.com, eg. diamonddata.com and lazydba.com to you. I attached the description from your first email. It is stating that it's being blocked when it's trying to send to you, in which means it's infected on their end and are being scanned/blocked on it's way out from their systems. Have you contact them about the possible of virus attach on their end. In any case, we were alarmed and run the scan anyway. See what they can find. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL
RE: LIST ADMIN: VIRUS Warning: Please Repsond
The universe exists according to our beliefs. If you believe that you have no choice, then you have no choice. But only because you believe it. Happy Friday, Mark There is no spoon Stahlke Denver Newspaper Agency -Original Message- Sent: Friday, August 30, 2002 7:58 AM To: Multiple recipients of list ORACLE-L Subject:RE: LIST ADMIN: VIRUS Warning: Please Repsond My point was that in the corporate world, there is little choice. The only viable software choice is Outlook on WinNT boxes. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L No, I'm not saying that people using M$ products are doing so because they are stupid or lazy. Perhaps they are if they refuse to even consider the alternatives. I don't consider myself stupid or lazy and I'm using M$ products both at home and at work. I don't like them. I suggest alternatives to damagement every time I have the opportunity. For my home machines, I have put my foot down -- neither XP nor W2K will ever be used in my home -- they are just too damn invasive. I'm toying with the idea of getting one of those Lindows machines when I need to replace one of my current machines. The only reason I don't go with full Linux is that I have not found a good Linux alternative to Quicken (and I'm either too busy or too lazy to write one 8-) To restate what I said before: You always have a choice. Some people choose to believe that M$ is the ONLY choice. I don't. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 1:39 PM To: Multiple recipients of list ORACLE-L So basically you're saying that those of us using Microsoft products are doing so because we're stupid or lazy to change? -Original Message- Sent: Thursday, August 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L You always have a choice. Sometimes it is difficult to make the right choice. Consider a high school student who is doing poorly -- they can make the easy choice and drop out or they can make the difficult choice and work harder. In the case of M$, the easy choice is to accept whatever M$ does and produces. The difficult choice is to find a viable alternative (and even more difficult is to sell that to management). In the past, M$ bought out or crushed any viable alternative; they have been finding that more difficult lately. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Gee, that's a helpful reply! As if we have any choice! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Stop using MS products if you are seriously worried about viruses. [EMAIL PROTECTED] wrote: Got trigger happy, so I'm resending. -Original Message- Sent: Thursday, August 29, 2002 10:11 AM To: DBA List (E-mail); Fat Dba (E-mail) Hi, I recieved an email today as follows: Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Address of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Recipient of the infected attachment: Kelly Grigg\Inbox Subject of the message: Happy humour Epiphany One or more attachments were deleted Attachment URL.pif was Deleted for the following reasons: Virus W32.Klez.E@mm was found. Here is the repsonse from my guys: It's sending out from other domains rather sungard.com, eg. diamonddata.com and lazydba.com to you. I attached the description from your first email. It is stating that it's being blocked when it's trying to send to you, in which means it's infected on their end and are being scanned/blocked on it's way out from their systems. Have you contact them about the possible of virus attach on their end. In any case, we were alarmed and run the scan anyway. See what they can find. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat
Re: select count(*) = 0, select /*+ full(a) */ count(*) = 5227 ?
I had the same issue in a 8.1.6 database and found that was bug related to the cost based optimizer and materialized views. Never did resolve it but found that the problem occurred when the table in question had a materialized view selecting data from in. Thanks, caj - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 30, 2002 9:23 AM On Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production PL/SQL Release 8.1.7.2.0 - Production CORE8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.2.0 - Production NLSRTL Version 3.4.1.0.0 - Production I got a stange result and I wish to find an explanation. Look I did SQL select count(*) from ced_info_mouvement ; cls COUNT(*) -- 0 1 ligne sÚlectionnÚe. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1) 1 0 SORT (AGGREGATE) 2 1 PARTITION RANGE (ALL) 3 2 PARTITION HASH (ALL) 4 3 INDEX (FAST FULL SCAN) OF 'MVT_ID_LOT_IDX' (NON-UNIQUE) (Cost=2 Card=24507) Statistics -- 0 recursive calls 288 db block gets 120 consistent gets 0 physical reads 0 redo size 203 bytes sent via SQL*Net to client 248 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed I tryed with and order by on the first column_name, I got the exact number of rows in this table, why ? SQL select count(*) from ced_info_mouvement order by IDENTIF_PRODUIT_COMPTABLE; cls COUNT(*) -- 5227 1 ligne sÚlectionnÚe. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=19 Card=1 Bytes=17) 1 0 SORT (AGGREGATE) 2 1 PARTITION RANGE (ALL) 3 2 PARTITION HASH (ALL) 4 3 TABLE ACCESS (FULL) OF 'CED_INFO_MOUVEMENT' (Cost=19 Card=24507 Bytes=416619) Statistics -- 0 recursive calls 116 db block gets 246 consistent gets 0 physical reads 0 redo size 206 bytes sent via SQL*Net to client 248 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed I tryed vith HINTS FULL and I got 5227 rows. Regards. NAME VALUE - - active_instance_count always_anti_join NESTED_LOOPS always_semi_join standard aq_tm_processes 0 audit_file_dest ?/rdbms/audit audit_trail NONE background_core_dump partial background_dump_dest /sscedre/data/sqcedi/admin/log backup_tape_io_slaves FALSE bitmap_merge_area_size1048576 blank_trimmingFALSE buffer_pool_keep buffer_pool_recycle commit_point_strength 1 compatible8.1.0 control_file_record_keep_time 7 control_files /sscedre/data/sqcedi/disk1/ctrl11sqcedi.ctl, /sscedre/data/sqcedi/disk2/ctrl12sqcedi.ctl, /sscedre/data/sqcedi/disk3/ctrl13sqcedi.ctl core_dump_dest?/dbs cpu_count 4 create_bitmap_area_size 8388608 cursor_sharingEXACT cursor_space_for_time FALSE db_block_buffers 3200 db_block_checking FALSE db_block_checksum FALSE db_block_lru_latches 2 db_block_max_dirty_target 3200 db_block_size 8192 db_domain db_file_direct_io_count 64 db_file_multiblock_read_count 32 db_file_name_convert db_files 500 dblink_encrypt_login FALSE db_name sqcedi dbwr_io_slaves0 db_writer_processes 1 disk_asynch_ioTRUE distributed_transactions 23 dml_locks 500
RE: IMPORT sloooowwww
Title: RE: IMPORT sl I like the way you found the root cause. If I may paraphrase, you asked the database how it was spending its time, and the answer guided the remainder of your performance improvement project. I contrast this method with the traditional approach, which is to try to guess at a root cause from the domain of literally thousands of possible root causes. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 13 San Francisco, Oct 1517 Dallas, Dec 911 Honolulu - 2003 Hotsos Symposium on Oracle System Performance, Feb 912 Dallas - Next event: Miracle Database Forum, Sep 2022 Middlefart Denmark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Casey Dyke Sent: Friday, August 30, 2002 10:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: IMPORT sl i might add my 2c, even though the problem has been resolved. :-) once upon a time, we had a 2g database that was taking a looong time to import. anyone ever heard of remedy? did everything that has already been mentioned. tracing revealed log file sync waits ... and lots of em' ... (and a few other log type waits ...) we had long datatypes ... we were frustrated ... it's only 2 bloody gig after all ... got rid of the 2nd member of each log group -- byebye log file parallel write waits ... i then threw the remaining logs on /tmp. bingo. an import that was looking to take 24hrs suddenly flew. this was done in test a number of times before we did it on production. but we did put the logs on /tmp in prod. after the import we very quickly moved them off. :-) the real issue was a poor io subsystem, but oracle's handling of longs during import did not help. never followed up on the internals of it. a document on metalink purporting to shed light on issues w/importing longs was ... not available to me (or something like that). the moral here is, in _certain_ situations, odd little tricks like that can save the day. it ain't for everyone, but in our particular case, logs in memory allowed us to complete a nasty little rebuild (can you say 15 extents ...) for a very poorly configured db w/in the allocated time window. cheers, casey ... -Original Message- From: Ball, Terry [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 5:23 PM To: Multiple recipients of list ORACLE-L Subject: IMPORT sl Oracle 8.1.7 on Solaris 8 I am testing and upgrade from 7.3.4 to 8.1.7. Because the test server is solaris 8, and I can't find the patches for 7 anymore, I am trying to upgrade via an export and import. Besides, the DB is small - less than 2G. The export was done with compress=n. There are 200+ tables to be imported. It is taking 3+ minutes per table for the import, even on tables that have 0 rows. (Though it does take longer than that for the few tables with over 50K rows). I have tried: 1) Simple import. 2) Import with indexes=n 3) Import with table and constraints (but not indexes) pre-created and indexes=n ignore=y 4) All of the above with the buffer set to 8M (This actually slows the import down, taking 5+ minutes per table). 5) Increasing the sort_area_size for the DB to twice as large as it was and trying the above. In looking at how long it takes, the table imports in a second or less, but it takes 3 minutes + to start the import of the next table. I'm not sure what it is doing for 3 minutes after the table imports. Does anyone have any ideas how I can speed this up? 10 hours to import a 2G. DB is extreme and unacceptable. TIA. Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Library cache lock and library cache latch
Good morning, everyone. A running Oracle server contains both library cache locks and library cache latches. What are the criteria for using a lock vs. a latch for protecting objects in the cache? For example, at the moment we're trying to create a new version of a package, but a running session calls it constantly; the wait event references the library cache lock. I've seen waits on the library cache latch in similar situations (at least I think I have; my memory may be failing me!). TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LIST ADMIN: VIRUS Warning: Please Repsond
Lotus Notes is good enough and for a time were the number one (and the only one). How the hell did they lose market share? ltiu On Friday 30 August 2002 08:28, April Wells wrote: found some way to fake out Linux to run Lotus Notes in a shell if I am not mistaken, too... -Original Message- Sent: Friday, August 30, 2002 9:49 AM To: Multiple recipients of list ORACLE-L oh no, you can always use Lotus Notes with W2K, XP or NT... we are here such lovely choices we have --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: My point was that in the corporate world, there is little choice. The only viable software choice is Outlook on WinNT boxes. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L No, I'm not saying that people using M$ products are doing so because they are stupid or lazy. Perhaps they are if they refuse to even consider the alternatives. I don't consider myself stupid or lazy and I'm using M$ products both at home and at work. I don't like them. I suggest alternatives to damagement every time I have the opportunity. For my home machines, I have put my foot down -- neither XP nor W2K will ever be used in my home -- they are just too damn invasive. I'm toying with the idea of getting one of those Lindows machines when I need to replace one of my current machines. The only reason I don't go with full Linux is that I have not found a good Linux alternative to Quicken (and I'm either too busy or too lazy to write one 8-) To restate what I said before: You always have a choice. Some people choose to believe that M$ is the ONLY choice. I don't. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 1:39 PM To: Multiple recipients of list ORACLE-L So basically you're saying that those of us using Microsoft products are doing so because we're stupid or lazy to change? -Original Message- Sent: Thursday, August 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L You always have a choice. Sometimes it is difficult to make the right choice. Consider a high school student who is doing poorly -- they can make the easy choice and drop out or they can make the difficult choice and work harder. In the case of M$, the easy choice is to accept whatever M$ does and produces. The difficult choice is to find a viable alternative (and even more difficult is to sell that to management). In the past, M$ bought out or crushed any viable alternative; they have been finding that more difficult lately. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Gee, that's a helpful reply! As if we have any choice! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Stop using MS products if you are seriously worried about viruses. [EMAIL PROTECTED] wrote: Got trigger happy, so I'm resending. -Original Message- Sent: Thursday, August 29, 2002 10:11 AM To: DBA List (E-mail); Fat Dba (E-mail) Hi, I recieved an email today as follows: Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Address of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Recipient of the infected attachment: Kelly Grigg\Inbox Subject of the message: Happy humour Epiphany One or more attachments were deleted Attachment URL.pif was Deleted for the following reasons: Virus W32.Klez.E@mm was found. Here is the repsonse from my guys: It's sending out from other domains rather sungard.com, eg. diamonddata.com and lazydba.com to you. I attached the description from your first email. It is stating that it's being blocked when it's trying to send to you, in which means it's infected on their end and are being scanned/blocked on it's way out from their systems. Have you contact them about the possible of virus attach on their end. In any case, we were alarmed and run the scan anyway. See what they can find. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing
Creating Scott/Tiger
I need to create the Scott/Tiger schema in Oracle9i. Does anyone recall off the top of their head just where the script to do this is located? 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).
SQL*Plus in 10i
Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sql loader control file help
On Mon, 26 Aug 2002 13:41:50 -0800, Rachel wrote: I am not, by any means, a SQL*Loader expert (Jonathan, I keep meaning to get your book!) Sounds like you've solved this one already, but since you invoked my name (and in vain too, since I was of no help grin), I'll just chime in to say that my best guess is that you are encountering a character set translation issue. Not sure my book would help much with this. I don't recall delving into character sets in the book. I'll have to correct that omission when I do the revision. I will say that I've recently had occasion to delve into Oracle's support of Unicode (for Steven Feuerstein's upcomming PL/SQL, Third Edition). It's incredible how complicated something so seemingly simple (on the surface) can be. 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).
Why it picks up the same PFILE for both the DBs?
Hi All, I have a system with 2 databases, both running on the same server 8.0.5. OS - Windows NT When i connect thru server manager to TEST, and then issue STARTUP, it starts up the PROD database using the initPROD.ora file. On querying V$instance it shows INSTANCE_NAME = TEST On querying V$database it shows NAME=PROD. When i connect to PROD and STARTUP, it starts PROD using initPROD.ora On querying V$instance it shows INSTANCE_NAME = PROD On querying V$database it shows NAME=PROD. The following registry parameters are set... ORA_TEST_PFILE - Pointing to initTEST.ora ORA_PROD_PFILE - Pointing to initPROD.ora What am i missing?? Regards, Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Hot Backup scripts UNIX
Here's a ksh script that dumps backup files to a remote server. It also accounts for multiple datafiles per tablespace, which I didn't see coded in the Velpuri scripts. Suzy #!/bin/ksh # --- # Program: hot_backup.sh # Created By: lvordos # Syntax: hot_backup.sh ORACLE_SID BACKUP_SRVR # # Executes hot backup for ${ORACLE_SID} and sends all backup data # to ${BACKUP_SRVR}. # # This script connects as BACKUP_ADM and requires the following system # privileges: create session, select_catalog_role, alter database, # alter tablespace, alter system # # Events of this script are logged to: # ${HOME}/logs/hot_backup_${ORACLE_SID}.log # # --- # LOAD ENVIRONMENT # #-- set base env --# . ${HOME}/bin/setenv.sh #-- set oracle env --# ORACLE_SID=${1} ; export ORACLE_SID ORACLE_HOME=`cat ${ORATAB} |grep ${ORACLE_SID} | awk -F: '/^[^#]/' | \ cut -d : -f2` ; export ORACLE_HOME unset SQLPATH #-- set custom env --# NOTIFY_SUBJ=FAILURE: ${HOSTNAME}:${ORACLE_SID} ${0##*/} ; export NOTIFY_SUBJ BACKUP_SRVR=${2} ; export BACKUP_SRVR RMTBAK_DIR1=/backup01/orcldb/${ORACLE_SID} ; export RMTBAK_DIR1 LOCBAK_DIR1=/dbbak01/bakdata/${ORACLE_SID} ; export LOCBAK_DIR1 ORACFG_DIR=${ORACLE_ADMIN}/${ORACLE_SID}/pfile ; export ORACFG_DIR SSH=/usr/local/bin/ssh ; export SSH SCP=/usr/local/bin/scp ; export SCP # # PROGRAM FUNCTIONS # # ## # generate output listing of tablespaces # # and datafiles for backup # ## do_tablespace_lst() { function=do_tablespace_lst; print \nSTART ${function} at `date +%H:%M:%S`\n ${ORACLE_HOME}/bin/sqlplus -s /nolog -[] connect ${BACKUP_ADM}@${ORACLE_SID} whenever sqlerror exit sql.sqlcode; set feedback off echo on pagesize 0 trimspool on host echo \n++ Executing checkpoint alter system checkpoint ; host echo \n++ Archiving current logs alter system archive log current ; host echo ++ Generating tablespace and datafile list for backup spool ${LOGDIR}/${ORACLE_SID}_datafiles.txt select tablespace_name ||':'|| file_name from dba_data_files order by tablespace_name, file_name ; spool off host echo \n++ Backup tablespace list complete [] if [[ $? != 0 ]] ; then print \nFATAL: ${function} Failure generating tablespace list\n NOTIFY_MSG=`cat ${LOGFILE}` enotify exit -1 else if [[ ! -s ${LOGDIR}/${ORACLE_SID}_datafiles.txt ]] ; then print \nFATAL: ${function} Tablespace list does not exist \n NOTIFY_MSG=`cat ${LOGFILE}` enotify exit -1 fi fi print END ${function} at `date +%H:%M:%S` Status $? \n } ## # roll previous backups on backup server # ## do_roll_backups() { function=do_roll_backups; print \nSTART ${function} at `date +%H:%M:%S` # remove oldest backup if ${SSH} ${BACKUP_SRVR} rm -r ${RMTBAK_DIR1}/03 ; then print \n++ Rolling previous backups on ${BACKUP_SRVR}\n # rename previous current previous backups ${SSH} ${BACKUP_SRVR} mv ${RMTBAK_DIR1}/02 ${RMTBAK_DIR1}/03 ${SSH} ${BACKUP_SRVR} mv ${RMTBAK_DIR1}/01 ${RMTBAK_DIR1}/02 ${SSH} ${BACKUP_SRVR} cp -pr ${RMTBAK_DIR1}/00 ${RMTBAK_DIR1}/01 else print \nFATAL: ${function} Could not roll backups on ${BACKUP_SRVR}\n NOTIFY_MSG=`cat ${LOGFILE}` enotify exit -1 fi if ${SSH} ${BACKUP_SRVR} ls -d ${RMTBAK_DIR1}/01 ; then print ++ Backup directory exists on ${BACKUP_SRVR}\n else print \nFATAL: ${function} Backup directory ${RMTBAK_DIR1}/01 not found on ${BACKUP_SRVR}\n NOTIFY_MSG=`cat ${LOGFILE}` enotify exit -1 fi print END ${function} at `date +%H:%M:%S` Status $? \n } ## # put tablespaces in backup mode - if that fails # # for any tablespace call do_end and exit script # ## do_begin_backup() { function=do_begin_backup; print \nSTART ${function} at `date +%H:%M:%S`\n ${ORACLE_HOME}/bin/sqlplus -s /nolog -[] connect ${BACKUP_ADM}@${ORACLE_SID} whenever sqlerror exit sql.sqlcode; set feedback off echo on variable tscnt number ; host echo \n++ Altering tablespace ${T} to backup mode alter tablespace ${T} begin backup ; set termout off execute select count(1) into :tscnt from v\$backup b, dba_data_files d where d.file_id = b.file# and d.tablespace_name = '${T}' and b.status != 'ACTIVE'; execute if :tscnt 0 then raise invalid_number ; end if ; host echo ++ Tablespace ${T} in backup mode [] if [[ $? != 0 ]] ; then print \nFATAL: ${function} Tablespace ${T} not in backup mode\n NOTIFY_MSG=`cat ${LOGFILE}` enotify exit -1 fi #
RE: LIST ADMIN: VIRUS Warning: Please Repsond
HERE... herd mentality... Microsoft rules... Microsoft Rules... Oracle Applications are buggy and user GMT in their log files... Access is better, Microsoft doesn't sell buggy software... mooo... hey... look at that really cool cliff... Let's follow those other buffalo ... the jump looks like fun Better question. If 90% of the email virus's are written for Outlook address book... Why is it considered 'what to use'? -Original Message- Sent: Friday, August 30, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Lotus Notes is good enough and for a time were the number one (and the only one). How the hell did they lose market share? ltiu On Friday 30 August 2002 08:28, April Wells wrote: found some way to fake out Linux to run Lotus Notes in a shell if I am not mistaken, too... -Original Message- Sent: Friday, August 30, 2002 9:49 AM To: Multiple recipients of list ORACLE-L oh no, you can always use Lotus Notes with W2K, XP or NT... we are here such lovely choices we have begin 666 InterScan_Disclaimer.txt M0U-502 R,# R.B @26UA9VEN92!T:4@4]SVEB:6QI=EER$-D-OG!O MF%T92!37-T96US($%N;G5A;!5V5RR!!W-O8VEA=EO;B!#;VYF97)E M;F-E#0I7:5N.B!/8W1O8F5R(#(M-P@,C P,@T*5VAEF4Z($-AFEB92!2 M;WEA;4@4F5S;W)T( @3W)L86YD;RP@1DP@(%5300T*1F]R(UOF4@:6YF M;W)M871I;VX@9V\@=\@=W=W+F-S961G92YC;VT-@T*#0H-E1H92!I;F9O MFUA=EO;B!C;VYT86EN960@:6X@=AIR!E+6UA:6P@:7,@W1R:6-T;'D@ M8V]N9FED96YT:6%L(%N9!F;W(@=AE(EN=5N95D('5S92!O9B!T:4@ M861DF5SV5E(]N;'D[(ET(UA2!A;'-O()E(QE9V%L;'D@')I=FEL M96=E9!A;F0O;W(@')I8V4@V5NVET:79E+B @3F]T:6-E(ES(AEF5B M2!G:79E;B!T:%T(%N2!D:7-C;]S=7)E+!UV4@;W(@8V]P6EN9R!O M9B!T:4@:6YF;W)M871I;VX@8GD@86YY;VYE(]T:5R('1H86X@=AE(EN M=5N95D(')E8VEP:65N=!IR!PF]H:6)I=5D(%N9!M87D@8F4@:6QL M96=A;X@($EF('EO=2!H879E(')E8V5I=F5D('1H:7,@;65SV%G92!I;B!E MG)OBP@QE87-E(YO=EF2!T:4@V5N95R(EM;65D:6%T96QY()Y M(')E='5R;B!E+6UA:6PN@I#;W)P;W)A=4@4WES=5MRP@26YC+B!H87,@ M=%K96X@979EGD@F5AV]N86)L92!PF5C875T:6]N('1O(5NW5R92!T M:%T(%N2!A='1A8VAM96YT('1O('1H:7,@92UM86EL(AAR!B965N('-W M97!T(9OB!V:7)UV5S+B @5V4@86-C97!T(YO(QI86)I;ET2!F;W(@ M86YY(1A;6%G92!S=7-T86EN960@87,@82!R97-U;'0@;V8@V]F='=AF4@ M=FER=7-ER!A;F0@861V:7-E('EO=2!C87)R2!O=70@6]UB!O=VX@=FER M=7,@8VAE8VMS()E9F]R92!O5N:6YG(%N2!A='1A8VAM96YT+@T*#0H- #@T* end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Automatic generation of Statspack report ...
Someone had asked this question ... maybe this will help .. Batch mode report generation To run a report without being prompted, assign values to the and the report name before running spreport. The variables are: begin_snap - specifies the begin Snapshot Id end_snap - specifies the end Snapshot Id report_name - specifies the Report output name e.g. on Unix: SQL connect perfstat/perfstat SQL define begin_snap=1 SQL define end_snap=2 SQL define report_name=batch_run SQL ?/rdbms/admin/spreport spreport will no longer prompt for the above information. 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! *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: Creating Scott/Tiger
I don't know about the user scott/tiger, but the scripts to build the tables (emp, dept, etc) are in $ORACLE_HOME/sqlplus/demo /opt/oracle/product/9.0.2/sqlplus/demo ll total 16 -rw-r--r-- 1 oracle oinstall 3565 May 13 2001 demobld.sql -rw-r--r-- 1 oracle oinstall 573 May 13 2001 demodrop.sql Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Jonathan Gennick [SMTP:[EMAIL PROTECTED]] Sent: Friday, August 30, 2002 11:53 AM To: Multiple recipients of list ORACLE-L Subject: Creating Scott/Tiger I need to create the Scott/Tiger schema in Oracle9i. Does anyone recall off the top of their head just where the script to do this is located? 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). -- 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: SQL*Plus in 10i
Are you kidding? So what do we use to startup and shutdown db? OEM? I don't think there is any truth to this one. Richard -Original Message- Sent: Friday, August 30, 2002 12:23 PM To: Multiple recipients of list ORACLE-L Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- 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: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LIST ADMIN: VIRUS Warning: Please Repsond
The same way Digital did. The best product doesn't always win... -Original Message- Sent: Friday, August 30, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Lotus Notes is good enough and for a time were the number one (and the only one). How the hell did they lose market share? ltiu On Friday 30 August 2002 08:28, April Wells wrote: found some way to fake out Linux to run Lotus Notes in a shell if I am not mistaken, too... -Original Message- Sent: Friday, August 30, 2002 9:49 AM To: Multiple recipients of list ORACLE-L oh no, you can always use Lotus Notes with W2K, XP or NT... we are here such lovely choices we have --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: My point was that in the corporate world, there is little choice. The only viable software choice is Outlook on WinNT boxes. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L No, I'm not saying that people using M$ products are doing so because they are stupid or lazy. Perhaps they are if they refuse to even consider the alternatives. I don't consider myself stupid or lazy and I'm using M$ products both at home and at work. I don't like them. I suggest alternatives to damagement every time I have the opportunity. For my home machines, I have put my foot down -- neither XP nor W2K will ever be used in my home -- they are just too damn invasive. I'm toying with the idea of getting one of those Lindows machines when I need to replace one of my current machines. The only reason I don't go with full Linux is that I have not found a good Linux alternative to Quicken (and I'm either too busy or too lazy to write one 8-) To restate what I said before: You always have a choice. Some people choose to believe that M$ is the ONLY choice. I don't. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 1:39 PM To: Multiple recipients of list ORACLE-L So basically you're saying that those of us using Microsoft products are doing so because we're stupid or lazy to change? -Original Message- Sent: Thursday, August 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L You always have a choice. Sometimes it is difficult to make the right choice. Consider a high school student who is doing poorly -- they can make the easy choice and drop out or they can make the difficult choice and work harder. In the case of M$, the easy choice is to accept whatever M$ does and produces. The difficult choice is to find a viable alternative (and even more difficult is to sell that to management). In the past, M$ bought out or crushed any viable alternative; they have been finding that more difficult lately. Kevin Kennedy First Point Energy Corporation If you take RAC out of Oracle you get OLE! What can this mean? -Original Message- Sent: Thursday, August 29, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Gee, that's a helpful reply! As if we have any choice! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 29, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Stop using MS products if you are seriously worried about viruses. [EMAIL PROTECTED] wrote: Got trigger happy, so I'm resending. -Original Message- Sent: Thursday, August 29, 2002 10:11 AM To: DBA List (E-mail); Fat Dba (E-mail) Hi, I recieved an email today as follows: Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Address of sender to me: NAV for Microsoft Exchange-DDS_MAIL [EMAIL PROTECTED]@SUNGARD Recipient of the infected attachment: Kelly Grigg\Inbox Subject of the message: Happy humour Epiphany One or more attachments were deleted Attachment URL.pif was Deleted for the following reasons: Virus W32.Klez.E@mm was found. Here is the repsonse from my guys: It's sending out from other domains rather sungard.com, eg. diamonddata.com and lazydba.com to you. I attached the description from your first email. It is stating that it's being blocked when it's trying to send to you, in which means it's infected on their end and are being scanned/blocked on it's way out from their systems. Have you contact them about the possible of virus attach on their end. In any case, we were alarmed and run the scan anyway. See what they can find. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San
Re: Creating Scott/Tiger
$ORACLE_HOME/rdbms/admin/utlsampl.sql Jonathan Gennick [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/30/2002 09:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Creating Scott/Tiger I need to create the Scott/Tiger schema in Oracle9i. Does anyone recall off the top of their head just where the script to do this is located? 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). -- 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: Automatic generation of Statspack report ...
EXCELLENT! This is EXACTLY what I was looking for. Thank you very much! Erik -Original Message- Sent: Friday, August 30, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Someone had asked this question ... maybe this will help .. Batch mode report generation To run a report without being prompted, assign values to the and the report name before running spreport. The variables are: begin_snap - specifies the begin Snapshot Id end_snap - specifies the end Snapshot Id report_name - specifies the Report output name e.g. on Unix: SQL connect perfstat/perfstat SQL define begin_snap=1 SQL define end_snap=2 SQL define report_name=batch_run SQL @?/rdbms/admin/spreport spreport will no longer prompt for the above information. 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! -- 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).
Re: SQL*Plus in 10i
How do they expect you to start and stop the database if it goes away? and please don't say OEM... --- Freeman, Robert [EMAIL PROTECTED] wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus in 10i
Nooo!!! On Friday 30 August 2002 09:23, Freeman, Robert wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora-1017 invalid username/password when trying to login as internal
Check init.ora parameter,remote_login_passwordfile should be exclusive. regards, --- Atin Kumar Jain OCP 8i DBA IBM Global Services SO Jamshedpur 0657- 424478,147074 [EMAIL PROTECTED] [EMAIL PROTECTED] --- Bob Metelsky bmetelsky@cps92 To: Multiple recipients of list ORACLE-L .com[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ora-1017 invalid username/password when trying to login as internal 08/30/02 07:38 PM Please respond to ORACLE-L Oracle 8.1.6/WinNT I get ora-1017 invalid username/password when trying to connect as internal. I have recreated password file many times to no avail. Usually this all I have had to do in the past for this error. I have tried all combinations of remote_login_passwordfile. I was getting connected earlier. I had to a shutdown but cannot get server up. Luckily it is a relatively used development server. Any ideas on how to correct? After you create a new password file, stop and restart the sid service via oradim or through nt services This happens here from time to time, not sure why, but the above works bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). DISCLAIMER Information contained and transmitted by this e-mail is confidential and proprietary to Tata Steel Ltd. and is intended for use only by the addressee. If you are not the intended recipient , you are notified that any dissemination or copying of this e-mail is strictly prohibited and you are requested to delete this e-mail immediately and notify the originator. Tata Steel does not enter into any binding agreement with any party by e-mail. Any views expressed by an individual do not necessarily reflect the view of Tata Steel. Tata Steel is not responsible for the consequences of any actions taken on the basis of information provided. While this e-mail has been checked for all known viruses the addressee should also scan for viruses. To know more about Tata Steel please visit www.tatasteel.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ATIN KUMAR JAIN INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: new email address
Ruth, i got it as i've not file 13'd the email acct yet. thanks, joe Ruth Gramolini wrote: Does that mean you didn't get my email about presenting my rman paper? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 7:47 PM the [EMAIL PROTECTED] email addy has evidently been sent on to spam lists, i'm getting way too many. Since I own that domain, i'll be dropping the [EMAIL PROTECTED] and be replacing it with [EMAIL PROTECTED] Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Seconds in Wait
I've been sampling active SQL at a rate of 5 Hz and saving the wait information to a table. Here is one example. SELECT RUNDATE, EVENT, SECONDS_IN_WAIT, STATE, SEQ# FROM STATEMENT_WAIT_INFO WHERE USERNAME = 'ARF' AND ADDRESS = '8992E2C8' AND HASH_VALUE = 3642756738 RUNDATEEVENT SECONDS_IN_WAIT STATE SEQ# -- --- --- -- 29-AUG-2002:22:41:53 SQL*Net message from dblink 3 WAITING 209 29-AUG-2002:22:41:58 SQL*Net message from dblink 8 WAITING 209 29-AUG-2002:22:42:04 SQL*Net message from dblink 25 WAITING 209 29-AUG-2002:22:42:10 SQL*Net message from dblink 30 WAITING 209 29-AUG-2002:22:42:15 SQL*Net message from dblink 35 WAITING 209 29-AUG-2002:22:42:21 SQL*Net message from dblink 39 WAITING 209 29-AUG-2002:22:42:27 SQL*Net message from dblink 42 WAITING 209 29-AUG-2002:22:42:32 SQL*Net message from dblink 47 WAITING 209 29-AUG-2002:22:42:38 SQL*Net message from dblink 52 WAITING 209 29-AUG-2002:22:42:43 SQL*Net message from dblink 57 WAITING 209 29-AUG-2002:22:42:49 SQL*Net message from dblink 62 WAITING 209 29-AUG-2002:22:42:55 SQL*Net message from dblink 64 WAITING 209 29-AUG-2002:22:43:00 SQL*Net message from dblink 69 WAITING 209 29-AUG-2002:22:43:06 SQL*Net message from dblink 86 WAITING 209 29-AUG-2002:22:43:12 SQL*Net message from dblink 91 WAITING 209 29-AUG-2002:22:43:17 SQL*Net message from dblink 96 WAITING 209 --- Note that the state is WAITING so seconds_in_wait should be the Actual Wait time in Seconds. See Oracle Performance Tuning 101 pg 32. Note, also the seq# number. I am intrigued by the jump from 8 seconds to 25 seconds for the seconds_in_wait column where the clock time only advanced six seconds. Also the jump from 69 to 86 seconds of wait_time between 10:43:00 PM and 10:43:06 PM. Interestingly both of these great leaps are 17 seconds, and both occurred just after the system time had changed to the next minute. These could both be coincidences. Any thoughts about what's going on here. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- 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: sql loader control file help
I find that the worst problems I have with SQL*Loader tend to be language related. The same goes with export/import. I wish there were better documentation on the NLS parameters. and yes, it was characterset. What I didn't understand was why when I selected from NLS_DATABASE_PARAMETERS it showed the proper settings yet I couldn't load. NLS_LANG was unset in Unix/ one of these days I might actually learn something about Oracle :) --- Jonathan Gennick [EMAIL PROTECTED] wrote: On Mon, 26 Aug 2002 13:41:50 -0800, Rachel wrote: I am not, by any means, a SQL*Loader expert (Jonathan, I keep meaning to get your book!) Sounds like you've solved this one already, but since you invoked my name (and in vain too, since I was of no help grin), I'll just chime in to say that my best guess is that you are encountering a character set translation issue. Not sure my book would help much with this. I don't recall delving into character sets in the book. I'll have to correct that omission when I do the revision. I will say that I've recently had occasion to delve into Oracle's support of Unicode (for Steven Feuerstein's upcomming PL/SQL, Third Edition). It's incredible how complicated something so seemingly simple (on the surface) can be. 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). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Creating Scott/Tiger
Hi Jonathan I need to create the Scott/Tiger schema in Oracle9i. Does anyone recall off the top of their head just where the script to do this is located? The creation script can usually be found in ${ORACLE_HOME}/sqlplus/demo/demobld.sql Regards Dale -- Need instant schema documentation? Check out the DDL to HTML generator in the free DataBee DBATool. http://www.DataBee.com/dt_home.htm -- 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: SQL*Plus in 10i
Yes, Oracle will sell it as standalone product because it is most useful and most used client software on Oracle. The licence model is 'per session'. :-))) BTW: Anybody's using gqlplus? http://gqlplus.sourceforge.net/ JP On Friday 30 August 2002 18:23, you wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Test - pls Ignore
Re: SQL*Plus in 10i
oradim -startup -sid sid -pfile pfile_path ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: How do they expect you to start and stop the database if it goes away? and please don't say OEM... --- Freeman, Robert [EMAIL PROTECTED] wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: working with datafile 2Gb in HadHat 7.3
Nope. -Original Message- Sent: Thursday, August 29, 2002 7:47 PM To: Multiple recipients of list ORACLE-L If you can't do it in hardware, do it in software. Right? ltiu Ji, Richard wrote: There is no such hardware limitation like that. Those are the OS i.e. software limitations. For instance, the 2gb file size limit is because of the 32 bit OS, actually, to be more specific, it's the 32 bit file system. You can have a 32bit OS kernel, but if your file system supports 64bit, then you can support 2gb files. Same thing for the memory. Richard Ji -Original Message- Sent: Thursday, August 29, 2002 5:59 PM To: Multiple recipients of list ORACLE-L OK. I stand corrected. You do need third party tools though. But I suppose engineers can always hack their way through hardware limitations to make thing work. Like the 4GB memory limit of intels - this is not more since I believe Windows 2K and XP have this feature(in software?) where it can access greater than 4GB memory.. Philip Douglass wrote: Uh... don't think so! -- we're running UnixWare 7 on Intel hardware (Xeons) and large file support is a matter of enabling the largefiles option on the Veritas (VxFS) filesystem. That being said, I only use 2Gig datafiles because it seems foolhardy to me to use 2Gig datafiles unless you have an obvious need for them. And if you do, then test it a lot! And make sure all of your programs support large files too (some versions of tar/cpio/gzip don't) -- Philip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 2:43 PM It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: Ok ltiu, REDHAT 7.3 kernel-2.4.18-10 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 1:18 PM What's HadHat 7.3? A new Linux distro pattered after RedHat 7.3? ltiu Adriano Freire wrote: Gurus, I've some problems with datafiles 2Gb in HadHat 7.3. I'm using datafile type ext3 and when i try create a datafile with 2Gb the database is catching. Anybody have the some problem? any suggestion? Thanks Adriano. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ji, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED]
RE: ora-1017 invalid username/password when trying to login as internal
Just my guess, look at the registry parameter ORA_SID_PWFILE(Sorry my knowledge is limited to NT only) and see if it is pointing to the right file. Try restarting the service. Are you running more than one DB on the same server? by the way, if you find out the exact reason why this is happening do put it in the List. It bugged me too once, not sure exactly how i got rid of it. naveen -Original Message- Sent: Friday, August 30, 2002 11:44 PM To: Multiple recipients of list ORACLE-L internal Check init.ora parameter,remote_login_passwordfile should be exclusive. regards, --- Atin Kumar Jain OCP 8i DBA IBM Global Services SO Jamshedpur 0657- 424478,147074 [EMAIL PROTECTED] [EMAIL PROTECTED] --- Bob Metelsky bmetelsky@cps92 To: Multiple recipients of list ORACLE-L .com[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ora-1017 invalid username/password when trying to login as internal 08/30/02 07:38 PM Please respond to ORACLE-L Oracle 8.1.6/WinNT I get ora-1017 invalid username/password when trying to connect as internal. I have recreated password file many times to no avail. Usually this all I have had to do in the past for this error. I have tried all combinations of remote_login_passwordfile. I was getting connected earlier. I had to a shutdown but cannot get server up. Luckily it is a relatively used development server. Any ideas on how to correct? After you create a new password file, stop and restart the sid service via oradim or through nt services This happens here from time to time, not sure why, but the above works bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). DISCLAIMER Information contained and transmitted by this e-mail is confidential and proprietary to Tata Steel Ltd. and is intended for use only by the addressee. If you are not the intended recipient , you are notified that any dissemination or copying of this e-mail is strictly prohibited and you are requested to delete this e-mail immediately and notify the originator. Tata Steel does not enter into any binding agreement with any party by e-mail. Any views expressed by an individual do not necessarily reflect the view of Tata Steel. Tata Steel is not responsible for the consequences of any actions taken on the basis of information provided. While this e-mail has been checked for all known viruses the addressee should also scan for viruses. To know more about Tata Steel please visit www.tatasteel.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ATIN KUMAR JAIN INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test - pls ignore
RE: SQL*Plus in 10i
We only need to start it. It usually stops itself without human control. That is why we have ora-600 and ora-7445 features implemented in PMON and SMON. As for starting and stopping, let me be innovative: What do you say to call the start/stop program IOR and have database startup performed by ior w and database creation by ior i (i liki init). That would be a new and improved thing, wouldn't it? May be, calling the program sqldba would be even better. Integrating an ncurses version of top sessions monitor and rollback segment monitor would also be an outrageous improvement, don't you think so? -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Friday, August 30, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: SQL*Plus in 10i How do they expect you to start and stop the database if it goes away? and please don't say OEM... --- Freeman, Robert [EMAIL PROTECTED] wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test ignore
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denis Vasconcelos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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*Plus in 10i
What would be the replacement?? -Original Message- Sent: Friday, August 30, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- 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: 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).
accessing user_users via a procedure in SYS
Hi, I am trying to put together a package that uses the AUTHID current_user directive to decide whether to let people kill a session or not, and I ran into a problem. One procedure will run as SYS, but I need to double-check the requester's username to ensure he/she isn't trying to kill their neighbour's session. To do that I build a function that runs with the AUTHID current_user directive and tries to select username from user_users. Hopefully it will be able to pass back the username to the parent proc. When I try to run a procedure that does a select against user_users using that directive, I get an error: PLS-00357: Table,View Or Sequence reference 'USER_USERS' not allowed in this context I found tech note 162489.1, according to that, shouldn't user_users work as well? 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] -- 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: SQL*Plus in 10i
oradim is only a windows thingy. Those of us on real OS's use svrmgrl or sqlplus depending on version. Are you saying that they are going to port oradim to *NIX?? Rodd On Fri, 2002-08-30 at 13:33, ltiu wrote: oradim -startup -sid sid -pfile pfile_path ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: How do they expect you to start and stop the database if it goes away? and please don't say OEM... --- Freeman, Robert [EMAIL PROTECTED] wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Missing Redo Log Files and Control File
Title: Missing Redo Log Files and Control File Hi, We were almost done setting up a new server for the developers when a hard drive crashed. MTBF sure took a hit on that one! We had a replacement drive installed. Fortunately we really only lost a control file and redo logs on that disk and they were multiplexed. Please correct me if I'm wrong, but we should be able to recover by shutting down the database; copying over a good control file and redo log file; and then restarting the database? Thanks, Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145
Re: Table Locks
Thanks Raj. I'll give these a try. -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 8/30/2002 10:08 AM, Jamadagni, Rajendra [EMAIL PROTECTED] wrote: I created following two views for developer's use and so far there have been no complaints .. CREATE OR REPLACE FORCE VIEW SYSTEM.DB$LOCKED_OBJECTS (OBJECT_NAME, SESSION_ID, ORACLE_USERNAME, OS_USER_NAME, SQL_ACTIONS, LOCK_MODE) AS SELECT DO.object_name, lo.SESSION_ID, lo.oracle_username, lo.OS_USER_NAME, DECODE(locked_mode, 1, 'SELECT', 2, 'SELECT FOR UPDATE / LOCK ROW SHARE', 3, 'INSERT/UPDATE/DELETE/LOCK ROW EXCLUSIVE', 4, 'CREATE INDEX/LOCK SHARE', 5, 'LOCK SHARE ROW EXCLUSIVE', 6, 'ALTER TABLE/DROP TABLE/DROP INDEX/TRUNCATE TABLE/LOCK EXCLUSIVE') sql_actions, DECODE(locked_mode, 1, 'NULL', 2, 'SS - SUB SHARE', 3, 'SX - SUB EXCLUSIVE', 4, 'S - SHARE', 5, 'SSX - SHARE/SUB EXCLUSIVE', 6, 'X - EXCLUSIVE') Lock_mode FROM sys.V_$LOCKED_OBJECT lo, DB$OBJECTS DO WHERE DO.object_id = lo.object_id; CREATE PUBLIC SYNONYM DB$LOCKED_OBJECTS FOR SYSTEM.DB$LOCKED_OBJECTS; GRANT SELECT ON SYSTEM.DB$LOCKED_OBJECTS TO PUBLIC; and CREATE OR REPLACE FORCE VIEW SYSTEM.DB$LOCKS (OBJ_OWNER, OBJ_NAME, OBJ_TYPE, OBJ_ROWID, DB_USER, SID, LOCK_TYPE, ROW_WAIT_FILE#, ROW_WAIT_BLOCK#, ROW_WAIT_ROW#) AS SELECT owner obj_owner, object_name obj_name, object_type obj_type, dbms_rowid.rowid_create(1, row_wait_obj#, ROW_WAIT_FILE#, ROW_WAIT_BLOCK#,ROW_WAIT_ROW#) obj_rowid, a.username db_user, a.sid sid, a.TYPE lock_type, a.row_wait_file#, a.row_wait_block#, a.row_wait_row# FROM DB$OBJECTS, (SELECT a.username, a.sid, a.row_wait_obj#, a.ROW_WAIT_FILE#, a.ROW_WAIT_BLOCK#, a.ROW_WAIT_ROW#, b.TYPE FROM sys.V_$SESSION a, sys.V_$LOCK b WHERE a.username IS NOT NULL AND a.row_wait_obj# -1 AND a.sid = b.sid AND b.TYPE IN ('TX','TM') ) a WHERE object_id = a.row_wait_obj#; CREATE PUBLIC SYNONYM DB$LOCKS FOR SYSTEM.DB$LOCKS; GRANT SELECT ON SYSTEM.DB$LOCKS TO PUBLIC; DB$OBJECTs is a snapshot of DBA_OBJECTS, it is too slow to select from DBA_OBJECTS, so I created a snapshot that is refreshed on a daily basis, it works fine for me. Hope this helps some. As others have mentioned, currently locked rows are very difficult to find, what you can find though is the rowid for which a lock is requested. 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: Friday, August 30, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Thanks Rachel. I spent the train ride reading the chapters on Instance Tuning and Dynamic Performance Views hoping to find something, but no such luck. I learned a lot of other useful things though, so it wasn't a waste of time. Jacques, v$locked_object shows the table, but I already knew which table was locked. I was hoping to find the offending SQL statement. Have a great weekend everyone. Regards, -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 8/29/2002 10:43 PM, Rachel Carmichael [EMAIL PROTECTED] wrote: I'm not sure it's possible to find the locking SQL and SID once the session issues other SQL statements. I spent a lot of time a few years back attempting to find it, without success. I got the people at both Platinum Technology and Savant (yes, I'm showing my age here) to try to find it as well, figuring their technical people were better at this sort of thing than I am... no luck. I don't think Oracle stores the statement and who issued it, just the rollback info necessary and the fact that there is a lock. --- Alan Davey [EMAIL PROTECTED] wrote: Hi All, I've noticed some locks on various tables and I'm trying to figure out which DML statements are causing the locks. In this example, the lock isn't being released because the developer forgot to include a commit/rollback. If I look at v$session which is causing the lock and query v$sqlarea with the values in sql_address and prev_sql_addr, I only see select statements that were issued after the DML (in this case a delete). I can query v$sqlarea with the locked table name and find the delete statement, but how do I link this back to the sid that issued it? Also, what if there had been multiple DML statements by this user, how would I know which was the first/last one executed? I'm RTFMing, but so far no luck. Any help would be greatly appreciated. Regards, -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --
Please need some help on imp
Hi All, i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3 times but don't seem able to get the imp to just load the data and not the tables as well. Am running solaris 8 oracle 8.1.7 anything that i might not be seeing would be very much appreciated!! TiA -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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*Plus in 10i
Connected to that, there is a rumor tha M$ will buy Oracle Corp., with Larry Ellison taking the place of Steve Ballmer. -Original Message-From: Rodd Holman [mailto:[EMAIL PROTECTED]]Sent: Friday, August 30, 2002 3:24 PMTo: Multiple recipients of list ORACLE-LSubject: Re: SQL*Plus in 10ioradim is only a windows thingy. Those of us on real OS's use svrmgrl or sqlplus depending on version. Are you saying that they are going to port oradim to *NIX?? Rodd On Fri, 2002-08-30 at 13:33, ltiu wrote: oradim -startup -sid sid -pfile pfile_path ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: How do they expect you to start and stop the database if it goes away? and please don't say OEM... --- "Freeman, Robert" [EMAIL PROTECTED] wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Index hints?
Naveen, If you specify a hint Oracle is forced to use the index. Not 'forced'. Hence the name 'hint'. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Missing Redo Log Files and Control File
Absolutely -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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*Plus in 10i
thats the Stupid WINDOZE way. joe ltiu wrote: oradim -startup -sid sid -pfile pfile_path ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: How do they expect you to start and stop the database if it goes away? and please don't say OEM... --- Freeman, Robert [EMAIL PROTECTED] wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus in 10i
Why not? It's easy to use. It will increase Oracle's market share to the dumb and dumber. ltiu On Friday 30 August 2002 12:24, you wrote: oradim is only a windows thingy. Those of us on real OS's use svrmgrl or sqlplus depending on version. Are you saying that they are going to port oradim to *NIX?? Rodd On Fri, 2002-08-30 at 13:33, ltiu wrote: oradim -startup -sid sid -pfile pfile_path ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: How do they expect you to start and stop the database if it goes away? and please don't say OEM... --- Freeman, Robert [EMAIL PROTECTED] wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --- - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 8.1.6.2 to 8.1.7.3 or 8.1.7.4
My understanding is that 8.1.7.3 is the buggy one. It was supposed to be the terminal 8.1.7 release but it had so many problems they had to come out with 8.1.7.4 -Original Message- Sent: Thursday, August 29, 2002 5:44 PM To: Multiple recipients of list ORACLE-L DBA's I have to upgrade an 8.1.6.2 DB on Solaris this weekend (so much for a three day weekend). Is there any reason not to go to 8.1.7.4??? Is 8.1.7.3 less buggy, etc??? I hope to upgrade this DB to 9.2.0.1 as soon as the app vendor ok's it, thanks to our Oracle friends we can't go direct from 8.1.6.x to 9.2.0.1... ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: SQL*Plus in 10i
Rumor ... They might as well buy SUN along the way (and get rid of Java for good). SUN's market cap is only $13B. MS got $300B. On Friday 30 August 2002 12:44, Gogala, Mladen wrote: Connected to that, there is a rumor tha M$ will buy Oracle Corp., with Larry Ellison taking the place of Steve Ballmer. -Original Message- Sent: Friday, August 30, 2002 3:24 PM To: Multiple recipients of list ORACLE-L oradim is only a windows thingy. Those of us on real OS's use svrmgrl or sqlplus depending on version. Are you saying that they are going to port oradim to *NIX?? Rodd On Fri, 2002-08-30 at 13:33, ltiu wrote: oradim -startup -sid sid -pfile pfile_path ??? They got rid of SVRMGR. ltiu On Friday 30 August 2002 11:08, you wrote: How do they expect you to start and stop the database if it goes away? and please don't say OEM... --- Freeman, Robert [EMAIL PROTECTED] wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Please need some help on imp
Bill, I assume from the way you state this, you already have the tables built and don't want imp to blow up trying to recreate them. Correct? If so, try ignore=y. Also, if the user is changing, are you using fromuser= touser=? Output from your problem might be helpful. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, August 30, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Hi All, i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3 times but don't seem able to get the imp to just load the data and not the tables as well. Am running solaris 8 oracle 8.1.7 anything that i might not be seeing would be very much appreciated!! TiA -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Table Locks
Alan Davey wrote: Thanks Rachel. I spent the train ride reading the chapters on Instance Tuning and Dynamic Performance Views hoping to find something, but no such luck. I learned a lot of other useful things though, so it wasn't a waste of time. Jacques, v$locked_object shows the table, but I already knew which table was locked. I was hoping to find the offending SQL statement. Have a great weekend everyone. Regards, -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 8/29/2002 10:43 PM, Rachel Carmichael [EMAIL PROTECTED] wrote: I'm not sure it's possible to find the locking SQL and SID once the session issues other SQL statements. I spent a lot of time a few years back attempting to find it, without success. I got the people at both Platinum Technology and Savant (yes, I'm showing my age here) to try to find it as well, figuring their technical people were better at this sort of thing than I am... no luck. I don't think Oracle stores the statement and who issued it, just the rollback info necessary and the fact that there is a lock. --- Alan Davey [EMAIL PROTECTED] wrote: Hi All, I've noticed some locks on various tables and I'm trying to figure out which DML statements are causing the locks. In this example, the lock isn't being released because the developer forgot to include a commit/rollback. If I look at v$session which is causing the lock and query v$sqlarea with the values in sql_address and prev_sql_addr, I only see select statements that were issued after the DML (in this case a delete). I can query v$sqlarea with the locked table name and find the delete statement, but how do I link this back to the sid that issued it? Also, what if there had been multiple DML statements by this user, how would I know which was the first/last one executed? I'm RTFMing, but so far no luck. Any help would be greatly appreciated. Regards, -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 I hate to disagree even partially with Rachel, but IMHO if a lock exists, then a cursor *may* still be open somewhere (I insist on 'may' because this is typically untrue with SQL*Plus). In that case, V$OPEN_CURSOR provides the SID and the hash value/address allowing to join with V$SQL_TEXT. There is, also, V$SQL_CURSORS. Unfortunately, this one is, I think, 'private' to a session and making use of CURNO requires a plunge into the X$ tables. If I may suggest something, it is to create an 'after' trigger on the locked table which systematically logs (in an autonomous transaction) the statement which fired it. If I do not err, when a lock occurs then the last logged statement should be the offending one. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Please need some help on imp
Bill Ignore=Y is that what you're looking for? Mike -Original Message- Sent: Friday, August 30, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Hi All, i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3 times but don't seem able to get the imp to just load the data and not the tables as well. Am running solaris 8 oracle 8.1.7 anything that i might not be seeing would be very much appreciated!! TiA -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
RE: ADV OT: Oracle-dba.com domain for sale
just throw it out on ebay for auction Joe! :-) Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Thursday, August 29, 2002 7:48 PM To: Multiple recipients of list ORACLE-L If you're interested, email me for the asking price. Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Please need some help on imp
I assume that the schemas, tables, synonyms, roles, grants, etc already exist and you just want to populate the tables with the data from your other database. In your parm file set IGNORE=Y. This will ignore errors caused by already created objects and just load the data. Type: imp help=y to see all the parameters. HTH Bill Conner bill.conner To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @clarent.comcc: Sent by: rootSubject: Please need some help on imp 08/30/2002 03:44 PM Please respond to ORACLE-L Hi All, i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3 times but don't seem able to get the imp to just load the data and not the tables as well. Am running solaris 8 oracle 8.1.7 anything that i might not be seeing would be very much appreciated!! TiA -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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*Plus in 10i
BTW: Anybody's using gqlplus? Whoa, I've been looking for something like this. Is it any good? -Original Message- Sent: Friday, August 30, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Yes, Oracle will sell it as standalone product because it is most useful and most used client software on Oracle. The licence model is 'per session'. :-))) BTW: Anybody's using gqlplus? http://gqlplus.sourceforge.net/ JP On Friday 30 August 2002 18:23, you wrote: Anyone else hear that SQL*Plus is going away in 10i?? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) The avalanche has begun, It is too late for the pebbles to vote. -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Re: Please need some help on imp
Bill, Where are you trying to load the data to? Do the tables already exist? If so, then use the ignore=y option and it won't complain if the table already exists when it tries to create it, but it will load the data into it. Bill Conner wrote: Hi All, i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3 times but don't seem able to get the imp to just load the data and not the tables as well. Am running solaris 8 oracle 8.1.7 anything that i might not be seeing would be very much appreciated!! TiA -bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Conner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 8.1.6.2 to 8.1.7.3 or 8.1.7.4
Speaking of the recursion, now 8.1.7.4 has some serious problmes, especially on HP-UX 11/64 with OPS. -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Friday, August 30, 2002 3:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: upgrade 8.1.6.2 to 8.1.7.3 or 8.1.7.4 My understanding is that 8.1.7.3 is the buggy one. It was supposed to be the terminal 8.1.7 release but it had so many problems they had to come out with 8.1.7.4 -Original Message- Sent: Thursday, August 29, 2002 5:44 PM To: Multiple recipients of list ORACLE-L DBA's I have to upgrade an 8.1.6.2 DB on Solaris this weekend (so much for a three day weekend). Is there any reason not to go to 8.1.7.4??? Is 8.1.7.3 less buggy, etc??? I hope to upgrade this DB to 9.2.0.1 as soon as the app vendor ok's it, thanks to our Oracle friends we can't go direct from 8.1.6.x to 9.2.0.1... ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).