Unable to cross-connect equipment. MetaSolv Solution hangs and the user's session consumes all of the CPU resources on the database server

(Doc ID 1134047.1)

Last updated on JANUARY 06, 2017

Applies to:

Oracle Communications MetaSolv Solution - Version 6.0.16 and later
Information in this document applies to any platform.
*** Reviewed September 13th, 2012 ***

Symptoms

Unable to cross-connect equipment.  MetaSolv Solution hangs and the user's session consumes all of the CPU resources on the database server.  The DBA may report the following SQL as the offending statement consuming all the CPU resources on the database.

SELECT portaddr_seq_paprev, equipment_id_paprev, portaddr_seq_paphprev,
equipment_id_paphprev,
mountpos_seq_paphprev
       from asap.hardwired_crossconnect 
       where portaddr_seq_panext = :b2 and 
             equipment_id_panext = :b1
The SQL below identifies processes consuming the highest amount of CPU resources on the database.
select p.spid "Thread ID",
       b.name "Background Process",
       s.username "User Name",
       s.machine,
       s.client_identifier "MSS User",
       s.osuser "OS User",
       s.status "STATUS",
       s.sid "Session ID",
       s.serial# "Serial No.",
       s.program "OS Program",
       sa.SQL_TEXT,sa.CPU_TIME/1000000, 
       sa.ELAPSED_TIME/1000000
from v$process p, v$bgprocess b, v$session s , v$SQL Sa
       where s.paddr = p.addr
       and b.paddr(+) = p.addr
       and s.sql_address = sa.address
       and s.sql_hash_value = sa.hash_value
       and s.status='ACTIVE'
order by sa.CPU_TIME DESC

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms