Re: 8i to 9i upgrade of Oracle Apps database
- From: Paul Baumgartel <paul.baumgartel@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 2 Mar 2005 10:52:21 -0500
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@xxxxxxxxx> wrote:
> Our shared_pool is 320M already.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
