Re: sequential reads/scattered reads

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

Re: How to calculate table size in 8i

Regarding this question, I like to use the following story... One day, the king ordered that a census be taken. He wanted to know how much money he could expect to collect in taxes. He called together all the dukes and duchesses in the kingdom and ordered them each to count

Re: What is the point to use alter database rename file command?

If you don't mind SHUTDOWN and then STARTUP NOMOUNT in order to run CREATE CONTROLFILE, then the methods are pretty much equivalent. Often, though, uptime requirements don't permit that luxury... If you are using RMAN with NOCATALOG, then CREATE CONTROLFILE candestroy some valuable

Re: LogMiner errors

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

Re: Count rows in textfile

ORACLE-L (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

Re: system event waits

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

Re: performance

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

Re: Remove numbers from string

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

Re: Twin City OUG Meeting

Yup.Talking aboutusing STATSPACK with Oracle Apps... - Original Message - From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Monday, July 01, 2002 7:48 AM Subject: Twin City OUG Meeting Is anyone on this list going to attend the TCOUG

Re: performance

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

Re: Questionable V$SQLAREA Statistics

, include a line containing: UNSUB ORACLE-L (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

Re: ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

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

Re: ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

, but that is not the point,here developers question is why it is working in other database? (sure they haven't set anything over there) thanks, ravi --- Tim Gorman [EMAIL PROTECTED] wrote: Ravi, The DBMS_OUTPUT package stores all output from PUT_LINE commands into a buffer, and this error indicates you

Re: performance

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

Re: rbs oracle data block corrupted

Atul, Using "_OFFLINE_ROLLBACK_SEGMENTS" or "_CORRUPTED_ROLLBACK_SEGMENTS" might allow you to open the database, but there is an almost absolutecertainty that you will hopelessly corrupt thedata in the database in doing so. So this is not a solution, this is the absolutevery LAST resort.

Re: Rollback OPTIMAL setting

I personally prefer to have it set, but I think the reasoning against setting it has to do with allowing rollback segments to "find themselves"... :-) In other words, it is based on the idea that space allocation (and deallocation) for rollback segment extents is unnecessary and harmful.

Re: Virtual drive on Solaris

(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

Re: WebLogic, Oracle JDBC related

: 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

Re: Rollback OPTIMAL setting

(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

Re: Virtual drive on Solaris

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

Re: I/O contention with external process reading the oracle logs (online redo logs)

with external process reading the oracle logs (online redo logs) My experience is that they do nothing for free. -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of "Tim Gorman" [EMAIL PROTECTED] Sent: Thursday, June 13, 2002 9:23 PM To: Multiple

Re: SunOS 5.8 I/O buffer size?

\01BAFF486.., 10485760) = 10485760 0.1074 write(4, \0\00386\0\0A0\01BAFF486.., 10485760) = 10485760 But isn't this a moot point - I'm pretty sure SSTIOMAX is fixed at 1M for all 'current' Oracle versions Cheers Connor --- Tim Gorman [EMAIL PROTECTED] wrote: Carmen et al, Did some

Re: change Language on server after Oracle install

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

Re: Oracle DB2 DBA Needed in Nebraska (near Colorado border)

: UNSUB ORACLE-L (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

Re: Init.ora and Config.ora

I always thought it was for separating instance-specific parameters from database-specific parameters in an OPS environment. At least, that's one place where it is very useful to have separate files. Of course, it was a matter of style whether "config.ora" was the database-level one or

Re: Memory utilization

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

Re: I/O contention with external process reading the oracle logs (online redo logs)

tenance, rbs segment maintenance, etc. But you are right to point out (so right) that a multi-row update by a single SQL on the source results in individual updates on the target. That's a little nugget that the marketing folks left out of their 30% claim. Tony -Original Message-

Re: Wait event problems

BODY, include a line containing: UNSUB ORACLE-L (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

Re: SunOS 5.8 I/O buffer size?

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

Re: 8.1.7 7.3.4 on one listener?

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

Re: partial restore of a database

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

Re: buffer cache - and an empty v_$BH

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

Re: I/O contention with external process reading the oracle logs (online redo logs)

, which generates SQL statements to be applied and allows the database to be open and active. --- Tim Gorman [EMAIL PROTECTED] wrote: why wouldn't you consider simply using the standby database feature? do you need the remote site to support users also? - Original Message

Re: buffer cache

The X$BH table is a view into the Buffer Cache which has a column OBJ which can be joined to the OBJ$ table (a.k.a. DBA_OBJECTS view) via the column DATAOBJ# (a.k.a. column DATA_OBJECT_ID in DBA_OBJECTS). But for rollback segments, the OBJ column needs some special treatment, so I wouldn't

Re: OEM

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

Re: I/O contention with external process reading the oracle logs (online redo logs)

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

Re: Horrendous Execution Plan from CBO

Mark, What were the elapsed times for each run? You show the AUTOTRACE, but did you have SET TIMING ON? Some notes: The CBO plan isn't so horrendous (although the elapsed times would be useful to either validate or negate that statement). The total logical reads were about 66,000

Re: Why is Parallel Query Running after upgrading to 8.1.7.2

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

Re: Oracle DBA with 8i through 11i Experience Needed in Columbus,

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

Re: TAF

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

Re: Who should I buy Oracle software from?

') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

Re: Archiving in OPS

If I understand you correctly, you are referring to "RAW" EMC storage as the shared storage array accessible from all nodes in the cluster, while "local" is local storage that is only accessible from the node to which it is directly attached? If so, then putting the tablespaces on that

Re: is this a valid scenario?

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

Re: * Oracle DBA Needed in Minnesota..

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

Re: More parses than eecutes

') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

Re: Production Database Open Fails after Mount

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

Re: Problem on shadow process

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

Re: Jr.DBA, Mid level DBA, Sr.DBA

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

Re: Stubborn Table

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

Re: Wait time for SQL*Net message

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

Re: Bind Variable values

') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

Re: tkprof analysis

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

Re: updated rows count

containing: UNSUB ORACLE-L (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

Re: How do I parse information from a Column

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

Re: updated rows count

(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

Re: probem using ROWNUM and ORDER BY clause together

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

Re: storage parameters

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

Re: ad-hoc update check

containing: UNSUB ORACLE-L (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

Fw: storage parameters

a line containing: UNSUB ORACLE-L (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

Re: storage parameters

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

Re: Senior DBA position - Dublin, Ireland

ORACLE-L (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

Re: Parallel degrees in DBMS_STATS

: UNSUB ORACLE-L (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

Re: Financials Client question

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

Re: ProC problem

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

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

Re: Diagnose Slow System--OraPerf

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

Re: CLARIFICATION !

') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

Re: Diagnose Slow System

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

Re: Diagnose Slow System

containing: UNSUB ORACLE-L (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

Re: Diagnose Slow System--OraPerf

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

Re: Statistical sampling and representative stats collection

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

Re: TEST

a bad thing to do!) that you were trying to test some thing (a program?) using the ORACLE-L email list as a guinea pig for your experiments. Again, my apologies... - Original Message - From: RAJESH DAYAL To: 'Tim Gorman' Sent: Friday, May 24, 2002 12:55 AM Subject: RE

Re: Oracle Parallel Server

Thisanswer (i.e. "can't write a dynamic hotbackup script for raw disk") is untrue. You would just use the same techniques (i.e. query the data dictionary to generate a shell script) as you would with any other type of datafile... Also, you do not need to "put tablespaces into backup mode

Re: Diagnose Slow System

, 2002 6:53 AM Tim, I'm curious why you say that utlbstat/utlestat should be run from svrmgrl and not sqlplus. I've not heard/read that before. Cherie Machler Oracle DBA Gelco Information Network Tim Gorman Tim@SageLogix To: Multiple

Re: Oracle Parallel Server

: Friday, May 24, 2002 8:48 AM Subject: Re: Oracle Parallel Server ## (i.e. "can't write a dynamic hotbackup script for raw disk") is untrue. Ok but in the case when datafile uses symbolic link point to raw device then how this could work? -Jalil Tim Gorman [EMAIL

Re: Oracle Parallel Server

Try "dd if=/dev/rdsk/x | compress -c /dev/rmt/0" or something like that if you want to compress your backups of "raw" devices using the standard UNIX "dd" utility. However, Oracle Support has always been leery about the use of "compress" for backups, with regards to possible corruption

Re: Oracle Application Consultants - Austin, TX

because they use vans instead of airplanes? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 23, 2002 7:23 AM if travel is 100% why does it matter WHERE you are local to? --- Tim Gorman [EMAIL PROTECTED] wrote: ...and you have

Re: ADMIN: Warning: Your address may have been harvested by a spammer.

(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

Re: Diagnose Slow System

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

Re: Standby DB with Oracle Standard Edition

Works great, but you cannot use the new Oracle8i standby database functionality, such as automatic file shipping and automated apply. Just have to do it "the old way"... - Original Message - From: Ravindra To: Multiple recipients of list ORACLE-L Sent: Thursday,

Re: Database backup question.

Trang, Theoretically, the online redo log filesare be necessary, but the world has a habit of making a shambles of the theoretical.Let's say, in the event that you automate your Friday script, you'llprobably come to realize that SHUTDOWN IMMEDIATE is far from perfect (as well as far from

Re: oracle FTPserver

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

Re: oracle FTPserver

Ouch! It's updates.oracle.com... sorry... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 22, 2002 12:08 PM On Wed, May 22, 2002 at 09:14:49AM -0800, Tim Gorman wrote: For downloading patches found on http://metalink.oracle.com

Re: newbie seeks career direction: become a DBA or DEVELOPER?

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

Re: Oracle Application Consultants - Austin, TX

(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

Re: 9i r2

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

Re: ORA-2085

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

Re: Upgrade and it says it doesn't need it

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

Re: SQL Server to Oracle DB

Title: SQL Server to Oracle DB ...speaking of $0.02, make sure that the utilityfrom SQL Server that produces the "flat" file does not perform unsolicited rounding of numerics. I was recently burned on a Sybase-Oracle conversion when the BCP (a.k.a. "bulk copy") and ISQL (a.k.a. SQL*Plus in

Re: wait event trace file formatter?

, include a line containing: UNSUB ORACLE-L (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

Re: Microsoft Transaction Server Standby database problem

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

Re: Upgrade and it says it doesn't need it

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

Re: Microsoft Transaction Server Standby database problem

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

Re: Can a database go down because of too few locks?

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

Re: Compressing Export Dumps / WinZip

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

Re: Compressing Export Dumps / WinZip

spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

Re: ora-04031 and x$ksmlru

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

Re: Dedicated Server versus Shared Server

? Jared Tim Gorman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/15/2002 09:58 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Dedicated Server versus Shared Server multiplexing architecture

Re: Re[2]: Dedicated Server versus Shared Server

PROTECTED] Date: 5/16/2002 10:05 AM Tim, If I understood this correctly, you are saying that a DBMS_LOCK.SLEEP(600) call would tie up an MTS shared server for 10 minutes causing other sessions connected to it to hang for 10 minutes? Jared Tim Gorman [EMAIL PROTECTED] Sent by: [EMAIL

Re: How to translate PL/SQL to C

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

<    1   2   3   4   5   6   7   >