RE: New interface on Metalink to do queries ...

2003-11-12 Thread Henry Poras
nformation (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --

RE: RE: Index behavior

2003-11-06 Thread Henry Poras
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 (l

RE: RE: How do you generate primary keys?

2003-11-05 Thread Henry Poras
s area now. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message----- Henry

RE: RE: How do you generate primary keys?

2003-11-05 Thread Henry Poras
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

RE: RE: How do you genrate primary keys?

2003-11-05 Thread Henry Poras
d 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

RE: Re: explain plan conundrum

2003-11-05 Thread Henry Poras
NSUB 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.net > -- > Author: <[EMAIL PROTECTED

RE: Re: explain plan conundrum

2003-11-04 Thread Henry Poras
st, 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). -- P

RE: redhat/oracle

2003-11-04 Thread Henry Poras
ning: 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.net >> >> > > > >

RE: Finding overlapping time periods - suggestions please

2003-11-03 Thread Henry Poras
he HELP command for other information (like subscribing). > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: 10046 trace data question

2003-10-29 Thread Henry Poras
Title: Message But if that is true, shouldn't we all have about the same values (assuming the OS time is set up correctly)? tim in my trace files are really different from this value.   Henry -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Tim Fl

RE: Transportable tablespaces

2003-10-22 Thread Henry Poras
;t say you wouldn't have to export the metadata, as you do in 8i and 9i.... --- Henry Poras <[EMAIL PROTECTED]> wrote: > I don't see how this would work. You still have to move the physical > data > file to the new machine. What makes a transportable tablespace > tras

RE: Transportable tablespaces

2003-10-22 Thread Henry Poras
"Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message- Henry Poras Sent: Thursday, October 23, 2003 2:10 AM To: Multiple recipients of list ORACLE-L I don't see how this would work. You still have to move the physic

RE: Transportable tablespaces

2003-10-22 Thread Henry Poras
he official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --------

RE: CBO with Foreign Key

2003-10-17 Thread Henry Poras
child.b])}. > >> > >>This is assuming independence of field a and b. However, since they make >up > >>the PK of the parent, the denomenator is actually rows(parent) so the >actual > >>cardinality is rows(child). This causes the CBO to dramatically > >&

RE: anyone have opinions on the future of the 'grid'?

2003-10-17 Thread Henry Poras
(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.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: CBO with Foreign Key

2003-10-17 Thread Henry Poras
amatically >>underestimate the join cardinality. If this is part of a multi-table join >>the entire execution plan can be thrown way off. >> >>I would assume that since the FK constraint is part of the data dictionary, >>Oracle would find a way to use this infor

CBO with Foreign Key

2003-10-16 Thread Henry Poras
f the data dictionary, Oracle would find a way to use this information. I checked by running autotraces with and without the FK, but the plan remained unchanged. Any suggestions? Thanks. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL

RE: DB Parameters

2003-10-09 Thread Henry Poras
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.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

RE: Re: Desupport of RBO

2003-10-08 Thread Henry Poras
age 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 OR

RE: STAT from trace

2003-10-02 Thread Henry Poras
sos.com for schedule details... -Original Message- Henry Poras Sent: Wednesday, October 01, 2003 4:45 PM To: Multiple recipients of list ORACLE-L Wolfgang, I'll give level 9 a try. Yes I get PARSE, EXEC, FETCH, WAIT. My platform is AIX 5.1 For now I've run sql_trace = true and 1

RE: logg error line in unix

2003-10-02 Thread Henry Poras
ee the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: STAT from trace

2003-10-01 Thread Henry Poras
ery after the query of interest? >(something like "select 1 from dual;") STAT should be emitted when the >cursor is closed. > >Daniel > > >Henry Poras wrote: >> Thanks. I tried both disabling the trace and quitting from the session. >> No luck with 10046

RE: Did Comp die in 9.2?

2003-10-01 Thread Henry Poras
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.or

RE: STAT from trace

2003-10-01 Thread Henry Poras
traceHenry, What happens if you issue another query after the query of interest? (something like "select 1 from dual;") STAT should be emitted when the cursor is closed. Daniel   Henry Poras wrote:  Thanks. I tried both disabling the trace and quitting from the sessio

RE: STAT from trace

2003-10-01 Thread Henry Poras
: Henry Poras [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 01, 2003 9:34 AM To: Multiple recipients of list ORACLE-L Subject: STAT from trace I was creating some trace files yesterday and came across one of these problems that shows up occasionally (then I forget about it

STAT from trace

2003-10-01 Thread Henry Poras
p? Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Hi Honey I'm Home!

2003-09-25 Thread Henry Poras
g: 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.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Se

RE: what is a materilized view ?

2003-09-10 Thread Henry Poras
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.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatci

RE: Weird ORA-00060 (deadlock) with pragma autonomous transaction

2003-09-09 Thread Henry Poras
ease see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -

external procedure as not-oracle on OS

2003-09-05 Thread Henry Poras
. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and

RE: ERD to O-O

2003-08-27 Thread Henry Poras
7;) 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.net -- Author: Henry Pora

RE: [UBE?] Re: Nature of Oracle-l has changed

2003-08-27 Thread Henry Poras
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 th

Grid

2003-08-25 Thread Henry Poras
this trend (unless they mangle the concept of Grid in the process). Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Ma

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

2003-08-20 Thread Henry Poras
Title: Re: URGENT!!!  My 9i databases are not shutting down cleanly/cons sync, sync sync always reminded me of Benny Goodman.   Henry   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Tim GormanSent: Wednesday, August 20, 2003 5:04 PMTo: Multiple

RE: Multiple Datafiles and performance?

2003-08-14 Thread Henry Poras
gt; these, I suspect someone has been reading some rather discredited books... Okay, now I have an image of Tim, in a kilt, standing over a grate, with his face painted with Blue vertical stripes and a big sword strapped to his back! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

RE: what happens if a remove a job that is running?

2003-08-14 Thread Henry Poras
P command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Can't insert into partition

2003-08-14 Thread Henry Poras
VIEW > SORT GROUP BY > TABLE ACCESS FULL CASHTXNFACT > VIEW > SORT UNIQUE > NESTED LOOPS > PARTITION RANGE ITERATOR > > Query Plan >

RE: HELP! Index Debate!

2003-08-14 Thread Henry Poras
d=2 cnt=30 pid=1 pos=1 obj=100890 op='INDEX RANGE SCAN ' 33 more physical reads and 34 more logical reads than the query with all equal predicates. There are also two surprising facts in this trace - suprising at least for me: a) Oracle switches to a fast scan of the index - see

RE: Consolidating Servers

2003-08-11 Thread Henry Poras
Title: RE: Consolidating Servers David,   Can you create the clone from a production backup as a standby database? Then when it's time to switch over, just apply the last few archive logs from production, turn the clone on, and test. This way you can do most of the cloning at your convenienc

RE: Can't insert into partition

2003-08-06 Thread Henry Poras
RANGE ALL > TABLE ACCESS FULL WKLYJOBFACT > > 33 rows selected. > > > Table truncated. > > SQL> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://

RE: sar

2003-08-04 Thread Henry Poras
sage 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 offic

RE: sar

2003-08-04 Thread Henry Poras
me some details on the kind of information you would like >to >be able to collect, maybe we could set up some kind of command to obtain >it." > >Henry > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Henry Poras > IN

RE: sar

2003-07-31 Thread Henry Poras
nformation you would like to be able to collect, maybe we could set up some kind of command to obtain it." Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.

sar

2003-07-31 Thread Henry Poras
could give me some details on the kind of information you would like to be able to collect, maybe we could set up some kind of command to obtain it." Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Networ

RE: waiting for rdbms ipc reply from checkpoint

2003-07-30 Thread Henry Poras
--corresponds to > the TEMP data file > and block#=1 --some kind of header block > > Interestingly, although this combination of ts# and file# doesn't exist now, > EXEC has r=1 > > This database is a clone so it is up, but

RE: waiting for rdbms ipc reply from checkpoint

2003-07-30 Thread Henry Poras
e so it is up, but is a relative newborn. Henry -Original Message----- Henry Poras Sent: Wednesday, July 30, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Most are local (except for SYSTEM, TEMP, and a few small ones). I do have a couple of more clues. First, a quick, incomplete l

RE: Any German here ? Character set

2003-07-30 Thread Henry Poras
ELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting ser

RE: waiting for rdbms ipc reply from checkpoint

2003-07-30 Thread Henry Poras
e see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --

waiting for rdbms ipc reply from checkpoint

2003-07-30 Thread Henry Poras
nry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web h

RE: Timestamps in trace files (and other trace file oddities)

2003-07-28 Thread Henry Poras
RACLE-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.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5

RE: Timestamps in trace files (and other trace file oddities)

2003-07-24 Thread Henry Poras
d, the >same thing happens at the CPU. I doubt that all 7 minutes were CPU, most >likely there was a lot of intervening activity. All Oracle know was that it >was not waiting on something to happen internally. > > I hope I've done better the second time around. > >Da

RE: Timestamps in trace files (and other trace file oddities)

2003-07-24 Thread Henry Poras
on something to happen internally. I hope I've done better the second time around. Dan Henry Poras wrote: > > Dan, > I see what you are saying but something doesn't feel right (see, say, feel. > Should be some pun in here about not making sense). CPU time of 7 min

RE: Timestamps in trace files (and other trace file oddities)

2003-07-24 Thread Henry Poras
t event. Perhaps, the read request was issued, but the 65.6041 block was already in memory, so the read request was reissued minus that block. I'm not sure how the latch free enters into the picture, but I have a feeling that this wait is integral in the sequence of events. Dan Henry Poras

RE: Timestamps in trace files (and other trace file oddities)

2003-07-24 Thread Henry Poras
ssage 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.net -- Author: Henry Poras INET: [EMAIL

RE: Timestamps in trace files (and other trace file oddities)

2003-07-23 Thread Henry Poras
services > - > 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

RE: Here comes Oracle10G

2003-07-17 Thread Henry Poras
ROTECTED] (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:

are fast refreshes really fast?

2003-07-16 Thread Henry Poras
ood stuff. For example, the explain plans for the INSERT INTO test1_test2 inlude a view VW_NSO_1 which I can't find. No clue what that is. Hope this helps someone. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat C

RE: wierd wait event - library cache load lock

2003-07-09 Thread Henry Poras
> -Original Message- > From: Henry Poras [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 03, 2003 9:06 AM > To: Multiple recipients of list ORACLE-L > Subject: wierd wait event - library cache load lock > > > We have a PeopleSoft system (Finanacials) that is just moving i

wierd wait event - library cache load lock

2003-07-03 Thread Henry Poras
ix up 'library cache lock' with 'library cache load lock'. Don't know if the same tracking techniques work on both.). Anybody else see this before? Suggestions on what to do if it shows up again? Thanks. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.ne

RE: Good technical documents/references on tuning restores

2003-06-05 Thread Henry Poras
Title: RE: Good technical documents/references on tuning restores Paula,   IIRC 'MISSING' means it is in the data dictionary, but not the control file. I've gotten that before, but haven't played that game in a while. You might be able to 'DROP' them, but I'm not sure. Check that first on a m

RE: upgrading AIX

2003-03-20 Thread Henry Poras
'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.net -- Author: H

RE: Oracle Bug Reports...

2003-03-06 Thread Henry Poras
nclude 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.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fa

RE: Skill Sets - This may be a dumb question

2003-02-25 Thread Henry Poras
Title: Skill Sets - This may be a dumb question Lisa, I'm sorry for selfish reasons. I liked having someone else on a Peoplesoft/Oracle/AIX environment out there. As far as the new position, just change your job title to Data Architect (what does that do to your tag lines?)   Henry  

RE: Materialized views not refreshing

2003-02-25 Thread Henry Poras
(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: ht

RE: direct path read waits

2003-02-20 Thread Henry Poras
sage 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.net -- Author: Henry Poras INET: [EMAIL P

RE: lsnrctl status

2003-02-19 Thread Henry Poras
q.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --------- To REMOVE yourself from this mailing li

RE: Service startup on Windows 2000 fails

2003-02-19 Thread Henry Poras
---- 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 w

RE:

2003-02-19 Thread Henry Poras
(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:/

RE: Teradata baned from IOUG???

2003-02-18 Thread Henry Poras
hit ratio in the future. Show you why your hit ratio matters. How to analyze the hit ratio. Fallacies by those who want to sell you products and tools instead. " Henry Poras wrote: Neither is David Teplow (former president of NOUG) -Original Message-From: [E

RE: Teradata baned from IOUG???

2003-02-18 Thread Henry Poras
Neither is David Teplow (former president of NOUG) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daniel W. FinkSent: Tuesday, February 18, 2003 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata baned from IOUG???I know

RE: Teradata baned from IOUG???

2003-02-18 Thread Henry Poras
- Mailing list and web hosting services > - > 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

RE: Hanging query puzzle

2003-02-06 Thread Henry Poras
taining: 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.net -- Author: Henry Poras INET: [EMAIL PROTECTED

RE: java

2003-02-06 Thread Henry Poras
> It completed successfully (arrgh!!!) after a week of no luck. Better a week of no luck then a week of no lunch. Good luck, Stefan -Ursprüngliche Nachricht- Von: Henry Poras [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 6. Februar 2003 15:44 An: Multiple recipients of list ORACLE-L Betref

RE: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question

2003-02-06 Thread Henry Poras
Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Lisa,   When I first got to URI (8.1.7 4.3.3) timed_statistics were also set to false. I changed them to true and have had no problems with it.   I have also found that a lot of PeopleSoft setups aren't installed by experienced D

RE: Hanging query puzzle

2003-02-06 Thread Henry Poras
f 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 informat

RE: java

2003-02-06 Thread Henry Poras
runtime ? Is the correct runtime found ? Are there any issues with this particular version on AIX (like with Sun's JDK 1.3.1 on Linux for the Oracle installer) ? Are any Peoplesoft specific libraries needed ? If so, check the classpath on the machine where it works. Regards, Stefan -Ursprün

RE: Oracle Support Alert 223399.1 on Export Bug 2598387

2003-02-04 Thread Henry Poras
l ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourse

RE: Re[2]: Re[2]: Peoplesoft & Oracle

2003-01-30 Thread Henry Poras
--- >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

RE: Peoplesoft & Oracle

2003-01-28 Thread Henry Poras
ling 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.net

RE: Peoplesoft & Oracle

2003-01-28 Thread Henry Poras
Title: Peoplesoft & Oracle Welcome Lisa,   I've got PeopleSoft with 8.1.7 and AIX also (peoplesoft 8.4). It's not quite the dark side, more like Dante's Inferno. There are a number of websites and lists, but I haven't found any to be all that useful. A lot of the problems you mention arise b

java

2003-01-27 Thread Henry Poras
o me (but where does java tie in to the OS?) Sorry for the off-topic post. PG Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: unable to create stored outline for sql inside a procedure --Resolved

2002-12-26 Thread Henry Poras
--- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --

RE: Increase size of data files and rollback segments

2002-12-10 Thread Henry Poras
u 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: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Di

RE: Unix Q: Substring-ing an output.

2002-10-28 Thread Henry Poras
TED] "It is not enough to have a good mind. The main thing is to use it well." -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Networ

RE: Making a tablespace read-only - identifying blocking tx

2002-10-10 Thread Henry Poras
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://w

RE: cpu on AIX

2002-10-09 Thread Henry Poras
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

RE: cpu on AIX

2002-10-09 Thread Henry Poras
y nail down, the better. Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: ORA-472 DBWR terminated

2002-10-09 Thread Henry Poras
DY, 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: Henry Poras INET: [EMAIL PROTECTE

cpu on AIX

2002-10-09 Thread Henry Poras
re any way to track this down? Multiple applications (manned by different teams) run on the same server, and so the more I can irrefutably nail down, the better. Thanks for the help. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTE

RE: Degrade a database??

2002-09-26 Thread Henry Poras
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: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.f

RE: Oracle trace file question

2002-09-25 Thread Henry Poras
d the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Lost ofall redo logs

2002-09-23 Thread Henry Poras
.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from t

EMC and AIX resources

2002-08-12 Thread Henry Poras
I'll be starting a new job next month and consequently starting at the beginning of a learning curve for some products. Just wondering if anyone has any good resources or comments for what to watch for with AIX (most of my experience so far has been with Sun Solaris. I do know about http://b

Re: Live Webcast: The death of the buffer cache hit ratio

2002-08-04 Thread Henry Poras
gt; 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). -- Pleas

Re: Oracle Corp. move to India

2002-07-31 Thread Henry Poras
> -- > 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 yourse

Re: RE: Rant

2002-07-23 Thread Henry Poras
ssage 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 o

Re: DB copying : Attack of the Clones!

2002-07-18 Thread Henry Poras
aining: 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: Henry Poras INET: [EMAIL PROTECTED] Fat City Netwo

Re: Count rows in textfile

2002-07-03 Thread Henry Poras
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: Henry Poras INET: [E

Re: Count rows in textfile

2002-07-03 Thread Henry Poras
or other information (like subscribing). > > > ______ > Do You Yahoo!? > Sign up for SBC Yahoo! Dial - First Month Free > http://sbc.yahoo.com > -- > Please see the off

Re: the ora certified masters cert, yet again

2002-06-27 Thread Henry Poras
> > > > > Fat City Network Services-- (858) 538-5051 > > FAX: (858) 538-5051 > > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > > > &

  1   2   3   >