starting up 8i on Win2000 Problems
Hello, I am new to the Windows Platform. I have a Oracle 8i (8.1.6.0.0) on a Windows 2000 system. My problem is this, when I shutdown the system, using svrmgrl and the command shutdown immediate. The system shuts down as one would expect with no errors. However when I try restarting the instance, also in svrmgrl as I have done thousands of time in UNIX, she refuses. Giving either: cannot open the database EXCLUSIVE OR the initPWD.ora is incorrect or corrupt. I have been forced to bounce this system, were she will startup automatically without a whisper of complaint. Has anyone else experienced this? Does anyone have any idea what has gone wrong? Does anyone have a soulution? Thank You in advance Denham Eva -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data dictionary for function
Hi all, Thank you for your answers dba_source user_source all_source Sinardy -Original Message- [EMAIL PROTECTED] Sent: Friday, 29 June 2001 1:50 PM To: Multiple recipients of list ORACLE-L dba_all_source Regards Sinardy Xing SinardyXing@bcs-aTo: Multiple recipients of list ORACLE-L ch.com.sg[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Data dictionary for function 29-Jun-2001 12:20 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book Hi all, Do you know what data dictionary store information about all user function, store procedure ? Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data dictionary for function
Sorry the below should have read dba/all _source table Ravinder_Bahadur@singapore air.com.sgTo: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Re: Data dictionary for function 29-Jun-2001 01:50 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book dba_all_source Regards Sinardy Xing SinardyXing@bcs-aTo: Multiple recipients of list ORACLE-L ch.com.sg[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Data dictionary for function 29-Jun-2001 12:20 PM Please respond to ORACLE-L Sender Info: No Sender Info found in the address Book Hi all, Do you know what data dictionary store information about all user function, store procedure ? Best Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Visit us at www.singaporeair.com. __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data dictionary for function
jaimin wrote: Hi, DBA_SOURCE is the table which stores information about all procedures and fuctions. SQL desc dba_source NameNull?Type --- OWNER NOT NULL VARCHAR2(30) NAMENOT NULL VARCHAR2(30) TYPE VARCHAR2(12) LINENOT NULL NUMBER TEXT VARCHAR2(4000) Jaimin. I believe that the TABLE that stores source is sys.source$. DBA_, USER_ and ALL_ are views, and have no segments or extents. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: (No Subject)
hi, just do: '' represent ' SQL create table testtb(a varchar(90)); Table created. SQL insert into testtb values('i love oracle''s money'); 1 row created. SQL select * from testtb; A i love oracle's money SQL drop table testtb; Table dropped. - Original Message - From: C.S.Venkata Subramanian [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 29, 2001 1:30 PM Subject: (No Subject) HI Gurus, I want to insert single quotes with my data from my application. Some data will contain quotes and some may not. How can this be achieved? Kindly help TIA Regards C.S.Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). æ¬zǶ¨}ø©ND ±@Bm§ÿðà +iöªrºØhÈZ¢§DMÈZ¢§Éòj(rV +r5ëp¢¹z»âqëçÎwó9ÔPó9ßÎtçT8'è®xæåÂ'µêçzÖqë,üÆ¢)à.+-±:Ã*.®Ç¥}úèØb²f¢)à+-±éÝjq +j)fzËëh.+-êî}«\Ü¢ièµá $ì¥éex(|¸¬´k«¹©Ý{azg¬±¨àØw%¹×)Þríj)â +I@ND º+¶§jg¨~f¢)à+-Ê°j{m¡·«zj/y×ë¢f(ºf²j[(±éݶ³Ü¢i×è®az¸§~æjبX¤z˱Êân)à
RE:
STOP IT !!! -Original Message- Sent: 29 June 2001 05:10 To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: starting up 8i on Win2000 Problems
hi guys! i was wondering if someone knows about some good resources (documentation and examples) for pl/sql web development using the pl/sql htp, htf and owa_* packages. i would also like to ask a simple but interesting licensing question about the use the pl/sql web interface. starting with oracle 8.1.x, oracle ships the apache web server as part of the oracle installation and with the apache web server they also ship the pl/sql mod needed to create dynamic web pages from within pl/sql. on the other side, oracle sells the oracle application server as it's own products offering den same functionality and a lot more. do i need to license the application server or would the regular database (including apache server and pl/sql mod) be ok. thanks do -- 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: Venkata's pc is back in line VIRUS messgaes again
for those of you on UNIX, write a looping shell script, say 1,000 times which does a mailx to his email account. Just a thought, but if I get one more from him (which incidentally should be triggered by this email) then that is what I considering doing. (I have metioned this to the UNIX S.As and they do not have a problem with me doing this). Lee -Original Message- Sent: 28 June 2001 21:51 To: Multiple recipients of list ORACLE-L Why we don't all send it back to him 10x? Also, when you get junk snail mail w/ a prepaid return envelope, just send it back empty. This way the marketers have to pay twice :). [EMAIL PROTECTED] 06/28/01 12:23PM same here. -Original Message- Sent: Thursday, June 28, 2001 11:46 AM To: Multiple recipients of list ORACLE-L I Just received 3 messages from Venlata Apparao that had virus's attached. My mail server deleted the attachment. The mail was sent directly to me and not the ORACLE-L list. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: (No Subject)
Thanks Chao -- On Thu, 28 Jun 2001 23:47:32 chao_ping wrote: hi, just do: '' represent ' SQL create table testtb(a varchar(90)); Table created. SQL insert into testtb values('i love oracle''s money'); 1 row created. SQL select * from testtb; A i love oracle's money SQL drop table testtb; Table dropped. - Original Message - From: C.S.Venkata Subramanian [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 29, 2001 1:30 PM Subject: (No Subject) HI Gurus, I want to insert single quotes with my data from my application. Some data will contain quotes and some may not. How can this be achieved? Kindly help TIA Regards C.S.Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Migrate from Oracle Web 7.3/NT to 8i (AS 9i)/2000
HiI have couple of pages on Oracle web Server included in Oracle 7.3 Server.How can I transfer them to Oracle8 - want to move to Windows 2000 whichdoesn't support 7.3, as far as I know.How do I setup the Web Server - Oracle or Apache? And how to transferhomepages, agents, listener... I have the Application Server 9i. How to migrate old Web server to it? Rok Kodrun Rok Kodrun TIBET pictures: http://tramontana.ijs.si/tibet Kolodvorska 20a 1000 Ljubljana Slovenia tel.:+386 (0)1 2302472 GSM: +386 (0)31 370173 EMail: [EMAIL PROTECTED]IJS: +386 (0)1 4773864 WWW: http://tramontana.ijs.si CHAT: http://tramontana.ijs.si:8000
Influencing commit interval of read-only replication's refresh gr
Hi, does some one know of a way to force the refresh process of a read-only snapshot group to commit at predefined intervals: by table, by n number of rows or any other way? The problem that we are facing is that a refresh group has some rapidly changing tables and the rollback segment is not big enough. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
help
Hi , I have a doubt in pl/sql.I want to insert 5 rows in a table.I want the user to be prompted for entering data 5 times. But this code prompts the user only one time and inserts 5 times.What should i do to achieve my expected behaviour? declare begin for i in 1 .. 5 loop insert into tmpc values(no,name,mark); end loop; end; / DK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DK INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What's lock/unlock mechnism
Hi, To find out more about the locking mechanism you can try the oracle concepts manual Jack Helen rwulfjeq lannyue@yahoo To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Re: What's lock/unlock mechnism [EMAIL PROTECTED] om 28-06-2001 21:40 Please respond to ORACLE-L Thank you very much for your response. But how oracle design let server to handle locks. There are lots of overheads because lots of clients can access server at a same time. If client handles individually, They will release lots of overburden for server. And server just make sure that only owner of lock can unlock CS. Anywhere we can find those information. Thanks. HL [EMAIL PROTECTED] wrote: Hi, All locking is handled by the server, not client Jack Helen rwulfjeq .com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: What's lock/unlock mechnism [EMAIL PROTECTED] om 28-06-2001 00:09 Please respond to ORACLE-L Hi , Oracle database system uses very complicated lock/unlock design for readlock,writelock and row/recordlock etc. Does anyone know lock/unlock is implemented both client like sqlplus and server side or just on server side or just client side. For instance, one user using sqlplus access database to update one record of table XX. So should be sqlplus's responsibility to lock this record based on row level of XX table? or serve! ! ! r is also involved in? Thanks. H. Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.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 onbevoegde derden. Indien bovenstaand e-mail! ! ! bericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the i! ! ! ntegrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this
OAS 4.0.8.2
I am running Oracle 8.1.6. on solaris 2.6 After installing Oracle Application Server I am getting this error on trying to start it owsctl start Please wait while the command is being processed on host unetdb2 ... Starting ORB process... waiting for ORB to be ready... The command completed successfully on host unetdb2. ld.so.1: /opt/var/m1/ows/ows/4.0/bin/oassrv: fatal: relocation error: file /opt/var/m1/ows/ows/4.0/lib//libwrblog.so: symbol naeren128i: referenced symbol not found OWS-08820: Unable to start oassrv process '/opt/var/m1/ows/ows/4.0/bin/oassrv'. Initialization Failure- Exiting OAS... Execute STOP of all the OAS Processes from the OAS Manager TIA -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Invalid packages not being recompiled by Oracle
Hi Paul, I agree completely with you and feel your pain. I have a workaround though, if the changes made to your package does not affect the specification(i.e no new parameters, no new functions/procedures) really, for changes only to the package body, You can do a ALTER PACKAGE package_name COMPILE BODY This does not invalidate the dependent packages. My thinking is that the dependency is on the specification. Try it out. HTH, Niyi - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 11:41 PM Thanks Lisa and others, The dbms_utility.compile_schema will work. It is a bit annoying though as this involves six schemas and hundreds of packages to be recompiled. Fortunatly I do keep control and there are no circular dependencies in the packages. I am sending out an order of dependency among the schemas to the appropriate people. The recursive error seems to have been fixed when I patched to 8.0.5.2.1. Has anyone seen it in 8.1.7? It seems to be only for one package that this happens. It is larger than the rest at 6000 lines and 250 KB Modifying the application to execute again isn't really feasible in this case. There are dozens of packages that refer to this packages. Each one would have to be modified and fully regression tested. As far as standard behavior, Oracle is supposed to (and does in all other cases except for this package) automatically recompile any package flagged as invalid at execution time. It should only raise an error when the package in question can not be recompiled. In this case, the user can 'alter package package_name compile' and all is fixed, provided the 'user' is privileged to do so. Obviously, in production there aren't many who can do this. Any thoughts as to how or what could cause this normal behavior to fail? - Paul -Original Message- Sent: Thursday, June 28, 2001 1:20 PM To: Multiple recipients of list ORACLE-L HI Paul, By chance can you use dbms_utility.compile_Schema after recompiling? Are you using it already? I know it doesn't answer your quesiton but this package is suppossed to follow the dependencies, no matter how odd they are (what you are describing below is pretty weird). HTH Lisa Koivu Database Bored Administrator Ft. Lauderdale, FL, USA -Original Message- Sent: Thursday, June 28, 2001 2:56 PM To: Multiple recipients of list ORACLE-L We have one package A that refers to package B. If package B's body and specification are both recompiled by user 1, package A is correctly marked as invalid. Another user, user 2, then attempts to execute package A and gets the following error stack: -- ORA-04068: existing state of packages has been discarded -- ORA-04061: existing state of package B has been invalidated -- ORA-04065: not executed, altered or dropped package B -- ORA-06508: PL/SQL: could not find program unit being called -- ORA-06512: at B, line n ORA-06512: at line 2 User 2 then issues the statement 'alter package A compile;' It compiles successfully and user 2 can now execute the package. Why does Oracle not automatically recompile package A as it should? Since user 2 was able to recompile the package in its existing state, Oracle should not have failed at doing so. User 2's session instantiation of package A (as well as all of their other instantiated packages) should have been lost when package A was invalidated. I understand that two possible options are: (1) Flush the shared pool after recompiling; and (2) Manually recompile all dependent packages (such as A). The first seems like overkill and will cause performance issues. The second, with many dependencies involved, is not an option. We need to consistently be able to recompile a package that other packages are dependent upon without a user recieving the above error stack in addition to not impacting performance or without having to recompile all the dependent packages. Thanks in advance, - Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Troiano, Paul (CAP, GEFA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
RE: Virus again
Well, I just a got a REAL Virus - Chicken Pox!! Just been to the doctors.. You better hope I can't spread E-Chicken Pox :) -Original Message- Sent: Friday, June 29, 2001 01:41 To: Multiple recipients of list ORACLE-L If I get e-mail from the customer with virus I'll inform him/her about the virus. 99.9% of customers would eliminate the source of the virus. If they refuse to do so I would probably not want to deal with them even as customers. It would not make any impact on the business if I lost 0.1% of my customers and that action would actualy work for me because all good people out there would know I don't challenge my values. It is like going to an unsanitized doctor's office, catching something there and doctor's claiming: 'you didn't get it from my office you got it from one of my patients'. That is what doesn't make scence I can even handle annoying recruter's e-mails but not e-mails with viruses. Noone asks you to block ALL e-mails but when the source of inconvinience has been identified why not to take care of it? Anyway, I am giving up. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 4:56 PM There is definately an association between this list and the person The point remains that such a broad solution makes no sense. If you get an email from a customer and it has a virus, you could say there is definitely an association between our customers and email with viruses. But are you going to stop all email from customers? How about just stopping all email? That would solve the problem. Perhaps the boys in network admin need to work on a more focused solution instead of cutting off a broad source of email. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: lyudah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OCP Discount S36
I don't think it does - it is just the Technet membership code.. -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 10:21 To: Multiple recipients of list ORACLE-L OTN says that you can get an OCT 20% discount on the testw with code S36. However, it doesn't say when this code expires? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OAS 4.0.8.2
Here is th full message owsctl start Please wait while the command is being processed on host unetdb2 ... The ORB process have already been started on host unetdb2. The command is not completed on host unetdb2. ld.so.1: /opt/var/m1/ows/ows/4.0/bin/oassrv: fatal: relocation error: file /opt/var/m1/ows/ows/4.0/lib//libwrblog.so: symbol naeren128i: referenced symbol not found OWS-08820: Unable to start oassrv process '/opt/var/m1/ows/ows/4.0/bin/oassrv'. Initialization Failure- Exiting OAS... Execute STOP of all the OAS Processes from the OAS Manager Saj On Fri, 29 Jun 2001, Sajid Iqbal wrote: I am running Oracle 8.1.6. on solaris 2.6 After installing Oracle Application Server I am getting this error on trying to start it owsctl start Please wait while the command is being processed on host unetdb2 ... Starting ORB process... waiting for ORB to be ready... The command completed successfully on host unetdb2. ld.so.1: /opt/var/m1/ows/ows/4.0/bin/oassrv: fatal: relocation error: file /opt/var/m1/ows/ows/4.0/lib//libwrblog.so: symbol naeren128i: referenced symbol not found OWS-08820: Unable to start oassrv process '/opt/var/m1/ows/ows/4.0/bin/oassrv'. Initialization Failure- Exiting OAS... Execute STOP of all the OAS Processes from the OAS Manager TIA -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Sajid Iqbal Database Team Leader VIA NET.WORKS 620 Birchwood Boulevard Birchwood Warrington WA3 7QZ DDI: +44 (0) 1925 484485 Fax: +44 (0) 1925 484466 Email: [EMAIL PROTECTED] Website: http://www.vianetworks.co.uk local touch global reach -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Invalid packages not being recompiled by Oracle
On Thu, Jun 28, 2001 at 10:56:23AM -0800, Troiano, Paul (CAP, GEFA) wrote: We have one package A that refers to package B. If package B's body and specification are both recompiled by user 1, package A is correctly marked as invalid. Another user, user 2, then attempts to execute package A and gets the following error stack: -- ORA-04068: existing state of packages has been discarded -- ORA-04061: existing state of package B has been invalidated -- ORA-04065: not executed, altered or dropped package B -- ORA-06508: PL/SQL: could not find program unit being called -- ORA-06512: at B, line n ORA-06512: at line 2 User 2 then issues the statement 'alter package A compile;' It compiles successfully and user 2 can now execute the package. Why does Oracle not automatically recompile package A as it should? Since user 2 was able to recompile the package in its existing state, Oracle should not have failed at doing so. User 2's session instantiation of package A (as well as all of their other instantiated packages) should have been lost when package A was invalidated. I understand that two possible options are: (1) Flush the shared pool after recompiling; and (2) Manually recompile all dependent packages (such as A). The first seems like overkill and will cause performance issues. The second, with many dependencies involved, is not an option. We need to consistently be able to recompile a package that other packages are dependent upon without a user recieving the above error stack in addition to not impacting performance or without having to recompile all the dependent packages. Having read the other responses, and thinking odd, I've been doing this for years, I've spotted the source of your confusion: Oracle does automatically recompile package A as it should. ;-) The problem is that package B declares some package variables, and user 2 has already invoked it at some point in their session. So when B is recompiled by user 1, the package variables of user 2 will need to be flushed, and reinitialised. This doesn't happen until they reinvoked A, which then produces the exception that you're discovering. This is really just a warning, to tell you that the variables are being flushed (and at this point the reset happens). If the operation is tried again, it'll succeed. So you could code... PACKAGE A IS BEGIN ... BEGIN B.proc_call; EXCEPTION WHEN STATE_DISCARDED THEN B.proc_call; END; ... END; Tedious though... -- T. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tommy Wareing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PL/SQL
How can I change this pl/sql code. I want this to happen: I have for instance this blank 5 5 blank 55 which means 55 55 (the spaces ar ethe blanks.) and I want it to be like this: 00 How can I change this code to let this happen: vPOSTAL_NO:= lpad(nvl(recCursor.POSTAL_NO,'0'),7,'0'); Thanks to all who canhelp me. Roland Sköldblom -- 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: Invalid packages not being recompiled by Oracle
Paul, From what I remember, if a package has been marked invalid and a user tries to execute it, it DOES get re-compiled at that time, but does not get executed. So the FIRST call to an invalid Package changes it's state to valid. The Second call will actually execute the package. The only other suggestion I have (other than running UTLRP, or dbms_utility.compile_schema) would be to write a short SQL script to look at the ALL_DEPENDENCIES table, looking for all PACKAGES that are dependent on the package you just re-compiled to compile them for you. This would cut down the amount of work you would need to do. Personally, I would test UTLRP to be sure it works for you before I wrote my own script. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, June 28, 2001 5:41 PM To: Multiple recipients of list ORACLE-L Thanks Lisa and others, The dbms_utility.compile_schema will work. It is a bit annoying though as this involves six schemas and hundreds of packages to be recompiled. Fortunatly I do keep control and there are no circular dependencies in the packages. I am sending out an order of dependency among the schemas to the appropriate people. The recursive error seems to have been fixed when I patched to 8.0.5.2.1. Has anyone seen it in 8.1.7? It seems to be only for one package that this happens. It is larger than the rest at 6000 lines and 250 KB Modifying the application to execute again isn't really feasible in this case. There are dozens of packages that refer to this packages. Each one would have to be modified and fully regression tested. As far as standard behavior, Oracle is supposed to (and does in all other cases except for this package) automatically recompile any package flagged as invalid at execution time. It should only raise an error when the package in question can not be recompiled. In this case, the user can 'alter package package_name compile' and all is fixed, provided the 'user' is privileged to do so. Obviously, in production there aren't many who can do this. Any thoughts as to how or what could cause this normal behavior to fail? - Paul -Original Message- Sent: Thursday, June 28, 2001 1:20 PM To: Multiple recipients of list ORACLE-L HI Paul, By chance can you use dbms_utility.compile_Schema after recompiling? Are you using it already? I know it doesn't answer your quesiton but this package is suppossed to follow the dependencies, no matter how odd they are (what you are describing below is pretty weird). HTH Lisa Koivu Database Bored Administrator Ft. Lauderdale, FL, USA -Original Message- Sent: Thursday, June 28, 2001 2:56 PM To: Multiple recipients of list ORACLE-L We have one package A that refers to package B. If package B's body and specification are both recompiled by user 1, package A is correctly marked as invalid. Another user, user 2, then attempts to execute package A and gets the following error stack: -- ORA-04068: existing state of packages has been discarded -- ORA-04061: existing state of package B has been invalidated -- ORA-04065: not executed, altered or dropped package B -- ORA-06508: PL/SQL: could not find program unit being called -- ORA-06512: at B, line n ORA-06512: at line 2 User 2 then issues the statement 'alter package A compile;' It compiles successfully and user 2 can now execute the package. Why does Oracle not automatically recompile package A as it should? Since user 2 was able to recompile the package in its existing state, Oracle should not have failed at doing so. User 2's session instantiation of package A (as well as all of their other instantiated packages) should have been lost when package A was invalidated. I understand that two possible options are: (1) Flush the shared pool after recompiling; and (2) Manually recompile all dependent packages (such as A). The first seems like overkill and will cause performance issues. The second, with many dependencies involved, is not an option. We need to consistently be able to recompile a package that other packages are dependent upon without a user recieving the above error stack in addition to not impacting performance or without having to recompile all the dependent packages. Thanks in advance, - Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Troiano, Paul (CAP, GEFA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of
RE: Oracle DBA with SQL Server and Manufacturing Industry
We have an Alpha server here that we are going to be putting into service next year to run a financial application. Currently the os is OpenVMS and will support an oracle database but not the financials. We will have to change the os to Tru64 to handle the financials. The server is a dual ES40 cluster that is real fast and should serve our needs for quite awile. ROR mª¿ªm [EMAIL PROTECTED] 06/28/01 11:40PM SQL Server or Alpha Server experience Who does Alpha Server?? - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PL/SQL
Roland, Try vPOSTAL_NO := replace(vPOSTAL_NO,' ','0'); lc -Original Message- [EMAIL PROTECTED] Sent: Friday, June 29, 2001 8:30 AM To: Multiple recipients of list ORACLE-L How can I change this pl/sql code. I want this to happen: I have for instance this blank 5 5 blank 55 which means 55 55 (the spaces ar ethe blanks.) and I want it to be like this: 00 How can I change this code to let this happen: vPOSTAL_NO:= lpad(nvl(recCursor.POSTAL_NO,'0'),7,'0'); Thanks to all who canhelp me. Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PL/SQL
vPOSTAL_NO:=lpad(replace(nvl(POSTAL_NO,'0'),' ',''),6,'0'); -Original Message- Sent: 29 June 2001 13:30 To: Multiple recipients of list ORACLE-L How can I change this pl/sql code. I want this to happen: I have for instance this blank 5 5 blank 55 which means 55 55 (the spaces ar ethe blanks.) and I want it to be like this: 00 How can I change this code to let this happen: vPOSTAL_NO:= lpad(nvl(recCursor.POSTAL_NO,'0'),7,'0'); Thanks to all who canhelp me. Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PL/SQL
Roland, try vPOSTAL_NO:= lpad(replace(' 55 55',' ',null),7,'0'); select lpad(replace(' 55 55',' ',null),7,'0') from dual hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, June 29, 2001 8:30 AM To: Multiple recipients of list ORACLE-L How can I change this pl/sql code. I want this to happen: I have for instance this blank 5 5 blank 55 which means 55 55 (the spaces ar ethe blanks.) and I want it to be like this: 00 How can I change this code to let this happen: vPOSTAL_NO:= lpad(nvl(recCursor.POSTAL_NO,'0'),7,'0'); Thanks to all who canhelp me. Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Work around for PL/SQL code
Hi, Let me introduce myself. I am Rangachari Sundar from Chennai India. I have the workaround for the requirement you have posted and here it is vPOSTAL_NO := lpad(replace(trim(recCursor.POSTAL_NO), ' ', ''), 7, '0') ; Trim is not available prior to oracle 8 so if your version is prior to 8 you can change that to LTRIM(RTRIM(recCursor.POSTAL_NO)) Bye Sundar [EMAIL PROTECTED] wrote: How can I change this pl/sql code. I want this to happen: I have for instance this blank 5 5 blank 55 which means 55 55 (the spaces ar ethe blanks.) and I want it to be like this: 00 How can I change this code to let this happen: vPOSTAL_NO:= lpad(nvl(recCursor.POSTAL_NO,'0'),7,'0'); Thanks to all who canhelp me. Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[3]: Pocket Guide
Dick, Would you be interested in reviewing an RMAN pocket ref? I'm currently editing the book, and it should be ready for review in a week or two. If you'd be interested in reading it over, let me know. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Thursday, June 28, 2001, 10:06:30 AM, you wrote: dvc I've become overwhelmed by the number and completeness of a number of Pocket dvc Guides that have recently (in the last 6 months) appeared in my local Borders dvc book store from O'Reilly. The really nice part of the pocket guides is that dvc there is an accompanying desk size book that one can refer to for a much moor dvc detailed explanation. My top favorites are the PL/SQL Language and Oracle dvc Built-ins by Steven Feuerstein company (nothing like PL/SQL from the guru dvc of dvc guru's). And at $8 a piece their a bargain. I've already broken the binder dvc on dvc one of them. dvc Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i Open Day (UK Listers)
I am sure lots of people will want to meet you now that you have annnouced to the list that you have got chicken pox Where is the meet? - Bracknell I assume, and how do you get an invite? John -Original Message- Sent: 29 June 01 13:31 To: Multiple recipients of list ORACLE-L Hi all UK listers, I was just wondering how many people from the UK on here have actually registered for the 9i Open Day? I think it would be a great chance to get together for a quick drink and put faces to Signatures :) Thoughts? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hallas John INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Influencing commit interval of read-only replication's refresh gr
Hi, does some one know of a way to force the refresh process of a read-only snapshot group to commit at predefined intervals: by table, by n number of rows or any other way? The problem that we are facing is that a refresh group has some rapidly changing tables and the rollback segment is not big enough. TIA, Tamas Szecsy -- Tamas, A refresh group is a set of related (through FKs and the like) tables. Not committing before everything has been replicated is the Oracle way to fudge the integrity constraint violation issue (don't forget that they have one log per table, not a single chronological log). Either you begin writing your own refresh functions, or you find a way to split your refresh group into subgroups for which referential integrity would not be a problem, or you increase the rate of refresh. I don't see anytging else. Regards, Stephane Faroult Oriole Corporation - Performance tools for Oracle ® http://www.oriole.com/ -- 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[2]: Pocket Guide
What about O'Reilly's Oracle SQL: The Essential Ref? It's about 370 pages long, covers SQL syntax and a few other things. Has anyone looked at that? Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Thursday, June 28, 2001, 9:05:31 AM, you wrote: RR Kishore Bhamidipati has written a paper back book 337 pages that covers RR the Complete Set of SQL Commands for Oracle, Informix, and Sybase Systems RR plus special coverage of Oracle's latest PL/SQL and SQLJ extensions. I know RR it is not a pocket reference but it is small enough and light enough to carry RR in your linch bag. RR Osborne Press ISBN 0-07-882460-5 RR ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i Open Day (UK Listers)
I'm definitely there and am staying overnight on the Thursday so will be partaking in a fair few beverages Lee -Original Message- Sent: 29 June 2001 13:31 To: Multiple recipients of list ORACLE-L Hi all UK listers, I was just wondering how many people from the UK on here have actually registered for the 9i Open Day? I think it would be a great chance to get together for a quick drink and put faces to Signatures :) Thoughts? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OCP Discount S36
Here is what the web site says: Sign Up For a Test Now Register for Oracle certification testing (mention promotional code S36 to receive your OTN 20% discount) -- There is no mention of an expiration date. Ken I don't think it does - it is just the Technet membership code.. -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 10:21 To: Multiple recipients of list ORACLE-L OTN says that you can get an OCT 20% discount on the testw with code S36. However, it doesn't say when this code expires? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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[2]: What's lock/unlock mechnism
One can influence the locking of data via the lock table command and for update of portions of a SQL cursor. As a general rule of thumb I totally discourage anyone from ever using the lock table command. Certainly the process within the server is complicated as needs be, but it is one of the best I've seen in terms of concurrency and consistency. If your having a problem with clients being able to access data that is locked by another client then the problem is either in their application and/or their use of the application. I've seen problems where a user updated a number of records in SQL*Plus and then decided to go to lunch while the statement completed. A second user then tried to update a different column in a number of the same records only to get locked out. The answer was to have a few words with the first users manager, who BTW was the second user's manager as well. From then on this individual never left a statement just to run by itself the problem has not re-occurred. In general locking issues are VERY infrequently a server side problem though that is where it is implemented. Instead they are almost always a client side issue. Also, there is no way that I can think of for a client to manage their locks without involving the server. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 6/29/2001 2:01 AM Hi, To find out more about the locking mechanism you can try the oracle concepts manual Jack Helen rwulfjeq lannyue@yahoo To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Re: What's lock/unlock mechnism [EMAIL PROTECTED] om 28-06-2001 21:40 Please respond to ORACLE-L Thank you very much for your response. But how oracle design let server to handle locks. There are lots of overheads because lots of clients can access server at a same time. If client handles individually, They will release lots of overburden for server. And server just make sure that only owner of lock can unlock CS. Anywhere we can find those information. Thanks. HL [EMAIL PROTECTED] wrote: Hi, All locking is handled by the server, not client Jack Helen rwulfjeq .com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: What's lock/unlock mechnism [EMAIL PROTECTED] om 28-06-2001 00:09 Please respond to ORACLE-L Hi , Oracle database system uses very complicated lock/unlock design for readlock,writelock and row/recordlock etc. Does anyone know lock/unlock is implemented both client like sqlplus and server side or just on server side or just client side. For instance, one user using sqlplus access database to update one record of table XX. So should be sqlplus's responsibility to lock this record based on row level of XX table? or serve! ! ! r is also involved in? Thanks. H. Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.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,
RE: 9i Open Day (UK Listers)
I recieved the offical invite on my doormat this morning. I was wonderring whether to go and I see that it starts at 13:00+ which means I can still go the work in the morning. If I decide to go then a get-together /drinks would be great. - Mike. -Original Message- Sent: 29 June 2001 13:31 To: Multiple recipients of list ORACLE-L Hi all UK listers, I was just wondering how many people from the UK on here have actually registered for the 9i Open Day? I think it would be a great chance to get together for a quick drink and put faces to Signatures :) Thoughts? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DBA with SQL Server and Manufacturing Industry
Ron, Is Oracle Financials no longer supported on OpenVMS?. 10.7 financials was definitely OK on VMS although not many sites ran it and I thought 11.0 was out for VMS as well. John -Original Message- Sent: 29 June 01 14:06 To: Multiple recipients of list ORACLE-L We have an Alpha server here that we are going to be putting into service next year to run a financial application. Currently the os is OpenVMS and will support an oracle database but not the financials. We will have to change the os to Tru64 to handle the financials. The server is a dual ES40 cluster that is real fast and should serve our needs for quite awile. ROR mª¿ªm [EMAIL PROTECTED] 06/28/01 11:40PM SQL Server or Alpha Server experience Who does Alpha Server?? - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hallas John INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Virus again
I beleive there is definately an association, like the dude is still on the list, set up some stupid VB thing tha takes parts of messages and attaches viruses to them and sends them out That's my guess. KK -Original Message- Sent: Thursday, June 28, 2001 7:56 PM To: Multiple recipients of list ORACLE-L There is definately an association between this list and the person The point remains that such a broad solution makes no sense. If you get an email from a customer and it has a virus, you could say there is definitely an association between our customers and email with viruses. But are you going to stop all email from customers? How about just stopping all email? That would solve the problem. Perhaps the boys in network admin need to work on a more focused solution instead of cutting off a broad source of email. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT RE: 24 x 7 on NT?
Title: OT RE: 24 x 7 on NT? Thanks for the link, I love that story:)) KK -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jacques KilchoerSent: Thursday, June 28, 2001 6:28 PMTo: Multiple recipients of list ORACLE-LSubject: OT RE: 24 x 7 on NT? -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Hahah, the software, the ship had to be towed back to port:) However, not sure if it was the coast guard or the navy, but I am going with the coast guard. Navy ship USS Yorktown. http://www.gcn.com/archives/gcn/1998/july13/cov2.htm This article (in Scientific American) says that the problem may have been caused by 3rd party software, not NT. http://www.sciam.com/1998/1198issue/1198techbus2.html
Re: A Question on the Basics of PL/SQL
On Thursday 28 June 2001 18:01, MacGregor, Ian A. wrote: Here's a line from the package header for dbms_standard: function dictionary_obj_name_list (object_list out ora_name_list_t) return binary_integer; The function returns both a binary integer and a table of varchar2(64)'s. Arghh! That just makes me crazy! We should send the Oracle development team copies of: The Elements of Programming Style Code Complete Writing Solid Code Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: audits
Bill, Auditors are likely folks originally trained as accountants and CPA's. This reminds me of the days when I fixed computers for a living. The bean counters decided that $0.25 per board could be saved in manufacturing by not putting test points on the boards. ( A pin soldered to the board for attaching oscilloscope leads, etc ) Their reality is on another plane. My preference is that it's one headed out of town. Jared On Thursday 28 June 2001 10:36, Thater, William wrote: well, we've just gotten the results of ours. some of the suggestions actually make sense like strong passwords and rotating them more often, but you have to question some of them like having to read mail via ssh on the internal network and banning mail from lists. sometimes you wonder if the auditors are living in the real world.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Search out every place a sick, twisted, solitary misfit might run to. I'll start with radio shack. - Lisa Simpson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SGA QUESTION
200MB? I realize simply adding memory is not the solution for fixing a poorly tuned database, but on the other hand, if you have a lot of memory why not use it? - Greg -- Hi Jared, I think like Greg . Why not use 2-4 gb of 8 gb memory for SGA. ? If It has bad results ,Then How can I understand it? Thank you Greg and Jared and All others. Bunyamin No one said this is a poorly performing system, as it isn't even built yet. Allocating 50% of your memory may be possible, but also may be a bad idea, it really depends on the system, which we know nothing about other than it has 8 gig of memory. If it's a data warehouse, it's probably a bad idea. There's usually a lot of full tables scans and little need for a large data block buffer size or a large shared pool. On a DW though, there is a need for a lot of system memory to satisfy the parallel processes and sort_area_size requirements. If it's OLTP, it really depends on the # of users and the application, as well as considerations such as MTS, etc. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: A Question on the Basics of PL/SQL
Jared Still wrote: On Thursday 28 June 2001 18:01, MacGregor, Ian A. wrote: Here's a line from the package header for dbms_standard: function dictionary_obj_name_list (object_list out ora_name_list_t) return binary_integer; The function returns both a binary integer and a table of varchar2(64)'s. Arghh! That just makes me crazy! We should send the Oracle development team copies of: The Elements of Programming Style Code Complete Writing Solid Code Jared yea, but would they read them?;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ It's not a bug. It's an undocumented feature -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
MetaDink Returns
Maybe because it's Friday? Fri, 29 Jun 2001 14:10:44 GMT ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at SURE.SURE_API, line 1291 ORA-06512: at METALINK.ML2_DOCUMENTS, line 324 ORA-06512: at line 7 DAD name: plsql PROCEDURE : ml2_documents.showNOT USER : toddcarlson URL: http://metalink.oracle.com:80/metalink/plsql/ml2_documents.showNOT?p_id=142058.1%20TARGET p_showHeader=1p_showHelp=0 PARAMETERS : p_id: 142058.1 TARGET= p_showHeader: 1 p_showHelp: 0 ENVIRONMENT: PLSQL_GATEWAY=WebDb GATEWAY_IVERSION=2 SERVER_SOFTWARE=Oracle HTTP Server Powered by Apache/1.3.12 (Unix) ApacheJServ/1.1 mod_perl/1.24 GATEWAY_INTERFACE=CGI/1.1 SERVER_PORT=80 SERVER_NAME=metalink.oracle.com REQUEST_METHOD=GET QUERY_STRING=p_id=142058.1%20TARGET=p_showHeader=1p_showHelp=0 PATH_INFO=/metalink/plsql/ml2_documents.showNOT SCRIPT_NAME=/metalink REMOTE_HOST= REMOTE_ADDR=12.22.137.2 SERVER_PROTOCOL=HTTP/1.1 REQUEST_PROTOCOL=HTTP REMOTE_USER= HTTP_CONTENT_LENGTH= HTTP_CONTENT_TYPE= HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) HTTP_HOST=metalink.oracle.com HTTP_ACCEPT=image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */* HTTP_ACCEPT_ENCODING=gzip, deflate HTTP_ACCEPT_LANGUAGE=en-us HTTP_ACCEPT_CHARSET= HTTP_COOKIE= Authorization=Basic dG9kZGNhcmxzb246dGMxNzgy HTTP_IF_MODIFIED_SINCE= HTTP_REFERER=http://metalink.oracle.com/metalink/plsql/showdoc?db=NOTid=142058.1 TARGET= Todd Carlson Oracle 8i Certified DBA Bunge North America -- 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).
Why are my indexes being ignored?
Hi, I created an index on a table. The table has about 83,000 rows. The index is a simple index on one field, 35 different values of the index. I analyzed the table and I analyzed the index, trying it both with a histogram and without a histogram. No matter how I do it, it does a full table scan. Any ideas why? I know I can use a hint, but it seems to me that it ought to use the index. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
db file sequential reads
Hi all, We have SAP application runing on a machine and Oracle 8.1.6.2 instance on an other, the two machines are connected to a gigabyte network. time response of the requests from SAP to Oracle is very long. We investigated with utlbstat and utlestat and we found that we have too much waits on db file sequential reads (85% of the active waits) No disk I/O problem is detected. Buffer cache hit_ratio = 92.30 % Is it normal to have such amount of waits on db file sequential reads ? SVRMGR select n1.event Event Name, 2 n1.event_count Count, 3 n1.time_waited Total Time, 4 round(n1.time_waited/n1.event_count, 2) Avg Time 5from stats$event n1 6where n1.event_count 0 7order by n1.time_waited desc; Event Name Count Total TimeAvg Time - - - SQL*Net message from client 34369851 161024416 4.69 db file sequential read 18474734 11209083 .61 latch free 1673637 1478560 .88 buffer busy waits 2310599 1318970 .57 log file sync 150741179103 1.19 db file parallel read10358 23297 2.25 Saad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mouloudi, Saad INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Two indexes same columns
If there is a primary key on a table (which inherently builds an index), is it still necessary for performance to build a seperate index on the same columns as those identified in the primary key or is the index generated by the primary key sufficient? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Why are my indexes being ignored?
What is the sql statement that you are executing against this table? Carle, William T (Bill), NLCIO wrote: Hi, I created an index on a table. The table has about 83,000 rows. The index is a simple index on one field, 35 different values of the index. I analyzed the table and I analyzed the index, trying it both with a histogram and without a histogram. No matter how I do it, it does a full table scan. Any ideas why? I know I can use a hint, but it seems to me that it ought to use the index. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are my indexes being ignored?
I'm returning 117 rows. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Friday, June 29, 2001 9:50 AM To: [EMAIL PROTECTED]; Carle, William T (Bill), NLCIO Subject:Re: Why are my indexes being ignored? Carle, William T (Bill), NLCIO wrote: Hi, I created an index on a table. The table has about 83,000 rows. The index is a simple index on one field, 35 different values of the index. I analyzed the table and I analyzed the index, trying it both with a histogram and without a histogram. No matter how I do it, it does a full table scan. Any ideas why? I know I can use a hint, but it seems to me that it ought to use the index. how many rows are you returning? if i remember right, and if i don't i'm sure i'll be reminded;-), if you return more than a certain % of the table it does a full table scan even if there are indexes. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ It's not a bug. It's an undocumented feature -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
advanced replication
I was beginning to think advanced replication looked like a reasonable solution for an applicaiton. Then I read: Replication environments supporting both multimaster and snapshot replication can be challenging to configure and manage. To help administer these replication environments, Oracle provides a sophisticated management tool called Oracle Replication Manager. Coupled with the absence of a config guide, am I to guess that Oracle is underpining it's advanced technology with a toy OS? This would be ironic, pathetic, and unacceptable. Please tell me I've missed the real config guide. === 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).
RE: 9i Open Day (UK Listers)
mais non. Oracle HQ Thames Business Park in Reading. http://www.oracle.com/uk/start/9iopenday Regards Lee -Original Message- Sent: 29 June 2001 14:52 To: Multiple recipients of list ORACLE-L I am sure lots of people will want to meet you now that you have annnouced to the list that you have got chicken pox Where is the meet? - Bracknell I assume, and how do you get an invite? John -Original Message- Sent: 29 June 01 13:31 To: Multiple recipients of list ORACLE-L Hi all UK listers, I was just wondering how many people from the UK on here have actually registered for the 9i Open Day? I think it would be a great chance to get together for a quick drink and put faces to Signatures :) Thoughts? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hallas John INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SAP Interview Questions
We are looking to hire an SAP Systems Analyst. Can anyone suggest some good questions/answers specific to SAP? I have seen lists of Oracle interview questions so I was wondering if anyone has seen any on SAP? Or, if you just know some good questions/answers, please send them to me. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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-12638: Credential retrieval failed URGENT!!!!
Look in C:\oracle\ora81\network\admin\sqlnet.ora for the line SQLNET.AUTHENTICATION_SERVICES= (NTS) This is why Oracle is trying to retrieve user information from the domain. I ran into this when I had a laptop plugged into the network, and I installed Oracle onto it, then tried to access Oracle when disconnected from the network. Off the top of my head, I changed it to NONE and then I was all set. g -Original Message- Sent: Wednesday, June 27, 2001 11:50 PM To: Multiple recipients of list ORACLE-L On Wed, 27 Jun 2001,Helen rwulfjeq scribbled on the wall in glitter crayon: -ORA-12638: Credential retrieval failed - - -BM_28047 - -Cause: The authentication service failed to retrieve the credentials of -a user. - -BM_28048 - -Action: Enable tracing to determine the exact error. did you enable tracing? if so what's the output? - -I would like to guess authentication service has problem since network -config change. We have similar situation before. Change ip address and -keep hostname without any problem are you sure you're accessing by hostname and that the hostname is resolving correctly? -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Kiss your keyboard goodbye! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Two indexes same columns
Connie, When you create the PK constraint, Oracle automatically creates a unique index to enforce it. You should explicitly name the tablespace in which this index is to be created. Otherwise Oracle will just create it in the scema owner's default tablespace - not necessarily a performance enhancer, since that could be the very tablespace in which the table resides. The PK index is all you need on the PK columns, unless you frequently access the table via the 2nd (or 3rd) PK column. Then you could create a UK on the same columns, but in a different order. It all depends on your application's access of the table, as well as the FKs you've defined (you need an index on each FK to reduce table locking - see the docs for more info.). Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Milliken Sent: Friday, June 29, 2001 10:46 AM To: Multiple recipients of list ORACLE-L If there is a primary key on a table (which inherently builds an index), is it still necessary for performance to build a seperate index on the same columns as those identified in the primary key or is the index generated by the primary key sufficient? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Common Oracle RDBMS Misconceptions
Yup, you need Oracle 8i Application Programming by Wrox Press. And I got paid by the page rather than as a percentage of sales, so I can say that with a clear conscience! ;0) g -Original Message- Sent: Tuesday, June 26, 2001 8:27 PM To: Multiple recipients of list ORACLE-L BTW: IMHO, don't waste your money on any of the SAMS books. They are full of similar misconceptions. Are there any you DO recommend? The only one I have is Kevin Loney's Oracle 8 DBA Handbook. Thanks, Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gardner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT::Take a look.
Dick, McCain is what one should think of as a dyslexic Republican. He thinks he's on the right when he's really on the left. ;) [EMAIL PROTECTED] 06/28/01 04:26PM snip Dick Goulet PS: For those of you who feel I'm Republican bashing, I'm not. I'd have VERY happily voted for McCain, even if that meant having Bush as a VP. Now where's that independent counsel when you need him!!! -- 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: starting up 8i on Win2000 Problems
u have to apply patch 8.1.6.3.4 -Original Message- Sent: Friday, June 29, 2001 2:46 AM To: Multiple recipients of list ORACLE-L Hello, I am new to the Windows Platform. I have a Oracle 8i (8.1.6.0.0) on a Windows 2000 system. My problem is this, when I shutdown the system, using svrmgrl and the command shutdown immediate. The system shuts down as one would expect with no errors. However when I try restarting the instance, also in svrmgrl as I have done thousands of time in UNIX, she refuses. Giving either: cannot open the database EXCLUSIVE OR the initPWD.ora is incorrect or corrupt. I have been forced to bounce this system, were she will startup automatically without a whisper of complaint. Has anyone else experienced this? Does anyone have any idea what has gone wrong? Does anyone have a soulution? Thank You in advance Denham Eva -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i Open Day (UK Listers)
LOL - my doctor ensured me that I should be ok within a week or so. If not - then I won't be coming :( You can register on the web @ http://www.oracle.com/uk/start/9iopenday or call 01252 771499 Regards Mark -Original Message- Sent: Friday, June 29, 2001 02:52 To: Multiple recipients of list ORACLE-L I am sure lots of people will want to meet you now that you have annnouced to the list that you have got chicken pox Where is the meet? - Bracknell I assume, and how do you get an invite? John -Original Message- Sent: 29 June 01 13:31 To: Multiple recipients of list ORACLE-L Hi all UK listers, I was just wondering how many people from the UK on here have actually registered for the 9i Open Day? I think it would be a great chance to get together for a quick drink and put faces to Signatures :) Thoughts? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hallas John INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Why are my indexes being ignored?
Carle, William T (Bill), NLCIO wrote: Hi, I created an index on a table. The table has about 83,000 rows. The index is a simple index on one field, 35 different values of the index. I analyzed the table and I analyzed the index, trying it both with a histogram and without a histogram. No matter how I do it, it does a full table scan. Any ideas why? I know I can use a hint, but it seems to me that it ought to use the index. how many rows are you returning? if i remember right, and if i don't i'm sure i'll be reminded;-), if you return more than a certain % of the table it does a full table scan even if there are indexes. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ It's not a bug. It's an undocumented feature -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Two indexes same columns
No, there would be no benefit and it probably wouldn't be allowed anyway unless you reversed the columns in the 2nd index. Regards, Mike Hately. |+--- || Connie | || Milliken | || cemail@sprin| || tmail.com | || | || 06/29/01 | || 04:46 PM | || Please | || respond to | || ORACLE-L | || | |+--- --| | | | To: Multiple recipients of list ORACLE-L | | [EMAIL PROTECTED] | | cc: (bcc: Mike Hately/ETECH) | | Subject: Two indexes same columns | --| If there is a primary key on a table (which inherently builds an index), is it still necessary for performance to build a seperate index on the same columns as those identified in the primary key or is the index generated by the primary key sufficient? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Virus again
S'OK. This list won't let you send it as an attachment. At 03:15 AM 6/29/01 -0800, you wrote: Well, I just a got a REAL Virus - Chicken Pox!! Just been to the doctors.. You better hope I can't spread E-Chicken Pox :) Dennis Taylor Good judgement comes from experience, and experience comes from bad judgement. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Re: Common Oracle RDBMS Misconceptions
Rachel, I love those animations on the last slide!! :0) g -Original Message- Sent: Wednesday, June 27, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Joe, Oops, not that I forgot, I don't think I knew. okay KEVIN!!! :) Will send him a new copy to put up there. Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Setting PCTFREE PCTUSED in a Datawarehouse
I read in the Oracle docs that setting a high PCTUSED ( such as 60/70) would increase the cost of INSERTS to the table. Can someone explain this , pleas e! thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are my indexes being ignored?
index is not selective enough. it would wind up pulling MORE db blocks in using the index than a FTS. hth - Hannibal -Original Message- Sent: Friday, June 29, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Hi, I created an index on a table. The table has about 83,000 rows. The index is a simple index on one field, 35 different values of the index. I analyzed the table and I analyzed the index, trying it both with a histogram and without a histogram. No matter how I do it, it does a full table scan. Any ideas why? I know I can use a hint, but it seems to me that it ought to use the index. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Good Beginner Oracle book recommendations:
Hello, I inherited an oracle database not too long ago, and I've never used Oracle. So far it's running fine and I've been able to wing the startup/shutdown procedures from looking on the net, and most of the time just keeping my fingers crossed. Went to the book store yesterday, there are a lot of Oracle books, but I decided before I go and spend anywhere from $60 - $100, I'd like to know what books you guys would recommend a semi-newbie Oracle DBA. I'm looking for something that I can use as a reference when I need to, and also something I can read in my spare time to better understand Oracle. www.nul.cjb.net www.FreeBSD.org _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Two indexes same columns
I agree, there is no benefit, but it perfectly allowed to create as many indexes on the same columns, as you wish. May be some DBA performance is evaluated based on 'used db space' :) Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 29, 2001 11:57 AM No, there would be no benefit and it probably wouldn't be allowed anyway unless you reversed the columns in the 2nd index. Regards, Mike Hately. |+--- || Connie | || Milliken | || cemail@sprin| || tmail.com | || | || 06/29/01 | || 04:46 PM | || Please | || respond to | || ORACLE-L | || | |+--- --| | | | To: Multiple recipients of list ORACLE-L | | [EMAIL PROTECTED] | | cc: (bcc: Mike Hately/ETECH) | | Subject: Two indexes same columns | --| If there is a primary key on a table (which inherently builds an index), is it still necessary for performance to build a seperate index on the same columns as those identified in the primary key or is the index generated by the primary key sufficient? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: Pocket Guide
Hi Jonathan, We still have HELP facility with 8.1.6.2. See below please... Regards Rafiq Connected to: Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production With the Partitioning option JServer Release 8.1.6.2.0 - Production SQL help create table CREATE TABLE command PURPOSE: To create a table, the basic structure to hold user data, specifying this information: * column definitions * integrity constraints * the table's tablespace * storage characteristics * an optional cluster * data from an arbitrary query SYNTAX: CREATE TABLE [schema.]table ( { column datatype [DEFAULT expr] [column_constraint] ... | table_constraint} [, { column datatype [DEFAULT expr] [column_constraint] ... | table_constraint} ]...) [ [PCTFREE integer] [PCTUSED integer] [INITRANS integer] [MAXTRANS integer] [TABLESPACE tablespace] [STORAGE storage_clause] [ RECOVERABLE | UNRECOVERABLE ] [ PARALLEL ( [ DEGREE { integer | DEFAULT } ] [ INSTANCES { integer | DEFAULT } ] ) | NOPARALLEL ] [ CACHE | NOCACHE ] | [CLUSTER cluster (column [, column]...)] ] [ ENABLE enable_clause | DISABLE disable_clause ] ... [AS subquery] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 28 Jun 2001 15:45:59 -0800 Thursday, June 28, 2001, 4:15:56 PM, you wrote: jb help works for sqlplus, if you installed, but if there is a script for jb building sql command structure, please pass that on. At least 'help jb index' is only showing the sqlplus commands. When 8i was released, the SQL statements were removed from the help. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are my indexes being ignored?
u didn't specify which type of index u have created. but for such low selectivity bitmap index might helps... -Original Message- Sent: Friday, June 29, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Hi, I created an index on a table. The table has about 83,000 rows. The index is a simple index on one field, 35 different values of the index. I analyzed the table and I analyzed the index, trying it both with a histogram and without a histogram. No matter how I do it, it does a full table scan. Any ideas why? I know I can use a hint, but it seems to me that it ought to use the index. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why are my indexes being ignored?
You table doesn't have a degree 1 does it?. I've seen examples where this caused a lot of indexes to be ignored. -Original Message- Sent: 29 June 2001 16:53 To: Multiple recipients of list ORACLE-L I'm returning 117 rows. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Friday, June 29, 2001 9:50 AM To: [EMAIL PROTECTED]; Carle, William T (Bill), NLCIO Subject:Re: Why are my indexes being ignored? Carle, William T (Bill), NLCIO wrote: Hi, I created an index on a table. The table has about 83,000 rows. The index is a simple index on one field, 35 different values of the index. I analyzed the table and I analyzed the index, trying it both with a histogram and without a histogram. No matter how I do it, it does a full table scan. Any ideas why? I know I can use a hint, but it seems to me that it ought to use the index. how many rows are you returning? if i remember right, and if i don't i'm sure i'll be reminded;-), if you return more than a certain % of the table it does a full table scan even if there are indexes. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ It's not a bug. It's an undocumented feature -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: starting up 8i on Win2000 Problems
Yes , It occurs to me too. To overcome this error.Sometimes I need to create my database with REMOTE_LOGIN_PASSWORD _FILE=NONE. Then after creating the DB , change it to exclusive. If the problem does not go away , create a new password file with ORAPWD Then it will be ok. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 29, 2001 9:45 AM Hello, I am new to the Windows Platform. I have a Oracle 8i (8.1.6.0.0) on a Windows 2000 system. My problem is this, when I shutdown the system, using svrmgrl and the command shutdown immediate. The system shuts down as one would expect with no errors. However when I try restarting the instance, also in svrmgrl as I have done thousands of time in UNIX, she refuses. Giving either: cannot open the database EXCLUSIVE OR the initPWD.ora is incorrect or corrupt. I have been forced to bounce this system, were she will startup automatically without a whisper of complaint. Has anyone else experienced this? Does anyone have any idea what has gone wrong? Does anyone have a soulution? Thank You in advance Denham Eva -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Re: Common Oracle RDBMS Misconceptions
thanks I thought it would be a good way to end it on a smile From: Guy Hammond [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Re: Common Oracle RDBMS Misconceptions Date: Fri, 29 Jun 2001 08:11:48 -0800 Rachel, I love those animations on the last slide!! :0) g -Original Message- Sent: Wednesday, June 27, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Joe, Oops, not that I forgot, I don't think I knew. okay KEVIN!!! :) Will send him a new copy to put up there. Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT::Take a look.
Yea, Dick. I guess for real republicans, look at Helms, DeLay, and Rehnquist?? -Original Message- Sent: Friday, June 29, 2001 12:12 PM To: Multiple recipients of list ORACLE-L Dick, McCain is what one should think of as a dyslexic Republican. He thinks he's on the right when he's really on the left. ;) [EMAIL PROTECTED] 06/28/01 04:26PM snip Dick Goulet PS: For those of you who feel I'm Republican bashing, I'm not. I'd have VERY happily voted for McCain, even if that meant having Bush as a VP. Now where's that independent counsel when you need him!!! -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Why this sql is running in parallel ??
Title: Why this sql is running in parallel ?? Hi All, I have a query which is running parallel with degree 4. I don't want this sql to run in parallel. My database is 8.1.6 optimizer_mode = CHOOSE ALL tables are analyzed Tables and index have degree =1 No hint for the parallelism is specified in the query. Then how is its running in parallel. Any ideas ? SELECT T1.* FROM sd.INVOICE_ITEMS_ALL T1,sd.CP_CUSTOMERS T2, sd.ITEM T3 WHERE T1.CUSTOMER_NUMBER = T2.CUSTOMER_NUMBER (+) AND T1.PRODUCT_NUMBER = T3.PRODUCT_NUMBER (+) AND MONTH = 'APR1999' AND BUSINESS_UNIT IN ( 'CYLINDER','BULK','TONNAGE' ) AND T2.CATEGORY_CODE IN ( 'Direct','Equity Distributor - Consolida','Equity Distributor - Non-Conso','Independent Distributor','Tonnage' ) Here is from v$session : Lock USERNAME SID SERIAL# OSUSER PROGRAM MACHINE STATUS wait LOGON_TIME -- - --- -- SD 8 4167 bernard. oracle@IBM-HOU-2 (P002) US-AIRLIQUIDE\10 INACTIVE No 28-JUN-01 juchet WM801B 16:32:37 12 5030 bernard. oracle@IBM-HOU-2 (P003) US-AIRLIQUIDE\10 INACTIVE No 28-JUN-01 juchet WM801B 16:32:37 15 1810 bernard. oracle@IBM-HOU-2 (P001) US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet WM801B 16:32:37 19 74 bernard. C:\Documents and Settings\ US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet bernard.juchet\Desktop WM801B 16:15:41 14 4120 bernard. oracle@IBM-HOU-2 (P000) US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet WM801B 16:32:37 Thanks Brijesh Oracle DBA
RE: Why are my indexes being ignored?
The select statement is: select objid from trafficassignmentpersistent where subclassidentifier = 17; Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Friday, June 29, 2001 10:53 AM To: Multiple recipients of list ORACLE-L Subject:Re: Why are my indexes being ignored? What is the sql statement that you are executing against this table? Carle, William T (Bill), NLCIO wrote: Hi, I created an index on a table. The table has about 83,000 rows. The index is a simple index on one field, 35 different values of the index. I analyzed the table and I analyzed the index, trying it both with a histogram and without a histogram. No matter how I do it, it does a full table scan. Any ideas why? I know I can use a hint, but it seems to me that it ought to use the index. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Off Topic posts hit the limit
Dear list members, Due to the fact that I am once again employed, I find that I no longer have time to read every message on Oracle-L. In fact, I don't have time at the moment to read most of them. So when I go home, and cozy up to the computer for a read of what's going on in Oracle-L, I find that the off topic posts are outnumbering the relevant posts. I'm a defender of having some off topic stuff in this forum, but it's gotten out of hand. Many of the threads have useful information in them, but there are so many off topic posts in the thread that it takes much too long to find the posts that are technically interesting. Please, take if offline if just a few of you are engaging in a side topic that has no relevance to the real subject. It makes it pretty hard for the person that started the thread to find any useful information. Thanks Jared -- 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: 9i Open Day (UK Listers)
Reading or bracknell, may as well be the moon. I've got a living to make. I read the blurb on my invitation and it looked like a barely-scratch-the-surface-sales-job. I've got 9i installed and I can glean the same depth of information from the Oracle web site. Mind you, if I was in the area I might go along for a free sausage roll so if anyone does atend could they mail me one? It would have been nice to have faces to go with names though. Maybe someone can host a rogues' gallery? Thanks, Mike |+--- || Robertson Lee| || - lerobe | || lerobe@acxio| || m.co.uk | || | || 06/29/01 | || 04:46 PM | || Please | || respond to | || ORACLE-L | || | |+--- --| | | | To: Multiple recipients of list ORACLE-L | | [EMAIL PROTECTED] | | cc: (bcc: Mike Hately/ETECH) | | Subject: RE: 9i Open Day (UK Listers) | --| mais non. Oracle HQ Thames Business Park in Reading. http://www.oracle.com/uk/start/9iopenday Regards Lee -Original Message- Sent: 29 June 2001 14:52 To: Multiple recipients of list ORACLE-L I am sure lots of people will want to meet you now that you have annnouced to the list that you have got chicken pox Where is the meet? - Bracknell I assume, and how do you get an invite? John -Original Message- Sent: 29 June 01 13:31 To: Multiple recipients of list ORACLE-L Hi all UK listers, I was just wondering how many people from the UK on here have actually registered for the 9i Open Day? I think it would be a great chance to get together for a quick drink and put faces to Signatures :) Thoughts? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hallas John INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network
RE: OCP Discount S36
No restriction like this. They are advertising it on Oracle Education site.Not applicable in Japan only... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 29 Jun 2001 03:15:57 -0800 I don't think it does - it is just the Technet membership code.. -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 10:21 To: Multiple recipients of list ORACLE-L OTN says that you can get an OCT 20% discount on the testw with code S36. However, it doesn't say when this code expires? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Good Beginner Oracle book recommendations:
Peter wrote: I'm looking for something that I can use as a reference when I need to, and also something I can read in my spare time to better understand Oracle. Oracle DBA101 from Oracle Press. good book, geared to learning ORACLE, used it to train my Jr. DBA, use it myself to look things up. and as a bonus, you can ask questions of one of the author's right here!;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ It's not a bug. It's an undocumented feature -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Install Oracle 9i on SUSE Linux 7.1
Hi, read the chapter 'Non-Interactive Installation and Configuration' in your platform-dependant Oracle9i Installation Guide. BTW Are there any hardcore dba's out there which installing via scp from one to another machine? oli [EMAIL PROTECTED] wrote: So basically I encountered not one single problem. It just took a hell of a time to do the install. I work for a client with more than 200 databases (small, but a lot of big ones), so we need to optimize the install or upgrade. Off course the machines are a whole lot bigger than my portable. -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why this sql is running in parallel ??
Title: Why this sql is running in parallel ?? No, tables are not partitioned -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Friday, June 29, 2001 12:11 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Why this sql is running in parallel ?? interesting.something is off about the query data. are the tables partitioned, by chance? -Original Message-From: Gupta, Brijesh [mailto:[EMAIL PROTECTED]]Sent: Friday, June 29, 2001 12:51 PMTo: Multiple recipients of list ORACLE-LSubject: Why this sql is running in parallel ?? Hi All, I have a query which is running parallel with degree 4. I don't want this sql to run in parallel. My database is 8.1.6 optimizer_mode = CHOOSE ALL tables are analyzed Tables and index have degree =1 No hint for the parallelism is specified in the query. Then how is its running in parallel. Any ideas ? SELECT T1.* FROM sd.INVOICE_ITEMS_ALL T1,sd.CP_CUSTOMERS T2, sd.ITEM T3 WHERE T1.CUSTOMER_NUMBER = T2.CUSTOMER_NUMBER (+) AND T1.PRODUCT_NUMBER = T3.PRODUCT_NUMBER (+) AND MONTH = 'APR1999' AND BUSINESS_UNIT IN ( 'CYLINDER','BULK','TONNAGE' ) AND T2.CATEGORY_CODE IN ( 'Direct','Equity Distributor - Consolida','Equity Distributor - Non-Conso','Independent Distributor','Tonnage' ) Here is from v$session : Lock USERNAME SID SERIAL# OSUSER PROGRAM MACHINE STATUS wait LOGON_TIME -- - --- -- SD 8 4167 bernard. oracle@IBM-HOU-2 (P002) US-AIRLIQUIDE\10 INACTIVE No 28-JUN-01 juchet WM801B 16:32:37 12 5030 bernard. oracle@IBM-HOU-2 (P003) US-AIRLIQUIDE\10 INACTIVE No 28-JUN-01 juchet WM801B 16:32:37 15 1810 bernard. oracle@IBM-HOU-2 (P001) US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet WM801B 16:32:37 19 74 bernard. C:\Documents and Settings\ US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet bernard.juchet\Desktop WM801B 16:15:41 14 4120 bernard. oracle@IBM-HOU-2 (P000) US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet WM801B 16:32:37 Thanks Brijesh Oracle DBA
RE: Good Beginner Oracle book recommendations:
Oracle DBA 101 by Marlene Theriault, Rachel Carmichael, and James Viscusi. That is what I started with and it was a great source. Also, you will notice that some of these authors participate on this list. Peter, May I add 'Oracle Tuning 101 by Gaja Vaidyanatha and Kirti Deshpande' to your list when you progress upward (you will!) after DBA 101. The authors of this book are on this list too. In short, it will set you along the correct path right in the beginning as far as understanding and resolving performance issues as it deals very well with myths and incorrect information All the best! John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Perl and SQL+ and svgmgrl
Greetings members, Can I use commands like the one below in perl or I needs to use the DBI for any database use? I would like to migrate some shell scripts into perl, but I do not see if it would be convenient or feasible... sqlplus / -s EOF comands in here EOF Samples would be great! Thanks. Abraham J. Guerra Oracle DBA American Family Insurance (608) 242-4100 x32026 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guerra, Abraham 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: Delete me
revoke posting from [EMAIL PROTECTED] due to too much testing. joe [EMAIL PROTECTED] 06/29/01 12:45AM Hi,I am changing e-mail addresssorry for the inconvenience Best Regards Sinardy-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Sinardy Xing INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Setting PCTFREE PCTUSED in a Datawarehouse
Title: RE: Setting PCTFREE PCTUSED in a Datawarehouse Hi Vikas, The docs should have discussed the reason why. High pctused can lead to a block going on and off the freelist frequently as deletes/inserts are processed, and also can leave the amount of free space inadequate for a new insert (your avg_rowlen comes into play here). So what you'd end up with is several blocks on the freelist that don't have enough free space for an insert, and every time an insert is processed it goes thorugh the freelist and checks for space in the block. The performance hit comes when too many blocks have to be checked for adequate space. Does that make sense? Now some people on this list have debated that PCTFREE/PCTUSED is so low level and that performance really is not affected that much. Of course Ross was one of those people (amen, my brother) HTH Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA -Original Message- From: Vikas Kawatra [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 11:42 AM To: Multiple recipients of list ORACLE-L Subject: Setting PCTFREE PCTUSED in a Datawarehouse I read in the Oracle docs that setting a high PCTUSED ( such as 60/70) would increase the cost of INSERTS to the table. Can someone explain this , pleas e! thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Pocket Guide
Was this an upgrade from a previous version? Or new install? What script did you run to get the SQL command help. I know where the one for SQL*Plus resides, but it does not contain SQL help. Jon --- Mohammad Rafiq wrote: Hi Jonathan, We still have HELP facility with 8.1.6.2. See below please... Regards Rafiq Connected to: Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production With the Partitioning option JServer Release 8.1.6.2.0 - Production SQL help create table CREATE TABLE command PURPOSE: To create a table, the basic structure to hold user data, specifying this information: * column definitions * integrity constraints * the table's tablespace * storage characteristics * an optional cluster * data from an arbitrary query SYNTAX: CREATE TABLE [schema.]table ( { column datatype [DEFAULT expr] [column_constraint] ... | table_constraint} [, { column datatype [DEFAULT expr] [column_constraint] ... | table_constraint} ]...) [ [PCTFREE integer] [PCTUSED integer] [INITRANS integer] [MAXTRANS integer] [TABLESPACE tablespace] [STORAGE storage_clause] [ RECOVERABLE | UNRECOVERABLE ] [ PARALLEL ( [ DEGREE { integer | DEFAULT } ] [ INSTANCES { integer | DEFAULT } ] ) | NOPARALLEL ] [ CACHE | NOCACHE ] | [CLUSTER cluster (column [, column]...)] ] [ ENABLE enable_clause | DISABLE disable_clause ] ... [AS subquery] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 28 Jun 2001 15:45:59 -0800 Thursday, June 28, 2001, 4:15:56 PM, you wrote: jb help works for sqlplus, if you installed, but if there is a script for jb building sql command structure, please pass that on. At least 'help jb index' is only showing the sqlplus commands. When 8i was released, the SQL statements were removed from the help. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: jon baker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: OT::Take a look.
OH, damn. Jared Bruce forgive me and I will keep it civil. As far as republicans and democrats go I'm neither (registered as an independent). Politicians are all dirty, there isn't a one that does not have a significant skeleton in the closet waiting to bash them. I'm also in favor of term limits with MR Helms being the first to go. Now could we drop this thread??? Dick Goulet Reply Separator Author: Mohan; Ross [EMAIL PROTECTED] Date: 6/29/2001 8:30 AM Yea, Dick. I guess for real republicans, look at Helms, DeLay, and Rehnquist?? -Original Message- Sent: Friday, June 29, 2001 12:12 PM To: Multiple recipients of list ORACLE-L Dick, McCain is what one should think of as a dyslexic Republican. He thinks he's on the right when he's really on the left. ;) [EMAIL PROTECTED] 06/28/01 04:26PM snip Dick Goulet PS: For those of you who feel I'm Republican bashing, I'm not. I'd have VERY happily voted for McCain, even if that meant having Bush as a VP. Now where's that independent counsel when you need him!!! -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 question
I want to get every date between two user entered date's whether or not it exists in the table and then the quantity of data for the date if any exists. My table t1 has date and quantity values (may be more than one quantity field per date) and I want 0 for all dates in the range where no data exists. Is there a sql to get this without making some kind of date table? so if the user enters 03/02/01 and 03/06/01 they get. 03/02/0110 03/03/011 03/04/010 03/05/010 03/06/018 They want to load into a spreadsheet. tia. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why this sql is running in parallel ??
Title: Why this sql is running in parallel ?? Whoops, I sent my earlier message too fast. You've already checked the degree on table and index. Hmmm... Puzzling... I'm curious to see the answer if you ever get one. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Give me an hour alone in a bank Pay all my tickets, wipe the slate blank Give me a car, fill up the tank Tell me a boat full of lawyers just sank - Robert Cray -Original Message-From: Gupta, Brijesh [mailto:[EMAIL PROTECTED]]Sent: Friday, June 29, 2001 12:51 PMTo: Multiple recipients of list ORACLE-LSubject: Why this sql is running in parallel ?? Hi All, I have a query which is running parallel with degree 4. I don't want this sql to run in parallel. My database is 8.1.6 optimizer_mode = CHOOSE ALL tables are analyzed Tables and index have degree =1 No hint for the parallelism is specified in the query. Then how is its running in parallel. Any ideas ? SELECT T1.* FROM sd.INVOICE_ITEMS_ALL T1,sd.CP_CUSTOMERS T2, sd.ITEM T3 WHERE T1.CUSTOMER_NUMBER = T2.CUSTOMER_NUMBER (+) AND T1.PRODUCT_NUMBER = T3.PRODUCT_NUMBER (+) AND MONTH = 'APR1999' AND BUSINESS_UNIT IN ( 'CYLINDER','BULK','TONNAGE' ) AND T2.CATEGORY_CODE IN ( 'Direct','Equity Distributor - Consolida','Equity Distributor - Non-Conso','Independent Distributor','Tonnage' ) Here is from v$session : Lock USERNAME SID SERIAL# OSUSER PROGRAM MACHINE STATUS wait LOGON_TIME -- - --- -- SD 8 4167 bernard. oracle@IBM-HOU-2 (P002) US-AIRLIQUIDE\10 INACTIVE No 28-JUN-01 juchet WM801B 16:32:37 12 5030 bernard. oracle@IBM-HOU-2 (P003) US-AIRLIQUIDE\10 INACTIVE No 28-JUN-01 juchet WM801B 16:32:37 15 1810 bernard. oracle@IBM-HOU-2 (P001) US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet WM801B 16:32:37 19 74 bernard. C:\Documents and Settings\ US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet bernard.juchet\Desktop WM801B 16:15:41 14 4120 bernard. oracle@IBM-HOU-2 (P000) US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet WM801B 16:32:37 Thanks Brijesh Oracle DBA
RE: Why this sql is running in parallel ??
What does v$pq_sysstat show? What does v$pq_sesstat show? (If session is still connected). - Kirti -Original Message- From: Gupta, Brijesh [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 1:01 PM To: Multiple recipients of list ORACLE-L Subject: RE: Why this sql is running in parallel ?? No, tables are not partitioned -Original Message- From: Mohan, Ross [mailto:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 12:11 PM To: Multiple recipients of list ORACLE-L Subject: RE: Why this sql is running in parallel ?? interesting.something is off about the query data. are the tables partitioned, by chance? -Original Message- From: Gupta, Brijesh [mailto:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Subject: Why this sql is running in parallel ?? Hi All, I have a query which is running parallel with degree 4. I don't want this sql to run in parallel. My database is 8.1.6 optimizer_mode = CHOOSE ALL tables are analyzed Tables and index have degree =1 No hint for the parallelism is specified in the query. Then how is its running in parallel. Any ideas ? SELECT T1.* FROM sd.INVOICE_ITEMS_ALL T1,sd.CP_CUSTOMERS T2, sd.ITEM T3 WHERE T1.CUSTOMER_NUMBER = T2.CUSTOMER_NUMBER (+) AND T1.PRODUCT_NUMBER = T3.PRODUCT_NUMBER (+) AND MONTH = 'APR1999' AND BUSINESS_UNIT IN ( 'CYLINDER','BULK','TONNAGE' ) AND T2.CATEGORY_CODE IN ( 'Direct','Equity Distributor - Consolida','Equity Distributor - Non-Conso','Independent Distributor','Tonnage' ) Here is from v$session : Lock USERNAME SID SERIAL# OSUSER PROGRAM MACHINE STATUS wait LOGON_TIME -- - --- -- SD 84167 bernard. oracle@IBM-HOU-2 (P002) US-AIRLIQUIDE\10 INACTIVE No 28-JUN-01 juchet WM801B 16:32:37 125030 bernard. oracle@IBM-HOU-2 (P003) US-AIRLIQUIDE\10 INACTIVE No 28-JUN-01 juchet WM801B 16:32:37 151810 bernard. oracle@IBM-HOU-2 (P001) US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet WM801B 16:32:37 19 74 bernard. C:\Documents and Settings\ US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet bernard.juchet\Desktop WM801B 16:15:41 144120 bernard. oracle@IBM-HOU-2 (P000) US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet WM801B 16:32:37 Thanks Brijesh Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why this sql is running in parallel ??
Title: Why this sql is running in parallel ?? select from parameters where is_session_adjusted is TRUE. is there anything? -Original Message-From: Gupta, Brijesh [mailto:[EMAIL PROTECTED]]Sent: Friday, June 29, 2001 12:51 PMTo: Multiple recipients of list ORACLE-LSubject: Why this sql is running in parallel ?? Hi All, I have a query which is running parallel with degree 4. I don't want this sql to run in parallel. My database is 8.1.6 optimizer_mode = CHOOSE ALL tables are analyzed Tables and index have degree =1 No hint for the parallelism is specified in the query. Then how is its running in parallel. Any ideas ? SELECT T1.* FROM sd.INVOICE_ITEMS_ALL T1,sd.CP_CUSTOMERS T2, sd.ITEM T3 WHERE T1.CUSTOMER_NUMBER = T2.CUSTOMER_NUMBER (+) AND T1.PRODUCT_NUMBER = T3.PRODUCT_NUMBER (+) AND MONTH = 'APR1999' AND BUSINESS_UNIT IN ( 'CYLINDER','BULK','TONNAGE' ) AND T2.CATEGORY_CODE IN ( 'Direct','Equity Distributor - Consolida','Equity Distributor - Non-Conso','Independent Distributor','Tonnage' ) Here is from v$session : Lock USERNAME SID SERIAL# OSUSER PROGRAM MACHINE STATUS wait LOGON_TIME -- - --- -- SD 8 4167 bernard. oracle@IBM-HOU-2 (P002) US-AIRLIQUIDE\10 INACTIVE No 28-JUN-01 juchet WM801B 16:32:37 12 5030 bernard. oracle@IBM-HOU-2 (P003) US-AIRLIQUIDE\10 INACTIVE No 28-JUN-01 juchet WM801B 16:32:37 15 1810 bernard. oracle@IBM-HOU-2 (P001) US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet WM801B 16:32:37 19 74 bernard. C:\Documents and Settings\ US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet bernard.juchet\Desktop WM801B 16:15:41 14 4120 bernard. oracle@IBM-HOU-2 (P000) US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet WM801B 16:32:37 Thanks Brijesh Oracle DBA
RE: Pocket Guide
Jon, just fooling around, I came up with this. run it thru sqlplus. obviously, change the table reference to your table. set serveroutput on spool results.xls DECLARE l_date DATE; start_date DATE := to_date('s_date','mm/dd/'); end_Date DATE := to_date('e_Date','mm/dd/'); loc_sum number; BEGIN l_date := start_date; LOOP SELECT SUM(col1) INTO loc_sum FROM TOM3 WHERE crdate = l_date; dbms_output.put_line(TO_CHAR(l_date,'mm/dd/') || CHR(9) || nvl(loc_sum,0)); l_date := l_date + 1; EXIT WHEN l_date end_date; END LOOP; END; / hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, June 29, 2001 2:26 PM To: Multiple recipients of list ORACLE-L Was this an upgrade from a previous version? Or new install? What script did you run to get the SQL command help. I know where the one for SQL*Plus resides, but it does not contain SQL help. Jon --- Mohammad Rafiq wrote: Hi Jonathan, We still have HELP facility with 8.1.6.2. See below please... Regards Rafiq Connected to: Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production With the Partitioning option JServer Release 8.1.6.2.0 - Production SQL help create table CREATE TABLE command PURPOSE: To create a table, the basic structure to hold user data, specifying this information: * column definitions * integrity constraints * the table's tablespace * storage characteristics * an optional cluster * data from an arbitrary query SYNTAX: CREATE TABLE [schema.]table ( { column datatype [DEFAULT expr] [column_constraint] ... | table_constraint} [, { column datatype [DEFAULT expr] [column_constraint] ... | table_constraint} ]...) [ [PCTFREE integer] [PCTUSED integer] [INITRANS integer] [MAXTRANS integer] [TABLESPACE tablespace] [STORAGE storage_clause] [ RECOVERABLE | UNRECOVERABLE ] [ PARALLEL ( [ DEGREE { integer | DEFAULT } ] [ INSTANCES { integer | DEFAULT } ] ) | NOPARALLEL ] [ CACHE | NOCACHE ] | [CLUSTER cluster (column [, column]...)] ] [ ENABLE enable_clause | DISABLE disable_clause ] ... [AS subquery] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 28 Jun 2001 15:45:59 -0800 Thursday, June 28, 2001, 4:15:56 PM, you wrote: jb help works for sqlplus, if you installed, but if there is a script for jb building sql command structure, please pass that on. At least 'help jb index' is only showing the sqlplus commands. When 8i was released, the SQL statements were removed from the help. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: jon baker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sql question
Title: RE: Sql question John, I see two options. Both include a cross reference table with every date in it. 1. Outer join the dates table with the data table and nvl after the sum to replace nulls with 0's. Or 2. Simply union-all your query as it stands right now with SELECT DATE_FIELD, 0 FROM DATES_TABLE and summarize over that dataset. I think the union all (option #2) will be faster. HTH Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA -Original Message- From: Shaw, John B [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 2:37 PM To: Multiple recipients of list ORACLE-L Subject: Sql question I want to get every date between two user entered date's whether or not it exists in the table and then the quantity of data for the date if any exists. My table t1 has date and quantity values (may be more than one quantity field per date) and I want 0 for all dates in the range where no data exists. Is there a sql to get this without making some kind of date table? so if the user enters 03/02/01 and 03/06/01 they get. 03/02/01 10 03/03/01 1 03/04/01 0 03/05/01 0 03/06/01 8 They want to load into a spreadsheet. tia. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why this sql is running in parallel ??
Title: Why this sql is running in parallel ?? Have you checked the column DEGREE in DBA_TABLES for this table? R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Give me an hour alone in a bank Pay all my tickets, wipe the slate blank Give me a car, fill up the tank Tell me a boat full of lawyers just sank - Robert Cray -Original Message-From: Gupta, Brijesh [mailto:[EMAIL PROTECTED]]Sent: Friday, June 29, 2001 12:51 PMTo: Multiple recipients of list ORACLE-LSubject: Why this sql is running in parallel ?? Hi All, I have a query which is running parallel with degree 4. I don't want this sql to run in parallel. My database is 8.1.6 optimizer_mode = CHOOSE ALL tables are analyzed Tables and index have degree =1 No hint for the parallelism is specified in the query. Then how is its running in parallel. Any ideas ? SELECT T1.* FROM sd.INVOICE_ITEMS_ALL T1,sd.CP_CUSTOMERS T2, sd.ITEM T3 WHERE T1.CUSTOMER_NUMBER = T2.CUSTOMER_NUMBER (+) AND T1.PRODUCT_NUMBER = T3.PRODUCT_NUMBER (+) AND MONTH = 'APR1999' AND BUSINESS_UNIT IN ( 'CYLINDER','BULK','TONNAGE' ) AND T2.CATEGORY_CODE IN ( 'Direct','Equity Distributor - Consolida','Equity Distributor - Non-Conso','Independent Distributor','Tonnage' ) Here is from v$session : Lock USERNAME SID SERIAL# OSUSER PROGRAM MACHINE STATUS wait LOGON_TIME -- - --- -- SD 8 4167 bernard. oracle@IBM-HOU-2 (P002) US-AIRLIQUIDE\10 INACTIVE No 28-JUN-01 juchet WM801B 16:32:37 12 5030 bernard. oracle@IBM-HOU-2 (P003) US-AIRLIQUIDE\10 INACTIVE No 28-JUN-01 juchet WM801B 16:32:37 15 1810 bernard. oracle@IBM-HOU-2 (P001) US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet WM801B 16:32:37 19 74 bernard. C:\Documents and Settings\ US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet bernard.juchet\Desktop WM801B 16:15:41 14 4120 bernard. oracle@IBM-HOU-2 (P000) US-AIRLIQUIDE\10 ACTIVE No 28-JUN-01 juchet WM801B 16:32:37 Thanks Brijesh Oracle DBA
Re: OT::Take a look.
[EMAIL PROTECTED] wrote: OH, damn. Jared Bruce forgive me and I will keep it civil. As far as republicans and democrats go I'm neither (registered as an independent). Politicians are all dirty, there isn't a one that does not have a significant skeleton in the closet waiting to bash them. I'm also in favor of term limits with MR Helms being the first to go. Now could we drop this thread??? Dick Goulet oh where's your sense of adventure?;-) but you're right, this should be taken off list if it's to continue. FWIW, i'm registered as non-aligned since we do have an independent party here in NY.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ It's not a bug. It's an undocumented feature -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Good Beginner Oracle book recommendations:
John, Thank you for the endorsement. BTW, John also contributed to the book, and was a technical reviewer as well !! Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: John Kanagaraj [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 1:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: Good Beginner Oracle book recommendations: Oracle DBA 101 by Marlene Theriault, Rachel Carmichael, and James Viscusi. That is what I started with and it was a great source. Also, you will notice that some of these authors participate on this list. Peter, May I add 'Oracle Tuning 101 by Gaja Vaidyanatha and Kirti Deshpande' to your list when you progress upward (you will!) after DBA 101. The authors of this book are on this list too. In short, it will set you along the correct path right in the beginning as far as understanding and resolving performance issues as it deals very well with myths and incorrect information All the best! John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sql question
John, just fooling around, I came up with this. run it thru sqlplus. obviously, change the table reference to your table. set serveroutput on spool results.xls DECLARE l_date DATE; start_date DATE := to_date('s_date','mm/dd/'); end_Date DATE := to_date('e_Date','mm/dd/'); loc_sum number; BEGIN l_date := start_date; LOOP SELECT SUM(col1) INTO loc_sum FROM TOM3 WHERE crdate = l_date; dbms_output.put_line(TO_CHAR(l_date,'mm/dd/') || CHR(9) || nvl(loc_sum,0)); l_date := l_date + 1; EXIT WHEN l_date end_date; END LOOP; END; / hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, June 29, 2001 2:37 PM To: Multiple recipients of list ORACLE-L I want to get every date between two user entered date's whether or not it exists in the table and then the quantity of data for the date if any exists. My table t1 has date and quantity values (may be more than one quantity field per date) and I want 0 for all dates in the range where no data exists. Is there a sql to get this without making some kind of date table? so if the user enters 03/02/01 and 03/06/01 they get. 03/02/0110 03/03/011 03/04/010 03/05/010 03/06/018 They want to load into a spreadsheet. tia. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sql question
John, It's a pretty common practice to create a dates table. Comes in handy in many ways, one of which you've just encountered. Sorry that wasn't the answer you wanted. Have a great weekend anyway :-). Yosi -Original Message- From: Shaw, John B [mailto:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 2:37 PM To: Multiple recipients of list ORACLE-L Subject: Sql question I want to get every date between two user entered date's whether or not it exists in the table and then the quantity of data for the date if any exists. My table t1 has date and quantity values (may be more than one quantity field per date) and I want 0 for all dates in the range where no data exists. Is there a sql to get this without making some kind of date table? so if the user enters 03/02/01 and 03/06/01 they get. 03/02/01 10 03/03/01 1 03/04/01 0 03/05/01 0 03/06/01 8 They want to load into a spreadsheet. tia. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Good Beginner Oracle book recommendations:
A hearty second to both these books (though the Tuning Book is definitely something to look at later). DBA 101 is perfect for where you are now. I've finally gotten my copy of Tuning 101 and am breaking the spine to have it open on my desk. I snatch the opportunity to read pages in between phone calls and e-mails. Once things calm down (ha!) I intend to implement a thorough performance review of all our Oracle databases using that book. I'm really looking forward to it (in fact, the prospect of being able to do it is one of the few things keeping me here at the moment). Jay Miller -Original Message- Sent: Friday, June 29, 2001 2:15 PM To: Multiple recipients of list ORACLE-L Oracle DBA 101 by Marlene Theriault, Rachel Carmichael, and James Viscusi. That is what I started with and it was a great source. Also, you will notice that some of these authors participate on this list. Peter, May I add 'Oracle Tuning 101 by Gaja Vaidyanatha and Kirti Deshpande' to your list when you progress upward (you will!) after DBA 101. The authors of this book are on this list too. In short, it will set you along the correct path right in the beginning as far as understanding and resolving performance issues as it deals very well with myths and incorrect information All the best! John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Griping about auditing (not the Oracle Kind)
As you might have gathered from my previous e-mail I'm not a big fan of functional division as opposed to project division. Since I was moved to a different building from the developers much of the time I don't spend dealing with the new paperwork and bureaucracy I spend on the phone. I can see the temptation that people have to just say, 'don't think about working *with* the developers, just put their stuff into production and send it back if it doesn't compile' (this is my current job description), but I'm still holding onto doing some review, helping them with SQL, recommending hints, etc. Don't know how much longer I'll be able to keep doing it (though the appreciation and thanks from the developers helps a lot). My impression (this is confirmed by a friend who was a product manager at his company and is now leading a consulting team) is that this is the latest management fad. According to my friend this goes in waves, with everyone moving to functional division, then project division, then back again. He's been through a few shifts back and forth in his time. This is my first one. Jay Miller -Original Message- Sent: Thursday, June 28, 2001 7:52 PM To: Multiple recipients of list ORACLE-L On June 28, 2001 11:51 am, Miller, Jay wrote: Yep, I've dealt with incredibly incompetent consultants (Because of our new division of responsibilties, all programming must come from the development team. I This brings up an interesting point - I've noticed that recently division of responsibilities is increasing and becoming more polarized. For example, in past incarnations, I was the dba, unix sysadmin, configuration manager, and responsible for software licenses for all software in the plant (in addition to whatever else the boss needed at that exact moment in time... :). Lately, however, I have started working on another project (in addition to my usual stuff) that has the sysadmin, development, System dba, and Application dba responsibilities spread across different group. Sysdba is handled by an Infernal Beuracratic Monster, sysadmin by somewhat Ejectable Data Sources, and Application dba stuff handled by we keaners. Very strange to have development arrive, review it for application impact, then send off any physical database change requests to another group. I don't seem any valid reason to stratify the various responsibilities in this manner as it only seems to add several more layers of beauracracy without adding any addition value. So, a) am I alone, or have others seen this sort of stratification, and b) is my griping simply the loss of turf and the slowly broiling coup to get it back, or is it somewhat valid? Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Procedural Replication
David Turner wrote: I have heard numbers of about 100-800 transactions per minute as the limit for Oracle replication, but does anyone know if this would include procedural replication. If so does anyone out there know of some better solutions for replicationg a really high number of transactions across a WAN. Thanks, Dave Turner -- Dave, I know an investment bank which for the past years has been using an in-house, trigger-based, almost real-time (a change in London or Paris is usually replicated in Tokyo within 4-5 seconds) WAN replication between 10 machines in the Europe-centered network and I think 12 in the Asia centered-network (I say 'centered' because Singapore, New-York, Tokyo and London are in both loops, although different machines and databases are involved). I don't know exactly the peak transfer rate, because it works by bursts, but I can tell you that around market closure there is a lot of traffic. And yet there is ample scope for improvement in their system. Unless you are after an off-the-shelf solution, e-mail me off-list if you want details. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- 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: A Question on the Basics of PL/SQL
MacGregor, Ian A. wrote: Functions are used when when a value must be returned. The quotes are around value because the return type is not necessarily scalar. Under most circumstances a function only returns one value. I believe in sticking to that rule, although Oracle does not always: Here's a line from the package header for dbms_standard: function dictionary_obj_name_list (object_list out ora_name_list_t) return binary_integer; The function returns both a binary integer and a table of varchar2(64)'s. Ian, You might see this in a kinder light if you consider that the 'return value' is not a return value proper but a status (which probably happens to be the number of items in the list). It must have been coded by an unreformed C developer (C knows no procedure, remember, only 'void' functions). -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- 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).
BIG PROBLEM
Hello all, I just joined this list today and am in need of desperate help!!! In its infinite wisdom HR decided to lay off our only oracle dba!!! I am trying to get some backups working on our database using rman. It seems to backup our datafiles ok, but I am getting the following error ... RMAN-03022: compiling command: backup RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure during compilation of command RMAN-03013: command type: backup RMAN-06089: archived log /oradata/bdw/disk01/archive/bdw_1_24445.arc not found or out of sync with catalog The problem here is twofold: 1) It is looking in the wrong directory for the archive logs 2) We have been moving old archive logs off of the server to another server to keep the disk from filling up while we were working on this backup problem, so I do not want it looking for the old logs. As I am not a DBA I have no clue how to fix this, but it needs to be done A.S.A.P. ... Thanks to anyone who can help me!!! -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. winmail.dat