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 MARCH 29, 2019
Applies to:
Oracle Communications MetaSolv Solution - Version 6.0.16 and laterInformation in this document applies to any platform.
*** Reviewed 28-MAR-2019 ***
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
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
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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |