oradebug dump processstate 10 2005-06-10 - By Radoulov, Dimitre
I didn't get that ...
If you just run the "alter ... compile" command and it hangs ...., if you
run from another session:
select
V$S.LOGON_TIME,
V$S.SID,
V$S.SERIAL#,
V$S.USERNAME,
V$S.PROCESS,
V$P.SPID,
V$S.STATUS,
V$S.MACHINE,
V$S.CLIENT_INFO
from v$session V$S,
v$process V$P
where
V$S.PADDR = V$P.ADDR
and V$S.SID in
(select distinct sid from v$access where object like upper('&obj'))
order by
V$S.PROCESS,
V$S.SID
&obj --> the object_name you're trying to compile .....
You want to see who is locking your object, or understand what is the
"parent lock" concept?
Cheers
Dimitre Radoulov
ETN?TEAM
-- -- Original Message -- --
From: "Egor Starostin" <egorst@(protected)>
To: "Dimitar Radoulov" <cichomitiko@(protected)>
Cc: <oracle-l@(protected)>
Sent: Friday, June 10, 2005 4:50 AM
Subject: Re: oradebug dump processstate 10
> I think it will be much easier to check the v$access view and find who
> is accessing the object ...
I think it will be much harder (at least to Oracle instance).
Here's the test case:
***
exec runstats_pkg.rs_start;
alter session set events 'immediate trace name hanganalyze level 2';
exec runstats_pkg.rs_middle;
select sid from v$access where object='OBJ$';
exec runstats_pkg.rs_stop;
***
And here's the extract from results:
***
[skipped]
Run1 ran in 7 hsecs
Run2 ran in 6062 hsecs
run 1 ran in .12% of the time
[skipped]
Run1 latches total versus runs -- difference and pct
Run1 Run2 Diff Pct
7,067 2,301,590 2,294,523 .31%
***
To me, v$access is only usable on idle instances.
--
Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler
--
http://www.freelists.org/webpage/oracle-l
|
|
