Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 8i to 9i upgrade of Oracle Apps database

Re: 8i to 9i upgrade of Oracle Apps database

From: Paul Baumgartel <paul.baumgartel_at_gmail.com>
Date: Wed, 2 Mar 2005 10:52:21 -0500
Message-ID: <f8c4771050302075237a70531@mail.gmail.com>


Have you queried v$session_wait? Identify the process SID, then try this:

set pages 999 verify off
col event format a40
col p1text format a30 newline
col p2text format a30
col p3text format a30
col p1raw format a8
col p2text newline
col p2raw format a8
col p3text newline
col p3raw format a8
col sql_text format a78 newline
col username newline
select event
,seq#
,P1TEXT
,P1
,P1RAW
,P2TEXT
,P2
,P2RAW
,P3TEXT
,P3
,P3RAW
,sql_text
,s.username
,wait_time
,seconds_in_wait
,state

from v$session s
,v$session_wait w
,v$sqlarea sa

where s.sql_address = sa.address

and s.sql_hash_value = sa.hash_value
and w.sid = s.sid
and s.sid = &sid

/

On Wed, 02 Mar 2005 09:35:36 -0500, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote:
> Our shared_pool is 320M already.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 02 2005 - 10:55:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US