_tru64_directio_disabled param Value on Digital Tru64 Unix

2002-05-26 Thread VIVEK_SHARMA
_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

8.1.7.2.0 Supported on Digital Tru64 Unix ver 5.1 ?

2002-05-26 Thread VIVEK_SHARMA
Is 8.1.7.2.0 Supported/Safe/Advisable on Digital Tru64 Unix ver 5.1 ? OR Should we Go to a Minimum of 8.1.7.2.1 ? We are Migrating our Ver 7.3 Database Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network

Re: Diagnose Slow System--OraPerf

2002-05-26 Thread Anjo Kolk
Hi Debi, The check that is performed is basically looking at the settings of log_checkpoint_interval and that is multiplied by the physical blocksize. In your case that comes to 9+GB. Setting the checkpoint interval high but the size of log file is kept small, will still cause a lot of

Re: _tru64_directio_disabled param Value on Digital Tru64 Unix

2002-05-26 Thread Anjo Kolk
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

Re: so when did you switch from NT to unix for oracle

2002-05-26 Thread Hemant K Chitale
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

Re: 8.1.7.2.0 Supported on Digital Tru64 Unix ver 5.1 ?

2002-05-26 Thread Hemant K Chitale
The 8.1.7.2.0 Patchset for Tru64 was withdrawn and replaced by the 8.1.7.2.1 Patchset. You would be applying the patchset on top of an 8.1.7.0.0 or 8.1.7.1.0 or 8.1.7.1.0B installation. 8.1.7 is certified on Tru64 5.1 Hemant K Chitale - Original Message - To: Multiple recipients of

Re: changing db name

2002-05-26 Thread Hemant K Chitale
The SID name is the ORACLE_SID value and point to the initSID.ora file. You can, at any time, shutdown the database, change the value of ORACLE_SID, rename the initSID.ora file to initnewSID.ora and restart --- voila your SID name has changed ! [You would also need to update the listener.ora for

Re: Database backup question.

2002-05-26 Thread Yechiel Adar
Title: RE: Database backup question. You missed the last one. He is PHB again. Yechiel AdarMehish - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Friday, May 24, 2002 11:43 PM Subject: RE: Database backup question.

WinXP certified: Oracle 9.x only / Re: CLARIFICATION !

2002-05-26 Thread Eric D. Pierce
I just confirmed by looking at Certifications on Metastink. You can also run 9.0 or 9.2 on Win2000, but (as Tim said:) you can't run 8.x on WinXP regards, ep On 25 May 2002 at 8:43, KENNETH JANUSZ wrote: I have 9i installed on my Dell 8200 with XP Prof. Works with no problems. Ken

Re: Diagnose Slow System--OraPerf

2002-05-26 Thread dlorraine
Aack! I don't know why, it makes more sense to me the way I said it, but I can see now my error. Here is the result of the first query...I have 20 groups with 2 members in each group! (That's not so astonishing I hope!) select thread#, group#, members, bytes/1048575 mb from v$log; THREAD#

Ora-600

2002-05-26 Thread Nalla Ravi
Can any one please point me to right search URL in metalink for ORA-600 error. Thans for your help Cheers, Ravi __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com --

Re: Diagnose Slow System--OraPerf

2002-05-26 Thread Tim Gorman
Not astonishing, but unusual and -- as it turns out -- probably unnecessary... The query against V$LOG_HISTORY reveals that you are performing anywhere from 2 to 42 log switches per day, but no higher than 15 since you raised the size from 50M to 100M. The major question here is whether the log

ORA-600

2002-05-26 Thread Nalla Ravi
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

RE: Ora-600

2002-05-26 Thread DENNIS WILLIAMS
Ravi - I'm assuming you want the ORA-600 Argument Lookup feature. It appears to be associated with Note:153788.1. I can click on the link and get the screen to appear, but it doesn't update the address part of the browser, so I don't know how to give you specific directions. If you search for

RE: Ora-600

2002-05-26 Thread Nalla Ravi
Hi Dennis, Thanks you so much I got that. Cheers, Ravi --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Ravi - I'm assuming you want the ORA-600 Argument Lookup feature. It appears to be associated with Note:153788.1. I can click on the link and get the screen to appear, but it doesn't

Re: so when did you switch from NT to unix for oracle

2002-05-26 Thread Jared Still
He! I just said we are running NT and it works, mostly. I never claimed I liked it. I would much prefer being on Solaris. Jared On Sunday 26 May 2002 09:23, 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.

Re: Diagnose Slow System--OraPerf

2002-05-26 Thread Rachel Carmichael
20 groups of redo logs IS a bit astonishing.. are you switching logs so rapidly that you loop around to the first before it is archived if you use a smaller number of groups? if nothing else, it must be a nightmare to manage! --- [EMAIL PROTECTED] wrote: Aack! I don't know why, it makes

RMAN + Legato Networker Module for Oracle

2002-05-26 Thread kminerva
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. We are using Legato Server on a different host. TIA Kepa -- __ Ota itsellesi luotettava kotimainen email http://www.jippii.fi/ Tutustu samalla netin

RE: Media Recovery needed

2002-05-26 Thread Simon Waibale
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; and that was it !! -Original Message- Sent: Sunday, May 26,

how to pick the lastes file using UTL_FILE package ?

2002-05-26 Thread Rahul
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