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

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Wed, 02 Mar 2005 11:16:56 -0500
Message-Id: <s225a0b9.069@gcrta.org>

We killed the upgrade script.  

Eliminated large_pool, mts settings in the init.ora  

Did not set event 10520  

Started u0801070 again.  

Our log file is already the same size as yesterday's which ran for 20 hours!!!  

Might be the event???  

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
>>> Paul Baumgartel <paul.baumgartel_at_gmail.com> 3/2/05 11:13:26 AM >>>

I don't see why not.

When I use this, I usually run it repeatedly to see if I can catch various waits.

Also try the following script repeatedly, and see if the numbers increase--that'll tell you that the session is actually doing something.

select vn.name, vs.value from v$statname vn, v$sesstat vs where vs.sid = &sid and vn.statistic#=vs.statistic# and vs.value != 0
and vn.name in ('consistent gets','db block changes','table scan blocks gotten',
'process last non-idle time','execute count','physical reads','session logical reads',
'sorts (rows)')
order by vn.name
/

On Wed, 02 Mar 2005 10:59:42 -0500, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org> wrote:
> can you do that while the upgrade script is running?
>
> >>> Paul Baumgartel <paul.baumgartel_at_gmail.com> 3/2/05 10:52:21 AM

>>>

>
> 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
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 02 2005 - 11:26:50 CST