Re: Media Recovery needed
On 2002.05.27 02:33 Simon Waibale wrote: Hi Mladen Gogala, Thanks for your input, I did use similar approach to your suggestion save I left everthing to oracle! 1) svrmgrl 2) connect internal 3) startup mount; 4) recover automatic database; 5) alter database open; That means that all the archives were in place. I do advise you to check whether the file is in the backup mode. That is a frequent cause of alarm, usually caused by a combination of a backup script and system reboot (either crash or negligence). Trust me, I did recovery more then once. The company that I work for has so-called DR tests at Comdisco in NJ once a year. There we fully recover our systems, just as if a disaster has taken place. Our configuration is 4 HP 9000/N systems with EMC and Hyperfabric, of course with OPS. The plan is to transition to RAC within a year. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: altering next extent solved
The batchjob was doing a truncate, Thx Iain ! Jeroen -Oorspronkelijk bericht- Van: Nicoll, Iain (Calanais) [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 24 mei 2002 15:16 Aan: 'Jeroen van Sluisdam' Onderwerp: RE: altering next extent I believe that if you set the next extent then all extents after that will be set to that size (assuming pct_increase 0). However if you do truncate it removes all but the first extent and sets next extent to the size of the last extent it removed. You would either have to do truncate with the reuse storage option (drop storage is the default) or set next extent when only the initial extent exists i.e. after a truncate and before any growth. Iain Nicoll -Original Message- Sent: Friday, May 24, 2002 2:09 PM To: 'Nicoll, Iain (Calanais)' Yes there are, is that causing this problem? Thx, Jeroen -Oorspronkelijk bericht- Van: Nicoll, Iain (Calanais) [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 24 mei 2002 14:22 Aan: '[EMAIL PROTECTED]' Onderwerp: RE: altering next extent There aren't any truncates done on this table are there? Iain Nicoll -Original Message- Sent: Friday, May 24, 2002 1:08 PM To: Multiple recipients of list ORACLE-L Hi, It isn't a local managed tablespace problem because I'm still on 7.3.4 db Besides that I'm changing the table specs as far as I know this overrules the tablespace specs. New is that I created in a new attempt the table on 256K next extent then run the batch again and the storage remains on 256K. Tia, Jeroen -Oorspronkelijk bericht- Van: Rahul [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 24 mei 2002 13:18 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: altering next extent LMT ??? -- From: Jeroen van Sluisdam[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, May 24, 2002 6:03 PM To: Multiple recipients of list ORACLE-L Subject: altering next extent Hi, I have a strange phenomena. Due to sizing problems with a specific table. I changed the next extent clause with ALTER TABLE contingenten.BOEKINGEN_ADDITIONS storage ( next 256K ); Mysteriously after running the batch, it was back on 8K. Ofcourse I select before (also closing sqlplus and starting it again and selecting) and after the batch the next extent by SQL select next_extent from dba_tables where table_name = 'BOEKINGEN_ADDITIONS'; NEXT_EXTENT --- 8192 After the batch it was back on 8K. I checked the scripts and there was no alter in the script. I turned on the audit on this table and did find only records with 'session rec' in action_name What can cause the previous alter to be changed back? Tia, Jeroen Details: oracle 7.3.4 HP-UX 10.20 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--
Financials Client question
We have outsourced implementation and setup of a scaled down Oracle Applications 11i (rel 11.5.5) for Suse Linux... I have received a memo from the implementation team's application DBAs and they have informed me of a certain limitation for the specs of the client PC's. I was informed that the clients must either be Pentium 3s and below or all Pentium 4s. Mixed network of Pentium 3 and 4s will not work. I was told it was because of the JInitiator being invoked from the server. to quote: Let us further clarify that, through our proven installation/setup experience, the Shooman Application works on a network environment of mixed Pentium 3s and earlier computers. As of this writing, we have yet to prove that Shooman works properly in a network of Pentium 3 (or older) workstations mixed with Pentium 4s. However, we have proven that the application works if ALL workstations are Pentium 4s. It therefore follows that, should you purchase the latest Pentium 4 computers, you must issue ALL your Shooman users with this model in order for the system to work properly. (Shooman refers to the Oracle Application residing on a server named Shooman) I am completely ignorant of Oracle Applications as I have 0 experience in managing it. I'd really appreciate your opinion if we are being fooled or not. I am very concerned about this because as we all know PCs become obsolete in months... time will come we will have to change PCs...maybe move on to Pentium 5/6... This can pose a problem for us. Thanks a lot! -- Maria Aurora VT de la Vega OCP Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
novice learns a new thing
Hi all, I noticed something strange. Logically it makes sense but nevertheless strange. I don't know how to pur it in words. So seniors please help === SQL conn hlledw/hlledw@orcl9iConnected.SQL grant select on edw_week_lvl to scott; Grant succeeded. SQL grant select on edw_week_lvl to test1; Grant succeeded. SQL conn scott/tiger@orcl9iConnected.SQL desc hlledw.edw_week_lvlName Null? Type--- ID NOT NULL NUMBER(5)CODE NOT NULL VARCHAR2(16)DSC NOT NULL VARCHAR2(40)END_DATE NOT NULL DATETIMESPAN NOT NULL NUMBER(3) SQL conn test1/test1@orcl9iConnected.SQL desc hlledw.edw_week_lvlName Null? Type--- ID NOT NULL NUMBER(5)CODE NOT NULL VARCHAR2(16)DSC NOT NULL VARCHAR2(40)END_DATE NOT NULL DATETIMESPAN NOT NULL NUMBER(3) SQL desc scott.edw_week_lvlERROR:ORA-04043: object scott.edw_week_lvl does not exist SQL conn scott/tiger@orcl9iConnected.SQL create synonym edw_week_lvl for hlledw.edw_week_lvl; Synonym created. SQL desc edw_week_lvlName Null? Type--- ID NOT NULL NUMBER(5)CODE NOT NULL VARCHAR2(16)DSC NOT NULL VARCHAR2(40)END_DATE NOT NULL DATETIMESPAN NOT NULL NUMBER(3) SQL conn test1/test1@orcl9iConnected.SQL desc hlledw.edw_week_lvlName Null? Type--- ID NOT NULL NUMBER(5)CODE NOT NULL VARCHAR2(16)DSC NOT NULL VARCHAR2(40)END_DATE NOT NULL DATETIMESPAN NOT NULL NUMBER(3) SQL desc scott.edw_week_lvlName Null? Type--- ID NOT NULL NUMBER(5)CODE NOT NULL VARCHAR2(16)DSC NOT NULL VARCHAR2(40)END_DATE NOT NULL DATETIMESPAN NOT NULL NUMBER(3) SQL = This is all strange to me Coz I am a novice DBA Oracle Certifiable DBBS An obstacle is something you see when you take your eyes off the goal -- Anonymous
RE: _tru64_directio_disabled param Value on Digital Tru64 Unix
Anjo , List If you mean it is SAFE to set this parameter to Either Value , Thanks Are there any Guidelines to Set this Value for Best Performance ? OR Should we Simply Set it See ? The only Concern is that it is a Production Database . Thanks -Original Message- Sent: Sunday, May 26, 2002 9:48 PM To: Multiple recipients of list ORACLE-L Well, If don't want direct io set it to true, else set it to false. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, May 26, 2002 5:23 PM _tru64_directio_disabled Stands for Direct IO support Disabled Current Default Value of _tru64_directio_disabled is FALSE ? Qs What would be the SAFE Advisable to set _tru64_directio_disabled to TRUE ? Oracle 8.1.7.2 on Digital Tru64 Unix 5.1 It is a Banking (Hybrid) Application having a Load of about 2 Million OLTP Transactions in a 5 Hour Window Everyday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to pick the lastes file using UTL_FILE package ?
- Original Message - From: Rahul [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sun, 26 May 2002 22:18:18 list, the requirement is to use the UTL_FILE package on the server side to open and process the files as they are created (each hour) in a server's directory !! could anyone suggest a logic to pick up the the lastest file created in that dir. ? TIA 8.1.6 on win2k The best solution I can think of is to make the filename predictable - if it contains some time of timestamp (eg YYMMDDHH24) the Oracle side can deduce in advance from SYSDATE which file it must open. Short of that, you can have a 'utility' file in which some procedure keeps track of the latest file - Read it first, then open the actual data file. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: novice learns a new thing
A quick look showed normal behaviour. You granted as the object owner select to test1 and scott than as test1 you tried describing a scott object that scott does not own but only has select rights on thus the error. after you created the synonym scott owned an object with that name (pointing to hlldew object) so the describe worked. jack novicedba novicedba@hotmaiTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] l.com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: novice learns a new thing [EMAIL PROTECTED] 27-05-2002 10:28 Please respond to ORACLE-L Hi all, I noticed something strange. Logically it makes sense but nevertheless strange. I don't know how to pur it in words. So seniors please help === SQL conn hlledw/hlledw@orcl9i Connected. SQL grant select on edw_week_lvl to scott; Grant succeeded. SQL grant select on edw_week_lvl to test1; Grant succeeded. SQL conn scott/tiger@orcl9i Connected. SQL desc hlledw.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL conn test1/test1@orcl9i Connected. SQL desc hlledw.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL desc scott.edw_week_lvl ERROR: ORA-04043: object scott.edw_week_lvl does not exist SQL conn scott/tiger@orcl9i Connected. SQL create synonym edw_week_lvl for hlledw.edw_week_lvl; Synonym created. SQL desc edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL conn test1/test1@orcl9i Connected. SQL desc hlledw.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL desc scott.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL = This is all strange to me Coz I am a novice DBA Oracle Certifiable DBBS An obstacle is something you see when you take your eyes off the goal -- Anonymous
RE: novice learns a new thing
Ther is Nothing Strange in this. If you see the Object was owned By hlledw. You granted the Rights to Both Scott and Test but there was not Object named edw_% in these schemas. Then u Tries to describe the Object thru hlledw and that worked but when u tried to acces it thru scott it did not work because as mentioned above there was no schema object so u got an error. Now U wen into scott and created a Synonym for the hlledw object and hen there was a Object named edw% in scott and hence when u again accesed it it redirected the request to the hlledw schema and u got the result. Hope u got it. Now my $0.02 Cents I feel u should pick up a good book like Oracle 8i Complete Reference and read it from back to back. Also complement that book with the concepts manual and the books by thomas kyte -- Beginning Oracle Programming and Expert One-On-One Oracle. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Monday, May 27, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Hi all, I noticed something strange. Logically it makes sense but nevertheless strange. I don't know how to pur it in words. So seniors please help === SQL conn hlledw/hlledw@orcl9i Connected. SQL grant select on edw_week_lvl to scott; Grant succeeded. SQL grant select on edw_week_lvl to test1; Grant succeeded. SQL conn scott/tiger@orcl9i Connected. SQL desc hlledw.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL conn test1/test1@orcl9i Connected. SQL desc hlledw.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL desc scott.edw_week_lvl ERROR: ORA-04043: object scott.edw_week_lvl does not exist SQL conn scott/tiger@orcl9i Connected. SQL create synonym edw_week_lvl for hlledw.edw_week_lvl; Synonym created. SQL desc edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL conn test1/test1@orcl9i Connected. SQL desc hlledw.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL desc scott.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL = This is all strange to me Coz I am a novice DBA Oracle Certifiable DBBS An obstacle is something you see when you take your eyes off the goal -- Anonymous -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Set Timing on and DBMS_utility.get_time()
Hi List, I am really confused by the results from the DBMS_UTILITY.get_time() and set timing on in the SQL PLUS. Can anybody please explain this with an example. I gave the following in the SQL PLUS SQL Set timing on SQL Select * from emp; Elapsed: 00:00:00.08 Does this mean the command took 80 milli second or it took 800 millisecond to execute. Now I put the same select statement in a procedure and used the DBMS_utility.get_time() before executing and after executing the statement, the values I got were different. Could somebody explain this. Does these two show the result in milli second. Prem
Re: novice learns a new thing
But the interesting point is that scott never granted the privileges on the object to test1 Coz I am a NoviceDBA Oracle Certifiable DBBS An obstacle is something you see when you take your eyes off the goal -- Anonymous - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 27, 2002 2:23 PM A quick look showed normal behaviour. You granted as the object owner select to test1 and scott than as test1 you tried describing a scott object that scott does not own but only has select rights on thus the error. after you created the synonym scott owned an object with that name (pointing to hlldew object) so the describe worked. jack novicedba novicedba@hotmaiTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] l.com cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: novice learns a new thing [EMAIL PROTECTED] 27-05-2002 10:28 Please respond to ORACLE-L Hi all, I noticed something strange. Logically it makes sense but nevertheless strange. I don't know how to pur it in words. So seniors please help === SQL conn hlledw/hlledw@orcl9i Connected. SQL grant select on edw_week_lvl to scott; Grant succeeded. SQL grant select on edw_week_lvl to test1; Grant succeeded. SQL conn scott/tiger@orcl9i Connected. SQL desc hlledw.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL conn test1/test1@orcl9i Connected. SQL desc hlledw.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL desc scott.edw_week_lvl ERROR: ORA-04043: object scott.edw_week_lvl does not exist SQL conn scott/tiger@orcl9i Connected. SQL create synonym edw_week_lvl for hlledw.edw_week_lvl; Synonym created. SQL desc edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL conn test1/test1@orcl9i Connected. SQL desc hlledw.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL desc scott.edw_week_lvl NameNull?Type --- ID NOT NULL NUMBER(5) CODENOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATENOT NULL DATE TIMESPANNOT NULL NUMBER(3) SQL = This is all strange to me Coz I am a novice DBA Oracle Certifiable DBBS An obstacle is something you see when you take your eyes off the goal -- Anonymous == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van
RE: how to pick the lastes file using UTL_FILE package ?
1. Run a Cron Job that every Hour Runs the Ls command with the necessary switches to sort the file listing by the date and redirect the filename to a Flat file. 2. Run a Job In Oracle that will open that particular file and read the contents of that file and open the file mentioned therein. There are always other ways to achieve this by means of a Java Stored Proc running inside Oracle without a Cron Job. You can search for Executing external Commands inside a Procedure in http://asktom.oracle.com [Which I blv is down today] HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 Live to learn... forget... and learn again. -Original Message- Sent: Monday, May 27, 2002 10:18 AM To: Multiple recipients of list ORACLE-L list, the requirement is to use the UTL_FILE package on the server side to open and process the files as they are created (each hour) in a server's directory !! could anyone suggest a logic to pick up the the lastest file created in that dir. ? TIA 8.1.6 on win2k -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Post Migration to 8.1.7.2 from Oracle 7.3.4 on Tru64 Unix - Best Practices ??
Batch Jobs seem to be performing Slightly Slower than Before . Are there any Best practices / parameters on Digital Tru64 Unix OR 8.1.7.2 for Better Performance ? This is a Hybrid Application (Banking) doing about 3 Million OLTP Transaction Daily in a 5 Hours Window Thanks P.S. Oracle Corp Suggested setting the O.S. Parameter fifo_do_adaptive = 0 (Default = 1) in /etc/sysconfigtab on DB Server which they believe Gives Performance . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ProC problem
All, Tru64 5.1a Oracle 8.0.6.3.0 One of our developers is getting the following error when trying to compile up a program Pro*C/C++: Release 8.0.6.3.0 - Production on Fri May 24 16:27:04 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. System default option values taken from: /usr/app/oracle/product/8.0.6/precomp/admin/pcscfg.cfg Error at line 3, column 10 in file unload_d_contract_role.pc #include gflib.h .1 PCC-S-02015, unable to open include file cc -DPROC2 /user1/lib/gflib.o -O4 -fast -fp_reorder -U_FASTMATH -std1 -DOSF1 -DA_OSF -Wf,-readonly_strings -noansi_alias -D_INTRINSICS -I. -DPROC2 -I/usr/app/oracle/product/8.0.6/precomp/public -I/usr/app/oracle/product/8.0.6/rdbms/public -I/usr/app/oracle/product/8.0.6/rdbms/demo -I/usr/app/oracle/product/8.0.6/plsql/public -I/usr/app/oracle/product/8.0.6/network/public -c unload_d_contract_role.c cc: Severe: unload_d_contract_role.c, line 141: Cannot find file gflib.h specified in #include directive. (noinclfilef) #include gflib.h -^ *** Exit 1 Stop. Complete 'unload_d_contract_role' Compiled in 5 Seconds The directory where the gflib.h file lives is in the .cfg file in the $ORACLE_HOME/precomp/admin directory. Anyone have any ideas Regards Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
snapshot too old error - strange
Dear list ! There is something strange going on in my production DB. There is a program that reads fom 2 huge tables (A and B - select only) and writes a fraction of records into some third table (let's call it C - inserts only). Now , NO ONE carries a DML agains A or B . But occasionally i get the Ora-1555 - snapshot too old error during the run of the aforementioned program. Any ideas , please ? TIA DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ProC problem
The directory where the gflib.h file lives is in the .cfg file in the $ORACLE_HOME/precomp/admin directory. Anyone have any ideas Regards Lee Lee, file or directory ? I guess that the .cfg file must reference a list of files which are expected to be there. If gflib.h actually is in the precomp/admin directory (not searched by the compiler), just copy it to any of those which are (specified by the -I flag). HTH, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: snapshot too old error - strange
Title: RE: snapshot too old error - strange Increase rollback segment size for this transaction and make sure that the transaction will use the huge rollback segment hth nirmal -Original Message- From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]] Sent: Mon, May 27, 2002 15:53 To: Multiple recipients of list ORACLE-L Subject: snapshot too old error - strange Dear list ! There is something strange going on in my production DB. There is a program that reads fom 2 huge tables (A and B - select only) and writes a fraction of records into some third table (let's call it C - inserts only). Now , NO ONE carries a DML agains A or B . But occasionally i get the Ora-1555 - snapshot too old error during the run of the aforementioned program. Any ideas , please ? TIA DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Media Recovery needed
Mladen - I am curious about your disaster recovery test. I am in the process of implementing RMAN here, but management says I must continue to do cold backups until I can successfully perform a disaster recovery test using RMAN. I can't argue the point. In a realistic sense, in a real disaster, our hardware vendors have promised to make a somewhat similar system available to us. I've been trying to decide what a reasonable disaster recovery test would involve. Any insights would be appreciated. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 27, 2002 2:38 AM To: Multiple recipients of list ORACLE-L On 2002.05.27 02:33 Simon Waibale wrote: Hi Mladen Gogala, Thanks for your input, I did use similar approach to your suggestion save I left everthing to oracle! 1) svrmgrl 2) connect internal 3) startup mount; 4) recover automatic database; 5) alter database open; That means that all the archives were in place. I do advise you to check whether the file is in the backup mode. That is a frequent cause of alarm, usually caused by a combination of a backup script and system reboot (either crash or negligence). Trust me, I did recovery more then once. The company that I work for has so-called DR tests at Comdisco in NJ once a year. There we fully recover our systems, just as if a disaster has taken place. Our configuration is 4 HP 9000/N systems with EMC and Hyperfabric, of course with OPS. The plan is to transition to RAC within a year. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ProC problem
Thanks for the reply, this is the entry in the pcscfg.cfg file in the $ORACLE_HOME/precomp/admin directory. sys_include=(/user1/include,/usr/include) If I do an ls -l listing of that directory -rwxr-xr-x 1 root system 1378 Apr 3 15:45 gflib.h HELP - I am an idiot. Regards Lee -Original Message- Sent: 27 May 2002 13:58 To: Multiple recipients of list ORACLE-L The directory where the gflib.h file lives is in the .cfg file in the $ORACLE_HOME/precomp/admin directory. Anyone have any ideas Regards Lee Lee, file or directory ? I guess that the .cfg file must reference a list of files which are expected to be there. If gflib.h actually is in the precomp/admin directory (not searched by the compiler), just copy it to any of those which are (specified by the -I flag). HTH, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: _tru64_directio_disabled param Value on Digital Tru64 Unix
Vivek - I don't know if you checked Google, but the following page has some information. http://www.ixora.com.au/notes/direct_io.htm It sounds like on Tru64 5.0 this is yes by default, so you would only be setting it no. And sure I always try out new settings on the production server. That is how you get a reputation as an eXtremeDBA. Corporations like to trust their systems to live on the edge types. ;-) Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 27, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Anjo , List If you mean it is SAFE to set this parameter to Either Value , Thanks Are there any Guidelines to Set this Value for Best Performance ? OR Should we Simply Set it See ? The only Concern is that it is a Production Database . Thanks -Original Message- Sent: Sunday, May 26, 2002 9:48 PM To: Multiple recipients of list ORACLE-L Well, If don't want direct io set it to true, else set it to false. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, May 26, 2002 5:23 PM _tru64_directio_disabled Stands for Direct IO support Disabled Current Default Value of _tru64_directio_disabled is FALSE ? Qs What would be the SAFE Advisable to set _tru64_directio_disabled to TRUE ? Oracle 8.1.7.2 on Digital Tru64 Unix 5.1 It is a Banking (Hybrid) Application having a Load of about 2 Million OLTP Transactions in a 5 Hour Window Everyday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: snapshot too old error - strange
Hi Andrey, Are there any LOB columns in the tables ? I read something on Metalink about bugs on ORA-01555 messages (followed by a ORA-22924), on tables with LOBs ... HTH, Remco -Oorspronkelijk bericht- Van: Andrey Bronfin [mailto:[EMAIL PROTECTED]] Verzonden: maandag 27 mei 2002 14:53 Aan: Multiple recipients of list ORACLE-L Onderwerp: snapshot too old error - strange Dear list ! There is something strange going on in my production DB. There is a program that reads fom 2 huge tables (A and B - select only) and writes a fraction of records into some third table (let's call it C - inserts only). Now , NO ONE carries a DML agains A or B . But occasionally i get the Ora-1555 - snapshot too old error during the run of the aforementioned program. Any ideas , please ? TIA DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to pick the lastes file using UTL_FILE package ?
Rahul - Just a thought here. This would be a simple task in Unix. One idea would be to take a look at the Unix/Posix type interface packages. Another thought would be to ask this question on a W2K forum. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 27, 2002 1:18 AM To: Multiple recipients of list ORACLE-L list, the requirement is to use the UTL_FILE package on the server side to open and process the files as they are created (each hour) in a server's directory !! could anyone suggest a logic to pick up the the lastest file created in that dir. ? TIA 8.1.6 on win2k -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: snapshot too old error - strange
Check size of your rollback segs Vs the job of selecting from a big table to insert into another big table -might have to increase size of segs. -Original Message- Sent: Monday, May 27, 2002 5:03 PM To: Multiple recipients of list ORACLE-L Hi Andrey, Are there any LOB columns in the tables ? I read something on Metalink about bugs on ORA-01555 messages (followed by a ORA-22924), on tables with LOBs ... HTH, Remco -Oorspronkelijk bericht- Van: Andrey Bronfin [mailto:[EMAIL PROTECTED]] Verzonden: maandag 27 mei 2002 14:53 Aan: Multiple recipients of list ORACLE-L Onderwerp: snapshot too old error - strange Dear list ! There is something strange going on in my production DB. There is a program that reads fom 2 huge tables (A and B - select only) and writes a fraction of records into some third table (let's call it C - inserts only). Now , NO ONE carries a DML agains A or B . But occasionally i get the Ora-1555 - snapshot too old error during the run of the aforementioned program. Any ideas , please ? TIA DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Covert tnsnames.ora to OID
Hello All How can I covert all the names from tnsnames.ora to OID? I do not feel like entering all this data again, by hand, one by one. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to pick the lastes file using UTL_FILE package ?
Rahul, This isn't exactly what you're asking but, If OEM is set up: You can use the intelligent agent on win2k. Write a script that identifies the file and then calls the PL/SQL procedure. Schedule the job in OEM. Chaim Rahul [EMAIL PROTECTED]@fatcity.com on 05/27/2002 02:18:18 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: list, the requirement is to use the UTL_FILE package on the server side to open and process the files as they are created (each hour) in a server's directory !! could anyone suggest a logic to pick up the the lastest file created in that dir. ? TIA 8.1.6 on win2k -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: snapshot too old error - strange
no , no lobs. thanks ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Mon, May 27, 2002 4:03 PM To: Multiple recipients of list ORACLE-L Hi Andrey, Are there any LOB columns in the tables ? I read something on Metalink about bugs on ORA-01555 messages (followed by a ORA-22924), on tables with LOBs ... HTH, Remco -Oorspronkelijk bericht- Van: Andrey Bronfin [mailto:[EMAIL PROTECTED]] Verzonden: maandag 27 mei 2002 14:53 Aan: Multiple recipients of list ORACLE-L Onderwerp: snapshot too old error - strange Dear list ! There is something strange going on in my production DB. There is a program that reads fom 2 huge tables (A and B - select only) and writes a fraction of records into some third table (let's call it C - inserts only). Now , NO ONE carries a DML agains A or B . But occasionally i get the Ora-1555 - snapshot too old error during the run of the aforementioned program. Any ideas , please ? TIA DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: _tru64_directio_disabled param Value on Digital Tru64 Unix
Tru64 5.0 pk3 and oracle 8.1.7.2 Where can I find this parameter ( _tru64_directio_disabled ) ? It is not in V$PARAMETER Thanks Darren -Original Message- Sent: May 27, 2002 6:58 AM To: Multiple recipients of list ORACLE-L Vivek - I don't know if you checked Google, but the following page has some information. http://www.ixora.com.au/notes/direct_io.htm It sounds like on Tru64 5.0 this is yes by default, so you would only be setting it no. And sure I always try out new settings on the production server. That is how you get a reputation as an eXtremeDBA. Corporations like to trust their systems to live on the edge types. ;-) Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 27, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Anjo , List If you mean it is SAFE to set this parameter to Either Value , Thanks Are there any Guidelines to Set this Value for Best Performance ? OR Should we Simply Set it See ? The only Concern is that it is a Production Database . Thanks -Original Message- Sent: Sunday, May 26, 2002 9:48 PM To: Multiple recipients of list ORACLE-L Well, If don't want direct io set it to true, else set it to false. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, May 26, 2002 5:23 PM _tru64_directio_disabled Stands for Direct IO support Disabled Current Default Value of _tru64_directio_disabled is FALSE ? Qs What would be the SAFE Advisable to set _tru64_directio_disabled to TRUE ? Oracle 8.1.7.2 on Digital Tru64 Unix 5.1 It is a Banking (Hybrid) Application having a Load of about 2 Million OLTP Transactions in a 5 Hour Window Everyday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS 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: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to pick the lastes file using UTL_FILE package ?
Well, in that case use loader to process the file into a tmptable, and forget UTL_FILE. aRNO -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 27, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Rahul, This isn't exactly what you're asking but, If OEM is set up: You can use the intelligent agent on win2k. Write a script that identifies the file and then calls the PL/SQL procedure. Schedule the job in OEM. Chaim Rahul [EMAIL PROTECTED]@fatcity.com on 05/27/2002 02:18:18 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: list, the requirement is to use the UTL_FILE package on the server side to open and process the files as they are created (each hour) in a server's directory !! could anyone suggest a logic to pick up the the lastest file created in that dir. ? TIA 8.1.6 on win2k -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Disser, Arno INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: so when did you switch from NT to unix for oracle
Maybe it's time to provoke a bit :-). Situation: I'm sitting here in Steve Adams' house (about 7 meters away from the IxOra server, which is SO small - just like the LITTLE mermaid in Copenhagen - very disappointing), and Anjo, Cary, Jonathan and the rest have gone to bed. Whiskies available on the oak table: Bowmore and Ardbeg. Provocative Thoughts (aimed at generating discussion, please): Basically a P4 processor can run circles round a Unix processor today (in other words: Unix processors are loosing the battle). A customer today would get most bang for the buck by bying Intel instead of Unix processors. The problem, of course, is that you can only choose between Windows and Linux on the Intel platform. If - this is no longer a choice - you could choose Solaris on Intel, you would get so much bang for the buck that nothing could compete with it. If Intel could handle many processors that would be interesting, too. I think Unix processors are dying. I didn't like it when VMS died (because it's the best operating system that was ever built). But it died. Now what? Mogens Hemant K Chitale wrote: Aah ! You _are_ looking at moving out of NT.Why I don't think it is an enterprise class platform 1. Much poorer memory management [2GB, memory leaks etc]than Unix. 2. Cannot scale beyond 4 CPUs.I AM surprised that you run a 450 users SAPapplication on 4CPU, 2GB on NT. Try that withOracle Applications ! 3. Any patch (e.g. the security patches that come outfrom Microsoft) requires a reboot of the server. I canunderstand OS patches requiring a Unix reboot but apatch to MSIE/Outlook/IIS on the same NT-box as thedatabase requiring a reboot of the server ? Unacceptable. 4. I don't know how good Online Backups are on NT.Hemant K Chitalehttp://hkchital.tripod.com- Original Message -To: "Multiple recipients of list ORACLE-L" ORACLE-L@fa tcity.comSent: Saturday, 25 May, 2002 4:33 AM 1) Not pulling any legs. That's what we run.2) We have a few reasons to switch to another platform.I'm lobbying for Solaris with Veritas Database Edition. Manygood reasons for doing so, but I'm beginning to have mydoubts about financing it.One of our current projects is to put in place an enterpriseclass backup and recovery system. The current one is lackingin several respects.One of damagement's questions: "What happens if we do nothing?"Another was "What's the ROI?"PHB's abound.JaredOn Friday 24 May 2002 08:03, Hemant K Chitale wrote: No way ! You're pulling a lot of legs[and hurting a lot of egos who take pride inpointing out that NT is _not_ an enterprise-classplatform, me included].Hemant K Chitale- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Friday, 24 May, 2002 8:00 AM How about 250 Gig, 450 users on SAP 4.0B?4 Cpu's 2 Gig Ram.Stop making me defend NT!!Jared"Disser, Arno" [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]05/23/2002 10:23 AMPlease respond to ORACLE-LTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:Subject:RE: so when did you switch from NT to unix for oracle Here are my 0.02EURTurn this reasoning around: Why would anyone use NT for a serious Oracle DB-server?Okay, for some minor development perhaps, but for an productionenvironment?b.t.w., ever considered a switch to VMS?Arno Disser--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Disser, Arno 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: 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 ot her information (like subscribing). --Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Jared Still INET: [EMAIL
Re: so when did you switch from NT to unix for oracle
its not a unix processor versus intel processor, i think its more a OS decision. I run all of my stuff on intel processors, just linux not windoze :) joe Mogens Nørgaard wrote: Maybe it's time to provoke a bit :-). Situation: I'm sitting here in Steve Adams' house (about 7 meters away from the IxOra server, which is SO small - just like the LITTLE mermaid in Copenhagen - very disappointing), and Anjo, Cary, Jonathan and the rest have gone to bed. Whiskies available on the oak table: Bowmore and Ardbeg. Provocative Thoughts (aimed at generating discussion, please): Basically a P4 processor can run circles round a Unix processor today (in other words: Unix processors are loosing the battle). A customer today would get most bang for the buck by bying Intel instead of Unix processors. The problem, of course, is that you can only choose between Windows and Linux on the Intel platform. If - this is no longer a choice - you could choose Solaris on Intel, you would get so much bang for the buck that nothing could compete with it. If Intel could handle many processors that would be interesting, too. I think Unix processors are dying. I didn't like it when VMS died (because it's the best operating system that was ever built). But it died. Now what? Mogens Hemant K Chitale wrote: Aah ! You _are_ looking at moving out of NT. Why I don't think it is an enterprise class platform 1. Much poorer memory management [2GB, memory leaks etc] than Unix. 2. Cannot scale beyond 4 CPUs. I AM surprised that you run a 450 users SAP application on 4CPU, 2GB on NT. Try that with Oracle Applications ! 3. Any patch (e.g. the security patches that come out from Microsoft) requires a reboot of the server. I can understand OS patches requiring a Unix reboot but a patch to MSIE/Outlook/IIS on the same NT-box as the database requiring a reboot of the server ? Unacceptable. 4. I don't know how good Online Backups are on NT. Hemant K Chitale http://hkchital.tripod.com - Original Message - To: Multiple recipients of list ORACLE-L ORACLE-L@fa tcity.com mailto:[EMAIL PROTECTED] Sent: Saturday, 25 May, 2002 4:33 AM 1) Not pulling any legs. That's what we run. 2) We have a few reasons to switch to another platform. I'm lobbying for Solaris with Veritas Database Edition. Many good reasons for doing so, but I'm beginning to have my doubts about financing it. One of our current projects is to put in place an enterprise class backup and recovery system. The current one is lacking in several respects. One of damagement's questions: What happens if we do nothing? Another was What's the ROI? PHB's abound. Jared On Friday 24 May 2002 08:03, Hemant K Chitale wrote: No way ! You're pulling a lot of legs [and hurting a lot of egos who take pride in pointing out that NT is _not_ an enterprise-class platform, me included]. Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent: Friday, 24 May, 2002 8:00 AM How about 250 Gig, 450 users on SAP 4.0B? 4 Cpu's 2 Gig Ram. Stop making me defend NT!! Jared Disser, Arno [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 05/23/2002 10:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] cc: Subject:RE: so when did you switch from NT to unix for oracle Here are my 0.02EUR Turn this reasoning around: Why would anyone use NT for a serious Oracle DB-server? Okay, for some minor development perhaps, but for an production environment? b.t.w., ever considered a switch to VMS? Arno Disser -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Disser, Arno INET: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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] mailto:[EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
Re: RMAN + Legato Networker Module for Oracle
http://www.legato.com/products/networker/modules/oracle.cfm On Sun, May 26, 2002 at 10:08:17PM -0800, [EMAIL PROTECTED] wrote: Hello all, does anyone have a document or could you point me a link how to implement RMAN with Legato Networker Module for Oracle on UNIX/NT. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Financials Client question
Maria, The Jinitiator is an applet required by Oracle Developer's Forms Server, mainly for authentication purposes. As an applet, it is extremely sensitive to the version of the browser and Windows, but not so much the hardware. However, for someone to assert that the applet is sensitive to the version of the hardware seems suspect. Despite the proven experience claimed by these folks, I would suggest that they have less-than-perfect powers of observation, reasoning, and deduction. Confusing the importance of hardware components as opposed to software components should not build confidence. They are apparently equating Pentium 3s with one version of Windows and browser and Pentium 4s with another version of Windows and browser, when in fact there is a good deal of overlap that is possible. It would have been more helpful if they had taken the time to examine the software versions rather than the hardware, as the software versions surely matter more. ...they would not happen to be PC resellers, would they? It would explain both their orientation as well as their motivation... :-) You can find a great deal of more relevant information on MetaLink. From the front-page of MetaLink, click on the left-hand navigation button for Product Lifecycle and on that page, click the button for Certification. Then, choose from the drop-down lists to find E-Business Suite and Jinitiator, and finally choose the version of Windows you are using on the client to find the certified, supported versions of the software. The navigation in this section of MetaLink is pretty confusing, but the supported configurations and versions of Jinitiator can be found here... Please note that the type of CPU hardware is never prompted for; it is simply not a criteria. At the very least, these experts (to which your company is outsourcing a critical business function) are sufficiently vague about important technical details that you are quite correct to hesitate before believing any statements they make without some form of corroboration. Hope this helps... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 27, 2002 2:18 AM We have outsourced implementation and setup of a scaled down Oracle Applications 11i (rel 11.5.5) for Suse Linux... I have received a memo from the implementation team's application DBAs and they have informed me of a certain limitation for the specs of the client PC's. I was informed that the clients must either be Pentium 3s and below or all Pentium 4s. Mixed network of Pentium 3 and 4s will not work. I was told it was because of the JInitiator being invoked from the server. to quote: Let us further clarify that, through our proven installation/setup experience, the Shooman Application works on a network environment of mixed Pentium 3s and earlier computers. As of this writing, we have yet to prove that Shooman works properly in a network of Pentium 3 (or older) workstations mixed with Pentium 4s. However, we have proven that the application works if ALL workstations are Pentium 4s. It therefore follows that, should you purchase the latest Pentium 4 computers, you must issue ALL your Shooman users with this model in order for the system to work properly. (Shooman refers to the Oracle Application residing on a server named Shooman) I am completely ignorant of Oracle Applications as I have 0 experience in managing it. I'd really appreciate your opinion if we are being fooled or not. I am very concerned about this because as we all know PCs become obsolete in months... time will come we will have to change PCs...maybe move on to Pentium 5/6... This can pose a problem for us. Thanks a lot! -- Maria Aurora VT de la Vega OCP Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY,
Re: ProC problem
The -I directives to the cc command tell the C compiler where to find the .h (include) files. The directory in which that specified file resides is not mentioned in any of the -I directives. Either modify the pcscfg.cfg file mentioned as containing the default options to add -I${ORACLE_HOME}/precomp/admin or specify the directives some other way... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 27, 2002 4:53 AM All, Tru64 5.1a Oracle 8.0.6.3.0 One of our developers is getting the following error when trying to compile up a program Pro*C/C++: Release 8.0.6.3.0 - Production on Fri May 24 16:27:04 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. System default option values taken from: /usr/app/oracle/product/8.0.6/precomp/admin/pcscfg.cfg Error at line 3, column 10 in file unload_d_contract_role.pc #include gflib.h .1 PCC-S-02015, unable to open include file cc -DPROC2 /user1/lib/gflib.o -O4 -fast -fp_reorder -U_FASTMATH -std1 -DOSF1 -DA_OSF -Wf,-readonly_strings -noansi_alias -D_INTRINSICS -I. -DPROC2 -I/usr/app/oracle/product/8.0.6/precomp/public -I/usr/app/oracle/product/8.0.6/rdbms/public -I/usr/app/oracle/product/8.0.6/rdbms/demo -I/usr/app/oracle/product/8.0.6/plsql/public -I/usr/app/oracle/product/8.0.6/network/public -c unload_d_contract_role.c cc: Severe: unload_d_contract_role.c, line 141: Cannot find file gflib.h specified in #include directive. (noinclfilef) #include gflib.h -^ *** Exit 1 Stop. Complete 'unload_d_contract_role' Compiled in 5 Seconds The directory where the gflib.h file lives is in the .cfg file in the $ORACLE_HOME/precomp/admin directory. Anyone have any ideas Regards Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Multiple ennvironments with Portal and 9iAS
I do not have experience with them either yet ... anyway the client doesn't want to pay for more licences so we'ill install on one server and configure the tools to handle 3 environments. --- Jared Still [EMAIL PROTECTED] a écrit : Stephane, I don't have any experience with the environment you describe, but it would seem good practice to separate the dev, test and maintenance logically, even if they do have to share hardware. Jared On Friday 24 May 2002 13:33, paquette stephane wrote: Hi all, The client has a dev, test, maintenance, QA and prod environments. Each environment consist of a pipeline of several applications. QA and prod have their own independant pipelines with their own servers with Oracle 9i, Oracle 8i, Workflow, Portal and 9iAS Dev, test and maintenance shares 4 servers. We would like to have dev, test and maintenance to have their pipelines with a maximum of independance. Do you suggest to install 1 setup of Portal and 9iAS to serve the 3 environments or to install 3 copies of Portal and 9iAS ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.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).
online backup question .
I must write an online backup script for the database 8.1.7 . Are my steps below true? 1) Alter system archive log current ; 2) Alter tablespace begin backup; copy datafiles Alter tablespace end backup; FOR ALL TABLESPACES EXCEPT TEMPORARY ONES. 3) alter database backup controlfile to trace; 4) alter database backup controlfile to :\bunyamin\yedek\controlfiles\controlxxx.ctl' 5) alter system archive log current; 6) alter system switch logfile; 7) copy e:\orafiles\archivefiles\uybs\archive\*.* E:\bunyamin\yedek\archivefilesdel e:\orafiles\archivefiles\uybs\archive\*.* /q 8)copy G:\orafiles\redologfiles\UYBS\*.* E:\bunyamin\yedek\redologfiles What is the differnce between "ALTER SYSTEM SWITCH LOGFILE , ALTER SYSTEM ARCHIVE LOG CURRENT, ALTER SYSTEM ARCHIVE LOG ALL" Thank you ... Bunyamin
Re: Media Recovery needed
Well, Oxford Health Plans (the company that I work for) has a 4-way OPS cluster (HP-9000/N) which gets restored to a single class N machine. I perform database recovery using backup controlfile until cancel and then somebody from the business side verifies the number of members, providers and claims and we're done. To restore the database, we are using the tapes from our external tape storage facility. This proves that we're able to restore the service within 24 hours of alleged disaster. We're not using RMAN but a product called DB Breeze from IBM. On 2002.05.27 09:48 DENNIS WILLIAMS wrote: Mladen - I am curious about your disaster recovery test. I am in the process of implementing RMAN here, but management says I must continue to do cold backups until I can successfully perform a disaster recovery test using RMAN. I can't argue the point. In a realistic sense, in a real disaster, our hardware vendors have promised to make a somewhat similar system available to us. I've been trying to decide what a reasonable disaster recovery test would involve. Any insights would be appreciated. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 27, 2002 2:38 AM To: Multiple recipients of list ORACLE-L On 2002.05.27 02:33 Simon Waibale wrote: Hi Mladen Gogala, Thanks for your input, I did use similar approach to your suggestion save I left everthing to oracle! 1) svrmgrl 2) connect internal 3) startup mount; 4) recover automatic database; 5) alter database open; That means that all the archives were in place. I do advise you to check whether the file is in the backup mode. That is a frequent cause of alarm, usually caused by a combination of a backup script and system reboot (either crash or negligence). Trust me, I did recovery more then once. The company that I work for has so-called DR tests at Comdisco in NJ once a year. There we fully recover our systems, just as if a disaster has taken place. Our configuration is 4 HP 9000/N systems with EMC and Hyperfabric, of course with OPS. The plan is to transition to RAC within a year. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS 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). -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PREVIOUS SQL statement
Hi Guys, I was wondering if someone could help me I'm trying to create an AFTER SERVERERROR trigger that will log all errors and the SQL that caused the error. Here's what I have so far CREATE OR REPLACE TRIGGER server_error_trig AFTER SERVERERROR ON DATABASE DECLARE text varchar2(1000); BEGIN select sql_text into text from v$session a , v$sql b where a.audsid = sys_context('USERENV','SESSIONID') and a.prev_sql_addr = b.address; INSERT INTO server_error_log VALUES(ora_sysevent, ora_login_user, SYS_CONTEXT('USERENV','OS_USER'), SYS_CONTEXT('USERENV','CLIENT_INFO'), sysdate, ora_server_error(1), dbms_utility.format_error_stack, text); END; my problem seems to be if I select * from v$session I can see my prev_sql_addr. BUT If I do this select prev_sql_addr from v$session where AUDSID = sys_context('USERENV','SESSIONID'); it returns 00 could someone try the sql above and tell me if works for you. I'm running 8.1.7.3
Re: Financials Client question
Actually, there have been (in the past) several issues where Java-ish things have problems with the Pentium 4 processor. Most notably: Note: 178050.1 Jinitiator will not install on Pentium 4 (IV) systems Note: 145839.1 Oracle Apps 11i not supported on MS Windows NT/2000 with Pentium 4 Note: 136038.1 ALERT: Win NT/2000 - 9iAS v.1.0.2.2.1 Unsupported on Pentium 4 Note: 132884.1 Unable to run Jinitiator 1.1.8.3 on Pentium 4 machines I believe that most of these issues may have been addressed, however, if you are going to have Pentium 4 clients in your environment, I recommend that you make yourself familiar with these issues and test on a few machines before you order the bulk of them. It is my understanding that there may still exist issues with the Pentium 4 chip as it relates to *SERVER* side deployments. (i.e. 9iAS on Win NT/2K and 11i on Win NT/2K servers). So, as always, proceed with caution. If you have doubts/concerns, it is always best to log a TAR and get support to help resolve your fears... -- James Tim Gorman wrote: Maria, The Jinitiator is an applet required by Oracle Developer's Forms Server, mainly for authentication purposes. As an applet, it is extremely sensitive to the version of the browser and Windows, but not so much the hardware. However, for someone to assert that the applet is sensitive to the version of the hardware seems suspect. Despite the proven experience claimed by these folks, I would suggest that they have less-than-perfect powers of observation, reasoning, and deduction. Confusing the importance of hardware components as opposed to software components should not build confidence. They are apparently equating Pentium 3s with one version of Windows and browser and Pentium 4s with another version of Windows and browser, when in fact there is a good deal of overlap that is possible. It would have been more helpful if they had taken the time to examine the software versions rather than the hardware, as the software versions surely matter more. ...they would not happen to be PC resellers, would they? It would explain both their orientation as well as their motivation... :-) You can find a great deal of more relevant information on MetaLink. From the front-page of MetaLink, click on the left-hand navigation button for Product Lifecycle and on that page, click the button for Certification. Then, choose from the drop-down lists to find E-Business Suite and Jinitiator, and finally choose the version of Windows you are using on the client to find the certified, supported versions of the software. The navigation in this section of MetaLink is pretty confusing, but the supported configurations and versions of Jinitiator can be found here... Please note that the type of CPU hardware is never prompted for; it is simply not a criteria. At the very least, these experts (to which your company is outsourcing a critical business function) are sufficiently vague about important technical details that you are quite correct to hesitate before believing any statements they make without some form of corroboration. Hope this helps... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 27, 2002 2:18 AM We have outsourced implementation and setup of a scaled down Oracle Applications 11i (rel 11.5.5) for Suse Linux... I have received a memo from the implementation team's application DBAs and they have informed me of a certain limitation for the specs of the client PC's. I was informed that the clients must either be Pentium 3s and below or all Pentium 4s. Mixed network of Pentium 3 and 4s will not work. I was told it was because of the JInitiator being invoked from the server. to quote: Let us further clarify that, through our proven installation/setup experience, the Shooman Application works on a network environment of mixed Pentium 3s and earlier computers. As of this writing, we have yet to prove that Shooman works properly in a network of Pentium 3 (or older) workstations mixed with Pentium 4s. However, we have proven that the application works if ALL workstations are Pentium 4s. It therefore follows that, should you purchase the latest Pentium 4 computers, you must issue ALL your Shooman users with this model in order for the system to work properly. (Shooman refers to the Oracle Application residing on a server named Shooman) I am completely ignorant of Oracle Applications as I have 0 experience in managing it. I'd really appreciate your opinion if we are being fooled or not. I am very concerned about this because as we all know PCs become obsolete in months... time will come we will have to change PCs...maybe move on to Pentium 5/6... This can pose a problem for us. Thanks a lot! -- Maria Aurora VT de la Vega OCP Database Specialist
Re: PREVIOUS SQL statement
David, I have tried to get the previous SQL on a number of versions and I have always found the address and hash value pretty buggy - usually the same as the current SQL. Moreover, SQL statements which have failed are usually pretty hard to catch (no mention in V$SQLAREA, for what I know). I have not used everything which follows in the context of an error-trapping handler, but I have obtained interesting results in another context. Oracle9 has a new function similar to ora_sysevent and the like which returns the statement which has fired a trigger;the documentation seems to imply that it's only available with DDL/Event triggers but in fact it works everywhere (Joe, take note). This is unfortunately not available with 8.1.7 but by toying around you can write yours. Look around V$SQL_CURSOR with the FLAG = 76 condition in your trigger, then join in on V$SQL using the PARENT_HANDLE column (which should match ADDRESS). Unfortunately you must make it an external join because CREATE and DROP statements (at least - I have not made an exhaustive check yet) do not appear at all as such in V$SQL (however, TRUNCATE and ALTER statements do). However, you can circumvate this with the functions which return operation/object type/object owner/object name - if not the actual statement, it should help you find what has gone wrong (once again, if it works with an AFTER SERVERERROR trigger - I have done it with an ON DDL trigger). Also, beware that some DDL statements such as ALTER TABLE ... ADD CONSTRAINT ... PRIMARY KEY ... degenerate into TWO statements (alter + create unique index). Hoping it doesn't sound like Greek to you ... Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: snapshot too old error - strange
2 huge tables A and B Now , NO ONE carries a DML agains A or B. If no one ever does DML against those two tables, how did they end up having so many rows? Do you run large batch update or insert operations against these tables from time to time? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: so when did you switch from NT to unix for oracle
OK, I'll bite... A P4 can run circles around an Alpha? I think not... The Intel processors are not winning the technical battle, butIntel Corporation iswinning the battle with the bean-counters and the MBAs. In a world where CIOs seriously consider outsourcing the entire IT department of their company at every turn, what Intel is doing is using similar logic to convince its competitors that resistance is futile, and why not let us build your processors for you? If technical prowess and long-term company viability were even a consideration at Compaq as opposed to showing near-term benefits to the financial bottom-line, would the Alpha product line have been sold to Intel? Since that company wasconsidering acquisitionby another that had already decided to scuttle it's own PA-RISC chip, what factors would you think influenced that decision? Is it a coincidence that the Alpha sale to Intel was announcedsome 60 daysbefore the Compaq sale to HP? Are the Alpha, PA-RISC, and PowerPC chips being scuttled because Intel chips are better, orbecauseIntel chipsarejust nearlygoodenough?Have these manufacturers (Compaq, HP, and IBM)been convinced that the emphasis on differentiation between CPUs is "so 20th century", and why not focus on other things? Like finding other creative ways to squeeze worker productivity higher and make one's company more attractive to buyout... Whoops! Better stop now... - Original Message - From: Mogens Nørgaard To: Multiple recipients of list ORACLE-L Sent: Monday, May 27, 2002 11:18 AM Subject: Re: so when did you switch from NT to unix for oracle Maybe it's time to provoke a bit :-). Situation: I'm sitting here in Steve Adams' house (about 7 meters away from the IxOra server, which is SO small - just like the LITTLE mermaid in Copenhagen - very disappointing), and Anjo, Cary, Jonathan and the rest have gone to bed. Whiskies available on the oak table: Bowmore and Ardbeg. Provocative Thoughts (aimed at generating discussion, please): Basically a P4 processor can run circles round a Unix processor today (in other words: Unix processors are loosing the battle). A customer today would get most bang for the buck by bying Intel instead of Unix processors. The problem, of course, is that you can only choose between Windows and Linux on the Intel platform. If - this is no longer a choice - you could choose Solaris on Intel, you would get so much bang for the buck that nothing could compete with it. If Intel could handle many processors that would be interesting, too.I think Unix processors are dying. I didn't like it when VMS died (because it's the best operating system that was ever built). But it died. Now what?MogensHemant K Chitale wrote: Aah ! You _are_ looking at moving out of NT.Why I don't think it is an enterprise class platform 1. Much poorer memory management [2GB, memory leaks etc]than Unix. 2. Cannot scale beyond 4 CPUs.I AM surprised that you run a 450 users SAPapplication on 4CPU, 2GB on NT. Try that withOracle Applications ! 3. Any patch (e.g. the security patches that come outfrom Microsoft) requires a reboot of the server. I canunderstand OS patches requiring a Unix reboot but apatch to MSIE/Outlook/IIS on the same NT-box as thedatabase requiring a reboot of the server ? Unacceptable. 4. I don't know how good Online Backups are on NT.Hemant K Chitalehttp://hkchital.tripod.com- Original Message -To: "Multiple recipients of list ORACLE-L" ORACLE-L@fa tcity.comSent: Saturday, 25 May, 2002 4:33 AM 1) Not pulling any legs. That's what we run.2) We have a few reasons to switch to another platform.I'm lobbying for Solaris with Veritas Database Edition. Manygood reasons for doing so, but I'm beginning to have mydoubts about financing it.One of our current projects is to put in place an enterpriseclass backup and recovery system. The current one is lackingin several respects.One of damagement's questions: "What happens if we do nothing?"Another was "What's the ROI?"PHB's abound.JaredOn Friday 24 May 2002 08:03, Hemant K Chitale wrote: No way ! You're pulling a lot of legs[and hurting a lot of egos who take pride inpointing out that NT is _not_ an enterprise-classplatform, me included].Hemant K Chitale- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Friday, 24 May, 2002 8:00 AM How about 250 Gig, 450 users on SAP 4.0B?4 Cpu's 2 Gig Ram.Stop making me defend NT!!Jared"Disser, Arno" [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]05/23/2002 10:23 AMPlease respond to ORACLE-LTo: Multiple recipients of list ORACLE-L[EMAIL PROTECTED] cc:fororacle Here are my 0.02EURTurn this reasoning around: Why would anyone use NT for a seriousOracle DB-server?Okay, for some minor development perhaps, but for an productionenvironment?b.t.w., ever considered a
Re: ORA-600
When I found the ORA 600 form, I opened the frame in its own window and bookmarked the URL. No need to look up the associated note first. http://metalink.oracle.com/metalink/plsql/showdoc?db=NOTid=153788.1blackframe=0 -Chris From: Nalla Ravi [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ORA-600 Date: Sun, 26 May 2002 12:28:19 -0800 Hi All, Can any one please point me to right URL for ORA-600 error search in Metalink. Thanks for your help. Ravi. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris McGrail INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: snapshot too old error - strange
Greg Moore wrote: 2 huge tables A and B Now , NO ONE carries a DML agains A or B. If no one ever does DML against those two tables, how did they end up having so many rows? Do you run large batch update or insert operations against these tables from time to time? One additional thought : no trigger referring to A and/or B on the updated table ? -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SAN Implementation
Hello Group / Guru's Anyone has White Paper on SAN, it Implementation especially with ORACLE ?? Any thought, personal experience with pros and cons will be highly appreciated. TIA Enlighten Me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nikunj Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: _tru64_directio_disabled param Value on Digital Tru64 Unix
_tru64_directio_disabled is an NON-Documented Tru64 Unix Specific parameter To get List of ALL (Documented NON-Documented) parameters :- set echo on spool parm1 select a.ksppinm Parameter, a.ksppdesc Description, b.ksppstvl Session Value, c.ksppstvl Instance Value from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and a.ksppinm like '/_%' escape '/' / spool off -Original Message- Sent: Monday, May 27, 2002 10:38 PM To: Multiple recipients of list ORACLE-L Tru64 5.0 pk3 and oracle 8.1.7.2 Where can I find this parameter ( _tru64_directio_disabled ) ? It is not in V$PARAMETER Thanks Darren -Original Message- Sent: May 27, 2002 6:58 AM To: Multiple recipients of list ORACLE-L Vivek - I don't know if you checked Google, but the following page has some information. http://www.ixora.com.au/notes/direct_io.htm It sounds like on Tru64 5.0 this is yes by default, so you would only be setting it no. And sure I always try out new settings on the production server. That is how you get a reputation as an eXtremeDBA. Corporations like to trust their systems to live on the edge types. ;-) Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 27, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Anjo , List If you mean it is SAFE to set this parameter to Either Value , Thanks Are there any Guidelines to Set this Value for Best Performance ? OR Should we Simply Set it See ? The only Concern is that it is a Production Database . Thanks -Original Message- Sent: Sunday, May 26, 2002 9:48 PM To: Multiple recipients of list ORACLE-L Well, If don't want direct io set it to true, else set it to false. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, May 26, 2002 5:23 PM _tru64_directio_disabled Stands for Direct IO support Disabled Current Default Value of _tru64_directio_disabled is FALSE ? Qs What would be the SAFE Advisable to set _tru64_directio_disabled to TRUE ? Oracle 8.1.7.2 on Digital Tru64 Unix 5.1 It is a Banking (Hybrid) Application having a Load of about 2 Million OLTP Transactions in a 5 Hour Window Everyday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS 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: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).