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,

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: [EM

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? > On

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=NOT&id=153788.1&blackframe=0 -Chris >From: Nalla Ravi <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED]

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, but Intel Corporation is winning the battle with the bean-counters and the MBAs.  In a world where CIOs seriously consider outsourcing the entire IT departmen

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: h

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 ha

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 P

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 te

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 c

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 back

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 envi

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${ORACL

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 t

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. ===

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

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

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

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 followin

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-01

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 P

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 Ser

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 ta

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: Monda

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

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.

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

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, ou

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

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,

"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 th

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

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

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. Ther

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" <[EM

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 t

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 wor

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

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 ho

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,

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

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 cli