RE: wierd wait event - library cache load lock

2003-07-03 Thread John Clarke

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
<>

RE: INDEX REBUILD

2003-06-19 Thread John Clarke

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
<>

RE: buffer busy waits, unique index, p3=1?

2003-06-07 Thread John Clarke

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
<>

buffer busy waits, unique index, p3=1?

2003-06-06 Thread John Clarke
Today on a busy production system I saw dozens of sessions waiting on buffer busy 
waits events.  p1 and p2 from v$session_wait were the same and mapped to one of our 
very large unique indexes on a large table.
 
For all but one of the sessions, p3=130.  Using Metalink and Steve Adams's website, it 
seems p3=130 means that "the block is being read by another session and no other 
suitable block image was found, so we wait until the read 
is completed, a buffer cache deadlock, or the kernel can't get a buffer in a 
certain amount of time and assumes a deadlock".
 
For the single, non-p3-130 session, p3=1. 
 
I killed the session where p3=1 (it shouldn't have been running anyway) and things 
went back to normal quickly.  My question - what does it mean when p3=1 on buffer busy 
waits for an index?  
 
I must be looking in the wrong documentation, but I can't find the answer anywhere.
 
Thanks.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Clarke
  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 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 (like subscribing).


RE: Quick Question of APPS DBA

2003-06-05 Thread John Clarke
Or $AR_TOP/$APPLLOG, if $APPLCSF is unset.  If $APPLCSF is set, $APPLCSF/$APPLLOG.
 
- John

-Original Message- 
From: Nelson, Allan [mailto:[EMAIL PROTECTED] 
Sent: Wed 6/4/2003 10:50 AM 
To: Multiple recipients of list ORACLE-L 
Cc: 
Subject: RE: Quick Question of APPS DBA



If this is a regular CONCSUB job and your stuff is in default spots then
look at $APPL_TOP/admin//log

Allan

-Original Message-
Sent: Tuesday, June 03, 2003 10:00 PM
To: Multiple recipients of list ORACLE-L


Any APPS DBAs out there?

I need to know where to find the argltp log file. (AR to GL transfer
process log file)

Thanks.

=)

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Maria Aurora de la Vega
  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 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 (like subscribing).



__
This email is intended solely for the person or entity to which it is 
addressed and may contain confidential and/or privileged information.  Copying, 
forwarding or distributing this message by persons or entities other than the 
addressee is prohibited. If you have received this email in error, please contact the 
sender immediately and delete the material from any computer.  This email may have 
been monitored for policy compliance.  [021216]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nelson, Allan
  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 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 (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Clarke
  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 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 (like subscribing).



RE: Datafile Resize Question

2003-03-02 Thread John Clarke
Apologies - when I use MS Web Outlook, I can't change the mail format from rich text 
to plan text, so it attaches the winmail.dat garbage.

Are your tablespaces, by any chance, locally managed with a large uniform extent size? 
 I don't believe you can shrink the size of a datafile smaller than the uniform extent 
size of the tablespace when it's locally managed.

If the size of your files, after moving all segments elsewhere, is about equal to the 
uniform extent size of the tablespace, this could be your answer.

-Original Message-
Dennis
Sent: Sunday, March 02, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L


John -
Your E-mail came to me as unreadable. If you have an answer to this, can you
send plain text ?

Thanks!

Dennis

-Original Message-
Sent: Sunday, March 02, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Meng, Dennis
  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 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 (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Clarke
  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 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 (like subscribing).



RE: Datafile Resize Question

2003-03-02 Thread John Clarke

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
<>

RE: LIBRARY CACHE LOCK !!!! ( SQL Tuning )

2003-02-25 Thread John Clarke
ther 0 nor 1 records, something is terribly 
wrong
 ELSE
:g_return_code := 4;
RAISE e_invalid_row_count;

 END IF;

  EXCEPTION
 WHEN OTHERS THEN
:g_return_code := 5;
DBMS_OUTPUT.PUT_LINE(SQLERRM);
DBMS_OUTPUT.PUT_LINE('Record ignored for store ' ||
v_row.store_id || ' sku ' ||
  v_row.product_id || '.');
  END;

   END LOOP;
   :g_return_code := 0;

END;
/
EXIT :g_return_code





***


***


***

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Reddy, Madhusudana
  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 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 (like subscribing).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Reddy, Madhusudana
  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 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 (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Clarke
  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 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 (like subscribing).



RE: urgent: lots of db file sequential read

2003-02-25 Thread John Clarke
What's the average time/wait, since adding devices?

I think you should focus on time/event, not count/event.

Thanks.

-Original Message-
Sent: Tuesday, February 25, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L

hi, friends:
  My db server has one poor t3(raid5, 256M Cache) and it is rather slow
in disk io.
  This night, I added a second T3(256M Cache,Raid10) to the database and
moved half of datafiles to the second raid.
  But it seems from statspack, IO wait is more than before:

StatisticTotal   per Secondper
Trans
-  

CPU used by this session66,663 23.5
8.2
CPU used when call started  66,692 23.5
8.2

  
---
db file sequential read   225,846  178,026
93.03
log file sync   8,6044,167
2.18
log file parallel write 8,6653,593
1.88
db file parallel write7682,455
1.28

now:  66 cpu used /178 cpu waited.
But with the old configuration,  cpu used vs cpu waited is like:
old:  7832 cpu used / 17508 cpu waited


  
---
db file sequential read10,164,408   17,508,898
83.50
db file parallel write 46,1301,072,257
5.11
enqueue90,498  854,241
4.07

StatisticTotal   per Secondper
Trans
-  

CPU used by this session 7,832,321167.4
9.5
CPU used when call started   7,832,333167.4
9.5

  These snapshot are from different time and different time lengh, but I
think after i added a disk array to disk array, IO wait should slowdown,
but from the new statspack, relatively more time is spent on io wait?
  How to explain this?
  Thanks.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: chao_ping
  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 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 (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Clarke
  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 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 (like subscribing).



what does "BUFFER (SORT)" operation mean?

2003-02-24 Thread John Clarke

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.
<>

RE: Error pinning PKS in shared pool

2003-02-23 Thread John Clarke
Title: Message









You can take out the “exec immediate”,
I believe.

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ramon
E. Estevez
Sent: Sunday, February 23, 2003
2:59 PM
To: Multiple recipients of list
ORACLE-L
Subject: Error pinning PKS in
shared pool 

 



Sorry, new DB and hadn't execute
the Dbmspool.sql script. 





 





CREATE OR REPLACE TRIGGER
PAQUETES_MEMORIA
    AFTER STARTUP ON DATABASE
  BEGIN
 exec immediate dbms_shared_pool.keep('DBMS_ALERT');
 exec immediate dbms_shared_pool.keep('DBMS_DDL');
 exec immediate dbms_shared_pool.keep('DBMS_DESCRIBE');
 exec immediate dbms_shared_pool.keep('DBMS_LOCK');
 exec immediate dbms_shared_pool.keep('DBMS_OUTPUT');
 exec immediate dbms_shared_pool.keep('DBMS_PIPE');
 exec immediate dbms_shared_pool.keep('DBMS_SESSION');
 exec immediate
dbms_shared_pool.keep('DBMS_SHARED_POOL');
 exec immediate dbms_shared_pool.keep('DBMS_STANDARD');
 exec immediate dbms_shared_pool.keep('DBMS_UTILITY');
 exec immediate dbms_shared_pool.keep('STANDARD');
 exec immediate
dbms_shared_pool.keep('BUSCA_SECUENCIA');
END;





 





I am getting this error, tried
with users SYS and SYSTEM





 





12/11    PLS-00103:
Encountered the symbol "DBMS_SHARED_POOL" when
 expecting one of the
following:
 := . ( @ % ;





tia





 





 



Ramon E.
Estevez

[EMAIL PROTECTED]

809-565-3121



 










RE: Top 10 DBA Do's and Don'ts anyone

2003-02-23 Thread John Clarke
I would say that one of the more important "Do's" is "Do understand
details about your O/S and storage system".  For example, I think every
DBA should be able to map data files back to physical devices,
regardless of the storage vendor (EMC, Hitachi, etc).  When you look at
I/O statistics from v$filestat, sar -d, or whatever, it's good to
understand what the I/O actually means, at a controller/disk drive
level.  Good DBAs shouldn't consider anything a Black Box.

-Original Message-
Freeman
Sent: Sunday, February 23, 2003 11:19 AM
To: Multiple recipients of list ORACLE-L

Ahhh well, I will look it over but I wouldn't want to plagiarize
from
you Rachel.

RF

-Original Message-
Carmichael
Sent: Sunday, February 23, 2003 6:24 AM
To: Multiple recipients of list ORACLE-L


for the don'ts you could just read my paper "how not to be a DBA, the
top 20 mistakes" which I gave at IOUG last year


--- Freeman Robert - IL <[EMAIL PROTECTED]> wrote:
> I'm collecting up a list of the top 10 do's and don'ts for DBA's
> for a little article I'm doing. Anyone want to provide their list or
> part of
> it?
>
> RF
>
> Robert G. Freeman
> Technical Management Consultant
> TUSC - The Oracle Experts www.tusc.com
> 904.708.5076 Cell (It's everywhere that I am!)
> Author of several books you can find on Amazon.com!
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Freeman Robert - IL
>   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 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 (like subscribing).
>


__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
--
Please see the 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
-
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 the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robert Freeman
  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 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 (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Clarke
  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 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 (like subscribing).



recursive calls and DBMS_JOB

2003-02-21 Thread John Clarke
I'm trying to isolate high CPU consumers in a stressed application, and have noticed 
that I'm spending a lot of time doing recursive calls.  Specifically, a high 
percentage of recursive calls and recursive CPU usage come from the following 
anonymous block:
 
DECLARE job BINARY INTEGER :=job; next_date .
 
My question is this:  Are the recursive cpu/call stats that are accumulating a result 
of the procedures scheduled within DBMS_JOB (there are a handful of these procedures), 
or is this likely due to DBMS_JOB (and whatever logic it uses to keep itself doing 
what it should) itself?
 
Thanks
 
John Clarke
Oracle DBA
Centroid Systems, Inc
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Clarke
  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 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 (like subscribing).




RE: 11i cloning help needed

2003-02-16 Thread John Clarke
Before cloning, you can create a temp table as select * from fnd_user
and fnd_user_resp_groups where creation_date > (the date since last
clone). 

Once the db is cloned, you can import this temp table and insert into
the main tables with this data.

If new users and responsibility groups had been added to your production
database since the last clone, you'll have issues with unique ID columns
that are populated using an index.  So, your re-insert program will have
to have some logic in it to account for this.  I think the best way to
design your re-insert program is to turn trace on in "test" as you
create a new user - the contents of the trace file should shed light on
the logic Oracle uses on the form.

Hope this helps.

-Original Message-
sreenivasa
Sent: Sunday, February 16, 2003 5:04 AM
To: Multiple recipients of list ORACLE-L

Hi DBA's

Need some help in post cloning.

DB: 8i
OS: SOlaris 2.8
Apps: 11i

Every sunday my test database 
(including TOPs (APPL_TOP and other tops)) 
is refreshed with production (cloned). It is 11i
(11.5.5)

When it is refreshed, I am loosing my newly created
users and their responsibilities etc.

I want to retain them in my test instance. I guess, I
would take some tables export before cloning and
import them into test instance after cloning.

But I am not clear which tables I have to take export.

Can someone guide me, how to do this and what tables
to use in this process ?

Thanks in advance,
Srinivas

__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: kommareddy sreenivasa
  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 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 (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Clarke
  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 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 (like subscribing).




RE: Optimizer help, get query to run as good as with RULE hint

2003-02-15 Thread John Clarke
E.LOCATION_ID
> >   6  AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
> >   7  AND NVL(ACCT_SITE.ORG_ID,-99) = NVL(LOC_ASSIGN.ORG_ID,-99)
> >   8* ;
> >
> >   Id  Par   Pos  Ins Plan
> >   - 
> > --
> > 
> >0   SELECT STATEMENT (hint: rule)
> >10 1  SORT(aggregate)
> >21 1NESTED LOOPS
> >32 1  NESTED LOOPS
> >43 1NESTED LOOPS
> >54 14 TABLE ACCESS (analyzed)  AR
> > HZ_LOC_ASSIGNMENTS (full)
> >64 2  INDEX (analyzed) UNIQUE AR
> > HZ_LOCATIONS_U1 (unique scan)
> >73 22   TABLE ACCESS (analyzed)  AR
> > HZ_PARTY_SITES (by index rowid)
> >87 1  INDEX (analyzed) NON-UNIQUE
> > AR HZ_PARTY_SITES_N2 (range scan)
> >92 25 TABLE ACCESS (analyzed)  AR
> > HZ_CUST_ACCT_SITES_ALL (by index rowid)
> >   109 1INDEX (analyzed) NON-UNIQUE AR
> > HZ_CUST_ACCT_SITES_N1 (range scan)
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Glenn Travis
> >   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 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 (like subscribing).
-- 
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
-
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 the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Clarke
  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 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 (like subscribing).




RE: Ora-00600 fun

2003-02-14 Thread John Clarke


The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.

<>

RE: update slow and EJB timesout

2003-02-13 Thread John Clarke


The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.

<>