UTLBSTAT/UTLESTAT

Hi

For the record I'm running version 7.3.2.2 on Solaris 2.6. Following some performance problems recently when using import/export I decided to run the Oracle UTLBSTAT/UTLESTAT scripts to generate some stats on my system. I've been following the advice given in Kevin Loney's DBA Handbook (you out there Kevin?) to create the stats tables in a database other than the one being monitored, so I've created a link in my monitoring database (ORCL) thus:
CREATE PUBLIC DATABASE LINK SIPR_STAT
CONNECT TO SYS IDENTIFIED BY password
USING 'service_name';

I've modified the UTLBSTAT script so that the table accesses refer to this link. E.g.
drop table stats$begin_latch;
create table stats$begin_latch

        tablespace user_data
        as select * from v$latch_at_sipr_stat where 0 = 1;

When I run the script (either from SQL*Plus or svrmgrl connected as "internal") most of it works fine except for the statements that access the latch information on the remote database (like the one above for example) which return the error:

ORA-02068: following severe error from SIPR_STAT ORA-03113: end-of-file on communication channel

I can log on as sys on the database being monitored and execute the select statements quite happily, it's only when I try and get them through the link that they fail. The trace file generated lists the following error:

ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [] [SIGSEGV] [Address not mapped to object] [0] [] []

I've not reported it to Oracle Support yet, just wondered if anyone had any ideas.

TIA.
--
Robin Bishop
University of Brighton Computer Centre Received on Tue Nov 24 1998 - 04:35:06 CST