Re: raw devices

Title: RE: Which index need rebuilding? You are correct; drop and recreate the tablespace and don't do anything at UNIX level, as the contents of the logical volume (a.k.a. raw device) will just be overwritten... - Original Message - From: Malik, Fawzia To: Multiple

Re: raw devices

-- 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: Unix Solaris forum.

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: Transferring data from one table to another

-- 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: OPTIMIZER_MODE recommendation for 9.2

Bug #564434, logged against 7.3.3, is not "visible" on MetaLink, but it displayed a lovely row between Oracle Support (advocating the customer logging a TAR) and Oracle Development (paraphrased here): Support: Setting ALL_ROWS or FIRST_ROWS forced the use of CBO, which performs poorly

Re: Free ware databases: which are worth the money?

://jeremy.zawodny.com/mysql/managing-mysql-replication.html (there are more presentations in that directory) PostgreSQL is also worth trying, especially if you need stored procedures (MySQL doesn't have them yet). Tim. On Fri, Aug 02, 2002 at 02:33:29AM -0800, Mark Teehan wrote: Hi, we

Re: DUAL revisited

: 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: soft parse

nope, you're right on... - Original Message - From: BigP To: Multiple recipients of list ORACLE-L Sent: Friday, August 02, 2002 2:13 PM Subject: soft parse How is it possible to avoid soft parse ? When I open a cursor it is hard parsed and soft parsed

Re: DUAL revisited

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: IFILE in node-specific init file in VMS

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: Microsoft Txn Server / Locking issues

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

Re: Cluster problem - Repost

-- 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: Delete performance

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: Display all privilleges belong to user

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

Re: How to hook up x$dual

You'd need to do something likethis under the SYS account: SQL create view v_$dual 2 as 3 select dummy 4 from x$dual 5 where inst_id = userenv('INSTANCE'); View created. SQL grant select on v_$dual to public; Permission granted. SQL create public synonym

Re: Cluster problem - Repost

I think that you are pushing the app owners in exactly the right direction. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 01, 2002 5:13 PM Tim, Thanks for your reply. Basically I think that this was a mistake on someones

Re: SQL*Plus blowing up on query on V$AQ...

- Sent: Tuesday, July 30, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Tim: I take exception to the age thing here. Yes, I remember rewriting the MVS procs for Oracle's MVS implementation because they never checked to see if MPM was running in the background task manager of SDSF

Re: using stored procedures from pro*c

Title: using stored procedures from pro*c It is meaningless. PL/SQL blocks handle their own cursors within a single cursor employed by PRO*C, so the contents of "sqlca.sqlerrd[2]" are likely leftover from a previous call? You may have gotten the value you wanted in one version, but I

Re: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

, 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

OT: plot by elitists confirmed...

...from http://www.gksoft.com/a/fun/unix-c-hoax.html... Creators admit: UNIX and C Hoax! In an announcement that has stunned the computer industry, Ken Thompson, Dennis Ritchie, and Brian Kernighan admitted that the Unix operating system and C programming language created by them is an

Re: Listener Log Aging Script

: 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

Re: Explain Plan and SQL Text Length

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

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: RE: a couple of questions

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: OFF TOPIC:Be careful from www.crescent.cc company

). -- 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: Size of Oracle server processes

Tim, I think your observation is correct, every Apps logon does create two sessions. How is that affecting the size of the server process? Do you mean the size is the sum of the two sessions? In glance, most of the memory size came out of the data segment of the process. Jos --- Tim Gorman

Re: a couple of questions

. void pointers) for type re-casting too. In other words, be assured that VARIANT is not the only way to get the job done, and might prove unpopular anyway... Just my $0.02... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 17

Re: (Fwd/2)

. Sure. Whatever. Whaddya say we get back to work and talk techie stuff and quit wasting time on this fluff? signing off on thread -- 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: McCain on Larry Ellison and Corporate Responsibility / Re: OT - unix

(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: McCain on Larry Ellison and Corporate Responsibility / Re: OT - unix

, but he is not infallible and he (and his staff) can certainly be off the mark... - Original Message - To: Tim Gorman [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 15, 2002 10:49 AM unix Tim, It is my understanding that Oracle's stocks have gone up and down wildly several

Re: Size of Oracle server processes

where spid = oracleSID-processID) Plug in the PID for the server process into "oracleSID-processID" where you are seeing the large RSS. If you do get two rows back from the query, then this might be an explanation for the increased size? Hope this helps... -Tim - Origin

Re: WHICH TABLE NEED TO INCREASE FREELISTS

, 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

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: 2003 IOUG Meeting

of this is how we say it works presentations vs this is how it works out in the real world presentations IOUG has almost all user presentations, so they are more real world applicable. If I had to choose only one, it would be IOUG. --- Tim Levatich [EMAIL PROTECTED] wrote: Hi, All. Before

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: 2003 IOUG Meeting

). ~ Tim Levatich, Database Administrator Cornell Laboratory of Ornithology, 159 Sapsucker Woods Road, Ithaca, New York 14850 [EMAIL PROTECTED]phone 607-254-2113fax 607-254-2415 http://birds.cornell.eduhttp://birdsource.cornell.edu

Re: Count rows in textfile

On Wed, Jul 03, 2002 at 01:53:25AM -0800, [EMAIL PROTECTED] wrote: Try the following which will give the number of line in the file cat filename | wc -l You might find this interesting: http://www.ling.helsinki.fi/~reriksso/unix/award.html#cat :-) Tim. -- Please see the official

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

Alexandre, I beg to differ. You have assumed, in the complete absence of any information, that he has an I/O problem. He might. He also might not. He should look first, before leaping. -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday

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

leaping. -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 01, 2002 1:53 AM Ravi, Make sure you have at least 5-10 redo log groups. That's depends on your workload. You also may need to increase their size

Re: Questionable V$SQLAREA Statistics

) FROM DBA_TABLES WHERE BUFFER_POOL = 'KEEP' would give you an idea, if you've analyzed the tables recently... Hope this helps -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 01, 2002 7:27 PM The degree is 4 and it is cached via

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

, where n is 100 or less... Alternatively, if you are not using SQL*Plus, then you can change the buffer size using DBMS_OUTPUT.ENABLE(n), where n is the size... Hope this helps... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June

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

to allow the output to come out, and then compare spooled output. Nothing stops an argument faster than proof... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 29, 2002 2:08 PM Hi Tim, Thanks for the response

Re: performance

:-). Also, there are several white papers on the http://www.oraperf.com site which explain the methodology of response time analysis using the YAPP report which might help; click on the link for white papers in the left-hand navigation bar... Hope this helps... -Tim - Original Message

Re: rbs oracle data block corrupted

question before restoring over it, just out of caution. Or, if you know how, rename the datafile and restore it from backup to the new location. Either way, don't wipe out the datafile with the corruption if you can help it... Hope this helps... -Tim - Original Message - From: Nikunj

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.

Tuning NON-network client-server communication

Is there any scope for tuning NON-network client-server communication? Where the client and Oracle server are on the same machine and don't communicate via the network? Are Net8 tuning parameters like SDU size still relevant? Tim. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: Virtual drive on Solaris

eye. If I said something and he nodded, the angels sang hosannas and the sun shone brightly. If I said something and he frowned or squinted and tilted his head, I almost fell over. Absolutely nerve-wracking! Oh well, that which doesn't kill you... Thanks for the info! -Tim - Original

Re: WebLogic, Oracle JDBC related

to be installed (i.e. servlets on the app server). JDBC Thin has some nasty quirks beyond not populating V$SESSION properly. For example, if a database object or a cursor should go invalid for any reason, a thin driver cannot handle the problem as an OCI driver can... Just some food for thought... -Tim

Re: Rollback OPTIMAL setting

days. - Kirti -Original Message- Sent: Thursday, June 27, 2002 4:16 PM To: Multiple recipients of list ORACLE-L Tim, I rebuilt the rollback segments without OPTIMAL in one case because the shrinks were causing ORA-1555's at bad times. I have a procedure that is scheduled via

Re: Virtual drive on Solaris

and warn of the consequences of disabling redo logging (i.e. database corruption if not shutdown normally for any reason)... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 24, 2002 2:48 PM Hi Tim Yes, I have tried the _disable_logging

Re: Virtual drive on Solaris

Have you considered setting _DISABLE_LOGGING = TRUE instead? It could be just as disastrous... ;-) Buying an NVRAM unit would probably be more sensible, since at least then you have some probability of the file-system on such a unit surviving node failure or restart. I don't use Informatica,

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

... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 14, 2002 3:38 AM We have a AIX server with Oracle 8.1.7 installed. The language is set to ISO8859-1 English US. We want to change the language to French for testing purposes. Do

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?

the test? Thanks! -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 8:33 AM The IO buffer size is the maximal size of a single, atomic disk IO, usually either 128k or 256k. All IO requests larger

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)

(online redo logs) Hello Tim and Rachel There is band width problem. The line is 256K (we are checking upgrade to 512k). The database, during peek time produce 10MB of logs every 2-3 minutes. On this line it will take 7-8 minutes to pass 10MB if the line was dedicate and it is not dedicated

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

ually like to set OPTIMIZER_INDEX_CACHING to "90" to better reflect the real behavior of index blocks with respect to the Buffer Cache. What are the settings of these? The tables and indexes involved appear to be analyzed, because the AUTOTRACE output shows what looks like valid s

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

after the time it is established, then you'll be out of luck. Hope this helps... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 07, 2002 5:43 AM Hi , I am configuring TAF on oracle 8.1.7 (solaris). I was just wondering

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: * Oracle DBA Needed in Minnesota..

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Tim 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

, it is possible that something inside the Oracle-managed portion of PRO*C is doing the same, but if there is any presence of malloc() in their code, it is almost certainly self-inflicted. It is the first thing to check before blaming PRO*C or Oracle... Hope this helps... -Tim - Original Message

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

. Hope this helps... -Tim - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 31, 2002 1:32 PM Well, it's time to call for the cavalry. I have a table where the optimizer stubbornly insists on doing full table scans for practically every

Re: MySQL versus Oracle

is a fast moving target. August 2001 is a long time ago in it's history. For example, the InnoDB table type now supports foreign keys. Tim. -Original Message- From: Joe Testa [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 10:39 AM To: Multiple recipients of list ORACLE-L

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

<    2   3   4   5   6   7   8   9   10   11   >