pls-00123 - Program too Large
We have a tool (an own-made pl/sql code generator) whose purpose is to generate a PL/SQL Package containing one pls function for each Table/View that has been configured in a specific repository table. Depending on the number of table/view configured the package dimension grows. Compiling one of those automatically generated packages we got the following error PLS-00123 - Program too Large. Obviously one of the possible solution to the the problem is to modularize, but depending of the fact that the package code is automatically generated this could not work. Could someone give us a more detailed explanation on why this error occurs and eventually a possible solution. I've read somethings about an existing correlation between Oracle Block_size and PL/SQL block size - has anyone more detailed information about this? Is it possible to determine in a unique way the max dimension a pl/sql package can have? Thanks in advance Imma 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: Imma C. Rocco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Naming Standards - Thoughts Needed
You can find a little bit how it is in our organization http://www.itsystems.lv/gints/eng/naming_conventions.htm Gints Plivna Tracy Rahmlow To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Tracy.Rahmlowcc: @aexp.comSubject: Naming Standards - Thoughts Needed Sent by: [EMAIL PROTECTED] om 2001.07.13 17:40 Please respond to ORACLE-L Were looking to develop naming standards within our organization and I am wondering what others use. Is there a formal process similiar to ofa? Do shops typically use underscores or case? (policy_number / PolicyNumber) What about abbreviating? Enforcement processes ? Other considerations? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: pls-00123 - Program too Large
Hi Imma, This error is concerned with number of Diana nodes (PL/SQL internals) and some other internal restrictions of PL/SQL machine. There is no direct relationship between appearance of PLS-00123 and size of the package. You can find 2 or 3 good notes on Metalink that explain the limitations in detail. And if my memory services me right, unfortunately, the only way to avoid this problem is to divide your package into smaller parts Regards, Ed We have a tool (an own-made pl/sql code generator) whose purpose is to generate a PL/SQL Package containing one pls function for each Table/View that has been configured in a specific repository table. Depending on the number of table/view configured the package dimension grows. Compiling one of those automatically generated packages we got the following error PLS-00123 - Program too Large. Obviously one of the possible solution to the the problem is to modularize, but depending of the fact that the package code is automatically generated this could not work. Could someone give us a more detailed explanation on why this error occurs and eventually a possible solution. I've read somethings about an existing correlation between Oracle Block_size and PL/SQL block size - has anyone more detailed information about this? Is it possible to determine in a unique way the max dimension a pl/sql package can have? Thanks in advance Imma -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
offline - Dynamic SQL doubt...
Hi, I want to call a procedure dynamically which returns a pl/sql table (OUT Parameter). This is the package where the procedure is defined. == create or replace package body pk1 as procedure proc1(no number, pltab out dbms_sql.varchar2_table) as tempdate date; begin select sysdate into tempdate from dual; pltab(1):='First'; pltab(2):='Second'; pltab(3):='Third'; pltab(4):='Fourth'; pltab(5):='Fifth'; end proc1; end pk1; / === Anonymous pl/sql block calling the above procedure fire.sql declare pltab2 dbms_sql.varchar2_table; ln_num number:=100; c number; dummy number; stmt varchar2(100); begin stmt := 'begin pk1.proc1(:ln_num, :pltab); end;'; c := dbms_sql.open_cursor; dbms_sql.parse(c, stmt, dbms_sql.native); dbms_sql.bind_variable(c, ':ln_num', ln_num); dbms_sql.bind_array(c, ':pltab', pltab2,1,2); dummy := dbms_sql.execute(c); dbms_sql.close_cursor(c); end; / ERROR at line 1: ORA-29252: collection does not contain elements at index locations in call to dbms_sql.bind_array ORA-06512: at SYS.DBMS_SYS_SQL, line 895 ORA-06512: at SYS.DBMS_SQL, line 140 ORA-06512: at line 21 I am getting the above error. Can anyone tell me what is wrong in this code? Thank You. Arul. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: pls-00123 - Program too Large
Probably the problem is with the DIANA dependencies of the object that is limited to about 64k. However the compiled version of the object called m-code has been increasing over the releases. Therefore this also could be a problem the chances here are less than the DIANA thing. Exactly look for the notes 99882.1 and 62603.1. Regards. --- Shevtsov, Eduard [EMAIL PROTECTED] wrote: Hi Imma, This error is concerned with number of Diana nodes (PL/SQL internals) and some other internal restrictions of PL/SQL machine. There is no direct relationship between appearance of PLS-00123 and size of the package. You can find 2 or 3 good notes on Metalink that explain the limitations in detail. And if my memory services me right, unfortunately, the only way to avoid this problem is to divide your package into smaller parts Regards, Ed We have a tool (an own-made pl/sql code generator) whose purpose is to generate a PL/SQL Package containing one pls function for each Table/View that has been configured in a specific repository table. Depending on the number of table/view configured the package dimension grows. Compiling one of those automatically generated packages we got the following error PLS-00123 - Program too Large. Obviously one of the possible solution to the the problem is to modularize, but depending of the fact that the package code is automatically generated this could not work. Could someone give us a more detailed explanation on why this error occurs and eventually a possible solution. I've read somethings about an existing correlation between Oracle Block_size and PL/SQL block size - has anyone more detailed information about this? Is it possible to determine in a unique way the max dimension a pl/sql package can have? Thanks in advance Imma -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Temp
hi every body, I have a user with no quota on it's temporary tablespace. is it normal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Temp
Hi Salim, I believe quota will appear only if he has been GRANTed some quota explicitly. If he has been granted as CREATE USER .. TEMPORARY TABLESPACE ts then quota wont appear in DBA_TS_QUOTAS Hope this may help. Regards, Arul. Djaroud Salim wrote: hi every body, I have a user with no quota on it's temporary tablespace. is it normal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Naming Standards - Thoughts Needed
IMHO the reason for prefixes/postfixes is so that dependent objects can be given a more 'natural' name, that relates it to the object it depends on. Therefore T_ is redundant because tables don't depend on anything, but V_, T_ etc _may_ not be. Similarly, in pl/sql, you often want a procedure parameter to be the value of a column on a table. You can't use the name of the column because that would cause problems in the sql statements that use the value, so the usual standard is to prefix all parameters with p_ and local variables with l_ or v_. BTW, TR_ is not generally sufficient - you may want to have more than one trigger on a table. I would use something like TAI_ = Trigger After Insert, TBIUD_ = Trigger Before Insert, Update or Delete, etc. On the underscores/capitalisation business; Oracle is generally not case-sensitive, so really you have to use underscores if you want readability. Regards David Lord -Original Message- Sent: 13 July 2001 20:21 To: Multiple recipients of list ORACLE-L Our old office used to do that as well, and I thought it was redundant. You can always look up the type in dba_objects to know what the type is. It might be worth more to keep those extra characters as part of the name. -Original Message- Sent: Friday, July 13, 2001 1:21 PM To: Multiple recipients of list ORACLE-L Hi , We use T_ for tables P_procs V_view TR_trigger F_function S_F_synonym of function - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 13, 2001 6:40 PM Were looking to develop naming standards within our organization and I am wondering what others use. Is there a formal process similiar to ofa? Do shops typically use underscores or case? (policy_number / PolicyNumber) What about abbreviating? Enforcement processes ? Other considerations? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lord, David - CS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Any idea about DIANA in Oracle...??
Hi DBAs, I have seen some packages / procs.. getting created with DIANA as names while executing CATALOG / CATPROC scripts. Does anyone have idea about it? What is special(!) about it?? Thank You. Arul. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: pls-00123 - Program too Large
Hi Christian, Didn't they remove their limitation on 64K ? I don't have access to Metalink now, can't look at the notes. Probably the problem is with the DIANA dependencies of the object that is limited to about 64k. However the compiled version of the object called m-code has been increasing over the releases. Therefore this also could be a problem the chances here are less than the DIANA thing. Exactly look for the notes 99882.1 and 62603.1. Regards. --- Shevtsov, Eduard [EMAIL PROTECTED] wrote: Hi Imma, This error is concerned with number of Diana nodes (PL/SQL internals) and some other internal restrictions of PL/SQL machine. There is no direct relationship between appearance of PLS-00123 and size of the package. You can find 2 or 3 good notes on Metalink that explain the limitations in detail. And if my memory services me right, unfortunately, the only way to avoid this problem is to divide your package into smaller parts Regards, Ed We have a tool (an own-made pl/sql code generator) whose purpose is to generate a PL/SQL Package containing one pls function for each Table/View that has been configured in a specific repository table. Depending on the number of table/view configured the package dimension grows. Compiling one of those automatically generated packages we got the following error PLS-00123 - Program too Large. Obviously one of the possible solution to the the problem is to modularize, but depending of the fact that the package code is automatically generated this could not work. Could someone give us a more detailed explanation on why this error occurs and eventually a possible solution. I've read somethings about an existing correlation between Oracle Block_size and PL/SQL block size - has anyone more detailed information about this? Is it possible to determine in a unique way the max dimension a pl/sql package can have? Thanks in advance Imma -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Temp
Hi Content d'avoir de tes nouvelles From Oracle Documentation (Server Concept) , there is no effect of quotas on temporary segments. -Message d'origine- De : Djaroud Salim [mailto:[EMAIL PROTECTED]] Envoyé : lundi 16 juillet 2001 09:00 À : Multiple recipients of list ORACLE-L Objet : Temp hi every body, I have a user with no quota on it's temporary tablespace. is it normal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Temp
HI, If I am not mistaken ,there is no concept of granting Quotas on the temporary tablespaces (Only on default tablespaces). The temporary tablespace is managed by Oracle for sorting data ( if memory sort is not possible). Hope this helps. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: hi every body, I have a user with no quota on it's temporary tablespace. is it normal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OEM - SMTP (urgent)
Hi, I am using OEM 2.2.3 on window NT client 4.0 service pack 3.0 and database 8.1.5. platform HP-UX 11. I already configure SMTP gateway and when I test this gateway through Preferences- Notification, the test failed.Outlook mail is working on that machine( window NT). I need help in above problem. Thanks, Ajay Singh RathoreHCL Infosystems Ltd---visit us at www.hclinsystems.com
Re: Last Update
Hi Erik, Check out the dba_objects tables. There is a column called as Last_ddl_time , which will give the ddl time. But if you want to capture select,insert,delete,update times ? I guess you will have to write trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: User Memory
Hi, We had this one recently on the list. 1) This could also be caused if the user is able to change his session level sort_area_size. alter session set sort_area_size=size in mb ; 2) Check if the users have alter session privilege . Revoke this privilege. 3) Check if they are actually changing the settings. HTH shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: Hi everybody, i've been monitoring my users connections for i alittle while now and i have noticed something that's worrying me. i'm running Hpu-UX 11, Oracle 8.1.7 with Dedicated connections i have sort area size set to 6m and i am seeing users using 20m and up to 100m of memory in unix what could be causing this? How can i find out whats being done in that PGA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: hp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Temp
hi, Moi aussi, je suis ravie . Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : GL2Z/ INF DBA BENLATRECHE [mailto:[EMAIL PROTECTED]] Envoyé : lundi 16 juillet 2001 09:46 À : Multiple recipients of list ORACLE-L Objet : RE: Temp Hi Content d'avoir de tes nouvelles From Oracle Documentation (Server Concept) , there is no effect of quotas on temporary segments. -Message d'origine- De : Djaroud Salim [mailto:[EMAIL PROTECTED]] Envoyé : lundi 16 juillet 2001 09:00 À : Multiple recipients of list ORACLE-L Objet : Temp hi every body, I have a user with no quota on it's temporary tablespace. is it normal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INF/MEKKAOUI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Naming Standards - Thoughts Needed
IMHO the reason for prefixes/postfixes is so that dependent objects can be given a more 'natural' name, that relates it to the object it depends on. Therefore T_ is redundant because tables don't depend on anything, but V_, T_ etc _may_ not be. Similarly, in pl/sql, you often want a procedure parameter to be the value of a column on a table. You can't use the name of the column because that would cause problems in the sql statements that use the value, so the usual standard is to prefix all parameters with p_ and local variables with l_ or v_. BTW, TR_ is not generally sufficient - you may want to have more than one trigger on a table. I would use something like TAI_ = Trigger After Insert, TBIUD_ = Trigger Before Insert, Update or Delete, etc. I fully subscribe to this. For triggers, it's even worse than this if you want to be exhaustive, because you may wish to indicate not only whether the trigger is a before or after trigger (or instead of ...), but also it it is fired once per statement or for each row. Currently (my own standards evolve over time) I tend to forget about AFTER or BEFORE, but postfix my triggers with _IUD_RTRG or _IUD_STRG, where I/U/D specifies whether it is fired by insert, update or delete and RTRG stands for row trigger and STRG for statement trigger. Also, opinions may be different about this, but I prefer postfixing over prefixing. The reason is that when you query USER_OBJECTS and order by OBJECT_NAME you will find related objects (tables, indexes, triggers ...) grouped together. Prefixing would put the emphasis on the type, which can make sense as well, but since you already have USER_ or DBA_ views for each type I find it less necessary and I think that postfixing 'adds value' in a way. 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: Temp
hi every body, I have a user with no quota on it's temporary tablespace. is it normal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] It is normal. You do not need quotas on temporary tablespaces. You need quotas where you want to create tables, indexes, clusters ... anything which will appear in USER_SEGMENTS (and is here to stay). Temporary space is a bit like rollback segments in this respect, the right to use them is implicit. In fact, you should remove quotas on temporary tablespaces from all users, if you do not want to see one day a Sybase-trained developer (most of those I have met were temporary tables lovers) create a 'temporary table' there. Applicative temporary tables, first are best avoided, and second have nothing to do in users' temporary tablespaces (as defined in the CREATE/ALTER USER statements). 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).
Unix/NFS/NT question
Hi, On one system, while moving backup files from unix to NT via NFS (yep state of the art backup strategy) we had this message : mv: cannot unlink /SvgUnix/Oracle/Svg_J/ora_DWPQ/database/bowebi_doc_data03.dbf.Z: No such file or directory The file is still on the unix box, all the other files where moved on NT. This is occuring once per 50 times. Any ideas ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Any idea about DIANA in Oracle...??
The notes I've sent for the PLS 123 give you a briefly idea of DIANA. However DIANA is an acronym of Descriptive Intermediate Notation for ADA. And is an intermedia language and uses the IDL tables for saving the structure of tables and logic of PL/SQL program units. In other words, is the language that allow the PL/SQL run. --- Arul kumar [EMAIL PROTECTED] wrote: Hi DBAs, I have seen some packages / procs.. getting created with DIANA as names while executing CATALOG / CATPROC scripts. Does anyone have idea about it? What is special(!) about it?? Thank You. Arul. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Last Update
alter table monitoring. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi Erik, Check out the dba_objects tables. There is a column called as Last_ddl_time , which will give the ddl time. But if you want to capture select,insert,delete,update times ? I guess you will have to write trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: pls-00123 - Program too Large
Better than my wordsthe notes themself: Doc ID: Note:99882.1 Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 23-FEB-2000 Last Revision Date: 13-JUN-2000 Overview This article provides an overview of PL/SQL size limits for the 8.1.x releases. It is intended as a quick reference and is a synopsis of documented Oracle behavior. PL/SQL Size Limits Explained Oracle's PL/SQL programming language is based upon the ADA programming language. As a result, PL/SQL uses a variant of Descriptive Intermediate Attributed Notation for Ada (DIANA), which is a tree-structured intermediate language. It is defined using a meta-notation called Interface Definition Language (IDL). DIANA provides for communication internal to compilers and other tools. PL/SQL source code for a procedure or a package is stored in the database using the following two constructs: o m-code o DIANA The m-code is the actual executable, while the DIANA provides source code dependency trees. At runtime, the m-code and DIANA are loaded into the shared pool. The m-code is the executable, while the DIANA compiles dependent procedures. According to 8.1.6 documentation the following size limits apply: In the shared pool, a package spec, object type spec, stand-alone subprogram, or anonymous block is limited to 64K DIANA nodes. The nodes correspond to tokens such as identifiers, keywords, operators, and so on. The m-code is limited to 64K compiler-generated temporary variables. Although the PL/SQL compiler enforces its own size limits (listed below), usually it is the DIANA size limits which are reached first. The following is an excerpt from Appendix E of the PL/SQL Users Guide and Reference 8.1.6 Release: Table E-1 PL/SQL Compiler Limits (8.1.X release) Item Limit bind variables passed to a program unit 32K exception handlers in a program unit 64K fields in a record 64K levels of block nesting 255 levels of record nesting 32 levels of subquery nesting 254 levels of label nesting 98 magnitude of a BINARY_INTEGER value 2G magnitude of a PLS_INTEGER value 2G objects referenced by a program unit 64K parameters passed to an explicit cursor 64K parameters passed to a function or procedure 64K precision of a FLOAT value (binary digits) 126 precision of a NUMBER value (decimal digits) 38 precision of a REAL value (binary digits) 63 size of an identifier (characters) 30 size of a string literal (bytes) 32K size of a CHAR value (bytes) 32K size of a LONG value (bytes) 32K - 7 size of a LONG RAW value (bytes) 32K - 7 size of a RAW value (bytes) 32K size of a VARCHAR2 value (bytes) 32K size of an NCHAR value (bytes) 32K size of an NVARCHAR2 value (bytes) 32K size of a BIFLE value (bytes) 4G size of a BLOB value (bytes) 4G size of a CLOB value (bytes) 4G size of an NCLOB value (bytes) 4G Related Documents - PL/SQL User's Guide and Reference Release 8.1.6, (A77069-01), Appendix E [NOTE:73969.1] PL/SQL Size Limitations [NOTE:62603.1] 'PLS-123 Program too Large' - Size Limitations on PLSQL Packages And the other: Doc ID: Note:62603.1 Limitations on PLSQL Packages Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 22-SEP-1998 Last Revision Date: 13-JUN-2000 Overview This article contains information on PL/SQL package size limitations. When limits are reached, you receive the following error: PLS-123 Program too large Size Limitations on PL/SQL Packages --- In releases prior to 8.1.3, large programs resulted in the PLS-123 error. This occurred because of genuine limits in the compiler; not as a result of a bug. When compiling a PL/SQL unit, the compiler builds a parse tree. The maximum size of a PL/SQL unit is determined by the size of the parse tree. A maximum number of diana
offline- Returning pl/sql table from a proc. dynamically..
Hi, I want to return a PL/SQL Table dynamically from a pl/sql procedure dynamically. Here , is the package which has the procedure : create or replace package body pk1 as procedure proc1(no number, pltab out dbms_sql.varchar2_table) as tempdate date; begin pltab(1):='First'; pltab(2):='Second'; pltab(3):='Second'; pltab(4):='Second'; pltab(5):='Second'; end proc1; end pk1; Fire. sql calls the above procedure : Fire.sql declare pltab2 dbms_sql.varchar2_table; ln_num number:=100; c number; dummy number; stmt varchar2(100); begin stmt := 'begin pk1.proc1(:ln_num, :pltab); end;'; c := dbms_sql.open_cursor; dbms_sql.parse(c, stmt, dbms_sql.native); dbms_sql.bind_variable(c, ':ln_num', ln_num); dbms_sql.bind_array(c, ':pltab', pltab2,1,1); dummy := dbms_sql.execute(c); dbms_sql.close_cursor(c); end; / On executing, the above code shows the foll. error: declare * ERROR at line 1: ORA-29252: collection does not contain elements at index locations in call to dbms_sql.bind_array ORA-06512: at SYS.DBMS_SYS_SQL, line 605 ORA-06512: at SYS.DBMS_SQL, line 146 ORA-06512: at line 21 Can anyone tell me the reason? This code has been tried in 8.0.4 , 8.1.6 and 8.1.7 (SOLARIS) oracle versions. It reports the same error. Thank You. Arul. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Any idea about DIANA in Oracle...??
Hi, This is what i have gleaned from the previous discussions on the list. As to what is actually inside these tables, here's a related extract from the PL/SQL docs: PL/SQL is based on the programming language Ada. As a result, PL/SQL uses a variant of Descriptive Intermediate Attributed Notation for Ada (DIANA), which is a tree-structured intermediate language. It is defined using a meta-notation called Interface Definition Language (IDL). DIANA provides for communication internal to compilers and other tools. At compile time, PL/SQL source code is translated into machine-readable m-code. Both the DIANA and m-code for a procedure or package are stored in the database. At run time, they are loaded into the shared (memory) pool. The DIANA is used to compile dependent procedures; the m-code is simply executed. These four tables hold the DIANA and the so-code m-code. I think m-code is short for machine-dependent byte code but there is a sizable machine-indenpendent part as well. If you have a look at sql.bsq, you can see that Oracle documents the type column of these tables as follows: part number not null, /* part: 0 = diana, 1 = portable pcode, 2 = machine-dependent pcode */ HTH shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: Hi DBAs, I have seen some packages / procs.. getting created with DIANA as names while executing CATALOG / CATPROC scripts. Does anyone have idea about it? What is special(!) about it?? Thank You. Arul. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Analyze
I have an Analyze Schema running once a week for a 35G instance. The Analyze is taking about 9 hours. This is too long. What is the opinion on doing an Analyze on a percentage of the data? 20%? 40%? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
No Subject
Hi friends : How to calculate the parameters : Shared_pool_size, db_block_buffer, sort_area_size of Database for : 50 session simultaneous 512 MB ram Linux Regards. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test message
please ignore
RE: A lazy connection!
I believe that you could try and change the settings in the sqlnet.ora file on the server side, SQLNET EXPIRE_TIME = 0. This may help:) KK -Original Message- [EMAIL PROTECTED] Sent: Monday, July 16, 2001 2:50 AM To: Multiple recipients of list ORACLE-L We have a network that have some computers with a lazy connection. Here, on these computers, we have some ORACLE users. On these computers running an application (I don't have acces to the code of this application.) When I work, sometimes, I have an ORACLE error : ORA-03114: not connected to Oracle . A ping to these computers don't show me that something is wrong. Everything is OK. This connection accept an transfer at 100 kBytes that is enough for me. The time of response for my ping is good, too (time 10 ms). I think is time of response, yet. I don't have other ideea. So, THE QUESTIN: Is there in ORACLE a setting that accept connection with lazy line? Something like a timeout settings? Thank you very much ! Marian -- 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: 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).
test message - please ignore
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Analyze
On 8i, use DBMS_STATS that you can do it in parallel except for the indexes. You need to put as argument a degree1. Also beware of the method_opt. Because the default is 'FOR ALL COLUMNS SIZE 1'. Regards. --- Smith, Ron L. [EMAIL PROTECTED] wrote: I have an Analyze Schema running once a week for a 35G instance. The Analyze is taking about 9 hours. This is too long. What is the opinion on doing an Analyze on a percentage of the data? 20%? 40%? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A lazy connection!
Beware that SQLNET.EXPIRE_TIME=0 doesn't activate this feature. Is the same that set it with huge value. Regards. --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: I believe that you could try and change the settings in the sqlnet.ora file on the server side, SQLNET EXPIRE_TIME = 0. This may help:) KK -Original Message- [EMAIL PROTECTED] Sent: Monday, July 16, 2001 2:50 AM To: Multiple recipients of list ORACLE-L We have a network that have some computers with a lazy connection. Here, on these computers, we have some ORACLE users. On these computers running an application (I don't have acces to the code of this application.) When I work, sometimes, I have an ORACLE error : ORA-03114: not connected to Oracle . A ping to these computers don't show me that something is wrong. Everything is OK. This connection accept an transfer at 100 kBytes that is enough for me. The time of response for my ping is good, too (time 10 ms). I think is time of response, yet. I don't have other ideea. So, THE QUESTIN: Is there in ORACLE a setting that accept connection with lazy line? Something like a timeout settings? Thank you very much ! Marian -- 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: 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Analyze
It seems you use 'compute' option of analyze command. Try to use 'estimate' with about 45% sample of data and then check whether the plans are still unchanged. This solution may decrease the time you spend on analyzing but usually keeps the precision of statistics. Regards, Ed I have an Analyze Schema running once a week for a 35G instance. The Analyze is taking about 9 hours. This is too long. What is the opinion on doing an Analyze on a percentage of the data? 20%? 40%? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Tracing
Hello I would like to start tracing for different session than my one. How it is possible in 8.1.7 EE? I want to start tracing for different sessions with different levels (not necessary diff. levels). I found that it should be possible with dbms_support package, but i didnt find this package and I also didnt find creation script in my rdbms/admin directory (it should be dbmssupp.sql). Please help me where I can find it or how to do it. Ivo Libal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
No Subject
Hello I would like to start tracing for different session than my one. How it is possible in 8.1.7 EE? I want to start tracing for different sessions with different levels (not necessary diff. levels). I found that it should be possible with dbms_support package, but i didnt find this package and I also didnt find creation script in my rdbms/admin directory (it should be dbmssupp.sql). Please help me where I can find it or how to do it. Ivo Libal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Last Update
Hi, but in my 8.1.7 db. (on SOLARIS), NO ROWS SELECTED when queried DBA_TAB_MODIFICATIONS... Any init parameters to be enabled?? Arul. Christian Trassens wrote: However you can query the view dba_tab_modifications for checking when and how many updates/deletes/inserts/truncate have been done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: alter table monitoring. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi Erik, Check out the dba_objects tables. There is a column called as Last_ddl_time , which will give the ddl time. But if you want to capture select,insert,delete,update times ? I guess you will have to write trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command
RE: A lazy connection!
Title: RE: A lazy connection! Are any profiles implemented? I believe that's the error I get when a profile has kicked me out. Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Subject: RE: A lazy connection! What? What do you mean? KK -Original Message- Trassens Sent: Monday, July 16, 2001 10:18 AM To: Multiple recipients of list ORACLE-L Beware that SQLNET.EXPIRE_TIME=0 doesn't activate this feature. Is the same that set it with huge value. Regards. --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: I believe that you could try and change the settings in the sqlnet.ora file on the server side, SQLNET EXPIRE_TIME = 0. This may help:) KK -Original Message- [EMAIL PROTECTED] Sent: Monday, July 16, 2001 2:50 AM To: Multiple recipients of list ORACLE-L We have a network that have some computers with a lazy connection. Here, on these computers, we have some ORACLE users. On these computers running an application (I don't have acces to the code of this application.) When I work, sometimes, I have an ORACLE error : ORA-03114: not connected to Oracle . A ping to these computers don't show me that something is wrong. Everything is OK. This connection accept an transfer at 100 kBytes that is enough for me. The time of response for my ping is good, too (time 10 ms). I think is time of response, yet. I don't have other ideea. So, THE QUESTIN: Is there in ORACLE a setting that accept connection with lazy line? Something like a timeout settings? Thank you very much ! Marian -- 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: 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: A lazy connection!
There is not any profile defined, except default profile. There is a problem only for the computers that has an acces with leased line. There is other computers that has an acces using a local network and everything is OK here. -Original Message- To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]; '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: luni 16 iulie 2001 16:49 Are any profiles implemented? I believe that's the error I get when a profile has kicked me out. Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA -Original Message- Sent: Monday, July 16, 2001 10:36 AM To: Multiple recipients of list ORACLE-L What? What do you mean? KK -Original Message- Trassens Sent: Monday, July 16, 2001 10:18 AM To: Multiple recipients of list ORACLE-L Beware that SQLNET.EXPIRE_TIME=0 doesn't activate this feature. Is the same that set it with huge value. Regards. --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: I believe that you could try and change the settings in the sqlnet.ora file on the server side, SQLNET EXPIRE_TIME = 0. This may help:) KK -Original Message- [EMAIL PROTECTED] Sent: Monday, July 16, 2001 2:50 AM To: Multiple recipients of list ORACLE-L We have a network that have some computers with a lazy connection. Here, on these computers, we have some ORACLE users. On these computers running an application (I don't have acces to the code of this application.) When I work, sometimes, I have an ORACLE error : ORA-03114: not connected to Oracle . A ping to these computers don't show me that something is wrong. Everything is OK. This connection accept an transfer at 100 kBytes that is enough for me. The time of response for my ping is good, too (time 10 ms). I think is time of response, yet. I don't have other ideea. So, THE QUESTIN: Is there in ORACLE a setting that accept connection with lazy line? Something like a timeout settings? Thank you very much ! Marian -- 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: 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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). -- 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
Re: Tracing
On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote: Hello I would like to start tracing for different session than my one. How it is possible in 8.1.7 EE? I want to start tracing for different sessions with different levels (not necessary diff. levels). I found that it should be possible with dbms_support package, but i didnt find this package and I also didnt find creation script in my rdbms/admin directory (it should be dbmssupp.sql). Please help me where I can find it or how to do it. Ivo Libal dbms_system.set_ev(sid, serial, event, level, NULL); -- Vladimir Begun | Without freedom of choice there is no http://vbegun.net/ | creativity. http://vbegun.net/wap/ | -- Kirk, The return of the [EMAIL PROTECTED]| Archons, stardate 3157.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman question
You should backup all of the archivelogs if you are going to delete them and maybe even if you are not. The redo logs contain data which is already in the database when the backup is made so you don't need to back them up. In my scripts I always to an 'archive log current' and backup all of my archive logs and delete them. We don't have enough room to keep them. This way the archive logs that I might need to restore and recovery from a particular backup are with that backup when I put it on tape. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 13, 2001 3:46 PM Ruth, Cold bacpup should backup online redo files. Level 0 did'nt include online redo files. If I do alter system archivelog current, should I backup archive files as well? We are in archive mode. Joan Ruth Gramolini wrote: You can so a cold backup with rman, the database will be in mount state to do it. Just to a shutdown, startup mount and run a full of level 0 backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 12, 2001 5:35 PM Hi Dear List, We are using unix shell script to cold backup our production right now and ftp the backupset to the test machine refresh the testing instance once a week. My question is if I decide to use rman instead shell script. How it works with cold backup? Can I using rman catalog to restore a production database to test database? Can I restore obsolete backups to another machine using rman? Sometimes we have to restore old backups on the test machine to debug a production problem. Thanks a lot. Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Last Update
If you have just set a table as monitoring (and have no other tables already set for this option), then you may not actually see any rows in this table for a while. The one downfall with this option (if you want/need real time info) is that this table may not update for some time after the table/data has been modified. Go back to it in an hour or so.. -Original Message- Sent: Monday, July 16, 2001 03:36 To: Multiple recipients of list ORACLE-L Hi, but in my 8.1.7 db. (on SOLARIS), NO ROWS SELECTED when queried DBA_TAB_MODIFICATIONS... Any init parameters to be enabled?? Arul. Christian Trassens wrote: However you can query the view dba_tab_modifications for checking when and how many updates/deletes/inserts/truncate have been done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: alter table monitoring. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi Erik, Check out the dba_objects tables. There is a column called as Last_ddl_time , which will give the ddl time. But if you want to capture select,insert,delete,update times ? I guess you will have to write trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
RE: A lazy connection!
My first suspicion would be a firewall; check with your network people. I would set the sqlnet.expire time to ten minutes to keep the firewall from kicking idle sql*net connections. --Michael -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 11:12 AM To: Multiple recipients of list ORACLE-L There is not any profile defined, except default profile. There is a problem only for the computers that has an acces with leased line. There is other computers that has an acces using a local network and everything is OK here. -Original Message- To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]; '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: luni 16 iulie 2001 16:49 Are any profiles implemented? I believe that's the error I get when a profile has kicked me out. Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA -Original Message- Sent: Monday, July 16, 2001 10:36 AM To: Multiple recipients of list ORACLE-L What? What do you mean? KK -Original Message- Trassens Sent: Monday, July 16, 2001 10:18 AM To: Multiple recipients of list ORACLE-L Beware that SQLNET.EXPIRE_TIME=0 doesn't activate this feature. Is the same that set it with huge value. Regards. --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: I believe that you could try and change the settings in the sqlnet.ora file on the server side, SQLNET EXPIRE_TIME = 0. This may help:) KK -Original Message- [EMAIL PROTECTED] Sent: Monday, July 16, 2001 2:50 AM To: Multiple recipients of list ORACLE-L We have a network that have some computers with a lazy connection. Here, on these computers, we have some ORACLE users. On these computers running an application (I don't have acces to the code of this application.) When I work, sometimes, I have an ORACLE error : ORA-03114: not connected to Oracle . A ping to these computers don't show me that something is wrong. Everything is OK. This connection accept an transfer at 100 kBytes that is enough for me. The time of response for my ping is good, too (time 10 ms). I think is time of response, yet. I don't have other ideea. So, THE QUESTIN: Is there in ORACLE a setting that accept connection with lazy line? Something like a timeout settings? Thank you very much ! Marian -- 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: 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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:
Re: Last Update
Andthen wait because the SMON updates it every three hours or after an startup. Regards. PS: Even that you can manually wakeup the SMON through oradebug wakeup orapid of SMON --- JOE TESTA [EMAIL PROTECTED] wrote: you have to turn monitoring on for each table. alter table tablename monitoring; joe [EMAIL PROTECTED] 07/16/01 10:36AM Hi, but in my 8.1.7 db. (on SOLARIS), NO ROWS SELECTED when queried DBA_TAB_MODIFICATIONS... Any init parameters to be enabled?? Arul. Christian Trassens wrote: However you can query the view dba_tab_modifications for checking when and how many updates/deletes/inserts/truncate have been done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi, This is what is mentioned in the manual. Alter table MONITORING specifies that Oracle can collect modification statistics on table. These statistics are estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user. I think erik is looking out for the date and time when the DML occurred. , whereas the monitoring clause woud give the rows affected . Hope my interpretation is correct. shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: alter table monitoring. --- Shreepad Vaidya [EMAIL PROTECTED] wrote: Hi Erik, Check out the dba_objects tables. There is a column called as Last_ddl_time , which will give the ddl time. But if you want to capture select,insert,delete,update times ? I guess you will have to write trigger and capture the times. HTH shreepad shreepad To: Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT INTERNET@CCMAIL cc: How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ:
Re: Tracing
Or with oradebug: oradebug setospid OS PID oradebug event 10046 trace name context forever, level 4,8,12 --- Vladimir Begun [EMAIL PROTECTED] wrote: On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote: Hello I would like to start tracing for different session than my one. How it is possible in 8.1.7 EE? I want to start tracing for different sessions with different levels (not necessary diff. levels). I found that it should be possible with dbms_support package, but i didnt find this package and I also didnt find creation script in my rdbms/admin directory (it should be dbmssupp.sql). Please help me where I can find it or how to do it. Ivo Libal dbms_system.set_ev(sid, serial, event, level, NULL); -- Vladimir Begun | Without freedom of choice there is no http://vbegun.net/ | creativity. http://vbegun.net/wap/ |-- Kirk, The return of the [EMAIL PROTECTED]|Archons, stardate 3157.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tracing
On Jul 16, 2001 at 07:12:00AM, Vladimir Begun wrote: On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote: Hello I would like to start tracing for different session than my one. How it is possible in 8.1.7 EE? I want to start tracing for different sessions with different levels (not necessary diff. levels). I found that it should be possible with dbms_support package, but i didnt find this package and I also didnt find creation script in my rdbms/admin directory (it should be dbmssupp.sql). Please help me where I can find it or how to do it. Ivo Libal dbms_system.set_ev(sid, serial, event, level, NULL); Forgot to mention: 10046 as a value for event. -- Vladimir Begun | Be consistent. http://vbegun.net/ | -- Larry Wall in the perl man http://vbegun.net/wap/ | page [EMAIL PROTECTED]| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tracing
Here you have: --- Libal, Ivo [EMAIL PROTECTED] wrote: Hello I would like to start tracing for different session than my one. How it is possible in 8.1.7 EE? I want to start tracing for different sessions with different levels (not necessary diff. levels). I found that it should be possible with dbms_support package, but i didnt find this package and I also didnt find creation script in my rdbms/admin directory (it should be dbmssupp.sql). Please help me where I can find it or how to do it. Ivo Libal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ dbms_support.zip
OT RE: ONS Install - my life is at an end
My best advice to you is to ignore me, because I am a Stegosaurus standing in the shadow created by an enormous asteriod about to land in the ocean, creating a marine volcano, the downline effect of which will be to obliterate all sunlight on the planet for decades driving the plant life to near extinction and killing all my brethren along with me. Folks who keep up with Oracle, Web, XML, and all the other TLAs are ALOT better to follow. now, back to munching on this yummy plant frond! :) -Original Message- Sent: Sunday, July 15, 2001 1:55 AM To: Multiple recipients of list ORACLE-L hi, I am thrilled to receive a mail from you Ross coz I am a novice Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 13, 2001 8:00 PM novicedba, Thanks for your offer of assistance...I am on unix, though, and this type of install problem can be platform-specific, not to mention OS-specifici'll keep you posted. Thanks again for your offer of help. - Ross -Original Message- Sent: Friday, July 13, 2001 3:41 AM To: Multiple recipients of list ORACLE-L hi ross, My boss (well a colleague but I donno anything about the configuration and he does so he is my boss) at the place where I work has installed Names server on NT. Will it be of any help? coz I am a novice Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 13, 2001 4:16 AM Ok, so no one liked the InterMedia Question, so let's forget that one. How about this? ONS, ver817namesctl installs and builds OK, but I cannot get names (name server) to run.if i run the make manually, it claims to be missing libnon8.a Sure enough, it's not on the file system. Any one run into this? I didnot find anything on MetaRetch, and R'ing the FM did not help... Thanks in advance! - Ross -- 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: novicedba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: novicedba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Re: Tracing
Ivo, See Metalink Note 1058210.6 for more details on ORADEBUG. HTH Srini Chavali Oracle DBA Cummins Inc Libal, Ivo [EMAIL PROTECTED]@fatcity.com on 07/16/2001 09:45:36 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hello I would like to start tracing for different session than my one. How it is possible in 8.1.7 EE? I want to start tracing for different sessions with different levels (not necessary diff. levels). I found that it should be possible with dbms_support package, but i didnt find this package and I also didnt find creation script in my rdbms/admin directory (it should be dbmssupp.sql). Please help me where I can find it or how to do it. Ivo Libal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: A lazy connection!
I meant that if you want to use expire_time feature, you'll need to set it with a value greater than 0. Remember that the value is in minutes. F.e.: SQLNET.EXPIRE_TIME=20 .means that every twenty minute SQL*Net or Net8 polls each connection SQLNET.EXPIRE_TIME=0.means that SQL*NET or NET8 doesn't poll any connection. Is it clear ?. Regards. --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: What? What do you mean? KK -Original Message- Trassens Sent: Monday, July 16, 2001 10:18 AM To: Multiple recipients of list ORACLE-L Beware that SQLNET.EXPIRE_TIME=0 doesn't activate this feature. Is the same that set it with huge value. Regards. --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: I believe that you could try and change the settings in the sqlnet.ora file on the server side, SQLNET EXPIRE_TIME = 0. This may help:) KK -Original Message- [EMAIL PROTECTED] Sent: Monday, July 16, 2001 2:50 AM To: Multiple recipients of list ORACLE-L We have a network that have some computers with a lazy connection. Here, on these computers, we have some ORACLE users. On these computers running an application (I don't have acces to the code of this application.) When I work, sometimes, I have an ORACLE error : ORA-03114: not connected to Oracle . A ping to these computers don't show me that something is wrong. Everything is OK. This connection accept an transfer at 100 kBytes that is enough for me. The time of response for my ping is good, too (time 10 ms). I think is time of response, yet. I don't have other ideea. So, THE QUESTIN: Is there in ORACLE a setting that accept connection with lazy line? Something like a timeout settings? Thank you very much ! Marian -- 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: 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062
RE: Tracing
Best option would be turn on the sql_trace and timed_statistice parameter in init.ora and re-start the database. But makes ure you have enought space to write trc files in OS Baskar -Original Message- Sent: 16 July 2001 16:12 To: Multiple recipients of list ORACLE-L On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote: Hello I would like to start tracing for different session than my one. How it is possible in 8.1.7 EE? I want to start tracing for different sessions with different levels (not necessary diff. levels). I found that it should be possible with dbms_support package, but i didnt find this package and I also didnt find creation script in my rdbms/admin directory (it should be dbmssupp.sql). Please help me where I can find it or how to do it. Ivo Libal dbms_system.set_ev(sid, serial, event, level, NULL); -- Vladimir Begun | Without freedom of choice there is no http://vbegun.net/ | creativity. http://vbegun.net/wap/ | -- Kirk, The return of the [EMAIL PROTECTED]| Archons, stardate 3157.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramasamy, Baskar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A lazy connection!
My first about this was about the SQLNET.EXPIRE_TIME and I didn't look the first mail. And referring to the question in that mail: there are two ways to forbid the connection through TCP: protocol.ora file or Connection Manager. Regards. --- Jenkins, Michael [EMAIL PROTECTED] wrote: My first suspicion would be a firewall; check with your network people. I would set the sqlnet.expire time to ten minutes to keep the firewall from kicking idle sql*net connections. --Michael -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 11:12 AM To: Multiple recipients of list ORACLE-L There is not any profile defined, except default profile. There is a problem only for the computers that has an acces with leased line. There is other computers that has an acces using a local network and everything is OK here. -Original Message- To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]; '[EMAIL PROTECTED]' [EMAIL PROTECTED] Date: luni 16 iulie 2001 16:49 Are any profiles implemented? I believe that's the error I get when a profile has kicked me out. Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA -Original Message- Sent: Monday, July 16, 2001 10:36 AM To: Multiple recipients of list ORACLE-L What? What do you mean? KK -Original Message- Trassens Sent: Monday, July 16, 2001 10:18 AM To: Multiple recipients of list ORACLE-L Beware that SQLNET.EXPIRE_TIME=0 doesn't activate this feature. Is the same that set it with huge value. Regards. --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: I believe that you could try and change the settings in the sqlnet.ora file on the server side, SQLNET EXPIRE_TIME = 0. This may help:) KK -Original Message- [EMAIL PROTECTED] Sent: Monday, July 16, 2001 2:50 AM To: Multiple recipients of list ORACLE-L We have a network that have some computers with a lazy connection. Here, on these computers, we have some ORACLE users. On these computers running an application (I don't have acces to the code of this application.) When I work, sometimes, I have an ORACLE error : ORA-03114: not connected to Oracle . A ping to these computers don't show me that something is wrong. Everything is OK. This connection accept an transfer at 100 kBytes that is enough for me. The time of response for my ping is good, too (time 10 ms). I think is time of response, yet. I don't have other ideea. So, THE QUESTIN: Is there in ORACLE a setting that accept connection with lazy line? Something like a timeout settings? Thank you very much ! Marian -- 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: 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see
Re: 8.1.6.1 on redhat, startup nomount hangs, alert.log shows NO ERRO
Which version of glibc is on RH 7.0? If 2.2, you will need to apply a patch from Oracle. Aslo, I don't believe RH is a supported platform. Jared On Monday 16 July 2001 04:20, Rahul wrote: List, i'm trying to create a new instance of 8.1.6.1 on linux (red hat 7.0) the installation goes without any errors... but when i want to create the instance...the svrmgrl jsut hangs..!!! the alert log shows no errors... i'm doing startup nomount pfile=.. to startup the instance the initsid.ora is presentand i tried changing the shared_pool /processes param also..(could be the semaphores or shmmax problem ?) ipcs shows semaphores and shared mem being allocated ...but the alert log shows.. Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 150 LICENSE_SESSIONS_WARNING = 0 LICENSE_MAX_USERS = 60 Starting up ORACLE RDBMS Version: 8.1.5.0.0. System parameters with non-default values: db_name=DEVP max_dump_file_size = 10240 .. that's it !! NO ERRORS !!! what to do ? TIA Rahul -- 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: Tracing
Title: RE: Tracing Don't do this blindly. Turning sql_trace = TRUE on for the entire database will decrease performance. And it goes without saying do NOT do this in production! Session level tracing is more appropriate. Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA -Original Message- From: Ramasamy, Baskar [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 11:46 AM To: Multiple recipients of list ORACLE-L Subject: RE: Tracing Best option would be turn on the sql_trace and timed_statistice parameter in init.ora and re-start the database. But makes ure you have enought space to write trc files in OS Baskar -Original Message- Sent: 16 July 2001 16:12 To: Multiple recipients of list ORACLE-L On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote: Hello I would like to start tracing for different session than my one. How it is possible in 8.1.7 EE? I want to start tracing for different sessions with different levels (not necessary diff. levels). I found that it should be possible with dbms_support package, but i didnt find this package and I also didnt find creation script in my rdbms/admin directory (it should be dbmssupp.sql). Please help me where I can find it or how to do it. Ivo Libal dbms_system.set_ev(sid, serial, event, level, NULL); -- Vladimir Begun | Without freedom of choice there is no http://vbegun.net/ | creativity. http://vbegun.net/wap/ | -- Kirk, The return of the [EMAIL PROTECTED] | Archons, stardate 3157.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramasamy, Baskar INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT RE: ONS Install - my life is at an end
Oh it would only be cloudy for a couple of months, but yeah, your as_ would be dead:) -Original Message- Sent: Monday, July 16, 2001 11:52 AM To: Multiple recipients of list ORACLE-L My best advice to you is to ignore me, because I am a Stegosaurus standing in the shadow created by an enormous asteriod about to land in the ocean, creating a marine volcano, the downline effect of which will be to obliterate all sunlight on the planet for decades driving the plant life to near extinction and killing all my brethren along with me. Folks who keep up with Oracle, Web, XML, and all the other TLAs are ALOT better to follow. now, back to munching on this yummy plant frond! :) -Original Message- Sent: Sunday, July 15, 2001 1:55 AM To: Multiple recipients of list ORACLE-L hi, I am thrilled to receive a mail from you Ross coz I am a novice Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 13, 2001 8:00 PM novicedba, Thanks for your offer of assistance...I am on unix, though, and this type of install problem can be platform-specific, not to mention OS-specifici'll keep you posted. Thanks again for your offer of help. - Ross -Original Message- Sent: Friday, July 13, 2001 3:41 AM To: Multiple recipients of list ORACLE-L hi ross, My boss (well a colleague but I donno anything about the configuration and he does so he is my boss) at the place where I work has installed Names server on NT. Will it be of any help? coz I am a novice Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 13, 2001 4:16 AM Ok, so no one liked the InterMedia Question, so let's forget that one. How about this? ONS, ver817namesctl installs and builds OK, but I cannot get names (name server) to run.if i run the make manually, it claims to be missing libnon8.a Sure enough, it's not on the file system. Any one run into this? I didnot find anything on MetaRetch, and R'ing the FM did not help... Thanks in advance! - Ross -- 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: novicedba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: novicedba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
RE: A lazy connection!
I was under the impression that setting it to zero meant that the connnections would wait indefinately. Like when I was receiving end of file on communication errors setting it to 0 was suggested. KK -Original Message- Trassens Sent: Monday, July 16, 2001 11:46 AM To: Multiple recipients of list ORACLE-L I meant that if you want to use expire_time feature, you'll need to set it with a value greater than 0. Remember that the value is in minutes. F.e.: SQLNET.EXPIRE_TIME=20 .means that every twenty minute SQL*Net or Net8 polls each connection SQLNET.EXPIRE_TIME=0.means that SQL*NET or NET8 doesn't poll any connection. Is it clear ?. Regards. --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: What? What do you mean? KK -Original Message- Trassens Sent: Monday, July 16, 2001 10:18 AM To: Multiple recipients of list ORACLE-L Beware that SQLNET.EXPIRE_TIME=0 doesn't activate this feature. Is the same that set it with huge value. Regards. --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: I believe that you could try and change the settings in the sqlnet.ora file on the server side, SQLNET EXPIRE_TIME = 0. This may help:) KK -Original Message- [EMAIL PROTECTED] Sent: Monday, July 16, 2001 2:50 AM To: Multiple recipients of list ORACLE-L We have a network that have some computers with a lazy connection. Here, on these computers, we have some ORACLE users. On these computers running an application (I don't have acces to the code of this application.) When I work, sometimes, I have an ORACLE error : ORA-03114: not connected to Oracle . A ping to these computers don't show me that something is wrong. Everything is OK. This connection accept an transfer at 100 kBytes that is enough for me. The time of response for my ping is good, too (time 10 ms). I think is time of response, yet. I don't have other ideea. So, THE QUESTIN: Is there in ORACLE a setting that accept connection with lazy line? Something like a timeout settings? Thank you very much ! Marian -- 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: 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
RE: Tracing
and dont do it and try to do an upgrade(which sql_trace=true) , a simple 1 hour upgrade ran like 16 hours, had me stumped for a while, thankfully the upgrade scripts can be run multiple time with no impact :) joe [EMAIL PROTECTED] 07/16/01 12:00PM Don't do this blindly. Turning sql_trace = TRUE on for the entire database will decrease performance. And it goes without saying do NOT do this in production! Session level tracing is more appropriate. Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA -Original Message- From: Ramasamy, Baskar [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 11:46 AM To: Multiple recipients of list ORACLE-L Subject: RE: Tracing Best option would be turn on the sql_trace and timed_statistice parameter in init.ora and re-start the database. But makes ure you have enought space to write trc files in OS Baskar -Original Message- Sent: 16 July 2001 16:12 To: Multiple recipients of list ORACLE-L On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote: Hello I would like to start tracing for different session than my one. How it is possible in 8.1.7 EE? I want to start tracing for different sessions with different levels (not necessary diff. levels). I found that it should be possible with dbms_support package, but i didnt find this package and I also didnt find creation script in my rdbms/admin directory (it should be dbmssupp.sql). Please help me where I can find it or how to do it. Ivo Libal dbms_system.set_ev(sid, serial, event, level, NULL); -- Vladimir Begun | Without freedom of choice there is no http://vbegun.net/ | creativity. http://vbegun.net/wap/ | -- Kirk, "The return of the [EMAIL PROTECTED] | Archons", stardate 3157.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramasamy, Baskar INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Friend : The database will be used with : - java applications accessing - on line transactions by internet - procedures schedulled ( a lot ) - pages getting data from internet Eriovaldo From: Koivu, Lisa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Date: Mon, 16 Jul 2001 06:30:48 -0800 What's the intended use of the database, or the nature of the application that will hit this database? -Original Message- From: Eca Eca [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 9:41 AM To: Multiple recipients of list ORACLE-L Subject: Hi friends : How to calculate the parameters : Shared_pool_size, db_block_buffer, sort_area_size of Database for : 50 session simultaneous 512 MB ram Linux Regards. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Script to report rman backup
I am using rman on UNIX so I am not sure how it works for NT. The rman log will have this information. You can spool it to disk. HTH, Ruth --- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 16, 2001 11:20 AM Hi Does anyone have any scripts which reports on the backups, time taken etc?? Any help/pointers would be appreciated Rgds Fawzia ___ This message is confidential and is intended for the addressee only; unless clearly stated that this disclaimer should not apply, this e-mail is not intended to create legally binding commitments on behalf of any company in the British Interactive Broadcasting Holdings Limited group, nor do its contents reflect the corporate views or policies of any such company. Any unauthorised disclosure, use or dissemination, either whole or partial, is prohibited. If you are not the intended recipient of the message, please notify the sender immediately. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Close Implicit Cursors??
Hello , In one of our applications , we have many open implicit cursors from Oracle Applications jobs .. is there any way to close them? We are running out of the max value for opened cursor parameter in init file and we are also have some performance issue with this one !!! Any ideas ?? Cheers RK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Apps Sol INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 lazy connection!
A setting of zero tells the server to never poll the connections and verify that they are active. This allows firewalls and various other middlemen to terminate inactive connections based on the fact that there is no sql*net traffic coming through the network. By setting it to anything other that zero, it forces the connections to be polled from the server and therefore by default creates network traffic. --Michael -Original Message- Sent: Monday, July 16, 2001 12:21 PM To: Multiple recipients of list ORACLE-L I was under the impression that setting it to zero meant that the connnections would wait indefinately. Like when I was receiving end of file on communication errors setting it to 0 was suggested. KK -Original Message- Trassens Sent: Monday, July 16, 2001 11:46 AM To: Multiple recipients of list ORACLE-L I meant that if you want to use expire_time feature, you'll need to set it with a value greater than 0. Remember that the value is in minutes. F.e.: SQLNET.EXPIRE_TIME=20 .means that every twenty minute SQL*Net or Net8 polls each connection SQLNET.EXPIRE_TIME=0.means that SQL*NET or NET8 doesn't poll any connection. Is it clear ?. Regards. --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: What? What do you mean? KK -Original Message- Trassens Sent: Monday, July 16, 2001 10:18 AM To: Multiple recipients of list ORACLE-L Beware that SQLNET.EXPIRE_TIME=0 doesn't activate this feature. Is the same that set it with huge value. Regards. --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: I believe that you could try and change the settings in the sqlnet.ora file on the server side, SQLNET EXPIRE_TIME = 0. This may help:) KK -Original Message- [EMAIL PROTECTED] Sent: Monday, July 16, 2001 2:50 AM To: Multiple recipients of list ORACLE-L We have a network that have some computers with a lazy connection. Here, on these computers, we have some ORACLE users. On these computers running an application (I don't have acces to the code of this application.) When I work, sometimes, I have an ORACLE error : ORA-03114: not connected to Oracle . A ping to these computers don't show me that something is wrong. Everything is OK. This connection accept an transfer at 100 kBytes that is enough for me. The time of response for my ping is good, too (time 10 ms). I think is time of response, yet. I don't have other ideea. So, THE QUESTIN: Is there in ORACLE a setting that accept connection with lazy line? Something like a timeout settings? Thank you very much ! Marian -- 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: 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --
RE: Naming Standards - Thoughts Needed
IMHO the reason for prefixes/postfixes. Postfixes ? Agggh! Is this technical term? What's wrong with suffixes. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, July 16, 2001 2:21 AM To: Multiple recipients of list ORACLE-L IMHO the reason for prefixes/postfixes is so that dependent objects can be given a more 'natural' name, that relates it to the object it depends on. Therefore T_ is redundant because tables don't depend on anything, but V_, T_ etc _may_ not be. Similarly, in pl/sql, you often want a procedure parameter to be the value of a column on a table. You can't use the name of the column because that would cause problems in the sql statements that use the value, so the usual standard is to prefix all parameters with p_ and local variables with l_ or v_. BTW, TR_ is not generally sufficient - you may want to have more than one trigger on a table. I would use something like TAI_ = Trigger After Insert, TBIUD_ = Trigger Before Insert, Update or Delete, etc. On the underscores/capitalisation business; Oracle is generally not case-sensitive, so really you have to use underscores if you want readability. Regards David Lord -Original Message- Sent: 13 July 2001 20:21 To: Multiple recipients of list ORACLE-L Our old office used to do that as well, and I thought it was redundant. You can always look up the type in dba_objects to know what the type is. It might be worth more to keep those extra characters as part of the name. -Original Message- Sent: Friday, July 13, 2001 1:21 PM To: Multiple recipients of list ORACLE-L Hi , We use T_ for tables P_procs V_view TR_trigger F_function S_F_synonym of function - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 13, 2001 6:40 PM Were looking to develop naming standards within our organization and I am wondering what others use. Is there a formal process similiar to ofa? Do shops typically use underscores or case? (policy_number / PolicyNumber) What about abbreviating? Enforcement processes ? Other considerations? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Lord, David - CS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services--
RE: Tracing
Hello list, Following link explains all issues on sql/event10046 traces: http://www.unal-bilisim.com/products/itrprof/itrprof_user_manual.html#sql_trace 16/7/01 07:10:35, JOE TESTA [EMAIL PROTECTED] wrote: and dont do it and try to do an upgrade(which sql_trace=true) , a simple 1 hour upgrade ran like 16 hours, had me stumped for a while, thankfully the upgrade scripts can be run multiple time with no impact :) joe [EMAIL PROTECTED] 07/16/01 12:00PM Don't do this blindly. Turning sql_trace = TRUE on for the entire database will decrease performance. And it goes without saying do NOT do this in production! Session level tracing is more appropriate. Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA -Original Message- From: Ramasamy, Baskar [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 11:46 AM To:Multiple recipients of list ORACLE-L Subject: RE: Tracing Best option would be turn on the sql_trace and timed_statistice parameter in init.ora and re-start the database. But makes ure you have enought space to write trc files in OS Baskar -Original Message- Sent: 16 July 2001 16:12 To: Multiple recipients of list ORACLE-L On Jul 16, 2001 at 06:45:36AM, Libal, Ivo wrote: Hello I would like to start tracing for different session than my one. How it is possible in 8.1.7 EE? I want to start tracing for different sessions with different levels (not necessary diff. levels). I found that it should be possible with dbms_support package, but i didnt find this package and I also didnt find creation script in my rdbms/admin directory (it should be dbmssupp.sql). Please help me where I can find it or how to do it. Ivo Libal dbms_system.set_ev(sid, serial, event, level, NULL); -- Vladimir Begun | Without freedom of choice there is no http://vbegun.net/ | creativity. http://vbegun.net/wap/ | -- Kirk, The return of the [EMAIL PROTECTED]| Archons, stardate 3157.4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramasamy, Baskar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
UNIX
Is anyone familiar with how to grab space in one file system and allocate it to another? For example, if file system /u03 is at 3% and /u06 is at 80%, how can I grab space from the /u03 file system and allocate to /u06?? TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
private/public rollbacks
Hi List, Who can tell me what advantages/disadvantages of having private rollback segments versus public rollback segments? Thank you. Lyuda Hoska -- 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: 7.3.4 Support
12/31/00 -Original Message- Sent: Monday, July 16, 2001 2:00 PM To: Multiple recipients of list ORACLE-L Can anyone tell me when Oracle officially ceased providing support for 7.3.4? Thanks, Jeff T [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UNIX
It really depends on what you are trying to accomplish. You can always create a symbolic link on /u06 pointing to an item on /03. -Original Message- From: Richard Huntley [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 1:45 PM To: Multiple recipients of list ORACLE-L Subject:UNIX Is anyone familiar with how to grab space in one file system and allocate it to another? For example, if file system /u03 is at 3% and /u06 is at 80%, how can I grab space from the /u03 file system and allocate to /u06?? TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: William Rogge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
7.3.4 Support
Title: 7.3.4 Support Can anyone tell me when Oracle officially ceased providing support for 7.3.4? Thanks, Jeff T [EMAIL PROTECTED]
RE: Oracle Applications Forum
Hi Rukmini, Is there any forum or mailing list for Oracle Applications? Didn't see any replies so here you go... http://www.oaug.org/public/oaugnet/oaugnet.html for Oracle Applications (functional/technical) http://www.oaug.org/public/oaugnet/oaugnet.html for Oracle Applications DBAs Enjoy! 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).
UNIX mailx
Does any one know if it is possible to attach a file when using mailx to send an email? TIA Yigal Get free email and a permanent address at http://www.amexmail.com/?A=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yigal Ran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: private/public rollbacks
Basically public rollback segment are used on OPS. They don't need to be in init.ora and are public for all the instances. Although it can be used on non-parallel servers. I heard about bugs using it on non-OPS while I was using 7.X. However I don't know nothing about problems on 8.X. Regards. --- [EMAIL PROTECTED] wrote: Hi List, Who can tell me what advantages/disadvantages of having private rollback segments versus public rollback segments? Thank you. Lyuda Hoska -- 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:7.3.4 Support
As far as I can remember I believe they cut it off in June of last year. Sorry, I've been on 8.x since mid 99. Dick Goulet Reply Separator Author: Thomas Jeff [EMAIL PROTECTED] Date: 7/16/2001 10:00 AM Can anyone tell me when Oracle officially ceased providing support for 7.3.4? Thanks, Jeff T [EMAIL PROTECTED] !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12 TITLE7.3.4 Support/TITLE /HEAD BODY PFONT SIZE=2 FACE=Courier NewCan anyone tell me when Oracle officially ceased providing support/FONT BRFONT SIZE=2 FACE=Courier Newfor 7.3.4?/FONT /P PFONT SIZE=2 FACE=Courier NewThanks,/FONT BRFONT SIZE=2 FACE=Courier NewJeff T/FONT BRFONT SIZE=2 FACE=Courier New[EMAIL PROTECTED]/FONT /P /BODY /HTML -- 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:private/public rollbacks
Lyuda, The chief advantage of private rollback segments is that you can take them offline if/when needed. A public rollback segment is online always consequently making it impossible to get out of the way of batch processes or doing any kind of maintenance on, unless your in restricted access mode. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/16/2001 10:06 AM Hi List, Who can tell me what advantages/disadvantages of having private rollback segments versus public rollback segments? Thank you. Lyuda Hoska -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: UNIX
What are you trying to do? If you need more space in a tablespace, you can create a datafile on /u03. If you actually need additional space on /u06, you will need to manage your drives with a DISK/Volume management software such as DiskSuite on Solaris. [EMAIL PROTECTED] 07/16/01 01:45PM Is anyone familiar with how to grab space in one file system and allocate it to another? For example, if file system /u03 is at 3% and /u06 is at 80%, how can I grab space from the /u03 file system and allocate to /u06?? TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 electronic mail (e-mail) and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Personal views and opinions expressed in this communication are those of the originator and may not necessarily reflect those of O'Brien Gere and O'Brien Gere shall not be liable for any damage caused by or resulting from any such material. If you are NOT the original recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error, and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error or any objectionable material, please delete it and immediately notify [EMAIL PROTECTED] It is O'Brien Gere's policy to respect the privacy of its employees and third parties communicating with O'Brien Gere via e-mail. However, the O'Brien Gere e-mail system may not be used for any illegal purposes or for the transmission of material that is libelous, vulgar, obscene, invasive of another's privacy, unlawful, harassing, abusive, threatening, harmful, or otherwise objectionable [objectionable material]. This includes anything that may infringe on the intellectual property or rights of another. O'Brien Gere may monitor communications but is under no obligation to do so. O'Brien Gere may, in our absolute discretion, remove, block or filter any material if in our view it is objectionable material or otherwise inappropriate. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 7.3.4 Support
Dec. 31, 2000 Cherie Machler Gelco Information Network Thomas Jeff ThomasJe@tceTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: Sent by: Subject: 7.3.4 Support root@fatcity. com 07/16/01 01:00 PM Please respond to ORACLE-L Can anyone tell me when Oracle officially ceased providing support for 7.3.4? Thanks, Jeff T [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UNIX
Basically, my file system that stores the indx tablespace datafile is running out of space and I need to allocate more space in order to create a second datafile for my indexes and keep it separated from the data. -Original Message- Sent: Monday, July 16, 2001 2:15 PM To: Multiple recipients of list ORACLE-L It really depends on what you are trying to accomplish. You can always create a symbolic link on /u06 pointing to an item on /03. -Original Message- From: Richard Huntley [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 1:45 PM To: Multiple recipients of list ORACLE-L Subject:UNIX Is anyone familiar with how to grab space in one file system and allocate it to another? For example, if file system /u03 is at 3% and /u06 is at 80%, how can I grab space from the /u03 file system and allocate to /u06?? TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: William Rogge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Richard Huntley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Jobs
Hello Oracle professionals, Are there any Oracle DBA's currently looking for work in and around London, England. If so, send me a copy of your cv and I will do my best to find you the right job. We are an Oracle specialist recruitment consultancy. Regards Culum SlaterManaging DirectorCMS Global Ltd D/L: 01923 233196 M/N: 07960 113 738 [EMAIL PROTECTED] CMS Global Ltd, 39 Elizabeth House, Watford, Herts, WD24 4RE
RE: UNIX mailx
Here is a simple command: uuencode filename filename | mailx -s Here is file filename recipient -Original Message- From: Yigal Ran [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 2:46 PM To: Multiple recipients of list ORACLE-L Subject:UNIX mailx Does any one know if it is possible to attach a file when using mailx to send an email? TIA Yigal Get free email and a permanent address at http://www.amexmail.com/?A=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yigal Ran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: William Rogge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: private/public rollbacks
Public and private rollback segments are like communism and capitalism. The idea behind the public rollback segment is that any node in the cluster that needs rollback segment can use them, but they end up being too slow. The idea is good but the implementation is impractical, just like the communism -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Subject: Re:private/public rollbacks Lyuda, The chief advantage of private rollback segments is that you can take them offline if/when needed. A public rollback segment is online always consequently making it impossible to get out of the way of batch processes or doing any kind of maintenance on, unless your in restricted access mode. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/16/2001 10:06 AM Hi List, Who can tell me what advantages/disadvantages of having private rollback segments versus public rollback segments? Thank you. Lyuda Hoska -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UNIX
Rich, unless you know exactly the physical layout of the raid system, keeping data and indexes separated, well the point is moot :( joe [EMAIL PROTECTED] 07/16/01 03:30PM Basically, my file system that stores the indx tablespace datafile isrunning out of space and I need to allocate more space in order to create asecond datafile for my indexes and keep it separated from the data.-Original Message-Sent: Monday, July 16, 2001 2:15 PMTo: Multiple recipients of list ORACLE-LIt really depends on what you are trying to accomplish. You can alwayscreate a symbolic link on /u06 pointing to an item on /03.-Original Message-From: Richard Huntley [SMTP:[EMAIL PROTECTED]]Sent: Monday, July 16, 2001 1:45 PMTo: Multiple recipients of list ORACLE-LSubject: UNIXIs anyone familiar with how to grab space in one file system and allocate itto another?For example, if file system /u03 is at 3% and /u06 is at 80%, how can I grabspace from the /u03 file system and allocate to /u06??TIA,Richard Huntley-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Richard Huntley INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: William Rogge INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Richard Huntley 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).
ORA-01023 ???
Hi all, We recently upgraded a database from 815 to 816. There is a SP which runs fine in 815 through sqlplus or developer's application; it also runs fine using sqlplus in 816. But when the programmer called it through RoughWave, it shows error: [SERVERMESSAGE] ORA-01023: Cursor context not found (Invalid cursor number) Any idea? Thanks. Leslie __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OEM - SMTP (urgent)
Ajay- Try using the IP address for the mail server when asked to enter the SMTP Mail Gateway. Michael Bush Corporate Systems Database Administration www.csedge.com -Original Message- Sent: Monday, July 16, 2001 4:51 AM To: Multiple recipients of list ORACLE-L Hi, I am using OEM 2.2.3 on window NT client 4.0 service pack 3.0 and database 8.1.5. platform HP-UX 11. I already configure SMTP gateway and when I test this gateway through Preferences- Notification, the test failed. Outlook mail is working on that machine( window NT). I need help in above problem. Thanks, Ajay Singh Rathore HCL Infosystems Ltd --- visit us at www.hclinsystems.com http://www.hclinsystems.com The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail. Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment. Ajay- Try using the IP address for the mail server when asked to enter the SMTP Mail Gateway. Michael Bush Corporate Systems Database Administrationwww.csedge.com -Original Message-From: Ajay Singh Rathore [mailto:[EMAIL PROTECTED]]Sent: Monday, July 16, 2001 4:51 AMTo: Multiple recipients of list ORACLE-LSubject: OEM - SMTP (urgent) Hi, I am using OEM 2.2.3 on window NT client 4.0 service pack 3.0 and database 8.1.5. platform HP-UX 11. I already configure SMTP gateway and when I test this gateway through Preferences- Notification, the test failed.Outlook mail is working on that machine( window NT). I need help in above problem. Thanks, Ajay Singh RathoreHCL Infosystems Ltd---visit us at www.hclinsystems.com
Re: ORA-01023 ???
Leslie Lu wrote: Hi all, We recently upgraded a database from 815 to 816. There is a SP which runs fine in 815 through sqlplus or developer's application; it also runs fine using sqlplus in 816. But when the programmer called it through RoughWave, it shows error: [SERVERMESSAGE] ORA-01023: Cursor context not found (Invalid cursor number) Any idea? Thanks. Leslie IMHO wrong libraries. Check whether RoughWave doesn't reset LD_LIBRARY_PATH (or CLASS_PATH, if there is some Java involved). -- HTH, 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).
ORA-01578: ORACLE data block corrupted (file # 1, block # 13559)
This morning I got a CD full of data files from a remote client database server that went belly up. This production database (8.1.5 on NT) was put together by a group of developers with no backups setup. They sent the CD to me in hopes that I could recover the database. I laid the files down on my NT laptop and got the database up. I went to execute an export and got ORA-01578. I executed DBV against a few of the data files. The SYSTEM tablespace has 18 corrupt blocks and USERS has over 80 corrupt blocks. Just about every query against the dictionary is returning ORA-01578. For example, I get ORA-01578 when I try to figure out the object name for a corrupt block. So now I'm trying to figure out what my options are. I'm scanning books and Metalink, but I'm not finding much. Am I missing something? Help? Many TIA. Chris Oracle is not with me...today -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Analyze
Why not use DBMS_STATS? It is faster. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, July 16, 2001 9:46 AM To: Multiple recipients of list ORACLE-L I have an Analyze Schema running once a week for a 35G instance. The Analyze is taking about 9 hours. This is too long. What is the opinion on doing an Analyze on a percentage of the data? 20%? 40%? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-01023 ???
Java use CLASSPATH, not CLASS_PATH, fyi. -Original Message- Sent: Monday, July 16, 2001 5:18 PM To: Multiple recipients of list ORACLE-L Leslie Lu wrote: Hi all, We recently upgraded a database from 815 to 816. There is a SP which runs fine in 815 through sqlplus or developer's application; it also runs fine using sqlplus in 816. But when the programmer called it through RoughWave, it shows error: [SERVERMESSAGE] ORA-01023: Cursor context not found (Invalid cursor number) Any idea? Thanks. Leslie IMHO wrong libraries. Check whether RoughWave doesn't reset LD_LIBRARY_PATH (or CLASS_PATH, if there is some Java involved). -- HTH, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tobin, Elliot (FUSA) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Multiple Listeners
Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. winmail.dat
MTS - in Linux
Friends : I have the parameters below and we are receiving the message : PMON: terminating instance due to error 601 Instance terminated by PMON, pid = 11300 Load Indicator not supported by OS ! Does anyone know this error ? If i to alter all parameters MTS solve this problem ? Regards Eriovaldo BANNER Oracle8i Release 8.1.6.1.0 - Production PL/SQL Release 8.1.6.0.0 - Production CORE8.1.6.0.0 Production TNS for Linux: Version 8.1.6.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production SVRMGR show parameter mts NAMETYPEVALUE --- --- -- mts_circuitsinteger 225 mts_dispatchers string (protocol=TCP) mts_listener_addressstring mts_max_dispatchers integer 5 mts_max_servers integer 20 mts_multiple_listeners boolean FALSE mts_servers integer 1 mts_service string I001 mts_sessionsinteger 220 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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-01578: ORACLE data block corrupted (file # 1, block #
Chris, 1) Call Oracle 2) Lay out BIG $$$ 3) import dmp file they provide into new DB 4) Go to customer site, watch file laydown cold backup. 5) Kick plenty of duhveloper ^% at site. 6) Go home, down 2 6-packs of your favorite. Dick Goulet Reply Separator Author: Grabowy; Chris [EMAIL PROTECTED] Date: 7/16/2001 1:23 PM This morning I got a CD full of data files from a remote client database server that went belly up. This production database (8.1.5 on NT) was put together by a group of developers with no backups setup. They sent the CD to me in hopes that I could recover the database. I laid the files down on my NT laptop and got the database up. I went to execute an export and got ORA-01578. I executed DBV against a few of the data files. The SYSTEM tablespace has 18 corrupt blocks and USERS has over 80 corrupt blocks. Just about every query against the dictionary is returning ORA-01578. For example, I get ORA-01578 when I try to figure out the object name for a corrupt block. So now I'm trying to figure out what my options are. I'm scanning books and Metalink, but I'm not finding much. Am I missing something? Help? Many TIA. Chris Oracle is not with me...today -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DBA Manager Needed in Greater Philadelphia area..
A fast growing firm within 1/2 hour of Philadelphia in a suburban New Jersey location is looking for a DBA Manager. We are looking for someone who was a DBA and is now a strong people manager. This person will manage about 5-7 very bright DBA's who support Oracle, Sybase, and SQL Server, in a heavy development environment. This client has single digit turn over and a creative and motivated staff. There is no relocation assistance offered. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. *Requirements: The Successful candidate will have experience with at least one of the following: Oracle, Sybase, SQL Server, or Informix. This person will have managed, not led, at least 3 people in the past, and truly enjoy managing very bright technical staff. Environment includes 24/7 on call, budget management, as well as staff development. The position is open due to internal growth. Degree required. U.S. citizenship or permanent residents only. This position offers: * Opportunity to become a key member of the I.T. team * Base Salary up to 110K + excellent benefits and bonus * Challenge For immediate consideration, please send your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/NJ DBA Mgr/Fairlie We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-01578: ORACLE data block corrupted (file # 1, block # 13559)
Grabowy, Chris wrote: This morning I got a CD full of data files from a remote client database server that went belly up. This production database (8.1.5 on NT) was put together by a group of developers with no backups setup. They sent the CD to me in hopes that I could recover the database. I laid the files down on my NT laptop and got the database up. I went to execute an export and got ORA-01578. I executed DBV against a few of the data files. The SYSTEM tablespace has 18 corrupt blocks and USERS has over 80 corrupt blocks. Just about every query against the dictionary is returning ORA-01578. For example, I get ORA-01578 when I try to figure out the object name for a corrupt block. So now I'm trying to figure out what my options are. I'm scanning books and Metalink, but I'm not finding much. Am I missing something? Help? Many TIA. Chris Oracle is not with me...today If your database is worth it (i.e. if rebuilding it from scratch would be extremely costly) the only option you have is to ask for somebody form the Oracle Support to come with DUL, a tool written by one of their Dutch consultants which tries (no guarantee, even if in practice it's an effective tool) to make sense out of corrupted files and generate a .dmp or flat file for reloading what can be saved. But you will have to fork out $$$. Otherwise, but the sad state of your dictionary will probably make this very difficult, you can try so SELECT round the corrupted blocks, and try to patch the missing pieces with whatever you can retrieve from indexes. This would mean that you have a list of tables and know where indexes are. Likely to be very time consuming, with a rather dim hope to get a usable result in the end. -- 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: Multiple Listeners
It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multiple Listeners
Edward, Yes, you can setup multiple listeners. Here is an example: LISTENERDB1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1521)) ) ) ) LISTENERDB2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname.com)(PORT = 1522)) ) ) ) SID_LIST_LISTENERDB1 = (SID_LIST = (SID_DESC = (SID_NAME = DBAME1) (ORACLE_HOME = /path/to/oracle/home) ) ) SID_LIST_LISTENERDB2 = (SID_LIST = (SID_DESC = (SID_NAME = DBAME2) (ORACLE_HOME = /path/to/oracle/home) ) ) After you have set this up, you can start the listeners individually: lsnrctl start listenerdb1 lsnrctl start listenerdb2 Hope that helps... Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] (303)-858-6394 -Original Message- Carr Sent: Monday, July 16, 2001 3:42 PM To: Multiple recipients of list ORACLE-L Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Aschenbrenner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multiple Listeners
Because the more listeners you have - the better. If your damager ask you how many listeners you are running and you answer one and he/she ( no sexizm :-)) heard that someone running 2 or 3 ( from another moro... err damager) - how would you explain why you are running only one. I hope that Ross can add more reasons to run at least 2 or better 3 listeners. Alex Hillman -Original Message- Sent: Monday, July 16, 2001 6:21 PM To: Multiple recipients of list ORACLE-L It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multiple Listeners
Mladen, I can think of numerous reasons to have multiple listeners. For example, imagine a server with several databases where you sometimes wanted to restrict outside access on just one database. Meanwhile still allowing local users on that server to access that particular database. In this case restricted mode wouldn't work, and downing the listener would restrict remote access to all the databases. With multiple listeners you could shutdown the listener for just that database. Outside users would then be unable to connect, but local users would still be able to work. The other databases would continue as usual... Another example, Veritas Cluster, is the reason I use multiple listeners. You need to be able to failover the listener for just one database, not all of them! Alan -Original Message- Sent: Monday, July 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Aschenbrenner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Multiple Listeners
ED, OK, looks like you've got 2 or more servers, each supporting a single DB or are you running parallel server? I'll assume the later since that would make more sense. Therefore, set up each listener to listen for requests on it's hostname and port 1521 which is just about the standard. I'd give each listener a specific name like 'listener_node_name' so that you can have everything in one file and use only what is needed. Kinda of like Alan suggested, but with different hostnames. I think he was thinking on multiple listeners on one host, not multiple listeners on multiple hosts. Dick Goulet Reply Separator Author: Edward W. Carr [EMAIL PROTECTED] Date: 7/16/2001 2:45 PM We are running Veritas Cluster Server and need it to be able to shutdown and startup the databases individually of themselves. We have the ability to run the any of the databases on any of the servers we choose, so I can run them on individual servers or all on the same server... I need to be able to do this!!! So any helpful hints would be appreciated!!! As I am not a D.B.A. I have a BIG learning curve ahead of me ... :) I have already had excellent help from the following: Alan Aschenbrenner Charlie Mengler Thanks Guys!!! -Original Message- Mladen Sent: Monday, July 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward W. Carr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Multiple Listeners
However, to answer the question, you need to name the listeners something other then listener and you need to have them listening on different ports. When you use the lsnrctl command you have to reference the listener you are dealing with. There are reasons to have multiple listeners. For example, when running HP ServiceGuard I have setup the databases to be able to fail separately so they each have their own listener that fails with the database. I needed it with Trusted Oracle as well, but I believe that is case dependant. On listened for stuff coming from the secret side and the other from the other side. -Original Message- Sent: Monday, July 16, 2001 3:56 PM To: Multiple recipients of list ORACLE-L Edward, One must ask, what benefit do you perceive you will obtain from having multiple listeners? The listener is only there to hear the end applications request for database service and pass them along to the appropriate dedicated server or dispatcher as required. Then it goes off to do other things. We have one HP with 9 different instances, one listener. Works fine all day. Dick Goulet Reply Separator Author: Edward W. Carr [EMAIL PROTECTED] Date: 7/16/2001 1:42 PM Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Analyze
Here is the syntax I am using: execute dbms_utility.analyze_schema('PROD','COMPUTE'); Is there anything that might have made the analyze run so long? By the way, we are running 7.3.4. Ron -Original Message- Sent: Monday, July 16, 2001 5:32 PM To: Multiple recipients of list ORACLE-L Really? On our approx. 200GB production DB (8.1.6 on Win2k) DBMS_Utility.Analyze_Schema takes about an hour each morning (estimate, sample 5%). I tried DBMS_Stats.Gather_Schema_Stats with 5% sampling a few weeks ago and finally killed the thing after almost 3 hours and, if I remember correctly, much more than usual CPU utilization. I know it's the recommended tool, but how do you get better performance from DBMS_Stats? Thanks. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Spence Sent: Monday, July 16, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Why not use DBMS_STATS? It is faster. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, July 16, 2001 9:46 AM To: Multiple recipients of list ORACLE-L I have an Analyze Schema running once a week for a 35G instance. The Analyze is taking about 9 hours. This is too long. What is the opinion on doing an Analyze on a percentage of the data? 20%? 40%? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Multiple Listeners
Edward, One must ask, what benefit do you perceive you will obtain from having multiple listeners? The listener is only there to hear the end applications request for database service and pass them along to the appropriate dedicated server or dispatcher as required. Then it goes off to do other things. We have one HP with 9 different instances, one listener. Works fine all day. Dick Goulet Reply Separator Author: Edward W. Carr [EMAIL PROTECTED] Date: 7/16/2001 1:42 PM Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- 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: Analyze
Really? On our approx. 200GB production DB (8.1.6 on Win2k) DBMS_Utility.Analyze_Schema takes about an hour each morning (estimate, sample 5%). I tried DBMS_Stats.Gather_Schema_Stats with 5% sampling a few weeks ago and finally killed the thing after almost 3 hours and, if I remember correctly, much more than usual CPU utilization. I know it's the recommended tool, but how do you get better performance from DBMS_Stats? Thanks. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Spence Sent: Monday, July 16, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Why not use DBMS_STATS? It is faster. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, July 16, 2001 9:46 AM To: Multiple recipients of list ORACLE-L I have an Analyze Schema running once a week for a 35G instance. The Analyze is taking about 9 hours. This is too long. What is the opinion on doing an Analyze on a percentage of the data? 20%? 40%? Ron Smith -- 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: Multiple Listeners
We are running Veritas Cluster Server and need it to be able to shutdown and startup the databases individually of themselves. We have the ability to run the any of the databases on any of the servers we choose, so I can run them on individual servers or all on the same server... I need to be able to do this!!! So any helpful hints would be appreciated!!! As I am not a D.B.A. I have a BIG learning curve ahead of me ... :) I have already had excellent help from the following: Alan Aschenbrenner Charlie Mengler Thanks Guys!!! -Original Message- Mladen Sent: Monday, July 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward W. Carr INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multiple Listeners
If you are using external procedures, the listener for them should be different as well. The external procedures run under the authority of the user which started the listener that has the sid list entry for them. If you place the entry in the main listener and that listener is initialized by oracle, the external procedures run with the authority of the oracle OS user. Having a different listener which can be started by a less privileged account allows the external procedures to run with less authority. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Monday, July 16, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Mladen, I can think of numerous reasons to have multiple listeners. For example, imagine a server with several databases where you sometimes wanted to restrict outside access on just one database. Meanwhile still allowing local users on that server to access that particular database. In this case restricted mode wouldn't work, and downing the listener would restrict remote access to all the databases. With multiple listeners you could shutdown the listener for just that database. Outside users would then be unable to connect, but local users would still be able to work. The other databases would continue as usual... Another example, Veritas Cluster, is the reason I use multiple listeners. You need to be able to failover the listener for just one database, not all of them! Alan -Original Message- Sent: Monday, July 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Aschenbrenner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).