Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to capture information to analyze high load peak?
Comments embedded.
AnySQL (d.c.b.a) wrote:
> I also wrote some tool, otop and opmon, I like otop, and using it now
> to find and resolve problems, and I want to enhance it.
>
> http://www.anysql.net/en/otop.html
> http://www.anysql.net/en/opmon.html
>
> My tool always catch SQL in statspack, but statspack never catch SQL in
> my tool.
Were your 'tool' to actually work I could verify this, however it fails to run on Solaris10 and on Windows XP Professional:
C:\sun>otop_win32_trial -s *******
ERROR: OCIServerAttach()
/export/home/oracle> ./otop_solaris_trial -S ******
ld.so.1: otop_solaris_trial: fatal:
/oraunix/app/oracle/product/9.2.0/lib/libclntsh.so: wrong ELF class:
ELFCLASS64
Killed
The opmon trial behaves in exactly the same way:
/export/home/oracle> ./opmon_solaris_trial -S *******
ld.so.1: opmon_solaris_trial: fatal:
/oraunix/app/oracle/product/9.2.0/lib/libclntsh.so: wrong ELF class:
ELFCLASS64
Killed
>
> And I found STATSPACK cannot be used to analyze the load peak.
>From my experience neither can your 'tool', but then it can't be used
for anything as it doesn't execute.
David Fitzjarrell Received on Wed Sep 07 2005 - 21:10:54 CDT