RE: statspack or internal routines peculiar issue!!

From: Riyaj Shamsudeen <rshamsud_at_jcpenney.com>
Date: Thu, 15 Jul 2004 13:21:19 -0500
Message-id: <005001c46a98$86a2b580$212f200a@rshamsudxp>

Hi john

No MTS neither PQ. DB restart actually fixed it though..I don't see these SQL statements in the top anymore. But, would love to hear if any listers had seen this behavior
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Kanagaraj Sent: Thursday, July 15, 2004 12:45 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: statspack or internal routines peculiar issue!!

Riyaj,

> Running this SQL from the sqlplus results in 11000 buffer gets
>approximately, with a subsecond response. Luckily, We had tracing on
>for the duration of the test and grepping through the trace file I can
>see that the above SQL was in 5 trace files with the OS PIDs: 8868,
>8872, 8874, 8876 and 8880.

Does this use MTS or PQ by any chance?

>BTW, DB is 8.1.7.4 64 bit on Solaris 8. No special options
>such as RAC..

John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is inevitable, but Discouragement is optional!

The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **
Please see the official ORACLE-L FAQ: http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
- Attached file included as plaintext by Ecartis --
- Desc: Signature

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jul 15 2004 - 13:18:10 CDT